I am new to PostGIS as well as SQL queries for rasters. I have imported a raster .tif file into PostGIS with tiles. I would need to select a bounded rectangle from within this raster using SQL statements but i have no clue on how to begin.

Can i ask what are the possible/better ways to do that? Do i need to have the top left and bottom right coordinates/lat long to get the rectangle?

I had search and read many other related posts about using ST_Intersects, BBOX and ST_MakeEnvelope but i don't really quite get them.

Thank you!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.