=Basic search=
[[Image:PANGAEA search 2018-07.PNG|thumb|200px|Search field on PANGAEA home]]

The most convenient and fastest way to find data is using the search engine on [http://www.pangaea.de/ PANGAEA home].
Each predefined dataset in its granularity as defined by the PI can be found by keywords and any expressions matching the data set description. Search is supported by an autocomplete functionality. Keywords can be
combined to create [https://en.wikipedia.org/wiki/Boolean_expression Boolean expressions] using a syntax identical to those used by search engines.

As a result of a query the titles of datasets are listed, linking to the full meta-description.

By prefixing keywords (using the format "prefix:keyword") with a tag name from the [[PANGAEA XML schema]] the search can be performed inside specific parts of the schema. Exceptions from that are schema parts like "attribute" and "reference" which are not searchable this way.

=Filtering of search results=

[[Image:PANGAEA search 2 2018-07.PNG|thumb|200px|Filtering of search results]]
The results of search can be filtered using facets in the left panel:
* [[Staff|Dataset Author]]
* Dataset Publication Year
* Topic
* [[Project]]
* [[Basis]]
* [[Method|Method/Device]]
* [[Campaign]] and
* Location

[[Image:PANGAEA geographical filter by 2018-07.PNG|thumb|200px|Filtering of search results]]
Additionally, the search results can be filtered by:
* Geographical coordinates and
* Date

=Advanced search=

'''Choosing search terms'''
</br>
When choosing search terms keep in mind:
* Try the obvious first. If you're looking for information on the grain size of sediment, enter "grain size" rather than "sediments"
* Use words likely to appear on a site with the information you want. "Holocene ice Lazarev" gets better results than "Holocene ice extension from the Lazarev Sea shelf".

'''Capitalization'''
</br>
PANGAEA searches are NOT case sensitive. All letters, regardless of how you type them, will be understood as lower case. For example, searches for "marine geology", "Marine Geology", and "mArInE gEoLoGy" will all return the same results.

'''Using query operators'''
</br>
PANGAEA Search uses per default the "AND" logic to combine the search terms. This means that all entered terms must be in the searched documents. To find documents that contain either one or another term (or both) concatenate by "OR". For example, enter "falconensis OR bulloides" to get all datasets that contain one of the terms.

The use of "AND" between keywords is optional. If you want to combine "AND" and "OR", use brackets - for example: "Globigerina AND (falconensis OR bulloides)".

'''Excluding searches by using "-"'''
</br>
To exclude certain keywords add a minus sign ("-") immediately before the search term you want to avoid (be sure to include a space before the minus sign).

'''Approximate searches'''
</br>
If you do not exactly know the spelling of a word, you may want to search not only for a particular keyword, but also for variants in spelling. Indicate a search for all by placing the tilde sign ("~") immediately in front of the keyword.

'''Wildcards'''
</br>
Wildcards allow a substitution of unknown characters in the item used for searching. The following table describes the wildcard characters and their attributes:

{| class="wikitable"
|-
! Wildcard !! Function !! Syntax !! Locates
|-
| ? || Specifies one alphanumeric character.|| m?ller || "müller", "miller", and "muller"
|-
| * || Specifies zero or more of any alphanumeric character. You should not use the asterisk to specify the first character of a wildcard-character string (slow search).|| corp*|| "corporate", "corporation", "corporal", and "corpulent"
|}

'''Phrase searches'''
</br>
Search for complete phrases by enclosing them in quotation marks. Words enclosed in double quotes ("like this") will appear together in all results exactly as you have entered them. Phrase searches are especially useful when searching for phrases or full names.

'''Searches in specific fields'''
</br>
[[PANGAEA XML schema]] can be used for specific queries using the PANGAEA search engine.
Search for keywords in specific fields by putting a the field name with a ':' immediately in front of the term you want to match. Exceptions from that are schema parts like "attribute" and "reference" which are not searchable this way, instead references can be searched using the reference relation type (e.g., "supplementto" or "relatedto"). Inside attributes can also be searched by using their name as field in front of the term. The most used field names are:

{| class="wikitable"
|-
! Field name !! Function
|-
| project:|| Search for keywords in [[Project|projects]]
|-
| project:label:|| Matches a project label
|-
| author:|| Search for authors of datasets or assigned references
|-
| citation:author:|| Search for authors of datasets only in the citation
|-
| pi:|| Search for datasets with Principal Investigator (PI)
|-
| citation:|| Search for keywords in the [[citation]]
|-
| relatedto:|| Search for keywords in assigned "Related to" [[Reference|references]].
|-
| supplementto:|| Search for keywords in assigned "Supplement to" [[Reference|references]].
|-
| year:|| Search for datasets or assigned references published in a specific year
|-
|citation:year:
|Search for datasets only published in a specific year
|-
| parameter:|| Search for keywords in [[parameter]] names
|-
| method:|| Search for keywords in [[method]] names
|-
| event:label:|| Search for [[event]] labels
|-
|basis:
|Search for [[basis]] eg. ship or research station
|-
|campaign:
|Search for reasearch [[Campaign|campaigns]]
|-
|topic:
|Search for [[Topic|topics]]
|-
|[https://www.pangaea.de/?q=O2ARegistryURI%3A* O2ARegistryURI:*]
|Search for datasets with a O2A Registry URI (link to registry.awi.de). This is an example of a special case for attributes and uses plain wildcard to find all datasets where the specific field is actually used.
|}

'''Query examples'''
</br>
{| class="wikitable"
|-
| marine|| Finds datasets that contain "marine".
|-
| marine geology || Finds datasets that contain both "marine" and "geology"
|-
| "marine geology"|| Placing quotation marks around any series of words turns them into a phrase and tells PANGAEA Search that you are only interested in data sets that have the words in this specific order.
|-
| marine geology -organic|| Finds datasets that contains both "marine" and "geology" but not "organic"
|-
| Globigerina AND (falconensis OR bulloides)|| Finds datasets that contain "Globigerina" and either "falconensis" or "bulloides"
|-
| ~Neogloboqadrina|| Finds datasets with "Neogloboquadrina" regardless of your spelling mistake
|-
| project:label:IMAGES|| Finds datasets that belong to project "IMAGES"
|-
| citation:author:Mackensen|| Finds datasets of author "Mackensen"
|-
| m?ller|| Finds "Müller", "Muller" or "Miller". Use this to specify characters you cannot type in with your keyboard
|-
|snow -type:series -type:bundled
|Finds datasets that contain "snow" but are no [[Publication types|collections of the publication type]] "Publication series" or "Bundled publication"
|}

'''PANGAEA Search Results'''
</br>
The results page shows a list of abbreviated dataset descriptions (thumbs) including the links to the full dataset description and links to download the dataset in either html or text format. The score gives an estimate on the relevance of the search result: a higher score means that the entered words can be found more often and closer together.

Datasets are listed with ordinal numbers and are shown in ten hits per page. Above and below the listing, one may click the page number or the NEXT (or PREV) link to see more results.



=Data warehouse=

[[Image:PANGAEA go to warehouse 2018-07.PNG|thumb|200px|Entering data warehouse]]
The '''[http://en.wikipedia.org/wiki/Data_warehouse data warehouse]''' is a tool to combine data from different PANGAEA datasets in one file. With a login the < Data warehouse > button is visible after submitting a query. The button links to a page which allows to configure geocodes and parameters for an export table. Parameters are listed in order by a score which depends on the query.

''' Example:'''
[[Image:Bulloides_1.png|thumb|200px|Data set of a planktonic foraminifera extracted with the data warehouse. Map plotted with ODV, interpolated with the ''diva'' algorithm.]]

The following example will produce a distribution map of a plankton shell in the world ocean sediments.

* go to http://www.pangaea.de
* login (or sign up for an account)
* search for ''bulloides'' (species name of a planktonic foraminifera)
* click on < Data warehouse > (a button on the upper right of the page)
* choose:
** Latitude
** Longitude
** Depth, sediment [m]
** Globigerina bulloides [%]
* < Start Data Warehouse Query >
* find a file ''bulloides.zip'' on your desktop and extract it. The file contains a list of all dataset citations in various formats (text only, RIS/Endnote, BIBTEX) and the datafile ''bulloides.tab''.
* start [[Pan2Applic]] (needs to be installed first)
* drag'n drop ''bulloides.tab'' to the empty window
* choose Convert/Ocean Data View (ODV needs to be installed first)
'''Important:''' '''''It is required to cite all datasets which are referenced in the data file and the citation list!'''''

=External services=
* '''[https://pypi.org/project/pangaeapy/ pangaeapy]''': a Python module to download and analyse metadata as well as data from tabular PANGAEA datasets
* '''[https://ropensci.github.io/pangaear/ pangaear]''': an R client to interact with the PANGAEA

Pan2Applic

2026-03-13T08:27:17Z

Pittauer: -ODV lnk

[[File:Pan2Applic_icon.png|thumb|right|Pan2Applic icon]]
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
# Google Earth
# Ocean Data View (ODV), oceanographic GIS
# ASCII/text for individual processing
# 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 [http://doi.pangaea.de/10.1594/PANGAEA.288115?format=html doi:10.1594/PANGAEA.288115]'''

[https://github.com/rsieger/Pan2Applic.git Find Sourcecode at GitHub]

Contact: Pan2Applic was developed by [[user:Rsieger|Rainer Sieger]], please contact [mailto:info@pangaea.de PANGAEA]. The software is provided as freeware under the ([http://www.gnu.org/licenses/gpl-3.0.txt 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 {{doi|10.1594/PANGAEA.288115}} 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 [http://www.microsoft.com/en-us/download/details.aspx?id=40784 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 ==

<h4>Station map</h4>
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''.

<h4>All Copepoda datasets of POLARSTERN</h4>
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)
[[File:Download_PANGAEA_datasets.png|thumb|right|Download PANGAEA datasets dialog]]
# Start Pan2Applic (File > Download PANGAEA datasets...), copy and paste the URL into the "PANGAEA Query URL" field
# Browse to your download directory
# Set the prefered encoding of data sets to be stored
# Set the extension of data sets to be stored
# Choose one or more download options (download data file, download citation, download metadata as xml)
# 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
# in a first step Pan2Applic scans all files and creates a list of environments and parameters.
# choose the environment (if there are several)
# configure the list of columns to display in the ODV import file (Select all)
# start conversion by clicking the OK button

<h4>Data from different environments vs. age</h4>
# 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.'' {{doi|10.1594/PANGAEA.700818}} and ''Meyer, H et al. (2006): Stable oxygen isotopes of ice core EDML.'' {{doi|10.1594/PANGAEA.552270}}
# drag the two files onto the program window
# choose ''Convert->Text (unformated)''
# select ''Age [ka BP]'' in the environment dialog
# select ''AGE [ka BP], Cibicidoides wuellerstorfi, d18O [per mil PDB]'', and ''delta 18O, water [per mil SMOW]'' in the parameter dialog

<h4>Create a shapefile</h4>
# download Petschick, R et al. (1996): Grain size distribution of surface sediments of the South Atlantic. {{doi|10.1594/PANGAEA.51464}}
# drag the file onto the program window
# choose ''Convert->Shapefile''
# Select metadata, geocodes, and parameters

== Links ==

* [https://doi.pangaea.de/10.1594/PANGAEA.288115?format=html Pan2Applic]
* [[PanGet]]
* [http://odv.awi.de Ocean Data View]
* [http://earth.google.com Google Earth]
* [http://www.awi.de AWI]