View In:   ArcGIS Online Map Viewer

Name: wHydrant

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This point feature class identifies the approximate locations of existing fire hydrants for the City of Oceanside's potable water distribution system owned, operated, and maintained by the Water Utilities Department and private water distribution pipe lines that connect into the City's system. All feature locations and attributes are maintained by the Water Utilities- Geographic Information System (GIS) division and are derived from input from the City field crew as well as various engineering and construction exhibits (e.g. As Built, Development Drawings, Subdivision Drawings, etc.). The City of Oceanside has no maintenance responsibility for private hydrants; which are normally maintained by Homeowner Associations or private owners.</SPAN></P></DIV></DIV></DIV>

Service Item Id: c0057a63ed8e4fbdb83f9f78b17e2b05

Copyright Text: City of Oceanside, Water Utilities; GIS Division

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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: 6210577.142715533
YMin: 2000962.4124548086
XMax: 6257248.818504349
YMax: 2054212.342516647
Spatial Reference: 102646  (2230)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [168, 37, 117, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 9, defaultValue: null, modelName: FACILITYID )
• USAGE ( type: esriFieldTypeSmallInteger, alias: Hydrant Usage, editable: true, nullable: true, defaultValue: 1, modelName: TYPE , Coded Values: [1: Residential] , [2: Industrial] , [3: Blow-off] )
• MAINDIAMETER ( type: esriFieldTypeDouble, alias: Main Diameter, editable: true, nullable: true, defaultValue: null, modelName: MAINDIAMETER , Coded Values: [-1: Other] , [0: Unknown] , [0.75: 3/4"] , ...31 more... )
• TAPVALVDEPTH ( type: esriFieldTypeDouble, alias: Tapping Valve Depth, editable: true, nullable: true, defaultValue: null, modelName: TAPVALVDEPTH )
• MATERIAL ( type: esriFieldTypeSmallInteger, alias: Hydrant Material, editable: true, nullable: true, defaultValue: null, modelName: MATERIAL )
• HGL ( type: esriFieldTypeInteger, alias: HGL, editable: true, nullable: true, defaultValue: null, modelName: HGL )
• SYSTEM ( type: esriFieldTypeSmallInteger, alias: System, editable: true, nullable: true, defaultValue: null, modelName: SYSTEM , Coded Values: [1: Transmission] , [2: Distribution] , [3: Service Line] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [952: Parent Out of Service] , [1: True] , [0: False] )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [952: Parent Out of Service] , [1: True] , [0: False] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [-1: Private] , [-2: Other] , [1: City of Oceanside] , ...4 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [-1: Private] , [-2: Other] , [1: City of Oceanside] )
• PLANNUM ( type: esriFieldTypeString, alias: Plan Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PLANNUM )
• INSTALLYEAR ( type: esriFieldTypeInteger, alias: Install Year, editable: true, nullable: true, defaultValue: null, modelName: INSTALLYEAR )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Corey: Corey] , ...16 more... )
• PORTS ( type: esriFieldTypeSmallInteger, alias: Ports, editable: true, nullable: true, defaultValue: null, modelName: PORTS )
• PORTSIZE1 ( type: esriFieldTypeDouble, alias: Port Diameter 1, editable: true, nullable: true, defaultValue: null, modelName: PORTSIZE1 , Coded Values: [-1: Other] , [0: Unknown] , [0.75: 3/4"] , ...31 more... )
• PORTSIZE2 ( type: esriFieldTypeDouble, alias: Port Diameter 2, editable: true, nullable: true, defaultValue: null, modelName: PORTSIZE2 , Coded Values: [-1: Other] , [0: Unknown] , [0.75: 3/4"] , ...31 more... )
• PORTSIZE3 ( type: esriFieldTypeDouble, alias: Port Diameter 3, editable: true, nullable: true, defaultValue: null, modelName: PORTSIZE3 , Coded Values: [-1: Other] , [0: Unknown] , [0.75: 3/4"] , ...31 more... )
• FLOW ( type: esriFieldTypeDouble, alias: Flow Rate (GPM), editable: true, nullable: true, defaultValue: null, modelName: FLOW )
• STATICPRESSURE ( type: esriFieldTypeDouble, alias: Static Pressure, editable: true, nullable: true, defaultValue: null, modelName: STATICPRESSURE )
• FLOWPRESSURE ( type: esriFieldTypeDouble, alias: Flow Pressure, editable: true, nullable: true, defaultValue: null, modelName: FLOWPRESSURE )
• LASTSERVICE ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICE )
• GPSFLAG ( type: esriFieldTypeSmallInteger, alias: GPS Flag, editable: true, nullable: true, defaultValue: 0, modelName: GPSFLAG , Coded Values: [952: Parent Out of Service] , [1: True] , [0: False] )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• PIPEID ( type: esriFieldTypeInteger, alias: Pipe Identifier, editable: true, nullable: true, defaultValue: null, modelName: PIPEID )
• LUCITYLINK ( type: esriFieldTypeInteger, alias: LUCITYLINK, editable: true, nullable: true, defaultValue: null, modelName: LUCITYLINK )
• INLUCITY ( type: esriFieldTypeSmallInteger, alias: INLUCITY, editable: true, nullable: true, defaultValue: null, modelName: INLUCITY )
• SEQ_NO ( type: esriFieldTypeInteger, alias: SEQ_NO, editable: true, nullable: true, defaultValue: null, modelName: SEQ_NO )
• TILE_NO ( type: esriFieldTypeString, alias: TILE_NO, editable: true, nullable: true, length: 4, defaultValue: null, modelName: TILE_NO )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• SOURCEUPDATE ( type: esriFieldTypeString, alias: Source of Update, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SOURCEUPDATE )
• FEATCOMMENT ( type: esriFieldTypeString, alias: Feature Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FEATCOMMENT )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )

Templates:

• Name: wHydrant
  Description:
  Prototype:
  SOURCEUPDATE: null
  FEATCOMMENT: null
  FACILITYID: null
  USAGE: 1
  MAINDIAMETER: null
  TAPVALVDEPTH: null
  MATERIAL: null
  HGL: null
  SYSTEM: null
  ACTIVEFLAG: 1
  OPERABLE: 1
  OWNEDBY: 1
  MAINTBY: 1
  PLANNUM: null
  INSTALLYEAR: null
  INSTALLDATE: null
  MANUFACTURER: null
  PORTS: null
  PORTSIZE1: null
  PORTSIZE2: null
  PORTSIZE3: null
  FLOW: null
  STATICPRESSURE: null
  FLOWPRESSURE: null
  LASTSERVICE: null
  GPSFLAG: 0
  LOCDESC: null
  ROTATION: null
  PIPEID: null
  LUCITYLINK: null
  INLUCITY: null
  SEQ_NO: null
  TILE_NO: null
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: LASTUPDATE
• Editor Field: LASTEDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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