Localities

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(created page)
 
 
(12 intermediate revisions by 3 users not shown)
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
+
* LocalityID, integer, 4 bytes, identifier for locality
    Level1ID, 1 character, = tblGeoLevel1.Level1ID
+
* [[Files|FileID]], integer, 4 bytes, = tblFiles.FileID
    Level2ID, 1 character, = tblGeoLevel2.Level2ID
+
* [[GeoLevel1|Level1ID]], 1 digit, = tblGeoLevel1.Level1ID
    Level3ID, 3 characters, = tblGeoLevel3.Level3ID
+
** 0 = "Not recorded"
    Level4ID, 3 characters, = tblGeoLevel4.Level4ID
+
* [[GeoLevel2|Level2ID]], 1 digit, = tblGeoLevel2.Level2ID.  This is not a foreign key by itself; it is composite with Level1ID.
    GeoID, calculated as concatenation of above 4 columns
+
** 0 = level 2 location has not been recorded
    Latitude, decimal, precision 7, scale 4, degrees (+ for N, - for S)
+
* [[GeoLevel3|Level3ID]], 3 alphabetic characters, = tblGeoLevel3.Level3ID ''this is a foreign key for tblGeoLevel3''
    Longitude, decimal, precision 7, scale 4, degrees (+ for E, - for W)
+
** --- = level 3 location has not been recorded
    PrecisionCode, integer, 1 byte (still available, no longer used, will be converted for use as indicator of confidence in the supplied Lat/Long)
+
** There are no spaces to pad because the foreign key has no blanks.
        0 = unspecified (default)
+
* [[GeoLevel4|Level4ID]], 3 characters, = tblGeoLevel4.Level4ID.  This is not a foreign key by itself; it is composite with Level3ID.
        1 = from locality label
+
** --- = level 4 location has not been recorded
        2 = estimated from map and locality label
+
** The TDWG endorsed values are all alphabetic characters.  Species File Software has added details at level 4 not recognized by TDWG.  These are identified by numeric characters.
        3 = based on county or similar modest area specified on locality label
+
* Latitude, decimal, precision 9, scale 6, degrees (+ for N, - for S), null permitted
        4 = estimated from less specific locality label
+
* Longitude, decimal, precision 9, scale 6, degrees (+ for E, - for W), null permitted
    Elevation, integer, 2 bytes, elevation in meters
+
* PrecisionCode, integer, 1 byte (still available, no longer used, will be converted for use as indicator of confidence in the supplied Lat/Long)
    MaxElevation, integer, 2 bytes, maximum elevation when there is a range, otherwise null
+
** 0 = unspecified (default)
    TimePeriodID, integer, 2 bytes, = tblTimePeriods.TimePeriodID, geologic time period
+
** 1 = from locality label
    LocalityDetail, text, 300 bytes maximum, place data not coded in any other field
+
** 2 = estimated from map and locality label
    TimeDetail, text, 300 bytes maximum, details not coded in TimePeriodID
+
** 3 = based on county or similar modest area specified on locality label
    LastUpdate, smalldatetime, date and time of last update
+
** 4 = estimated from less specific locality label
    ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
+
* Elevation, integer, 2 bytes, elevation in meters, null permitted
    DataFlags, integer, 1 byte, bit flags for data status, added in version 4.0
+
* MaxElevation, integer, 2 bytes, maximum elevation when there is a range, otherwise null
        1 = The disparity between geographic levels and the Latitude & Longitude was accepted by the user
+
* [[TimePeriods|TimePeriodID]], integer, 2 bytes, = tblTimePeriods.TimePeriodID, geologic time period
        2 = The locality was last edited by a user during a localities test run
+
*LocalityDetail, text, 300 characters maximum, place data not coded in any other field
    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
+
*TimeDetail, text, 300 characters maximum, details not coded in TimePeriodID
    State, text, 100 characters maximum, name of the state or province of collection, added in version 4.0
+
*DataFlags, integer, 1 byte, bit flags for data status
    County, text, 100 characters maximum, name of the county or precinct of collection, added in version 4.0
+
** <span class="alert">0 = conditions 1 and 2 are not present</span>
    BodyOfWater, text, 100 characters maximum, name of the body of water of collection, added in version 4.0
+
** 1 = The disparity between geographic levels and the Latitude & Longitude was accepted by the user
    PrecisionRadius, interger, 4 bytes, radius of the circle ot uncertainty of the accuarcy of the Latitude/Longitude data, added in version 4.0
+
** 2 = The locality was last edited by a user during a localities test run
    LatLongFrom, integer, 4 bytes, indicator of when the Latitude/Longitude data was applied, added in version 4.0
+
*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))
        0 = Unknown (default)
+
*State, text, 100 characters maximum, name of the state or province of collection
        1 = Provided by the collector at collection time
+
*County, text, 100 characters maximum, name of the county or precinct of collection
        2 = Provided during data entry
+
*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]]
 +
[[Category:Tables]]
 +
[[Category:Fixme]]

Latest revision as of 11:05, 30 May 2013

tblLocalities contains information about localities where specimens were found.

  • LocalityID, integer, 4 bytes, identifier for locality
  • FileID, integer, 4 bytes, = tblFiles.FileID
  • Level1ID, 1 digit, = tblGeoLevel1.Level1ID
    • 0 = "Not recorded"
  • Level2ID, 1 digit, = tblGeoLevel2.Level2ID. This is not a foreign key by itself; it is composite with Level1ID.
    • 0 = level 2 location has not been recorded
  • Level3ID, 3 alphabetic characters, = tblGeoLevel3.Level3ID this is a foreign key for tblGeoLevel3
    • --- = level 3 location has not been recorded
    • There are no spaces to pad because the foreign key has no blanks.
  • Level4ID, 3 characters, = tblGeoLevel4.Level4ID. This is not a foreign key by itself; it is composite with Level3ID.
    • --- = level 4 location has not been recorded
    • The TDWG endorsed values are all alphabetic characters. Species File Software has added details at level 4 not recognized by TDWG. These are identified by numeric characters.
  • 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
    • 0 = conditions 1 and 2 are not present
    • 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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox