k, the problem is that <!ENTITY prefix ""> is an empty string. edit that directly to what it should be (which is usually "planet_osm"), but it depends on whether you used a custom prefix with your osm2pgsql import.
Dane On Jul 28, 2011, at 11:03 AM, pz wrote: > 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
