Project:SPARQL/examples: Difference between revisions

m
Line 2,721: Line 2,721:
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/>


SELECT distinct ?person ?personLabel ?prop_label ?date_prop_label ?date_value ?date_precision ?pdv ?pdvLabel 
 
# ?date_prop  ?date_prop_type ?prop  ?s
SELECT distinct ?person ?personLabel ?prop_label ?prop_valueLabel ?qual_dateLabel ?date_value ?date_precision   ?s
#?prop ?prop_value ?qual_date
 


WHERE {
WHERE {
Line 2,735: Line 2,737:
    
    
     # get stuff about ?p .
     # get stuff about ?p .
       ?date_prop wikibase:claim ?p;     
       ?prop wikibase:claim ?p;     
         wikibase:statementProperty ?ps ;   
         wikibase:statementProperty ?ps ;   
         wikibase:statementValue ?psv .     
         wikibase:statementValue ?psv .     
       ?date_prop wikibase:propertyType ?date_prop_type .
       ?prop wikibase:propertyType ?date_prop_type .
       ?date_prop rdfs:label ?date_prop_label. filter(lang(?date_prop_label)="en-gb") .  
       ?prop rdfs:label ?prop_label. filter(lang(?prop_label)="en-gb") .  
    
    
   # get dates detail via ?s and psv
   # get dates detail via ?s and psv
   # gets edtf dates in simplified std wiki date format.  
   # gets edtf dates in simplified std wiki date format. are you sure?
   # https://github.com/ProfessionalWiki/WikibaseEdtf
   # https://github.com/ProfessionalWiki/WikibaseEdtf
    
    
Line 2,770: Line 2,772:
      
      
   # get date qualifiers. [assumes no edtf in quals. ]
   # get date qualifiers. [assumes no edtf in quals. ]
         ?s ?pq ?date_qual .  #  
         ?s ?pq ?date_value .  #  
           ?qual_prop wikibase:qualifier ?pq .
           ?qual_date wikibase:qualifier ?pq .
           ?qual_prop wikibase:propertyType wikibase:Time.  
           ?qual_date wikibase:propertyType wikibase:Time.  
           ?qual_prop rdfs:label ?date_qual_label . filter(lang(?date_qual_label)="en") .  
           ?qual_date rdfs:label ?date_qual_label . filter(lang(?date_qual_label)="en") .  


   # qualifier time precision. requires bnpqv: prefix  
   # qualifier time precision. requires bnpqv: prefix  
Line 2,779: Line 2,781:
       ?s (bnpqv:P1 | bnpqv:P27 | bnpqv:P28 | bnpqv:P51 | bnpqv:P53 ) ?pqv.
       ?s (bnpqv:P1 | bnpqv:P27 | bnpqv:P28 | bnpqv:P51 | bnpqv:P53 ) ?pqv.
           #?pqv wikibase:timeValue ?time_qual . #don't need this as well as date_qual.
           #?pqv wikibase:timeValue ?time_qual . #don't need this as well as date_qual.
           ?pqv wikibase:timePrecision ?date_qual_precision .
           ?pqv wikibase:timePrecision ?date_precision .
        
        
   }  # /qual dates
   }  # /qual dates
586

edits