Changeset: 138695967
Add English Wikipedia and Wikidata links to many numbered Missouri state routes. This does not include special routes like spurs or routes with conflated Wikipedia articles (like Route 27 which is conflated with the Avenue of the Saints).
Closed by tyfi
Tags
created_by | JOSM/1.5 (18772 en) |
---|
Discussion
-
Comment from tyfi
I used Excel to construct the enwiki article title for each route, called the Wikipedia API with the WEBSERVICE and FILTERXML formula functions to get the QID, and then called Wikidata API to get the enwiki article for each item. Then I used conditional formatting to double check that the predicted and actual enwiki article titles matched indicating non-conflated articles (e.g. Route 27 being folded into Avenue of the Saints or the Martin Luther King Bridge of which half is Route 799).
-
Comment from tyfi
I then, of course, manually verified. But I wanted the extra layer.
-
Comment from tyfi
I used Notepad++ macros to convert the resulting CSV into JavaScript function calls which I pasted into the Scripting console in JOSM.
-
Comment from tyfi
Also excluded are Route 64A and Route 64B which are considered related routes of Route 64. I treated them like special routes.
- 187 (128599), v2
- 267 (136078), v9
- 366 (181740), v47
- Missouri Highway 23 (184112), v14
- 127 (184127), v9
- 116 (184150), v17
- State Highway 58 (270633), v32
- Missouri Route 131 (270649), v21
- Missouri Highway 148 (271308), v7
- Missouri Highway 246 (271315), v7
- State Highway 46 (271882), v22
- Missouri Highway 118 (271884), v6
- Missouri Highway 113 (271885), v14
- Missouri Highway 120 (271886), v3
- Missouri Highway 111 (271890), v14
- 190 (273236), v4
- 146 (273237), v4
- 128 (273238), v4
- 145 (273239), v2
- Missouri Highway 139 (273277), v15
Welcome to OpenStreetMap!
OpenStreetMap is a map of the world, created by people like you and free to use under an open license.
Hosting is supported by Fastly, OSMF corporate members, and other partners.
https://openstreetmap.org/copyright | https://openstreetmap.org |
Copyright OpenStreetMap and contributors, under an open license |