1 / 38

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

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.

simone
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

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

  2. 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.

  3. GPS Base

  4. GPS Rover

  5. h GPS Precision E543859.994 ± 0.002m N N4815099.919 ± 0.003m Elevation: 1244.944 ± 0.006m 1cm2

  6. h North Quarry: 2000 N f 1 m g

  7. h North Quarry: 2001 N f 1 m g

  8. h North Quarry: 2002 N f 1 m g

  9. h North Quarry: 2003 N f 1 m g

  10. h North Quarry: 2004 N f 1 m g

  11. h North Quarry: 2005 N f 1 m g

  12. h North Quarry N Erosional surface below bed f 1 m g Not yet excavated

  13. 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

  14. Database Schema • Conceptual model of the structure of a database that defines the data contents and relationships • Two Broad Categories • Normalized • Un-normalized

  15. 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

  16. Normalized • Several smaller, interlinked tables • No data repetition • Data-entry much less error-prone • Logical linkage between related data enables advanced analysis

  17. 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

  18. 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

  19. 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

  20. 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…

  21. Visit Us Online! Online Fossil Catalog: http://geology.swau.edu/fossil/ Dinosaur Project: http://dinodig.swau.edu/ For more information: Email: justin@woodsmedia.com chadwick@swau.edu

More Related