readme.sparqlbook

[
  {
    "kind": 1,
    "language": "markdown",
    "value": "SPARQL Notebook\n=======\n\nCount events that are exported from Artsdata to La Vitrine.",
    "metadata": {}
  },
  {
    "kind": 2,
    "language": "sparql",
    "value": "# [endpoint=http://kg.artsdata.ca/query]\n\nPREFIX schema: <http://schema.org/>\n\nselect (count(?id) as ?count )\n\nwhere {\n ?id a schema:Event .\n   values ?catalog {\n    <http://kg.artsdata.ca/culture-creates/huginn/derived-grandtheatre-qc-ca>\n    <http://kg.artsdata.ca/culture-creates/footlight/placedesarts-com>\n    <http://kg.artsdata.ca/resource/dia-logGraphs>\n    <http://kg.artsdata.ca/culture-creates/footlight/hector-charland-com>\n    <http://kg.artsdata.ca/culture-creates/footlight/theatredumarais-com>\n   }\n   ?catalog schema:hasPart ?graph .\n  graph ?graph {\n    ?id a ?type ;\n      schema:name ?name ; \n      schema:startDate ?startDate .\n    OPTIONAL {\n      ?id schema:endDate ?endDate .\n    }\n    filter(not exists {\n        ?id schema:subEvent ?superEvent .\n    })\n  }\n   filter(?startDate >= now() || ?endDate >= now())\n  \n}  ",
    "metadata": {}
  },
  {
    "kind": 1,
    "language": "markdown",
    "value": "How to trace missing data\n================\n\nTo trace an individual event:\n\n1. Load Source Webpage data\n\n   Start by looking at the source webpage for the event.\n   \n   Use this linter http://linter.structured-data.org/. You can copy/paste the url or pass the url using `&url=. \n   \n   Here is an example linted webpage from Grand Theatre website for the event: \n   [OSQ - Clemens Schuldt entre en scène](http://linter.structured-data.org/?url=https://grandtheatre.qc.ca/programmation/osq-clemens-schuldt-entre-en-scene/)\n\n2. Check the URI in Artsdata with this SPARQL",
    "metadata": {}
  },
  {
    "kind": 2,
    "language": "sparql",
    "value": "# [endpoint=http://kg.artsdata.ca/query]\n\nselect * where {\n <https://grandtheatre.qc.ca/programmation/osq-clemens-schuldt-entre-en-scene/osq-clemens-schuldt-entre-en-scene-2023-09-21-00-00>\n  ?p ?o .\n}",
    "metadata": {}
  }
]