Data
The complete dataset is available:
Data Format
Field name | Description | Example |
---|---|---|
dataset_id |
Id of the dataset
int
Mandatory |
2 |
dataset_name |
Name of the dataset
string
Mandatory |
France - Naiades |
category |
Known / Presumptive / Known PFAS User
string
Mandatory List of values |
Known |
type |
Type of point (Industrial site, sampling location, etc)
string
List of values |
Industrial site |
sector |
Only present if type is "Industrial site".
string
List of values |
Weaving of textiles |
source_text |
Source of the data
string
Mandatory |
Minsitry of Health - Germany |
source_url |
Url where the data can be found, or of the source of the data
string
|
https://naiades.eaufrance.fr/ |
source_type |
Type of data source (Authorities, Scientific Paper, etc)
string
Mandatory List of values |
Authorities |
name |
Name of the point
string
|
Spree in Berlin |
lat |
GPS Lattitude. For some points we only have the city.
float
|
52.52046 |
lon |
GPS Longitude. For some points we only have the city.
float
|
13.37644 |
city |
City. Taken from the source data if present, otherwise inferred from the lat/lon
string
Mandatory |
Berlin |
country |
Country. Taken from the source data if present, otherwise inferred from the lat/lon. Empty only for points in the open sea.
string
List of values |
Germany |
date |
Sampling date. Only present for Known points
date
Only for known points |
2023-08-27 |
year |
Sampling year. Only present for Known points
int
Only for known points |
2023 |
matrix |
Sampling matrix. Only present for Known points. If a more precise matrix was mentionned in the origianal data, it is kept in the details field in the value 'precise_matrix'
string
Only for known points List of values |
Surface water |
unit |
unit of the value. Depends mostly on the matrix. Units are converted to p"arts per billion" (eg. ng/L or ng/kg)
string
Only for known points List of values |
ng/L |
pfas_sum |
sum of all concentrations of PFAS substances. Only values above LOD/LOQ are considered (see pfas_value table)
float
Only for known points |
1.34 |
pfas_values |
json array of pfas_value objects (see next tab)
json
Only for known points |
see below |
details |
json field containing extra info from the original data.
json
|
|
Format of pfas_values
The field pfas_values
is a JSON array, allowing to have a many individual PFAS concentrations as necessary.
The json objects of the array have the following fields. These fields are never all present: value
and less than
are never together, and isomer
is present only if needed.
Field name | Type | list of values | Mandatory | Description | example value |
---|---|---|---|---|---|
cas_id | string | TRUE | FALSE | CAS ID identifying the cas substance. See: https://www.cas.org/support/documentation/chemical-substances/faqs. Always written with the dashes | 1763-23-1 |
substance | string | TRUE | FALSE | Comon name of the PFAS. Usually the first acronym in the synonym list on PubChem (pubchem.ncbi.nlm.nih.gov) for the cas_id | PFOS |
isomer | string | TRUE | FALSE | In case the data mentionned if the value is for the branched / linear isomer of the PFAS. If an isomer value is present, the sum value is also present, with the concentrations of all isomers (see example below) | |
value | float | FALSE | FALSE | measured value | 2.01 |
less_than | float | FALSE | FALSE | In case the value is below the limit of detection or below the limit of the quantification of the measurement, the value is indicated here. Rows either have a value or a less_than, but never both. | 0.6 |
unit | string | FALSE | FALSE | unit of the value. Depends mostly on the matrix. Units are converted to p"arts per billion" (eg. ng/L or ng/kg). This value is also present in the main table | ng/L |
An example of pfas_values
could be the following:
[
{
"cas_id": "1763-23-1",
"unit": "ng/l",
"substance": "PFOS",
"value": "539.0"
},
{
"cas_id": "1763-23-1",
"unit": "ng/l",
"substance": "PFOS",
"isomer": "branched",
"value": "37.0"
},
{
"cas_id": "1763-23-1",
"unit": "ng/l",
"substance": "PFOS",
"isomer": "linear",
"value": "502.0"
},
{
"cas_id": "335-67-1",
"unit": "ng/l",
"substance": "PFOA",
"less_than": "0.3"
},
{
"cas_id": "307-24-4",
"unit": "ng/l",
"substance": "PFHxA",
"value": "1340.0"
}
]