<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt">Hi,<br><br><span>I am having problems populating the database. I have downloaded the data from <a target="_blank" href="http://download.geofabrik.de/osm/europe/">http://download.geofabrik.de/osm/europe/</a> and extracted it. I have created a postgresql database and created the schema as per <a target="_blank" href="http://www.passback.org.uk/maps/fedora.shtml">http://www.passback.org.uk/maps/fedora.shtml</a></span><br><br>I have modified the original big osm.xml to reflect the database setup.<br><br>
<Layer name="text" status="on" srs="+proj=merc +datum=WGS84 +k=1.0 +units=m +over +no_defs"><br>
<StyleName>text</StyleName><br>
<Datasource><br>
<Parameter name="type">postgis</Parameter><br>
<Parameter name="host">localhost</Parameter><br>
<Parameter name="port">5433</Parameter> <br>
<Parameter name="user">apache</Parameter><br>
<Parameter name="dbname">gis</Parameter><br>
<Parameter name="table">planet_osm_point</Parameter><br>
<Parameter name="estimate_extent">true</Parameter><br>
</Datasource><br>
</Layer><br><br>I am running /mnt/svn.openstreetmap.org/applications/utils/export/osm2pgsql/osm2pgsql -c -v /mnt/spatialdata/france.osm and getting<br><br><br>Using projection SRS 3395 (WGS84 Mercator)<br>Setting up table: planet_osm_point<br>Setting up table: planet_osm_line<br>Setting up table: planet_osm_polygon<br>Setting up table: planet_osm_roads<br><br>Reading in file: /mnt/spatialdata/france.osm<br>Processing: Node(1012k) Way(97k) Relation(0k)<br>Writing rel(0k)<br><br>Writing way(8k)<br><br>Node stats: total(1012818), max(157452867)<br>Way stats: total(97612), max(15739751)<br>Relation stats: total(97), max(3506)<br><br> echo 'select count(*) from planet_osm_point;' | psql gis<br> count<br>-------<br> 20753<br>(1 row)<br><br>However when I run Generate_tiles.py I get no road data. <br><br>Any ideas<br><br>Cheers<br><br><br></div><br>
<hr size=1>Never miss a thing. <a href="http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs"> Make Yahoo your homepage.</a>
</body></html>