AnsweredAssumed Answered

Accessing rasters within Postgres Database

Question asked by rata_zhaw on Aug 13, 2019
Latest reply on Aug 21, 2019 by asrujit_pb

We're working with a mix of different software to store and query our data on our PostgreSQL Server. We've found a way to deal with geometry data and convert the default st_geometry datatype into postGIS "geometry" and thus can query the data from inside R, for example, without external tools.

 

When storing our raster data on the server, this task becomes much more difficult. Viewed in pg admin, my raster dataset consists of a table with a single row of the following columns: oid (integer), footprint (st_geometry), raster (integer).

 

 

Where is the raster file (BLOB?) stored? We've searched through our database, but couldn't find anything relevant. Maybe these dependents give a hint?

 

 

Outcomes