Bonjour à tous,
I have a dattime problem.
Through wfs, i insert my data
wfs:Insert
wims:foo
wims:issue_time2006-12-14T12:08:13.000</wims:issue_time>
wims:geometry
<gml:Polygon srsName=“urn:ogc:def:crs:EPSG:4326”>
gml:exterior
gml:LinearRing
gml:posList0.672702 49.9706 3.90024 49.97063 3.90024 47.6684 0.672702 47.6684 0.672702 49.9706</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:statusweatherproduct>
</wfs:Insert>
In my postgis database i have :
issue_time=2006-12-14 13:08:13.00
+1 hour, summer hour i think.
But postgis is configured with timezone=gmt
perhaps i need to configure geoserver ? anyidea ?
I also need to dump the exact sql request made by geoserver on postgis datastore.
Do you know in which package the sql is dumped ?
By settings log4j.category.org.geotools level to DEBUG, i do not have this information.
Which log4j properties do i hae to change ?
in web :
./src/main/java/log4j.properties
./target/classes/log4j.properties
./target/geoserver/WEB-INF/classes/log4j.properties
thanks for all !
···
--
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre __at__ meteo.fr
when i request via wfs the db, i get
<?xml version="1.0" encoding="UTF-8"?>
<wfs:FeatureCollection numberOfFeatures="x" ..... >
<gml:featureMembers>
<wims:foo gml:id="foo.2">
<gml:boundedBy>
<gml:Envelope srsName="urn:x-ogc:def:crs:EPSG:6.11.2:4326">
<gml:lowerCorner>45.2 2.04</gml:lowerCorner>
<gml:upperCorner>45.3 2.1</gml:upperCorner>
</gml:Envelope>
</gml:boundedBy>
*<wims:issue_time>2006-12-14T13:08:13+01:00</wims:issue_time>*
<wims:geometry>
<gml:Polygon srsName="urn:x-ogc:def:crs:EPSG:6.11.2:4326">
<gml:exterior>
<gml:LinearRing>
<gml:posList>45.2 2.04 45.3 2.04 45.3 2.1 45.3 2.04 45.2 2.04</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:foo>
it seems that the db is in timezone +01:00...
could it be a postGIS configuration problem ?
Sébastien Geindre a écrit :
Bonjour à tous,
I have a dattime problem.
Through wfs, i insert my data
<wfs:Insert>
<wims:foo>
<wims:issue_time>2006-12-14T12:08:13.000</wims:issue_time>
<wims:geometry>
<gml:Polygon srsName="urn:ogc:def:crs:EPSG:4326">
<gml:exterior>
<gml:LinearRing>
<gml:posList>0.672702 49.9706 3.90024 49.97063 3.90024 47.6684 0.672702 47.6684 0.672702 49.9706</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:statusweatherproduct>
</wfs:Insert>
In my postgis database i have :
issue_time=2006-12-14 *13*:08:13.00
+1 hour, summer hour i think.
But postgis is configured with timezone=gmt
perhaps i need to configure geoserver ? anyidea ?
I also need to dump the exact sql request made by geoserver on postgis datastore.
Do you know in which package the sql is dumped ?
By settings log4j.category.org.geotools level to DEBUG, i do not have this information.
Which log4j properties do i hae to change ?
in web :
./src/main/java/log4j.properties
./target/classes/log4j.properties
./target/geoserver/WEB-INF/classes/log4j.properties
thanks for all !
--
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre __at__ meteo.fr
------------------------------------------------------------------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre __at__ meteo.fr
Hi Sébastien,
What timezone are you in, any chance it is currently GMT+1. My guess
would be that because the date in your request does not specify the
timezone it is being converted to the local one.
Try specifying a "Z" at the end of your date time. For instance:
2006-12-14T12:08:13Z
The "Z" marks the date explicitly as being in GMT.
-Justin
Sébastien Geindre wrote:
when i request via wfs the db, i get
<?xml version="1.0" encoding="UTF-8"?>
<wfs:FeatureCollection numberOfFeatures="x" ..... >
<gml:featureMembers>
<wims:foo gml:id="foo.2">
<gml:boundedBy>
<gml:Envelope srsName="urn:x-ogc:def:crs:EPSG:6.11.2:4326">
<gml:lowerCorner>45.2 2.04</gml:lowerCorner>
<gml:upperCorner>45.3 2.1</gml:upperCorner>
</gml:Envelope>
</gml:boundedBy>
*<wims:issue_time>2006-12-14T13:08:13+01:00</wims:issue_time>*
<wims:geometry>
<gml:Polygon srsName="urn:x-ogc:def:crs:EPSG:6.11.2:4326">
<gml:exterior>
<gml:LinearRing>
<gml:posList>45.2 2.04 45.3 2.04 45.3 2.1 45.3 2.04 45.2
2.04</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:foo>
it seems that the db is in timezone +01:00...
could it be a postGIS configuration problem ?
Sébastien Geindre a écrit :
Bonjour à tous,
I have a dattime problem.
Through wfs, i insert my data
<wfs:Insert>
<wims:foo>
<wims:issue_time>2006-12-14T12:08:13.000</wims:issue_time>
<wims:geometry>
<gml:Polygon srsName="urn:ogc:def:crs:EPSG:4326">
<gml:exterior>
<gml:LinearRing>
<gml:posList>0.672702 49.9706 3.90024 49.97063
3.90024 47.6684 0.672702 47.6684 0.672702 49.9706</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:statusweatherproduct>
</wfs:Insert>
In my postgis database i have :
issue_time=2006-12-14 *13*:08:13.00
+1 hour, summer hour i think.
But postgis is configured with timezone=gmt
perhaps i need to configure geoserver ? anyidea ?
I also need to dump the exact sql request made by geoserver on postgis
datastore.
Do you know in which package the sql is dumped ?
By settings log4j.category.org.geotools level to DEBUG, i do not have
this information.
Which log4j properties do i hae to change ?
in web :
./src/main/java/log4j.properties
./target/classes/log4j.properties
./target/geoserver/WEB-INF/classes/log4j.properties
thanks for all !
--
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre __at__ meteo.fr
------------------------------------------------------------------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
Justin Deoliveira a écrit :
Hi Sébastien,
What timezone are you in, any chance it is currently GMT+1. My guess
would be that because the date in your request does not specify the
timezone it is being converted to the local one.
[root@anonymised.com featureTypes]# date
mar aoû 21 09:11:46 CEST 2007
Try specifying a "Z" at the end of your date time. For instance:
2006-12-14T12:08:13Z
The "Z" marks the date explicitly as being in GMT.
i try this, but unfortunately, it does not change anything.
insert : <wims:validity_start_time>2006-12-14T11:30:00.000Z</wims:validity_start_time>
after a getFeature : <wims:validity_start_time>2006-12-14T12:30:00+01:00</wims:validity_start_time>
i am in France GMT+01, with summer/winter time. So it seems to be the same dateTime !!!
But, consider that my database with timezone=GMT and i want to store my date in GMT/UTC.
When request date field on GMT, via wfs :
<ogc:PropertyIsBetween>
<ogc:PropertyName>validity_start_time</ogc:PropertyName>
<ogc:LowerBoundary>
<ogc:Literal>2006-12-14T11:30:00.000Z</ogc:Literal>
</ogc:LowerBoundary>
<ogc:UpperBoundary>
<ogc:Literal>2006-12-14T12:25:00.000Z</ogc:Literal>
</ogc:UpperBoundary>
</ogc:PropertyIsBetween>
Nothing in return.
If UpperBoundary is set to <ogc:Literal>2006-12-14T12:35:00.000Z</ogc:Literal>
I got the feature in return with :
<wims:validity_start_time>2006-12-14T12:30:00+01:00</wims:validity_start_time>
something wrong somewhere...
maybe the filter, comparison of date, translation in sql....
-Justin
Sébastien Geindre wrote:
when i request via wfs the db, i get
<?xml version="1.0" encoding="UTF-8"?>
<wfs:FeatureCollection numberOfFeatures="x" ..... >
<gml:featureMembers>
<wims:foo gml:id="foo.2">
<gml:boundedBy>
<gml:Envelope srsName="urn:x-ogc:def:crs:EPSG:6.11.2:4326">
<gml:lowerCorner>45.2 2.04</gml:lowerCorner>
<gml:upperCorner>45.3 2.1</gml:upperCorner>
</gml:Envelope>
</gml:boundedBy>
*<wims:issue_time>2006-12-14T13:08:13+01:00</wims:issue_time>*
<wims:geometry>
<gml:Polygon srsName="urn:x-ogc:def:crs:EPSG:6.11.2:4326">
<gml:exterior>
<gml:LinearRing>
<gml:posList>45.2 2.04 45.3 2.04 45.3 2.1 45.3 2.04 45.2 2.04</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:foo>
it seems that the db is in timezone +01:00...
could it be a postGIS configuration problem ?
Sébastien Geindre a écrit :
Bonjour à tous,
I have a dattime problem.
Through wfs, i insert my data
<wfs:Insert>
<wims:foo>
<wims:issue_time>2006-12-14T12:08:13.000</wims:issue_time>
<wims:geometry>
<gml:Polygon srsName="urn:ogc:def:crs:EPSG:4326">
<gml:exterior>
<gml:LinearRing>
<gml:posList>0.672702 49.9706 3.90024 49.97063 3.90024 47.6684 0.672702 47.6684 0.672702 49.9706</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:statusweatherproduct>
</wfs:Insert>
In my postgis database i have :
issue_time=2006-12-14 *13*:08:13.00
+1 hour, summer hour i think.
But postgis is configured with timezone=gmt
perhaps i need to configure geoserver ? anyidea ?
I also need to dump the exact sql request made by geoserver on postgis datastore.
Do you know in which package the sql is dumped ?
By settings log4j.category.org.geotools level to DEBUG, i do not have this information.
Which log4j properties do i hae to change ?
in web :
./src/main/java/log4j.properties
./target/classes/log4j.properties
./target/geoserver/WEB-INF/classes/log4j.properties
thanks for all !
--
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre __at__ meteo.fr
------------------------------------------------------------------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre __at__ meteo.fr
Hi Sébastien,
I have been playing around all morning trying to replicate this problem
and cant seem too...
So here is my next guess. From the sql logs on inserts it appears that
the sql statements drop the timzone from the input... and instead
convert to the local timzone first.
I wonder if this in conjunction with you configuring your database to
store dates in a timezone different then the locale might be throwing
things off.
How exactly are you configuring your database to store dates in GMT?
From the postgres docs there seem to be three ways:
1. The TZ environment variable used by the backend directly on
postmaster startup as the default time zone.
2. The PGTZ environment variable set at the client used by libpq to send
time zone information to the backend upon connection.
3. set timezone SQL sets the time zone for the session.
-Justin
Sébastien Geindre wrote:
Justin Deoliveira a écrit :
Hi Sébastien,
What timezone are you in, any chance it is currently GMT+1. My guess
would be that because the date in your request does not specify the
timezone it is being converted to the local one.
[root@anonymised.com featureTypes]# date
mar aoû 21 09:11:46 CEST 2007
Try specifying a "Z" at the end of your date time. For instance:
2006-12-14T12:08:13Z
The "Z" marks the date explicitly as being in GMT.
i try this, but unfortunately, it does not change anything.
insert :
<wims:validity_start_time>2006-12-14T11:30:00.000Z</wims:validity_start_time>
after a getFeature :
<wims:validity_start_time>2006-12-14T12:30:00+01:00</wims:validity_start_time>
i am in France GMT+01, with summer/winter time. So it seems to be the
same dateTime !!!
But, consider that my database with timezone=GMT and i want to store my
date in GMT/UTC.
When request date field on GMT, via wfs :
<ogc:PropertyIsBetween>
<ogc:PropertyName>validity_start_time</ogc:PropertyName>
<ogc:LowerBoundary>
<ogc:Literal>2006-12-14T11:30:00.000Z</ogc:Literal>
</ogc:LowerBoundary>
<ogc:UpperBoundary>
<ogc:Literal>2006-12-14T12:25:00.000Z</ogc:Literal>
</ogc:UpperBoundary>
</ogc:PropertyIsBetween>
Nothing in return.
If UpperBoundary is set to
<ogc:Literal>2006-12-14T12:35:00.000Z</ogc:Literal>
I got the feature in return with :
<wims:validity_start_time>2006-12-14T12:30:00+01:00</wims:validity_start_time>
something wrong somewhere...
maybe the filter, comparison of date, translation in sql....
-Justin
Sébastien Geindre wrote:
when i request via wfs the db, i get
<?xml version="1.0" encoding="UTF-8"?>
<wfs:FeatureCollection numberOfFeatures="x" ..... >
<gml:featureMembers>
<wims:foo gml:id="foo.2">
<gml:boundedBy>
<gml:Envelope srsName="urn:x-ogc:def:crs:EPSG:6.11.2:4326">
<gml:lowerCorner>45.2 2.04</gml:lowerCorner>
<gml:upperCorner>45.3 2.1</gml:upperCorner>
</gml:Envelope>
</gml:boundedBy>
*<wims:issue_time>2006-12-14T13:08:13+01:00</wims:issue_time>*
<wims:geometry>
<gml:Polygon srsName="urn:x-ogc:def:crs:EPSG:6.11.2:4326">
<gml:exterior>
<gml:LinearRing>
<gml:posList>45.2 2.04 45.3 2.04 45.3 2.1 45.3 2.04
45.2 2.04</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:foo>
it seems that the db is in timezone +01:00...
could it be a postGIS configuration problem ?
Sébastien Geindre a écrit :
Bonjour à tous,
I have a dattime problem.
Through wfs, i insert my data
<wfs:Insert>
<wims:foo>
<wims:issue_time>2006-12-14T12:08:13.000</wims:issue_time>
<wims:geometry>
<gml:Polygon srsName="urn:ogc:def:crs:EPSG:4326">
<gml:exterior>
<gml:LinearRing>
<gml:posList>0.672702 49.9706 3.90024 49.97063
3.90024 47.6684 0.672702 47.6684 0.672702 49.9706</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:statusweatherproduct>
</wfs:Insert>
In my postgis database i have :
issue_time=2006-12-14 *13*:08:13.00
+1 hour, summer hour i think.
But postgis is configured with timezone=gmt
perhaps i need to configure geoserver ? anyidea ?
I also need to dump the exact sql request made by geoserver on
postgis datastore.
Do you know in which package the sql is dumped ?
By settings log4j.category.org.geotools level to DEBUG, i do not
have this information.
Which log4j properties do i hae to change ?
in web :
./src/main/java/log4j.properties
./target/classes/log4j.properties
./target/geoserver/WEB-INF/classes/log4j.properties
thanks for all !
--
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre __at__ meteo.fr
------------------------------------------------------------------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
Justin Deoliveira a écrit :
Hi Sébastien,
I have been playing around all morning trying to replicate this problem
and cant seem too...
So here is my next guess. From the sql logs on inserts it appears that
the sql statements drop the timzone from the input... and instead
convert to the local timzone first.
I wonder if this in conjunction with you configuring your database to
store dates in a timezone different then the locale might be throwing
things off.
How exactly are you configuring your database to store dates in GMT?
>From the postgres docs there seem to be three ways:
1. The TZ environment variable used by the backend directly on
postmaster startup as the default time zone.
2. The PGTZ environment variable set at the client used by libpq to send
time zone information to the backend upon connection.
3. set timezone SQL sets the time zone for the session.
i did after database creation : ALTER DATABASE flysafe SET TimeZone=gmt;
-Justin
Sébastien Geindre wrote:
Justin Deoliveira a écrit :
Hi Sébastien,
What timezone are you in, any chance it is currently GMT+1. My guess
would be that because the date in your request does not specify the
timezone it is being converted to the local one.
[root@anonymised.com featureTypes]# date
mar aoû 21 09:11:46 CEST 2007
Try specifying a "Z" at the end of your date time. For instance:
2006-12-14T12:08:13Z
The "Z" marks the date explicitly as being in GMT.
i try this, but unfortunately, it does not change anything.
insert : <wims:validity_start_time>2006-12-14T11:30:00.000Z</wims:validity_start_time>
after a getFeature :
<wims:validity_start_time>2006-12-14T12:30:00+01:00</wims:validity_start_time>
i am in France GMT+01, with summer/winter time. So it seems to be the
same dateTime !!!
But, consider that my database with timezone=GMT and i want to store my
date in GMT/UTC.
When request date field on GMT, via wfs :
<ogc:PropertyIsBetween>
<ogc:PropertyName>validity_start_time</ogc:PropertyName>
<ogc:LowerBoundary>
<ogc:Literal>2006-12-14T11:30:00.000Z</ogc:Literal>
</ogc:LowerBoundary>
<ogc:UpperBoundary>
<ogc:Literal>2006-12-14T12:25:00.000Z</ogc:Literal>
</ogc:UpperBoundary>
</ogc:PropertyIsBetween>
Nothing in return.
If UpperBoundary is set to
<ogc:Literal>2006-12-14T12:35:00.000Z</ogc:Literal>
I got the feature in return with :
<wims:validity_start_time>2006-12-14T12:30:00+01:00</wims:validity_start_time>
something wrong somewhere...
maybe the filter, comparison of date, translation in sql....
-Justin
Sébastien Geindre wrote:
when i request via wfs the db, i get
<?xml version="1.0" encoding="UTF-8"?>
<wfs:FeatureCollection numberOfFeatures="x" ..... >
<gml:featureMembers>
<wims:foo gml:id="foo.2">
<gml:boundedBy>
<gml:Envelope srsName="urn:x-ogc:def:crs:EPSG:6.11.2:4326">
<gml:lowerCorner>45.2 2.04</gml:lowerCorner>
<gml:upperCorner>45.3 2.1</gml:upperCorner>
</gml:Envelope>
</gml:boundedBy>
*<wims:issue_time>2006-12-14T13:08:13+01:00</wims:issue_time>*
<wims:geometry>
<gml:Polygon srsName="urn:x-ogc:def:crs:EPSG:6.11.2:4326">
<gml:exterior>
<gml:LinearRing>
<gml:posList>45.2 2.04 45.3 2.04 45.3 2.1 45.3 2.04
45.2 2.04</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:foo>
it seems that the db is in timezone +01:00...
could it be a postGIS configuration problem ?
Sébastien Geindre a écrit :
Bonjour à tous,
I have a dattime problem.
Through wfs, i insert my data
<wfs:Insert>
<wims:foo>
<wims:issue_time>2006-12-14T12:08:13.000</wims:issue_time>
<wims:geometry>
<gml:Polygon srsName="urn:ogc:def:crs:EPSG:4326">
<gml:exterior>
<gml:LinearRing>
<gml:posList>0.672702 49.9706 3.90024 49.97063
3.90024 47.6684 0.672702 47.6684 0.672702 49.9706</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:statusweatherproduct>
</wfs:Insert>
In my postgis database i have :
issue_time=2006-12-14 *13*:08:13.00
+1 hour, summer hour i think.
But postgis is configured with timezone=gmt
perhaps i need to configure geoserver ? anyidea ?
I also need to dump the exact sql request made by geoserver on
postgis datastore.
Do you know in which package the sql is dumped ?
By settings log4j.category.org.geotools level to DEBUG, i do not
have this information.
Which log4j properties do i hae to change ?
in web :
./src/main/java/log4j.properties
./target/classes/log4j.properties
./target/geoserver/WEB-INF/classes/log4j.properties
thanks for all !
--
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre __at__ meteo.fr
------------------------------------------------------------------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre __at__ meteo.fr
i have set timezone='GMT' in postgresql.conf and it seems to work.
good news !
thanks for your help justin.
Sébastien Geindre a écrit :
Justin Deoliveira a écrit :
Hi Sébastien,
I have been playing around all morning trying to replicate this problem
and cant seem too...
So here is my next guess. From the sql logs on inserts it appears that
the sql statements drop the timzone from the input... and instead
convert to the local timzone first.
I wonder if this in conjunction with you configuring your database to
store dates in a timezone different then the locale might be throwing
things off.
How exactly are you configuring your database to store dates in GMT?
>From the postgres docs there seem to be three ways:
1. The TZ environment variable used by the backend directly on
postmaster startup as the default time zone.
2. The PGTZ environment variable set at the client used by libpq to send
time zone information to the backend upon connection.
3. set timezone SQL sets the time zone for the session.
i did after database creation : ALTER DATABASE flysafe SET TimeZone=gmt;
-Justin
Sébastien Geindre wrote:
Justin Deoliveira a écrit :
Hi Sébastien,
What timezone are you in, any chance it is currently GMT+1. My guess
would be that because the date in your request does not specify the
timezone it is being converted to the local one.
[root@anonymised.com featureTypes]# date
mar aoû 21 09:11:46 CEST 2007
Try specifying a "Z" at the end of your date time. For instance:
2006-12-14T12:08:13Z
The "Z" marks the date explicitly as being in GMT.
i try this, but unfortunately, it does not change anything.
insert : <wims:validity_start_time>2006-12-14T11:30:00.000Z</wims:validity_start_time>
after a getFeature :
<wims:validity_start_time>2006-12-14T12:30:00+01:00</wims:validity_start_time>
i am in France GMT+01, with summer/winter time. So it seems to be the
same dateTime !!!
But, consider that my database with timezone=GMT and i want to store my
date in GMT/UTC.
When request date field on GMT, via wfs :
<ogc:PropertyIsBetween>
<ogc:PropertyName>validity_start_time</ogc:PropertyName>
<ogc:LowerBoundary>
<ogc:Literal>2006-12-14T11:30:00.000Z</ogc:Literal>
</ogc:LowerBoundary>
<ogc:UpperBoundary>
<ogc:Literal>2006-12-14T12:25:00.000Z</ogc:Literal>
</ogc:UpperBoundary>
</ogc:PropertyIsBetween>
Nothing in return.
If UpperBoundary is set to
<ogc:Literal>2006-12-14T12:35:00.000Z</ogc:Literal>
I got the feature in return with :
<wims:validity_start_time>2006-12-14T12:30:00+01:00</wims:validity_start_time>
something wrong somewhere...
maybe the filter, comparison of date, translation in sql....
-Justin
Sébastien Geindre wrote:
when i request via wfs the db, i get
<?xml version="1.0" encoding="UTF-8"?>
<wfs:FeatureCollection numberOfFeatures="x" ..... >
<gml:featureMembers>
<wims:foo gml:id="foo.2">
<gml:boundedBy>
<gml:Envelope srsName="urn:x-ogc:def:crs:EPSG:6.11.2:4326">
<gml:lowerCorner>45.2 2.04</gml:lowerCorner>
<gml:upperCorner>45.3 2.1</gml:upperCorner>
</gml:Envelope>
</gml:boundedBy>
*<wims:issue_time>2006-12-14T13:08:13+01:00</wims:issue_time>*
<wims:geometry>
<gml:Polygon srsName="urn:x-ogc:def:crs:EPSG:6.11.2:4326">
<gml:exterior>
<gml:LinearRing>
<gml:posList>45.2 2.04 45.3 2.04 45.3 2.1 45.3 2.04
45.2 2.04</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:foo>
it seems that the db is in timezone +01:00...
could it be a postGIS configuration problem ?
Sébastien Geindre a écrit :
Bonjour à tous,
I have a dattime problem.
Through wfs, i insert my data
<wfs:Insert>
<wims:foo>
<wims:issue_time>2006-12-14T12:08:13.000</wims:issue_time>
<wims:geometry>
<gml:Polygon srsName="urn:ogc:def:crs:EPSG:4326">
<gml:exterior>
<gml:LinearRing>
<gml:posList>0.672702 49.9706 3.90024 49.97063
3.90024 47.6684 0.672702 47.6684 0.672702 49.9706</gml:posList>
</gml:LinearRing>
</gml:exterior>
</gml:Polygon>
</wims:geometry>
</wims:statusweatherproduct>
</wfs:Insert>
In my postgis database i have :
issue_time=2006-12-14 *13*:08:13.00
+1 hour, summer hour i think.
But postgis is configured with timezone=gmt
perhaps i need to configure geoserver ? anyidea ?
I also need to dump the exact sql request made by geoserver on
postgis datastore.
Do you know in which package the sql is dumped ?
By settings log4j.category.org.geotools level to DEBUG, i do not
have this information.
Which log4j properties do i hae to change ?
in web :
./src/main/java/log4j.properties
./target/classes/log4j.properties
./target/geoserver/WEB-INF/classes/log4j.properties
thanks for all !
--
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre __at__ meteo.fr
------------------------------------------------------------------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre __at__ meteo.fr