BNA-EU: Advances of my master thesis for the Erasmus Mundus Masters of Geospatial Technologies
Advances of my master thesis for the Erasmus Mundus Masters in Geospatial Technologies.
The final document is here. The final presentation is here
Validating a bike network analysis score based on open data as a connectivity measure of urban cycling infrastructure adapted for European cities.
Reproduce the BNA score developed by People for Bikes, validate it and adapt it to compute bike network connectivity in European cities.
My thesis proposal can be accessed here. Keep in mind, it will be constantly updated.
BNA score translated into R and SQL, to be applied in European cities.
A series of scripts that come together into an R-Markdown report to calculate the BNA score for cities in the UK (England and Wales) and the Netherlands.
osm2pgsql
and osm2pgrouting
are also installed.test
should be created on the public schema
FULL VACUUM/ANALYZE
frequently on the database to improve performanceosm2pgsql
and osm2pgrouting
%APPDATA%/postgresql/pgpass.conf
with the format hostname:port:database:username:password
The BNA score bases its methodology on OSM data, however job and population data is accessed from other open data sources. Particularly for this project, this datasets were used:
Europe:
UK (England and Wales)
The Netherlands
England | ... | ... | The Netherlands | Wales |
---|---|---|---|---|
Cambridge | Bath | Corby | Venlo | Bridgend |
York | Canterbury | Blackpool | Delft | Newport |
Oxford | Carlisle | Colchester | Groningen | Swansea |
Cheltenham | Crawley | Exelter | Breda | |
Chesterfield | Plymouth | Warrington | Zwolle | |
Worcester | Gloucester | Hastings | Gouda | |
Maidstone | Hereford | Ipswich | Apeldoorn | |
Lincoln | Luton | Norwich | Enschede | |
Chelmsford | Slough | Nijmegen | ||
Bedford | Lancaster | Utrecht |