Location: Subtropical Horticulture Research
Project Number: 6038-21000-022-04
Start Date: Jun 04, 2013
End Date: Sep 30, 2016
(1) FIU personnel will evaluate existing workflows and data collection procedures. In order to develop appropriate method to gather location information FIU personnel will visit the USDA SHRS and accompany a trained person from USDA during data acquisition. Based on procedures, plant distribution and density FIU personnel will make recommendations on location attribute collection. (2) FIU personnel 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) FIU personnel 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. FIU personnel will work in close collaboration with USDA Scientists and Systems Administrators to guarantee compliance with software standards and limitations of the agency. (4) FIU personnel 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) FIU personnel will develop map templates that are most useful for data collection planning assistance and mapping of attribute data. For this task FIU personnel 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) FIU personnel 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 FIU personnel will provide consultation services, additional training and advising in continuation of accession collections.