Layers:

Layer: IowaCity.SDE.wHydrantR (1)

Name: IowaCity.SDE.wHydrantR

Display Field: SDE.wHydrantR.HYD_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 54aaff0af6b9424a859f65bb45f61df4

Copyright Text:

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:
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: [TS: Tony Stipes] , [SO: Shawn Ostrander] , [NS: Nate Swartzentruber] , ...14 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)

Tables:

Table: HydrantMaintenanceInspection (2)

Name: HydrantMaintenanceInspection

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 54aaff0af6b9424a859f65bb45f61df4

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: 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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PRESSURE ( type: esriFieldTypeDouble, alias: Pressure (PSI) )
• FACILITYKEY ( type: esriFieldTypeString, alias: Facility ID, length: 50 )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector, length: 50 , Coded Values: [TS: Tony Stipes] , [SO: Shawn Ostrander] , [NS: Nate Swartzentruber] , ...14 more... )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 1000 )
• DateInspected ( type: esriFieldTypeDate, alias: Date Inspected, length: 8 )
• HydAccessible ( type: esriFieldTypeString, alias: Hydrant Accessible?, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• HydDrains ( type: esriFieldTypeString, alias: Hydrant Drains?, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• HydFlushed ( type: esriFieldTypeString, alias: Hyd Flushed?, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• HydPaint ( type: esriFieldTypeString, alias: Paint Req'd?, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• LocatorBox ( type: esriFieldTypeString, alias: Locator Box?, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• RepairsNeeded ( type: esriFieldTypeString, alias: Repairs Needed, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• RepairNotes ( type: esriFieldTypeString, alias: Repair Notes, length: 200 )
• FlushTime ( type: esriFieldTypeDouble, alias: Flush Time in Minutes )
• WaterLoss ( type: esriFieldTypeDouble, alias: Water Loss in Gallons )
• TotalChlorine ( type: esriFieldTypeDouble, alias: Total Chlorine )
• InspectionStatus ( type: esriFieldTypeString, alias: InspectionStatus, length: 25 , Coded Values: [Complete: Complete] , [Needs Work Order: Complete Needs Work Order] , [In Progress: In Progress] )
• HydOperational ( type: esriFieldTypeString, alias: Hyd Operational?, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNKNOWN] , ...1 more... )
• Repairs_1 ( type: esriFieldTypeString, alias: Repairs 1, length: 100 , Coded Values: [Bolt: Bolt] , [Broken Flange: Broken Flange] , [Coupler: Coupler] , ...17 more... )
• Repairs_2 ( type: esriFieldTypeString, alias: Repairs 2, length: 100 , Coded Values: [Bolt: Bolt] , [Broken Flange: Broken Flange] , [Coupler: Coupler] , ...17 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• SDE.wHydrantR (0) -- Related To: IowaCity.SDE.wHydrantR (1)