Layers:

Layer: Water Hydrant (0)

Name: Water Hydrant

Display Field: CreatedBy

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Inventory of fire hydrants owned and maintained by Madison Water Utility. Also contains known private hydrants. Private hydrants are not actively maintained in this dataset and should not be considered current. The inventory of utility maintained hydrants is actively maintained and updated daily.

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 771125.2385253906
YMin: 456112.33999884676
XMax: 857856.4724731445
YMax: 518254.2264905726
Spatial Reference: 103412  (8193)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 145, 90, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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


HasZ: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, length: 20 , Coded Values: [ACT: Active] , [INA: Inactive] , [PRO: Proposed] , ...4 more... )
• Location ( type: esriFieldTypeString, alias: LocationDescription, length: 250 )
• SymbolRotation ( type: esriFieldTypeDouble, alias: SymbolRotation )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 10 , Coded Values: [AMERD: American Darling] , [AMERF: American Flow Control] , [APCO: APCO Valve & Primer] , ...21 more... )
• Style ( type: esriFieldTypeString, alias: Style, length: 25 )
• year_manufactured ( type: esriFieldTypeInteger, alias: year_manufactured )
• InstallYear ( type: esriFieldTypeSmallInteger, alias: InstallYear )
• Hyd_Model ( type: esriFieldTypeString, alias: Hyd_Model, length: 25 )
• nozzle_color ( type: esriFieldTypeString, alias: nozzle_color, length: 10 )
• MaintainedBy ( type: esriFieldTypeString, alias: MaintainedBy, length: 25 , Coded Values: [MADISON WATER UTILITY: Madison Water Utility] , [PRIVATE: Private] , [OTHER: Other] , ...5 more... )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Municipality ( type: esriFieldTypeString, alias: Municipality, length: 30 )

Tables:

Table: Water.DATA_ADMIN6.tblLSLMaterialsInventory (1)

Name: Water.DATA_ADMIN6.tblLSLMaterialsInventory

Display Field: SITEID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SITEID ( type: esriFieldTypeString, alias: SITE ID, length: 50 )
• LOCATIONID ( type: esriFieldTypeString, alias: LOCATIONAL IDENTIFIER, length: 50 )
• LEAD_GOOSENECK ( type: esriFieldTypeString, alias: LEAD GOOSENECK CURRENTLY PRESENT, length: 5 , Coded Values: [Y: Y] , [N: N] , [UNK: UNK] )
• MATERIAL ( type: esriFieldTypeString, alias: CURRENT STREET SIDE SERVIC LINE MATERIAL, length: 10 , Coded Values: [L: CONFIRMED LEAD] , [C: CONFIRMED COPPER] , [G: CONFIRMED GALVANIZED] , ...6 more... )
• PREVIOUSLY_LEAD ( type: esriFieldTypeString, alias: WAS STREET SIDE SERVICE LINE EVER PREVIOUSLY LEAD, length: 5 , Coded Values: [Y: Y] , [N: N] , [UNK: UNK] )
• SIZE ( type: esriFieldTypeString, alias: STREET SIDE SERVICE LINE SIZE, length: 10 )
• INSTALLDATE ( type: esriFieldTypeInteger, alias: STREET SIDE SERVICE LINE INSTALL DATE )
• POMATERIAL ( type: esriFieldTypeString, alias: CURRENT PROPERTY SIDE SERVICE LINE MATERIAL, length: 10 , Coded Values: [L: CONFIRMED LEAD] , [C: CONFIRMED COPPER] , [G: CONFIRMED GALVANIZED] , ...6 more... )
• POSIZE ( type: esriFieldTypeString, alias: PROPERTY SIZE SERVICE LINE SIZE, length: 10 )
• POINSTALLDATE ( type: esriFieldTypeInteger, alias: PROPERTY SIDE SERVICE LINE INSTALL DATE )
• BUILDINGTYPE ( type: esriFieldTypeString, alias: BUILDING TYPE, length: 10 , Coded Values: [SF: SINGLE-FAMILY RESIDENTIAL] , [MF: MULTI-FAMILY RESIDENTIAL] , [SCH/CC: SCHOOL OR CHILD CARE] , ...4 more... )
• POE_TREATMENT ( type: esriFieldTypeString, alias: POINT-OF-ENTRY OR POINT-OF-USE TREATMENT PRESENT, length: 5 , Coded Values: [Y: Y] , [N: N] , [UNK: UNK] )
• BUILDINGMATERIAL1 ( type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL 1, length: 5 , Coded Values: [CLS: COPPER WITH LEAD SOLDER] , [C: COPPER, NO LEAD SOLDER] , [O: OTHER MATERIAL THAT IS NOT COPPER, OR COPPER WITH LEAD SOLDER] , ...1 more... )
• BUILDINGMATERIAL2 ( type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL 2, length: 5 , Coded Values: [CLS: COPPER WITH LEAD SOLDER] , [C: COPPER, NO LEAD SOLDER] , [O: OTHER MATERIAL THAT IS NOT COPPER, OR COPPER WITH LEAD SOLDER] , ...1 more... )
• BUILDINGMATERIALINSTALLDATE ( type: esriFieldTypeInteger, alias: BUILDING PLUMBING MATERIAL INSTALL DATE )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• BASIS_MAT_CLASS ( type: esriFieldTypeString, alias: BASIS OF STREET SIDE MATERIAL CLASSIFICATION, length: 30 , Coded Values: [PREVIOUS EVAL: PREVIOUS MATERIALS EVALUATION] , [INSTALLATION RECORD: INSTALLATION RECORD (EG TAP CARD)] , [INSTALLED AFTER LEAD BAN: INSTALLATION AFTER LEAD BAN (1986)] , ...5 more... )
• MAT_FIELD_VERIFIED ( type: esriFieldTypeString, alias: WAS STREET SIDE MATERIAL FIELD VERIFIED, length: 5 , Coded Values: [Y: Y] , [N: N] , [UNK: UNK] )
• DATE_VERIFIED ( type: esriFieldTypeDate, alias: DATE OF STREET SIDE FIELD VERIFICATION, IF APPLICABLE, length: 8 )
• METHOD_VERIFIED ( type: esriFieldTypeString, alias: METHOD OF STREET SIDE FIELD VERIFICATION, IF APPLICABLE, length: 50 , Coded Values: [CUSTOMER SELF ID: CUSTOMER SELF IDENTIFICATION] , [CCTV - INTERNAL: CCTV AT CURB STOP - INTERNAL] , [CCTV - EXTERNAL: CCTV AT CURB STOP - EXTERNAL] , ...5 more... )
• BASIS_PO_MAT_CLASS ( type: esriFieldTypeString, alias: BASIS OF PROPERTY SIDE MATERIAL CLASSIFICATION, length: 30 , Coded Values: [PREVIOUS EVAL: PREVIOUS MATERIALS EVALUATION] , [INSTALLATION RECORD: INSTALLATION RECORD (EG TAP CARD)] , [INSTALLED AFTER LEAD BAN: INSTALLATION AFTER LEAD BAN (1986)] , ...5 more... )
• PO_MAT_FIELD ( type: esriFieldTypeString, alias: WATER PROPERTY SIDE MATERIAL FIELD VERIFIED, length: 5 , Coded Values: [Y: Y] , [N: N] , [UNK: UNK] )
• DATE_PO_VERIFIED ( type: esriFieldTypeDate, alias: DATE OF PROPERTY SIDE FIELD VERIFICATION, length: 8 )
• METHOD_PO_VERIFIED ( type: esriFieldTypeString, alias: METHOD OF PROPERTY SIDE FIELD VERIFICATION, length: 50 , Coded Values: [CUSTOMER SELF ID: CUSTOMER SELF IDENTIFICATION] , [CCTV - INTERNAL: CCTV AT CURB STOP - INTERNAL] , [CCTV - EXTERNAL: CCTV AT CURB STOP - EXTERNAL] , ...5 more... )
• NOTES_MAT_CLASS ( type: esriFieldTypeString, alias: NOTES_MAT_CLASS, length: 200 )
• ServiceLateralID ( type: esriFieldTypeString, alias: ServiceLateralID, length: 25 )
• PropertyID ( type: esriFieldTypeString, alias: PropertyID, length: 12 )