Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

These examples show how to count the entities in your VIVO that do not have labels.  

Code Block

 

This query returns the number of Agents (Persons, Orgs) without a label

titleFind Agents without labels
SELECT 

...

count(?s)

...


WHERE {

...


    ?s rdf:type foaf:Agent .

...


    OPTIONAL {?s rdfs:label ?label

...

 .}
    FILTER(!bound(?label))
}

}

This query returns the number of UF Persons with a ufid and without a label (#0 as of 3/7/11)

Code Block
titleCount grants without labels
SELECT 

...

count(?s)

...

Where {


WHERE {
    ?s rdf:type

...

 vivo:

...

?s ufVivo:ufid ?u .

...

Grant .
    OPTIONAL {?s rdfs:label ?

...

label .}
    FILTER(!bound(?

...

label))

...

}

This query returns the number of UF Organizations with a deptID and without a label (#37 as of 3/7/11)

Select count(?s)

Where {

?s rdf:type foaf:Organization .

Optional {?s rdfs:label ?l} .

?s ufVivo:deptID ?d

Filter (!bound (?l))

}

This query returns the number of grants harvested from the DSR that do not have a label (#0 as of 3/7/11)


}

 

 

Code Block
titleCount Positions without labels
SELECT 

...

count(?s)

...


WHERE {

...


    ?s rdf:type

...

 vivo:

...

?s ufVivo:harvestedBy "DSR-Harvester" .

...

Position .
    OPTIONAL {?s rdfs:label ?

...

label .}
	FILTER(!bound(?

...

}

...

label

...

)

...

SELECT count(?s)

WHERE {

?s rdf:type core:DependentResource .

Optional {?s rdfs:label ?l} .

Filter (!bound (?l))

}

This query returns the number of Publications that do not have a label (#0 as of 3/7/11)

...

)
}
Code Block
titleCount Publications without Labels
SELECT count(?s)

...


WHERE {

...


    ?s rdf:type

...

 vivo:InformationResource

...

 .
    OPTIONAL {?s rdfs:label ?

...

label .}
    FILTER(!bound(?

...

label))

...


}