Location: Subtropical Horticulture Research
Project Number: 6038-21000-022-04
Start Date: Jun 04, 2013
End Date: Sep 30, 2015
(1) We will evaluate existing workflows and data collection procedures. In order to develop appropriate method to gather location information we will visit the USDA SHRS and accompany a trained person from USDA during data acquisition. Based on procedures, plant distribution and density we will make recommendations on location attribute collection. (2) We will acquire spatial information for all accessions based on method developed in (1). Data will be stored as flat files and a database tables linked to accession data. Methods will primarily depend on the existing GRIN database structure and flexibility of expansion. (3) We will get familiar with the GRIN database schema - local installation and experimenting with existing tools (e.g., Curator Tool, Import Wizards, etc.). The data structure of all existing accessions in spreadsheet format will drive the scripting effort to convert all data to compliance with the GRIN database schema and loading tools. We will work in close collaboration with USDA Scientists and Systems Administrators to guarantee compliance with software standards and limitations of the agency. (4) We will batch process all existing data into a local database. Upon quality control of results data will be committed to the global GRIN database. (5) We will develop map templates that are most useful for data collection planning assistance and mapping of attribute data. For this task we will consult with data managers, campaign planners and scientists. The goal is to develop simple procedures within open source software environments that are GIS capable. We will consult with USDA personnel on preferences and current software use and compliance. (6) We will document all procedures and detailed method steps. Training material for a workshop will be prepared and one on-site workshop will be conducted. (7) For the second year we will provide consultation services, additional training and advising in continuation of accession collections.