Main Page: Difference between revisions

From iot
Jump to navigation Jump to search
 
(14 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 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]

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