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
date
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 Hunyo 30, 2025
Metadata last updated Pebrero 25, 2026
Created Hunyo 30, 2025
Format GeoJSON
License License not specified
Datastore activeTrue
Datastore cache{'CSV': {'4326': 'd9d97d68-72e8-4774-ace2-026da37e8da8', '2952': '2d03558b-ac2a-41a4-9b7d-ff132a61ef8e'}, 'SHP': {'4326': 'f6426937-f4d2-4795-9644-c5fa7c6d9a1f', '2952': 'f1cdb617-6c75-4052-8845-54bbfcf2e31d'}, 'GPKG': {'4326': 'bd046722-39e4-4f34-9a08-b3beceb88375', '2952': '52d79cfd-e065-4fba-9cfe-7fae9aca1d20'}, 'GEOJSON': {'4326': 'fefc080e-db94-4b0e-8231-818805fc6157'}}
Datastore cache last update12 oras ang nakalipas
Extract jobAirflow: Integration Pipeline watermains
Has viewsTrue
Idb82cb7f4-1fe0-401f-861c-bb05126cdc86
Is previewTrue
Package id4e0989b8-57b9-4629-a5bd-cc672f537593
Position0
Record count2,490
Stateactive
Url typedatastore
Vertex count19,843
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