[OSM-dev] Updated simplified osm2pgsql database dump available

Paul Norman penorman at mac.com
Tue May 24 19:50:53 UTC 2016


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-160425.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

- Don't try to download this from your browser, as it is 26GB. If you 
need to check the download, the md5sum is 5c771789b0820b4f7c4f705156633c7f

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

- The indexes at 
https://github.com/gravitystorm/openstreetmap-carto/blob/master/indexes.sql 
have been added, except with a fillfactor of 100.

- The database is 78GB after loading and index creation. Data only is 56GB.

To restore, do

createdb gis
psql -d gis -c 'create extension postgis;'
pg_restore -d gis -O -j4 planet-lz-160425.dum



More information about the dev mailing list