Name: BC_Utility.DBO.wHydrant_Contractor

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><P><SPAN>One of the most accessible parts of a water distribution system, they are often used for attaching pressure gauges or loggers or monitor system water pressure. Point where people are able to tap into a water supply (e.g. for firefighters' use). </SPAN></P></DIV></DIV>

Copyright Text: Originally created by Woolpert Inc. in 1997. Edited by Battle Creek DPW Records Division.

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1.2863913176183373E7
YMin: 272021.8697539866
XMax: 1.2932900476705179E7
YMax: 318035.10335443914
Spatial Reference: 2253  (2253)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Paint_Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: Complete
  Label: Complete
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [76, 230, 0, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Incomplete
  Label: Incomplete
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 0, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: false
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 20 )
• HYDRANT_ID ( type: esriFieldTypeString, alias: Hydrant ID, length: 15 )
• MUNICIPALITY ( type: esriFieldTypeString, alias: Municipality, length: 30 )
• OWNER ( type: esriFieldTypeString, alias: Owner, length: 50 , Coded Values: [City of Battle Creek: City of Battle Creek] , [Brownstone Apartments: Brownstone Apartments] , [Keystone Lake Apartments: Keystone Lake Apartments] , ...5 more... )
• PUBLIC_PVT ( type: esriFieldTypeString, alias: Public or Private, length: 10 , Coded Values: [Public: Public] , [Private: Private] , [Unknown: Unknown] )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, length: 30 , Coded Values: [American Darling: American Darling] , [Clow: Clow] , [EJIW: EJIW] , ...9 more... )
• CONTRACTOR ( type: esriFieldTypeString, alias: Contractor, length: 50 , Coded Values: [City of Battle Creek: City of Battle Creek] , [Crest Construction: Crest Construction] , [Hoffman Brothers: Hoffman Brothers] , ...10 more... )
• MODEL ( type: esriFieldTypeString, alias: Model, length: 15 , Coded Values: [5BR: 5BR] , [6BR: 6BR] , [B62B-5: B62B-5] )
• HYD_VOB ( type: esriFieldTypeString, alias: Valve on Branch, length: 1 )
• DEPTHOBURY ( type: esriFieldTypeDouble, alias: Depth of Bury , Coded Values: [4: 4 ft] , [5: 5 ft] , [5.5: 5.5 ft] , ...11 more... )
• CAST_DATE ( type: esriFieldTypeSmallInteger, alias: Cast Date )
• INSTALL_YR ( type: esriFieldTypeSmallInteger, alias: Year Installed )
• INSTALLMTH ( type: esriFieldTypeSmallInteger, alias: Month Installed , Coded Values: [1: January] , [2: February] , [3: March] , ...9 more... )
• VERT_EXT ( type: esriFieldTypeDouble, alias: Verticle Extension )
• DRAIN_HOLE ( type: esriFieldTypeSmallInteger, alias: Drain Holes )
• PLUGS_REMO ( type: esriFieldTypeString, alias: Plugs Removed, length: 1 )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation )
• GPS_Date ( type: esriFieldTypeDate, alias: GPS Date, length: 8 )
• VERIFIED ( type: esriFieldTypeString, alias: Verified, length: 10 , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• PRESSURE ( type: esriFieldTypeString, alias: Pressure, length: 10 , Coded Values: [H: High] , [L: Low] )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 100 )
• STATIC_PSI ( type: esriFieldTypeSmallInteger, alias: Static PSI )
• RESIDUAL_PSI ( type: esriFieldTypeSmallInteger, alias: Residual PSI )
• FLOW_GPM ( type: esriFieldTypeSmallInteger, alias: Flow GPM )
• TEST_TAKER ( type: esriFieldTypeString, alias: Test Taker, length: 25 )
• TEST_DATE ( type: esriFieldTypeDate, alias: Test Date, length: 8 )
• IDNO ( type: esriFieldTypeString, alias: IDNO, length: 14 )
• T1COMMENT ( type: esriFieldTypeString, alias: T1 Comments, length: 1073741822 )
• SHEET__S ( type: esriFieldTypeInteger, alias: Ortho Index )
• Duplicate ( type: esriFieldTypeSmallInteger, alias: Duplicate )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• WINTERCHECK ( type: esriFieldTypeString, alias: Winter Check, length: 20 , Coded Values: [Yes: Yes] , [No: No] , [Private: Private] )
• GROUNDWATER ( type: esriFieldTypeString, alias: Ground Water, length: 20 , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• WINTERCHECK_COMMENTS ( type: esriFieldTypeString, alias: Winter Check Comments, length: 250 )
• WINTERCHECK_DATE ( type: esriFieldTypeString, alias: Winter Check Date, length: 50 , Coded Values: [9/12/2019: 9/12/2019] , [9/13/2019: 9/13/2019] , [9/16/2019: 9/16/2019] , ...79 more... )
• NO_DRAINER ( type: esriFieldTypeString, alias: No Drainer, length: 20 , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• PROBLEM_CODE ( type: esriFieldTypeString, alias: Problem Code, length: 150 , Coded Values: [No Problems: No Problems] , [Broken Flange: Broken Flange] , [Needs Raised: Needs Raised] , ...10 more... )
• GIS_CHANGE ( type: esriFieldTypeString, alias: GIS Change, length: 15 , Coded Values: [Yes: Yes] , [No: No] , [Complete: Complete] )
• WINTERCHECKED_BY ( type: esriFieldTypeString, alias: Edited By, length: 100 )
• REPLACE_HYDRANT ( type: esriFieldTypeString, alias: Replce Hydrant, length: 10 , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• NEEDS_LETTER ( type: esriFieldTypeString, alias: Needs Letter, length: 10 , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• PUMPOUT_LIST ( type: esriFieldTypeString, alias: Pumpout List, length: 10 , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, length: 75 )
• CreatedByDate ( type: esriFieldTypeDate, alias: Created By Date, length: 8 )
• EditedBy ( type: esriFieldTypeString, alias: Edited By, length: 75 )
• EditedByDate ( type: esriFieldTypeDate, alias: Edited By Date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• STATIC_PSI_text ( type: esriFieldTypeString, alias: Static PSI_text, length: 255 )
• RESIDUAL_PSI_text ( type: esriFieldTypeString, alias: Residual PSI_text, length: 255 )
• FLOW_GPM_text ( type: esriFieldTypeString, alias: Flow GPM_text, length: 255 )
• FLOWTEST_ID ( type: esriFieldTypeString, alias: Flow Test ID, length: 255 )
• Flushtest ( type: esriFieldTypeString, alias: Flushtest, length: 50 )
• FF_Test ( type: esriFieldTypeInteger, alias: FF_Test )
• PSI_stat ( type: esriFieldTypeInteger, alias: PSI_stat )
• PSI_res ( type: esriFieldTypeInteger, alias: PSI_res )
• Date_Painted ( type: esriFieldTypeDate, alias: Date_Painted, length: 8 )
• Delete_Me ( type: esriFieldTypeDate, alias: Delete_Me, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Paint_Status ( type: esriFieldTypeString, alias: Paint Status, length: 255 , Coded Values: [Complete: Complete] , [Incomplete: Incomplete] )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata