Main Page: Difference between revisions

From iot
Jump to navigation Jump to search
 
(27 intermediate revisions by the same user not shown)
Line 1: Line 1:
Welcome to iot-device [https://wikiba.se/ wikibase]. This is an experimental sandbox, where we gather IoT devices....
Welcome to iot-device [https://wikiba.se/ wikibase]. This is an experimental sandbox, where we gather IoT devices....  
[[File:Media Viewer - New Design - Enable Panel 1 Dialog.png|thumb|class=noviewer]
* [https://iot-device.wiki.opencura.com/query/embed.html#%23defaultView%3AMap%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3Fcoord%20%3FAPI%20%3Fwww%20%3Feionet%20%3FHav%20%3Flayer%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP625%20%3Fcoord.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP6269%20%3FAPI%7D%20%23%20used%20as%20the%20service%20we%20get%20data%20from%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP856%20%3Fwww%7D%20%23%20maybe%20use%20what%20is%20in%20%20Wikidata%3F%20%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP9616%20%3FBathWaterIdentifier%7D%20%23%20BathIdentifier%20defined%20by%20eionet.europa.eu%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP131%20%3FadminID%7D%20%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%0A%20%20%20%20%3FadminID%20rdfs%3Alabel%20%3Flayer.%0A%20%20%7D%0A%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fbadplatsen.havochvatten.se%2Fbadplatsen%2Fkarta%2F%23%2Fbath%2F%22%2C%3FBathWaterIdentifier%29%29%20AS%20%3FHav%29%20%0A%20%20%23%20We%20have%20a%20technical%20debt%20with%20P9616%20it%20should%20just%20be%20defined%20when%20it%20is%20created%20as%20a%20euProtectedAreaCode%0A%20%20%23%20Lesson%20learned%20is%20that%20the%20Swedish%20Agency%20for%20Marine%20and%20Water%20Management%20%28Hav%29%20use%20the%20same%20value%20also%20before%20it%20is%20%22created%22%0A%20%20%23%20%2a%20work%20around%20is%20that%20we%20rank%20it%20depreciated%20when%20its%20not%20%22created%22%0A%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fdd.eionet.europa.eu%2Fvocabularyconcept%2Fwise%2FWFDProtectedArea%2FeuProtectedAreaCode.%22%2C%3FBathWaterIdentifier%29%29%20AS%20%3Feionet%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D%20order%20by%20%3Flayer map] what we have today
* [https://tinyurl.com/yfa8bc4x Graph]
* '''GITHUB''' [https://github.com/salgo60/iot-device-wikibase 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 [https://w.wiki/3RZu Wikidata map]
* > 27000 in Europe see [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ EEA StateOfBathingWaters]
 
The intention is to  
The intention is to  
* to track APIs to IoT devices
* to track APIs to IoT devices
Line 6: Line 13:
** make it easy to get the latest bathing water temperature from all the bathing waters in Sweden
** make it easy to get the latest bathing water temperature from all the bathing waters in Sweden
*** primary target group - [https://github.com/salgo60/Svenskabadplatser/issues/156 people ice skating] and [http://www.climate-cryosphere.org/activities/9-uncategorised/1612-simip-machinelearningmethods predicting ice] ;-)  
*** primary target group - [https://github.com/salgo60/Svenskabadplatser/issues/156 people ice skating] and [http://www.climate-cryosphere.org/activities/9-uncategorised/1612-simip-machinelearningmethods predicting ice] ;-)  
** get some understanding how we should design IoT to make them usable and agree about maybe an API standard
** 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:E1]] schema for describing a device
*** '''TBD''' [[EntitySchema:E2]] schema for measurements received from a device
*** '''TBD''' [[EntitySchema:E2]] schema for measurements received from a device
* [https://w.wiki/3Wfr map Swedish Bathing waters] that all are candidates for an IoT bathwater device
* [https://w.wiki/3Wfr map Swedish Bathing waters] that all are candidates for an IoT bathwater device > 2700
** see also project [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters European bathing waters]
** see also project [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters European bathing waters]
*** EEA [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ Map EU bathing waters]  
*** EEA [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ Map EU bathing waters] > 27 000


==Quicklinks==
==Quicklinks==
* What we have on a [https://tinyurl.com/yf8x3vs7 Map] / [https://tinyurl.com/yz2w6q8w list] - [https://youtu.be/-Ge0XCm0AE0 video] how to get json
* What we have on a [https://iot-device.wiki.opencura.com/query/embed.html#%23defaultView%3AMap%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3Fcoord%20%3FAPI%20%3Fwww%20%3Feionet%20%3FHav%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP625%20%3Fcoord.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP6269%20%3FAPI%7D%20%23%20used%20as%20the%20service%20we%20get%20data%20from%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP856%20%3Fwww%7D%20%23%20maybe%20use%20what%20is%20in%20%20Wikidata%3F%20%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP9616%20%3FBathWaterIdentifier%7D%20%23%20BathIdentifier%20defined%20by%20eionet.europa.eu%0A%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fbadplatsen.havochvatten.se%2Fbadplatsen%2Fkarta%2F%23%2Fbath%2F%22%2C%3FBathWaterIdentifier%29%29%20AS%20%3FHav%29%20%0A%20%20%23%20We%20have%20a%20technical%20debt%20with%20P9616%20it%20should%20just%20be%20defined%20when%20it%20is%20created%20as%20a%20euProtectedAreaCode%0A%20%20%23%20Lesson%20learned%20is%20that%20the%20Swedish%20Agency%20for%20Marine%20and%20Water%20Management%20%28Hav%29%20use%20the%20same%20value%20also%20before%20it%20is%20%22created%22%0A%20%20%23%20%2a%20work%20around%20is%20that%20we%20rank%20it%20depreciated%20when%20its%20not%20%22created%22%0A%20%20BIND%28URI%28CONCAT%28%22https%3A%2F%2Fdd.eionet.europa.eu%2Fvocabularyconcept%2Fwise%2FWFDProtectedArea%2FeuProtectedAreaCode.%22%2C%3FBathWaterIdentifier%29%29%20AS%20%3Feionet%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Map] / [https://tinyurl.com/yjyj7lj6 list] / [https://tinyurl.com/yfhxrtqa longer list] - [https://youtu.be/-Ge0XCm0AE0 video] how to get json
<SPARQL>
<SPARQL>
#defaultView:Map
#defaultView:Map
SELECT ?item ?itemLabel ?itemDescription ?coord ?API WHERE {
PREFIX iotd: <http://iot-device.wiki.opencura.com/entity/>
   ?item wdt:P625 ?coord.
PREFIX iotdt: <http://iot-device.wiki.opencura.com/prop/direct/>
   OPTIONAL {?item wdt:P6269 ?API}
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". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}
}
Line 26: Line 44:
<embedvideo service="youtube">https://www.youtube.com/watch?v=-Ge0XCm0AE0</embedvideo>
<embedvideo service="youtube">https://www.youtube.com/watch?v=-Ge0XCm0AE0</embedvideo>


=== Wikibase ===
=== SPARQL ===
* this is a [https://wikiba.se/fed/ federated Wikibase] and use Wikidata properties see [https://iot-device.wiki.opencura.com/wiki/Special:ListProperties Special:ListProperties]
* IoT devices at a bath with no [https://dd.eionet.europa.eu/dataelements/99263 Eionet bathingWaterIdentifier] - [https://tinyurl.com/yzo5mb57 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 - [https://tinyurl.com/yegps88p SPARQL] - '''Not supported yet''' [https://addshore.com/2021/05/wbstack-setting-changes-federated-properties-wikidata-entity-mapping-more/ read more]
 
== Wikibase ==
* this is a [https://wikiba.se/fed/ federated Wikibase] and use just Wikidata properties see [https://iot-device.wiki.opencura.com/wiki/Special:ListProperties Special:ListProperties]
* [https://tinyurl.com/yk5b3xvm ?s ?p ?o]
* [https://tinyurl.com/yk5b3xvm ?s ?p ?o]


== Links ==
== Links ==
Line 35: Line 56:
** Wikidata [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters WikiProject European Bathing Waters]
** Wikidata [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters WikiProject European Bathing Waters]
* GITHUB [https://github.com/salgo60/Svenskabadplatser Swedish BathingWater]
* GITHUB [https://github.com/salgo60/Svenskabadplatser Swedish BathingWater]
* [https://www.kaggle.com/search?q=IoT Kaggle IoT]
* [https://datasetsearch.research.google.com/search?query=bathwater Google dataset search bathwater]
* [https://datasetsearch.research.google.com/search?query=bathwater Google dataset search bathwater]
* "Announced this sandbox Wikibase" at the [https://community.dataportal.se/topic/87/hj%C3%A4lp-folk-att-bada-i-sommar-med-%C3%B6ppna-data-tips-och-hj%C3%A4lp-beh%C3%B6vs/64?_=1624260322569 Swedish community.dataportal.se]
* Informed the ice skating people [https://www.facebook.com/sssk.se/posts/4801037546579696 FB] / [https://www.sssk.se/skridskonet/kommentar/diskussion.html?ID=3138#skrivkommentarstart SSSK]
* [https://www.variot.eu/about/  www.variot.eu]
* [https://iot-device.wiki.opencura.com/w/rest.php/wikibase-manifest/v0/manifest wikibase-manifest] of this site
* [https://hubeau.eaufrance.fr/ Simplifier l'accèss aux donées sur l'eau]
* [https://scihub.copernicus.eu Copernicus Open Access Hub]

Latest revision as of 07:13, 3 July 2021

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

The intention is to

Quicklinks

#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 read more

Wikibase

Links