Re: [OSM-talk] SQL

2009-05-10 Thread Jon Burgess
On Sun, 2009-05-10 at 06:49 +0200, Torsten Mohr wrote: I also tried to access Thüringen by its osm_id, but also no success. In PSQL gis: gis= select osm_id, name from planet_osm_polygon where name like 'Thüringen' limit 1000; osm_id | name +--- -76689 | Thüringen

Re: [OSM-talk] SQL

2009-05-10 Thread Jon Burgess
On Sun, 2009-05-10 at 13:19 +0100, Jon Burgess wrote: I also tried to access Thüringen by its osm_id, but also no success. In PSQL gis: gis= select osm_id, name from planet_osm_polygon where name like 'Thüringen' limit 1000; osm_id | name +--- -76689 |

Re: [OSM-talk] SQL

2009-05-10 Thread Torsten Mohr
Hello, i just found out that the missing states are called: Freistaat Bayern Freistaat Sachsen Freistaat Thüringen That was the problem. Best regards, Torsten. On Sun, 2009-05-10 at 06:49 +0200, Torsten Mohr wrote: I also tried to access Thüringen by its osm_id, but also no success.

Re: [OSM-talk] SQL, Where are Thüringen , Bayern a nd Sachsen?

2009-05-10 Thread Torsten Mohr
Hello Jon, thanks a lot for your hints. I just tried updating the entry for Thüringen, but it did not help, Thüringen was not drawn. I actually tried it the way you described, in one try i had an own Layer für Thüringen with an own Style without Filter. In the Layer i changed the SQL query to

Re: [OSM-talk] SQL

2009-05-10 Thread Torsten Mohr
Hello, i just found out that the missing states are called: Freistaat Bayern Freistaat Sachsen Freistaat Thüringen That was the problem. Best regards, Torsten. On Sun, 2009-05-10 at 06:49 +0200, Torsten Mohr wrote: I also tried to access Thüringen by its osm_id, but also no success.

Re: [OSM-talk] SQL, Where are Thüringen , Bayern a nd Sachsen?

2009-05-10 Thread Torsten Mohr
Hello Jon, thanks a lot for your hints. I just tried updating the entry for Thüringen, but it did not help, Thüringen was not drawn. I actually tried it the way you described, in one try i had an own Layer für Thüringen with an own Style without Filter. In the Layer i changed the SQL query to

[OSM-talk] SQL

2009-05-09 Thread Torsten Mohr
Hello, when connecting to PostGIS and querying for german federal states i can find them all in either: planet_osm_line planet_osm_polygon It also is no problem to find states with special characters like in Baden-Württemberg. But no matter what i do, i don't find Bayern and Sachsen. I do

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

2009-03-06 Thread 80n
On Fri, Mar 6, 2009 at 5:21 AM, John3478 John3478 john3...@gmail.comwrote: Thanks, actually, I have the planet data and I want to use sql query to query exactly the same way as the osmxapi that you have. Do you know what is that sql? XAPI uses a schemaless database so there's no SQL. On

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

2009-03-06 Thread Tom Hughes
John3478 John3478 wrote: Thanks, actually, I have the planet data and I want to use sql query to query exactly the same way as the osmxapi that you have. Do you know what is that sql? Before we can answer that we need to know what format you have the planet data in... Do you just mean the

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

2009-03-06 Thread 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 of

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

2009-03-05 Thread 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 Thread John3478 John3478
Thanks, actually, I have the planet data and I want to use sql query to query exactly the same way as the osmxapi that you have. Do you know what is that sql? On Thu, Mar 5, 2009 at 7:19 PM, 80n 80n...@gmail.com wrote:

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

2009-03-05 Thread Jukka Rahkonen
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 of a street.Thank you in advance,john Hi, Import data into PostGIS with osm2pgsql and continue there. For example the