View In:   ArcGIS Online Map Viewer

Name: Water System Valves

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This layer is a collection of all of the line valves maintained by the Medina County Sanitary Engineering Department in the County of Medina.

Service Item Id: f061be1f06b648a385f361c025635fc0

Copyright Text: MCSE, MCE, MEDINA COUNTY AUDITOR

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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

Supports Datum Transformation: true

Extent:

XMin: 2085207.4190175235
YMin: 489827.6863991916
XMax: 2192407.37325336
YMax: 587516.6009290963
Spatial Reference: 3753  (3753)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: STATUS
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Canopy Block
  Label: Canopy too heavy; Unable to Locate
  Description:
  Symbol:
  
• Value: Unable to Locate
  Label: Canopy too heavy; Unable to Locate
  Description:
  Symbol:
  
• Value: GPS Incomplete
  Label: GPS Incomplete; GPS Unacceptable
  Description:
  Symbol:
  
• Value: GPS Unacceptable
  Label: GPS Incomplete; GPS Unacceptable
  Description:
  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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: STATUS

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• 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"] , ...19 more... )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 30, defaultValue: Gate, modelName: VALVETYPE , Coded Values: [Ball: Ball] , [Butterfly: Butterfly] , [Cone: Cone] , ...2 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: 1, 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: Our Utility] , [-1: Private] , [-2: Other] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Our Utility] , [-1: Private] , [-2: Other] )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• NORTHING ( type: esriFieldTypeString, alias: NORTHING, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NORTHING )
• EASTING ( type: esriFieldTypeString, alias: EASTING, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EASTING )
• ELEVATION ( type: esriFieldTypeString, alias: ELEVATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ELEVATION )
• NAME ( type: esriFieldTypeString, alias: NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NAME )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONDITION , Coded Values: [OK: OK] , [Leaning: Leaning] , [Broken: Broken] , ...2 more... )
• GRADE ( type: esriFieldTypeString, alias: GRADE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GRADE , Coded Values: [Below: Below Grade] , [At: At Grade] , [Above: Above Grade] , ...1 more... )
• PROJECT ( type: esriFieldTypeString, alias: PROJECT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT )
• DEPTHTOKEY ( type: esriFieldTypeString, alias: DEPTHTOKEY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEPTHTOKEY )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 50, defaultValue: GPS Incomplete, modelName: STATUS , Coded Values: [GPS Incomplete: GPS Incomplete] , [GPS Complete: GPS Complete] , [Unable to Locate: Unable to Locate] , ...2 more... )
• DATEENTERED ( type: esriFieldTypeDate, alias: DATEENTERED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEENTERED )
• SYSTEM ( type: esriFieldTypeString, alias: SYSTEM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SYSTEM , Coded Values: [Northwest Water: Northwest Water] , [Sharon Springs: Sharon Springs] , [Westfield Water: Westfield Water] , ...4 more... )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION , Coded Values: [Lawn: Lawn] , [Street: Street] , [Drive: Driveway] , ...4 more... )
• VALVE_CASING ( type: esriFieldTypeString, alias: VALVE_CASING, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVE_CASING , Coded Values: [clean: Clean Casing] , [water: Water sitting in casing] , [muck: Water and mud in casing] , ...3 more... )
• VALVE_EXERCISE ( type: esriFieldTypeString, alias: VALVE_EXERCISE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVE_EXERCISE , Coded Values: [YES: YES] , [NO: NO] , [PROBLEMS: PROBLEMS] )
• ESTIMATED_ACCURACY ( type: esriFieldTypeDouble, alias: ESTIMATED_ACCURACY, editable: true, nullable: true, defaultValue: null, modelName: ESTIMATED_ACCURACY )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DISTRICT , Coded Values: [Gayer: Gayer] , [Substation: Substation] , [Weymouth: Weymouth] , ...10 more... )
• YEARBUILT ( type: esriFieldTypeSmallInteger, alias: YEARBUILT, editable: true, nullable: true, defaultValue: null, modelName: YEARBUILT )
• PLANLINK ( type: esriFieldTypeString, alias: PLANLINK, editable: true, nullable: true, length: 150, defaultValue: null, modelName: PLANLINK )
• INSPECTION ( type: esriFieldTypeString, alias: INSPECTION, editable: true, nullable: true, length: 150, defaultValue: null, modelName: INSPECTION )
• TILE ( type: esriFieldTypeString, alias: TILE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TILE )
• HT_ABOVE_ELLIP ( type: esriFieldTypeDouble, alias: HT_ABOVE_ELLIP, editable: true, nullable: true, defaultValue: null, modelName: HT_ABOVE_ELLIP )
• LOC_TIME ( type: esriFieldTypeString, alias: LOC_TIME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOC_TIME )
• LOC_DATE ( type: esriFieldTypeString, alias: LOC_DATE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOC_DATE )
• Z ( type: esriFieldTypeString, alias: Z, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Z )
• X ( type: esriFieldTypeString, alias: X, editable: true, nullable: true, length: 50, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeString, alias: Y, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Y )
• PDOP ( type: esriFieldTypeDouble, alias: PDOP, editable: true, nullable: true, defaultValue: null, modelName: PDOP )
• EPE ( type: esriFieldTypeDouble, alias: EPE, editable: true, nullable: true, defaultValue: null, modelName: EPE )

Types:

ID: Canopy Block
Name: Canopy Block
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
• CONDITION:
  Inherited
• GRADE:
  Inherited
• STATUS:
  Inherited
• SYSTEM:
  Inherited
• LOCATION:
  Inherited
• VALVE_CASING:
  Inherited
• VALVE_EXERCISE:
  Inherited
• DISTRICT:
  Inherited
Templates:
• Name: Canopy Block
  Description:
  Prototype:
  PDOP: null
  EPE: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  VALVETYPE: Gate
  BYPASSVALVE: 0
  CLOCKTOCLOSE: 1
  NORMALLYOPEN: 1
  TURNSTOCLOSE: 1
  OPERABLE: 1
  HYDRFLAG: 0
  CURROPEN: 1
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  LASTEDITOR: null
  NORTHING: null
  EASTING: null
  ELEVATION: null
  NAME: null
  CONDITION: null
  GRADE: null
  PROJECT: null
  DEPTHTOKEY: null
  STATUS: Canopy Block
  DATEENTERED: null
  SYSTEM: null
  LOCATION: null
  VALVE_CASING: null
  VALVE_EXERCISE: null
  ESTIMATED_ACCURACY: null
  DISTRICT: null
  YEARBUILT: null
  PLANLINK: null
  INSPECTION: null
  TILE: null
  HT_ABOVE_ELLIP: null
  LOC_TIME: null
  LOC_DATE: null
  Z: null
  X: null
  Y: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Unable to Locate
Name: Unable to Locate
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
• CONDITION:
  Inherited
• GRADE:
  Inherited
• STATUS:
  Inherited
• SYSTEM:
  Inherited
• LOCATION:
  Inherited
• VALVE_CASING:
  Inherited
• VALVE_EXERCISE:
  Inherited
• DISTRICT:
  Inherited
Templates:
• Name: Unable to Locate
  Description:
  Prototype:
  PDOP: null
  EPE: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  VALVETYPE: Gate
  BYPASSVALVE: 0
  CLOCKTOCLOSE: 1
  NORMALLYOPEN: 1
  TURNSTOCLOSE: 1
  OPERABLE: 1
  HYDRFLAG: 0
  CURROPEN: 1
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  LASTEDITOR: null
  NORTHING: null
  EASTING: null
  ELEVATION: null
  NAME: null
  CONDITION: null
  GRADE: null
  PROJECT: null
  DEPTHTOKEY: null
  STATUS: Unable to Locate
  DATEENTERED: null
  SYSTEM: null
  LOCATION: null
  VALVE_CASING: null
  VALVE_EXERCISE: null
  ESTIMATED_ACCURACY: null
  DISTRICT: null
  YEARBUILT: null
  PLANLINK: null
  INSPECTION: null
  TILE: null
  HT_ABOVE_ELLIP: null
  LOC_TIME: null
  LOC_DATE: null
  Z: null
  X: null
  Y: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: GPS Incomplete
Name: GPS Incomplete
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
• CONDITION:
  Inherited
• GRADE:
  Inherited
• STATUS:
  Inherited
• SYSTEM:
  Inherited
• LOCATION:
  Inherited
• VALVE_CASING:
  Inherited
• VALVE_EXERCISE:
  Inherited
• DISTRICT:
  Inherited
Templates:
• Name: GPS Incomplete
  Description:
  Prototype:
  PDOP: null
  EPE: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  VALVETYPE: Gate
  BYPASSVALVE: 0
  CLOCKTOCLOSE: 1
  NORMALLYOPEN: 1
  TURNSTOCLOSE: 1
  OPERABLE: 1
  HYDRFLAG: 0
  CURROPEN: 1
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  LASTEDITOR: null
  NORTHING: null
  EASTING: null
  ELEVATION: null
  NAME: null
  CONDITION: null
  GRADE: null
  PROJECT: null
  DEPTHTOKEY: null
  STATUS: GPS Incomplete
  DATEENTERED: null
  SYSTEM: null
  LOCATION: null
  VALVE_CASING: null
  VALVE_EXERCISE: null
  ESTIMATED_ACCURACY: null
  DISTRICT: null
  YEARBUILT: null
  PLANLINK: null
  INSPECTION: null
  TILE: null
  HT_ABOVE_ELLIP: null
  LOC_TIME: null
  LOC_DATE: null
  Z: null
  X: null
  Y: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: GPS Unacceptable
Name: GPS Unacceptable
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
• CONDITION:
  Inherited
• GRADE:
  Inherited
• STATUS:
  Inherited
• SYSTEM:
  Inherited
• LOCATION:
  Inherited
• VALVE_CASING:
  Inherited
• VALVE_EXERCISE:
  Inherited
• DISTRICT:
  Inherited
Templates:
• Name: GPS Unacceptable
  Description:
  Prototype:
  PDOP: null
  EPE: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  VALVETYPE: Gate
  BYPASSVALVE: 0
  CLOCKTOCLOSE: 1
  NORMALLYOPEN: 1
  TURNSTOCLOSE: 1
  OPERABLE: 1
  HYDRFLAG: 0
  CURROPEN: 1
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  LASTEDITOR: null
  NORTHING: null
  EASTING: null
  ELEVATION: null
  NAME: null
  CONDITION: null
  GRADE: null
  PROJECT: null
  DEPTHTOKEY: null
  STATUS: GPS Unacceptable
  DATEENTERED: null
  SYSTEM: null
  LOCATION: null
  VALVE_CASING: null
  VALVE_EXERCISE: null
  ESTIMATED_ACCURACY: null
  DISTRICT: null
  YEARBUILT: null
  PLANLINK: null
  INSPECTION: null
  TILE: null
  HT_ABOVE_ELLIP: null
  LOC_TIME: null
  LOC_DATE: null
  Z: null
  X: null
  Y: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata