Metabase history

Metabase History

	GCE metabase	SBC, MCR metabase	SBC MBON data packages	SBC LTER data packages
Uses	GCE Matlab toolbox, drives GCE website (people, biblio, datasets, projects, other) Annual report contributions	Initial datasets: holds all content from exant EML research projects: all content for research projects (lterProject XML exported) Anticipated drive website (part) biblio mgmt GCE Toolbox	Assemble EML records with R EML text content in external files	Assemble EML records with R EML text content in external files Anticipated drive website (part, TBD) biblio mgmt
Features	SQL server (Microsoft) num schemas: ___ Num tables: ___	PostgreSQL (open source) MCR, SBC schemas synchronized uses built-in XML data type num schemas: 5 num tables: ___	PostgreSQL num schemas: 3 num tables: 22, 6 (10 views)	PostgreSQL num schemas: ___ num tables: ___
Activities		2011 Ported to postgreSQL populated project schema 2013 populated tables for datasets (16), concurrently with 14 forks (see forks/gce2ucsb) added 2 schemas: mb2EML (for export), pkg_mgmt	2015 dropped empty tables replaced XML-typed fields tailored views for EML production with R	2017 copy schema, migrate content 2018 judicious additions from sbc_metabase, for anticipated uses (above)

Further Reading

Gastil-Buhl, M. and M. O'Brien. 2013. Data Package Inventory Tracking: Slicing and Dicing with SQL. LTER Spring 2013 Databits.

Kui Li. 2018. Postgres, EML and R in a data management workflow EDI webinar

Kui Li and M. O’Brien. 2018. Postgres, EML and R in a data management workflow. LTER Spring 2018 Databits.

O'Brien M. and M. Gastil-Buhl. 2013. Metabase Adoption by SBC and MCR LTER Spring 2013 Databits.

O'Brien, M. 2011. The Santa Barbara Coastal (SBC) LTER's implementation of projectDB using Metabase LTER Fall 2011 Databits.

Sheldon, W.M. Jr., J. F. Chamblee, and R. Cary. 2012. Poster: GCE Data Toolbox and Metabase: A sensor-to-synthesis software pipeline for LTER data management. 2012 LTER All Scientists Meeting, 11-Sep-2012, Estes Park, Colorado.

Sheldon W. and J. Carpenter, 2010. Implementing ProjectDB at the Georgia Coastal Ecosystems. LTER Fall 2010 Databits.

Related GitHub Repositories

Code to read from SBC or MCR metabase, create EML records: https://github.com/mobb/MB2EML

Code for SBC metabase maintenance (incomplete): https://github.com/mobb/MBmaint

Models spawned by GCE-metabase

UCSB LTER metabase (2013, by SBC and MCR LTER): tbd

created and used by Santa Barbara Channel MBON (SBC MBON): tbd

SBC LTER modifications: tbd