From ICISWiki
Back to TABLE CHANGES v5.6
GEOREF Table Design v5.6
| Field Name
| Description
| Data Type
| Field Size
|
| LOCID
| Identifies the location. Link to the LOCATION table.
| Number
| Long Integer
|
| LLPN
| The lat-lon point (1 to NLLP).
| Number
| Integer
|
| LAT
| Latitude in decimal degrees (+ for North, - for South, -1E36 for missing).
| Number
| Double
|
| LON
| Longitude in decimal degrees (+ for East, - for West, -1E36 for missing).
| Number
| Double
|
| ALT
| Altitude (m above sea level, -1E36 for missing)
| Number
| Double
|
| LLSOURCE
| The type of source used for lat-long coordinates (e.g. GPS, digital gazetteer, map, collecting form, collecting report, providers database with unspecified source: lookup UDFLDS)
| Number
| Long Integer
|
| LLFMT
| Format in which Lat-Long coordinates were originally provided (lookup UDFLDS)
| Number
| Long Integer
|
| LLDATUM
| Datum used for coordinate data (Lookup UDFLDS). (Assume WGS84 if unknown)
| Number
| Long Integer
|
| LLUNCERT
| Quantitative estimate of the uncertainty of the measure of coordinates
| Number
| Double
|
| LLREF
| Reference to specific map, gazetteer, etc. Links to RefID in BibRefs table
| Number
| Long Integer
|
| LLDATE
| Date of entry
| Number
| Long Integer
|
| LLUID
| ICIS userID
| Number
| Integer
|
UDFLDS Table Entries v5.6
| FLDNO
| FTABLE
| FTYPE
| FCODE
| FNAME
| FDESC
|
| 1600
| GEOREF
| LLSOURCE
| GPS
| GPS
| Coordinates come from GPS
|
| 1601
| GEOREF
| LLSOURCE
| MAP
| Map
| Coordinates read from Map: Map ID should be in LLRef (PubType 442)
|
| 1602
| GEOREF
| LLSOURCE
| GAZ
| Digital gazetteer
| Coordinates obtained by looking up location in digital gazetteer: Gazetteer ID should be in LLRef (PubType 443)
|
| 1603
| GEOREF
| LLSOURCE
| CFORM
| Collecting form
| Coordinates were on collecting form with no information on the source of data. A scanned copy of the collecting form should be accessible through the GID and document/image management system
|
| 1604
| GEOREF
| LLSOURCE
| DONOR
| Donor
| Coordinates were supplied by donor in documentation accompanying the shipment, with no information on how the donor obtained the data. A scanned copy of documents from the donor should be accessible through the GID and document/image management system
|
| 1605
| GEOREF
| LLSOURCE
| CMISS
| Collecton Mission report
| Coordinates were in a report on a collecting mission, with no information on the source of the data. A scanned copy of the report should be accessible through the GID and document/image management system, with ID in LLRef
|
| 1606
| GEOREF
| LLSOURCE
| DBASE
| Another database
| Coordinates were obtained from another database with no information on its source. The database ID should be in LLRef (PubType 437)
|
| 1607
| GEOREF
| LLFMT
| D
| Degrees
| Original data provided to the nearest degree in the format D°H
|
| 1608
| GEOREF
| LLFMT
| DM
| Degrees-Minutes
| Original data provided to the nearest minute, in the format D°M\'H
|
| 1609
| GEOREF
| LLFMT
| DMS
| Degrees-Minutes-Seconds
| Original data provided to the nearest second in the format D°M\'S\"H
|
| 1610
| GEOREF
| LLFMT
| DD
| Decimal Degrees
| Original data provided in decimal degrees in the format D.DDDDD (negative for S and W)
|
| 1611
| GEOREF
| LLFMT
| DMM
| Decimal Minutes
| Original data provided in decimal minutes, in the format D°M.MMM\'H
|
| 1612
| GEOREF
| LLFMT
| DMSS
| Decimal Seconds
| Original data provided in decimsal seconds in the format D°M\'S.S\"H
|
| 1613
| GEOREF
| LLDATUM
| WGS84
| WGS84
| World Geodetic survey 1984
|
Legend:
| (gray cell)
| Already existing field/entry
|
| (yellow cell)
| New field/entry to be added
|
| (gold cell)
| Replace existing entry with this new code/size
|
