Edmonton's Open Data Portal

Close
Author
opendata@edmonton.ca
Description
Replacement link: https://data.edmonton.ca/Transportation-Infrastructure/On-street-Construction-and-Maintenance-Map-View/rqp6-b9gy Dataset summarizes active On-Street Construction and Maintenance (OSCAM) permits issued for the temporary use of road space for construction and special event activities. The dataset is current for the date the data is extracted. It does not provide historical or future OSCAM permit dates. Data is broken into 4 categories: - Permits that are successfully translated and/or cross referenced to actual road segments - Permits that could not be cross referenced to actual road segements, but a good approximation could be drawn - Permits that are successfully translated to only a point on the roadway network - Permits that could not be translated or cross reference to any aspect of the road network
Category
Transportation Infrastructure
Tags
on-street construction, on-street maintenance, oscam
Rating
Current value: 0 out of 5
Data Provided By
City of Edmonton
License
See Terms of Use
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

File Number
file_number
Start Date
start_date
Finish Date
finish_date
Work Reason
work_reason
Street Full Name
street_full_name
Road Segment Intersections
road_segment_intersections
Intersecting Streets
intersecting_streets
Spatial Reference
spatial_reference
Peak Hour Restrictions
peak_hour_restrictions
Bike Facilities Affected
bike_facilities_affected
On Street Parking Affected
on_street_parking_affected
Pedestrian Affected
pedestrian_affected
Latitude
latitude
Longitude
longitude
Location
location
Roadway Maintenance Area Polygon
:@computed_region_ecxu_fw7u
Edmonton Public School Board (EPSB) Ward Boundaries (effective at 12:00 AM on Oct 16, 2017)
:@computed_region_izdr_ja4x
Edmonton Catholic School District Ward Boundaries (effective at 12:00 AM on Oct 16, 2017)
:@computed_region_5jki_au6x
City of Edmonton - Ward Boundaries (effective at 12:00 AM on Oct 16, 2017)
:@computed_region_mnf4_kaez
City of Edmonton : Neighbourhood Boundaries
:@computed_region_eq8d_jmrp

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.