Q&A - Question

Can't load raster layers from PostGIS

Question
GloH asked on October 02, 2019, keyword: Viewer / Editor
Hi,
We imported a geoTiff file in PostgreSql whith raster2pgsql .
Using TatukGIS Viewer (5.15), we can connect to PostGIS and vector layers are showing. But Viewer can't show raster layer (when QGis can load them).

[TatukGIS Layer]
ADO=Provider=MSDASQL.1;Persist Security Info=False;Data Source=PostgreSQL35W
Dialect=POSTGRESQL
Layer=layerName;public;gis1
Storage=PixelStore2
 
=> Unrecognized file format

Does TatukGIS support raster layers from PostGIS? How we can load them?
 
Answers
Artur Redzko (TatukGIS) replied August 12, 2019
We support PostGIS raster via GDAL library. Here is sample config file (.ttkps) :

[TatukGIS Layer]
Storage=GDAL
LAYER=
layerName
DIALECT=GDAL
Path=PG:host=localhost port=5439 dbname='postgis' user='postgres' password='postgres' schema='public' table=world mode=2"
SanP replied October 02, 2019
@Artur Redzko

GDAL library (as you described above) can open raster (Imported GeoTiff) as pixel  not a Grid layer and then opened layer hasn't elevation information. What about opening a Grid layer from PostGIS raster?
If you would like to answer the question please Sign In.
Please review our recent Privacy Policy.
If you have any questions or requests, please contact us.
Rules
The Questions and Answers (Q & A) is intended to provide a means of communication between TatukGIS customers.
 
  1. Licensed users (with active maintenance play) of TatukGIS products may contribute to the Q & A content. Read-only access is available to anyone.
  2. Keep the content positive and professional.
  3. Be courteous to others by posting information when a question or issue asked on the Q & A is answered or resolved by other means (such as with help from TatukGIS technical support). Offer others at least a hint how the posted question was answered or the issue was resolved.
  4. The Q & A is not a replacement for TatukGIS technical support. TatukGIS team may or may not regularly follow or contribute content.