[Introduction] [Instructions] [Search form] [Database format]
Database format
Instructions
When selecting the option Field delimited, the search result is returned as an only weakly formatted html-file, which can easily be modified for database import. There is no max limit of how many records that may be returned, so be careful when specifying the search criteria. It may be a good idea to test the search criteria by using the Specimens examined style first, which pauses after 100 records are returned.
Each record makes up a line, ending in the tilde (~ - ascii 126) + html hard return tag + CR/LF. The field delimiter is the vertical bar (| - ascii 124).
A few steps are needed for making the file ready for import:
1) Remove the html codes and general information in the head and tail.
2) Substitute the end-of-record character (~) and the html hard return tag at
the end of each line with the one(s) used for import by your database (often none).
3) Substitute the field delimiter character (|) with the one(s) used for import
by your database (e.g. ",").
4) Substitute the html codes for the extended ascii characters with the characters
used by your system.
Before doing point 2 and 3, above, make sure that the character sequences you wish to use do not occur in the file.
The fields
Type of field:
|
Nr |
Contents (type of field) |
| 01 | Accession number in the indicated herbarium (N6) |
| 02 | Uncertain determination code (A1): A = aff., C = cfr |
| 03 | Genus (Memo) |
| 04 | Specific epithet (Memo) |
| 05 | Infraspecific rank (A1): S = ssp., V = var. |
| 06 | Infraspecific epithet (Memo). Abbreviated at the 12th character with a full stop at position 13, if neccessary |
| 07 | [Norwegian redlist status (A2) - no longer in use, but this position may be used for country in a future version] |
| 08 | County (A24) |
| 09 | Municipality (A25) |
| 10 | Locality and ecology (Memo) |
| 11 | UTM - first letter set (A2) |
| 12 | UTM - second letter set (A2) |
| 13 | UTM - first E/W-number (A4) |
| 14 | UTM - second E/W-number (A4) |
| 15 | UTM - first N/S-number (A4) |
| 16 | UTM - second N/S-number (A4) |
| 17 | Map (A8) - M711-series |
| 18 | Source of UTM data (A1): E = Collectors own specification (or taken from label), B = UTM found by others than collector |
| 19 | Map datum (A1): E = European Datum 1950, W = World Geodetic Standard 1984 |
| 20 | Uncertainty in UTM data (A1): C = ca. |
| 21 | Latitude, degree (N2) [not in use in the mycological database] |
| 22 | Latitude, minute (N2) [not in use in the mycological database] |
| 23 | Hemisphere (A1): N = North, S = South [not in use in the mycological database] |
| 24 | Longitude, degree (N3) [not in use in the mycological database] |
| 25 | Longitude, minute (N2) [not in use in the mycological database] |
| 26 | Hemisphere (A1): E = East, W = West [not in use in the mycological database] |
| 27 | Source for lat./long. data (A1) [not in use in the mycological database] |
| 28 | Map datum (A1) [not in use in the mycological database] |
| 29 | Uncertainty in lat./long. data (A1) [not in use in the mycological database] |
| 30 | Altitude-1 (N5): First (if interval) or only (if precise) altitude |
| 31 | Altitude-2 (N5): Second (if interval) altitude |
| 32 | Meter (A1): M = Meter |
| 33 | Source for altitude data: E = Collectors own specification (or taken from label) |
| 34 | Uncertainty in altitude data (A1): C = ca. |
| 35 | Host (Memo) |
| 36 | Year of collection (N4) |
| 37 | Date of collection (N2.2): MM.DD |
| 38 | Collector(s) (Memo) |
| 39 | Collection number (Memo) |
| 40 | Type of revision (A1): C = Conf., D = Det. |
| 41 | Revisioner (Memo) |
| 42 | Year of revision (A4) |
| 43 | Computerization status in O (A1): Not yet in use |
| 44 | Herbarium (Memo) |
| 45 | Date of latest edit (A10) |
| 46 | Comments (Memo) |
Updated 29.03.2005