SinBIOTA 2.0: Planning a New Generation Environmental Information System

1. Prof.Carlos A. Joly & Prof.João Meidanis University of Campinas & Scylla Bioinformatics SinBIOTA 2.0: Planning a New Generation Environmental Information System

2. Sao Paulo State 250,000 Km2 97,656 sq.m 720 km coast

3. Sao Paulo State Development rates close to Spain, France, Germany, Italy, UK 41,541,191 inhabitants (22% of Brazil) US$ 450 billion GDP (33,4% of Brazil) US$ 10,800.00/year per capita income 42% of Brazilian exports Brazilian’s biggest sugar cane producer: 270 million t/y = US$ 5.65 billion/2007 (expected to increase 50% in five years)

4. MARCH 1999 www.biota.org.br Based on the Convention of Biological Diversity

6. Sample of BIOTA Data Records

8. Guidelines for biodiversity conservation and restoration in the State of São Paulo.

9. The map produced by the BIOTA/FAPESP Program was adopted by the State Secretary of Agriculture to prohibit sugar cane expansion in the areas prioritize by the program for biodiversity conservation and restoration.

10. SinBIOTA Database of geo-referenced Sao Paulo’s Biodiversity102.704 records 11.820 species

12. SinBIOTA: shortcomings hard to expanded with new modules not portable hard to replicate for other states or regions need to check geographic coordinates for species occurrences need to check spelling of species names

13. SinBIOTA 2.0: Plan for evolution Reference Document - Specification Public call for implementation groups Implementation (possibly one module at a time)

14. Community Meeting: 2009 300+ researchers and students discussion of future directions for the BIOTA Program 2 full days resulted in “Science Plan & Strategies for the Next decade” suppl. material of Science paper

15. Community requirements Import all data from current system Must be easily replicable and portable, to allow use in other states and regions Must be easily expandable, to allow future inclusion of new modules

16. Community requirements (cont.) Built in dictionary of species names, to avoid mistakes due to misspeling Built in mechanism of data auditory, to avoid mistakes due to wrong geographic coordinates Import/export mechanisms to/from specialized tools (species distribution, niche modeling, etc.)

17. TOOLS MaxEnt Open Modeler DIVA Gis

18. Expand carthographic base

19. Full interoperability

20. Fapesp/Microsoft Research Two-year, jointly funded project Started Decembro 2009 Goals: Reference Document (specification) for SinBIOTA 2.0 Implementation of prototype for SinBIOTA 2.0

21. Reference Document: topics • Visits to users to get feedback • Study of GBIF, OBIS, ALA, EOL, etc. • Scalability and security of large DBs • Multimodal data and search • Survey of map systems • Specialized tools (sp. distribution, etc.) • Data mining, knowledge discovery • Use of mobile clients • Cloud computing • Social networks

22. Current Database Schema • Lack of integrity constraints • Each taxon rank as individual table

23. New Database Schema Class Modeling + Object-Relational Mapping

24. Taxonomy Class/Table Each taxon group is a row in Taxon table Rank is attribute of taxon group Explicit parent / child relationship

25. System architecture: prototype

26. Implementation with Bing Maps

27. Heat Map with Population

28. Color Map United Nations' Human Development Index

29. Auto-complete

30. Cited links www.biota.org.br www.biotaneotropica.org.br sinbiota.cria.org.br bioenfapesp.org biota.cna.unicamp.br/bioprospecta DOI: 10.1126/science.1188639 www.mp.sp.gov.br/portal/page/portal/cao_urbanismo_e_meio_ambiente/atos/Ato-PGJ-565-09-metas-GAEMA.doc www.cetesb.sp.gov.br/licenciamentoo/legislacao/estadual/resolucoes/2009_Res_SMA_15.pdf www.ambiente.sp.gov.br/zoneamentoagroambientalcana.pdf

31. DankeschönThank you ! Thank you !