Locality Management Image Map
Legend

Locality Management

These tables are used for management of locality data.

Locality

The main locality table.

Field Name Description1º Key 2º Index Foreign KeyParadox Field Type
LocPrefix Locality prefix. For compatibility with existing records
*
Alpha, 2 characters
LocalityNo
*
Long Integer
Geog Location of site
*
Geography Short Integer
MapName Map on which locality is marked
*
Map Alpha, 40 characters
GeolTime Age of locality
*
GeolTime Short Integer
RockUnitNo Rock unit fossils were found in
*
RockUnit Short Integer
LandownerNo Property ownerLandowner Long Integer
LocalityName Alpha, 80 characters
Latitude Stored in decimal degreesNumber
Longitude stored in decimal degreesNumber
Variance Amount of uncertainty in latitude/longitude measurements Alpha, 20 characters
Township Alpha, 3 characters
Range Alpha, 3 characters
Sections Alpha, 3 characters
Meridian Meridian referenced by Township Range Section valuesAlpha, 25 characters
Description Description to enable relocation of localityMemo, 100 characters displayed
CollectDate Date of first collection at localityAlpha, 25 characters
EntryDate date record entered in databaseDate
EnteredBy Data Entry personnelPerson Long Integer

Locality Audit

An audit table to track changes made to locality data.

Field Name Description1º Key Foreign KeyParadox Field Type
LocPrefix Locality prefix. For compatibility with existing records
*
Locality Alpha, 2 characters
LocalityNo
*
Locality Long Integer
DateChanged Date edited
*
Date field
ChangedBy Person Long Integer

Equivalent localities

This table tracks locality numbers from other museums which are equivalent to a UCMP locality number, and UCMP localities which are synonymous with other UCMP numbers.

Field Name Description1º Key 2º Index Foreign KeyParadox Field Type
LocPrefix Locality Alpha, 2 characters
LocalityNo Locality Long Integer
LocalityName Alternate locality name
*
Alpha, 80 characters
Acronym Other institution
*
Acronym Alpha, 15 characters
AlternateLocNo Other institution locality number
*
Alpha, 15 characters
Equivalency Deegree of overlap with other locality number (equals, near, part of, in part, approximately) Alpha, 10 characters

Locality Fate

This table tracks destruction of UCMP localities, by natural causes, highway construction etc.

Field Name Description1º Key 2º Index Foreign KeyParadox Field Type
LocPrefix Locality Alpha, 2 characters
LocalityNo Locality Long Integer
Fate Description of locality destruction Memo, 20 characters