[postgis-users] Importing large GeoTIFFs best practices

Антон Брюхов asbryukhov at gmail.com
Sat Dec 23 03:43:36 PST 2017


Hi Giuseppe,

Does PostGIS support seamless working with a set of tiles (small
rasters) as a single raster?
Thank you.

Best regards,
Anton Bryukhov

2017-12-22 12:18 GMT+03:00 Giuseppe Broccolo <g.broccolo.7 at gmail.com>:

> Hi Антон,
>
> 2017-12-21 20:13 GMT+01:00 Антон Брюхов <asbryukhov at gmail.com>:
>
>> Greetings,
>>
>> What is best way to import and work (in terms of performance
>> and convenience) with large GeoTIFF rasters (~9000x9000). Is it better to
>> register them as out-db rasters or not? Is it a good practice to cut big
>> rasters in tiles and process them in that way?
>>
>
> IMHO it is better to work with an higher granularity (i.e. smaller
> raster's size) in order to improve caching of tiles, etc., and keep them in
> the db, that will efficiently provide them basing on spatial queries.
>
> All the best,
> Giuseppe.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171223/5ff8e953/attachment.html>


More information about the postgis-users mailing list