View In:   ArcGIS Online Map Viewer

Parent Layer: Water

Name: VALVES

Display Field: VALVEID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 37586117b7334a4ca1042ae72f1d7b8c

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 15000

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: 1795872.8742222488
YMin: 480601.5298036486
XMax: 1964591.8694607466
YMax: 642845.8946187347
Spatial Reference: 102719  (2264)

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• VALVEID ( type: esriFieldTypeString, alias: VALVEID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVEID )
• DIAM ( type: esriFieldTypeString, alias: DIAM, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DIAM , Coded Values: [1: 1] , [2: 2] , [4: 4] , ...9 more... )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TYPE , Coded Values: [UNKNOWN: UNKNOWN] , [GATE: GATE] , [BUTTERFLY: BUTTERFLY] , ...8 more... )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OWNER , Coded Values: [NO: NO] , [PH: PH] , [7L: 7L] , ...21 more... )
• COLLECTED ( type: esriFieldTypeDate, alias: COLLECTED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COLLECTED )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOURCE , Coded Values: [GPS: GPS] , [ASBUILT: ASBUILT] , [PW GPS: PW GPS] , ...17 more... )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMENTS )
• HORZ_PREC ( type: esriFieldTypeDouble, alias: HORZ_PREC, editable: true, nullable: true, defaultValue: null, modelName: HORZ_PREC )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• FieldStatus ( type: esriFieldTypeString, alias: FieldStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FieldStatus , Coded Values: [Verified: Verified] , [Not Found: Not Found] , [2nd Pass: 2nd Pass] , ...1 more... )
• InstallDate ( type: esriFieldTypeDate, alias: IntallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• RecordDrawing ( type: esriFieldTypeString, alias: RecordDrawing, editable: true, nullable: true, length: 300, defaultValue: null, modelName: RecordDrawing )
• SheetNumber ( type: esriFieldTypeString, alias: SheetNumber, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SheetNumber )
• ScanID ( type: esriFieldTypeString, alias: ScanID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ScanID )
• FileSuffix ( type: esriFieldTypeString, alias: FileSuffix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FileSuffix , Coded Values: [geo: geo] , [geo1: geo1] , [geo2: geo2] , ...2 more... )
• GeoRef ( type: esriFieldTypeString, alias: GeoRef, editable: true, nullable: true, length: 25, defaultValue: null, modelName: GeoRef )
• Maintain ( type: esriFieldTypeString, alias: Maintain, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Maintain , Coded Values: [YES: YES] , [NO: NO] )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• DIAM_CHANGED ( type: esriFieldTypeString, alias: DIAM_CHANGED, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DIAM_CHANGED )
• DIAMCG_STATUS ( type: esriFieldTypeString, alias: DIAMCG_STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DIAMCG_STATUS )
• FieldEditDate ( type: esriFieldTypeDate, alias: FieldEditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FieldEditDate )
• Inspected ( type: esriFieldTypeDate, alias: Inspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspected )
• OpenDirect ( type: esriFieldTypeString, alias: OpenDirect, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OpenDirect , Coded Values: [LEFT: LEFT] , [RIGHT: RIGHT] )
• BuryDirect ( type: esriFieldTypeDouble, alias: BuryDirect, editable: true, nullable: true, defaultValue: null, modelName: BuryDirect )
• AccessType ( type: esriFieldTypeString, alias: AccessType, editable: true, nullable: true, length: 75, defaultValue: null, modelName: AccessType , Coded Values: [VALVE BOX: VALVE BOX] , [VAULT: VAULT] , [OTHER - SEE NOTES: OTHER - SEE NOTES] )
• ValveFunction ( type: esriFieldTypeString, alias: ValveFunction, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ValveFunction , Coded Values: [MAIN LINE: MAIN LINE] , [HYDRANT: HYDRANT] , [BLOW OFF: BLOW OFF] )
• NormalPosition ( type: esriFieldTypeString, alias: NormalPosition, editable: true, nullable: true, length: 25, defaultValue: null, modelName: NormalPosition )
• Active ( type: esriFieldTypeString, alias: Active, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Active , Coded Values: [ACTIVE: ACTIVE] , [INACTIVE: INACTIVE] , [VACANT: VACANT] )
• TotalRevs ( type: esriFieldTypeDouble, alias: TotalRevs, editable: true, nullable: true, defaultValue: null, modelName: TotalRevs )
• CycleCount ( type: esriFieldTypeDouble, alias: CycleCount, editable: true, nullable: true, defaultValue: null, modelName: CycleCount )
• CleanValveCan ( type: esriFieldTypeString, alias: CleanValveCan, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CleanValveCan , Coded Values: [YES: YES] , [NO: NO] )
• ExerciseMethod ( type: esriFieldTypeString, alias: ExerciseMethod, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ExerciseMethod , Coded Values: [MACHINE: MACHINE] , [HAND: HAND] , [OTHER - SEE NOTES: OTHER - SEE NOTES] , ...1 more... )
• LOCATE_TIME ( type: esriFieldTypeString, alias: LOCATE_TIME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATE_TIME )
• LOCATE_ISSUES ( type: esriFieldTypeString, alias: LOCATE_ISSUES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATE_ISSUES )
• Operator_ValveExercise ( type: esriFieldTypeString, alias: Operator_ValveExercise, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Operator_ValveExercise , Coded Values: [FIELD CREW: FIELD CREW] , [ON-CALL CREW: ON-CALL CREW] , [OTERH: OTHER] , ...9 more... )
• NewValve ( type: esriFieldTypeString, alias: NewValve, editable: true, nullable: true, length: 5, defaultValue: null, modelName: NewValve , Coded Values: [YES: YES] , [NO: NO] )
• InspectedBy ( type: esriFieldTypeString, alias: InspectedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectedBy , Coded Values: [FIELD CREW: FIELD CREW] , [ON-CALL CREW: ON-CALL CREW] , [OTERH: OTHER] , ...9 more... )
• Exercised ( type: esriFieldTypeString, alias: Exercised, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Exercised , Coded Values: [YES: YES] , [NO: NO] )
• YearExercised ( type: esriFieldTypeSmallInteger, alias: YearExercised, editable: true, nullable: true, defaultValue: null, modelName: YearExercised )
• 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 )
• WorkorderCreated ( type: esriFieldTypeString, alias: WorkorderCreated, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WorkorderCreated , Coded Values: [YES: YES] , [NO: NO] )
• MonthScheduled ( type: esriFieldTypeString, alias: MonthScheduled, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MonthScheduled )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: VALVES
  Description:
  Prototype:
  MonthScheduled: null
  VALVEID: null
  DIAM: null
  TYPE: null
  OWNER: null
  COLLECTED: null
  SOURCE: null
  COMMENTS: null
  HORZ_PREC: null
  Enabled: 1
  FieldStatus: null
  InstallDate: null
  RecordDrawing: null
  SheetNumber: null
  ScanID: null
  FileSuffix: null
  GeoRef: null
  Maintain: null
  Notes: null
  DIAM_CHANGED: null
  DIAMCG_STATUS: null
  FieldEditDate: null
  Inspected: null
  OpenDirect: null
  BuryDirect: null
  AccessType: null
  ValveFunction: null
  NormalPosition: null
  Active: null
  TotalRevs: null
  CycleCount: null
  CleanValveCan: null
  ExerciseMethod: null
  LOCATE_TIME: null
  LOCATE_ISSUES: null
  Operator_ValveExercise: null
  NewValve: null
  InspectedBy: null
  Exercised: null
  YearExercised: null
  WorkorderCreated: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

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

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