: 2024-11-06
Data format
Field name | Description | Example |
---|---|---|
dataset_idint |
Id of the dataset
Mandatory |
2 |
dataset_namestring |
Name of the dataset
Mandatory |
France - Naiades |
categorystring |
Known / Presumptive / Known PFAS User
Mandatory List of values |
Known |
typestring |
Type of point (Industrial site, sampling location, etc)
List of values |
Industrial site |
sectorstring |
Only present if type is "Industrial site".
List of values |
Weaving of textiles |
source_textstring |
Source of the data
Mandatory |
Minsitry of Health - Germany |
source_urlstring |
Url where the data can be found, or of the source of the data | https://naiades.eaufrance.fr/ |
source_typestring |
Type of data source (Authorities, Scientific Paper, etc)
Mandatory List of values |
Authorities |
data_collection_methodstring |
How the data was obtained
List of values |
Public data - API |
namestring |
Name of the point | Spree in Berlin |
latfloat |
GPS Lattitude. For some points we only have the city. | 52.52046 |
lonfloat |
GPS Longitude. For some points we only have the city. | 13.37644 |
citystring |
City. Taken from the source data if present, otherwise inferred from the lat/lon
Mandatory |
Berlin |
countrystring |
Country. Taken from the source data if present, otherwise inferred from the lat/lon. Empty only for points in the open sea.
List of values |
Germany |
datedate |
Sampling date. Only present for Known points
Only for known points |
2023-08-27 |
yearint |
Sampling year. Only present for Known points
Only for known points |
2023 |
matrixstring |
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'
Only for known points List of values |
Surface water |
unitstring |
unit of the value. Depends mostly on the matrix. Units are converted to p"arts per billion" (eg. ng/L or ng/kg)
Only for known points List of values |
ng/L |
pfas_sumfloat |
sum of all concentrations of PFAS substances. Only values above LOD/LOQ are considered (see pfas_value table)
Only for known points |
1.34 |
pfas_valuesjson |
json array of pfas_value objects (see next tab)
Only for known points |
see below |
detailsjson |
json field containing extra info from the original data. |
|
Format of pfas_values
The field pfas_values
is a JSON array, allowing to have as many individual PFAS concentrations as needed.
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"
}
]