I know this might be a similar question to many others. I have been prompting multiple questions here and on Google but I can't figure it out. I have a raster and I have uploaded it into PostGIS with the following code:

raster2pgsql -s 28992 -I -M r69hn1.tif -F -t 1000x1250 schema.table | psql -d database -U postgres -p 5432

I am not using -C because it gives an error and I learned in other questions that removing it from the code makes it work; and it does load it in.

Then I am trying to open the data in QGIS using DBManager. There it gives me the message that I have the wrong raster type. The error message is in Dutch and not searchable. I have not found anything similar to my exact problem. The data I am trying to use is downloadable from the following link: http://geodata.nationaalgeoregister.nl/ahn2/extract/ahn2_05m_ruw/r69hn1.tif.zip

The data is coming directly from the PDOK governmental services and is thus a trustworthy link. It is a tile from the AHN 2 height data.

My question is: Is there something wrong with my way of loading in the raster into PostGIS or with visualising it into QGIS. And further, what is wrong and how do I fix it?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.