Appendix B – Roads Data Dictionary

Roads

Name

Data Type

Description

Primary Key

Mandatory Field

10 Character alias

road_pid

character string (15)

Persistent identifier for a Roads feature

yes

yes

ROAD_PID

contributor_id

character string (40)

The contributor’s identifier for a Roads segment

no

no

CONTRIB_ID

date_created

date (dd-mm-yyyy)

Date this record was created in the data custodian’s system. Where this date is not available, then the first date on which the feature was processed for inclusion within Roads.

no

yes

DT_CREATE

date_modified

date (dd-mm-yyyy)

Date this record was last updated

no

no

DT_MOD

national_route

character string (10)

A route number to identify a route of National significance (e.g. C30)

no

no

NAT_ROUTE

state_route

character string (10)

A route number to identify a route of State significance (e.g. A20)

no

no

STA_ROUTE

road_name

character string (50)

Name of the road (e.g. SMITH AND JOHN)

no

no

RD_NAME

road_name_label

character string (50)

Title Case of road_name (e.g. Smith and John)

no

no

RD_NAM_LAB

road_type

character string (12)

Type of road (e.g. ROAD, STREET, CIRCUIT, LANE)

no

no

RD_TYPE

road_type_label

character string (12)

Title Case of road_type (e.g. Road, Street)

no

no

RD_TYP_LAB

road_suffix

character string (10)

Suffix of road (e.g. WEST)

no

no

RD_SUFFIX

road_suffix_label

character string (10)

Title Case of road_suffix (e.g. West)

no

no

RD_SUF_LAB

road_alias_name

character string (50)

A secondary name of the road

no

no

RD_AL_NAM

road_alias_type

character string (12)

A secondary type of the road

no

no

RD_AL_TYPE

road_alias_suffix

character string (10)

A secondary suffix of the road

no

no

RD_AL_SUF

hierarchy

character string (25)

Hierarchy of the road (e.g. NATIONAL OR STATE HIGHWAY)

no

no

HIERARCHY

subtype

character string (10)

Physical type of a road (e.g. ROUNDABOUT)

no

no

SUBTYPE

lane_count

number (2)

Number of physical lanes represented as a total count

no

no

LANE_COUNT

lane_description

character string (20)

Description of the physical lane count of a road

no

no

LANE_DESC

one_way

character string (20)

Indicates if the road supports one-way or two-way traffic direction

no

no

ONE_WAY

access_type

character string (20)

Accessibility of road (e.g. PRIVATE)

no

no

ACCESS_TYP

status

character string (20)

Lifecycle stage of a road (e.g. OPERATIONAL)

no

no

STATUS

surface

character string (20)

Surface of the road (e.g. SEALED)

no

no

SURFACE

trafficability

character string (20)

Indicates the minimum type of vehicle advised to traverse the road (e.g. 2WD)

no

no

TRFFCBL

travel_direction

character string (7)

Direction a vehicle is allowed to travel

no

no

TRADIR

speed

number (3)

Posted speed limit for the section of road to which it is attributed

no

no

SPEED

state

character string (3)

Indicates the State or Territory abbreviation of the jurisdiction its linear geometry predominantly intersects (e.g. NSW)

no

yes

STATE

geometry

polyline

Geometry of road

no

yes

GEOMETRY

Street Locality Line

Name

Data Type

Description

Primary Key

Mandatory Field

10 Character alias

street_locality_line_pid

character string (15)

Persistent identifier for a street_locality_line feature.

yes

yes

SL_LNE_PID

street_locality_pid

character string (15)

Foreign key relationship to G-NAF street_locality table.

no

no

ST_LOC_PID

date_created

date (dd-mm-yyyy)

The date on which the feature was processed for inclusion within street_locality_line.

no

yes

DT_CREATE

road_pid

character string (15)

Persistent identifier for a Roads feature.

no

yes

ROAD_PID

road_name

character string (50)

Name of the road (e.g. SMITH AND JOHN)

no

no

RD_NAME

road_type

character string (12)

Type of road (e.g. ROAD, STREET, CIRCUIT, LANE)

no

no

RD_TYPE

road_suffix

character string (10)

Suffix of road (e.g. WEST)

no

no

RD_SUFFIX

locality_pid

character string (15)

The persistent identifier of the locality associated with the road feature.

no

yes

LOC_PID

state

character string (3)

Indicates the state that supplied the road record (e.g. NSW).

no

yes

STATE

geometry

Polyline

Geometry of street_locality_line feature.

no

yes

GEOMETRY

Road Types

road_type/ road_alias_type

road_type_label

road_type/ road_alias_type

road_type_label

road_type/ road_alias_type

road_type_label

ACCESS

Access

EXTENSION

Extension

PRECINCT

Precinct

ACRE

Acre

FAIRWAY

Fairway

PROMENADE

Promenade

AIRWALK

Airwalk

FIREBREAK

Firebreak

PURSUIT

Pursuit

ALLEY

Alley

FIRELINE

Fireline

QUAD

Quad

ALLEYWAY

Alleyway

FIRETRACK

Firetrack

QUADRANT

Quadrant

AMBLE

Amble

FIRETRAIL

Firetrail

QUAY

Quay

APPROACH

Approach

FLAT

Flat

QUAYS

Quays

ARCADE

Arcade

FLATS

Flats

RAMBLE

Ramble

ARTERIAL

Arterial

FOLLOW

Follow

RAMP

Ramp

ARTERY

Artery

FOOTWAY

Footway

RANGE

Range

AVENUE

Avenue

FORD

Ford

REACH

Reach

BANAN

Banan

FORESHORE

Foreshore

REEF

Reef

BANK

Bank

FORK

Fork

RESERVE

Reserve

BAY

Bay

FORMATION

Formation

REST

Rest

BEACH

Beach

FREEWAY

Freeway

RETREAT

Retreat

BEND

Bend

FRONT

Front

RETURN

Return

BOARDWALK

Boardwalk

FRONTAGE

Frontage

RIDE

Ride

BOULEVARD

Boulevard

GAP

Gap

RIDGE

Ridge

BOULEVARDE

Boulevarde

GARDEN

Garden

RIGHT OF WAY

Right Of Way

BOWL

Bowl

GARDENS

Gardens

RING

Ring

BRACE

Brace

GATE

Gate

RISE

Rise

BRAE

Brae

GATEWAY

Gateway

RISING

Rising

BRANCH

Branch

GLADE

Glade

RIVER

River

BREAK

Break

GLEN

Glen

ROAD

Road

BRETT

Brett

GRANGE

Grange

ROADS

Roads

BRIDGE

Bridge

GREEN

Green

ROADWAY

Roadway

BROADWALK

Broadwalk

GROVE

Grove

ROTARY

Rotary

BROADWAY

Broadway

GULLY

Gully

ROUND

Round

BROW

Brow

HARBOUR

Harbour

ROUTE

Route

BULL

Bull

HAVEN

Haven

ROW

Row

BUSWAY

Busway

HEATH

Heath

ROWE

Rowe

BYPASS

Bypass

HEIGHTS

Heights

RUE

Rue

BYWAY

Byway

HIGHROAD

Highroad

RUN

Run

CAUSEWAY

Causeway

HIGHWAY

Highway

SERVICEWAY

Serviceway

CENTRE

Centre

HIKE

Hike

SHUNT

Shunt

CENTREWAY

Centreway

HILL

Hill

SKYLINE

Skyline

CHASE

Chase

HILLS

Hills

SLOPE

Slope

CIRCLE

Circle

HOLLOW

Hollow

SOUTH

South

CIRCLET

Circlet

HUB

Hub

SPUR

Spur

CIRCUIT

Circuit

INLET

Inlet

SQUARE

Square

CIRCUS

Circus

INTERCHANGE

Interchange

STEPS

Steps

CLOSE

Close

ISLAND

Island

STRAIGHT

Straight

CLUSTER

Cluster

JUNCTION

Junction

STRAIT

Strait

COLONNADE

Colonnade

KEY

Key

STRAND

Strand

COMMON

Common

KEYS

Keys

STREET

Street

COMMONS

Commons

KNOLL

Knoll

STRIP

Strip

CONCORD

Concord

LADDER

Ladder

SUBWAY

Subway

CONCOURSE

Concourse

LANDING

Landing

TARN

Tarn

CONNECTION

Connection

LANE

Lane

TERRACE

Terrace

COPSE

Copse

LANEWAY

Laneway

THOROUGHFARE

Thoroughfare

CORNER

Corner

LEAD

Lead

THROUGHWAY

Throughway

CORSO

Corso

LEADER

Leader

TOLLWAY

Tollway

COURSE

Course

LINE

Line

TOP

Top

COURT

Court

LINK

Link

TOR

Tor

COURTYARD

Courtyard

LOOKOUT

Lookout

TRACK

Track

COVE

Cove

LOOP

Loop

TRAIL

Trail

CRESCENT

Crescent

LYNNE

Lynne

TRAMWAY

Tramway

CREST

Crest

MALL

Mall

TRAVERSE

Traverse

CRIEF

Crief

MANOR

Manor

TRIANGLE

Triangle

CROOK

Crook

MART

Mart

TRUNKWAY

Trunkway

CROSS

Cross

MAZE

Maze

TUNNEL

Tunnel

CROSSING

Crossing

MEAD

Mead

TURN

Turn

CRUISEWAY

Cruiseway

MEANDER

Meander

TWIST

Twist

CUL-DE-SAC

Cul-De-Sac

MEW

Mew

UNDERPASS

Underpass

CUT

Cut

MEWS

Mews

VALE

Vale

CUTTING

Cutting

MILE

Mile

VALLEY

Valley

DALE

Dale

MOTORWAY

Motorway

VERGE

Verge

DASH

Dash

NOOK

Nook

VIADUCT

Viaduct

DELL

Dell

NORTH

North

VIEW

View

DENE

Dene

OUTLET

Outlet

VIEWS

Views

DEVIATION

Deviation

OUTLOOK

Outlook

VILLA

Villa

DIP

Dip

OVAL

Oval

VILLAGE

Village

DISTRIBUTOR

Distributor

PALMS

Palms

VILLAS

Villas

DIVIDE

Divide

PARADE

Parade

VISTA

Vista

DOCK

Dock

PARADISE

Paradise

VUE

Vue

DOMAIN

Domain

PARK

Park

WADE

Wade

DOWN

Down

PARKWAY

Parkway

WALK

Walk

DOWNS

Downs

PART

Part

WALKWAY

Walkway

DRIVE

Drive

PASS

Pass

WATERS

Waters

DRIVEWAY

Driveway

PASSAGE

Passage

WATERWAY

Waterway

EASEMENT

Easement

PATH

Path

WAY

Way

EAST

East

PATHWAY

Pathway

WEST

West

EDGE

Edge

PENINSULA

Peninsula

WHARF

Wharf

ELBOW

Elbow

PIAZZA

Piazza

WOOD

Wood

END

End

PLACE

Place

WOODS

Woods

ENTRANCE

Entrance

PLAZA

Plaza

WYND

Wynd

ESPLANADE

Esplanade

POCKET

Pocket

YARD

Yard

ESTATE

Estate

POINT

Point

EXPRESSWAY

Expressway

PORT

Port

Road Suffix

road_suffix/ road_alias_suffix

road_suffix_label

CENTRAL

Central

DEVIATION

Deviation

EAST

East

EXTENSION

Extension

INNER

Inner

LOWER

Lower

MALL

Mall

NORTH

North

NORTH EAST

North East

NORTH WEST

North West

OFF

Off

ON

On

OUTER

Outer

OVERPASS

Overpass

SOUTH

South

SOUTH EAST

South East

SOUTH WEST

South West

UPPER

Upper

WEST

West

Hierarchy

Domain Value

Domain Value Description

NATIONAL OR STATE HIGHWAY

Roads which are of importance in a national sense, and/or are major interstate through route, principal connector roads between capitals, major regions, key towns, commercial centres or inter-transport hubs.

ARTERIAL ROAD

Well maintained and widely used roads which are major connectors for national highways or state highways, major centres, key towns, or have major tourist importance or which main function is to form the principal avenue of communication for metropolitan traffic movements.

SUB-ARTERIAL ROAD

Acts as connector between highways and/or arterial roads, or as an alternative for arterial roads, or a principal avenue for massive traffic movements.

COLLECTOR ROAD

Provides for traffic movement between sub-arterial and local roads or to distribute traffic to local street systems.

LOCAL ROAD

Local area roads, often in residential areas. Includes service roads that may share the same name as higher order roads.

ACCESS ROAD

Road designed to provide access to the rear of, into or within a property but may not necessarily be part of the public road network. Would be applied to urban service lanes, driveways or and tracks.

VEHICLE TRACK

Unimproved roads which are generally restricted to a single lane with occasional passing opportunities. These roads are influenced by seasonal and weather conditions restricting access to particular vehicle types.

BUSWAY

A road which has been dedicated as a rapid bus-only transit way. This does not include roads which have bus-only lanes.

FERRY

A route which requires a ferry to traverse a body of water. These can be both passenger and vehicular transport.

FOOTPATH

Features that are intended for use of pedestrians.

CYCLEPATH

Features that are intended for bicycle transportation.

Subtype

Domain Values

Description

ROAD

Default value. Road with ability to be addressed if required. Would include emergency crossovers.

ROUNDABOUT

Road segment part of an intersection designed to allow smooth integration but also slow traffic. It must be circular or elliptical in design, have one-way flow, and would generally not have addresses on it.

RAMP

An access ramp to or from one road to another, to allow smooth integration of traffic. Travel flow is in one direction only, Ramps are always sealed and mostly have a single lane.

TUNNEL

An underground passage utilised by vehicular traffic to travel between point a and b quickly.

FIRE TRAIL

Primarily utilised by management vehicles and emergency services. May be open to access by the public.

BRIDGE

Structure erected over a depression or obstacle to carry traffic.

FERRY

The feature represents a ferry route.

PATHWAY

Default value for Hierarchies of FOOTPATH or CYCLEPATH. Classification of a FOOTPATH or CYCLEPATH Hierarchy that is not classified as any of the other subtypes (e.g. BRIDGE or TUNNEL)

Lane Description

Domain Values

Description

ONE

Road has one lane in each permitted traffic direction or is a single lane road.

TWO OR MORE

Road has two or more lanes in at least one permitted traffic direction.

One Way

Domain Values

Description

ONE WAY

Allows for traffic in one direction only.

TWO WAY

Allows for traffic in two directions.

Access Type

Domain Values

Description

PUBLIC

Is open to the general public.

PRIVATE

May be blocked by a fence or gate.

MANAGEMENT ONLY

For management purposes only and therefore may be blocked by a fence or gate.

Status

Domain Values

Description

OPERATIONAL

Can be used for transport.

UNDER CONSTRUCTION

Currently being built.

PROPOSED

Not yet built and may still be awaiting approval.

CLOSED

No longer used for traffic. Can include historical roads that are no longer maintained.

Surface

Domain Values

Description

SEALED

The road has a constructed surface e.g. brick, concrete, asphalt.

UNSEALED

The surface does not have a constructed surface.

Trafficability

Domain Values

Description

2WD

The minimum vehicle requirement recommended is a 2-wheel drive capable vehicle.

4WD

The minimum vehicle requirement recommended is a 4-wheel drive capable vehicle.

Travel Direction

Domain Values

Description

FROM TO

Traffic with the direction of digitisation.

TO FROM

Traffic against the direction of digitisation.

BOTH

Traffic can travel either direction.

State

Domain Values

Description

ACT

Australian Capital Territory

NSW

New South Wales

NT

Northern Territory

QLD

Queensland

SA

South Australia

TAS

Tasmania

VIC

Victoria

WA

Western Australia