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

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


  • 77 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 an online database with gis connections for vertebrate and other fossils justin woods and art chadwick

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


Gps gis technology

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 Base


Gps rover

GPS Rover


Gps precision

h

GPS Precision

E543859.994 ± 0.002m

N

N4815099.919

± 0.003m

Elevation:

1244.944 ± 0.006m

1cm2


North quarry 2000

h

North Quarry: 2000

N

f 1 m g


North quarry 2001

h

North Quarry: 2001

N

f 1 m g


North quarry 2002

h

North Quarry: 2002

N

f 1 m g


North quarry 2003

h

North Quarry: 2003

N

f 1 m g


North quarry 2004

h

North Quarry: 2004

N

f 1 m g


North quarry 2005

h

North Quarry: 2005

N

f 1 m g


North quarry

h

North Quarry

N

Erosional surface below bed

f 1 m g

Not yet excavated


Expanded view from previous slide

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

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

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

Normalized

  • Several smaller, interlinked tables

  • No data repetition

  • Data-entry much less error-prone

  • Logical linkage between related data enables advanced analysis


Digir protocol distributed generic information retrieval

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 protocol distributed generic information retrieval1

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

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

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

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