Stuff

2 files changed, 1 insertions, 12 deletions

diff --git a/create-db.sql b/create-db.sql
deleted file mode 100644
index c8068c2..0000000
--- a/create-db.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-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) 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);
-
-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);
-
diff --git a/osm2pgsql.style b/osm2pgsql.style
index 164a3dd..6396689 100644
--- a/osm2pgsql.style
+++ b/osm2pgsql.style
@@ -45,6 +45,7 @@ node,way   boundary     text         linear
 node,way   building     text         polygon
 node,way   public_transport    text  polygon
 way        building:levels     text  polygon
+way        buildingpart text         polygon
 way        height       text         polygon
 node,way   bicycle_parking text      linear
 node       capital      text         linear