Aan: Roel De Nijs <roel.den...@aquafin.be>
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
s
Verzonden: donderdag 1 oktober 2015 21:04
Aan: Roel De Nijs <roel.den...@aquafin.be>
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
<roel.den...@aquafin.be<mailto:roel.den..
nly 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.
Conclusion: so it seems for SQL Server 2008 R2 it would
94213104 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 :)
true
Kind regards,
Roel De N
-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 <roel.den...@aquafin.be>
CC: geoserver-users@lists.sourceforge.net
Onderwerp: Re: [Geoserver-users] Limiting GetMap request
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 <roel.den...@aquafin.be>
CC: geoserver-users@lists.sourceforge.net
Onderwerp: Re: [Geoserver-users] GetMap-r
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 <roel.den...@aquafin.be>
CC: geoserver
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 [mai
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
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 it
), 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
: 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 to tune the REST security
=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
CC: geoserver-users@lists.sourceforge.net
Onderwerp: Re: [Geoserver-users] Get legend from SLD with multiple
,
Roel De Nijs
Senior Java Developer
Volg Aquafin op Facebookhttps://www.facebook.com/AquafinNV |
Twitterhttps://twitter.com/aquafinnv |
YouTubehttp://www.youtube.com/channel/UCk_4P5BJ-MtEEDCkCsR_KqQ?feature=mhee |
LinkedINhttp://www.linkedin.com/company/aquafin
geowolf wrote
On Wed, Mar 18, 2015 at 5:38 PM, Roel De Nijs lt;
roel.denijs@
gt;
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 when just seeing
STIntersects
]
typeName[0] = {JAGIS}gemeente
outputFormat = text/xml; subtype=gml/3.1.1
resultType = results
Kind regards,
Roel De Nijs
Senior Java Developer
wfs:GetFeature service=WFS version=1.1.0
xmlns:wfs=http://www.opengis.net/wfs;
xmlns=http://www.opengis.net
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-users] Getting features intersecting with a polygon
Hi list,
We are using GeoServer 2.6.2 and I want
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 2.6.2 war. Deleted all demo
workspaces and copied our workspaces
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
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
Senior Java Developer
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 Facebookhttps://www.facebook.com/AquafinNV |
Twitterhttps://twitter.com/aquafinnv |
YouTubehttp
,
Roel De Nijs
Senior Java Developer
[Congres publieke ruimte]http://www.congrespubliekeruimte.be
Volg Aquafin op Facebookhttps://www.facebook.com/AquafinNV |
Twitterhttps://twitter.com/aquafinnv |
YouTubehttp://www.youtube.com/channel/UCk_4P5BJ-MtEEDCkCsR_KqQ
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
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
Volg Aquafin op Facebookhttps://www.facebook.com
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.NullPointerException
. The 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.sourceforge.net
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 Aquafin op
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
-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
Onderwerp: Re: [Geoserver-users] Representing
? 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
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
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
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
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
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
roel.den...@aquafin.bemailto:roel.den...@aquafin.be wrote:
Good afternoon,
Sometimes SLDs can be quite tedious
)
at java.lang.reflect.Method.invoke(Unknown Source)
I tried it on both geoserver 2.4.0 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 Facebookhttps
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 Developer
Volg Aquafin op Facebookhttps
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:
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
if OpenLayers is able to add the viewparams 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
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:
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: [Geoserver-users
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
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
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. Try
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
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.
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 tables
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:
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
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
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
Nijs
CC: geoserver-users@lists.sourceforge.net
Onderwerp: Re: [Geoserver-users] SLD: WellKnownName based on property?
On Wed, Jul 17, 2013 at 4:36 PM, Roel De Nijs
roel.den...@aquafin.bemailto:roel.den...@aquafin.be wrote:
Is it possible to have the WellKnownName of a mark be dependent on a 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 even
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
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
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 Facebookhttps://www.facebook.com/AquafinNV |
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
Onderwerp: Re: [Geoserver-users] SLD: WellKnownName based on property?
On Wed, Jul 17, 2013 at 4:36 PM, Roel De Nijs
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
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
considers
coordinates as deprecated. Is is not strictly forbidden, I believe, but it
would be better not to mix GML2 and GML3 dialects. Thus, use gml:posList.
-Jukka Rahkonen-
Roel De Nijs wrote:
Hello,
I'm trying to send a GetFeature (post) request using a Filter. But I keep
getting the above
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
62 matches
Mail list logo