Help:P11109/da

From Wikidata
Jump to navigation Jump to search
This page is a translated version of the page Help:P11109 and the translation is 8% complete.

Help page for Onestop ID (P11109) View with SQID. This help page will be included in Property talk:P11109. Please be careful editing it not to break the included page.

#Onestop ID type statistics
SELECT ?type (COUNT(?type) AS ?count)
(IRI(CONCAT("https://query.wikidata.org/#%23%20Onestop%20ID%20type%20",?type,"%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fid%0AWHERE%0A{%0A%09%3Fitem%20wdt%3AP11109%20%3Fid%20.%0A%20%20%20%20FILTER(SUBSTR(%3Fid%2C%201%2C%201)%20%3D%20%22",?type,"%22)%20.%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20{%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20}%20%20%20%20%0A}%0AORDER%20BY%20%3FitemLabel")) as ?instances)
WHERE {
  ?s wdt:P11109 ?id .
  BIND (SUBSTR(?id, 1, 1) AS ?type) .
 }
GROUP BY ?type
Try it!

Items with multiple Onestop IDs

The following separators are used to disambiguate IDs:

Route with multiple IDs

Opposite directions

Green Line (Q3720557)

Daytime / nighttime

501 Queen (Q3238944)

Station with multiple IDs

Two transport networks

Burbank Airport–South station (Q3096094)

Opposite directions with separate ID for the station

California Avenue station (Q5020256)

Two transport networks, multiple routes

Los Angeles Union Station (Q198019)