Northeastern Section - 54th Annual Meeting - 2019

Paper No. 17-4
Presentation Time: 1:30 PM-5:30 PM


MULLER, Otto H., Geology, Alfred University, 1 Saxon Drive, Alfred, NY 14802 and NAGEL-MYERS, Judith, Geology, St. Lawrence University, 23 Romoda Drive, Canton, NY 13617

The New York State Geological Association (NYSGA) has made their field trip guidebooks available online. We have developed four tools to manage this data trove. A guidebook has 5 to 20 field trips and often has hundreds of Stops and Views. We have digitized trips from 1956-2003 including over 8000 localities.

We constructed Google Earth’s kml files showing each trip's path complete with road log descriptions. This data is now available in a database and accessible via several different tools:

  1. Google Fusion Tables: Users who wish to display a subset of the data as a map on a web page can embed a filtered Fusion Table version of the database with a simple copy and paste from the Fusion Table site.
  2. Desktop FileMaker Database: Users owning FileMaker (Mac or Windows) can download the database. Mac users who do not own FileMaker can download a stand-alone application permitting them to manipulate the database. Complex searches limiting results by combinations of geospatial extent, date, author, content, etc., are easily done with this desktop application
  3. IOS FileMaker Database: Users with an iPhone or iPad can use the free app FileMaker Go to access the database. Although not quite as powerful as the desktop version, the search capabilities are still impressive. It permits exporting as csv or kml files, which can be imported into Avenza Maps, PocketEarth, Google Earth or similar apps, all on the same device.
  4. Excel Tables: We provide an Excel version of the database which lets users employ the filters in Excel Tables to limit their search by subject or geospatial extent. Inserting the data exported from Excel into the provided Word document converts the results into a kml file.

These tools provide the user with the opportunity to filter the large amount of data contained in the database by individual trips, geographic area, or the occurrence of a particular mineral or fossil in the locality descriptions. The search result can subsequently be downloaded or can be used to download the pdf file from that trip. These files contain much more information than the Road Log descriptions, including maps, graphs, data tables and explanations of why the stops are important, how they relate to each other, etc.

  • Instructions for Numbers users.pdf (673.6 kB)
  • Instructions for Excel users.pdf (3.8 MB)
  • NEGSA Poster 2019.pdf (3.1 MB)