A collection of tooling for building vector data and tiles of UK, US, IE, AU, CA and NZ cycle networks from OpenStreetMap data.
Install postgres, postgis, imposm, ogr2ogr and tippecanoe.
Run make
to spool through the build tasks and hopefully spit out routes.mbtiles
at the end of it.
Find cycleways that aren't part of cycle network route relations.
SELECT COUNT(*)
FROM osm_highways h
WHERE highway = 'cycleway'
OR (highway = 'footway' AND bicycle IS TRUE)
AND NOT EXISTS (
SELECT
FROM osm_route_members rm
WHERE rm.member = h.osm_id
)