Name: Riverside Trunk Wastewater Main Others

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Primary distribution system for wastewater. 19,359 pipe segments (2/3/2020). Differentiated by 4 subtypes: Gravity Mains (1), Trunk Mains (2) => 12" diameter, Force Mains (3) and Siphons (4). Participates in geometric network as complex edge. Attributes include: size, diameter, shape, length, slope, inverts, and maintenance frequency; COGO and Editor Tracking attributes. Last updated Nov. 4, 2019. Converted from tiled arcinfo coverages through ETL process that merged the tiles into a seamless file geodatabase. FGDB date: 12/16/2019. Features from swAbandonedLine and swHistoricalLine are incorporated in this feature class with OperationalStatus set to Abandoned. Z-Value enabled.

Copyright Text: City of Riverside, CA

Min. Scale: 0

Max. Scale: 25600

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13081533.0025
YMin: 4009803.981
XMax: -13055403.6526
YMax: 4031393.7387
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SubType","uniqueValueGroups":[{"heading":"SubType","classes":[{"label":"Trunk Main >= 12\"","description":"Trunk Main >= 12\"","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":2},"values":[["2"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":2},"value":"2","label":"Trunk Main >= 12\""}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,245,252,255],"toColor":[210,245,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,246,255],"toColor":[252,179,246,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,252,182,255],"toColor":[250,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,193,184,255],"toColor":[252,193,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,189,252,255],"toColor":[182,189,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,184,255],"toColor":[182,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[241,215,252,255],"toColor":[241,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,241,215,255],"toColor":[252,241,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,252,220,255],"toColor":[212,252,220,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,221,252,255],"toColor":[194,221,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,192,217,255],"toColor":[252,192,217,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,218,255],"toColor":[252,212,218,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,245,255],"toColor":[179,252,245,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: SubType

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• AssetID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• UpstreamStructureID (type: esriFieldTypeString, alias: UpstreamStructureID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• DownstreamStructureID (type: esriFieldTypeString, alias: DownstreamStructureID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• CasingID (type: esriFieldTypeString, alias: CasingID, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• FeatureReference (type: esriFieldTypeString, alias: FeatureReference, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SubType (type: esriFieldTypeInteger, alias: SubType, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 9])
• MapSheet (type: esriFieldTypeString, alias: MapSheet, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• PipeDiameter (type: esriFieldTypeInteger, alias: PipeDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PipeLength (type: esriFieldTypeDouble, alias: PipeLength, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PipeMaterial (type: esriFieldTypeString, alias: PipeMaterial, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• PipeShape (type: esriFieldTypeString, alias: PipeShape, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• PipeOffset (type: esriFieldTypeInteger, alias: PipeOffset, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Slope (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UpstreamInvert (type: esriFieldTypeDouble, alias: UpstreamInvert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DownstreamInvert (type: esriFieldTypeDouble, alias: DownstreamInvert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UpstreamInvert1929 (type: esriFieldTypeDouble, alias: UpstreamInvert1929, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DownstreamInvert1929 (type: esriFieldTypeDouble, alias: DownstreamInvert1929, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YearInstalled (type: esriFieldTypeInteger, alias: YearInstalled, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YearLined (type: esriFieldTypeInteger, alias: YearLined, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LiningType (type: esriFieldTypeString, alias: LiningType, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• WaterType (type: esriFieldTypeString, alias: WaterType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• OwnedBy (type: esriFieldTypeString, alias: OwnedBy, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MaintainedBy (type: esriFieldTypeString, alias: MaintainedBy, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MaintenanceFrequency (type: esriFieldTypeString, alias: MaintenanceFrequency, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MaintenanceMonth (type: esriFieldTypeString, alias: MaintenanceMonth, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• MaintenanceCrew (type: esriFieldTypeString, alias: MaintenanceCrew, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• MaintenanceMaster (type: esriFieldTypeString, alias: MaintenanceMaster, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• OperationalStatus (type: esriFieldTypeString, alias: OperationalStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SourceType (type: esriFieldTypeInteger, alias: SourceType, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SourceDrawing (type: esriFieldTypeString, alias: SourceDrawing, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• LastUpdated (type: esriFieldTypeDate, alias: LastUpdated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RevisionNotes (type: esriFieldTypeString, alias: RevisionNotes, 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: WardNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Benchmark (type: esriFieldTypeSmallInteger, alias: Benchmark, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GroupNum (type: esriFieldTypeSmallInteger, alias: GroupNum, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TaskNum (type: esriFieldTypeSmallInteger, alias: TaskNum, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PacketLabel (type: esriFieldTypeSmallInteger, alias: PacketLabel, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bearing (type: esriFieldTypeDouble, alias: Bearing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PmpSm (type: esriFieldTypeString, alias: PmpSm, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PmpLg (type: esriFieldTypeString, alias: PmpLg, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PeakWet (type: esriFieldTypeDouble, alias: PeakWet, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AvgFlow (type: esriFieldTypeDouble, alias: AvgFlow, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 2
Name: Trunk Main >= 12"
Domains:

• Field Name: SubType
  Inherited
  
Templates:

Name: 2
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubType: 2

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/29/2024 11:38:59 PM

Schema Last Edit Date: 1/29/2024 11:38:59 PM

Data Last Edit Date: 1/29/2024 11:38:59 PM

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