Thanks for the response. It's really the Mapnik piece that I'm trying to understand. I thought the NOTICE output was normal ( according to all the docs I could find ). My issue is that the ./generate_image.py script fails with:
>> ///, line 42, in <module> >> mapnik.load_map(m,mapfile) >> RuntimeError: PSQL error: >> ERROR: relation "planet_osm_polygon" does not exist >> LINE 4: from planet_osm_polygon and since there was apparently nothing that created that table, I'm at a loss for how that table would even get created. Or more to the point, where is the process failing? Greg On Oct 4, 2011, at 11:17 AM, Dane Springmeyer wrote: > Hi Gregory, > > The 'NOTICE' output you pasted below is standard output, nothing to worry > about. Generally if the tables are missing it means that the import failed > (e.g. if you ran out of memory). So you need to watch the very end of the > osm2pgsql output for clues. > > I would recommend trying to import a small extract first to confirm that > everything is working. On older ubuntu versions with packaged geos sometimes > tables can be empty. This does not appear to be your problem, but it would be > good to rule this out with a small extract first, before importing planet. > > Lastly, osm2pgsql questions are likely better ask in the future at > http://lists.openstreetmap.org/listinfo/dev since this list is targeted at > Mapnik rendering issues. > > Dane > > On Oct 4, 2011, at 10:56 AM, Gregory Mace wrote: > >> I've successfully imported the planet-latest file into postgres8.4 on ubuntu >> 10.04 and run into this error when trying to generate an image. When I look >> in the db, that table is not there. What I don't understand is that during >> the import it says: >> >> osm2pgsql import output: >> >> Setting up table: planet_osm_polygon >> NOTICE: table >> "planet_osm_polygon" >> does not exist, skipping >> NOTICE: table >> "planet_osm_polygon_tmp" does not exist, skipping >> >> but all the documentation for importing planet-latest indicates that this is >> normal. >> >> >> mapnik ./generate_image.py output >> >> ///, line 42, in <module> >> mapnik.load_map(m,mapfile) >> RuntimeError: PSQL error: >> ERROR: relation "planet_osm_polygon" does not exist >> LINE 4: from planet_osm_polygon >> ^ >> Full sql was: 'select * from >> (select >> way,aeroway,amenity,landuse,leisure,man_made,military,"natural",power,tourism,name,highway, >> case when religion in ('christian','jewish') then religion else >> 'INT-generic'::text end as religion >> from planet_osm_polygon >> where landuse is not null >> or leisure is not null >> or aeroway in ('apron','aerodrome') >> or amenity in >> ('parking','university','college','school','hospital','kindergarten','grave_yard') >> or military in ('barracks','danger_area') >> or "natural" in >> ('field','beach','desert','heath','mud','wood','sand','scrub') >> or power in ('station','sub_station','generator') >> or tourism in >> ('attraction','camp_site','caravan_site','picnic_site','zoo') >> or highway in ('services','rest_area') >> order by z_order,way_area desc >> ) as leisure >> limit 0' >> (encountered during parsing of layer 'land cover') >> >> is there some script that I have forgotten to run on the db ( before >> importing )? >> >> Thx >> >> >> >> _______________________________________________ >> Mapnik-users mailing list >> [email protected] >> https://lists.berlios.de/mailman/listinfo/mapnik-users > _______________________________________________ Mapnik-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/mapnik-users
