Name: Water Hydrants

Display Field: ASSET_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 343c9fe7351f4d7cb7f9ff9fe6f25f6e

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 8000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: N/A

Fields:

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

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata