Layer: Hydrant (ID:5)

View In: Map Viewer

Name: Hydrant

Display Field: EAM_PARENT

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 577791

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"LifecycleStatus","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"b761f501a4cee8b30e6793f0933d4986","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA50lEQVQoka3QIUvDQRgH4CcMF4SBMMGwYDEMxDhkZZoGGkwG58dwRTAoFvEDDBQ/gMUiDJxB0aLJtZlElBkMBmEaVFBkJ4z5/29DfOGO9353D9xdwh8r8d9wBpnQn+N+UFgeZv4N7ywOBDfJpshPtZE6K3ccVWjFwQJGM2wVGfkJJ5ne5RAVXKLZDTdSFPJhsYNxFDHBrPZYwv6vq35gKPQ3+OzIe73x4pWXA3Il0tsdG2fcooGHKLj6PZ2SbXGywNgzjqnVWMZTz1+tcl3lap25EO11o0gYqo5k6B+jDsTBtZi8L+xbX7VQMOF4mEziAAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"I","label":"Active"},{"symbol":{"type":"esriPMS","url":"1afdae60fd3f5485cde5347bf224a55e","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABGklEQVQoka2QsUuFQBzHv4OS4CQUJOTiILzBtYtAXk1CzQ3Rf6BjLUFLW39BU+6BizTVkuDSIWhbLUIQOTi8zeDAU8KyR7ynvUf0hTt+97nf5zh+Av4Y4b/FHQAbXR0BeF1WPJEkaZ9zDs75wVKi4zgjURS3DcNAVVXIsuy4KIpb3/fLIXEMYE1RlAtCiPINdV3fCoLgBsAlAArgbVY8l2V5bJrm5yEIAqiqCkIINE3bBdCuQwDXc1+t6xqC8IXyPJ/ypmnmhvBTfGCMvYdhuGnb9qrrutOLNE1fADy17/WJp+2WJMmIMXZvWdZ6WZaI4/guiqIjAJNfp0opfaaUpp7n7XXoalbqFbs8Aljp6qKvYUg8G+ALxYX5ANsxWoRj7G4rAAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"IN","label":"Inactive"},{"symbol":{"type":"esriPMS","url":"38447c0e6725fc8991624c849da75d8d","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABCUlEQVQoka3QoWsCYRjH8W8QFzQoKAxcM10URGRFrS5cGiir/gVqERa0ma4pCEaD7YUJ4pWFlQ3DbIppIBtoEIO7ciLK7W5M9E5l+MD78nuf9/3Ay+Pin+W6NEwCN1Z+ASbnwqLXy52ug65zfxas1ZA8Hm6j0R9Ev09hOqVXLvPtBBNAMBSiKsv4f5uRCHFF4QmoA2/A5z6s+HwkUinzoCgQDoMsgyRhdI2VBdoHX12twO0283gMm42Z1+vDIezCV01Da7WI5XIEGo2/C1XlAxgCX3awZGzdLtJyyXMmw/ViAZ0OqhA8APOjUxWCkRC85/OkrVZzH9lCqwbAlZVndg+c4KND/yQ8WVveNkathuvd8gAAAABJRU5ErkJggg==","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"PROP","label":"Proposed"},{"symbol":{"type":"esriPMS","url":"ed2d25137a128fefdbb036788a89c26f","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAsklEQVQoka3QMWoCQRiG4adYSB2IYOEFcgEJNmqrtUXwGKYR0th5AisPYG1lmhQ2WmlnSkFMkSKd9hIYYVh23UXywsD3/czL8E/iTpL/FluohbzEoaz4hm7IvbLiMxpRH2CBU57YRAVjPEbzF8wxwRrHtDgKchbtcF4xu7VjIbG4whl1PKXu7bHDd5Y4jD7nE9XQP9DHb96LV76wQSf0aVrKE//Y4iHkn6IdY95z5oViIRdawBrZbu9X5wAAAABJRU5ErkJggg==","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"AB","label":"Abandoned"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,127,189,255],"toColor":[212,127,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[205,224,126,255],"toColor":[205,224,126,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,151,116,255],"toColor":[207,151,116,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[217,121,134,255],"toColor":[217,121,134,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[217,204,152,255],"toColor":[217,204,152,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,145,168,255],"toColor":[207,145,168,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[227,159,157,255],"toColor":[227,159,157,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[217,206,121,255],"toColor":[217,206,121,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[185,207,143,255],"toColor":[185,207,143,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[227,189,132,255],"toColor":[227,189,132,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[209,171,146,255],"toColor":[209,171,146,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,126,116,255],"toColor":[207,126,116,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[224,157,210,255],"toColor":[224,157,210,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.FacilityID"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"LifecycleStatus <> 'AB' Or LifecycleStatus <> 'D' Or LifecycleStatus <> 'DC'","useCodedValues":true,"maxScale":0,"minScale":2257,"name":"Default","priority":11,"symbol":{"type":"esriTS","color":[230,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[225,225,225,255],"haloSize":2,"font":{"family":"Arial","size":9,"style":"normal","weight":"bold","decoration":"none"}}}]}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: LifecycleStatus

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
FacilityID (type: esriFieldTypeString, alias: FacilityID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
InstallDate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PressureZone (type: esriFieldTypeString, alias: Pressure Zone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Zone 1: Zone 1], [Zone 2: Zone 2], [Zone 3: Zone 3], ... 7 more ...)
LifecycleStatus (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [PROP: Proposed], [I: Active], [IN: Inactive], ... 3 more ...)
Elevation (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
WaterType (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Non-Potable Water: Non-Potable Water], [Treated Water: Treated Water], [Potable Water: Potable Water])
Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MainPortType (type: esriFieldTypeString, alias: MainPortType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Dry Barrel: Dry Barrel], [Wet Barrel: Wet Barrel], [Unknown: Unknown], ... 1 more ...)
MainPortDiameter (type: esriFieldTypeDouble, alias: MainPortDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
NozzleDiameter1 (type: esriFieldTypeDouble, alias: NozzleDiameter1, SQL Type: sqlTypeOther, nullable: true, editable: true)
NozzleDiameter2 (type: esriFieldTypeDouble, alias: NozzleDiameter2, SQL Type: sqlTypeOther, nullable: true, editable: true)
BuryDepth (type: esriFieldTypeString, alias: Bury Depth, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [3': 3'], [3.5': 3.5'], [4': 4'], ... 9 more ...)
RatedFlowGPM (type: esriFieldTypeDouble, alias: Rated Flow (GPM), SQL Type: sqlTypeOther, nullable: true, editable: true)
Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [AMERICANDARLING: American Darling], [COREY: Corey], [DRESSER: Dresser], ... 12 more ...)
ModelYear (type: esriFieldTypeString, alias: Model Year, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
Style (type: esriFieldTypeString, alias: Style, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
RestraintType (type: esriFieldTypeString, alias: Restraint Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [No Restraint: No Restraint], [Anchor: Anchor], [Blocking: Blocking], ... 10 more ...)
LocationDescription (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
PSI (type: esriFieldTypeDouble, alias: PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
Insp_Route (type: esriFieldTypeString, alias: Inspection Route, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
BranchValveDistance (type: esriFieldTypeDouble, alias: Branch Valve Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
BranchValveDirection (type: esriFieldTypeString, alias: Branch Valve Direction, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [E: E], [N: N], [NE: NE], ... 5 more ...)
ConnectionSize (type: esriFieldTypeSmallInteger, alias: ConnectionSize, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown/Other], [1: 1 inch], [2: 2 inch], ... 14 more ...)
ConnectionLocation (type: esriFieldTypeString, alias: ConnectionLocation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
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)
SubZone (type: esriFieldTypeString, alias: Pressure Subzone, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [2A: 2A], ... 30 more ...)
Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
AsBuiltNumber (type: esriFieldTypeString, alias: AsBuilt Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
IsLocated (type: esriFieldTypeString, alias: IsLocated, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [NO: NO], [YES: YES])
ExtensionKit (type: esriFieldTypeString, alias: Extension Kit, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [NO: NO], [YES: YES])
MaintDate (type: esriFieldTypeDate, alias: Maintenance Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MaintType (type: esriFieldTypeString, alias: Maintenance Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [REPAIR: Repair], [REPLACE: Replace], [MAINTAIN: Maintenance])
MaintBy (type: esriFieldTypeString, alias: MaintBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [BFARNSWORTH: Ben Farnsworth], [BFOLLOSE: Brandon Follose], [JHOLMGREN: Joe Holmgren], ... 4 more ...)

Types:

Field Name: PressureZone
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: WaterType
Inherited
Field Name: MainPortType
Inherited
Field Name: BuryDepth
Inherited
Field Name: Manufacturer
Inherited
Field Name: RestraintType
Inherited
Field Name: BranchValveDirection
Inherited
Field Name: ConnectionSize
Inherited
Field Name: SubZone
Inherited
Field Name: Enabled
Inherited
Field Name: IsLocated
Inherited
Field Name: ExtensionKit
Inherited
Field Name: MaintType
Inherited
Field Name: MaintBy
Inherited

FacilityID: WFH
LifecycleStatus: I
WaterType: Potable Water
Manufacturer: MUELLER
Enabled: 1

Field Name: PressureZone
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: WaterType
Inherited
Field Name: MainPortType
Inherited
Field Name: BuryDepth
Inherited
Field Name: Manufacturer
Inherited
Field Name: RestraintType
Inherited
Field Name: BranchValveDirection
Inherited
Field Name: ConnectionSize
Inherited
Field Name: SubZone
Inherited
Field Name: Enabled
Inherited
Field Name: IsLocated
Inherited
Field Name: ExtensionKit
Inherited
Field Name: MaintType
Inherited
Field Name: MaintBy
Inherited

FacilityID: WFH
LifecycleStatus: IN
WaterType: Potable Water
Manufacturer: MUELLER
Enabled: 1

Field Name: PressureZone
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: WaterType
Inherited
Field Name: MainPortType
Inherited
Field Name: BuryDepth
Inherited
Field Name: Manufacturer
Inherited
Field Name: RestraintType
Inherited
Field Name: BranchValveDirection
Inherited
Field Name: ConnectionSize
Inherited
Field Name: SubZone
Inherited
Field Name: Enabled
Inherited
Field Name: IsLocated
Inherited
Field Name: ExtensionKit
Inherited
Field Name: MaintType
Inherited
Field Name: MaintBy
Inherited

FacilityID: WFH
LifecycleStatus: PROP
WaterType: Potable Water
Manufacturer: MUELLER
Enabled: 1

Field Name: PressureZone
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: WaterType
Inherited
Field Name: MainPortType
Inherited
Field Name: BuryDepth
Inherited
Field Name: Manufacturer
Inherited
Field Name: RestraintType
Inherited
Field Name: BranchValveDirection
Inherited
Field Name: ConnectionSize
Inherited
Field Name: SubZone
Inherited
Field Name: Enabled
Inherited
Field Name: IsLocated
Inherited
Field Name: ExtensionKit
Inherited
Field Name: MaintType
Inherited
Field Name: MaintBy
Inherited

FacilityID: WFH
LifecycleStatus: AB
WaterType: Potable Water
Manufacturer: MUELLER
Enabled: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/26/2024 12:31:53 AM

Schema Last Edit Date: 11/26/2024 12:31:53 AM

Data Last Edit Date: 4/25/2024 10:58:59 AM

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