[OSM-dev] Populating the database

[Diarmuid Wrenne]

Hi,

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 have modified the original big osm.xml to reflect the database setup.


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

    <StyleName>text</StyleName>

    <Datasource>

      <Parameter name="type">postgis</Parameter>

      <Parameter name="host">localhost</Parameter>

      <Parameter name="port">5433</Parameter>     

      <Parameter name="user">apache</Parameter>

      <Parameter name="dbname">gis</Parameter>

      <Parameter name="table">planet_osm_point</Parameter>

      <Parameter name="estimate_extent">true</Parameter>

    </Datasource>

  </Layer>

I am  running /mnt/svn.openstreetmap.org/applications/utils/export/osm2pgsql/osm2pgsql -c -v /mnt/spatialdata/france.osm and getting


Using projection SRS 3395 (WGS84 Mercator)
Setting up table: planet_osm_point
Setting up table: planet_osm_line
Setting up table: planet_osm_polygon
Setting up table: planet_osm_roads

Reading in file: /mnt/spatialdata/france.osm
Processing: Node(1012k) Way(97k) Relation(0k)
Writing rel(0k)

Writing way(8k)

Node stats: total(1012818), max(157452867)
Way stats: total(97612), max(15739751)
Relation stats: total(97), max(3506)

 echo 'select count(*) from planet_osm_point;' | psql gis
 count
-------
 20753
(1 row)

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

Any ideas

Cheers





      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20071210/1fc12d96/attachment.html>