On Thu, Jul 24, 2014 at 5:03 PM, Ismail, Mark <mark.ism...@knowsley.gov.uk> wrote:
> Hi > > > > Is it possible to do a find nearest search using any combination of > geoserver and openlayers > > > > For example search from the coordinates of a house and list the nearest > school from a table held in geoserver ? > If you are using Oracle as the database, there is also a special filter function called sdonn that will translate in a nearest neighbour query directly in the database. There are no docs in the official documentation, but I've managed to pull a pdf that describes how to use it, it's attached to this mail This support is not available for other databases, but it should be possible to implement a similar function for all spatial databases that provide a nearest neighbour search operator. Cheers Andrea -- == GeoServer Professional Services from the experts! Visit http://goo.gl/NWWaa2 for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it -------------------------------------------------------
OracleSDO_NNGeoToolsFilterFunction.pdf
Description: Adobe PDF document
------------------------------------------------------------------------------ Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds
_______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
