Main Page: Difference between revisions

From iot
Jump to navigation Jump to search
 
(23 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....  
* [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  
Line 7: 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
Line 15: Line 21:


==Quicklinks==
==Quicklinks==
* 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/yz2w6q8w list] / [https://tinyurl.com/yj2cthxd longer 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 {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
   ?bathIoT wdt:P31 iotd:Q2.
}
  ?bathIoT wdt:P625 ?coord.
#defaultView:Map
   OPTIONAL {?bathIoT wdt:P6269 ?API} # used as the service we get data from
SELECT ?item ?itemLabel ?itemDescription ?coord ?API ?www ?eionet ?Hav WHERE {
   OPTIONAL {?bathIoT wdt:P856 ?www} # maybe use what is in  Wikidata?  
   ?item wdt:P625 ?coord.
   OPTIONAL {?bathIoT wdt:P9616 ?BathWaterIdentifier} # BathIdentifier defined by eionet.europa.eu
   OPTIONAL {?item wdt:P6269 ?API} # used as the service we get data from
   OPTIONAL {?item wdt:P856 ?www} # maybe use what is in  Wikidata?  
   OPTIONAL {?item wdt:P9616 ?BathWaterIdentifier} # BathIdentifier defined by eionet.europa.eu
   BIND(URI(CONCAT("https://badplatsen.havochvatten.se/badplatsen/karta/#/bath/",?BathWaterIdentifier)) AS ?Hav)  
   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 a euProtectedAreaCode
   # 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"
   # Lesson learned is that the Swedish Agency for Marine and Water Management (Hav) use the same value also  
   # * work around is that we rank it depreciated when its not "created"
  # 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)
   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 40: 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]


Line 50: Line 58:
* [https://www.kaggle.com/search?q=IoT Kaggle IoT]
* [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