localitydetail

Table info.

Title Locality Detail
Description Locality Detail

Fields

Name Type Required Index Hidden On form Title Pick list Description
LocalityDetailID int(11) PRI
TimestampCreated datetime Created timestampCreated
TimestampModified datetime Last edited timestampModified
Version int(11) Version version
BaseMeridian varchar(50) baseMeridian
Drainage varchar(64) Gazetteer Used to record the place name in the gazetteer that is the source of the geocode
StartDepth double Min. depth The depth that a specimen was collected at, in metres. If depth is given as a range, enter the shallower value here.
startdepthunit varchar(23) Depth unit Depth unit
  • metres
  • feet
  • fathoms
 The units the depth is given in (fathoms, feet, metres)
StartDepthVerbatim varchar(32) Start Depth Verbatim startDepthVerbatim
EndDepth double Max. depth If depth is given as a range, enter the deeper value here.
enddepthunit varchar(23) End Depth Unit endDepthUnit
EndDepthVerbatim varchar(32) End Depth Verbatim endDepthVerbatim
GML text Gml gml
HucCode varchar(16) Original geocode format The format in which the original geocode was provided
Island varchar(64) MUL Island
IslandGroup varchar(64) MUL Island group
MgrsZone varchar(4) Zone
NationalParkName varchar(64) National Park Name
Number1 double Number1
Number2 double Number2
RangeDesc varchar(50) Range rangeDesc
RangeDirection varchar(50) Range Direction rangeDirection
Section varchar(50) Botanical region The botanical region, when provided by the collector or listed on an exchange label
SectionPart varchar(50) Section Part sectionPart
Text1 text Text 1
Text2 text Map reference A map reference, if provided by the collector (e.g. the mapsheet on which the easting and northing is based, or a reference from a street directory)
Township varchar(50) Generalised locality The named place the locality is closest to. This is a read-only field; this information is obtained by reverse geocoding.
TownshipDirection varchar(50) Relation The relation of the collecting locality to the generalised locality
UtmDatum varchar(255) Grid UTMGrid
  • UTM
  • AMG
  • MGA
 UTM grid
UtmEasting decimal(19,2) Easting The UTM easting. Easting values are six digits in length.
UtmFalseEasting int(11) UTM False Easting utmFalseEasting
UtmFalseNorthing int(11) UTM False Northing utmFalseNorthing
UtmNorthing decimal(19,2) Northing The UTM northing. Northing values are seven digits in length.
UtmOrigLatitude decimal(19,2) utmOrigLatitude
UtmOrigLongitude decimal(19,2) utmOrigLongitude
UtmScale decimal(20,10) UTM Scale utmScale
UtmZone smallint(6) utmZone utmZone
WaterBody varchar(64) Water body Water body
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2
ModifiedByAgentID int(11) MUL
LocalityID int(11) MUL
CreatedByAgentID int(11) MUL
Number3 float Number3
Number4 float Number4
Number5 float Number5 number5
PaleoLat varchar(32) Paleo Latitude paleoLat
PaleoLng varchar(32) Paleo Longitude paleoLng
Text3 text Verbatim depth
Text4 text Text4
Text5 text Text5
YesNo3 bit(1) Yes No3 yesNo3
YesNo4 bit(1) Yes No4 yesNo4
YesNo5 bit(1) Yes No5 yesNo5

Indexes

Name Fields Unique Nullable
FKBB0D3F745327F942 ModifiedByAgentID
FKBB0D3F747699B003 CreatedByAgentID
FKBB0D3F74A666A5C4 LocalityID
Island Island
IslandGroup IslandGroup
PRIMARY LocalityDetailID

Many-to-one relationships

Name Field Related table Related field
FKBB0D3F745327F942 ModifiedByAgentID agent AgentID
FKBB0D3F747699B003 CreatedByAgentID agent AgentID
FKBB0D3F74A666A5C4 LocalityID locality LocalityID