Hi Dane, I haven't edited generate_xml.py
Here is the post: http://dpaste.com/580814/ Thanks for all your help! -Keith On Jul 28, 2011, at 1:49 PM, Dane Springmeyer wrote: > 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
