Name: Water Hydrant

Display Field: Number

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text: Copyright, 2011. CITY OF SOUTH BEND

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 135284.276175752
YMin: 2314550.91615318
XMax: 184317.982898172
YMax: 2371691.28120293
Spatial Reference: 2244 (2965)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[155,45,80,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Number (type: esriFieldTypeString, alias: Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Map (type: esriFieldTypeString, alias: Map, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• InstallDate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InstallYear (type: esriFieldTypeString, alias: Install Year, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Township (type: esriFieldTypeString, alias: Township, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Centre: Centre], [Clay: Clay], [German: German], ... 10 more ...)
• Political (type: esriFieldTypeString, alias: Political, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Ownership (type: esriFieldTypeString, alias: Owner Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Pub: Public], [Priv: Private], [Unk: Unknown])
• Make (type: esriFieldTypeString, alias: Make, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ValveLocation (type: esriFieldTypeString, alias: Valve Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StaticPSI (type: esriFieldTypeSmallInteger, alias: Static PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ResidualPSI (type: esriFieldTypeSmallInteger, alias: Residual PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowRateGPM (type: esriFieldTypeSmallInteger, alias: Flow Rate GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SteamerConn (type: esriFieldTypeString, alias: Steamer Connection, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• WorkOrderID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• HydrantOk (type: esriFieldTypeString, alias: Hydrant Ok, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [Unk: Unknown])
• DrainOk (type: esriFieldTypeString, alias: Drain Ok, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [Unk: Unknown])
• Oiled (type: esriFieldTypeString, alias: Oiled, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [Unk: Unknown])
• Flushed (type: esriFieldTypeString, alias: Flushed, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [Unk: Unknown])
• Leaks (type: esriFieldTypeString, alias: Leaks, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [Unk: Unknown])
• NeedsPaint (type: esriFieldTypeString, alias: Needs Paint, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [Unk: Unknown])
• NeedsRepair (type: esriFieldTypeString, alias: Needs Repair, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [Unk: Unknown])
• Turns (type: esriFieldTypeString, alias: Number of Turns, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• AncillaryRole (type: esriFieldTypeSmallInteger, alias: Ancillary Role, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Source], [2: Sink])
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Elevation (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPSDate (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GPSTime (type: esriFieldTypeString, alias: Time, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• PaintedDate (type: esriFieldTypeDate, alias: Painted Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RepairDate (type: esriFieldTypeDate, alias: Repair Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FlowTestDate (type: esriFieldTypeDate, alias: Flow Test Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Flag (type: esriFieldTypeString, alias: Flag, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LocDescrip (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FlushedDate (type: esriFieldTypeDate, alias: Date Flushed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Active: Active], [Abandoned: Abandoned], ... 3 more ...)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• FacID2 (type: esriFieldTypeSmallInteger, alias: FacID2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FacilityID (type: esriFieldTypeSmallInteger, alias: FacilityID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OperationalStatus (type: esriFieldTypeString, alias: Operational Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Operational: Operational], [Not Operational: Not Operational])

Templates:

Name: Water Hydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/26/2022 7:20:08 PM

Schema Last Edit Date: 5/26/2022 7:20:08 PM

Data Last Edit Date: 5/26/2022 7:20:08 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat