Hi Christian,
ah ok. My original data is GeoTIFF 800 images á 10.000 x 10.000 pixels RGB with
300 MB of each image. If I try to create one big GeoTIFF using gdal_retile I
got a memory exception… ;)
if you have some linux scripts I like to look inside the scripts and hope that
I can find some code snips which helps me to configure my geoserver in the
right point of view.
Thanks.
André
Von: Christian Mueller [mailto:christian.muel...@os-solutions.at]
Gesendet: Donnerstag, 30. April 2015 17:40
An: Mende, Andre
Cc: geoserver-users@lists.sourceforge.net
Betreff: Re: [Geoserver-users] WG: ImageMosaicJDBC problem: geoserver stop
waiting before postgres send the raster information
Hi Andre
I meant one big GeoTIFF (no use of gdal_retile) with internal compression,
tiles , overviews and the CRS. This setup works pretty well for my customers.
At the end of the day, you have only one geotiff file and GeoServer works very
good with a geotiff file (my experience).
Maybe I can send you some Linux scripts I am using.
What format is your original data ?
Cheers
Christian
On Wed, Apr 29, 2015 at 9:49 AM, Mende, Andre
<andre.me...@landkreis-zwickau.de<mailto:andre.me...@landkreis-zwickau.de>>
wrote:
Hi Christian again,
Your question was: Did you consider to create one big geotiff file with inner
tiling and overviews ?
I addition to my last post I will ask you something about big GeoTIFF with
inner tilling and overviews.
Do you mean that I have to create for every tile of my gdal_retile result a
inner tilling and overview or should I make one big GeoTIFF (165 GB, maybe 20
GB if I reduce with JPEG-compression) without using gdal_retile?
Thanks.
André
Hi Christian and Andrea,
thank you both for your response.
I had used gdal_retile with different pixelsizes 1000x1000, 2000x2000,
5000x5000.
I am interested in the best configuration as a balance between number of rows
in database for each pyramidal step and the size of the real image.
@ Andrea:
Do you have this paper of Paul Ramsey or a link with the full results?
@ Christian:
Is it faster if I use the raster-column in a function like st_envelope to get
the bounds or maybe we should use a extra column with the geometry bounds
because a raster is a fixed information without dynamic change of the borders?
In my opinion I think it is faster to ask the database whether a point is
inside a bounding box (geometry column) instead of using a full raster and
calculate the borders every time…
Another point: Is there a opportunity only use Image Links in database using
ImageMosaicJDBC? (please look at the answer of Andrea last mail)
Now I compress my source images using gdal_retile including compression
attribute because i will find the right balance between resolution and image
size.
If the process is ready I will tell you some result information. In addition I
will test a 32 bit server with JAI and a 64 bit server without JAI which is
faster or what´s the differences.
Thanks.
André
Von: Christian Mueller [mailto:christian.muel...@os-solutions.at]
Gesendet: Dienstag, 28. April 2015 11:43
An: Andrea Aime
Cc: Mende, Andre;
geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>
Betreff: Re: [Geoserver-users] ImageMosaicJDBC problem: geoserver stop waiting
before postgres send the raster information
Hi Andre
Did you consider to create one big geotiff file with inner tiling and
overviews ?
I think this is the simplest way to support image data.
And here is the Swiss army knife you may need
http://www.gdal.org/
Cheers
Christian
On Mon, Apr 27, 2015 at 4:45 PM, Andrea Aime
<andrea.a...@geo-solutions.it<mailto:andrea.a...@geo-solutions.it>> wrote:
On Mon, Apr 27, 2015 at 4:24 PM, Mende, Andre
<andre.me...@landkreis-zwickau.de<mailto:andre.me...@landkreis-zwickau.de>>
wrote:
Hi Christian,
yes there are write priveleges… but i will look at this again and tell you the
answer.
Now some additional ideas/questions would like to discuss.
A GeoServer-user will use this software with high speed and a useful
configuration.
Therefore it is very important to know whether a 32 bit geoserver using the jai
is faster then a 64 bit geoserver without using jai.
The difference in performance between native and non native jai is probably not
very relevant given you setup a poorly performing environment to start with:
* GeoServer on Windows server is a good 30% slower than on Linux, on the same
hardware (and other GIS software is too, not specific to GeoServer)
* Keeping raster in PostGIS is slower than keeping it on the file system (Paul
Ramsey reiterated that at FOSS4G-NA a few months ago, "keep rasters
in the database only to perform spatial analys, not to serve them on the web)
* Postgis raster does not have native overviews (they are going to be added in
the next version), although the imagemosaicjdbc can probably help here, since
it can work as a image pyramid plugin too
Cheers
Andrea
--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 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<tel:%2B39%200584%20962313>
fax: +39 0584 1660272<tel:%2B39%200584%201660272>
mob: +39 339 8844549<tel:%2B39%20%C2%A0339%208844549>
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.
-------------------------------------------------------
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users