45:["$","title",null,{"children":"SPARQL Queries for Cross-referencing and Data Cleanup | getty | Observable"}] 4d:[] 49:{"id":"515b260f027b1e40","slug":"sparql-queries-for-data-cleanup","title":"SPARQL Queries for Cross-referencing and Data Cleanup","thumbnail":"9e89356678723445b9d26217bb2b7ad8f56c556641696cf40fe0f7c5eede77e7","access_level":"public","create_time":"$D2022-03-31T17:28:24.302Z","update_time":"$D2025-08-06T14:26:41.781Z","view_time":null,"first_public_time":"$D2022-03-31T18:43:57.704Z","has_unpublished_edits":null,"fork":{"id":"ee9e4fb45c009de1","slug":"search-table","title":"Search + Table","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":0,"starred":false,"owner":{"type":"team","id":"869bed2618e3e3dc","login":"getty","name":"getty","avatar_url":"https://avatars-next.observableusercontent.com/05507b4cccf3e22249c6b267641707da332180adb28f29ccf00a56ffbde7947f","tier":"pro","bio":"","followed_by_you":false,"follows_you":false},"version":181,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"24ebb36c5101724a","login":"garciagregg","name":"Gregg Garcia","avatar_url":"https://avatars-next.observableusercontent.com/397d65fc4968ead11aa2b436571cebde13cccdac0952fac1581c59e25cf98bb6","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"24ebb36c5101724a","login":"garciagregg","name":"Gregg Garcia","avatar_url":"https://avatars-next.observableusercontent.com/397d65fc4968ead11aa2b436571cebde13cccdac0952fac1581c59e25cf98bb6","tier":null,"role":"editor"},{"type":"team","id":"869bed2618e3e3dc","login":"getty","name":"getty","avatar_url":"https://avatars-next.observableusercontent.com/05507b4cccf3e22249c6b267641707da332180adb28f29ccf00a56ffbde7947f","tier":"pro","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"titling":"auto","title":"SPARQL Queries for Cross-referencing and Data Cleanup","cells":[{"id":4,"value":"# SPARQL Queries for Cross-referencing and Data Cleanup","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":70,"value":"## Query 1: Find all Museum Object Records with Visual Items and No Manifest Link","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":20,"value":"sparql_query1 = `\nPREFIX crm: \nSELECT distinct ?object WHERE {\n graph ?object {\n ?object a crm:E22_Human-Made_Object .\n ?object crm:P65_shows_visual_item ?vi .\n ?vi crm:P2_has_type .\n FILTER NOT EXISTS { \n ?object crm:P129i_is_subject_of ?so .\n ?so crm:P2_has_type .\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":7,"value":"{\n let config = {\n header: {\n object: \"Object LOD URL\"\n },\n format: {\n object: (x) => html`${x}`\n }\n };\n return Inputs.table(missing_manifests1, config);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":167,"value":"sparql_query = `\nPREFIX crm: \nSELECT distinct ?object WHERE {\n graph ?object {\n ?object a crm:E22_Human-Made_Object .\n FILTER NOT EXISTS {\n ?object crm:P65_shows_visual_item ?vi .\n ?vi crm:P2_has_type .\n }\n ?object crm:P129i_is_subject_of ?so .\n ?so crm:P2_has_type .\n }\n}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":170,"value":"{\n let config = {\n header: {\n object: \"Object LOD URL\"\n },\n format: {\n object: (x) => html`${x}`\n }\n };\n return Inputs.table(missing_manifests, config);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"## Query 2: Get Object Records with TMS ID that Reference a Media LOD Record ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":95,"value":"sparql_query2 = `\nPREFIX crm: \nSELECT ?tmsid ?object_lod WHERE {\n graph ?object_lod {\n ?sub ?pred .\n ?object_lod crm:P1_is_identified_by ?idb.\n ?idb crm:P2_has_type .\n ?idb crm:P190_has_symbolic_content ?tmsid\n }\n}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"viewof media_url = Inputs.text({\n label: \"URL\",\n value:\n \"https://data.getty.edu/media/image/1de10be5-23c5-56c7-b3e1-3a434c04d7d9\",\n width: \"1\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"{\n let config = {\n header: {\n object_lod: \"Object LOD URL\",\n tmsid: \"TMS ID\"\n },\n width: {\n object_lod: 600\n },\n format: {\n object_lod: (x) => html`${x}`\n }\n };\n return Inputs.table(objects_with_media, config);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"### Helper functions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":48,"value":"import { SPARQLQueryDispatcher } from \"@lukesmurray/wikidata-sparql-helpers\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"queryDispatcher = new SPARQLQueryDispatcher(\"https://data.getty.edu/museum/collection/sparql\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"missing_manifests = queryDispatcher.query(sparql_query)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"missing_manifests1 = queryDispatcher.query(sparql_query1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"objects_with_media = queryDispatcher.query(\n sparql_query2.replace(\"MEDIA_URL\", media_url)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4d","stdlib":"1"}} 44:null