Main Page: Difference between revisions

From iot
Jump to navigation Jump to search
Line 15: Line 15:


==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/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

Revision as of 07:44, 21 June 2021

Welcome to iot-device wikibase. This is an experimental sandbox, where we gather IoT devices....


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"
  # * 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

Wikibase

Links