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