geotools-gt2-users — Help and support for GeoTools users

Re: [Geotools-gt2-users] Question about ESRI OIDs

[SPDBA <si...@sp...>]

> I am accessing them via GeoTools so I want a GeoTools based solution.

This is what I do initially to try and identify the "primary key"

String key = "[fixme]";
List<AttributeDescriptor> adl = schema.getAttributeDescriptors();
for (AttributeDescriptor attribute : adl) {
    if ( attribute.getType().isIdentified()
         ||
         attribute.getLocalName().equalsIgnoreCase("OBJECTID")) {
          key = attribute.getLocalName();
          break;
     }
}


On 13 Mar 2024, 09:03, at 09:03, SPDBA <si...@sp...> wrote:
>Mark,
>
>They are not WFS, they are ESRI ArcGIS Feature Services.
>
>I am accessing them via GeoTools so I want a GeoTools based solution.
>
>Simon
>
>⁣39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
>(P) 03 62 396 397
>(M) 0418 396 381
>(W) www.spdba.com.au​
>
>On 13 Mar 2024, 04:05, at 04:05, Mark Prins <mc....@gm...> wrote:
>>On 09-03-2024 03:20, SPDBA wrote:
>>> GeoTools people.
>>> I've a simple question.
>>> I'm connecting to an ArcGIS feature web service.
>>> What I want to discover is which field in the published attributes
>is
>>
>>> the primary key. The sites I am looking at can have OBJECTID fields
>>of
>>> type esriFieldTypeOID, but often the name is otherwise: rid, gid,
>>fid,
>>> oid etc etc. The common thing is that one field is of type
>>> esriFieldTypeOID.
>>> Looking at the source with GeoTools the data type is returned as
>>> java.lang.Integer (AttributeDescriptor) which is fair enough in one
>>> sense but not useful to distinguish a field from all other integer.
>>So,
>>> is there a way of discovering what field is of type
>>> esriFieldTypeOID?
>>
>>it's unclear to me if you are talking about the esri native rest
>>service
>>interface aka "FeatureServer" or the OGC standard WFS interface of
>AGS.
>>The REST interface provides the esri types as metadata of a layer[0]; 
>>the WFS is limited to the types specified in the GML standard.
>>Some WFS services use the primary key value to produce the gml:id
>>attribute of a feature, this is exposed in GeoTools as the fid afaik
>>
>>[0]
>>https://sampleserver6.arcgisonline.com/arcgis/rest/services/CommercialDamageAssessment/FeatureServer/0
>>
>>
>>or as json
>>https://sampleserver6.arcgisonline.com/arcgis/rest/services/CommercialDamageAssessment/FeatureServer/0?f=pjson
>>
>>
>>
>>_______________________________________________
>>GeoTools-GT2-Users mailing list
>>Geo...@li...
>>https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>
>
>------------------------------------------------------------------------
>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>GeoTools-GT2-Users mailing list
>Geo...@li...
>https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

Re: [Geotools-gt2-users] Question about ESRI OIDs

[SPDBA <si...@sp...>]

Mark,

They are not WFS, they are ESRI ArcGIS Feature Services.

I am accessing them via GeoTools so I want a GeoTools based solution.

Simon

⁣39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
(P) 03 62 396 397
(M) 0418 396 381
(W) www.spdba.com.au​

On 13 Mar 2024, 04:05, at 04:05, Mark Prins <mc....@gm...> wrote:
>On 09-03-2024 03:20, SPDBA wrote:
>> GeoTools people.
>> I've a simple question.
>> I'm connecting to an ArcGIS feature web service.
>> What I want to discover is which field in the published attributes is
>
>> the primary key. The sites I am looking at can have OBJECTID fields
>of 
>> type esriFieldTypeOID, but often the name is otherwise: rid, gid,
>fid, 
>> oid etc etc. The common thing is that one field is of type 
>> esriFieldTypeOID.
>> Looking at the source with GeoTools the data type is returned as 
>> java.lang.Integer (AttributeDescriptor) which is fair enough in one 
>> sense but not useful to distinguish a field from all other integer.
>So, 
>> is there a way of discovering what field is of type
>> esriFieldTypeOID?
>
>it's unclear to me if you are talking about the esri native rest
>service 
>interface aka "FeatureServer" or the OGC standard WFS interface of AGS.
>The REST interface provides the esri types as metadata of a layer[0]; 
>the WFS is limited to the types specified in the GML standard.
>Some WFS services use the primary key value to produce the gml:id 
>attribute of a feature, this is exposed in GeoTools as the fid afaik
>
>[0] 
>https://sampleserver6.arcgisonline.com/arcgis/rest/services/CommercialDamageAssessment/FeatureServer/0
>
>
>or as json
>https://sampleserver6.arcgisonline.com/arcgis/rest/services/CommercialDamageAssessment/FeatureServer/0?f=pjson
>
>
>
>_______________________________________________
>GeoTools-GT2-Users mailing list
>Geo...@li...
>https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

Re: [Geotools-gt2-users] Question about ESRI OIDs

[Mark P. <mc....@gm...>]

On 09-03-2024 03:20, SPDBA wrote:
> GeoTools people.
> I've a simple question.
> I'm connecting to an ArcGIS feature web service.
> What I want to discover is which field in the published attributes is 
> the primary key. The sites I am looking at can have OBJECTID fields of 
> type esriFieldTypeOID, but often the name is otherwise: rid, gid, fid, 
> oid etc etc. The common thing is that one field is of type 
> esriFieldTypeOID.
> Looking at the source with GeoTools the data type is returned as 
> java.lang.Integer (AttributeDescriptor) which is fair enough in one 
> sense but not useful to distinguish a field from all other integer. So, 
> is there a way of discovering what field is of type
> esriFieldTypeOID?

it's unclear to me if you are talking about the esri native rest service 
interface aka "FeatureServer" or the OGC standard WFS interface of AGS.
The REST interface provides the esri types as metadata of a layer[0]; 
the WFS is limited to the types specified in the GML standard.
Some WFS services use the primary key value to produce the gml:id 
attribute of a feature, this is exposed in GeoTools as the fid afaik

[0] 
https://sampleserver6.arcgisonline.com/arcgis/rest/services/CommercialDamageAssessment/FeatureServer/0 

or as json
https://sampleserver6.arcgisonline.com/arcgis/rest/services/CommercialDamageAssessment/FeatureServer/0?f=pjson

[Geotools-gt2-users] Question about ESRI OIDs

[SPDBA <si...@sp...>]

GeoTools people.
I've a simple question.
I'm connecting to an ArcGIS feature web service.
What I want to discover is which field in the published attributes is the primary key. The sites I am looking at can have OBJECTID fields of type esriFieldTypeOID, but often the name is otherwise: rid, gid, fid, oid etc etc. The common thing is that one field is of type esriFieldTypeOID. 
Looking at the source with GeoTools the data type is returned as java.lang.Integer (AttributeDescriptor) which is fair enough in one sense but not useful to distinguish a field from all other integer. So, is there a way of discovering what field is of type 
esriFieldTypeOID?
Simon

⁣39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
(P) 03 62 396 397
(M) 0418 396 381
(W) www.spdba.com.au​

Re: [Geotools-gt2-users] GeoPackage: TIMESTAMP must be DATETIME according to the GeoPackage spec

[Andrea A. <and...@ge...>]

You can add this one to the list:
https://osgeo-org.atlassian.net/browse/GEOS-11292

The way to fix it is explained here:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-fixes,-improvements-and-new-features-in-GeoServer

Cheers
Andrea

On Tue, Feb 27, 2024 at 11:38 AM Goedertier Stijn via GeoTools-GT2-Users <
geo...@li...> wrote:

> Dear all,
>
>
>
> We noticed an issue with GeoPackage files produced by Geotools. The issue
> is that timestamp columns are not read by GDAL/OGR nor by QGIS because the
> TIMESTAMP datatype is not in accordance with the GeoPackage spec.
>
>
>
> Further info is in the following tickets:
> https://osgeo-org.atlassian.net/browse/GEOT-7528
>
>
>
> https://osgeo-org.atlassian.net/browse/GEOT-7537
>
> https://osgeo-org.atlassian.net/browse/GEOT-7528
>
>
>
> Is there a way to fix this?
>
>
>
> best regards,
>
> Stijn
> _______________________________________________
> GeoTools-GT2-Users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>


-- 

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax:     +39 0584 1660272

mob:   +39  339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

-------------------------------------------------------

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE
2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si
precisa che ogni circostanza inerente alla presente email (il suo
contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è
riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il
messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra
operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is
addressed and may contain information that is privileged, confidential or
otherwise protected from disclosure. We remind that - as provided by
European Regulation 2016/679 “GDPR” - copying, dissemination or use of this
e-mail or the information herein by anyone other than the intended
recipient is prohibited. If you have received this email by mistake, please
notify us immediately by telephone or e-mail

[Geotools-gt2-users] GeoPackage: TIMESTAMP must be DATETIME according to the GeoPackage spec

[Goedertier S. <sti...@vl...>]

Dear all,

We noticed an issue with GeoPackage files produced by Geotools. The issue is that timestamp columns are not read by GDAL/OGR nor by QGIS because the TIMESTAMP datatype is not in accordance with the GeoPackage spec.

Further info is in the following tickets: https://osgeo-org.atlassian.net/browse/GEOT-7528

https://osgeo-org.atlassian.net/browse/GEOT-7537
https://osgeo-org.atlassian.net/browse/GEOT-7528

Is there a way to fix this?

best regards,
Stijn

[Geotools-gt2-users] GeoTools 29.5 released

[Andrea A. <and...@ge...>]

Hi all,
GeoTools 29.5 has just been released, please read updates about it here:
https://geotoolsnews.blogspot.com/2024/02/geotools-295-released.html

Mind, this is the last planned release for the 29.x series, it's time to
either plan an upgrade
to GeoTools 30.x, or wait a month for GeoTools 31.0 to be released, and
jump directly to it.
An upgrade guide
<https://docs.geotools.org/latest/userguide/welcome/upgrade.html> is
available to ease the migration.

Best regards
Andrea

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax:     +39 0584 1660272

mob:   +39  339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

-------------------------------------------------------

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE
2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si
precisa che ogni circostanza inerente alla presente email (il suo
contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è
riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il
messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra
operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is
addressed and may contain information that is privileged, confidential or
otherwise protected from disclosure. We remind that - as provided by
European Regulation 2016/679 “GDPR” - copying, dissemination or use of this
e-mail or the information herein by anyone other than the intended
recipient is prohibited. If you have received this email by mistake, please
notify us immediately by telephone or e-mail

Re: [Geotools-gt2-users] DEM from points

[Ian T. <ijt...@gm...>]

Yes, you can interpolate the points using a Barnes Surface - see
https://gis.stackexchange.com/questions/41197/creating-raster-by-interpolating-point-values-using-geotools

Ian

On Sat, 17 Feb 2024 at 06:33, sunish <sun...@gm...> wrote:

> Hello,
>
> I have a set of points with x y z coordinates on EPSG:4326 projection.
> Can I utilize GeoTools to generate elevation data in DEM format from the
> provided dataset?
>
> Could you please provide insights, how I should proceed.
>
>
>
> Thank You.
>
> _______________________________________________
> GeoTools-GT2-Users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>


-- 
Ian Turton

[Geotools-gt2-users] DEM from points

[sunish <sun...@gm...>]

Hello,

I have a set of points with x y z coordinates on EPSG:4326 projection.
Can I utilize GeoTools to generate elevation data in DEM format from the
provided dataset?

Could you please provide insights, how I should proceed.



Thank You.

Re: [Geotools-gt2-users] Using gt-referencing within an app bundled with JPackage - where does the epsg database go.

[Jody G. <jod...@gm...>]

Plugin discover looks at one of the folders on the jar, where a text files
list what implementations are available for each.

When using shading  to remix jars - these text files need to be combined
from multiple jars.

The result is that the text files can be found on the classpath by
ServiceLoader.

https://docs.oracle.com/javase/8/docs/api/java/util/ServiceLoader.html





--
Jody Garnett


On Wed, Feb 7, 2024 at 5:41 PM Phil Scadden <P.S...@gn...> wrote:

> This turns out to be more a mystery than I first thought. I assumed the
> when running under JPACKAGE, it was not finding the epsg database, but logs
> didn’t show any sign of that. I requested stackdump in the exception, and I
> get:
> org.opengis.referencing.NoSuchAuthorityCodeException: No code "EPSG:2193"
> from authority "EPSG" found for object of type "EngineeringCRS".
>
>         at
> org.geotools.referencing.factory.epsg.CartesianAuthorityFactory.noSuchAuthorityException(CartesianAuthorityFactory.java:140)
>
>         at
> org.geotools.referencing.factory.epsg.CartesianAuthorityFactory.createEngineeringCRS(CartesianAuthorityFactory.java:132)
>
>         at
> org.geotools.referencing.factory.epsg.CartesianAuthorityFactory.createCoordinateReferenceSystem(CartesianAuthorityFactory.java:123)
>
>         at
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:811)
>
>         at
> org.geotools.referencing.factory.ThreadedAuthorityFactory.createCoordinateReferenceSystem(ThreadedAuthorityFactory.java:667)
>
>         at
> org.geotools.referencing.DefaultAuthorityFactory.createCoordinateReferenceSystem(DefaultAuthorityFactory.java:172)
>
>         at org.geotools.referencing.CRS.decode(CRS.java:507)
>
>         at org.geotools.referencing.CRS.decode(CRS.java:428)
>
>
>
> Reading this, I would assume that it didn’t find the plugin at all.
> Relevant bits of pom:        <dependency>
>
>             <groupId>org.geotools</groupId>
>
>             <artifactId>gt-referencing</artifactId>
>
>             <version>${geotools.version}</version>
>
>         </dependency>
>
>         <dependency>
>
>             <groupId>org.geotools</groupId>
>
>             <artifactId>gt-epsg-wkt</artifactId>
>
>             <version>${geotools.version}</version>
>
>         </dependency>
>
>         <dependency>
>
>             <groupId>org.geotools</groupId>
>
>             <artifactId>gt-epsg-extension</artifactId>
>
>             <version>${geotools.version}</version>
>
>         </dependency>
>
>         <dependency>
>
>             <groupId>org.geotools</groupId>
>
>             <artifactId>gt-api</artifactId>
>
>             <version>15.0</version>
>
>             <type>jar</type>
>
>         </dependency>
>
>
>
> ( I been trying both wkt and h2sql plugins – same result for h2sql).
>
> If I look at the shaded jar in the application image, I can see the plugin
> classes. I am pretty hazy though about plugins work in java – what would be
> reasons for the executable not to find them? As noted earlier, this works
> fine if run as jar on a machine with java already installed.
>
>
>
>
>
>
>
> *From:* Jody Garnett <jod...@gm...>
> *Sent:* Thursday, February 1, 2024 9:55 PM
> *To:* Phil Scadden <P.S...@gn...>
> *Cc:* geo...@li...
> *Subject:* Re: [Geotools-gt2-users] Using gt-referencing within an app
> bundled with JPackage - where does the epsg database go.
>
>
>
>
>
> *CAUTION:* This email originated from outside of the organization. Do not
> click links or open attachments unless you recognize the sender and know
> the content is safe:
>
> If you have done sharing correctly then plugin discovery works.
>
>
>
> The zip is unpacked into the the temp folder I believe? Yes it is:
>
>
>
>         File directory = new File(System.getProperty("java.io.tmpdir",
> "."), "Geotools");
>
>         if (directory.isDirectory() || directory.mkdir()) {
>
>             directory = new File(directory, "Databases/HSQL");
>
>             if (directory.isDirectory() || directory.mkdirs()) {
>
>                 return directory;
>
>             }
>
>         }
>
>
>
> You can also set a property "EPSG-HSQL.directory" to indicate where the
> database is located.
>
>
>
> See
> https://github.com/geotools/geotools/blob/main/modules/plugin/epsg-hsql/src/main/java/org/geotools/referencing/factory/epsg/hsql/HsqlEpsgDatabase.java
>
>
>
> --
>
> Jody Garnett
>
>
>
>
>
> On Jan 31, 2024 at 8:07:47 PM, Phil Scadden <P.S...@gn...> wrote:
>
> I have a little console app (pushing excel sheet to a database), that runs
> fine as a shaded jar with java. However, I have folk using it that are
> reluctant to install java and I packaged it with JRT etc using JPackage. If
> the code is launched with JPackage, then it doesn’t find the EPSG database.
> Tried with both epgl-h2sql and epsg-wkt. No luck. JPackage allows me to
> specify a resource directory, but no idea what it would be. When the app
> runs, what exactly happens to say the EPSG.zip in epsg-h2sql for instance?
>
>
>
> ________________________________________________
>
> Ngā mihi, Nā Phil Scadden (he/him)
>
> Te Raraunga me te Tātaritanga Mokowā Aronuku (Geospatial Data and
> Analysis)
>
> *GNS Science **Te Pῡ Ao*
>
> 764 Cumberland St
> <https://www.google.com/maps/search/764+Cumberland+St?entry=gmail&source=g>,
> Private Bag 1930,
>
> Dunedin, New Zealand Ph +64 3 4799663, 027 3463185
>
>
>
> “Whāia te iti kahurangi ki te tūohu koe me he maunga teitei”
>
>
>
> Notice: This email and any attachments are confidential and may not be
> used, published or redistributed without the prior written consent of the
> Institute of Geological and Nuclear Sciences Limited (GNS Science). If
> received in error please destroy and immediately notify GNS Science. Do not
> copy or disclose the contents.
>
> _______________________________________________
> GeoTools-GT2-Users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>
> Notice: This email and any attachments are confidential and may not be
> used, published or redistributed without the prior written consent of the
> Institute of Geological and Nuclear Sciences Limited (GNS Science). If
> received in error please destroy and immediately notify GNS Science. Do not
> copy or disclose the contents.
>

Re: [Geotools-gt2-users] Using gt-referencing within an app bundled with JPackage - where does the epsg database go.

[Phil S. <P.S...@gn...>]

This turns out to be more a mystery than I first thought. I assumed the when running under JPACKAGE, it was not finding the epsg database, but logs didn’t show any sign of that. I requested stackdump in the exception, and I get:
org.opengis.referencing.NoSuchAuthorityCodeException: No code "EPSG:2193" from authority "EPSG" found for object of type "EngineeringCRS".
        at org.geotools.referencing.factory.epsg.CartesianAuthorityFactory.noSuchAuthorityException(CartesianAuthorityFactory.java:140)
        at org.geotools.referencing.factory.epsg.CartesianAuthorityFactory.createEngineeringCRS(CartesianAuthorityFactory.java:132)
        at org.geotools.referencing.factory.epsg.CartesianAuthorityFactory.createCoordinateReferenceSystem(CartesianAuthorityFactory.java:123)
        at org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:811)
        at org.geotools.referencing.factory.ThreadedAuthorityFactory.createCoordinateReferenceSystem(ThreadedAuthorityFactory.java:667)
        at org.geotools.referencing.DefaultAuthorityFactory.createCoordinateReferenceSystem(DefaultAuthorityFactory.java:172)
        at org.geotools.referencing.CRS.decode(CRS.java:507)
        at org.geotools.referencing.CRS.decode(CRS.java:428)

Reading this, I would assume that it didn’t find the plugin at all. Relevant bits of pom:        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-referencing</artifactId>
            <version>${geotools.version}</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-epsg-wkt</artifactId>
            <version>${geotools.version}</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-epsg-extension</artifactId>
            <version>${geotools.version}</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-api</artifactId>
            <version>15.0</version>
            <type>jar</type>
        </dependency>

( I been trying both wkt and h2sql plugins – same result for h2sql).
If I look at the shaded jar in the application image, I can see the plugin classes. I am pretty hazy though about plugins work in java – what would be reasons for the executable not to find them? As noted earlier, this works fine if run as jar on a machine with java already installed.



From: Jody Garnett <jod...@gm...>
Sent: Thursday, February 1, 2024 9:55 PM
To: Phil Scadden <P.S...@gn...>
Cc: geo...@li...
Subject: Re: [Geotools-gt2-users] Using gt-referencing within an app bundled with JPackage - where does the epsg database go.



CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe:
If you have done sharing correctly then plugin discovery works.

The zip is unpacked into the the temp folder I believe? Yes it is:

        File directory = new File(System.getProperty("java.io.tmpdir", "."), "Geotools");
        if (directory.isDirectory() || directory.mkdir()) {
            directory = new File(directory, "Databases/HSQL");
            if (directory.isDirectory() || directory.mkdirs()) {
                return directory;
            }
        }

You can also set a property "EPSG-HSQL.directory" to indicate where the database is located.

See https://github.com/geotools/geotools/blob/main/modules/plugin/epsg-hsql/src/main/java/org/geotools/referencing/factory/epsg/hsql/HsqlEpsgDatabase.java

--
Jody Garnett


On Jan 31, 2024 at 8:07:47 PM, Phil Scadden <P.S...@gn...<mailto:P.S...@gn...>> wrote:
I have a little console app (pushing excel sheet to a database), that runs fine as a shaded jar with java. However, I have folk using it that are reluctant to install java and I packaged it with JRT etc using JPackage. If the code is launched with JPackage, then it doesn’t find the EPSG database. Tried with both epgl-h2sql and epsg-wkt. No luck. JPackage allows me to specify a resource directory, but no idea what it would be. When the app runs, what exactly happens to say the EPSG.zip in epsg-h2sql for instance?

________________________________________________
Ngā mihi, Nā Phil Scadden (he/him)
Te Raraunga me te Tātaritanga Mokowā Aronuku (Geospatial Data and Analysis)
GNS Science Te Pῡ Ao
764 Cumberland St, Private Bag 1930,
Dunedin, New Zealand Ph +64 3 4799663, 027 3463185

“Whāia te iti kahurangi ki te tūohu koe me he maunga teitei”

Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents.
_______________________________________________
GeoTools-GT2-Users mailing list
Geo...@li...<mailto:Geo...@li...>
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents.

Re: [Geotools-gt2-users] Using gt-referencing within an app bundled with JPackage - where does the epsg database go.

[Phil S. <P.S...@gn...>]

Thanks very much Jody, that was just the information that I needed.

From: Jody Garnett <jod...@gm...>
Sent: Thursday, February 1, 2024 9:55 PM
To: Phil Scadden <P.S...@gn...>
Cc: geo...@li...
Subject: Re: [Geotools-gt2-users] Using gt-referencing within an app bundled with JPackage - where does the epsg database go.



CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe:
If you have done sharing correctly then plugin discovery works.

The zip is unpacked into the the temp folder I believe? Yes it is:

        File directory = new File(System.getProperty("java.io.tmpdir", "."), "Geotools");
        if (directory.isDirectory() || directory.mkdir()) {
            directory = new File(directory, "Databases/HSQL");
            if (directory.isDirectory() || directory.mkdirs()) {
                return directory;
            }
        }

You can also set a property "EPSG-HSQL.directory" to indicate where the database is located.

See https://github.com/geotools/geotools/blob/main/modules/plugin/epsg-hsql/src/main/java/org/geotools/referencing/factory/epsg/hsql/HsqlEpsgDatabase.java

--
Jody Garnett


On Jan 31, 2024 at 8:07:47 PM, Phil Scadden <P.S...@gn...<mailto:P.S...@gn...>> wrote:
I have a little console app (pushing excel sheet to a database), that runs fine as a shaded jar with java. However, I have folk using it that are reluctant to install java and I packaged it with JRT etc using JPackage. If the code is launched with JPackage, then it doesn’t find the EPSG database. Tried with both epgl-h2sql and epsg-wkt. No luck. JPackage allows me to specify a resource directory, but no idea what it would be. When the app runs, what exactly happens to say the EPSG.zip in epsg-h2sql for instance?

________________________________________________
Ngā mihi, Nā Phil Scadden (he/him)
Te Raraunga me te Tātaritanga Mokowā Aronuku (Geospatial Data and Analysis)
GNS Science Te Pῡ Ao
764 Cumberland St, Private Bag 1930,
Dunedin, New Zealand Ph +64 3 4799663, 027 3463185

“Whāia te iti kahurangi ki te tūohu koe me he maunga teitei”

Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents.
_______________________________________________
GeoTools-GT2-Users mailing list
Geo...@li...<mailto:Geo...@li...>
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents.

Re: [Geotools-gt2-users] Using gt-referencing within an app bundled with JPackage - where does the epsg database go.

[Jody G. <jod...@gm...>]

If you have done sharing correctly then plugin discovery works.

The zip is unpacked into the the temp folder I believe? Yes it is:

        File directory = new File(System.getProperty("java.io.tmpdir",
"."), "Geotools");
        if (directory.isDirectory() || directory.mkdir()) {
            directory = new File(directory, "Databases/HSQL");
            if (directory.isDirectory() || directory.mkdirs()) {
                return directory;
            }
        }

You can also set a property "EPSG-HSQL.directory" to indicate where the
database is located.

See
https://github.com/geotools/geotools/blob/main/modules/plugin/epsg-hsql/src/main/java/org/geotools/referencing/factory/epsg/hsql/HsqlEpsgDatabase.java

--
Jody Garnett


On Jan 31, 2024 at 8:07:47 PM, Phil Scadden <P.S...@gn...> wrote:

> I have a little console app (pushing excel sheet to a database), that runs
> fine as a shaded jar with java. However, I have folk using it that are
> reluctant to install java and I packaged it with JRT etc using JPackage. If
> the code is launched with JPackage, then it doesn’t find the EPSG database.
> Tried with both epgl-h2sql and epsg-wkt. No luck. JPackage allows me to
> specify a resource directory, but no idea what it would be. When the app
> runs, what exactly happens to say the EPSG.zip in epsg-h2sql for instance?
>
>
>
> ________________________________________________
>
> Ngā mihi, Nā Phil Scadden (he/him)
>
> Te Raraunga me te Tātaritanga Mokowā Aronuku (Geospatial Data and
> Analysis)
>
> *GNS Science* *Te Pῡ Ao*
>
> 764 Cumberland St, Private Bag 1930,
>
> Dunedin, New Zealand Ph +64 3 4799663, 027 3463185
>
>
>
> “Whāia te iti kahurangi ki te tūohu koe me he maunga teitei”
>
>
> Notice: This email and any attachments are confidential and may not be
> used, published or redistributed without the prior written consent of the
> Institute of Geological and Nuclear Sciences Limited (GNS Science). If
> received in error please destroy and immediately notify GNS Science. Do not
> copy or disclose the contents.
> _______________________________________________
> GeoTools-GT2-Users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>

[Geotools-gt2-users] Using gt-referencing within an app bundled with JPackage - where does the epsg database go.

[Phil S. <P.S...@gn...>]

I have a little console app (pushing excel sheet to a database), that runs fine as a shaded jar with java. However, I have folk using it that are reluctant to install java and I packaged it with JRT etc using JPackage. If the code is launched with JPackage, then it doesn’t find the EPSG database. Tried with both epgl-h2sql and epsg-wkt. No luck. JPackage allows me to specify a resource directory, but no idea what it would be. When the app runs, what exactly happens to say the EPSG.zip in epsg-h2sql for instance?

________________________________________________
Ngā mihi, Nā Phil Scadden (he/him)
Te Raraunga me te Tātaritanga Mokowā Aronuku (Geospatial Data and Analysis)
GNS Science Te Pῡ Ao
764 Cumberland St, Private Bag 1930,
Dunedin, New Zealand Ph +64 3 4799663, 027 3463185

“Whāia te iti kahurangi ki te tūohu koe me he maunga teitei”

Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents.

Re: [Geotools-gt2-users] Problem with NetCDF gridcoverage module

[<pie...@sy...>]

Hi Jody,

 

Finally, the solution is to add the following line of code to the test.

 

            TimeZone.setDefault(TimeZone.getTimeZone("UTC"));

 

I will do the PR

 

Regards,

 

Pierre

 

 

De : Jody Garnett <jod...@gm...> 
Envoyé : 24 janvier 2024 10:03
À : Andrea Aime <and...@ge...>
Cc : geo...@li...; pie...@sy...
Objet : Re: [Geotools-gt2-users] Problem with NetCDF gridcoverage module

 

Should we adjust the GitHub action to run a different timezone? It would catch this category of errors. 


--

Jody Garnett

 

 

On Wed, Jan 24, 2024 at 12:03 AM Andrea Aime <and...@ge... <mailto:and...@ge...> > wrote:

Perhaps they easiest way is to force the test to run in UTC, either

with the surefire JVM configuration <https://github.com/geotools/geotools/blob/main/pom.xml#L1760> , or in the test setup, like for example DateParserTest <https://github.com/geotools/geotools/blob/main/modules/unsupported/geojson-core/src/test/java/org/geotools/data/geojson/DateParserTest.java#L17> 

PRs with updates to make it build on your end too welcomed, the Github actions will

run in UTC and confirm it can work for others as well (along with a manual review checking the change).

 

Best regards

Andrea

 

On Wed, Jan 24, 2024 at 1:57 AM Jody Garnett <jod...@gm... <mailto:jod...@gm...> > wrote:

In my experience some it can be interesting to write tests that compare times, often people write tests in Europe which then fail when we run them in North America due to timezone offset.

 

Options:

 

1.	When you look at the test is it possible to providing in GMT or Z time for comparison? Look at the value prior to toString().
2.	I am not sure if it is a bug in the code, in the test, or worst case in the file format specification?

--

Jody Garnett

 

 

On Dec 19, 2023 at 9:03:50 AM, pie...@sy... <mailto:pie...@sy...>  wrote:

Hi,

 

What is wrong with my settings ?

 

When I run « mvn install », I have the following error:

 

NetCDF gridcoverage module FAILURE

 

To correct the problem I have to change the function  testGranuleSourceFileView() in the file NetCDFMosaicReaderTest.java.

 

The two lines :

             assertEquals("2017-02-06 00:00:00.0", nc1.getAttribute("time").toString());

             assertEquals("2017-02-06 12:00:00.0", nc2.getAttribute("time").toString());

 

should be change for 

            assertEquals("2017-02-05 19:00:00.0", nc1.getAttribute("time").toString());

            assertEquals("2017-02-06 07:00:00.0", nc2.getAttribute("time").toString());

 

 

My computer is in the zone (UTC -05:00)  East (USA and Canada). It is exactly the difference of time shown previously.

 

 

Regards,

 

 

Pierre 

_______________________________________________
GeoTools-GT2-Users mailing list
Geo...@li... <mailto:Geo...@li...> 
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

_______________________________________________
GeoTools-GT2-Users mailing list
Geo...@li... <mailto:Geo...@li...> 
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users




 

-- 

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit  <http://bit.ly/gs-services-us> http://bit.ly/gs-services-us for more information.
==

Ing. Andrea Aime 
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax:     +39 0584 1660272

mob:   +39  339 8844549

 

 <https://www.geosolutionsgroup.com/> https://www.geosolutionsgroup.com/

 <http://twitter.com/geosolutions_it> http://twitter.com/geosolutions_it

-------------------------------------------------------


Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

Re: [Geotools-gt2-users] Problem with NetCDF gridcoverage module

[<pie...@sy...>]

Hi Jody,

 

For your information, if I change the time zone of my machine to UTC+0:00 (zone 0) then the test runs without problems. But I didn’t find the solution to run the test in my time zone yet. 

 

Regards,

 

Pierre

 

De : Jody Garnett <jod...@gm...> 
Envoyé : 24 janvier 2024 15:03
À : Andrea Aime <and...@ge...>
Cc : geo...@li...; pie...@sy...
Objet : Re: [Geotools-gt2-users] Problem with NetCDF gridcoverage module

 

Should we adjust the GitHub action to run a different timezone? It would catch this category of errors. 


--

Jody Garnett

 

 

On Wed, Jan 24, 2024 at 12:03 AM Andrea Aime <and...@ge... <mailto:and...@ge...> > wrote:

Perhaps they easiest way is to force the test to run in UTC, either

with the surefire JVM configuration <https://github.com/geotools/geotools/blob/main/pom.xml#L1760> , or in the test setup, like for example DateParserTest <https://github.com/geotools/geotools/blob/main/modules/unsupported/geojson-core/src/test/java/org/geotools/data/geojson/DateParserTest.java#L17> 

PRs with updates to make it build on your end too welcomed, the Github actions will

run in UTC and confirm it can work for others as well (along with a manual review checking the change).

 

Best regards

Andrea

 

On Wed, Jan 24, 2024 at 1:57 AM Jody Garnett <jod...@gm... <mailto:jod...@gm...> > wrote:

In my experience some it can be interesting to write tests that compare times, often people write tests in Europe which then fail when we run them in North America due to timezone offset.

 

Options:

 

1.	When you look at the test is it possible to providing in GMT or Z time for comparison? Look at the value prior to toString().
2.	I am not sure if it is a bug in the code, in the test, or worst case in the file format specification?

--

Jody Garnett

 

 

On Dec 19, 2023 at 9:03:50 AM, pie...@sy... <mailto:pie...@sy...>  wrote:

Hi,

 

What is wrong with my settings ?

 

When I run « mvn install », I have the following error:

 

NetCDF gridcoverage module FAILURE

 

To correct the problem I have to change the function  testGranuleSourceFileView() in the file NetCDFMosaicReaderTest.java.

 

The two lines :

             assertEquals("2017-02-06 00:00:00.0", nc1.getAttribute("time").toString());

             assertEquals("2017-02-06 12:00:00.0", nc2.getAttribute("time").toString());

 

should be change for 

            assertEquals("2017-02-05 19:00:00.0", nc1.getAttribute("time").toString());

            assertEquals("2017-02-06 07:00:00.0", nc2.getAttribute("time").toString());

 

 

My computer is in the zone (UTC -05:00)  East (USA and Canada). It is exactly the difference of time shown previously.

 

 

Regards,

 

 

Pierre 

_______________________________________________
GeoTools-GT2-Users mailing list
Geo...@li... <mailto:Geo...@li...> 
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

_______________________________________________
GeoTools-GT2-Users mailing list
Geo...@li... <mailto:Geo...@li...> 
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users




 

-- 

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit  <http://bit.ly/gs-services-us> http://bit.ly/gs-services-us for more information.
==

Ing. Andrea Aime 
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax:     +39 0584 1660272

mob:   +39  339 8844549

 

 <https://www.geosolutionsgroup.com/> https://www.geosolutionsgroup.com/

 <http://twitter.com/geosolutions_it> http://twitter.com/geosolutions_it

-------------------------------------------------------


Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

[Geotools-gt2-users] GeoTools 30.2 stable release

[Jody G. <jod...@gm...>]

Dear GeoTools community,

We are pleased to announce the latest stable release of GeoTools 30.2 is
available for download or via maven repo.

For details please see blog post:
https://geotoolsnews.blogspot.com/2024/01/geotools-302-released.html
Or release notes: https://github.com/geotools/geotools/releases/tag/30.2

--
Jody Garnett

Re: [Geotools-gt2-users] Problem with NetCDF gridcoverage module

[Jody G. <jod...@gm...>]

Should we adjust the GitHub action to run a different timezone? It would
catch this category of errors.
--
Jody Garnett


On Wed, Jan 24, 2024 at 12:03 AM Andrea Aime <
and...@ge...> wrote:

> Perhaps they easiest way is to force the test to run in UTC, either
> with the surefire JVM configuration
> <https://github.com/geotools/geotools/blob/main/pom.xml#L1760>, or in the
> test setup, like for example DateParserTest
> <https://github.com/geotools/geotools/blob/main/modules/unsupported/geojson-core/src/test/java/org/geotools/data/geojson/DateParserTest.java#L17>
>
> PRs with updates to make it build on your end too welcomed, the Github
> actions will
> run in UTC and confirm it can work for others as well (along with a manual
> review checking the change).
>
> Best regards
> Andrea
>
> On Wed, Jan 24, 2024 at 1:57 AM Jody Garnett <jod...@gm...>
> wrote:
>
>> In my experience some it can be interesting to write tests that compare
>> times, often people write tests in Europe which then fail when we run them
>> in North America due to timezone offset.
>>
>> Options:
>>
>>
>>    1. When you look at the test is it possible to providing in GMT or Z
>>    time for comparison? Look at the value prior to toString().
>>    2. I am not sure if it is a bug in the code, in the test, or worst
>>    case in the file format specification?
>>
>> --
>> Jody Garnett
>>
>>
>> On Dec 19, 2023 at 9:03:50 AM, pie...@sy... wrote:
>>
>>> Hi,
>>>
>>>
>>>
>>> What is wrong with my settings ?
>>>
>>>
>>>
>>> When I run « mvn install », I have the following error:
>>>
>>>
>>>
>>> NetCDF gridcoverage module FAILURE
>>>
>>>
>>>
>>> To correct the problem I have to change the function
>>>  testGranuleSourceFileView() in the file NetCDFMosaicReaderTest.java.
>>>
>>>
>>>
>>> The two lines :
>>>
>>>              assertEquals("2017-02-06 00:00:00.0",
>>> nc1.getAttribute("time").toString());
>>>
>>>              assertEquals("2017-02-06 12:00:00.0",
>>> nc2.getAttribute("time").toString());
>>>
>>>
>>>
>>> should be change for
>>>
>>>             assertEquals("2017-02-05 19:00:00.0",
>>> nc1.getAttribute("time").toString());
>>>
>>>             assertEquals("2017-02-06 07:00:00.0",
>>> nc2.getAttribute("time").toString());
>>>
>>>
>>>
>>>
>>>
>>> My computer is in the zone (UTC -05:00)  East (USA and Canada). It is
>>> exactly the difference of time shown previously.
>>>
>>>
>>>
>>>
>>>
>>> Regards,
>>>
>>>
>>>
>>>
>>>
>>> Pierre
>>> _______________________________________________
>>> GeoTools-GT2-Users mailing list
>>> Geo...@li...
>>> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>>
>> _______________________________________________
>> GeoTools-GT2-Users mailing list
>> Geo...@li...
>> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>
>
>
> --
>
> Regards,
>
> Andrea Aime
>
> ==
> GeoServer Professional Services from the experts!
>
> Visit http://bit.ly/gs-services-us for more information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions Group
> phone: +39 0584 962313
>
> fax:     +39 0584 1660272
>
> mob:   +39  339 8844549
>
> https://www.geosolutionsgroup.com/
>
> http://twitter.com/geosolutions_it
>
> -------------------------------------------------------
>
> Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE
> 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si
> precisa che ogni circostanza inerente alla presente email (il suo
> contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è
> riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il
> messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra
> operazione è illecita. Le sarei comunque grato se potesse darmene notizia.
>
> This email is intended only for the person or entity to which it is
> addressed and may contain information that is privileged, confidential or
> otherwise protected from disclosure. We remind that - as provided by
> European Regulation 2016/679 “GDPR” - copying, dissemination or use of this
> e-mail or the information herein by anyone other than the intended
> recipient is prohibited. If you have received this email by mistake, please
> notify us immediately by telephone or e-mail
>

Re: [Geotools-gt2-users] Problem with NetCDF gridcoverage module

[Andrea A. <and...@ge...>]

Perhaps they easiest way is to force the test to run in UTC, either
with the surefire JVM configuration
<https://github.com/geotools/geotools/blob/main/pom.xml#L1760>, or in the
test setup, like for example DateParserTest
<https://github.com/geotools/geotools/blob/main/modules/unsupported/geojson-core/src/test/java/org/geotools/data/geojson/DateParserTest.java#L17>

PRs with updates to make it build on your end too welcomed, the Github
actions will
run in UTC and confirm it can work for others as well (along with a manual
review checking the change).

Best regards
Andrea

On Wed, Jan 24, 2024 at 1:57 AM Jody Garnett <jod...@gm...> wrote:

> In my experience some it can be interesting to write tests that compare
> times, often people write tests in Europe which then fail when we run them
> in North America due to timezone offset.
>
> Options:
>
>
>    1. When you look at the test is it possible to providing in GMT or Z
>    time for comparison? Look at the value prior to toString().
>    2. I am not sure if it is a bug in the code, in the test, or worst
>    case in the file format specification?
>
> --
> Jody Garnett
>
>
> On Dec 19, 2023 at 9:03:50 AM, pie...@sy... wrote:
>
>> Hi,
>>
>>
>>
>> What is wrong with my settings ?
>>
>>
>>
>> When I run « mvn install », I have the following error:
>>
>>
>>
>> NetCDF gridcoverage module FAILURE
>>
>>
>>
>> To correct the problem I have to change the function
>>  testGranuleSourceFileView() in the file NetCDFMosaicReaderTest.java.
>>
>>
>>
>> The two lines :
>>
>>              assertEquals("2017-02-06 00:00:00.0",
>> nc1.getAttribute("time").toString());
>>
>>              assertEquals("2017-02-06 12:00:00.0",
>> nc2.getAttribute("time").toString());
>>
>>
>>
>> should be change for
>>
>>             assertEquals("2017-02-05 19:00:00.0",
>> nc1.getAttribute("time").toString());
>>
>>             assertEquals("2017-02-06 07:00:00.0",
>> nc2.getAttribute("time").toString());
>>
>>
>>
>>
>>
>> My computer is in the zone (UTC -05:00)  East (USA and Canada). It is
>> exactly the difference of time shown previously.
>>
>>
>>
>>
>>
>> Regards,
>>
>>
>>
>>
>>
>> Pierre
>> _______________________________________________
>> GeoTools-GT2-Users mailing list
>> Geo...@li...
>> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>
> _______________________________________________
> GeoTools-GT2-Users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>


-- 

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax:     +39 0584 1660272

mob:   +39  339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

-------------------------------------------------------

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE
2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si
precisa che ogni circostanza inerente alla presente email (il suo
contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è
riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il
messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra
operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is
addressed and may contain information that is privileged, confidential or
otherwise protected from disclosure. We remind that - as provided by
European Regulation 2016/679 “GDPR” - copying, dissemination or use of this
e-mail or the information herein by anyone other than the intended
recipient is prohibited. If you have received this email by mistake, please
notify us immediately by telephone or e-mail

Re: [Geotools-gt2-users] Question about JDBCDatastore

[sunish <sun...@gm...>]

Thank you.

The exception got resolved by adding these lines.

params.put("validate connections", true);
params.put("Max connection idle time", 300);
params.put("Evictor run periodicity", 150);

There is a firewall running in DB server which terminated idle connections.

Thanks and Regards,

On Wed, Jan 24, 2024 at 6:28 AM Jody Garnett <jod...@gm...> wrote:

> I do not think anyone is answering you as the answer depends on how you
> are using the database and what your expectations are?
>
> If your application is using the database all the time it is worth making
> use of a connection pool, to recycle connections, rather than connect to
> the database directly.
>
> If your application is in a shared environment like JavaEE you may wish to
> look up a JNDI data source and share the database connections with the rest
> of the application?
>
> If your code only talks to the database for a bit, and then is quiet it
> may be kind to do as you say and create the dataStore, use the connections
> for a bit, and then dispose of everything until next time.
> --
> Jody Garnett
>
>
> On Jan 14, 2024 at 3:33:14 AM, sunish <sun...@gm...> wrote:
>
>> Hello,
>>
>> I am developing an application using Geotools. The framework used for the
>> application is Quarkus. The application connects to the PostGIS database.
>>
>> Since it is a web application I want to minimize the overheads in
>> connecting to the database in each request. I want to reuse an already
>> connected database.
>>
>> I have maintained an application level DataStore object which gets
>> created when the application starts up.
>>
>> Map<String, Object> params = new HashMap<>();
>> params.put("dbtype", "postgis");
>> params.put("host", this.dbConfig.getHost());
>> params.put("port", this.dbConfig.getPort());
>> params.put("schema", "public");
>> params.put("database" ,this.dbConfig.getDatabase());
>> params.put("user", this.dbConfig.getUser());
>> params.put("passwd", this.dbConfig.getPassword());
>> params.put("preparedStatements", true);
>> params.put("encode functions", true);
>>
>> try {
>>     this.dataStore = (JDBCDataStore) DataStoreFinder.getDataStore(params);
>> } catch (IOException e) {
>>
>> Logger.getLogger(DataSourceService.class.getName()).warning(e.getMessage());
>> } catch (SQLException e) {
>>
>> Logger.getLogger(DataSourceService.class.getName()).warning(e.getMessage());
>> }
>> ---------
>>
>> Then I am using the dataStore object in the rest of the places.
>>
>> Is this the proper way of doing  or should I use DataStoreFinder each
>> time to find the datastore and dispose of the data store at the end of
>> processing request?
>> Can I plug connection pools like HikariCP to get datastore out of that
>> connection?
>>
>> When I leave the application idle for a long time I am getting  this
>> error.
>>
>> java.sql.SQLException: An I/O error occurred while sending to the backend.
>>
>> Please suggest the best way of doing it.
>>
>> Thanks in advance.
>>
>> Sunish.
>>
>>
>>
>>
>>
>> _______________________________________________
>> GeoTools-GT2-Users mailing list
>> Geo...@li...
>> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>>
>

Re: [Geotools-gt2-users] Question about JDBCDatastore

[Jody G. <jod...@gm...>]

 I do not think anyone is answering you as the answer depends on how you
are using the database and what your expectations are?

If your application is using the database all the time it is worth making
use of a connection pool, to recycle connections, rather than connect to
the database directly.

If your application is in a shared environment like JavaEE you may wish to
look up a JNDI data source and share the database connections with the rest
of the application?

If your code only talks to the database for a bit, and then is quiet it may
be kind to do as you say and create the dataStore, use the connections for
a bit, and then dispose of everything until next time.
--
Jody Garnett


On Jan 14, 2024 at 3:33:14 AM, sunish <sun...@gm...> wrote:

> Hello,
>
> I am developing an application using Geotools. The framework used for the
> application is Quarkus. The application connects to the PostGIS database.
>
> Since it is a web application I want to minimize the overheads in
> connecting to the database in each request. I want to reuse an already
> connected database.
>
> I have maintained an application level DataStore object which gets created
> when the application starts up.
>
> Map<String, Object> params = new HashMap<>();
> params.put("dbtype", "postgis");
> params.put("host", this.dbConfig.getHost());
> params.put("port", this.dbConfig.getPort());
> params.put("schema", "public");
> params.put("database" ,this.dbConfig.getDatabase());
> params.put("user", this.dbConfig.getUser());
> params.put("passwd", this.dbConfig.getPassword());
> params.put("preparedStatements", true);
> params.put("encode functions", true);
>
> try {
>     this.dataStore = (JDBCDataStore) DataStoreFinder.getDataStore(params);
> } catch (IOException e) {
>
> Logger.getLogger(DataSourceService.class.getName()).warning(e.getMessage());
> } catch (SQLException e) {
>
> Logger.getLogger(DataSourceService.class.getName()).warning(e.getMessage());
> }
> ---------
>
> Then I am using the dataStore object in the rest of the places.
>
> Is this the proper way of doing  or should I use DataStoreFinder each time
> to find the datastore and dispose of the data store at the end of
> processing request?
> Can I plug connection pools like HikariCP to get datastore out of that
> connection?
>
> When I leave the application idle for a long time I am getting  this error.
>
> java.sql.SQLException: An I/O error occurred while sending to the backend.
>
> Please suggest the best way of doing it.
>
> Thanks in advance.
>
> Sunish.
>
>
>
>
>
> _______________________________________________
> GeoTools-GT2-Users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>

Re: [Geotools-gt2-users] Problem with NetCDF gridcoverage module

[Jody G. <jod...@gm...>]

 In my experience some it can be interesting to write tests that compare
times, often people write tests in Europe which then fail when we run them
in North America due to timezone offset.

Options:


   1. When you look at the test is it possible to providing in GMT or Z
   time for comparison? Look at the value prior to toString().
   2. I am not sure if it is a bug in the code, in the test, or worst case
   in the file format specification?

--
Jody Garnett


On Dec 19, 2023 at 9:03:50 AM, pie...@sy... wrote:

> Hi,
>
>
>
> What is wrong with my settings ?
>
>
>
> When I run « mvn install », I have the following error:
>
>
>
> NetCDF gridcoverage module FAILURE
>
>
>
> To correct the problem I have to change the function
>  testGranuleSourceFileView() in the file NetCDFMosaicReaderTest.java.
>
>
>
> The two lines :
>
>              assertEquals("2017-02-06 00:00:00.0",
> nc1.getAttribute("time").toString());
>
>              assertEquals("2017-02-06 12:00:00.0",
> nc2.getAttribute("time").toString());
>
>
>
> should be change for
>
>             assertEquals("2017-02-05 19:00:00.0",
> nc1.getAttribute("time").toString());
>
>             assertEquals("2017-02-06 07:00:00.0",
> nc2.getAttribute("time").toString());
>
>
>
>
>
> My computer is in the zone (UTC -05:00)  East (USA and Canada). It is
> exactly the difference of time shown previously.
>
>
>
>
>
> Regards,
>
>
>
>
>
> Pierre
> _______________________________________________
> GeoTools-GT2-Users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>

[Geotools-gt2-users] Question about JDBCDatastore

[sunish <sun...@gm...>]

Hello,

I am developing an application using Geotools. The framework used for the
application is Quarkus. The application connects to the PostGIS database.

Since it is a web application I want to minimize the overheads in
connecting to the database in each request. I want to reuse an already
connected database.

I have maintained an application level DataStore object which gets created
when the application starts up.

Map<String, Object> params = new HashMap<>();
params.put("dbtype", "postgis");
params.put("host", this.dbConfig.getHost());
params.put("port", this.dbConfig.getPort());
params.put("schema", "public");
params.put("database" ,this.dbConfig.getDatabase());
params.put("user", this.dbConfig.getUser());
params.put("passwd", this.dbConfig.getPassword());
params.put("preparedStatements", true);
params.put("encode functions", true);

try {
    this.dataStore = (JDBCDataStore) DataStoreFinder.getDataStore(params);
} catch (IOException e) {

Logger.getLogger(DataSourceService.class.getName()).warning(e.getMessage());
} catch (SQLException e) {

Logger.getLogger(DataSourceService.class.getName()).warning(e.getMessage());
}
---------

Then I am using the dataStore object in the rest of the places.

Is this the proper way of doing  or should I use DataStoreFinder each time
to find the datastore and dispose of the data store at the end of
processing request?
Can I plug connection pools like HikariCP to get datastore out of that
connection?

When I leave the application idle for a long time I am getting  this error.

java.sql.SQLException: An I/O error occurred while sending to the backend.

Please suggest the best way of doing it.

Thanks in advance.

Sunish.

[Geotools-gt2-users] Latest maintenance release GeoTools 29.4

[Peter S. <gs...@sm...>]

Dear GeoTools users

We are pleased to announce the release of the latest maintenance version of
GeoTools (29.4).  More details are available in the related blog post:

https://geotoolsnews.blogspot.com/2023/12/geotools-294-released.html
<https://geotoolsnews.blogspot.com/2023/10/geotools-293-released.html>

Peter

[Geotools-gt2-users] Problem with NetCDF gridcoverage module

[<pie...@sy...>]

Hi,

 

What is wrong with my settings ?

 

When I run < mvn install >, I have the following error:

 

NetCDF gridcoverage module FAILURE

 

To correct the problem I have to change the function
testGranuleSourceFileView() in the file NetCDFMosaicReaderTest.java.

 

The two lines :

             assertEquals("2017-02-06 00:00:00.0",
nc1.getAttribute("time").toString());

             assertEquals("2017-02-06 12:00:00.0",
nc2.getAttribute("time").toString());

 

should be change for 

            assertEquals("2017-02-05 19:00:00.0",
nc1.getAttribute("time").toString());

            assertEquals("2017-02-06 07:00:00.0",
nc2.getAttribute("time").toString());

 

 

My computer is in the zone (UTC -05:00)  East (USA and Canada). It is
exactly the difference of time shown previously.

 

 

Regards,

 

 

Pierre