View In:   ArcGIS Online Map Viewer

Name: Valves

Display Field: Enabled

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000

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: 4851.719482421875
YMin: 5018.049072280526
XMax: 3126700.877372235
YMax: 1742770.5879404843
Spatial Reference: 102654  (2232)

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

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 )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• LegacyID ( type: esriFieldTypeString, alias: Work Order, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LegacyID )
• ValveType ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 25, defaultValue: Gate, modelName: ValveType , Coded Values: [Gate: Gate] , [Butterfly: Butterfly] , [Unknown: Unknown] , ...4 more... )
• ValveSize ( type: esriFieldTypeInteger, alias: Valve Size, editable: true, nullable: true, defaultValue: null, modelName: ValveSize , Coded Values: [2: 2"] , [4: 4"] , [6: 6"] , ...27 more... )
• LifeCycleStatus ( type: esriFieldTypeString, alias: Life Cycle Status, editable: true, nullable: true, length: 15, defaultValue: ACTIVE, modelName: LifeCycleStatus , Coded Values: [PROPOSED: Proposed] , [ACTIVE: Active] , [OUTOFSERV: Out of Service] , ...6 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 15, defaultValue: Open, modelName: Status , Coded Values: [Open: Open] , [Closed: Closed] , [Unknown: Unknown] )
• WaterType ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 15, defaultValue: Potable, modelName: WaterType , Coded Values: [Potable: Potable] , [Raw: Raw] , [Unknown: Unknown] , ...3 more... )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location , Coded Values: [NPL: NPL] , [SPL: SPL] , [EPL: EPL] , ...4 more... )
• SurfaceCondition ( type: esriFieldTypeString, alias: Surface Condition, editable: true, nullable: true, length: 25, defaultValue: Asphalt, modelName: SurfaceCondition , Coded Values: [Dirt: Dirt] , [Asphalt: Asphalt] , [Concrete: Concrete] , ...3 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• ServiceArea ( type: esriFieldTypeString, alias: Service Area, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ServiceArea , Coded Values: [Denver: Denver] , [MapleGrove: MapleGrove] )
• PressureZone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 65, defaultValue: null, modelName: PressureZone , Coded Values: [A-Blue: A-Blue PS #1, #2 & #5] , [B-Blue: B-Blue PS #3] , [C-Green: C-Green PS #4] , ...22 more... )
• FireDistrict ( type: esriFieldTypeString, alias: Fire District, editable: true, nullable: true, length: 10, defaultValue: WMFPD, modelName: FireDistrict , Coded Values: [WMFPD: West Metro Fire Protection District] , [PVMDFD: Pleasant View Metropolitan District Fire Department] , [WRFD: Wheatridge Fire Department] , ...3 more... )
• SurveyCollection ( type: esriFieldTypeString, alias: Survey Collection, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SurveyCollection , Coded Values: [Unknown: Unknown] , [Other: Other] , [CAD: CAD] , ...8 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: Mueller, modelName: Manufacturer , Coded Values: [American: American AVK] , [AFC/ACIPC: American Flow Control/ American Cast Iron Pipe Company] , [Clow: Clow] , ...5 more... )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: A-2360, modelName: Model , Coded Values: [A-2360: A-2360 GV (2" - 12")] , [A-2361: A-2361 GV (14" - 48")] , [LineSeal3Class150B: LineSeal3Class150B (3" - 48")] , ...122 more... )
• OpenDir ( type: esriFieldTypeString, alias: Open Direction, editable: true, nullable: true, length: 10, defaultValue: Left, modelName: OpenDir , Coded Values: [Right: Right] , [Left: Left] , [Unknown: Unknown] )
• ValveClass ( type: esriFieldTypeString, alias: Valve Class, editable: true, nullable: true, length: 15, defaultValue: System, modelName: ValveClass , Coded Values: [System: System] , [Hydrant: Hydrant] , [FireLine: Fire Line] , ...2 more... )
• SedaruID ( type: esriFieldTypeString, alias: SedaruID, editable: true, nullable: true, length: 18, defaultValue: null, modelName: SedaruID )
• additionalwork ( type: esriFieldTypeString, alias: Additional Work Needed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: additionalwork , Coded Values: [No: No] , [Valve Replace: Valve Replace] , [Valve Box Replace: Valve Box Replace] , ...2 more... )
• NumTurns ( type: esriFieldTypeString, alias: Number of Turns, editable: true, nullable: true, length: 5, defaultValue: null, modelName: NumTurns )
• MeasureDown ( type: esriFieldTypeSingle, alias: Measure Down, editable: true, nullable: true, defaultValue: null, modelName: MeasureDown )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• DepthofMain ( type: esriFieldTypeSingle, alias: DepthofMain, editable: true, nullable: true, defaultValue: 4.5, modelName: DepthofMain )
• DataValid ( type: esriFieldTypeString, alias: DataValid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DataValid , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• Accessibility ( type: esriFieldTypeString, alias: Accessibility, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Accessibility , Coded Values: [Direct_Bury: Direct_Bury] , [Inside_Building: Inside_Building] , [Inside_Vault: Inside_Vault] , ...2 more... )
• AdditionalWorkType ( type: esriFieldTypeString, alias: AdditionalWorkType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AdditionalWorkType , Coded Values: [Valve Replace: Valve Replace] , [Valve Box Reset-Replace: Vavle Box Reset-Replace] , [Valve Nut Missing/Rounded: Valve Nut Missing/Rounded] , ...2 more... )
• DataValid_Comment ( type: esriFieldTypeString, alias: Data Valid Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DataValid_Comment )
• workdate ( type: esriFieldTypeDate, alias: Date Last Inspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: workdate )
• commentaddwork ( type: esriFieldTypeString, alias: Additonal Work Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: commentaddwork )
• outofservice ( type: esriFieldTypeString, alias: Out of Service, editable: true, nullable: true, length: 255, defaultValue: null, modelName: outofservice , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• turnstoclose ( type: esriFieldTypeDouble, alias: turnstoclose, editable: true, nullable: true, defaultValue: null, modelName: turnstoclose )

Templates:

• Name: Valves
  Description:
  Prototype:
  outofservice: null
  commentaddwork: null
  Enabled: 1
  LegacyID: null
  ValveType: Gate
  ValveSize: null
  LifeCycleStatus: ACTIVE
  Status: Open
  WaterType: Potable
  InstallDate: null
  Location: null
  SurfaceCondition: Asphalt
  Comments: null
  ServiceArea: null
  PressureZone: null
  FireDistrict: WMFPD
  SurveyCollection: null
  Manufacturer: Mueller
  Model: A-2360
  OpenDir: Left
  ValveClass: System
  SedaruID: null
  additionalwork: null
  NumTurns: null
  MeasureDown: null
  turnstoclose: null
  DepthofMain: 4.5
  DataValid: null
  Accessibility: null
  AdditionalWorkType: null
  DataValid_Comment: null
  workdate: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• GIS_PROD.GDB_ADMIN.ValveHistory (0) -- Related To: ValveHistory (1)

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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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