View In:   ArcGIS Online Map Viewer

Name: wFireHydrants

Display Field: facilityid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: da171f5bef9e4c83a788519e82bf1d55

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.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

Extent:

XMin: 920140.0892739445
YMin: 556258.3000776917
XMax: 1004841.7000541091
YMax: 640120.9499373585
Spatial Reference: 102719  (2264)  VCSWkid(115702)  LatestVCSWkid(115702)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: maintained
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: City Fire Hydrant
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Non-City Fire Hydrant
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Proposed Fire Hydrant
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [hydrantnum]
Use Coded Values: true
Symbol:
Color: [168, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 3000.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true
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: esriServerHTMLPopupTypeNone

Type ID Field: maintained

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• facilityid ( modelName: FacilityID, nullable: true, editable: true, defaultValue: null, length: 30, alias: FacilityID, type: esriFieldTypeString )
• legacyid ( modelName: LegacyID, nullable: true, editable: true, defaultValue: null, length: 30, alias: LegacyID, type: esriFieldTypeString )
• hydrantnum ( modelName: HydrantNum, nullable: true, editable: true, defaultValue: null, length: 10, alias: HydrantNum, type: esriFieldTypeString )
• manufacturer ( modelName: Manufacturer, nullable: true, editable: true, defaultValue: null, length: 20, alias: Manufacturer, type: esriFieldTypeString , Coded Values: [American: American] , [Clow: Clow] , [Columbian: Columbian] , ...6 more... )
• outlets ( modelName: Outlets, nullable: true, editable: true, defaultValue: null, alias: Outlets, type: esriFieldTypeSmallInteger )
• threadtype ( modelName: ThreadType, nullable: true, editable: true, defaultValue: null, length: 20, alias: ThreadType, type: esriFieldTypeString , Coded Values: [Hendersonville: Hendersonville] , [National: National] , [Unknown: Unknown] )
• manufyear ( modelName: ManufYear, nullable: true, editable: true, defaultValue: null, length: 10, alias: ManufYear, type: esriFieldTypeString )
• staticpressure ( modelName: StaticPressure, nullable: true, editable: true, defaultValue: null, length: 3, alias: StaticPressure, type: esriFieldTypeString )
• spcommecnts ( modelName: SPCommecnts, nullable: true, editable: true, defaultValue: null, length: 30, alias: SPCommecnts, type: esriFieldTypeString )
• elevation ( modelName: Elevation, nullable: true, editable: true, defaultValue: null, alias: Elevation, type: esriFieldTypeDouble )
• locationdesc ( modelName: LocationDesc, nullable: true, editable: true, defaultValue: null, length: 100, alias: LocationDesc, type: esriFieldTypeString )
• subdivision ( modelName: Subdivision, nullable: true, editable: true, defaultValue: null, length: 50, alias: Subdivision, type: esriFieldTypeString )
• pressurezone ( modelName: PressureZone, nullable: true, editable: true, defaultValue: null, length: 20, alias: PressureZone, type: esriFieldTypeString )
• firedistrict ( modelName: FireDistrict, nullable: true, editable: true, defaultValue: null, length: 30, alias: FireDistrict, type: esriFieldTypeString )
• tagged ( modelName: Tagged, nullable: true, editable: true, defaultValue: null, length: 10, alias: Tagged, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• controlvalve ( modelName: ControlValve, nullable: true, editable: true, defaultValue: null, length: 10, alias: ControlValve, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• flushnight ( modelName: FlushNight, nullable: true, editable: true, defaultValue: null, alias: FlushNight, type: esriFieldTypeSmallInteger )
• flushsequence ( modelName: FlushSequence, nullable: true, editable: true, defaultValue: null, alias: FlushSequence, type: esriFieldTypeSmallInteger )
• flushmethod ( modelName: FlushMethod, nullable: true, editable: true, defaultValue: null, length: 10, alias: FlushMethod, type: esriFieldTypeString , Coded Values: [ON/OFF: ON/OFF] , [FULL: FULL] , [HOLD: HOLD] )
• specialinstructions ( modelName: SpecialInstructions, nullable: true, editable: true, defaultValue: null, length: 100, alias: SpecialInstructions, type: esriFieldTypeString )
• datasource ( modelName: DataSource, nullable: true, editable: true, defaultValue: null, length: 100, alias: DataSource, type: esriFieldTypeString )
• datastatus ( modelName: DataStatus, nullable: true, editable: true, defaultValue: null, length: 10, alias: DataStatus, type: esriFieldTypeString , Coded Values: [HIGH: Confidence Level = HIGH] , [LOW: Confidence Level = LOW] )
• notes ( modelName: Notes, nullable: true, editable: true, defaultValue: null, length: 50, alias: Notes, type: esriFieldTypeString )
• fieldverified ( modelName: FieldVerified, nullable: true, editable: true, defaultValue: null, length: 10, alias: FieldVerified, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• dataverified ( modelName: DataVerified, nullable: true, editable: true, defaultValue: null, length: 50, alias: DataVerified, type: esriFieldTypeString )
• whoverified ( modelName: WhoVerified, nullable: true, editable: true, defaultValue: null, length: 50, alias: WhoVerified, type: esriFieldTypeString )
• lastupdated ( modelName: LastUpdated, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: LastUpdated, type: esriFieldTypeDate )
• editor ( modelName: Editor, nullable: true, editable: true, defaultValue: null, length: 10, alias: Editor, type: esriFieldTypeString )
• maintained ( modelName: Maintained, nullable: true, editable: true, defaultValue: 1, alias: Maintained, type: esriFieldTypeSmallInteger )
• mainsize ( modelName: MainSize, nullable: true, editable: true, defaultValue: null, length: 10, alias: MainSize, type: esriFieldTypeString , Coded Values: [3/4: 3/4"] , [1: 1"] , [2: 2"] , ...22 more... )
• company ( modelName: Company, nullable: true, editable: true, defaultValue: null, length: 30, alias: Company, type: esriFieldTypeString )
• shift ( modelName: Shift, nullable: true, editable: true, defaultValue: null, length: 10, alias: Shift, type: esriFieldTypeString )
• infirehouse ( modelName: InFireHouse, nullable: true, editable: true, defaultValue: null, length: 10, alias: InFireHouse, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• flush ( modelName: Flush, nullable: true, editable: true, defaultValue: null, length: 15, alias: Flush, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• newflush ( modelName: NewFlush, nullable: true, editable: true, defaultValue: null, alias: NewFlush, type: esriFieldTypeSmallInteger )
• barrelsize ( modelName: BarrelSize, nullable: true, editable: true, defaultValue: null, alias: BarrelSize, type: esriFieldTypeDouble )
• latitude ( modelName: Latitude, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( modelName: Longitude, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• tll_static_demand__gpm_ ( modelName: LL_Stat_Demand, nullable: true, editable: true, defaultValue: null, alias: Tank Lowest Level Static Demand (gpm), type: esriFieldTypeDouble )
• tll_static_pressure_psi ( modelName: LL_Stat_Press, nullable: true, editable: true, defaultValue: null, alias: Tank Lowest Level Static Pressure (psi) , type: esriFieldTypeInteger )
• tll_resid_pres_psi ( modelName: LL_Res_Pres_500_gpm, nullable: true, editable: true, defaultValue: null, alias: Tank Lowest Level Residual Pressure(AFF) (psi) at 500 gpm, type: esriFieldTypeInteger )
• ll_availflow_20psi ( modelName: LL_AvailFlow_20psi, nullable: true, editable: true, defaultValue: null, alias: LL_AvailFlow_20psi, type: esriFieldTypeInteger )
• tnf_stat_demand_psi ( modelName: NF_Stat_Demand, nullable: true, editable: true, defaultValue: null, alias: Tank Near Full Static Demand (gpm), type: esriFieldTypeDouble )
• tnf_static_pressure_psi ( modelName: NF_Stat_Press, nullable: true, editable: true, defaultValue: null, alias: Tank Near Full Static Pressure (psi), type: esriFieldTypeInteger )
• tnf_resid_pressure_gpm ( modelName: NF_Res_Pres_gpm, nullable: true, editable: true, defaultValue: null, alias: Tank Near Full Residual Pressure (psi) at 500 gpm, type: esriFieldTypeInteger )
• tnf_avail_flow_at_20psi ( modelName: NF_AvailFlow_20_psi, nullable: true, editable: true, defaultValue: null, alias: Tank Near Full Available Flow at Hydrant (gpm) at 20 psi, type: esriFieldTypeDouble )
• hyd_num ( modelName: HYD_NUM, nullable: true, editable: true, defaultValue: null, length: 255, alias: HYD_NUM, type: esriFieldTypeString )
• raster_elevation ( modelName: raster_elevation, nullable: true, editable: true, defaultValue: null, alias: Raster_Elevation, type: esriFieldTypeDouble )

Types:

ID: 1
Name: City Fire Hydrant
Domains:
• fieldverified:
  Inherited
• flushmethod:
  Inherited
• flush:
  Inherited
• tagged:
  Inherited
• mainsize:
  Inherited
• threadtype:
  Inherited
• datastatus:
  Inherited
• infirehouse:
  Inherited
• controlvalve:
  Inherited
• manufacturer:
  Inherited
Templates:
• Name: 1
  Description:
  Prototype:
  facilityid: null
  notes: null
  staticpressure: null
  firedistrict: null
  shift: null
  latitude: null
  outlets: null
  pressurezone: null
  hyd_num: null
  locationdesc: null
  tll_static_demand__gpm_: null
  manufacturer: null
  subdivision: null
  tll_static_pressure_psi: null
  dataverified: null
  newflush: null
  flush: null
  tagged: null
  tnf_resid_pressure_gpm: null
  ll_availflow_20psi: null
  company: null
  maintained: 1
  raster_elevation: null
  longitude: null
  elevation: null
  fieldverified: null
  editor: null
  flushsequence: null
  tll_resid_pres_psi: null
  specialinstructions: null
  threadtype: null
  hydrantnum: null
  datastatus: null
  infirehouse: null
  controlvalve: null
  flushmethod: null
  tnf_static_pressure_psi: null
  tnf_avail_flow_at_20psi: null
  datasource: null
  manufyear: null
  whoverified: null
  mainsize: null
  legacyid: null
  lastupdated: null
  spcommecnts: null
  flushnight: null
  barrelsize: null
  tnf_stat_demand_psi: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Non-City Fire Hydrant
Domains:
• fieldverified:
  Inherited
• flushmethod:
  Inherited
• flush:
  Inherited
• tagged:
  Inherited
• mainsize:
  Inherited
• threadtype:
  Inherited
• datastatus:
  Inherited
• infirehouse:
  Inherited
• controlvalve:
  Inherited
• manufacturer:
  Inherited
Templates:
• Name: 2
  Description:
  Prototype:
  facilityid: null
  notes: null
  staticpressure: null
  firedistrict: null
  shift: null
  latitude: null
  outlets: null
  pressurezone: null
  hyd_num: null
  locationdesc: null
  tll_static_demand__gpm_: null
  manufacturer: null
  subdivision: null
  tll_static_pressure_psi: null
  dataverified: null
  newflush: null
  flush: null
  tagged: null
  tnf_resid_pressure_gpm: null
  ll_availflow_20psi: null
  company: null
  maintained: 2
  raster_elevation: null
  longitude: null
  elevation: null
  fieldverified: null
  editor: null
  flushsequence: null
  tll_resid_pres_psi: null
  specialinstructions: null
  threadtype: null
  hydrantnum: null
  datastatus: null
  infirehouse: null
  controlvalve: null
  flushmethod: null
  tnf_static_pressure_psi: null
  tnf_avail_flow_at_20psi: null
  datasource: null
  manufyear: null
  whoverified: null
  mainsize: null
  legacyid: null
  lastupdated: null
  spcommecnts: null
  flushnight: null
  barrelsize: null
  tnf_stat_demand_psi: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Proposed Fire Hydrant
Domains:
• fieldverified:
  Inherited
• flushmethod:
  Inherited
• flush:
  Inherited
• tagged:
  Inherited
• mainsize:
  Inherited
• threadtype:
  Inherited
• datastatus:
  Inherited
• infirehouse:
  Inherited
• controlvalve:
  Inherited
• manufacturer:
  Inherited
Templates:
• Name: 4
  Description:
  Prototype:
  facilityid: null
  notes: null
  staticpressure: null
  firedistrict: null
  shift: null
  latitude: null
  outlets: null
  pressurezone: null
  hyd_num: null
  locationdesc: null
  tll_static_demand__gpm_: null
  manufacturer: null
  subdivision: null
  tll_static_pressure_psi: null
  dataverified: null
  newflush: null
  flush: null
  tagged: null
  tnf_resid_pressure_gpm: null
  ll_availflow_20psi: null
  company: null
  maintained: 4
  raster_elevation: null
  longitude: null
  elevation: null
  fieldverified: null
  editor: null
  flushsequence: null
  tll_resid_pres_psi: null
  specialinstructions: null
  threadtype: null
  hydrantnum: null
  datastatus: null
  infirehouse: null
  controlvalve: null
  flushmethod: null
  tnf_static_pressure_psi: null
  tnf_avail_flow_at_20psi: null
  datasource: null
  manufyear: null
  whoverified: null
  mainsize: null
  legacyid: null
  lastupdated: null
  spcommecnts: null
  flushnight: null
  barrelsize: null
  tnf_stat_demand_psi: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: 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

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata