Main Page

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

• GITHUB iot-device-wikibase

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
• www.variot.eu