<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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.<br>
<br>
It is available at <a class="moz-txt-link-freetext" href="http://tile.paulnorman.ca/planet-lz-150202.dump">http://tile.paulnorman.ca/planet-lz-150202.dump</a>,
but before downloading please read the notes below<br>
<br>
- Buildings without a name, amenity, shop, or similar tag have been
removed<br>
<br>
- Residential roads have been removed<br>
<br>
- It comes with no indexes. To create the indexes, do<br>
<br>
CREATE INDEX ON planet_osm_point USING GIST (way) WITH (fillfactor =
100);<br>
CREATE INDEX ON planet_osm_line USING GIST (way) WITH (fillfactor =
100);<br>
CREATE INDEX ON planet_osm_polygon USING GIST (way) WITH (fillfactor
= 100);<br>
CREATE INDEX ON planet_osm_roads USING GIST (way) WITH (fillfactor =
100);<br>
<br>
- Don't try to download this from your browser, as it is 26GB<br>
<br>
- I <b>will</b> be removing this dump from my server at some point.<br>
<br>
- 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 <a class="moz-txt-link-freetext" href="https://wiki.postgresql.org/wiki/Apt">https://wiki.postgresql.org/wiki/Apt</a><br>
<br>
- The dump is based on the planet dump from 150202 and is not
current<br>
<br>
- The database size is about 50GB after loading<br>
</body>
</html>