View In:   ArcGIS Online Map Viewer

Name: Fire Hydrant

Display Field: ROAD_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Final, new, complete Fire hydrants/Fire Connection Point dataset. This dataset was derived from the following data sources: A GIS dataset that was converted from City of Tracy AutoCAD data supplied by DES also combined with point data that was supplied by the Tracy Fire Department; Data that was collected during the June 2010 Asset Management GPS data collection efforts; data supplied in 2008 from Mountain House (MHCSD), and data that was hand-digitized from field-verified mapbooks. Last Update Date: September 2012. Attribute updates performed by KJorgensen.

Service Item Id: 064b535d1f7c4f13bd3d7d628e787101

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000

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: 6256102.060573533
YMin: 2053165.9324383587
XMax: 6305760.867504228
YMax: 2113583.8897403404
Spatial Reference: 102643  (2227)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SUBTYPEID ( type: esriFieldTypeInteger, alias: SubTypeIdentifier, editable: true, nullable: true, defaultValue: 201849, modelName: SUBTYPEID )
• FIRHYDR_ID ( type: esriFieldTypeString, alias: PKFirhydrID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: firhydr_id )
• MAP_ID ( type: esriFieldTypeInteger, alias: PKMapID, editable: true, nullable: true, defaultValue: null, modelName: map_id )
• META_ID ( type: esriFieldTypeString, alias: FKMetaID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: meta_id )
• MEDIA_ID ( type: esriFieldTypeString, alias: FKMediaID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: media_id )
• COORD_ID ( type: esriFieldTypeString, alias: FKCoordID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: coord_id )
• DATE_ACQRD ( type: esriFieldTypeInteger, alias: DateAcqrd, editable: true, nullable: true, defaultValue: null, modelName: date_acqrd )
• DISPOSTN_D ( type: esriFieldTypeString, alias: DispostnDOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: dispostn_d )
• CON_TYPE_D ( type: esriFieldTypeString, alias: ConTypeDOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: con_type_d )
• HYD_TY_D ( type: esriFieldTypeString, alias: HydTyDOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: hyd_ty_d )
• VLV_ST_D ( type: esriFieldTypeString, alias: VlvStDOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: vlv_st_d )
• SOURCE_D ( type: esriFieldTypeString, alias: SourceDOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: source_d )
• SIZE_D ( type: esriFieldTypeString, alias: SizeDOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: size_d )
• SIZE_U_D ( type: esriFieldTypeString, alias: SizeUOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: size_u_d )
• INLET_DIA ( type: esriFieldTypeDouble, alias: InletDia, editable: true, nullable: true, defaultValue: null, modelName: inlet_dia )
• OUTCON1DIA ( type: esriFieldTypeDouble, alias: Outcon1dia, editable: true, nullable: true, defaultValue: null, modelName: outcon1dia )
• OUTCON2DIA ( type: esriFieldTypeDouble, alias: Outcon2dia, editable: true, nullable: true, defaultValue: null, modelName: outcon2dia )
• OUTCON3DIA ( type: esriFieldTypeDouble, alias: Outcon3dia, editable: true, nullable: true, defaultValue: null, modelName: outcon3dia )
• DIA_U_D ( type: esriFieldTypeString, alias: DiaUOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: dia_u_d )
• MEAS_TY_D ( type: esriFieldTypeString, alias: MeasTyDOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: meas_ty_d )
• HYD_ELV ( type: esriFieldTypeDouble, alias: HydElv, editable: true, nullable: true, defaultValue: null, modelName: hyd_elv )
• GROUND_ELV ( type: esriFieldTypeDouble, alias: GroundElv, editable: true, nullable: true, defaultValue: null, modelName: ground_elv )
• ELV_U_D ( type: esriFieldTypeString, alias: ElvUOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: elv_u_d )
• PRESS_MAX ( type: esriFieldTypeDouble, alias: PressMax, editable: true, nullable: true, defaultValue: null, modelName: press_max )
• PRESS_RESD ( type: esriFieldTypeDouble, alias: PressResd, editable: true, nullable: true, defaultValue: null, modelName: press_resd )
• PRESS_STAT ( type: esriFieldTypeDouble, alias: PressStat, editable: true, nullable: true, defaultValue: null, modelName: press_stat )
• PRESS_U_D ( type: esriFieldTypeString, alias: PressUOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: press_u_d )
• FLOW_TEST ( type: esriFieldTypeInteger, alias: FlowTest, editable: true, nullable: true, defaultValue: null, modelName: flow_test )
• FLOW_U_D ( type: esriFieldTypeString, alias: FlowUOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: flow_u_d )
• MANUF_ID ( type: esriFieldTypeString, alias: FKManufID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: manuf_id )
• MODEL_NO ( type: esriFieldTypeString, alias: ModelNo, editable: true, nullable: true, length: 12, defaultValue: null, modelName: model_no )
• WATVLV_ID ( type: esriFieldTypeString, alias: FKWatvlvID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: watvlv_id )
• WATPIPE_ID ( type: esriFieldTypeString, alias: FKWatpipeID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: watpipe_id )
• INSTLN_ID ( type: esriFieldTypeString, alias: FKInstlnID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: instln_id )
• BUILDNG_ID ( type: esriFieldTypeString, alias: FKBuildngID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: buildng_id )
• PROJECT_ID ( type: esriFieldTypeString, alias: FKProjectID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: project_id )
• WATZONE_ID ( type: esriFieldTypeString, alias: FKWatzoneID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: watzone_id )
• NARRATIVE ( type: esriFieldTypeString, alias: Narrative, editable: true, nullable: true, length: 240, defaultValue: null, modelName: narrative )
• USER_FLAG ( type: esriFieldTypeString, alias: UserFlag, editable: true, nullable: true, length: 20, defaultValue: null, modelName: user_flag )
• FACIL_ID ( type: esriFieldTypeString, alias: FKFacilID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: facil_id )
• GRID_VALUE ( type: esriFieldTypeDouble, alias: GridValue, editable: true, nullable: true, defaultValue: null, modelName: grid_value )
• COORD_X ( type: esriFieldTypeDouble, alias: CoordX, editable: true, nullable: true, defaultValue: null, modelName: coord_x )
• COORD_Y ( type: esriFieldTypeDouble, alias: CoordY, editable: true, nullable: true, defaultValue: null, modelName: coord_y )
• COORD_Z ( type: esriFieldTypeDouble, alias: CoordZ, editable: true, nullable: true, defaultValue: null, modelName: coord_z )
• OWNER_ID ( type: esriFieldTypeString, alias: FKOwnerID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: owner_id )
• HYDCLASS_D ( type: esriFieldTypeString, alias: HydclassDOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: hydclass_d )
• W_UTIL_ID ( type: esriFieldTypeString, alias: FKWUtilID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: w_util_id )
• COND_D ( type: esriFieldTypeString, alias: CondDOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: cond_d )
• ROAD_NAME ( type: esriFieldTypeString, alias: RoadName, editable: true, nullable: true, length: 30, defaultValue: null, modelName: road_name )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 80, defaultValue: null, modelName: location )
• VERIFY_D ( type: esriFieldTypeString, alias: VerifyDOM, editable: true, nullable: true, length: 16, defaultValue: null, modelName: verify_d )
• UPDATE_USER ( type: esriFieldTypeString, alias: UPDATE_USER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UPDATE_USER )
• UPDATE_DATE ( type: esriFieldTypeDate, alias: UPDATE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UPDATE_DATE )
• MapbookPage ( type: esriFieldTypeString, alias: MapbookPage, editable: true, nullable: true, length: 12, defaultValue: null, modelName: MapbookPage )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• ImgName ( type: esriFieldTypeString, alias: ImgName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ImgName )
• NumOutlet ( type: esriFieldTypeInteger, alias: NumOutlet, editable: true, nullable: true, defaultValue: null, modelName: NumOutlet )
• DataSource ( type: esriFieldTypeString, alias: DataSource, editable: true, nullable: true, length: 120, defaultValue: null, modelName: DataSource )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TYPE )
• UniqueID ( type: esriFieldTypeSmallInteger, alias: UniqueID, editable: true, nullable: true, defaultValue: null, modelName: UniqueID )
• Fireflow_Test_Date ( type: esriFieldTypeDate, alias: Fireflow_Test_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Fireflow_Test_Date )
• FlowHydrantID_1 ( type: esriFieldTypeString, alias: FlowHydrantID_1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FlowHydrantID_1 )
• FlowHydrantID_2 ( type: esriFieldTypeString, alias: FlowHydrantID_2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FlowHydrantID_2 )
• PitotReading_psi ( type: esriFieldTypeDouble, alias: PitotReading_psi, editable: true, nullable: true, defaultValue: null, modelName: PitotReading_psi )
• TotalFlowGPM ( type: esriFieldTypeDouble, alias: TotalFlowGPM, editable: true, nullable: true, defaultValue: null, modelName: TotalFlowGPM )
• CalculatedFlowGPM ( type: esriFieldTypeDouble, alias: CalculatedFlowGPM, editable: true, nullable: true, defaultValue: null, modelName: CalculatedFlowGPM )
• TestHydrantID ( type: esriFieldTypeString, alias: TestHydrantID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TestHydrantID )
• FlowHydrant1GPM ( type: esriFieldTypeDouble, alias: FlowHydrant1GPM, editable: true, nullable: true, defaultValue: null, modelName: FlowHydrant1GPM )
• FlowHydrant2GPM ( type: esriFieldTypeDouble, alias: FlowHydrant2GPM, editable: true, nullable: true, defaultValue: null, modelName: FlowHydrant2GPM )
• HydrantCfactorAv_ ( type: esriFieldTypeDouble, alias: HydrantCfactorAv_, editable: true, nullable: true, defaultValue: null, modelName: HydrantCfactorAv_ )
• DischargeOrificeDiam ( type: esriFieldTypeDouble, alias: DischargeOrificeDiam, editable: true, nullable: true, defaultValue: null, modelName: DischargeOrificeDiam )
• 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: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: Fire Hydrant
  Description:
  Prototype:
  DischargeOrificeDiam: null
  SUBTYPEID: 201849
  FIRHYDR_ID: null
  MAP_ID: null
  META_ID: null
  MEDIA_ID: null
  COORD_ID: null
  DATE_ACQRD: null
  DISPOSTN_D: null
  CON_TYPE_D: null
  HYD_TY_D: null
  VLV_ST_D: null
  SOURCE_D: null
  SIZE_D: null
  SIZE_U_D: null
  INLET_DIA: null
  OUTCON1DIA: null
  OUTCON2DIA: null
  OUTCON3DIA: null
  DIA_U_D: null
  MEAS_TY_D: null
  HYD_ELV: null
  GROUND_ELV: null
  ELV_U_D: null
  PRESS_MAX: null
  PRESS_RESD: null
  PRESS_STAT: null
  PRESS_U_D: null
  FLOW_TEST: null
  FLOW_U_D: null
  MANUF_ID: null
  MODEL_NO: null
  WATVLV_ID: null
  WATPIPE_ID: null
  INSTLN_ID: null
  BUILDNG_ID: null
  PROJECT_ID: null
  WATZONE_ID: null
  NARRATIVE: null
  USER_FLAG: null
  FACIL_ID: null
  GRID_VALUE: null
  COORD_X: null
  COORD_Y: null
  COORD_Z: null
  OWNER_ID: null
  HYDCLASS_D: null
  W_UTIL_ID: null
  COND_D: null
  ROAD_NAME: null
  LOCATION: null
  VERIFY_D: null
  UPDATE_USER: null
  UPDATE_DATE: null
  MapbookPage: null
  Comments: null
  ImgName: null
  NumOutlet: null
  DataSource: null
  TYPE: null
  UniqueID: null
  Fireflow_Test_Date: null
  FlowHydrantID_1: null
  FlowHydrantID_2: null
  PitotReading_psi: null
  TotalFlowGPM: null
  CalculatedFlowGPM: null
  TestHydrantID: null
  FlowHydrant1GPM: null
  FlowHydrant2GPM: null
  HydrantCfactorAv_: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

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: last_edited_date
• Editor Field: last_edited_user

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