Re: [OSM-talk] Begginer question: Why road is not rendered in mapnik?
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.pyhttp://svn.openstreetmap.org/applications/rendering/mapnik/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?
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 roller...@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 ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Begginer question: Why road is not rendered in mapnik?
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?
http://goog_1233181872477 http://goog_1233181872477 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 http://goog_1233181872477 (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?
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?
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?
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 john3...@gmail.com 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
