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
