View In:   ArcGIS Online Map Viewer

Name: System Valves

Display Field: USE_

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 68a47d4195a54fde81ac7ffd5c72478b

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1493460.524968475
YMin: 2028769.5757928938
XMax: 1653030.1133089662
YMax: 2182178.454013899
Spatial Reference: 102680  (2247)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: USE_
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 7
  Label: Fire Service
  Description: N/A
  Symbol:
  
• Value: 8
  Label: Hydrant
  Description: N/A
  Symbol:
  
• Value: 9
  Label: Line
  Description: N/A
  Symbol:
  
• Value: 15
  Label: Tap
  Description: N/A
  Symbol:
  
• Value: 17
  Label: Zone
  Description: N/A
  Symbol:
  
• Value: 0
  Label: Other
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: USE_

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PWSID ( type: esriFieldTypeString, alias: Public Water System ID, editable: true, nullable: false, length: 3, defaultValue: 1, modelName: PWSID , Coded Values: [1: 0470175] , [-1: N/A] , [0: Other] )
• OWNER ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: false, length: 3, defaultValue: 1, modelName: OWNER , Coded Values: [1: Hardin County Water District No. 2] , [0: Other] , [-1: Private Owner] )
• Type_Copy ( type: esriFieldTypeSmallInteger, alias: Valve Type, editable: true, nullable: true, defaultValue: null, modelName: Type_Copy , Coded Values: [1: Ball] , [2: Butterfly] , [3: Cone] , ...8 more... )
• USE_ ( type: esriFieldTypeString, alias: Valve Use, editable: true, nullable: false, length: 3, defaultValue: , modelName: USE_ , Coded Values: [0: Other] , [15: Tap] , [17: Zone] , ...3 more... )
• SIZE ( type: esriFieldTypeString, alias: Valve Size, editable: true, nullable: false, length: 3, defaultValue: , modelName: SIZE , Coded Values: [0.7: .75] , [01: 1"] , [02: 2"] , ...13 more... )
• INSTALLED ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLED )
• VLV_MANUF ( type: esriFieldTypeString, alias: Valve Manufacturer, editable: true, nullable: true, length: 20, defaultValue: , modelName: VLV_MANUF )
• MODEL ( type: esriFieldTypeString, alias: Valve Model, editable: true, nullable: true, length: 20, defaultValue: , modelName: MODEL )
• YEAR ( type: esriFieldTypeString, alias: Year Manufactured, editable: true, nullable: true, length: 4, defaultValue: , modelName: YEAR )
• OPEN_DIR ( type: esriFieldTypeString, alias: Open Direction, editable: true, nullable: false, length: 3, defaultValue: , modelName: OPEN_DIR , Coded Values: [-1: N/A] , [1: Left (Counter Clockwise)] , [2: Right (Clockwise)] )
• TURNS_OPEN ( type: esriFieldTypeString, alias: Turns to Open, editable: true, nullable: false, length: 3, defaultValue: , modelName: TURNS_OPEN , Coded Values: [13: 13 ½] , [14: 14] , [16: 16 ½] , ...14 more... )
• NORM_OPEN ( type: esriFieldTypeString, alias: Normally Open, editable: true, nullable: false, length: 3, defaultValue: , modelName: NORM_OPEN , Coded Values: [-1: N/A] , [1: Yes] , [2: No] )
• FUNCTIONAL ( type: esriFieldTypeString, alias: Functional, editable: true, nullable: false, length: 3, defaultValue: , modelName: FUNCTIONAL , Coded Values: [-1: N/A] , [1: Yes] , [2: No] )
• MANHOLE_ID ( type: esriFieldTypeString, alias: Manhole ID, editable: true, nullable: true, length: 20, defaultValue: , modelName: MANHOLE_ID )
• BOX ( type: esriFieldTypeString, alias: Valve Box, editable: true, nullable: false, length: 3, defaultValue: , modelName: BOX , Coded Values: [-1: N/A] , [1: Yes] , [2: No] )
• BOX_TYPE ( type: esriFieldTypeString, alias: Valve Box Type, editable: true, nullable: false, length: 3, defaultValue: , modelName: BOX_TYPE , Coded Values: [-1: N/A] , [1: Cast Iron] , [2: Plastic] , ...1 more... )
• BOX_COLLAR ( type: esriFieldTypeString, alias: Valve Box Collared, editable: true, nullable: false, length: 3, defaultValue: , modelName: BOX_COLLAR , Coded Values: [-1: N/A] , [1: Yes] , [2: No] )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: , modelName: LOCATION )
• STREET ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 100, defaultValue: , modelName: STREET )
• CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: false, length: 3, defaultValue: , modelName: CITY , Coded Values: [1: Big Clifty] , [14: Bonnieville] , [2: Cecilia] , ...12 more... )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: false, length: 3, defaultValue: , modelName: COUNTY , Coded Values: [085: Grayson] , [093: Hardin] , [099: Hart] , ...1 more... )
• ZONE ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: false, length: 3, defaultValue: , modelName: ZONE , Coded Values: [01: Blue 1] , [02: Blue 2] , [03: Blue 3] , ...9 more... )
• PLAT_REF ( type: esriFieldTypeString, alias: Plat Reference, editable: true, nullable: true, length: 100, defaultValue: , modelName: PLAT_REF )
• COMMENTS ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 255, defaultValue: , modelName: COMMENTS )
• GNSS_HEIGH ( type: esriFieldTypeDouble, alias: Height, editable: true, nullable: false, defaultValue: 0, modelName: GNSS_HEIGH )
• MUID_G ( type: esriFieldTypeString, alias: MUID_G, editable: true, nullable: true, length: 50, defaultValue: , modelName: MUID_G )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• UID ( type: esriFieldTypeString, alias: UID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UID )
• 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 )
• CurrentlyOpen ( type: esriFieldTypeSmallInteger, alias: Currently Open, editable: true, nullable: true, defaultValue: null, modelName: CurrentlyOpen , Coded Values: [0: False] , [1: True] )
• LastExercisedDate ( type: esriFieldTypeDate, alias: Last Exercised Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastExercisedDate )
• HydrantFlag ( type: esriFieldTypeSmallInteger, alias: Hydrant Valve, editable: true, nullable: true, defaultValue: null, modelName: HydrantFlag , Coded Values: [0: False] , [1: True] )
• Rotation ( type: esriFieldTypeInteger, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: Rotation )

Types:

ID: 7
Name: Fire Service
Domains:
• PWSID:
  Inherited
• OWNER:
  Inherited
• Type_Copy:
  Inherited
• USE_:
  Inherited
• SIZE:
  Inherited
• OPEN_DIR:
  Inherited
• TURNS_OPEN:
  Inherited
• NORM_OPEN:
  Inherited
• FUNCTIONAL:
  Inherited
• BOX:
  Inherited
• BOX_TYPE:
  Inherited
• BOX_COLLAR:
  Inherited
• CITY:
  Inherited
• COUNTY:
  Inherited
• ZONE:
  Inherited
• CurrentlyOpen:
  Inherited
• HydrantFlag:
  Inherited
• TYPE:
  Inherited
Templates:
• Name: Fire Service
  Description:
  Prototype:
  INSTALLED: null
  YEAR:
  ZONE:
  USE_: 7
  HydrantFlag: null
  LOCATION:
  OPEN_DIR:
  FUNCTIONAL:
  VLV_MANUF:
  BOX_TYPE:
  MANHOLE_ID:
  Type_Copy: null
  TURNS_OPEN:
  LastExercisedDate: null
  BOX_COLLAR:
  CITY:
  STREET:
  CurrentlyOpen: null
  PLAT_REF:
  GNSS_HEIGH: 0
  MODEL:
  COUNTY:
  NORM_OPEN:
  PWSID: 1
  BOX:
  COMMENTS:
  OWNER: 1
  SIZE:
  MUID_G:
  Rotation: null
  UID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 8
Name: Hydrant
Domains:
• PWSID:
  Inherited
• OWNER:
  Inherited
• Type_Copy:
  Inherited
• USE_:
  Inherited
• SIZE:
  Inherited
• OPEN_DIR:
  Inherited
• TURNS_OPEN:
  Inherited
• NORM_OPEN:
  Inherited
• FUNCTIONAL:
  Inherited
• BOX:
  Inherited
• BOX_TYPE:
  Inherited
• BOX_COLLAR:
  Inherited
• CITY:
  Inherited
• COUNTY:
  Inherited
• ZONE:
  Inherited
• CurrentlyOpen:
  Inherited
• HydrantFlag:
  Inherited
• TYPE:
  Inherited
Templates:
• Name: Hydrant
  Description:
  Prototype:
  INSTALLED: null
  YEAR:
  ZONE:
  USE_: 8
  HydrantFlag: null
  LOCATION:
  OPEN_DIR:
  FUNCTIONAL:
  VLV_MANUF:
  BOX_TYPE:
  MANHOLE_ID:
  Type_Copy: null
  TURNS_OPEN:
  LastExercisedDate: null
  BOX_COLLAR:
  CITY:
  STREET:
  CurrentlyOpen: null
  PLAT_REF:
  GNSS_HEIGH: 0
  MODEL:
  COUNTY:
  NORM_OPEN:
  PWSID: 1
  BOX:
  COMMENTS:
  OWNER: 1
  SIZE:
  MUID_G:
  Rotation: null
  UID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 9
Name: Line
Domains:
• PWSID:
  Inherited
• OWNER:
  Inherited
• Type_Copy:
  Inherited
• USE_:
  Inherited
• SIZE:
  Inherited
• OPEN_DIR:
  Inherited
• TURNS_OPEN:
  Inherited
• NORM_OPEN:
  Inherited
• FUNCTIONAL:
  Inherited
• BOX:
  Inherited
• BOX_TYPE:
  Inherited
• BOX_COLLAR:
  Inherited
• CITY:
  Inherited
• COUNTY:
  Inherited
• ZONE:
  Inherited
• CurrentlyOpen:
  Inherited
• HydrantFlag:
  Inherited
• TYPE:
  Inherited
Templates:
• Name: Line
  Description:
  Prototype:
  INSTALLED: null
  YEAR:
  ZONE:
  USE_: 9
  HydrantFlag: null
  LOCATION:
  OPEN_DIR:
  FUNCTIONAL:
  VLV_MANUF:
  BOX_TYPE:
  MANHOLE_ID:
  Type_Copy: null
  TURNS_OPEN:
  LastExercisedDate: null
  BOX_COLLAR:
  CITY:
  STREET:
  CurrentlyOpen: null
  PLAT_REF:
  GNSS_HEIGH: 0
  MODEL:
  COUNTY:
  NORM_OPEN:
  PWSID: 1
  BOX:
  COMMENTS:
  OWNER: 1
  SIZE:
  MUID_G:
  Rotation: null
  UID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 15
Name: Tap
Domains:
• PWSID:
  Inherited
• OWNER:
  Inherited
• Type_Copy:
  Inherited
• USE_:
  Inherited
• SIZE:
  Inherited
• OPEN_DIR:
  Inherited
• TURNS_OPEN:
  Inherited
• NORM_OPEN:
  Inherited
• FUNCTIONAL:
  Inherited
• BOX:
  Inherited
• BOX_TYPE:
  Inherited
• BOX_COLLAR:
  Inherited
• CITY:
  Inherited
• COUNTY:
  Inherited
• ZONE:
  Inherited
• CurrentlyOpen:
  Inherited
• HydrantFlag:
  Inherited
• TYPE:
  Inherited
Templates:
• Name: Tap
  Description:
  Prototype:
  INSTALLED: null
  YEAR:
  ZONE:
  USE_: 15
  HydrantFlag: null
  LOCATION:
  OPEN_DIR:
  FUNCTIONAL:
  VLV_MANUF:
  BOX_TYPE:
  MANHOLE_ID:
  Type_Copy: null
  TURNS_OPEN:
  LastExercisedDate: null
  BOX_COLLAR:
  CITY:
  STREET:
  CurrentlyOpen: null
  PLAT_REF:
  GNSS_HEIGH: 0
  MODEL:
  COUNTY:
  NORM_OPEN:
  PWSID: 1
  BOX:
  COMMENTS:
  OWNER: 1
  SIZE:
  MUID_G:
  Rotation: null
  UID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 17
Name: Zone
Domains:
• PWSID:
  Inherited
• OWNER:
  Inherited
• Type_Copy:
  Inherited
• USE_:
  Inherited
• SIZE:
  Inherited
• OPEN_DIR:
  Inherited
• TURNS_OPEN:
  Inherited
• NORM_OPEN:
  Inherited
• FUNCTIONAL:
  Inherited
• BOX:
  Inherited
• BOX_TYPE:
  Inherited
• BOX_COLLAR:
  Inherited
• CITY:
  Inherited
• COUNTY:
  Inherited
• ZONE:
  Inherited
• CurrentlyOpen:
  Inherited
• HydrantFlag:
  Inherited
• TYPE:
  Inherited
Templates:
• Name: Zone
  Description:
  Prototype:
  INSTALLED: null
  YEAR:
  ZONE:
  USE_: 17
  HydrantFlag: null
  LOCATION:
  OPEN_DIR:
  FUNCTIONAL:
  VLV_MANUF:
  BOX_TYPE:
  MANHOLE_ID:
  Type_Copy: null
  TURNS_OPEN:
  LastExercisedDate: null
  BOX_COLLAR:
  CITY:
  STREET:
  CurrentlyOpen: null
  PLAT_REF:
  GNSS_HEIGH: 0
  MODEL:
  COUNTY:
  NORM_OPEN:
  PWSID: 1
  BOX:
  COMMENTS:
  OWNER: 1
  SIZE:
  MUID_G:
  Rotation: null
  UID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 0
Name: Other
Domains:
• PWSID:
  Inherited
• OWNER:
  Inherited
• Type_Copy:
  Inherited
• USE_:
  Inherited
• SIZE:
  Inherited
• OPEN_DIR:
  Inherited
• TURNS_OPEN:
  Inherited
• NORM_OPEN:
  Inherited
• FUNCTIONAL:
  Inherited
• BOX:
  Inherited
• BOX_TYPE:
  Inherited
• BOX_COLLAR:
  Inherited
• CITY:
  Inherited
• COUNTY:
  Inherited
• ZONE:
  Inherited
• CurrentlyOpen:
  Inherited
• HydrantFlag:
  Inherited
• TYPE:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  INSTALLED: null
  YEAR:
  ZONE:
  USE_: 0
  HydrantFlag: null
  LOCATION:
  OPEN_DIR:
  FUNCTIONAL:
  VLV_MANUF:
  BOX_TYPE:
  MANHOLE_ID:
  Type_Copy: null
  TURNS_OPEN:
  LastExercisedDate: null
  BOX_COLLAR:
  CITY:
  STREET:
  CurrentlyOpen: null
  PLAT_REF:
  GNSS_HEIGH: 0
  MODEL:
  COUNTY:
  NORM_OPEN:
  PWSID: 1
  BOX:
  COMMENTS:
  OWNER: 1
  SIZE:
  MUID_G:
  Rotation: null
  UID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• Valve Inspections (3) -- Related To: Valve Inspections (13)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata