Layers:

Layer: PRV Inspection (1)

Name: PRV Inspection

Display Field: created_user

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1412356.6112826802
YMin: 286243.8216124475
XMax: 1430228.5424022637
YMax: 300080.68140586466
Spatial Reference: 102697  (102697)



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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• 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 )
• INLETPRESSURE ( type: esriFieldTypeDouble, alias: Inlet pressure, editable: true, nullable: true, defaultValue: null, modelName: INLETPRESSURE )
• OUTLETPRESSURE ( type: esriFieldTypeDouble, alias: Outlet pressure, editable: true, nullable: true, defaultValue: null, modelName: OUTLETPRESSURE )
• MAINTENANCENEEDED ( type: esriFieldTypeString, alias: Maintenance needed Yes/No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAINTENANCENEEDED , Coded Values: [Yes: Yes] , [No: No] )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: COMMENTS )
• OPERATIONAL ( type: esriFieldTypeString, alias: Operational Yes/No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OPERATIONAL , Coded Values: [Yes: Yes] , [No: No] )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: PRV Inspection
  Description:
  Prototype:
  OPERATIONAL: null
  COMMENTS: null
  OUTLETPRESSURE: null
  INLETPRESSURE: null
  MAINTENANCENEEDED: null
  GUID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.wControlValve (0) -- Related To: Pressure Reducer Valve (2)

Layer: Pressure Reducer Valve (2)

Name: Pressure Reducer Valve

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1405754.0076900125
YMin: 285332.1347875297
XMax: 1431018.5099824294
YMax: 302120.4348722771
Spatial Reference: 102697  (102697)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Needs inspection - Maintenance required
  Label: Needs inspection - Maintenance required
  Description: Needs inspection - Maintenance required
  Symbol:
  
• Value: Needs inspection - No maintenance needed
  Label: Needs inspection - No maintenance needed
  Description: Needs inspection - No maintenance needed
  Symbol:
  
• Value: Not operational
  Label: Not operational
  Description: Not operational
  Symbol:
  
• Value: Bypass PRV
  Label: Bypass PRV
  Description: Bypass PRV
  Symbol:
  
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: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVETYPE , Coded Values: [Altitude: Altitude] , [Blowoff: Blowoff] , [Air Control: Air Control] , ...13 more... )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• 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 )
• LABEL ( type: esriFieldTypeString, alias: Valve Type Label, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LABEL )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIAL )
• GPS_DATE ( type: esriFieldTypeDate, alias: Date of GPS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• GPS_USER ( type: esriFieldTypeString, alias: GPS User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GPS_USER )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 400, defaultValue: null, modelName: COMMENT )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed of Valve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• VALVE_ID ( type: esriFieldTypeString, alias: Valve ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VALVE_ID )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ADDRESS )
• BRAND ( type: esriFieldTypeString, alias: Brand, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BRAND )
• MODELNO ( type: esriFieldTypeString, alias: Model number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MODELNO )
• FLOWDIRECTION ( type: esriFieldTypeString, alias: Flow direction, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FLOWDIRECTION , Coded Values: [East: East] , [North: North] , [South: South] , ...9 more... )
• BYPASS ( type: esriFieldTypeString, alias: Bypass Yes/No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BYPASS , Coded Values: [Yes: Yes] , [No: No] )
• BYPASSTYPE ( type: esriFieldTypeString, alias: Bypass type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BYPASSTYPE )
• BYPASSSIZE ( type: esriFieldTypeDouble, alias: Bypass size, editable: true, nullable: true, defaultValue: null, modelName: BYPASSSIZE , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• BYPASSINLETPRESSURE ( type: esriFieldTypeDouble, alias: Bypass Inlet Pressure, editable: true, nullable: true, defaultValue: null, modelName: BYPASSINLETPRESSURE )
• BYPASSOUTLETPRESSURE ( type: esriFieldTypeDouble, alias: Bypass outlet pressure, editable: true, nullable: true, defaultValue: null, modelName: BYPASSOUTLETPRESSURE )
• BYPASSBRAND ( type: esriFieldTypeString, alias: Bypass brand, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BYPASSBRAND )
• BYPASSMODELNO ( type: esriFieldTypeString, alias: Bypass model number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BYPASSMODELNO )
• OPERATIONAL ( type: esriFieldTypeString, alias: Operational Yes/No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OPERATIONAL , Coded Values: [Yes: Yes] , [No: No] )
• INLETPRESSURE ( type: esriFieldTypeDouble, alias: Inlet pressure, editable: true, nullable: true, defaultValue: null, modelName: INLETPRESSURE )
• OUTLETPRESSURE ( type: esriFieldTypeDouble, alias: Outlet pressure, editable: true, nullable: true, defaultValue: null, modelName: OUTLETPRESSURE )
• MAINTENANCENEEDED ( type: esriFieldTypeString, alias: Maintenance needed yes/no, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAINTENANCENEEDED , Coded Values: [Yes: Yes] , [No: No] )
• LASTINSPECTED ( type: esriFieldTypeDate, alias: Last inspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTINSPECTED )
• HIDEFROMAPP ( type: esriFieldTypeString, alias: Hide from app?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HIDEFROMAPP , Coded Values: [Yes: Yes] , [No: No] )
Templates:
• Name: Pressure Reducer Valve
  Description:
  Prototype:
  MAINTENANCENEEDED: null
  OUTLETPRESSURE: null
  BYPASSOUTLETPRESSURE: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  VALVETYPE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  INLETPRESSURE: null
  OPERATIONAL: null
  BYPASSMODELNO: null
  BYPASSBRAND: null
  MAINTBY: 1
  LABEL: null
  MATERIAL: null
  GPS_DATE: null
  GPS_USER: null
  COMMENT: null
  WATERSHED: null
  LASTINSPECTED: null
  PRESSUREZN: null
  VALVE_ID: null
  ADDRESS: null
  BRAND: null
  MODELNO: null
  FLOWDIRECTION: null
  BYPASS: null
  BYPASSTYPE: null
  BYPASSSIZE: null
  BYPASSINLETPRESSURE: null
  HIDEFROMAPP: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.PRVInspection (0) -- Related To: PRV Inspection (1)

Layer: Replace Valves (3)

Name: Replace Valves

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1405246.9421030954
YMin: 284440.10113853216
XMax: 1436848.5688603446
YMax: 341317.68948286027
Spatial Reference: 102697  (102697)



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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVETYPE , Coded Values: [Plug: Plug] , [Other: Other] , [Unknown: Unknown] , ...10 more... )
• BYPASSVALVE ( type: esriFieldTypeSmallInteger, alias: Bypass Valve, editable: true, nullable: true, defaultValue: 0, modelName: BYPASSVALVE , Coded Values: [0: False] , [1: True] )
• CLOCKTOCLOSE ( type: esriFieldTypeSmallInteger, alias: Clockwise To Close, editable: true, nullable: true, defaultValue: 1, modelName: CLOCKTOCLOSE , Coded Values: [0: False] , [1: True] )
• NORMALLYOPEN ( type: esriFieldTypeSmallInteger, alias: Normally Open, editable: true, nullable: true, defaultValue: 1, modelName: NORMALLYOPEN , Coded Values: [0: False] , [1: True] )
• TURNSTOCLOSE ( type: esriFieldTypeInteger, alias: Turns To Close, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• HYDRFLAG ( type: esriFieldTypeSmallInteger, alias: Hydrant Valve, editable: true, nullable: true, defaultValue: 0, modelName: HYDRFLAG , Coded Values: [0: False] , [1: True] )
• CURROPEN ( type: esriFieldTypeSmallInteger, alias: Currently Open, editable: true, nullable: true, defaultValue: 1, modelName: CURROPEN , Coded Values: [0: False] , [1: True] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• 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 )
• LABEL ( type: esriFieldTypeString, alias: Valve Type Label, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LABEL )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIAL )
• GPS_DATE ( type: esriFieldTypeDate, alias: Date of GPS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• GPS_USER ( type: esriFieldTypeString, alias: GPS User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GPS_USER )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 400, defaultValue: null, modelName: COMMENT )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed of Valve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED )
• 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 )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• VALVE_ID ( type: esriFieldTypeString, alias: Valve ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VALVE_ID )
• ServiceLineDepth ( type: esriFieldTypeString, alias: Service Line Depth, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ServiceLineDepth , Coded Values: [12: 12"] , [18: 18"] , [24: 24"] , ...6 more... )
• LASTEXERCISE ( type: esriFieldTypeDate, alias: Last Exercise Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTEXERCISE )
• VALVECONDITION ( type: esriFieldTypeString, alias: Valve Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVECONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• EXERCISENEEDED ( type: esriFieldTypeString, alias: Exercise Needed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXERCISENEEDED , Coded Values: [Yes: Yes] , [No: No] )
• BOXNEEDCLEAN ( type: esriFieldTypeString, alias: Box Need Clean, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXNEEDCLEAN , Coded Values: [Yes: Yes] , [No: No] )
• BOXCONDITION ( type: esriFieldTypeString, alias: Box Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXCONDITION , Coded Values: [Broken: Broken] , [Clean: Clean] , [Completed: Completed] , ...5 more... )
• NEEDSLID ( type: esriFieldTypeString, alias: Needs Lid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDSLID , Coded Values: [Yes: Yes] , [No: No] )
• GOODPACKING ( type: esriFieldTypeString, alias: Good Packing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GOODPACKING , Coded Values: [Yes: Yes] , [No: No] )
• NEEDSMAINT ( type: esriFieldTypeString, alias: Needs Maintenance, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDSMAINT , Coded Values: [Yes: Yes] , [No: No] )
• MAINTREQUIRED ( type: esriFieldTypeString, alias: Maintenance Required, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MAINTREQUIRED )
• VALVEDEPTH ( type: esriFieldTypeDouble, alias: Valve Depth, editable: true, nullable: true, defaultValue: null, modelName: VALVEDEPTH )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
Templates:
• Name: Replace Valves
  Description:
  Prototype:
  MAINTREQUIRED: null
  NEEDSMAINT: null
  EXERCISENEEDED: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  VALVETYPE: null
  BYPASSVALVE: 0
  CLOCKTOCLOSE: 1
  NORMALLYOPEN: 1
  TURNSTOCLOSE: null
  OPERABLE: 1
  HYDRFLAG: 0
  CURROPEN: 1
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  GOODPACKING: null
  NEEDSLID: null
  BOXCONDITION: null
  BOXNEEDCLEAN: null
  MAINTBY: 1
  LABEL: null
  MATERIAL: null
  GPS_DATE: null
  GPS_USER: null
  COMMENT: null
  WATERSHED: null
  LATITUDE: null
  LONGITUDE: null
  ELEVATION: null
  VALVEDEPTH: null
  PRESSUREZN: null
  VALVE_ID: null
  ServiceLineDepth: null
  LASTEXERCISE: null
  VALVECONDITION: null
  GUID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Layer: Valves Excercised This Calender Year (4)

Name: Valves Excercised This Calender Year

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1405246.9421030954
YMin: 284437.8347388655
XMax: 1436848.5688603446
YMax: 341317.68948286027
Spatial Reference: 102697  (102697)



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: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVETYPE , Coded Values: [Plug: Plug] , [Other: Other] , [Unknown: Unknown] , ...10 more... )
• BYPASSVALVE ( type: esriFieldTypeSmallInteger, alias: Bypass Valve, editable: true, nullable: true, defaultValue: 0, modelName: BYPASSVALVE , Coded Values: [0: False] , [1: True] )
• CLOCKTOCLOSE ( type: esriFieldTypeSmallInteger, alias: Clockwise To Close, editable: true, nullable: true, defaultValue: 1, modelName: CLOCKTOCLOSE , Coded Values: [0: False] , [1: True] )
• NORMALLYOPEN ( type: esriFieldTypeSmallInteger, alias: Normally Open, editable: true, nullable: true, defaultValue: 1, modelName: NORMALLYOPEN , Coded Values: [0: False] , [1: True] )
• TURNSTOCLOSE ( type: esriFieldTypeInteger, alias: Turns To Close, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• HYDRFLAG ( type: esriFieldTypeSmallInteger, alias: Hydrant Valve, editable: true, nullable: true, defaultValue: 0, modelName: HYDRFLAG , Coded Values: [0: False] , [1: True] )
• CURROPEN ( type: esriFieldTypeSmallInteger, alias: Currently Open, editable: true, nullable: true, defaultValue: 1, modelName: CURROPEN , Coded Values: [0: False] , [1: True] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• 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 )
• LABEL ( type: esriFieldTypeString, alias: Valve Type Label, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LABEL )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIAL )
• GPS_DATE ( type: esriFieldTypeDate, alias: Date of GPS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• GPS_USER ( type: esriFieldTypeString, alias: GPS User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GPS_USER )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 400, defaultValue: null, modelName: COMMENT )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed of Valve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED )
• 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 )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• VALVE_ID ( type: esriFieldTypeString, alias: Valve ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VALVE_ID )
• ServiceLineDepth ( type: esriFieldTypeString, alias: Service Line Depth, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ServiceLineDepth , Coded Values: [12: 12"] , [18: 18"] , [24: 24"] , ...6 more... )
• LASTEXERCISE ( type: esriFieldTypeDate, alias: Last Exercise Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTEXERCISE )
• VALVECONDITION ( type: esriFieldTypeString, alias: Valve Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVECONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• EXERCISENEEDED ( type: esriFieldTypeString, alias: Exercise Needed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXERCISENEEDED , Coded Values: [Yes: Yes] , [No: No] )
• BOXNEEDCLEAN ( type: esriFieldTypeString, alias: Box Need Clean, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXNEEDCLEAN , Coded Values: [Yes: Yes] , [No: No] )
• BOXCONDITION ( type: esriFieldTypeString, alias: Box Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXCONDITION , Coded Values: [Broken: Broken] , [Clean: Clean] , [Completed: Completed] , ...5 more... )
• NEEDSLID ( type: esriFieldTypeString, alias: Needs Lid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDSLID , Coded Values: [Yes: Yes] , [No: No] )
• GOODPACKING ( type: esriFieldTypeString, alias: Good Packing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GOODPACKING , Coded Values: [Yes: Yes] , [No: No] )
• NEEDSMAINT ( type: esriFieldTypeString, alias: Needs Maintenance, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDSMAINT , Coded Values: [Yes: Yes] , [No: No] )
• MAINTREQUIRED ( type: esriFieldTypeString, alias: Maintenance Required, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MAINTREQUIRED )
• VALVEDEPTH ( type: esriFieldTypeDouble, alias: Valve Depth, editable: true, nullable: true, defaultValue: null, modelName: VALVEDEPTH )
Templates:
• Name: Valves Excercised This Calender Year
  Description:
  Prototype:
  NEEDSMAINT: null
  GOODPACKING: null
  VALVECONDITION: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  VALVETYPE: null
  BYPASSVALVE: 0
  CLOCKTOCLOSE: 1
  NORMALLYOPEN: 1
  TURNSTOCLOSE: null
  OPERABLE: 1
  HYDRFLAG: 0
  CURROPEN: 1
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  NEEDSLID: null
  BOXCONDITION: null
  BOXNEEDCLEAN: null
  EXERCISENEEDED: null
  MAINTBY: 1
  LABEL: null
  MATERIAL: null
  GPS_DATE: null
  GPS_USER: null
  COMMENT: null
  WATERSHED: null
  LATITUDE: null
  LONGITUDE: null
  ELEVATION: null
  MAINTREQUIRED: null
  PRESSUREZN: null
  VALVE_ID: null
  ServiceLineDepth: null
  LASTEXERCISE: null
  VALVEDEPTH: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.wValveExerciseInfo (2) -- Related To: Water Valve Exercise Info (17)

Layer: Valves Not Oowned by Branson (6)

Name: Valves Not Oowned by Branson

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1405246.9421030954
YMin: 284437.8347388655
XMax: 1436848.5688603446
YMax: 341317.68948286027
Spatial Reference: 102697  (102697)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: OPERABLE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Not Owned By Branson
UniqueValueInfos:
• Value: 0
  Label: False
  Description: False
  Symbol:
  
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: OPERABLE

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVETYPE , Coded Values: [Plug: Plug] , [Other: Other] , [Unknown: Unknown] , ...10 more... )
• BYPASSVALVE ( type: esriFieldTypeSmallInteger, alias: Bypass Valve, editable: true, nullable: true, defaultValue: 0, modelName: BYPASSVALVE , Coded Values: [0: False] , [1: True] )
• CLOCKTOCLOSE ( type: esriFieldTypeSmallInteger, alias: Clockwise To Close, editable: true, nullable: true, defaultValue: 1, modelName: CLOCKTOCLOSE , Coded Values: [0: False] , [1: True] )
• NORMALLYOPEN ( type: esriFieldTypeSmallInteger, alias: Normally Open, editable: true, nullable: true, defaultValue: 1, modelName: NORMALLYOPEN , Coded Values: [0: False] , [1: True] )
• TURNSTOCLOSE ( type: esriFieldTypeInteger, alias: Turns To Close, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• HYDRFLAG ( type: esriFieldTypeSmallInteger, alias: Hydrant Valve, editable: true, nullable: true, defaultValue: 0, modelName: HYDRFLAG , Coded Values: [0: False] , [1: True] )
• CURROPEN ( type: esriFieldTypeSmallInteger, alias: Currently Open, editable: true, nullable: true, defaultValue: 1, modelName: CURROPEN , Coded Values: [0: False] , [1: True] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• 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 )
• LABEL ( type: esriFieldTypeString, alias: Valve Type Label, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LABEL )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIAL )
• GPS_DATE ( type: esriFieldTypeDate, alias: Date of GPS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• GPS_USER ( type: esriFieldTypeString, alias: GPS User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GPS_USER )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 400, defaultValue: null, modelName: COMMENT )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed of Valve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED )
• 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 )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• VALVE_ID ( type: esriFieldTypeString, alias: Valve ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VALVE_ID )
• ServiceLineDepth ( type: esriFieldTypeString, alias: Service Line Depth, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ServiceLineDepth , Coded Values: [12: 12"] , [18: 18"] , [24: 24"] , ...6 more... )
• LASTEXERCISE ( type: esriFieldTypeDate, alias: Last Exercise Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTEXERCISE )
• VALVECONDITION ( type: esriFieldTypeString, alias: Valve Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVECONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• EXERCISENEEDED ( type: esriFieldTypeString, alias: Exercise Needed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXERCISENEEDED , Coded Values: [Yes: Yes] , [No: No] )
• BOXNEEDCLEAN ( type: esriFieldTypeString, alias: Box Need Clean, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXNEEDCLEAN , Coded Values: [Yes: Yes] , [No: No] )
• BOXCONDITION ( type: esriFieldTypeString, alias: Box Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXCONDITION , Coded Values: [Broken: Broken] , [Clean: Clean] , [Completed: Completed] , ...5 more... )
• NEEDSLID ( type: esriFieldTypeString, alias: Needs Lid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDSLID , Coded Values: [Yes: Yes] , [No: No] )
• GOODPACKING ( type: esriFieldTypeString, alias: Good Packing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GOODPACKING , Coded Values: [Yes: Yes] , [No: No] )
• NEEDSMAINT ( type: esriFieldTypeString, alias: Needs Maintenance, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDSMAINT , Coded Values: [Yes: Yes] , [No: No] )
• MAINTREQUIRED ( type: esriFieldTypeString, alias: Maintenance Required, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MAINTREQUIRED )
• VALVEDEPTH ( type: esriFieldTypeDouble, alias: Valve Depth, editable: true, nullable: true, defaultValue: null, modelName: VALVEDEPTH )
Types:
ID: 0
Name: False
Domains:
• DIAMETER:
  Inherited
• VALVETYPE:
  Inherited
• BYPASSVALVE:
  Inherited
• CLOCKTOCLOSE:
  Inherited
• NORMALLYOPEN:
  Inherited
• OPERABLE:
  Inherited
• HYDRFLAG:
  Inherited
• CURROPEN:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ServiceLineDepth:
  Inherited
• VALVECONDITION:
  Inherited
• EXERCISENEEDED:
  Inherited
• BOXNEEDCLEAN:
  Inherited
• BOXCONDITION:
  Inherited
• NEEDSLID:
  Inherited
• GOODPACKING:
  Inherited
• NEEDSMAINT:
  Inherited
Templates:
• Name: 0
  Description:
  Prototype:
  NEEDSMAINT: null
  GOODPACKING: null
  VALVECONDITION: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  VALVETYPE: null
  BYPASSVALVE: 0
  CLOCKTOCLOSE: 1
  NORMALLYOPEN: 1
  TURNSTOCLOSE: null
  OPERABLE: 0
  HYDRFLAG: 0
  CURROPEN: 1
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  NEEDSLID: null
  BOXCONDITION: null
  BOXNEEDCLEAN: null
  EXERCISENEEDED: null
  MAINTBY: 1
  LABEL: null
  MATERIAL: null
  GPS_DATE: null
  GPS_USER: null
  COMMENT: null
  WATERSHED: null
  LATITUDE: null
  LONGITUDE: null
  ELEVATION: null
  MAINTREQUIRED: null
  PRESSUREZN: null
  VALVE_ID: null
  ServiceLineDepth: null
  LASTEXERCISE: null
  VALVEDEPTH: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• COB_LGIM.DBO.wValveExerciseInfo (2) -- Related To: Water Valve Exercise Info (17)

Layer: Valves Excercised (5)

Name: Valves Excercised

Display Field: FACILITYID

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: 1405246.9421030954
YMin: 284437.8347388655
XMax: 1436848.5688603446
YMax: 341317.68948286027
Spatial Reference: 102697  (102697)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Exercised over 10 years ago - Box cleaning needed
  Label: Exercised over 10 years ago - Box cleaning needed
  Description: Exercised over 10 years ago - Box cleaning needed
  Symbol:
  
• Value: Exercised within last 8 years - Box cleaning needed
  Label: Exercised within last 8 years - Box cleaning needed
  Description: Exercised within last 8 years - Box cleaning needed
  Symbol:
  
• Value: Exercised within last 8 years - No box cleaning needed
  Label: Exercised within last 8 years - No box cleaning needed
  Description: Exercised within last 8 years - No box cleaning needed
  Symbol:
  
• Value: No exercise data - Box cleaning needed
  Label: No exercise data - Box cleaning needed
  Description: No exercise data - Box cleaning needed
  Symbol:
  
• Value: No exercise data - No box cleaning needed
  Label: No exercise data - No box cleaning needed
  Description: No exercise data - No box cleaning needed
  Symbol:
  
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: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVETYPE , Coded Values: [Plug: Plug] , [Other: Other] , [Unknown: Unknown] , ...10 more... )
• BYPASSVALVE ( type: esriFieldTypeSmallInteger, alias: Bypass Valve, editable: true, nullable: true, defaultValue: 0, modelName: BYPASSVALVE , Coded Values: [0: False] , [1: True] )
• CLOCKTOCLOSE ( type: esriFieldTypeSmallInteger, alias: Clockwise To Close, editable: true, nullable: true, defaultValue: 1, modelName: CLOCKTOCLOSE , Coded Values: [0: False] , [1: True] )
• NORMALLYOPEN ( type: esriFieldTypeSmallInteger, alias: Normally Open, editable: true, nullable: true, defaultValue: 1, modelName: NORMALLYOPEN , Coded Values: [0: False] , [1: True] )
• TURNSTOCLOSE ( type: esriFieldTypeInteger, alias: Turns To Close, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• HYDRFLAG ( type: esriFieldTypeSmallInteger, alias: Hydrant Valve, editable: true, nullable: true, defaultValue: 0, modelName: HYDRFLAG , Coded Values: [0: False] , [1: True] )
• CURROPEN ( type: esriFieldTypeSmallInteger, alias: Currently Open, editable: true, nullable: true, defaultValue: 1, modelName: CURROPEN , Coded Values: [0: False] , [1: True] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• 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 )
• LABEL ( type: esriFieldTypeString, alias: Valve Type Label, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LABEL )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIAL )
• GPS_DATE ( type: esriFieldTypeDate, alias: Date of GPS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• GPS_USER ( type: esriFieldTypeString, alias: GPS User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GPS_USER )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 400, defaultValue: null, modelName: COMMENT )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed of Valve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED )
• 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 )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• VALVE_ID ( type: esriFieldTypeString, alias: Valve ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VALVE_ID )
• ServiceLineDepth ( type: esriFieldTypeString, alias: Service Line Depth, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ServiceLineDepth , Coded Values: [12: 12"] , [18: 18"] , [24: 24"] , ...6 more... )
• LASTEXERCISE ( type: esriFieldTypeDate, alias: Last Exercise Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTEXERCISE )
• VALVECONDITION ( type: esriFieldTypeString, alias: Valve Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVECONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• EXERCISENEEDED ( type: esriFieldTypeString, alias: Exercise Needed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXERCISENEEDED , Coded Values: [Yes: Yes] , [No: No] )
• BOXNEEDCLEAN ( type: esriFieldTypeString, alias: Box Need Clean, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXNEEDCLEAN , Coded Values: [Yes: Yes] , [No: No] )
• BOXCONDITION ( type: esriFieldTypeString, alias: Box Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXCONDITION , Coded Values: [Broken: Broken] , [Clean: Clean] , [Completed: Completed] , ...5 more... )
• NEEDSLID ( type: esriFieldTypeString, alias: Needs Lid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDSLID , Coded Values: [Yes: Yes] , [No: No] )
• GOODPACKING ( type: esriFieldTypeString, alias: Good Packing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GOODPACKING , Coded Values: [Yes: Yes] , [No: No] )
• NEEDSMAINT ( type: esriFieldTypeString, alias: Needs Maintenance, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDSMAINT , Coded Values: [Yes: Yes] , [No: No] )
• MAINTREQUIRED ( type: esriFieldTypeString, alias: Maintenance Required, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MAINTREQUIRED )
• VALVEDEPTH ( type: esriFieldTypeDouble, alias: Valve Depth, editable: true, nullable: true, defaultValue: null, modelName: VALVEDEPTH )
Templates:
• Name: Water System Valves
  Description:
  Prototype:
  NEEDSMAINT: null
  GOODPACKING: null
  VALVECONDITION: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  VALVETYPE: null
  BYPASSVALVE: 0
  CLOCKTOCLOSE: 1
  NORMALLYOPEN: 1
  TURNSTOCLOSE: null
  OPERABLE: 1
  HYDRFLAG: 0
  CURROPEN: 1
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  NEEDSLID: null
  BOXCONDITION: null
  BOXNEEDCLEAN: null
  EXERCISENEEDED: null
  MAINTBY: 1
  LABEL: null
  MATERIAL: null
  GPS_DATE: null
  GPS_USER: null
  COMMENT: null
  WATERSHED: null
  LATITUDE: null
  LONGITUDE: null
  ELEVATION: null
  MAINTREQUIRED: null
  PRESSUREZN: null
  VALVE_ID: null
  ServiceLineDepth: null
  LASTEXERCISE: null
  VALVEDEPTH: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.wValveExerciseInfo (2) -- Related To: Water Valve Exercise Info (17)

Layer: Valves That Need Maintenance (7)

Name: Valves That Need Maintenance

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1405246.9421030954
YMin: 284437.8347388655
XMax: 1436848.5688603446
YMax: 341317.68948286027
Spatial Reference: 102697  (102697)



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: System-maintained ObjectID )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVETYPE , Coded Values: [Plug: Plug] , [Other: Other] , [Unknown: Unknown] , ...10 more... )
• 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 )
• VALVECONDITION ( type: esriFieldTypeString, alias: Valve Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVECONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• VALVEDEPTH ( type: esriFieldTypeDouble, alias: Valve Depth, editable: true, nullable: true, defaultValue: null, modelName: VALVEDEPTH )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• BYPASSVALVE ( type: esriFieldTypeSmallInteger, alias: Bypass Valve, editable: true, nullable: true, defaultValue: 0, modelName: BYPASSVALVE , Coded Values: [0: False] , [1: True] )
• CLOCKTOCLOSE ( type: esriFieldTypeSmallInteger, alias: Clockwise To Close, editable: true, nullable: true, defaultValue: 1, modelName: CLOCKTOCLOSE , Coded Values: [0: False] , [1: True] )
• NORMALLYOPEN ( type: esriFieldTypeSmallInteger, alias: Normally Open, editable: true, nullable: true, defaultValue: 1, modelName: NORMALLYOPEN , Coded Values: [0: False] , [1: True] )
• TURNSTOCLOSE ( type: esriFieldTypeInteger, alias: Turns To Close, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• HYDRFLAG ( type: esriFieldTypeSmallInteger, alias: Hydrant Valve, editable: true, nullable: true, defaultValue: 0, modelName: HYDRFLAG , Coded Values: [0: False] , [1: True] )
• CURROPEN ( type: esriFieldTypeSmallInteger, alias: Currently Open, editable: true, nullable: true, defaultValue: 1, modelName: CURROPEN , Coded Values: [0: False] , [1: True] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• LABEL ( type: esriFieldTypeString, alias: Valve Type Label, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LABEL )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIAL )
• GPS_DATE ( type: esriFieldTypeDate, alias: Date of GPS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• GPS_USER ( type: esriFieldTypeString, alias: GPS User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GPS_USER )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 400, defaultValue: null, modelName: COMMENT )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed of Valve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED )
• 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 )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• VALVE_ID ( type: esriFieldTypeString, alias: Valve ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VALVE_ID )
• ServiceLineDepth ( type: esriFieldTypeString, alias: Service Line Depth, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ServiceLineDepth , Coded Values: [12: 12"] , [18: 18"] , [24: 24"] , ...6 more... )
• LASTEXERCISE ( type: esriFieldTypeDate, alias: Last Exercise Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTEXERCISE )
• EXERCISENEEDED ( type: esriFieldTypeString, alias: Exercise Needed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXERCISENEEDED , Coded Values: [Yes: Yes] , [No: No] )
• BOXNEEDCLEAN ( type: esriFieldTypeString, alias: Box Need Clean, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXNEEDCLEAN , Coded Values: [Yes: Yes] , [No: No] )
• BOXCONDITION ( type: esriFieldTypeString, alias: Box Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXCONDITION , Coded Values: [Broken: Broken] , [Clean: Clean] , [Completed: Completed] , ...5 more... )
• NEEDSLID ( type: esriFieldTypeString, alias: Needs Lid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDSLID , Coded Values: [Yes: Yes] , [No: No] )
• GOODPACKING ( type: esriFieldTypeString, alias: Good Packing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GOODPACKING , Coded Values: [Yes: Yes] , [No: No] )
• NEEDSMAINT ( type: esriFieldTypeString, alias: Needs Maintenance, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDSMAINT , Coded Values: [Yes: Yes] , [No: No] )
• MAINTREQUIRED ( type: esriFieldTypeString, alias: Maintenance Required, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MAINTREQUIRED )
Templates:
• Name: Valves That Need Maintenance
  Description:
  Prototype:
  NEEDSMAINT: null
  GOODPACKING: null
  VALVEDEPTH: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  LASTEXERCISE: null
  DIAMETER: null
  BYPASSVALVE: 0
  CLOCKTOCLOSE: 1
  NORMALLYOPEN: 1
  TURNSTOCLOSE: null
  OPERABLE: 1
  HYDRFLAG: 0
  CURROPEN: 1
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  NEEDSLID: null
  BOXCONDITION: null
  BOXNEEDCLEAN: null
  EXERCISENEEDED: null
  MAINTBY: 1
  LABEL: null
  MATERIAL: null
  GPS_DATE: null
  GPS_USER: null
  COMMENT: null
  WATERSHED: null
  LATITUDE: null
  LONGITUDE: null
  ELEVATION: null
  VALVECONDITION: null
  PRESSUREZN: null
  VALVE_ID: null
  ServiceLineDepth: null
  VALVETYPE: null
  MAINTREQUIRED: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.wValveExerciseInfo (2) -- Related To: Water Valve Exercise Info (17)

Layer: Valves That Need Lids (8)

Name: Valves That Need Lids

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1405246.9421030954
YMin: 284437.8347388655
XMax: 1436848.5688603446
YMax: 341317.68948286027
Spatial Reference: 102697  (102697)



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: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVETYPE , Coded Values: [Plug: Plug] , [Other: Other] , [Unknown: Unknown] , ...10 more... )
• BYPASSVALVE ( type: esriFieldTypeSmallInteger, alias: Bypass Valve, editable: true, nullable: true, defaultValue: 0, modelName: BYPASSVALVE , Coded Values: [0: False] , [1: True] )
• CLOCKTOCLOSE ( type: esriFieldTypeSmallInteger, alias: Clockwise To Close, editable: true, nullable: true, defaultValue: 1, modelName: CLOCKTOCLOSE , Coded Values: [0: False] , [1: True] )
• NORMALLYOPEN ( type: esriFieldTypeSmallInteger, alias: Normally Open, editable: true, nullable: true, defaultValue: 1, modelName: NORMALLYOPEN , Coded Values: [0: False] , [1: True] )
• TURNSTOCLOSE ( type: esriFieldTypeInteger, alias: Turns To Close, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• HYDRFLAG ( type: esriFieldTypeSmallInteger, alias: Hydrant Valve, editable: true, nullable: true, defaultValue: 0, modelName: HYDRFLAG , Coded Values: [0: False] , [1: True] )
• CURROPEN ( type: esriFieldTypeSmallInteger, alias: Currently Open, editable: true, nullable: true, defaultValue: 1, modelName: CURROPEN , Coded Values: [0: False] , [1: True] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• 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 )
• LABEL ( type: esriFieldTypeString, alias: Valve Type Label, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LABEL )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIAL )
• GPS_DATE ( type: esriFieldTypeDate, alias: Date of GPS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• GPS_USER ( type: esriFieldTypeString, alias: GPS User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GPS_USER )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 400, defaultValue: null, modelName: COMMENT )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed of Valve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED )
• 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 )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• VALVE_ID ( type: esriFieldTypeString, alias: Valve ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VALVE_ID )
• ServiceLineDepth ( type: esriFieldTypeString, alias: Service Line Depth, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ServiceLineDepth , Coded Values: [12: 12"] , [18: 18"] , [24: 24"] , ...6 more... )
• LASTEXERCISE ( type: esriFieldTypeDate, alias: Last Exercise Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTEXERCISE )
• VALVECONDITION ( type: esriFieldTypeString, alias: Valve Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVECONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• EXERCISENEEDED ( type: esriFieldTypeString, alias: Exercise Needed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXERCISENEEDED , Coded Values: [Yes: Yes] , [No: No] )
• BOXNEEDCLEAN ( type: esriFieldTypeString, alias: Box Need Clean, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXNEEDCLEAN , Coded Values: [Yes: Yes] , [No: No] )
• BOXCONDITION ( type: esriFieldTypeString, alias: Box Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXCONDITION , Coded Values: [Broken: Broken] , [Clean: Clean] , [Completed: Completed] , ...5 more... )
• NEEDSLID ( type: esriFieldTypeString, alias: Needs Lid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDSLID , Coded Values: [Yes: Yes] , [No: No] )
• GOODPACKING ( type: esriFieldTypeString, alias: Good Packing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GOODPACKING , Coded Values: [Yes: Yes] , [No: No] )
• NEEDSMAINT ( type: esriFieldTypeString, alias: Needs Maintenance, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDSMAINT , Coded Values: [Yes: Yes] , [No: No] )
• MAINTREQUIRED ( type: esriFieldTypeString, alias: Maintenance Required, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MAINTREQUIRED )
• VALVEDEPTH ( type: esriFieldTypeDouble, alias: Valve Depth, editable: true, nullable: true, defaultValue: null, modelName: VALVEDEPTH )
Templates:
• Name: Valves That Need Lids
  Description:
  Prototype:
  NEEDSMAINT: null
  GOODPACKING: null
  VALVECONDITION: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  VALVETYPE: null
  BYPASSVALVE: 0
  CLOCKTOCLOSE: 1
  NORMALLYOPEN: 1
  TURNSTOCLOSE: null
  OPERABLE: 1
  HYDRFLAG: 0
  CURROPEN: 1
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  NEEDSLID: null
  BOXCONDITION: null
  BOXNEEDCLEAN: null
  EXERCISENEEDED: null
  MAINTBY: 1
  LABEL: null
  MATERIAL: null
  GPS_DATE: null
  GPS_USER: null
  COMMENT: null
  WATERSHED: null
  LATITUDE: null
  LONGITUDE: null
  ELEVATION: null
  MAINTREQUIRED: null
  PRESSUREZN: null
  VALVE_ID: null
  ServiceLineDepth: null
  LASTEXERCISE: null
  VALVEDEPTH: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.wValveExerciseInfo (2) -- Related To: Water Valve Exercise Info (17)

Layer: Replace Hydrants (10)

Name: Replace Hydrants

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1402335.1323099285
YMin: 278390.5256392807
XMax: 1433650.7022245936
YMax: 334528.55345486104
Spatial Reference: 102697  (102697)



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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Dresser: Dresser] , ...8 more... )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• LASTSERVICE ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• FLOW ( type: esriFieldTypeDouble, alias: Flow Rate (GPM), editable: true, nullable: true, defaultValue: null, modelName: FLOW )
• 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 )
• ID_FIELD ( type: esriFieldTypeString, alias: Hydrant ID Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ID_FIELD )
• H2OR3WAY ( type: esriFieldTypeString, alias: 2 or 3 Way Hydrant, editable: true, nullable: true, length: 10, defaultValue: null, modelName: H2OR3WAY , Coded Values: [2 Way: 2 Way] , [3 Way: 3 Way] )
• PAINT ( type: esriFieldTypeString, alias: Hydrant Paint, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PAINT )
• WATER_MAIN ( type: esriFieldTypeString, alias: Water Main, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATER_MAIN )
• GRID_ID ( type: esriFieldTypeString, alias: Map Grid ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GRID_ID )
• FLOW_CLASS ( type: esriFieldTypeString, alias: Flow Class, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FLOW_CLASS )
• STATIC ( type: esriFieldTypeInteger, alias: Static, editable: true, nullable: true, defaultValue: null, modelName: STATIC )
• RESIDUAL ( type: esriFieldTypeInteger, alias: Residual, editable: true, nullable: true, defaultValue: null, modelName: RESIDUAL )
• OPENING ( type: esriFieldTypeDouble, alias: Opening, editable: true, nullable: true, defaultValue: null, modelName: OPENING )
• PSI ( type: esriFieldTypeSmallInteger, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PITOT )
• DATE ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• CREW ( type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CREW )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 400, defaultValue: null, modelName: NOTES )
• LAT_DMS ( type: esriFieldTypeString, alias: Latitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAT_DMS )
• LONG_DMS ( type: esriFieldTypeString, alias: Longitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LONG_DMS )
• STREET_NUM ( type: esriFieldTypeSmallInteger, alias: Street Address Number, editable: true, nullable: true, defaultValue: null, modelName: STREET_NUM )
• STREET_DIR ( type: esriFieldTypeString, alias: Street Address Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STREET_DIR )
• STREET_NAME ( type: esriFieldTypeString, alias: Street Address Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_NAME )
• STREET_TYPE ( type: esriFieldTypeString, alias: Street Address Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STREET_TYPE )
• UNIT ( type: esriFieldTypeString, alias: Street Address Unit, editable: true, nullable: true, length: 15, defaultValue: null, modelName: UNIT )
• OKAY ( type: esriFieldTypeString, alias: Data Review Code, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OKAY )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• YR_PAINT ( type: esriFieldTypeString, alias: Year Painted, editable: true, nullable: true, length: 10, defaultValue: null, modelName: YR_PAINT )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• WATER_MAIN_DIA ( type: esriFieldTypeDouble, alias: Water Main Diameter, editable: true, nullable: true, defaultValue: null, modelName: WATER_MAIN_DIA )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• UT_HYD_ID ( type: esriFieldTypeString, alias: Utilities Hydrant ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UT_HYD_ID )
• HYDRANT_YEAR ( type: esriFieldTypeInteger, alias: Year Hydrant Built, editable: true, nullable: true, defaultValue: null, modelName: HYDRANT_YEAR )
• HYD_SIZE ( type: esriFieldTypeString, alias: Hydrant Size, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_SIZE , Coded Values: [5 1/4: 5 1/4] , [4 1/4: 4 1/4] )
• HYD_VLV ( type: esriFieldTypeString, alias: Hydrant Valve Yes/No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_VLV , Coded Values: [Yes: Yes] , [No: No] )
• LATITUDE_DD ( type: esriFieldTypeString, alias: Latitude Decimal Degrees, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LATITUDE_DD )
• LONGITUDE_DD ( type: esriFieldTypeString, alias: Longitude Decimal Degrees, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LONGITUDE_DD )
• LAST_INSPECTION_DATE ( type: esriFieldTypeDate, alias: Date of Last Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_INSPECTION_DATE )
• INSPECTION_STATUS ( type: esriFieldTypeString, alias: Hydrant Inspection Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTION_STATUS , Coded Values: [Inspected within a year: Inspected within a year] , [Inspected more than a year ago: Inspected more than a year ago] , [No Data: No Data] )
• NEEDS_REPAIR ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDS_REPAIR , Coded Values: [Yes: Yes] , [No: No] )
• NEEDS_PAINT ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDS_PAINT , Coded Values: [Yes: Yes] , [No: No] )
• LEAKING ( type: esriFieldTypeString, alias: Leaking, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEAKING , Coded Values: [Yes: Yes] , [No: No] )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
Templates:
• Name: Replace Hydrants
  Description:
  Prototype:
  NEEDS_PAINT: null
  NEEDS_REPAIR: null
  HYD_VLV: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: 1
  LASTSERVICE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  INSPECTION_STATUS: null
  LAST_INSPECTION_DATE: null
  LONGITUDE_DD: null
  LATITUDE_DD: null
  FLOW: null
  ID_FIELD: null
  H2OR3WAY: null
  PAINT: null
  WATER_MAIN: null
  GRID_ID: null
  FLOW_CLASS: null
  STATIC: null
  RESIDUAL: null
  OPENING: null
  PSI: null
  DATE: null
  CREW: null
  NOTES: null
  LAT_DMS: null
  LONG_DMS: null
  STREET_NUM: null
  STREET_DIR: null
  STREET_NAME: null
  STREET_TYPE: null
  UNIT: null
  OKAY: null
  WATERSHED: null
  PRESSUREZN: null
  YR_PAINT: null
  CONDITION: null
  LEAKING: null
  WATER_MAIN_DIA: null
  UT_HYD_ID: null
  HYDRANT_YEAR: null
  HYD_SIZE: null
  GUID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Layer: Hydrants Inspected This Calender Year (11)

Name: Hydrants Inspected This Calender Year

Display Field: HydrantID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1405248.603845179
YMin: 284435.5325781107
XMax: 1431314.90407468
YMax: 311617.4034111127
Spatial Reference: 102697  (102697)



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 )
• Operable ( type: esriFieldTypeString, alias: Operable, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Operable , Coded Values: [Yes: Yes] , [No: No] )
• 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 )
• PSI ( type: esriFieldTypeDouble, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PSI )
• Date ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Notes )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Leaking ( type: esriFieldTypeString, alias: Leaking, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Leaking , Coded Values: [Yes: Yes] , [No: No] )
• Id ( type: esriFieldTypeInteger, alias: Id, editable: true, nullable: true, defaultValue: null, modelName: Id )
• HydrantID ( type: esriFieldTypeString, alias: HydrantID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HydrantID )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Location )
• Critical ( type: esriFieldTypeString, alias: Critical, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Critical , Coded Values: [Yes: Yes] , [No: No] )
• MaintPerf ( type: esriFieldTypeString, alias: MaintPerf, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintPerf , Coded Values: [Yes: Yes] , [No: No] )
• Valve ( type: esriFieldTypeString, alias: Valve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Valve , Coded Values: [Yes: Yes] , [No: No] )
• NeedsPaint ( type: esriFieldTypeString, alias: NeedsPaint, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NeedsPaint , Coded Values: [Yes: Yes] , [No: No] )
• OilGrease ( type: esriFieldTypeString, alias: OilGrease, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OilGrease , Coded Values: [Yes: Yes] , [No: No] )
• BCoupling ( type: esriFieldTypeString, alias: BCoupling, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BCoupling , Coded Values: [Yes: Yes] , [No: No] )
• BrokenStem ( type: esriFieldTypeString, alias: BrokenStem, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BrokenStem , Coded Values: [Yes: Yes] , [No: No] )
• DefMissCap ( type: esriFieldTypeString, alias: DefMissCap, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DefMissCap , Coded Values: [Yes: Yes] , [No: No] )
• HardToOpen ( type: esriFieldTypeString, alias: HardToOpen, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HardToOpen , Coded Values: [Yes: Yes] , [No: No] )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• FLUSHED ( type: esriFieldTypeDouble, alias: Amount Flushed, editable: true, nullable: true, defaultValue: null, modelName: FLUSHED )
• PLANTFLUSH ( type: esriFieldTypeDouble, alias: Water Plant Amount Flushed, editable: true, nullable: true, defaultValue: null, modelName: PLANTFLUSH )
• SERVICED ( type: esriFieldTypeString, alias: Serviced, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SERVICED , Coded Values: [Yes: Yes] , [No: No] )
Templates:
• Name: Hydrants Inspected This Calender Year
  Description:
  Prototype:
  NEEDS_PAINT: null
  NEEDS_REPAIR: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  MANUFACTURER: null
  HYD_VLV: null
  LASTSERVICE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  FLOW: null
  INSPECTION_STATUS: null
  LAST_INSPECTION_DATE: null
  LONGITUDE_DD: null
  LATITUDE_DD: null
  ID_FIELD: null
  H2OR3WAY: null
  PAINT: null
  WATER_MAIN: null
  GRID_ID: null
  FLOW_CLASS: null
  STATIC: null
  RESIDUAL: null
  OPENING: null
  Operable: 1
  PSI: null
  CREW: null
  Date: null
  LAT_DMS: null
  LONG_DMS: null
  STREET_NUM: null
  STREET_DIR: null
  STREET_NAME: null
  STREET_TYPE: null
  UNIT: null
  OKAY: null
  WATERSHED: null
  PRESSUREZN: null
  YR_PAINT: null
  CONDITION: null
  WATER_MAIN_DIA: null
  Notes: null
  UT_HYD_ID: null
  HYDRANT_YEAR: null
  HYD_SIZE: null
  Leaking: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.wHydrant (4) -- Related To: Water Hydrants Not Owned By Branson (9)

Layer: Water Hydrants Not Owned By Branson (9)

Name: Water Hydrants Not Owned By Branson

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1402335.1323099285
YMin: 278389.1906681955
XMax: 1433650.7022245936
YMax: 334528.55345486104
Spatial Reference: 102697  (102697)



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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Dresser: Dresser] , ...8 more... )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• LASTSERVICE ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• FLOW ( type: esriFieldTypeDouble, alias: Flow Rate (GPM), editable: true, nullable: true, defaultValue: null, modelName: FLOW )
• 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 )
• ID_FIELD ( type: esriFieldTypeString, alias: Hydrant ID Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ID_FIELD )
• H2OR3WAY ( type: esriFieldTypeString, alias: 2 or 3 Way Hydrant, editable: true, nullable: true, length: 10, defaultValue: null, modelName: H2OR3WAY , Coded Values: [2 Way: 2 Way] , [3 Way: 3 Way] )
• PAINT ( type: esriFieldTypeString, alias: Hydrant Paint, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PAINT )
• WATER_MAIN ( type: esriFieldTypeString, alias: Water Main, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATER_MAIN )
• GRID_ID ( type: esriFieldTypeString, alias: Map Grid ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GRID_ID )
• FLOW_CLASS ( type: esriFieldTypeString, alias: Flow Class, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FLOW_CLASS )
• STATIC ( type: esriFieldTypeInteger, alias: Static, editable: true, nullable: true, defaultValue: null, modelName: STATIC )
• RESIDUAL ( type: esriFieldTypeInteger, alias: Residual, editable: true, nullable: true, defaultValue: null, modelName: RESIDUAL )
• OPENING ( type: esriFieldTypeDouble, alias: Opening, editable: true, nullable: true, defaultValue: null, modelName: OPENING )
• PSI ( type: esriFieldTypeSmallInteger, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PITOT )
• DATE ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• CREW ( type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CREW )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 400, defaultValue: null, modelName: NOTES )
• LAT_DMS ( type: esriFieldTypeString, alias: Latitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAT_DMS )
• LONG_DMS ( type: esriFieldTypeString, alias: Longitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LONG_DMS )
• STREET_NUM ( type: esriFieldTypeSmallInteger, alias: Street Address Number, editable: true, nullable: true, defaultValue: null, modelName: STREET_NUM )
• STREET_DIR ( type: esriFieldTypeString, alias: Street Address Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STREET_DIR )
• STREET_NAME ( type: esriFieldTypeString, alias: Street Address Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_NAME )
• STREET_TYPE ( type: esriFieldTypeString, alias: Street Address Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STREET_TYPE )
• UNIT ( type: esriFieldTypeString, alias: Street Address Unit, editable: true, nullable: true, length: 15, defaultValue: null, modelName: UNIT )
• OKAY ( type: esriFieldTypeString, alias: Data Review Code, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OKAY )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• YR_PAINT ( type: esriFieldTypeString, alias: Year Painted, editable: true, nullable: true, length: 10, defaultValue: null, modelName: YR_PAINT )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• WATER_MAIN_DIA ( type: esriFieldTypeDouble, alias: Water Main Diameter, editable: true, nullable: true, defaultValue: null, modelName: WATER_MAIN_DIA )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• UT_HYD_ID ( type: esriFieldTypeString, alias: Utilities Hydrant ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UT_HYD_ID )
• HYDRANT_YEAR ( type: esriFieldTypeInteger, alias: Year Hydrant Built, editable: true, nullable: true, defaultValue: null, modelName: HYDRANT_YEAR )
• HYD_SIZE ( type: esriFieldTypeString, alias: Hydrant Size, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_SIZE , Coded Values: [5 1/4: 5 1/4] , [4 1/4: 4 1/4] )
• HYD_VLV ( type: esriFieldTypeString, alias: Hydrant Valve Yes/No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_VLV , Coded Values: [Yes: Yes] , [No: No] )
• LATITUDE_DD ( type: esriFieldTypeString, alias: Latitude Decimal Degrees, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LATITUDE_DD )
• LONGITUDE_DD ( type: esriFieldTypeString, alias: Longitude Decimal Degrees, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LONGITUDE_DD )
• LAST_INSPECTION_DATE ( type: esriFieldTypeDate, alias: Date of Last Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_INSPECTION_DATE )
• INSPECTION_STATUS ( type: esriFieldTypeString, alias: Hydrant Inspection Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTION_STATUS , Coded Values: [Inspected within a year: Inspected within a year] , [Inspected more than a year ago: Inspected more than a year ago] , [No Data: No Data] )
• NEEDS_REPAIR ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDS_REPAIR , Coded Values: [Yes: Yes] , [No: No] )
• NEEDS_PAINT ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDS_PAINT , Coded Values: [Yes: Yes] , [No: No] )
• LEAKING ( type: esriFieldTypeString, alias: Leaking, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEAKING , Coded Values: [Yes: Yes] , [No: No] )
Templates:
• Name: Water Hydrants Not Owned By Branson
  Description:
  Prototype:
  NEEDS_REPAIR: null
  INSPECTION_STATUS: null
  HYD_SIZE: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: 1
  LASTSERVICE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  LAST_INSPECTION_DATE: null
  LONGITUDE_DD: null
  LATITUDE_DD: null
  HYD_VLV: null
  FLOW: null
  ID_FIELD: null
  H2OR3WAY: null
  PAINT: null
  WATER_MAIN: null
  GRID_ID: null
  FLOW_CLASS: null
  STATIC: null
  RESIDUAL: null
  OPENING: null
  PSI: null
  DATE: null
  CREW: null
  NOTES: null
  LAT_DMS: null
  LONG_DMS: null
  STREET_NUM: null
  STREET_DIR: null
  STREET_NAME: null
  STREET_TYPE: null
  UNIT: null
  OKAY: null
  WATERSHED: null
  PRESSUREZN: null
  YR_PAINT: null
  CONDITION: null
  NEEDS_PAINT: null
  WATER_MAIN_DIA: null
  UT_HYD_ID: null
  HYDRANT_YEAR: null
  LEAKING: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• HydrantInspectionsREL (5) -- Related To: HydrantInspections (22)
• COB_LGIM.DBO.HydrantInspectionInfo (4) -- Related To: Hydrants Inspected This Calender Year (11)

Layer: Water Hydrants Not Operable (13)

Name: Water Hydrants Not Operable

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1402335.1323099285
YMin: 278389.1906681955
XMax: 1433650.7022245936
YMax: 334528.55345486104
Spatial Reference: 102697  (102697)



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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Dresser: Dresser] , ...8 more... )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• LASTSERVICE ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• FLOW ( type: esriFieldTypeDouble, alias: Flow Rate (GPM), editable: true, nullable: true, defaultValue: null, modelName: FLOW )
• 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 )
• ID_FIELD ( type: esriFieldTypeString, alias: Hydrant ID Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ID_FIELD )
• H2OR3WAY ( type: esriFieldTypeString, alias: 2 or 3 Way Hydrant, editable: true, nullable: true, length: 10, defaultValue: null, modelName: H2OR3WAY , Coded Values: [2 Way: 2 Way] , [3 Way: 3 Way] )
• PAINT ( type: esriFieldTypeString, alias: Hydrant Paint, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PAINT )
• WATER_MAIN ( type: esriFieldTypeString, alias: Water Main, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATER_MAIN )
• GRID_ID ( type: esriFieldTypeString, alias: Map Grid ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GRID_ID )
• FLOW_CLASS ( type: esriFieldTypeString, alias: Flow Class, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FLOW_CLASS )
• STATIC ( type: esriFieldTypeInteger, alias: Static, editable: true, nullable: true, defaultValue: null, modelName: STATIC )
• RESIDUAL ( type: esriFieldTypeInteger, alias: Residual, editable: true, nullable: true, defaultValue: null, modelName: RESIDUAL )
• OPENING ( type: esriFieldTypeDouble, alias: Opening, editable: true, nullable: true, defaultValue: null, modelName: OPENING )
• PSI ( type: esriFieldTypeSmallInteger, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PITOT )
• DATE ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• CREW ( type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CREW )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 400, defaultValue: null, modelName: NOTES )
• LAT_DMS ( type: esriFieldTypeString, alias: Latitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAT_DMS )
• LONG_DMS ( type: esriFieldTypeString, alias: Longitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LONG_DMS )
• STREET_NUM ( type: esriFieldTypeSmallInteger, alias: Street Address Number, editable: true, nullable: true, defaultValue: null, modelName: STREET_NUM )
• STREET_DIR ( type: esriFieldTypeString, alias: Street Address Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STREET_DIR )
• STREET_NAME ( type: esriFieldTypeString, alias: Street Address Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_NAME )
• STREET_TYPE ( type: esriFieldTypeString, alias: Street Address Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STREET_TYPE )
• UNIT ( type: esriFieldTypeString, alias: Street Address Unit, editable: true, nullable: true, length: 15, defaultValue: null, modelName: UNIT )
• OKAY ( type: esriFieldTypeString, alias: Data Review Code, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OKAY )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• YR_PAINT ( type: esriFieldTypeString, alias: Year Painted, editable: true, nullable: true, length: 10, defaultValue: null, modelName: YR_PAINT )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• WATER_MAIN_DIA ( type: esriFieldTypeDouble, alias: Water Main Diameter, editable: true, nullable: true, defaultValue: null, modelName: WATER_MAIN_DIA )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• UT_HYD_ID ( type: esriFieldTypeString, alias: Utilities Hydrant ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UT_HYD_ID )
• HYDRANT_YEAR ( type: esriFieldTypeInteger, alias: Year Hydrant Built, editable: true, nullable: true, defaultValue: null, modelName: HYDRANT_YEAR )
• HYD_SIZE ( type: esriFieldTypeString, alias: Hydrant Size, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_SIZE , Coded Values: [5 1/4: 5 1/4] , [4 1/4: 4 1/4] )
• HYD_VLV ( type: esriFieldTypeString, alias: Hydrant Valve Yes/No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_VLV , Coded Values: [Yes: Yes] , [No: No] )
• LATITUDE_DD ( type: esriFieldTypeString, alias: Latitude Decimal Degrees, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LATITUDE_DD )
• LONGITUDE_DD ( type: esriFieldTypeString, alias: Longitude Decimal Degrees, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LONGITUDE_DD )
• LAST_INSPECTION_DATE ( type: esriFieldTypeDate, alias: Date of Last Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_INSPECTION_DATE )
• INSPECTION_STATUS ( type: esriFieldTypeString, alias: Hydrant Inspection Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTION_STATUS , Coded Values: [Inspected within a year: Inspected within a year] , [Inspected more than a year ago: Inspected more than a year ago] , [No Data: No Data] )
• NEEDS_REPAIR ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDS_REPAIR , Coded Values: [Yes: Yes] , [No: No] )
• NEEDS_PAINT ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDS_PAINT , Coded Values: [Yes: Yes] , [No: No] )
• LEAKING ( type: esriFieldTypeString, alias: Leaking, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEAKING , Coded Values: [Yes: Yes] , [No: No] )
Templates:
• Name: Water Hydrants Not Operable
  Description:
  Prototype:
  NEEDS_REPAIR: null
  INSPECTION_STATUS: null
  HYD_SIZE: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: 1
  LASTSERVICE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  LAST_INSPECTION_DATE: null
  LONGITUDE_DD: null
  LATITUDE_DD: null
  HYD_VLV: null
  FLOW: null
  ID_FIELD: null
  H2OR3WAY: null
  PAINT: null
  WATER_MAIN: null
  GRID_ID: null
  FLOW_CLASS: null
  STATIC: null
  RESIDUAL: null
  OPENING: null
  PSI: null
  DATE: null
  CREW: null
  NOTES: null
  LAT_DMS: null
  LONG_DMS: null
  STREET_NUM: null
  STREET_DIR: null
  STREET_NAME: null
  STREET_TYPE: null
  UNIT: null
  OKAY: null
  WATERSHED: null
  PRESSUREZN: null
  YR_PAINT: null
  CONDITION: null
  NEEDS_PAINT: null
  WATER_MAIN_DIA: null
  UT_HYD_ID: null
  HYDRANT_YEAR: null
  LEAKING: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• HydrantInspectionsREL (5) -- Related To: HydrantInspections (22)
• COB_LGIM.DBO.HydrantInspectionInfo (4) -- Related To: Hydrants Inspected This Calender Year (11)

Layer: Water Hydrants Inspected (12)

Name: Water Hydrants Inspected

Display Field: STREET_NAME

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: 1402335.1323099285
YMin: 278389.1906681955
XMax: 1433650.7022245936
YMax: 334528.55345486104
Spatial Reference: 102697  (102697)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Inspected over a year ago - No repair needed
  Label: Inspected over a year ago - No repair needed
  Description: Inspected over a year ago - No repair needed
  Symbol:
  
• Value: Inspected over a year ago - Repair needed
  Label: Inspected over a year ago - Repair needed
  Description: Inspected over a year ago - Repair needed
  Symbol:
  
• Value: Inspected within last year - No repair needed
  Label: Inspected within last year - No repair needed
  Description: Inspected within last year - No repair needed
  Symbol:
  
• Value: Inspected within last year - Repair needed
  Label: Inspected within last year - Repair needed
  Description: Inspected within last year - Repair needed
  Symbol:
  
• Value: No inspection data - No repair needed
  Label: No inspection data - No repair needed
  Description: No inspection data - No repair needed
  Symbol:
  
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Dresser: Dresser] , ...8 more... )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• LASTSERVICE ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• FLOW ( type: esriFieldTypeDouble, alias: Flow Rate (GPM), editable: true, nullable: true, defaultValue: null, modelName: FLOW )
• 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 )
• ID_FIELD ( type: esriFieldTypeString, alias: Hydrant ID Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ID_FIELD )
• H2OR3WAY ( type: esriFieldTypeString, alias: 2 or 3 Way Hydrant, editable: true, nullable: true, length: 10, defaultValue: null, modelName: H2OR3WAY , Coded Values: [2 Way: 2 Way] , [3 Way: 3 Way] )
• PAINT ( type: esriFieldTypeString, alias: Hydrant Paint, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PAINT )
• WATER_MAIN ( type: esriFieldTypeString, alias: Water Main, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATER_MAIN )
• GRID_ID ( type: esriFieldTypeString, alias: Map Grid ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GRID_ID )
• FLOW_CLASS ( type: esriFieldTypeString, alias: Flow Class, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FLOW_CLASS )
• STATIC ( type: esriFieldTypeInteger, alias: Static, editable: true, nullable: true, defaultValue: null, modelName: STATIC )
• RESIDUAL ( type: esriFieldTypeInteger, alias: Residual, editable: true, nullable: true, defaultValue: null, modelName: RESIDUAL )
• OPENING ( type: esriFieldTypeDouble, alias: Opening, editable: true, nullable: true, defaultValue: null, modelName: OPENING )
• PSI ( type: esriFieldTypeSmallInteger, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PITOT )
• DATE ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• CREW ( type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CREW )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 400, defaultValue: null, modelName: NOTES )
• LAT_DMS ( type: esriFieldTypeString, alias: Latitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAT_DMS )
• LONG_DMS ( type: esriFieldTypeString, alias: Longitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LONG_DMS )
• STREET_NUM ( type: esriFieldTypeSmallInteger, alias: Street Address Number, editable: true, nullable: true, defaultValue: null, modelName: STREET_NUM )
• STREET_DIR ( type: esriFieldTypeString, alias: Street Address Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STREET_DIR )
• STREET_NAME ( type: esriFieldTypeString, alias: Street Address Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_NAME )
• STREET_TYPE ( type: esriFieldTypeString, alias: Street Address Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STREET_TYPE )
• UNIT ( type: esriFieldTypeString, alias: Street Address Unit, editable: true, nullable: true, length: 15, defaultValue: null, modelName: UNIT )
• OKAY ( type: esriFieldTypeString, alias: Data Review Code, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OKAY )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• YR_PAINT ( type: esriFieldTypeString, alias: Year Painted, editable: true, nullable: true, length: 10, defaultValue: null, modelName: YR_PAINT )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• WATER_MAIN_DIA ( type: esriFieldTypeDouble, alias: Water Main Diameter, editable: true, nullable: true, defaultValue: null, modelName: WATER_MAIN_DIA )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• UT_HYD_ID ( type: esriFieldTypeString, alias: Utilities Hydrant ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UT_HYD_ID )
• HYDRANT_YEAR ( type: esriFieldTypeInteger, alias: Year Hydrant Built, editable: true, nullable: true, defaultValue: null, modelName: HYDRANT_YEAR )
• HYD_SIZE ( type: esriFieldTypeString, alias: Hydrant Size, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_SIZE , Coded Values: [5 1/4: 5 1/4] , [4 1/4: 4 1/4] )
• HYD_VLV ( type: esriFieldTypeString, alias: Hydrant Valve Yes/No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_VLV , Coded Values: [Yes: Yes] , [No: No] )
• LATITUDE_DD ( type: esriFieldTypeString, alias: Latitude Decimal Degrees, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LATITUDE_DD )
• LONGITUDE_DD ( type: esriFieldTypeString, alias: Longitude Decimal Degrees, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LONGITUDE_DD )
• LAST_INSPECTION_DATE ( type: esriFieldTypeDate, alias: Date of Last Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_INSPECTION_DATE )
• INSPECTION_STATUS ( type: esriFieldTypeString, alias: Hydrant Inspection Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTION_STATUS , Coded Values: [Inspected within a year: Inspected within a year] , [Inspected more than a year ago: Inspected more than a year ago] , [No Data: No Data] )
• NEEDS_REPAIR ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDS_REPAIR , Coded Values: [Yes: Yes] , [No: No] )
• NEEDS_PAINT ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDS_PAINT , Coded Values: [Yes: Yes] , [No: No] )
• LEAKING ( type: esriFieldTypeString, alias: Leaking, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEAKING , Coded Values: [Yes: Yes] , [No: No] )
Templates:
• Name: Water Hydrants
  Description:
  Prototype:
  NEEDS_REPAIR: null
  INSPECTION_STATUS: null
  HYD_SIZE: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: 1
  LASTSERVICE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  LAST_INSPECTION_DATE: null
  LONGITUDE_DD: null
  LATITUDE_DD: null
  HYD_VLV: null
  FLOW: null
  ID_FIELD: null
  H2OR3WAY: null
  PAINT: null
  WATER_MAIN: null
  GRID_ID: null
  FLOW_CLASS: null
  STATIC: null
  RESIDUAL: null
  OPENING: null
  PSI: null
  DATE: null
  CREW: null
  NOTES: null
  LAT_DMS: null
  LONG_DMS: null
  STREET_NUM: null
  STREET_DIR: null
  STREET_NAME: null
  STREET_TYPE: null
  UNIT: null
  OKAY: null
  WATERSHED: null
  PRESSUREZN: null
  YR_PAINT: null
  CONDITION: null
  NEEDS_PAINT: null
  WATER_MAIN_DIA: null
  UT_HYD_ID: null
  HYDRANT_YEAR: null
  LEAKING: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• HydrantInspectionsREL (5) -- Related To: HydrantInspections (22)
• COB_LGIM.DBO.HydrantInspectionInfo (4) -- Related To: Hydrants Inspected This Calender Year (11)

Layer: Hydrants Not Flushed (0)

Name: Hydrants Not Flushed

Display Field: created_user

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1405815.9298102632
YMin: 281027.91701803356
XMax: 1431101.6840286776
YMax: 303725.86013911664
Spatial Reference: 102697  (102697)



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 )
• DATE ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• 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 )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 400, defaultValue: null, modelName: LOCATION )
• JOBTYPE ( type: esriFieldTypeString, alias: Job Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: JOBTYPE , Coded Values: [Abandoned Motor Vehicle: Abandoned Motor Vehicle] , [Bridge Impassible: Bridge Impassible] , [Damaged Structure: Damaged Structure] , ...44 more... )
• ACTIONTAKEN ( type: esriFieldTypeString, alias: Action Taken, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ACTIONTAKEN , Coded Values: [Disconnect: Disconnect] , [Fabrication: Fabrication] , [Flushing: Flushing] , ...12 more... )
• SERVICETYPE ( type: esriFieldTypeString, alias: Service Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SERVICETYPE , Coded Values: [Domestic: Domestic] , [Commercial: Commercial] , [Industrial: Industrial] , ...11 more... )
• STRUCTUREPSI ( type: esriFieldTypeDouble, alias: Structure PSI, editable: true, nullable: true, defaultValue: null, modelName: STRUCTUREPSI )
• NEARESTHYDPSI ( type: esriFieldTypeDouble, alias: Nearest Hydrant PSI, editable: true, nullable: true, defaultValue: null, modelName: NEARESTHYDPSI )
• NUMFEATGPS ( type: esriFieldTypeSmallInteger, alias: Number of GPS Features, editable: true, nullable: true, defaultValue: null, modelName: NUMFEATGPS )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITYID )
• HYDFLUSHED ( type: esriFieldTypeString, alias: Hydrant Flushed, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYDFLUSHED , Coded Values: [Yes: Yes] , [No: No] )
• AMTFLUSHED ( type: esriFieldTypeDouble, alias: Amount Flushed, editable: true, nullable: true, defaultValue: null, modelName: AMTFLUSHED )
• SUPPLIES ( type: esriFieldTypeString, alias: Supplies, editable: true, nullable: true, length: 400, defaultValue: null, modelName: SUPPLIES )
• COMMENT ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 400, defaultValue: null, modelName: COMMENT )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CATEGORY ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CATEGORY )
Templates:
• Name: Utility Service Stop
  Description:
  Prototype:
  COMMENT: null
  SUPPLIES: null
  NEARESTHYDPSI: null
  AMTFLUSHED: null
  HYDFLUSHED: null
  FACILITYID: null
  NUMFEATGPS: null
  DATE: null
  LOCATION: null
  JOBTYPE: null
  ACTIONTAKEN: null
  SERVICETYPE: null
  STRUCTUREPSI: null
  CATEGORY: null
  
  Drawing Tool: esriFeatureEditToolPoint

Layer: Hydrants That Need Paint (15)

Name: Hydrants That Need Paint

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1402335.1323099285
YMin: 278389.1906681955
XMax: 1433650.7022245936
YMax: 334528.55345486104
Spatial Reference: 102697  (102697)



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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• DATE ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• LEAKING ( type: esriFieldTypeString, alias: Leaking, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEAKING , Coded Values: [Yes: Yes] , [No: No] )
• PSI ( type: esriFieldTypeSmallInteger, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PITOT )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 400, defaultValue: null, modelName: NOTES )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Dresser: Dresser] , ...8 more... )
• LASTSERVICE ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• FLOW ( type: esriFieldTypeDouble, alias: Flow Rate (GPM), editable: true, nullable: true, defaultValue: null, modelName: FLOW )
• ID_FIELD ( type: esriFieldTypeString, alias: Hydrant ID Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ID_FIELD )
• H2OR3WAY ( type: esriFieldTypeString, alias: 2 or 3 Way Hydrant, editable: true, nullable: true, length: 10, defaultValue: null, modelName: H2OR3WAY , Coded Values: [2 Way: 2 Way] , [3 Way: 3 Way] )
• PAINT ( type: esriFieldTypeString, alias: Hydrant Paint, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PAINT )
• WATER_MAIN ( type: esriFieldTypeString, alias: Water Main, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATER_MAIN )
• GRID_ID ( type: esriFieldTypeString, alias: Map Grid ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GRID_ID )
• FLOW_CLASS ( type: esriFieldTypeString, alias: Flow Class, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FLOW_CLASS )
• STATIC ( type: esriFieldTypeInteger, alias: Static, editable: true, nullable: true, defaultValue: null, modelName: STATIC )
• RESIDUAL ( type: esriFieldTypeInteger, alias: Residual, editable: true, nullable: true, defaultValue: null, modelName: RESIDUAL )
• OPENING ( type: esriFieldTypeDouble, alias: Opening, editable: true, nullable: true, defaultValue: null, modelName: OPENING )
• CREW ( type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CREW )
• LAT_DMS ( type: esriFieldTypeString, alias: Latitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAT_DMS )
• LONG_DMS ( type: esriFieldTypeString, alias: Longitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LONG_DMS )
• STREET_NUM ( type: esriFieldTypeSmallInteger, alias: Street Address Number, editable: true, nullable: true, defaultValue: null, modelName: STREET_NUM )
• STREET_DIR ( type: esriFieldTypeString, alias: Street Address Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STREET_DIR )
• STREET_NAME ( type: esriFieldTypeString, alias: Street Address Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_NAME )
• STREET_TYPE ( type: esriFieldTypeString, alias: Street Address Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STREET_TYPE )
• UNIT ( type: esriFieldTypeString, alias: Street Address Unit, editable: true, nullable: true, length: 15, defaultValue: null, modelName: UNIT )
• OKAY ( type: esriFieldTypeString, alias: Data Review Code, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OKAY )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• YR_PAINT ( type: esriFieldTypeString, alias: Year Painted, editable: true, nullable: true, length: 10, defaultValue: null, modelName: YR_PAINT )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• WATER_MAIN_DIA ( type: esriFieldTypeDouble, alias: Water Main Diameter, editable: true, nullable: true, defaultValue: null, modelName: WATER_MAIN_DIA )
• UT_HYD_ID ( type: esriFieldTypeString, alias: Utilities Hydrant ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UT_HYD_ID )
• HYDRANT_YEAR ( type: esriFieldTypeInteger, alias: Year Hydrant Built, editable: true, nullable: true, defaultValue: null, modelName: HYDRANT_YEAR )
• HYD_SIZE ( type: esriFieldTypeString, alias: Hydrant Size, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_SIZE , Coded Values: [5 1/4: 5 1/4] , [4 1/4: 4 1/4] )
• HYD_VLV ( type: esriFieldTypeString, alias: Hydrant Valve Yes/No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_VLV , Coded Values: [Yes: Yes] , [No: No] )
• LATITUDE_DD ( type: esriFieldTypeString, alias: Latitude Decimal Degrees, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LATITUDE_DD )
• LONGITUDE_DD ( type: esriFieldTypeString, alias: Longitude Decimal Degrees, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LONGITUDE_DD )
• LAST_INSPECTION_DATE ( type: esriFieldTypeDate, alias: Date of Last Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_INSPECTION_DATE )
• INSPECTION_STATUS ( type: esriFieldTypeString, alias: Hydrant Inspection Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTION_STATUS , Coded Values: [Inspected within a year: Inspected within a year] , [Inspected more than a year ago: Inspected more than a year ago] , [No Data: No Data] )
• NEEDS_REPAIR ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDS_REPAIR , Coded Values: [Yes: Yes] , [No: No] )
• NEEDS_PAINT ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDS_PAINT , Coded Values: [Yes: Yes] , [No: No] )
Templates:
• Name: Hydrants That Need Paint
  Description:
  Prototype:
  PLANTFLUSH: null
  FLUSHED: null
  Id: null
  HydrantID: null
  Location: null
  GUID: null
  DATE: null
  Critical: null
  MaintPerf: null
  Valve: null
  NeedsPaint: null
  OilGrease: null
  BCoupling: null
  BrokenStem: null
  DefMissCap: null
  OPERABLE: null
  HardToOpen: null
  LEAKING: null
  PSI: null
  SERVICED: null
  NOTES: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• HydrantInspectionsREL (5) -- Related To: HydrantInspections (22)
• COB_LGIM.DBO.HydrantInspectionInfo (4) -- Related To: Hydrants Inspected This Calender Year (11)

Layer: Hydrants Needing Service (14)

Name: Hydrants Needing Service

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1402335.1323099285
YMin: 278389.1906681955
XMax: 1433650.7022245936
YMax: 334528.55345486104
Spatial Reference: 102697  (102697)



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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Dresser: Dresser] , ...8 more... )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• LASTSERVICE ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• FLOW ( type: esriFieldTypeDouble, alias: Flow Rate (GPM), editable: true, nullable: true, defaultValue: null, modelName: FLOW )
• 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 )
• ID_FIELD ( type: esriFieldTypeString, alias: Hydrant ID Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ID_FIELD )
• H2OR3WAY ( type: esriFieldTypeString, alias: 2 or 3 Way Hydrant, editable: true, nullable: true, length: 10, defaultValue: null, modelName: H2OR3WAY , Coded Values: [2 Way: 2 Way] , [3 Way: 3 Way] )
• PAINT ( type: esriFieldTypeString, alias: Hydrant Paint, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PAINT )
• WATER_MAIN ( type: esriFieldTypeString, alias: Water Main, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATER_MAIN )
• GRID_ID ( type: esriFieldTypeString, alias: Map Grid ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GRID_ID )
• FLOW_CLASS ( type: esriFieldTypeString, alias: Flow Class, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FLOW_CLASS )
• STATIC ( type: esriFieldTypeInteger, alias: Static, editable: true, nullable: true, defaultValue: null, modelName: STATIC )
• RESIDUAL ( type: esriFieldTypeInteger, alias: Residual, editable: true, nullable: true, defaultValue: null, modelName: RESIDUAL )
• OPENING ( type: esriFieldTypeDouble, alias: Opening, editable: true, nullable: true, defaultValue: null, modelName: OPENING )
• PSI ( type: esriFieldTypeSmallInteger, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PITOT )
• DATE ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• CREW ( type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CREW )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 400, defaultValue: null, modelName: NOTES )
• LAT_DMS ( type: esriFieldTypeString, alias: Latitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAT_DMS )
• LONG_DMS ( type: esriFieldTypeString, alias: Longitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LONG_DMS )
• STREET_NUM ( type: esriFieldTypeSmallInteger, alias: Street Address Number, editable: true, nullable: true, defaultValue: null, modelName: STREET_NUM )
• STREET_DIR ( type: esriFieldTypeString, alias: Street Address Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STREET_DIR )
• STREET_NAME ( type: esriFieldTypeString, alias: Street Address Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_NAME )
• STREET_TYPE ( type: esriFieldTypeString, alias: Street Address Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STREET_TYPE )
• UNIT ( type: esriFieldTypeString, alias: Street Address Unit, editable: true, nullable: true, length: 15, defaultValue: null, modelName: UNIT )
• OKAY ( type: esriFieldTypeString, alias: Data Review Code, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OKAY )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• YR_PAINT ( type: esriFieldTypeString, alias: Year Painted, editable: true, nullable: true, length: 10, defaultValue: null, modelName: YR_PAINT )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• WATER_MAIN_DIA ( type: esriFieldTypeDouble, alias: Water Main Diameter, editable: true, nullable: true, defaultValue: null, modelName: WATER_MAIN_DIA )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• UT_HYD_ID ( type: esriFieldTypeString, alias: Utilities Hydrant ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UT_HYD_ID )
• HYDRANT_YEAR ( type: esriFieldTypeInteger, alias: Year Hydrant Built, editable: true, nullable: true, defaultValue: null, modelName: HYDRANT_YEAR )
• HYD_SIZE ( type: esriFieldTypeString, alias: Hydrant Size, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_SIZE , Coded Values: [5 1/4: 5 1/4] , [4 1/4: 4 1/4] )
• HYD_VLV ( type: esriFieldTypeString, alias: Hydrant Valve Yes/No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_VLV , Coded Values: [Yes: Yes] , [No: No] )
• LATITUDE_DD ( type: esriFieldTypeString, alias: Latitude Decimal Degrees, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LATITUDE_DD )
• LONGITUDE_DD ( type: esriFieldTypeString, alias: Longitude Decimal Degrees, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LONGITUDE_DD )
• LAST_INSPECTION_DATE ( type: esriFieldTypeDate, alias: Date of Last Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_INSPECTION_DATE )
• INSPECTION_STATUS ( type: esriFieldTypeString, alias: Hydrant Inspection Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTION_STATUS , Coded Values: [Inspected within a year: Inspected within a year] , [Inspected more than a year ago: Inspected more than a year ago] , [No Data: No Data] )
• NEEDS_REPAIR ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDS_REPAIR , Coded Values: [Yes: Yes] , [No: No] )
• NEEDS_PAINT ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDS_PAINT , Coded Values: [Yes: Yes] , [No: No] )
• LEAKING ( type: esriFieldTypeString, alias: Leaking, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEAKING , Coded Values: [Yes: Yes] , [No: No] )
Templates:
• Name: Hydrants Needing Service
  Description:
  Prototype:
  NEEDS_REPAIR: null
  INSPECTION_STATUS: null
  HYD_SIZE: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: 1
  LASTSERVICE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  LAST_INSPECTION_DATE: null
  LONGITUDE_DD: null
  LATITUDE_DD: null
  HYD_VLV: null
  FLOW: null
  ID_FIELD: null
  H2OR3WAY: null
  PAINT: null
  WATER_MAIN: null
  GRID_ID: null
  FLOW_CLASS: null
  STATIC: null
  RESIDUAL: null
  OPENING: null
  PSI: null
  DATE: null
  CREW: null
  NOTES: null
  LAT_DMS: null
  LONG_DMS: null
  STREET_NUM: null
  STREET_DIR: null
  STREET_NAME: null
  STREET_TYPE: null
  UNIT: null
  OKAY: null
  WATERSHED: null
  PRESSUREZN: null
  YR_PAINT: null
  CONDITION: null
  NEEDS_PAINT: null
  WATER_MAIN_DIA: null
  UT_HYD_ID: null
  HYDRANT_YEAR: null
  LEAKING: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• HydrantInspectionsREL (5) -- Related To: HydrantInspections (22)
• COB_LGIM.DBO.HydrantInspectionInfo (4) -- Related To: Hydrants Inspected This Calender Year (11)

Layer: COB_LGIM.DBO.HydrantInspectionInfo (16)

Name: COB_LGIM.DBO.HydrantInspectionInfo

Display Field: HydrantID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1405248.603845179
YMin: 284435.5325781107
XMax: 1431314.90407468
YMax: 311617.4034111127
Spatial Reference: 102697  (102697)



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 )
• Id ( type: esriFieldTypeInteger, alias: Id, editable: true, nullable: true, defaultValue: null, modelName: Id )
• HydrantID ( type: esriFieldTypeString, alias: HydrantID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HydrantID )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Location )
• Date ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date )
• Operable ( type: esriFieldTypeString, alias: Operable, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Operable , Coded Values: [Yes: Yes] , [No: No] )
• Critical ( type: esriFieldTypeString, alias: Critical, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Critical , Coded Values: [Yes: Yes] , [No: No] )
• MaintPerf ( type: esriFieldTypeString, alias: MaintPerf, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintPerf , Coded Values: [Yes: Yes] , [No: No] )
• Valve ( type: esriFieldTypeString, alias: Valve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Valve , Coded Values: [Yes: Yes] , [No: No] )
• NeedsPaint ( type: esriFieldTypeString, alias: NeedsPaint, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NeedsPaint , Coded Values: [Yes: Yes] , [No: No] )
• OilGrease ( type: esriFieldTypeString, alias: OilGrease, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OilGrease , Coded Values: [Yes: Yes] , [No: No] )
• BCoupling ( type: esriFieldTypeString, alias: BCoupling, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BCoupling , Coded Values: [Yes: Yes] , [No: No] )
• BrokenStem ( type: esriFieldTypeString, alias: BrokenStem, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BrokenStem , Coded Values: [Yes: Yes] , [No: No] )
• DefMissCap ( type: esriFieldTypeString, alias: DefMissCap, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DefMissCap , Coded Values: [Yes: Yes] , [No: No] )
• Leaking ( type: esriFieldTypeString, alias: Leaking, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Leaking , Coded Values: [Yes: Yes] , [No: No] )
• HardToOpen ( type: esriFieldTypeString, alias: HardToOpen, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HardToOpen , Coded Values: [Yes: Yes] , [No: No] )
• PSI ( type: esriFieldTypeDouble, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PSI )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Notes )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• FLUSHED ( type: esriFieldTypeDouble, alias: Amount Flushed, editable: true, nullable: true, defaultValue: null, modelName: FLUSHED )
• PLANTFLUSH ( type: esriFieldTypeDouble, alias: Water Plant Amount Flushed, editable: true, nullable: true, defaultValue: null, modelName: PLANTFLUSH )
• SERVICED ( type: esriFieldTypeString, alias: Serviced, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SERVICED , Coded Values: [Yes: Yes] , [No: No] )
Templates:
• Name: COB_LGIM.DBO.HydrantInspectionInfo
  Description:
  Prototype:
  FLUSHED: null
  GUID: null
  Notes: null
  Id: null
  HydrantID: null
  Location: null
  Date: null
  Operable: null
  Critical: null
  MaintPerf: null
  Valve: null
  NeedsPaint: null
  OilGrease: null
  BCoupling: null
  BrokenStem: null
  DefMissCap: null
  Leaking: null
  HardToOpen: null
  PSI: null
  PLANTFLUSH: null
  SERVICED: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.wHydrant (4) -- Related To: Water Hydrants Not Owned By Branson (9)

Layer: Water Valve Exercise Info (17)

Name: Water Valve Exercise Info

Display Field: EMPLOYEE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: 1405246.9421030954
YMin: 284653.6472993642
XMax: 1431228.540074177
YMax: 311631.4975430295
Spatial Reference: 102697  (102697)



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 )
• EMPLOYEE ( type: esriFieldTypeString, alias: Employee, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EMPLOYEE )
• DATE ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• VALVESIZE ( type: esriFieldTypeDouble, alias: VALVESIZE, editable: true, nullable: true, defaultValue: null, modelName: VALVESIZE , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVETYPE , Coded Values: [Plug: Plug] , [Other: Other] , [Unknown: Unknown] , ...10 more... )
• VALVECONDITION ( type: esriFieldTypeString, alias: Valve Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVECONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• EXERCISED ( type: esriFieldTypeString, alias: Exercised, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXERCISED , Coded Values: [Yes: Yes] , [No: No] )
• EXERCISENEEDED ( type: esriFieldTypeString, alias: Exercise Needed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXERCISENEEDED , Coded Values: [Yes: Yes] , [No: No] )
• BOXNEEDCLEAN ( type: esriFieldTypeString, alias: Box Need Clean, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXNEEDCLEAN , Coded Values: [Yes: Yes] , [No: No] )
• BOXCONDITION ( type: esriFieldTypeString, alias: Box Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOXCONDITION , Coded Values: [Broken: Broken] , [Clean: Clean] , [Completed: Completed] , ...5 more... )
• HASLID ( type: esriFieldTypeString, alias: Has Lid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HASLID , Coded Values: [Yes: Yes] , [No: No] )
• GOODPACKING ( type: esriFieldTypeString, alias: Good Packing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GOODPACKING , Coded Values: [Yes: Yes] , [No: No] )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• EMPLOYEE2 ( type: esriFieldTypeString, alias: Employee 2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EMPLOYEE2 )
• NEEDSMAINT ( type: esriFieldTypeString, alias: Needs Maintenance, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDSMAINT , Coded Values: [Yes: Yes] , [No: No] )
• VALVEDEPTH ( type: esriFieldTypeDouble, alias: Valve Depth, editable: true, nullable: true, defaultValue: null, modelName: VALVEDEPTH )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 400, defaultValue: null, modelName: COMMENT )
• 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: Water Valve Exercise Info
  Description:
  Prototype:
  VALVEDEPTH: null
  NEEDSMAINT: null
  EMPLOYEE2: null
  EMPLOYEE: null
  DATE: null
  VALVESIZE: null
  VALVETYPE: null
  VALVECONDITION: null
  EXERCISED: null
  EXERCISENEEDED: null
  BOXNEEDCLEAN: null
  BOXCONDITION: null
  HASLID: null
  GOODPACKING: null
  GUID: null
  COMMENT: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.wSystemValve (2) -- Related To: Valves Excercised This Calender Year (4)

Tables:

Table: wHydrantInspection__ATTACH (21)

Name: wHydrantInspection__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• REL_OBJECTID ( type: esriFieldTypeInteger, alias: REL_OBJECTID, editable: true, nullable: false, defaultValue: null, modelName: REL_OBJECTID )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, editable: true, nullable: false, length: 150, defaultValue: null, modelName: CONTENT_TYPE )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, editable: true, nullable: false, length: 250, defaultValue: null, modelName: ATT_NAME )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE, editable: true, nullable: false, defaultValue: null, modelName: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA, editable: true, nullable: true, defaultValue: null, modelName: DATA )
Templates:
• Name: wHydrantInspection__ATTACH
  Description:
  Prototype:
  DATA_SIZE: 0
  DATA: null
  REL_OBJECTID: 0
  CONTENT_TYPE:
  ATT_NAME:
  
  Drawing Tool: esriFeatureEditToolNone

Table: HydrantInspections (22)

Name: HydrantInspections

Display Field: HydrantID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• HydrantID ( type: esriFieldTypeString, alias: Hydrant ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HydrantID )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• Operable ( type: esriFieldTypeString, alias: Operable, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Operable , Coded Values: [Yes: Yes] , [No: No] )
• NearCriticalFac ( type: esriFieldTypeString, alias: Near Critical Facility, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NearCriticalFac , Coded Values: [Yes: Yes] , [No: No] )
• MaintPerf ( type: esriFieldTypeString, alias: Maintenance Performed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintPerf , Coded Values: [Yes: Yes] , [No: No] )
• HydrantValve ( type: esriFieldTypeString, alias: Hydrant Valve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HydrantValve , Coded Values: [Yes: Yes] , [No: No] )
• NeedsPaint ( type: esriFieldTypeString, alias: Needs Paint, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NeedsPaint , Coded Values: [Yes: Yes] , [No: No] )
• NeedsOilGrease ( type: esriFieldTypeString, alias: Needs Oil/Greased, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NeedsOilGrease , Coded Values: [Yes: Yes] , [No: No] )
• BrokenCoupling ( type: esriFieldTypeString, alias: Broken Coupling, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BrokenCoupling , Coded Values: [Yes: Yes] , [No: No] )
• BrokenStem ( type: esriFieldTypeString, alias: Broken Stem, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BrokenStem , Coded Values: [Yes: Yes] , [No: No] )
• DefectMissCap ( type: esriFieldTypeString, alias: Defective/Missing Caps, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DefectMissCap , Coded Values: [Yes: Yes] , [No: No] )
• DefectThreadNut ( type: esriFieldTypeString, alias: Defective Threads/Nuts, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DefectThreadNut , Coded Values: [Yes: Yes] , [No: No] )
• Leaking ( type: esriFieldTypeString, alias: Leaking, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Leaking , Coded Values: [Yes: Yes] , [No: No] )
• HardToOpen ( type: esriFieldTypeString, alias: Hard to Open/Close, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HardToOpen , Coded Values: [Yes: Yes] , [No: No] )
• PSI ( type: esriFieldTypeDouble, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PSI )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 400, defaultValue: null, modelName: Notes )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: HydrantInspections
  Description:
  Prototype:
  GUID: null
  Notes: null
  HydrantID: null
  Location: null
  InspectionDate: null
  Operable: null
  NearCriticalFac: null
  MaintPerf: null
  HydrantValve: null
  NeedsPaint: null
  NeedsOilGrease: null
  BrokenCoupling: null
  BrokenStem: null
  DefectMissCap: null
  DefectThreadNut: null
  Leaking: null
  HardToOpen: null
  PSI: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• wHydrant (5) -- Related To: Water Hydrants Not Owned By Branson (9)