AIFDR/risk_in_a_box — Issue #120: Create view for OSM PostGIS database
Author: uniomni
Created: 2012-03-02 01:39:54+00:00
State: open

The OSM building survey data is hosted (by way of mirroring) on an AIFDR server at 203.77.224.77, port 5432, username aifdr.

Create view:
drop view vw_planet_osm_polygon;
CREATE VIEW vw_planet_osm_polygon as select id, osm_id, "building:levels" as levels, "building:structure" as structure, way from planet_osm_polygon where building is not NULL;

Task, move this database to new more permanent server.