Name: Meters

Display Field: PublicWorks.DBO.wMeter.ComputerName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>In 2010 the City of Richland Public Works used esri data models to create four unique file geodatabases, water, sewer, storm, and irrigation, to move its data from AutoCAD to esri. After choosing esri data models changes were made with input from the different departments within public works. When the four Geodatabase were satafactory, vector data from AutoCAD was imported into the respective database and cleaned up. Then the geodatabases were put in an ArcSDE database each database creating two datasets, one for Networked features classes and one for nonNetworked feature classes. </SPAN></P></DIV></DIV></DIV>

Service Item Id: 6bb635c32d304e6da73af564d35b749b

Copyright Text: City of Richland Public Works GIS Department

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1931812.4179077148
YMin: 317266.00567626953
XMax: 1965450.9276733398
YMax: 377837.8701171875
Spatial Reference: 102749  (2286)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PublicWorks.dbo.WMNUMBERS_TABLE.SERVICE_TYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: Irrigation
  Label: Irrigation
  Description: N/A
  Symbol:
  
• Value: Water
  Label: Water
  Description: N/A
  Symbol:
  
• Value: Water Multi-Fam
  Label: Water
  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: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: Subtype

Fields:

• PublicWorks.DBO.wMeter.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PublicWorks.DBO.wMeter.FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• PublicWorks.DBO.wMeter.Subtype ( type: esriFieldTypeInteger, alias: Subtype )
• PublicWorks.DBO.wMeter.LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, length: 20 , Coded Values: [ABANDONED: Abandoned] , [ACTIVE: Active] , [PROPOSED: Proposed] , ...2 more... )
• PublicWorks.DBO.wMeter.InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• PublicWorks.DBO.wMeter.Elevation ( type: esriFieldTypeDouble, alias: Elevation )
• PublicWorks.DBO.wMeter.Rotation ( type: esriFieldTypeDouble, alias: Rotation )
• PublicWorks.DBO.wMeter.WaterType ( type: esriFieldTypeString, alias: WaterType, length: 255 , Coded Values: [POTABLE: Potable] , [RAW: Raw] , [RECLAIMED: Reclaimed] , ...1 more... )
• PublicWorks.DBO.wMeter.Diameter ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0.75: .75"] , [1: 1"] , [1.25: 1.25"] , ...21 more... )
• PublicWorks.DBO.wMeter.Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• PublicWorks.DBO.wMeter.PressureZone ( type: esriFieldTypeSmallInteger, alias: Pressure Zone , Coded Values: [0: CORE] , [1: Tapteal I] , [2: Tapteal II] , ...9 more... )
• PublicWorks.DBO.wMeter.LocationDescription ( type: esriFieldTypeString, alias: LocationDescription, length: 200 )
• PublicWorks.DBO.wMeter.DataCollection ( type: esriFieldTypeString, alias: How was the Data Collected, length: 10 , Coded Values: [ASBUILT: As-Builts] , [OTHER: Construction Drawings/Field Notes] , [LEGACY: Data from AutoCAD Conversion (2011 & Older)] , ...4 more... )
• PublicWorks.DBO.wMeter.Project ( type: esriFieldTypeString, alias: Project, length: 255 , Coded Values: [-1: Field Drawing/Crew Corrections] , [-2: Survey Corrections] , [-3: Handheld Corrections] , ...866 more... )
• PublicWorks.DBO.wMeter.Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• PublicWorks.DBO.wMeter.AsBuilt1 ( type: esriFieldTypeString, alias: Asbuilt1, length: 6 )
• PublicWorks.DBO.wMeter.AsBuilt2 ( type: esriFieldTypeString, alias: Asbuilt2, length: 6 )
• PublicWorks.DBO.wMeter.PW_GIS_Notes ( type: esriFieldTypeString, alias: PW GIS Notes, length: 255 )
• PublicWorks.DBO.wMeter.Status ( type: esriFieldTypeSmallInteger, alias: QA Status , Coded Values: [0: NoDraw] , [1: Draw] , [2: Checked 4 Ownership] , ...1 more... )
• PublicWorks.DBO.wMeter.ActivityID ( type: esriFieldTypeString, alias: ActivityID, length: 20 )
• PublicWorks.DBO.wMeter.LastActivity ( type: esriFieldTypeString, alias: LastActivity, length: 4 , Coded Values: [INST: New Installation] , [UPDT: Update Info] , [INSP: Inspection] , ...8 more... )
• PublicWorks.DBO.wMeter.DateStamp ( type: esriFieldTypeDate, alias: DateStamp, length: 8 )
• PublicWorks.DBO.wMeter.OperatedBy ( type: esriFieldTypeString, alias: OperatedBy, length: 30 )
• PublicWorks.DBO.wMeter.ComputerName ( type: esriFieldTypeString, alias: ComputerName, length: 30 )
• PublicWorks.DBO.wMeter.LocationID ( type: esriFieldTypeString, alias: LocationID, length: 30 )
• PublicWorks.DBO.wMeter.AccountNumber ( type: esriFieldTypeString, alias: AccountNumber, length: 30 )
• PublicWorks.DBO.wMeter.Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 20 )
• PublicWorks.DBO.wMeter.Critical ( type: esriFieldTypeSmallInteger, alias: Critical , Coded Values: [0: No] , [1: Yes] , [2: N/A] )
• PublicWorks.DBO.wMeter.ReadStatus ( type: esriFieldTypeString, alias: ReadStatus, length: 20 )
• PublicWorks.DBO.wMeter.Reading ( type: esriFieldTypeInteger, alias: Reading )
• PublicWorks.DBO.wMeter.OldMeterNumber ( type: esriFieldTypeString, alias: OldMeterNumber, length: 20 )
• PublicWorks.DBO.wMeter.OldReading ( type: esriFieldTypeInteger, alias: OldReading )
• PublicWorks.DBO.wMeter.MeterRead ( type: esriFieldTypeInteger, alias: MeterRead )
• PublicWorks.DBO.wMeter.GPSx ( type: esriFieldTypeDouble, alias: GPSx )
• PublicWorks.DBO.wMeter.GPSy ( type: esriFieldTypeDouble, alias: GPSy )
• PublicWorks.DBO.wMeter.TestedDate ( type: esriFieldTypeDate, alias: TestedDate, length: 8 )
• PublicWorks.DBO.wMeter.LowTest ( type: esriFieldTypeDouble, alias: LowTest )
• PublicWorks.DBO.wMeter.HighTest ( type: esriFieldTypeDouble, alias: HighTest )
• PublicWorks.DBO.wMeter.PassFail ( type: esriFieldTypeString, alias: PassFail, length: 10 , Coded Values: [Pass: Pass] , [Fail: Fail] )
• PublicWorks.DBO.wMeter.Owner ( type: esriFieldTypeString, alias: Owner, length: 10 , Coded Values: [COR: City Of Richland] , [COE: Corps Of Engineers] , [POB: Port Of Benton] , ...14 more... )
• PublicWorks.DBO.wMeter.Maintenance ( type: esriFieldTypeSmallInteger, alias: Maintenance , Coded Values: [0: City] , [1: Private] , [2: County] , ...1 more... )
• PublicWorks.DBO.wMeter.Shape ( type: esriFieldTypeGeometry, alias: Shape )
• PublicWorks.DBO.wMeter.ADDID ( type: esriFieldTypeInteger, alias: ADDID )
• PublicWorks.DBO.wMeter.COR_Material ( type: esriFieldTypeString, alias: COR_Material, length: 100 , Coded Values: [AC: Asbestos Concrete] , [CC: Concrete Cylinder] , [CI: Cast Iron] , ...14 more... )
• PublicWorks.DBO.wMeter.PVT_Material ( type: esriFieldTypeString, alias: PVT_Material, length: 100 , Coded Values: [AC: Asbestos Concrete] , [CC: Concrete Cylinder] , [CI: Cast Iron] , ...14 more... )
• PublicWorks.dbo.WMNUMBERS_TABLE.ACCOUNT ( type: esriFieldTypeString, alias: ACCOUNT, length: 50 )
• PublicWorks.dbo.WMNUMBERS_TABLE.SERVICE_ADDRESS ( type: esriFieldTypeString, alias: Service Address, length: 60 )
• PublicWorks.dbo.WMNUMBERS_TABLE.ADDID ( type: esriFieldTypeInteger, alias: ADDID )
• PublicWorks.dbo.WMNUMBERS_TABLE.LOCATIONID ( type: esriFieldTypeString, alias: LOCATIONID, length: 50 )
• PublicWorks.dbo.WMNUMBERS_TABLE.METER ( type: esriFieldTypeString, alias: METER, length: 50 )
• PublicWorks.dbo.WMNUMBERS_TABLE.SERVICE_TYPE ( type: esriFieldTypeString, alias: SERVICE_TYPE, length: 50 )
• PublicWorks.dbo.WMNUMBERS_TABLE.LATITUDE ( type: esriFieldTypeString, alias: LATITUDE, length: 20 )
• PublicWorks.dbo.WMNUMBERS_TABLE.LONGITUDE ( type: esriFieldTypeString, alias: LONGITUDE, length: 20 )
• PublicWorks.dbo.WMNUMBERS_TABLE.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• PublicWorks.dbo.WMNUMBERS_TABLE.LOCATION_NOTES ( type: esriFieldTypeString, alias: LOCATION_NOTES, length: 1073741822 )

Types:

ID: 14
Name: Irrigation
Domains:
• PublicWorks.DBO.wMeter.LifecycleStatus:
  Inherited
• PublicWorks.DBO.wMeter.Rotation:
  Range: [0, 360]
• PublicWorks.DBO.wMeter.WaterType:
  Inherited
• PublicWorks.DBO.wMeter.Diameter:
  Inherited
• PublicWorks.DBO.wMeter.Enabled:
  Inherited
• PublicWorks.DBO.wMeter.PressureZone:
  Inherited
• PublicWorks.DBO.wMeter.DataCollection:
  Inherited
• PublicWorks.DBO.wMeter.Project:
  Inherited
• PublicWorks.DBO.wMeter.Status:
  Inherited
• PublicWorks.DBO.wMeter.LastActivity:
  Inherited
• PublicWorks.DBO.wMeter.Critical:
  Inherited
• PublicWorks.DBO.wMeter.PassFail:
  Inherited
• PublicWorks.DBO.wMeter.Owner:
  Inherited
• PublicWorks.DBO.wMeter.Maintenance:
  Inherited
• PublicWorks.DBO.wMeter.COR_Material:
  Inherited
• PublicWorks.DBO.wMeter.PVT_Material:
  Inherited

---

ID: 15
Name: Water
Domains:
• PublicWorks.DBO.wMeter.LifecycleStatus:
  Inherited
• PublicWorks.DBO.wMeter.Rotation:
  Range: [0, 360]
• PublicWorks.DBO.wMeter.WaterType:
  Inherited
• PublicWorks.DBO.wMeter.Diameter:
  Inherited
• PublicWorks.DBO.wMeter.Enabled:
  Inherited
• PublicWorks.DBO.wMeter.PressureZone:
  Inherited
• PublicWorks.DBO.wMeter.DataCollection:
  Inherited
• PublicWorks.DBO.wMeter.Project:
  Inherited
• PublicWorks.DBO.wMeter.Status:
  Inherited
• PublicWorks.DBO.wMeter.LastActivity:
  Inherited
• PublicWorks.DBO.wMeter.Critical:
  Inherited
• PublicWorks.DBO.wMeter.PassFail:
  Inherited
• PublicWorks.DBO.wMeter.Owner:
  Inherited
• PublicWorks.DBO.wMeter.Maintenance:
  Inherited
• PublicWorks.DBO.wMeter.COR_Material:
  Inherited
• PublicWorks.DBO.wMeter.PVT_Material:
  Inherited

---

ID: 0
Name: Unknown
Domains:
• PublicWorks.DBO.wMeter.LifecycleStatus:
  Inherited
• PublicWorks.DBO.wMeter.Rotation:
  Range: [0, 360]
• PublicWorks.DBO.wMeter.WaterType:
  Inherited
• PublicWorks.DBO.wMeter.Diameter:
  Inherited
• PublicWorks.DBO.wMeter.Enabled:
  Inherited
• PublicWorks.DBO.wMeter.PressureZone:
  Inherited
• PublicWorks.DBO.wMeter.DataCollection:
  Inherited
• PublicWorks.DBO.wMeter.Project:
  Inherited
• PublicWorks.DBO.wMeter.Status:
  Inherited
• PublicWorks.DBO.wMeter.LastActivity:
  Inherited
• PublicWorks.DBO.wMeter.Critical:
  Inherited
• PublicWorks.DBO.wMeter.PassFail:
  Inherited
• PublicWorks.DBO.wMeter.Owner:
  Inherited
• PublicWorks.DBO.wMeter.Maintenance:
  Inherited
• PublicWorks.DBO.wMeter.COR_Material:
  Inherited
• PublicWorks.DBO.wMeter.PVT_Material:
  Inherited

---

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata