Transmission Watermain
URL: https://ckan0.cf.opendata.inter.prod-toronto.ca/datastore/dump/a486806f-fec4-498e-8a6a-39d50169a60e
Dataset description:
This dataset provides pertinent information on the location of water system pipes, watermain type based on function, and pipe characteristics (e.g. diameter, material etc.). The data is...
Source: Watermains
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| Watermain Asset Identification | text | Identification number assigned by the City of Toronto |
|
| Watermain Type | text | Distribution, Transmission, or Trans-Dist Connection |
|
| Watermain Diameter | int4 | Pipe diameter (millimetres) |
|
| Watermain Material | text | 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) |
|
| Watermain Install Date | date | Approximate construction date |
|
| Watermain Construction Year | int4 | Approximate construction year |
|
| Watermain Measured Length | float8 | Approximate span of the selected pipes (metres) |
|
| Watermain Location Description | text | Address or location description |
|
| geometry | text |
Additional Information
| Field | Value |
|---|---|
| Data last updated | January 15, 2025 |
| Metadata last updated | May 5, 2025 |
| Created | January 15, 2025 |
| Format | GeoJSON |
| License | License not specified |
| Datastore active | True |
| Datastore cache | {'CSV': {'4326': '52e2f9fd-f4a1-4b23-97fe-d8c64cbd2fda', '2952': '220ff789-0de2-4ea5-b2fb-98effe7de239'}, 'SHP': {'4326': '16bbfe54-3b8d-4b5e-845a-edd96640861b', '2952': '402ac02f-6d67-4068-9eae-2c665d0e814b'}, 'GPKG': {'4326': '5b72ae08-a9c0-445d-b248-b67047ac845c', '2952': '84b3a11e-e0ae-4867-9af5-3c66e66919d7'}, 'GEOJSON': {'4326': 'd30e710e-8074-4031-8d85-bd4c9a352193'}} |
| Datastore cache last update | 4 days ago |
| Extract job | Airflow: Integration Pipeline watermains |
| Has views | True |
| Id | a486806f-fec4-498e-8a6a-39d50169a60e |
| Is preview | True |
| Package id | watermains |
| Position | 0 |
| State | active |
| Url type | datastore |
| Extract Job | Airflow: Integration Pipeline watermains |
| Is Datastore Cache File? | |
| Datastore Cache |
|
| Datastore Cache Last Updated | |
| Datastore resource's ID |