Re: [OSM-talk] SQL to query street name within a define bbox

2009-03-06 Per discussione John3478 John3478
Thanks Jukka, You resolved my question. On Thu, Mar 5, 2009 at 9:26 PM, Jukka Rahkonen jukka.rahko...@mmmtike.fiwrote: John3478 John3478 john3478 at gmail.com writes: Hi,Did any one know how to query street name within a define bbox?And second question, how to find lat, lon mid point

[OSM-talk] SQL to query street name within a define bbox

2009-03-05 Per discussione John3478 John3478
Hi, Did any one know how to query street name within a define bbox? And second question, how to find lat, lon mid point of a street. Thank you in advance, john ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk

Re: [OSM-talk] SQL to query street name within a define bbox

2009-03-05 Per discussione John3478 John3478
=-74,40.6,-73.9,40.8]http://osmxapi.hypercube.telascience.org/api/0.5/way%5Bname=Broadway%5D%5Bbbox=-74,40.6,-73.9,40.8%5D On Fri, Mar 6, 2009 at 2:56 AM, John3478 John3478 john3...@gmail.comwrote: Hi, Did any one know how to query street name within a define bbox? This will get you all

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

2009-01-30 Per discussione 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

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

2009-01-30 Per discussione John3478 John3478
Problem resolved. The problem is in bbox, it supposed to be using minX, minY, maxX, maxY. Thanks for Jon Burgess who resolved the issues. On Fri, Jan 30, 2009 at 12:53 AM, John3478 John3478 john3...@gmail.comwrote: I think, I narrow down the problem. The original generate_tiles from

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

2009-01-28 Per discussione John3478 John3478
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

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

2009-01-28 Per discussione John3478 John3478
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.

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

2009-01-28 Per discussione 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

[OSM-talk] why there is no historic column from planet_osm_line?

2009-01-27 Per discussione John3478 John3478
From the generate image tiles, there is a select for historic column, however in the database there is no historic column in planet_osm_line. Do you guys know why there is ho historic column? or the osm_template that I used is old version already? Thanks in advances, John (select way from

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

2009-01-27 Per discussione John3478 John3478
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

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

2009-01-26 Per discussione John3478
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