[Geoserver-users] Wrong bounding box in layer with Sinusoidal projection

[Diego Nieto Cid]

Hello

I'm having some trouble with a layer using the Sinusoidal projection. When
I edit it's configuration the calculated lat/long bounding box is wrong
resulting in the layer being misplaced.

When I open the shapefile in QGIS Desktop (2.8.7-Wien) I can see that it
uses the following projection definition (proj4):

+proj=sinu +lon_0=0 +x_0=0 +y_0=0 +a=6371007.181 +b=6371007.181
+units=m +no_defs

and, as there's no sinusoidal projection in GeoServer's SRS list, I added
it to user_projections/epsg.properties under code 11 where I copied the
WKT text from the accompanying prj file (which I attached).

When I publish the layer I use the following SRS configuration, with
bounding boxes calculated by geoserver:

Native SRS
UNKNOWN - Sinusoidal...

Declared SRS
EPSG:11 - Sinusoidal...

Reproject (but I beleive it makes no difference)

Native BBOX

Min X : -5,510,409.794019982
Min Y : -3,667,583.463717
Máx X : -5,505,545.010496439
Máx Y : -3,662,718.6804764285

Lat/Lon BBOX

Min X : -59.07789581211166
Min Y : -33.158781662023415
Máx X : -58.99652065907146
Máx Y : -33.11491197687222

The problem is the Y coordinate of the Lat/Lon BBOX. GeoServer thinks it's
around -33.13. However, opening the shapefile in QGIS, and using on the fly
SRS transformation to get WGS84 coordinates, I can see the layer located
around (-59.03, -32.95).

I believe QGIS is showing the right coordinates because it's putting it "in
the right place" relative to other layers I have which use the WGS84
projection.

Anybody knows what's going on? How can I debug it? Or fix it?

Thanks!
Diego

---

PS: My environment is as follows:

GeoServer 2.8.4
Container: Tomcat 7 (JBoss EWS 2.0) [at OpenShift]
Java:
java version "1.7.0_101"
OpenJDK Runtime Environment (rhel-2.6.6.1.el6_7-i386 u101-b00)
OpenJDK Server VM (build 24.95-b01, mixed mode)


grilla_modis_LC_MB.prj
Description: Binary data
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] How to serve large spatio-temporal dataset with GeoServer?

[Peter Kovac]

Dear Andrea,

thank you for this deep insight into why Postgres/PostGIS with GeoServer 
rocks! You were totally right!


I just made an exact clone of the lightning table in PostGIS and there 
is no observable difference in performance whether I'm looking at whole 
Europe (just a couple hundred ms) or just a tiny village unfortunate 
enough to have a major thunderstorm. It's amazing.



BTW, if there's anybody wondering how to migrate table from Oracle 
Locator/Spatial to PostGIS, here's a link describing usage of another 
excellent open source software ogr2ogr: 
http://words.mixedbredie.net/archives/1751



Thank you again!


On 22. 6. 2016 14:31, Andrea Aime wrote:
On Wed, Jun 22, 2016 at 2:15 PM, Jonathan Moules 
> 
wrote:


While Andrea has an (understandable) leaning towards PostGres, I'd
be surprised if you can't optimise Oracle to get the desired
result too if you're fixed with that (but if you're not - PostGres
would probably be a worthwhile change).


The leaning has some explanation, that goes beyond the natural 
sympathy for another open source project.
GeoServer is translating every OGC request into the best query it can 
setup, but the translation
is still, after all, automatic, with little or no control on the admin 
side (sql views might help to some extent).


In Oracle developers decided to add query hints, every time a query 
misbehaves you can add one of those to force the better
execution path... that's nice, as long as you can control how the 
queries are written  but that's not the case in GeoServer.
Of course that reduced pressure to improve the query planner (and made 
the Oracle consultant market a bigger and more

profitable one).

In PostgreSql developers instead refused to add query hints support, 
and treated every case in which the optimizer took
the wrong path as a bug. At the beginning that was pretty painful, but 
over time the planner evolved to the point that it's actually
very good... this couples well with an automatic query generator, as 
long as the query is valid the db should not need

any help using the best access path.

If you think about it setting up a WFS (or a WMS with CQL_FILTER) is 
really like saying "hey, here is my database, hit it with whatever you 
want", since
people can literally write the filter they feel like, with no 
limitation on complexity.
The is no query hint salvation there, each query is dynamic and 
defined by the user at the time the request is made...
either the database is smart and fast on its own, without query 
specific help from a human, or you're in for a pile of troubles.


Cheers
Andrea

--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o 
nel/i file/s allegato/i sono da considerarsi strettamente riservate. 
Il loro utilizzo è consentito esclusivamente al destinatario del 
messaggio, per le finalità indicate nel messaggio stesso. Qualora 
riceviate questo messaggio senza esserne il destinatario, Vi preghiamo 
cortesemente di darcene notizia via e-mail e di procedere alla 
distruzione del messaggio stesso, cancellandolo dal Vostro sistema. 
Conservare il messaggio stesso, divulgarlo anche in parte, 
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità 
diverse, costituisce comportamento contrario ai principi dettati dal 
D.Lgs. 196/2003.


The information in this message and/or attachments, is intended solely 
for the attention and use of the named addressee(s) and may be 
confidential or proprietary in nature or covered by the provisions of 
privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New 
Data Protection Code).Any use not in accord with its purpose, any 
disclosure, reproduction, copying, distribution, or either 
dissemination, either whole or partial, is strictly forbidden except 
previous formal approval of the named addressee(s). If you are not the 
intended recipient, please contact immediately the sender by 
telephone, fax or e-mail and delete the information in this message 
that has been received in error. The sender does not give any warranty 
or accept liability as the content, accuracy or completeness of sent 
messages and accepts no responsibility  for changes made after they 
were sent or for other risks which arise as a result of e-mail 
transmission, viruses, etc.



---


--
Peter Kovac
IMS Programmer
MicroStep-MIS
peter.ko...@microstep-mis.com

--
Attend Shape: An 

Re: [Geoserver-users] How to serve large spatio-temporal dataset with GeoServer?

[Jonathan Moules]

Hi Andrea,
I wasn't trying to downplay your penchant to push PostGres, it's something 
I understand and agree with. Your explanation of the differences was very 
informative - I've seen posts mentioning them in passing before, but this was a 
little more in depth, thanks for sharing.

Cheers,
Jonathan


 On Wed, 22 Jun 2016 13:31:39 +0100 Andrea 
Aimeandrea.a...@geo-solutions.it wrote  

On Wed, Jun 22, 2016 at 2:15 PM, Jonathan Moules 
jonathan-li...@lightpear.com wrote:
While Andrea has an (understandable) leaning towards PostGres, I'd be surprised 
if you can't optimise Oracle to get the desired result too if you're fixed with 
that (but if you're not - PostGres would probably be a worthwhile change).




The leaning has some explanation, that goes beyond the natural sympathy for 
another open source project.
GeoServer is translating every OGC request into the best query it can setup, 
but the translation
is still, after all, automatic, with little or no control on the admin side 
(sql views might help to some extent).


In Oracle developers decided to add query hints, every time a query misbehaves 
you can add one of those to force the better
execution path... that's nice, as long as you can control how the queries are 
written  but that's not the case in GeoServer.
Of course that reduced pressure to improve the query planner (and made the 
Oracle consultant market a bigger and more 
profitable one).


In PostgreSql developers instead refused to add query hints support, and 
treated every case in which the optimizer took
the wrong path as a bug. At the beginning that was pretty painful, but over 
time the planner evolved to the point that it's actually
very good... this couples well with an automatic query generator, as long as 
the query is valid the db should not need
any help using the best access path.


If you think about it setting up a WFS (or a WMS with CQL_FILTER) is really 
like saying "hey, here is my database, hit it with whatever you want", since
people can literally write the filter they feel like, with no limitation on 
complexity. 
The is no query hint salvation there, each query is dynamic and defined by the 
user at the time the request is made... 
either the database is smart and fast on its own, without query specific help 
from a human, or you're in for a pile of troubles.


Cheers
Andrea



-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==





Ing. Andrea Aime 

@geowolf
Technical Lead


GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313

fax: +39 0584 1660272
mob: +39  339 8844549


http://www.geo-solutions.it
http://twitter.com/geosolutions_it


AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i 
file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo 
è consentito esclusivamente al destinatario del messaggio, per le finalità 
indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne 
il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di 
procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro 
sistema. Conservare il messaggio stesso, divulgarlo anche in parte, 
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, 
costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
 
The information in this message and/or attachments, is intended solely for the 
attention and use of the named addressee(s) and may be confidential or 
proprietary in nature or covered by the provisions of privacy act (Legislative 
Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in 
accord with its purpose, any disclosure, reproduction, copying, distribution, 
or either dissemination, either whole or partial, is strictly forbidden except 
previous formal approval of the named addressee(s). If you are not the intended 
recipient, please contact immediately the sender by telephone, fax or e-mail 
and delete the information in this message that has been received in error. The 
sender does not give any warranty or accept liability as the content, accuracy 
or completeness of sent messages and accepts no responsibility  for changes 
made after they were sent or for other risks which arise as a result of e-mail 
transmission, viruses, etc.



---










 

 




--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Geoserver-users mailing list

Re: [Geoserver-users] How to serve large spatio-temporal dataset with GeoServer?

[Andrea Aime]

On Wed, Jun 22, 2016 at 2:15 PM, Jonathan Moules <
jonathan-li...@lightpear.com> wrote:

> While Andrea has an (understandable) leaning towards PostGres, I'd be
> surprised if you can't optimise Oracle to get the desired result too if
> you're fixed with that (but if you're not - PostGres would probably be a
> worthwhile change).
>

The leaning has some explanation, that goes beyond the natural sympathy for
another open source project.
GeoServer is translating every OGC request into the best query it can
setup, but the translation
is still, after all, automatic, with little or no control on the admin side
(sql views might help to some extent).

In Oracle developers decided to add query hints, every time a query
misbehaves you can add one of those to force the better
execution path... that's nice, as long as you can control how the queries
are written  but that's not the case in GeoServer.
Of course that reduced pressure to improve the query planner (and made the
Oracle consultant market a bigger and more
profitable one).

In PostgreSql developers instead refused to add query hints support, and
treated every case in which the optimizer took
the wrong path as a bug. At the beginning that was pretty painful, but over
time the planner evolved to the point that it's actually
very good... this couples well with an automatic query generator, as long
as the query is valid the db should not need
any help using the best access path.

If you think about it setting up a WFS (or a WMS with CQL_FILTER) is really
like saying "hey, here is my database, hit it with whatever you want", since
people can literally write the filter they feel like, with no limitation on
complexity.
The is no query hint salvation there, each query is dynamic and defined by
the user at the time the request is made...
either the database is smart and fast on its own, without query specific
help from a human, or you're in for a pile of troubles.

Cheers
Andrea

-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

---
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] How to serve large spatio-temporal dataset with GeoServer?

[Jonathan Moules]

Hi Peter,
To build on the other answers you've received - you need to create indexes that 
the database will use. This applies to all relational databases - Oracle/SQL 
Server/PostGres/Sqlite, etc.

When you send a query to a database there's a query planner which takes your 
query and tries to determine the optimal way to execute it. It looks at what 
indexes you have and tries to decide which, if any, will get it the answer the 
fastest. Sometimes it will decide an index won't help.
Just having an index on a particular column (or set of columns) doesn't mean 
the database will use it.
Some reading around the topic: 
http://docs.oracle.com/cd/B19306_01/server.102/b14211/optimops.htm
http://docs.oracle.com/cd/B19306_01/server.102/b14211/ex_plan.htm

(Note: Different databases have different planners and work differently - 
that's all Oracle specific).

I'd suggest taking the query that is slow for you, and trying to optimise the 
database around it by using the EXPLAIN function and seeing where it's spending 
all of its time.


While Andrea has an (understandable) leaning towards PostGres, I'd be surprised 
if you can't optimise Oracle to get the desired result too if you're fixed with 
that (but if you're not - PostGres would probably be a worthwhile change).

Cheers,
Jonathan

 On Wed, 22 Jun 2016 09:33:57 +0100 Andrea 
Aimeandrea.a...@geo-solutions.it wrote  

On Wed, Jun 22, 2016 at 10:02 AM, Peter Kovac 
peter.ko...@microstep-mis.com wrote:
  Hi Andrea,
 what do you mean with "deciding which one to use"? AFAIK it has to use both, 
(almost) all the time.

According to what Bruce Momjan told me a few years ago, not always. He was 
going over some statistics
on index usage, and when it's actually more efficient to use an index than to 
do a linear scan, and the
threshold was less than 10% of the data (can't remember the actual value), in 
other terms, index access is faster 
than a linear scan in postgresql only if the index selects less than 10% of the 
overall data.
Based on that, the planner will decide to use no index, only one, or both, 
based on their selectivity.


In your case it seems you're constraining much more on time than on space, if 
that's the case there is a chance
only the time index will be used, because using the other one as well might 
result in slower execution.
 

 This is the query found in GeoServer logs (LOCATION is the point geometry 
column with a spatial index):
 SELECT ID,TIME,LOCATION
 FROM lightning_strikes
 WHERE  (
   TIME BETWEEN ? AND ?
   AND SDO_FILTER(LOCATION, ?, 'mask=anyinteract querytype=WINDOW') = 'TRUE')
 )
 
 Let's say I want just 1 hour worth of lightning strikes but from almost all of 
the central Europe (so the BBOX is not covering the whole dataset but covers 
90% of it).
 The 'TIME BETWEEN' clause quickly filters 3M rows to let's say 10K lightnings. 
However, some of them lie outside of the BBOX. So it has to filter them out. 
Unfortunately, there are millions of other records in the same BBOX, so the 
spatial index finds them all and then the database engine has to make 
intersection of the two sets. Since one of them is huge, it takes time. And it 
will get worse over time.



Yes!
 
 
 OK, maybe I see your point now. The DB engine could just check each row from 
the smaller set if it is inside the BBOX, without using the spatial index. I 
wonder if PostGIS can do it. I'll give it a try.



In my experience it does. Let us know how it goes.


Cheers
Andrea





-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==





Ing. Andrea Aime 

@geowolf
Technical Lead


GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313

fax: +39 0584 1660272
mob: +39  339 8844549


http://www.geo-solutions.it
http://twitter.com/geosolutions_it


AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i 
file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo 
è consentito esclusivamente al destinatario del messaggio, per le finalità 
indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne 
il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di 
procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro 
sistema. Conservare il messaggio stesso, divulgarlo anche in parte, 
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, 
costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
 
The information in this message and/or attachments, is intended solely for the 
attention and use of the named addressee(s) and may be confidential or 
proprietary in nature or covered by the provisions of privacy act (Legislative 
Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in 
accord with its purpose, any disclosure, reproduction, copying, distribution, 
or either 

Re: [Geoserver-users] How to serve large spatio-temporal dataset with GeoServer?

[Julian Hollingbery]

Hi,

I think the point is, which index to use *first* ☺

My two cents, by the way: If you can narrow your use cases down from ”any time 
interval, in any area”, you might consider pre-processing (aggregating) the 
data in e.g. 1-hour, 1-day, 1-week, etc. chunks, or similarly, geographic 
chunks of, say 100km x 100km, similar to the idea behind tiled maps.

But before you do that: Try PostGIS.

/julian

Fra: Peter Kovac [mailto:peter.ko...@microstep-mis.com]
Sendt: 22. juni 2016 10:02
Til: Andrea Aime 
Cc: GeoServer Mailing List List 
Emne: Re: [Geoserver-users] How to serve large spatio-temporal dataset with 
GeoServer?


Hi Andrea,

what do you mean with "deciding which one to use"? AFAIK it has to use both, 
(almost) all the time.

This is the query found in GeoServer logs (LOCATION is the point geometry 
column with a spatial index):

SELECT ID,TIME,LOCATION
FROM lightning_strikes
WHERE  (
  TIME BETWEEN ? AND ?
  AND SDO_FILTER(LOCATION, ?, 'mask=anyinteract querytype=WINDOW') = 'TRUE')
)
Let's say I want just 1 hour worth of lightning strikes but from almost all of 
the central Europe (so the BBOX is not covering the whole dataset but covers 
90% of it).
The 'TIME BETWEEN' clause quickly filters 3M rows to let's say 10K lightnings. 
However, some of them lie outside of the BBOX. So it has to filter them out. 
Unfortunately, there are millions of other records in the same BBOX, so the 
spatial index finds them all and then the database engine has to make 
intersection of the two sets. Since one of them is huge, it takes time. And it 
will get worse over time.

OK, maybe I see your point now. The DB engine could just check each row from 
the smaller set if it is inside the BBOX, without using the spatial index. I 
wonder if PostGIS can do it. I'll give it a try.


Thank you

On 21. 6. 2016 17:47, Andrea Aime wrote:
Hi Peter,
from my experience Oracle is probably the cause, given a spatial and a regular 
index
it has sometimes issues deciding which one to use and ends up using the wrong 
one.
You should try PostGis, with proper indexes and statistics setup, with "only" 3 
million records
it should respond fast.

Worth investigating at the very least, let us know how it goes.

Cheers
Andrea


On Tue, Jun 21, 2016 at 4:22 PM, Peter Kovac 
> wrote:
Dear GeoServer users,

I have trouble figuring out fast and scalable way to serve lightning
data via GeoServer.

My dataset consists of several million points spread over central Europe
spanning several years. I have approximately 3M lightning strikes right
now and it's just a fraction of what I'll have to handle ultimately. I'm
using Oracle Locator database with both spatial and normal indexes and
while it has a few quirks it works reasonably well when the amount of
lightnings is small (i.e. in thousands or tens of thousands).

While my WMS client will never allow to show more than 2 hours worth of
data (that's small amount of lightning strikes) there are particular WMS
requests which take a very long time: when I want to see a "bigger
picture" of all lightning strikes in central Europe during a specified
short period of time.

The core of the problem is my data have both spatial and temporal
dimension and there is no spatio-temporal index in Oracle Locator. So
even if regular index on the time dimension can limit the number of
features to a few thousands in the blink of an eye, the spatial index
over the point geometry column won't help much (since the BBOX in the
request covers the whole area anyway) and is in fact doing harm. The
query found in GeoServer logs runs really fast If I omit the spatial
index clause in such case (just a few hundred ms compared to 6-7 seconds
for the full query with SDO_FILTER function call). Another bad thing is
my colleagues predict that the performance will get worse with more data
in the table once it won't fit into RAM and the database engine will
have to use hard drives for processing.

The performance improves rapidly as I zoom to larger scales (smaller
areas), where the spatial index selects just a small subset of data.
However, I'd like to be able to serve the whole central Europe quickly, too.

One possible solution is to add the time dimension to my spatial index
(so it's 3D instead of 2D), but I'm afraid GeoServer won't be able to
retrieve data from such index (it won't be EPSG:3857 geometry anymore).

Another solution from an Oracle forum suggests using partitioning over
time and have separate spatial index for each partition, but that
requires expensive Oracle Enterprise license (which was not budgeted in
the project of course) and it's just dividing the problem by a constant
factor anyway.

So, since I'm out of my own ideas, how would you handle this situation?
What other tools or formats are useful? Is the Postgres/PostGIS combo
better at serving large-scale spatio-temporal 

[Geoserver-users] ImageMosaic publish error - Unable to acquire test coverage for format:ImageMosaic

[Rochelle OHAGAN]

Hello,


I am trying to use ImageMosaic to publish a time series of VHI images. I can 
create the datastore, but when I try to publish, I get the error below. I have 
set the directory and file permissions to allow read/write access and changed 
the owner to tomcat7. The GeoTiffs can be loaded and viewed individually by 
GeoServer.


The gdalinfo for the GeoTiff is:

Driver: GTiff/GeoTIFF

Files: idn_phy_MODIS_201508.1_km_monthly_EVI_LST_VHI.tif

Size is 5503, 2030

Coordinate System is:

GEOGCS["WGS 84",

DATUM["WGS_1984",

SPHEROID["WGS 84",6378137,298.257223563,

AUTHORITY["EPSG","7030"]],

AUTHORITY["EPSG","6326"]],

PRIMEM["Greenwich",0],

UNIT["degree",0.0174532925199433],

AUTHORITY["EPSG","4326"]]

Origin = (94.996602323078150,5.957979463531878)

Pixel Size = (0.008365616936217,-0.008365616936217)

Metadata:

  AREA_OR_POINT=Area

  DataType=Generic

Image Structure Metadata:

  COMPRESSION=LZW

  INTERLEAVE=BAND

Corner Coordinates:

Upper Left  (  94.9966023,   5.9579795) ( 94d59'47.77"E,  5d57'28.73"N)

Lower Left  (  94.9966023, -11.0242229) ( 94d59'47.77"E, 11d 1'27.20"S)

Upper Right ( 141.0325923,   5.9579795) (141d 1'57.33"E,  5d57'28.73"N)

Lower Right ( 141.0325923, -11.0242229) (141d 1'57.33"E, 11d 1'27.20"S)

Center  ( 118.0145973,  -2.5331217) (118d 0'52.55"E,  2d31'59.24"S)

Band 1 Block=128x128 Type=Float64, ColorInterp=Gray

  NoData Value=-1.79769313486231571e+308

  Metadata:

SourceBandIndex=0


java.lang.RuntimeException: Error occurred while building the resources for the 
configuration page at 
org.geoserver.web.data.layer.NewLayerPage.buildLayerInfo(NewLayerPage.java:356) 
at org.geoserver.web.data.layer.NewLayerPage$8.onClick(NewLayerPage.java:281) 
at org.geoserver.web.wicket.SimpleAjaxLink$1.onClick(SimpleAjaxLink.java:46) at 
org.apache.wicket.ajax.markup.html.AjaxLink$1.onEvent(AjaxLink.java:68) at 
org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:177) at 
org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:300)
 at 
org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:119)
 at 
org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92)
 at 
org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1250) 
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329) at 
org.apache.wicket.RequestCycle.steps(RequestCycle.java:1436) at 
org.apache.wicket.RequestCycle.request(RequestCycle.java:545) at 
org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:484) at 
org.apache.wicket.protocol.http.WicketServlet.doGet(WicketServlet.java:138) at 
javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at 
javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at 
org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:156)
 at 
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
 at 
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
 at 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919)
 at com.boundlessgeo.geoserver.AppDispatcher.doDispatch(AppDispatcher.java:67) 
at 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851)
 at 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)
 at 
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:844)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at 
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
 at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at 
org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:28)
 at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at 
org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:75)
 at org.geoserver.wms.animate.AnimatorFilter.doFilter(AnimatorFilter.java:71) 
at 
org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:71)
 at com.boundlessgeo.geoserver.AppAuthFilter.doFilter(AppAuthFilter.java:111) 
at 
org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:71)
 at 
org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:46)
 at 

Re: [Geoserver-users] Time Zone issue with dates using GeoServer WFS

[Chris Buckmaster]

That sounds like what I might need – is that altering the config file in the 
WEB-INF folder? Is there documentation online for carrying this out?


From: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] On Behalf Of Andrea 
Aime
Sent: 22 June 2016 09:54
To: Chris Buckmaster
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Time Zone issue with dates using GeoServer WFS

On Wed, Jun 22, 2016 at 10:52 AM, Chris Buckmaster 
> 
wrote:
Ah, bummer – any suggestions when using version 2.5, or would I need to 
upgrade? Or any ways I can serve my data in different ways so it will not 
modify my dates and introduce time zone details?

GeoServer reports dates and times in GMT, so you can set the entire system to 
be on GMT to avoid shifts.

Cheers
Andrea

--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


AVVERTENZE AI SENSI DEL D.Lgs. 196/2003

Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i 
file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo 
è consentito esclusivamente al destinatario del messaggio, per le finalità 
indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne 
il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di 
procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro 
sistema. Conservare il messaggio stesso, divulgarlo anche in parte, 
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, 
costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for the 
attention and use of the named addressee(s) and may be confidential or 
proprietary in nature or covered by the provisions of privacy act (Legislative 
Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in 
accord with its purpose, any disclosure, reproduction, copying, distribution, 
or either dissemination, either whole or partial, is strictly forbidden except 
previous formal approval of the named addressee(s). If you are not the intended 
recipient, please contact immediately the sender by telephone, fax or e-mail 
and delete the information in this message that has been received in error. The 
sender does not give any warranty or accept liability as the content, accuracy 
or completeness of sent messages and accepts no responsibility  for changes 
made after they were sent or for other risks which arise as a result of e-mail 
transmission, viruses, etc.

---
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Time Zone issue with dates using GeoServer WFS

[Andrea Aime]

On Wed, Jun 22, 2016 at 10:52 AM, Chris Buckmaster <
chris.buckmas...@runnymede.gov.uk> wrote:

> Ah, bummer – any suggestions when using version 2.5, or would I need to
> upgrade? Or any ways I can serve my data in different ways so it will not
> modify my dates and introduce time zone details?
>

GeoServer reports dates and times in GMT, so you can set the entire system
to be on GMT to avoid shifts.

Cheers
Andrea

-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

---
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] IDW Interpolation

[rakesh.modi1585]

Hi ruz76,


I have also tried on demo data it works really fine but it wont work on
my data, It is quite possible because of the scaling since demo data is for
world while my scaling point containing only 10-15 plots in a particular
village.


   Barnes is not working properly for multiple nearest feature
or short area.



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/IDW-Interpolation-tp5271484p5272776.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Time Zone issue with dates using GeoServer WFS

[Chris Buckmaster]

Ah, bummer – any suggestions when using version 2.5, or would I need to 
upgrade? Or any ways I can serve my data in different ways so it will not 
modify my dates and introduce time zone details?


From: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] On Behalf Of Andrea 
Aime
Sent: 22 June 2016 09:47
To: Chris Buckmaster
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Time Zone issue with dates using GeoServer WFS

On Wed, Jun 22, 2016 at 10:45 AM, Andrea Aime 
> wrote:

There was a discussion about this topic on geotools-devel some time ago, the 
outcome was that yes, also dates have timezone (not hard to grasp,
e.g., now it's Wednesday here in Europe, but in a few hours it will be Thursday 
in Australia). I believe that the outcome was also that it's useful to add a 
configuration flag
for those that do not work in an international settings, so that the dates do 
not get modified in those cases.
According to the docs there is a system variable you can set:
http://docs.geotools.org/latest/userguide/library/metadata/geotools.html

Oh, forgot to add, this settings is available, as far as I know, only starting 
with GeoServer 2.9.0

Cheers
Andrea

--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


AVVERTENZE AI SENSI DEL D.Lgs. 196/2003

Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i 
file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo 
è consentito esclusivamente al destinatario del messaggio, per le finalità 
indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne 
il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di 
procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro 
sistema. Conservare il messaggio stesso, divulgarlo anche in parte, 
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, 
costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for the 
attention and use of the named addressee(s) and may be confidential or 
proprietary in nature or covered by the provisions of privacy act (Legislative 
Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in 
accord with its purpose, any disclosure, reproduction, copying, distribution, 
or either dissemination, either whole or partial, is strictly forbidden except 
previous formal approval of the named addressee(s). If you are not the intended 
recipient, please contact immediately the sender by telephone, fax or e-mail 
and delete the information in this message that has been received in error. The 
sender does not give any warranty or accept liability as the content, accuracy 
or completeness of sent messages and accepts no responsibility  for changes 
made after they were sent or for other risks which arise as a result of e-mail 
transmission, viruses, etc.

---
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Time Zone issue with dates using GeoServer WFS

[Chris Buckmaster]

Thanks for your reply Andrea.

I have Geoserver installed as a Windows service and am not too knowledgeable on 
the Java environment – is this an application that can be installed to link 
into Geoserver to change the settings then? Am I able to change the Geoserver 
config settings to reflect the below through the config files if this isn’t 
possible using the UI?

Thanks, Chris

From: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] On Behalf Of Andrea 
Aime
Sent: 22 June 2016 09:46
To: Chris Buckmaster
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Time Zone issue with dates using GeoServer WFS

On Wed, Jun 22, 2016 at 9:50 AM, Chris Buckmaster 
> 
wrote:
The problem I am encountering is, for any dates that fall within British summer 
time (GMT Daylight Saving Time), it appears to be moving the actual date back 
by one day (i.e. for a date stored as 8th September 1993 in PostGIS, it is 
displaying as 07/09/1993 in my HTML / Javascript web application). The field is 
not a timestamp field, it is just a date field so from what I can gather it 
shouldn’t be storing any information on time zones?

There was a discussion about this topic on geotools-devel some time ago, the 
outcome was that yes, also dates have timezone (not hard to grasp,
e.g., now it's Wednesday here in Europe, but in a few hours it will be Thursday 
in Australia). I believe that the outcome was also that it's useful to add a 
configuration flag
for those that do not work in an international settings, so that the dates do 
not get modified in those cases.
According to the docs there is a system variable you can set:
http://docs.geotools.org/latest/userguide/library/metadata/geotools.html

So starting your JVM with -Dorg.geotools.localDateTimeHandling=true should 
change the behavior. It would be nice to have that as a global setting
in the GeoServer UI... anyone interested in coding it? :-)

Cheers
Andrea

--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


AVVERTENZE AI SENSI DEL D.Lgs. 196/2003

Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i 
file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo 
è consentito esclusivamente al destinatario del messaggio, per le finalità 
indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne 
il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di 
procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro 
sistema. Conservare il messaggio stesso, divulgarlo anche in parte, 
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, 
costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for the 
attention and use of the named addressee(s) and may be confidential or 
proprietary in nature or covered by the provisions of privacy act (Legislative 
Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in 
accord with its purpose, any disclosure, reproduction, copying, distribution, 
or either dissemination, either whole or partial, is strictly forbidden except 
previous formal approval of the named addressee(s). If you are not the intended 
recipient, please contact immediately the sender by telephone, fax or e-mail 
and delete the information in this message that has been received in error. The 
sender does not give any warranty or accept liability as the content, accuracy 
or completeness of sent messages and accepts no responsibility  for changes 
made after they were sent or for other risks which arise as a result of e-mail 
transmission, viruses, etc.

---
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Time Zone issue with dates using GeoServer WFS

[Andrea Aime]

On Wed, Jun 22, 2016 at 10:45 AM, Andrea Aime 
wrote:

>
>> There was a discussion about this topic on geotools-devel some time ago,
> the outcome was that yes, also dates have timezone (not hard to grasp,
> e.g., now it's Wednesday here in Europe, but in a few hours it will be
> Thursday in Australia). I believe that the outcome was also that it's
> useful to add a configuration flag
> for those that do not work in an international settings, so that the dates
> do not get modified in those cases.
> According to the docs there is a system variable you can set:
> http://docs.geotools.org/latest/userguide/library/metadata/geotools.html
>

Oh, forgot to add, this settings is available, as far as I know, only
starting with GeoServer 2.9.0

Cheers
Andrea

-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

---
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Time Zone issue with dates using GeoServer WFS

[Andrea Aime]

On Wed, Jun 22, 2016 at 9:50 AM, Chris Buckmaster <
chris.buckmas...@runnymede.gov.uk> wrote:

> The problem I am encountering is, for any dates that fall within British
> summer time (GMT Daylight Saving Time), it appears to be moving the actual
> date back by one day (i.e. for a date stored as 8th September 1993 in
> PostGIS, it is displaying as 07/09/1993 in my HTML / Javascript web
> application). The field is not a timestamp field, it is just a date field
> so from what I can gather it shouldn’t be storing any information on time
> zones?
>

There was a discussion about this topic on geotools-devel some time ago,
the outcome was that yes, also dates have timezone (not hard to grasp,
e.g., now it's Wednesday here in Europe, but in a few hours it will be
Thursday in Australia). I believe that the outcome was also that it's
useful to add a configuration flag
for those that do not work in an international settings, so that the dates
do not get modified in those cases.
According to the docs there is a system variable you can set:
http://docs.geotools.org/latest/userguide/library/metadata/geotools.html

So starting your JVM with -Dorg.geotools.localDateTimeHandling=true should
change the behavior. It would be nice to have that as a global setting
in the GeoServer UI... anyone interested in coding it? :-)

Cheers
Andrea

-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

---
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] How to serve large spatio-temporal dataset with GeoServer?

[Andrea Aime]

On Wed, Jun 22, 2016 at 10:02 AM, Peter Kovac  wrote:

> Hi Andrea,
>
> what do you mean with "deciding which one to use"? AFAIK it has to use
> both, (almost) all the time.
>
According to what Bruce Momjan told me a few years ago, not always. He was
going over some statistics
on index usage, and when it's actually more efficient to use an index than
to do a linear scan, and the
threshold was less than 10% of the data (can't remember the actual value),
in other terms, index access is faster
than a linear scan in postgresql only if the index selects less than 10% of
the overall data.
Based on that, the planner will decide to use no index, only one, or both,
based on their selectivity.

In your case it seems you're constraining much more on time than on space,
if that's the case there is a chance
only the time index will be used, because using the other one as well might
result in slower execution.


> This is the query found in GeoServer logs (LOCATION is the point geometry
> column with a spatial index):
>
> SELECT ID,TIME,LOCATION
> FROM lightning_strikes
> WHERE  (
>   TIME BETWEEN ? AND ?
>   AND SDO_FILTER(LOCATION, ?, 'mask=anyinteract querytype=WINDOW') =
> 'TRUE')
> )
> Let's say I want just 1 hour worth of lightning strikes but from almost
> all of the central Europe (so the BBOX is not covering the whole dataset
> but covers 90% of it).
> The 'TIME BETWEEN' clause quickly filters 3M rows to let's say 10K
> lightnings. However, some of them lie outside of the BBOX. So it has to
> filter them out. Unfortunately, there are millions of other records in the
> same BBOX, so the spatial index finds them all and then the database engine
> has to make intersection of the two sets. Since one of them is huge, it
> takes time. And it will get worse over time.
>

Yes!


>
> OK, maybe I see your point now. The DB engine could just check each row
> from the smaller set if it is inside the BBOX, without using the spatial
> index. I wonder if PostGIS can do it. I'll give it a try.
>

In my experience it does. Let us know how it goes.

Cheers
Andrea


-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

---
--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] IDW Interpolation

[ruz76]

I have tried it via WMS woth different style and it gives me quite correct
results. I have tried it on dmeo data from GeoServer.

http://localhost:8080/geoserver/sf/wms?service=WMS=1.1.0=GetMap=sf:bugsites=barnes=590223.4382724703,4914107.882513998,608462.4604629107,4920523.89081033=768=330=EPSG:26713=application/openlayers

 

http://www.opengis.net/sld StyledLayerDescriptor.xsd"
 xmlns="http://www.opengis.net/sld;
 xmlns:ogc="http://www.opengis.net/ogc;
 xmlns:xlink="http://www.w3.org/1999/xlink;
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;>
  
Barnes surface

  Barnes Surface
  A style that produces a Barnes surface using a rendering
transformation
  
   
 
   
 data
   
   
 valueAttr
 cat
   
   
 scale
 1000
   
   
 convergence
 0.2
   
   
 passes
 3
   
   
 minObservations
 1
   
   
 maxObservationDistance
 1000
   
   
 pixelsPerCell
 10
   
   
 queryBuffer
 4
   
   
 outputBBOX
 
wms_bbox
 
   
   
 outputWidth
 
wms_width
 
   
   
 outputHeight
 
wms_height
 
   
 
   
   
 
   
   point
   0.8
   
 
 

























































































 
   
 

  

  




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/IDW-Interpolation-tp5271484p5272743.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] IDW Interpolation

[ruz76]

I have tried the Barnes Surface Interpolation with WPS request builder and it
gives me correct results. So there should be problem with styling.



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/IDW-Interpolation-tp5271484p5272741.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users