View In:   ArcGIS Online Map Viewer

Name: Fire Hydrants

Display Field: JURISDICTION

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>INTERNAL NOTES:</SPAN></P><P><SPAN>Data Manager: Water Resources Department (Mike Vradenberg)</SPAN></P><P><SPAN>The GIS Office assigns the hydrant IDs in this data layer. There are four fields that need to be completed in order to complete this process: QTR_NO; ID; QUARTER; QTR_LBL. All other fields are filled out and maintained by the WR Department. The hydrant ID is comprised of the </SPAN><SPAN STYLE="font-weight:bold;">Quarter Number </SPAN><SPAN>(space) Quarter Section Number (space) </SPAN><SPAN STYLE="font-style:italic;">Quarter section letter &amp; hydrant number</SPAN><SPAN>. An example of this ID is: </SPAN><SPAN STYLE="font-weight:bold;">103 </SPAN><SPAN>12</SPAN><SPAN STYLE="font-style:italic;">c004</SPAN><SPAN>. The spaces in between the three components are necessary!</SPAN></P><P><SPAN>A script to auto-populate these fields may be helpful; however less than 50 hydrants a month are newly created or updated with new hydrant IDs.</SPAN></P><P><SPAN>Rotation</SPAN><SPAN STYLE="font-weight:bold;">: internal use only</SPAN><SPAN>. How many turns for Isolation valve shut off </SPAN><SPAN STYLE="font-weight:bold;">*</SPAN></P></DIV></DIV></DIV>

Copyright Text: City of Bakersfield

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

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: true

Supports Datum Transformation: true

Extent:

XMin: 6204272.819353357
YMin: 2274074.271023929
XMax: 6317953.918762356
YMax: 2353660.5652631074
Spatial Reference: 102645  (2229)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [79, 150, 158, 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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• JURISDICTION ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 11, defaultValue: null, modelName: JURISDICTION , Coded Values: [COB: CITY OF BAKERSFIELD] , [KC: KERN COUNTY] , [COS: CITY OF SHAFTER] )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COMMENT )
• QTR_NO ( type: esriFieldTypeString, alias: QTR NO, editable: true, nullable: true, length: 5, defaultValue: null, modelName: QTR_NO )
• ID ( type: esriFieldTypeString, alias: ID, editable: true, nullable: true, length: 11, defaultValue: null, modelName: ID )
• QUARTER ( type: esriFieldTypeString, alias: Quarter, editable: true, nullable: true, length: 1, defaultValue: null, modelName: QUARTER )
• QTR_LBL ( type: esriFieldTypeString, alias: Quarter Label, editable: true, nullable: true, length: 5, defaultValue: null, modelName: QTR_LBL )
• RESIDUAL_PRESSURE ( type: esriFieldTypeSmallInteger, alias: Residual Pressure, editable: true, nullable: true, defaultValue: null, modelName: RESIDUAL_PRESSURE )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 52, defaultValue: null, modelName: ADDRESS )
• STREET ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 45, defaultValue: null, modelName: STREET )
• INSTALLED ( type: esriFieldTypeDate, alias: Date Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLED )
• RETESTED ( type: esriFieldTypeDate, alias: Retested, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RETESTED )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NOTES )
• SHUTOFF ( type: esriFieldTypeString, alias: Shutoff Location, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SHUTOFF )
• GPM ( type: esriFieldTypeSmallInteger, alias: Gallons Per Minute, editable: true, nullable: true, defaultValue: null, modelName: GPM )
• PITOT ( type: esriFieldTypeSmallInteger, alias: Pitot, editable: true, nullable: true, defaultValue: null, modelName: PITOT )
• STATIC_PRESSURE ( type: esriFieldTypeSmallInteger, alias: Static Pressure, editable: true, nullable: true, defaultValue: null, modelName: STATIC_PRESSURE )
• MAIN_SIZE ( type: esriFieldTypeString, alias: Main Size (Inches), editable: true, nullable: true, length: 2, defaultValue: null, modelName: MAIN_SIZE , Coded Values: [06: 06] , [08: 08] , [10: 10] , ...4 more... )
• WATER_CO ( type: esriFieldTypeString, alias: Water Co, editable: true, nullable: true, length: 16, defaultValue: null, modelName: WATER_CO , Coded Values: [C.O.B: City of Bakersfield] , [CAL WATER: California Water Company] , [EAST NILES: East Niles Water Company] , ...12 more... )
• MAKE ( type: esriFieldTypeString, alias: Make, editable: true, nullable: true, length: 7, defaultValue: null, modelName: MAKE , Coded Values: [CLOW: Clow Valve Corporation] , [JONES: Jame Jones Company] , [LBIW: Long Beach Iron Works] , ...4 more... )
• TYPE ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TYPE , Coded Values: [850: 850] , [425: 425] , [3711: 3711] , ...2 more... )
• ORDER_TEST ( type: esriFieldTypeString, alias: Order of Test, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ORDER_TEST )
• PROJECT ( type: esriFieldTypeString, alias: Project, editable: true, nullable: true, length: 22, defaultValue: null, modelName: PROJECT )
• OUTLET_2HALF_INCH ( type: esriFieldTypeString, alias: Outlet 2 Half Inch, editable: true, nullable: true, length: 1, defaultValue: null, modelName: OUTLET_2HALF_INCH )
• OUTLET_4INCH ( type: esriFieldTypeString, alias: Outlet 4 Inch, editable: true, nullable: true, length: 1, defaultValue: null, modelName: OUTLET_4INCH )
• WHARF_VALVE ( type: esriFieldTypeString, alias: Wharf Valve, editable: true, nullable: true, length: 1, defaultValue: null, modelName: WHARF_VALVE )
• CALLED_SERVICE_DATE ( type: esriFieldTypeDate, alias: Called in Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CALLED_SERVICE_DATE )
• HM_STATION ( type: esriFieldTypeString, alias: Hydrant Maintenance Station, editable: true, nullable: true, length: 4, defaultValue: null, modelName: HM_STATION )
• HM_SHIFT ( type: esriFieldTypeString, alias: Hydrant Maintenance Shift, editable: true, nullable: true, length: 2, defaultValue: null, modelName: HM_SHIFT )
• LAST_SERVICED ( type: esriFieldTypeDate, alias: Last Serviced, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_SERVICED )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Fire Hydrants
  Description:
  Prototype:
  LAST_SERVICED: null
  JURISDICTION: null
  COMMENT: null
  QTR_NO: null
  ID: null
  QUARTER: null
  QTR_LBL: null
  RESIDUAL_PRESSURE: null
  ADDRESS: null
  STREET: null
  INSTALLED: null
  RETESTED: null
  NOTES: null
  SHUTOFF: null
  GPM: null
  PITOT: null
  STATIC_PRESSURE: null
  MAIN_SIZE: null
  WATER_CO: null
  MAKE: null
  TYPE: null
  ORDER_TEST: null
  PROJECT: null
  OUTLET_2HALF_INCH: null
  OUTLET_4INCH: null
  WHARF_VALVE: null
  CALLED_SERVICE_DATE: null
  HM_STATION: null
  HM_SHIFT: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

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   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata