2e:null 2f:["$","title",null,{"children":"SPARQL SELECT Query Tool for any RDF / Knowledge Graphs | Damien LIEBER | Observable"}] 34:[] 32:{"id":"afe26e8e7bdc6bb2","slug":"sparql-select-query-tool-for-any-rdf-knowledge-graphs","title":"SPARQL SELECT Query Tool for any RDF / Knowledge Graphs","thumbnail":"3e611bbae0529a26cf21d902947cccc495fa1acdb73e6a2f576eba8700672c98","access_level":"public","create_time":"$D2020-07-24T14:36:51.292Z","update_time":"$D2020-07-30T22:50:14.859Z","view_time":null,"first_public_time":"$D2020-07-24T16:41:25.042Z","has_unpublished_edits":null,"fork":{"id":"b8395bdbc9e78a31","slug":"openei-sparql-tool-find-predicate-object-pairs-for-a-given-v","title":"OpenEI SPARQL tool: explore predicate/object pairs for a given value based on the Wiki page URL and visualize as a hierarchy / tidy tree","owner":{"id":"f1833863e1ef8994","login":"damienlieber","name":"Damien LIEBER"}},"stars":2,"starred":false,"owner":{"type":"team","id":"f1833863e1ef8994","login":"damienlieber","name":"Damien LIEBER","avatar_url":"https://avatars-next.observableusercontent.com/0e1f2b0778dcdd3cb2dd2365e32c6c023e6371c8c102eab5dcf2b22b76cb3064","tier":"starter_2024"},"version":544,"publish_version":544,"role":null,"authored":false,"authors":[{"type":"individual","id":"c095b1fa4a790aee","login":"damienlieber","name":"Damien LIEBER","avatar_url":"https://avatars-next.observableusercontent.com/0e1f2b0778dcdd3cb2dd2365e32c6c023e6371c8c102eab5dcf2b22b76cb3064","tier":null}],"members":[{"type":"individual","id":"c095b1fa4a790aee","login":"damienlieber","name":"Damien LIEBER","avatar_url":"https://avatars-next.observableusercontent.com/0e1f2b0778dcdd3cb2dd2365e32c6c023e6371c8c102eab5dcf2b22b76cb3064","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":6,"collection":{"id":"a61ce6724bc2ac1f","slug":"data-processing","title":"Data processing","owner":{"id":"f1833863e1ef8994","login":"damienlieber","name":"Damien LIEBER"}},"type":"notebook","body":{"title":"SPARQL SELECT Query Tool for any RDF / Knowledge Graphs","cells":[{"id":0,"value":"md`# SPARQL SELECT Query Tool for any RDF / Knowledge Graphs`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":476,"value":"md`**Use in your notebook with:**\n~~~js\nimport { query_results_extract } \nwith {SPARQL_endpoint, SPARQL_query}\nfrom '@damienlieber/sparql-select-query-tool-for-any-rdf-knowledge-graphs'\n~~~\nor\n~~~js\nimport { tidy_tree, hierarchical_data } \nwith {SPARQL_endpoint, SPARQL_query, hierarchySteps, NRowsLimit, valueKeyName}\nfrom '@damienlieber/sparql-select-query-tool-for-any-rdf-knowledge-graphs'\n~~~\nor\n~~~js\nimport { json_query_results, prefixes } \nwith {SPARQL_endpoint, SPARQL_query}\nfrom '@damienlieber/sparql-select-query-tool-for-any-rdf-knowledge-graphs'\n~~~\n*Note: if NRowsLimit = 0 then all rows are included in the hierarchy*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":269,"value":"md`## Table View`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":312,"value":"table(query_results_extract)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"md`## Tidy Tree View`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"viewof NRowsLimit = rangeSlider({\n format: 'd',\n title:\n 'Select which binding row indexes to display in Tidy Tree view (total: ' +\n String(json_query_results.results.bindings.length) +\n ')',\n description:\n 'To avoid huge tidy trees and long data processing to make it a hierarchy. E.g. rows 10-20',\n min: 1,\n max: json_query_results.results.bindings.length,\n value: [10, 20]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":432,"value":"md`Select below and drag and drop variables to include/arrange in tidy tree hierarchy (default is first three variables in SELECT clause):`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":457,"value":"viewof hierarchyStepsSelect = selectOrder(json_query_results.head.vars)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"tidy_tree","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":145,"value":"md`## User input:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"viewof SPARQL_endpoint = text({\n title: \"Paste here the SPARQL enpoint URL\",\n placeholder: \"https://query.wikidata.org/sparql\",\n value: \"https://query.wikidata.org/sparql\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":278,"value":"viewof SPARQL_query = textarea({\n title: \"SPARQL query\",\n placeholder: \"Insert your SPARQL query here...\",\n width: \"100%\",\n rows: 20,\n submit: \"Run query\",\n value: defaultQuery\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"md`*Note: write queries directly in the SPARQL editor [Yasgui by Triply](https://yasgui.triply.cc/#) and copy-paste above when ready*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"md`# Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"md`## Process query and retrieve results as JSON`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"proxy_URL = 'https://cors-anywhere.herokuapp.com/'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"URL_withQuery = SPARQL_endpoint +\n `?query=${encodeURIComponent(SPARQL_query)}` +\n `&output=json`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"json_query_results = fetch(proxy_URL + URL_withQuery, {\n headers: { accept: \"application/sparql-results+json\" }\n}).then(response => response.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":300,"value":"query_results_extract = parseSPARQL(json_query_results, prefixes)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":437,"value":"md`## Parse prefixes for clearer, abbreviated display`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"prefixes = parseSPARQLPrefixes(SPARQL_query)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"md`## Transform response into hierarchy for Tidy Tree`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":403,"value":"json_query_results_NrowsLimit = {\n let smallerBindingsSet = {};\n smallerBindingsSet.head = json_query_results.head;\n smallerBindingsSet.results = {};\n if (NRowsLimit === 0) {\n smallerBindingsSet.results.bindings = json_query_results.results.bindings;\n } else {\n smallerBindingsSet.results.bindings = json_query_results.results.bindings.slice(\n NRowsLimit[0] - 1,\n NRowsLimit[1] - 1\n );\n }\n return smallerBindingsSet;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":95,"value":"hierarchySteps = {\n if (hierarchyStepsSelect.length > 0) {\n return Object.values(hierarchyStepsSelect);\n } else {\n return json_query_results.head.vars.slice(0, 3);\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":243,"value":"valueKeyName = ''","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":250,"value":"hierarchical_data","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":339,"value":"md`## Misc.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":448,"value":"md`Access default query in the Wikidata editor [here](https://query.wikidata.org/#%23Properties%20grouped%20by%20their%20parent%20property%0A%23TODO%3A%20should%20display%20links%20and%20numeric%20ids%0A%23defaultView%3ATree%0ASELECT%20%3Fproperty2%20%3Fproperty2Label%20%3Fproperty1%20%3Fproperty1Label%20WHERE%20%7B%0A%20%20%3Fproperty1%20rdf%3Atype%20wikibase%3AProperty.%20%23not%20replaceable%20with%20wikibase%3AItem%2C%20wikibase%3AStatement%2C%20wikibase%3AReference%20at%20WDQS%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23https%3A%2F%2Fwww.mediawiki.org%2Fwiki%2FWikibase%2FIndexing%2FRDF_Dump_Format%23WDQS_data_differences%0A%20%20%3Fproperty1%20wdt%3AP1647%20%3Fproperty2.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D) (obtained from Examples folder)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":285,"value":"defaultQuery = `PREFIX wd: \\nPREFIX wdt: \\nPREFIX wikibase: \\nPREFIX p: \\nPREFIX ps: \\nPREFIX pq: \\nPREFIX rdfs: \\nPREFIX bd: \\n\\nSELECT ?property2 ?property2Label ?property1 ?property1Label\\nWHERE {\n?property1 rdf:type wikibase:Property.\\n?property1 wdt:P1647 ?property2.\\nSERVICE wikibase:label { bd:serviceParam wikibase:language \"[AUTO_LANGUAGE],en\". }\\n}\\nORDER BY ASC(?property2)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"md`## Import notebooks`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"import {\n parseSPARQL,\n parseSPARQLPrefixes\n} from '@damienlieber/sparql-parsing-function'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"import { chart as tidy_tree } with {\n hierarchical_data as data\n} from '@d3/tidy-tree'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"import { hierarchical_data } with {\n json_query_results_NrowsLimit as json_query_results,\n prefixes,\n hierarchySteps\n} from \"@damienlieber/process-sparql-query-results-into-subject-predicate-objec\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"import { text, textarea } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":307,"value":"import { table } from \"@tmcw/tables\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"import { rangeSlider } from \"@mootari/range-slider\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":454,"value":"import { selectOrder } from '@jashkenas/select-order-input'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":530,"value":"md`## Work in progress\n### Add color coding to editor\nInspired from https://observablehq.com/@tmcw/codemirror-inside-of-observable\nHelp needed!`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":511,"value":"CodeMirror = require('https://unpkg.com/codemirror/lib/codemirror').then(\n CodeMirror => {\n // this is a bit tricky: we don't just require('codemirror') above, because\n // the sparql mode requires a slightly different path (codemirror instead of codemirror.js)\n // and we need the mode to modify the right instance\n return require('https://unpkg.com/codemirror/mode/sparql/sparql.js').then(\n () => CodeMirror\n );\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":505,"value":"div = {\n let div = DOM.element('div');\n div.style.border = '1px solid #000';\n div.style.height = '500px';\n return div;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":517,"value":"editor = {\n while (div.firstChild) {\n div.removeChild(div.firstChild);\n }\n let editor = CodeMirror(div, {\n mode: \"application/sparql-query\"\n });\n editor.setValue(defaultQuery);\n editor.setSize(width - 20, 500);\n return editor.getValue();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":509,"value":"editor","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":520,"value":"stylesheet = html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 33:"$32:body"