426
edits
Main Page: Difference between revisions
Jump to navigation
Jump to search
→Links
(→SPARQL) |
(→Links) |
||
| (15 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 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/yjyj7lj6 list] / [https://tinyurl.com/ | * 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 | ||
| Line 28: | Line 34: | ||
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 an 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 | ||
# 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 | # * 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) | ||
| Line 39: | Line 46: | ||
=== SPARQL === | === SPARQL === | ||
* 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 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 - 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 == | == Wikibase == | ||
| Line 51: | 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] | |||