2e:null 2f:["$","title",null,{"children":"OpenEI SPARQL tool: explore predicate/object pairs for a given value based on the Wiki page URL and visualize as a hierarchy / tidy tree | Damien LIEBER | Observable"}] 34:[] 32:{"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","thumbnail":"4dcb54f5050c4ff6c0d5cda41db369356f3f31b07e6e098be1710b76ab19998f","access_level":"public","create_time":"$D2020-07-21T16:19:58.656Z","update_time":"$D2020-07-24T22:02:43.778Z","view_time":null,"first_public_time":"$D2020-07-21T19:45:50.198Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"f1833863e1ef8994","login":"damienlieber","name":"Damien LIEBER","avatar_url":"https://avatars-next.observableusercontent.com/0e1f2b0778dcdd3cb2dd2365e32c6c023e6371c8c102eab5dcf2b22b76cb3064","tier":"starter_2024"},"version":284,"publish_version":284,"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":3,"collection":{"id":"cf78157daa342813","slug":"sparql","title":"SPARQL","owner":{"id":"f1833863e1ef8994","login":"damienlieber","name":"Damien LIEBER"}},"type":"notebook","body":{"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","cells":[{"id":0,"value":"md`# OpenEI SPARQL tool: explore predicate/object pairs for a given value based on the Wiki page URL and visualize as a hierarchy / tidy tree`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"md`## Tidy tree visualization`","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 wiki_URL = text({\n title: \"Paste here the Wiki URL from OpenEI\",\n placeholder: \"https://openei.org/wiki/Consolidated_Edison_Co-NY_Inc\",\n value: \"https://openei.org/wiki/Consolidated_Edison_Co-NY_Inc\",\n description:\n \"Allow up to 30s to refresh. A grey band on the side of a cell means it is still loading.
Test with https://openei.org/wiki/Consolidated_Edison_Co-NY_Inc as subject or object;
Test with https://openei.org/wiki/Property:EIA/861/NercLocation as property\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"viewof triple_type = radio({\n title: 'Type:',\n options: [\n { label: 'Subject', value: 'subject' },\n { label: 'Predicate/Property', value: 'predicate' },\n { label: 'Object', value: 'object' }\n ],\n value: 'subject'\n})","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`## Write query and retrieve results as JSON`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"md`Access query in a SPARQL editor here: https://api.triplydb.com/s/gc3IArGHy`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"SPARQL_endpoint = 'https://openei.org/sparql'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"SPARQL_query = `PREFIX ref: \nPREFIX rdf: \nPREFIX rdfs: \nPREFIX swivt: \nPREFIX xsd: \nPREFIX resource: \nPREFIX category: \nPREFIX property: \n\nSELECT distinct ?subjectLabel ?subject ?predicate ?object ?subjectDescription \nFROM \nWHERE {\n #Input below between the <> the Wiki URL:\n ?` +\n triple_type +\n ` swivt:page <` +\n wiki_URL +\n `>.\n \n #Fin all predicates and objects\n ?subject ?predicate ?object\n \n #Optionally, select labels and descriptions\n OPTIONAL { ?subject rdfs:label ?subjectLabel}\n OPTIONAL { ?subject rdfs:comment ?subjectDescription}\n }\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"md`## Transform response into hierarchy`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":95,"value":"hierarchySteps = {\n let hierarchySteps;\n if (triple_type == 'object') {\n hierarchySteps = ['object', 'predicate', 'subject'];\n } else if (triple_type == 'predicate') {\n hierarchySteps = ['object', 'subject'];\n } else {\n hierarchySteps = ['subject', 'predicate', 'object'];\n }\n return hierarchySteps;\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":270,"value":"NRowsLimit = 0","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":76,"value":"md`## Import notebooks`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":269,"value":"import { tidy_tree, hierarchical_data } with {\n SPARQL_endpoint,\n SPARQL_query,\n hierarchySteps,\n NRowsLimit,\n valueKeyName\n} from '@damienlieber/sparql-select-query-tool-for-any-rdf-knowledge-graphs'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"import { text, radio } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 33:"$32:body"