Timeline for PostGIS intersect query: Raster footprints of multiple high resolution GeoTIFF's or not? [closed]
Current License: CC BY-SA 3.0
11 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Feb 25, 2018 at 13:41 | history | edited | nmtoken | CC BY-SA 3.0 |
corrected spelling
|
Jan 9, 2018 at 13:24 | history | closed |
Vince whyzar xunilk Kersten Simbamangu |
Opinion-based | |
Jan 9, 2018 at 1:22 | answer | added | Alex Leith | timeline score: 1 | |
Jan 8, 2018 at 20:24 | review | Close votes | |||
Jan 9, 2018 at 13:24 | |||||
Jan 8, 2018 at 20:15 | comment | added | johlund | Sorry Vince! So the path-column that the plugin Image Footprint creates in the footprint attribute table can be used by PostGIS to get me the answer without having to load a singel raster file into the db? Even though it's not solely a xy, but mainly a z-overlap I wanna determine? | |
Jan 8, 2018 at 20:09 | history | edited | Vince | CC BY-SA 3.0 |
removed wannas
|
Jan 8, 2018 at 20:04 | comment | added | Vince | No, you missed it again. The footprint can identify which image, at which point any tool can identify the pixels. | |
Jan 8, 2018 at 19:40 | comment | added | johlund | Thanks for the first explanation I've received on what a footprint is, very helpful! I removed the duplicate question about raster2pgsql. If I understand your definition of a footprint correctly, loading a footprint won't do it for me since I need all the z-values in every 2x2 meter cell of the 700 MB raster!? Looks like I'm gonna need an A380 to deliver the mail? | |
Jan 8, 2018 at 19:37 | history | edited | johlund | CC BY-SA 3.0 |
removed multiple question
|
Jan 8, 2018 at 17:57 | comment | added | Vince | You still have multiple questions here. A footprint is the quadrilateral polygon constructed from corner points e.g. { SWx, SWy, SEx, SEy, NEx, NEy, NWx, NWy, SWx, SWy}). Loading the rasters into the database solely for the purpose of determining overlap is like using an A380 to deliver mail in the bush. | |
Jan 8, 2018 at 15:30 | history | asked | johlund | CC BY-SA 3.0 |