View In:   ArcGIS Online Map Viewer

Name: ssValves

Display Field: facilityid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: da171f5bef9e4c83a788519e82bf1d55

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 952008.7007334381
YMin: 566618.9634114355
XMax: 997569.8389416933
YMax: 602846.5451555997
Spatial Reference: 102719  (2264)  VCSWkid(115702)  LatestVCSWkid(115702)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: servicetype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Main Valve
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Private Valve
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Service Valve
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Unknown
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: servicetype

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• servicetype ( modelName: ServiceType, nullable: true, editable: true, defaultValue: 1, alias: ServiceType, type: esriFieldTypeSmallInteger )
• valvetype ( modelName: valvetype, nullable: true, editable: true, defaultValue: null, length: 20, alias: ValveType, type: esriFieldTypeString )
• hasbvp ( modelName: hasbvp, nullable: true, editable: true, defaultValue: null, length: 10, alias: HasBVP, type: esriFieldTypeString )
• currentstat ( modelName: currentstat, nullable: true, editable: true, defaultValue: null, length: 10, alias: CurrentStat, type: esriFieldTypeString )
• normalstat ( modelName: normalstat, nullable: true, editable: true, defaultValue: null, length: 10, alias: NormalStat, type: esriFieldTypeString )
• opendir ( modelName: opendir, nullable: true, editable: true, defaultValue: null, length: 10, alias: OpenDir, type: esriFieldTypeString )
• datasource ( modelName: datasource, nullable: true, editable: true, defaultValue: null, length: 100, alias: DataSource, type: esriFieldTypeString )
• datastatus ( modelName: datastatus, nullable: true, editable: true, defaultValue: null, length: 10, alias: DataStatus, type: esriFieldTypeString )
• notes ( modelName: notes, nullable: true, editable: true, defaultValue: null, length: 50, alias: Notes, type: esriFieldTypeString )
• fieldverified ( modelName: fieldverified, nullable: true, editable: true, defaultValue: null, length: 10, alias: FieldVerified, type: esriFieldTypeString )
• dataverified ( modelName: dataverified, nullable: true, editable: true, defaultValue: null, length: 50, alias: DataVerified, type: esriFieldTypeString )
• whoverified ( modelName: whoverified, nullable: true, editable: true, defaultValue: null, length: 50, alias: WhoVerified, type: esriFieldTypeString )
• lastupdated ( modelName: lastupdated, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: LastUpdated, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: true, defaultValue: null, length: 10, alias: Editor, type: esriFieldTypeString )
• facilityid ( modelName: facilityid, nullable: true, editable: true, defaultValue: null, length: 30, alias: FacilityID, type: esriFieldTypeString )
• legacyid ( modelName: legacyid, nullable: true, editable: true, defaultValue: null, length: 30, alias: LegacyID, type: esriFieldTypeString )
• warrantydate ( modelName: warrantydate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: WarrantyDate, type: esriFieldTypeDate )
• valveid ( modelName: valveid, nullable: true, editable: true, defaultValue: null, alias: ValveID, type: esriFieldTypeSmallInteger )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Types:

ID: 1
Name: Main Valve
Domains:
• fieldverified:
  Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown]
• valvetype:
  Coded Values: [Ball: Ball] , [MJ: MJ] , [Unknown: Unknown]
• hasbvp:
  Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown]
• opendir:
  Coded Values: [Open Right: Open Right] , [Open Left: Open Left] , [Unknown: Unknown]
• currentstat:
  Coded Values: [Open: Open] , [Closed: Closed] , [Unknown: Unknown]
• datastatus:
  Coded Values: [HIGH: Confidence Level = HIGH] , [LOW: Confidence Level = LOW]
• normalstat:
  Coded Values: [Open: Open] , [Closed: Closed] , [Unknown: Unknown]
Templates:
• Name: Main Valve
  Description:
  Prototype:
  fieldverified: null
  editor: null
  notes: null
  facilityid: null
  valveid: null
  hasbvp: null
  currentstat: null
  datastatus: null
  normalstat: null
  servicetype: 1
  dataverified: null
  valvetype: null
  opendir: null
  datasource: null
  whoverified: null
  warrantydate: null
  lastupdated: null
  legacyid: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Private Valve
Domains:
• fieldverified:
  Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown]
• valvetype:
  Coded Values: [Ball: Ball] , [MJ: MJ] , [Unknown: Unknown]
• hasbvp:
  Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown]
• opendir:
  Coded Values: [Open Right: Open Right] , [Open Left: Open Left] , [Unknown: Unknown]
• currentstat:
  Coded Values: [Open: Open] , [Closed: Closed] , [Unknown: Unknown]
• datastatus:
  Coded Values: [HIGH: Confidence Level = HIGH] , [LOW: Confidence Level = LOW]
• normalstat:
  Coded Values: [Open: Open] , [Closed: Closed] , [Unknown: Unknown]
Templates:
• Name: Private Valve
  Description:
  Prototype:
  fieldverified: null
  editor: null
  notes: null
  facilityid: null
  valveid: null
  hasbvp: null
  currentstat: null
  datastatus: null
  normalstat: null
  servicetype: 4
  dataverified: null
  valvetype: null
  opendir: null
  datasource: null
  whoverified: null
  warrantydate: null
  lastupdated: null
  legacyid: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Service Valve
Domains:
• fieldverified:
  Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown]
• valvetype:
  Coded Values: [Ball: Ball] , [MJ: MJ] , [Unknown: Unknown]
• hasbvp:
  Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown]
• opendir:
  Coded Values: [Open Right: Open Right] , [Open Left: Open Left] , [Unknown: Unknown]
• currentstat:
  Coded Values: [Open: Open] , [Closed: Closed] , [Unknown: Unknown]
• datastatus:
  Coded Values: [HIGH: Confidence Level = HIGH] , [LOW: Confidence Level = LOW]
• normalstat:
  Coded Values: [Open: Open] , [Closed: Closed] , [Unknown: Unknown]
Templates:
• Name: Service Valve
  Description:
  Prototype:
  fieldverified: null
  editor: null
  notes: null
  facilityid: null
  valveid: null
  hasbvp: null
  currentstat: null
  datastatus: null
  normalstat: null
  servicetype: 2
  dataverified: null
  valvetype: null
  opendir: null
  datasource: null
  whoverified: null
  warrantydate: null
  lastupdated: null
  legacyid: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Unknown
Domains:
• fieldverified:
  Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown]
• valvetype:
  Coded Values: [Ball: Ball] , [MJ: MJ] , [Unknown: Unknown]
• hasbvp:
  Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown]
• opendir:
  Coded Values: [Open Right: Open Right] , [Open Left: Open Left] , [Unknown: Unknown]
• currentstat:
  Coded Values: [Open: Open] , [Closed: Closed] , [Unknown: Unknown]
• datastatus:
  Coded Values: [HIGH: Confidence Level = HIGH] , [LOW: Confidence Level = LOW]
• normalstat:
  Coded Values: [Open: Open] , [Closed: Closed] , [Unknown: Unknown]
Templates:
• Name: Unknown
  Description:
  Prototype:
  fieldverified: null
  editor: null
  notes: null
  facilityid: null
  valveid: null
  hasbvp: null
  currentstat: null
  datastatus: null
  normalstat: null
  servicetype: 3
  dataverified: null
  valvetype: null
  opendir: null
  datasource: null
  whoverified: null
  warrantydate: null
  lastupdated: null
  legacyid: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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