Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Wikidata & SPARQL: Islands of Indonesia

Wikidata & SPARQL: Islands of Indonesia

Using SPARQL to query Wikidata to find information about islands of Indonesia.
A workshop presented at Wikimedia Indonesia

Avatar for John Vandenberg

John Vandenberg

June 17, 2017
Tweet

Other Decks in Technology

Transcript

  1. Wikipedia says... The exact number of islands comprising Indonesia varies

    among definitions and sources. According to a geospatial survey conducted between 2007 and 2010 by Badan Koordinasi Survei dan Pemetaan Nasional (Bakorsurtanal), the National Coordinating Agency for Survey and Mapping, Indonesia has 13,466 islands.[1] However, according to earlier survey in 2002 by National Institute of Aeronautics and Space (LAPAN), the Indonesian archipelago has 18,307 islands and, … according to the CIA World Factbook, there are 17,508 islands.[2] The discrepancy of the numbers of Indonesian islands was because that the earlier surveys include "tidal islands"; sandy cays and rocky reefs that appear during low tide and are submerged during high tide.[1] 8,844 islands have been named according to estimates made by the government of Indonesia, with 922 of those permanently inhabited.[3] http://enwp.org/List_of_islands_of_Indonesia
  2. Indonesia has DPKI describing the small islands http://enwp.org/Indonesian_Small_Islands_Directory Indonesian Small

    Islands Directory (Direktori Pulau-pulau Kecil Indonesia) is a web directory that lists small islands of Indonesia.[1] Established by 2007 Law 27 (Undang-Undang 27 Tahun 2007), it covers islands up to area of 2,000 km2 and their surrounding ecosystem. The directory is managed by Direktorat Pendayagunaan Pulau-Pulau Kecil, Direktorat Jenderal Pengelolaan Ruang Laut, Kementerian Kelautan dan Perikanan, Republik Indonesia.
  3. “DPKI” says... Ceningan Nusa with • Province • Regency •

    Coordinate is number 4871 http://www.ppk-kp3k.kkp.go.id/direktori-pulau/index.php/public_c/pulau_info/4871
  4. Wikidata: Intro Wikidata is a “user generated” “open data” database.

    https://www.wikidata.org/ Wikidata can be queried. https://query.wikidata.org/ The following queries and results were done on 14-15 June 2017. Wikimedia Indonesia has an intern busily improving the data; the results should be different when you run these queries.
  5. Wikidata: Properties • instance of (P31) • subclass of (P279)

    • country (P17) • coordinate (P625) • geoshape (P3896) • OpenSteetMap relation (P402) • Northernmost (P1332) • Southernmost (P1333) • Easternmost (P1334) • Westernmost (P1335)
  6. Wikidata has 95049 islands Lorem ipsum dolor sit amet, consectetur

    adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  7. Wikidata has 96505 islands, islets, etc. Lorem ipsum dolor sit

    amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  8. Wikidata has 31 types of islands Lorem ipsum dolor sit

    amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  9. Wikidata has 1327 islands that are not Q23442 (island) Lorem

    ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  10. Wikidata has 91775 islands with country ? Lorem ipsum dolor

    sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  11. Wikidata has 3436 islands without country Lorem ipsum dolor sit

    amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 4%
  12. Wikidata has 91613 islands with country Lorem ipsum dolor sit

    amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  13. Wikidata has 95049 islands Wikidata has 3436 islands without country

    Wikidata has 91613 islands with country 96%
  14. Wikidata has 3016 countries Lorem ipsum dolor sit amet, consectetur

    adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  15. Wikidata has 477 countries describing geographic regions Lorem ipsum dolor

    sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  16. Wikidata has 195 countries describing islands Lorem ipsum dolor sit

    amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  17. Wikidata has 154 islands with multiple country Lorem ipsum dolor

    sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 0.1%
  18. Wikidata has 154 islands with 314 claims Lorem ipsum dolor

    sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  19. Wikidata has 3 islands shared by Indonesia Shared with: Brunei

    Malaysia Papua New Guinea Timor Leste Q36117 Q83067 Q40285
  20. Wikidata has 58583 islands with P131 (located within) Lorem ipsum

    dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 64%
  21. Wikidata has 107 islands linked to OSM (worldwide) Lorem ipsum

    dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 0.1%
  22. Wikidata has 0 islands with a geoshape Lorem ipsum dolor

    sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  23. Wikidata has 0 anything with a geoshape Lorem ipsum dolor

    sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  24. Wikidata: Islands of the World • Add country to all

    islands (96% complete) • Create query to separate disputed vs shared islands • Add OpenStreetMap relations to Wikidata islands (0.1% complete) TO DO
  25. Wikidata has † 6217 islands 2627 * missing Lorem ipsum

    dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. * or more, as Wikidata may have islands not in the official list. † some items may not be found using this query 70%
  26. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do

    eiusmod tempor incididunt ut labor. Wikidata has 6217 islands 70%
  27. Wikidata has 6228? islands Wikidata now has 11 extra islands?

    Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 70%
  28. Wikidata has 285 coordinates of islands Lorem ipsum dolor sit

    amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor.
  29. Wikidata has 278 islands with coordinates Lorem ipsum dolor sit

    amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 3%
  30. Wikidata has 11 islands with multiple coordinates Lorem ipsum dolor

    sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 0.1%
  31. Wikidata has 11 islands with multiple coordinates Lorem ipsum dolor

    sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 0.1%
  32. Wikidata has 207 islands with coordinates without admin Lorem ipsum

    dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 72%
  33. Wikidata has 207 islands with coordinates without admin Lorem ipsum

    dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 72%
  34. 207 islands with Coordinates Without Lorem ipsum dolor sit amet,

    consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 72% 207 islands with coordinates without administrative territory Wikidata has
  35. Wikidata has 0 islands linked to OSM Lorem ipsum dolor

    sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 0%
  36. Wikidata: Indonesia islands • Remove duplicate coordinates (1+) • Remove

    multiple coordinates (11) • Add DPKI authority to coordinates (0%) • Add coordinates from DPKI (3% completed) • Add missing islands from DPKI (70% completed) • Add other countries to disputed/shared islands of Indonesia • Add OpenStreetMap relations to Wikidata islands of Indonesia (%0) TO DO
  37. Wikipedia: Indonesia islands • Remove duplicate Wikidata islands (76) •

    Create bahasa Indonesia Wikipedia articles • Create bahasa Inggris Wikipedia articles • Create bahasa Jawa Wikipedia articles etc.. TO DO
  38. Wikidata has 274 islands with bahasa Indonesia label Lorem ipsum

    dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 3%
  39. Wikidata has 199 islands with a coordinate and Bahasa Indonesia

    label Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 2.2%
  40. Wikidata has 199 islands with a coordinate and Bahasa Indonesia

    label Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 2.2%
  41. Wikidata: Indonesia island labels • Remove duplicate Wikidata islands (95)

    • Create bahasa Indonesia Wikipedia labels • Create bahasa Inggris Wikipedia labels • Create bahasa Jawa Wikipedia labels etc.. • Find new duplicate Wikidata islands using new labels TO DO
  42. Wikidata: Islands of Bali There are 28 official islands of

    Bali Province, in Direktori Pulau-Pulau Kecil Indonesia
  43. Wikidata has 26 28 islands in Bali Lorem ipsum dolor

    sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labor. 100%