https://iot-device.wikibase.cloud/w/api.php?action=feedcontributions&user=Salgo60&feedformat=atomiot - User contributions [en]2024-03-28T22:00:51ZUser contributionsMediaWiki 1.39.6https://iot-device.wikibase.cloud/w/index.php?title=Main_Page&diff=426Main Page2021-07-03T07:13:46Z<p>Salgo60: /* Links */</p>
<hr />
<div>Welcome to iot-device [https://wikiba.se/ wikibase]. This is an experimental sandbox, where we gather IoT devices.... <br />
* [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<br />
* [https://tinyurl.com/yfa8bc4x Graph]<br />
* '''GITHUB''' [https://github.com/salgo60/iot-device-wikibase iot-device-wikibase]<br />
<br />
We start with bathing water temperature IoT devices that starts popping up as data silos with or without an API. The potential is <br />
* > 2800 in Sweden see [https://w.wiki/3RZu Wikidata map]<br />
* > 27000 in Europe see [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ EEA StateOfBathingWaters]<br />
<br />
The intention is to <br />
* to track APIs to IoT devices<br />
* the purpose <br />
** make it easy to get the latest bathing water temperature from all the bathing waters in Sweden<br />
*** 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] ;-) <br />
** get some understanding how we should design IoT API/document it to make them usable and agree about maybe an API standard<br />
*** '''TBD''' [[EntitySchema:E1]] schema for describing a device<br />
*** '''TBD''' [[EntitySchema:E2]] schema for measurements received from a device<br />
* [https://w.wiki/3Wfr map Swedish Bathing waters] that all are candidates for an IoT bathwater device > 2700<br />
** see also project [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters European bathing waters]<br />
*** EEA [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ Map EU bathing waters] > 27 000<br />
<br />
==Quicklinks==<br />
* 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<br />
<SPARQL><br />
#defaultView:Map<br />
PREFIX iotd: <http://iot-device.wiki.opencura.com/entity/><br />
PREFIX iotdt: <http://iot-device.wiki.opencura.com/prop/direct/><br />
SELECT ?bathIoT ?bathIoTLabel ?bathIoTDescription ?coord ?API ?www ?eionet ?Hav WHERE {<br />
?bathIoT wdt:P31 iotd:Q2.<br />
?bathIoT wdt:P625 ?coord.<br />
OPTIONAL {?bathIoT wdt:P6269 ?API} # used as the service we get data from<br />
OPTIONAL {?bathIoT wdt:P856 ?www} # maybe use what is in Wikidata? <br />
OPTIONAL {?bathIoT wdt:P9616 ?BathWaterIdentifier} # BathIdentifier defined by eionet.europa.eu<br />
BIND(URI(CONCAT("https://badplatsen.havochvatten.se/badplatsen/karta/#/bath/",?BathWaterIdentifier)) AS ?Hav) <br />
# We have a technical debt with P9616 it should just be defined when it is created as an euProtectedAreaCode<br />
# Lesson learned is that the Swedish Agency for Marine and Water Management (Hav) use the same value also <br />
# before it is "created" but then have the odd name NUTSKOD<br />
# * work around is that we rank it depreciated when its not "created" but used by Hav<br />
BIND(URI(CONCAT("https://dd.eionet.europa.eu/vocabularyconcept/wise/WFDProtectedArea/euProtectedAreaCode.",?BathWaterIdentifier)) AS ?eionet)<br />
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }<br />
}<br />
</SPARQL><br />
<br />
<embedvideo service="youtube">https://www.youtube.com/watch?v=-Ge0XCm0AE0</embedvideo><br />
<br />
=== SPARQL ===<br />
* IoT devices at a bath with no [https://dd.eionet.europa.eu/dataelements/99263 Eionet bathingWaterIdentifier] - [https://tinyurl.com/yzo5mb57 SPARQL]<br />
** 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]<br />
<br />
== Wikibase ==<br />
* 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]<br />
* [https://tinyurl.com/yk5b3xvm ?s ?p ?o]<br />
<br />
== Links ==<br />
* GITHUB [https://github.com/salgo60/EuropeanBathingWater European BathingWater]<br />
** Wikidata [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters WikiProject European Bathing Waters]<br />
* GITHUB [https://github.com/salgo60/Svenskabadplatser Swedish BathingWater]<br />
* [https://www.kaggle.com/search?q=IoT Kaggle IoT]<br />
* [https://datasetsearch.research.google.com/search?query=bathwater Google dataset search bathwater]<br />
* "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]<br />
* 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]<br />
* [https://www.variot.eu/about/ www.variot.eu]<br />
* [https://iot-device.wiki.opencura.com/w/rest.php/wikibase-manifest/v0/manifest wikibase-manifest] of this site<br />
* [https://hubeau.eaufrance.fr/ Simplifier l'accèss aux donées sur l'eau]<br />
* [https://scihub.copernicus.eu Copernicus Open Access Hub]</div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Main_Page&diff=425Main Page2021-06-28T06:15:47Z<p>Salgo60: /* Links */</p>
<hr />
<div>Welcome to iot-device [https://wikiba.se/ wikibase]. This is an experimental sandbox, where we gather IoT devices.... <br />
* [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<br />
* [https://tinyurl.com/yfa8bc4x Graph]<br />
* '''GITHUB''' [https://github.com/salgo60/iot-device-wikibase iot-device-wikibase]<br />
<br />
We start with bathing water temperature IoT devices that starts popping up as data silos with or without an API. The potential is <br />
* > 2800 in Sweden see [https://w.wiki/3RZu Wikidata map]<br />
* > 27000 in Europe see [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ EEA StateOfBathingWaters]<br />
<br />
The intention is to <br />
* to track APIs to IoT devices<br />
* the purpose <br />
** make it easy to get the latest bathing water temperature from all the bathing waters in Sweden<br />
*** 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] ;-) <br />
** get some understanding how we should design IoT API/document it to make them usable and agree about maybe an API standard<br />
*** '''TBD''' [[EntitySchema:E1]] schema for describing a device<br />
*** '''TBD''' [[EntitySchema:E2]] schema for measurements received from a device<br />
* [https://w.wiki/3Wfr map Swedish Bathing waters] that all are candidates for an IoT bathwater device > 2700<br />
** see also project [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters European bathing waters]<br />
*** EEA [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ Map EU bathing waters] > 27 000<br />
<br />
==Quicklinks==<br />
* 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<br />
<SPARQL><br />
#defaultView:Map<br />
PREFIX iotd: <http://iot-device.wiki.opencura.com/entity/><br />
PREFIX iotdt: <http://iot-device.wiki.opencura.com/prop/direct/><br />
SELECT ?bathIoT ?bathIoTLabel ?bathIoTDescription ?coord ?API ?www ?eionet ?Hav WHERE {<br />
?bathIoT wdt:P31 iotd:Q2.<br />
?bathIoT wdt:P625 ?coord.<br />
OPTIONAL {?bathIoT wdt:P6269 ?API} # used as the service we get data from<br />
OPTIONAL {?bathIoT wdt:P856 ?www} # maybe use what is in Wikidata? <br />
OPTIONAL {?bathIoT wdt:P9616 ?BathWaterIdentifier} # BathIdentifier defined by eionet.europa.eu<br />
BIND(URI(CONCAT("https://badplatsen.havochvatten.se/badplatsen/karta/#/bath/",?BathWaterIdentifier)) AS ?Hav) <br />
# We have a technical debt with P9616 it should just be defined when it is created as an euProtectedAreaCode<br />
# Lesson learned is that the Swedish Agency for Marine and Water Management (Hav) use the same value also <br />
# before it is "created" but then have the odd name NUTSKOD<br />
# * work around is that we rank it depreciated when its not "created" but used by Hav<br />
BIND(URI(CONCAT("https://dd.eionet.europa.eu/vocabularyconcept/wise/WFDProtectedArea/euProtectedAreaCode.",?BathWaterIdentifier)) AS ?eionet)<br />
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }<br />
}<br />
</SPARQL><br />
<br />
<embedvideo service="youtube">https://www.youtube.com/watch?v=-Ge0XCm0AE0</embedvideo><br />
<br />
=== SPARQL ===<br />
* IoT devices at a bath with no [https://dd.eionet.europa.eu/dataelements/99263 Eionet bathingWaterIdentifier] - [https://tinyurl.com/yzo5mb57 SPARQL]<br />
** 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]<br />
<br />
== Wikibase ==<br />
* 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]<br />
* [https://tinyurl.com/yk5b3xvm ?s ?p ?o]<br />
<br />
== Links ==<br />
* GITHUB [https://github.com/salgo60/EuropeanBathingWater European BathingWater]<br />
** Wikidata [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters WikiProject European Bathing Waters]<br />
* GITHUB [https://github.com/salgo60/Svenskabadplatser Swedish BathingWater]<br />
* [https://www.kaggle.com/search?q=IoT Kaggle IoT]<br />
* [https://datasetsearch.research.google.com/search?query=bathwater Google dataset search bathwater]<br />
* "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]<br />
* 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]<br />
* [https://www.variot.eu/about/ www.variot.eu]<br />
* [https://iot-device.wiki.opencura.com/w/rest.php/wikibase-manifest/v0/manifest wikibase-manifest] of this site<br />
* [https://hubeau.eaufrance.fr/ Simplifier l'accèss aux donées sur l'eau]</div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Main_Page&diff=424Main Page2021-06-25T08:57:00Z<p>Salgo60: /* SPARQL */</p>
<hr />
<div>Welcome to iot-device [https://wikiba.se/ wikibase]. This is an experimental sandbox, where we gather IoT devices.... <br />
* [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<br />
* [https://tinyurl.com/yfa8bc4x Graph]<br />
* '''GITHUB''' [https://github.com/salgo60/iot-device-wikibase iot-device-wikibase]<br />
<br />
We start with bathing water temperature IoT devices that starts popping up as data silos with or without an API. The potential is <br />
* > 2800 in Sweden see [https://w.wiki/3RZu Wikidata map]<br />
* > 27000 in Europe see [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ EEA StateOfBathingWaters]<br />
<br />
The intention is to <br />
* to track APIs to IoT devices<br />
* the purpose <br />
** make it easy to get the latest bathing water temperature from all the bathing waters in Sweden<br />
*** 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] ;-) <br />
** get some understanding how we should design IoT API/document it to make them usable and agree about maybe an API standard<br />
*** '''TBD''' [[EntitySchema:E1]] schema for describing a device<br />
*** '''TBD''' [[EntitySchema:E2]] schema for measurements received from a device<br />
* [https://w.wiki/3Wfr map Swedish Bathing waters] that all are candidates for an IoT bathwater device > 2700<br />
** see also project [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters European bathing waters]<br />
*** EEA [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ Map EU bathing waters] > 27 000<br />
<br />
==Quicklinks==<br />
* 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<br />
<SPARQL><br />
#defaultView:Map<br />
PREFIX iotd: <http://iot-device.wiki.opencura.com/entity/><br />
PREFIX iotdt: <http://iot-device.wiki.opencura.com/prop/direct/><br />
SELECT ?bathIoT ?bathIoTLabel ?bathIoTDescription ?coord ?API ?www ?eionet ?Hav WHERE {<br />
?bathIoT wdt:P31 iotd:Q2.<br />
?bathIoT wdt:P625 ?coord.<br />
OPTIONAL {?bathIoT wdt:P6269 ?API} # used as the service we get data from<br />
OPTIONAL {?bathIoT wdt:P856 ?www} # maybe use what is in Wikidata? <br />
OPTIONAL {?bathIoT wdt:P9616 ?BathWaterIdentifier} # BathIdentifier defined by eionet.europa.eu<br />
BIND(URI(CONCAT("https://badplatsen.havochvatten.se/badplatsen/karta/#/bath/",?BathWaterIdentifier)) AS ?Hav) <br />
# We have a technical debt with P9616 it should just be defined when it is created as an euProtectedAreaCode<br />
# Lesson learned is that the Swedish Agency for Marine and Water Management (Hav) use the same value also <br />
# before it is "created" but then have the odd name NUTSKOD<br />
# * work around is that we rank it depreciated when its not "created" but used by Hav<br />
BIND(URI(CONCAT("https://dd.eionet.europa.eu/vocabularyconcept/wise/WFDProtectedArea/euProtectedAreaCode.",?BathWaterIdentifier)) AS ?eionet)<br />
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }<br />
}<br />
</SPARQL><br />
<br />
<embedvideo service="youtube">https://www.youtube.com/watch?v=-Ge0XCm0AE0</embedvideo><br />
<br />
=== SPARQL ===<br />
* IoT devices at a bath with no [https://dd.eionet.europa.eu/dataelements/99263 Eionet bathingWaterIdentifier] - [https://tinyurl.com/yzo5mb57 SPARQL]<br />
** 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]<br />
<br />
== Wikibase ==<br />
* 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]<br />
* [https://tinyurl.com/yk5b3xvm ?s ?p ?o]<br />
<br />
== Links ==<br />
* GITHUB [https://github.com/salgo60/EuropeanBathingWater European BathingWater]<br />
** Wikidata [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters WikiProject European Bathing Waters]<br />
* GITHUB [https://github.com/salgo60/Svenskabadplatser Swedish BathingWater]<br />
* [https://www.kaggle.com/search?q=IoT Kaggle IoT]<br />
* [https://datasetsearch.research.google.com/search?query=bathwater Google dataset search bathwater]<br />
* "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]<br />
* 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]<br />
* [https://www.variot.eu/about/ www.variot.eu]<br />
* [https://iot-device.wiki.opencura.com/w/rest.php/wikibase-manifest/v0/manifest wikibase-manifest] of this site</div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Main_Page&diff=423Main Page2021-06-25T08:56:03Z<p>Salgo60: /* Links */</p>
<hr />
<div>Welcome to iot-device [https://wikiba.se/ wikibase]. This is an experimental sandbox, where we gather IoT devices.... <br />
* [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<br />
* [https://tinyurl.com/yfa8bc4x Graph]<br />
* '''GITHUB''' [https://github.com/salgo60/iot-device-wikibase iot-device-wikibase]<br />
<br />
We start with bathing water temperature IoT devices that starts popping up as data silos with or without an API. The potential is <br />
* > 2800 in Sweden see [https://w.wiki/3RZu Wikidata map]<br />
* > 27000 in Europe see [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ EEA StateOfBathingWaters]<br />
<br />
The intention is to <br />
* to track APIs to IoT devices<br />
* the purpose <br />
** make it easy to get the latest bathing water temperature from all the bathing waters in Sweden<br />
*** 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] ;-) <br />
** get some understanding how we should design IoT API/document it to make them usable and agree about maybe an API standard<br />
*** '''TBD''' [[EntitySchema:E1]] schema for describing a device<br />
*** '''TBD''' [[EntitySchema:E2]] schema for measurements received from a device<br />
* [https://w.wiki/3Wfr map Swedish Bathing waters] that all are candidates for an IoT bathwater device > 2700<br />
** see also project [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters European bathing waters]<br />
*** EEA [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ Map EU bathing waters] > 27 000<br />
<br />
==Quicklinks==<br />
* 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<br />
<SPARQL><br />
#defaultView:Map<br />
PREFIX iotd: <http://iot-device.wiki.opencura.com/entity/><br />
PREFIX iotdt: <http://iot-device.wiki.opencura.com/prop/direct/><br />
SELECT ?bathIoT ?bathIoTLabel ?bathIoTDescription ?coord ?API ?www ?eionet ?Hav WHERE {<br />
?bathIoT wdt:P31 iotd:Q2.<br />
?bathIoT wdt:P625 ?coord.<br />
OPTIONAL {?bathIoT wdt:P6269 ?API} # used as the service we get data from<br />
OPTIONAL {?bathIoT wdt:P856 ?www} # maybe use what is in Wikidata? <br />
OPTIONAL {?bathIoT wdt:P9616 ?BathWaterIdentifier} # BathIdentifier defined by eionet.europa.eu<br />
BIND(URI(CONCAT("https://badplatsen.havochvatten.se/badplatsen/karta/#/bath/",?BathWaterIdentifier)) AS ?Hav) <br />
# We have a technical debt with P9616 it should just be defined when it is created as an euProtectedAreaCode<br />
# Lesson learned is that the Swedish Agency for Marine and Water Management (Hav) use the same value also <br />
# before it is "created" but then have the odd name NUTSKOD<br />
# * work around is that we rank it depreciated when its not "created" but used by Hav<br />
BIND(URI(CONCAT("https://dd.eionet.europa.eu/vocabularyconcept/wise/WFDProtectedArea/euProtectedAreaCode.",?BathWaterIdentifier)) AS ?eionet)<br />
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }<br />
}<br />
</SPARQL><br />
<br />
<embedvideo service="youtube">https://www.youtube.com/watch?v=-Ge0XCm0AE0</embedvideo><br />
<br />
=== SPARQL ===<br />
* IoT devices at a bath with no [https://dd.eionet.europa.eu/dataelements/99263 Eionet bathingWaterIdentifier] - [https://tinyurl.com/yzo5mb57 SPARQL]<br />
** 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'''<br />
<br />
== Wikibase ==<br />
* 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]<br />
* [https://tinyurl.com/yk5b3xvm ?s ?p ?o]<br />
<br />
== Links ==<br />
* GITHUB [https://github.com/salgo60/EuropeanBathingWater European BathingWater]<br />
** Wikidata [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters WikiProject European Bathing Waters]<br />
* GITHUB [https://github.com/salgo60/Svenskabadplatser Swedish BathingWater]<br />
* [https://www.kaggle.com/search?q=IoT Kaggle IoT]<br />
* [https://datasetsearch.research.google.com/search?query=bathwater Google dataset search bathwater]<br />
* "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]<br />
* 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]<br />
* [https://www.variot.eu/about/ www.variot.eu]<br />
* [https://iot-device.wiki.opencura.com/w/rest.php/wikibase-manifest/v0/manifest wikibase-manifest] of this site</div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q73&diff=422Item:Q732021-06-24T17:41:55Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P9616: FI110910012</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q73&diff=421Item:Q732021-06-24T17:40:56Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P856: https://palvelukartta.hel.fi/unit/41960</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q73&diff=420Item:Q732021-06-24T17:40:35Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P6269: https://iot.fvh.fi/opendata/uiras/70B3D57050001AB9_v1.json</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q73&diff=419Item:Q732021-06-24T17:39:32Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P625: 60°13'39.734"N, 24°59'1.756"E</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q73&diff=418Item:Q732021-06-24T17:38:57Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P131: Item:Q38</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q73&diff=417Item:Q732021-06-24T17:38:37Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P17: Item:Q37</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q73&diff=416Item:Q732021-06-24T17:38:18Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P31: Item:Q2</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q73&diff=415Item:Q732021-06-24T17:37:46Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P9616: FI110910012</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q73&diff=414Item:Q732021-06-24T17:37:11Z<p>Salgo60: /* wbeditentity-create:2|en */ Pikkukosken uimaranta, IoT device in Helsinki, Finland</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q36&diff=413Item:Q362021-06-24T16:51:47Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P9616: FI110910003</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q63&diff=412Item:Q632021-06-24T16:50:14Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P9616: FI110910008</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q72&diff=411Item:Q722021-06-24T16:47:15Z<p>Salgo60: /* wbeditentity-create-item:0| */ #quickstatements; #temporary_batch_1624553230633</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q71&diff=410Item:Q712021-06-24T16:24:41Z<p>Salgo60: /* wbeditentity-create-item:0| */ #quickstatements; #temporary_batch_1624551831971</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q70&diff=409Item:Q702021-06-24T16:24:37Z<p>Salgo60: /* wbeditentity-create-item:0| */ #quickstatements; #temporary_batch_1624551831971</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q69&diff=408Item:Q692021-06-24T16:24:33Z<p>Salgo60: /* wbeditentity-create-item:0| */ #quickstatements; #temporary_batch_1624551831971</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q68&diff=407Item:Q682021-06-24T16:24:28Z<p>Salgo60: /* wbeditentity-create-item:0| */ #quickstatements; #temporary_batch_1624551831971</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q67&diff=406Item:Q672021-06-24T16:24:24Z<p>Salgo60: /* wbeditentity-create-item:0| */ #quickstatements; #temporary_batch_1624551831971</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q66&diff=405Item:Q662021-06-24T16:24:19Z<p>Salgo60: /* wbeditentity-create-item:0| */ #quickstatements; #temporary_batch_1624551831971</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q65&diff=404Item:Q652021-06-24T16:24:15Z<p>Salgo60: /* wbeditentity-create-item:0| */ #quickstatements; #temporary_batch_1624551831971</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q64&diff=403Item:Q642021-06-24T16:24:10Z<p>Salgo60: /* wbeditentity-create-item:0| */ #quickstatements; #temporary_batch_1624551831971</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q63&diff=402Item:Q632021-06-24T16:24:05Z<p>Salgo60: /* wbeditentity-create-item:0| */ #quickstatements; #temporary_batch_1624551831971</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q62&diff=401Item:Q622021-06-24T16:23:35Z<p>Salgo60: /* wbeditentity-create-item:0| */ #quickstatements; #temporary_batch_1624551789578</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q59&diff=400Item:Q592021-06-24T07:05:38Z<p>Salgo60: /* wbsetclaim-update:2||1 */ wikidata:Special:EntityPage/P625: 60°1'0.19"N, 18°20'4.49"E</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q59&diff=399Item:Q592021-06-24T07:05:10Z<p>Salgo60: /* wbsetclaim-update:2||1 */ wikidata:Special:EntityPage/P9616: SE0210380000001184</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q59&diff=398Item:Q592021-06-24T07:04:48Z<p>Salgo60: /* wbsetdescription-add:1|sv */ EC 327 mäter WaterQualityObserved - letar efter API</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q59&diff=397Item:Q592021-06-24T07:04:41Z<p>Salgo60: /* wbsetdescription-set:1|en */ EC 327 measure WaterQualityObserved - looking for API id</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q59&diff=396Item:Q592021-06-24T07:04:34Z<p>Salgo60: /* wbsetlabel-add:1|sv */ Måviksbadet</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q59&diff=395Item:Q592021-06-24T07:04:26Z<p>Salgo60: /* wbsetlabel-set:1|en */ Måviksbadet</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Main_Page&diff=394Main Page2021-06-24T06:57:04Z<p>Salgo60: </p>
<hr />
<div>Welcome to iot-device [https://wikiba.se/ wikibase]. This is an experimental sandbox, where we gather IoT devices.... <br />
* [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<br />
* [https://tinyurl.com/yfa8bc4x Graph]<br />
* '''GITHUB''' [https://github.com/salgo60/iot-device-wikibase iot-device-wikibase]<br />
<br />
We start with bathing water temperature IoT devices that starts popping up as data silos with or without an API. The potential is <br />
* > 2800 in Sweden see [https://w.wiki/3RZu Wikidata map]<br />
* > 27000 in Europe see [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ EEA StateOfBathingWaters]<br />
<br />
The intention is to <br />
* to track APIs to IoT devices<br />
* the purpose <br />
** make it easy to get the latest bathing water temperature from all the bathing waters in Sweden<br />
*** 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] ;-) <br />
** get some understanding how we should design IoT API/document it to make them usable and agree about maybe an API standard<br />
*** '''TBD''' [[EntitySchema:E1]] schema for describing a device<br />
*** '''TBD''' [[EntitySchema:E2]] schema for measurements received from a device<br />
* [https://w.wiki/3Wfr map Swedish Bathing waters] that all are candidates for an IoT bathwater device > 2700<br />
** see also project [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters European bathing waters]<br />
*** EEA [https://maps.eea.europa.eu/wab/StateOfBathingWaters/ Map EU bathing waters] > 27 000<br />
<br />
==Quicklinks==<br />
* 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<br />
<SPARQL><br />
#defaultView:Map<br />
PREFIX iotd: <http://iot-device.wiki.opencura.com/entity/><br />
PREFIX iotdt: <http://iot-device.wiki.opencura.com/prop/direct/><br />
SELECT ?bathIoT ?bathIoTLabel ?bathIoTDescription ?coord ?API ?www ?eionet ?Hav WHERE {<br />
?bathIoT wdt:P31 iotd:Q2.<br />
?bathIoT wdt:P625 ?coord.<br />
OPTIONAL {?bathIoT wdt:P6269 ?API} # used as the service we get data from<br />
OPTIONAL {?bathIoT wdt:P856 ?www} # maybe use what is in Wikidata? <br />
OPTIONAL {?bathIoT wdt:P9616 ?BathWaterIdentifier} # BathIdentifier defined by eionet.europa.eu<br />
BIND(URI(CONCAT("https://badplatsen.havochvatten.se/badplatsen/karta/#/bath/",?BathWaterIdentifier)) AS ?Hav) <br />
# We have a technical debt with P9616 it should just be defined when it is created as an euProtectedAreaCode<br />
# Lesson learned is that the Swedish Agency for Marine and Water Management (Hav) use the same value also <br />
# before it is "created" but then have the odd name NUTSKOD<br />
# * work around is that we rank it depreciated when its not "created" but used by Hav<br />
BIND(URI(CONCAT("https://dd.eionet.europa.eu/vocabularyconcept/wise/WFDProtectedArea/euProtectedAreaCode.",?BathWaterIdentifier)) AS ?eionet)<br />
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }<br />
}<br />
</SPARQL><br />
<br />
<embedvideo service="youtube">https://www.youtube.com/watch?v=-Ge0XCm0AE0</embedvideo><br />
<br />
=== SPARQL ===<br />
* IoT devices at a bath with no [https://dd.eionet.europa.eu/dataelements/99263 Eionet bathingWaterIdentifier] - [https://tinyurl.com/yzo5mb57 SPARQL]<br />
** 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'''<br />
<br />
== Wikibase ==<br />
* 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]<br />
* [https://tinyurl.com/yk5b3xvm ?s ?p ?o]<br />
<br />
== Links ==<br />
* GITHUB [https://github.com/salgo60/EuropeanBathingWater European BathingWater]<br />
** Wikidata [https://www.wikidata.org/wiki/Wikidata:WikiProject_European_Bathing_Waters WikiProject European Bathing Waters]<br />
* GITHUB [https://github.com/salgo60/Svenskabadplatser Swedish BathingWater]<br />
* [https://www.kaggle.com/search?q=IoT Kaggle IoT]<br />
* [https://datasetsearch.research.google.com/search?query=bathwater Google dataset search bathwater]<br />
* "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]<br />
* 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]<br />
* [https://www.variot.eu/about/ www.variot.eu]</div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q61&diff=393Item:Q612021-06-24T06:50:06Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P2575: Item:Q3</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q61&diff=392Item:Q612021-06-24T06:48:45Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P9616: SE0210380000001166</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q61&diff=391Item:Q612021-06-24T06:48:12Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P625: 60°1'27.41"N, 17°48'56.74"E</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q61&diff=390Item:Q612021-06-24T06:47:38Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P126: Item:Q57</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q61&diff=389Item:Q612021-06-24T06:47:21Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P131: Item:Q57</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q61&diff=388Item:Q612021-06-24T06:46:57Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P17: Item:Q33</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q61&diff=387Item:Q612021-06-24T06:46:41Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P856: https://github.com/salgo60/iot-device-wikibase/issues/3</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q61&diff=386Item:Q612021-06-24T06:46:17Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P6269: unknown value</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q61&diff=385Item:Q612021-06-24T06:45:57Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P31: Item:Q2</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q61&diff=384Item:Q612021-06-24T06:45:47Z<p>Salgo60: /* wbsetdescription-add:1|sv */ EC 323 har WaterQualityObserved - letar efter API</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q61&diff=383Item:Q612021-06-24T06:45:41Z<p>Salgo60: /* wbsetlabel-add:1|sv */ Lafsenbadet</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q61&diff=382Item:Q612021-06-24T06:45:14Z<p>Salgo60: /* wbeditentity-create:2|en */ Lafsenbadet, EC 323 has WaterQualityObserved - looking for API</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q60&diff=381Item:Q602021-06-24T06:35:12Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P625: 59°57'39.85"N, 17°41'18.17"E</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q60&diff=380Item:Q602021-06-24T06:34:59Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P9616: SE0210380000003866</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q60&diff=379Item:Q602021-06-24T06:33:46Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P126: Item:Q57</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q60&diff=378Item:Q602021-06-24T06:33:27Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P131: Item:Q57</p>
<hr />
<div></div>Salgo60https://iot-device.wikibase.cloud/w/index.php?title=Item:Q60&diff=377Item:Q602021-06-24T06:33:03Z<p>Salgo60: /* wbsetclaim-create:2||1 */ wikidata:Special:EntityPage/P2575: Item:Q3</p>
<hr />
<div></div>Salgo60