I am new to PostGIS and am unsure if I'm thinking of this correctly, but I'd like to return values from multiple raster tables in a PostGIS database in one go.
The purpose is to query legend values for a webmap based on the lat/long values of a cursor click. So, if there are multiple raster tables in the database e.g.,
raster2, I would like to shoot
lon to the DB and return the values from both rasters in some sort of dictionary.
How would I go about doing so with an SQL command? Would I need to do some sort of spatial join? Multiple select statements?