View In:   ArcGIS Online Map Viewer

Name: Preliminary Water Hydrants

Display Field: REFNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -1.078767784168708E7
YMin: 5900442.209794915
XMax: -1.0771386372177038E7
YMax: 5936976.552801367
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: REFNAME
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: HYD
  Label: Hydrant
  Description: N/A
  Symbol:
  
• Value: HWGV
  Label: Hydrant with Gate Valve
  Description: N/A
  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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: REFNAME

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FHNumber ( type: esriFieldTypeString, alias: FHNumber, editable: true, nullable: true, length: 16, defaultValue: null, modelName: FHNumber )
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 16, defaultValue: null, modelName: ProjectNumber )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, editable: true, nullable: true, length: 25, defaultValue: null, modelName: YearInstalled )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectRetired )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YearRetired )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 25, defaultValue: Red, modelName: Type , Coded Values: [Red: Red] , [Yellow: Yellow] , [Private: Private] )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Material )
• Diameter ( type: esriFieldTypeString, alias: Diameter, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Diameter )
• Elevation ( type: esriFieldTypeString, alias: Elevation(TOB), editable: true, nullable: true, length: 16, defaultValue: null, modelName: Elevation )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Datum ( type: esriFieldTypeString, alias: Datum, editable: true, nullable: true, length: 50, defaultValue: 1988, modelName: Datum , Coded Values: [1988: U.S.G.S. Vertical Datum of 1988] , [Fargo: City of Fargo Datum] , [1927: U.S.G.S. Vertical Datum of 1927] )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MFG , Coded Values: [American Darling: American Darling] , [Pacer: Pacer] , [5" Waterous: 5" Waterous] , ...3 more... )
• Unit ( type: esriFieldTypeString, alias: Unit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Unit , Coded Values: [801: 801] , [802: 802] , [803: 803] , ...7 more... )
• Shift ( type: esriFieldTypeString, alias: Shift, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Shift , Coded Values: [A: A] , [B: B] , [C: C] , ...1 more... )
• Occupant ( type: esriFieldTypeString, alias: Occupant, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Occupant )
• HydrantLocation ( type: esriFieldTypeString, alias: HydrantLocation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HydrantLocation )
• PrivateHydrant ( type: esriFieldTypeString, alias: PrivateHydrant, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PrivateHydrant , Coded Values: [Y: Yes] , [YPF: Yes Permission Notify First] , [YPC: Yes Permission Owner Will Flush] , ...2 more... )
• PrivateOwnerInformation ( type: esriFieldTypeString, alias: PrivateOwnerInformation, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PrivateOwnerInformation )
• OutOfService ( type: esriFieldTypeSmallInteger, alias: OutOfService, editable: true, nullable: true, defaultValue: 0, modelName: OutOfService , Coded Values: [1: Yes] , [0: No] )
• NeedsRepair ( type: esriFieldTypeSmallInteger, alias: NeedsRepair, editable: true, nullable: true, defaultValue: 0, modelName: NeedsRepair , Coded Values: [1: Yes] , [0: No] )
• DateFlushed ( type: esriFieldTypeDate, alias: DateFlushed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateFlushed )
• MarkerMissing ( type: esriFieldTypeSmallInteger, alias: MarkerMissing, editable: true, nullable: true, defaultValue: 0, modelName: MarkerMissing , Coded Values: [0: No] , [1: Yes] , [2: NA] )
• CapsMissing ( type: esriFieldTypeSmallInteger, alias: CapsMissing, editable: true, nullable: true, defaultValue: 0, modelName: CapsMissing , Coded Values: [1: Yes] , [0: No] )
• IDTagMissing ( type: esriFieldTypeSmallInteger, alias: IDTagMissing, editable: true, nullable: true, defaultValue: 0, modelName: IDTagMissing , Coded Values: [1: Yes] , [0: No] )
• Pumped ( type: esriFieldTypeSmallInteger, alias: Pumped, editable: true, nullable: true, defaultValue: 0, modelName: Pumped , Coded Values: [1: Yes] , [0: No] )
• Leaks ( type: esriFieldTypeSmallInteger, alias: Leaks, editable: true, nullable: true, defaultValue: 0, modelName: Leaks , Coded Values: [1: Yes] , [0: No] )
• DrainOK ( type: esriFieldTypeSmallInteger, alias: DrainOK, editable: true, nullable: true, defaultValue: 1, modelName: DrainOK , Coded Values: [1: Yes] , [0: No] )
• HydrantGuardAdded ( type: esriFieldTypeSmallInteger, alias: HydrantGuardAdded, editable: true, nullable: true, defaultValue: 0, modelName: HydrantGuardAdded , Coded Values: [1: Yes] , [0: No] )
• Coefficient ( type: esriFieldTypeDouble, alias: Coefficient, editable: true, nullable: true, defaultValue: null, modelName: Coefficient )
• FireRemarks ( type: esriFieldTypeString, alias: FireRemarks, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FireRemarks )
• WaterJurisdiction ( type: esriFieldTypeString, alias: WaterJurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterJurisdiction )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• ID ( type: esriFieldTypeString, alias: ID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: ID )
• LAYER ( type: esriFieldTypeString, alias: LAYER, editable: true, nullable: true, length: 254, defaultValue: X_WM_struct, modelName: Layer )
• CADTYPE ( type: esriFieldTypeString, alias: CADTYPE, editable: true, nullable: true, length: 25, defaultValue: INSERT, modelName: CADTYPE )
• REFNAME ( type: esriFieldTypeString, alias: REFNAME, editable: true, nullable: true, length: 25, defaultValue: null, modelName: REFNAME )
• JOINFIELD ( type: esriFieldTypeInteger, alias: JOINFIELD, editable: true, nullable: true, defaultValue: null, modelName: JOINFIELD )
• SYMBOL_ROTATION ( type: esriFieldTypeDouble, alias: SYMBOL_ROTATION, editable: true, nullable: true, defaultValue: null, modelName: SYMBOL_ROTATION )
• 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 )

Types:

ID: HYD
Name: Hydrant
Domains:
• Type:
  Inherited
• Datum:
  Inherited
• Status:
  Inherited
• Manufacturer:
  Inherited
• Unit:
  Inherited
• Shift:
  Inherited
• PrivateHydrant:
  Inherited
• OutOfService:
  Inherited
• NeedsRepair:
  Inherited
• MarkerMissing:
  Inherited
• CapsMissing:
  Inherited
• IDTagMissing:
  Inherited
• Pumped:
  Inherited
• Leaks:
  Inherited
• DrainOK:
  Inherited
• HydrantGuardAdded:
  Inherited
Templates:
• Name: Hydrant
  Description:
  Prototype:
  CapsMissing: 0
  OutOfService: 0
  DrainOK: 1
  CADTYPE: INSERT
  IDTagMissing: 0
  PrivateOwnerInformation: null
  YearRetired: null
  DateFlushed: null
  LAYER: X_WM_struct
  Comments: null
  ID: null
  Pumped: 0
  MarkerMissing: 0
  Leaks: 0
  last_edited_user: null
  FHNumber: null
  ProjectNumber: null
  YearInstalled: null
  ProjectRetired: null
  Type: Red
  Material: null
  Diameter: null
  Elevation: null
  Datum: 1988
  Status: null
  Manufacturer: null
  Unit: null
  Shift: null
  Occupant: null
  HydrantLocation: null
  PrivateHydrant: null
  NeedsRepair: 0
  HydrantGuardAdded: 0
  Coefficient: null
  FireRemarks: null
  WaterJurisdiction: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  REFNAME: HYD
  JOINFIELD: null
  SYMBOL_ROTATION: null
  created_user: null
  created_date: null
  last_edited_date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: HWGV
Name: Hydrant with Gate Valve
Domains:
• Type:
  Inherited
• Datum:
  Inherited
• Status:
  Inherited
• Manufacturer:
  Inherited
• Unit:
  Inherited
• Shift:
  Inherited
• PrivateHydrant:
  Inherited
• OutOfService:
  Inherited
• NeedsRepair:
  Inherited
• MarkerMissing:
  Inherited
• CapsMissing:
  Inherited
• IDTagMissing:
  Inherited
• Pumped:
  Inherited
• Leaks:
  Inherited
• DrainOK:
  Inherited
• HydrantGuardAdded:
  Inherited
Templates:
• Name: Hydrant with Gate Valve
  Description:
  Prototype:
  CapsMissing: 0
  OutOfService: 0
  DrainOK: 1
  CADTYPE: INSERT
  IDTagMissing: 0
  PrivateOwnerInformation: null
  YearRetired: null
  DateFlushed: null
  LAYER: X_WM_struct
  Comments: null
  ID: null
  Pumped: 0
  MarkerMissing: 0
  Leaks: 0
  last_edited_user: null
  FHNumber: null
  ProjectNumber: null
  YearInstalled: null
  ProjectRetired: null
  Type: Red
  Material: null
  Diameter: null
  Elevation: null
  Datum: 1988
  Status: null
  Manufacturer: null
  Unit: null
  Shift: null
  Occupant: null
  HydrantLocation: null
  PrivateHydrant: null
  NeedsRepair: 0
  HydrantGuardAdded: 0
  Coefficient: null
  FireRemarks: null
  WaterJurisdiction: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  REFNAME: HWGV
  JOINFIELD: null
  SYMBOL_ROTATION: null
  created_user: null
  created_date: null
  last_edited_date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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