[OSM-dev] API for local Postgis installs?
Martin Spott
Martin.Spott at mgras.net
Mon Oct 22 19:37:35 BST 2007
Hi Jon,
Jon Burgess wrote:
> Q. What are the nearest roads or other linear features within 250m of
> Buckingham Palace?
>
> First locate the co-ordinates of Buckingham Palace:
[...]
> Next perform geometry query to locate the nearest linear features:
Things could be even simpler: PostgreSQL/PostGIS should allow you to
replace the "GeomFromText('POINT[...]'" clause by the SELECT statement
you use in the first query - sub-selects are a neat tool here :-)
Cheers,
Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
--------------------------------------------------------------------------
More information about the dev
mailing list