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> 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
> <christian.muel...@os-solutions.at>]
> *Gesendet:* Dienstag, 28. April 2015 11:43
> *An:* Andrea Aime
> *Cc:* Mende, Andre; 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>
> wrote:
>
> On Mon, Apr 27, 2015 at 4:24 PM, Mende, Andre <
> 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
>
> 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.
>
>
>
> -------------------------------------------------------
>
>
>
> ------------------------------------------------------------------------------
> 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
>
>
>
>
>
> --
>
> 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
>
>
--
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
