View In:   ArcGIS Online Map Viewer

Parent Layer: Water

Name: PRV

Display Field: AncillaryRole

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1500

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: 3088599.574638948
YMin: 1668665.548203826
XMax: 3114424.4497944713
YMax: 1705049.653523177
Spatial Reference: 102654  (2232)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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

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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: 0, modelName: AncillaryRole )
• LegacyID ( type: esriFieldTypeString, alias: Work Order, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LegacyID )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Comments )
• ServiceArea ( type: esriFieldTypeString, alias: Service Area, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ServiceArea , Coded Values: [Denver: Denver] , [MapleGrove: MapleGrove] )
• PressureZone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, 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... )
• SurveyCollection ( type: esriFieldTypeString, alias: Survey Collection, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SurveyCollection , Coded Values: [Unknown: Unknown] , [Other: Other] , [CAD: CAD] , ...8 more... )
• PRVType ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PRVType )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Model )
• UpstreamPSI ( type: esriFieldTypeInteger, alias: Upstream PSI, editable: true, nullable: true, defaultValue: null, modelName: UpstreamPSI )
• DownstreamPSI ( type: esriFieldTypeInteger, alias: Downstream PSI, editable: true, nullable: true, defaultValue: null, modelName: DownstreamPSI )
• SetPoint ( type: esriFieldTypeInteger, alias: Set Point, editable: true, nullable: true, defaultValue: null, modelName: SetPoint )
• PressureZoneLow ( type: esriFieldTypeString, alias: Low Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PressureZoneLow , Coded Values: [A-Blue: A-Blue PS #1, #2 & #5] , [B-Blue: B-Blue PS #3] , [C-Green: C-Green PS #4] , ...22 more... )
• PressureZoneHigh ( type: esriFieldTypeString, alias: High Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PressureZoneHigh , Coded Values: [A-Blue: A-Blue PS #1, #2 & #5] , [B-Blue: B-Blue PS #3] , [C-Green: C-Green PS #4] , ...22 more... )
• ValveFunction ( type: esriFieldTypeString, alias: Function, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ValveFunction )
• ValveSize ( type: esriFieldTypeInteger, alias: Size, editable: true, nullable: true, defaultValue: null, modelName: ValveSize )
• additionalwork ( type: esriFieldTypeString, alias: Additional Work Needed, editable: true, nullable: true, length: 5, defaultValue: null, modelName: additionalwork , 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 )
• DataValid ( type: esriFieldTypeString, alias: DataValid, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DataValid , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• HighPSI_ValveSize ( type: esriFieldTypeString, alias: HighPSI_ValveSize, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HighPSI_ValveSize )
• LowPSI_ValveSize ( type: esriFieldTypeString, alias: LowPSI_ValveSize, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LowPSI_ValveSize )
• MainMaterial ( type: esriFieldTypeString, alias: MainMaterial, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MainMaterial , Coded Values: [CastIron: Cast Iron] , [Steel: Steel] , [DuctileIron: Ductile Iron] , ...10 more... )
• MainSize ( type: esriFieldTypeString, alias: MainSize, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MainSize )
• DirectionOfOperation ( type: esriFieldTypeString, alias: DirectionOfOperation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DirectionOfOperation )
• AdditonalWorkType ( type: esriFieldTypeString, alias: AdditonalWorkType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AdditonalWorkType )
• DesignPSI_High ( type: esriFieldTypeInteger, alias: DesignPSI_High, editable: true, nullable: true, defaultValue: null, modelName: DesignPSI_High )
• DesignPSI_Low ( type: esriFieldTypeInteger, alias: DesignPSI_Low, editable: true, nullable: true, defaultValue: null, modelName: DesignPSI_Low )
• PRV_Num ( type: esriFieldTypeString, alias: PRV #, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRV_Num )
• PRV_Serial ( type: esriFieldTypeString, alias: PRV Serial, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRV_Serial )
• Pilot_Valve_Manufacturer ( type: esriFieldTypeString, alias: Pilot Valve Manufacturer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Pilot_Valve_Manufacturer )
• Pilot_Valve_Model ( type: esriFieldTypeString, alias: Pilot Valve Model, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Pilot_Valve_Model )
• Pilot_Valve_Serial_Number ( type: esriFieldTypeString, alias: Pilot Valve Serial Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Pilot_Valve_Serial_Number )
• ExpectedActivation ( type: esriFieldTypeDouble, alias: Expected Activation, editable: true, nullable: true, defaultValue: null, modelName: ExpectedActivation )
• SustainingPressure ( type: esriFieldTypeDouble, alias: Sustaining Pressure, editable: true, nullable: true, defaultValue: null, modelName: SustainingPressure )
• DataValidComment ( type: esriFieldTypeString, alias: Data Valid Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DataValidComment )
• WorkDate ( type: esriFieldTypeDate, alias: Date Last Inspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WorkDate )
• AdditionalWorkComment ( type: esriFieldTypeString, alias: Additional Work Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AdditionalWorkComment )
• ReplacementRecomendation ( type: esriFieldTypeInteger, alias: ReplacementRecomendation, editable: true, nullable: true, defaultValue: null, modelName: ReplacementRecomendation , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• ReplacementComment ( type: esriFieldTypeString, alias: ReplacementComment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ReplacementComment )
• PRV_Status ( type: esriFieldTypeString, alias: PRV_Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRV_Status , Coded Values: [Online: Online] , [Offline: Offline] )

Templates:

• Name: PRV
  Description:
  Prototype:
  ReplacementComment: null
  ReplacementRecomendation: null
  PRV_Status: null
  AncillaryRole: 0
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  PressureZone: null
  SurveyCollection: null
  PRVType: null
  Manufacturer: null
  Model: null
  UpstreamPSI: null
  DownstreamPSI: null
  SetPoint: null
  PressureZoneLow: null
  PressureZoneHigh: null
  ValveFunction: null
  ValveSize: null
  additionalwork: null
  Accessibility: null
  DataValid: null
  HighPSI_ValveSize: null
  LowPSI_ValveSize: null
  MainMaterial: null
  MainSize: null
  DirectionOfOperation: null
  AdditonalWorkType: null
  DesignPSI_High: null
  DesignPSI_Low: null
  PRV_Num: null
  PRV_Serial: null
  Pilot_Valve_Manufacturer: null
  Pilot_Valve_Model: null
  Pilot_Valve_Serial_Number: null
  ExpectedActivation: null
  SustainingPressure: null
  DataValidComment: null
  WorkDate: null
  AdditionalWorkComment: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• GIS_PROD.GDB_ADMIN.PRV_History (2) -- Related To: MaintenancePRV_History (479)

Capabilities: Query,Update,Uploads,Editing,Extract

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   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata