Integrated Map and Database

Compiled information from many sources in one database. Information about the bones is also linked to individual bones in a map of the entire quarry.

thumbnail of DigitizingDNMThesisThe thesis written by Rebecca Esplin explaining the project, some results, and some basics about working with the files. It also includes a few tables and a printable version of the Master Map.

 

 

Map Files

CarnegieQuarryMasterMap is a Microsoft version of the Master Map. An explanation for the various layers is given in Appendix F of the thesis, DigitizingDNMThesis. If this file is used with MAPublisher then the attribute table that relates the data to the database can be accessed.

GISCarnegieQuarryMasterMap is the ArcMap version of the Master Map. This version can be used to make measurements of the quarry, and the attributes table includes some information from the database. CarnegieQuarry.mxd can be read by ArcMap version 10.5, CarnegieQuarry2.mxd can be read by version 10.3 and CarnegieQuarry3.mxd can be read by version 9.

Database Files

The Full Carnegie Quarry Database

DigitalCarnegieQuarryDatabase is a zipped file of the digital quarry database that includes 30+ populated tables and a handful of queries that contain data about the Carnegie Quarry specimens.

csv CQdatabase is a zipped folder that includes all the populated tables from the database in a csv format and an image of how the tables should be related.

DigitalQuarryDatabaseBlank is a zipped file of the unpopulated database. It has all the same tables and relationships but without the data. This could be used for other quarries.

Queries

These are queries from the database exported as excel files that can be used to answer specific questions.

HRQ Individuals lists the bones along with their IndividualID number so that they can swiftly be sorted by individual dinosaur. This also includes their family, species and genus.

HRQ Literature lists the scientific literature including titles, authors and journal names, that references quarry specimens.

HRQ Provenance lists the bones with their repository acronym (both past and current) so that the bones can be grouped by which museum they are in.

HRQ Specimens lists the specimens, skeletal elements, individual id number, location in the quarry, excavator, sources, and repository, taphonomic and taxonomic information, and other information.

HRQ SpecimensReferencedinRecords lists the bones and the article titles in which they are mentioned including authors, and years.

NCCQ SpecimensWithNumbers is a query that lists the specimens by DigitalQuarryID and then their various field, catalog and accession numbers in a single row.

NCQ DINOSpecimens lists the specimens by DINO number and includes much of the other data from HRQ Specimens as well. The other number check queries (NCQ) provide the same function but for other catalog or field numbers.

TQ SpecimensWithAllNumbers lists the bones by their box, field, catalog, and accession numbers. Most bones are listed multiple times, once for each number.

TQ NISP is a query used to calculate MNI. It includes many of the fields of “DTbl Specimens” and excludes specimens that are not identified to the family level and skeletal element. By selecting unique values in the family or genus fields and then counting skeletal elements by side this can be used to calculate MNI by taxon.

 

Integrated-re

As an open science, open source initiative, all fossil data and many of the records and images on this website are licensed in the public domain. However, not everything has the same license, so please check for license information in the caption or metadata before use. Dinosaur National Monument mural artwork, including the full-color illustrations of dinosaurs and other animals, is owned by the National Park Service and may be used freely for non-commercial purposes with the credit: "NPS Artwork by Bob Walters and Tess Kissinger."

For fossil fans who code or design, there are also a number of ways to be a part of the Digital Quarry Project. To contribute, visit our GitHub project page.