Source: NORTH CAROLINA STATE UNIV submitted to
DATABASE INTEGRATION WORKSHOP: BUILDING THE DATA CAPACITY FOR FOOD-ENERGY-WATER RESEARCH
Sponsoring Institution
National Institute of Food and Agriculture
Project Status
COMPLETE
Funding Source
Reporting Frequency
Annual
Accession No.
1015076
Grant No.
2018-67021-27696
Cumulative Award Amt.
$37,198.00
Proposal No.
2017-07088
Multistate No.
(N/A)
Project Start Date
Mar 1, 2018
Project End Date
Feb 28, 2019
Grant Year
2018
Program Code
[A1521]- Agricultural Engineering
Project Director
Yao, Y.
Recipient Organization
NORTH CAROLINA STATE UNIV
(N/A)
RALEIGH,NC 27695
Performing Department
Forest Biomaterials
Non Technical Summary
Energy and water are two critical sources for food production; developing sustainable agricultural systems requires a wise management and balance among food, energy, and water systems (FEW). Better understandings of the interaction among food, water, energy systems and the social, economic, and environmental impacts of FEW nexus will greatly enhance system-wide decision-making, improving the sustainability of food supply chain as well as water and energy systems.Advancing the knowledge of interactions within FEW systems and identifying critical challenges that could be addressed by the simultaneous management of three systems requires massive datasets related to the supply chain of food, water, and energy. Intensive efforts have been made by the research community, government agencies, and the industry to generate data to meet the needs of various stakeholders, but such data is highly scattered and has not been integrated for the potential application of big data analysis that could bring new insights and advance knowledge. We believe many solutions to addressing complex sustainability issues in U.S. food supply chains, especially those related to water and energy use, could be generated through the integration of different datasets.To better understand the frontier of existing data, the future needs of data, as well as the barriers to building data capacity for improving system sustainability of food supply chains in a context of FEW, we propose to host a 1.5-day workshop to gather experts to discuss, brainstorm, and identify critical issues and future directions of big data investment for addressing FEW challenges. The topic is highly aligned with multiple AFRI program area priorities, such as bioenergy, natural resources, and environment, agriculture economics and rural communities, critical agricultural research and extension, and agriculture systems and technology.After the workshop, we will deliver a report that highlights the major findings and conclusions from the workshop, and submit it to USDA and disseminate to the public through Dr. Yao's research website and a peer-reviewed publication. The insights and ideas generated during the workshop will shed light on directions of future efforts and investment in big data.North Carolina State University (NCSU) is a perfect location to host the proposed workshop. NCSU has close connections with governmental research offices in the Research Triangle Park area, such as USDA and EPA. We will host the workshop at the Talley Student Union on the NCSU main campus. At 283,000 square feet, Talley is one of NC State's largest, busiest and most sustainably-designed buildings. There is a management team in Talley to help the university and faculty organize meetings, host events, and provide technical support. The conference rooms in Talley are equipped with assistive technologies, such as screen readers, special switches, and communication boards.
Animal Health Component
(N/A)
Research Effort Categories
Basic
(N/A)
Applied
(N/A)
Developmental
100%
Classification

Knowledge Area (KA)Subject of Investigation (SOI)Field of Science (FOS)Percent
60560503030100%
Goals / Objectives
The long-term goal of the project is to provide a clear vision for the research community, industry, and government agency to better measure, understand, and promote system-wide sustainability of food, water, and energy systems through large-scale data sharing and engagement. Specifically, we are proposing to host a 1.5-day workshop to identify priorities and bottlenecks in generating, managing, and integrating large datasets related to the three pillars of sustainability (social, economic, and environmental) for FEW systems. After the workshop, we will deliver a report that highlights the major findings and conclusions from the workshop, and submit it to USDA and disseminate to the public through Dr. Yao's research website and a peer-reviewed publication. The insights and ideas generated during the workshop will shed light on directions of future efforts and investment in big data.The proposed workshop includes the following sub-objectives:promote the communication and knowledge sharing for database integration for food, water, and energy systemsidentify the frontier of data and understand current data capacity across different government agencies and private sources vision transformative insights that could be obtained through data integration among different database, and how those insights would be useful to decision makingidentify future barriers and challenges for database integrationidentify short-term and long-term research and development priorities/needs of large-scale data sharing, engagement, and integration.
Project Methods
Early July in 2017 are proposed dates, subject to change if necessary for adequate participation. Discussions will be recorded electronically, scribed, and shared via Google Doc. The announcement of the workshop will include the information about the nature and purpose of the workshop, the names of organizing committee members, potential participants, location and time. The invitation email to speakers will include additional information, such as the timeslots and expected topics of their talks. In the announcement, we will provide a link for RSVP. We will designate a contact person (a student at the NCSU) and email address for responses. The contact person will also be responsible for managing a participants list and responding to general questions from participants, such as parking and accommodation.Workshop participantswill be asmall set of peoplewho either manage government databases or have had experiences using those databases. The list of potential participants includes (subject to change based on their availability):AgendaThe expected number of participants is 30-40 people (given that the proposed participants above may want to bring their team members or other researchers). We will work with the management team at the Talley Student Union at NCSU to prepare and organize the workshop, such as setting up the workshop and purchasing food. The schedule is proposed to be:Workshop Agenda TimeActivities1st Day8:00-8:30Breakfast and networking8:30-9:00Background for the activity;participant introduction; discussion and adaptation of workshop agenda9:00 - 9:45USDA Data Capacity and VisionUSDA speaker will give a talk on current efforts and future vision of database development and integration9:45-10:30DOE/EIA Data Capacity and VisionSpeaker from DOE national labs/EIA will give a talk on DOE/EIA's efforts and visions for database development10:45 - 11: 30EPA Data Capacity and VisionSpeaker from EPA will give a talk on EPA's data capacity and efforts on database integration11:30 -12:20Small group practice:What is the current data capacity? Is there any overlapping among different databases and data sources?Participants will be separated into small groups (5-6 people/group) for practice. Each participant will be given post-it notes to write database/data sources he/she is aware of from both government agencies and private sources, as well as the type of the data included. Then each of them will be asked to attach the notes to the flip chart (1 flip chart/group). Each discussion chart will be divided into four sub-sections (energy, food, water, and environment).The purpose of this practice is to encourage communication and knowledge sharing among the participants and identify all the databases and data sources that are available, and areas that have overlapping.12:20 - 1: 30Working lunchThe information on the discussion flip charts will be collected and reported. The expected deliverable is a comprehensive list of all the database and data sources that are currently available and related to energy, food, water systems and their environmental impacts, as well as some areas that have overlaps.1:30 - 2:15IEA's experience in database integration and management Dr. Eric Masanet (the Head of the Energy Demand Technology Unit, International Energy Agency) will give a talk about IEA's approaches in collecting, managing, and integrating data from different sources.The purpose is to share the experience of IEA as a large autonomous intergovernmental organization for OECD countries on database integration and data capacity development across a broad range of organizations/governments all over the world.2:15 - 3:00Database harmonization and integrationDr. Runze Huang will give a talk about the harmonization and integration across several databases from different U.S. government agencies.The purpose is to highlight the potential insights and barriers to integrating various database.3: 15 - 4:15Small group discussion:What are challenges for database integration and data analysis across different agencies (more specifically, technical, educational, and politic/governmental challenges)?Each group will be provided with a flip chart with paper to write down their thoughts under four categories of challenges, including technical, educational, and politic/governmental challenges.In the last 15 minute, each group will be asked to give a summary of their discussion4:15 - 5:15Small group discussions:What efforts should government agencies, academia, and the industry make to address these challenges (more specifically, technical, education, and politic/governmental efforts)?The format of the discussion is similar the previous one. In the last 15 minutes, each group will be asked to give a summary of their discussion5:15 - 6:00In the small groups, each group will be asked to draft and post outlines for the report sections about the challenges and efforts of mitigation6 pmDinner and networking2nd Day 8:30-9:00 amResults reportingThe organizing committee will give a presentation about the results and conclusions generated from the first day's discussion.9:15-10:15Small group discussions to identify priorities and define short-term and long-term goals.The format is similar to the previous discussions. Each group will be asked to discuss and rank the importance and urgency of different questions, issues, and challenges highlighted from previous discussions, as well as the priority of governmental, technical, and educational efforts to address those issues.Each group is expected to generate an action plan outlining the short-term and long-term efforts for government agencies to pursue10:15 - 11:15Each group presents the action plan, and discussion with all participants.11:30- 12:30Lunch with summary and feedback.Meeting adjournedPost-workshopDraft and edit the report, review by all participantsPresentation by PI to USDAFeedback to workshop participants, using conference call if necessary to resolve additional questions. Submission of the final document and peer-reviewed article

Progress 03/01/18 to 02/28/19

Outputs
Target Audience:The Database Integration Workshop: Building the Data Capacity for Food-Energy-Water Research was held on September 11, 2018, at North Carolina State University. The objective of the workshop was to provide a clear vision for better measuring, understanding, and promoting system-wide sustainability of FEW systems through large-scale data sharing and engagement. The targeted participants include researchers, analysts, and program leaders from universities, research institutes, national labs, and government agencies with expertise in FEW systems and/or data management. In total, we had 35 participants from U.S. government agencies (i.e., USDA, Environmental Protection Agency, U.S. Department of Energy, and U.S. Forest Service), International Energy Agency, six U.S. national labs, university, and research institutes. A project website was developed and hosted at the PI Yao's research group website. The project website includes the slides of presentations and a project report that is open to the public. Changes/Problems:The major challenge we encountered during the project period was Hurricane Florence, which landed NC in the same week of the workshop. As most participants are out of the state, we decided to condense the workshop from 1.5 days to 1 day by merging some discussion sessions to allow sufficient time for participants to leave NC and travel back. This was an unexpected situation, and thankfully we accomplished all goals mentioned in the proposal. What opportunities for training and professional development has the project provided? Nothing Reported How have the results been disseminated to communities of interest?A project website was developed and hosted at the PI Yao's research group website. The project website includes the slides of presentations and a project report that is open to the public, which allows for dissemination to a broad public audience who are interested in data and food-energy-water nexus related topics. We emailed the project website link to all workshop participants and asked them to share with any colleagues they feel relevant and interested. We also posted the project website link in social media such as LinkedIn. The project website will be hosted permanentlyand maintained by PI Yao after the project period at least five years. The website link is below: https://faculty.cnr.ncsu.edu/yuanyao/database-integration-workshop-building-the-data-capacity-for-food-energy-water-research/ We also submitted an abstract to International Symposium on Sustainable Systems and Technology (ISSST) conference, which is one of the longest-running research conferences related to sustainability and the intersection of technology, policy, and behavior. The abstract was accepted for the oral presentation in June 2019. The conference participants include engineers, scientists, professionals, and educators. We may submit additional abstracts after the project period for other suitable conferences. What do you plan to do during the next reporting period to accomplish the goals? Nothing Reported

Impacts
What was accomplished under these goals? Weaccomplished those objectives mentioned in the proposal. The workshop gathered researchers, analysts, and program leaders from universities, research institutes, national labs, and government agencies with expertise in Food-Energy-Water (FEW) systems and/or data management. The workshop included group discussions and keynote presentations. The outcomes of the workshop include: A comprehensive list of data resources available and related to the FEW, which shows the frontier of data and current data capacity across different government agencies and private resources. The list was generated by workshop participants' discussions and knowledge sharing. Insights and challenges that could be addressed by data integration in theFEW areas, which were generated through keynote speakers and breakout session discussions in the workshop. A list of top gaps and data needs with a vision of future database integration and data sharing. Top challenges and knowledge gaps identified and ranked by workshop participants Action plans developed by workshop participants with short-term and long-term goals to address the top challenges. All outcomes discussed above were included in the project report that was written by the project team and posted on the project website: https://faculty.cnr.ncsu.edu/yuanyao/database-integration-workshop-building-the-data-capacity-for-food-energy-water-research/

Publications

  • Type: Conference Papers and Presentations Status: Accepted Year Published: 2019 Citation: Yuan Yao, Runze Huang, Richard Venditti, Kai Lan, Zhenzhen Zhang, Insights from the Database Integration Workshop: Building the Data Capacity for Food-Energy-Water Research, International Symposium on Sustainable Systems and Technology Conference, Portland, Oregon, USA, June 25-28, 2019.
  • Type: Websites Status: Published Year Published: 2019 Citation: Database Integration Workshop: Building the Data Capacity for Food-Energy-Water Research, North Carolina State University, 2019. URL https://faculty.cnr.ncsu.edu/yuanyao/database-integration-workshop-building-the-data-capacity-for-food-energy-water-research/.
  • Type: Other Status: Published Year Published: 2019 Citation: Yuan Yao, Runze Huang, Richard Venditti, Kai Lan, Zhenzhen Zhang. Report for Database Integration Workshop: Building the Data Capacity for Food-Energy-Water Research, North Carolina State University, Raleigh, NC, 2019. URL https://faculty.cnr.ncsu.edu/yuanyao/database-integration-workshop-building-the-data-capacity-for-food-energy-water-research/.