5

I have a problem... I have been successful in uploading the raster in postgis but when I access it through Qgis. it does not open even after several hours.

I have 10GB aerial image raster and everytime i try to open it through QGIS it does not open even after many hours and QGIS crashes...

why is this happening...?? is it really due to the file size..??

Regards, Omer

  • 2
    How did you load (correctly) the file into postgis? Is it indexed - do request a small area spatially? – Mapperz Aug 27 '13 at 16:48
  • This is also posted on the qgis-user mailing list... lists.osgeo.org/pipermail/qgis-user/2013-August/023617.html – SaultDon Aug 27 '13 at 21:24
  • 5
    You're loading it and then trying to view the whole extent in QGIS? Yes, it's the file size. You can't view a 10G image without overviews, and your database raster probably doesn't have overviews built. If you're just looking at it, leave it as a file and access it there, it'll be loads faster and even will work. – Paul Ramsey Aug 28 '13 at 17:13
1

Raster was loaded properly in Postgis with overviews but qgis plugin "Add a Postgis Raster layer" can't handle this file due to the size (10GB). However, I was successful in adding a subset of that raster whose size was comparatively very small. QGIS displays that raster correctly. I have tried raster having maximum 3GB size. If anyone has succeeded with more than this size, kindly post a comment here

0

Try building a virtual raster and pyramids from the original. Qgis should then only load the visible part into memory.

See http://osgeo-org.1560.x6.nabble.com/gdalbuildvrt-setting-scale-dependent-visibility-td5095071.html for details

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.