View In:   ArcGIS Online Map Viewer

Name: Water: Hydrant

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The datasets provides a geographic location of water fire hydrants, fire blowoffs, fire department connections, and dry standpipes within the City of Redmond city limits and in the UPD (Urban Planned Development) areas located east of Redmond. The locations of the hydrants were derived from field verification, paper and electronic record drawings, and/or construction drawings. Mapping of the water hydrants was initiated in 1995 by the Water/Wastewater Engineering Division. The initial mapping occurred within Microstation (Bentley, Inc.) software environment and Lynx (Ch2MHill Engineering). Lynx was an AM/FM (automated mapping facility management) add-on to Microstation. Also, portion of the water system maintained by the former Rose Hill Water District was imported into the Lynx system. The Rose Hill portion of the water system was originally in AutoCAD (dwg) format. Accuracy and mapping techniques for that portion of the water system is unknown. In 2004 the data were migrated to GeoMedia and SQL Server 2000 database. The dataset is being maintained on daily basis by the GIS Services group

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2400

Max Scale: 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: 1311898.8072205484
YMin: 224384.95850764215
XMax: 1369237.1354570538
YMax: 267028.7957919687
Spatial Reference: 2926  (2926)  VCSWkid(5702)  LatestVCSWkid(5702)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [150, 173, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: AssetID )
• d_AssetType ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: d_AssetType , Coded Values: [Aquatic: Aquatic] , [Art: Art] , [Building: Building] , ...69 more... )
• d_Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: false, length: 6, defaultValue: ACT, modelName: d_Status , Coded Values: [ACT: Active] , [CONST: Construction] , [ABN: Abandon] , ...3 more... )
• d_Ownership ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: false, length: 6, defaultValue: UNK, modelName: d_Ownership , Coded Values: [RED: City of Redmond] , [PVT: Private] , [KCO: King County] , ...15 more... )
• d_MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 6, defaultValue: UNK, modelName: d_MaintainedBy , Coded Values: [CORPK: City of Redmond Parks Department] , [CORSM: City of Redmond Stormwater Department] , [CORST: City of Redmond Street Department] , ...19 more... )
• d_HydrantType ( type: esriFieldTypeString, alias: Type, editable: true, nullable: false, length: 12, defaultValue: UNK, modelName: d_HydrantType , Coded Values: [FIRE_HYD: Fire Hydrant] , [FDC_SNDP: Fire Department Connection Standpipe] , [FDC_WSNDP: Fire Department Connection Wall Mounted] , ...3 more... )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elevation )
• d_StorzFitting ( type: esriFieldTypeString, alias: Storz Fitting, editable: true, nullable: false, length: 3, defaultValue: UNK, modelName: d_StorzFitting , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• d_PressureZone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: false, length: 6, defaultValue: 0, modelName: d_PressureZone , Coded Values: [238: 238] , [300: 300] , [315: 315] , ...24 more... )
• InstallYear ( type: esriFieldTypeString, alias: Install Year, editable: true, nullable: true, length: 4, defaultValue: null, modelName: InstallYear )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectName )
• RecordDrawing ( type: esriFieldTypeString, alias: Record Drawing, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RecordDrawing )
• RecordDrawing1 ( type: esriFieldTypeString, alias: Record Drawing 1, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RecordDrawing1 )
• RecordDrawing2 ( type: esriFieldTypeString, alias: Record Drawing 2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RecordDrawing2 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Water: Hydrant
  Description:
  Prototype:
  RecordDrawing2: null
  AssetID: null
  d_AssetType: null
  d_Status: ACT
  d_Ownership: UNK
  d_MaintainedBy: UNK
  d_HydrantType: UNK
  Elevation: null
  d_StorzFitting: UNK
  d_PressureZone: 0
  InstallYear: null
  ProjectName: null
  RecordDrawing: null
  RecordDrawing1: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata