Ahh.. I had done this previously because the machine couldn't handle the full planet_osm so I only imported USA only.
/usr/local/bin/osm2pgsql --slim -S /usr/local/share/osm2pgsql/default.style -d gis -C 2048 ./usa.osm.bz2 On Jul 28, 2011, at 2:12 PM, Dane Springmeyer wrote: > 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
