| 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. |
|
|
|
| GASSERVICEVALVEID |
Gasservicevalveid |
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. |
|
|
|
| ROTATION |
Rotation |
NUMBER |
|
|
|
|
| REL_GASSERVICEPIPEID |
Rel Gasservicepipeid |
NUMBER |
|
|
|
|
| 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. |
|
|
|
| SOURCE_DATE |
Source Date |
DATE |
GIS maintained field. Date of the source document or information. |
|
|
|
| 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. |
|
|
|
| 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. |
|
|
|
| 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 |
|
|
|
|
| TYPE |
Type |
VARCHAR2 |
|
GasValveType |
|
BALL; GEARED; PLUG; UNKNOWN |
| SUBTYPE |
Subtype |
VARCHAR2 |
|
GasValveSubtype |
WITH STOP |
NO STOP; NO STOPS CLOSED; NO STOPS OPEN; UNKNOWN; WITH STOP |
| MANUFACTURER |
Manufacturer |
VARCHAR2 |
|
GasServiceValveManufacturer |
POLYVALVE LLC |
BROAN; CRANE; GROVE; MUELLER; NEWMAN; NORDSTROM; POLYVALVE LLC; ROCKWELL; RuB; UNKNOWN ...See GIS for a complete list... |
| MODEL |
Model |
VARCHAR2 |
|
GasServiceValveModel |
|
3E; D2513; H11175; H11405; H11406; H11435; H11445; H17501; S80; UNKNOWN ...See GIS for a complete list... |
| MATERIAL |
Material |
VARCHAR2 |
|
GasServiceValveMaterial |
PLASTIC |
BRASS; PLASTIC; STEEL; UNKNOWN |
| INSTALLATION_DATE |
Installation Date |
DATE |
Date the feature was installed |
|
|
|
| VALVE_LEFT |
Valve Left |
VARCHAR2 |
|
GISOpenClosed |
U |
C - CLOSED; O - OPEN; U - UNKNOWN |
| VALVE_KEY |
Valve Key |
VARCHAR2 |
|
GasValveKey |
U |
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 |
| BOX_TYPE |
Box Type |
VARCHAR2 |
|
GasValveBoxType |
|
334; 445; 558; 668; ABOVE GRADE; BURIED; CHAMBER; KG3; STEEL; UNKNOWN |
| HARD_TO_OPERATE |
Hard To Operate |
VARCHAR2 |
|
YesNo |
N |
N - NO; U - UNKNOWN; Y - YES |
| KU_NOTES |
Ku Notes |
VARCHAR2 |
|
|
|
|
| TURNS |
Turns |
NUMBER |
|
|
|
|
| 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_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 |
0; 1; 2; 3; 4 |
