20260818
11273900
1.0
FALSE
win_sewer_gld
002
50000
5000
ItemDescription
20261013
11234900
20261013
11234900
Tabular representation of the business ready complete sewer pipeline asset data inventory managed primarily within Hansen and synchronized into the enterprise geodatabase for data analytics, web applications, data reporting and dashboards consumption.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This dataset represents business ready enterprise data. Tabular attributes are extracted from their respective primary Systems of Record (SoR), processed via automated data pipelines, and joined with authoritative spatial geometry. This layer is maintained as a read-only representation for downstream GIS applications, Power BI Dashboards, and business consumption:</SPAN></P><P><SPAN /></P><P><SPAN>System of Record (SoR): </SPAN></P><P><SPAN>Primary Authoritative System: Hansen</SPAN></P><P><SPAN>Authoritative Table/View Source: assetmanagement_storm.stm and assetmanagement_sewer.smn</SPAN></P><P><SPAN> </SPAN></P><P><SPAN>Data Lineage & Pipeline:</SPAN></P><P><SPAN>Mechanics: Automated python ETL pipelines extract tabular source records, enforce business rules and standards (Gold tier).</SPAN></P><P><SPAN>Geometry Capture: Attachable to authoritative municipal sewer pipeline polylines.</SPAN></P><P><SPAN> </SPAN></P><P><SPAN>Coordinate Reference Notes:</SPAN></P><P><SPAN>Native Database Projection: NAD 1983 UTM Zone 17N (EPSG: 26917).</SPAN></P><P><SPAN>Linear Units: Meters.</SPAN></P><P><SPAN /></P></DIV></DIV></DIV>
Data Steward / SoR Owner: Technical Support - IMS
GIS Infrastructure & ETL Maintenance: GIS Team
Sync Schedule: Daily
City of Windsor Sewer Pipeline Assets
ims
sewer
gold
hansen
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Data provided 'as is' for planning, display, and analytical purposes. Authoritative reportable or financial values are recommended to be cross-referenced directly within the primary System of Record.</SPAN></P></DIV></DIV></DIV>
Esri ArcGIS 13.7.0.1901
20261013
File Geodatabase Table
dataset
win_sewer_gld
Table
0
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
sewer_compkey
Sewer Compkey
Integer
4
0
0
street_compkey
Street Compkey
Integer
4
0
0
upstream_node_id
Upstream Node ID
String
50
0
0
downstream_node_id
Downstream Node ID
String
50
0
0
pipe_segment_reference
Pipe Segment Reference
String
30
0
0
pipe_diameter
Pipe Diameter
Single
4
0
0
pipe_height
Pipe Height
Single
4
0
0
pipe_length
Pipe Length
Single
4
0
0
pipe_count
Pipe Count
Integer
4
0
0
pipe_shape
Pipe Shape
String
255
0
0
pipe_type
Pipe Type
String
255
0
0
upstream_depth
Upstream Depth
Single
4
0
0
downstream_depth
Downstream Depth
Single
4
0
0
upstream_elevation
Upstream Elevation
Single
4
0
0
downstream_elevation
Downstream Elevation
Single
4
0
0
is_estimated_upstream_invert
Upstream Invert is Estimated
String
40
0
0
is_estimated_downstream_invert
Downstream Invert is Estimated
String
40
0
0
slope
Slope
Single
4
0
0
upstream_flow_direction
Upstream Flow Direction
String
255
0
0
downstream_flow_direction
Downstream Flow Direction
String
255
0
0
sewer_location
Sewer Location
String
255
0
0
sewer_type
Sewer Type
String
255
0
0
service_status
Service Status
String
255
0
0
condition_rating
Condition Rating
String
255
0
0
sewer_atlas_number
Sewer Atlas Number
String
15
0
0
drawing_number
Drawing Number
String
15
0
0
assumption_bylaw
Assumption Bylaw
String
255
0
0
political_ward
Political Ward
String
255
0
0
additional_information
Additional Information
String
1000
0
0
created_date
Created Date
Date
8
0
0
constructed_date
Constructed Date
Date
8
0
0
service_status_date
Service Status Date
Date
8
0
0
is_actual_date
Is Actual Date
String
255
0
0
last_edited_date
Last Edited Date
Date
8
0
0