Hi Mark,
I'd guess that sdo_nn_distance may do what you want:
http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_operat.htm#i80529
Cheers,
Jonathan
On 28 July 2014 15:33, Ismail, Mark <mark.ism...@knowsley.gov.uk> wrote:
> Hi Andrea
>
>
>
> I've gotten an example working using the PDF you attached but have hit a
> slight problem
>
>
>
> The results are not sorted by the distance from the search point.
>
>
>
> It has brought back the closest 10 but the closest 2 are in the middle of
> the list
>
>
>
> Also I would like to know the distance to each (if I had this I could sort
> by distance) do you know if this is possible ?
>
>
>
> See below the link (should work externally)
>
>
>
>
> https://kgeo.knowsley.gov.uk/geoserver/ows?service=WFS&version=1.1.0&request=GetFeature&typeName=Geostore:BUS_STOPS&cql_filter=sdo_nn%28POINT%28344956.59%20390143.52%29%2c10%29=true
>
>
>
>
>
> *Mark Ismail*
>
> *Principal IT Officer*
>
> Tel: 0151 443 3021
>
> Knowsley Council ê Westmorland Road ê Huyton ê L36 9GL
>
>
>
> *Save time - use the IT Service Desk **Self Serve*
> <http://kmbcselfservice/>* Application *
>
>
>
> *From:* andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] *On Behalf
> Of *Andrea Aime
> *Sent:* 28 July 2014 13:15
> *To:* Ismail, Mark; GeoServer Mailing List List
> *Subject:* Re: [Geoserver-users] Find my nearest search using openlayers
> and geoserver
>
>
>
> On Mon, Jul 28, 2014 at 2:10 PM, Ismail, Mark <mark.ism...@knowsley.gov.uk>
> wrote:
>
> The example doesn't seem to let me choose which table to bring nearest
> results from - does it do it from each active table ?
>
>
>
> The table is the feature type you are querying. You cannot do cross table
> comparisons, the reference geometry
>
> has to be statically included in the GML.
>
>
>
> I guess the work could be extended to work as a spatial join too, but it
> needs some coding at the geootols
>
> level to become functional.
>
>
>
> 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
>
>
>
> -------------------------------------------------------
> This e-mail and any attachments are confidential. It may contain
> privileged information and is intended for the named recipient(s) only. It
> must not be distributed without consent. If you are not one of the intended
> recipients, please notify the sender immediately and do not disclose,
> distribute, or retain this email or any part of it and do not take any
> action based on it.
>
> Unless expressly stated, opinions in this email are those of the
> individual sender, and not of Knowsley MBC. Legally binding obligations can
> only be created for, or be entered into on behalf of, Knowsley MBC by duly
> authorised officers or representatives.
>
> Knowsley MBC excludes any liability whatsoever for any offence caused, any
> direct or consequential loss arising from the use, or reliance on, this
> e-mail or its contents. We believe but do not warrant that this e-mail and
> any attachments are virus free. You must therefore take full responsibility
> for virus checking and no responsibility is accepted for loss or damage
> arising from viruses or changes made to this message after it was sent.
> Knowsley MBC reserves the right to monitor and/or record all e-mail
> communications through its network in accordance with relevant legislation.
>
>
> ------------------------------------------------------------------------------
> Infragistics Professional
> Build stunning WinForms apps today!
> Reboot your WinForms applications with our WinForms controls.
> Build a bridge from your legacy apps to the future.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
This transmission is intended for the named addressee(s) only and may
contain confidential, sensitive or personal information and should be
handled accordingly. Unless you are the named addressee (or authorised to
receive it for the addressee) you may not copy or use it, or disclose it to
anyone else. If you have received this transmission in error please notify
the sender immediately. All email traffic sent to or from us, including
without limitation all GCSX traffic, may be subject to recording and/or
monitoring in accordance with relevant legislation.
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
