Thanks Jukka, You resolved my question.
On Thu, Mar 5, 2009 at 9:26 PM, Jukka Rahkonen <jukka.rahko...@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@openstreetmap.org > http://lists.openstreetmap.org/listinfo/talk >
_______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk