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).