Name: Riverside 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: 0

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":"Gravity Main < 12\"","description":"Gravity Main < 12\"","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":2},"values":[["1"]]},{"label":"Trunk Main >= 12\"","description":"Trunk Main >= 12\"","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":3},"values":[["2"]]},{"label":"Force Main","description":"Force Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":2},"values":[["3"]]},{"label":"Siphon","description":"Siphon","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":1},"values":[["4"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":2},"value":"1","label":"Gravity Main < 12\""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":3},"value":"2","label":"Trunk Main >= 12\""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":2},"value":"3","label":"Force Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":1},"value":"4","label":"Siphon"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[225,212,252,255],"toColor":[225,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[201,252,179,255],"toColor":[201,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,206,179,255],"toColor":[252,206,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,252,241,255],"toColor":[204,252,241,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,249,255],"toColor":[252,187,249,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,189,208,255],"toColor":[252,189,208,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,252,199,255],"toColor":[252,252,199,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,179,252,255],"toColor":[194,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,226,252,255],"toColor":[184,226,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,252,210,255],"toColor":[204,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,216,255],"toColor":[252,215,216,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,238,212,255],"toColor":[252,238,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,199,237,255],"toColor":[252,199,237,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: 1
Name: Gravity Main < 12"
Domains:

• Field Name: SubType
  Inherited
  
Templates:

Name: 1
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubType: 1

---

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

• Field Name: SubType
  Inherited
  
Templates:

Name: 2
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubType: 2

---

ID: 3
Name: Force Main
Domains:

• Field Name: SubType
  Inherited
  
Templates:

Name: 3
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubType: 3

---

ID: 4
Name: Siphon
Domains:

• Field Name: SubType
  Inherited
  
Templates:

Name: 4
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubType: 4

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/29/2024 11:39:54 PM

Schema Last Edit Date: 1/29/2024 11:39:54 PM

Data Last Edit Date: 1/29/2024 11:39:54 PM

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