Name: IowaCity.SDE.wHydrantR

Display Field: SDE.wHydrantR.HYD_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: General locations of fire hydrants connected to the Iowa City drinking water distribution system, including hydrants connected through private water service lines. Fire hydrants of sister water utilities are included where the Iowa City Water Division may use them for general system/interconnection maintenance. Information attached to each fire hydrants includes make and model, general location description, size, size of lateral connection, size of water pipe fed from, existence of auxiliary valve, flushing route and order, and dead-end designation. This feature class is based on information submitted through construction as-builts and field observations.

Service Item Id: 54aaff0af6b9424a859f65bb45f61df4

Copyright Text: City of Iowa City Water Division

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 50000.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: 2151996.9765985236
YMin: 591935.928136677
XMax: 2197106.087535587
YMax: 623631.1866296022
Spatial Reference: 102676  (3418)  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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• SDE.wHydrantR.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SDE.wHydrantR.HYD_ID ( type: esriFieldTypeString, alias: HYD_ID, length: 50 )
• SDE.wHydrantR.OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, length: 20 , Coded Values: [City: City] , [Other: Other] , [Private: Private] , ...8 more... )
• SDE.wHydrantR.MAP_NUM ( type: esriFieldTypeString, alias: MAP_NUM, length: 20 )
• SDE.wHydrantR.LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 256 )
• SDE.wHydrantR.MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, length: 50 , Coded Values: [AMERICAN DARLING: AMERICAN DARLING] , [CLOW: CLOW] , [EDDY: EDDY] , ...7 more... )
• SDE.wHydrantR.HYD_MODEL ( type: esriFieldTypeString, alias: HYD_MODEL, length: 50 , Coded Values: [F-2545: F-2545] , [F-2500: F-2500] , [MK-73: MK-73] , ...5 more... )
• SDE.wHydrantR.YEAR_MAN ( type: esriFieldTypeSmallInteger, alias: YEAR_MAN )
• SDE.wHydrantR.HYD_SIZE ( type: esriFieldTypeDouble, alias: HYD_SIZE )
• SDE.wHydrantR.NOZZLE_NUM ( type: esriFieldTypeSmallInteger, alias: NOZZLE_NUM )
• SDE.wHydrantR.BURY_DEPTH ( type: esriFieldTypeDouble, alias: BURY_DEPTH )
• SDE.wHydrantR.HYD_EXTEN ( type: esriFieldTypeSingle, alias: HYD_EXTEN )
• SDE.wHydrantR.YEAR_INST ( type: esriFieldTypeSmallInteger, alias: YEAR_INST )
• SDE.wHydrantR.AUX_VAL ( type: esriFieldTypeString, alias: AUX_VAL, length: 5 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• SDE.wHydrantR.VALVE_DIAM ( type: esriFieldTypeSingle, alias: VALVE_DIAM )
• SDE.wHydrantR.ROUTE_NUM ( type: esriFieldTypeString, alias: ROUTE_NUM, length: 20 )
• SDE.wHydrantR.ROUTE_ORDER ( type: esriFieldTypeDouble, alias: ROUTE_ORDER )
• SDE.wHydrantR.DEAD_END ( type: esriFieldTypeString, alias: DEAD_END, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• SDE.wHydrantR.DE_NUM ( type: esriFieldTypeString, alias: DE_NUM, length: 10 )
• SDE.wHydrantR.DE_ORDER ( type: esriFieldTypeDouble, alias: DE_ORDER )
• SDE.wHydrantR.STATIC_PRES ( type: esriFieldTypeSmallInteger, alias: STATIC_PRES )
• SDE.wHydrantR.DATE_REC ( type: esriFieldTypeDate, alias: DATE_REC, length: 8 )
• SDE.wHydrantR.MAIN_DIAM ( type: esriFieldTypeSmallInteger, alias: MAIN_DIAM )
• SDE.wHydrantR.NOTES ( type: esriFieldTypeString, alias: NOTES, length: 500 )
• SDE.wHydrantR.BILLING ( type: esriFieldTypeString, alias: BILLING, length: 50 , Coded Values: [U OF I: U OF I] , [UI-DUAL: UI-DUAL] , [UNIVERSITY HEIGHTS: UNIVERSITY HEIGHTS] )
• SDE.wHydrantR.EASTING ( type: esriFieldTypeDouble, alias: EASTING )
• SDE.wHydrantR.NORTHING ( type: esriFieldTypeDouble, alias: NORTHING )
• SDE.wHydrantR.GPS_ACCURACY ( type: esriFieldTypeString, alias: GPS_ACCURACY, length: 50 , Coded Values: [CAD: CAD 3FT TO 300FT] , [REC: GPS RECREATIONAL GRADE 10M TO 30FT] , [MAP: GPS MAPPING GRADE 4IN TO 1M] , ...3 more... )
• SDE.wHydrantR.created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• SDE.wHydrantR.created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• SDE.wHydrantR.last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• SDE.wHydrantR.last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• SDE.wHydrantR.LAT_DIAM ( type: esriFieldTypeSingle, alias: LAT_DIAM )
• SDE.wHydrantR.SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SDE.wHydrantR.GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SDE.wHydrantR.GPM ( type: esriFieldTypeDouble, alias: Gallons per Minute )
• SDE.wHydrantR.Storz_Conn ( type: esriFieldTypeString, alias: Storz_Connection, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• SDE.wHydrantR.ANN_BAC_SAM_HYD ( type: esriFieldTypeString, alias: Annual Bacterial Sample Hydrant, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• SDE.HydrantMaintenanceInspection.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• SDE.HydrantMaintenanceInspection.PRESSURE ( type: esriFieldTypeDouble, alias: Pressure (PSI) )
• SDE.HydrantMaintenanceInspection.FACILITYKEY ( type: esriFieldTypeString, alias: Facility ID, length: 50 )
• SDE.HydrantMaintenanceInspection.INSPECTOR ( type: esriFieldTypeString, alias: Inspector, length: 50 , Coded Values: [ZK: Zach Knoop] , [TS: Tony Stipes] , [SO: Shawn Ostrander] , ...18 more... )
• SDE.HydrantMaintenanceInspection.NOTES ( type: esriFieldTypeString, alias: NOTES, length: 1000 )
• SDE.HydrantMaintenanceInspection.DateInspected ( type: esriFieldTypeDate, alias: Date Inspected, length: 8 )
• SDE.HydrantMaintenanceInspection.HydAccessible ( type: esriFieldTypeString, alias: Hydrant Accessible?, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• SDE.HydrantMaintenanceInspection.HydDrains ( type: esriFieldTypeString, alias: Hydrant Drains?, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• SDE.HydrantMaintenanceInspection.HydFlushed ( type: esriFieldTypeString, alias: Hyd Flushed?, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• SDE.HydrantMaintenanceInspection.HydPaint ( type: esriFieldTypeString, alias: Paint Req'd?, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• SDE.HydrantMaintenanceInspection.LocatorBox ( type: esriFieldTypeString, alias: Locator Box?, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• SDE.HydrantMaintenanceInspection.RepairsNeeded ( type: esriFieldTypeString, alias: Repairs Needed, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• SDE.HydrantMaintenanceInspection.RepairNotes ( type: esriFieldTypeString, alias: Repair Notes, length: 200 )
• SDE.HydrantMaintenanceInspection.FlushTime ( type: esriFieldTypeDouble, alias: Flush Time in Minutes )
• SDE.HydrantMaintenanceInspection.WaterLoss ( type: esriFieldTypeDouble, alias: Water Loss in Gallons )
• SDE.HydrantMaintenanceInspection.TotalChlorine ( type: esriFieldTypeDouble, alias: Total Chlorine )
• SDE.HydrantMaintenanceInspection.InspectionStatus ( type: esriFieldTypeString, alias: InspectionStatus, length: 25 , Coded Values: [Complete: Complete] , [Needs Work Order: Complete Needs Work Order] , [In Progress: In Progress] )
• SDE.HydrantMaintenanceInspection.HydOperational ( type: esriFieldTypeString, alias: Hyd Operational?, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• SDE.HydrantMaintenanceInspection.Repairs_1 ( type: esriFieldTypeString, alias: Repairs 1, length: 100 , Coded Values: [Bolt: Bolt] , [Broken Flange: Broken Flange] , [Coupler: Coupler] , ...17 more... )
• SDE.HydrantMaintenanceInspection.Repairs_2 ( type: esriFieldTypeString, alias: Repairs 2, length: 100 , Coded Values: [Bolt: Bolt] , [Broken Flange: Broken Flange] , [Coupler: Coupler] , ...17 more... )
• SDE.HydrantMaintenanceInspection.GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )

Relationships:

• SDE.HydrantMaintenanceInspection (0) -- Related To: HydrantMaintenanceInspection (2)

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

  Iteminfo   Thumbnail   Metadata