Localities
From Species File Help
(Difference between revisions)
Line 5: | Line 5: | ||
* [[GeoLevel1|Level1ID]], 1 character, = tblGeoLevel1.Level1ID | * [[GeoLevel1|Level1ID]], 1 character, = tblGeoLevel1.Level1ID | ||
** 0 = "Not recorded" | ** 0 = "Not recorded" | ||
− | ** <span class="alert">null | + | ** <span class="alert">null is not allowed</span> |
* [[GeoLevel2|Level2ID]], 1 character, = tblGeoLevel2.Level2ID | * [[GeoLevel2|Level2ID]], 1 character, = tblGeoLevel2.Level2ID | ||
** 0 = various values from tblGeoLevel2 (''this is not a foreign key by it self, it is composite with tblGeoLevel1'') | ** 0 = various values from tblGeoLevel2 (''this is not a foreign key by it self, it is composite with tblGeoLevel1'') | ||
− | ** <span class="alert">null | + | ** <span class="alert">null is not permitted</span> |
− | ** <span class="alert">is | + | ** <span class="alert">There is no space to pad because the foreign key has no blank.</span> |
* [[GeoLevel3|Level3ID]], 3 characters (''no digits''), = tblGeoLevel3.Level3ID ''this is a foreign key for tblGeoLevel3'' | * [[GeoLevel3|Level3ID]], 3 characters (''no digits''), = tblGeoLevel3.Level3ID ''this is a foreign key for tblGeoLevel3'' | ||
** 0 = **NOT USED** | ** 0 = **NOT USED** | ||
− | ** <span class="alert">null | + | ** <span class="alert">null is not allowed</span> |
− | ** <span class="alert">is stored value padded with spaces?</span> | + | ** <span class="alert">is stored value padded with spaces? There are no spaces to pad because the foreign key has no blanks.</span> |
* [[GeoLevel4|Level4ID]], 3 characters, = tblGeoLevel4.Level4ID | * [[GeoLevel4|Level4ID]], 3 characters, = tblGeoLevel4.Level4ID | ||
** 0 = various values from tblGeoLevel2 (''values like "830", "KO", "36"''), ''this is not a primary key, it is composite with tblGeoLevel3'' | ** 0 = various values from tblGeoLevel2 (''values like "830", "KO", "36"''), ''this is not a primary key, it is composite with tblGeoLevel3'' | ||
− | ** <span class="alert">null | + | ** <span class="alert">null is not allowed</span> |
− | ** <span class="alert">is stored value padded with spaces?</span> | + | ** <span class="alert">is stored value padded with spaces? no</span> |
− | + | ||
* Latitude, decimal, precision 9, scale 6, degrees (+ for N, - for S), null permitted | * 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 | * Longitude, decimal, precision 9, scale 6, degrees (+ for E, - for W), null permitted | ||
Line 33: | Line 32: | ||
*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 | ||
− | ** <span class="alert">0 = | + | ** <span class="alert">0 = conditions 1 and 2 are not present</span> |
** 1 = The disparity between geographic levels and the Latitude & Longitude was accepted by the user | ** 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 | ** 2 = The locality was last edited by a user during a localities test run |
Revision as of 17:15, 23 October 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
- 0 = "Not recorded"
- null is not allowed
- Level2ID, 1 character, = tblGeoLevel2.Level2ID
- 0 = various values from tblGeoLevel2 (this is not a foreign key by it self, it is composite with tblGeoLevel1)
- null is not permitted
- There is no space to pad because the foreign key has no blank.
- Level3ID, 3 characters (no digits), = tblGeoLevel3.Level3ID this is a foreign key for tblGeoLevel3
- 0 = **NOT USED**
- null is not allowed
- is stored value padded with spaces? There are no spaces to pad because the foreign key has no blanks.
- Level4ID, 3 characters, = tblGeoLevel4.Level4ID
- 0 = various values from tblGeoLevel2 (values like "830", "KO", "36"), this is not a primary key, it is composite with tblGeoLevel3
- null is not allowed
- is stored value padded with spaces? no
- 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