sparqlquery.sql

PREFIX schema: <http://schema.org/>
PREFIX admin: <https://schema.ld.admin.ch/>
SELECT ?name ?company_uri ?company_type ?municipality
WHERE {
  ?company_uri a admin:ZefixOrganisation ;
       schema:name ?name ;
       admin:municipality ?muni_id .
  ?muni_id schema:name ?municipality .
  ?company_uri schema:additionalType ?type_id .
  ?type_id schema:name ?company_type .
  ?company_uri schema:address ?adr.
  
  FILTER(?municipality = "Zürich")
  FILTER(LANG(?company_type) = "de")
  # Je nach dem Filter auskommentieren 
  # FILTER(contains(?company_type, "Aktiengesellschaft") || contains(?company_type, "Aktiengesellschaft"))
} 
# Limitiert auf 100 Resultate
LIMIT 100