Changes between Initial Version and Version 1 of Ticket #21988, comment 1


Ignore:
Timestamp:
2022-04-27T13:47:56+02:00 (3 years ago)
Author:
pyrog

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #21988, comment 1

    initial v1  
    1010**Fixes:** Formatter URL are sorted by rank (Preferred first) and Deprecated are removed.
    1111
    12 **Sophox SPARQL query**
     12**[https://sophox.org/#SELECT%20%28CONCAT%28%22Key%3A%22%2C%20%3Fpermanent_key_ID%29%20as%20%3FOSM_key%29%20%3Fformatter_URL%20%3Frank%20%3Fsource%20WHERE%20%7B%0A%20%20%3Fitem%20osmdt%3AP2%20osmd%3AQ7.%0A%20%20%3Fitem%20osmdt%3AP16%20%3Fpermanent_key_ID.%0A%20%20%3Fitem%20osmp%3AP8%20%5Bosmps%3AP8%20%3Fformatter_URL%3B%20wikibase%3Arank%20%3Frank%3B%5D.%0A%20%20BIND%28%22osmwiki%3AP8%22%20AS%20%3Fsource%20%29.%0A%20%20FILTER%20%28%3Frank%20%21%3D%20wikibase%3ADeprecatedRank%29%0A%7D%0AORDER%20BY%20%3FOSM_key%20DESC%28%3Frank%29 Sophox SPARQL query]**
    1313{{{
    1414SELECT (CONCAT("Key:", ?permanent_key_ID) as ?OSM_key) ?formatter_URL ?rank ?source WHERE {
    … …  
    2222}}}
    2323
    24 **Wikidata SPARQL query**
     24**[https://query.wikidata.org/#SELECT%20%3FOSM_key%20%3Fformatter_URL%20%3Frank%20%3Fsource%20WHERE%20%7B%0A%20%20%7B%20%3Fitem%20wdt%3AP1282%20%3FOSM_key.%20%7D%0A%20%20FILTER%28STRSTARTS%28%3FOSM_key%2C%20%27Key%3A%27%29%29%20.%0A%0A%20%20%7B%0A%20%20%20%20%7B%20%3Fitem%20p%3AP1630%20%5Bps%3AP1630%20%3Fformatter_URL%3B%20wikibase%3Arank%20%3Frank%3B%5D.%20BIND%28%22wikidata%3AP1630%22%20AS%20%3Fsource%20%29.%20%7D%0A%20%20%20%20UNION%0A%20%20%20%20%7B%20%3Fitem%20p%3AP3303%5Bps%3AP3303%20%3Fformatter_URL%3B%20wikibase%3Arank%20%3Frank%3B%5D.%20BIND%28%22wikidata%3AP3303%22%20AS%20%3Fsource%20%29.%20%7D%0A%20%20%7D%0A%20%20FILTER%20%28%3Frank%20%21%3D%20wikibase%3ADeprecatedRank%29%0A%7D%0AORDER%20BY%20%3FOSM_key%20DESC%28%3Frank%29 Wikidata SPARQL query]**
    2525{{{
    2626SELECT ?OSM_key ?formatter_URL ?rank ?source WHERE {