Keith, Did you edit the generate_xml.py script at all? You should not need to.
Also, there should be a file generated by generate_xml.py at 'inc/settings.xml.inc'. Can you open that and post at http://dpaste.com/ for us to take a look? Dane On Jul 27, 2011, at 2:24 PM, pz wrote: > Hi Dane, > > I'm still fighting with this, it has to be something small (I hope): > > [root@user mapnik]# export MAPNIK_DBNAME=osm && export MAPNIK_HOST=localhost > && ./generate_xml.py --dbname gis --host 'localhost' --user 'postgres' --port > '5432' --password 'postgres' > Include files written successfully! Pass the osm.xml file as an argument if > you want to serialize a new version or test reading the XML > > > [root@user mapnik]# > [root@user mapnik]# ./generate_image.py > > > PostGIS: SRID warning, using srid=-1 > Traceback (most recent call last): > > > File "./generate_image.py", line 37, in <module> > mapnik.load_map(m,mapfile) > > > RuntimeError: PSQL error: > ERROR: relation "_polygon" does not exist > > > LINE 4: from _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 _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 'landcover') > > > Thank you! > > -Keith > > > > On Jul 19, 2011, at 1:38 PM, Dane Springmeyer wrote: > >> >> On Jul 19, 2011, at 10:32 AM, pz wrote: >> >>> Martin, >>> >>> 'prefix':'planet_osm', # default osm2pgsql table prefix in generate_xml.py >>> >>> When I ran generate_xml.py originally it didn't generate a new osm.xml >>> >>> Is it possible this is causing issues with tile generation? >> >> No, all generate_xml.py primarily does is help author a few files inside of >> inc/. The script is poorly named, which is my fault. It should be called >> 'setup_xml.py' or something like that. >> >> The idea is that you don't have to touch osm.xml at all, and the only files >> that need editing are in inc/. See the README for more details. >> >>> >>> Thanks, >>> >>> -Keith >>> >>> >>> >>> On Jul 19, 2011, at 12:01 PM, M∡rtin Koppenhoefer wrote: >>> >>>> 2011/7/19 pz <[email protected]>: >>>>> ERROR: relation "_polygon" does not exist >>>>> LINE 4: from _polygon >>>>> Sorting data and creating indexes for planet_osm_polygon >>>> >>>> >>>> looks as if you have to set the prefix in your generate tiles.py to >>>> the same as you used in your database import: "planet_osm" >>>> >>>> cheers, >>>> Martin >>>> >>> >>> _______________________________________________ >>> 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
