View In:   ArcGIS Online map viewer

Name: Hydrants

Display Field: LegacyID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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: 6326274.264900714
YMin: 1898532.0972825587
XMax: 6397073.982224882
YMax: 1947235.4254006445
Spatial Reference: 102642  (2226)

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

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 )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY, editable: true, nullable: true, defaultValue: null, modelName: COMPKEY )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LegacyID )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AssetID )
• ParentAssetID ( type: esriFieldTypeString, alias: ParentAssetID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ParentAssetID )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Description )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location , Coded Values: [CRK: EASEMENT ACROSS CREEK] , [DIST: DISTRIBUTION] , [DRWY: DRIVEWAY] , ...8 more... )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Address )
• Safety_Note ( type: esriFieldTypeString, alias: Safety_Note, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Safety_Note )
• District ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 25, defaultValue: null, modelName: District , Coded Values: [1: COUNCIL DISTRICT 1] , [2: COUNCIL DISTRICT 2] , [3: COUNCIL DISTRICT 3] , ...4 more... )
• PressureZone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PresZone , Coded Values: [A1: AQUADUCT ZONE 1] , [A2: AQUADUCT ZONE 2] , [A3: AQUADUCT ZONE 3] , ...37 more... )
• Hydrant_Type ( type: esriFieldTypeString, alias: Hydrant Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EquipmentType , Coded Values: [PRIV: PRIVATE] , [RES: RESIDENTIAL] , [REC: RECLAIMED WATER HYDRANT] , ...4 more... )
• Hydrant_Style ( type: esriFieldTypeString, alias: Hydrant Style, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Hydrant_Style , Coded Values: )
• PaintColor ( type: esriFieldTypeString, alias: Paint Color, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PaintColor , Coded Values: [BLACK: BLACK] , [BLUE: BLUE] , [BROWN: BROWN] , ...8 more... )
• Paint_Type ( type: esriFieldTypeString, alias: Paint Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Paint_Type , Coded Values: )
• Chain_Cnt ( type: esriFieldTypeSmallInteger, alias: Chain Count, editable: true, nullable: true, defaultValue: null, modelName: Chaint_Cnt )
• BlueDot ( type: esriFieldTypeSmallInteger, alias: BlueDot, editable: true, nullable: true, defaultValue: null, modelName: BlueDot )
• HighPress ( type: esriFieldTypeSmallInteger, alias: HighPress, editable: true, nullable: true, defaultValue: null, modelName: HighPress , Coded Values: [0: False] , [1: True] )
• Assoc_Hyd ( type: esriFieldTypeString, alias: AssocHyd, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Assoc_Hyd )
• AutoFlusher ( type: esriFieldTypeSmallInteger, alias: AutoFlusher, editable: true, nullable: true, defaultValue: null, modelName: AutoFlusher , Coded Values: [0: False] , [1: True] )
• Iso_Shutoff ( type: esriFieldTypeString, alias: Iso_Shutoff, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Iso_Shutoff )
• CheckValve ( type: esriFieldTypeString, alias: CheckValve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CheckValve )
• Assoc_Pump ( type: esriFieldTypeString, alias: Assoc_Pump, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Assoc_Pump )
• PumpConn ( type: esriFieldTypeSmallInteger, alias: PumpConn, editable: true, nullable: true, defaultValue: null, modelName: PumpConn , Coded Values: [0: False] , [1: True] )
• OutletSize1 ( type: esriFieldTypeDouble, alias: OutletSize1, editable: true, nullable: true, defaultValue: null, modelName: OutletSize1 )
• OutletSize2 ( type: esriFieldTypeDouble, alias: OutletSize2, editable: true, nullable: true, defaultValue: null, modelName: OutletSize2 )
• OutletSize3 ( type: esriFieldTypeDouble, alias: OutletSize3, editable: true, nullable: true, defaultValue: null, modelName: OutletSize3 )
• OutletSize4 ( type: esriFieldTypeDouble, alias: OutletSize4, editable: true, nullable: true, defaultValue: null, modelName: OutletSize4 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer , Coded Values: [AMERIC: AMERICAN MARSH PUMPS] , [APCO: APCO WILLAMETTE VALVE & PRIMER] , [BELOIT: BELOIT] , ...59 more... )
• ModelNum ( type: esriFieldTypeString, alias: Model Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ModelNum )
• SerialNum ( type: esriFieldTypeString, alias: SerialNum, editable: true, nullable: true, length: 125, defaultValue: null, modelName: SerialNum )
• MapNum ( type: esriFieldTypeString, alias: Map Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MapNum )
• BudgetNum ( type: esriFieldTypeString, alias: Budget Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BudgetNum )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LifecycleStatus , Coded Values: [Under Repair: Under Repair] , [In Service: In Service] , [Out of Service: Out of Service] , ...3 more... )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Condition , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• ConditionDate ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Condition_Date )
• ConditionScore ( type: esriFieldTypeDouble, alias: Condition_Score, editable: true, nullable: true, defaultValue: null, modelName: Condition_Score )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintainedBy , Coded Values: [CITY: CITY] , [CNTY: COUNTY] , [DEVL: DEVELOPER-FUTURE CITY OWNRSHIP] , ...5 more... )
• Img_Path ( type: esriFieldTypeString, alias: Image Path, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Img_Path )
• Asbuilt ( type: esriFieldTypeString, alias: Asbuilt, editable: true, nullable: true, length: 16, defaultValue: null, modelName: Asbuilt )
• LABEL ( type: esriFieldTypeString, alias: LABEL, editable: true, nullable: true, length: 24, defaultValue: null, modelName: LABEL )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• POF ( type: esriFieldTypeDouble, alias: POF, editable: true, nullable: true, defaultValue: null, modelName: POF )
• COF ( type: esriFieldTypeDouble, alias: COF, editable: true, nullable: true, defaultValue: null, modelName: COF )
• BRE ( type: esriFieldTypeDouble, alias: BRE, editable: true, nullable: true, defaultValue: null, modelName: BRE )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Pressure ( type: esriFieldTypeSmallInteger, alias: Pressure, editable: true, nullable: true, defaultValue: null, modelName: Pressure )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Status , Coded Values: [OUT: OUT OF SERVICE] , [IN: IN SERVICE] , [STUB: FUTURE SERVICE/MAIN & BLOWOFF] )
• Sidewalk_Clr ( type: esriFieldTypeString, alias: Sidewalk_Clr, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Sidewalk_Clr )

Templates:

• Name: Hydrants
  Description:
  Prototype:
  Status: null
  Pressure: null
  COMPKEY: null
  LegacyID: null
  AssetID: null
  ParentAssetID: null
  Description: null
  Location: null
  Address: null
  Safety_Note: null
  District: null
  PressureZone: null
  Hydrant_Type: null
  Hydrant_Style: null
  PaintColor: null
  Paint_Type: null
  Chain_Cnt: null
  BlueDot: null
  HighPress: null
  Assoc_Hyd: null
  AutoFlusher: null
  Iso_Shutoff: null
  CheckValve: null
  Assoc_Pump: null
  PumpConn: null
  OutletSize1: null
  OutletSize2: null
  OutletSize3: null
  OutletSize4: null
  Manufacturer: null
  ModelNum: null
  SerialNum: null
  MapNum: null
  BudgetNum: null
  InstallationDate: null
  WarrantyDate: null
  LifecycleStatus: null
  Condition: null
  ConditionDate: null
  ConditionScore: null
  Owner: null
  Img_Path: null
  Asbuilt: null
  LABEL: null
  Comments: null
  POF: null
  COF: null
  BRE: null
  Sidewalk_Clr: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

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

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