Datenverzeichnis

ID
Sewer Gravity Asset Identification
Typ
text
Beschreibung

Identification number assigned by the City of Toronto

ID
Sewer Gravity Upstream Maintenance Hole
Typ
text
Beschreibung

Identification number of upstream maintenance hole

ID
Sewer Gravity Downstream Maintenance Hole
Typ
text
Beschreibung

Identification number of downstream maintenance hole

ID
Sewer Gravity Twin Number
Typ
int4
Beschreibung

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

ID
Sewer Gravity Flow Type
Typ
text
Beschreibung

Type of medium flowing in the sewer (SAN - Sanitary, Storm - Stormwater, Combined - Combined, CSO - Combined Sewer Overflow, SCSO - Storm Plus CSO, EO - Emergency Overflow, FD - Foundation Drain)

ID
Sewer Gravity Structure Type
Typ
text
Beschreibung

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
Sewer Gravity Location Description
Typ
text
Beschreibung

Address or location description

ID
Sewer Gravity Owned By
Typ
text
Beschreibung

Ownership group of the gravity sewer

ID
Sewer Gravity Managed By
Typ
text
Beschreibung

Maintenance group of the gravity sewer

ID
Sewer Gravity Install Date
Typ
timestamp
Beschreibung

Approximate construction date

ID
Sewer Gravity Diameter
Typ
int4
Beschreibung

Pipe diameter (millimetres)

ID
Sewer Gravity Material
Typ
text
Beschreibung

Pipe material (AC- Asbestos Cement, BR- Brick, CAS -Cast Iron, CIPP - Cured-in-Place Pipe Lining, CMP - Corrugated Metal Pipe, CP - Concrete Pipe (non-reinforced), CSB - Concrete Segments (bolted), CSU - Concrete Segments (Unbolted), CT - Clay Tile, DIP - Ductile Iron Pipe, FRP - Fiberglass Reinforced Pipe, GRC - Glass Reinforced Cement, OB - Pitch Fiber (Tar Paper), PCCP - Pre-Stressed Concrete Cylinder Pipe, PE - Polyethylene, PP - Polypropylene, PSC - Plastic-Steel Composite, PVC - Polyvinyl Chloride, RPM - Reinforced Plastic Pipe (Truss Pipe), SB - Segmented Block, SP - Steel Pipe, TTE - Transite Pipe, VCP - Vitrified Clay Pipe, D - Wood, XXX - Unknown, ZZZ - Other)

ID
Sewer Gravity Main Shape
Typ
text
Beschreibung

Pipe cross-sectional shape (e.g. circular, egg etc.)

ID
Upstream Elevation
Typ
text
Beschreibung

The approximate elevation of the sewer at the upstream maintenance hole (metres)

ID
Downstream Elevation
Typ
text
Beschreibung

The approximate elevation of the sewer at the downstream maintenance hole (metres)

ID
Sewer Gravity Measured Length
Typ
float8
Beschreibung

Approximate span of the selected pipes (metres)

ID
Sewer Gravity Trunk Sewer
Typ
text
Beschreibung

Yes or No label denoting a Trunk Sewer

ID
Sewer Gravity Trunk Name
Typ
text
Beschreibung

Identification name assigned by the City of Toronto

Zusätzliche Informationen

Feld Wert
Daten wurden zuletzt aktualisiert 30. Juni 2025
Metadaten zuletzt aktualisiert 24. Februar 2026
Erstellt 30. Juni 2025
Format GeoJSON
Lizenz License not specified
Datastore activeTrue
Datastore cache{'CSV': {'4326': 'c47974cc-05a1-4547-924c-224305393c80', '2952': '99c89fd6-3a1d-4bb2-8bd8-4c90afa5e639'}, 'SHP': {'4326': '46652211-68d1-43ac-ab80-8f660fbc8cb2', '2952': '2a4cb31d-8078-4292-a5e5-4f685080629b'}, 'GPKG': {'4326': '2dc28550-4822-45ec-afb8-848ce13d52d4', '2952': 'bf42b6f4-a8af-4ce9-8e42-bd66dbac608f'}, 'GEOJSON': {'4326': 'c254cabb-fe88-43f8-811f-e32a9fa1a1bd'}}
Datastore cache last updatevor 2 Stunden
Extract jobAirflow: Integration Pipeline sewer-gravity-mains
Has viewsTrue
Idb774654a-d58d-47ec-95cb-2030c3621b1b
Is previewTrue
Package id71a2da32-2a26-4343-bcaf-8ca63a696060
Position0
Record count165.850
Stateactive
Url typedatastore
Vertex count459.718
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