This repository contains scripts and data for the ODM data dive.
Open Data Manchester have been scraping data on Greater Manchester's SCOOT (Split Cycle Offset Optimisation Technique) loop system from the TfGM developer portal.
-
You can download the database as a .bacpac file here.
-
Sam has queried the db for some sample scoot data available in csv files, which you can find here.
-
cleaned_scoots.csvis the above data merged, cleaned, and with loop information added. -
Cleaning_scoots.Rcontains the code for automating merging, cleaning, and adding loop info used to generatecleaned_scoots.csv. I t may be usefull if you want to query the db yourself. -
loop_info.csvcontains information on the location and ID of each loop, you can also find usefull diagrams as pdf files here -
Creating Shapefiles.Rcontains code for creating shapefiles from the loop info. -
scoot_linestringcontains shapefiles for all the SCOOT loops in Greater Manchester, represented as linestrings. -
loop_map.htmlis an interactive map of the SCOOT network.
Data collected:
Scoot name, Description, Time, Congestion percentage, Current flow, Average speed, Link travel time, Start latitude, Start longitude, End latitude, End longitude