Marine Infrastructure Points |
A point feature class displaying the location of infrastructure associated with the marine environment of Queensland's Coastline and inland waters. |
Column Name | Nulls | Format | Size | Description | Constraints |
FEATURE_TYPE | No | Text | 50 | Unique feature type that identifies the type of feature. Options: | dm_marine_ infra_point |
NAME | Yes | Text | 100 | The name of the feature (if available) | |
ALTERNATE_NAME | Yes | Text | 100 | An alternate name of the feature if available from the Queensland Place Names Database, otherwise left blank | |
QLD_PNDB_ID | Yes | Long | | Queensland Place Names Database unique identifier | |
ATTRIBUTE_SOURCE | No | Text | 100 | If the feature is named, the attribute_source is the source imagery, map or data from which the features name has been obtained. If the feature is not named, the attribute_source is the source imagery, map, or data used to define what the feature type is. | |
ATTRIBUTE_DATE | No | Date | | Date of the source imagery, map, or data used for attributing the feature. | |
ADDITIONAL_NAMES | Yes | Text | 100 | The feature may be commonly known by other names or have different spelling. Multiple additional names can be shown and separated by a comma. | |
ADD_NAMES_SOURCE | Yes | Text | 100 | The source map or data that the additional names were obtained. Multiple sources can be shown, separated by a comma. If multiple sources are shown, the written sequence will be the same as the written sequence of the names themselves. | |
FEATURE_SOURCE | No | Text | 100 | The source imagery, map, or data that the spatial location of the feature was obtained from. | |
FEATURE_DATE | No | Date | | Date of the feature source information that the location of the feature was obtained from. | |
OPERATIONAL_STATUS | No | Text | 30 | The operation status of the facility. Options: Abandoned Operational Non Operational Proposed Under Construction
| dm_infra_status |
PFI | No | Text | 15 | A Persistent Feature Identifier (PFI) is generated for each feature at the point of creation in the database. The value of the PFI will stay with the feature through all changes to the feature (both spatial and non-spatial) until the feature is retired. (See Persistent and Unique Feature Identifiers) | |
UFI | No | Text | 15 | A Unique Feature Identifier (UFI) is generated for each new feature at the point of creation in the database (at this point the PFI and UFI will be the same). The value of the UFI will stay with the feature through all changes to the feature (both spatial and non-spatial) unless the feature is split into multiple other parts. If the feature is split, the separate parts will retain the original PFI but new UFI’s will be generated for the split parts. (See Persistent and Unique Feature Identifiers) | |
CREATED_DATE* | No | Date | | The date the feature was originally captured and first loaded to the database *internal use only | |
LAST_EDITED_DATE* | No | Date | | Date of the last editing or revision to the feature *internal use only | |
UPPER_SCALE | No | Long | | The upper scale for which the feature should be considered suitable for digital display | dm_upper_scale |
TEXT_NOTE | Yes | Text | 50 | For mapping purposes. Additional annotation that can be shown on a map. | |
ADD_INFORMATION | Yes | Text | 255 | A comment field (additional information) | |