Differences

This shows you the differences between two versions of the page.

--- using_overlay_to_extract_data_from_openstreetmap [2022/01/13 20:10] – created abeverley
+++ using_overlay_to_extract_data_from_openstreetmap [2022/06/21 18:14] (current) – [Total length of segregated cycleways in Westminster] abeverley
@@ Line 1: / Line 1: @@
-===== Using Overlay to extract data from OpenStreetMap =====
+===== Using Overpass to extract data from OpenStreetMap =====
-I used the following Overlay files to measure the amount of cycle lanes in cities:
+I used the following [[https://overpass-turbo.eu/|Overpass]] files to measure the amount of cycle lanes in cities:
+==== Total length of highways in Westminster ====
+  [out:csv(number,length)];
+  {{geocodeArea:Westminster}}->.searchArea;
+  way["highway"]["highway"!="cycleway"]["highway"!="bridleway"]["highway"!="footway"]["highway"!="path"]["highway"!="service"]["access"!="private"](area.searchArea);
+  make stat number=count(ways),length=sum(length());
+  out;
+==== Total length of segregated cycleways in Westminster ====
+  [out:csv(number,length)];
+  {{geocodeArea:Westminster}}->.searchArea;
+  way["highway"="cycleway"]["foot"!="designated"](area.searchArea);
+  make stat number=count(ways),length=sum(length());
+  out;
+==== Total length of segregated cycleways in Camden ====
+  [out:csv(number,length)];
+  {{geocodeArea:London borough of Camden}}->.searchArea;
+  way["highway"="cycleway"](area.searchArea);
+  make stat number=count(ways),length=sum(length());
+  out;
+==== Show all segregated cycleways in Westminster on a map ====
+Click the zoom icon once generated
+  [out:json];
+  {{geocodeArea:Westminster}}->.searchArea;
+  (
+    way["highway"="cycleway"]["foot"!="designated"](area.searchArea);
+  );
+  out body;
+  >;
+  out skel qt;
+==== Show only roads in Westminster on a map ====
+  [out:json];
+  {{geocodeArea:Westminster}}->.searchArea;
+  (
+    way["highway"]["highway"!="cycleway"]["highway"!="bridleway"]["highway"!="footway"]["highway"!="path"]["highway"!="service"]["access"!="private"](area.searchArea);
+  );
+  out body;
+  >;
+  out skel qt;
+==== Show segregated cycle routes on current viewed map ====
+  [bbox:{{bbox}}];
+  (
+    way["highway"="cycleway"];
+  );
+  out geom;
+==== Other things I didn't write details for ====
   [out:csv(length,value)];
@@ Line 21: / Line 78: @@
     out;
   }
-  [bbox:{{bbox}}];
-  (
-    way["highway"="cycleway"];
-  );
-  out geom;
   [out:csv(length,value)];