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

[John3478 John3478]

I think, I narrow down the problem. The original generate_tiles from this
links below does not generate roads. This very strange because openstreetmap
use similar script to generate road
http://svn.openstreetmap.org/applications/rendering/mapnik/generate_tiles.py

I try to change the code by adding one to the range, it now generate road
for the one level down. ""for y in
range(int(px0[1]/256.0),int(px1[1]/256.0)+2)".
but did not generate image after zoom level 12+

http://img502.imageshack.us/img502/7779/792kz0.png

Does any body have generate_tiles.py that also generate roads?

Thanks
___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk

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

[John3478 John3478]

OK, I try it in Ubuntu, it still the same, it failed to generate image after
zoom level 8+.
This time, I am back to windows again and start debugging the
generate_tiles.
>From the screenshot below, you can see it failed after zoom level 8+,
because there is no range in "for y in
range(int(px0[1]/256.0),int(px1[1]/256.0)+1)"
(generate_tiles.py
)
which is "range(99,99)". because there is no loop it will not execute the
statement inside the loop.
http://img206.imageshack.us/img206/5619/failedhb9.jpg
___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk

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

[John3478 John3478]

> > 4. Since there is no historic column, I removed historic and airways
> > Layer and its association from the osm.xml
>
> Perhaps the lack of images at zoom 8+ is due to other missing columns.
> You should get the latest default.style the link below and import the
> data again
>
>
> http://trac.openstreetmap.org/browser/applications/utils/export/osm2pgsql/default.style?format=raw
>
> After this you should have a database with the historic column and
> probably a few more as well.
>

Your are awesome Jon, this did resolved problem in importing tables. So, now
the table contain historic column. However, it still missing zoom 8+,
directory generated just no images. And no error in Postgres log files. So,
no way of knowing what is the error.

I think I might need to do it in Ubuntu instead and just forget about
windows.

---
render_tiles( (-122.52862930297852, 37.811275770361121, -122.34237670898437,
37.682190082863734) D:/lamp/mapnik/rendercode/osm-local.xml D:/lamp/mapni
k/output/ 1 16 San Francisco )
San Francisco [ 1 - 16 ]:  1 0 0 p: (-180.0, 0.0) (0.0, 85.051128779806604)
San Francisco [ 1 - 16 ]:  2 0 1 p: (-180.0, 0.0) (-90.0,
66.513260443111847)
San Francisco [ 1 - 16 ]:  3 1 3 p: (-135.0, 0.0) (-90.0,
40.979898069620127)
San Francisco [ 1 - 16 ]:  4 2 6 p: (-135.0, 21.94304553343818) (-112.5,
40.979898069620127)
San Francisco [ 1 - 16 ]:  5 5 12 p: (-123.75, 31.952162238024975) (-112.5,
40.979898069620127)
San Francisco [ 1 - 16 ]:  6 10 24 p: (-123.75, 36.597889133070218)
(-118.125, 40.979898069620127)
San Francisco [ 1 - 16 ]:  7 20 49 p: (-123.75, 36.597889133070218)
(-120.9375, 38.822590976177104)
___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk

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

[Jon Burgess]

On Wed, 2009-01-28 at 15:04 -0800, John3478 John3478 wrote:
>  
> 
> 
> 
> 
> If some zooms are working fine but others are not then
> it suggests that
> maybe you need to change more of the Postgis usernames
> & passwords in
> the osm.xml file. By my counting there are 29
> instances of DB username &
> password in the file.
> 
> You might find it easiest to start with the
> osm-template.xml file which
> has special tokens like DBPASS, DBUSER. Normally you'd
> run this through
> the customize-mapnik-map Perl script but I'm unsure
> how well this will
> work on Windows due to the use of environment
> variables. You could just
> use a search and replace in a text editor instead.
> 
>Jon
> 
> (somehow, my first email with attachment not working, I resend the
> email without attachment)
> Thanks so much for the feedback, any feedback will be useful for me,
> since I am just stuck no where to go. :). So, I will try anything. he
> he he.
> 
> Ok, here what I have tried (My environment is windows and I am using
> extracted cloudmate map. )
> 1. Here is the last zoom at 7
> http://img301.imageshack.us/my.php?image=10282803gm2.png
> Is this means the images get the data from database? or is it get the
> data from the boundary?

The blue and red lines are definitely coming from the database. At least
part of the rendering is working

> 2. From zoom lever 8 to 16, it did create directory including sub
> directory, however no images generated at all. 
> 
> 3. I did replace all in the databasource setting for database in
> osm.xml. (I attached the osm-local.xml. Yes, perl script is not
> running that well with environment in windows, so I manually replace
> them. 
> 
> 4. Since there is no historic column, I removed historic and airways
> Layer and its association from the osm.xml

Perhaps the lack of images at zoom 8+ is due to other missing columns.
You should get the latest default.style the link below and import the
data again

http://trac.openstreetmap.org/browser/applications/utils/export/osm2pgsql/default.style?format=raw

After this you should have a database with the historic column and
probably a few more as well.


> 5. The database coming from cloudmate map because I only wanted
> certain region only. I did try to import from latest planet osm but
> failed in the middle of import. I did have 120GB freespace and 2GB
> memory). 

A small extract is the best place to start. It is very frustrating to
waste a day re-importing the full planet data due to a minor error in
the import process.

> Thanks so much, I did halftway trying out in Ubuntu, I think windows
> give so much problems.  :)

I believe most of the OSM development work happens on top of Linux so
you'll have better luck with Ubuntu. There will probably be known
solutions for any problems you find.

Jon



___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk

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

[John3478 John3478]

>
> 
>>
>>
>>  
>> If some zooms are working fine but others are not then it suggests that
>> maybe you need to change more of the Postgis usernames & passwords in
>> the osm.xml file. By my counting there are 29 instances of DB username &
>> password in the file.
>>
>> You might find it easiest to start with the osm-template.xml file which
>> has special tokens like DBPASS, DBUSER. Normally you'd run this through
>> the customize-mapnik-map Perl script but I'm unsure how well this will
>> work on Windows due to the use of environment variables. You could just
>> use a search and replace in a text editor instead.
>>
>>Jon 
>
>
(somehow, my first email with attachment not working, I resend the email
without attachment)
Thanks so much for the feedback, any feedback will be useful for me, since I
am just stuck no where to go. :). So, I will try anything. he he he.

Ok, here what I have tried (My environment is windows and I am using
extracted cloudmate map. )
1. Here is the last zoom at 7
http://img301.imageshack.us/my.php?image=10282803gm2.png
*Is this means the images get the data from database? or is it get the data
from the boundary?*

2. From zoom lever 8 to 16, it did create directory including sub directory,
however no images generated at all.

3. I did replace all in the databasource setting for database in osm.xml. (I
attached the osm-local.xml. Yes, perl script is not running that well with
environment in windows, so I manually replace them.

4. Since there is no historic column, I removed historic and airways Layer
and its association from the osm.xml

5. The database coming from cloudmate map because I only wanted certain
region only. I did try to import from latest planet osm but failed in the
middle of import. I did have 120GB freespace and 2GB memory).

Thanks so much, I did halftway trying out in Ubuntu, I think windows give so
much problems.  :)

And thanks again for any feedback.
___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk

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

[Jon Burgess]

On Tue, 2009-01-27 at 16:26 -0800, 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.

If some zooms are working fine but others are not then it suggests that
maybe you need to change more of the Postgis usernames & passwords in
the osm.xml file. By my counting there are 29 instances of DB username &
password in the file.

You might find it easiest to start with the osm-template.xml file which
has special tokens like DBPASS, DBUSER. Normally you'd run this through
the customize-mapnik-map Perl script but I'm unsure how well this will
work on Windows due to the use of environment variables. You could just
use a search and replace in a text editor instead.

Jon



___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk

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

[John3478 John3478]

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
returning.

Thanks so much


On Wed, Jan 28, 2009 at 12:20 AM, Chris Jones  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
>
>
>
___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk

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

[Chris Jones]

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



___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk

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

[John3478 John3478]

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.

thanks in advance



On Mon, Jan 26, 2009 at 12:15 PM, John3478  wrote:

>
> I am able to generate tiles using "generate_tiles.py".
>
> http://svn.openstreetmap.org/applications/rendering/mapnik/generate_tiles.py
>
> It did create tiles up to zoom level 7 but it did not create any more from
> 8
> to 16 (I am using the extracted california osm file from cloudmate.) Also,
> it did not print any road at all eventhough the database has road details
>
> My question is, is this below statement (from generate_tiles.py) supposed
> to
> print road detail? Or I need to add more statement to it
>
> - this what I try to create-
> bbox = (-122.52862930297852, 37.81127577036112, -122.34237670898438,
> 37.682190082863734)
> render_tiles(bbox, mapfile, tile_dir, 1, 16, "San Francisco")
> 
> --
> View this message in context:
> http://www.nabble.com/Begginer-question%3A-Why-road-is-not-rendered-in-mapnik--tp21669227p21669227.html
> Sent from the OpenStreetMap - General mailing list archive at Nabble.com.
>
>
> ___
> talk mailing list
> talk@openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk
>
___
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk