add AquaMaps data

[7yl4r]

Explorer: load data into PostGIS database: AquaMaps

Notes for MBON & AquaMaps - Google Docs

• Load tables into pg db
• hcaf -> ...

[bbest]

Initial investigations in aquamaps_ingest.Rmd...

CSV to TIF

1. Initial conversion from *.csv to *.tif, eg from speciesoccursum_ver0816c.csv SpeciesID == "ITS-Mam-180537" (North Atlantic right whale Eubalaena glacialis) to ITS-Mam-180537.tif:

https://www.aquamaps.org/preMap2.php?cache=1&SpecID=ITS-Mam-180537

For the 24,904 species, it took 8.8 hours and the output *.tif's used 472 MB.

Rasters in PostGIS

Research on storing in PostGIS and doing intersection operations, especially:

• WKTRasterTutorial01 – PostGIS
  • "use the st_intersection() function and st_intersects() operator which operates directly on raster and geometries by vectorizing only the necessary part of the raster before doing the intersection and is one of the main feature of PostGIS WKT Raster"
  • Summarizing the elevation values for each buffer and exporting the table to CSV
  • Intersecting a raster with a polygon using PostGIS - artefact error - Geographic Information Systems Stack Exchange