c0mm0.com — the continuously verified register of European data

Register record·API·FRVERIFIED · checked 2d ago
A

Water Quality Analyses - Archives 2015-2020 - Distribution NetworkAnalyses d'eau - Archives 2015-2020 - Distribution

Analyses d'eau - Archives 2015-2020 - DistributionWater Quality Analyses - Archives 2015-2020 - Distribution Network

APIExecutable4/7Query nowOpen workbenchSubscribe🇫🇷France

This API provides access to archived water quality analysis results for the drinking water distribution network in Strasbourg, covering the period 2015-2020. The data is published via the Strasbourg open data portal (data.strasbourg.eu) and links to the dedicated water analysis page maintained by the city. It is intended for users seeking historical records of water testing results in the Strasbourg area.Consulter la page dédiée aux analyses d'eau sur strasbourg.eu

environment
45
fair

Weighted across five axes. Tap a ring for what it measures.

Data schema (20 fields)

Filterable via the API (18)
psv_commpsv_nompsv_codeana_rfana_typeins_nomins_typeplv_codeplv_locaplv_motipsv_typeplv_typeplv_ty00plv_dateanneemoisjourlien_fiche

Click a field to see example values.

FillFieldTypeDescription
—geo_point_2dGeo Pointgeo_point_2dGeographic coordinates of the sampling point.Geographic coordinates of the sampling point.
—geo_shapeShapegeo_shapeGeographic shape associated with the record.Geographic shape associated with the record.
—psv_commFilterable via the APICommunetextMunicipality where the water sampling point is located.
—psv_nomFilterable via the APIRéseau/QuartiertextName of the water distribution network or neighborhood.
—psv_codeFilterable via the APIPsv codeintInternal code identifying the sampling point.Internal code identifying the sampling point.
—ana_rfFilterable via the APIRéférence laboratoiretextLaboratory reference number for the analysis.
—ana_typeFilterable via the APIAna typetextCode indicating the type of water analysis performed.Code indicating the type of water analysis performed.
—ins_nomFilterable via the APIUnité de distributiontextName of the water distribution unit (UDI).Name of the water distribution unit (UDI).
—ins_typeFilterable via the APIIns typetextType code of the distribution installation.Type code of the distribution installation.
—plv_codeFilterable via the APIPlv codetextIdentifier code for the water sample.Identifier code for the water sample.
99.9%plv_locaFilterable via the APILieu de prélèvementtextLocation where the water sample was taken.
100%plv_motiFilterable via the APIPlv motitextCode indicating the reason for the sampling.Code indicating the reason for the sampling.
100%psv_typeFilterable via the APIPsv typetextType code of the sampling point.Type code of the sampling point.
100%plv_typeFilterable via the APIPlv typetextType code of the water sample.Type code of the water sample.
100%plv_ty00Filterable via the APIType d'analysetextCode indicating the type of analysis performed.
100%plv_dateFilterable via the APIDate de prélèvementdateDate the water sample was collected.
100%anneeFilterable via the APItextYear the sample was collected.Year the sample was collected.
100%moisFilterable via the APItextMonth the sample was collected.Month the sample was collected.
100%jourFilterable via the APItextDay the sample was collected.Day the sample was collected.
100%lien_ficheFilterable via the APILien fichetextLink to the detailed analysis record sheet.Link to the detailed analysis record sheet.

Schema captured from opendatasoft 1 day ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

=

Sample data (5 records)

Record 1jour: 23 · mois: 05
{
  "jour": "23",
  "mois": "05",
  "annee": "2019",
  "ana_rf": "CAN1905-477",
  "ins_nom": "EUROMETROPOLE DE STRASBOURG",
  "psv_nom": "RESEAU STRASBOURG MEINAU",
  "ana_type": "D1",
  "ins_type": "UDI",
  "plv_code": "219008",
  "plv_date": "2019-05-23",
  "plv_loca": "EHPAD BARTISHGUT - RUE DU BARTISCH - ROBINET ÉVIER RÉFECTOIRE",
  "plv_moti": "CS",
  "plv_ty00": "D1",
  "plv_type": "T",
  "psv_code": 6251,
  "psv_comm": "STRASBOURG",
  "psv_type": "T",
  "geo_shape": "[large value omitted]",
  "lien_fiche": "https://www.sig.strasbourg.eu/datastrasbourg/analyses_eau_archives/Analyses_eau/2019/EUROMETROPOLE_STG/2019_05/D1_190523_Strasbourg_ME_CAN1905-477.pdf",
  "geo_point_2d": {
    "lat": 48.5557216085,
    "lon": 7.74702658101
  }
}
Record 2jour: 20 · mois: 11
{
  "jour": "20",
  "mois": "11",
  "annee": "2018",
  "ana_rf": "CAN1811-536",
  "ins_nom": "EUROMETROPOLE DE STRASBOURG",
  "psv_nom": "RESEAU SCHILTIGHEIM",
  "ana_type": "D1",
  "ins_type": "UDI",
  "plv_code": "214861",
  "plv_date": "2018-11-20",
  "plv_loca": "LAVABO TOILETTE VESTIAIRE",
  "plv_moti": "CS",
  "plv_ty00": "D1",
  "plv_type": "T",
  "psv_code": 5636,
  "psv_comm": "SCHILTIGHEIM",
  "psv_type": "T",
  "geo_shape": "[large value omitted]",
  "lien_fiche": "https://www.sig.strasbourg.eu/datastrasbourg/analyses_eau_archives/Analyses_eau/2018/EUROMETROPOLE_STG/2018_11/D1_181120_Schiltigheim_CAN1811-536.pdf",
  "geo_point_2d": {
    "lat": 48.6119834934,
    "lon": 7.74640550218
  }
}
Record 3jour: 11 · mois: 12
{
  "jour": "11",
  "mois": "12",
  "annee": "2018",
  "ana_rf": "CAN1812-1067",
  "ins_nom": "EUROMETROPOLE DE STRASBOURG",
  "psv_nom": "RESEAU SCHILTIGHEIM",
  "ana_type": "D1",
  "ins_type": "UDI",
  "plv_code": "215413",
  "plv_date": "2018-12-11",
  "plv_loca": "MAISON DE L'AGRICULTURE 2 RUE DE ROME ROB WC RESTAURANT",
  "plv_moti": "CS",
  "plv_ty00": "D1",
  "plv_type": "T",
  "psv_code": 5636,
  "psv_comm": "SCHILTIGHEIM",
  "psv_type": "T",
  "geo_shape": "[large value omitted]",
  "lien_fiche": "https://www.sig.strasbourg.eu/datastrasbourg/analyses_eau_archives/Analyses_eau/2018/EUROMETROPOLE_STG/2018_12/D1_181211_Schiltigheim_CAN1812-1067.pdf",
  "geo_point_2d": {
    "lat": 48.6119834934,
    "lon": 7.74640550218
  }
}
Record 4jour: 02 · mois: 12
{
  "jour": "02",
  "mois": "12",
  "annee": "2015",
  "ana_rf": "CAN1512-1104",
  "ins_nom": "EUROMETROPOLE - SECTEUR ILL ANDLAU",
  "psv_nom": "RESEAU WIBOLSHEIM",
  "ana_type": "D2MET",
  "ins_type": "UDI",
  "plv_code": "152312",
  "plv_date": "2015-12-02",
  "plv_loca": "WIBOLSHEIM - RUE DE FRIESENHEIM",
  "plv_moti": "CP",
  "plv_ty00": "D2",
  "plv_type": "T",
  "psv_code": 9311,
  "psv_comm": "ESCHAU",
  "psv_type": "T",
  "geo_shape": "[large value omitted]",
  "lien_fiche": "https://www.sig.strasbourg.eu/datastrasbourg/analyses_eau_archives/Analyses_eau/2015/EUROMETROPOLE_ILL_ANDLAU/D2_151202_Eschau_CAN1512-1104.pdf",
  "geo_point_2d": {
    "lat": 48.4834933483,
    "lon": 7.73038113418
  }
}
Record 5jour: 13 · mois: 07
{
  "jour": "13",
  "mois": "07",
  "annee": "2020",
  "ana_rf": "CAN2007-930",
  "ins_nom": "EUROMETROPOLE DE STRASBOURG",
  "psv_nom": "RESEAU ILLKIRCH-GRAFFENSTADEN",
  "ana_type": "D1",
  "ins_type": "UDI",
  "plv_code": "227923",
  "plv_date": "2020-07-13",
  "plv_loca": "Pharmacie des Cèdres Rte de Lyon salle de préparation",
  "plv_moti": "CS",
  "plv_ty00": "D1",
  "plv_type": "T",
  "psv_code": 2887,
  "psv_comm": "ILLKIRCH-GRAFFENSTADEN",
  "psv_type": "T",
  "geo_shape": "[large value omitted]",
  "lien_fiche": "https://www.sig.strasbourg.eu/datastrasbourg/analyses_eau_archives/Analyses_eau/2020/EUROMETROPOLE_STG/2020_07/D1_200713_Illkirch_CAN2007-930.pdf",
  "geo_point_2d": {
    "lat": 48.5203099947,
    "lon": 7.73143351899
  }
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL
https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/analyses_eau_archives_2015_2020

License

  • ✓ Redistributable
  • ✓ Attribution required

Query examples

curl -s 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/analyses_eau_archives_2015_2020/records?limit=20' -H 'Accept: application/json'

First 20 records of the dataset as JSON.

Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.

Full API documentation ↗

Rate limits

2 000 000 req/day
per ipmeasured
observed 1 day ago

Dataset

Volume & freshness

Records
4.3k
4312
Last upstream update
5 years ago
2021-09-13

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

Analyses d'eau - Archives 2015-2020 - Distribution — live verification badge

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.