Files
osm-search/database/views.sql
2023-06-13 13:53:20 +02:00

6 lines
206 B
SQL

CREATE VIEW planet_osm AS
SELECT "osm_id", "tags", "way" FROM planet_osm_point
UNION ALL
SELECT "osm_id", "tags", "way" FROM planet_osm_line
UNION ALL
SELECT "osm_id", "tags", "way" FROM planet_osm_polygon;