From 0a5c3ccd31d2e38ce68719a4e8e3ca912737c73c Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Tue, 27 Aug 2013 11:42:58 +0100 Subject: Add db --- create-db.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 create-db.sql diff --git a/create-db.sql b/create-db.sql new file mode 100644 index 0000000..0177b34 --- /dev/null +++ b/create-db.sql @@ -0,0 +1,12 @@ +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; + +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); + +drop table uni_bicycle_parking; +create table uni_bicycle_parking as select way,capacity,bicycle_parking,covered from planet_osm_polygon where amenity='bicycle_parking' and ST_Contains((select ST_Union(way) from uni_site), way) union select way,capacity,bicycle_parking,covered from planet_osm_point where amenity='bicycle_parking' and ST_Contains((select ST_Union(way) from uni_site), way); + -- cgit v1.2.3