20200521
11295700
1.0
FALSE
ssMains
002
-119400400.000000
875222.125768
-97309100.000000
532401.388784
1
-
ssMains2ssMainJetting
Relationship
Projected
GCS_North_American_1983_HARN
Linear Unit: Foot_US (0.304801)
NAD_1983_HARN_WISCRS_Dane_County_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.6'><WKT>PROJCS["NAD_1983_HARN_WISCRS_Dane_County_Feet",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",811000.0],PARAMETER["False_Northing",480943.886],PARAMETER["Central_Meridian",-89.42222222222223],PARAMETER["Standard_Parallel_1",43.0695160375],PARAMETER["Scale_Factor",1.0000384786],PARAMETER["Latitude_Of_Origin",43.0695160375],UNIT["Foot_US",0.3048006096012192],AUTHORITY["Esri",103412]]</WKT><XOrigin>-119400400</XOrigin><YOrigin>-97309100</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>103412</WKID><LatestWKID>103412</LatestWKID></ProjectedCoordinateSystem>
20210114
08464100
20250630
15083600
50000
5000
ItemDescription
Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9270
Wastewater Mains
1
-180.000000
180.000000
43.210689
-67.943792
The purpose of this feature class - this asset management feature class, Wastewater Main, is designed to allow for inspections, maintenance, and potentially work order/revenue processes. This is completed via staff involvement at all levels of our organization.
Attribution includes - Facility ID, Active Flag, Install Date, Retire Date, Last Editor, Last Update, Owned By, Maintained By, Location Desc, Material, Diameter, Lined Date, From MH, To MH, Up Elev, Street Name, Slope, Pipe Drop, Drop MH, Main Type, Label, Up Depth, Down Depth, Asbuilt, Subdivision, Contractor, Source, create_user, created_date, last_edited_user, last_edited_date, Global ID
Schedule – updates are made on a as needed basis, but a general yearly cycle is followed.
Wastewater Mains
Wastewater
Sanitary Sewer
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>A wastewater main, also known as a sewer main or main sewer line, is a large underground pipe that collects and transports wastewater (sewage) from multiple sources, like individual homes or buildings, to a wastewater treatment plant. It acts as a central "highway" in a network of smaller pipes (laterals) that carry wastewater from individual properties. </SPAN></P></DIV></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>The burden for determining 'fitness for use' rests entirely upon the requester. The City of Sun Prairie will not be liable in any way for accuracy of the data or for uses other than intended. The City of Sun Prairie assumes no responsibility whatsoever for direct, indirect, special, consequential, exemplary or other damages. This information is intended for cartographic use, general spatial analysis and as a spatial index to land related information. It is not intended for site specific analysis.</SPAN></P></DIV></DIV></DIV>
Feature Class
dataset
Esri
9.2.0
3353
Simple
FALSE
3353
TRUE
FALSE
ssMains
Feature Class
3353
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
FacilityID
Facility ID
String
20
0
0
ActiveFlag
Active Flag
SmallInteger
2
5
0
InstallDate
Install Date
Date
8
0
0
RetireDate
Retire Date
Date
8
0
0
LastEditor
Last Editor
String
50
0
0
LastUpdate
Last Update
Date
8
0
0
OwnedBy
Owned By
SmallInteger
2
5
0
MaintBy
Maint By
SmallInteger
2
5
0
LocDesc
Location Desc
String
50
0
0
Material
Material
String
50
0
0
Diameter
Diameter
Double
8
20
4
LinedDate
Lined Date
Date
8
0
0
FromMH
From MH
String
50
0
0
ToMH
To MH
String
50
0
0
UpElev
Up Elev
Double
8
20
4
DwnElev
Dwn Elev
Double
8
20
4
StreetName
Street Name
String
50
0
0
Slope
Slope
Double
8
20
4
Length
Length
Double
8
20
4
PipeDrop
Pipe Drop
String
50
0
0
DropMH
Drop MH
String
50
0
0
MainType
Main Type
String
50
0
0
Label
Label
String
50
0
0
UpDepth
Up Depth
Double
8
20
4
DownDepth
Down Depth
Double
8
20
4
Asbuilt
Asbuilt
String
30
0
0
Subdivision
Subdivision
String
30
0
0
Contractor
Contractor
String
30
0
0
Source
Source
String
30
0
0
Flag_SpatialChange
Flag_SpatialChange
String
50
0
0
Flag_GeneralNotes
Flag_GeneralNotes
String
255
0
0
Flag_UpStreamIE_Source
Flag_UpStreamIE_Source
String
50
0
0
Flag_DownStreamIE_Source
Flag_DownStreamIE_Source
String
50
0
0
Added_UpDepth_LastFieldWork
Added_UpDepth_LastFieldWork
String
5
0
0
Added_DownDepth_LastFieldWork
Added_DownDepth_LastFieldWork
String
5
0
0
SHAPE
SHAPE
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
LineContractor
Line Contractor
String
50
0
0
Vacuumed
Vacuumed
String
4
0
0
MainJetStatus
Jetting Status
String
10
0
0
YearCleaned
Year Cleaned
String
4
0
0
SHAPE.STLength()
SHAPE.STLength()
Double
0
0
0
20250630