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

[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
latter goes this way (my data is in now in other projection, epsg:2393, but
centroid query can be modified to give result in epsg:4326 as well):
postgis=# select astext(st_centroid(way)) from osm_line limit 2;
                  astext
------------------------------------------
 POINT(3091471.21604526 6654258.08523552)
 POINT(3087407.56739872 6702046.09292488)
(2 rows)