Field Name | Description | 1º Key | 2º Index | Foreign Key | Paradox 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 owner | Landowner | Long Integer | |||
LocalityName | Alpha, 80 characters | |||||
Latitude | Stored in decimal degrees | Number | ||||
Longitude | stored in decimal degrees | Number | ||||
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 values | Alpha, 25 characters | ||||
Description | Description to enable relocation of locality | Memo, 100 characters displayed | ||||
CollectDate | Date of first collection at locality | Alpha, 25 characters | ||||
EntryDate | date record entered in database | Date | ||||
EnteredBy | Data Entry personnel | Person | Long Integer |
Field Name | Description | 1º Key | Foreign Key | Paradox 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 |
Field Name | Description | 1º Key | 2º Index | Foreign Key | Paradox 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 |
Field Name | Description | 1º Key | 2º Index | Foreign Key | Paradox Field Type | |
LocPrefix | Locality | Alpha, 2 characters | ||||
LocalityNo | Locality | Long Integer | ||||
Fate | Description of locality destruction | Memo, 20 characters |