1 / 38

Using The IRRItoGRIN Form

Using The IRRItoGRIN Form. Esther Peregrine USDA-ARS Urbana, IL. Some GRIN source records have been changed after IRRI received the data. GRIN tables were downloaded 1/27/10. The IRRI Data. What is it? How should it be used?. IRRI data - What is it?. SRCNO COUNTRY ADM_1. Misc

holli
Download Presentation

Using The IRRItoGRIN Form

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using The IRRItoGRIN Form Esther Peregrine USDA-ARS Urbana, IL

  2. Some GRIN source records have been changed after IRRI received the data • GRIN tables were downloaded 1/27/10

  3. The IRRI Data • What is it? • How should it be used?

  4. IRRI data - What is it? • SRCNO • COUNTRY • ADM_1 • Misc • georefsource • georefremarks • georefperson • georefdata • adm1_georef_use • adm2_georef_use • loc_georef_use1 • error • Locality • Latitude • Longitude • Uncertainty • Elevation • ADM_type1 • ADM_2 • ADM_type2 • Type_of_collection_site • NameOfCompany • NameOfPerson

  5. IRRI Data – How is it used by the form? • PREPSRC • country and state (ADM_1) • PREPHAB • country, state (Adm1), latitude, longitude, uncertainty, locality • PREPAACT • narrative of old vs new fields plus all of the IRRI fields separated by “##” • event • “PASS_FIX” or “PASS_OK” (src) • “LATLON_ADD”, “LATLON_FIX”, or “LATLON_OK” (hab)

  6. If Prep tables are not in the database, buttons for linking or importing will be visible • Can’t use other forms until PREPSRC, PREPHAB, and PREPAACT are present • If prep tables are present, buttons for exporting them will be enabled

  7. Prep tables can be linked directly to GRIN via ODBC • The form will show updates • Don’t need to upload anything into GRIN • Performance may be slower • Requires iclient

  8. Download Instant Client on GRIN tools menu and follow the instructions for ODBC connectivity

  9. Need to Select Unique Record Identifiers when linking to GRIN

  10. Prep tables can be imported from GRIN via ODBC • Performance may be faster • The form will not show updates • Requires iclient • Need to upload table into GRIN

  11. Prep tables can be imported as dbf files to the database • Performance may be faster • Doesn’t require iclient • The form will not show updates • Need to upload the tables to GRIN

  12. The button to open the Main form will be visible if prepsrc, prephab, prepaact are present

  13. Main Form toUSDA src & geo hab acc prepsrc prephab prepaact

  14. Main Form Select Site, Genus and/or Taxon to display only pertinent records

  15. Main Form Click to reset and show all records

  16. Main Form

  17. Main Form

  18. Google map button is visible with GRIN Habitat data if there is any Lat/Lon data

  19. Add Country and ADM_1 to PREPSRC • Add a prepaact action • “PASS_FIX” or “PASS_OK” • a narr of changes and all IRRI fields

  20. PREPAACT NARR For a Source Change Updated ##Country: Mexico##State: ## to ##Country: Mexico##State: Guanajuato## based on information from USDA, ARS ARIS Project # 5348-21000-022-02-S: ## SRCNO: 32297##Country: Mexico##ADM_1: Guanajuato##ADM_type1: ##ADM_2: Salvatierra##ADM_type2: Municipality##Elevation: ##Locality: Km 25, Acambao-Salvatierra Road##Type_of_collection_site: ##NameOfCompany: ##NameOfPerson: ##Misc: ##Latitude: 20.0991421##Longitude: -100.8379697##Uncertainty: 15835##Georefsource: biogeomancer.org / IRRI##Georefremarks: between Acambaro and Salvatierra georeferenced; coordinates moved on road##Georefperson: Paule, Ma. Cristina A.##Georefdata: 2008-08-06##Adm1_georef_use: Y##Adm2_georef_use: Y##Loc_geofer_use: Y##

  21. Country Discrepancies (will cause GRIN loading error)

  22. State Discrepancies • accent marks • Córdoba Cordoba • Spelling errors • Nort Carolina North Carolina • Onatrio Ontario • Abbreviations (GRIN field 20 char) • Australian Capital Territory Austr. Capital Terr. • Not all ADM_1 are states or provinces • South California

  23. IRRI Misc Field • Sometimes filled in PI 479731 • GRIN locality: Jilin Province • IRRI ADM_1: Jilin • IRRI misc: IRRI: Had Locality ="Jilin Province"; delete locality • Sometimes blank PI 479732 • GRIN locality: Jilin Province • IRRI ADM_1: Jilin • IRRI misc:

  24. Add Latitude, Longitude, uncertainty, locality to PREPHAB • Add a prepaact action • “LATLON_ADD”, “LATLON_FIX”, or “LATLON_OK” • a narr of changes and all IRRI fields:

  25. PREPAACT NARR Updated habitat information from ##Country: Mexico##State: ##Latitude: ##Longitude: ##uncertainty: ##Locality: Km 25, Acambao-Salvatierra Road, Municipio Salvatierra, Guanajuato## to ##Country: Mexico##State: Guanajuato##Latitude: 20.0991421##Longitude: -100.8379697##uncertainty: 15835##Locality: Km 25, Acambao-Salvatierra Road## based on information from USDA, ARS ARIS Project # 5348-21000-022-02-S: ## SRCNO: 32297##Country: Mexico##ADM_1: Guanajuato##ADM_type1: ##ADM_2: Salvatierra##ADM_type2: Municipality##Elevation: ##Locality: Km 25, Acambao-Salvatierra Road##Type_of_collection_site: ##NameOfCompany: ##NameOfPerson: ##Misc: ##Latitude: 20.0991421##Longitude: -100.8379697##Uncertainty: 15835##Georefsource: biogeomancer.org / IRRI##Georefremarks: between Acambaro and Salvatierra georeferenced; coordinates moved on road##Georefperson: Paule, Ma. Cristina A.##Georefdata: 2008-08-06##Adm1_georef_use: Y##Adm2_georef_use: Y##Loc_geofer_use: Y##

  26. Elevations are text with varying units • 970 meters • 8200 ft. • near sea level. • not observed about 6800 ft. elevation or below 5000 ft. elevation • Growing between 2408 m to 2709 m elevation

  27. Elevations • Add manually to PREPHAB • Manually edit PREPAACT narrative

  28. Locality text needs to be checked PI 553013 GRIN: Black cracking clay, 15.8km W of intersection of Highway 23 on gravel road to Dalgety IRRI: 15.8 km W of intersection of Highway 23 on gravel road to Dalgety

  29. Adds a record to PREPAACTwith no EVENT or NARR filled in • May want to add an event of “ELEV_ADD”?

  30. If preptables aren’t linked, export them as dbf files to upload to GRIN

  31. Summary • Select site, genus, taxon to narrow down records or search by accession ID • Use buttons to add information to prep tables • Modify with elevations, check locality fields • Export prep tables as dbf tables and upload into GRIN • (skip this step if preptables are linked via ODBC)

  32. Summary continued • Load prep tables in GRIN • Optional for unlinked preptables • Export loaded tables from GRIN and replace the local prep tables with the GRIN tables to have a record of what has already been added. • Update Source member records in GRIN if there is enough COOP information to be useful

More Related