OpenStreetMap - Revision history

Jonasg: /* Download of OSM data */

2016-12-21T15:47:33Z

‎Download of OSM data

Jonasg at 15:47, 21 December 2016

2016-12-21T15:47:05Z

Jonasg: /* OSM in oedb */

2016-10-13T16:26:20Z

‎OSM in oedb

Jonasg: /* OSM in oedb */

2016-10-13T16:26:06Z

‎OSM in oedb

Jonasg: /* OSM in oedb */

2016-10-13T16:25:11Z

‎OSM in oedb

Jonasg: /* OSM in oedb */

2016-10-13T16:24:46Z

‎OSM in oedb

Jonasg: /* OSM in oedb */

2016-10-13T16:23:09Z

‎OSM in oedb

Jonasg: /* OSM in oedb */

2016-10-13T16:21:49Z

‎OSM in oedb

Jonasg: /* OSM in oedb */

2016-10-13T16:17:18Z

‎OSM in oedb

Jonasg: /* OSM in oedb */

2016-10-13T16:16:16Z

‎OSM in oedb

@@ Line 26: / Line 26: @@
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OR "highway" = 'motorway_link' OR&nbsp; "highway" = 'trunk_link' OR&nbsp; "highway" = 'primary_link'
   OR&nbsp; "highway" = 'secondary_link' OR&nbsp; "highway" = 'tertiary_link' OR&nbsp; "highway" = 'track'</pre>
@@ Line 31: / Line 32: @@
 = Download of OSM data =
-Small chunks off OSM data can be downloaded using QGIS. Under Vektor --> OpenstreetMap --> Daten herunterladen
+OSM data for whole regions is available under [http://download.geofabrik.de/ http://download.geofabrik.de/]
-−
-a .osm-file covering the current screen size can be downloaded.
-−
-−
-−
 OSM data for whole regions is available under http://download.geofabrik.de/

@@ Line 4: / Line 4: @@
 |Sources=https://en.wikipedia.org/wiki/OpenStreetMap, http://www.openstreetmap.org/
 }}
 == OSM in oedb<br/> ==
@@ Line 35: / Line 26: @@
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OR "highway" = 'motorway_link' OR&nbsp; "highway" = 'trunk_link' OR&nbsp; "highway" = 'primary_link'
   OR&nbsp; "highway" = 'secondary_link' OR&nbsp; "highway" = 'tertiary_link' OR&nbsp; "highway" = 'track'</pre>

@@ Line 4: / Line 4: @@
 |Sources=https://en.wikipedia.org/wiki/OpenStreetMap, http://www.openstreetmap.org/
 }}
@@ Line 26: / Line 27: @@
 When importing OSM data this way, the tables osm_deu_line and osm_deu_roads are created among others. Osm_deu_line contains every imported line object. Osm_deu_roads does NOT contain only roads, but is a subset of osm_deu_line, which in other applications can be used for simplified map visualisation at higher zoom levels. It is not suitable for data processing purposes because of incompleteness of the data.
-<br/>A subset of osm_deu_line which contains only roads can be created by using the highway-key as follows
+<br/>A subset of osm_deu_line which contains only roads can be created by using the highway-key as follows:
 [http://wiki.openstreetmap.org/wiki/Key:highway): http://wiki.openstreetmap.org/wiki/Key:highway]<br/><pre> SELECT * FROM openstreetmap.osm_deu_line

@@ Line 4: / Line 4: @@
 |Sources=https://en.wikipedia.org/wiki/OpenStreetMap, http://www.openstreetmap.org/
 }}
@@ Line 27: / Line 28: @@
 <br/>A subset of osm_deu_line which contains only roads can be created by using the highway-key as follows
-([http://wiki.openstreetmap.org/wiki/Key:highway): &nbsp http://wiki.openstreetmap.org/wiki/Key:highway):]<br/><pre> SELECT * FROM openstreetmap.osm_deu_line
+[http://wiki.openstreetmap.org/wiki/Key:highway): http://wiki.openstreetmap.org/wiki/Key:highway]<br/><pre> SELECT * FROM openstreetmap.osm_deu_line
   WHERE "highway" = 'motorway' OR "highway" = 'trunk' OR "highway" = 'primary' OR "highway" = 'secondary'
   OR "highway" = 'tertiary' OR&nbsp; "highway" = 'unclassified' OR "highway" = 'residential' OR "highway" = 'service'

@@ Line 4: / Line 4: @@
 |Sources=https://en.wikipedia.org/wiki/OpenStreetMap, http://www.openstreetmap.org/
 }}
@@ Line 26: / Line 27: @@
 <br/>A subset of osm_deu_line which contains only roads can be created by using the highway-key as follows
-(http://wiki.openstreetmap.org/wiki/Key:highway):&nbsp;&nbsp;<br/><pre> SELECT * FROM openstreetmap.osm_deu_line
+([http://wiki.openstreetmap.org/wiki/Key:highway): &nbsp http://wiki.openstreetmap.org/wiki/Key:highway):]<br/><pre> SELECT * FROM openstreetmap.osm_deu_line
   WHERE "highway" = 'motorway' OR "highway" = 'trunk' OR "highway" = 'primary' OR "highway" = 'secondary'
   OR "highway" = 'tertiary' OR&nbsp; "highway" = 'unclassified' OR "highway" = 'residential' OR "highway" = 'service'

@@ Line 4: / Line 4: @@
 |Sources=https://en.wikipedia.org/wiki/OpenStreetMap, http://www.openstreetmap.org/
 }}
@@ Line 21: / Line 22: @@
 When importing OSM data this way, the tables osm_deu_line and osm_deu_roads are created among others. Osm_deu_line contains every imported line object. Osm_deu_roads does NOT contain only roads, but is a subset of osm_deu_line, which in other applications can be used for simplified map visualisation at higher zoom levels. It is not suitable for data processing purposes because of incompleteness of the data.
-<br/>A subset of osm_deu_line which contains only roads can be created by using the highway-key as follows:
+<br/>A subset of osm_deu_line which contains only roads can be created by using the highway-key as follows:&nbsp;&nbsp; <br/>
-<pre> SELECT * FROM openstreetmap.osm_deu_line</pre>
-<pre>        WHERE "highway" = 'motorway' OR "highway" = 'trunk' OR "highway" = 'primary' OR "highway" = 'secondary' OR&nbsp; "highway" = 'tertiary'</pre>
+<br/>
-<pre>             OR&nbsp; "highway" = 'unclassified' OR "highway" = 'residential' OR "highway" = 'service' OR "highway" = 'living_street'
+<pre> SELECT * FROM openstreetmap.osm_deu_line
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OR&nbsp; "highway" = 'pedestrian' OR "highway" = 'bus_guideway' OR "highway" = 'road' &nbsp;
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OR&nbsp; "highway" = 'motorway_link' OR&nbsp; "highway" = 'trunk_link' OR&nbsp; "highway" = 'primary_link'
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OR&nbsp; "highway" = 'secondary_link' OR&nbsp; "highway" = 'tertiary_link' OR&nbsp; "highway" = 'track'
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OR&nbsp; "highway" = 'motorway_link' OR&nbsp; "highway" = 'motorway_link' OR&nbsp; "highway" = 'motorway_link' </pre>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </pre>