Contents
How to load raster data to PostGIS-geographic information systems Stack Exchange?
For question 3, the simplest would be to load the raster into QGIS just as a regular raster and check that it is aligned with something using a known projection. Whether it is in PostGIS or not should not make a difference in this regard. Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
Which is the best tool for loading raster data?
Usually named rast -I #Create Gist index. You want this for using spatial indexes. -Y #Use copy instead of insert when importing the data. Much faster. harder to debug if there are problems. 1.) Is raster2pgsql the best loading tool?
How to correct no data layer in PostGIS?
An easy way to correct the layer as sent is simply to use gdal_translate to produce a new layer with the correct no data value. This can be done directly on the command line, or in the GUI by choosing the relevant option in Quantum GIS from the raster menu.
How to check the alignment of raster data?
You can make a visual check of the raster with QGIS like tools by loading other vector data around Spain. Consistently using SRIDs solves most alignment issues. For question 3, the simplest would be to load the raster into QGIS just as a regular raster and check that it is aligned with something using a known projection.
Is the PostGIS executable compatible with raster2pgsql?
It is capable of loading folders of raster files as well as creating overviews of rasters. Since the raster2pgsql is compiled as part of PostGIS most often (unless you compile your own GDAL library), the raster types supported by the executable will be the same as those compiled in the GDAL dependency library.
How to add rasters to a QGIS query?
If you tile the rasters (speeds up queries considerably) with -t 128×128 for example, you would have one line per tile. You can add them to QGIS, using the DB manager. You right click on the layer in the DB manager and choose “Add to Canvas”.