Re: [Geoserver-users] Problem with SLD PointPlacement Displacement not working

2018-12-11 Thread Martin Davis
Issue created: https://osgeo-org.atlassian.net/browse/GEOS-9056 On Mon, Dec 10, 2018 at 10:57 PM Andrea Aime wrote: > On Mon, Dec 10, 2018 at 9:37 PM Martin Davis wrote: > >> Are there any known issues with this? Or is there something wrong with >> the style? >

Re: [Geoserver-users] Problem with SLD PointPlacement Displacement not working

2018-12-11 Thread Martin Davis
. I could imagine a more sophisticated layout control allowing labels to be anchored relative to the map extent box, as well. On Tue, Dec 11, 2018 at 11:05 AM Andrea Aime wrote: > On Tue, Dec 11, 2018 at 7:41 PM Martin Davis wrote: > >> Thanks for the assistance. >> >>

Re: [Geoserver-users] Problem with SLD PointPlacement Displacement not working

2018-12-11 Thread Martin Davis
be visible, which should help. On Tue, Dec 11, 2018 at 10:40 AM Martin Davis wrote: > Thanks for the assistance. > > I will look into logging an issue for this. > > For the record, the use cases for this capability are: > - In the case where there are two polygonal coverage

Re: [Geoserver-users] Problem with SLD PointPlacement Displacement not working

2018-12-11 Thread Martin Davis
at the polygon centroid)? On Tue, Dec 11, 2018 at 12:42 AM Ian Turton wrote: > Could you work round it by adding a geom tag with a centroid function to > get a point? > > Ian > > On Tue, 11 Dec 2018 at 07:00, Andrea Aime > wrote: > >> On Mon, Dec 10, 2018

[Geoserver-users] Problem with SLD PointPlacement Displacement not working

2018-12-10 Thread Martin Davis
We are styling an SDE layer of polygons. We want to display the polygon labels offset from the centre of the map image when zoomed into a single polygon, so that the label is readable when zooming to a point (which is using a client-side icon, so obscuring the label). We are trying to set the

Re: [Geoserver-users] Error in GelLegendGraphic against an Oracle POINT table (class [B is not supported)

2018-06-25 Thread Martin Davis
Good news again... Turns out I was testing against a 2.9 version. Testing against 2.12 with a custom Legend image specified seems to solve the problem - the Legend graphic is returned correctly. On Mon, Jun 25, 2018 at 10:05 AM, Martin Davis wrote: > Well, apparently setting a custom leg

Re: [Geoserver-users] Error in GelLegendGraphic against an Oracle POINT table (class [B is not supported)

2018-06-25 Thread Martin Davis
, Martin Davis wrote: > Revisting this issue... > > One workaround for this would be to provide a custom legend image that > overrides the generated one. Is this possible in Geoserver? Is there > documentation on this? > > Martin > > On Thu, Apr 26, 2018 at 10:27 A

Re: [Geoserver-users] Error in GelLegendGraphic against an Oracle POINT table (class [B is not supported)

2018-06-25 Thread Martin Davis
Next question: is it possible to configure this via the REST API? On Mon, Jun 25, 2018 at 9:47 AM, Martin Davis wrote: > Ok, I see this now in the docs for Geoserver 2.12 [1].Custom legend > images can be set on the Style Editor page under the Legend area. > >

Re: [Geoserver-users] Error in GelLegendGraphic against an Oracle POINT table (class [B is not supported)

2018-06-25 Thread Martin Davis
Ok, I see this now in the docs for Geoserver 2.12 [1].Custom legend images can be set on the Style Editor page under the Legend area. [1] http://docs.geoserver.org/maintain/en/user/styling/webadmin/index.html#style-editor-data-tab On Mon, Jun 25, 2018 at 9:38 AM, Martin Davis wrote

Re: [Geoserver-users] Error in GelLegendGraphic against an Oracle POINT table (class [B is not supported)

2018-06-25 Thread Martin Davis
Revisting this issue... One workaround for this would be to provide a custom legend image that overrides the generated one. Is this possible in Geoserver? Is there documentation on this? Martin On Thu, Apr 26, 2018 at 10:27 AM, Andrea Aime wrote: > On Thu, Apr 26, 2018 at 7:25 PM, Mar

Re: [Geoserver-users] Trouble with dynamically generated SLD

2018-05-15 Thread Martin Davis
You can also read the Geoserver SLD Reference docs, which describe the element ordering specified by the standard (and might be a bit easier to read). On Mon, May 14, 2018 at 7:17 AM, Kris Johnson wrote: > Hi Ian, > > Thanks for the response. > Your answer is what I was

[Geoserver-users] How to fix Error: Tile Layers out of synch ?

2018-05-08 Thread Martin Davis
We get the following error message when invoking the Tile Caching / Tile Layers panel in the web UI: Caused by: java.lang.IllegalStateException: Could not locate a layer or layer group with id LayerInfoImpl--2c3fc31e:159ff9b77e2:-7f6a within GeoServer configuration, the GWC configuration seems to

Re: [Geoserver-users] Error in GelLegendGraphic against an Oracle POINT table (class [B is not supported)

2018-04-26 Thread Martin Davis
by the type of SDO_GEOMETRY? On Thu, Apr 26, 2018 at 12:34 AM, Ian Turton <ijtur...@gmail.com> wrote: > I'm fairly sure that class [B is a byte array, can you add the featuretype > info? > > Ian > > On 25 April 2018 at 19:16, Martin Davis <mtncl...@gmail.com> wrote: > >&

[Geoserver-users] Error in GelLegendGraphic against an Oracle POINT table (class [B is not supported)

2018-04-25 Thread Martin Davis
We are seeing an error when issuing GetLegendGraphic against an Oracle view containing POINT geometries. The error trace is below. The styling is straightforward - uses a PNG as the icon for the point. The layer displays the point feature icons correctly - it's just the legend that doesn't

[Geoserver-users] Geoserver as a raster overlay engine?

2018-04-12 Thread Martin Davis
Has anyone experimented with using Geoserver as a raster overlay engine? I can think of two ways this might work: 1. Use the SLD compositing capabiity 2. Render layers as two or multi-valued images, and then use client-side image processing code to combine the rasters An ability to support even

Re: [Geoserver-users] Reduce precision of WFS output to decrease response size?

2017-10-18 Thread Martin Davis
------- > *Lähettäjä:* Martin Davis <mtncl...@gmail.com> > *Lähetetty:* 18. lokakuuta 2017 19:53 > *Vastaanottaja:* Andrea Aime > *Kopio:* geoserver-users@lists.sourceforge.net > *Aihe:* Re: [Geoserver-users] Reduce precision of WFS output to decrease > response si

Re: [Geoserver-users] Reduce precision of WFS output to decrease response size?

2017-10-18 Thread Martin Davis
d, Oct 18, 2017 at 6:09 PM, Martin Davis <mtncl...@gmail.com> wrote: > >> Here's another reason why reducing precision of responses on-the-fly >> would be useful. It turn out the data as stored in EPGS:3005 essentially >> has 1 m precision. However, we are reque

Re: [Geoserver-users] Reduce precision of WFS output to decrease response size?

2017-10-18 Thread Martin Davis
by GeoServer. So in this case it is perfectly safe to round back to 1 m precision. We will explore requesting the data in the native CRS, since we can project on the client-side. But it would be nice to be able to do this fully in GeoServer. On Tue, Oct 17, 2017 at 3:55 PM, Martin Davis <mt

Re: [Geoserver-users] Reduce precision of WFS output to decrease response size?

2017-10-17 Thread Martin Davis
ards, > Ben. > > > On 18/10/17 13:20, Martin Davis wrote: > >> There are many geometries in a reponse (for example, one response has 2240 >> geometries, and has an uncompressed size of 123 MB!). >> >> We're aware of WFS paging, but in this partic

Re: [Geoserver-users] Reduce precision of WFS output to decrease response size?

2017-10-17 Thread Martin Davis
on, > not part of the spec); just use maxfeatures instead of count and you should > be good to go. > > GZIP compression should already be used on the wire. > > Kind regards, > Ben. > > > On 18/10/17 12:41, Martin Davis wrote: > >> Thanks, Ben. Unfortunately

Re: [Geoserver-users] Reduce precision of WFS output to decrease response size?

2017-10-17 Thread Martin Davis
ameter > to request only the properties you need for even smaller responses: > http://localhost:8080/geoserver/wfs?service=WFS=2.0. > 0=GetFeature=topp:states=topp:PERSONS, > topp:WORKERS > > Kind regards, > Ben. > > > On 18/10/17 11:55, Martin Davis wrote: > >> Is

Re: [Geoserver-users] Reduce precision of WFS output to decrease response size?

2017-10-17 Thread Martin Davis
[1] http://docs.geoserver.org/stable/en/user/services/wfs/vendor.html On Tue, Oct 17, 2017 at 3:55 PM, Martin Davis <mtncl...@gmail.com> wrote: > Is there any way in GeoServer to request that the precision of WFS output > be reduced? (I.e. remove decimal places from the ordinates?). >

[Geoserver-users] Reduce precision of WFS output to decrease response size?

2017-10-17 Thread Martin Davis
Is there any way in GeoServer to request that the precision of WFS output be reduced? (I.e. remove decimal places from the ordinates?). We have a large dataset which has far too much precision on the data. Removing unecessary decimal digits seems like it could significantly reduce WFS response

Re: [Geoserver-users] feature frenzy - any requests?

2017-08-10 Thread Martin Davis
Provide a Layer Preview utility that allows displaying multiple layers, and using a user-defined base map. On Sun, Aug 6, 2017 at 5:07 PM, Jody Garnett wrote: > For me I got a see first hand out some nifty features that I had only ever > read about before: > > 1)

Re: [Geoserver-users] feature frenzy - any requests?

2017-08-09 Thread Martin Davis
Here's one: Add links to REST resources on GUI pages (such as Edit Layer, Edit Datastore, etc). On Sun, Aug 6, 2017 at 5:07 PM, Jody Garnett wrote: > For me I got a see first hand out some nifty features that I had only ever > read about before: > > 1) Starting from an

Re: [Geoserver-users] How to use REST to create a coverage from a TIF file with no explicit SRS ?

2017-08-01 Thread Martin Davis
ding this, and perhaps also some mention in the UI docs about what is going on under the hood. On Tue, Aug 1, 2017 at 2:43 PM, Martin Davis <mtncl...@gmail.com> wrote: > I am trying to create a CoverageStore and Coverage layer from a TIF file > staged on the Geoserver server, using t

Re: [Geoserver-users] MIssing REST datastores Swagger doc?

2017-05-29 Thread Martin Davis
type. On Wed, May 24, 2017 at 1:50 PM, Jim Hughes <jn...@ccri.com> wrote: > Hi Martin, > > Looks like there is link missing for this yaml: > http://docs.geoserver.org/api/#/1.0.0/datastores.yaml. > > Cheers, > > Jim > > > On 05/24/2017 04:22 PM, Marti

[Geoserver-users] MIssing REST datastores Swagger doc?

2017-05-24 Thread Martin Davis
Is the documentation for the REST datastores resource missing in the new REST API Swagger doc? It's not listed here: http://docs.geoserver.org/latest/en/user/rest/index.html#rest But is here: http://docs.geoserver.org/latest/en/user/rest/api/datastores.html

Re: [Geoserver-users] Default Style via REST

2017-02-27 Thread Martin Davis
We use the request below, and it works for us. URL: %HOST%/rest/layers/%LYR% Body: %STYLE% On Mon, Feb 27, 2017 at 1:24 AM, David Alda Fernandez de Lezea < da...@hazi.eus> wrote: > Hi, > > I'm developing a small program to automatically populate some satellite > images via REST. I

Re: [Geoserver-users] Legend issue - multiple symbols for cased lines

2017-02-23 Thread Martin Davis
. On Thu, Feb 23, 2017 at 10:59 AM, Martin Davis <mtncl...@gmail.com> wrote: > Makes sense, Andrea. > > In this particular case the rules are as simple as can be - no filters or > scale dependency. So that should be the easiest case to handle. > > I can see how this could be hard

Re: [Geoserver-users] Legend issue - multiple symbols for cased lines

2017-02-23 Thread Martin Davis
separate entries for them. Not sure I'll be able to rustle up funding to work on this, but I'll give it a try. On Thu, Feb 23, 2017 at 10:36 AM, Andrea Aime <andrea.a...@geo-solutions.it> wrote: > On Thu, Feb 23, 2017 at 7:19 PM, Martin Davis <mtncl...@gmail.com> wrote: >

[Geoserver-users] Legend issue - multiple symbols for cased lines

2017-02-23 Thread Martin Davis
As I understand it, the recommended approach for producing "cased" lines (e.g. for roads or polygon outlines) is to specify each different line style in a separate FeatureTypeStyle. However, this seems to produce Legend graphics with the different line styles on separate lines. (See attached map

[Geoserver-users] Legend issue - blank entries for label rules

2017-02-23 Thread Martin Davis
It looks like GeoServer produces a "blank line" in Legends if a TextSymbolizer is specified in a separate rule (as is often done for scale-dependent labelling). Is there any way to turn this off? This behaviour actuall seems a bit useless, so perhaps it could be prevented in the code?

[Geoserver-users] Bug in SLD WKT Graphic Mark Legend generation?

2017-02-21 Thread Martin Davis
We have defined a style using a Graphic Mark defined using a WKT symbol. The symbol looks fine on the map, but in the Legend graphic it appears to be displaced to the upper right, resulting in a useless display. Is there a bug in the Legend code for this? Or should the WKT extent be different

Re: [Geoserver-users] Creating a spatial view from an XY table in MS SQL Server?

2017-02-07 Thread Martin Davis
reported that this even works with defining the view as a GeoServer SQL View, which is a very handy capability. It would be nice if this worked for Oracle as well! On Mon, Feb 6, 2017 at 10:01 AM, Martin Davis <mtncl...@gmail.com> wrote: > Has anyone tried creating a spatial view on an

[Geoserver-users] Creating a spatial view from an XY table in MS SQL Server?

2017-02-06 Thread Martin Davis
Has anyone tried creating a spatial view on an XY table in MS SQL Server, so it can be exposed via GeoServer? We are not having any luck with this. What we have done is: 1) Define a spatial view: CREATE VIEW UDO_Fuel_Cache_SVW AS SELECT ID, Latitude, Longitude,

Re: [Geoserver-users] Uploading SLD ExternalGraphic images via REST API?

2017-01-12 Thread Martin Davis
ver-2-9-0-released/>. > > > -- > Jody Garnett > > On 11 January 2017 at 13:41, Martin Davis <mtncl...@gmail.com> wrote: > >> Can the REST API resources request [1] be used to upload image files for >> use in SLDs as external graphics? >> >> Are ther

[Geoserver-users] Uploading SLD ExternalGraphic images via REST API?

2017-01-11 Thread Martin Davis
Can the REST API resources request [1] be used to upload image files for use in SLDs as external graphics? Are there any examples of how to do this? In particular, it's not clear to me from the docs how to specify the location the files should be stored to. [1]

Re: [Geoserver-users] GeoServer 2.9 deleting SLD Stroke elements?

2016-12-11 Thread Martin Davis
missing default elements, rather than eliding them. But if this is the new convention it would be nice to have the defaults documented in the GeoServer docs. On Thu, Dec 8, 2016 at 11:34 PM, Andrea Aime <andrea.a...@geo-solutions.it> wrote: > On Thu, Dec 8, 2016 at 7:52 PM, Martin Dav

[Geoserver-users] GeoServer 2.9 deleting SLD Stroke elements?

2016-12-08 Thread Martin Davis
I noticed some odd behaviour in GS 2.9.1. I load a style via the REST API which has the following in a PolygonSymbolizer: #00 1 1.0 When I view the style in the Style Editor panel the following is displayed: This is also what is stored in the data

Re: [Geoserver-users] Hexagon Binning

2016-10-12 Thread Martin Davis
You might be able to use Rendering Transformations to do this: http://docs.geoserver.org/latest/en/user/styling/sld/extensions/rendering-transform.html But it will take a bit of code... On Wed, Oct 12, 2016 at 6:07 AM, Volkan Gümüs wrote: > Hello everybody! > > I'm

[Geoserver-users] Strategy for GetCaps layer scale range for multiple styles?

2016-07-05 Thread Martin Davis
What strategy does GeoServer use for computing the GetCaps layer scale range if a layer has multiple available styles with different scale ranges? Is it the union (really the "envelope") of the scale ranges? -- Attend

Re: [Geoserver-users] Styling when points symbols are overlapping

2016-03-29 Thread Martin Davis
Perhaps the PointStacker rendering transformation could help? http://docs.geoserver.org/latest/en/user/styling/sld-extensions/rendering-transform.html https://wiki.state.ma.us/confluence/display/massgis/GeoServer+-+WMS+and+WPS+-+Rendering+Transformations+-+Point+Clustering On Tue, Mar 29, 2016

Re: [Geoserver-users] Possible to obtain groups from HTTP Headers?

2016-02-25 Thread Martin Davis
d also be a bit more explicit about the configuration UI in [2]. (I know, I know - make a PR for this!) On Thu, Feb 25, 2016 at 12:51 AM, Mauro Bartolomeoli < mauro.bartolome...@geo-solutions.it> wrote: > Hi Martin, > > 2016-02-24 18:22 GMT+01:00 Martin Davis <mtncl...@gmail.c

Re: [Geoserver-users] SLD problem with attribute filtering

2016-02-24 Thread Martin Davis
uirements of > the work I have to do. > > Isn't this behavior a bug of geoserver ? It shouldn't behave this way > when you don't have the exact same attribute for your point and your > polygon. > > 2016-02-25 2:06 GMT+01:00 Martin Davis <mtncl...@gmail.com>: &g

Re: [Geoserver-users] SLD problem with attribute filtering

2016-02-24 Thread Martin Davis
Why not create two different SLDs? On Wed, Feb 24, 2016 at 3:41 PM, Geoffrey wrote: > Hello, > > I have a SLD file styling 2 different shapefiles, one containing point and > the other containing polygons. The polygons have an attribute that the > point > doesn't. > > The

Re: [Geoserver-users] Possible to obtain groups from HTTP Headers?

2016-02-24 Thread Martin Davis
a ResourceAccessManager plugin that can access the Authorization mechanism that is already in place. Martin On Wed, Feb 24, 2016 at 12:19 AM, Mauro Bartolomeoli < maurobartolome...@gmail.com> wrote: > Hi Martin, > > 2016-02-24 2:03 GMT+01:00 Martin Davis <mtncl...@gmail.com>

[Geoserver-users] Possible to obtain groups from HTTP Headers?

2016-02-23 Thread Martin Davis
We are running GeoServer behind a HTTP security proxy which provides both user authentication and user group membership information (via HTTP Headers). Is it possible to somehow pass the user groups into GeoServer for use by Security subsystem, against a suitably configured Role Service? We are

Re: [Geoserver-users] Scale discrepancy between Web Mercator and BC-Albers

2016-02-16 Thread Martin Davis
: layout> On Tue, Feb 16, 2016 at 9:35 AM, Andrea Aime <andrea.a...@geo-solutions.it> wrote: > On Tue, Feb 16, 2016 at 6:10 PM, Martin Davis <mtncl...@gmail.com> wrote: > >> Thanks, Andrea. I suspected this might be the cause of the issue. >> >> Is

Re: [Geoserver-users] Scale discrepancy between Web Mercator and BC-Albers

2016-02-16 Thread Martin Davis
Thanks for the advice - and for the warning. Sigh On Tue, Feb 16, 2016 at 9:35 AM, Andrea Aime <andrea.a...@geo-solutions.it> wrote: > On Tue, Feb 16, 2016 at 6:10 PM, Martin Davis <mtncl...@gmail.com> wrote: > >> Thanks, Andrea. I suspected this might b

Re: [Geoserver-users] Scale discrepancy between Web Mercator and BC-Albers

2016-02-16 Thread Martin Davis
<andrea.a...@geo-solutions.it> wrote: > On Tue, Feb 16, 2016 at 12:05 AM, Martin Davis <mtncl...@gmail.com> wrote: > >> Are you suggesting that GeoServer computes the scale at a single known >> point for all map request extents, no matter where on the globe they are >

Re: [Geoserver-users] Scale discrepancy between Web Mercator and BC-Albers

2016-02-15 Thread Martin Davis
expect that the > tiles of the same zoom level would use different styles at equator than in > Canada or Finland even the true scale differs a lot. > > > > -Jukka Rahkonen- > > > > Martin Davis wrote: > > > > We are displaying map images in Web Mercator, from

Re: [Geoserver-users] Scale discrepancy between Web Mercator and BC-Albers

2016-02-15 Thread Martin Davis
ood the problem but I wonder how the true scale > suits together with Web Mercator. I guess that you do not expect that the > tiles of the same zoom level would use different styles at equator than in > Canada or Finland even the true scale differs a lot. > > > > -Jukka Rahkon

[Geoserver-users] Scale discrepancy between Web Mercator and BC-Albers

2016-02-15 Thread Martin Davis
We are displaying map images in Web Mercator, from a GeoServer with native CRS as BC-Albers (EPGS:3005). We are using an OpenLayers client to display the map images. We have confirmed that the geodetic scale displayed by OpenLayers is approximately the true scale of the map images (modulo the

Re: [Geoserver-users] Odd behaviour with WFS GetFeature in Geoserver 2.7.1.1 - property names (and geometry) returned that are not requested.

2016-01-17 Thread Martin Davis
+1 for a nogeometry switch. We need some way to support GetFeatureInfo but not return geometry, for security reasons. Actually it would be great to support returning a BBOX rather than the actual geometry, since this supports zooming. This improves both security and performance. On Sun, Jan

Re: [Geoserver-users] Remap raster band values to strings for GetFeatureInfo ?

2015-11-24 Thread Martin Davis
ature". Will the SLD do this? As you say, with custom code anything is possible, but we need to have a supported solution for this. On Tue, Nov 24, 2015 at 6:08 AM, Andrea Aime <andrea.a...@geo-solutions.it> wrote: > On Mon, Nov 23, 2015 at 11:03 PM, Martin Davis <mtncl...@gmail.co

Re: [Geoserver-users] Remap raster band values to strings for GetFeatureInfo ?

2015-11-24 Thread Martin Davis
, Andrea Aime <andrea.a...@geo-solutions.it> wrote: > On Tue, Nov 24, 2015 at 6:52 PM, Martin Davis <mtncl...@gmail.com> wrote: > >> Thanks, Andrea. >> >> Being a bit of a raster newb, I realized after i posted that as you >> suggest an SLD is needed to

[Geoserver-users] Remap raster band values to strings for GetFeatureInfo ?

2015-11-23 Thread Martin Davis
We have a GeoTiff with a single paletted band. By default GetFeatureInfo returns results containing (for example) PALETTE_INDEX = 2.0. We'd like to return more business-meaningful titles, such as "C‐2 Boreal Spruce". It seems like FreeMarker templates are one way to do this (as per

Re: [Geoserver-users] GeoServer's spatial filter preventing SQL view layer from working

2015-11-19 Thread Martin Davis
+1 - agreed that this seems like the "simplest" way forward. On Thu, Nov 19, 2015 at 10:08 AM, cheesybiscuits wrote: > Wow, that is a long thread! > > I read / skimmed through the full conversation and what I take from it is > there are numerous ways this could be

Re: [Geoserver-users] GeoServer's spatial filter preventing SQL view layer from working

2015-11-19 Thread Martin Davis
sfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > Cheers > Andrea > > On Thu, Nov 19, 2015 at 6:32 AM, Martin Davis <mtncl...@gmail.com> wrote: > >> I think this is the same issue discussed in this (lengthy) thread: >> >> >>

Re: [Geoserver-users] GeoServer's spatial filter preventing SQL view layer from working

2015-11-18 Thread Martin Davis
I think this is the same issue discussed in this (lengthy) thread: http://osgeo-org.1560.x6.nabble.com/Reducing-query-data-size-in-Oracle-td5192620.html TLDR: not possible right now, apparently requires clever development to make it work. If there has been improvement on this front it would be

Re: [Geoserver-users] Multiple Layers in GetLegendGraphic?

2015-09-28 Thread Martin Davis
love to have one that > operates like GetFeatureInfo - and includes a reference GetMap complete > with BBox (and thus could only show the layers / rules that end up having > something on the screen. > > -- > Jody Garnett > > On 25 September 2015 at 09:48, Martin Davis <mt

[Geoserver-users] Multiple Layers in GetLegendGraphic?

2015-09-25 Thread Martin Davis
It looks like GetLegendGraphic only supports requesting a legend for a single layer. Could this be generalized to allow multiple layers being requested? The use case is that in some simple clients it's difficult to display an arbitrary-length list of images (e.g. Jasper Reports).

Re: [Geoserver-users] Issue with internal connection pooling for Oracle datastore with no schema name?

2015-09-02 Thread Martin Davis
Thanks, Andrea, that sounds like the cause. We'll upgrade and see if the problem goes away. On Tue, Sep 1, 2015 at 11:25 PM, Andrea Aime <andrea.a...@geo-solutions.it> wrote: > On Wed, Sep 2, 2015 at 1:21 AM, Martin Davis <mtncl...@gmail.com> wrote: > >> We've run so

Re: [Geoserver-users] Native Oracle JDBC logging in GeoServer ?

2015-09-02 Thread Martin Davis
some packet sniffer intermediate to watch > the requests as they go by; not sure if fiddler2 can handle this type of > packet. > > Cheers, > Jonathan > > > On 01/09/2015 20:11, Martin Davis wrote: > > In order to diagnose a performance problem [1] we would like to capture &g

[Geoserver-users] Native Oracle JDBC logging in GeoServer ?

2015-09-01 Thread Martin Davis
In order to diagnose a performance problem [1] we would like to capture ALL SQL statements emitted by GeoServer to Oracle. It appears that many of the metadata queries are not logged. Oracle JDBC drivers support logging internally [2]. Has anyone tried this, and is it possible to enable this by

Re: [Geoserver-users] Issue with internal connection pooling for Oracle datastore with no schema name?

2015-09-01 Thread Martin Davis
e metadata queries. This is odd, since we are not seeing this happen in another similar environment. One difference is that we are connecting via an Oracle Service rather than a SID in the slow environment. Would be odd if this was the cause, though. On Fri, Jul 31, 2015 at 10:02 AM, Martin Da

Re: [Geoserver-users] Issue with internal connection pooling for Oracle datastore with no schema name?

2015-09-01 Thread Martin Davis
? On Tue, Sep 1, 2015 at 12:46 PM, Martin Davis <mtncl...@gmail.com> wrote: > An update on this issue. > > As Andrea predicted, using a JNDI connection made no difference to the > performance issue (no schema still substantially slower than using a > schema). > > On Fr

Re: [Geoserver-users] Issue with internal connection pooling for Oracle datastore with no schema name?

2015-09-01 Thread Martin Davis
gt; database online tests again, but they test conformance, not performance. > > -- > Jody Garnett > > On 1 September 2015 at 14:38, Martin Davis <mtncl...@gmail.com> wrote: > >> Yes, we are suspicious that the metadata queries are returning a lot of >> rows

Re: [Geoserver-users] Issue with internal connection pooling for Oracle datastore with no schema name?

2015-09-01 Thread Martin Davis
on? > > I would expect that to take a bit longer on startup ... but you are > indicating that every GetMap request is consistently slow. > > -- > Jody Garnett > > On 1 September 2015 at 12:46, Martin Davis <mtncl...@gmail.com> wrote: > >> An update on this iss

[Geoserver-users] Schemaless WFS spatial queries in GeoServer ?

2015-08-19 Thread Martin Davis
The WFS spec supports schemaless (or perhaps anonymous spatial queries against featuretypes via the BBOX parameter. But if a more complex query geometry is required (e.g. polygon), it's necessary to create a Filter, which then needs to have the spatial propertyname provided. This means that

Re: [Geoserver-users] Schemaless WFS spatial queries in GeoServer ?

2015-08-19 Thread Martin Davis
and asking it to return GML. -- Jody Garnett On 19 August 2015 at 13:04, Martin Davis mtncl...@gmail.com wrote: The WFS spec supports schemaless (or perhaps anonymous spatial queries against featuretypes via the BBOX parameter. But if a more complex query geometry is required (e.g. polygon

Re: [Geoserver-users] Performance issue with large polygon

2015-08-09 Thread Martin Davis
AFAIK there is no way to cache a layer in memory. This would be a useful feature to add to GeoServer. Perhaps you could cache the geometry as a shapefile - which should provide fastest performance off disk? It would be interesting to see what the performance boost is at any rate. I also wonder

Re: [Geoserver-users] Issue with internal connection pooling for Oracle datastore with no schema name?

2015-07-31 Thread Martin Davis
Aime andrea.a...@geo-solutions.it wrote: On Thu, Jul 30, 2015 at 7:56 PM, Martin Davis mtncl...@gmail.com wrote: We have the following GeoServer setup: Datastore to an Oracle 12c Exadata instance Internal connection pooling No schema specified What GEoServer version? We noticed

[Geoserver-users] Issue with internal connection pooling for Oracle datastore with no schema name?

2015-07-30 Thread Martin Davis
We have the following GeoServer setup: Datastore to an Oracle 12c Exadata instance Internal connection pooling No schema specified We noticed a serious performance anomaly, where each layer was taking about 4 s to render, even when the data was very small. When we switched to specifying an

Re: [Geoserver-users] Remove geometry from gml output WMS

2015-06-17 Thread Martin Davis
You might find this recent thread applicable: http://osgeo-org.1560.x6.nabble.com/Reduce-Geometry-size-in-GetFeatureInfo-responses-td5210228.html On Wed, Jun 17, 2015 at 3:23 PM, Leonardo Dobles hablecon...@gmail.com wrote: HI Is there a way to remove geometry field from the gml output in the

Re: [Geoserver-users] Reduce Geometry size in GetFeatureInfo responses?

2015-06-10 Thread Martin Davis
there would be some kind of query parameter that could be added to control how the geometry is returned in the response. On Wed, Jun 10, 2015 at 10:41 AM, Martin Davis mtncl...@gmail.com wrote: We're looking for ways to improve performance of Identify operations in a web map client (using

Re: [Geoserver-users] Reduce Geometry size in GetFeatureInfo responses?

2015-06-10 Thread Martin Davis
so tied to view map scale. We'll have to weigh the cost of a code enhancement versus the pain of other options... On Wed, Jun 10, 2015 at 10:57 AM, Andrea Aime andrea.a...@geo-solutions.it wrote: On Wed, Jun 10, 2015 at 7:41 PM, Martin Davis mtncl...@gmail.com wrote: We're looking for ways

Re: [Geoserver-users] Reduce Geometry size in GetFeatureInfo responses?

2015-06-10 Thread Martin Davis
- -- Martin Davis wrote: We're looking for ways to improve performance of Identify operations in a web map client (using OpenLayers). We are seeing poor performance due to the network latency of retrieving large GetFeatureInfo reponses. Is there any way to reduce the size

Re: [Geoserver-users] Reduce Geometry size in GetFeatureInfo responses?

2015-06-10 Thread Martin Davis
All good advice, but unfortunately not so easy to take advantage of in our environment. We allow all visible layers to be queried. This is why we prefer GetFeatureInfo to WFS, since it's sensitive to scale limits. The propertynames option is one way to do this, but we have hundreds of layers,

Re: [Geoserver-users] Oracle View Problem

2015-05-13 Thread Martin Davis
Have you tried creating a spatial function-based index on the table? http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_exten.htm#SPATL799 See the example 9.2.1 - it creates a function creating the geometry out of the X,Y values, and then uses that for indexing and querying. Hopefully

Re: [Geoserver-users] Oracle View Problem

2015-05-13 Thread Martin Davis
, which should be able to support a spatial index directly. On Wed, May 13, 2015 at 9:27 AM, Martin Davis mtncl...@gmail.com wrote: Have you tried creating a spatial function-based index on the table? http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_exten.htm#SPATL799 See the example

Re: [Geoserver-users] Questions about layer naming

2015-04-25 Thread Martin Davis
-solutions.it wrote: On Fri, Apr 24, 2015 at 9:42 PM, Martin Davis mtncl...@gmail.com wrote: Ok, how about: Names must be compatible with their use in OWS service requests and response documents. For general use, consider using only the characters: upper and lowercase letters, numbers, dash

Re: [Geoserver-users] Questions about layer naming

2015-04-24 Thread Martin Davis
. (I realized that semicolons probably cause issues in some situations - for instance, when workspaces are used) On Thu, Apr 23, 2015 at 11:14 PM, Andrea Aime andrea.a...@geo-solutions.it wrote: On Thu, Apr 23, 2015 at 9:47 PM, Martin Davis mtncl...@gmail.com wrote: Thanks. I found

Re: [Geoserver-users] Questions about layer naming

2015-04-24 Thread Martin Davis
Geoserver accepts and what kind of escaping is needed - What we can cascade with WMS? - What we can cascade with WFS? Before you accuse me, have a look at yourself. -Jukka Rahkonen- -- Andrea Aime wrote: On Fri, Apr 24, 2015 at 4:49 PM, Martin Davis

Re: [Geoserver-users] Questions about layer naming

2015-04-24 Thread Martin Davis
consider using is meant to indicate this is only a suggestion to avoid possible pain, not a validation rule. On Fri, Apr 24, 2015 at 12:32 PM, Andrea Aime andrea.a...@geo-solutions.it wrote: On Fri, Apr 24, 2015 at 7:55 PM, Martin Davis mtncl...@gmail.com wrote: Great, all good advice. I

[Geoserver-users] Questions about layer naming

2015-04-23 Thread Martin Davis
Is there any standard or best practice for the valid charset used for layer names? E.g. it seems like using URL-significant chars is not a good idea (comma, semicolon, amp, etc). If a layer is renamed from the default name (ie. the store resource name), is there any way in the UI to know what

Re: [Geoserver-users] Questions about layer naming

2015-04-23 Thread Martin Davis
... On Thu, Apr 23, 2015 at 10:13 AM, Andrea Aime andrea.a...@geo-solutions.it wrote: On Thu, Apr 23, 2015 at 6:59 PM, Martin Davis mtncl...@gmail.com wrote: Is there any standard or best practice for the valid charset used for layer names? E.g. it seems like using URL-significant chars is not a good

[Geoserver-users] Publish a table as two separate layers?

2015-04-22 Thread Martin Davis
What is the best way to publish a single table as two separate layers? Does this required defining a SQL View for one of the layers? It seems like the UI only allows publishing a table as a single layer via the Publish mechanism.

Re: [Geoserver-users] Publish a table as two separate layers?

2015-04-22 Thread Martin Davis
, Andrea Aime andrea.a...@geo-solutions.it wrote: On Wed, Apr 22, 2015 at 6:23 PM, Martin Davis mtncl...@gmail.com wrote: What is the best way to publish a single table as two separate layers? Does this required defining a SQL View for one of the layers? It seems like the UI only allows

[Geoserver-users] Layer Data Name VS Layer Publishing Name?

2015-04-22 Thread Martin Davis
Another perhaps obvious question... in the Edit Layer screen what is the difference between the Name field on the Data tab and the Name field on the Publishing tab? Are these the same data item, just exposed in two different places for convenience?

Re: [Geoserver-users] Publish a table as two separate layers?

2015-04-22 Thread Martin Davis
for this feature there. On Wed, Apr 22, 2015 at 9:47 AM, Andrea Aime andrea.a...@geo-solutions.it wrote: On Wed, Apr 22, 2015 at 6:43 PM, Martin Davis mtncl...@gmail.com wrote: Thanks - I just discovered this thread giving the same advice: http://osgeo-org.1560.x6.nabble.com/Using-two

Re: [Geoserver-users] Layer Data Name VS Layer Publishing Name?

2015-04-22 Thread Martin Davis
(the publish tab). In practice the two data structures have always been linked in the UI. I believe if you edit one it will update in both data structures. -- Jody Garnett On 22 April 2015 at 10:03, Martin Davis mtncl...@gmail.com wrote: Another perhaps obvious question... in the Edit

Re: [Geoserver-users] Slow WFS query against SDE?

2015-04-15 Thread Martin Davis
In it's useful for anyone, attached is a small test program that demonstrates the performance issue with computing statistics for SDE layers with spatial filters. On Thu, Apr 2, 2015 at 10:47 AM, Martin Davis mtncl...@gmail.com wrote: I've now identified the problem causing the slow WFS

Re: [Geoserver-users] Slow WFS query against SDE?

2015-04-15 Thread Martin Davis
now. On Thu, Apr 2, 2015 at 10:47 AM, Martin Davis mtncl...@gmail.com wrote: I've now identified the problem causing the slow WFS performance. As Andrea suspected, it is in the ArcSDEQuery.calculateResultCount() method, called before the WFS query queries the data. The issue is that (on our

Re: [Geoserver-users] Slow WFS query against SDE?

2015-04-07 Thread Martin Davis
On Thu, Apr 2, 2015 at 11:51 PM, Andrea Aime andrea.a...@geo-solutions.it wrote: On Thu, Apr 2, 2015 at 7:47 PM, Martin Davis mtncl...@gmail.com wrote: I've now identified the problem causing the slow WFS performance. As Andrea suspected, it is in the ArcSDEQuery.calculateResultCount

Re: [Geoserver-users] Slow WFS query against SDE?

2015-04-02 Thread Martin Davis
I've now identified the problem causing the slow WFS performance. As Andrea suspected, it is in the ArcSDEQuery.calculateResultCount() method, called before the WFS query queries the data. The issue is that (on our Oracle SDE instance at least) the SeQuery.calculateTableStatistics() call is

Re: [Geoserver-users] Slow WFS query against SDE?

2015-04-01 Thread Martin Davis
a debug GeoServer environment up and running, so I will be able to see what's going on. On Tue, Mar 31, 2015 at 11:12 PM, Andrea Aime andrea.a...@geo-solutions.it wrote: On Tue, Mar 31, 2015 at 10:48 PM, Martin Davis mtncl...@gmail.com wrote: An update on this issue, which I think

Re: [Geoserver-users] Slow WFS query against SDE?

2015-04-01 Thread Martin Davis
/blob/master/modules/plugin/arcsde/datastore/src/main/java/org/geotools/arcsde/data/ArcSDEQuery.java#L631 On Wed, Apr 1, 2015 at 8:47 AM, Martin Davis mtncl...@gmail.com wrote: Argh... that code snippet for the CORRECT use of spatial constraints should read: query = new SeQuery(conn, columns

Re: [Geoserver-users] Slow WFS query against SDE?

2015-03-31 Thread Martin Davis
path through the SDE driver result in a different statement order than the WFS path? And if so, how can this be fixed? On Tue, Mar 17, 2015 at 9:50 AM, Martin Davis mtncl...@gmail.com wrote: We have a GeoServer 2.6.0 connected to an SDE 10.2 backed by Oracle 11g. One layer is a grid layer

  1   2   3   >