Data Dictionary

ID
Trunk Sewer Asset Identification
Typ
text
Opis

Identification number assigned by the City of Toronto

ID
Trunk Sewer Install Date
Typ
text
Opis

Identification number assigned by the City of Toronto

ID
Trunk Sewer Material
Typ
text
Opis

Identification number assigned by the City of Toronto

ID
Trunk Sewer Diameter
Typ
int4
Opis

Identification number assigned by the City of Toronto

ID
Trunk Sewer Main Shape
Typ
text
Opis

Identification number assigned by the City of Toronto

ID
Trunk Sewer Upstream Maintenance Hole
Typ
text
Opis

Identification number of upstream maintenance hole

ID
Trunk Sewer Downstream Maintenance Hole
Typ
text
Opis

Identification number of downstream maintenance hole

ID
Trunk Sewer Owned By
Typ
text
Opis

Ownership group of the gravity sewer

ID
Trunk Sewer Maintained By
Typ
text
Opis

Maintenance group of the gravity sewer

ID
Trunk Sewer Structure Type
Typ
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
Typ
text
Opis

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

ID
Trunk Sewer Name
Typ
text
Opis

Identification name assigned by the City of Toronto

ID
Trunk Sewer Measured Length
Typ
float8
Opis

Approximate span of the selected pipes (metres)

ID
Trunk Sewer Location Description
Typ
text
Opis

Address or location description

ID
Trunk Sewer
Typ
text
Opis

Yes or No label denoting a Trunk Sewer

ID
Trunk Sewer Twin Number
Typ
int4
Opis

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

Dodatkowe informacje

Pole Wartość
Data last updated 30 czerwca 2025
Metadata last updated 23 lutego 2026
Created 30 czerwca 2025
Format GeoJSON
Licencja 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 update8 godzin temu
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 616
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