| OBJECTID |
OBJECTID |
NUMBER |
ESRI system maintained integer field used to uniquely identify rows in tables in a geodatabase. Note that OBJECTIID values change upon export or import of the data and should not be used as a primary field for searching or identifying records. |
|
|
|
| RAILSEGMENTID |
Railsegmentid |
NUMBER |
Database maintained field that permanently assigns a unique value for each record. This ID value should be the one referred to when identifying a record. |
|
|
|
| CATEGORY |
Category |
VARCHAR2 |
|
|
|
|
| SUBCATEGORY |
Subcategory |
VARCHAR2 |
|
|
|
|
| STATUS |
Status |
VARCHAR2 |
Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values. |
|
|
|
| STATUS_DATE |
Status Date |
TIMESTAMP(6) |
Database maintained field. Updates to the current date/time when the STATUS field value is changed. |
|
|
|
| SOURCE |
Source |
VARCHAR2 |
GIS maintained field. Source EDRA (Electronic Document Registration Application) document number, or name of department or specific staff member that the information came from. |
|
|
|
| SOURCE_DATE |
Source Date |
TIMESTAMP(6) |
GIS maintained field. Date of the source document or information. |
|
|
|
| CREATE_BY |
Create By |
VARCHAR2 |
Database maintained field. Updates to the user name that created the feature. Update takes place when the feature is created. |
|
|
|
| CREATE_DATE |
Create Date |
TIMESTAMP(6) |
Database maintained field. Updates to the current data/time. Update takes place when the feature is created. |
|
|
|
| UPDATE_BY |
Update By |
VARCHAR2 |
Database maintained field. Updates to the user name that most recently updated either an attribute or the geometry of the feature. Update takes place when the feature is created and/or changed. |
|
|
|
| UPDATE_DATE |
Update Date |
TIMESTAMP(6) |
Database maintained field. Updates to the current data/time when an attribute or the geometry of the feature is changed. Update takes place when the feature is created and/or changed. |
|
|
|
| TAG1 |
Tag1 |
VARCHAR2 |
Temporary location to store short term data for mapping purposes only. |
|
|
|
| TAG2 |
Tag2 |
NUMBER |
Temporary location to store short term data for mapping purposes only. |
|
|
|
| TAG3 |
Tag3 |
NUMBER |
Temporary location to store short term data for mapping purposes only. |
|
|
|
| OWNER |
Owner |
VARCHAR2 |
|
|
|
|
| OPERATOR |
Operator |
VARCHAR2 |
|
|
|
|
| TRACK_USER |
Track User |
VARCHAR2 |
|
|
|
|
| TRACK_NAME |
Track Name |
VARCHAR2 |
|
|
|
|
| TRACK_LOCATION |
Track Location |
VARCHAR2 |
|
|
|
|
| TRAVEL_DIRECTION |
Travel Direction |
VARCHAR2 |
|
|
|
|
| ONEWAY |
Oneway |
VARCHAR2 |
|
|
|
|
| TYPE |
Type |
VARCHAR2 |
|
|
|
|
| ELECTRICAL |
Electrical |
VARCHAR2 |
|
|
|
|
| PRIMARY_CONTACT |
Primary Contact |
VARCHAR2 |
|
|
|
|
| LABEL |
Label |
VARCHAR2 |
|
|
|
|
| SHAPE |
SHAPE |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
| CRITICAL_INFRASTRUCTURE |
CRITICAL_INFRASTRUCTURE |
VARCHAR2 |
|
RoadCriticalInfrastructure |
|
Evacuation Centres Road; Exit Road; Freeway; Major Internal; Non-Critical; Railway |