Name: Riverside Wastewater Service

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: 77,056 structures as of 2/3/2020. Features participate in the geometric network as simple junctions, always at the end of a service lateral. Features were migrated from ArcInfo coverages via an ETL process, from sewer_lats_node --> swServiceConnection; spatial selection tools applied to separate service and tap node types. Last edited 11/1/2019 (approx).Migration date: 12/16/2019. Note there is an accounting balance issue between lateral lines (77,131), service points (77,056) and taps (75,398).

Copyright Text: City of Riverside

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13081521.4529
YMin: 4012718.9456
XMax: -13055496.5162
YMax: 4031374.1849
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"3b4324ab38bc73b710c2515b5737bde9","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAYAAACprHcmAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA1ElEQVQYlWNhIAGwkK141dVVbJcPHQ9iZGIUFOIVXlcQVf0Sq+Ki3lS1H++fbwpI9FBnZWNhuHv1YWvjvNLM+qTulRiK1bSUuwytddVhfBUdBcF///9NkJGR2fTkyZPvKIoFRPgN0N2oqqMoYetnar982pMdKIr//P77ioGBQR5Z8e9ff/5eOXn9KYYzzhy4MF/PQtOYkZGRCSZ2dPvJxZfP3riCoXhC1ZyZ37/9+GHmZBjAxMzM/fjm40N1ab2TGRgY/mMLun8zW5bMB2GsgUxqpAAAYVZNS00GlvoAAAAASUVORK5CYII=","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"visualVariables":[{"type":"rotationInfo","field":"Rotation","rotationType":"arithmetic"}]},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• AssetID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• LateralID (type: esriFieldTypeString, alias: Lateral ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• AccountID (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MapSheet (type: esriFieldTypeString, alias: Map Sheet, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• AddressNumber (type: esriFieldTypeString, alias: Address Number, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• StreetName (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LocationDescription (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• IsLargeMeter (type: esriFieldTypeString, alias: Is Large Meter?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• IsCriticalCustomer (type: esriFieldTypeString, alias: Is Critical Customer?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SumOfFlow (type: esriFieldTypeDouble, alias: Sum Of Flow, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YearInstalled (type: esriFieldTypeInteger, alias: Year Installed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OwnedBy (type: esriFieldTypeString, alias: Owned By, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MaintainedBy (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• OperationalStatus (type: esriFieldTypeString, alias: Operational Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• RevisionNotes (type: esriFieldTypeString, alias: Revision Notes, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Hyperlink (type: esriFieldTypeString, alias: Hyperlink, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• WardNumber (type: esriFieldTypeSmallInteger, alias: Ward, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Riverside Wastewater Service
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/29/2024 11:34:15 PM

Schema Last Edit Date: 1/29/2024 11:34:15 PM

Data Last Edit Date: 1/29/2024 11:34:15 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat