Hi Jonathan
I am not sure how a view would help, I still have to connect my mvc app to
oracle etc
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: Jonathan Moules [mailto:jonathanmou...@warwickshire.gov.uk]
Sent: 28 July 2014 16:09
To: Ismail, Mark
Cc: Andrea Aime; GeoServer Mailing List List
Subject: Re: [Geoserver-users] Find my nearest search using openlayers and
geoserver
Hi Mark,
Could you perhaps use an View? Then point GeoServer at the view rather than the
table itself?
Cheers,
Jonathan
On 28 July 2014 15:52, Ismail, Mark
<mark.ism...@knowsley.gov.uk<mailto:mark.ism...@knowsley.gov.uk>> wrote:
Hi Jonathan
You are right - I created an oracle query that does all this but I was hoping
to just use geoserver.
Doing it all in oracle means I will have to run oracle commands via a link
server from my MVC application
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: Jonathan Moules
[mailto:jonathanmou...@warwickshire.gov.uk<mailto:jonathanmou...@warwickshire.gov.uk>]
Sent: 28 July 2014 15:47
To: Ismail, Mark
Cc: Andrea Aime; GeoServer Mailing List List
Subject: Re: [Geoserver-users] Find my nearest search using openlayers and
geoserver
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<mailto: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>
[mailto: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<mailto: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<tel:%2B39%200584%20962313>
fax: +39 0584 1660272<tel:%2B39%200584%201660272>
mob: +39 339 8844549<tel:%2B39%20%C2%A0339%208844549>
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<mailto: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.
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.
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.
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
