User:Bouzinac/Rues

à faire 3 rues en FR= edit

Martinique streets edit

SELECT ?item ?itemLabel ?nomm__en_r_f_rence__ ?nomm__en_r_f_rence__Label WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
  ?item wdt:P131 ?local;
    wdt:P31 wd:Q79007;
    (wdt:P131*) wd:Q617806.
  OPTIONAL { ?item wdt:P138 ?nomm__en_r_f_rence__. }
}

Try it!

Bilingual names streets edit

SELECT ?item ?itemLabel ?place_name_sign ?lang1Label ?lang2Label
WHERE
{
  ?item p:P1766 ?sign_statement .
  ?sign_statement a wikibase:BestRank .
  ?sign_statement ps:P1766 ?place_name_sign .
  ?sign_statement pq:P407 ?lang1 .
  ?sign_statement pq:P407 ?lang2 .
  FILTER (STR(?lang1) < STR(?lang2))
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Bilingual names streets in Alsatian and French edit

https://w.wiki/3Yev