DEVELOPMENT OF AN
Sponsored Links
This presentation is the property of its rightful owner.
1 / 38

DEVELOPMENT OF AN ONLINE DATABASE WITH GIS CONNECTIONS FOR VERTEBRATE AND OTHER FOSSILS Justin Woods and Art Chadwick PowerPoint PPT Presentation


  • 82 Views
  • Uploaded on
  • Presentation posted in: General

DEVELOPMENT OF AN ONLINE DATABASE WITH GIS CONNECTIONS FOR VERTEBRATE AND OTHER FOSSILS Justin Woods and Art Chadwick. GPS/GIS Technology. New Technology for mapping bones in the quarry using high-resolution GPS equipment. GPS data is combined with digital photos of bones in the computer.

Download Presentation

DEVELOPMENT OF AN ONLINE DATABASE WITH GIS CONNECTIONS FOR VERTEBRATE AND OTHER FOSSILS Justin Woods and Art Chadwick

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


DEVELOPMENT OF ANONLINE DATABASEWITHGIS CONNECTIONSFOR VERTEBRATE AND OTHER FOSSILSJustin Woods and Art Chadwick


GPS/GIS Technology

  • New Technology for mapping bones in the quarry using high-resolution GPS equipment.

  • GPS data is combined with digital photos of bones in the computer.

  • The bones can then be seen in the computer just as they looked in the ground, but with the dirt removed.


GPS Base


GPS Rover


h

GPS Precision

E543859.994 ± 0.002m

N

N4815099.919

± 0.003m

Elevation:

1244.944 ± 0.006m

1cm2


h

North Quarry: 2000

N

f 1 m g


h

North Quarry: 2001

N

f 1 m g


h

North Quarry: 2002

N

f 1 m g


h

North Quarry: 2003

N

f 1 m g


h

North Quarry: 2004

N

f 1 m g


h

North Quarry: 2005

N

f 1 m g


h

North Quarry

N

Erosional surface below bed

f 1 m g

Not yet excavated


Expanded view from previous slide

  • Note the long ossified tendon visible in the center just above the femur. It is ¼ inch in diameter.

  • Femur is 50 inches long, for comparison


Database Schema

  • Conceptual model of the structure of a database that defines the data contents and relationships

  • Two Broad Categories

    • Normalized

    • Un-normalized


Un-Normalized

  • One Huge Table

  • Data repeated row-to-row

  • Data-entry errors difficult to prevent

  • No logical linkage between related data

  • Memory-intensive

  • Slow data access


Normalized

  • Several smaller, interlinked tables

  • No data repetition

  • Data-entry much less error-prone

  • Logical linkage between related data enables advanced analysis


DiGIR ProtocolDistributed Generic Information Retrieval

  • Taxonomic Databases Working Group (TDWG) has proposed “Darwin Schema” to facilitate dissemination of information about biological organisms

  • Protocol for disparate biological databases to exchange data easily


DiGIR ProtocolDistributed Generic Information Retrieval

  • Our fully-normalized database will easily integrate with DiGIR / Darwin

  • Protocol still in draft stage

  • When it is finalized, our project will adopt it so that our data is as accessible as possible


Online Fossil Database

  • Catalog of approximately 7000 fossil specimens, currently

  • Each has multiple high-resolution photographs online

  • Each has full GPS position data online

  • Each can be visualized in the quarry using GIS data

  • Fully searchable


Conclusion

  • Fully-normalized database schema improves quality, availability of data

  • GPS / GIS / Specimen Collection integration provides wealth of data not otherwise accessible

  • The data are there, the possibilities are endless…


Visit Us Online!

Online Fossil Catalog:

http://geology.swau.edu/fossil/

Dinosaur Project:

http://dinodig.swau.edu/

For more information:

Email: [email protected]

[email protected]


  • Login