Stack Overflow
Stack Overflow

Questions tagged [postgis-raster]

To store and analyze raster data in PostGIS, use the raster data type.

20 questions
0
votes
0 answers

Why is ST_Contour returning error "band number must be between 1 and 0 inclusive", when value passed to the function is 1?

I am trying to use ST_Contour() to create contour lines from a raster stored in db. When I pass: SELECT ST_Contour(my_raster_column, 1, 5, 0) FROM my_schema.my_table WHEN my_other_column IS NOT NULL (I am using async python with…
bzlmnop
  • 1
0
votes
1 answer

ERROR: current transaction is aborted, commands ignored until end of transaction block when trying to import a raster image to postgis

I am getting the following error when trying to import a raster image to a PostGIS DB using raster2pgsql. ERROR: current transaction is aborted, commands ignored until end of transaction block I have tried a number of different solutions without…
Jaun van Loggerenberg
  • 3
  • 4
0
votes
1 answer

Insert GTiff-file into PostGIS table using raster2pgsql

I am trying to insert a GTiff-file into a specific PostGIS table using the raster2pgsql-command. So far I managed inserting the GTiff-file into the PostGIS database I am connected to. But this creates a new table with the file-name of the…
jakobxu
  • 15
  • 5
0
votes
1 answer

Getting FILTER variable into MapServer DATA string

I need a solution to the following or a link to a detailed parameter guide that describes a Mapserver MapFile DATA element so I can try and work out a solution. I'm trying to pass a dynamic filter to the mapfile but can't work out the syntax to do…
Diplonics
  • 435
  • 1
  • 4
  • 12
0
votes
0 answers

how to decrease the execution time in postgresql?

I stored large amount of Raster data ~ 100 MB deolali map in postgresql using raster2pgsql command. The primary key in deolali table is rid. I am using query st_clip from postgis extension and i am getting 9.6 seconds for the query to execute. I…
user7495107
1
2