[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