So I changed the prefix to: "planet_osm" after trying usa combinations and now
have this:
[root@ mapnik]# ./generate_image.py
proj_init_error:failed to initialize projection with:+init=epsg:4326
Thoughts?
Thanks!
-Keith
On Jul 28, 2011, at 2:19 PM, pz wrote:
> 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
_______________________________________________
Mapnik-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/mapnik-users
