Name: FireHydrants2022

Display Field: Condition

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9437514.93820597
YMin: 4790259.95470498
XMax: -9429042.04945651
YMax: 4798190.69529576
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"Flushed","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[228,26,28,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[230,0,0,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"0","label":"Not Flushed"},{"symbol":{"type":"esriPMS","url":"0341d0758d991ce5d7a6e4b3b1d934ef","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA9klEQVQ4jaXTsUpCcRQH4E+9ZRqklFNBNjUlRG0NTT5DW43OQU8QTQ3NQQ/RE0RTQYsQCVENwd2NMOkOpdlQBOHN+NcPzvj7Dmc4kY9UPickbbQjVIpVJ6Waaki70xInsXqESqmmunqkHAI0GySxShRSSksQMOiTyf0BaJ/xcM78JoXZAGDQ53qXfkJtf3h7KtC9pTBHrsjlNoNXVg6RSV/yDeg9cbFBeZnxaZ7vWTv+uTwERFNUt7g7IDfB+inZ/KgjU05Y3OHlkfwMkwujy6kALO3x1vu9/CMgQ3bsP0BAIrQ7LXGzEVbsdV19AUmsnsTB7ww370aPOq3oFVMIAAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":12,"angle":0,"xoffset":0,"yoffset":0},"value":"1","label":"Flushed"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[227,25,28,255],"toColor":[227,25,28,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[55,126,184,255],"toColor":[55,126,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[77,176,74,255],"toColor":[77,176,74,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.HydrantID","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","useCodedValues":true,"maxScale":0,"minScale":1145.5650202339523,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[78,78,78,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Corbel","size":10,"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:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID_2

Type ID Field: Flushed

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [NR: Needs Repaired], [GD: Good])
• Flushed (type: esriFieldTypeInteger, alias: Flushed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• Note2 (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [JW: Jake Wyant], [JH: Josh Hatmaker], [CS: Chris Sizemore], ... 3 more ...)
• Inspection (type: esriFieldTypeDate, alias: Inspection, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Reflective (type: esriFieldTypeString, alias: Reflective, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [OK: OK], [NR: Needs replaced])
• PressureTe (type: esriFieldTypeDate, alias: PressureTe, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FlowRateGP (type: esriFieldTypeInteger, alias: FlowRateGP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Manufactur (type: esriFieldTypeString, alias: Manufactur, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AD: American Darling], [CL: Clow], [KE: Kennedy], ... 1 more ...)
• HasLabel (type: esriFieldTypeString, alias: HasLabel, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• HydrantID (type: esriFieldTypeString, alias: HydrantID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• DateLocate (type: esriFieldTypeString, alias: DateLocate, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Elevation (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CapMissing (type: esriFieldTypeInteger, alias: CapMissing, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• CapReplace (type: esriFieldTypeDate, alias: CapReplace, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CapGreased (type: esriFieldTypeDate, alias: CapGreased, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ChainsMiss (type: esriFieldTypeInteger, alias: ChainsMiss, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• ChainsRepl (type: esriFieldTypeDate, alias: ChainsRepl, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ChainsNorm (type: esriFieldTypeInteger, alias: ChainsNorm, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• Paint (type: esriFieldTypeInteger, alias: Paint, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• Repainted (type: esriFieldTypeDate, alias: Repainted, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OpenNutOK (type: esriFieldTypeInteger, alias: OpenNutOK, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• OpenNutGre (type: esriFieldTypeDate, alias: OpenNutGre, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OpenNutRep (type: esriFieldTypeDate, alias: OpenNutRep, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NozzlesOK (type: esriFieldTypeInteger, alias: NozzlesOK, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• NozzlesCau (type: esriFieldTypeDate, alias: NozzlesCau, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NozzlesRep (type: esriFieldTypeDate, alias: NozzlesRep, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ValveAndSe (type: esriFieldTypeInteger, alias: ValveAndSe, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• ValveAnd_1 (type: esriFieldTypeDate, alias: ValveAnd_1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PackingOK (type: esriFieldTypeInteger, alias: PackingOK, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• PackingTig (type: esriFieldTypeDate, alias: PackingTig, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PackingRep (type: esriFieldTypeDate, alias: PackingRep, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Drainage (type: esriFieldTypeInteger, alias: Drainage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• DrainageCo (type: esriFieldTypeDate, alias: DrainageCo, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BranchValv (type: esriFieldTypeString, alias: BranchValv, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• DefectsCor (type: esriFieldTypeString, alias: DefectsCor, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DefectsC_1 (type: esriFieldTypeDate, alias: DefectsC_1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CreateDate (type: esriFieldTypeDate, alias: CreateDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• Maintained (type: esriFieldTypeString, alias: Maintained, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CoO: City of Oxford], [TP: Third Party])
• GlobalID_2 (type: esriFieldTypeGlobalID, alias: GlobalID_2, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Types:

ID: 0
Name: Not Flushed
Domains:

• Field Name: Condition
  Inherited
  
• Field Name: Flushed
  Inherited
  
• Field Name: Inspector
  Inherited
  
• Field Name: Reflective
  Inherited
  
• Field Name: Manufactur
  Inherited
  
• Field Name: CapMissing
  Inherited
  
• Field Name: ChainsMiss
  Inherited
  
• Field Name: ChainsNorm
  Inherited
  
• Field Name: Paint
  Inherited
  
• Field Name: OpenNutOK
  Inherited
  
• Field Name: NozzlesOK
  Inherited
  
• Field Name: ValveAndSe
  Inherited
  
• Field Name: PackingOK
  Inherited
  
• Field Name: Drainage
  Inherited
  
• Field Name: Maintained
  Inherited
  
Templates:

Name: Not Flushed
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• PackingOK: 1
• Flushed: 0
• Reflective: OK
• CapMissing: 0
• ChainsMiss: 0
• ChainsNorm: 1
• Paint: 0
• OpenNutOK: 1
• NozzlesOK: 1
• ValveAndSe: 1
• Drainage: 1

---

ID: 1
Name: Flushed
Domains:

• Field Name: Condition
  Inherited
  
• Field Name: Flushed
  Inherited
  
• Field Name: Inspector
  Inherited
  
• Field Name: Reflective
  Inherited
  
• Field Name: Manufactur
  Inherited
  
• Field Name: CapMissing
  Inherited
  
• Field Name: ChainsMiss
  Inherited
  
• Field Name: ChainsNorm
  Inherited
  
• Field Name: Paint
  Inherited
  
• Field Name: OpenNutOK
  Inherited
  
• Field Name: NozzlesOK
  Inherited
  
• Field Name: ValveAndSe
  Inherited
  
• Field Name: PackingOK
  Inherited
  
• Field Name: Drainage
  Inherited
  
• Field Name: Maintained
  Inherited
  
Templates:

Name: Flushed
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• PackingOK: 1
• Flushed: 1
• Reflective: OK
• CapMissing: 0
• ChainsMiss: 0
• ChainsNorm: 1
• Paint: 0
• OpenNutOK: 1
• NozzlesOK: 1
• ValveAndSe: 1
• Drainage: 1

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/30/2023 12:02:09 PM

Schema Last Edit Date: 10/30/2023 12:02:09 PM

Data Last Edit Date: 10/30/2023 12:02:09 PM

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