Versions Compared

Old Version 16

changes.mady.by.user Mike Conlon

Saved on

compared with

New Version 17

changes.mady.by.user Mike Conlon

Saved on

Key

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

...

Code Block
titleList publications with common citation information
linenumberstrue
SELECT ?doi ?pub_label ?type_label ?venue_label ?issn ?issue ?startPage ?endPage ?volume ?year
WHERE{
    ?pub vivo:hasPublicationVenue ?venue .
    
    ?venue rdf:type bibo:Journal .
    ?venue bibo:issn ?issn .
    ?venue rdfs:label ?venue_label .

    ?pub rdfs:label $pub_label .
    ?pub vitro:mostSpecificType ?type .
    ?type rdfs:label ?type_label .
  
    ?pub vivo:dateTimeValue ?dtv . 
    ?dtv vivo:dateTime ?dt .
    BIND(SUBSTR(str(?dt),1,4) AS ?year)
    
    OPTIONAL { ?pub bibo:doi ?doi . }
    OPTIONAL { ?pub bibo:pageStart ?startPage . }
    OPTIONAL { ?pub bibo:pageEnd ?endPage . }    
    OPTIONAL { ?pub bibo:volume ?volume . }
    OPTIONAL { ?pub bibo:issue ?issue . }  
}

Authors

List

...

authors by

...

number of publications

Code Block
titleList Authors by Department
linenumberstrue
SELECT (MIN(str(?infoResourceauthor_label)) ?typeAS ?author_name) ?firstName ?lastName ?position_label ?department ?pemail(COUNT(DISTINCT ?authorship) AS ?pub_count)
WHERE {
    ?infoResourceauthor vivo:hasPublicationVenuerelatedBy ?pubVenueauthorship .
?pubVenue rdf:type bibo:Journal .
?infoResource rdf:type ?anyType .
?anyType rdfs:label ?type .
?infoResource vivo:informationResourceInAuthorship ?authorship .
?authorship rdf:typeauthor a foaf:Person .
    ?authorship a vivo:Authorship .
?authorship  vivo:linkedAuthor ?authorURI .
?authorURI rdfs:label    ?author .
?infoResource rdfs:label ?infoResourceauthor_label .
OPTIONAL { $authorURI foaf:firstName ?firstName } .
OPTIONAL { $authorURI foaf:lastName ?lastName } .
OPTIONALGROUP { $authorURI vivo:primaryEmail ?pemail } .
?authorURI vivo:personInPosition ?position .
?position vivo:positionInOrganization $organization .
?organization rdfs:label ?department .
?position rdfs:label ?position_label .
BY ?author
ORDER BY DESC(?pub_count)

People with less than five publications

...