From 5a3439f8a8026c62b04e4c74265ca79e80a13f78 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Thu, 29 Aug 2013 13:13:55 +0100 Subject: Also include buildings that are not on a site --- create-db.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/create-db.sql b/create-db.sql index 0177b34..c8068c2 100644 --- a/create-db.sql +++ b/create-db.sql @@ -2,7 +2,7 @@ drop table uni_site; create table uni_site as select way,name,loc_ref,uri,amenity,landuse from planet_osm_polygon where operator='University of Southampton' and building is null or osm_id=230335224; drop table uni_building; -create table uni_building as select way, coalesce("addr:housename", name, '') as name, coalesce(height::int, "building:levels"::int * 10, 10) as height, loc_ref, uri, case when coalesce("addr:housename", name, '')='' or "addr:housename"="addr:housenumber" then true else false end as minor from planet_osm_polygon where ST_Contains((select ST_Union(way) from uni_site), way) and building is not null order by z_order,way_area desc; +create table uni_building as select way, coalesce("addr:housename", name, '') as name, coalesce(height::int, "building:levels"::int * 10, 10) as height, loc_ref, uri, case when coalesce("addr:housename", name, '')='' or "addr:housename"="addr:housenumber" then true else false end as minor from planet_osm_polygon where (ST_Contains((select ST_Union(way) from uni_site), way) or operator='University of Southampton') and building is not null order by z_order,way_area desc; drop table uni_parking; create table uni_parking as select way,name,access,capacity,"capacity:disabled",fee from planet_osm_polygon where amenity='parking' and ST_Contains((select ST_Union(way) from uni_site), way); -- cgit v1.2.3