query-d9602de30d118251ad89edfed3949fe9

rq turtle/ttl

Alle Gemeinden in D mit zusätzlichen Daten SELECT ?cid ?name ?AGS ?_licence_plate_code ?_official_website ?_local_dialing_code ?_postal_code ?_image ?_head_of_government ?_time_of_earliest_written_record ?_Facebook_Places_ID WHERE { ?cid wdt:P31 wd:Q262166. ?cid wdt:P439 ?AGS. OPTIONAL { ?cid rdfs:label ?name. FILTER((LANG(?name)) = "de") } OPTIONAL { ?cid wdt:P395 ?_licence_plate_code. } OPTIONAL { ?cid wdt:P856 ?_official_website. } OPTIONAL { ?cid wdt:P473 ?_local_dialing_code. } OPTIONAL { ?cid wdt:P281 ?_postal_code. } OPTIONAL { ?cid wdt:P18 ?_image. } OPTIONAL { ?cid wdt:P6 ?_head_of_government. } OPTIONAL { ?cid wdt:P1249 ?_time_of_earliest_written_record. } OPTIONAL { ?cid wdt:P1997 ?_Facebook_Places_ID. } }

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
# Alle Gemeinden in D mit zusätzlichen Daten
SELECT ?cid ?name ?AGS ?_licence_plate_code ?_official_website ?_local_dialing_code ?_postal_code ?_image ?_head_of_government ?_time_of_earliest_written_record ?_Facebook_Places_ID WHERE {
  ?cid wdt:P31 wd:Q262166.
  ?cid wdt:P439 ?AGS.
  OPTIONAL {
    ?cid rdfs:label ?name.
    FILTER((LANG(?name)) = "de")
  }
  OPTIONAL { ?cid wdt:P395 ?_licence_plate_code. }
  OPTIONAL { ?cid wdt:P856 ?_official_website. }
  OPTIONAL { ?cid wdt:P473 ?_local_dialing_code. }
  OPTIONAL { ?cid wdt:P281 ?_postal_code. }
  OPTIONAL { ?cid wdt:P18 ?_image. }
  OPTIONAL { ?cid wdt:P6 ?_head_of_government. }
  OPTIONAL { ?cid wdt:P1249 ?_time_of_earliest_written_record. }
  OPTIONAL { ?cid wdt:P1997 ?_Facebook_Places_ID. }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?AGS"):::projected v11("?_Facebook_Places_ID"):::projected v9("?_head_of_government"):::projected v8("?_image"):::projected v4("?_licence_plate_code"):::projected v6("?_local_dialing_code"):::projected v5("?_official_website"):::projected v7("?_postal_code"):::projected v10("?_time_of_earliest_written_record"):::projected v2("?cid"):::projected v1("?name"):::projected c3(["wd:Q262166"]):::iri v2 --"wdt:P31"--> c3 v2 --"wdt:P439"--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."rdfs:label".-> v1 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P395".-> v4 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P856".-> v5 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P473".-> v6 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P281".-> v7 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P18".-> v8 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P6".-> v9 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P1249".-> v10 end subgraph optional8["(optional)"] style optional8 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P1997".-> v11 end