[image: image.png] SRID in postgis 4326 [image: image.png] SRID in QGis 4326
вт, 13 дек. 2022 г. в 12:05, Bo Victor Thomsen <bo.victor.thom...@gmail.com >: > Is the rasters in same projection (CRS) as the QGIS project ? > > Med venlig hilsen / Best regards > > Bo Victor Thomsen > > Den 13-12-2022 kl. 07:50 skrev Alex German: > > I did everything as described in the documentation. > raster2pgsql -I -C -e -Y -F -s 4326 -t 128x128 -l 2,4,8,16,32 "d:\Temp\060 > tiff\res\t1.tif" testrastr.t1 | psql. > The download is very slow. > https://youtu.be/LULngZIs4nc > > вт, 13 дек. 2022 г. в 09:45, Regina Obe <l...@pcorp.us>: > >> PostGIS raster sadly doesn’t use the pyramids in the Tifs. Or if it does >> no one told me. >> >> >> >> You should build raster overviews using the raster2pgsql –l switch. >> >> https://postgis.net/docs/using_raster_dataman.html#RT_Raster_Loader >> >> >> >> Doc example is this which builds a level 2 and 4 pyramid >> >> raster2pgsql -I -C -e -Y -F -s 26986 -t 128x128 -l 2,4 >> bostonaerials2008/*.jpg aerials.boston | psql -U postgres -d gisdb -h >> localhost -p 5432 >> >> >> >> QGIS knows how to use the overviews built that way and should be much >> faster to view in QGIS >> >> >> >> raster2pgsql -s 4326 -t 256x256 -C -I -F "d:\Temp\060 >> tiff\res\OCG_t1.tif" OCG_t1 -R| psql. >> >> >> >> >> >> *From:* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *On >> Behalf Of *Alex German >> *Sent:* Monday, December 12, 2022 11:34 PM >> *To:* PostGIS Users Discussion <postgis-users@lists.osgeo.org> >> *Subject:* [postgis-users] Qgis + PostGis. Low operating speed. >> >> >> >> Hello everyone! >> >> I have a GeoTIFF. >> >> I built the pyramids in an external file using GDAL >> >> "gdaladdo d:\Temp\060 tiff\res\t1.tif -r lanczos -ro 2 4 8 16 32 64 128 >> 256 512. >> >> Uploaded to PostGIS using >> >> raster2pgsql -s 4326 -t 256x256 -C -I -F "d:\Temp\060 >> tiff\res\OCG_t1.tif" OCG_t1 -R| psql. >> >> The number of files is more than 1000. >> >> When trying to load tables in QGis, the loading is very slow. >> >> At the same time, downloading to QGis from files is fast. Question. What >> is not configured correctly and how to speed up the download to Qgis from >> PostGIS? >> >> >> >> -- >> >> Alex German >> >> >> _______________________________________________ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> > > > -- > Алексей Герман > 8-905-86-00-416 > > _______________________________________________ > postgis-users mailing > listpostgis-users@lists.osgeo.orghttps://lists.osgeo.org/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > -- Алексей Герман 8-905-86-00-416
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users