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@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk