-
Notifications
You must be signed in to change notification settings - Fork 50
/
motorways.pgsql
38 lines (29 loc) · 1.41 KB
/
motorways.pgsql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
SELECT DropGeometryColumn('', 'planet_osm_motorways', 'way_orig');
SELECT DropGeometryColumn('', 'planet_osm_motorways', 'way_zoom6');
SELECT DropGeometryColumn('', 'planet_osm_motorways', 'way_zoom7');
SELECT DropGeometryColumn('', 'planet_osm_motorways', 'way_zoom8');
SELECT DropGeometryColumn('', 'planet_osm_motorways', 'way_zoom9');
DROP TABLE "planet_osm_motorways";
BEGIN;
CREATE TABLE "planet_osm_motorways" (
osm_id INTEGER,
highway TEXT,
name TEXT,
ref TEXT,
route TEXT
);
SELECT AddGeometryColumn('', 'planet_osm_motorways', 'way_orig', '900913', 'LINESTRING', 2);
SELECT AddGeometryColumn('', 'planet_osm_motorways', 'way_zoom6', '900913', 'LINESTRING', 2);
SELECT AddGeometryColumn('', 'planet_osm_motorways', 'way_zoom7', '900913', 'LINESTRING', 2);
SELECT AddGeometryColumn('', 'planet_osm_motorways', 'way_zoom8', '900913', 'LINESTRING', 2);
SELECT AddGeometryColumn('', 'planet_osm_motorways', 'way_zoom9', '900913', 'LINESTRING', 2);
INSERT INTO "planet_osm_motorways"
SELECT osm_id, name, highway, ref, route,
way AS way_orig,
ST_Simplify(way, 20037508*2 / 2^(8 + 6)) AS way_zoom6,
ST_Simplify(way, 20037508*2 / 2^(8 + 7)) AS way_zoom7,
ST_Simplify(way, 20037508*2 / 2^(8 + 8)) AS way_zoom8,
ST_Simplify(way, 20037508*2 / 2^(8 + 9)) AS way_zoom9
FROM planet_osm_line
WHERE highway IN ('motorway', 'trunk');
COMMIT;