Project:SPARQL/examples: Difference between revisions

From geokb
No edit summary
Line 116: Line 116:
WHERE {
WHERE {
   ?item wdt:P107 wd:Q44210 ; # Employed by the USGS
   ?item wdt:P107 wd:Q44210 ; # Employed by the USGS
         p:P107 ?prop_statement .
         p:P107 ?emp_statement .
   OPTIONAL {
   OPTIONAL {
     ?prop_statement pq:P61 ?end_time . # Any value here indicates that employment status ended at some point
     ?emp_statement pq:P61 ?end_time . # Any value here indicates that employment status ended at some point
   }
   }
   OPTIONAL {
   OPTIONAL {

Revision as of 13:19, 12 August 2024

Organizations

Classification of organizations

PREFIX wdt: <https://geokb.wikibase.cloud/prop/direct/>
PREFIX wd: <https://geokb.wikibase.cloud/entity/>

SELECT ?item ?itemLabel ?subclass_of ?subclass_ofLabel
WHERE {
  {
    wd:Q50862 wdt:P2* ?item .
    ?item wdt:P2 ?subclass_of .
  } UNION {
    ?item wdt:P2* wd:Q50862 ;
          wdt:P2 ?subclass_of .
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}

Try it!


USGS Organizations

PREFIX wd: <https://geokb.wikibase.cloud/entity/>
PREFIX wdt: <https://geokb.wikibase.cloud/prop/direct/>

SELECT ?item ?itemLabel ?item_alt_label ?instance_ofLabel 
(GROUP_CONCAT(?url; separator=",") AS ?urls)
WHERE {
  ?org_types wdt:P2 wd:Q50862 . # Gets subclasses of USGS organization
  ?item wdt:P1 ?org_types ; # Gets items in those classes
        wdt:P1 ?instance_of . # Gets the individual instance of classification
  OPTIONAL {
    ?item skos:altLabel ?item_alt_label . # Retrieves alternate labels into separate rows
    FILTER (lang(?item_alt_label)='en')
  }
  OPTIONAL {
    ?item wdt:P145 ?url . # Get all reference URLs when available
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
GROUP BY ?item ?itemLabel ?item_alt_label ?instance_ofLabel

Try it!


People

People and their identifiers

PREFIX wd: <https://geokb.wikibase.cloud/entity/>
PREFIX wdt: <https://geokb.wikibase.cloud/prop/direct/>
PREFIX p: <https://geokb.wikibase.cloud/prop/>
PREFIX pq: <https://geokb.wikibase.cloud/prop/qualifier/>

SELECT ?item ?itemLabel ?itemDescription ?itemAltLabel ?email ?orcid ?url ?alt_url
WHERE {
  ?item wdt:P1 wd:Q3 .
  OPTIONAL {
    ?item wdt:P145 ?url ;
          p:P145 ?url_statement .
    OPTIONAL {
      ?url_statement pq:P202 ?alt_url .
    }
  }
  OPTIONAL {
    ?item wdt:P109 ?email .
  }
  OPTIONAL {
    ?item wdt:P106 ?orcid .
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}

Try it!


Occupations

PREFIX wdt: <https://geokb.wikibase.cloud/prop/direct/>
PREFIX wd: <https://geokb.wikibase.cloud/entity/>

SELECT ?item ?itemLabel ?itemAltLabel
WHERE {
  ?item wdt:P2* wd:Q3 ;
        skos:altLabel ?itemAltLabel .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}

Try it!


Academic Disciplines

PREFIX wdt: <https://geokb.wikibase.cloud/prop/direct/>
PREFIX wd: <https://geokb.wikibase.cloud/entity/>

SELECT ?item ?itemLabel ?itemAltLabel
WHERE {
  ?item wdt:P2* wd:Q158710 ;
        skos:altLabel ?itemAltLabel .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}

Try it!


iSAID

The following queries focus on the entities and linkages in the GeoKB related to USGS staff and capacity assessment analyses.

USGS Current and Former Staff

PREFIX wd: <https://geokb.wikibase.cloud/entity/>
PREFIX wdt: <https://geokb.wikibase.cloud/prop/direct/>
PREFIX p: <https://geokb.wikibase.cloud/prop/>
PREFIX pq: <https://geokb.wikibase.cloud/prop/qualifier/>

SELECT ?item ?itemLabel ?orcid ?email ?url ?end_time
WHERE {
  ?item wdt:P107 wd:Q44210 ; # Employed by the USGS
        p:P107 ?emp_statement .
  OPTIONAL {
    ?emp_statement pq:P61 ?end_time . # Any value here indicates that employment status ended at some point
  }
  OPTIONAL {
    ?item wdt:P106 ?orcid .
  }
  OPTIONAL {
    ?item wdt:P109 ?email .
  }
  OPTIONAL {
    ?item wdt:P145 ?url .
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}

Try it!