| 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. |
|
|
|
| WATSERVICEVALVEID |
Watservicevalveid |
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. |
GISStatusAbandoned |
ACTIVE |
ABANDONED; ACTIVE; 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. |
|
|
|
| ROTATION |
Rotation |
NUMBER |
|
|
|
|
| REL_WATSERVICEPIPEID |
Rel Watservicepipeid |
NUMBER |
|
|
|
|
| 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. |
|
|
|
| MAPPED_FROM |
Mapped From |
VARCHAR2 |
|
WatServPipeMappedFrom |
|
CORRECT LOC PENDING; ESTIMATED LOCATION; FROM CONSTRUCTION; FROM LOCATE; UNKNOWN |
| TYPE |
Type |
VARCHAR2 |
|
WatServValveType |
|
CUT-IN; HYDRANT; STANDARD; TAPPING; UNKNOWN |
| TURNS |
Turns |
NUMBER |
|
|
|
|
| KU_NOTES |
Ku Notes |
VARCHAR2 |
Input by Utilities staff. Open text field for notes. |
|
|
|
| ENGINEERING_NOTES |
Engineering Notes |
VARCHAR2 |
Input by Engineering staff. Open text field for notes. |
|
|
|
| CONSULTANT |
Consultant |
VARCHAR2 |
|
|
|
|
| GENERAL_GRID |
General Grid |
VARCHAR2 |
|
GridStandardID |
|
277; 563; 582; 583; 584; 585; 586; 587; 607; 608 ...See GIS for a complete list... |
| REL_CLEANING_AREA |
Rel Cleaning Area |
VARCHAR2 |
|
WatMainCleanMainArea |
0 |
0; 1; 2; 3; 4; 5; 6 |
| REL_CLEANING_SUBAREA |
Rel Cleaning Subarea |
VARCHAR2 |
|
WatMainCleanSubArea |
0 |
0; 41; 42; 43; 44; 45; 46; 47; 48; 49 ...See GIS for a complete list... |
| LRT_HAZARD_ZONE |
Lrt Hazard Zone |
VARCHAR2 |
|
LrtHazardZone |
NONE |
BUFFER; NONE; ROAD LRT; ZONE A; ZONE B |
| LOCATION |
Location |
VARCHAR2 |
Open text field that describes the location of the feature in more detail. |
|
|
|
| DIAMETER |
Diameter in mm |
NUMBER |
|
WatServiceDiameter |
0 |
0; 100; 150; 200; 250; 300; 32; 38; 50; 75 ...See GIS for a complete list... |
| INSTALLATION_DATE |
INSTALLATION_DATE |
TIMESTAMP(6) |
Date the feature was installed |
|
|
|
| BONNET_BOLTS_REPLACED |
BONNET_BOLTS_REPLACED |
VARCHAR2 |
|
YesNoOnly |
N |
No; Yes |
| PACKING_BOLTS_REPLACED |
PACKING_BOLTS_REPLACED |
VARCHAR2 |
|
YesNoOnly |
N |
No; Yes |
