The times in the database will be in UTC, and I guess you're in
UTC+!. Add -Duser.timezone=GMT to make it work as you expect
Ian
On Thu, 2 Mar 2023 at 16:37, Jeroen van Gent
<jeroen.vang...@aeronomie.be <mailto:jeroen.vang...@aeronomie.be>> wrote:
Hello all,
I have been trying to create an Imagemosaic GeoTiff data store,
using a Postgres database.
The typical filename pattern for the GeoTiffs is:
s5p_tropomi_so2vcd_epsg3857_{yyyyMMdd}T{HHmmss}_{orbitnumber}.tiff,
for example:
s5p_tropomi_so2vcd_epsg3857_20220604T210415_27650.tiff.
I have declared the following regular expression in
'timeregex.properties':
regex=_[0-9]{8}T[0-9]{6}_,format='_'yyyyMMdd'T'HHmmss'_'
I can successfully create the store, and files seems to be
properly ingested into the database, but when looking in the
database table, the entries seem to give the correct date, but
the wrong time, at least for the hour field:
| location | ingestion
|
| s5p_tropomi_so2vcd_epsg3857_20230213T120806_27653.tiff | 2023-02-13
13:08:06 |
| s5p_tropomi_so2vcd_epsg3857_20220604T021341_27650.tiff | 2022-06-04
04:13:41 |
| s5p_tropomi_so2vcd_epsg3857_20220604T210415_27650.tiff | 2022-06-04
23:04:15 |
Some relevant lines from the GeoServer logs:
SELECT count(*) FROM "public"."s5p_tropomi_so2vcd_epsg3857_test" WHERE ("location" =
? AND "location" IS NOT NULL )
2023-03-02 16:22:56,601 DEBUG [geotools.jdbc] - 1 =
s5p_tropomi_so2vcd_epsg3857_20220604T021341_27650.tiff
2023-03-02 16:22:56,601 DEBUG [geotools.jdbc] - SELECT "fid",ST_AsEWKB("the_geom") as
"the_geom","location","ingestion" FROM "public"."s5p_tropomi_so2vcd_epsg3857_test" LIMIT 1
2023-03-02 16:22:56,602 DEBUG [geotools.jdbc] - SELECT
ST_AsText(ST_Force2D(ST_Envelope(ST_Extent("the_geom"::geometry)))) FROM
"public"."s5p_tropomi_so2vcd_epsg3857_test"
2023-03-02 16:22:56,604 DEBUG [geotools.jdbc] - SELECT "fid",ST_AsEWKB("the_geom") as
"the_geom","location","ingestion" FROM "public"."s5p_tropomi_so2vcd_epsg3857_test" WHERE 0 = 1
2023-03-02 16:22:56,605 DEBUG [geotools.jdbc] - Setting the_geom to POLYGON
((-20026376.39 -20048673.9, -20026376.39 20048966.1, 20026863.61 20048966.1,
20026863.61 -20048673.9, -20026376.39 -20048673.9))
2023-03-02 16:22:56,605 DEBUG [geotools.jdbc] - Setting 0 to POLYGON
((-20026376.39 -20048673.9, -20026376.39 20048966.1, 20026863.61 20048966.1,
20026863.61 -20048673.9, -20026376.39 -20048673.9))
2023-03-02 16:22:56,605 DEBUG [geotools.jdbc] - Setting location to
s5p_tropomi_so2vcd_epsg3857_20220604T021341_27650.tiff
2023-03-02 16:22:56,605 DEBUG [geotools.jdbc] - Setting 1 to
s5p_tropomi_so2vcd_epsg3857_20220604T021341_27650.tiff
2023-03-02 16:22:56,605 DEBUG [geotools.jdbc] - Setting ingestion to
2022-06-04 04:13:41.0
2023-03-02 16:22:56,605 DEBUG [geotools.jdbc] - Setting 2 to 2022-06-04
04:13:41.0
2023-03-02 16:22:56,605 DEBUG [geotools.jdbc] - Inserting new features with ps: INSERT INTO
"public"."s5p_tropomi_so2vcd_epsg3857_test" ( "the_geom","location","ingestion"
) VALUES ( ST_GeomFromWKB(?, 3857),?,?)
2023-03-02 16:22:56,605 DEBUG [geotools.jdbc] - 1 = POLYGON ((-20026376.39
-20048673.9, -20026376.39 20048966.1, 20026863.61 20048966.1, 20026863.61
-20048673.9, -20026376.39 -20048673.9))
2023-03-02 16:22:56,605 DEBUG [geotools.jdbc] - 2 =
s5p_tropomi_so2vcd_epsg3857_20220604T021341_27650.tiff
2023-03-02 16:22:56,605 DEBUG [geotools.jdbc] - 3 = 2022-06-04 04:13:41.0
For what it's worth: the *.properties files are in the same
folder as my data files.
I am using GeoServer 2.20.2.
Any suggestions?
Thanks,
Jeroen
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before
posting to this list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ianturton.com%2Ftalks%2Ffoss4g.html%23%2F&data=05%7C01%7CJan_Tjalling.vanderWal%40wur.nl%7C596b7bba161943b7c85308db1b5a69d9%7C27d137e5761f4dc1af88d26430abb18f%7C0%7C0%7C638133847381282721%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=5gWDV%2Ffx%2FaCDF%2F%2FxL0Rhrhwo%2FtBywgEsE9BarsKZoS4%3D&reserved=0>
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeoserver.org%2Fcomm%2Fuserlist-guidelines.html&data=05%7C01%7CJan_Tjalling.vanderWal%40wur.nl%7C596b7bba161943b7c85308db1b5a69d9%7C27d137e5761f4dc1af88d26430abb18f%7C0%7C0%7C638133847381282721%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=DeEBXxdNRqhNLIPD6SKb70AB%2F%2BwL%2FJ1MdmPHWQ8Hjms%3D&reserved=0>
If you want to request a feature or an improvement, also see
this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fgeoserver%2Fgeoserver%2Fwiki%2FSuccessfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer&data=05%7C01%7CJan_Tjalling.vanderWal%40wur.nl%7C596b7bba161943b7c85308db1b5a69d9%7C27d137e5761f4dc1af88d26430abb18f%7C0%7C0%7C638133847381282721%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=eKynav7yEFeKZiwsFKQWaOy17XacIvdHcCQ2Nk7e0Ds%3D&reserved=0>
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fgeoserver-users&data=05%7C01%7CJan_Tjalling.vanderWal%40wur.nl%7C596b7bba161943b7c85308db1b5a69d9%7C27d137e5761f4dc1af88d26430abb18f%7C0%7C0%7C638133847381282721%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=s1ogLtU3rtjuAqk%2Bp6VHM4%2FAxB75GTyHAU9Bxs0z2YA%3D&reserved=0>
--
Ian Turton
