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
