Data Dictionary

ID
Watermain Asset Identification
Typ
text
Opis

Identification number assigned by the City of Toronto

ID
Watermain Type
Typ
text
Opis

Distribution, Transmission, or Trans-Dist Connection

ID
Watermain Diameter
Typ
int4
Opis

Pipe diameter (millimetres)

ID
Watermain Material
Typ
text
Opis

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
Typ
timestamp
Opis

Approximate construction date

ID
Watermain Construction Year
Typ
int4
Opis

Approximate construction year

ID
Watermain Measured Length
Typ
float8
Opis

Approximate span of the selected pipes (metres)

ID
Watermain Location Description
Typ
text
Opis

Address or location description

Dodatkowe informacje

Pole Wartość
Data last updated 30 czerwca 2025
Metadata last updated 24 lutego 2026
Created 30 czerwca 2025
Format GeoJSON
Licencja 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 update2 godziny temu
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 count460 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