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 . In the Layer i changed the SQL query to look fo

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 . In the Layer i changed the SQL query to look fo

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

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 > > +--

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

[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 John3478 John3478
Thanks Jukka, You resolved my question. On Thu, Mar 5, 2009 at 9:26 PM, Jukka Rahkonen wrote: > John3478 John3478 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 > adv

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 80n
On Fri, Mar 6, 2009 at 5:21 AM, 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? > XAPI uses a schemaless database so there's no SQL. > > On Thu, Mar 5,

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

2009-03-05 Thread Jukka Rahkonen
John3478 John3478 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 latter goes t

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: > > http://osmxapi.hypercube.telascience.org/api/0.5/way[name=Broadway][bbox

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

2009-03-05 Thread 80n
http://osmxapi.hypercube.telascience.org/api/0.5/way[name=Broadway][bbox=-74,40.6,-73.9,40.8] On Fri, Mar 6, 2009 at 2:56 AM, John3478 John3478 wrote: > Hi, > > Did any one know how to query street name within a define bbox? This will get you all the ways named Broadway in Manhattan: http://osm

[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