[OSM-dev] Populating the database

Martijn van Oosterhout kleptog at gmail.com
Mon Dec 10 21:37:12 GMT 2007


On Dec 10, 2007 9:38 PM, Diarmuid Wrenne <dwrenne at yahoo.com> wrote:
> I am having problems populating the database. I have downloaded the data
> from  http://download.geofabrik.de/osm/europe/   and extracted it. I have
> created a postgresql database and created the schema as per
> http://www.passback.org.uk/maps/fedora.shtml

I'm sure this is going to be a silly question but I'd like to be sure:

>    <Layer name="text" status="on" srs="+proj=merc +datum=WGS84  +k=1.0
> +units=m +over +no_defs">
<snip>
>        <Parameter name="table">planet_osm_point</Parameter>

This is the layer for points and further down you display:
>  echo 'select count(*) from planet_osm_point;' | psql gis
>  count
> -------
>  20753
> (1 row)

Again points. The roads are obviously in the planet_osm_roads table.
Did you define those other layers also?

> However when I run Generate_tiles.py I get no road data.

I generally find that generate_image is a better place to start. Enter
the bounds and generate a single image and view it. generate_tiles
tends to want to do the whole world and unless you've got a lot of
data, nothing's going to show up at the lower zoom levels...

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/




More information about the dev mailing list