Project:SPARQL/examples: Difference between revisions

Line 751: Line 751:
<sparql tryit="1">
<sparql tryit="1">
#title:ppa buckets (revised February 2024)
#title:ppa buckets (revised February 2024)
# broad PPA grouping categories to use for overviews and analysis within categories
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/>
Line 767: Line 769:
   
   
       ?ppa wikibase:claim ?p;       
       ?ppa wikibase:claim ?p;       
         wikibase:statementProperty ?ps.    
         wikibase:statementProperty ?ps.  
         
 
      # note: i think you need rdfs:label (*Label won't work) for the bind()
 
       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb".  
       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb".  
                       ?ppa rdfs:label ?ppa_label.       # what kind of thing
                       ?ppa rdfs:label ?ppa_label.  
                 } # /label service
                 } # /label service
    
    
Line 778: Line 782:
       ?s ?ps ?ppa_value.
       ?s ?ps ?ppa_value.
    
    
 
    # note: it would be possible to write this to use ppa rather than ppa_label
    # BUT then it would be much more opaque and difficult to edit if (when!) we make any changes to the buckets.
     bind(
     bind(
       if( str(?ppa_label) in ("attended", "exhibited at", "organiser of", "performed at", "spoke at", "was delegate at (free text)", "was delegate at (item)" ), "events",
       if( str(?ppa_label) in ("attended", "exhibited at", "organiser of", "performed at", "spoke at", "was delegate at (free text)", "was delegate at (item)" ), "events",
579

edits