20240601
15291800
1.0
FALSE
SewerPipeline
002
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
NAD_1983_UTM_Zone_17N
<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/3.4.0'><WKT>PROJCS["NAD_1983_UTM_Zone_17N",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-81.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",26917]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>-9998100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>26917</WKID><LatestWKID>26917</LatestWKID></ProjectedCoordinateSystem>
20250205
08184700
20250205
08184700
50000
5000
ItemDescription
SanitarySewer
Polyline feature defining the sewer pipeline locations, in addition to their attributes, throughout the City of Windsor. Forms the City's sewer network when used along the SewerAssetPoint feature class.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Services: SewerInfrastructure and MappMyCity </SPAN></P><P><SPAN>Scripts: sewer_update.py Notes: The inventory of sewer pipelines with their location information is maintained by IMS in the Hansen database. The polyline features for the locations of pipelines are maintained by the CAD staff in the Geomatics department in an AutoCAD drawing. The GIS team then converts this AutoCAD drawing to a feature layer in their SDE so it can be used in a published web service. This layer is updated upon request by Geomatics using a python script that combines the CAD geometry with attributes from Hansen. </SPAN></P><P><SPAN>Queries can be conducted on the SEWER_TYPE to select the relevant sewer access type such as SANITARY (SEWER_TYPE)</SPAN></P><P><SPAN>Primary key: COMPKEY</SPAN></P><P><SPAN>Foreign key: COMPKEY</SPAN></P></DIV></DIV></DIV>
Owned by: Hansen
Managed by: Operations - IMS
Esri ArcGIS 13.4.0.55405
sewer
utilities
cow
sewer atlas
IMS
Hansen
CAD
polyline
script
File Geodatabase Feature Class
dataset
EPSG
6.11(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
SewerPipeline
Feature Class
0
OBJECTID
FID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
LAYER
Original CAD Layer
String
254
0
0
NOTES
Additional Notes
String
254
0
0
CompKey
Compkey
Integer
4
0
0
UPSTREAM_MH
Upstream Manhole ID
String
254
0
0
DWNSTREAM_MH
Downstream Manhole ID
String
254
0
0
PIPE_NUM
Pipe Number
Integer
4
0
0
SEWER_TYPE
Sewer Type
String
254
0
0
PIPE_TYPE
Pipe Type
String
254
0
0
IMS_DRAIN
IMS Drainage Area
String
254
0
0
PIPE_SIZE
Pipe Size
Integer
4
0
0
PIPE_SHAPE
Pipe Shape
String
254
0
0
PIPE_LENGTH
Pipe Length
Double
8
0
0
PIPE_HGT
Pipe Height
Integer
4
0
0
UPSTREAM_EL
Upstream Elevation
Double
8
0
0
DWNSTREAM_EL
Downstream Elevation
Double
8
0
0
Slope
Slope
Double
8
0
0
SERV_STAT
Service Status
String
254
0
0
INSTALL_D
Installation Date
Date
8
0
0
ACTUAL_D
Actual Date
String
254
0
0
ST_ID
Street ID
Integer
4
0
0
ST_NAME
Street Name
String
254
0
0
Seg_ID
Segment ID
Integer
4
0
0
FROM_ST
From Street
String
254
0
0
TO_ST
To Street
String
254
0
0
PSR
PSR
String
254
0
0
GISID
GISID
String
254
0
0
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
GlobalID
GlobalID
GlobalID
38
0
0
DRAWING_NUM
Drawing Number
String
255
0
0
Shape_Length
Shape_Length
Double
8
0
0
Length of feature in internal units.
Esri
Positive real numbers that are automatically generated.
20250205