blob: 5ce386380414c09ea6f11f961fbe69f8fe4b8b38 [file] [log] [blame]
DROP VIEW IF EXISTS osm_linestring CASCADE;
CREATE VIEW osm_linestring AS
SELECT id, tags, geom
FROM osm_ways
LEFT JOIN osm_ways_member ON id = way_id
WHERE ST_GeometryType(osm_ways.geom) = 'ST_LineString'
AND tags != '{}'
AND way_id IS NULL;