Data Dictionary

ID
Trunk Sewer Asset Identification
Type
text
Opis

Identification number assigned by the City of Toronto

ID
Trunk Sewer Install Date
Type
text
Opis

Identification number assigned by the City of Toronto

ID
Trunk Sewer Material
Type
text
Opis

Identification number assigned by the City of Toronto

ID
Trunk Sewer Diameter
Type
int4
Opis

Identification number assigned by the City of Toronto

ID
Trunk Sewer Main Shape
Type
text
Opis

Identification number assigned by the City of Toronto

ID
Trunk Sewer Upstream Maintenance Hole
Type
text
Opis

Identification number of upstream maintenance hole

ID
Trunk Sewer Downstream Maintenance Hole
Type
text
Opis

Identification number of downstream maintenance hole

ID
Trunk Sewer Owned By
Type
text
Opis

Ownership group of the gravity sewer

ID
Trunk Sewer Maintained By
Type
text
Opis

Maintenance group of the gravity sewer

ID
Trunk Sewer Structure Type
Type
text
Opis

Sewer main structure type (SL - gravity, CRV - Curved Sewer Line, IS - Inverted Siphon, SP - Storage Pipe, OR - Orifice (Dummy Pipe), OVF Overflow, WR, Weir (Dummy Pipe), PF - Perforated Pipe (Infiltration Pipe), VSL - Vacuum Sewer Line, DP - Drop Pipe or Shaft)

ID
Trunk Sewer Water Type
Type
text
Opis

Type of medium flowing in sewer (e.g. storm, sanitary, combined storm and sanitary)

ID
Trunk Sewer Name
Type
text
Opis

Identification name assigned by the City of Toronto

ID
Trunk Sewer Measured Length
Type
float8
Opis

Approximate span of the selected pipes (metres)

ID
Trunk Sewer Location Description
Type
text
Opis

Address or location description

ID
Trunk Sewer
Type
text
Opis

Yes or No label denoting a Trunk Sewer

ID
Trunk Sewer Twin Number
Type
int4
Opis

Distinguishes pipes that have the same upstream and downstream maintenance holes.

Dodаtne informаcije

Polje Vrijednost
Data last updated 30. lipnja 2025.
Metadata last updated 21. veljače 2026.
Kreirаno 30. lipnja 2025.
Formаt GeoJSON
Licencа License not specified
Datastore activeTrue
Datastore cache{'CSV': {'4326': '726c6642-ed34-411e-b24b-be4b01db90ea', '2952': '634724f0-818e-4e48-976f-09fe9a3d1266'}, 'SHP': {'4326': '718fc3d1-624a-4e39-8d65-6de748aa7e09', '2952': '9061bd3a-089d-42f1-88f0-5eb2a6369552'}, 'GPKG': {'4326': '804aef88-c695-49b8-ad8f-1621ce8e6727', '2952': '45c824e9-dde6-4dea-9264-2a5ff83368f1'}, 'GEOJSON': {'4326': '5d72c772-b127-4410-b4c5-c8ae977756e0'}}
Datastore cache last updateprije 6 sati
Extract jobAirflow: Integration Pipeline sewer-gravity-mains
Has viewsTrue
Id6dc32e1c-6fdb-491d-88a7-96e10ba208bf
Is previewTrue
Package id71a2da32-2a26-4343-bcaf-8ca63a696060
Position1
Record count3.198
Stateactive
Url typedatastore
Vertex count15.612
Extract Job Airflow: Integration Pipeline sewer-gravity-mains
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. SHP
  3. GPKG
  4. GEOJSON
Datastore Cache Last Updated
Datastore resource's ID