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.
- State Highway 37 (62134), v23
- MO 96 (63200), v38
- Missouri Highway 171 (63206), v36
- State Highway 266 (69451), v15
- State Highway 66 (69454), v25
- 249 (69697), v14
- State Highway 59 (69950), v26
- Missouri Route 43 (70401), v60
- State Route 90 (75980), v19
- Missouri Route 76 (76814), v65
- State Highway 86 (77098), v43
- 112 (77479), v5
- Missouri Highway 126 (77483), v9
- 265 (77502), v27
- 173 (77516), v4
- 376 (77520), v5
- 175 (77748), v5
- 150 (77770), v37
- 245 (77773), v6
- 215 (77784), v14
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 |