130 likes | 297 Views
Putting GLOBIOM data into a database. Pedro R. Andrade Cambrigde, 2013. Integration between TerraLib and IIASA tools. SciSoft. G4M. GLOBIOM. EPIC. GeoWiki. ???. TerraLib. Integration between TerraLib and GLOBIOM. GLOBIOM. TerraLib. GLOBIOM Integration. data. GeoTiff, CSV. GMS
E N D
Putting GLOBIOM data into a database Pedro R. Andrade Cambrigde, 2013
Integration between TerraLib and IIASA tools SciSoft G4M GLOBIOM EPIC GeoWiki ??? TerraLib
Integration between TerraLib and GLOBIOM GLOBIOM TerraLib
GLOBIOM Integration data GeoTiff, CSV GMS files import GLOBIOM export data GDX files Amazonia (TerraLib) TerraView simU shapefiles
GLOBIOM Integration data GeoTiff, CSV GMS files import GLOBIOM export data GDX files Amazonia (TerraLib) TerraView simU shapefiles
Implementation generate- brazil-cr.R brasilcr_pt.shp
Implementation ACR_COMPARE.csv CROP_DATA_COMPARE.csv YLD_COMPARE.csv ... CRbrazil- plotall.R bmp files CRbrazil- basics.R globiom (TerraLib) aRT CRbrazil- database.R
7_output.gms 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"), ) 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 = NULL w$COUNTRY = NULL w$ALLScenYear = 2000 w$IEA_SCEN = "BASE" w$AllMacroScen = NULL w$ALTICLASS = NULL w$SLPCLASS = NULL w$SOILCLASS = NULL save_all(w, original_file) tstates = createTheme(lstates, paste("states-", original_file, sep=""), view=original_file) setVisual(tstates, visualPolygons(transp=100, cwidth=2)) Input Selecting attributes Output
Future development • Version 2.0 of the scripts • Review R-Script_Instructions.pdf • Adapt the scripts to work with different geographical areas