geography

Table info.

Title Geography
Description Geography

Fields

Name Type Required Index Hidden On form Title Pick list Description
GeographyID int(11) PRI
TimestampCreated datetime Created The timestamp the record was created.
TimestampModified datetime Last edited The timestamp the record was last modified.
Version int(11) Version version
Abbrev varchar(16) Abbreviation abbrev
CentroidLat decimal(19,2) Centroid Latitude centroidLat
CentroidLon decimal(19,2) Centroid Longitude centroidLon
CommonName varchar(128) Name on label The name as it will print on labels, if different to the standard name
FullName varchar(500) MUL Full name Full name string
GeographyCode varchar(24) Geography Code geographyCode
GML text GML gml
GUID varchar(128) GUID guid
HighestChildNodeNumber int(11) Highest Child Node Number highestChildNodeNumber
IsAccepted bit(1) Is Preferred The preferred name of a synonym.
IsCurrent bit(1) Is Current `Yes` if the Name and/or Geographic/Political entity is currently valid.
Name varchar(128) MUL Name The geographic place name
NodeNumber int(11) Node Number nodeNumber
Number1 int(11) Number1 User definable
Number2 int(11) Number2 User definable
RankID int(11) Rank Id rankId
Remarks text Comments Comments about the geographical place name
Text1 varchar(32) Country code Darwin Core countrycode: this is the Geography code for the country.
Text2 varchar(32) Continent Continent from the GBIF continent enumeration (http://gbif.github.io/gbif-api/apidocs/org/gbif/api/vocabulary/Continent.html). These are different from the TDWG-WGS Level 1 regions that are used in storage of vascular plants.
TimestampVersion datetime Timestamp Version timestampVersion
AcceptedID int(11) MUL
ParentID int(11) MUL
GeographyTreeDefID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
GeographyTreeDefItemID int(11) MUL

Indexes

Name Fields Unique Nullable
FK496A777C5327F942 ModifiedByAgentID
FK496A777C7699B003 CreatedByAgentID
FK496A777C83AAF47E ParentID
FK496A777CBF9C9714 GeographyTreeDefID
FK496A777CE3C6E41A GeographyTreeDefItemID
FK496A777CF484C03B AcceptedID
GeoFullNameIDX FullName
GeoNameIDX Name
PRIMARY GeographyID

One-to-many relationships

Name Field Related table Related field
FK89CDCA17D649F6D0 GeographyID agentgeography GeographyID
FK496A777C83AAF47E GeographyID geography ParentID
FK496A777CF484C03B GeographyID geography AcceptedID
FK714BFD63D649F6D0 GeographyID locality GeographyID

Many-to-one relationships

Name Field Related table Related field
FK496A777C5327F942 ModifiedByAgentID agent AgentID
FK496A777C7699B003 CreatedByAgentID agent AgentID
FK496A777C83AAF47E ParentID geography GeographyID
FK496A777CBF9C9714 GeographyTreeDefID geographytreedef GeographyTreeDefID
FK496A777CE3C6E41A GeographyTreeDefItemID geographytreedefitem GeographyTreeDefItemID
FK496A777CF484C03B AcceptedID geography GeographyID

View: Geography (Discipline)

<view name="Geography"
      class="edu.ku.brc.specify.datamodel.Geography"
      busrules="edu.ku.brc.specify.datamodel.busrules.GeographyBusRules"
      isinternal="false"
      resourcelabels="false">
    <desc><![CDATA[Geography data entry form.]]></desc>
    <altviews>
        <altview name="Geography View" viewdef="Geography" mode="view"/>
        <altview name="Geography Edit" viewdef="Geography" mode="edit" default="true"/>
    </altviews>
</view>

View def.: Geography

<viewdef name="Geography"
      type="form"
      class="edu.ku.brc.specify.datamodel.Geography"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj"
      useresourcelabels="true">
 
    <desc><![CDATA[New Geography Node Form]]></desc>
    <enableRules>
        <!--rule id="acceptedParent"><![CDATA[!isAccepted.isSelected()]]></rule-->
        <rule id="definitionItem"><![CDATA[parent.getValue() != null]]></rule>
    </enableRules>
    <columnDef>100px,2px,323px,5px,135px,2px,150px,5px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,370px,5px,135px,2px,168px,25px,95px,0px,15px,p,p:g</columnDef>
    <columnDef os="mac">130px,2px,483px,5px,140px,2px,150px,10px,110px,0px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,max(p;323px),5px:g,p,2px,max(p;150px),25px,p,0px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="parent"/>
        	<cell type="field" id="parent" uitype="querycbx" isrequired="true" initialize="name=Geography;title=Geography;editbtn=false;newbtn=false;editoncreate=true" name="parent"/>
            <cell type="label" labelfor="definitionItem"/>
        	<cell type="field" id="definitionItem" uitype="combobox" name="definitionItem"/>
        </row>
        <row>
            <cell type="label" labelfor="name"/>
            <cell type="field" id="name" uitype="text" cols="6" name="name" colspan="5"/> 
        </row>
        <!--row>
        	<cell type="label" labelfor="acceptedParent"/>
        	<cell type="field" id="acceptedParent" uitype="querycbx" initialize="name=Geography;title=Geography;editbtn=false;newbtn=false" name="acceptedParent"/>
        	<cell type="field" id="isAccepted" uitype="checkbox" name="isAccepted" default="true" isrequired="true"/>
        </row-->
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="text1" uitype="text" colspan="5"/>
        </row>
        <row>
            <cell type="label" labelfor="remarks"/>
            <cell type="field" id="remarks" uitype="textareabrief" rows="2" name="remarks" colspan="5"/>
        </row>
        <row>
            <cell type="subview" viewname="GeographySubform" id="children" name="children" colspan="8"/>
        </row>
    </rows>
</viewdef>
 

View: GeographySubform (Discipline)

<view name="GeographySubform"
      class="edu.ku.brc.specify.datamodel.Geography"
      busrules="edu.ku.brc.specify.datamodel.busrules.GeographyBusRules"
      resourcelabels="false">
    <desc><![CDATA[Geography data entry form.]]></desc>
    <altviews>
        <altview name="Geography Children View" viewdef="GeographySubform" mode="view"/>
    </altviews>
</view>

View def.: GeographySubform

<viewdef name="GeographySubform"
      type="form"
      class="edu.ku.brc.specify.datamodel.Geography"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[New Geography Node Form]]></desc>
    <enableRules/>
 
    <columnDef>100px,2px,400px,p:g</columnDef>
    <!--columnDef os="lnx">115px,2px,800px,p:g</columnDef>
    <columnDef os="mac">130px,2px,900px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g</columnDef-->
    <rowDef auto="true" cell="p" sep="2dlu"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="Name"/>
            <cell type="field" id="Name" uitype="text" cols="16" name="Name"/> 
        </row>
    </rows>
</viewdef>