View In:   ArcGIS Online Map Viewer

Name: Hydrant

Display Field: DESCRIPTION

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Water network hydrants such as Fire, Farm and Water Hydrants.

Copyright Text: City of Sioux Falls

Default Visibility: true

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 2244151.2066093273
YMin: 1.5816260001802571E7
XMax: 2256865.7467969954
YMax: 1.5827665917967074E7
Spatial Reference: 32164  (32164)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: STATUS
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Has Been Flushed
  Label: Has Been Flushed
  Description:
  Symbol:
  
• Value: Needs Repair
  Label: Needs Repair
  Description:
  Symbol:
  
• Value: Out of Service
  Label: Out of Service
  Description:
  Symbol:
  
• Value: Private
  Label: Private
  Description:
  Symbol:
  
• Value: To Be Flushed
  Label: To Be Flushed
  Description:
  Symbol:
  
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: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: STATUS

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• DESCRIPTION ( type: esriFieldTypeString, alias: HYDRANT TYPE, editable: true, nullable: true, length: 4, defaultValue: FH, modelName: DESCRIPTION , Coded Values: [FH: Fire Hydrant] )
• TYPE ( type: esriFieldTypeString, alias: HYDRANT STYLE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TYPE , Coded Values: [Breakaway: Breakaway] , [Non-Breakaway: Non-Breakaway] , [9999: Unknown] )
• INSTALLDATE ( type: esriFieldTypeSmallInteger, alias: INSTALL DATE, editable: true, nullable: true, defaultValue: null, modelName: INSTALLDATE , Coded Values: [2018: 2018] , [2017: 2017] , [2016: 2016] , ...116 more... )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [AVK: AVK] , [Other: Other] , ...2 more... )
• DISTANCE ( type: esriFieldTypeDouble, alias: DISTANCE, editable: true, nullable: true, defaultValue: null, modelName: DISTANCE )
• LOCDESC ( type: esriFieldTypeString, alias: LOCATION DESCRIPTION, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: OPERABLE, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• LASTFLUSHED ( type: esriFieldTypeDate, alias: LAST FLUSHED DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICE )
• FLOW_GPM ( type: esriFieldTypeDouble, alias: FLOW RATE (GPM), editable: true, nullable: true, defaultValue: null, modelName: FLOW_GPM )
• SUBDIVISION ( type: esriFieldTypeString, alias: SUBDIVISION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SUBDIVISION , Coded Values: [29 RUSSELL RIVER PARK ADDN: 29 RUSSELL RIVER PARK ADDN] , [49TH STREET ADDN: 49TH STREET ADDN] , [85TH ST TOWER ADDN: 85TH ST TOWER ADDN] , ...1396 more... )
• SUBPHASE ( type: esriFieldTypeString, alias: SUBPHASE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SUBPHASE )
• CONTRACTOR ( type: esriFieldTypeString, alias: CONTRACTOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTRACTOR , Coded Values: [605 Company: 605 Company] , [A & J Excavating: A & J Excavating] , [Ace Excavating: Ace Excavating] , ...150 more... )
• PROJECTNUMBER ( type: esriFieldTypeString, alias: PROJECT NUMBER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PROJECTNUMBER )
• CIPNUMBER ( type: esriFieldTypeString, alias: CIP NUMBER, editable: true, nullable: true, length: 24, defaultValue: null, modelName: CIPNUMBER )
• INSGPSDATE ( type: esriFieldTypeInteger, alias: INSPECTION GPS DATE, editable: true, nullable: true, defaultValue: null, modelName: INSGPSDATE , Coded Values: [2018: 2018] , [2017: 2017] , [2016: 2016] , ...116 more... )
• DATE_ENTERED ( type: esriFieldTypeDate, alias: DATE ENTERED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_ENTERED )
• HYDRANTNUMBER ( type: esriFieldTypeInteger, alias: HYDRANT ID, editable: true, nullable: true, defaultValue: null, modelName: HYDRANTNUMBER )
• PID ( type: esriFieldTypeString, alias: PARCEL ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PID )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NOTES )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: ACTIVE FLAG, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: OWNED BY, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: MANAGED BY, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITY ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS , Coded Values: [To Be Flushed: To Be Flushed] , [Has Been Flushed: Has Been Flushed] , [Needs Repair: Needs Repair] , ...2 more... )
• CondIndex ( type: esriFieldTypeSmallInteger, alias: CondIndex, editable: true, nullable: true, defaultValue: null, modelName: CondIndex )
• InstallYear ( type: esriFieldTypeSmallInteger, alias: InstallYear, editable: true, nullable: true, defaultValue: null, modelName: InstallYear )
• LastInspectedBy ( type: esriFieldTypeString, alias: LastInspectedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LastInspectedBy )
• LastInspectedDate ( type: esriFieldTypeDate, alias: LastInspectedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastInspectedDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: Has Been Flushed
Name: Has Been Flushed
Domains:
• DESCRIPTION:
  Inherited
• TYPE:
  Inherited
• INSTALLDATE:
  Inherited
• MANUFACTURER:
  Inherited
• OPERABLE:
  Inherited
• SUBDIVISION:
  Inherited
• CONTRACTOR:
  Inherited
• INSGPSDATE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Has Been Flushed
  Description:
  Prototype:
  LastInspectedDate: null
  LastInspectedBy: null
  DESCRIPTION: FH
  TYPE: null
  INSTALLDATE: null
  MANUFACTURER: null
  DISTANCE: null
  LOCDESC: null
  OPERABLE: 1
  LASTFLUSHED: null
  FLOW_GPM: null
  SUBDIVISION: null
  SUBPHASE: null
  CONTRACTOR: null
  PROJECTNUMBER: null
  CIPNUMBER: null
  INSGPSDATE: null
  DATE_ENTERED: null
  HYDRANTNUMBER: null
  PID: null
  NOTES: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  FACILITYID: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  STATUS: Has Been Flushed
  CondIndex: null
  InstallYear: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Needs Repair
Name: Needs Repair
Domains:
• DESCRIPTION:
  Inherited
• TYPE:
  Inherited
• INSTALLDATE:
  Inherited
• MANUFACTURER:
  Inherited
• OPERABLE:
  Inherited
• SUBDIVISION:
  Inherited
• CONTRACTOR:
  Inherited
• INSGPSDATE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Needs Repair
  Description:
  Prototype:
  LastInspectedDate: null
  LastInspectedBy: null
  DESCRIPTION: FH
  TYPE: null
  INSTALLDATE: null
  MANUFACTURER: null
  DISTANCE: null
  LOCDESC: null
  OPERABLE: 1
  LASTFLUSHED: null
  FLOW_GPM: null
  SUBDIVISION: null
  SUBPHASE: null
  CONTRACTOR: null
  PROJECTNUMBER: null
  CIPNUMBER: null
  INSGPSDATE: null
  DATE_ENTERED: null
  HYDRANTNUMBER: null
  PID: null
  NOTES: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  FACILITYID: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  STATUS: Needs Repair
  CondIndex: null
  InstallYear: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Out of Service
Name: Out of Service
Domains:
• DESCRIPTION:
  Inherited
• TYPE:
  Inherited
• INSTALLDATE:
  Inherited
• MANUFACTURER:
  Inherited
• OPERABLE:
  Inherited
• SUBDIVISION:
  Inherited
• CONTRACTOR:
  Inherited
• INSGPSDATE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Out of Service
  Description:
  Prototype:
  LastInspectedDate: null
  LastInspectedBy: null
  DESCRIPTION: FH
  TYPE: null
  INSTALLDATE: null
  MANUFACTURER: null
  DISTANCE: null
  LOCDESC: null
  OPERABLE: 1
  LASTFLUSHED: null
  FLOW_GPM: null
  SUBDIVISION: null
  SUBPHASE: null
  CONTRACTOR: null
  PROJECTNUMBER: null
  CIPNUMBER: null
  INSGPSDATE: null
  DATE_ENTERED: null
  HYDRANTNUMBER: null
  PID: null
  NOTES: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  FACILITYID: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  STATUS: Out of Service
  CondIndex: null
  InstallYear: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Private
Name: Private
Domains:
• DESCRIPTION:
  Inherited
• TYPE:
  Inherited
• INSTALLDATE:
  Inherited
• MANUFACTURER:
  Inherited
• OPERABLE:
  Inherited
• SUBDIVISION:
  Inherited
• CONTRACTOR:
  Inherited
• INSGPSDATE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Private
  Description:
  Prototype:
  LastInspectedDate: null
  LastInspectedBy: null
  DESCRIPTION: FH
  TYPE: null
  INSTALLDATE: null
  MANUFACTURER: null
  DISTANCE: null
  LOCDESC: null
  OPERABLE: 1
  LASTFLUSHED: null
  FLOW_GPM: null
  SUBDIVISION: null
  SUBPHASE: null
  CONTRACTOR: null
  PROJECTNUMBER: null
  CIPNUMBER: null
  INSGPSDATE: null
  DATE_ENTERED: null
  HYDRANTNUMBER: null
  PID: null
  NOTES: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  FACILITYID: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  STATUS: Private
  CondIndex: null
  InstallYear: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: To Be Flushed
Name: To Be Flushed
Domains:
• DESCRIPTION:
  Inherited
• TYPE:
  Inherited
• INSTALLDATE:
  Inherited
• MANUFACTURER:
  Inherited
• OPERABLE:
  Inherited
• SUBDIVISION:
  Inherited
• CONTRACTOR:
  Inherited
• INSGPSDATE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: To Be Flushed
  Description:
  Prototype:
  LastInspectedDate: null
  LastInspectedBy: null
  DESCRIPTION: FH
  TYPE: null
  INSTALLDATE: null
  MANUFACTURER: null
  DISTANCE: null
  LOCDESC: null
  OPERABLE: 1
  LASTFLUSHED: null
  FLOW_GPM: null
  SUBDIVISION: null
  SUBPHASE: null
  CONTRACTOR: null
  PROJECTNUMBER: null
  CIPNUMBER: null
  INSGPSDATE: null
  DATE_ENTERED: null
  HYDRANTNUMBER: null
  PID: null
  NOTES: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  FACILITYID: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  STATUS: To Be Flushed
  CondIndex: null
  InstallYear: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata