View In:   ArcGIS Online Map Viewer

Name: FireFlowTest_Publish

Display Field: syshydname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><P><SPAN>Fire Flow Tests. The City of Hayward regularly performs fire hydrant flow tests throughout the City to provide estimates of water system flow and pressure, also known as fire flow data. This data may be required for development projects, fire suppression system designs, and irrigation system designs.</SPAN></P></DIV>

Service Item Id: 56858fc9283a45bdb102f11def639601

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: -1.35983221742E7
YMin: 4523940.327821194
XMax: -1.35800004571E7
YMax: 4537686.147353718
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 132, 168, 255]
Size: 5.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: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• testnum ( type: esriFieldTypeSmallInteger, alias: Test Number, editable: true, nullable: true, defaultValue: null, modelName: testnum )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FacilityID )
• static_residual_hydrantnum ( type: esriFieldTypeString, alias: Static & Residual Hydrant Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: static_residual_hydrantnum )
• pitot_hydrant_num ( type: esriFieldTypeString, alias: Pitot Hydrant Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: pitot_hydrant_num )
• test_date ( type: esriFieldTypeDate, alias: Test Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: test_date )
• approximate_location ( type: esriFieldTypeString, alias: Approximate Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: approximate_location )
• longitude_1 ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: longitude_1 )
• latitude_1 ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: latitude_1 )
• static_press_psi ( type: esriFieldTypeSmallInteger, alias: Static Pressure (psi), editable: true, nullable: true, defaultValue: null, modelName: static_press_psi )
• residual_press_psi ( type: esriFieldTypeSmallInteger, alias: Residual Pressure (psi), editable: true, nullable: true, defaultValue: null, modelName: residual_press_psi )
• pitot_press_psi ( type: esriFieldTypeSmallInteger, alias: Pitot Pressure (psi), editable: true, nullable: true, defaultValue: null, modelName: pitot_press_psi )
• orifice_diam_in ( type: esriFieldTypeDouble, alias: Orifice Diameter (in), editable: true, nullable: true, defaultValue: null, modelName: orifice_diam_in )
• observed_discharge_gpm ( type: esriFieldTypeDouble, alias: Observed Discharge (gpm), editable: true, nullable: true, defaultValue: null, modelName: observed_discharge_gpm )
• est_discharge_20_psi_gpm ( type: esriFieldTypeDouble, alias: Estimated Discharge @20 psi (gpm), editable: true, nullable: true, defaultValue: null, modelName: est_discharge_20_psi_gpm )
• testdateshorttext ( type: esriFieldTypeString, alias: Test Date, editable: true, nullable: true, length: 20, defaultValue: null, modelName: testdateshorttext )
• addrnum ( type: esriFieldTypeString, alias: AddrNum, editable: true, nullable: true, length: 255, defaultValue: null, modelName: addrnum )
• street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 255, defaultValue: null, modelName: street )
• cross_st_ ( type: esriFieldTypeString, alias: Cross_St, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cross_st_ )
• location_description ( type: esriFieldTypeString, alias: Location_Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: location_description )
• record_dwg_no_ ( type: esriFieldTypeString, alias: RecordDrawing, editable: true, nullable: true, length: 255, defaultValue: null, modelName: record_dwg_no_ )
• remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 255, defaultValue: null, modelName: remarks )
• lateralid ( type: esriFieldTypeInteger, alias: LateralID, editable: true, nullable: true, defaultValue: null, modelName: lateralid )
• point_x ( type: esriFieldTypeDouble, alias: POINT_X, editable: true, nullable: true, defaultValue: null, modelName: point_x )
• point_y ( type: esriFieldTypeDouble, alias: POINT_Y, editable: true, nullable: true, defaultValue: null, modelName: point_y )
• syshydname ( type: esriFieldTypeString, alias: SysHydName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: syshydname )
• installyear ( type: esriFieldTypeString, alias: InstallYear, editable: true, nullable: true, length: 10, defaultValue: null, modelName: installyear )
• fh_mfg ( type: esriFieldTypeString, alias: FH_Mfg, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fh_mfg )
• fh_model ( type: esriFieldTypeString, alias: FH_Model, editable: true, nullable: true, length: 100, defaultValue: null, modelName: fh_model )
• inservice ( type: esriFieldTypeString, alias: InService, editable: true, nullable: true, length: 10, defaultValue: null, modelName: inservice )
• mapbookpage ( type: esriFieldTypeString, alias: MapbookPage, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mapbookpage )
• abandoned ( type: esriFieldTypeString, alias: Abandoned, editable: true, nullable: true, length: 10, defaultValue: null, modelName: abandoned )
• subtype2 ( type: esriFieldTypeInteger, alias: Subtype2, editable: true, nullable: true, defaultValue: 3, modelName: subtype2 )
• objrevisedate ( type: esriFieldTypeDate, alias: Date Object Revised, editable: true, nullable: true, length: 8, defaultValue: null, modelName: objrevisedate )
• x_nad27 ( type: esriFieldTypeDouble, alias: X_NAD27, editable: true, nullable: true, defaultValue: null, modelName: x_nad27 )
• y_nad27 ( type: esriFieldTypeDouble, alias: Y_NAD27, editable: true, nullable: true, defaultValue: null, modelName: y_nad27 )
• latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: latitude )
• longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: longitude )
• ownership ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 20, defaultValue: COH, modelName: ownership )
• transsyshydrant ( type: esriFieldTypeSmallInteger, alias: TransSysHydrant, editable: true, nullable: true, defaultValue: 0, modelName: transsyshydrant )
• esrignss_receiver ( type: esriFieldTypeString, alias: Receiver Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: esrignss_receiver )
• eoslaser_method ( type: esriFieldTypeString, alias: Measurement Method, editable: true, nullable: true, length: 30, defaultValue: null, modelName: eoslaser_method )
• esrignss_latitude ( type: esriFieldTypeDouble, alias: Offset Point Latitude, editable: true, nullable: true, defaultValue: null, modelName: esrignss_latitude )
• esrignss_longitude ( type: esriFieldTypeDouble, alias: Offset Point Longitude, editable: true, nullable: true, defaultValue: null, modelName: esrignss_longitude )
• esrignss_altitude ( type: esriFieldTypeDouble, alias: Offset Point HAE (ellipsoidal), editable: true, nullable: true, defaultValue: null, modelName: esrignss_altitude )
• eos_ortho_height ( type: esriFieldTypeDouble, alias: Orthometric Height, editable: true, nullable: true, defaultValue: null, modelName: eos_ortho_height )
• eos_undulation ( type: esriFieldTypeDouble, alias: Altitude Undulation, editable: true, nullable: true, defaultValue: null, modelName: eos_undulation )
• eos_geoid_model ( type: esriFieldTypeString, alias: Geoid Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: eos_geoid_model )
• eoslaser_device ( type: esriFieldTypeString, alias: Bluetooth Laser Device, editable: true, nullable: true, length: 50, defaultValue: null, modelName: eoslaser_device )
• eoslaser_gnssanth ( type: esriFieldTypeDouble, alias: GNSS Antenna Height, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_gnssanth )
• eoslaser_deviceh ( type: esriFieldTypeDouble, alias: Laser Device Height, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_deviceh )
• eoslaser_magdec ( type: esriFieldTypeDouble, alias: Magnetic Declination, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_magdec )
• eoslaser_ctl1_lat ( type: esriFieldTypeDouble, alias: CP1 Latitude, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl1_lat )
• eoslaser_ctl1_lon ( type: esriFieldTypeDouble, alias: CP1 Longitude, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl1_lon )
• eoslaser_ctl1_alt ( type: esriFieldTypeDouble, alias: CP1 Altitude, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl1_alt )
• eoslaser_ctl1_hrms ( type: esriFieldTypeDouble, alias: CP1 HRMS, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl1_hrms )
• eoslaser_ctl1_sats ( type: esriFieldTypeSmallInteger, alias: CP1 Number of Sats, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl1_sats )
• eoslaser_ctl1_fixtype ( type: esriFieldTypeSmallInteger, alias: CP1 Fix Type, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl1_fixtype , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• eoslaser_ctl1_age ( type: esriFieldTypeDouble, alias: CP1 Diff Age, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl1_age )
• eoslaser_ctl1_diffid ( type: esriFieldTypeString, alias: CP1 Station ID, editable: true, nullable: true, length: 4, defaultValue: null, modelName: eoslaser_ctl1_diffid )
• eoslaser_ctl1_avg ( type: esriFieldTypeSmallInteger, alias: CP1 Points Averaged, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl1_avg )
• eoslaser_ctl1_sldist ( type: esriFieldTypeDouble, alias: CP1 Laser Slope Distance, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl1_sldist )
• eoslaser_ctl1_azi ( type: esriFieldTypeDouble, alias: CP1 Laser Azimuth, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl1_azi )
• eoslaser_ctl1_sl ( type: esriFieldTypeDouble, alias: CP1 Laser Inclination, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl1_sl )
• eoslaser_bs_lat ( type: esriFieldTypeDouble, alias: Backsight Latitude, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_lat )
• eoslaser_bs_lon ( type: esriFieldTypeDouble, alias: Backsight Longitude, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_lon )
• eoslaser_bs_alt ( type: esriFieldTypeDouble, alias: Backsight Altitude, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_alt )
• eoslaser_bs_hrms ( type: esriFieldTypeDouble, alias: Backsight HRMS, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_hrms )
• eoslaser_bs_sats ( type: esriFieldTypeSmallInteger, alias: Backsight Number of Sats, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_sats )
• eoslaser_bs_fixtype ( type: esriFieldTypeSmallInteger, alias: Backsight Fix Type, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_fixtype , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• eoslaser_bs_age ( type: esriFieldTypeDouble, alias: Backsight Diff Age, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_age )
• eoslaser_bs_diffid ( type: esriFieldTypeString, alias: Backsight Station ID, editable: true, nullable: true, length: 4, defaultValue: null, modelName: eoslaser_bs_diffid )
• eoslaser_bs_avg ( type: esriFieldTypeSmallInteger, alias: Backsight Points Averaged, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_avg )
• eoslaser_bs_sldist ( type: esriFieldTypeDouble, alias: Backsight Slope Distance, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_sldist )
• eoslaser_bs_azi ( type: esriFieldTypeDouble, alias: Backsight Azimuth, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_azi )
• eoslaser_bs_sl ( type: esriFieldTypeDouble, alias: Backsight Inclination, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_sl )
• eoslaser_bs_trueazi ( type: esriFieldTypeDouble, alias: Computed True Azimuth, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_trueazi )
• eoslaser_bs_azicorr ( type: esriFieldTypeDouble, alias: Azimuth Correction, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_bs_azicorr )
• eoslaser_ctl2_lat ( type: esriFieldTypeDouble, alias: CP2 Latitude, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl2_lat )
• eoslaser_ctl2_lon ( type: esriFieldTypeDouble, alias: CP2 Longitude, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl2_lon )
• eoslaser_ctl2_alt ( type: esriFieldTypeDouble, alias: CP2 Altitude, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl2_alt )
• eoslaser_ctl2_hrms ( type: esriFieldTypeDouble, alias: CP2 HRMS, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl2_hrms )
• eoslaser_ctl2_sats ( type: esriFieldTypeSmallInteger, alias: CP2 Number of Sats, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl2_sats )
• eoslaser_ctl2_fixtype ( type: esriFieldTypeSmallInteger, alias: CP2 Fix Type, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl2_fixtype , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• eoslaser_ctl2_age ( type: esriFieldTypeDouble, alias: CP2 Differential Age, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl2_age )
• eoslaser_ctl2_diffid ( type: esriFieldTypeString, alias: CP2 Station ID, editable: true, nullable: true, length: 4, defaultValue: null, modelName: eoslaser_ctl2_diffid )
• eoslaser_ctl2_avg ( type: esriFieldTypeSmallInteger, alias: CP2 Points Averaged, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl2_avg )
• eoslaser_ctl2_sldist ( type: esriFieldTypeDouble, alias: CP2 Laser Slope Distance, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl2_sldist )
• eoslaser_ctl2_azi ( type: esriFieldTypeDouble, alias: CP2 Laser Azimuth, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl2_azi )
• eoslaser_ctl2_sl ( type: esriFieldTypeDouble, alias: CP2 Laser Inclination, editable: true, nullable: true, defaultValue: null, modelName: eoslaser_ctl2_sl )
• orthometricheight_ft ( type: esriFieldTypeDouble, alias: Orthometric Height Feet, editable: true, nullable: true, defaultValue: null, modelName: orthometricheight_ft )
• 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 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, 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 )
• creationdate ( type: esriFieldTypeDate, alias: CreationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: creationdate )
• creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 255, defaultValue: null, modelName: creator )
• editdate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: editdate )
• editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: editor )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Fire Flow Test
  Description:
  Prototype:
  last_edited_date: null
  editor: null
  testnum: null
  FacilityID: null
  static_residual_hydrantnum: null
  pitot_hydrant_num: null
  test_date: null
  approximate_location: null
  longitude_1: null
  latitude_1: null
  static_press_psi: null
  residual_press_psi: null
  pitot_press_psi: null
  orifice_diam_in: null
  observed_discharge_gpm: null
  est_discharge_20_psi_gpm: null
  testdateshorttext: null
  addrnum: null
  street: null
  cross_st_: null
  location_description: null
  record_dwg_no_: null
  remarks: null
  lateralid: null
  point_x: null
  point_y: null
  syshydname: null
  installyear: null
  fh_mfg: null
  fh_model: null
  inservice: null
  mapbookpage: null
  abandoned: null
  subtype2: 3
  objrevisedate: null
  x_nad27: null
  y_nad27: null
  latitude: null
  longitude: null
  ownership: COH
  transsyshydrant: 0
  esrignss_receiver: null
  eoslaser_method: null
  esrignss_latitude: null
  esrignss_longitude: null
  esrignss_altitude: null
  eos_ortho_height: null
  eos_undulation: null
  eos_geoid_model: null
  eoslaser_device: null
  eoslaser_gnssanth: null
  eoslaser_deviceh: null
  eoslaser_magdec: null
  eoslaser_ctl1_lat: null
  eoslaser_ctl1_lon: null
  eoslaser_ctl1_alt: null
  eoslaser_ctl1_hrms: null
  eoslaser_ctl1_sats: null
  eoslaser_ctl1_fixtype: null
  eoslaser_ctl1_age: null
  eoslaser_ctl1_diffid: null
  eoslaser_ctl1_avg: null
  eoslaser_ctl1_sldist: null
  eoslaser_ctl1_azi: null
  eoslaser_ctl1_sl: null
  eoslaser_bs_lat: null
  eoslaser_bs_lon: null
  eoslaser_bs_alt: null
  eoslaser_bs_hrms: null
  eoslaser_bs_sats: null
  eoslaser_bs_fixtype: null
  eoslaser_bs_age: null
  eoslaser_bs_diffid: null
  eoslaser_bs_avg: null
  eoslaser_bs_sldist: null
  eoslaser_bs_azi: null
  eoslaser_bs_sl: null
  eoslaser_bs_trueazi: null
  eoslaser_bs_azicorr: null
  eoslaser_ctl2_lat: null
  eoslaser_ctl2_lon: null
  eoslaser_ctl2_alt: null
  eoslaser_ctl2_hrms: null
  eoslaser_ctl2_sats: null
  eoslaser_ctl2_fixtype: null
  eoslaser_ctl2_age: null
  eoslaser_ctl2_diffid: null
  eoslaser_ctl2_avg: null
  eoslaser_ctl2_sldist: null
  eoslaser_ctl2_azi: null
  eoslaser_ctl2_sl: null
  orthometricheight_ft: null
  creator: null
  creationdate: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: editdate
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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