[Geoserver-users] GeoServer without PostGIS, is it a good idea?

2015-06-24 Thread Peter Kovac
Dear GeoServer users,

my company develops systems in meteorology, climatology, radiation
monitoring etc. It's mostly data collection, storing and later retrieval.
Our customers started to demand maps, recently.

What we need is a map client serving customers' data, both rasters (e.g.
forecasts from GRIB files) and vector (e.g. various values measured by
stations from a national climatology network). We looked out for some
options and settled on a combination of a GeoServer  OpenLayers
integrated into our existing web interface.

After several weeks of playing with GeoServer I got an impression that
GeoServer works great in combination with a local PostGIS instance.
PostGIS fits well into our scenario, too: it would contain metadata about
our rasters with time dimensions, and whole vector layers.

The problem is we already have our own infrastructure which does all the
bookkeeping of all our datasets. E.g. we already store our raster data
somewhere in the filesystem and there is a table in our database which
tracks metadata (origin, time, etc.) about these rasters. For climatology
data, we use Oracle database and have our own schema which stores
information about weather stations (e.g. name, location) and current and
historical measured values.

Because of this, my manager does not want to allow me to create a PostGIS
instance along with a GeoServer instance. His arguments is it's
unnecessary duplicity, it won't be consistent with our database unless we
invest heavily in syncing the two and it needs additional maintenance. His
original idea was that our system will provide data to a GeoServer
instance via some Web Service / WFS / whatever and GeoServer will just
render it. The problem is our system does not have a WFS interface
(yet?) and our existing interfaces are not OGC standardized. Of course, if
we implement WFS we won't need GeoServer (mostly).

I tried to explain to him that we should treat the PostGIS store as some
kind of internal GeoServer store (just like various index files on disk -
he is a database guy and does not care about all those files created by
GeoServer - he cares about databases) and not try to mess with it in order
to speed up development (deadlines are tight, as usual).

I need either better arguments in this debate or an alternative solution.

I stumbled upon DataStore Development tutorial on GeoTools (
http://docs.geotools.org/latest/tutorials/advanced/datastore.html ) which
looks promising, but I'm not quite sure if it's the right thing. I'll try
to implement a proof-of-concept to see if I'm able to convert our existing
database schema into a new Data Store type recognized by GeoSever.

In the meantime I'd love to hear your opinion about the case. Is it common
to implement custom DataStores from existing databases or mirroring it in
PostGIS is the preferred way? Are there any other options?

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


--
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors 
network devices and physical  virtual servers, alerts via email  sms 
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] GeoServer startup time (>2h)

2015-10-27 Thread Peter Kovac
Hi eting,

I have a short experience with ImageMosaic datastores. I think you might 
be interested.

We have an installation with approximately 14000 GeoTiffs (and growing) 
organized into several Image Mosaic layers. The starting time is just a 
minute or two and geoserver is able to serve them smoothly (no 
noticeable difference to individual GeoTiff layers). We serve 
multidimensional meteorological datasets (forecasts with time, forecast 
hour and sometimes ensemble dimensions) so it makes a lot of sense to 
use Image Mosaic datastores. For example we are able to iterate over all 
forecasts for a given runtime of a meteorological model.

Cheers,

Peter

--

Peter Kovac
IMS Programmer
MicroStep-MIS
http://www.microstep-mis.com
peter.ko...@microstep-mis.sk


On 27. 10. 2015 16:57, eting123 wrote:
> Good question and I have been thinking about the same thing, whether we
> should have done this differently by combining the layers.
>
> I'm wondering how scalable is an image mosaic? If we currently have 30,000
> layers, should we put all of them into a single Image Mosaic? At which point
> should we consider separating things into a separate mosaic?
>
> Thank you very much for your help
> eting
>
>
>
> --
> View this message in context: 
> http://osgeo-org.1560.x6.nabble.com/GeoServer-startup-time-2h-tp5232511p5232855.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
> --
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

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


--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] Labels drawn over graphic elements

2015-10-13 Thread Peter Kovac

Dear Andrea,

thank you for clearing it up for me. As you'd might guess, my company is 
interested in the "drawImmediately" vendor option. So we either code it 
ourselves or we will fund core developers, depending on time/money 
costs. Do you remember if this feature was discussed among developers 
before? Who and where should I ask about GeoServer developers' time and 
money estimates?


Regards,

Peter Kovac

On 12. 10. 2015 19:50, Andrea Aime wrote:
On Mon, Oct 12, 2015 at 6:45 PM, Peter Kovac 
<peter.ko...@microstep-mis.sk <mailto:peter.ko...@microstep-mis.sk>> 
wrote:


It seems to me all graphics are rendered first and all labels are
rendered after.

What can I do about it?

I tried using shapes from SLD styles but I need to use more than one
shape for every feature. GeoServer renders multiple shapes centered
around anchor point and there is no possibility to use
Displacement for
graphic (AFAIK it's possible only with text labels). That's why I use
ExternalGraphic, I need to show all shapes side by side.


Displacement for graphics is supported in recent versions of GeoServer 
(since 2.7

I believe).

About the ability to avoid drawing all labels at the end, it has been 
discussed,
in normal situation it just breaks maps big time, as the WMS user can 
compose

them in any order they want and labels need to stay on top to be legible,
but we understand there are cases in which this might not be desirable 
(for

example when labels are not really labels, but more parts of symbols).

For this we'd need to add and code support for a new "drawImmediately" 
vendor
option. So far no one has provided either their own coding time to 
make it a reality,
or funding to allow core developers to add this features during 
working hours.

Maybe you could be the one? ;-)

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 Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
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.sk

--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


[Geoserver-users] Labels drawn over graphic elements

2015-10-12 Thread Peter Kovac
Dear GeoServer users,

I have a layer which shows data from a meteorology station network in 
using very specific graphics symbol.

The symbol consists of a colored square to the left and a colored 
rectangle to the right of feature's anchor point, with a possibility of 
label drawn over the rectangle.

I'm using my custom PNG icons as  and choose the right 
colors according to feature data as follows:


 stations
 
 
 
 
 image/png
 
 
 
 
 
 TEXT
 
 
 Arial
 14
 normal
 bold
 
 
 
 
 0
 0
 
 
 -2
 4
 
 
 
 #FF
 


The problem is that the icons might overlap and when they do the text is 
drawn always on top, regardless of relative z-index of the icon it 
belongs to. Here's an example: http://imgur.com/YxwieHW

It seems to me all graphics are rendered first and all labels are 
rendered after.

What can I do about it?

I tried using shapes from SLD styles but I need to use more than one 
shape for every feature. GeoServer renders multiple shapes centered 
around anchor point and there is no possibility to use Displacement for 
graphic (AFAIK it's possible only with text labels). That's why I use 
ExternalGraphic, I need to show all shapes side by side.

Many thanks

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


--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] bulk geotiff import

2016-01-13 Thread Peter Kovac

Hi Alex,

try this if you have the file on your local computer:

curl -u "user:password" -XPUT -H 'Content-type: image/tiff' \
--data-binary @"$LOCAL_GEOTIFF"\
"http://$HOSTNAME:$PORT/geoserver/rest/workspaces/$WORKSPACE/coveragestores/$STORE_NAME/file.geotiff

where variables are the following:
$LOCAL_GEOTIFF - path to the file on your local computer
$HOSTNAME, $PORT - obviously GeoServer instance hostname and port
$WORKSPACE - workspace name
$STORE_NAME - name of the datastore that will be created for your GeoTIFF

If the file is already on the server where the GeoServer runs (and the 
file is readable by the GeoServer process), try it like this


REMOTE_GEOTIFF="file:///path/to/your/remote/geotiff.tiff"
curl -w "%{http_code}" -u "admin:Merc4tr99" -XPUT -H 'Content-type: 
text/plain' \

-d "$REMOTE_GEOTIFF"\
"http://$HOSTNAME:$PORT/geoserver/rest/workspaces/$WORKSPACE/coveragestores/$STORE_NAME/external.geotiff;

I think your confusion stems from using incorrect documentation: you 
have raster data, so you should read "Coverage stores" section of the 
manual: 
http://docs.geoserver.org/stable/en/user/rest/api/coveragestores.html


Data stores are for vector data (citing 
http://docs.geoserver.org/stable/en/user/rest/api/datastores.html ):
A data store contains vector format spatial data. It can be a file 
(such as a shapefile), a database (such as PostGIS), or a server (such 
as a /remote Web Feature Service/ 
<http://docs.geoserver.org/stable/en/user/data/cascaded/wfs.html#data-external-wfs>).





On 12. 1. 2016 18:25, Alex O'Ree wrote:

HTTP PUT to

http://localhost:8080/geoserver/rest/workspaces/myworkspace/datastores/test/external.shp
with the content text/plain
file://data_dir/maps/xyz.tiff

fails with "unable to configure datastore, bad parameters. I'm
assuming this is from the .shp extension.
Changing the extension of the put url to .tiff I get

unsupported format: tiff

I've tried with a few other variants.

It looks like REST API creation of datastores is limited to shape
files. Is that correct?



On Thu, Jan 7, 2016 at 12:59 PM, Alex O'Ree <spyhunte...@gmail.com> wrote:

Jody, et al

I'm having some issues get the geotiffs imported via the REST API. I
can import from the web app without any issues. I think I may either
be misinterpreting the documentation and/or the docs may be slightly
inaccurate.

First a bit more info for my setup. v 2.8.RC1
All geotiff files are located in data_dir/maps

I have a workspace called "maps"

I've tried a number of different combinations
HTTP verb: POST
URL http://localhost:8080/geoserver/rest/workspaces/maps/datastores.json
Content-type application/json
Body contents
{
Location: "file:///data_dir/maps/MyGeoTiff.tiff"
}

I'm getting an 500 internal server error. The server logs say, cannot
resolve class exception "Location".

I'm not sure what "right" looks like here. Any pointers to examples?



On Wed, Jan 6, 2016 at 3:57 PM, Alex O'Ree <spyhunte...@gmail.com> wrote:

Found it here, http://docs.geoserver.org/stable/en/user/rest/api/datastores.html

thanks for the pointer!

On Wed, Jan 6, 2016 at 12:54 PM, Alex O'Ree <spyhunte...@gmail.com> wrote:

Fantastic, can you point me towards the documentation or any where
with more info?

On Wed, Jan 6, 2016 at 12:36 PM, Jody Garnett <jody.garn...@gmail.com> wrote:

The REST API can be used to load and configure raster content. The importer
can also be pointed at a directory of spatial files and do a bulk import ...
and the importer is also available via a REST API :)

--
Jody Garnett

On 6 January 2016 at 09:24, Alex O'Ree <spyhunte...@gmail.com> wrote:

I have a large collection of geotiff files, is there a process to
getting them all bulk imported into geoserver? Any kind of script or
command line interface I can use? Perhaps a rest api?


--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


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

--
Site24x7 AP

Re: [Geoserver-users] GeoServer 2.9.0 Released

2016-05-31 Thread Peter Kovac

Hi Jody et al.

Thank you for your outstanding work. I was eager to try the custom 
legend image for a style but I'm not able to make it work. I'm using a 
clean 2.9.0 war deployment on Tomcat 8.0.30.



This is what I did:

1. Add a new style, let's name it "another_raster" and generate a raster 
SLD for it.


2. Add legend, type the name of an existing "grass_fill.png" file.

3. Click the "Auto-detect image and size" link. At this point I get 
"Field 'styleEditor' is required." error at the top of the screen, but 
all legend fields are auto filled with correct values (width and height 
is 32, format is image/png;charset=UTF-8).


4. Save the style and let the layer Pk50095 use it as additional style.

5. Now, when I do a WMS GetCapabilites request and track down the URL 
for the legend of Pk50095 I get the following: link 
http://hostname:port/geoserver/grass_fill.png which is incorrect. The 
correct link is http://hostname:port/geoserver/styles/grass_fill.png 
(also the docs say so: 
http://docs.geoserver.org/stable/en/user/datadirectory/structure.html#styles 
)



Also another inconvenience is that when I set a workspace (say nurc), 
edit the style via web UI, save it, edit it again and save it again the 
workspace is lost (despite the fact that during the second edit the 
workspace combobox is populated with what I assume is the correct value 
and it is sent over to the server as HTTP POST request parameter when I 
click on Submit).



Are these known issues or should I open a JIRA bug reports?


On 31. 5. 2016 0:41, Jody Garnett wrote:

The GeoServer team is happy to announce the release of GeoServer 2.9.0:

  * http://geoserver.org/release/2.9.0/

This is the new stable release suitable for use in production. This 
release *requires the use of Java 8*.


Important updates:

  * Web admin application layer, preview, global settings, image
processing and raster access screens have been updated.
  * User guide has been restructured for ease of navigation and to
reduce duplication
  * The REST API can now be used to manage icons, fonts and
configuration files and report on the status of installed components.
  * Internally this release features Wicket 7 and Spring 4 and the
latest JAI-Ext library.
  * Layer bounds can now be generated from spatial reference systems
extent
  * Styles can now be configured with a custom legend.
  * For more details please see the blog post
<http://blog.geoserver.org/2016/05/30/geoserver-2-9-0-released/>
and release notes  (2.9.0

<https://osgeo-org.atlassian.net/secure/ReleaseNote.jspa?projectId=1=13003>|RC1

<https://osgeo-org.atlassian.net/secure/ReleaseNote.jspa?projectId=1=12502>|beta2

<https://osgeo-org.atlassian.net/secure/ReleaseNote.jspa?projectId=1=12700>|beta

<https://osgeo-org.atlassian.net/secure/ReleaseNote.jspa?projectId=1=12100>|M0

<https://osgeo-org.atlassian.net/secure/ReleaseNote.jspa?projectId=1=11401>)

Thanks to Jody and Devon (from Boundless) for publishing this release. 
This release was delayed for two months due to incompatibility with 
Java 8. Thanks for the dedicated testing a fix support from Andrea, 
Alessandro, Alex, Ben, Brad, Jukka, Niels, Torben and others during 
this long release cycle. Special thanks to sponsors of the Wicket 7 
upgrade 
<https://wiki.osgeo.org/wiki/GeoServer_Code_Sprint_2016> sprint: OSGeo 
<http://www.osgeo.org/>, Boundless <http://boundlessgeo.com/>, Vivid 
Solutions <http://www.vividsolutions.com/>, How 2 Map 
<http://www.how2map.com/>, San Jose Water Company 
<https://www.sjwater.com/>, Transient <http://transient.nz/>, 
Geobeyond <http://www.geobeyond.it/> (with in-kind sponsors 
GeoSolutions, CCRi, Astun Technology and Voyager).

--
The GeoServer Team


--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e


___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


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

--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacit

Re: [Geoserver-users] Reload ImageMosaic store via Rest API

2016-06-01 Thread Peter Kovac

Hi Ivan,

what you want to do is what ImageMosaic calls "reindexing granules".

You can reindex the whole layer, but it is time consuming and 
inefficient, because GeoServer will reexamine each granule (individual 
GeoTIFF raster) and delete it from the index or add it to the index. It 
might take a couple of minutes and performance for ordinary WMS requests 
drops badly during that period.


curl -v -u username:password -XPOST -H "Content-type: text/plain" \
 -d "file:/path/to/dir/with/geotiff/files/" \
 "http://localhost:8080/geoserver/rest/workspaces//coveragestores//external.imagemosaic 
<http://localhost:8080/geoserver/rest/workspaces/POVAPSYS/coveragestores/aladin_test3temperature/external.imagemosaic>"



Much better approach (at least in my scenario) is to index each granule 
individually just when the file is ready and is copied to the ImageMosaic 
directory.
curl -v -u username:password -XPOST -H "Content-type: text/plain" \
-d "file:/path/to/dir/with/geotiff/files/your_file.tiff" \

"http://localhost:8080/geoserver/rest/workspaces//coveragestores//external.imagemosaic"


Use another REST call to delete old granules. You can use filter to e.g. delete 
all granules older than 1st January 2016 (assuming you use the time dimension).
curl -u "user:pass" -XDELETE "http://localhost:8080/geoserver/rest/workspaces//coveragestores//coverages//index/granules.xml?filter=time%20BEFORE%202016-01-01T00:00:00Z 
<http://localhost:8080/geoserver/rest/workspaces/RADMON/coveragestores/radmon_short_range/coverages/short_range/index/granules.xml?filter=time%20BEFORE%202016-01-01T00:00:00Z>"



Useful resources are online tutorial by GeoSolutions ( 
http://geoserver.geo-solutions.it/multidim/en/index.html ) and REST API 
docs ( 
http://docs.geoserver.org/stable/en/user/rest/api/coverages.html#structured-coverages 
).



Peter

On 31. 5. 2016 16:14, Ivan Kotev wrote:


Hello All,

This might be quite trivial but I cannot seem to be able to figure it 
out based on the Rest API documentation.


I have several ImageMosaic stores (each of them has exactly 1 layer) 
which are in turn backed by GeoTIFF data files. Every few hours I 
refresh the data by uploading new GeoTIFF files and removing the old 
ones (external operation to GeoServer).


I am looking for a Rest API based approach to the reload the data for 
a particular ImageMosaic store. Currently what I am doing is:


"POST /geoserver/rest/reload", followed by:
"POST /geoserver/rest/reset"

This seems to be working but it reloads the data for *all* datastores 
which is a bit of overkill.


Is there a Rest API to reload the data for a given ImageMosaic 
store/layer?


Thanks much in advance.

Cheers,
Ivan



--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e


___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


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

--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e___
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?

2016-06-22 Thread 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 
<jonathan-li...@lightpear.com <mailto: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.



-------


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

-

Re: [Geoserver-users] REST API creating of a composite layer "Layer Group"

2016-01-13 Thread Peter Kovac
Hi Alex,

from what I have learned how people usually work with REST API is that 
they do what they want on a small scale using the web GUI and then do a 
GET request using the XML format. The XML returned usually is in the 
exact format a PUT request needs.

So, make one small layer group, GET it via REST and use that as a 
template for your PUT requests.

On 13. 1. 2016 16:58, Alex O'Ree wrote:
> So I've just imported a large number of geotiff files that are grouped
> logically on the file system by resolution (1:2M, 1:1M, 1:250K, etc)
>
> Since the volume is high, I want to use the REST api to create a layer
> group, One for each resolution set.
>
> I've found this
> http://docs.geoserver.org/stable/en/user/rest/examples/curl.html#creating-a-layer-group
>
> but it doesn't provide the complete syntax for referencing a raster
> layer set, workspace, coordinate reference system, output formats,
> gridsets etc.
>
> Are there additional examples, documentation or a scheme file for
> defining what the request needs to look like for creating a layer
> group?
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

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


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] How to point GeoServer to MOSAIC_DIR?

2016-02-25 Thread Peter Kovac

Hi Padhrig,

I recommend using XML indexer, not .properties file for configuring 
image mosaics: 
http://geoserver.geo-solutions.it/multidim/en/imagemosaic/mosaic_indexer.html


Then provide appropriate parameters in your indexer.xml and you can 
store granules anywhere on your filesystem:





...


Cheers

On 24. 2. 2016 17:10, Padhrig Mccarthy wrote:

Hi-

I am a novice GeoServer user, and I am tasked with setting up multiple 
timeseries ImageMosaics for our project. I have a MOSAIC_DIR set up 
and configured according to the tutorial at 
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html.


Based on information in that tutorial, it seems MOSAIC_DIR can be 
anywhere on our system. However, when I go to create the ImageMosaic 
data store in GeoServer, all of the configuration seems to use 
relative paths from MOSAIC_DIR. How do I tell GeoServer where my 
MOSAIC_DIR is? Or do I need to place MOSAIC_DIR in some location where 
GeoServer expects it? Alternatively, do I need to define MOSAIC_DIR 
env var for the user running the tomcat container? I have tried this 
last option, yet still have no joy.


Thank you in advance for any hints.


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140


___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


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

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] SLD: Is it possible to get relative displacement between and in ?

2016-07-26 Thread Peter Kovac

Hi Victor,

as an alternative to what Andrea has suggested you might try to prepare 
a custom image for the graphic symbol, which is appropriately offset and 
has transparent background. Then use the displacement only to displace 
the label.


However, I'm not sure if GeoServer is clever enough to figure out that 
transparent parts of the images are actually not overlapping, you'll 
have to try it.



Peter


On 26. 7. 2016 8:41, Victor.Sinceac wrote:


Hi Peter,

Nope, separating Graphic and Label elements in 2 different rules would 
of course handle well the relative displacement but wouldn’t manage 
the labels overlapping.


The labels overlapping is the main reason of using both Graphic and 
Label in the same rule: it ensures that each Label is drawn over a 
Marker, then also avoids the overlapping of different pairs Marker+Label.


My particular requirement is to have:

- a pair Marker+Label for each point

- pairs Marker+Label shall not overlap when zooming the map

- the Marker is centered on the point geom (X,Y)

- the Label is centered on the point geom (X+DELTAX,Y)

Something similar with the well-known case of roads shields (the road 
number in the middle of a road marker) but where the road number is 
not centered on the marker but it is written on the right side of the 
marker.


Did someone already find a solution to this?

Thanks,

Victor

> Date: Mon, 25 Jul 2016 12:51:25 +0200

> From: Peter Kovac <peter.ko...@microstep-mis.com 
<mailto:peter.ko...@microstep-mis.com>>


> Subject: Re: [Geoserver-users] SLD: Is it possible to get relative 
displacement between  and  in ?


> To: geoserver-users@lists.sourceforge.net 
<mailto:geoserver-users@lists.sourceforge.net>


> Message-ID: <90e7c4a5-488f-462b-4fa8-6bab429c7...@microstep-mis.com 
<mailto:90e7c4a5-488f-462b-4fa8-6bab429c7...@microstep-mis.com>>


> Content-Type: text/plain; charset=windows-1252; format=flowed

>

> Hi Victor,

> just split it into 2 rules: one for the graphic and one for the text 
label.


> Then you can use different displacement in each of them.

> Cheers,

> Peter

> On 25. 7. 2016 12:00, Victor.Sinceac wrote:

> > Hi All,

> >

> > In a SLD rule, I need to use a  with both  and

>  elements (something similar to Highways Shields use case):

> > 

> > 

> >   ... 

> >   ... 

> >   ... 

> > 
.


> > 

> > 

> > This works well when the requirement is to get the same position 
X,Y for


> > both Graphic and Label elements.

> > If I had well understood, the   element in such a rule

> > would apply to both elements Label and Graphic.

> > Is it possible to define in such a rule a displacement which would 
only apply


> > to the element Label?

> > Thanks,

> > Victor


This message is subject to and does not create or vary any contractual 
relationship between Campbell Scientific Limited, its subsidiaries or 
affiliates ("CSL") and you. Internet communications are not secure and 
therefore CSL does not accept legal responsibility for the contents of 
this message. The message is intended for the addressee only and its 
contents and any attached files are strictly confidential. If you have 
received it in error, please telephone +44 (0)1509 601141 or email 
postmas...@campbellsci.co.uk. Thank you.

Campbell Scientific Ltd.
Company Registration Number: 1933935 (England and Wales) Registered 
Address: Campbell Park, 80 Hathern Road, Shepshed, Loughborough, 
Leicestershire LE12 9GX, UK

Tel: +44 (0) 1509 601141
Fax: +44 (0) 1509 601091
Web: www.campbellsci.co.uk





--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev


___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


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

--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] SLD: Is it possible to get relative displacement between and in ?

2016-07-25 Thread Peter Kovac
Hi Victor,

just split it into 2 rules: one for the graphic and one for the text label.

Then you can use different displacement in each of them.

Cheers,

Peter


On 25. 7. 2016 12:00, Victor.Sinceac wrote:
> Hi All,
>
> In a SLD rule, I need to use a  with both  and 
>  elements (something similar to Highways Shields use case):
> 
> 
>  ...  
>  ...  
>  ... 
>   ...  ... 
>   ... 
> 
> 
>
> This works well when the requirement is to get the same position X,Y for both 
> Graphic and Label elements.
> If I had well understood, the   element in such a rule would 
> apply to both elements Label and Graphic.
> Is it possible to define in such a rule a displacement which would only apply 
> to the element Label?
>
> Thanks,
> Victor
> 
> This message is subject to and does not create or vary any contractual 
> relationship between Campbell Scientific Limited, its subsidiaries or 
> affiliates ("CSL") and you. Internet communications are not secure and 
> therefore CSL does not accept legal responsibility for the contents of this 
> message. The message is intended for the addressee only and its contents and 
> any attached files are strictly confidential. If you have received it in 
> error, please telephone +44 (0)1509 601141 or email 
> postmas...@campbellsci.co.uk. Thank you.
> Campbell Scientific Ltd.
> Company Registration Number: 1933935 (England and Wales) Registered Address: 
> Campbell Park, 80 Hathern Road, Shepshed, Loughborough, Leicestershire LE12 
> 9GX, UK
> Tel: +44 (0) 1509 601141
> Fax: +44 (0) 1509 601091
> Web: www.campbellsci.co.uk
>
> 
>
> --
> What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
> patterns at an interface-level. Reveals which users, apps, and protocols are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity planning
> reports.http://sdm.link/zohodev2dev
> _______
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

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


--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] Raster symbology

2016-07-22 Thread Peter Kovac

Hi Don,

have you tried the "extended" attribute of the  element?



extended

The extended attribute specifies whether the color map gradient uses 
256 (8-bit) or 65536 (16-bit) colors. The value false (the default) 
specifies that the color scale is calculated using 8-bit color, and 
true specifies using 16-bit color.



http://docs.geoserver.org/latest/en/user/styling/sld-reference/rastersymbolizer.html


Cheers


On 22. 7. 2016 0:48, Brown, Donald wrote:
Is there any way to get GeoServer to render more than 255 colors for 
my geotiff? I can create a .sld with over 500 'colorMapEntries', add 
it to GeoServer, and even add it as the default style for my layer. 
However, GeoServer throws an error when I subsequently do a 'GetMap' 
request on the WMS. Maybe there's a way to embed a large colormap into 
my tiff that I'm not aware of?


Thanks for any help.

Don

--
Don Brown
U.S. Geological Survey
Fort Collins Science Center
2150 Centre Ave. Bldg. C
Fort Collins, CO 80526
(970) 226-9155
_brownd@usgs.gov_ <mailto:bro...@usgs.gov>


--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev


___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


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

--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] Is use of the Marlin renderer recommended

2016-08-08 Thread Peter Kovac
Hi Paul,

you can verify the renderer GeoServer is using by checking the "Java 
Rendering Engine" on the "Server Status" screen (the first link in web 
admin GUI). If you use Marlin, you'll have 
"org.marlin.pisces.PiscesRenderingEngine" in there.

Cheers,

Peter


On 8. 8. 2016 12:14, Paul Wittle wrote:
> I thought it might do that. In text form for point 2:
>
>   - I put the *.jar reference in the Java Classpath of the w.exe Java tab and 
> then added:
> -Dsun.java2d.renderer=org.marlin.pisces.PiscesRenderingEngine
> -Dsun.java2d.renderer.useThreadLocal=false
>
> to the Java Options.
>
> However, I don't think I've seen a reference to Marlin in the GeoServer logs 
> so I wonder if I've put the *.jar reference in the wrong place?
>
> Thanks,
> Paul
>
> --
>
> Message: 1
> Date: Mon, 8 Aug 2016 09:52:17 +
> From: Paul Wittle <p.wit...@dorsetcc.gov.uk>
> Subject: [Geoserver-users] Is use of the Marlin renderer recommended
> To: "geoserver-users@lists.sourceforge.net"
>  <geoserver-users@lists.sourceforge.net>
> Message-ID:
>  
> <D67B8B2041F8004B9C0534736661A4D1FB444AAB@VMCREXCHMBOX01.dorsetcc.local>
>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi,
>
> I have found a blog post from 2014 suggesting that there is an improved 
> renderer for Oracle available. This appears to be the Marlin Renderer and I 
> have attempted to follow the installation instructions; however I'm never 
> quite certain how that fits with the Tomcat service deployment. Two questions:
>
> 1) Is it recommended to use Marlin still (I'm using GeoServer 2.8.4)?
> 2) Is this the correct place to put the settings (hopefully there will be a 
> screenshot below:
> [cid:image001.png@01D1F162.EE166870]
>
> Thanks,
> Paul
> "This e-mail is intended for the named addressee(s) only and may contain 
> information about individuals or other sensitive information and should be 
> handled accordingly. Unless you are the named addressee (or authorised to 
> receive it for the addressee) you may not copy or use it, or disclose it to 
> anyone else. If you have received this email in error, kindly disregard the 
> content of the message and notify the sender immediately. Please be aware 
> that all email may be subject to recording and/or monitoring in accordance 
> with relevant legislation."
> -- next part --
> An HTML attachment was scrubbed...
> -- next part --
> A non-text attachment was scrubbed...
> Name: image001.png
> Type: image/png
> Size: 20673 bytes
> Desc: image001.png
>
> --
>
> --
>
>
> --
>
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
> End of Geoserver-users Digest, Vol 123, Issue 17
> 
> "This e-mail is intended for the named addressee(s) only and may contain 
> information about individuals or other sensitive information and should be 
> handled accordingly. Unless you are the named addressee (or authorised to 
> receive it for the addressee) you may not copy or use it, or disclose it to 
> anyone else. If you have received this email in error, kindly disregard the 
> content of the message and notify the sender immediately. Please be aware 
> that all email may be subject to recording and/or monitoring in accordance 
> with relevant legislation."
>
> --
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

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


--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


[Geoserver-users] How to configure Pacific raster layers spanning the 180 meridian?

2016-09-12 Thread Peter Kovac
PROJCS[WGS 84 / PDC Mercator,
   GEOGCS[WGS 84,
 DATUM[World Geodetic System 1984,
   SPHEROID[WGS 84, 6378137.0, 298.257223563, 
AUTHORITY[EPSG,7030]],
AUTHORITY[EPSG,6326]],
 PRIMEM[Greenwich, 0.0, 
AUTHORITY[EPSG,8901]],
 UNIT[degree, 0.017453292519943295],
 AXIS[Geodetic longitude, EAST],
 AXIS[Geodetic latitude, NORTH],
AUTHORITY[EPSG,4326]],
   PROJECTION[Mercator_1SP, 
AUTHORITY[EPSG,9804]],
   PARAMETER[latitude_of_origin, 0.0],
   PARAMETER[central_meridian, 150.0],
   PARAMETER[scale_factor, 1.0],
   PARAMETER[false_easting, 0.0],
   PARAMETER[false_northing, 0.0],
   UNIT[m, 1.0],
   AXIS[Easting, EAST],
   AXIS[Northing, NORTH],
AUTHORITY[EPSG,3832]]
   EPSG:3832
   
 -1.9628687512850948E7
 1.5807367692644846E7
 -8362698.548500745
 1.0023392492023032E7
 EPSG:3832
   
   
 -180.0
 180.0
 -59.999866
 66.669982
 GEOGCS[WGS84(DD),
   DATUM[WGS84,
 SPHEROID[WGS84, 6378137.0, 298.257223563]],
   PRIMEM[Greenwich, 0.0],
   UNIT[degree, 0.017453292519943295],
   AXIS[Geodetic longitude, EAST],
   AXIS[Geodetic latitude, NORTH]]
   
REPROJECT_TO_DECLARED
   true
   
 
   
0
 true
 NONE
 W.m-2.Sr-1
   
 
 test_NAT_3832_test_NAT_3832
   
   
CoverageStoreInfoImpl--2d5f6d1:1570f9abf84:-751f
   
   GeoTIFF
   
 
   0 0
   7921 13389
 
 
   2284.8548262200666
   -2284.8548262200666
   0.0
   0.0
-1.008291672173188E7
1.5294720190268923E7
 
 EPSG:3832
   
   
 GIF
 PNG
 JPEG
 TIFF
 ImageMosaic
 GRIB
 ArcGrid
 NetCDF
 GEOTIFF
 Gtopo30
   
   
 nearest neighbor
 bilinear
 bicubic
   
   nearest neighbor
   
 
   RED_BAND
GridSampleDimension[4.851844693347973E-33,4.851844693347973E-33]
   
 0.0
 0.0
   
   
4.851844693347973E-33
   
   W.m-2.Sr-1
   
 UNSIGNED_8BITS
   
 
 
   GREEN_BAND
GridSampleDimension[4.851844693347973E-33,4.851844693347973E-33]
   
 0.0
 0.0
   
   
4.851844693347973E-33
   
   W.m-2.Sr-1
   
 UNSIGNED_8BITS
   
 
 
   BLUE_BAND
GridSampleDimension[4.851844693347973E-33,4.851844693347973E-33]
   
 0.0
 0.0
   
   
4.851844693347973E-33
   
   W.m-2.Sr-1
   
 UNSIGNED_8BITS
   
 
   
   
 EPSG:3832
   
   
 EPSG:3832
   
   
 
   InputTransparentColor
   
 
 
   SUGGESTED_TILE_SIZE
   512,512
 
   
test_NAT_3832





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


--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] HELP: creating a store ImageMosaicJDBC for raster image in Geoserver 2.9.0

2016-09-21 Thread Peter Kovac

Hi Tommaso,

you will need to dedicate more RAM (if it's available on your computer) 
to the Java process running GeoServer.


The exact command depends on your platform and type of GeoServer 
installation (which you did not mention). You'll have to find the 
correct config file/script where to put parameters for JVM and enter 
higher values to -Xmx switch (and its useful to adjust -Xms too), e.g.:


|-Xms1024m -Xmx2048m|


Cheers,

Peter

On 21. 9. 2016 17:16, Tommaso Pirini wrote:

Hello,

I have a problem similar to that described here, but *during the store 
definition in Geoserver*:


http://seotoast.com/getting-a-java-lang-outofmemoryerror-error-while-importing-raster-files-from-postgis-to-geoserver/

I am trying to import raster data from PostGIS 2.2 to GeoServer 2.9.0.

I follow the instructions given on this link:
http://docs.geoserver.org/stable/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html

I used the gdal_retile to make tiles of my GTiff imagery. I configured 
xml files and placed them at desire place. Then I used the DDL 
generation utility which create 4 SQL scripts file, then I ran the SQL 
scripts. The image tiles importing runs correctly, but *when I tried 
to connect the data store in Geoserver* I get this error:


...
Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded at 
java.util.zip.ZipCoder.getBytes(ZipCoder.java:80) at 
java.util.zip.ZipFile.getEntry(ZipFile.java:310) at 
java.util.jar.JarFile.getEntry(JarFile.java:240) at 
java.util.jar.JarFile.getJarEntry(JarFile.java:223) at 
sun.misc.URLClassPath$JarLoader.getResource(URLClassPath.java:1005) at 
sun.misc.URLClassPath.getResource(URLClassPath.java:212) at 
java.net.URLClassLoader$1.run(URLClassLoader.java:365) at 
java.net.URLClassLoader$1.run(URLClassLoader.java:362) at 
java.security.AccessController.doPrivileged(Native Method) at 
java.net.URLClassLoader.findClass(URLClassLoader.java:361) at 
org.eclipse.jetty.webapp.WebAppClassLoader.findClass(WebAppClassLoader.java:510) 
at 
org.eclipse.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:441) 
at 
org.eclipse.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:403) 
at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1969) 
at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) 
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) 
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) 
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305)

...

The image size is almost 500MB.
If I use the same procedure with an image of 4MB size, everything works.

Could you help me, please?

Thanks for your attention.

Best regards,

Tommaso


_
Tommaso Pirini, PhD
Computer Engineer
email: tommaso.pir...@unibo.it <mailto:tommaso.pir...@unibo.it>
phone: +39 340 3301299
Skype: tommy.piro24








--


___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


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

--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] How many layers/resources per store?

2016-09-29 Thread Peter Kovac

Hi Anton,

Please, keep the conversation on the mailing list so others can help you 
or benefit from our conversation.


I don't use gsconfig, so I'm not able to help you with it. However, once 
you set up your PostGIS JNDI datastore, it's just another datastore and 
I wildly guess that gsconfig will work happily with it.


In my opinion setting up JNDI manually is just a small effort for a very 
high reward.



Cheers,

Peter


On 28. 9. 2016 10:40, Anton Lundkvist wrote:

Ok thanks!

I'm relying heavily on gsconfig.py 
https://github.com/boundlessgeo/gsconfig for publishing my tables. I 
haven't found any info on if it is possible to use JNDI with gsconfig. 
Does anyone know?


regards,

anton

2016-09-28 9:15 GMT+02:00 Peter Kovac <peter.ko...@microstep-mis.com 
<mailto:peter.ko...@microstep-mis.com>>:


Hi Anton,

If you are using Apache Tomcat or another container I recommend
using JNDI connection pooling. That way you have 1 connection pool
shared among all of your layers and you can manage it easily. I
observed significant performance gains when switching from
"PostGIS" to "PostGIS (JNDI)" type of store (database connections
don't have to be recreated with each request and it saves a lot of
time). It works with ImageMosaic datastores with custom dimensions
too.


http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html

<http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html>


Cheers,

Peter


On 28. 9. 2016 8:57, Anton Lundkvist wrote:

Hi GeoServer Users:

I'm using GeoServer for serving vector data (from PostGis).
Keeping the number of stores down e.g. many layers per store
reduces the number of connections to PostGis. This is desirable
as I have hundreds of tables that are published through GeoServer.

 Is there a recommended limit for how many layers / resources I
should handle with one store?

Regards,

Anton Lundkvist





--

___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
<https://lists.sourceforge.net/lists/listinfo/geoserver-users>


-- 
Peter Kovac

IMS Programmer
MicroStep-MIS
peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com>

--
---
Anton Lundkvist
Malmö
Tel:0046 768 847 703

--
Peter Kovac
IMS Programmer
MicroStep-MIS
peter.ko...@microstep-mis.com
--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] How many layers/resources per store?

2016-09-28 Thread Peter Kovac

Hi Anton,

If you are using Apache Tomcat or another container I recommend using 
JNDI connection pooling. That way you have 1 connection pool shared 
among all of your layers and you can manage it easily. I observed 
significant performance gains when switching from "PostGIS" to "PostGIS 
(JNDI)" type of store (database connections don't have to be recreated 
with each request and it saves a lot of time). It works with ImageMosaic 
datastores with custom dimensions too.


http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html


Cheers,

Peter

On 28. 9. 2016 8:57, Anton Lundkvist wrote:

Hi GeoServer Users:

I'm using GeoServer for serving vector data (from PostGis). Keeping 
the number of stores down e.g. many layers per store reduces the 
number of connections to PostGis. This is desirable as I have hundreds 
of tables that are published through GeoServer.


 Is there a recommended limit for how many layers / resources I should 
handle with one store?


Regards,

Anton Lundkvist




--


___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


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

--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] GetCapabilities returning invalid xml

2016-10-03 Thread Peter Kovac
Hi Alex,

you'll have to check the log file for more detailed information.

Look for $GEOSERVER_DATA_DIR/logs/geoserver.log.

You might set the log level to VERBOSE_LOGGING (in Settings -> Global -> 
Logging profile) temporarily if you can't find any apparent error with 
default log level.


Cheers,

Peter


On 30. 9. 2016 21:42, Alex O'Ree wrote:
> geoserver/ows?service=wms=1.3.0=GetCapabilities
>
> is returning mostly valid XML, until it goes to some CRS element
> whereby the body is actually an exception with an additiona  and a ServiceExceptionREport
>
> RunTimeException can't obtain envelope of Layer-Groups: null
>
> any idea what's wrong? Running 2.8.1
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

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


--
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] How many layers/resources per store?

2016-11-08 Thread Peter Kovac

Hi Anton,

sorry, for late response: in my experience this is something you have to 
try and adjust yourself, because every computer setup is different. You 
can use e.g. Apache JMeter to create a bunch of testing WMS requests and 
then try to find the setting where you have the best performance. You 
may find out you are not bounded by database, but network or disk access...


Cheers,

Peter


On 1. 11. 2016 17:08, Anton Lundkvist wrote:


Thanks for the info!

I finally had the time to implement the Jindi connection pooling. It 
seems to work well.


I configured according to the geoserver docs. 
http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html


Do you have any info on what the different configuration settings in 
the context.xml stand for or if there are any additional setting I 
should set to maximize performance? I use tomcat 8 and checked the 
docs there but did not find much.


For example I would like to know what the

maxActive="20"
maxIdle="8"

In the context.xml does. Does the connection pool allow adding 
unlimited amount of feature types to that store or are there still 
limits to what it can handle?


My database is configured to accept unlimited amounts of connections

Thanks again for the help!

Anton


Den 29 sep. 2016 8:27 AM skrev "Peter Kovac" 
<peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com>>:


Hi Anton,

Please, keep the conversation on the mailing list so others can
help you or benefit from our conversation.

I don't use gsconfig, so I'm not able to help you with it.
However, once you set up your PostGIS JNDI datastore, it's just
another datastore and I wildly guess that gsconfig will work
happily with it.

In my opinion setting up JNDI manually is just a small effort for
a very high reward.


Cheers,

Peter


On 28. 9. 2016 10:40, Anton Lundkvist wrote:

Ok thanks!

I'm relying heavily on gsconfig.py
https://github.com/boundlessgeo/gsconfig
<https://github.com/boundlessgeo/gsconfig> for publishing my
tables. I haven't found any info on if it is possible to use JNDI
with gsconfig. Does anyone know?

regards,

anton

2016-09-28 9:15 GMT+02:00 Peter Kovac
<peter.ko...@microstep-mis.com
<mailto:peter.ko...@microstep-mis.com>>:

Hi Anton,

If you are using Apache Tomcat or another container I
recommend using JNDI connection pooling. That way you have 1
connection pool shared among all of your layers and you can
manage it easily. I observed significant performance gains
when switching from "PostGIS" to "PostGIS (JNDI)" type of
store (database connections don't have to be recreated with
each request and it saves a lot of time). It works with
ImageMosaic datastores with custom dimensions too.


http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html

<http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html>


Cheers,

Peter


On 28. 9. 2016 8:57, Anton Lundkvist wrote:

Hi GeoServer Users:

I'm using GeoServer for serving vector data (from PostGis).
Keeping the number of stores down e.g. many layers per store
reduces the number of connections to PostGis. This is
desirable as I have hundreds of tables that are published
through GeoServer.

 Is there a recommended limit for how many layers /
resources I should handle with one store?

Regards,

Anton Lundkvist





--

___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
    <https://lists.sourceforge.net/lists/listinfo/geoserver-users>


-- 
Peter Kovac

IMS Programmer
MicroStep-MIS
peter.ko...@microstep-mis.com
<mailto:peter.ko...@microstep-mis.com>

-- 
---

Anton Lundkvist
Malmö
Tel:0046 768 847 703
-- 
Peter Kovac

IMS Programmer
    MicroStep-MIS
peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com>


--
Peter Kovac
IMS Programmer
MicroStep-MIS
peter.ko...@microstep-mis.com
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http:

Re: [Geoserver-users] Missing band definitions when adding a GeoTIFF via REST

2016-11-11 Thread Peter Kovac

Hi Victor,

usually, with REST, it works like this:

If you want to update some property X of some resource Y, first try to 
configure similar resource via web UI  and then make a GET request via 
REST so that you can see the full configuration with all the options and 
their values.


In your case, try to make a GET request against this url:

http://localhost:8080/geoserver/rest/workspaces/files/coveragestores/myraster/coverages/myraster.json

You should get something like the attached JSON. Look especially at 
"dimensions" and "coverageDimension" properties. In general that's how 
you should format your POST request.


Cheers,

Peter


On 11. 11. 2016 13:32, Víctor González wrote:

Hi,

I'm loading a new GeoTIFF layer using REST by adding a new 
coveragestore and coverage (requests below). After that, the layer 
does not have information about bands and I have to use the "Reload 
band definitions" option in the web GUI to load them manually (because 
I don't know the raster metadata and I cannot include it in the request).


Why is the band information not loaded automatically? Is it possible 
to load it programmatically without using the web GUI?


I'm using 2.9.1.

$ curl -u admin:geoserver -XPOST 
http://localhost:8080/geoserver/rest/workspaces/files/coveragestores.json 
-H "Content-Type: application/json" --data '{

  "coverageStore" : {
"name" : "myraster",
"type" : "GeoTIFF",
"enabled" : true,
"workspace" : {
  "name" : "files"
},
"url" : "file:test.tif"
  }
}'

$ curl -u admin:geoserver -XPOST 
http://localhost:8080/geoserver/rest/workspaces/files/coveragestores/myraster/coverages.json 
-H "Content-Type: application/json" --data '{

  "coverage" : {
"name" : "myraster",
"enabled" : true,
"store" : {
  "name" : "files:myraster"
}
  }
}'

Best regards.

--
Víctor González
http://geomati.co


--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi


___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


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

{
   "coverage":{
  "name":"myraster",
  "nativeName":"myraster",
  "namespace":{
 "name":"files",
 
"href":"http:\/\/localhost:8080\/geoserver\/rest\/namespaces\/files.json"
  },
  "title":"My Raster",
  "description":"Generated from GeoTIFF",
  "keywords":{
 "string":[
"WCS",
"GeoTIFF"
 ]
  },
  "nativeCRS":{
 "@class":"projected",
 "$":"PROJCS[\"WGS 84 \/ Pseudo-Mercator\", \n  GEOGCS[\"WGS 84\", \n   
 DATUM[\"World Geodetic System 1984\", \n  SPHEROID[\"WGS 84\", 6378137.0, 
298.257223563, AUTHORITY[\"EPSG\",\"7030\"]], \n  
AUTHORITY[\"EPSG\",\"6326\"]], \nPRIMEM[\"Greenwich\", 0.0, 
AUTHORITY[\"EPSG\",\"8901\"]], \nUNIT[\"degree\", 0.017453292519943295], \n 
   AXIS[\"Geodetic longitude\", EAST], \nAXIS[\"Geodetic latitude\", 
NORTH], \nAUTHORITY[\"EPSG\",\"4326\"]], \n  PROJECTION[\"Popular 
Visualisation Pseudo Mercator\", AUTHORITY[\"EPSG\",\"1024\"]], \n  
PARAMETER[\"semi_minor\", 6378137.0], \n  PARAMETER[\"latitude_of_origin\", 
0.0], \n  PARAMETER[\"central_meridian\", 0.0], \n  PARAMETER[\"scale_factor\", 
1.0], \n  PARAMETER[\"false_easting\", 0.0], \n  PARAMETER[\"false_northing\", 
0.0], \n  UNIT[\"m\", 1.0], \n  AXIS[\"Easting\", EAST], \n  AXIS[\"Northing\", 
NORTH], \n  AUTHORITY[\"EPSG\",\"3857\"]]"
  },
  "srs":"EPSG:3857",
  "nativeBoundingBox":{
 "minx":-2.0037508299778014E7,
 "maxx":2.003121201463195E7,
 "miny":-1.31002474063954E7,
 "maxy":1.3095217057218852E7,
 "crs":{
"@class":"projected",
"$":&quo

Re: [Geoserver-users] Windbarbs not working in geoserver 2.9.2

2016-11-22 Thread Peter Kovac

Dear Devin,


when I had trouble with external legend images in the styles directory 
(I always got NullPointerException when trying to set the image name 
from web UI) I figured out that I can just edit the styles XML 
configuration file and then reload the catalog to apply changes. 
Somehow, it works for me.



The XML file of your style has the same name as the SLD file, just 
different extension. See below for an example configuration with the 
legend.png file in the styles directory:




<id>StyleInfoImpl-41238c1:157e2c81df1:-2db4</id>
  <name>my_style</name>
  <format>sld</format>
  <languageVersion>
<version>1.0.0</version>
  </languageVersion>
  <filename>my_style.sld</filename>
  <legend>
<width>159</width>
<height>435</height>
<format>image/png;charset=UTF-8</format>
<onlineResource>legend.png</onlineResource>
  </legend>



Cheers,


Peter


On 22. 11. 2016 17:55, Devin Eyre wrote:


Yesterday, the windbarbs began working on the new server.  The error 
below is actually for the legend.


I have uploaded legend graphics to the styles directory on the server, 
but a call to getLegendGraphic does not return them.  Is there a 
different format other than just an image file that's needed for this 
to work?



*From:* Devin Eyre
*Sent:* Monday, November 21, 2016 9:19 AM
*To:* geoserver-users@lists.sourceforge.net
*Subject:* [Geoserver-users] Windbarbs not working in geoserver 2.9.2

We had them working in version 2.9.0.  We installed 2.9.2 on a new 
server (Ubuntu 16.04), and they haven't worked on this server.  Is 
there a plugin that's required to make these work?


Below is the error from geoserver's log:


ERROR [geoserver.ows] -
java.lang.IllegalArgumentException: The specified mark 
strConcat([strConcat([windbarbs://default(], [magnitude])], [)[mph]]) 
was not found!
at 
org.geotools.renderer.style.SLDStyleFactory.createMarkStyle(SLDStyleFactory.java:713)
at 
org.geotools.renderer.style.SLDStyleFactory.createPointStyle(SLDStyleFactory.java:676)
at 
org.geotools.renderer.style.SLDStyleFactory.createPointStyle(SLDStyleFactory.java:543)
at 
org.geotools.renderer.style.SLDStyleFactory.createStyleInternal(SLDStyleFactory.java:378)
at 
org.geotools.renderer.style.SLDStyleFactory.createStyle(SLDStyleFactory.java:325)
at 
org.geoserver.wms.legendgraphic.BufferedImageLegendGraphicBuilder.buildLegendGraphic(BufferedImageLegendGraphicBuilder.java:413)
at 
org.geoserver.wms.legendgraphic.PNGLegendOutputFormat.produceLegendGraphic(PNGLegendOutputFormat.java:41)
at 
org.geoserver.wms.legendgraphic.PNGLegendOutputFormat.produceLegendGraphic(PNGLegendOutputFormat.java:22)
at 
org.geoserver.wms.GetLegendGraphic.run(GetLegendGraphic.java:49)
at 
org.geoserver.wms.DefaultWebMapService.getLegendGraphic(DefaultWebMapService.java:349)

at sun.reflect.GeneratedMethodAccessor412.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)
at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at 
org.geoserver.kml.WebMapServiceKmlInterceptor.invoke(WebMapServiceKmlInterceptor.java:34)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at 
org.geoserver.ows.util.RequestObjectLogger.invoke(RequestObjectLogger.java:55)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)




--


___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


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

--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] SLD question - AlphaChannel RGBA Raster

2017-08-17 Thread Peter Kovac

Hi Danilo,

have you tried using the default Raster style that's bundled with 
GeoServer? I'm using it on RGBA images and transparency works fine.


Regards,

Peter Kovac



On 16. 8. 2017 23:28, Danilo da Silveira Figueira wrote:

Hi all,

I have the following working Sld for a RGB raster:


http://www.opengis.net/sld; 
xmlns:sld="http://www.opengis.net/sld; 
xmlns:gml="http://www.opengis.net/gml; 
xmlns:ogc="http://www.opengis.net/ogc; version="1.0.0">

 
  Default Styler
  
   RGB image 3 channels
   RGB image
   
rgb_general

 
  
   
1
   
   
2
   
   
3
   
  
 

   
  
 



I have a RGBA raster, where the bands are [Red, Green, Blue, Alpha] to 
be shown.
So i need something like a "AlphaChannel", or "Opacity" values from 
the 4 band. I dont found nothing in documentation, how to do this??


Ps: I can't use ColorMap because i want all values exactly as in RGB 
format.



--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


___
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#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


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

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
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#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] ImagePyramid using Postgresql for granules

2017-09-29 Thread Peter Kovac

Hi Darell,

can you post your indexer.xml configuration for the imagemosaic?

Regards,

Peter Kovac


On 28. 9. 2017 9:59, Darell van der Voort wrote:

Hello everybody,

I'm running Geoserver 2.11.2 on Java 1.8.0_144 32 bits on Amazon Linux 
together with Tomcat 9. The plugins I have installed are imagemosaic, 
imagepyramid, GeowebCache (internal) and Geofence.


When using the imagemosaic plugin I am able to use a Postgresql DB for 
storing the granules and time dimension via a datastore.properties 
file. The file looks like:


SPI=org.geotools.data.postgis.PostgisNGJNDIDataStoreFactory
schema=database_schema_name
Loose\ bbox=true
Estimated\ extends=false
validate\ connections=true
Connection\ timeout=10
preparedStatements=true
jndiReferenceName=java:comp/env/jdbc/postgis

Which work as expected. However when I add the same file in the 
imagepyramid datastructure, this setup fails. When I add this 
datastore.properties in just the lowest level (0) then that level gets 
configured in a database table, while the higher levels are configured 
using a shapefile. When I add a datastore.properties to all levels, 
geoserver returns the following error:


2017-09-28 07:39:40,780 ERROR [gce.imagemosaic] -
java.io.IOException
at 
org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.createGranuleCatalogFromDatastore(ImageMosaicConfigHandler.java:406)
at 
org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.createCatalog(ImageMosaicConfigHandler.java:329)
at 
org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.buildCatalog(ImageMosaicConfigHandler.java:962)
at 
org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.indexingPreamble(ImageMosaicConfigHandler.java:941)
at 
org.geotools.gce.imagemosaic.ImageMosaicDirectoryWalker$MosaicDirectoryWalker.(ImageMosaicDirectoryWalker.java:109)
at 
org.geotools.gce.imagemosaic.ImageMosaicDirectoryWalker.run(ImageMosaicDirectoryWalker.java:197)

at org.geotools.gce.imagemosaic.Utils.createMosaic(Utils.java:460)
at org.geotools.gce.imagemosaic.Utils.checkSource(Utils.java:1336)
at 
org.geotools.gce.imagemosaic.ImageMosaicReader.initReaderFromURL(ImageMosaicReader.java:532)
at 
org.geotools.gce.imagemosaic.ImageMosaicReader.(ImageMosaicReader.java:479)
at 
org.geotools.gce.imagemosaic.ImageMosaicFormat.getReader(ImageMosaicFormat.java:504)

at org.geotools.gce.imagepyramid.Utils.checkSource(Utils.java:200)
at 
org.geotools.gce.imagepyramid.ImagePyramidReader.(ImagePyramidReader.java:177)
at 
org.geotools.gce.imagepyramid.ImagePyramidFormat.getReader(ImagePyramidFormat.java:249)
at 
org.geotools.gce.imagepyramid.ImagePyramidFormat.getReader(ImagePyramidFormat.java:56)
at 
org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1511)
at 
org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1441)
at 
org.geoserver.catalog.impl.CoverageStoreInfoImpl.getGridCoverageReader(CoverageStoreInfoImpl.java:59)

.
at 
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at 
org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.createGranuleCatalogFromDatastore(ImageMosaicConfigHandler.java:389)

... 160 more

Is it possible to configure the granules of all levels in the 
database? And if so, how would my datastore.properties file look like? 
Like I said, it works fine for the lowest level (0) but it fails for 
all the levels above. If it may not be possible, is it sufficient to 
use the shapefiles as an index for the granules? The geoserver is used 
in a production environment and I am worried about performance issues 
when using the shapefiles as index.


Furthermore the imagepyramid automatically names the table after the 
level folder (0). This folder and table name are automatically created 
when configuring the datastore. Is there a way to custom name the 
folder and thus the table name? Otherwise I could end up with multiple 
'0' tables in the same schema.


Many thanks!

Kind regards,
Darell


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


___
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#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


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

--
Check out the vibrant tech community

Re: [Geoserver-users] ImagePyramid using Postgresql for granules

2017-09-29 Thread Peter Kovac
I usually configure ImageMosaic for time-series plain GeoTIFF granules 
so my advice might not be 100% accurate but I hope it helps anyway.


Firstly, your schema seems wrong to me: you have two types specified for 
ingestion - java.util.Date and a Double after that. Perhaps another 
attribute of double type is missing or the :Double part should be deleted.


Otherwise, I recommend using indexer.xml instead of indexer.properties 
for configuration. In your case it might look like this:




   
  
 ref="timeCollector">ingestion

  
   
   
  
*the_geom:Polygon,location:String,ingestion:java.util.Date
  
   
   
  
 your_coverage_name
 
 
    
 
  
   
   
  
regex=([0-9]{14}),format=MMddHHmmss,fullPath=true

TimestampFileNameExtractorSPI
 ingestion
  
   
   
    

    
    
    value="/path/to/directory/to/be/indexed" />
    
    
    

    


Usually my ImageMosaic folder structure is like this 
(/opt/geoserver_data is the GEOSERVER_DATA_DIR)
* the indexer.xml and datastore.properties files are in a 
/opt/geoserver_data/data/
* there is a subdirectory, usually with a date tree structure for 
storing granules from separate days in separate directories: 
/opt/geoserver_data/data//tiff//MM/DD/some_file_MMDDHHmss.tiff

* in indexer.xml I have *Recursive *parameter set to *true
** I usually use absolute path to the tiff directory as 
*IndexingDirectories* parameter value, e.g. 
/opt/geoserver_data/data//tiff


Finally, if I encounter any problems during ImageMosaic creation I 
ensure to:

* set GeoServer logging to VERBOSE
* drop any database table created (ImageMosaic will refuse to create 
store if a table with the same name already exists), along with index 
and metadata (if using Oracle)
* try it again and look into the log (usually the problem is not 
revealed in the last stacktrace in the log, but in some before last)
* if it doesn't help or I still cannot figure out what is wrong I launch 
Eclipse debugger and examine what EXACTLY is wrong (I used it a lot 
until I figured out how to properly configure time parsing regexes)


Regards,

Peter Kovac



On 29. 9. 2017 10:40, Darell van der Voort wrote:

Hi Peter,

This is my indexer.properties configuration:

Caching=false
TimeAttribute=ingestion
Schema=*the_geom:Polygon,location:String,ingestion:java.util.Date:Double
PropertyCollectors=TimestampFileNameExtractorSPI[timeregex](ingestion)

And this is my 0.properties which is automatically generated for the 
lowest zoomlevel (0):


#-Automagically created from GeoTools-
#Wed Sep 27 14:50:18 UTC 2017
MosaicCRS=EPSG\:32617
Levels=0.062,0.062
Heterogeneous=false
TimeAttribute=ingestion
AbsolutePath=false
Name=0
TypeName=0
Caching=false
ExpandToRGB=false
LocationAttribute=location
SuggestedSPI=it.geosolutions.imageioimpl.plugins.tiff.TIFFImageReaderSpi
CheckAuxiliaryMetadata=false
LevelsNum=1

So like I said, the plugin automatically configures level 0 to the 
PostgreSQL DB if I add the datastore.properties files, but refuses to 
do so for other levels if I add the datastore.properties file to the 
folder levels. If I do not add the datastore.properties file to the 
additional levels, the plugin automatically creates a shapefile for 
these levels, while using the DB connection for level 0. This 
combination works, even with a time dimension. However I would like to 
use the DB connection for all levels and use unique table names in the DB.


Kind regards,
Darell




On Fri, Sep 29, 2017 at 9:59 AM, Peter Kovac 
<peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com>> 
wrote:


Hi Darell,

can you post your indexer.xml configuration for the imagemosaic?

Regards,

Peter Kovac


On 28. 9. 2017 9:59, Darell van der Voort wrote:

Hello everybody,

I'm running Geoserver 2.11.2 on Java 1.8.0_144 32 bits on Amazon
Linux together with Tomcat 9. The plugins I have installed are
imagemosaic, imagepyramid, GeowebCache (internal) and Geofence.

When using the imagemosaic plugin I am able to use a Postgresql
DB for storing the granules and time dimension via a
datastore.properties file. The file looks like:

SPI=org.geotools.data.postgis.PostgisNGJNDIDataStoreFactory
schema=database_schema_name
Loose\ bbox=true
Estimated\ extends=false
validate\ connections=true
Connection\ timeout=10
preparedStatements=true
jndiReferenceName=java:comp/env/jdbc/postgis

Which work as expected. However when I add the same file in the
imagepyramid datastructure, this setup fails. When I add this
datastore.properties in just the lowest level (0) then that level
gets configured in a database table, while the higher levels are
configured using a shapefile. When I add a datastore.properties
to all levels, geoserver returns the following error:

2017-09-

Re: [Geoserver-users] SLD issue with UTC time in TextSymbolizer Label

2017-11-15 Thread Peter Kovac

Hi Ricardo,

is your data source an Oracle database? I used to have some trouble when 
I had DATE columns in Oracle (which, interestingly, stores also the time 
information, despite its type name). I proposed a fix for my use case 
and it has landed on 2.12, but there might be other code paths which 
were not covered. My issue had the same symptoms as yours - TIMESTAMP 
output appeared with time information zeroed.


Regards,

Peter Kovac

On 14. 11. 2017 17:39, PEREIRA Ricardo (EMSA) wrote:


Dear Andrea,

In fact it is a SQL Timestamp.

Cheers,

Ricardo Pereira

*From:*andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] *On Behalf 
Of *Andrea Aime

*Sent:* Thursday, November 9, 2017 11:08 AM
*To:* PEREIRA Ricardo (EMSA); GeoServer Mailing List List
*Cc:* Ian Turton
*Subject:* Re: [Geoserver-users] SLD issue with UTC time in 
TextSymbolizer Label


(please keep the conversation on the list)

That is weird, but I'm wondering... is the data in the data source 
actually a timestamp (e.g., SQL TIMESTAP)?


Or is it a string?

Cheers

Andrea

On Wed, Nov 8, 2017 at 5:49 PM, PEREIRA Ricardo (EMSA) 
<ricardo.pere...@emsa.europa.eu 
<mailto:ricardo.pere...@emsa.europa.eu>> wrote:


Dear Andrea,

Yes…

Please take a look on the attached picture.

Regards,

Ricardo

*From:*andrea.a...@gmail.com <mailto:andrea.a...@gmail.com> 
[mailto:andrea.a...@gmail.com <mailto:andrea.a...@gmail.com>] *On 
Behalf Of *Andrea Aime

*Sent:* Wednesday, November 8, 2017 3:22 PM
*To:* PEREIRA Ricardo (EMSA)
*Cc:* Ian Turton; geoserver-users@lists.sourceforge.net 
<mailto:geoserver-users@lists.sourceforge.net>



*Subject:* Re: [Geoserver-users] SLD issue with UTC time in 
TextSymbolizer Label


Hi Ricardo,

what is the data source?

If you do a WFS request do you get the full time?

What about doing a GetFeatureInfo in the map preview on that polygon?

Cheers

Andrea

On Wed, Nov 8, 2017 at 12:55 PM, PEREIRA Ricardo (EMSA) 
<ricardo.pere...@emsa.europa.eu 
<mailto:ricardo.pere...@emsa.europa.eu>> wrote:


Dear Ian,

Thank you for your suggestion.

Well, I don’t really mind with the wrapping, but I am wondering why 
the hours/minutes/seconds are set to “00:00:00+” as I was 
expecting “15:20:10Z” in this case.


Cheers,

Ricardo Pereira

*From:*Ian Turton [mailto:ijtur...@gmail.com <mailto:ijtur...@gmail.com>]
*Sent:* Wednesday, November 8, 2017 11:49 AM
*To:* PEREIRA Ricardo (EMSA)
*Cc:* Andrea Aime; geoserver-users@lists.sourceforge.net 
<mailto:geoserver-users@lists.sourceforge.net>



*Subject:* Re: [Geoserver-users] SLD issue with UTC time in 
TextSymbolizer Label


Since you have set - 60 - 
that is exactly what I would expect. You have asked GeoServer to wrap 
any label at 60px wide.


Ian

On 8 November 2017 at 11:44, PEREIRA Ricardo (EMSA) 
<ricardo.pere...@emsa.europa.eu 
<mailto:ricardo.pere...@emsa.europa.eu>> wrote:


Dear Ian, dear Andrea,

Below you may find the TextSymbolizer portion and also the .png 
version of the previous image.




 



   -MM-dd'T'HH:mm:ssZ

some_time_property







Arial

9

normal

bold









0.5

0.5









#00



60

150



Thank you very much for your support,

Ricardo Pereira

*From:*Ian Turton [mailto:ijtur...@gmail.com <mailto:ijtur...@gmail.com>]
*Sent:* Wednesday, November 8, 2017 11:37 AM
*To:* PEREIRA Ricardo (EMSA)
*Cc:* geoserver-users@lists.sourceforge.net 
<mailto:geoserver-users@lists.sourceforge.net>
*Subject:* Re: [Geoserver-users] SLD issue with UTC time in 
TextSymbolizer Label


We'd need to see the rest of the TextSymbolizer to see what was going 
on. Also, a larger or png image might help.


Ian

On 8 November 2017 at 11:10, PEREIRA Ricardo (EMSA) 
<ricardo.pere...@emsa.europa.eu 
<mailto:ricardo.pere...@emsa.europa.eu>> wrote:


Hi,

After reading the GeoServer documentation for the dateFormat function 
<http://docs.geoserver.org/stable/en/user/filter/function_reference.html> 
under a SLD style, I put the following in my style:




-MM-dd'T'HH:mm:ss.sssZ

some_time_property



When applying the above, I obtain the following result 
(some_time_property: 2017-11-11 15:20:10.952):


-Do you have an idea what I am missing or if it is even possible to 
show times in this format?


Ricardo Pereira


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
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#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html


Geoserver-users@lists.sourceforge.net 
<mailto:Geoserver-users@lists.sourceforge.net