Table | Name | Field Alias | Data Type | Description |
Attribute Table | PLAN_NO | | text | Unique identifier / Asset Number as defined by DIT |
Attribute Table | LGA | | text | Local Government Association (LGA), council area in which the structure is located ie LGA number, as defined by Road Centreline System (Oracle Tables). |
Attribute Table | ROAD_NO | | text | Unique identifier as defined by DIT for roads which DIT are responsible for maintaining or may have in the past, as well roads which may be of interest to DIT
NCRN coded for roads which have no Road Number
|
Attribute Table | SIDE | | text | NOT Maintained
Carriageway/Side for the designated section of road |
Attribute Table | RRD | | Double | NOT Maintained
Driven length (road running distance) in kilometres from the start of the road to the structure.
NB All roads have a designated start, end and direction
|
Attribute Table | VERT_CLEARANCE_UNDER | | Double | Vertical Clearance Under the structure in metres |
Attribute Table | ROAD_NAME | | text | Road Name |
Attribute Table | ROAD_SECTION | | text | Section of road aiding in defining the location of the structure. |
Attribute Table | LOCATION_COMMENT | | text | Description locating the structure, to be read in conjunction with ROAD_SECTION |
Attribute Table | ROAD_NUMBER_UNDER | | text | The road number (ROAD_NO) of the road under the structure |
Attribute Table | ROAD_NAME_UNDER | | text | The name of the road under the structure |
Attribute Table | STRUCTURE_NAME | | text | Official name for the Structure.
(Geographic Names) |
Attribute Table | GENERAL_COMMENT | | text | General Comment / description |
Attribute Table | POSTED_GROSS_LOAD_LIMIT_T | | text | Structure load limit in tonnes if imposed. |
Attribute Table | POSTED_SPEED_LIMIT_KPH | | text | Speed limit restriction over the structure if imposed |
Attribute Table | BLUE_FLAG_RESTRICTION | | text | The structure may be flagged to be investigated for any special vehicle type or conditions |
Attribute Table | OVERALL_WIDTH | | Double | Overall Width of the structure in metres |
Attribute Table | CV_VOLUME | | text | Annual average daily number of Commercial Vehicle travelling over the structure, expressed as vehicles per day |
Attribute Table | STRUCTURE_LENGTH | | Double | Length of the structure in metres |
Attribute Table | NUMBER_SPANS | | Long Integer | Number of Spans |
Attribute Table | MAXIMUM_SPAN | | Double | Maximum span length in metres |
Attribute Table | MINIMUM_SPAN | | Double | Minimum span length in metres |
Attribute Table | HORIZ_CLEARANCE_ON | | Double | Horizontal Clearance On the Structure in metres |
Attribute Table | HORIZ_CLEARANCE_UNDER | | Double | Horizontal Clearance Under the Structure in metres |
Attribute Table | KERB_TO_KERB_WIDTH | | Double | Kerb to Kerb Width of the structure in metres |
Attribute Table | STRUCTURE_TYPE | | text | Structure Type Code
00 Other
01 Bridge
02 Culvert
03 Concrete Pipe
04 Corrugated Metal
05 Bridge & Culvert
06 Bridge & Concrete Pipe
07 Bridge & Corrugated Metal
08 Bridge & Footbridge
09 Footbridge
10 Culvert & Concrete Pipe
11 Culvert & Corrugated Metal
12 Concrete Pipe & Corrugated Metal
13 Ferry Ramps
14 Gantry
15 Retaining Wall
16 Open Culvert
17 Tunnel
18 Busway Track
19 Culvert, Corrugated Metal & Concrete Pipe
20 HDPE Pipe
21 Noise Wall
22 Service Pit
23 Cattle Grid
24 Arch
25 Arch & Culvert
26 Arch & Bridge
27 Arch & Concrete Pipe
28 Jetty
29 Causeway
30 Wharf
31 Fishing Platform
32 Jetty & Bridge
33 Floodway & Culvert
34 Roundabout
35 Tram Storage Workshop
36 Urban Art
37 Service Chamber
38 Pedestrian Subway - Bridge
39 Pedestrian Subway - Arch
40 Pedestrian Subway - Culvert
41 Pedestrian Subway - Corrugated Metal
42 Observation Deck
43 Viaduct
44 Surge Chamber
45 Inlet Chamber
46 Outlet Chamber
47 Portal
48 Cantilever
49 Butterfly
|
Attribute Table | STRUCTURE_CLASS | | text | Structure overall class
1 Bridge
2 Culvert
3 Ferry Ramps
4 Gantry
5 Retaining Wall
6 Tunnel
7 Busway Track
8 Jetty
9 Ancillary Asset
10 Noise Wall
11 Cattle Grid
12 Subway Bridge
13 Subway Culvert
14 Footbridge |
Attribute Table | MAINTENANCE_RESP | | text | Maintenance Responsibility for the structure
000 DPTI
001 Structure Not Built
002 Private Ownership
003 Road Maintenance
004 Design, Construct & Maintain
005 Bypassed - Not Maintained
006 Designed (Pending Construction)
009 Widen/Lengthen Maintained Structure
180 Bridge Assets
181 DPTI (Marine)
182 DPTI (Marine) & LGA (Joint Insp)
183 DPTI (Marine) & Santos (Joint Insp)
201 DPTI Rail Track & Civil
202 City Pt Adelaide Enfield Council
203 DPTI Road
204 Adelaide City Council
205 City of Playford Council
206 City of Holfast Bay Council
207 City of Marion Council
208 City of Onkaparinga Council
209 Survey
210 Region
872 Adelaide Airport
873 Defence SA
874 National Trust SA
875 DPTI - Rail Track Asset Maintenance
876 PIRSA
877 BHP Billiton
878 ExxonMobil
879 OneSteel
880 Flinders Ports
881 Divested Jetty (LGA)
882 DPTI (Marine Assets)
883 DPTI (Transport Property)
884 Genesee & Wyoming
885 ElectraNet
886 SEWCDB
887 Pichi Richi Railway
888 DPTI (bypassed)
889 ARTC
990 DPTI RAIL
991 SA Water
992 SA Power Networks
993 Dept for Environment & Heritage
994 Steam Ranger
995 Not on Inspection Programme
996 Renewal SA
997 Dry Creek Drainage Authority
998 Little Para River Drainage Authority
999 Demolished
LGA Local Govt. Authority
|