Road Tunnels
A polyline feature class displaying the location of road tunnels along the Queensland road network.
Attribute schema:
Road Tunnels | |||||
A polyline feature class displaying the location of road tunnels along the Queensland road network. | |||||
Column Name | Nulls | Format | Size | Description | Constraints |
FEATURE_TYPE | No | Text | 50 |
Unique feature type that identifies the type of feature. Options:
|
|
NAME | No | Text | 100 | The name of the feature (if available) |
|
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 and shape of the of the feature was obtained from.
|
|
FEATURE_DATE | No | Date |
|
Date of the source imagery, map, or data that the spatial location and shape of the feature was obtained from.
|
|
OPERATIONAL STATUS | No | Text | 20 |
The operation status of the feature. Options:
| dm_road_bri_ status |
PFI | No | Text |
|
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 |
|
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 |
|
DIMENSION_M | No | Double |
| The length of the feature measured in metres GDA2020 |
|
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) |
|
SEGMENT_ID | Yes | Text | 20 | Corresponding id number for Queensland Roads and Tracks |
|
Feature Type definitions:
Road Tunnel – A constructed passage that may be underground, underwater or passing under infrastructure.
Upper scale:
1:25 000 – >/= 25 m and < 50 m
1:100 000 – >/= 50 m
Capture process:
ROAD TUNNEL
Definition: A constructed passage that may be underground, underwater or passing under infrastructure.
Alternate Terms: Underpass
|
|