On Sun, Jan 30, 2011 at 3:38 PM, Graham Jones <[email protected]> wrote: > Parveen, > It sounds as though either the osm2pgsql import did not work, or you > imported the data into a different database to the one mapnik is using (I > did that once and got very confused...). > I would check what is in your database with a few simple queries from the > command line. > Try: > psql -d gis <assuming gis is the database you used for the osm2pgsql > import> > \d > \d should list all the tables in the database - on my computer I get: > List of relations > Schema | Name | Type | Owner > --------+--------------------+----------+-------- > public | contours | table | graham > public | contours_gid_seq | sequence | graham > public | geometry_columns | table | graham > public | planet_osm_line | table | graham > public | planet_osm_nodes | table | graham > public | planet_osm_point | table | graham > public | planet_osm_polygon | table | graham > public | planet_osm_rels | table | graham > public | planet_osm_roads | table | graham > public | planet_osm_ways | table | graham > public | spatial_ref_sys | table | graham > (11 rows) Here I hot like this: gis=# \d List of relations Schema | Name | Type | Owner --------+------------------+-------+--------- public | geometry_columns | table | parveen public | spatial_ref_sys | table | parveen (2 rows)
> (but you will not have the contours ones). > If you do not have something like this, then osm2pgsql has failed - I would I have installed osm2pgsql using some files of previous 3.0.0 version after compilation > try the import again with a very small area - just download a bit of a local > town and import that so it is quicker than a whole country - and look out > for any errors. I also have tried to that but it has only imported country's file instead of small area then error was like this: Going over pending ways processing way (0k)*** glibc detected *** ./osm2pgsql: double free or corruption (out): 0x00007fffed43dd70 *** ======= Backtrace: ========= /lib/libc.so.6(+0x775b6)[0x7fe3a0cbd5b6] /lib/libc.so.6(cfree+0x73)[0x7fe3a0cc3e83] /usr/lib/libgeos-3.1.0.so(_ZNK4geos4geom7Polygon8apply_roEPNS0_23GeometryComponentFilterE+0x1c)[0x7fe3a1c5fa9c] ./osm2pgsql[0x40551e] ./osm2pgsql[0x40a22e] ./osm2pgsql[0x40d9f1] ./osm2pgsql[0x40817d] ./osm2pgsql[0x4104d5] /lib/libc.so.6(__libc_start_main+0xfd)[0x7fe3a0c64c4d] ./osm2pgsql[0x404309] ======= Memory map: ======== 00400000-00420000 r-xp 00000000 08:01 8526402 /home/parveen/bin/osm2pgsql/osm2pgsql > If the tables do exist you can do some simple queries like: > select osm_id,name from planet_osm_polygon where leisure='playground'; > to see if the data looks reasonable. It has not worked, may be you are right osm2pgsql installation is not correct. -- With Kind Regards Parveen Arora _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
