Name: Storm Sewer Mains

Display Field: Diameter

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text: Maintained and updated by City of Janesville GIS staff, and also updated by engineering staff or utility staff as needed.

Min. Scale: 50000

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 476968.486854337
YMin: 241643.991470009
XMax: 514074.348994169
YMax: 296202.472904012
Spatial Reference: 103453 (8128)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"StormMainType","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3},"value":"1","label":"Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3},"value":"2","label":"Lead"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[168,112,0,255],"width":2},"value":"3","label":"Culvert"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,152,0,255],"width":1},"value":"5","label":"Drain Tile"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[0,0,0,255],"width":4},"value":"4","label":"Private"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[205,189,252,255],"toColor":[205,189,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,252,179,255],"toColor":[184,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,208,184,255],"toColor":[252,208,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,249,252,255],"toColor":[192,249,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,211,255],"toColor":[252,179,211,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[246,252,197,255],"toColor":[246,252,197,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,222,252,255],"toColor":[210,222,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,179,252,255],"toColor":[250,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,252,217,255],"toColor":[207,252,217,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,236,255],"toColor":[252,212,236,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,242,215,255],"toColor":[252,242,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,194,203,255],"toColor":[252,194,203,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,224,179,255],"toColor":[252,224,179,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

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: GlobalID

Type ID Field: StormMainType

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FacilityID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: false)
• StormMainType (type: esriFieldTypeInteger, alias: Storm Main Type, SQL Type: sqlTypeOther, nullable: true, editable: false)
• InstallDate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• StreetName (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• Source (type: esriFieldTypeString, alias: Location Source, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: false, Coded Values: [Aerial: Aerial], [Approximate: Approximate], [Asbuilt: Asbuilt], ... 6 more ...)
• Diameter (type: esriFieldTypeInteger, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: false, Coded Values: [12: 12"], [18: 18"], [21: 21"], ... 51 more ...)
• AsbuiltLength (type: esriFieldTypeDouble, alias: Asbuilt Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
• UpstreamElevation (type: esriFieldTypeDouble, alias: Upstream Invert, SQL Type: sqlTypeOther, nullable: true, editable: false)
• DownstreamDirection (type: esriFieldTypeString, alias: Downstream Direction, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: false, Coded Values: [N: N], [S: S], [E: E], ... 5 more ...)
• DownstreamElevation (type: esriFieldTypeDouble, alias: Downstream Invert, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Slope (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: false)
• PipeMaterial (type: esriFieldTypeString, alias: Pipe Material, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: false, Coded Values: [AC: Asbestos Cement], [BR: Brick], [CD: Cast Ductile Iron], ... 17 more ...)
• MaterialLabel (type: esriFieldTypeString, alias: Material Label, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: false, Coded Values: [CI STM: CI STM], [CMP STM: CMP STM], [CON STM: CON STM], ... 6 more ...)
• OwnedBy (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: false, Coded Values: [1: City of Janesville], [2: Alliant Energy], [3: Rock County Electric], ... 3 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 1
Name: Main
Domains:

• Field Name: Source
  Inherited
  
• Field Name: Diameter
  Inherited
  
• Field Name: DownstreamDirection
  Inherited
  
• Field Name: PipeMaterial
  Inherited
  
• Field Name: MaterialLabel
  Inherited
  
• Field Name: OwnedBy
  Inherited
  
Templates:

Name: Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:


---

ID: 2
Name: Lead
Domains:

• Field Name: Source
  Inherited
  
• Field Name: Diameter
  Inherited
  
• Field Name: DownstreamDirection
  Inherited
  
• Field Name: PipeMaterial
  Inherited
  
• Field Name: MaterialLabel
  Inherited
  
• Field Name: OwnedBy
  Inherited
  
Templates:

Name: Lead
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:


---

ID: 3
Name: Culvert
Domains:

• Field Name: Source
  Inherited
  
• Field Name: Diameter
  Inherited
  
• Field Name: DownstreamDirection
  Inherited
  
• Field Name: PipeMaterial
  Inherited
  
• Field Name: MaterialLabel
  Inherited
  
• Field Name: OwnedBy
  Inherited
  
Templates:

Name: Culvert
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:


---

ID: 5
Name: Drain Tile
Domains:

• Field Name: Source
  Inherited
  
• Field Name: Diameter
  Inherited
  
• Field Name: DownstreamDirection
  Inherited
  
• Field Name: PipeMaterial
  Inherited
  
• Field Name: MaterialLabel
  Inherited
  
• Field Name: OwnedBy
  Inherited
  
Templates:

Name: Drain Tile
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:


---

ID: 4
Name: Private
Domains:

• Field Name: Source
  Inherited
  
• Field Name: Diameter
  Inherited
  
• Field Name: DownstreamDirection
  Inherited
  
• Field Name: PipeMaterial
  Inherited
  
• Field Name: MaterialLabel
  Inherited
  
• Field Name: OwnedBy
  Inherited
  
Templates:

Name: Private
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:


---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/23/2024 7:41:24 PM

Schema Last Edit Date: 8/23/2024 7:41:24 PM

Data Last Edit Date: 8/23/2024 7:41:24 PM

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