2d:null 2e:["$","title",null,{"children":"Material Characterization View | Michael Deagen | Observable"}] 33:[] 31:{"id":"6d450b602c1ac3fe","slug":"material-characterization-view","title":"Material Characterization View","thumbnail":"5477996aaa870baeaab7fd176ea68c0a6773b6867eae02b06644fdeb39c3bea1","access_level":"public","create_time":"$D2021-05-04T20:13:08.701Z","update_time":"$D2021-07-23T15:33:10.678Z","view_time":null,"first_public_time":"$D2021-05-04T20:59:50.651Z","has_unpublished_edits":null,"fork":{"id":"646cafa322d3eb9f","slug":"material-property-view","title":"Material Property View","owner":{"id":"5ca8a3812ea4a326","login":"mdeagen","name":"Michael Deagen"}},"stars":0,"starred":false,"owner":{"type":"team","id":"5ca8a3812ea4a326","login":"mdeagen","name":"Michael Deagen","avatar_url":"https://avatars-next.observableusercontent.com/0b8e876e2eac1058faa6c1a2624346f3e72350b8a7e6c9acaec6a9ad920b0476","tier":"starter_2024"},"version":363,"publish_version":363,"role":null,"authored":false,"authors":[{"type":"individual","id":"d3611c0325cb99e9","login":"mdeagen","name":"Michael Deagen","avatar_url":"https://avatars-next.observableusercontent.com/0b8e876e2eac1058faa6c1a2624346f3e72350b8a7e6c9acaec6a9ad920b0476","tier":null}],"members":[{"type":"individual","id":"d3611c0325cb99e9","login":"mdeagen","name":"Michael Deagen","avatar_url":"https://avatars-next.observableusercontent.com/0b8e876e2eac1058faa6c1a2624346f3e72350b8a7e6c9acaec6a9ad920b0476","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Material Characterization View","cells":[{"id":0,"value":"md`# Material Characterization View\n\nThis prototype **characterization view** for materials characterization methods in the MaterialsMine knowledge graph provides an example of a landing page for documentation about a particular characterization method.\n\nThe URL of this page could be the URI of the characterization class (e.g., *http://materialsmine.org/ns/DifferentialScanningCalorimetry*) or the page could be stored as a separate depiction/description of the resource.\n\nTo demonstrate **interoperability**, data are automatically populated from the MaterialsMine knowledge graph and external data resources such as [dbpedia](https://www.dbpedia.org/), [PubChem](https://pubchem.ncbi.nlm.nih.gov/), and [Wikidata](https://www.wikidata.org/wiki/Wikidata:Main_Page).\n\nTo see how it works, **select a characterization method** from the drop-down list.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"viewof characterization = Select(result00,{label: \"Select method:\", format: x => x.Label, value: result00.find(t => t.Label )})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":152,"value":"md`# *${characterization.Label}*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":184,"value":"md`## MaterialsMine Knowledge Graph`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":299,"value":"md`### Definition (MaterialsMine)\n\n${result06[0].definition}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":208,"value":"md`### Curated Research Articles\n\nThere are currently **${result05[0].DOI_count}** research articles in the MaterialsMine knowledge graph which contain *${characterization.Label}* as a reported attribute or property.\n\nEquipment linked to these research articles is listed below.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"Table(result04)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":325,"value":"md`## External Information`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"md`### Abstract (from DBpedia)\n\n${result02[0].abstract}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":175,"value":"md`### Thumbnail (from DBpedia)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"md`#### *Wikipedia* link (via *DBpedia* rdfs:label match)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"md`${result01[0].wikipage}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":120,"value":"md`#### *Wikidata* resource link (via *Wikidata* schema:about, schema:name)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":192,"value":"md`${result03[0].wikidataPage}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":155,"value":"md`#### *DBpedia resource link*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":196,"value":"md`${result01[0].dbp_resource}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"md`---\n\n## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"MM_SPARQL_endpoint = \"https://materialsmine.org/wi/sparql\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"dbp_SPARQL_endpoint = \"https://dbpedia.org/sparql\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":255,"value":"wd_SPARQL_endpoint = \"https://query.wikidata.org/sparql\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"md`### Libraries`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"import { querySPARQLendpoint } from '@mdeagen/sparql-select-query-function'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"import { Table, Select } from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"md`### Query Results`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"result00 = querySPARQLendpoint(MM_SPARQL_endpoint, query00_MM)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"result01 = querySPARQLendpoint(dbp_SPARQL_endpoint, query01_dbp)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"result02 = querySPARQLendpoint(dbp_SPARQL_endpoint, query02_dbp)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"result03 = querySPARQLendpoint(wd_SPARQL_endpoint, query03_wd)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":230,"value":"result04 = querySPARQLendpoint(MM_SPARQL_endpoint, query04_MM)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"result05 = querySPARQLendpoint(MM_SPARQL_endpoint, query05_MM)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":293,"value":"result06 = querySPARQLendpoint(MM_SPARQL_endpoint, query06_MM)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"md`### SPARQL Queries`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"query00_MM = `PREFIX rdfs: \nPREFIX dct: \nPREFIX prov: \nPREFIX nm: \nSELECT DISTINCT ?CharacterizationTypeURI ?Label WHERE {\n ?assertion prov:wasQuotedFrom [ a dct:BibliographicResource ] ;\n prov:wasGeneratedBy ?characterization .\n ?characterization a ?CharacterizationTypeURI ;\n prov:used [ a ?EquipmentURI ] .\n ?CharacterizationTypeURI rdfs:label ?Label .\n FILTER(!REGEX(STR(?Label),\"measuring\"))\n FILTER(!REGEX(STR(?Label),\"nan\"))\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"query01_dbp = `PREFIX foaf: \nselect distinct * where {\n?wikipage foaf:primaryTopic ?dbp_resource .\n?dbp_resource rdfs:label \"` + characterization.Label + `\"@en\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":164,"value":"query02_dbp = `PREFIX foaf: \nPREFIX dbo: \nselect distinct * where {\nOPTIONAL{\n<` + result01[0].dbp_resource + `> dbo:abstract ?abstract ;\ndbo:thumbnail ?thumbnail\nFILTER(LANG(?abstract) = 'en')\n}\nOPTIONAL{\n<` + result01[0].dbp_resource + `> dbo:wikiPageRedirects ?primaryPage .\n?primaryPage dbo:abstract ?abstract ;\ndbo:thumbnail ?thumbnail\nFILTER(LANG(?abstract) = 'en')\n}\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"query03_wd = `SELECT * WHERE {\n?wikipediaPage schema:about ?wikidataPage ;\n schema:name \"` + characterization.Label + `\"@en\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":227,"value":"query04_MM = `PREFIX rdfs: \nPREFIX dct: \nPREFIX prov: \nPREFIX nm: \nSELECT DISTINCT ?EquipmentURI (COUNT(DISTINCT ?DOI) AS ?DOI_count) (GROUP_CONCAT(DISTINCT ?DOI; SEPARATOR=\"; \") AS ?DOIs) WHERE {\n ?assertion prov:wasQuotedFrom ?doi ;\n prov:wasGeneratedBy ?characterization .\n ?doi a dct:BibliographicResource .\n ?characterization a ` + characterization.CharacterizationTypeURI + ` ;\n prov:used [ a ?EquipmentURI ] .\n BIND(REPLACE(STR(?doi), \"http://dx.doi.org/\", \"\") AS ?DOI)\n FILTER(REGEX(STR(?EquipmentURI), \"materialsmine\"))\n FILTER(!REGEX(STR(?doi),\"unpublished\"))\n} GROUP BY ?EquipmentURI\nORDER BY DESC (?DOI_count)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":275,"value":"query05_MM = `PREFIX rdfs: \nPREFIX dct: \nPREFIX prov: \nPREFIX nm: \nSELECT DISTINCT (COUNT(DISTINCT ?doi) AS ?DOI_count) WHERE {\n ?assertion prov:wasQuotedFrom ?doi ;\n prov:wasGeneratedBy ?characterization .\n ?doi a dct:BibliographicResource .\n ?characterization a ` + characterization.CharacterizationTypeURI + ` ;\n prov:used [ a ?EquipmentURI ] .\n FILTER(REGEX(STR(?EquipmentURI), \"materialsmine\"))\n FILTER(!REGEX(STR(?doi),\"unpublished\"))\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":291,"value":"query06_MM = `PREFIX skos: \nPREFIX nm: \nSELECT DISTINCT * WHERE {\n ` + characterization.CharacterizationTypeURI + ` skos:definition ?definition\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 32:"$31:body"