Data

The complete dataset is available:

• as a csv,
• as a parquet.

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	{ "code_station": "06216X0173/P1", "altitude": 236.0 }

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"
  }
]