List of Entities, Diagram: CDEFD Gathering Site Related Entities

Entities are listed in alphabetical order. For every entity, primary key attributes (if present) are listed first, other attributes follow in alphabetical order. Foreign keys are recognized by a _Pt suffix (pointer).
Every attribute name is followed by the name of its data element, which in many cases provides a short description of the attribute's meaning. Type and example values refer to the data element.


Co-ordinate System

CoordinateSystem_ID
Data element: Co-ordinate System Identifier
Type: LONG
CentralMeridian
Data element: Co-ordinate System Central Meridian
Type: INTEGER
CoordinateSystemName
Data element: Co-ordinate System Name or Description
Type: CHAR()
NumberFormatting
Data element: Co-ordinate System Number Formatting Rules
Type: CHAR()
PrefixForX
Data element: Co-ordinate System Prefix for X-value
Type: CHAR()
PrefixForY
Data element: Co-ordinate System Prefix for Y-value
Type: CHAR()
SuffixForXNegative
Data element: Co-ordinate System Suffix for X-negative Value
Type: CHAR()
SuffixForXPositive
Data element: Co-ordinate System Suffix for X-positive Value
Type: CHAR()
SuffixForYNegative
Data element: Co-ordinate System Suffix for Y-negative Value
Type: CHAR()
SuffixForYPositive
Data element: Co-ordinate System Suffix for Y-positive Value
Type: CHAR()


Ecological Site Descriptors

EcolSiteDescriptor_ID
Data element: Ecological Site Descriptor Set Identifier
Type: LONG
EcolDescriptorName
Data element: Ecological Site Descriptor Name
Type: CHAR()
EcolDescriptorValue
Data element: Ecological Site Descriptor Value
Type: CHAR()
EcolDescriptrSubtypeDesig
Data element: Ecological Site Descriptor Subtype Designator
Type: CHAR()


Gathering Site

Site_ID
Data element: Site Object Identifier
Type: LONG
AltitudePrecisModif
Data element: Altitude Precision Modifier
Type: CHAR(10)
Example values: estimated, ca., about
AltitudeRangeHigherValue
Data element: Altitude Higher Value of Range
Type: INTEGER
AltitudeUnit
Data element: Length Measurement Unit
Type: CHAR()
Example values: m, ft
AltitudeValue
Data element: Altitude Single Value or Lower Value of Range
Type: INTEGER()
AltitudeValueError
Data element: Altitude Value Error
Type: INTEGER
Area_Pt
Data element: Gazetteer: Area Identifier
Type: LONG
CoordinatePrecisModif
Data element: Co-ordinates Precision Modifier
Type: CHAR(10)
Example values: about, estimated, ca.
CoordinateSystem_Pt
Data element: Co-ordinate System Identifier
Type: LONG
CoordinateValueError
Data element: Co-ordinates Error
Type: DOUBLE
CoordinateXValue
Data element: Co-ordinates X-value
Type: DOUBLE
CoordinateYValue
Data element: Co-ordinates Y-value
Type: DOUBLE
GridCode
Data element: Geographical Grid System Cell Code
Type: CHAR()
GridPrecisModif
Data element: Geographical Grid Code Assignment Precision Modifier
Type: CHAR()
GridSystemName
Data element: Geographical Grid System Name
Type: CHAR()
MeasurementMethod
Data element: Geospatial Co-ordinates Measurement Method
Type: CHAR()
Example values: from map, GPS, GPS with local reference
SiteDetail
Data element: Site Localization Detail
Type: CHAR()
SiteUserDefinedName
Data element: Gathering Site User Defined Name
Type: CHAR()


Gazetteer: Area Name

AreaName_ID
Data element: Gazetteer: Area Non-English Name Identifier
Type: LONG
AreaCategoryName
Data element: Gazetteer: Area Category Name
Type: CHAR()
AreaName
Data element: Gazetteer: Area Name
Type: CHAR()
Area_Pt
Data element: Gazetteer: Area Identifier
Type: LONG
DefaultNameFlag
Data element: Gazetteer: Area Name Default Flag
Type: LOGICAL (Y/N)
Language_Pt
Data element: Language Identifier
Type: LONG


Gazetteer: Geographic Area

Area_ID
Data element: Gazetteer: Area Identifier
Type: LONG
AltitudMax
Data element: Gazetteer: Area Highest Point Elevation in m
Type: INTEGER
AltitudMin
Data element: Gazetteer: Area Lowest Point Elevation in m
Type: INTEGER
AreaDataSourceRef_Pt
Data element: Reference Title Identifier
Type: LONG
AreaSubtypeDesignator
Data element: Gazetteer: Geographic Area Subtype Designator
Type: CHAR()
CoordinateSystem_Pt
Data element: Co-ordinate System Identifier
Type: LONG
CoordinateXMax
Data element: Co-ordinates X-value
Type: DOUBLE
CoordinateXMin
Data element: Co-ordinates X-value
Type: DOUBLE
CoordinateYMax
Data element: Co-ordinates Y-value
Type: DOUBLE
CoordinateYMin
Data element: Co-ordinates Y-value
Type: DOUBLE
HigherCategoryArea_Pt
Data element: Gazetteer: Area Identifier
Type: LONG
LandWaterMarker
Data element: Gazetteer: Area is Land and/or Water Marker
Type: CHAR()
ValidFromDate
Data element: Gazetteer: Area Validity Starting Date
Type: DATE
ValidUntilDate
Data element: Gazetteer: Area Validity Ending Date
Type: DATE


Gazetteer: Geographic Area Inclusion

IncludedArea_Pt
Data element: Gazetteer: Area Identifier
Type: LONG
IncludingArea_Pt
Data element: Gazetteer: Area Identifier
Type: LONG
PartiallyIncludedFlag
Data element: Gazetteer: Geographic Area Partial Inclusion Flag
Type: LOGICAL (Y/N)


Geoecological Classification Unit

GeoecolUnit_ID
Data element: Geoecological Classification Unit Identifier
Type: LONG
GeoecolClassCategory
Data element: Geoecological Classification Unit Category
Type: CHAR()
GeoecolClassSubtypeDesig
Data element: Geoecological Classification Unit Subtype Designation
Type: CHAR()
GeoecolClassSystemRef_Pt
Data element: Reference Title Identifier
Type: LONG
GeoecolClassUnitDetail
Data element: Geoecological Classification Unit Detailed Description
Type: MEMO
GeoecolClassUnitName
Data element: Geoecological Classification Unit Name
Type: CHAR()
HigherUnit_Pt
Data element: Geoecological Classification Unit Identifier
Type: LONG
Language_Pt
Data element: Language Identifier
Type: LONG


Language

Language_ID
Data element: Language Identifier
Type: LONG
LanguageCharacterSet
Data element: Language Character Set
LanguageEnglishName
Data element: Language English Name
Type: CHAR()
LanguageISOAbbr
Data element: Language ISO Code
Type: CHAR(2)
LanguageOwnName
Data element: Language Own Name
Type: CHAR()
LanguageSortOrder
Data element: Language Sort Order

This HTML document has been generated by an export function written in the scripting language of the CASE/4/0 program (MicroTool 1995).