Images file
Updated: 28-11-2023Fields
Below is given a list of fields that must be in the images table. Each row represents one image. An example file can be found below.
source refers to the supplier of the data. Fields in square brackets ([]) are optional
image_url
The public url or relative path of an image file.
Values
| Value | Description | Example |
|---|---|---|
url |
A unique, valid, publicly accessible and preferably persistant URL to the image. | https://waarneming.nl/media/photo/027/097/27097651.jpg |
path |
If the image files are not downloadable and delivered on an external hard drive, please provide the path relative to the data directory where the subdirectories for the different species are stored , instead of just the filename of the image. | /image_dataset/Aegopodium podagraria/image_001.jpg |
The prefered method of providing images is url.
observation_id
Identifies an observation record (specimen), links images belonging to one record.
Values
| Value | Description | Example |
|---|---|---|
Qualified ID |
A qualified ID as described here. | WRN:192541141 |
image_id
Uniquely identifies an image.
Values
| Value | Description | Example |
|---|---|---|
Qualified ID |
A qualified ID as described here. | WRN:27097651 |
taxon_id_at_source
Taxon id as given in the source system.
Values
| Value | Description | Example |
|---|---|---|
Qualified ID |
A qualified ID as described here. | WRN:7099 |
taxon_full_name
The full taxon name (including infraspecific_epithet, if present).
Values
| Value | Description | Example |
|---|---|---|
scientific name |
(Latin) scientific name which must also be present in the column taxon_full_name of the taxa table. Please do not put common species names here. | Nymphaea Alba |
[sex]
Sex of the specimen in the observation
Values
| Value | Description | Example |
|---|---|---|
sex |
Optional sex of the specimen in the observation. | male, female |
Please make sure the values across this column are consistent (language, spelling, etc.). We will not check against a controlled vocabulary.
[morph]
Appearance of the specimen in the image. Information about the specimen’s appearance on the image helps us in the selection process of which images are used for model training. For different source systems, it can vary which information is gathered for the appearance of a specimen, often dependent on the species group.
| Value | Description | Example |
|---|---|---|
morph |
Description | adult, imago, second summer, winter plumage |
Please make sure the values across this column are consistent (language, spelling, etc.). We will not check against a controlled vocabulary.
[morph_id]
If the source system has identifiers for different appearances, please provide them in this column.
| Value | Description | Example |
|---|---|---|
Qualified ID |
A qualified ID as described here. | WRN:36 |
[location_latitude]
Latitude of the location of the observation in decimal degrees using the WGS84 coordinate system.
| Value | Description | Example |
|---|---|---|
latitude |
Latitude part of the WGS84 coordinate system in decimal degrees. | 50.523097 |
Please use a decimal point instead of a comma
If not empty, also location_longitude must be supplied
[location_longitude]
Longitude of the location of the observation in decimal degrees using the WGS84 coordinate system.
| Value | Description | Example |
|---|---|---|
longitude |
Longitude part of the WGS84 coordinate system in decimal degrees. | 3.70281234 |
Please use a decimal point instead of a comma
If not empty, also location_latitude must be supplied
[date]
Date of the observation
Values
| Value | Description | Example |
|---|---|---|
date |
Date string in the format YYYY-MM-DD | 2023-11-28 |
[time]
Time of the observation
Values
| Value | Description | Example |
|---|---|---|
date |
Time string in the 24h format HH:MM | 18:36 |
If not empty, also date must be provided