25:["$","title",null,{"children":"live-edit visual of SPARQL query structure | Ruben THOMAS | Observable"}] 49:T7e7,default_query = ` PREFIX wd: PREFIX wdt: PREFIX wikibase: PREFIX p: PREFIX ps: PREFIX pq: PREFIX rdfs: PREFIX bd: PREFIX schema: SELECT ?item (SAMPLE(?itemLabel) AS ?itemLabel) (SAMPLE(?itemDescription) AS ?itemDescription) (SAMPLE(?pic) AS ?pic) (SAMPLE(?taxonname) AS ?taxonname) (SAMPLE(?taxoncommon) AS ?taxoncommon) (SAMPLE(?instance_of) AS ?instance_of) (SAMPLE(?article) AS ?article) (SAMPLE(?ncbi_on_wikidata) as ?ncbi_on_wikidata) (GROUP_CONCAT(DISTINCT ?country; SEPARATOR=", ") AS ?countries) (GROUP_CONCAT(DISTINCT ?countryLabel; SEPARATOR=", ") AS ?countryLabels) WHERE { # VALUES ?item { # wd:Q734870 #wd:Q4951627 #wd:Q95600208 #wd:Q95623161 # } OPTIONAL { ?item wdt:P18 ?pic. } OPTIONAL { ?item wdt:P225 ?taxonname. } OPTIONAL { ?item wdt:P17 ?country. } OPTIONAL { ?item wdt:P31 ?instance_of. } OPTIONAL { ?item wdt:P17 ?country. } OPTIONAL { ?item wdt:P685 ?ncbi_on_wikidata. } #look for english wikipedia article OPTIONAL { ?article schema:about ?item . ?article schema:inLanguage "en" . ?article schema:isPartOf . } # follow the instancesOf "organisms known by a particular common name" for more taxons OPTIONAL { ?item p:P31 ?statement. ?statement ps:P31 wd:Q55983715. ?statement pq:P642 ?of. ?of wdt:P1843 ?taxoncommon. FILTER((LANG(?taxoncommon)) = "en") ?of wdt:P225 ?taxonname. } OPTIONAL { ?item wdt:P1843 ?taxoncommon. FILTER (lang(?taxoncommon) = 'en') } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?item rdfs:label ?itemLabel. ?item rdfs:description ?itemDescription. ?country rdfs:label ?countryLabel. } } GROUP BY ?item`4a:T135c,/* these are dependencies that were built in pyodide docker for kglab in case they could not be installed as wheel packages */ otherKglabDependencies = Promise.all([ await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/CLAPACK.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/asttokens.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/chocolate.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/colorama.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/csvwlib.js" ), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/cycler.js" // ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/dataclasses.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/decorator.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/executing.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/fsspec.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/gcsfs.js" ), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/gensim.js" // ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/html5lib.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/icecream.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/isodate.js" ), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/joblib.js" // ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/keepalive.js" ), // await pyodide.loadPackage("https://thadk.net/pyodide_packages/pyodide_18_1/kglab.js"), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/kiwisolver.js" // ), // await pyodide.loadPackage("https://thadk.net/pyodide_packages/pyodide_18_1/matplotlib.js"), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/micropip.js" // ), // await pyodide.loadPackage("https://thadk.net/pyodide_packages/pyodide_18_1/networkx.js"), // await pyodide.loadPackage("https://thadk.net/pyodide_packages/pyodide_18_1/numpy.js"), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/owlrl.js" ), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/packaging.js" // ), // await pyodide.loadPackage("https://thadk.net/pyodide_packages/pyodide_18_1/pandas.js"), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/patsy.js" // ), // await pyodide.loadPackage("https://thadk.net/pyodide_packages/pyodide_18_1/pillow.js"), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/pygments.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/pylev.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/pynvml.js" ), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/pyparsing.js" // ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/pyshacl.js" ), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/python-dateutil.js" // ), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/pytz.js" // ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/rdflib.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/requests.js" ), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/scikit-learn.js" // ), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/scipy.js" // ), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/setuptools.js" // ), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/six.js" // ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/smart_open.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/sparqlwrapper.js" ), // await pyodide.loadPackage( // "https://thadk.net/pyodide_packages/pyodide_18_1/statsmodels.js" // ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/tqdm.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/urlpath.js" ), await pyodide.loadPackage( "https://thadk.net/pyodide_packages/pyodide_18_1/webencodings.js" ) ])4b:T5c6,// Micropip dependencies are simple "wheel" python packages that do not need to be built in any special way. You just have to use micropip with a PyPi wheel URL or package name. micropipDependenciesPy = py`import micropip, os # Github Pages does not succeed, perhaps mime types, only raw github. micropip.install("https://files.pythonhosted.org/packages/7c/f7/280bf4a3830cf6723535096342785aa3a9a15251b188b6bc592da2dda53f/pslpython-2.2.2-py3-none-any.whl") micropip.install("https://files.pythonhosted.org/packages/af/f4/524415c0744552cce7d8bf3669af78e8a069514405ea4fcbd0cc44733744/urllib3-1.26.7-py2.py3-none-any.whl") micropip.install("https://files.pythonhosted.org/packages/47/84/b06f6729fac8108c5fa3e13cde19b0b3de66ba5538c325496dbe39f5ff8e/charset_normalizer-2.0.9-py3-none-any.whl") micropip.install("https://files.pythonhosted.org/packages/37/45/946c02767aabb873146011e665728b680884cd8fe70dde973c640e45b775/certifi-2021.10.8-py2.py3-none-any.whl") micropip.install("https://files.pythonhosted.org/packages/04/a2/d918dcd22354d8958fe113e1a3630137e0fc8b44859ade3063982eacd2a4/idna-3.3-py3-none-any.whl") micropip.install("language-tags") micropip.install("uritemplate") #micropip.install("https://files.pythonhosted.org/packages/07/d1/e87844ec86e96df7364f21af2263ad6030c0d727660ae89935c7af56a540/pyvis-0.1.9-py3-none-any.whl") micropip.install("https://thadk.net/pyodide_packages/pyodide_18_1/pyvis-0.1.9-py2.py3-none-any.whl") os.listdir("/lib/python3.9/site-packages/") `4c:[{"id":"ece1832016566b42c8d77e58bf6acd80bbfd1635e2fb7c60c98e4d16e8b26c6569820229fec0c87e1505451c02262727c7f20032c3bdd12cc610aa3a5a93e0f3","href":"https://static.observableusercontent.com/files/ece1832016566b42c8d77e58bf6acd80bbfd1635e2fb7c60c98e4d16e8b26c6569820229fec0c87e1505451c02262727c7f20032c3bdd12cc610aa3a5a93e0f3","name":"kglab-main.zip","type":"application/zip","lastModified":1682718937143.189,"size":17569732}] 29:{"id":"ef7b373ddf709bd1","slug":null,"title":"live-edit visual of SPARQL query structure","thumbnail":"269ba2cfb86c6a89d798f7eb00d2898de0091e64a5a7dc26b921c9b2547d2bf8","access_level":"public","create_time":"$D2023-04-28T21:55:37.143Z","update_time":"$D2023-04-28T21:55:37.143Z","view_time":null,"first_public_time":"$D2023-04-28T21:55:37.143Z","has_unpublished_edits":null,"fork":{"id":"eb85dea7acb1f15e","slug":"live-edit-visual-of-sparql-query-structure","title":"live-edit visual of SPARQL query structure","owner":{"id":"5cd4a42aead2029f","login":"thadk","name":"Thad Kerosky"}},"stars":0,"starred":false,"owner":{"type":"team","id":"0d47fa586209c7b5","login":"leblocdunet","name":"Ruben THOMAS","avatar_url":"https://avatars-next.observableusercontent.com/27010161af0e8a2a650f23b03c06b7fe2f4adc9ad81267e72566a57213e79d95","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":288,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"7503eedf9ef4cf63","login":"leblocdunet","name":"Ruben THOMAS","avatar_url":"https://avatars-next.observableusercontent.com/27010161af0e8a2a650f23b03c06b7fe2f4adc9ad81267e72566a57213e79d95","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"7503eedf9ef4cf63","login":"leblocdunet","name":"Ruben THOMAS","avatar_url":"https://avatars-next.observableusercontent.com/27010161af0e8a2a650f23b03c06b7fe2f4adc9ad81267e72566a57213e79d95","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"live-edit visual of SPARQL query structure","cells":[{"id":0,"value":"# live-edit visual of SPARQL query structure\n- See [limitations](https://observablehq.com/@thadk/kglab-in-observablehq?collection=@thadk/kglab-js-alpha-example) such as 60+ second initial load time. [ex4_0](https://observablehq.com/@thadk/ex4_0-running-sparql-queries?collection=@thadk/kglab-js-alpha-example#cell-765) has it in context.\n- TODO: add a debounce to speed up text edits and only redraw every second or so. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":198,"value":"queryEditor = view`\n\n\n\n

\n ${viewof y}

\n${pyvisSidepanel}\n

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":244,"value":"pyvisSidepanel = {\n try {\n return await pyVisFrame(\n await py`\nsparql = ${y}\npyvis_graph = ${kg}.visualize_query(sparql, notebook=True)\npyvis_graph.force_atlas_2based()\npyvis_graph.show(\"tmp.yasqe.html\")`\n );\n } catch (error) {\n return await pyVisFrame(\n await py`\nVIS_STYLE = {\n \"wtm\": {\n \"color\": \"orange\",\n \"size\": 40,\n },\n \"ind\":{\n \"color\": \"blue\",\n \"size\": 30,\n },\n}\nsubgraph = ${kglab}.SubgraphTensor(${kg})\npyvis_graph = subgraph.build_pyvis_graph(notebook=True, style=VIS_STYLE)\npyvis_graph.show(\"tmp.yasqe_fail.html\")\n`\n );\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":249,"value":"viewof preloadFilename = Inputs.select(\n kgzip.filenames.filter(\n (a) => a.indexOf(\"kglab-main/dat\") !== -1 && a.indexOf(\".ttl\") !== -1\n ),\n { label: \"pick an example Turtle (ttl) dataset\" }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":200,"value":"viewof y = {\n /* set default value */\n // Yasgui.Yasqe.defaults.value = sparql2;\n /* crib from https://observablehq.com/@mootari/codemirror */\n const view = document.createElement(\"div\");\n view.appendChild(\n html`