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