Table | Name | Field Alias | Data Type | Description |
Point Attribute Table | SITE_SEQ | | Number | Site identifier |
Point Attribute Table | ROAD_NO | | Character | Unique identifier as defined by DPTI, for Roads |
Point Attribute Table | SIDE_OF_ROAD | | Character | Feature location in relation to the road direction, increasing road distanceSELECT 1 FROM DUAL;
Left Side, Right Side, Both Sides, Median |
Point Attribute Table | START_RRD | | Number | Driven length in kilometres from the start of the road to the start location of the feature or section of road |
Point Attribute Table | END_RRD | | Number | Driven length in kilometres from the start of the road to the end location of the feature or section of road |
Point Attribute Table | LOCATION_DESC | | Character | Description/Rating/Significance of the site |
Point Attribute Table | SIGNIF_CATEGORY | | Character | Category of feature typesSELECT 1 FROM DUAL;
Built/Cultural, Natural |
Point Attribute Table | MARKER_INSTALLED | | Character | Whether a marker defining the site is installedSELECT 1 FROM DUAL;
Yes, marker is presentSELECT 1 FROM DUAL;
No, no marker is presentSELECT 1 FROM DUAL;
N/A, not applicable |
Point Attribute Table | OFFSET | | Number | Offset from the road for cartographic mapping. Positive, Left offset. Negative, Right offset |
Point Attribute Table | ABORIGINAL_SITE | | Character | Whether the site is of Aboriginal Significance. Y-Yes. N-No |