Data format

Field name	Description	Example
dataset_id int	Id of the dataset Mandatory	2
dataset_name string	Name of the dataset Mandatory	France - Naiades
category string	Known / Presumptive / Known PFAS User Mandatory List of values	Known
type string	Type of point (Industrial site, sampling location, etc) List of values	Industrial site
sector string	Only present if type is "Industrial site". List of values	Weaving of textiles
source_text string	Source of the data Mandatory	Minsitry of Health - Germany
source_url string	Url where the data can be found, or of the source of the data	https://naiades.eaufrance.fr/
source_type string	Type of data source (Authorities, Scientific Paper, etc) Mandatory List of values	Authorities
data_collection_method string	How the data was obtained List of values	Public data - API
name string	Name of the point	Spree in Berlin
lat float	GPS Lattitude. For some points we only have the city.	52.52046
lon float	GPS Longitude. For some points we only have the city.	13.37644
city string	City. Taken from the source data if present, otherwise inferred from the lat/lon Mandatory	Berlin
country string	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
date date	Sampling date. Only present for Known points Only for known points	2023-08-27
year int	Sampling year. Only present for Known points Only for known points	2023
matrix string	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
unit string	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_sum float	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_values json	json array of pfas_value objects (see next tab) Only for known points	see below
details json	json field containing extra info from the original data.	{ "code_station":"06216X0173/P1", "altitude":236.0 }

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