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

[John3478 John3478]

Thanks Jukka,

You resolved my question.

On Thu, Mar 5, 2009 at 9:26 PM, Jukka Rahkonen <jukka.rahkonen at mmmtike.fi>wrote:

> 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)
>
>
>
> _______________________________________________
> talk mailing list
> talk at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20090306/9f2bf228/attachment.html>