Localities

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(added content)
 
(11 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
*FileID, integer, 4 bytes, = tblFiles.FileID
+
* [[Files|FileID]], integer, 4 bytes, = tblFiles.FileID
*Level1ID, 1 character, = tblGeoLevel1.Level1ID
+
* [[GeoLevel1|Level1ID]], 1 digit, = tblGeoLevel1.Level1ID
*Level2ID, 1 character, = tblGeoLevel2.Level2ID
+
** 0 = "Not recorded"
*Level3ID, 3 characters, = tblGeoLevel3.Level3ID
+
* [[GeoLevel2|Level2ID]], 1 digit, = tblGeoLevel2.Level2ID.  This is not a foreign key by itself; it is composite with Level1ID.
*Level4ID, 3 characters, = tblGeoLevel4.Level4ID
+
** 0 = level 2 location has not been recorded
*GeoID, calculated as concatenation of above 4 columns
+
* [[GeoLevel3|Level3ID]], 3 alphabetic characters, = tblGeoLevel3.Level3ID ''this is a foreign key for tblGeoLevel3''
*Latitude, decimal, precision 9, scale 6, degrees (+ for N, - for S), null permitted
+
** --- = level 3 location has not been recorded
*Longitude, decimal, precision 9, scale 6, degrees (+ for E, - for W), null permitted
+
** There are no spaces to pad because the foreign key has no blanks.
*PrecisionCode, integer, 1 byte (still available, no longer used, will be converted for use as indicator of confidence in the supplied Lat/Long)
+
* [[GeoLevel4|Level4ID]], 3 characters, = tblGeoLevel4.Level4ID.  This is not a foreign key by itself; it is composite with Level3ID.
**0 = unspecified (default)
+
** --- = level 4 location has not been recorded
**1 = from 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.
**2 = estimated from map and locality label
+
* Latitude, decimal, precision 9, scale 6, degrees (+ for N, - for S), null permitted
**3 = based on county or similar modest area specified on locality label
+
* Longitude, decimal, precision 9, scale 6, degrees (+ for E, - for W), null permitted
**4 = estimated from less specific locality label
+
* PrecisionCode, integer, 1 byte (still available, no longer used, will be converted for use as indicator of confidence in the supplied Lat/Long)
*Elevation, integer, 2 bytes, elevation in meters, null permitted
+
** 0 = unspecified (default)
*MaxElevation, integer, 2 bytes, maximum elevation when there is a range, otherwise null
+
** 1 = from locality label
*TimePeriodID, integer, 2 bytes, = tblTimePeriods.TimePeriodID, geologic time period
+
** 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
 +
* [[TimePeriods|TimePeriodID]], integer, 2 bytes, = tblTimePeriods.TimePeriodID, geologic time period
 
*LocalityDetail, text, 300 characters maximum, place data not coded in any other field
 
*LocalityDetail, text, 300 characters maximum, place data not coded in any other field
 
*TimeDetail, text, 300 characters maximum, details not coded in TimePeriodID
 
*TimeDetail, text, 300 characters maximum, details not coded in TimePeriodID
 
*DataFlags, integer, 1 byte, bit flags for data status
 
*DataFlags, integer, 1 byte, bit flags for data status
**1 = The disparity between geographic levels and the Latitude & Longitude was accepted by the user
+
** <span class="alert">0 = conditions 1 and 2 are not present</span>
**2 = The locality was last edited by a user during a localities test run
+
** 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))
 
*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
 
*State, text, 100 characters maximum, name of the state or province of collection
Line 38: Line 44:
 
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row
 
*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