| 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. |
|
|
|
| GASVALVEID |
Gasvalveid |
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_DATE |
Source Date |
DATE |
GIS maintained field. Date of the source document or information. |
|
|
|
| REL_GASMAINID |
Rel Gasmainid |
NUMBER |
Input by GIS staff. GASMAINID value of the gas main feature in the GIS_DATA.GAS_MAIN layer that the valve is associated with. |
|
|
|
| ROTATION |
Rotation |
NUMBER |
Input by GIS staff input. Field that rotates the gas valve so that its symbol is in line with the associated gas main. 0 is north, 90 is east, 180 is south, 270 is west. |
|
|
|
| SHAPE |
SHAPE |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
| 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. |
|
|
|
| VALVE_NUM |
Valve Num |
VARCHAR2 |
Provided through as-built plan or digital submission. Unique value assigned by Utility staff for the valve. Value must begin with a uppercase V. A value must be entered. |
|
|
|
| TYPE |
Type |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the type of gas valve. The default value is 'TO INPUT'. Valid values are 'BALL', 'GEARED', 'PLUG'. The value 'UNKNOWN' indicates that the subtype was not given or is unknown. |
GasValveType |
|
BALL; GEARED; PLUG; UNKNOWN |
| SUBTYPE |
Subtype |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates if the gas valve has a stop or not. The default value is 'TO INPUT'. Valid values are 'NO STOP', 'WITH STOP'. The value 'UNKNOWN' indicates that the subtype of the valve was not given or is unknown. |
GasValveSubtype |
WITH STOP |
NO STOP; NO STOPS CLOSED; NO STOPS OPEN; UNKNOWN; WITH STOP |
| MANUFACTURER |
Manufacturer |
VARCHAR2 |
Provided through as-built plan or digital submission. Manufacturer of the gas valve. The default value is 'TO INPUT'. Valid values are 'BROAN', 'CENTRAL', 'GROVE', 'MUELLER', 'NORDSTROM', 'POLYVALVE LLC', 'ROCKWELL'. The value 'UNKNOWN' indicates that the manufacturer was not given or is unknown. |
GasValveManufacturer |
POLYVALVE LLC |
BOEHMER; BROAN; GROVE; MUELLER; NEWMAN; NORDSTROM; POLYVALVE LLC; ROCKWELL; UNKNOWN; WARREN ...See GIS for a complete list... |
| MODEL |
Model |
VARCHAR2 |
Provided through as-built plan or digital submission. Model of the gas valve. The default value is 'TO INPUT'. Valid values are '114', '115', '143', '165', '169', '185', '200', '305', '1942 1/2', '1943 1/2', '2025', '2045', '4187 1/2', '4235', '4285', '4287', '82111', '82210', '82211', '84111', '84210', '84211', '12BMW285KFPTRVG14S', '4BMW275', '8BMW285KFPCBVG14S', 'H11405', 'H11406', 'H11435', 'H11445'. The value 'UNKNOWN' indicates that the model was not given or is unknown. |
GasValveModel |
|
3E; 99ELK1119902-01; A350LF2; H11405; H11406; H11435; H11445; H17501; P355NL2; UNKNOWN ...See GIS for a complete list... |
| INSTALLATION_DATE |
Installation Date |
DATE |
Date the feature was installed |
|
|
|
| MATERIAL |
Material |
VARCHAR2 |
Provided through as-built plan or digital submission. Material of the gas valve. 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; STEEL; UNKNOWN |
| VALVE_KEY |
Valve Key |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the type of key to activate the gas valve. Values are codes. The following uses the key 'CODE' ('DESCRIPTION'). The default value is 'X' ('X - TO INPUT'). Valid values are 'L' ('L - LUBRICATED PLUG VALVE REQUIRING 2" SQ. KEY (4" NORD OR LARGER)', 'LO' ('LO - LONG KEY REQUIRED FOR LUBRICATED PLUG VALVE'), 'M' ('M - PLUG VALVE REQUIRING SLOTTED MUELLER KEY (2" MUELLER OR SMALLER)'), 'PL' ('PL - PLASTIC VALVE REQUIRING 2" SQ. KEY (2" OR 4" POLYVALVE)'), 'PM' ('PM - PLASTIC VALVE REQUIRING SLOTTED MUELLER KEY (1" OR 1/4" POLYVALVE)'). The value 'U' ('U - UNKNOWN') indicates that the type was not given or is unknown. 'U' ('U - UNKNOWN')' is the value GIS staff enter. |
GasValveKey |
|
F - FORK KEY; HW - HANDWHEEL; L - LUBRICATED PLUG VALVE REQUIRING 2"" SQ. KEY (4"" NORD OR LARGER); LO - LONG KEY REQUIRED FOR LUBRICATED PLUG VALVE; M - PLUG VALVE REQUIRING SLOTTED MUELLER KEY (2"" MUELLER OR SMALLER); PL - PLASTIC VALVE REQUIRING 2"" SQ. KEY (2"" OR 4"" POLYVALVE); PM - PLASTIC VALVE REQUIRING SLOTTED MUELLER KEY (1"" OR 1/4"" POLYVALVE); U - UNKNOWN; W - WRENCH |
| VALVE_LEFT |
Valve Left |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the position of the gas valve. Values are codes. The following uses the key 'CODE' ('DESCRIPTION'). The default value is 'X' ('X - TO INPUT'). Valid values are 'C' ('C - CLOSED'), 'O' ('O - OPEN'). The value 'U' ('U - UNKNOWN') indicates that the position was not given or is unknown. 'U' ('U - UNKNOWN')' is the value GIS staff enter. |
GISOpenClosed |
|
C - CLOSED; O - OPEN; U - UNKNOWN |
| BOX_TYPE |
Box Type |
VARCHAR2 |
Provided through as-built plan or digital submission. Box type of the gas valve. The default value is 'TO INPUT'. Valid values are '334' , '445', '558', '668', 'BURIED', 'CHAMBER', 'KG3'. The value 'UNKNOWN' indicates that the box type was not given or is unknown. |
GasValveBoxType |
|
334; 445; 558; 668; ABOVE GRADE; BURIED; CHAMBER; KG3; STEEL; UNKNOWN |
| HARD_TO_OPERATE |
Hard To Operate |
VARCHAR2 |
Provided through as-built plan or digital submission. Maintained by Utility staff. Indicates if the gas valve is hard to operate. 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 difficulty of turnning the valve was not given or is unknown. 'U' ('U - UNKNOWN') is the value GIS staff enter. |
YesNo |
N |
N - NO; U - UNKNOWN; Y - YES |
| CROSS_STREET |
Cross Street |
VARCHAR2 |
Provided through as-built plan or digital submission. The nearest crossing street. |
|
|
|
| KU_NOTES |
Ku Notes |
VARCHAR2 |
Input by Utility staff. Open text field for notes. |
|
|
|
| TURNS |
Turns |
NUMBER |
Input by Utility staff. Indicates the number of turns to activate or deactivate the gas valve. The default value is <null>. |
|
|
|
| GENERAL_GRID |
General Grid |
VARCHAR2 |
|
GridStandardID |
|
277; 563; 582; 583; 584; 585; 586; 587; 607; 608 ...See GIS for a complete list... |
| QUARTER_GRID |
Quarter Grid |
VARCHAR2 |
|
GridQuarteredID |
|
277-A; 407-C; 586-D; 587-A; 607-A; 607-B; 607-C; 607-D; 608-A; 608-B ...See GIS for a complete list... |
| LRT_VALVE |
Lrt Valve |
VARCHAR2 |
|
YesNo |
N |
N - NO; U - UNKNOWN; Y - YES |
| LUBRICATE_VALVE |
Lubricate Valve |
VARCHAR2 |
|
YesNo |
N |
N - NO; U - UNKNOWN; Y - YES |
| EMERGENCY_VALVE |
Emergency Valve |
VARCHAR2 |
|
YesNo |
N |
N - NO; U - UNKNOWN; Y - YES |
| LRT_HAZARD_ZONE |
Lrt Hazard Zone |
VARCHAR2 |
|
LrtHazardZone |
NONE |
BUFFER; NONE; ROAD LRT; ZONE A; ZONE B |
| VALVE_SIZE |
Valve Size |
NUMBER |
|
GasMainSize |
0 |
0; 100; 150; 200; 250; 300; 38; 400; 50; 75 ...See GIS for a complete list... |
| OPERATING_CHECK_AREA |
Operating check area |
VARCHAR2 |
|
GasValveOperatingCheckArea |
|
0; 1; 2; 3; 4 |
