Name: Riverside Wastewater Tap

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: 75,938 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, CA

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: -13081518.9085
YMin: 4012704.1104
XMax: -13055496.7164
YMax: 4031382.308
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"95e34bb5ae8c1f137736cc8c481b404a","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAkklEQVQYlYXOr4oCYRSH4efomC2yxavwSsSiWPZGNqwWwXuwGUTxHuzm6QZhixt2g0mcTxxxcJIvHDjwe8+fzBuyZ7NLsl9GBR8F23E41oQTW/QDTb43SW8YDqWwSbr38GVzO/jEtBRanC9cH8MV/9WJQfhbJ1/BDA3sE4vaD6MwXyXLFp2cfBKKmnBnHH4oq+IGnjUiZekl0EIAAAAASUVORK5CYII=","contentType":"image/png","width":6,"height":6,"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)
• MapSheet (type: esriFieldTypeString, alias: MapSheet, 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)
• 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: OperationalStatus, 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 Tap
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:35:05 PM

Schema Last Edit Date: 1/29/2024 11:35:05 PM

Data Last Edit Date: 1/29/2024 11:35:05 PM

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