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
[email protected]
http://lists.openstreetmap.org/listinfo/talk
