View In:   ArcGIS Online Map Viewer

Name: Hydrant

Display Field: ENTNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 531870.79472471
YMin: 4809092.57982861
XMax: 542331.95332471
YMax: 4819833.37282861
Spatial Reference: 26917  (26917)  VCSWkid(115702)  LatestVCSWkid(115702)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [50, 173, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LIFECYCLESTATUS, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: LIFECYCLESTATUS , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...4 more... )
• ASSET_ID ( type: esriFieldTypeInteger, alias: ASSET_ID, editable: true, nullable: true, defaultValue: null, modelName: ASSET_ID )
• HYDRANT_ID ( type: esriFieldTypeDouble, alias: HYDRANT_ID, editable: true, nullable: true, defaultValue: null, modelName: HYDRANT_ID )
• ENTNAME ( type: esriFieldTypeString, alias: ENTNAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ENTNAME )
• SEGMENT_ID ( type: esriFieldTypeInteger, alias: SEGMENT_ID, editable: true, nullable: true, defaultValue: null, modelName: SEGMENT_ID )
• VAIL_ID ( type: esriFieldTypeInteger, alias: VAIL_ID, editable: true, nullable: true, defaultValue: null, modelName: VAIL_ID )
• CIVIC_ADDRESS ( type: esriFieldTypeString, alias: CIVIC_ADDRESS, editable: true, nullable: true, length: 80, defaultValue: null, modelName: ADDRESS )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OWNER , Coded Values: [City of Waterloo: City of Waterloo] , [City of Kitchener: City of Kitchener] , [Region of Waterloo: Region of Waterloo] , ...10 more... )
• ASBUILTNUMBER ( type: esriFieldTypeString, alias: ASBUILTNUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASBUILTNUMBER )
• POSITION_ACCURACY ( type: esriFieldTypeString, alias: POSITION_ACCURACY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POSITION , Coded Values: [Digitized +/- 2m: Digitized +/- 2m] , [Total Station +/- 0.5m: Total Station +/- 0.5m] , [AutoCAD Drawings +/- 1m: AutoCAD Drawings +/- 1m] , ...9 more... )
• MAIN_DIAMETER ( type: esriFieldTypeSmallInteger, alias: MAIN_DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: MAIN_DIAMETER , Coded Values: [25: 25] , [50: 50] , [100: 100] , ...15 more... )
• HYDRANT_MAKE ( type: esriFieldTypeString, alias: HYDRANT_MAKE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: HYDRANT_MAKE , Coded Values: [AMERD: AMERD] , [COREY: COREY] , [CLOW: CLOW] , ...18 more... )
• DISTANCE_HYD_TO_VALVE ( type: esriFieldTypeSingle, alias: DISTANCE_HYD_TO_VALVE, editable: true, nullable: true, defaultValue: null, modelName: DISTANCE_HYD_TO_VALVE )
• NUMBER_OF_OUTLETS ( type: esriFieldTypeSmallInteger, alias: NUMBER_OF_OUTLETS, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_OUTLETS )
• STORTZ_CONNECTION ( type: esriFieldTypeString, alias: STORTZ_CONNECTION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STORTZ_CONNECTION , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• DRAINHOLES_CAPPED ( type: esriFieldTypeString, alias: DRAINHOLES_CAPPED, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DRAINHOLES_CAPPED , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• BARREL_TYPE ( type: esriFieldTypeString, alias: BARREL_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BARREL_TYPE )
• ATLAS_TILE ( type: esriFieldTypeString, alias: ATLAS_TILE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ATLAS_TILE )
• MAINTENANCE_AREA ( type: esriFieldTypeSmallInteger, alias: MAINTENANCE_AREA, editable: true, nullable: true, defaultValue: null, modelName: MAINTENANCE_AREA )
• HYDRANT_FLOW ( type: esriFieldTypeString, alias: HYDRANT_FLOW, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HYDRANT_FLOW )
• COLOUR_CODE ( type: esriFieldTypeString, alias: COLOUR_CODE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COLOUR_CODE , Coded Values: [Blue: Blue] , [Green: Green] , [Orange: Orange] , ...1 more... )
• PRESSURE_ZONE ( type: esriFieldTypeString, alias: PRESSURE_ZONE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRESSURE_ZONE )
• LOCATION_DESCRIPTION ( type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, editable: true, nullable: true, length: 80, defaultValue: null, modelName: LOCATION_DESCRIPTION )
• ASSUMPTIONSTATUS ( type: esriFieldTypeString, alias: ASSUMPTIONSTATUS, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ASSUMPTIONSTATUS , Coded Values: [Assumed by City of Waterloo: Assumed by City of Waterloo] , [NA: NA] , [On Maintenance: On Maintenance] )
• STARTOFMAINTDATE ( type: esriFieldTypeDate, alias: STARTOFMAINTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: STARTOFMAINTDATE )
• FINALACCEPTANCEDATE ( type: esriFieldTypeDate, alias: FINALACCEPTANCEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FINALACCEPTANCEDATE )
• REMOVED_DATE ( type: esriFieldTypeDate, alias: REMOVED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REMOVED_DATE )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 200, defaultValue: null, modelName: NOTES )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, editable: true, nullable: true, defaultValue: null, modelName: ANCILLARYROLE , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• CREATE_DATE ( type: esriFieldTypeDate, alias: CREATE_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATE_DATE )
• CREATE_USER ( type: esriFieldTypeString, alias: CREATE_USER, editable: false, nullable: true, length: 16, defaultValue: null, modelName: CREATE_USER )
• UPDATE_DATE ( type: esriFieldTypeDate, alias: UPDATE_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: UPDATE_DATE )
• UPDATE_USER ( type: esriFieldTypeString, alias: UPDATE_USER, editable: false, nullable: true, length: 16, defaultValue: null, modelName: UPDATE_USER )
• ACTIVITYID ( type: esriFieldTypeString, alias: ACTIVITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACTIVITYID )
• LASTACTIVITY ( type: esriFieldTypeString, alias: LASTACTIVITY, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LASTACTIVITY , Coded Values: [INST: Installation] , [UPDT: Update Info] , [INSP: Inspection] , ...5 more... )
• DATESTAMP ( type: esriFieldTypeDate, alias: DATESTAMP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESTAMP )
• OPTIME ( type: esriFieldTypeString, alias: OPTIME, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OPTIME )
• COMPUTERNAME ( type: esriFieldTypeString, alias: COMPUTERNAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COMPUTERNAME )
• OPERATEDBY ( type: esriFieldTypeString, alias: OPERATEDBY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OPERATEDBY )
• OPERATIONALSTATUS ( type: esriFieldTypeString, alias: OPERATIONALSTATUS, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OPERATIONALSTATUS , Coded Values: [OK: OK] , [NRPR: Needs Repair] , [INOP: Inoperable] , ...3 more... )
• FLOWGPM ( type: esriFieldTypeSmallInteger, alias: FLOWGPM, editable: true, nullable: true, defaultValue: null, modelName: FLOWGPM )
• FLOW20 ( type: esriFieldTypeSmallInteger, alias: FLOW20, editable: true, nullable: true, defaultValue: null, modelName: FLOW20 )
• STATICPSI ( type: esriFieldTypeSmallInteger, alias: STATICPSI, editable: true, nullable: true, defaultValue: null, modelName: STATICPSI )
• RESIDPSI ( type: esriFieldTypeSmallInteger, alias: RESIDPSI, editable: true, nullable: true, defaultValue: null, modelName: RESIDPSI )
• PITOT ( type: esriFieldTypeSmallInteger, alias: PITOT, editable: true, nullable: true, defaultValue: null, modelName: PITOT )
• FLOWMINS ( type: esriFieldTypeString, alias: FLOWMINS, editable: true, nullable: true, length: 7, defaultValue: null, modelName: FLOWMINS )
• GALUSED ( type: esriFieldTypeString, alias: GALUSED, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GALUSED )
• ISOVALVE ( type: esriFieldTypeString, alias: ISOVALVE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ISOVALVE )
• OPERATIONCOMMENTS ( type: esriFieldTypeString, alias: OPERATIONCOMMENTS, editable: true, nullable: true, length: 200, defaultValue: null, modelName: OPERATIONCOMMENTS , Coded Values: [BranchValveNS: Branch valve needs service] , [Broken Barrel: Broken Barrel] , [Broken Stem: Broken Stem] , ...6 more... )
• HYDRANTREPAIRS ( type: esriFieldTypeString, alias: HYDRANTREPAIRS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HYDRANTREPAIRS , Coded Values: [Yes: Yes] , [No: No] )
• PITOT2 ( type: esriFieldTypeSmallInteger, alias: PITOT2, editable: true, nullable: true, defaultValue: null, modelName: PITOT2 )
• FLOWGPM2 ( type: esriFieldTypeSmallInteger, alias: FLOWGPM2, editable: true, nullable: true, defaultValue: null, modelName: FLOWGPM2 )
• RESIDUAL_HYDRANT ( type: esriFieldTypeString, alias: RESIDUAL_HYDRANT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RESIDUAL_HYDRANT )
• LINKEDDOCUMENTS ( type: esriFieldTypeString, alias: LINKEDDOCUMENTS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LINKEDDOCUMENTS )
• REPAIRS_NEEDED ( type: esriFieldTypeString, alias: REPAIRS_NEEDED, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REPAIRS_NEEDED , Coded Values: [Major: Major] , [Minor: Minor] )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• HYDRANT_DRAINAGE ( type: esriFieldTypeString, alias: HYDRANT_DRAINAGE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: HYDRANT_DRAINAGE , Coded Values: [Yes: Yes] , [No: No] )
• HYDRANT_OPERATION_NUT ( type: esriFieldTypeString, alias: HYDRANT_OPERATION_NUT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: HYDRANT_OPERATION_NUT , Coded Values: [needs service: needs service] , [good condition: good condition] )
• HYDRANT_PAINTING ( type: esriFieldTypeString, alias: HYDRANT_PAINTING, editable: true, nullable: true, length: 3, defaultValue: null, modelName: HYDRANT_PAINTING , Coded Values: [Yes: Yes] , [No: No] )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: Hydrant
  Description:
  Prototype:
  HYDRANT_PAINTING: null
  HYDRANT_OPERATION_NUT: null
  LIFECYCLESTATUS: Active
  ASSET_ID: null
  HYDRANT_ID: null
  ENTNAME: null
  SEGMENT_ID: null
  VAIL_ID: null
  CIVIC_ADDRESS: null
  OWNER: null
  ASBUILTNUMBER: null
  POSITION_ACCURACY: null
  MAIN_DIAMETER: null
  HYDRANT_MAKE: null
  DISTANCE_HYD_TO_VALVE: null
  NUMBER_OF_OUTLETS: null
  STORTZ_CONNECTION: null
  DRAINHOLES_CAPPED: null
  BARREL_TYPE: null
  ATLAS_TILE: null
  MAINTENANCE_AREA: null
  HYDRANT_FLOW: null
  COLOUR_CODE: null
  PRESSURE_ZONE: null
  LOCATION_DESCRIPTION: null
  ASSUMPTIONSTATUS: null
  STARTOFMAINTDATE: null
  FINALACCEPTANCEDATE: null
  REMOVED_DATE: null
  NOTES: null
  ANCILLARYROLE: null
  ENABLED: 1
  HYDRANT_DRAINAGE: null
  INSTALLDATE: null
  REPAIRS_NEEDED: null
  LINKEDDOCUMENTS: null
  ACTIVITYID: null
  LASTACTIVITY: null
  DATESTAMP: null
  OPTIME: null
  COMPUTERNAME: null
  OPERATEDBY: null
  OPERATIONALSTATUS: null
  FLOWGPM: null
  FLOW20: null
  STATICPSI: null
  RESIDPSI: null
  PITOT: null
  FLOWMINS: null
  GALUSED: null
  ISOVALVE: null
  OPERATIONCOMMENTS: null
  HYDRANTREPAIRS: null
  PITOT2: null
  FLOWGPM2: null
  RESIDUAL_HYDRANT: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CREATE_DATE
• Creator Field: CREATE_USER
• Edit Date Field: UPDATE_DATE
• Editor Field: UPDATE_USER

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata