View In:   ArcGIS Online Map Viewer

Name: Water Meters

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 91f29ce71a32454bbb30d061a168d24a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000

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: 1.5167146921157837E-4
YMin: 3.54275107383728E-5
XMax: 8347380.311919339
YMax: 4483784.676477008
Spatial Reference: 2270  (2270)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: AssetStatus_2019
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: Active
  Label: Active
  Description: N/A
  Symbol:
  
• Value: In Construction
  Label: In Construction
  Description: N/A
  Symbol:
  
• Value: Proposed
  Label: Proposed
  Description: N/A
  Symbol:
  
• Value: Abandoned
  Label: Abandoned
  Description: N/A
  Symbol:
  
• Value: Removed and Backfilled
  Label: Removed and Backfilled
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveCenter
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: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Verdana
Font Style: normal
Font Weight: normal
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
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: AssetStatus_2019

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• ACCOUNTID ( type: esriFieldTypeString, alias: Account Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ACCOUNTID )
• METSERVICE ( type: esriFieldTypeString, alias: Metered Service, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: METSERVICE , Coded Values: [Yes: Yes] , [No: No] )
• SERVICETYPE ( type: esriFieldTypeString, alias: ServiceTypeStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERVICETYPE , Coded Values: [Domestic: Domestic] , [Commercial: Commercial] , [Industrial: Industrial] , ...12 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• LOCATIONID ( type: esriFieldTypeString, alias: Route, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LOCATIONID )
• CRITICAL ( type: esriFieldTypeSmallInteger, alias: CriticalCustomer, editable: true, nullable: true, defaultValue: 0, modelName: CRITICAL , Coded Values: [0: False] , [1: True] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• SurveyPtNum ( type: esriFieldTypeString, alias: Survey Point Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SurveyPtNum )
• SurveyDate ( type: esriFieldTypeDate, alias: Survey Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SurveyDate )
• MeterNumber ( type: esriFieldTypeString, alias: MeterNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MeterNumber )
• SizeMeter ( type: esriFieldTypeDouble, alias: SizeMeter, editable: true, nullable: true, defaultValue: null, modelName: SizeMeter , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...28 more... )
• AssetStatus_2019 ( type: esriFieldTypeString, alias: AssetStatus_2019, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: AssetStatus_2019 , Coded Values: [Active: Active] , [Proposed: Proposed] , [Abandoned: Abandoned] , ...3 more... )
• AssetOwner_2019 ( type: esriFieldTypeString, alias: AssetOwner_2019, editable: true, nullable: true, length: 50, defaultValue: City of Grants Pass, modelName: AssetOwner_2019 , Coded Values: [City of Grants Pass: City of Grants Pass] , [GPID: GPID] , [State of Oregon: State of Oregon] , ...4 more... )
• UniqueID_2019 ( type: esriFieldTypeInteger, alias: UniqueID_2019, editable: true, nullable: true, defaultValue: null, modelName: UniqueID_2019 )
• WaterPressureZone ( type: esriFieldTypeString, alias: WaterPressureZone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterPressureZone )
• AbanDate ( type: esriFieldTypeDate, alias: AbanDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AbanDate )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 252, defaultValue: null, modelName: NOTES )
• DataSource ( type: esriFieldTypeString, alias: Data Source, editable: true, nullable: true, length: 35, defaultValue: null, modelName: DataSource , Coded Values: [Aerial Photograhy: Aerial Photograhy] , [CAD As Built: CAD As Built] , [CAD Constr Drwng: CAD Constr Drwng] , ...24 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Manufacturer , Coded Values: [ABB: ABB] , [Badger: Badger] , [Metron: Metron] , ...10 more... )
• ApprxElev ( type: esriFieldTypeDouble, alias: ApprxElev, editable: true, nullable: true, defaultValue: null, modelName: ApprxElev )
• ApprxPSI ( type: esriFieldTypeDouble, alias: ApprxPSI, editable: true, nullable: true, defaultValue: null, modelName: ApprxPSI )
• HistoricID ( type: esriFieldTypeString, alias: Historic ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: HistoricID )
• ServiceSize1 ( type: esriFieldTypeDouble, alias: Service Size, editable: true, nullable: true, defaultValue: null, modelName: ServiceSize1 , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...28 more... )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled, required: true , Coded Values: [0: False] , [1: True] )
• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: 0, modelName: AncillaryRole, required: true , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• AssociatedAddress ( type: esriFieldTypeString, alias: AssociatedAddress, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AssociatedAddress )
• BackflowDevcAttached ( type: esriFieldTypeString, alias: Backflow Device Attached, editable: true, nullable: true, length: 5, defaultValue: null, modelName: BackflowDevcAttached , Coded Values: [Yes: Yes] , [No: No] )
• PhysicalLocation ( type: esriFieldTypeString, alias: Physical Location, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PhysicalLocation )
• TestGPM ( type: esriFieldTypeSmallInteger, alias: TestGPM, editable: true, nullable: true, defaultValue: null, modelName: TestGPM )
• TestPSI ( type: esriFieldTypeSmallInteger, alias: TestPSI, editable: true, nullable: true, defaultValue: null, modelName: TestPSI )
• TestDateGPM ( type: esriFieldTypeDate, alias: TestDateGPM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TestDateGPM )
• TestDatePSI ( type: esriFieldTypeDate, alias: TestDatePSI, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TestDatePSI )
• MeterSubtype ( type: esriFieldTypeString, alias: MeterSubtype, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MeterSubtype )
• ServiceLineMaterial ( type: esriFieldTypeString, alias: ServiceLineMaterial, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ServiceLineMaterial , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...36 more... )
• MeterStatus ( type: esriFieldTypeString, alias: MeterStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MeterStatus , Coded Values: [Meter Change Out: Meter Change Out] , [Meter Drop In: Meter Drop In] , [Service Install: Service Install] , ...1 more... )
• AssocMapNum ( type: esriFieldTypeString, alias: AssocMapNum, editable: true, nullable: true, length: 30, defaultValue: null, modelName: AssocMapNum )
• DefltReadSeq ( type: esriFieldTypeInteger, alias: DefltReadSeq, editable: true, nullable: true, defaultValue: null, modelName: DefltReadSeq )

Types:

ID: Active
Name: Active
Domains:
• METSERVICE:
  Inherited
• SERVICETYPE:
  Inherited
• CRITICAL:
  Inherited
• SizeMeter:
  Inherited
• AssetStatus_2019:
  Inherited
• AssetOwner_2019:
  Inherited
• DataSource:
  Inherited
• Manufacturer:
  Inherited
• ServiceSize1:
  Inherited
• Enabled:
  Inherited
• AncillaryRole:
  Inherited
• BackflowDevcAttached:
  Inherited
• ServiceLineMaterial:
  Inherited
• MeterStatus:
  Inherited
Templates:
• Name: Active
  Description:
  Prototype:
  SizeMeter: null
  AssocMapNum: null
  FACILITYID: null
  ACCOUNTID: null
  METSERVICE: Yes
  SERVICETYPE: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  LOCATIONID: null
  CRITICAL: 0
  DefltReadSeq: null
  MeterStatus: null
  ServiceLineMaterial: null
  MeterSubtype: null
  TestDatePSI: null
  SurveyPtNum: null
  SurveyDate: null
  MeterNumber: null
  AssetStatus_2019: Active
  AssetOwner_2019: City of Grants Pass
  UniqueID_2019: null
  WaterPressureZone: null
  AbanDate: null
  NOTES: null
  DataSource: null
  Manufacturer: null
  ApprxElev: null
  ApprxPSI: null
  HistoricID: null
  ServiceSize1: null
  Enabled: 1
  AncillaryRole: 0
  AssociatedAddress: null
  BackflowDevcAttached: null
  PhysicalLocation: null
  TestGPM: null
  TestPSI: null
  TestDateGPM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: In Construction
Name: In Construction
Domains:
• METSERVICE:
  Inherited
• SERVICETYPE:
  Inherited
• CRITICAL:
  Inherited
• SizeMeter:
  Inherited
• AssetStatus_2019:
  Inherited
• AssetOwner_2019:
  Inherited
• DataSource:
  Inherited
• Manufacturer:
  Inherited
• ServiceSize1:
  Inherited
• Enabled:
  Inherited
• AncillaryRole:
  Inherited
• BackflowDevcAttached:
  Inherited
• ServiceLineMaterial:
  Inherited
• MeterStatus:
  Inherited
Templates:
• Name: In Construction
  Description:
  Prototype:
  SizeMeter: null
  AssocMapNum: null
  FACILITYID: null
  ACCOUNTID: null
  METSERVICE: Yes
  SERVICETYPE: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  LOCATIONID: null
  CRITICAL: 0
  DefltReadSeq: null
  MeterStatus: null
  ServiceLineMaterial: null
  MeterSubtype: null
  TestDatePSI: null
  SurveyPtNum: null
  SurveyDate: null
  MeterNumber: null
  AssetStatus_2019: In Construction
  AssetOwner_2019: City of Grants Pass
  UniqueID_2019: null
  WaterPressureZone: null
  AbanDate: null
  NOTES: null
  DataSource: null
  Manufacturer: null
  ApprxElev: null
  ApprxPSI: null
  HistoricID: null
  ServiceSize1: null
  Enabled: 1
  AncillaryRole: 0
  AssociatedAddress: null
  BackflowDevcAttached: null
  PhysicalLocation: null
  TestGPM: null
  TestPSI: null
  TestDateGPM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Proposed
Name: Proposed
Domains:
• METSERVICE:
  Inherited
• SERVICETYPE:
  Inherited
• CRITICAL:
  Inherited
• SizeMeter:
  Inherited
• AssetStatus_2019:
  Inherited
• AssetOwner_2019:
  Inherited
• DataSource:
  Inherited
• Manufacturer:
  Inherited
• ServiceSize1:
  Inherited
• Enabled:
  Inherited
• AncillaryRole:
  Inherited
• BackflowDevcAttached:
  Inherited
• ServiceLineMaterial:
  Inherited
• MeterStatus:
  Inherited
Templates:
• Name: Proposed
  Description:
  Prototype:
  SizeMeter: null
  AssocMapNum: null
  FACILITYID: null
  ACCOUNTID: null
  METSERVICE: Yes
  SERVICETYPE: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  LOCATIONID: null
  CRITICAL: 0
  DefltReadSeq: null
  MeterStatus: null
  ServiceLineMaterial: null
  MeterSubtype: null
  TestDatePSI: null
  SurveyPtNum: null
  SurveyDate: null
  MeterNumber: null
  AssetStatus_2019: Proposed
  AssetOwner_2019: City of Grants Pass
  UniqueID_2019: null
  WaterPressureZone: null
  AbanDate: null
  NOTES: null
  DataSource: null
  Manufacturer: null
  ApprxElev: null
  ApprxPSI: null
  HistoricID: null
  ServiceSize1: null
  Enabled: 1
  AncillaryRole: 0
  AssociatedAddress: null
  BackflowDevcAttached: null
  PhysicalLocation: null
  TestGPM: null
  TestPSI: null
  TestDateGPM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Abandoned
Name: Abandoned
Domains:
• METSERVICE:
  Inherited
• SERVICETYPE:
  Inherited
• CRITICAL:
  Inherited
• SizeMeter:
  Inherited
• AssetStatus_2019:
  Inherited
• AssetOwner_2019:
  Inherited
• DataSource:
  Inherited
• Manufacturer:
  Inherited
• ServiceSize1:
  Inherited
• Enabled:
  Inherited
• AncillaryRole:
  Inherited
• BackflowDevcAttached:
  Inherited
• ServiceLineMaterial:
  Inherited
• MeterStatus:
  Inherited
Templates:
• Name: Abandoned
  Description:
  Prototype:
  SizeMeter: null
  AssocMapNum: null
  FACILITYID: null
  ACCOUNTID: null
  METSERVICE: Yes
  SERVICETYPE: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  LOCATIONID: null
  CRITICAL: 0
  DefltReadSeq: null
  MeterStatus: null
  ServiceLineMaterial: null
  MeterSubtype: null
  TestDatePSI: null
  SurveyPtNum: null
  SurveyDate: null
  MeterNumber: null
  AssetStatus_2019: Abandoned
  AssetOwner_2019: City of Grants Pass
  UniqueID_2019: null
  WaterPressureZone: null
  AbanDate: null
  NOTES: null
  DataSource: null
  Manufacturer: null
  ApprxElev: null
  ApprxPSI: null
  HistoricID: null
  ServiceSize1: null
  Enabled: 1
  AncillaryRole: 0
  AssociatedAddress: null
  BackflowDevcAttached: null
  PhysicalLocation: null
  TestGPM: null
  TestPSI: null
  TestDateGPM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Removed and Backfilled
Name: Removed and Backfilled
Domains:
• METSERVICE:
  Inherited
• SERVICETYPE:
  Inherited
• CRITICAL:
  Inherited
• SizeMeter:
  Inherited
• AssetStatus_2019:
  Inherited
• AssetOwner_2019:
  Inherited
• DataSource:
  Inherited
• Manufacturer:
  Inherited
• ServiceSize1:
  Inherited
• Enabled:
  Inherited
• AncillaryRole:
  Inherited
• BackflowDevcAttached:
  Inherited
• ServiceLineMaterial:
  Inherited
• MeterStatus:
  Inherited
Templates:
• Name: Removed and Backfilled
  Description:
  Prototype:
  SizeMeter: null
  AssocMapNum: null
  FACILITYID: null
  ACCOUNTID: null
  METSERVICE: Yes
  SERVICETYPE: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  LOCATIONID: null
  CRITICAL: 0
  DefltReadSeq: null
  MeterStatus: null
  ServiceLineMaterial: null
  MeterSubtype: null
  TestDatePSI: null
  SurveyPtNum: null
  SurveyDate: null
  MeterNumber: null
  AssetStatus_2019: Removed and Backfilled
  AssetOwner_2019: City of Grants Pass
  UniqueID_2019: null
  WaterPressureZone: null
  AbanDate: null
  NOTES: null
  DataSource: null
  Manufacturer: null
  ApprxElev: null
  ApprxPSI: null
  HistoricID: null
  ServiceSize1: null
  Enabled: 1
  AncillaryRole: 0
  AssociatedAddress: null
  BackflowDevcAttached: null
  PhysicalLocation: null
  TestGPM: null
  TestPSI: null
  TestDateGPM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Sync,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

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