putting globiom data into a database pedro r. andrade cambrigde, 2013
TRANSCRIPT
Putting GLOBIOM data into a database
Pedro R. Andrade
Cambrigde, 2013
Integration between TerraLib and IIASA tools
G4M
SciSoft
TerraLib
GeoWikiEPICGLOBIOM
???
Integration between TerraLib and GLOBIOM
TerraLib
GLOBIOM
GLOBIOM Integration
TerraView
data
Amazonia (TerraLib)
export
import GeoTiff, CSV
dataGLOBIOM GMS
files
GDX files
simU shapefiles
GLOBIOM Integration
TerraView
data
Amazonia (TerraLib)
export
import GeoTiff, CSV
dataGLOBIOM GMS
files
GDX files
simU shapefiles
Implementation
generate-brazil-cr.R
brasilcr_pt.shp
Implementation
CRbrazil-database.R
CRbrazil-plotall.R
CRbrazil-basics.R
globiom(TerraLib)
bmp files
ACR_COMPARE.csvCROP_DATA_COMPARE.csvYLD_COMPARE.csv...
aRT
FILE aux3 /'Land_Compare3.CSV'/;aux3.pc=5;PUT aux3;
LOOP ( (COUNTRY('Brazil'),ALLCOLROW,AltiClass,SlpClass,SOILCLASS,AEZCLASS,LC_TYPE, AllMacroScen,AllBioenScen,IEA_SCEN,ALLScenYear) $ Land_Compare3(COUNTRY,ALLCOLROW,AltiClass,SlpClass,SOILCLASS,AEZCLASS, LC_TYPE, AllMacroScen,AllBioenScen,IEA_SCEN,ALLScenYear), PUT COUNTRY.tl,ALLCOLROW.tl,AltiClass.tl,SlpClass.tl,SOILCLASS.tl, AEZCLASS.tl, LC_TYPE.tl,AllMacroScen.tl,AllBioenScen.tl,IEA_SCEN.tl, ALLScenYear.tl, Land_Compare3(COUNTRY,ALLCOLROW,AltiClass,SlpClass, SOILCLASS,AEZCLASS, LC_TYPE,AllMacroScen,AllBioenScen,IEA_SCEN, ALLScenYear) /);PUTCLOSE;
attribute_names = list( ... Land_Compare3 = c("COUNTRY", "ALLCOLROW", "ALTICLASS", "SLPCLASS", "SOILCLASS", "AEZCLASS", "LC_TYPE", "AllMacroScen", "AllBioenScen", "IEA_SCEN”, "ALLScenYear", "Value"),)
7_output.gms
CRbrazil-basics.R
CRbrazil-plotall.R/CRbrazil-database.R
original_file = "LUCDET_Compare"r = read_output_csv(original_file)print_unique(r)w = uniques(r)w$AEZCLASS = NULLw$COUNTRY = NULLw$ALLScenYear = 2000w$IEA_SCEN = "BASE"w$AllMacroScen = NULLw$ALTICLASS = NULLw$SLPCLASS = NULLw$SOILCLASS = NULLsave_all(w, original_file)tstates = createTheme(lstates, paste("states-", original_file, sep=""), view=original_file)setVisual(tstates, visualPolygons(transp=100, cwidth=2))
Output
Selecting attributes
Input
7_output.gms
7_output.gms
R plot x TerraLib database
R plot TerraLib database
Overlay single multiple
Plotting at once
multiple maps single map
Colors and spatial operations
require R knowledge
can be handled visually
Running script
every time to plot the results (or save the R session)
only once
Future development
Version 2.0 of the scripts Review R-Script_Instructions.pdf Adapt the scripts to work with different geographical areas