search

terrabrasilis / ams

AMS - Amazon Situation Room
GNU General Public License v3.0
0 stars 2 forks source link

Integrate data into the database tier #97

Closed andre-carvalho closed 3 years ago

andre-carvalho commented 3 years ago

Integrate DETER-B and DETER IBAMA data into the AMS database using SGDB features such as dblink and SQL Views.

andre-carvalho commented 3 years ago

New objects were created in the AMS database as a result of the solution.

Three SQL views were created:

  1. public.deter_aggregated_ibama
  2. public.deter_all
  3. public.deter_public

Three data tables were created:

  1. deter.deter_all
  2. deter.deter_public
  3. deter.nomes_estrutura_fundiaria