Saturday, 7 March 2015

qgis - Can PostGIS return a list of filenames to rasters that intersects with a vector polygon?



I have 390 invisibility depth viewshed rasters, each with a size of 687 MB. The rasters contain the maximum value a building could attain at any given location, before it's visible from any of the 390 viewshed points.


Would it be possible to get PostGIS to query all the rasters that intersects with a vector polygon (could be converted to raster if easier) and return a list of filenames to those rasters that the vector polygon (a planned building with height in a column called "Z") intersects with?


I would like to be able to take a planned building and without to much manual work get a list/summary over which of the 390 rasters it intersects with.


If this is possible, how would you recommend me to set it up to be able to minimize manual steps?




No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...