[postgis-devel] postgis-devel Digest, Vol 227, Issue 14

[Pascal Bircher / Netzwerk Schweizer Pärke]

Dear Regina
One of the mentioned solutions would be good. Otherwise the db gets very large with the overviews and the "-R" option is not worth it. By the way this function can be a big advantage keeping the db small to other db solutions storing raster data.
Kind regards
Pascal

-----Ursprüngliche Nachricht-----
Von: postgis-devel <postgis-devel-bounces at lists.osgeo.org> Im Auftrag von postgis-devel-request at lists.osgeo.org
Gesendet: Montag, 28. März 2022 21:00
An: postgis-devel at lists.osgeo.org
Betreff: postgis-devel Digest, Vol 227, Issue 14

Send postgis-devel mailing list submissions to
	postgis-devel at lists.osgeo.org

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.osgeo.org/mailman/listinfo/postgis-devel
or, via email, send a message with subject or body 'help' to
	postgis-devel-request at lists.osgeo.org

You can reach the person managing the list at
	postgis-devel-owner at lists.osgeo.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of postgis-devel digest..."


Today's Topics:

   1. Re: Is it planned that overview rasters of PostGIS rasters
      can be registered outside the database instead of inside (Regina Obe)


----------------------------------------------------------------------

Message: 1
Date: Mon, 28 Mar 2022 03:23:52 -0400
From: "Regina Obe" <lr at pcorp.us>
To: "'PostGIS Development Discussion'" <postgis-devel at lists.osgeo.org>
Subject: Re: [postgis-devel] Is it planned that overview rasters of
	PostGIS rasters can be registered outside the database instead of
	inside
Message-ID: <001401d84274$c79722c0$56c56840$@pcorp.us>
Content-Type: text/plain; charset="iso-8859-1"

Pascal,

 

Not to my knowledge.  Are you proposing that raster2pgsql would generate the overviews outside of the database and then register what it generated?

The issue I see with that is then it would need to decide what format to store these overviews because the postgis raster format can?t exist outside of the database.

A more common request is referencing overviews that are already built.  Many external raster already have such a functionality.  I think that?s a bit more involved though.

 

Thanks,

Regina

 

 

 

From: postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Pascal Bircher / Netzwerk Schweizer P?rke
Sent: Thursday, March 24, 2022 9:56 AM
To: postgis-devel at lists.osgeo.org
Subject: [postgis-devel] Is it planned that overview rasters of PostGIS rasters can be registered outside the database instead of inside

 

Dear PostGIS-Developer

With the raster2pgsql tool also overviews of the rasters can be loaded into the database. It should be possible to register these overviews outside the database instead of loading them into the database. The problem is that rasters with high resolutions (2m, 0.1m) need a lot of space for the overviews. Is there any development ongoing or planned in this regard?

 

Kind regards

---

Pascal Bircher

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20220328/66da6507/attachment-0001.html>

------------------------------

Subject: Digest Footer

_______________________________________________
postgis-devel mailing list
postgis-devel at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-devel


------------------------------

End of postgis-devel Digest, Vol 227, Issue 14
**********************************************