Re: [Geoserver-users] Problem with print plugin

2015-03-12 Thread Mauro Bartolomeoli
Hi Fernando, the printing plugin distributed with 2.5 is using a default template that referred to an online image that is not available anymore after the GeoServer website migrated to a different platform. You can try replacing the config.yaml in your data_dir/printing folder with the one

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Rahkonen Jukka (MML)
Hi, I am not sure but perhaps you could fool Oracle by inserting the point geometry of the polygon into the SDO_POINT array of SDO_GEOMETRY. Oracle documentation says that if SDO_ELEM_INFO and SDO_ORDINATES arrays are not both null then SDO_POINT will be skipped. However, it would be so nice

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Martin Davis
Thanks for the idea, Ben. I did look at this briefly, but thought I'd pursue the simpler approach first. Although auto-simplification would be much nicer if possible, since it would be more general purpose and give a nicer visual appearance. I think I've seen or heard that the Oracle

Re: [Geoserver-users] Mutple Raster ColorMaps issues

2015-03-12 Thread Simone Giannecchini
Ciao Danilo, such an SLD won't work in GeoServer. You can have only a single RasterSymbolizer. Regards, Simone Giannecchini == GeoServer Professional Services from the experts! Visit http://goo.gl/NWWaa2 for more information. == Ing. Simone Giannecchini @simogeo Founder/Director GeoSolutions

Re: [Geoserver-users] XY layers in Oracle?

2015-03-12 Thread Andrea Aime
On Tue, Mar 10, 2015 at 7:47 PM, Martin Davis mtncl...@gmail.com wrote: Is it possible to create a GeoServer layer against an Oracle table that has only X and Y numeric columns? (This seems like it might provide another potential solution to the issue of reducing Oracle query data size).

Re: [Geoserver-users] The gwc and The coordinate reference system must be the same for all objects error

2015-03-12 Thread Maciej Filocha
W dniu 2015-03-12 o 01:04, Andrea Aime pisze: Sounds like a bug indeed... please open a ticket and attach a small dataset and requests, enough to reproduce the problem Done: https://jira.codehaus.org/browse/GEOS-6934 Regards Maciej

Re: [Geoserver-users] parametric SQL View with escaped viewparams and Oracle Data Source

2015-03-12 Thread Andrea Aime
On Wed, Mar 11, 2015 at 5:45 PM, Paul Jereb paul.je...@blauorange.com wrote: Hello everyone! When using a parametric SQL View and trying to escape the viewparams values with backslashes as described in

Re: [Geoserver-users] Loading vector data into SOLR

2015-03-12 Thread Tobias Reinicke
Hi David, Many thanks - that's some great info - if I may pry though - why is the spatial search of SOLR not as good as PostGIS (as I don't know SOLR much I don't know what to expect :) ) - I presume it's along the lines of PG has better spatial indexes (indicies?)? If so, that pretty much

Re: [Geoserver-users] XY layers in Oracle?

2015-03-12 Thread Martin Davis
Or it might be simpler and neater to have a function geomFromWKT_SRID(String wkt, int srid) After a bit of code browsing it looks as thought this might not be sufficient to get this to work though? On Tue, Mar 10, 2015 at 1:55 PM, Martin Davis mtncl...@gmail.com wrote: Answering my own

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Martin Davis
To take another slant on this, I realized that the source of the problem is that for SQL views the custom SQL is wrapped in parens before the WMS bbox filter condition is appended to it. This is what's causing the DB to complain that the geometry column expression doesn't have an index.

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Martin Davis
Hi, About crazy talks, what our hardcore Oracle developers do first when they face problems with efficiency is to start writing some PL/SQL procedures which they then tune until they are satisfied (of when we say that we have paid enough). Unfortunately Geoserver can't utilize those

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Andrea Aime
Martin, I see what you mean, and it would work in your particular case, but it does not make sense in general, please review how sql views work, under the notion of a general mechanism (as a data source that can be queried), not under the lenses of your specific wms generalization use case, and it

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Andrea Aime
On Fri, Mar 13, 2015 at 3:20 AM, Martin Davis mtncl...@gmail.com wrote: Hi, About crazy talks, what our hardcore Oracle developers do first when they face problems with efficiency is to start writing some PL/SQL procedures which they then tune until they are satisfied (of when we say that

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Martin Davis
On Thu, Mar 12, 2015 at 3:27 PM, Andrea Aime andrea.a...@geo-solutions.it wrote: On Thu, Mar 12, 2015 at 7:00 PM, Martin Davis mtncl...@gmail.com wrote: Now who's talking crazy! :) +0 on using a full templating language. Seems perhaps a bit of overkill for the immediate need? The macro

Re: [Geoserver-users] Loading vector data into SOLR

2015-03-12 Thread Andrea Aime
On Thu, Mar 12, 2015 at 10:09 AM, Tobias Reinicke ramot...@gmail.com wrote: Hi David, Many thanks - that's some great info - if I may pry though - why is the spatial search of SOLR not as good as PostGIS (as I don't know SOLR much I don't know what to expect :) ) - I presume it's along the

Re: [Geoserver-users] WMS Polygons as PointSymbolizer - missing points

2015-03-12 Thread Andrea Aime
: http://www.salford.gov.uk/geoserver/wms?request=GetMaplayers=NE:v_point_display_teststyles=width=512height=445srs=EPSG:3857format=application/openlayerstracker=20150312-Testingbbox=-253000,7057000,-207000,7096000 There is a total 237 polygons features all within the initial viewport, if you zoom

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Rahkonen Jukka (MML)
Hi, About crazy talks, what our hardcore Oracle developers do first when they face problems with efficiency is to start writing some PL/SQL procedures which they then tune until they are satisfied (of when we say that we have paid enough). Unfortunately Geoserver can't utilize those fancy

Re: [Geoserver-users] Geoserver Clustering Issue

2015-03-12 Thread Martin Davis
A goo search for geoserver cluster turns up lots of resources that describe various ways to implement clustering. Here's a good one: http://boundlessgeo.com/2013/04/geoserver-in-a-clustered-configuration-part-1/ On Thu, Mar 12, 2015 at 12:05 PM, Rahkonen Jukka (MML)

[Geoserver-users] WMS Polygons as PointSymbolizer - missing points

2015-03-12 Thread Langford, Robert
=512height=445srs=EPSG:3857format=application/openlayerstracker=20150312-Testingbbox=-253000,7057000,-207000,7096000 There is a total 237 polygons features all within the initial viewport, if you zoom out the 4 points that are displayed should disappear, and if you zoom in more should appear. Any

Re: [Geoserver-users] Geoserver Clustering Issue

2015-03-12 Thread mumairr
Thank you for the reply Martin, I've followed all the tutorials and they all lead to vertical clustering (same machine with multiple instances) none of them explains how to achieve horizontal clustering, though geo solutilns themselves claim horizontal clustering is possible. -- View this

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Martin Davis
Now who's talking crazy! :) +0 on using a full templating language. Seems perhaps a bit of overkill for the immediate need? The macro language already discussed would suffice for the immediate need I think? Whatever the syntax used, it seems like the solution has to: - allow altering the

Re: [Geoserver-users] Geoserver Clustering Issue

2015-03-12 Thread mumairr
No reply? Did i ask a wrong question? -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Geoserver-Clustering-Issue-tp5190519p5193097.html Sent from the GeoServer - User mailing list archive at Nabble.com.

Re: [Geoserver-users] Geoserver Clustering Issue

2015-03-12 Thread mumairr
Thank you for the reply. First of all i think network isn't an issue here, I've tested my network supports multicast. Vertical clustering works well and changes are submitted to instances running on same machine bit changes on other machines aren't broadcasted. It has something to do with the

Re: [Geoserver-users] Geoserver Clustering Issue

2015-03-12 Thread Rahkonen Jukka (MML)
Hi, Question is OK but I guess that there are not so many users running Geoservers in clusters. Problem But I'm unable to send these changes over network to other machines makes me feel that it could have something to do with general network and firewall configuration. -Jukka Rahkonen-

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Martin Davis
I think the scheme being discussed should support that nicely. It would be great to support allowing an arbitrary SQL expression to compute the geometry returned for WMS usage. That could be a custom Oracle function which performed some kind of special purpose simplification (if not already

Re: [Geoserver-users] Loading vector data into SOLR

2015-03-12 Thread David Collins
Hello, Ramo. There would be 2 reasons why SOLR is slower than PG 1. SOLR is not built from the ground up for spatial queries - eg. it stores spatial data as WKT strings (although maybe it transforms them to something more efficient behind the scenes? - I don't know) 2. The transfer of the

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Andrea Aime
On Thu, Mar 12, 2015 at 7:40 PM, Rahkonen Jukka (MML) jukka.rahko...@maanmittauslaitos.fi wrote: Hi, About crazy talks, what our hardcore Oracle developers do first when they face problems with efficiency is to start writing some PL/SQL procedures which they then tune until they are

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Andrea Aime
On Thu, Mar 12, 2015 at 7:00 PM, Martin Davis mtncl...@gmail.com wrote: Now who's talking crazy! :) +0 on using a full templating language. Seems perhaps a bit of overkill for the immediate need? The macro language already discussed would suffice for the immediate need I think? The

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Rahkonen Jukka (MML)
Hi, Good to know, we must make some tests. All that we have in WFS is implemented before SQL Views were supported or made with the same recipes later. Are here any users who utilize stored procedures listening and willing to tell about how it goes? -Jukka-

Re: [Geoserver-users] Reducing query data size in Oracle

2015-03-12 Thread Andrea Aime
On Tue, Mar 10, 2015 at 7:00 PM, Martin Davis mtncl...@gmail.com wrote: We're working on tuning a GeoServer implementation over an Oracle SDO database. We think we are seeing that the network latency of queries is the hotspot in the performance of GeoServer render requests. It seems that for