When you connect to the NBII Metadata Clearinghouse you will be able to search through metadata-based descriptions of biological data sets and information products from many different sources to identify those that meet your particular search criteria.
The NBII Metadata Clearinghouse: http://metadata.nbii.gov/
The NBII Home Page: http://www.nbii.gov/
Powered by Mercury
None
1) Imported CSV formatted files into Microsoft Excel. Concatenated multiple Deteminations files from David and LinnAnn together in one worksheet. Did same for Collections CSV files. Ensured no duplicate records. Resulting files: All_Determinations_thruMarch17th_byPJN.xls, All_Collections_thruMarch17th_byPJN.xls
2) For Sites table, added Burgess Falls state park coordinate from David Hill, also corrected Pinson Mounds and Montgomery Bell coordinates via Bill Avant. Also fixed some Determinations and Collections records that were incorrectly using the Big Ridge code instead of the Burgess Falls code (because none was available in the Sites table earlier.)
3) Converted Excel tables to DBF format and imported into ArcMap.
4) In ArcMap, Joined Determinations table to Collections table on COLLECTION_ID, then Joined Sites table on SITE_CODE, then Joined Park table on PARKCODE. (Species names were already in Determinations table, so did not need to join previous Species table given in February 1, 2006.)
5) Used ArcCatalog to create New Personal Geodatabase. In ArcMap, used Display X,Y function to convert new large joined table to feature class in the new Geodatabase.
6) Because field names were truncated by DBF conversion, used Microsoft Access to rename all the fields to match the TN State Parks ATBI database design diagram field names. Saved a copy, then dropped all duplicate and unnecessary Id fields.
7) Added new feature class to ArcMap and overlayed bio data with 5 of the previously created state park boundaries. Verified points fell within these boundaries (only for these 5 -- did not have boundaries for Henry Horton, Cedars of Lebanon, or Big Ridge easily available).
-83.9304139, 36.2422500
using Modify Feature - Move To option in ArcMap.