Dicionário de Dados

ID
Sewer Gravity Asset Identification
Tipo
text
Descrição

Identification number assigned by the City of Toronto

ID
Sewer Gravity Upstream Maintenance Hole
Tipo
text
Descrição

Identification number of upstream maintenance hole

ID
Sewer Gravity Downstream Maintenance Hole
Tipo
text
Descrição

Identification number of downstream maintenance hole

ID
Sewer Gravity Twin Number
Tipo
int4
Descrição

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

ID
Sewer Gravity Flow Type
Tipo
text
Descrição

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
Tipo
text
Descrição

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
Tipo
text
Descrição

Address or location description

ID
Sewer Gravity Owned By
Tipo
text
Descrição

Ownership group of the gravity sewer

ID
Sewer Gravity Managed By
Tipo
text
Descrição

Maintenance group of the gravity sewer

ID
Sewer Gravity Install Date
Tipo
timestamp
Descrição

Approximate construction date

ID
Sewer Gravity Diameter
Tipo
int4
Descrição

Pipe diameter (millimetres)

ID
Sewer Gravity Material
Tipo
text
Descrição

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
Tipo
text
Descrição

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

ID
Upstream Elevation
Tipo
text
Descrição

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

ID
Downstream Elevation
Tipo
text
Descrição

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

ID
Sewer Gravity Measured Length
Tipo
float8
Descrição

Approximate span of the selected pipes (metres)

ID
Sewer Gravity Trunk Sewer
Tipo
text
Descrição

Yes or No label denoting a Trunk Sewer

ID
Sewer Gravity Trunk Name
Tipo
text
Descrição

Identification name assigned by the City of Toronto

Informação adicional

Campo Valor
Data last updated 30 de junho de 2025
Metadata last updated 24 de fevereiro de 2026
Data de criação 30 de junho de 2025
Formato GeoJSON
Licença 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 updatehá 19 horas
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