| 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. |
|
|
|
| GASMAINID |
Gasmainid |
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. |
|
|
|
| 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 |
DATE |
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 |
DATE |
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. |
|
|
|
| STATUS |
Status |
VARCHAR2 |
Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values. |
GasStatus |
ACTIVE |
ACTIVE; DEACTIVATED; PLANNED; UNKNOWN |
| STATUS_DATE |
Status Date |
DATE |
Database maintained field. Updates to the current date/time when the STATUS field value is changed. |
|
|
|
| SOURCE |
Source |
NUMBER |
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 |
DATE |
GIS maintained field. Date of the source document or information. |
|
|
|
| PARENTID |
Parentid |
NUMBER |
Input by GIS staff. Used when an an existing gas main is split for any number of reasons. Usually this occurs when another, typically new, pipe tees into it. The existing record is split into 2 or more individual records. The longest single existing record retains its GASMAINID value and no value is entered into PARENTID, however for each of the remaining shorter existing records the original GASMAINID value is copied into the PARENTID field, their GASMAINID values are deleted and the database generates new GASMAINIDs for the 2 or more new shorter records. This is done so that information, such as work orders, could be linked back to the records that have new GASMAINID values. |
|
|
|
| ROADSEGMENTID |
Roadsegmentid |
NUMBER |
Input by GIS staff. ROADSEGMENTID of the GIS_DATA.ROADSEGMENT layer feature that the majority of the gas main follows . A value of -1 indicates that the feature does not follow a road. Roadsegments must have a CATEGORY value of 'HIGHWAY' , 'RAMP' , 'ROAD' , or 'ROUNDABOUT' and a STATUS value of 'ACTIVE' , 'PLANNED', or 'REGISTERED'. |
|
|
|
| MAP_LABEL |
Map Label |
VARCHAR2 |
Database maintained field. Combines the GIS length, and the DIAMETER and MATERIAL field values. |
|
|
|
| TAG1 |
Tag1 |
VARCHAR2 |
Temporary location to store short term data for mapping purposes only. |
|
|
|
| SHAPE |
SHAPE |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
| MATERIAL |
Material |
VARCHAR2 |
Provided through as-built plan or digital submission. Material of the gas main. The default value is 'TO INPUT'. Valid values are 'PLASTIC', 'STEEL'. The value 'UNKNOWN' indicates that the material was not given or is unknown. |
GasPipeMaterial |
PLASTIC |
PLASTIC; STEEL; UNKNOWN |
| SUB_MATERIAL |
Sub Material |
VARCHAR2 |
Provided through as-built plan or digital submission. Submaterial of the gas main. The default value is 'TO INPUT'. Valid values are 'ALDYL A', 'ALDYL HD', 'BARE PIPE', 'EPOXY', 'PE 100', 'RELINE', 'TAR COAT', TR418', 'YELLOW JACKET'. The value 'UNKNOWN' indicates that the submaterial was not given or is unknown. |
GasPipeSubmaterial |
|
3M SK 6233 3M SK 6352; ALDYL A; EPOXY; PE 100; PE2406/2708; TAR COAT; TR418; UNI-MODAL PE2708; UNKNOWN; YELLOW JACKET ...See GIS for a complete list... |
| INSTALLATION_DATE |
Installation Date |
DATE |
Date the feature was installed |
|
|
|
| HIGH_PRESSURE |
High Pressure |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates if the gas main is a high pressure transmission main. A distribution pressure main is given the value 'N'. Values are codes. The following uses the key 'CODE' ('DESCRIPTION'). The default value is 'X' ('X - TO INPUT'). Valid values are 'N' ('N - NO'), 'Y' ('Y - YES'). The value 'U' ('U - UNKNOWN') indicates that the type of pressure was not given or is unknown. |
YesNo |
N |
N - NO; U - UNKNOWN; Y - YES |
| TRACER_WIRE_COLOUR |
Tracer Wire Colour |
VARCHAR2 |
Provided through as-built plan or digital submission. Tracer wire colour of the gas main. The default value is 'TO INPUT'. Valid values are 'BLUE', 'WHITE', 'YELLOW'. The value 'UNKNOWN' indicates that the tracer wire colour was not given or known. |
GasTracerWireColour |
|
BLACK; BLUE; RED; UNKNOWN; WHITE; YELLOW |
| EASEMENT |
Easement |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates if the gas main is within an easement and if so the type of easement the main is within. The default value is 'TO INPUT'. Valid values are 'HYDRO RIGHT OF WAY', 'NO EASEMENT', 'PRIVATE PROPERTY', 'RAILWAY'. The value 'UNKNOWN' indicates that the easement was not given or is unknown. |
GasMainEasement |
NO EASEMENT |
HYDRO RIGHT OF WAY; NO EASEMENT; PRIVATE PROPERTY; RAILWAY |
| KU_NOTES |
Ku Notes |
VARCHAR2 |
Input by Utility staff. Open text field for notes. |
|
|
|
| BRIDGE_MAIN |
Bridge Main |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates if the gas main uses a bridge to pass over other features. |
YesNo |
N |
N - NO; U - UNKNOWN; Y - YES |
| BRIDGE_DETAILS |
Bridge Details |
VARCHAR2 |
Provided by Gas Utilities staff. Additional details concerning gas mains that use a bridge to pass over other features. |
|
|
|
| SDR |
Sdr |
VARCHAR2 |
Provided by Gas Utilities staff. SDR stands for standard dimension ratio and is a measurement and method often used by pipe manufacturers to rate the working pressure capacity of a pipe. |
GasSDR |
|
10; 11; 13.5; N/A; UNKNOWN |
| DIAMETER |
Diameter |
NUMBER |
Provided through as-built plan or digital submission. The diameter in milimetres of the gas main. |
GasMainSize |
0 |
0; 100; 150; 200; 250; 300; 38; 400; 50; 75 ...See GIS for a complete list... |
