Re: [Geoserver-users] GetMap-request with CQL_FILTER too slow

Verzonden: donderdag 1 oktober 2015 21:04 Aan: Roel De Nijs CC: geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] GetMap-request with CQL_FILTER too slow On Thu, Oct 1, 2015 at 6:33 PM, Roel De Nijs mailto:roel.den...@aquafin.be>> wrote: Conclusion: so it seems for SQL Serve

Re: [Geoserver-users] Getting features intersecting with a polygon

Aan: Roel De Nijs CC: geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] Getting features intersecting with a polygon Hi Roel, yes, adding a ticket would not hurt. Is there anybody around with a more recent SQL server release that can perform similar tests? It would be great

Re: [Geoserver-users] GetMap-request with CQL_FILTER too slow

1370)) = 1 AND 1 = 1) So in the WHERE clause you now have only 1 spatial function. Each of these queries execute in 20-50ms! Which is again a huge performance improvement. Needless to say that the average time to execute a GetMap-request (at this zoom level) will be less as well: only 1400ms.

Re: [Geoserver-users] GetMap-request with CQL_FILTER too slow

regards, Roel De Nijs Senior Java Developer Van: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Namens Andrea Aime Verzonden: woensdag 30 september 2015 18:16 Aan: Roel De Nijs CC: geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] GetMap-request with CQL_FILTER too slow Hi

Re: [Geoserver-users] Limiting GetMap request using a Geometry

-td5226626.html Kind regards, Roel De Nijs Senior Java Developer Van: Martin Davis [mailto:mtncl...@gmail.com] Verzonden: dinsdag 10 februari 2015 19:08 Aan: Roel De Nijs CC: geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] Limiting GetMap request using a Geometry What is the

Re: [Geoserver-users] GetMap-request with CQL_FILTER too slow

09.05054760101, 79619.92994213104 202286.088612559, 79896.96800708795 202286.088612559, 79896.96800708795 202009.05054760101, 79619.92994213104 202009.05054760101))', 31370)) = 1) And to be absolutely sure, I verified the spatial index flag of the store again and it’s definitely true :)

Re: [Geoserver-users] GetMap-request with CQL_FILTER too slow

some further investigation tomorrow. But now it’s Champions League time :-) Kind regards, Roel Van: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Namens Andrea Aime Verzonden: dinsdag 29 september 2015 19:31 Aan: Roel De Nijs CC: geoserver-users@lists.sourceforge.net Onderwerp: Re

Re: [Geoserver-users] GetMap-request with CQL_FILTER too slow

71484)));INTERSECTS("geom", POLYGON ((116547.44384766 188202.28271484, 116547.44384766 188467.90722656, 116813.06835938 188467.90722656, 116813.06835938 188202.28271484, 116547.44384766 188202.28271484)))]] Kind regards, Roel De Nijs Senior Java Developer Van: andrea.a...@gmail.com [

[Geoserver-users] GetMap-request with CQL_FILTER too slow

come. I take anything I can get :-) And if it is a really specific issue, I'll try debugging some geoserver code. Kind regards, Roel De Nijs Senior Java Developer Volg Aquafin op Facebook<https://www.facebook.com/AquafinNV> | Twitter<https://twi

Re: [Geoserver-users] Getting features intersecting with a polygon

records in 5180ms c) Filter and STIntersects: 77729 records in 11604ms If it’s still useful, I will open a jira ticket in the next few days and share these results. Kind regards, Roel De Nijs Senior Java Developer Van: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Namens Andrea Aime Verzonden

Re: [Geoserver-users] download geoserver 2.7.2 war fails

Ah ok! Don’t need the downloads asap, so I’ll wait until SF fixes its issues. Van: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Namens Andrea Aime Verzonden: woensdag 29 juli 2015 12:22 Aan: Roel De Nijs CC: geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] download

[Geoserver-users] download geoserver 2.7.2 war fails

I'm trying to download the latest and greatest version of GeoServer from http://geoserver.org/release/stable/ but it seems every link results in an error message like "The "/GeoServer/2.7.2/geo..server-2.7.2-war.zip" file could not be found or is not available. Please select another file" Tried

Re: [Geoserver-users] Get legend from SLD with multiple user styles

s.it] Verzonden: maandag 15 juni 2015 15:00 Aan: Roel De Nijs CC: Andrea Aime; geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] Get legend from SLD with multiple user styles Hi Roel, you could try and access the SLD files in your workspace via the REST interface (remember t

Re: [Geoserver-users] Get legend from SLD with multiple user styles

), but without any success. Kind regards, Roel Van: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Namens Andrea Aime Verzonden: vrijdag 12 juni 2015 4:59 Aan: Roel De Nijs CC: Stefano Costa; geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] Get legend from SLD with multiple

Re: [Geoserver-users] Get legend from SLD with multiple user styles

ersion=1.0.0&format=image/png&strict=false&style=layerLegend&width=20&height=20&SLD=file:/styles/layer.sld Kind regards, Roel De Nijs Senior Java Developer Van: Stefano Costa [mailto:stefano.co...@geo-solutions.it] Verzonden: donderdag 4 juni 2015 15:24 Aan: Roel De Nijs C

[Geoserver-users] Get legend from SLD with multiple user styles

hic&version=1.0.0&format=image/png&strict=false&style=layerLegend&width=20&height=20&SLD=http://localhost:8080/geoserver/www/styles/layer.sld Is it possible to generate the legend of a 2nd (or 3rd) user style in an SLD without having to copy the sld into the www/style

[Geoserver-users] unknown layer after style change

nd regards, Roel De Nijs Senior Java Developer Volg Aquafin op Facebook<https://www.facebook.com/AquafinNV> | Twitter<https://twitter.com/aquafinnv> | YouTube<http://www.youtube.com/channel/UCk_4P5BJ-MtEEDCkCsR_KqQ?feature=mhee> | LinkedIN<

Re: [Geoserver-users] Getting features intersecting with a polygon

geowolf wrote > On Wed, Mar 18, 2015 at 5:38 PM, Roel De Nijs < > roel.denijs@ > > > wrote: > > Primary and secondary filter... the first one uses the spatial index, the > second does the in memory filtering. > Or has SQL Server learned to use the spatial index w

Re: [Geoserver-users] Getting features intersecting with a polygon

here-clause has two conditions: Filter and STIntersects? I would only expecte the STIntersects one. Kind regards, Roel De Nijs Senior Java Developer Van: Roel De Nijs [mailto:roel.den...@aquafin.be] Verzonden: woensdag 18 maart 2015 11:50 Aan: Mailinglist: Geoserver - Users Onderwerp: [Geoserver-

[Geoserver-users] Getting features intersecting with a polygon

METRY intersects POLYGON EMPTY ] typeName[0] = {JAGIS}gemeente outputFormat = text/xml; subtype=gml/3.1.1 resultType = results Kind regards, Roel De Nijs Senior Java Developer http://www.opengis.net/wfs"; xmlns="http://www.opengis.net/ogc";

Re: [Geoserver-users] web admin interface broken in geoserver

case of any > problems, cleaning temporaries is a first action. Caching is a > blessing and a curse ;-). > > best, > > Just > > On 24-02-15 14:22, Roel De Nijs wrote: >> After Richard’s reply I decided to start from scratch using a fresh >> data directory from the geoserver

Re: [Geoserver-users] web admin interface broken in geoserver

After Richard’s reply I decided to start from scratch using a fresh data directory from the geoserver 2.6.2 war. Deleted all demo workspaces and copied our workspaces from the old data directory. Restarted geoserver and all previously mentioned problems have vanished. I can preview layers again

[Geoserver-users] web admin interface broken in geoserver

nlikely to be a bug which nobody else has reported yet, so I'll probably have an issue with the data directory. Any pointers to look for? Because it makes the web admin interface almost unusable. I just tested with geoserver 2.5.5 and got the same errors. Kind regards, Roel De Nijs S

[Geoserver-users] web admin interface - sorting layers

nt to sort them on workspace, store and layer name. Kind regards, Roel De Nijs Senior Java Developer [Congres publieke ruimte]<http://www.congrespubliekeruimte.be> Volg Aquafin op Facebook<https://www.facebook.com/AquafinNV> | Twitter<https://twitter.

[Geoserver-users] Limiting GetMap request using a Geometry

ive... Kind regards, Roel De Nijs Senior Java Developer [Congres publieke ruimte]<http://www.congrespubliekeruimte.be> Volg Aquafin op Facebook<https://www.facebook.com/AquafinNV> | Twitter<https://twitter.com/aquafinnv> | YouTube<

Re: [Geoserver-users] primary key not showing in feature details

Hi, Ticking the ”Expose primary keys” checkbox in the datastore settings made the primary key column appear in the “Feature Type Details” section. Such a simple solution, but you have to know where to look :-) Thanks! Kind regards, Roel De Nijs Senior Java Developer Van: Rahkonen Jukka (MML

[Geoserver-users] primary key not showing in feature details

th Microsoft's jdbc drivers sqljdbc4-4.0.2206.100 and sqljdbc41-4.1.5605.100. Any ideas? A limitation on the name of a PK column? Kind regards, Roel De Nijs Senior Java Developer [Congres publieke ruimte]<http://www.congrespubliekeruimte.be>

Re: [Geoserver-users] SLD validation curio

StyledLayerDescriptor start-tag already takes 7 lines in the recent slds of style "line". Kind regards, Roel De Nijs Senior Java Developer Van: Rahkonen Jukka (Tike) [mailto:jukka.rahko...@mmmtike.fi] Verzonden: woensdag 8 oktober 2014 12:17 Aan: 'Jones, Spencer R'; 'geoserver-users@lists.s

[Geoserver-users] (gs 2.6.0) NullPointerException in LocalWorkspaceCatalogFilter

s, even on the same line. I added a snippet of the stack traces at the bottom for completeness. Is this a known issue? Or should I just create a bug report on JIRA? Kind regards, Roel De Nijs Senior Java Developer The stack trace when I try to remove a non-default style: java.lang.NullPointe

[Geoserver-users] (WPS) Caclulate the (center of) bbox of features

al to the bounding box returned by the first scenario when the first feature is no a Point geometry. 3/ Is it possible to get the center of this bounding box using another process? Kind regards, Roel De Nijs [banner Chap-eau]<http://www.chap-eau.be> Volg

Re: [Geoserver-users] Representing a SQL Server table with different types

the separate values) [1] http://osgeo-org.1560.x6.nabble.com/Publishing-a-geoserver-sql-view-more-than-once-td5159076.html Kind regards, Roel Van: Jonathan Moules [mailto:jonathanmou...@warwickshire.gov.uk] Verzonden: vrijdag 29 augustus 2014 9:10 Aan: Roel De Nijs CC: Jorge Sanz; rcefo Onderwe

[Geoserver-users] Publishing a geoserver sql view more than once?

Hi list, I want to create 1 parametrized sql view on geoserver and then define a bunch of layers (15+) based on this sql view, each layer using another value for the parameter(s) in this sql view. Is this possible? From a first attempt I'm inclined to say it seems to be not possible. But maybe

Re: [Geoserver-users] Representing a SQL Server table with different types

? Thoughts? Concerns? [1] http://docs.geoserver.org/stable/en/user/data/database/sqlview.html Kind regards, Roel Van: xurxos...@gmail.com [mailto:xurxos...@gmail.com] Namens Jorge Sanz Verzonden: maandag 25 augustus 2014 23:38 Aan: Roel De Nijs CC: geoserver-users ‎[geoserver-users@lists.sourcefo

[Geoserver-users] Representing a SQL Server table with different types

Hi list, We have a SQL Server spatial table node with a node_type column containing +-350K records. Currently we have +-15 different types; the records are not equally divided (the least common type 300 records vs the most common type 300K records). On different (zoom) levels of our map we need

Re: [Geoserver-users] Best GeoServer Features

1/ Friendly, helpful and very active community Great release management process Very simple/easy to setup Highly configurable using a web interface 2/ WFS, WMS, SqlServer database connection 3/ SqlServer database connection 4/ How easy it was to setup a geoserver and display your data, even with

Re: [Geoserver-users] [SLD] Labeling no repeat

label. So I’m a happy camper too. Thanks for the help! Van: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Namens Andrea Aime Verzonden: vrijdag 13 juni 2014 14:02 Aan: Roel De Nijs CC: GeoServer Mailing List List Onderwerp: Re: [Geoserver-users] [SLD] Labeling no repeat On Fri, Jun 13

Re: [Geoserver-users] [SLD] Labeling no repeat

geowolf wrote > What often happens is that what looks like a single line visually, is > actually a set of many lines in the > data set, each one with its own attributes, very common in road networks > for example, where > the road is cut at every crossing. > For those cases you should look at the g

[Geoserver-users] [SLD] Labeling no repeat

Hi list, According to the documentation [1] GeoServer labels each line only once. And if you want to repeat the label (for long lines) you should add the repeat vender option with a positive value (the number of pixels). That's not what I'm experiencing. In each of the following 3 scenarios I g

Re: [Geoserver-users] Some CSS newbie questions

23 april 2014 18:26 Aan: Roel De Nijs CC: geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] Some CSS newbie questions On Wed, Apr 23, 2014 at 6:16 PM, Roel De Nijs mailto:roel.den...@aquafin.be>> wrote: Good afternoon, Sometimes SLDs can be quite tedious, so I started

[Geoserver-users] Some CSS newbie questions

tf://Times+New+Roman#0x19b2'); instead (that's what I used in the original SLD as well), it works like a charm. Could it be a flaw in the documentation? [1] http://docs.geoserver.org/latest/en/user/extensions/css/values.html Kind regards, Roel De Nijs @javaroe Senior Java Develo

[Geoserver-users] GetFeature, viewparams & 2 layers

as a geoserver 2.5 snapshot. Both requests result in the above mentioned exception. Is this a known issue/bug? Kind regards, Roel De Nijs @javaroe Senior Java Developer Volg Aquafin op Facebook<https://www.facebook.com/AquafinNV> | Twitter<https://tw

Re: [Geoserver-users] GetFeature feature duplicates

That issue sounds very familiar to me: http://sourceforge.net/p/geoserver/mailman/message/31385805/ Just add service=wfs to the request and GetFeature won’t return duplicates anymore. Van: Andrea Aime [mailto:andrea.a...@geo-solutions.it] Verzonden: maandag 21 april 2014 16:10 Aan: GeoUser CC:

Re: [Geoserver-users] Issue with GeoWebCache when GeoServer style is tied to a workspace. GS 2.5B

For what it’s worth: I noticed the same behavior in geoserver 2.4.0 Is there some kind of workaround? Or is not tying the style to the workspace the best option you have? Van: Shane StClair [mailto:sh...@axiomalaska.com] Verzonden: dinsdag 8 april 2014 20:33 Aan: geoserver-users@lists.sourceforg

Re: [Geoserver-users] WFS post & viewparams

ms to the GetFeature post-request. Fingers crossed! Kind regards, Roel Van: maurobartolome...@gmail.com [mailto:maurobartolome...@gmail.com] Namens Mauro Bartolomeoli Verzonden: dinsdag 15 april 2014 14:41 Aan: Roel De Nijs CC: geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserv

[Geoserver-users] WFS post & viewparams

Hi all, Is geoserver able to handle viewparams in a WFS post-request? If it is, how should the WFS-request be built? Because I tried a few different requests, but unfortunately without success. Kind regards, Roel Volg Aquafin op Facebook

[Geoserver-users] Correct location of log4j config files?

For sorting out another issue I had to change my log4jConfigFile. This resulted in the following warning. I only had the PRODUCTION_LOGGING.properties in "dataDir/logs", so the warning is definitely spot-on! 2014-04-03 11:35:35,401 WARN [geoserver.logging] - log4jConfigFile 'GEOTOOLS_DEVELOPER_

Re: [Geoserver-users] geoserver 2.5 & viewparams

anslations to/from the sql server dialect. Is this a correct assumption? Kind regards, Roel Van: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Namens Andrea Aime Verzonden: woensdag 2 april 2014 20:05 Aan: Roel De Nijs CC: geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geose

[Geoserver-users] geoserver 2.5 & viewparams

Hi all, Today I upgraded our geoserver 2.4 instance to the latest stable version (2.5). After this upgrade I noticed our wms-requests using viewparams (SQL-view based layers) just return empty tiles. Same happens when you preview the layer using e.g. openlayers. Executing exactly the same reque

Re: [Geoserver-users] Why does GetFeature return feature 5 times?

Rahkonen Jukka wrote > Geoserver could do schema validation and be strict but that would mean > that your service=wfs would also fail because it should be service=WFS. > And getfeature would fail because it is officially GetFeature. That would > make some users to say that Geoserver is nit-picky. T

Re: [Geoserver-users] Why does GetFeature return feature 5 times?

I upgraded geoserver to the latest 2.4.0 release, unfortunately this issue still occurs. I was able to do some extra tests now and I guess I found the cause (and also a solution). For some reason the PROPERTYNAME parameter influences the size of the feature collection. When this parameter contains

[Geoserver-users] PropertyIsBetween throws NPE after upgrading to GeoServer 2.3.5

When an SLD (containing a rule with a PropertyIsBetween filter) is applied on a layer using GeoServer 2.1.1 the layer is rendered nicely. If this SLD is applied on the same layer using GeoServer 2.3.5 the layer is not rendered and the following error is logged: Caused by: java.lang.NullPointerExcep

Re: [Geoserver-users] Why does GetFeature return feature 5 times?

geowolf wrote > You'll have to be more specific to have any chance to get an answer. Are > you using app-schema in your feature type? > Can you provide a detailed description of how that feature type is setup? No, we are not using app-schema plugin. All our layers (feature types) are based on tabl

[Geoserver-users] Why does GetFeature return feature 5 times?

When I execute the GetFeature request [1] against a geoserver 2.1.1 instance I get a gml-string with just 1 feature in the feature-collection (as expected). When I execute the same request against a geoserver 2.3.5 instance the feature collection contains this feature 5 times for some reason. [

Re: [Geoserver-users] SLD: Best practices

geowolf wrote > I don't think there is any solution that satisfies the third requirement. > Not without > developing new features in the legend bulding code at least. The third requirement is just a nice to have. We'll settle for any solution which has a better maintainability than a very large SL

Re: [Geoserver-users] SLD: Best practices

Jonathan Moules-2 wrote > I've never used it myself, but perhaps the CSS module (soon to be > extension > maybe) will let you do what you want. It seems to be more terse than the > very-verbose SLD files. > > http://docs.geoserver.org/stable/en/user/extensions/css/index.html?highlight=css Great a

[Geoserver-users] SLD: Best practices

We have a layer with +- 350K records and the point features are rendered based on 2 attributes: 1 has 10 distinct values and defines the symbol (mark), the other one has 12 distinct values and defines the color. Now we have 1 big SLD with +- 3200 lines and because of its size the SLD is hard to ma

Re: [Geoserver-users] GetFeature request extremely slow after upgrade to GeoServer 2.3.3

geowolf wrote > Have no idea there, haven't used sql server in months. > This would require some investigation inside the code, but I have no time > to do that right now > outside of working hours. Today I did all kinds of tests: - Created 2 layers from scratch to verify it had nothing to do with

Re: [Geoserver-users] GetFeature request extremely slow after upgrade to GeoServer 2.3.3

geowolf wrote > Yes, if you look into the store config panel you should find a "disable > native paging" flag In the store config panel I have a "use native paging" flag which was not checked, so I guess it shouldn't have generated these paging queries in the 1st place. When I created a new store

[Geoserver-users] GetFeature request extremely slow after upgrade to GeoServer 2.3.3

After upgrading to GeoServer 2.3.3 (from version 2.1.1) a GetFeature request is taking several minutes to complete. When using version 2.1.1 the same request took 300-500ms which is already a little bit slow (definitely for our use case). Certainly if you compare with the time needed to render a

Re: [Geoserver-users] SLD: WellKnownName based on property?

geowolf wrote > Yes, of course, we cannot scan the whole data set just to generate the > legend, that would take ages > (I've played with vector dataset with up to 50 million records... do you > really want to scan them to generate a legend?) > For these cases we cannot scan the whole dataset, or e

Re: [Geoserver-users] SLD: WellKnownName based on property?

cified mark ${Concatenate('ttf://ourfont#0x', vorm)} was not found! [1] http://docs.geoserver.org/stable/en/user/styling/sld-extensions/pointsymbols.html Van: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Namens Andrea Aime Verzonden: woensdag 17 juli 2013 16:

Re: [Geoserver-users] SLD: WellKnownName based on property?

I also tried this with no success (where property "vorm" contains the correct values): vorm Van: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Namens Andrea Aime Verzonden: woensdag 17 juli 2013 16:52 Aan: Roel De Nijs CC: geoserver-users@lists.sourceforge.net Onder

[Geoserver-users] SLD: WellKnownName based on property?

Is it possible to have the WellKnownName of a mark be dependent on a property name (or using the recode filter function)? Based on a few experiments I think it's not possible... Volg Aquafin op Facebook | Twitter

Re: [Geoserver-users] SLD: open arrow on center of end segment?

Jonathan, Thanks! That was the missing piece of the puzzle. Works like a charm! Regards, Roel Van: Jonathan Moules [mailto:jonathanmou...@warwickshire.gov.uk] Verzonden: dinsdag 16 juli 2013 17:43 Aan: Roel De Nijs CC: geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] SLD

[Geoserver-users] SLD: open arrow on center of end segment?

I'm using GeoServer 2.3.3 and I created a point symbolyzer which puts an open arrow on the end point of a line. This works great and is lightning fast. But I wonder if it's somehow possible to put the arrow at the center of the end segment instead of the end point? Even better (for our use case)

Re: [Geoserver-users] Points of LinearRing do not form a closed linestring

Onderwerp: Re: [Geoserver-users] Points of LinearRing do not form a closed linestring Hi, GML coordinates tend to include commas 0,0 100,0 100,100 0,100 0,0 In addition, you are using WFS 1.1.0 which defaults to GML3 which considers coordinates as deprecated. Is is not strictly forbidden, I b

[Geoserver-users] Points of LinearRing do not form a closed linestring

Hello, I'm trying to send a GetFeature (post) request using a Filter. But I keep getting the above error and I have no clue about the cause of the issue (because it's closed). If I create a LinearRing using JTS and the same coordinates the Geometry is created without any errors. The request I try

[Geoserver-users] Adding geographical restrictions to each request

Hi, We have a web application showing sewerage data using geoserver 2.1.1 and OpenLayers 2.11. Some of our users should be restricted to a city or some other region. We created a proxy before geoserver which accepts all requests made by OpenLayers. Based on the user a CQL_FILTER ("within(the_g