Pan2Applic

The software Pan2Applic is a tool to convert files or folders of files (ascii/tab-separated data files with or without metaheader), downloaded from PANGAEA via the search engine or the data warehouse to formats as used by applications, e.g. for visualization or further processing. It may also be used to convert files or zip-archives as downloaded from CD-ROM data collections, published in the WDC-MARE Reports series.

Export formats supported by Pan2Applic are
 * 1) Google Earth
 * 2) Ocean Data View (ODV), oceanographic GIS
 * 3) ASCII/text for individual processing
 * 4) Shapefile, format as used by GIS applications

Further export formats may be added on request.

Pan2Applic output formats 1-3 are tab-delimited text-files with the extension *.txt. The DOI as a reference to the source of the data will be included in the output dataset. The user is requested to quote all references related to the original data when publishing new products resulting from a PANGAEA or CD download and processing with Pan2Applic. PANGAEA export files and Pan2Applic processed files can be opened by any editor or spreadsheet software.

Find the current version and reference of Pan2Applic at doi:10.1594/PANGAEA.288115

Find Sourcecode at GitHub

Contact: Pan2Applic was developed by Rainer Sieger, please contact [mailto:info@pangaea.de PANGAEA]. The software is provided as freeware under the (GNU General Public License (GPLv3) and is freely distributed without warranty by the Alfred Wegener Institute, Helmholtz Center for Polar and Marine Research, Bremerhaven.

Installation
Open and click on "View dataset as HTML". Download the current version of Pan2Applic to your computer.

Windows
Double-click Pan2Applic_Win.exe and follow the instructions. If the MSVCR120.dll is missing on your computer, you have to install the Visual C++ Redistributable Packages for Visual Studio 2013 from Microsoft.

OS X
Open the downloaded dmg file with a double-click. Drag and drop the file Pan2Applic.app onto the appliction folder icon.

Linux
Uncompress the archive to your user bin directory. Double-click Pan2Applic.sh.

Examples
Station map Open https://pangaea.de/expeditions/cr.php/Polarstern and download the station list of cruise ARK-IX/4. The downloaded file can be open with an editor or with a spreadsheet program like Excel. Drag the file onto the Pan2Applic window and choose Convert->Google Earth.

All Copepoda datasets of POLARSTERN Retrieve datasets with the PANGAEA Search engine. In this example we create a query to all Copepoda datasets of POLARSTERN published in 2017: Type in "polarstern copepoda". Return. Choose "Dataset Publication Year" = 2017 (https://www.pangaea.de/?q=Polarstern+Copepoda&f.pubyear%5B%5D=2017)
 * 1) Start Pan2Applic (File > Download PANGAEA datasets...), copy and paste the URL into the "PANGAEA Query URL" field
 * 2) Browse to your download directory
 * 3) Set the prefered encoding of data sets to be stored
 * 4) Set the extension of data sets to be stored
 * 5) Choose one or more download options (download data file, download citation, download metadata as xml)
 * 6) Click Go. PanGet downloads all data sets sequentialy, progress is shown. The download time depends on the number and size of the data sets.

Choose Options->Ocean Data View and set the options you want. With "Convert->Ocean Data View" the program will create an ODV import file
 * 1) in a first step Pan2Applic scans all files and creates a list of environments and parameters.
 * 2) choose the environment (if there are several)
 * 3) configure the list of columns to display in the ODV import file (Select all)
 * 4) start conversion by clicking the OK button

Data from different environments vs. age
 * 1) download McManus, JF et al. (1999): Stable carbon and oxygen isotope ratios of Cibicidoides wuellerstorfi in the 340 to 0 kyr section of ODP Site 162-980 in the subpolar North Atlantic.  and Meyer, H et al. (2006): Stable oxygen isotopes of ice core EDML.
 * 2) drag the two files onto the program window
 * 3) choose Convert->Text (unformated)
 * 4) select Age [ka BP] in the environment dialog
 * 5) select AGE [ka BP], Cibicidoides wuellerstorfi, d18O [per mil PDB], and delta 18O, water [per mil SMOW] in the parameter dialog

Create a shapefile
 * 1) download Petschick, R et al. (1996): Grain size distribution of surface sediments of the South Atlantic.
 * 2) drag the file onto the program window
 * 3) choose Convert->Shapefile
 * 4) Select metadata, geocodes, and parameters

Links

 * Pan2Applic
 * PanGet
 * Ocean Data View
 * Google Earth
 * AWI