Data Dictionary

ID
Watermain Asset Identification
Type
text
Description

Identification number assigned by the City of Toronto

ID
Watermain Type
Type
text
Description

Distribution, Transmission, or Trans-Dist Connection

ID
Watermain Diameter
Type
int4
Description

Pipe diameter (millimetres)

ID
Watermain Material
Type
text
Description

Pipe material (AC - Asbestos Cement/Transite, CI - Cast Iron, CICL - Cast Iron Cement Lined, COP - Copper, CP - Concrete, DICL - Ductile Iron Cement Lined, DIP - Ductile Iron, HDPE - High Density Polyethylene, PE - Polyethylene, PVC - Polyvinyl Chloride, PVCO - Molecular Oriented Polyvinyl Chloride, SP - Steel, SPCL - Steel Pipe Cement Lined, UNK - Unknown/Other)

ID
Watermain Install Date
Type
timestamp
Description

Approximate construction date

ID
Watermain Construction Year
Type
int4
Description

Approximate construction year

ID
Watermain Measured Length
Type
float8
Description

Approximate span of the selected pipes (metres)

ID
Watermain Location Description
Type
text
Description

Address or location description

Additional Information

Field Value
Data last updated 2025 जुन 30
Metadata last updated 2026 फेब्रुअरी 24
Created 2025 जुन 30
Format GeoJSON
License License not specified
Datastore activeTrue
Datastore cache{'CSV': {'4326': '35b22f1c-6684-43ac-9101-0087f601d80b', '2952': '3c473a42-82a7-4a55-aea7-cfba1cde8fb5'}, 'SHP': {'4326': '52027067-5b7e-4991-ad32-163c2b402b98', '2952': '2a766cb6-4644-4a0d-a185-4c0ad4b681ff'}, 'GPKG': {'4326': '13374a86-c619-47b6-a9c8-4307abc8e86c', '2952': 'b5f2bcb6-d0fc-46f3-a7ba-2563369c6883'}, 'GEOJSON': {'4326': '172419f6-88b6-4cf8-bcc5-5a3aa860e1f8'}}
Datastore cache last update19 घण्टा पहिले
Extract jobAirflow: Integration Pipeline watermains
Has viewsTrue
Id7b685ae1-648c-4083-ab87-cb18ab66048b
Is previewTrue
Package id4e0989b8-57b9-4629-a5bd-cc672f537593
Position1
Record count46,531
Stateactive
Url typedatastore
Vertex count4,60,421
Extract Job Airflow: Integration Pipeline watermains
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. SHP
  3. GPKG
  4. GEOJSON
Datastore Cache Last Updated
Datastore resource's ID