bio2rdf_location.sparql

bio2rdf_trial_locations.sparql

prefix dcterm: <http://purl.org/dc/terms/>
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix ctvoc: <http://bio2rdf.org/clinicaltrials_vocabulary:>
prefix ctres: <http://bio2rdf.org/clinicaltrials_resource:>
prefix ct: <http://bio2rdf.org/clinicaltrials:>


select ?trial ?location ?cityName ?countryName
where {
  	  BIND(ct:NCT00005636 AS ?trial).
  	  ?trial ctvoc:location ?locationRes.
      ?locationRes dcterm:title ?location.
      ?locationRes ctvoc:address ?addressRes.
      ?addressRes ctvoc:city ?city.
      ?addressRes ctvoc:country ?country.
      ?addressRes ctvoc:zip ?zip.
      
      BIND (IRI(CONCAT("http://bio2rdf.org/", ?city)) AS ?cityRes).
      ?cityRes dcterm:title ?cityName.
       
      BIND (IRI(CONCAT("http://bio2rdf.org/", ?country)) AS ?countryRes).
      ?countryRes dcterm:title ?countryName.
       
      BIND (IRI(CONCAT("http://bio2rdf.org/", ?zip)) AS ?zipRes).
      OPTIONAL {?zipRes dcterm:title ?zipCode.}
      }