[OSM-talk] Begginer question: Why road is not rendered in mapnik?

John3478 John3478 john3478 at gmail.com
Wed Jan 28 13:56:31 GMT 2009

Thanks for the feedback Chris,
1. I am successfully, query the table from postgres sql editor
2. I don't know what code/statement that I can use from python to verify
that I can query/grap the data from postgres database. (although, I do know
that if I change the table name in osm.xml, it will prompt error in postgres
sql log. And if, I put the correct table  name in osxm.xml, it will not
prompt error. So, seems like it is connecting. however, I am not sure if it
is grapping the data or not)

Would you mind give me a little code example, how to connect to database and
return the data? I want to verify if it is the problem in data not

Thanks so much

On Wed, Jan 28, 2009 at 12:20 AM, Chris Jones <rollercow at sucs.org> wrote:

> On 28 Jan 2009, at 00:26, John3478 John3478 wrote:
>  I am still stuck in rendering zoom level 8 to 16.
>> 1. From postgres sql log, I can see if I modify the table name in osm.xml,
>> it will prompt table not found. So, it seems like it able to connect to
>> database. but I am stuck why it is not able to render any data from
>> database. looks like its only get data from boundary.
>> -----also in the postgres log file
>> ------------------------------------------------------
>> %t LOG:  could not receive data from client: No connection could be made
>> because the target machine actively refused it.
>> %t LOG:  unexpected EOF on client connection
>> ------------------------------------------------------------------------------------------------
>> Do you guys know what is the problem? (it is in windows environment) (Iam
>> able to run demo from the shape file just fine)
>> - PostgreSQL 8.3 , postgis 1.3.5
>> - python 2.5
>> - mapnik 0.5.1
>> I try to figure it out, is it still the database problem not able to
>> return the data or it is the osm.xml stylesheet that I need to troubleshoot.
> Can you connect and grab data from the tables as the user your asking
> mapnik to use?
> --
> Chris Jones, SUCS Admin
> http://sucs.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20090128/765310a4/attachment.html>

More information about the talk mailing list