I recently set up an Ubuntu Server as a Postgres/PostGIS database server. In an effort to serve a collection of aerial photos to my colleagues, I loaded 608 GeoTiffs (non-overlapping 1km tiles each ~60mb) into a Postgres/PostGIS (Postgres version 9.3) using raster2pgsql. Six overview levels were selected using the -l switch to speed up rendering in QGIS. The following was used to load the rasters into the dbase:
raster2pgsql -s 26917 -I -C -M -l 2,4,8,16,32,64 *.tif -F -t 100x100 imagery.aerials | psql -d KCCAGIS postgres The process ran successfully without any errors. Using DB Manager in QGIS (version 2.8.1), the resulting raster dataset (imagery.aerials) loads. However, when zoomed out to the maximum extent (or anything beyond 1:30,000), white lines appear on the imagery. These are presumably NoData areas, but there are absolutely no gaps in the raster dataset. Furthermore, when zoomed in those lines do not appear. For example, see this image (1:38,000).
Can anyone explain what causes the appearance of these lines, and how to either remove them or prevent them from appearing? Furthermore, is this a QGIS issue or a Postgres/Postgis issue?
Thanks in advance!
أكثر...
raster2pgsql -s 26917 -I -C -M -l 2,4,8,16,32,64 *.tif -F -t 100x100 imagery.aerials | psql -d KCCAGIS postgres The process ran successfully without any errors. Using DB Manager in QGIS (version 2.8.1), the resulting raster dataset (imagery.aerials) loads. However, when zoomed out to the maximum extent (or anything beyond 1:30,000), white lines appear on the imagery. These are presumably NoData areas, but there are absolutely no gaps in the raster dataset. Furthermore, when zoomed in those lines do not appear. For example, see this image (1:38,000).
Can anyone explain what causes the appearance of these lines, and how to either remove them or prevent them from appearing? Furthermore, is this a QGIS issue or a Postgres/Postgis issue?
Thanks in advance!
أكثر...