[Geoserver-devel] Custom Database-backed Filter Functions

2023-09-25 Thread Carsten Klein
Hi there, I'd like to use some custom PostgreSQL functions as filters in standard WFS 2.0.0 requests. The goal is to request features filtered by e.g. Full Text Search or the word_similarity function provided by the pg_trgm extension (Trigram/Trigraph support). Since WFS only provides a quit

Re: [Geoserver-devel] Custom Database-backed Filter Functions

2023-09-26 Thread Carsten Klein
gt; You can see the mapping being done from the GeoTools function data structure (which is why you need a java implementation) to the SQL. -- Jody Garnett On Sep 25, 2023 at 11:23:00 PM, Carsten Klein wrote: Hi there, I'd like to use some custom PostgreSQL functions as filters in standa

Re: [Geoserver-devel] Custom Database-backed Filter Functions

2023-10-02 Thread Carsten Klein
lso normally not a big deal because the description of functions in WFS capabilities is so poor that clients cannot automatically use them anyways, clients using functions are usually written by hand anyways. Cheers Andrea On Tue, Sep 26, 2023 at 9:01 AM Carsten Klein wrote: Hi Jody, t

Re: [Geoserver-devel] Custom Database-backed Filter Functions

2023-10-02 Thread Carsten Klein
"SqlEncodable" could do that job? Cheers Carsten Am 02.10.2023 um 10:03 schrieb Andrea Aime: On Mon, Oct 2, 2023 at 9:05 AM Carsten Klein wrote: I managed to add a simple function "add", which returns the sum of both its Double arguments. The add function follows t

Re: [Geoserver-devel] Custom Database-backed Filter Functions

2023-10-02 Thread Carsten Klein
Andrea, There is nothing planned to support this functionality. We are more interested in nudging people to contribute open code to benefit everyone. Unless you're going to write functions that are very specific to your case, and would not be of interest to the larger community? Maybe I didn

Re: [Geoserver-devel] Custom Database-backed Filter Functions

2023-10-02 Thread Carsten Klein
Another idea: Couldn't there be a more extensible way to declare a SPI provided function "SQL encodable" for a certain Store (e.g. PostGIS)? Maybe a tag interface "SqlEncodable" could do that job? No, it does not make sense... a filter may be sql encodable in one database, but not

Re: [Geoserver-devel] Custom Database-backed Filter Functions

2023-10-23 Thread Carsten Klein
Hi Andrea, hi Jody, any progress here? For me, the interface-based approach seems quite simple and is likely easy to implement. What do you think about it? Would be great if we could get things moving... Cheers Carsten ___ Geoserver-devel mailing li

Re: [Geoserver-devel] Custom Database-backed Filter Functions

2023-10-24 Thread Carsten Klein
at, without somehow extending FunctionName to support JDBC encoding (which sounds like it would be another bad idea). Jody, any other suggestion? Cheers Andrea On Tue, Oct 24, 2023 at 8:10 AM Carsten Klein wrote: Hi Andrea, hi Jody, any progress here? For me, the interface-based app

Re: [Geoserver-devel] Custom Database-backed Filter Functions

2023-12-04 Thread Carsten Klein
Hi Andrea, what's next with the SQL-encodable filter functions. You said I'll let the other core developers chime in and help with a decision. Is there anything new? Do you expect me to issue a Jira CR? Or even a ready to use patch? I'd much appreciate if someone of the core devs could mak

Re: [Geoserver-devel] Custom Database-backed Filter Functions

2023-12-07 Thread Carsten Klein
Hi Jody, yes, the change must be applied in GeoTools. Shall I write such a proposal as a New Feature (or Wish) in Jira for the GeoTools (GEOT) project? -- Carsten Klein Am 07.12.2023 um 17:38 schrieb Jody Garnett: I think this needs a geotools proposal to gather the results of this thread

Re: [Geoserver-devel] Custom Database-backed Filter Functions

2023-12-08 Thread Carsten Klein
ack. Jody On Thu, Dec 7, 2023 at 8:50 AM Carsten Klein wrote: Hi Jody, yes, the change must be applied in GeoTools. Shall I write such a proposal as a New Feature (or Wish) in Jira for the GeoTools (GEOT) project? -- Carsten Klein Am 07.12.2023 um 17:38 schrieb Jody

Re: [Geoserver-devel] Custom Database-backed Filter Functions

2023-12-12 Thread Carsten Klein
Hi Jody and list members, here's the link to the new proposal *SQL Encoding of Vendor‐Provided Custom Functions* https://github.com/geotools/geotools/wiki/SQL-Encoding-of-Vendor%E2%80%90Provided-Custom-Functions Hope that everything is in place. Cheers Carsten

Re: [Geoserver-devel] GeoServer/GeoTools PMC Meeting at 18:30 CET / 9:30 PST tomorrow

2024-01-16 Thread Carsten Klein
Hi, could you please add this to today's agenda: * Review/have a look at my GeoTools proposal "SQL Encoding of Vendor‐Provided Custom Functions" available at https://github.com/geotools/geotools/wiki/SQL-Encoding-of-Vendor%E2%80%90Provided-Custom-Functions Many thanks in advance, Carst

[Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-09-13 Thread Carsten Klein
Hello everyone, I'd like to enhance WFS responses in JSON/JSONP format. In some of our Web GIS Applications, one may download up to several thousand Simple Features through WFS. Some Layers may have between 400 and 500 columns. Although JSON produces much smaller responses than XML/GML, such

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-09-13 Thread Carsten Klein
Hi Ian and Andrea, thanks for your input and recommendations. I'll try to create a community extension (using flatgeobuf and others as a starting point / boilerplate). I'm using Eclipse and still struggling with Maven. However, things are moving... I will also have a look at the flatgeobuf f

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-09-14 Thread Carsten Klein
Hello there, now, I've managed to setup a community module project with Maven, created and Eclipse project, which I additionally linked to project 'gs-wfs', so I can make changes to the existing GeoJSON producer Andrea mentioned. After linking my new project 'gs-compactjson' to project 'gs-w

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-09-14 Thread Carsten Klein
pos = format.indexOf(';'); return pos != -1 ? format.substring(0, pos).trim() : format; } On Wed, Sep 14, 2022 at 12:41 PM Mark Prins wrote> On 14-09-2022 10:57, Carsten Klein wrote: this.LOGGER = logger != null ? logger     : org.geotools.util.logging.Logging.getLog

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-09-22 Thread Carsten Klein
Hello there, the new WFS output format CompactJSON, implemented as a community extension, is ready and works as expected. With our mentioned WFS responses (1.000+ features, 450 columns each), compared to standard GeoJSON, savings are between ~30% and ~70% (uncompressed) and between ~20% and ~

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-10-06 Thread Carsten Klein
final version of the PR should be OK for merging. There are still some issues with QA checks and build checks (a test failed on Mac). I've written some more remarks on that in the PR on GitHub. Cheers Carsten On Thu, Sep 29, 2022 at 10:17 AM Andrea Aime wrote On Thu, Sep 22, 2022 at 10:08

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-10-06 Thread Carsten Klein
source projects for collecting more opinions and suggestions. A short announcement on the gdal-dev mailing list might be a good start. -Jukka Rahkonen- -Alkuperäinen viesti- Lähettäjä: Carsten Klein Lähetetty: torstai 6. lokakuuta 2022 16.47 Vastaanottaja: Andrea Aime Kopio: geoserv

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-10-06 Thread Carsten Klein
polite to contact the authors of the GeoJSON specification and ask their opinion. All the authors are named in the beginning of the RFC document but maybe Howard Butler or Sean Gilles are the best first contacts. Otherwise it is fine for me if you prefer to write your format just by yourself. -Jukk

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-10-07 Thread Carsten Klein
hobu” and “sgillies” in GitHub and see what happens. -Jukka Rahkonen- *Lähettäjä:* Andrea Aime *Lähetetty:* perjantai 7. lokakuuta 2022 10.57 *Vastaanottaja:* Carsten Klein *Kopio:* Rahkonen Jukka ; geoserver-devel@lists.sourceforge.net; bj...@wololo.org *Aihe:* Re: [Geoserver-devel] E

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-10-10 Thread Carsten Klein
neric term it probably could not obtain a trademark, and other efforts calling themselves something that looks like it could not be stopped in any official capacity anyway. In closing, you can call it what you like. Naming things is really hard :) Howard On Oct 10, 2022, at 1:31 AM, Carsten Klein

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-10-12 Thread Carsten Klein
order to build the plugin Zip files? Cheers Carsten Am 12.10.2022 um 09:46 schrieb Andrea Aime: All the names work for me, if you like SpatialJSON go for it. Let's get this one rolling :-D Cheers Andrea On Tue, Oct 11, 2022 at 8:07 AM Carsten Klein wrote: Hello Andrea and

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-10-14 Thread Carsten Klein
that builds all the documentation. Cheers Carsten Am 12.10.2022 um 14:11 schrieb Andrea Aime: On Wed, Oct 12, 2022 at 10:48 AM Carsten Klein wrote: OK, I will go for SpatialJSON. I will now do the following: * Rename all items according to SpatialJSON * Throw an excepti

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-10-14 Thread Carsten Klein
erate PDFs) Cheers Andrea On Fri, Oct 14, 2022 at 10:12 AM Carsten Klein wrote: Hi Andrea, thanks for the advice. I can now test building the zip archives. What about documentation? I'd like to test my *.rst files? Sorry for asking so much, but I did not find anything abo

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-10-15 Thread Carsten Klein
OK, will do so :) Am 15.10.2022 um 16:35 schrieb Jody Garnett: Yes, we made folders for different languages. If you like that is an excellent single line fix you could do; there is a procedure for doing quick fixes in the doc guide. On Fri, Oct 14, 2022 at 2:12 AM Carsten Klein wrote

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-10-17 Thread Carsten Klein
schrieb Andrea Aime: See the documentation guide: https://docs.geoserver.org/latest/en/docguide/ (you can skip the Latex part, that's needed only to generate PDFs) Cheers Andrea On Fri, Oct 14, 2022 at 10:12 AM Carsten Klein wrote: Hi Andrea, thanks for the advice. I can now

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-10-17 Thread Carsten Klein
ch I did not see so far (like ServletContext.set/getAttribute)? Cheers Carsten Am 12.10.2022 um 14:11 schrieb Andrea Aime: On Wed, Oct 12, 2022 at 10:48 AM Carsten Klein wrote: OK, I will go for SpatialJSON. I will now do the following: * Rename all items according to Spati

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-10-20 Thread Carsten Klein
See my answers inline: Am 20.10.2022 um 13:05 schrieb Andrea Aime: On Tue, Oct 18, 2022 at 7:28 AM Carsten Klein wrote: Hello Andrea, prior to porting back, I'd like to make another change. I'd like to have a context/storage to share data between methods encodeSimp

Re: [Geoserver-devel] Enhancement: WFS Simple Feature Response in new more compact JSON/JSONP format

2022-11-03 Thread Carsten Klein
s a quite complex system and new to me (I'm doing this for the first time). I want to do it the right way now and as well for future contributions, but still feel kind of lost... :-p Cheers Carsten -- Carsten Klein Lead Software Engineer DataGis GmbH Johann-Strauß-Str. 26 70794 Fild

Re: [Geoserver-devel] so what transfix do we use?

2022-11-07 Thread Carsten Klein
Could do the German translation. Are you fine with (sparse) usage of ... tags? In English you can emphasize a word using capitalization. Since in German nouns always start with a capital letter, stronger emphasizing techniques are required sometimes. Not using any tool. An editor and Git is

Re: [Geoserver-devel] so what transfix do we use?

2022-11-08 Thread Carsten Klein
Hello there, I've translated the new welcome page messages (e. g. GeoServerHomePage.description[...]) into German. Like these as a separate commit/PR? Or... I could also translate some more of the commented out messages in the German locale files. Furthermore, I think about editing some of

Re: [Geoserver-devel] so what transfix do we use?

2022-11-09 Thread Carsten Klein
ening label to fit UI). Even if folks do not respond today; they can find the topic later. -- Jody Garnett On Tue, 8 Nov 2022 at 06:16, Carsten Klein wrote: Hello there, I've translated the new welcome page messages (e. g. GeoServerHomePage.description[...]) into German. Like

[Geoserver-devel] Completing and Updating German translation

2022-11-15 Thread Carsten Klein
uot;Veröffentlichung", which I guess is the more common term in German. However, this change may not be part of the first batch of German translation changes. The 2.22.0 release is scheduled for Friday, November 18th. In turn, I will issue the first PR on that on Thursday, November 17th. So, plea

Re: [Geoserver-devel] Completing and Updating German translation

2022-11-15 Thread Carsten Klein
consistency... Tomorrow, I could commit my changes to a temporary branch in my own repo. You and others could then compare my changes to the original version of the language file in order to get a rough idea of what I'm actually doing :) Greets Carsten Am 15.11.2022 um 17:23 schrieb Marc

Re: [Geoserver-devel] Completing and Updating German translation

2022-11-15 Thread Carsten Klein
, please find some comments inline. Am 15.11.22 um 13:04 schrieb Carsten Klein: Hello GeoServer devs and German translators, as recommended by Jody Garnett, I've translated the new messages on the welcome page for the 2.22.0 release. After that, I started to complete the German translatio

Re: [Geoserver-devel] Completing and Updating German translation

2022-11-16 Thread Carsten Klein
Jansen: Hi Carsten, list, please find some comments inline. Am 15.11.22 um 13:04 schrieb Carsten Klein: Hello GeoServer devs and German translators, as recommended by Jody Garnett, I've translated the new messages on the welcome page for the 2.22.0 release. After that, I start

Re: [Geoserver-devel] Completing and Updating German translation

2022-11-16 Thread Carsten Klein
Hi there, now, theres a (local) PR in my repo to show, primarily to German translators, how I'm updating German translation. https://github.com/cklein05/geoserver/pull/2 I will soon add in a PR comment that describes, what's already finished and what not. Have a look at the changed files to

Re: [Geoserver-devel] Completing and Updating German translation

2022-11-16 Thread Carsten Klein
0) An: Carsten Klein Cc: Marc Jansen , geoserver-devel@lists.sourceforge.net Betreff: Re: [Geoserver-devel] Completing and Updating German translation Andrea is starting the release process tomorrow with geotools; so please make your PR and backport as soon as possible!--Jody GarnettOn Wed, 16 Nov 20

Re: [Geoserver-devel] Completing and Updating German translation

2022-11-16 Thread Carsten Klein
some things a bit easier). Cheers Carsten Am 16.11.2022 um 21:08 schrieb Carsten Klein: PR against main will be available tomorrow, 7:30 CET. I can't add labels, so please, someone should kick off backports (2.22.x should be sufficient) Carsten Von meinem/meiner Galax

Re: [Geoserver-devel] Completing and Updating German translation

2022-11-16 Thread Carsten Klein
backported. -- Jody Garnett On Wed, 16 Nov 2022 at 22:13, Carsten Klein wrote: Final PR #6359 /German Translation Overhaul Part 1/ is now available and all green. https://github.com/geoserver/geoserver/pull/6359 Please backport someone to 2.22.x, as I

Re: [Geoserver-devel] Some troubles with the GeoServer release

2022-11-18 Thread Carsten Klein
I expect that as a normal user jenkins cannot change ownership of a file (w access for the group is not sufficient for chown?) In Linux, only root can change ownership. Maybe you could sudo? Carsten Am 18.11.2022 um 17:32 schrieb Jody Garnett: Updated the Personal Access Token, I note the chm

[Geoserver-devel] Transifex Questions

2022-11-19 Thread Carsten Klein
d and backported. -- Jody Garnett On Wed, 16 Nov 2022 at 22:13, Carsten Klein wrote: Final PR #6359 /German Translation Overhaul Part 1/ is now available and all green. https://github.com/geoserver/geoserver/pull/6359 Please backport someone to 2.22.

Re: [Geoserver-devel] Transifex Questions

2022-11-19 Thread Carsten Klein
week before the release. Did you make some changes you cannot find? Alexandre Le sam. 19 nov. 2022 à 11:56, Carsten Klein a écrit : Hello there, is it correct, that new latest/current translations are in the /GeoServer GitHub Integration/ project? If so, Alexandre, didn'

[Geoserver-devel] [JIRA] (GEOS-8206) WMS 1.3.0 Axis ordering for non-geographic coordinate systems

2017-06-30 Thread Carsten Klein (JIRA)
Title: Message Title Carsten Klein

[Geoserver-devel] [jira] (GEOS-6710) GeoServer 2.6.0 leaves PostgreSQL transactions open

2014-10-06 Thread Carsten Klein (JIRA)
Title: Message Title Carsten Klein created an issue

[Geoserver-devel] [JIRA] (GEOS-8984) Different handling of empty strings and NULL values passed through WFS-T update requests

2018-10-24 Thread Carsten Klein (JIRA)
Reporter: Carsten Klein

[Geoserver-devel] [JIRA] (GEOS-10708) SpatialJSON WFS output format community module

2022-10-17 Thread Carsten Klein (JIRA)
Carsten Klein ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=634d0122d66d8108a12107f4 ) *created* an issue GeoServer ( https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiYzcyNjUzZWUyNzQyNDc3M2ExNmE0MGU4MzYwZWVkODIiLCJwIjoiaiJ9 ) / New Feature ( https://osgeo

[Geoserver-devel] [JIRA] (GEOS-10733) SpatialJSON WFS output format community module

2022-11-03 Thread Carsten Klein (JIRA)
Carsten Klein ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=634d0122d66d8108a12107f4 ) *created* an issue GeoServer ( https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiNjFlNTU4NmEyZjAxNDdhODk5ODk5NWVhZTIzOGM5MjEiLCJwIjoiaiJ9 ) / New Feature ( https://osgeo

[Geoserver-devel] [JIRA] (GEOS-10734) SpatialJSON WFS output format community module

2022-11-03 Thread Carsten Klein (JIRA)
Carsten Klein ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=634d0122d66d8108a12107f4 ) *created* an issue GeoServer ( https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiMDMxYTQ1NTM1NTkyNDNiMjlmNzBjN2M4MGM2ZmM5MmEiLCJwIjoiaiJ9 ) / New Feature ( https://osgeo

[Geoserver-devel] [JIRA] (GEOS-10750) German Translation Overhaul Part 1

2022-11-16 Thread Carsten Klein (JIRA)
Carsten Klein ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=634d0122d66d8108a12107f4 ) *created* an issue GeoServer ( https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiZTY1OWFhYTdiMDI2NDMwNGI1YmM3OTU2NjMzMzZmN2UiLCJwIjoiaiJ9 ) / Improvement ( https://osgeo