Name: Storm Mains
Display Field: FacilityID
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: Storm Mains
Copyright Text:
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","uniqueValueGroups":[{"heading":"MainType","classes":[{"label":"Main","description":"Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3},"values":[["1"]]},{"label":"Lead","description":"Lead","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3},"values":[["2"]]},{"label":"Culvert","description":"Culvert","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[168,112,0,255],"width":2},"values":[["3"]]},{"label":"Drain Tile","description":"Drain Tile","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,152,0,255],"width":1},"values":[["5"]]},{"label":"Private","description":"Private","symbol":{"type":"esriSLS","style":"esriSLSDash","color":[0,0,0,255],"width":4},"values":[["4"]]}]}],"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":[208,199,252,255],"toColor":[208,199,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,188,255],"toColor":[179,252,188,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,214,184,255],"toColor":[252,214,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,248,252,255],"toColor":[202,248,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,210,255],"toColor":[252,179,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[238,252,210,255],"toColor":[238,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[238,182,252,255],"toColor":[238,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,247,255],"toColor":[252,215,247,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,224,252,255],"toColor":[202,224,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,185,182,255],"toColor":[252,185,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,252,182,255],"toColor":[252,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,227,255],"toColor":[187,252,227,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,218,255],"toColor":[252,215,218,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"DomainName($feature, 'Diameter') + \" \" + DomainName($feature, 'MaterialLabel')","title":"Custom"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","useClippedGeometry":true,"allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"StormMainType = 1","useCodedValues":true,"maxScale":0,"minScale":2500,"name":"Main","priority":9,"symbol":{"type":"esriTS","color":[255,255,255,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[200,120,50,255],"haloSize":1.7,"font":{"family":"Arial","size":7.1,"style":"normal","weight":"bold","decoration":"none"}}}]}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field: StormMainType
Fields:
- 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)
- InstallContractor (type: esriFieldTypeString, alias: Install Contractor, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: false, Coded Values: [City: City], [Fox: RT Fox], [Henshue: Henshue], ... 12 more ...)
- Inspector (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: false, Coded Values: [JensonS: Steve Jenson], [JorgensonD: Dewey Jorgenson], [McLeanP: Pat McLean], ... 22 more ...)
- 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 ...)
- 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], ... 18 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 ...)
- AsbuiltLength (type: esriFieldTypeDouble, alias: Asbuilt Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
- UpstreamFacility (type: esriFieldTypeString, alias: Upstream Facility, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: false)
- UpstreamElevation (type: esriFieldTypeDouble, alias: Upstream Invert, SQL Type: sqlTypeOther, nullable: true, editable: false)
- DownstreamFacility (type: esriFieldTypeString, alias: Downstream Facility, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: false)
- DownstreamElevation (type: esriFieldTypeDouble, alias: Downstream 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 ...)
- Slope (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: false)
- AsbPlansImages (type: esriFieldTypeString, alias: Asbuilt Plans Images, SQL Type: sqlTypeOther, length: 175, nullable: true, editable: false)
- AsbNotesImages (type: esriFieldTypeString, alias: Asbuilt Notes Images, SQL Type: sqlTypeOther, length: 175, nullable: true, editable: false)
- EditorComments (type: esriFieldTypeString, alias: Editor Comments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: false)
- LastUpdate (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- LastEditor (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: false, Coded Values: [BenzK: Kirby Benz], [BlumerB: Brad Blumer], [DuerrM: Margaret Duerr], ... 29 more ...)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- IsLined (type: esriFieldTypeSmallInteger, alias: Is Lined, SQL Type: sqlTypeOther, nullable: true, editable: false, Coded Values: [0: No], [1: Yes])
- LiningType (type: esriFieldTypeString, alias: Lining Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: false)
- LiningDate (type: esriFieldTypeDate, alias: Date Lined, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- LiningContract (type: esriFieldTypeString, alias: Lining Contract Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: false)
- LiningContractor (type: esriFieldTypeString, alias: Lining Contractor, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: false, Coded Values: [City: City], [Fox: RT Fox], [Great Lakes: Great Lakes Tv Seal], ... 19 more ...)
- LiningComments (type: esriFieldTypeString, alias: Lining Comments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: false)
- IsTelevised (type: esriFieldTypeSmallInteger, alias: Is Televised, SQL Type: sqlTypeOther, nullable: true, editable: false, Coded Values: [0: No], [1: Yes])
- TelevisedDate (type: esriFieldTypeDate, alias: Date Televised, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- TelevisedContractor (type: esriFieldTypeString, alias: Televised Contractor, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: false, Coded Values: [City: City], [Fox: RT Fox], [Great Lakes: Great Lakes Tv Seal], ... 19 more ...)
- TelevisingComments (type: esriFieldTypeString, alias: Televising Comments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: false)
- MediaReports (type: esriFieldTypeString, alias: Media Reports, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: false)
- TVSurveyReport (type: esriFieldTypeString, alias: TV Survey Report, SQL Type: sqlTypeOther, length: 175, nullable: true, editable: false)
- LiningTVReport (type: esriFieldTypeString, alias: Lining TV Report, SQL Type: sqlTypeOther, length: 175, nullable: true, editable: false)
- VideoPath (type: esriFieldTypeString, alias: Video Path, SQL Type: sqlTypeOther, length: 175, nullable: true, editable: false)
- VideoPath2 (type: esriFieldTypeString, alias: Video Path 2, SQL Type: sqlTypeOther, length: 175, nullable: true, editable: false)
- VideoPath3 (type: esriFieldTypeString, alias: Video Path 3, SQL Type: sqlTypeOther, length: 175, nullable: true, editable: false)
- StructuralPipeRating (type: esriFieldTypeSmallInteger, alias: Structural Pipe Rating, SQL Type: sqlTypeOther, nullable: true, editable: false)
- OMPipeRating (type: esriFieldTypeSmallInteger, alias: O&M Pipe Rating, SQL Type: sqlTypeOther, nullable: true, editable: false)
- LastActivity (type: esriFieldTypeString, alias: Last Activity, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: false, Coded Values: [INSP: Inspection/Maintenance], [RPR: Repair], [UPDT: Update Info], ... 1 more ...)
- ActivityDate (type: esriFieldTypeDate, alias: Activity Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- CleanedDate (type: esriFieldTypeDate, alias: Cleaned Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- ActivityBy (type: esriFieldTypeString, alias: Activity By, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: false)
- ActivityComments (type: esriFieldTypeString, alias: Activity Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: false)
- Sediment (type: esriFieldTypeString, alias: Sediment, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: false, Coded Values: [NONE: None], [L: Light], [M: Medium], ... 1 more ...)
- FlowDescription (type: esriFieldTypeString, alias: Flow Description, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: false, Coded Values: [NONE: None], [L: Light], [M: Medium], ... 1 more ...)
- Roots (type: esriFieldTypeString, alias: Roots, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: false, Coded Values: [NONE: None], [L: Light], [M: Medium], ... 1 more ...)
- OperationalStatus (type: esriFieldTypeString, alias: Operational Status, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: false, Coded Values: [OK: OK], [NRPR: Needs Repair], [INOP: Inoperable], ... 7 more ...)
- PipeConditionRating (type: esriFieldTypeString, alias: City Pipe Condition Rating, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false, Coded Values: [5: 5 - Like New], [4: 4 - Good], [3: 3 - Average], ... 3 more ...)
- JointConditionRating (type: esriFieldTypeString, alias: City Joint Condition Rating, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false, Coded Values: [5: 5 - Like New], [4: 4 - Good], [3: 3 - Average], ... 3 more ...)
- GroundWater (type: esriFieldTypeString, alias: Ground Water, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: false, Coded Values: [NONE: None], [L: Light], [M: Medium], ... 1 more ...)
- CrossBore (type: esriFieldTypeSmallInteger, alias: Cross Bore, SQL Type: sqlTypeOther, nullable: true, editable: false, Coded Values: [0: No], [1: Yes])
- NeedRepair (type: esriFieldTypeSmallInteger, alias: Need Repair, SQL Type: sqlTypeOther, nullable: true, editable: false, Coded Values: [0: No], [1: Yes])
- FieldLinkedDocument (type: esriFieldTypeString, alias: Field Linked Document, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: false)
- SDELinkedDocument (type: esriFieldTypeString, alias: SDE Linked Document, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: false)
- LinkedDocument (type: esriFieldTypeString, alias: Linked Document, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: false)
- LinkedDocument2 (type: esriFieldTypeString, alias: Linked Document 2, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: false)
- LinkedDocument3 (type: esriFieldTypeString, alias: Linked Document 3, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: false)
- LinkedDocument4 (type: esriFieldTypeString, alias: Linked Document 4, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: false)
- LinkedDocument5 (type: esriFieldTypeString, alias: Linked Document 5, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: false)
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- USVerticalOffset (type: esriFieldTypeDouble, alias: Upstream Vertical Offset, SQL Type: sqlTypeOther, nullable: true, editable: false)
- DSVerticalOffset (type: esriFieldTypeDouble, alias: Downstream Vertical Offset, SQL Type: sqlTypeOther, nullable: true, editable: false)
- CleanedFootage (type: esriFieldTypeDouble, alias: Cleaned Footage, SQL Type: sqlTypeOther, nullable: true, editable: false)
- IsPointRepaired (type: esriFieldTypeSmallInteger, alias: Is Point Repaired, SQL Type: sqlTypeOther, nullable: true, editable: false, Coded Values: [0: No], [1: Yes])
- PointRepairDate (type: esriFieldTypeDate, alias: Date Point Repaired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- PointRepairContract (type: esriFieldTypeString, alias: Point Repair Contract Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: false)
- PointRepairContractor (type: esriFieldTypeString, alias: Point Repair Contractor, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: false, Coded Values: [City: City], [Fox: RT Fox], [Great Lakes: Great Lakes Tv Seal], ... 19 more ...)
- PointRepairComments (type: esriFieldTypeString, alias: Point Repair Comments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: false)
- 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 ...)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- CreationDate (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Types:
ID: 1
Name: Main
Domains:
- Field Name: InstallContractor
Inherited
- Field Name: Inspector
Inherited
- Field Name: Source
Inherited
- Field Name: Diameter
Inherited
- Field Name: PipeMaterial
Inherited
- Field Name: MaterialLabel
Inherited
- Field Name: DownstreamDirection
Inherited
- Field Name: LastEditor
Inherited
- Field Name: IsLined
Inherited
- Field Name: IsTelevised
Inherited
- Field Name: OwnedBy
Inherited
Templates:
Name: Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- isvariable: 0
- activeflag: 1
- qcflag: 0
Name: Main (1)
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- isvariable: 0
- activeflag: 1
- qcflag: 0
ID: 2
Name: Lead
Domains:
- Field Name: InstallContractor
Inherited
- Field Name: Inspector
Inherited
- Field Name: Source
Inherited
- Field Name: Diameter
Inherited
- Field Name: PipeMaterial
Inherited
- Field Name: MaterialLabel
Inherited
- Field Name: DownstreamDirection
Inherited
- Field Name: LastEditor
Inherited
- Field Name: IsLined
Inherited
- Field Name: IsTelevised
Inherited
- Field Name: OwnedBy
Inherited
Templates:
Name: Lead
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- isvariable: 0
- activeflag: 1
- qcflag: 0
Name: Lead (1)
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- isvariable: 0
- activeflag: 1
- qcflag: 0
ID: 3
Name: Culvert
Domains:
- Field Name: InstallContractor
Inherited
- Field Name: Inspector
Inherited
- Field Name: Source
Inherited
- Field Name: Diameter
Inherited
- Field Name: PipeMaterial
Inherited
- Field Name: MaterialLabel
Inherited
- Field Name: DownstreamDirection
Inherited
- Field Name: LastEditor
Inherited
- Field Name: IsLined
Inherited
- Field Name: IsTelevised
Inherited
- Field Name: OwnedBy
Inherited
Templates:
Name: Culvert
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- isvariable: 0
- activeflag: 1
- qcflag: 0
Name: Culvert (1)
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- isvariable: 0
- activeflag: 1
- qcflag: 0
ID: 5
Name: Drain Tile
Domains:
- Field Name: InstallContractor
Inherited
- Field Name: Inspector
Inherited
- Field Name: Source
Inherited
- Field Name: Diameter
Inherited
- Field Name: PipeMaterial
Inherited
- Field Name: MaterialLabel
Inherited
- Field Name: DownstreamDirection
Inherited
- Field Name: LastEditor
Inherited
- Field Name: OwnedBy
Inherited
Templates:
Name: Drain Tile
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- isvariable: 0
- activeflag: 1
- qcflag: 0
Name: Drain Tile (1)
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- isvariable: 0
- activeflag: 1
- qcflag: 0
ID: 4
Name: Private
Domains:
- Field Name: InstallContractor
Inherited
- Field Name: Inspector
Inherited
- Field Name: Source
Inherited
- Field Name: Diameter
Inherited
- Field Name: PipeMaterial
Inherited
- Field Name: MaterialLabel
Inherited
- Field Name: DownstreamDirection
Inherited
- Field Name: LastEditor
Inherited
- Field Name: OwnedBy
Inherited
Templates:
Name: Private
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- isvariable: 0
- activeflag: 1
- qcflag: 0
Name: Private (1)
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- isvariable: 0
- activeflag: 1
- qcflag: 0
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/22/2025 3:03:46 PM
Schema Last Edit Date: 7/22/2025 3:03:46 PM
Data Last Edit Date: 7/22/2025 3:03:46 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat