geocoorddetail

Table info.

Title Geo Coord Detail
Description Geo Coord Detail

Fields

Name Type Required Index Hidden On form Title Pick list Description
GeoCoordDetailID int(11) PRI
TimestampCreated datetime Created timestampCreated
TimestampModified datetime Last edited timestampModified
Version int(11) Version version
GeoRefAccuracyUnits varchar(20) Geo Ref Accuracy Units geoRefAccuracyUnits
GeoRefDetDate datetime Georeference date geoRefDetDate
GeoRefDetRef varchar(100) Geo Ref Det Ref geoRefDetRef
GeoRefRemarks text Georeferencing notes Any notes about how the locality information has been interpreted by data entry personnel, or why a particular geocode was selected
GeoRefVerificationStatus varchar(50) Verification status GeoReferenceVerificationStatus
  • Corrected by collector
  • Corrected by curator
  • Verified by collector
  • Verified by curator
 Indicates if the quality assertion has been verified, and by whom (collector or curator)
MaxUncertaintyEst decimal(20,10) GEOLocate uncertainty Uncertainty set by GEOLocate; will be delivered to AVH as coordinateUncertainty in preference to the uncertainty classes.
MaxUncertaintyEstUnit varchar(8) Max Uncertainty Est Unit maxUncertaintyEstUnit
UncertaintyPolygon text Uncertainty Polygon uncertaintyPolygon
ErrorPolygon text Error Polygon errorPolygon
NamedPlaceExtent decimal(20,10) Precision Darwin Core coordinatePrecision
NoGeoRefBecause varchar(100) Not geocoded because NotGeocodedBecause
  • Locality ambiguous
  • Locality not found
 The reason why a geocode has not been assigned to the collecting locality. Select a value from the pick list, and enter any additional comments in the Georeferencing notes field.
OriginalCoordSystem varchar(32) Coord. system Darwin Core verbatimCoordinatesystem
Protocol varchar(64) Protocol protocol
Source varchar(64) Source
Validation varchar(64) Validation validation
CreatedByAgentID int(11) MUL
LocalityID int(11) MUL
AgentID int(11) MUL
ModifiedByAgentID int(11) MUL
GeoRefAccuracy double Uncertainty in meters Darwin Core coordinateUncertaintyInMeters
Text1 text Geocode source The source of the geocode (e.g.' Western Australian Phytogeographic Regions map, 1980')
Text2 text ALA quality assertion ALA quality assertions
  • Detected outlier
  • Coordinates outside country
  • Coordinates outside state
  • Coordinates in centre of country
  • Coordinates in centre of state
 Quality assertions from the ALA data quality tools
Text3 text Text3 text3
GeoRefCompiledDate datetime Geo Ref Compiled Date geoRefCompiledDate
CompiledByID int(11) MUL

Indexes

Name Fields Unique Nullable
FKB688EB95384B3622 AgentID
FKB688EB955327F942 ModifiedByAgentID
FKB688EB957699B003 CreatedByAgentID
FKB688EB9580202F05 CompiledByID
FKB688EB95A666A5C4 LocalityID
PRIMARY GeoCoordDetailID

Many-to-one relationships

Name Field Related table Related field
FKB688EB95384B3622 AgentID agent AgentID
FKB688EB955327F942 ModifiedByAgentID agent AgentID
FKB688EB957699B003 CreatedByAgentID agent AgentID
FKB688EB9580202F05 CompiledByID agent AgentID
FKB688EB95A666A5C4 LocalityID locality LocalityID