Localities
From Species File Help
(Difference between revisions)
(created page) |
(added content) |
||
| Line 1: | Line 1: | ||
'''tblLocalities''' contains information about localities where specimens were found. | '''tblLocalities''' contains information about localities where specimens were found. | ||
| − | + | *LocalityID, integer, 4 bytes, identifier for locality | |
| − | + | *FileID, integer, 4 bytes, = tblFiles.FileID | |
| − | + | *Level1ID, 1 character, = tblGeoLevel1.Level1ID | |
| − | + | *Level2ID, 1 character, = tblGeoLevel2.Level2ID | |
| − | + | *Level3ID, 3 characters, = tblGeoLevel3.Level3ID | |
| − | + | *Level4ID, 3 characters, = tblGeoLevel4.Level4ID | |
| − | + | *GeoID, calculated as concatenation of above 4 columns | |
| − | + | *Latitude, decimal, precision 9, scale 6, degrees (+ for N, - for S), null permitted | |
| − | + | *Longitude, decimal, precision 9, scale 6, degrees (+ for E, - for W), null permitted | |
| − | + | *PrecisionCode, integer, 1 byte (still available, no longer used, will be converted for use as indicator of confidence in the supplied Lat/Long) | |
| − | + | **0 = unspecified (default) | |
| − | + | **1 = from locality label | |
| − | + | **2 = estimated from map and locality label | |
| − | + | **3 = based on county or similar modest area specified on locality label | |
| − | + | **4 = estimated from less specific locality label | |
| − | + | *Elevation, integer, 2 bytes, elevation in meters, null permitted | |
| − | + | *MaxElevation, integer, 2 bytes, maximum elevation when there is a range, otherwise null | |
| − | + | *TimePeriodID, integer, 2 bytes, = tblTimePeriods.TimePeriodID, geologic time period | |
| − | + | *LocalityDetail, text, 300 characters maximum, place data not coded in any other field | |
| − | + | *TimeDetail, text, 300 characters maximum, details not coded in TimePeriodID | |
| − | + | *DataFlags, integer, 1 byte, bit flags for data status | |
| − | + | **1 = The disparity between geographic levels and the Latitude & Longitude was accepted by the user | |
| − | + | **2 = The locality was last edited by a user during a localities test run | |
| − | + | *Country, text, 100 characters maximum, name of the country of collection (It is not required that this name match any data supplied in the GeoID (above)) | |
| − | + | *State, text, 100 characters maximum, name of the state or province of collection | |
| − | + | *County, text, 100 characters maximum, name of the county or precinct of collection | |
| − | + | *BodyOfWater, text, 100 characters maximum, name of the body of water of collection | |
| − | + | *PrecisionRadius, integer, 4 bytes, radius of the circle of uncertainty of the accuarcy of the latitude and longitude data | |
| − | + | *LatLongFrom, integer, 4 bytes, indicator of when the Latitude/Longitude data was applied | |
| − | + | **0 = Unknown (default) | |
| − | + | **1 = Provided by the collector at collection time | |
| − | + | **2 = Provided during data entry | |
| − | + | *LastUpdate, smalldatetime, date and time row last updated | |
| − | + | *ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change | |
| + | *CreatedOn, smalldatetime, date and time row was created | ||
| + | *CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row | ||
[[Category:SpecimenTables]] | [[Category:SpecimenTables]] | ||
Revision as of 11:02, 29 August 2012
tblLocalities contains information about localities where specimens were found.
- LocalityID, integer, 4 bytes, identifier for locality
- FileID, integer, 4 bytes, = tblFiles.FileID
- Level1ID, 1 character, = tblGeoLevel1.Level1ID
- Level2ID, 1 character, = tblGeoLevel2.Level2ID
- Level3ID, 3 characters, = tblGeoLevel3.Level3ID
- Level4ID, 3 characters, = tblGeoLevel4.Level4ID
- GeoID, calculated as concatenation of above 4 columns
- Latitude, decimal, precision 9, scale 6, degrees (+ for N, - for S), null permitted
- Longitude, decimal, precision 9, scale 6, degrees (+ for E, - for W), null permitted
- PrecisionCode, integer, 1 byte (still available, no longer used, will be converted for use as indicator of confidence in the supplied Lat/Long)
- 0 = unspecified (default)
- 1 = from locality label
- 2 = estimated from map and locality label
- 3 = based on county or similar modest area specified on locality label
- 4 = estimated from less specific locality label
- Elevation, integer, 2 bytes, elevation in meters, null permitted
- MaxElevation, integer, 2 bytes, maximum elevation when there is a range, otherwise null
- TimePeriodID, integer, 2 bytes, = tblTimePeriods.TimePeriodID, geologic time period
- LocalityDetail, text, 300 characters maximum, place data not coded in any other field
- TimeDetail, text, 300 characters maximum, details not coded in TimePeriodID
- DataFlags, integer, 1 byte, bit flags for data status
- 1 = The disparity between geographic levels and the Latitude & Longitude was accepted by the user
- 2 = The locality was last edited by a user during a localities test run
- Country, text, 100 characters maximum, name of the country of collection (It is not required that this name match any data supplied in the GeoID (above))
- State, text, 100 characters maximum, name of the state or province of collection
- County, text, 100 characters maximum, name of the county or precinct of collection
- BodyOfWater, text, 100 characters maximum, name of the body of water of collection
- PrecisionRadius, integer, 4 bytes, radius of the circle of uncertainty of the accuarcy of the latitude and longitude data
- LatLongFrom, integer, 4 bytes, indicator of when the Latitude/Longitude data was applied
- 0 = Unknown (default)
- 1 = Provided by the collector at collection time
- 2 = Provided during data entry
- LastUpdate, smalldatetime, date and time row last updated
- ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
- CreatedOn, smalldatetime, date and time row was created
- CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row
