Green Bridges

Green Bridges

A polyline feature class displaying the location of bridges for green and or sustainable transportation options.

Attribute schema:

Green bridges

A polyline feature class displaying the location of bridges for green and or sustainable transportation options.

Column Name

Nulls

Format

Size

Description

Constraints

 

FEATURE_TYPE

 

No

Text

50

 

Unique feature type that identifies the type of feature.

Options:

  • Footbridge

  • Bikeway Bridge

  • Multi-use Bridge

  • Other Bridge

 

 

NAME

Yes

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 feature source information that the location of the feature was obtained from.

 

OPERATIONAL STATUS

No

Text

20

 

The operation status of the feature. Options:

  • Abandoned

  • Dismantled

  • Operational

  • Non Operational

  • Proposed

  • Under Construction

 

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*

Yes

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

Yes

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:

  • Foot Bridge – A structure erected over a depression or obstacle to carry pedestrian traffic only.

  • Bikeway Bridge – A structure erected over a depression or obstacle to carry bicycle traffic only.

  • Multi-use Bridge – A structure erected over a depression or obstacle to carry multi forms of traffic.

  • Other Bridge – Any bridge not covered by the above.

Upper scale:

  • 1:25 000 – all data

Capture process:

FOOTBRIDGE

 

Definition: A structure erected over a depression or obstacle to carry pedestrian traffic

 

Alternate Terms: Pedestrian overpass

 

 

  • Capture as a 2D polyline along the centre of the feature

  • The location is plotted from orthorectified imagery

  • Locations can be obtained from other datasets, existing mapping, organisations, Government websites, or other source material.

  • Capture features of significance. e.g. a length greater than 25 metres, major throughfare etc

  • End points to coincide with the vertex of any pathway feature.

  • If the feature is less than 25 metres and is named or significant, capture to the feature extents

 

 

BIKEWAY BRIDGE

 

Definition: A structure erected over a depression or obstacle to carry bicycle traffic

 

Alternate Terms: Bikeway overpass, Cycleway bridge, Cycleway overpass

 

 

  • Capture as a 2D polyline along the centre of the feature

  • The location is plotted from orthorectified imagery

  • Locations can be obtained from other datasets, existing mapping, organisations, Government websites, or other source material.

  • Capture features of significance. e.g. a length greater than 25 metres, major throughfare etc

  • End points to coincide with the vertex of any pathway feature.

  • If the feature is less than 25 metres and is named or significant, capture to the feature extents

 

 

MULTI-USE BRIDGE

 

Definition: A structure erected over a depression or obstacle to carry multi forms of traffic

 

Alternate Terms: mixed use bridge, mixed use overpass

 

 

  • Capture as a 2D polyline along the centre of the feature

  • The location is plotted from orthorectified imagery

  • Locations can be obtained from other datasets, existing mapping, organisations, Government websites, or other source material.

  • Capture features of significance. e.g. a length greater than 25 metres, major throughfare etc

  • End points to coincide with the vertex of any pathway feature.

  • If the feature is less than 25 metres and is named or significant, capture to the feature extents

 

Return to Transport Networks