| 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. |
|
|
|
| WATHYDRANTID |
Wathydrantid |
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. |
WatHydrantStatus |
IN SERVICE |
IN SERVICE; OUT OF SERVICE |
| 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. |
|
|
|
| REL_WATMAINID |
Rel Watmainid |
NUMBER |
Input by GIS staff. WATMAINID value of the GIS_DATA.WAT_MAIN layer feature which the hydrant is serviced from. |
|
|
|
| REL_WATSERVICEPIPEID |
Rel Watservicepipeid |
NUMBER |
Input by GIS staff. WATSERVICEPIPEID value of the GIS_DATA.WAT_SERVICE_PIPE layer feature which the hydrant is serviced from. |
|
|
|
| PROPERTY_UNIT_ID |
Property Unit Id |
NUMBER |
Input by GIS staff. Closest feature in the layer GIS_DATA.PROPERTY_UNIT_LOCATION to the water hydrant on the same street using the PROPERTY_UNIT_ID value. |
|
|
|
| ADDRESSID |
Addressid |
NUMBER |
Input by GIS staff. Closest address to the water hydrant along the same street using the fire address id. |
|
|
|
| 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. |
|
|
|
| MAKE |
Make |
VARCHAR2 |
Provided through as-built plan or digital submission. Make of the water hydrant. The default value is 'TO INPUT'. Valid values are 'MCAVITY/CLOW', 'KERR', 'DAIGLE', 'CANADA VALVE', 'AVK', and 'MEULLER'. The value 'UNKNOWN' indicates that the make was not given or is unknown. |
WatHydrantMake |
|
AVK; CANADA VALVE; DAIGLE; KERR; MCAVITY/CLOW; MUELLER CANADA; UNKNOWN |
| MODEL |
Model |
VARCHAR2 |
Provided through as-built plan or digital submission. Model of the water hydrant. The default value is 'TO INPUT'. Valid values are 'M-67', 'DARLING', 'CONCORD', 'CENTURY', 'BRIGADIER', and 'MODERN CENTURIAN'. The value 'UNKNOWN' indicates that the model was not given or is unknown. |
WatHydrantModel |
|
27-80; CENTURY; CONCORD; DARLING; HERITAGE; M-67; MODERN CENTURIAN; NOSTALGIC DRY BARREL; UFFEE; UNKNOWN ...See GIS for a complete list... |
| LOC_MARKER |
Loc Marker |
VARCHAR2 |
Provided by Utilities. Indicates if the hydrant has a flag marker. The default value is 'TO INPUT'. Valid values are 'NO', and 'YES'. The value 'UNKNOWN' indicates that the flag marking indication was not given or is unknown. |
YesNoOnly |
N |
No; Yes |
| CONNECTION_TYPE |
Connection Type |
VARCHAR2 |
Provided through as-built plan or digital submission. Connection type of the hydrant. The default is 'TO INPUT'. Valid values are 'NORM', and 'STORTZ'. The value 'UNKNOWN' indicates that the connection type was not given or is unknown. |
WatHydrantConnection |
|
2 PORTS ONLY; STORTZ PLUS 2 PORTS; UNKNOWN |
| DEADEND_FLUSHING |
Deadend Flushing |
VARCHAR2 |
Provided by Utilities |
WatHydDeadendFlushing |
N |
B - BOTH FALL AND REGULAR; F - FALL; N - NONE; ND - NEW DEVELOPMENT; R - REGULAR |
| INSTALLATION_DATE |
Installation Date |
DATE |
Date the feature was installed |
|
|
|
| WARRANTYDATE |
Warrantydate |
DATE |
Same as INSTALLATION_DATE. |
|
|
|
| ACQUISITION |
Acquisition |
VARCHAR2 |
Input by GIS staff. Identification of how the city received or acquired the feature. If the feature came through the subdivision process it is considered 'DONATED' and if not it is 'PURCHASED' |
PSABAcquisition |
DONATED |
DONATED; PURCHASED |
| 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... |
| 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... |
| BFP_BOX_NUM |
Bfp Box Num |
NUMBER |
|
|
|
|
| CUSTOMER |
Customer |
VARCHAR2 |
|
|
|
|
| REL_WATSERVICEVALVEID |
Rel Watservicevalveid |
NUMBER |
|
|
|
|
| LRT_HAZARD_ZONE |
Lrt Hazard Zone |
VARCHAR2 |
|
LrtHazardZone |
NONE |
BUFFER; NONE; ROAD LRT; ZONE A; ZONE B |
| HYDRANT_FLAG_INSTALLED |
Hydrant flag installed |
VARCHAR2 |
|
YesNoOnly |
N |
No; Yes |
| CLOSEST_ADDRESS |
CLOSEST_ADDRESS |
VARCHAR2 |
|
|
|
|
| STATIC_PRESSURE |
Latest static pressure |
NUMBER |
Updated nightly through data from Cityworks inspections. Static pressure reading from latest inspection where the pressure was measured. |
|
|
|
| STATIC_PRESSURE_DATE |
Latest static pressure date |
TIMESTAMP(6) |
Updated nightly through data from Cityworks inspections. Date of latest inspection where the pressure was measured. |
|
|
|
| INSPECTED_SPRING_1YR |
Inspected in spring in last year |
VARCHAR2 |
Updated nightly through data from Cityworks inspections. Indicates if the hydrant has had a spring operating check inspection. |
YesNoOnly |
N |
No; Yes |
| INSPECTED_FALL_1YR |
Inspected in fall last year |
VARCHAR2 |
Updated nightly through data from Cityworks inspections. Indicates if the hydrant has had a fall operating check inspection. |
YesNoOnly |
N |
No; Yes |
| WATER_IN_BARREL |
WATER_IN_BARREL |
VARCHAR2 |
Updated nightly through data from Cityworks inspections. If water was found the hydrant barrel at last fall operating check inspection which would indicate potential groundwater issues. |
YesNoLong |
|
NO; UNKNOWN; YES |
