How to filter based on value of property? List of all the Places?

[adarshmadrecha]

Questions

1. How to export list of all the Places?
2. Get list of all types of Places

[adarshmadrecha]

A place can have more than one value for P1 i.e. Instance Of (Category). Hence need to perform GROUP_CONCAT

PREFIX yq: <https://data.jain.wiki/entity/>
PREFIX yp: <https://data.jain.wiki/prop/direct/>

SELECT DISTINCT ?item ?itemLabel ?itemDescription 
       (GROUP_CONCAT(DISTINCT ?mainCategoryLabel; separator=",") AS ?mainCategorys) 
WHERE {
  ?item yp:P1 ?mainCategory . # Get Main Category
  # Q8238 means "Place"
  ?mainCategory yp:P1 yq:Q8238 . # Filter Main Category for only "Places"

  SERVICE wikibase:label { 
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
    ?item rdfs:label ?itemLabel .
    ?item schema:description ?itemDescription .
    ?mainCategory rdfs:label ?mainCategoryLabel .
  }
}
GROUP BY ?item ?itemLabel ?itemDescription
ORDER BY ?itemLabel

Run the query and then click on Download and select CSV