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

2015-11-19 Thread cheesybiscuits
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 done that would increase complexity, deviate from GeoServer's UI philosophy, and consume lots of developer time, but that Andrea's original suggestion - to

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

2015-11-18 Thread cheesybiscuits
I've created a function within Oracle for on-the-fly clustering that I hoped to query via GeoServer using an SQL view layer. The function takes as its arguments the bounding box and the number of grid cells to use in a basic gridded clustering process (i.e. find the centre of mass for points

[Geoserver-users] Possible getFeatureInfo bug in 2.6.1

2014-12-31 Thread cheesybiscuits
I think I've discovered a bug in 2.6.1 but I need a second opinion. I upgraded to 2.6.1 from 2.2.5 so as far as I know the issue could have been introduced anywhere in between. I have a line layer in Oracle Locator 11gR2 with around 100,000 features (all 2-vertex lines, no line strings).

[Geoserver-users] Calculating CRS max extent

2014-10-23 Thread cheesybiscuits
Playing around with the 'Edit gridset' page under 'Tile Caching' in the GeoServer admin area I see that GWC / GeoServer is able to retrieve the maximum extent of the CRS set in this page. I'm interested in learning how this query is performed, and if I can use the same functionality in my own

Re: [Geoserver-users] curl not creating the desired datastore

2012-11-09 Thread cheesybiscuits
Yes I would expect your new command to work fine but there are a few possible explanations for why it might fail. 1) the target of your new path is different to your original relative path - I assume /var/www/geo/shapefile/csvQshp/ does actually contain shapefiles 2) you might be seeing

Re: [Geoserver-users] curl not creating the desired datastore

2012-11-07 Thread cheesybiscuits
Did you try using an absolute path? GeoServer needs to be able to find the group of files that make up the Shp, but your path is relative to your pwd in the shell. -- View this message in context:

Re: [Geoserver-users] Delegate authentication to separate application

2012-10-19 Thread cheesybiscuits
OK, I'm still a bit lost, I have a feeling it's simpler to use my application as a proxy and deny all access to GeoServer that doesn't originate from localhost. Appreciate the suggestion -- View this message in context:

[Geoserver-users] Delegate authentication to separate application

2012-10-18 Thread cheesybiscuits
I have a page in an existing Spring-based Java application that uses GeoServer (2.2) via WMS WFS, with requests originating from the client. Users have to authenticate with the Java application but currently GeoServer OWS services are accessed anonymously. This is changing, and now OWS services

[Geoserver-users] Where and how are well-known point symbols defined?

2012-09-21 Thread cheesybiscuits
Hopefully this is quick and easy question for someone with the knowledge. GeoServer lets me use well-known shapes for point symbols, e.g. circle square triangle etc. When rendering large numbers of features I have seen that these symbols are rendered much faster than external graphics. I am

Re: [Geoserver-users] Using the GeoWebCache seems to make the OpenLayers Overview Map stop working

2012-08-31 Thread cheesybiscuits
I know this is an old thread, but I just wanted to add some recent wisdom. If you set the correct min / max ratio on the overview map you can still use the cached service for it. The overview control has minRatio and maxRatio to specify the ratio of the main map area to the overview map area. If

Re: [Geoserver-users] 5 seconds to render 130, 000 points -typical GeoServer WMS performance?

2012-08-20 Thread cheesybiscuits
Christian, Andrea: I really appreciate you providing test results and putting in the effort to help me figure out what's going on. My next step is to test with a Shapefile data source, hopefully I will see much better results. Andrea: you said geowolf wrote GeoServer sets the fetch size to

Re: [Geoserver-users] 5 seconds to render 130, 000 points -typical GeoServer WMS performance?

2012-08-19 Thread cheesybiscuits
I agree that there is value in limiting what is rendered, but my current concern is whether what I'm seeing performance-wise indicates a problem in my GeoServer setup or is just normal behaviour. If there is an issue, and 130,000 should render quicker, then I might still see sub-optimal rendering

[Geoserver-users] 5 seconds to render 130, 000 points -typical GeoServer WMS performance?

2012-08-17 Thread cheesybiscuits
[GeoServer 2.1.3 (standard non-native JAI), Oracle (Locator) 11.1.2, CentOS 64-bit, Java 1.6] I'm working on a project that has previously mapped up to 50,000 point features and a similar number of line features connecting them. Performance from GeoServer has been great (two thumbs up). The

Re: [Geoserver-users] 5 seconds to render 130, 000 points -typical GeoServer WMS performance?

2012-08-17 Thread cheesybiscuits
Yukka: unfortunately yes, at this point it is necessary to draw all the points. I have to show their distribution so I can't hide some and show others as it would misrepresent the overall shape. As their locations frequently change it is not feasible to calculate any of this in advance and

Re: [Geoserver-users] 5 seconds to render 130, 000 points -typical GeoServer WMS performance?

2012-08-17 Thread cheesybiscuits
Andrea: thanks for your input. geowolf wrote Is the point symbolizer the only thing you have in the style? No text symbolizers for example? What version of GeoServer are you using? I am only using the default point symbolizer with no graphics, labels, filter rules, scale dependencies,

Re: [Geoserver-users] 5 seconds to render 130, 000 points -typical GeoServer WMS performance?

2012-08-17 Thread cheesybiscuits
Martin I really appreciate your suggestion on PointStacker. Unfortunately I can't try it until Monday now. The page didn't specify if you could aggregate conditionally (e.g. group by) which would be really useful, because then features could retain the right symbology. It seems like it was

Re: [Geoserver-users] REST create data store NullPointerException on second run

2012-07-11 Thread cheesybiscuits
Additional information in case it helps: The issue may be related to either the names of the Shapefiles I am configuring or the number of them ( 350). Shapefiles have a naming structure like tile(-94_5047275__38_330816__-94_0047275__38_830816)_leisure_polygon.shp I tried calling GeoServer's

Re: [Geoserver-users] Getting JSESSIONID whithout authentication

2012-06-25 Thread cheesybiscuits
I think I have a legitimate reason to ask the same question so hopefully there is an easy way to do this. I'm writing a .NET application that uses GeoServer and relies on Windows Authentication. I need to use GeoServer's role-based security but I can't ask the user to login using a GeoServer

[Geoserver-users] CQL injection - is it even possible?

2012-05-23 Thread cheesybiscuits
In a recent demo a developer in my company saw that we were using CQL filters in GeoServer, and saw how similar the syntax is to SQL, then started worrying about SQL / CQL injection. I assured him that as CQL filters are exposed by default I would be very surprised if this was even possible within

Re: [Geoserver-users] SLD drawing order

2012-05-22 Thread cheesybiscuits
Christian, I feel we're approaching an 'agree to disagree', but I'm curious - where are the guidelines suggesting that SLDs should only contain one active style at any scale? The specification permits multiple FeatureTypeStyle elements for a good reason - so that you can have multiple 'layers'

[Geoserver-users] Parametric view (Oracle) layeris very slow even though the query is fast

2012-05-15 Thread cheesybiscuits
I have a layer defined in GeoServer which uses a parametric view to Oracle (11.2.0.1, with Locator capabilities). The query I use to define the view is not particularly complex and when I run it directly against the DB it executes in well under 1 second. If I request a WMS map from this layer

[Geoserver-users] GetFeatureInfo JSON template - multiple feature collections and trailing commas

2012-05-09 Thread cheesybiscuits
I have created the following global template for my text/html GetFeatureInfo response and it's working great with one layer: { layer: { name: ${type.name?js_string}, features: [ #list features

Re: [Geoserver-users] What's the difference between LAYERS and QUERY_LAYERS parameters in GetFeatureInfo request?

2012-05-09 Thread cheesybiscuits
I know this is an old thread but I was thinking about how getFeatureInfo might work under the covers and Andrea's description of layer ordering and only querying what the user can see is what I would expect to happen. Regarding most servers just query all the layers without checking what is

Re: [Geoserver-users] SLD drawing order

2012-05-03 Thread cheesybiscuits
Unfortunately it's not always practical to aim for exactly one rule applying at any scale. For example a roads layer will usually show highways and residential roads at the same scale. In my WMS roads layer all road features are contained in a single Shapefile with an attribute indicating road

Re: [Geoserver-users] geoserver + oracle locator

2012-04-06 Thread cheesybiscuits
There could be multiple problems here, but this is a big one: You set the SRID to 4326 (WGS 84 Lat/Lon), but the coordinates you provided for your feature and your DIMINFO array are not using Lat/Lon. For 4326 to be the correct SRS all X ordinates would be within -180 to +180 and Y within -90 to

Re: [Geoserver-users] GeoWebCache geowebcache.xml bug? custom GridSet and applying it to a layer

2012-03-23 Thread cheesybiscuits
http://osgeo-org.1560.n6.nabble.com/file/n4650570/geowebcache.xml geowebcache.xml OK sorry I am also slow getting back to this, the tile cache is no longer at the top of my list but I still have to get this figured out. Hopefully you can access the geowebcache.xml file I uploaded to nabble. On

[Geoserver-users] GeoServer WFS in ArcMap via Data Interoperability Extension - ogc:filter errors

2012-03-09 Thread cheesybiscuits
I recognise that this is as much an ArcGIS question as it is GeoServer, so I will put something on the ESRI forums also, but I find the ESRI forums surprisingly poor for actually resolving ArcGIS problems. I am connecting ArcGIS (v10, SP3) to a GeoServer (2.1.3) WFS through its Data

Re: [Geoserver-users] GeoWebCache geowebcache.xml bug? custom GridSet and applying it to a layer

2012-03-02 Thread cheesybiscuits
That's great thanks Max, unfortunately I can't test this out until next week as I'm out of the office and have no remote access, but I'll update this thread with the outcome. If this is the issue it suggests the xml validation on configuration reload should be a bit stricter and more informative.

[Geoserver-users] GeoWebCache geowebcache.xml bug? custom GridSet and applying it to a layer

2012-03-01 Thread cheesybiscuits
I'm having trouble understanding how GeoWebCache and GeoServer fit together when it comes to new GridSets - this may be a bug but I'm not sure. I have defined a new GridSet which seems fine (no more messages in GeoServer's log when I reload geowebcache.xml). I found out here: