Table 1. Columns labels in CSV output, with their AVH counterparts. Click on column headers to re-order the columns. For a more detailed explanation of the AVH fields, click on the symbol next to the field name.

Column order Column name Description (blank where self-explanatory) AVH field name
01 Record ID The ALA identifier for the record. ALA record ID
02 Catalog Number The catalogue number for this record. Catalogue number
03 Match Taxon Concept GUID The GUID for the concept in the National Species List (NSL). N/A
04 Scientific Name The taxon name provided with the specimen record. Taxon name (provided)
05 Vernacular Name The common name provided with the specimen record. Common names are not provided with AVH data, but are provided with some ALA records from other data sets. N/A
06 Matched Scientific Name The taxon name in the NSL that the ALA has matched this record to. Taxon name (processed)
07 Taxon Rank – matched The taxon rank in the NSL that the ALA has matched this record to. Taxon rank (matched)
08 Vernacular Name – matched The common name in the NSL that the ALA has matched this record to. Common name
09 Kingdom – matched The kingdom in the NSL that the ALA has matched this record to. Kingdom
10 Phylum – matched The phylum in the NSL that the ALA has matched this record to. Phylum
11 Class – matched The class in the NSL that the ALA has matched this record to. Class
12 Order – matched The order in the NSL that the ALA has matched this record to. Order
13 Family – matched The family in the NSL that the ALA has matched this record to. Family
14 Genus – matched The genus in the NSL that the ALA has matched this record to. Genus
15 Species – matched The species name in the NSL that the ALA has matched this record to. Species
16 Subspecies – matched The infraspecific epithet in the NSL that the ALA has matched this record to. Infraspecific taxon
17 Institution Code The institution code for this record. The institution code refers to the department or organisation to which the herbarium belongs. Herbarium code
18 Collection Code The Index Herbariorum code for the herbarium where the specimen is held. Herbarium code
19 Latitude before processing The decimal latitude before processing. This will be populated when the user has permission to view the original value. Latitude (provided)
20 decimalLongitude The decimal longitude before processing. This will be populated when the user has permission to view the original value. Longitude (provided)
21 Latitude – processed The decimal latitude associated with the record. If the original latitude was supplied in degrees, minutes and seconds, this value representsthe converted value. Latitude
22 Longitude – processed The decimal longitude associated with the record. If the original latitude was supplied in degrees, minutes and seconds, this value representsthe converted value. Longitude
23 Coordinate Precision The precision of the geocode. Geocode precision is not delivered with any herbarium records, but is available in some records in other ALA datasets. N/A
24 Coordinate Uncertainty In Meters A measurement or estimate of how far away in metres the point represented by the latitude and longitude may be from the actual location where the specimen was collected. Geocode uncertainty (m)
25 Country – parsed The country in which the specimen was collected. Country
26 IBRA Region – parsed The IBRA region matching the supplied coordinates. IBRA region
27 IMCRA Region – parsed The IMCRA region matching the supplied coordinates. IMCRA region
28 State – parsed The state or territory matching the supplied coordinates. State or territory
29 Local Government Area – parsed The local government area matching the supplied coordinates. Local government area
30 Minimum Elevation In Metres The minimum altitude in metres for the collecting locality. Minimum altitude (m)
31 Maximum Elevation In Metres The maximum altitude in metres for the collecting locality. Maximum altitude (m)
32 Minimum Depth In Meters The minimum depth in metres for the collecting locality. Minimum depth (m)
33 Maximum Depth In Meters The maximum depth in metres for the collecting locality. Maximum depth (m)
34 Year – parsed The year in which the specimen was collected. Year
35 Month – parsed The month in which the specimen was collected. Month
36 Day – parsed The day of the month in which the specimen was collected. Day
37 Event Date – parsed The date the specimen was collected, in ISO-compliant form. Collecting date
38 Event Time – parsed The time of the observation of collecting event. Event time is not generally recorded for herbarium specimens, and is not delivered to the ALA by the herbaria. N/A
39 Basis Of Record The basis of record e.g. Specimen, Observation etc. Basis of record
40 Sex The sex of the species for the occurrence. Sex is not delivered to the ALA. We draw the line at beer and cake. N/A
41 Preparations A list (concatenated and separated) of preparations and preservation methods for a specimen. Preparations
42 Information withheld during processing Indicates if information withheld due to sensitivity issues. Information withheld
43 Data Generalised during processing Describes the data generalisation performed in the case of sensitive records. Data generalised
44 Species habitats The ecoregion (non-marine, marine, or limnetic) in which the taxon occurs. Ecoregion
45 Outlier for layer Environmental layer for which record is an outlier, or for which there are records in the result set that are outliers. Outlier for layer
46 Taxon identification issue The record has been provided with a Determination qualifier, indicating that there was uncertainty about the determination. Determination qualifier
47 Location Quality An assessment of whether or not the location is spatially valid, based on a range of data quality checks and user-contributed annotations. Spatial validity
48 recordNumber Collecting number, a number provided by the Collector of the specimen Collecting number
49 cultivated Whether or not the specimen was cultivated at the collecting locality. Establishment means
50 duplicates A list of herbaria that duplicate specimens have been sent to. Duplicates sent to
51 duplicatesOriginalInstitutionID The herbarium from which a duplicate specimen was received. Herbarium received from
52 duplicatesOriginalUnitID The catalogue number for the original specimen at the herbarium from which the duplicate was received. Ex herb. catalogue number
53 loanIdentifier The number assigned to a loan by the lending herbarium. Loan number
54 loanDestination The herbarium to which the specimen was sent on loan. Borrowing institution
55 phenology Whether the specimen is bearing flowers, fruit etc. Phenology
56 scientificNameWithoutAuthor The provided taxon name without the authorship. Taxon name (provided) [without the author of the name]
57 identifierRole The role the determiner has played in the determination, e.g. determined the specimen (‘Det.’) or confirmed an earlier determination (‘Conf.’). Determiner role
58 identifiedBy The person or persons that determined the specimen Determiner
59 dateIdentified The date the specimen was determined. Determination date
60 identificationRemarks Notes about the specimen by the determiner as part of the determination. Determination notes
61 verbatimDateIdentified The determination date, as provided by the herbaria. Verbatim determination date
62 geodeticDatum The geodetic datum, or reference, use for the georeference. Geodetic datum
63 nameMatchMetric The method by which the name was matched. Name match metric
64 recordedBy The name of the person(s) who made the observation. For specimen records this is the collector. Collector
65 verbatimEventDate The date the observation was made, as provided by the observer (or by the data provider). For specimen-based records this is the collectingdate. Collecting date
66 locality The locality where the observation was made or the specimen collected. Locality
67 habitat A description of the habitat that the plant, alga or fungus was growing in, provided by the collector. Habitat
68 occurrenceRemarks Any additional notes about the specimen or the collecting event provided by the collector. Collecting notes
69 stateConservation The conservation status associated with the taxon in the state or territory in which it was collected. Conservation status
70 georeferenceProtocol The method by which the georeference was obtained, for example by GPS or by using a topographic map. Georeferencing method
71 georeferencedBy A general term for the person who provided the georeference (‘Collector’ or ‘Compiler’). Georeferenced by
72+ Issue flags Potential issues found during quality checks when the record was uploaded into the BioCache or during post-processing,or that have been reported by users. There is a separate column for each issue that occurs in the result set, with a value of ‘true’ or ‘false’. Data issues

Leave a Reply

Your email address will not be published. Required fields are marked *