Dear All,
I have a question regarding spatial queries linked to shapefiles. I have different shapefile (points and lines). I want to query them in a circle/bbox (that would be faster) range based on the click of the mouse over a map. It’s a query related to the number of them and its attributes. (I found something similar HERE)Thanks
I’m using GeoServer and, as long I understood, just them it’s not good enough when I have many and many shapefiles! (I’m talking more than 100k). I understood that I have to link GeoServer to a Database. This will improve the performances!
The point is, what database do you suggest? There is one that works better with GeoServer and it is easy to set up? I’m also looking for something free. Do you know some good tutorial that explain how to execute spatial queries trough GeoServer+DB?
Furthermore, I could call the data from GeoServer? I have read that it’s not simple to call WFS from GeoServer because I have to use a proxy…Could you please link me a good overview/tutorial?
Thanks to all!!
Hi Gianni,
You’re asking a lot of questions there; I think it would be best to address them one at a time.
The commonly used database would be PostGreSQL with the PostGIS extension. The later giving it proper spatial awareness. This is a Free & Open Source product and is well supported by GeoServer. There’s plenty of documentation on it scattered around if you just google for something like “installing postgis postgresql”.
I think getting that set up and working would be the first step. Play around with it and see what it can do and how it works for you, and then when done if you have any further questions you can come back and ask them. You should be able to do all you want with that setup, but you need to learn to walk before you run. 
Regards,
Jonathan
This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED 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.
···
On 28 October 2013 09:40, Gianni Iannelli <giannicristian@anonymised.com> wrote:
Dear All,
I have a question regarding spatial queries linked to shapefiles. I have different shapefile (points and lines). I want to query them in a circle/bbox (that would be faster) range based on the click of the mouse over a map. It’s a query related to the number of them and its attributes. (I found something similar HERE)Thanks
I’m using GeoServer and, as long I understood, just them it’s not good enough when I have many and many shapefiles! (I’m talking more than 100k). I understood that I have to link GeoServer to a Database. This will improve the performances!
The point is, what database do you suggest? There is one that works better with GeoServer and it is easy to set up? I’m also looking for something free. Do you know some good tutorial that explain how to execute spatial queries trough GeoServer+DB?
Furthermore, I could call the data from GeoServer? I have read that it’s not simple to call WFS from GeoServer because I have to use a proxy…Could you please link me a good overview/tutorial?
Thanks to all!!
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Hi Gianni,
Please reply on-list, that way others can help too.
To suggest a proxy server tutorial we’d need to know what web-server you’re using in the first place.
The reason you need it a proxy server:
If your web-page is at:
www.example.com/mywebpage
then any time a WFS request is made, the browser needs to see it going to that domain (www.example.com). The problem is that GeoServer will be running on a different port (usually 8080), so the domain is:
www.example.com:8080
This triggers the browser to be paranoid and not trust it. To get around this we use a proxy script. But without knowing what you’re using for a web-server, we can’t suggest a solution.
Regards,
Jonathan
This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED 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.
···
On 29 October 2013 14:29, Gianni Iannelli <giannicristian@anonymised.com> wrote:
You have right!! I know that there are a lot of installation guide in order to install it but there I was not able to find a tutorial that show how to use it with the spatial queries through GeoServer. I have understood that I have to use a proxy if I wanna call WFS data through GeoServer but I didn’t understand it and I couldn’t find a tutorial. Do you know some place where I could find info and tutorial?
Thank you very much for the help!
Gianni
From: jonathanmoules@anonymised.com
Date: Tue, 29 Oct 2013 11:36:38 +0000
Subject: Re: [Geoserver-users] GeoServer and Spatial queries
To: giannicristian@anonymised.com816…
CC: geoserver-users@lists.sourceforge.net
Hi Gianni,
You’re asking a lot of questions there; I think it would be best to address them one at a time.
The commonly used database would be PostGreSQL with the PostGIS extension. The later giving it proper spatial awareness. This is a Free & Open Source product and is well supported by GeoServer. There’s plenty of documentation on it scattered around if you just google for something like “installing postgis postgresql”.
I think getting that set up and working would be the first step. Play around with it and see what it can do and how it works for you, and then when done if you have any further questions you can come back and ask them. You should be able to do all you want with that setup, but you need to learn to walk before you run.
Regards,
Jonathan
On 28 October 2013 09:40, Gianni Iannelli <giannicristian@anonymised.com> wrote:
Dear All,
I have a question regarding spatial queries linked to shapefiles. I have different shapefile (points and lines). I want to query them in a circle/bbox (that would be faster) range based on the click of the mouse over a map. It’s a query related to the number of them and its attributes. (I found something similar HERE)Thanks
I’m using GeoServer and, as long I understood, just them it’s not good enough when I have many and many shapefiles! (I’m talking more than 100k). I understood that I have to link GeoServer to a Database. This will improve the performances!
The point is, what database do you suggest? There is one that works better with GeoServer and it is easy to set up? I’m also looking for something free. Do you know some good tutorial that explain how to execute spatial queries trough GeoServer+DB?
Furthermore, I could call the data from GeoServer? I have read that it’s not simple to call WFS from GeoServer because I have to use a proxy…Could you please link me a good overview/tutorial?
Thanks to all!!
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&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 sensitive or protectively marked material up to RESTRICTED 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.
Choice of database can be dictated by your environment. Spatial data doesnt usually exist in isolation - its likely there is a GIS involved in authoring and compatibility with the GIS can be important if you dont want to be replicating datasets.
Proxies are only complicated if you have never done server-side code. The script is usually extremely simple but what you use is highly dependent on your server side environment. Tell us that and we can give you pointers.
Notice: This email and any attachments are confidential.
If received in error please destroy and immediately notify us.
Do not copy or disclose the contents.