[OSM-dev] Simplified osm2pgsql database dump available

Paul Norman penorman at mac.com
Sun Jul 12 04:02:53 UTC 2015

To help with some OpenStreetMap carto development work, I've created a 
dump of the rendering tables with certain features removed, for testing 
at low zoom. This allows someone to load the database if using a machine 
incapable of importing the planet, and the dropped features cut the 
database size in half.

It is available at http://tile.paulnorman.ca/planet-lz-150202.dump, but 
before downloading please read the notes below

- Buildings without a name, amenity, shop, or similar tag have been removed

- Residential roads have been removed

- It comes with no indexes. To create the indexes, do

CREATE INDEX ON planet_osm_point USING GIST (way) WITH (fillfactor = 100);
CREATE INDEX ON planet_osm_line USING GIST (way) WITH (fillfactor = 100);
CREATE INDEX ON planet_osm_polygon USING GIST (way) WITH (fillfactor = 100);
CREATE INDEX ON planet_osm_roads USING GIST (way) WITH (fillfactor = 100);

- Don't try to download this from your browser, as it is 26GB

- I *will* be removing this dump from my server at some point.

- The dump has been generated with pg_dump from PostgreSQL 9.4 in the 
pg_dump "custom" format. To get 9.4 on Debian or Ubuntu based systems, 
see https://wiki.postgresql.org/wiki/Apt

- The dump is based on the planet dump from 150202 and is not current

- The database size is about 50GB after loading
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20150711/c277a9c7/attachment.html>

More information about the dev mailing list