Localities

tblLocalities contains information about localities where specimens were found.

LocalityID, integer, 4 bytes, identifier for locality 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 7, scale 4, degrees (+ for N, - for S)   Longitude, decimal, precision 7, scale 4, degrees (+ for E, - for W)    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 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 bytes maximum, place data not coded in any other field TimeDetail, text, 300 bytes maximum, details not coded in TimePeriodID LastUpdate, smalldatetime, date and time of last update ModifiedBy, integer, 2 bytes, UserID of the signon that made the change DataFlags, integer, 1 byte, bit flags for data status, added in version 4.0 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)), added in version 4.0 State, text, 100 characters maximum, name of the state or province of collection, added in version 4.0 County, text, 100 characters maximum, name of the county or precinct of collection, added in version 4.0 BodyOfWater, text, 100 characters maximum, name of the body of water of collection, added in version 4.0 PrecisionRadius, interger, 4 bytes, radius of the circle ot uncertainty of the accuarcy of the Latitude/Longitude data, added in version 4.0 LatLongFrom, integer, 4 bytes, indicator of when the Latitude/Longitude data was applied, added in version 4.0 0 = Unknown (default) 1 = Provided by the collector at collection time 2 = Provided during data entry