View In:   ArcGIS Online Map Viewer

Name: Water Hydrants

Display Field: ASSET_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: c9c56bb432e2423ab2b00d3c85714c62

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 8000.0

Max Scale: 0.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: -1.2687434635274038E7
YMin: 6600072.308413415
XMax: -1.2620048672979906E7
YMax: 6633377.735909652
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• ASSET_ID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSET_ID )
• HYD_NUMBER ( type: esriFieldTypeString, alias: Hydrant Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HYD_NUMBER )
• DIAMETER ( type: esriFieldTypeDouble, alias: Pipe Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• FUNCTION_ ( type: esriFieldTypeString, alias: Function, editable: true, nullable: true, length: 254, defaultValue: FIRE SUPPRESSION, modelName: FUNCTION_ , Coded Values: [FIRE SUPPRESSION: FIRE SUPPRESSION] )
• TYPE ( type: esriFieldTypeString, alias: Hydrant Type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TYPE )
• OWN_TYPE ( type: esriFieldTypeString, alias: Owner Type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: OWN_TYPE )
• INSTALL_YR ( type: esriFieldTypeDouble, alias: Install Year, editable: true, nullable: true, defaultValue: 2023, modelName: INSTALL_YR )
• ADD_NUMBER ( type: esriFieldTypeString, alias: Address Number, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ADD_NUMBER )
• ADD_STREET ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ADD_STREET )
• ADDRESS ( type: esriFieldTypeString, alias: Full Address, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ADDRESS )
• LOCATION ( type: esriFieldTypeString, alias: Location (Specific), editable: true, nullable: true, length: 254, defaultValue: null, modelName: LOCATION )
• COMMUNITY ( type: esriFieldTypeString, alias: Community, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMUNITY )
• ROAD_PRJCT ( type: esriFieldTypeString, alias: Road Project Association, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ROAD_PRJCT )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• MAKE_MODEL ( type: esriFieldTypeString, alias: Make/Model, editable: true, nullable: true, length: 254, defaultValue: null, modelName: MAKE_MODEL )
• PUMPTHREAD ( type: esriFieldTypeDouble, alias: Pump Thread, editable: true, nullable: true, defaultValue: null, modelName: PUMPTHREAD )
• SIDETHREAD ( type: esriFieldTypeDouble, alias: Side Thread, editable: true, nullable: true, defaultValue: null, modelName: SIDETHREAD )
• VALVE_TYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: VALVE_TYPE )
• DRAIN_TYPE ( type: esriFieldTypeString, alias: Drain Type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: DRAIN_TYPE )
• STATIC_PR ( type: esriFieldTypeDouble, alias: Static Pressue, editable: true, nullable: true, defaultValue: null, modelName: STATIC_PR )
• RESIDUA_PR ( type: esriFieldTypeDouble, alias: Residual Pressure, editable: true, nullable: true, defaultValue: null, modelName: RESIDUA_PR )
• FLOW_RATE ( type: esriFieldTypeDouble, alias: Flow Rate, editable: true, nullable: true, defaultValue: null, modelName: FLOW_RATE )
• PRESSURE ( type: esriFieldTypeDouble, alias: Pressure (PSI), editable: true, nullable: true, defaultValue: null, modelName: PRESSURE )
• OBSTRUCTED ( type: esriFieldTypeString, alias: Obstructed, editable: true, nullable: true, length: 254, defaultValue: null, modelName: OBSTRUCTED )
• BARREL_DIA ( type: esriFieldTypeDouble, alias: Barrel Diameter, editable: true, nullable: true, defaultValue: null, modelName: BARREL_DIA )
• SERIALNUM ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SERIALNUM )
• LIFECYCYCL ( type: esriFieldTypeString, alias: Life Cycle, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LIFECYCYCL )
• CAP_M3_H ( type: esriFieldTypeDouble, alias: Capacity (m3/hr), editable: true, nullable: true, defaultValue: null, modelName: CAP_M3_H )
• CAP_M3_D ( type: esriFieldTypeDouble, alias: Capacity (m3/day), editable: true, nullable: true, defaultValue: null, modelName: CAP_M3_D )
• USEFULLIFE ( type: esriFieldTypeDouble, alias: Useful Life (Years), editable: true, nullable: true, defaultValue: null, modelName: USEFULLIFE )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 254, defaultValue: null, modelName: COMMENT )
• SERVICE ( type: esriFieldTypeString, alias: Service Type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SERVICE )
• LastInspec ( type: esriFieldTypeDouble, alias: LastInspec, editable: true, nullable: true, defaultValue: null, modelName: LastInspec )
• OUTLETTYPE ( type: esriFieldTypeString, alias: Outlet Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OUTLETTYPE )
• WRANTYDATE ( type: esriFieldTypeDate, alias: WRANTYDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WRANTYDATE )
• CONDITION ( type: esriFieldTypeInteger, alias: CONDITION, editable: true, nullable: true, defaultValue: null, modelName: CONDITION )
• CNDITNDATE ( type: esriFieldTypeDate, alias: CNDITNDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CNDITNDATE )
• X ( type: esriFieldTypeDouble, alias: X Coordinate (m), editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y Coordinate (m), editable: true, nullable: true, defaultValue: null, modelName: Y )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• UDF_Zone ( type: esriFieldTypeString, alias: UDF Zone, editable: true, nullable: true, length: 1, defaultValue: null, modelName: UDF_Zone )
• VALVE_ID ( type: esriFieldTypeString, alias: Isolation Valve ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVE_ID )
• CW_HYDPSI ( type: esriFieldTypeString, alias: Hydrant Pressure (PSI), editable: true, nullable: true, length: 3, defaultValue: null, modelName: CW_HYDPSI )
• CW_OBST ( type: esriFieldTypeString, alias: Obstructed (Cityworks), editable: true, nullable: true, length: 3, defaultValue: null, modelName: CW_OBST )
• CW_CAPGSKT ( type: esriFieldTypeString, alias: Caps and Gaskets Condition (Cityworks), editable: true, nullable: true, length: 25, defaultValue: null, modelName: CW_CAPGSKT )
• CW_DRNDWN ( type: esriFieldTypeString, alias: Drain Down (Cityworks), editable: true, nullable: true, length: 25, defaultValue: null, modelName: CW_DRNDWN )
• CW_HYDBODY ( type: esriFieldTypeString, alias: Hydrant Body Condion (Cityworks), editable: true, nullable: true, length: 25, defaultValue: null, modelName: CW_HYDBODY )
• CW_HYD_OPTN ( type: esriFieldTypeString, alias: Hydrant Operation (Cityworks), editable: true, nullable: true, length: 25, defaultValue: null, modelName: CW_HYD_OPTN )
• CW_THRDCOND ( type: esriFieldTypeString, alias: Thread Condition (Cityworks), editable: true, nullable: true, length: 25, defaultValue: null, modelName: CW_THRDCOND )
• CW_INTMECH ( type: esriFieldTypeString, alias: Interior Mechanism Condition (Cityworks), editable: true, nullable: true, length: 25, defaultValue: null, modelName: CW_INTMECH )
• CW_LEAKS ( type: esriFieldTypeString, alias: Is Hydrant Leaking (Cityworks), editable: true, nullable: true, length: 25, defaultValue: null, modelName: CW_LEAKS )
• CW_HYD_ISOV ( type: esriFieldTypeString, alias: Isolation Valve Condition (Cityworks), editable: true, nullable: true, length: 25, defaultValue: null, modelName: CW_HYD_ISOV )
• CW_INSP_CMNT ( type: esriFieldTypeString, alias: Inspection Comments (Cityworks), editable: true, nullable: true, length: 255, defaultValue: null, modelName: CW_INSP_CMNT )
• CW_INSP_DATE ( type: esriFieldTypeDate, alias: Inspection Date (Cityworks), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CW_INSP_DATE )
• CW_INSPTBY ( type: esriFieldTypeString, alias: Inspected By (CityWorks), editable: true, nullable: true, length: 25, defaultValue: null, modelName: CW_INSPTBY )
• CW_INSPTDATE ( type: esriFieldTypeDate, alias: Inspection Date (CityWorks), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CW_INSPTDATE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FLOW_RATE_LPM ( type: esriFieldTypeDouble, alias: Flow Rate Liters Per Minute, editable: true, nullable: true, defaultValue: null, modelName: FLOW_RATE_LPM )
• CDA_Value ( type: esriFieldTypeDouble, alias: CDA Value, editable: true, nullable: true, defaultValue: null, modelName: CDA_Value )
• UDFZone ( type: esriFieldTypeString, alias: UDF Zone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UDFZone )

Templates:

• Name: Water Hydrants
  Description:
  Prototype:
  CDA_Value: null
  ASSET_ID: null
  HYD_NUMBER: null
  DIAMETER: null
  FUNCTION_: FIRE SUPPRESSION
  TYPE: null
  OWN_TYPE: null
  INSTALL_YR: 2023
  ADD_NUMBER: null
  ADD_STREET: null
  ADDRESS: null
  LOCATION: null
  COMMUNITY: null
  ROAD_PRJCT: null
  ELEVATION: null
  MAKE_MODEL: null
  PUMPTHREAD: null
  SIDETHREAD: null
  VALVE_TYPE: null
  DRAIN_TYPE: null
  STATIC_PR: null
  RESIDUA_PR: null
  FLOW_RATE: null
  PRESSURE: null
  OBSTRUCTED: null
  BARREL_DIA: null
  SERIALNUM: null
  LIFECYCYCL: null
  CAP_M3_H: null
  CAP_M3_D: null
  USEFULLIFE: null
  COMMENT: null
  SERVICE: null
  LastInspec: null
  OUTLETTYPE: null
  WRANTYDATE: null
  CONDITION: null
  CNDITNDATE: null
  X: null
  Y: null
  FLOW_RATE_LPM: null
  UDFZone: null
  CW_INSPTDATE: null
  CW_INSPTBY: null
  UDF_Zone: null
  VALVE_ID: null
  CW_HYDPSI: null
  CW_OBST: null
  CW_CAPGSKT: null
  CW_DRNDWN: null
  CW_HYDBODY: null
  CW_HYD_OPTN: null
  CW_THRDCOND: null
  CW_INTMECH: null
  CW_LEAKS: null
  CW_HYD_ISOV: null
  CW_INSP_CMNT: null
  CW_INSP_DATE: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• IsolationValve (0) -- Related To: Water Valves (14)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:

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