Parameter



The parameter table contains all parameters with unit and ID, grouped by categories (ParamGroup, see also discussion page). When defining new parameters, the following points should be kept in mind:
 * 1) First check for existing parameters by using the 4D-client or the Parameter Dictionary.
 * 2) Avoid duplicate definitions of parameters at any time! If the parameter already exists with a unit different from the one needed and the data can easily be converted, a new parameter should NOT be defined and the data must be converted prior to or during import. (It is one of the major challanges of Pangaea, that it delivers data in a consistent format, which also means it uses standard units as far as defined in science.)
 * 3) Do not define parameters with user specific 'qualifiers', e.g. in species names something like Thalassiosira sp. F. In this case the data should be linked to the parameter Thalassiosira sp. and the data series comment should contain sp. F (see also import; for the use of abbreviations in taxonomic names see Taxon).
 * 4) Do not define parameters containing two different individuals, e.g. Convallina logani/dawsoni. Instead use Convallina logani and add to the data series comment including Convallina dawsoni. Do not define any mixed parameters accordingly.
 * 5) Clearly separate parameters from methods or any other specifications. Methods are defined in the method table; the relation between a data series and the method or data specific comments is set during the import.
 * 6) New parameters are defined by the data librarian. Please use the parameter import form for new definitions and send it in excel or text/zipped format to [mailto:hgrobe@pangaea.de Hannes Grobe].
 * 7) Prior to changes in the fields of a parameter definition, in particular geocodes, inform [mailto:uschindler@pangaea.de Uwe Schindler] & [mailto:hgrobe@pangaea.de Hannes Grobe].

Below find a description of the fields in the parameter table; hints on how to fill out the columns in the import form are given in italic, mandatory fields are underlined, in import files delete unused columns.

Field description of the parameter table Names in the header line used in the parameter import form are added in (brackets).
 * Name (ParameterName) contains the full name of the parameter. ParameterName in combination with the unit must be unique in Pangaea.
 * Abbreviation (Abbreviation) or short name of the parameter; is used in the header of data sets.
 * Unit (Unit) should follow standard use i.a. Already existing parameter should only be defined with an other unit if the values can not be converted from one to an other. Delete column for text-parameters in import form or leave empty.
 * Parameter group (ParameterGroupID) is used for a better overview and grouping of parameters. Before defining a new parameter, ensure, that the required parameter group already exists; relational to the Parameter groups table. For import use the ID of the parameter group.
 * Data group (DataGroup) Primary data are raw data, e.g. counts of microfossils are weight of samples. Secondary data are those calclulated from the raw data and are the most commonly used, e.g. concentrations in % or ppm. Tertiary data are mostly calculated data on a higher level of scientific interpretation, e.g. paleotemperatures. For technical parameters, the group not classified can be used.
 * Range min/max (LowerLimit/UpperLimit) can be used to define the numeric range of values in which a certain parameter will occur. An internal routine will check during the import of data for outliers and will flag them as not valid. Delete columns for text-parameters in import form or leave empty.
 * Default format (DefaultFormat) some predefined formats are offert by a menue but can be eddited by hand. The format should follow the general precision and will be used by the system as the default. Format can be changed during (or after) the import of data on the config card.
 * Default data type (DefaultDataType) of a parameter can be numeric (1), text (2) or datetime (3, only used for 1599 DATE/TIME). If a text parameter is defined, no unit, format and min/max values should be given. A field of a text parameter may contain up to 255 characters.
 * Default method (DefaultMethodID) is a relational field to the Method table where a required method has to be defined first. Methods defined in this field are shown during import of data by default. The default can be changed during the import procedure. Use the ID of the method for import.
 * Reference (ReferenceID) can be given in case a parameter was defined through a publication; relational to Reference. Use the ID of the referenceI for import.
 * URL may contain a link to a more detailed explanation/definition of the parameter, e.g. in Wikipedia. This definition should be of general use. Field not included in the parameter import form.
 * Comment (Description) may be used for any descriptions, helpfull to other curators to understand its meaning. This is an internal info field, its content does not appear in datasets!
 * Keywords may be used to define a certain parameter group for special purpose, projects or users. Keyword-related parameter lists can be produced using the DDI tool to set up a dynamic link; relational to the Thesaurus. Field not included in the parameter import form. Keywords need to be added by hand for each parameter.

Find missing parameter in an import file with PanTool
 * 1) Create ParameterDB.pdb through a download of all parameter from Parameter Dictionary
 * 2) prepare import file with parameter names and unit in header line, format e.g. Olivine [%]
 * 3) open import file with PanTool,
 * 4) choose default location of parameter database (from 1) at File > Options,
 * 5) choose special tools > create parameter import file,
 * 6) find unknown parameter prepared in a preformatted import file at ...
 * 7) parameter import table needs some further editing, see field descriptions above

Check taxonomic parameters in the pangaea parameter list
 * 1) A script (by Robert Huber) matching the pangaea parameter list with the species catalog of UBIO