load data for infographic: NCEAS ecosystems, OBIS observations, MarineRegions EEZ, ddgrid hexagons

[bbest]

Load initial data for infographic product:

• NCEAS ecosystems, eg deep soft benthic:

• OBIS observations: see bbest/obis-lat-time-fig to quickly use obis.dat from Pieter Provost 10/3/16 -- a "dump of all OBIS records with latitude, longitude, depth and year" (too big for Github so on BB's hard drive)

• MarineRegions EEZ/IHO political regions

  • or for ABNJ, could use FAO. and within a selected country, could have options within popup to discretize to...

  • World Database of Protected Areas (WDPA from UNEP-WCMC)

  • General Administrative boundaries (GADM.org)

• ddgrid hexagons

[bbest]

Loaded obis occurrence (obis_occ) data into PostGIS database per technical/obis-postgis-connect.Rmd.

[bbest]

• Update postgres/postgis point data attribute from another enclosed polygon shapefile in QGIS - Geographic Information Systems Stack Exchange

UPDATE points SET district = poly.district 
FROM poly 
WHERE ST_Within(points.geom, poly.geom)

• qgis - Update one table from another based on spatial join - Geographic Information Systems Stack Exchange

UPDATE points p 
SET plgn = poly.id 
FROM polygon poly 
WHERE ST_Contains(poly.geom, p.geom);

• postgis - Update database row with points that fall within polygons - Geographic Information Systems Stack Exchange

  update points set country = t1.country from (
  select points.oid, countries.name as country from
  countries INNER JOIN points on st_contains(countries.wkb_geometry,points.wkb_geometry)
  ) t1 
  where t1.oid = points.oid