Main Page

Welcome to iot-device wikibase. This is an experimental sandbox, where we gather IoT devices....

We start with bathing water temperature IoT devices that starts popping up as data silos with or without an API. The potential is

• > 2800 in Sweden see Wikidata map
• > 27000 in Europe see EEA StateOfBathingWaters

The intention is to

• to track APIs to IoT devices
• the purpose
  • make it easy to get the latest bathing water temperature from all the bathing waters in Sweden
    • primary target group - people ice skating and predicting ice ;-)
  • get some understanding how we should design IoT API/document it to make them usable and agree about maybe an API standard
    • TBD EntitySchema:E1 schema for describing a device
    • TBD EntitySchema:E2 schema for measurements received from a device
• map Swedish Bathing waters that all are candidates for an IoT bathwater device > 2700
  • see also project European bathing waters
    • EEA Map EU bathing waters > 27 000

Quicklinks

• What we have on a Map / list / longer list - video how to get json

#defaultView:Map
PREFIX iotd: <http://iot-device.wiki.opencura.com/entity/>
PREFIX iotdt: <http://iot-device.wiki.opencura.com/prop/direct/>
SELECT ?bathIoT ?bathIoTLabel ?bathIoTDescription ?coord ?API ?www ?eionet ?Hav WHERE {
  ?bathIoT wdt:P31 iotd:Q2.
  ?bathIoT wdt:P625 ?coord.
  OPTIONAL {?bathIoT wdt:P6269 ?API} # used as the service we get data from
  OPTIONAL {?bathIoT wdt:P856 ?www} # maybe use what is in  Wikidata? 
  OPTIONAL {?bathIoT wdt:P9616 ?BathWaterIdentifier} # BathIdentifier defined by eionet.europa.eu
  BIND(URI(CONCAT("https://badplatsen.havochvatten.se/badplatsen/karta/#/bath/",?BathWaterIdentifier)) AS ?Hav) 
  # We have a technical debt with P9616 it should just be defined when it is created as an euProtectedAreaCode
  # Lesson learned is that the Swedish Agency for Marine and Water Management (Hav) use the same value also 
  # before it is "created" but then have the odd name NUTSKOD
  # * work around is that we rank it depreciated when its not "created" but used by Hav
  BIND(URI(CONCAT("https://dd.eionet.europa.eu/vocabularyconcept/wise/WFDProtectedArea/euProtectedAreaCode.",?BathWaterIdentifier)) AS ?eionet)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}

SPARQL

• IoT devices at a bath with no Eionet bathingWaterIdentifier - SPARQL
  • IoT devices at a bath with a deprecated bathingWaterIdentifier i.e. it is a value at the Swedish Swedish Agency for Marine and Water Managemen but not an official bathingWaterIdentifier - SPARQL - Not supported yet

Wikibase

• this is a federated Wikibase and use just Wikidata properties see Special:ListProperties
• ?s ?p ?o

Links

• GITHUB European BathingWater
  • Wikidata WikiProject European Bathing Waters
• GITHUB Swedish BathingWater
• Kaggle IoT
• Google dataset search bathwater
• "Announced this sandbox Wikibase" at the Swedish community.dataportal.se
• Informed the ice skating people FB / SSSK