Automated edits/Ian Wagner

From OpenStreetMap Wiki
Jump to navigation Jump to search

This page documents automated edits performed or coordinated by Ian Wagner.

August 11-12, 2018 - Korean Romanisation Tag Clean-up

Status: COMPLETED

Overview

As discussed in the OSM Korea mailing list, in IRC, and over the unofficial OSM Korea Telegram channel, we decided to clean up the tags used for romanised names on the Korean peninsula (we also fixed the neighbors as well for consistency). This has also been discussed for Japan, but that group will be coordinated separately.

Process

We used JOSM to re-tag anything using a ko_rm language code to use ko-Latn instead, as the former does is not in conformance with the BCP 47 standard. Documentation for the Korea Naming Convention on the wiki is up to date with this policy. We also cleaned up additional related language tags that we found were incorrect, including language-specific tags using kr instead of ko.

The edits touched around 150 000 objects. To ensure that we did not unduly load the server, we will worked through the peninsula systematically using appropriately sized bounding boxes determined using the tile numbering scheme.

Status

We coordinated our efforts via a Google Sheet. We have reproduced the changelog below. Many thanks to Artemis64, revi^, and panoramedia for their collaboration on this.

Tile based edits

Z X Y Changeset Comments
8 219 94 https://www.openstreetmap.org/changeset/61557225 북한
8 220 94 https://www.openstreetmap.org/changeset/61557275 북한
8 217 95 No changes needed 북한
8 218 95 https://www.openstreetmap.org/changeset/61557291 북한
8 219 95 No changes needed 북한
8 220 95 No changes needed 북한
8 216 96 https://www.openstreetmap.org/changeset/61557309 북한
8 217 96 https://www.openstreetmap.org/changeset/61557317 북한
8 218 96 No changes needed 북한
8 219 96 No changes needed 북한
8 216 97 https://www.openstreetmap.org/changeset/61557751 북한
8 217 97 No changes needed 북한
8 218 97 https://www.openstreetmap.org/changeset/61557790 북한
8 216 98 https://www.openstreetmap.org/changeset/61557888 북한
8 217 98 https://www.openstreetmap.org/changeset/61557918 북한
9 436 196 https://www.openstreetmap.org/changeset/61557942 북한
9 437 196 https://www.openstreetmap.org/changeset/61557968 북한
9 438 196 https://www.openstreetmap.org/changeset/61557992 북한
9 436 197 https://www.openstreetmap.org/changeset/61557428
9 437 197 https://www.openstreetmap.org/changeset/61558080
9 438 197 https://www.openstreetmap.org/changeset/61558269
9 439 197 https://www.openstreetmap.org/changeset/61558410
9 434 198 https://www.openstreetmap.org/changeset/61558495
9 435 198 https://www.openstreetmap.org/changeset/61558533
10 872 396 https://www.openstreetmap.org/changeset/61558657 서울/부천 area (very big edit)
10 873 396 https://www.openstreetmap.org/changeset/61559074 https://www.openstreetmap.org/changeset/61559372 https://www.openstreetmap.org/changeset/61560150 Central 서울 (very big edit, several changesets as I ran into version conflicts while uploading)
10 872 397 https://www.openstreetmap.org/changeset/61560326 인천
10 873 397 https://www.openstreetmap.org/changeset/61560479 Southern 서울
9 437 198 https://www.openstreetmap.org/changeset/61560977
9 438 198 https://www.openstreetmap.org/changeset/61561204
9 439 198 https://www.openstreetmap.org/changeset/61562292
9 434 199 No changes needed
9 435 199 https://www.openstreetmap.org/changeset/61577614
9 436 199 https://www.openstreetmap.org/changeset/61577777
9 437 199 https://www.openstreetmap.org/changeset/61577802
9 438 199 https://www.openstreetmap.org/changeset/61577916
9 439 199 https://www.openstreetmap.org/changeset/61579197
9 440 199 https://www.openstreetmap.org/changeset/61579255
9 434 200 https://www.openstreetmap.org/changeset/61569635 바다? (probably just water but who knows)
9 435 200 https://www.openstreetmap.org/changeset/61579274
9 436 200 https://www.openstreetmap.org/changeset/61579288
9 437 200 https://www.openstreetmap.org/changeset/61579327 대전
9 438 200 https://www.openstreetmap.org/changeset/61579591
9 439 200 https://www.openstreetmap.org/changeset/61579702
9 440 200 https://www.openstreetmap.org/changeset/61579874
9 435 201 No changes needed 바다? (probably just water but who knows)
9 436 201 https://www.openstreetmap.org/changeset/61579918
9 437 201 https://www.openstreetmap.org/changeset/61579960 https://www.openstreetmap.org/changeset/61580058
9 438 201 https://www.openstreetmap.org/changeset/61580111 대구
9 439 201 https://www.openstreetmap.org/changeset/61580111 https://www.openstreetmap.org/changeset/61580363 울산/포항
9 440 201 https://www.openstreetmap.org/changeset/61580776
9 434 202 No changes needed
9 435 202 https://www.openstreetmap.org/changeset/61581008
9 436 202 https://www.openstreetmap.org/changeset/61581102 광주
9 437 202 https://www.openstreetmap.org/changeset/61581315
9 438 202 https://www.openstreetmap.org/changeset/61581409
10 878 404 https://www.openstreetmap.org/changeset/61580957 부산
10 879 404 https://www.openstreetmap.org/changeset/61580779 부산
10 878 405 https://www.openstreetmap.org/changeset/61580598 부산
10 879 405 https://www.openstreetmap.org/changeset/61580456 부산
9 440 202 https://www.openstreetmap.org/changeset/61580354 바다? (probably just water but who knows)
9 433 203 https://www.openstreetmap.org/changeset/61580374 바다? (probably just water but who knows)
9 434 203 https://www.openstreetmap.org/changeset/61580374
9 435 203 https://www.openstreetmap.org/changeset/61581771
9 436 203 https://www.openstreetmap.org/changeset/61581915
9 437 203 https://www.openstreetmap.org/changeset/61582190 여수
9 438 203 https://www.openstreetmap.org/changeset/61581909
9 439 203
9 440 203 https://www.openstreetmap.org/changeset/61572297
8 217 102 https://www.openstreetmap.org/changeset/61572044 제주
8 218 102 https://www.openstreetmap.org/changeset/61571898
8 217 103 https://www.openstreetmap.org/changeset/61571838
8 218 103 https://www.openstreetmap.org/changeset/61572257
7 110 49 https://www.openstreetmap.org/changeset/61571737 Liancourt Rocks

Other edits

Changeset Comments
https://www.openstreetmap.org/changeset/61582586 Cleanup of ko_Latn tags
https://www.openstreetmap.org/changeset/61583344 Cleanup of ko_Latn tags
https://www.openstreetmap.org/changeset/61583983 Final cleanup of misc incorrect tags using regex key search
https://www.openstreetmap.org/changeset/61612563 Worldwide checks and fixes on ko_rm tags (Asia)
https://www.openstreetmap.org/changeset/61612596 Worldwide checks and fixes on ko_rm tags (Oceania)
https://www.openstreetmap.org/changeset/61612657 Worldwide checks and fixes on ko_rm tags (Africa)
https://www.openstreetmap.org/changeset/61614317 Worldwide checks and fixes on ko_rm tags (Europe)
https://www.openstreetmap.org/changeset/61614353 Worldwide checks and fixes on ko_rm tags (North America)
https://www.openstreetmap.org/changeset/61614368 Worldwide checks and fixes on ko_rm tags (South America)

Steps taken

These were extracted from the Google Sheets file in case the file ever gets lost.

Set-up

  1. Get JOSM
  2. Enable expert mode in the preferences.

For each tile

  1. Put your OSM username in the edit log by the tile so someone else doesn't do the same work twice
  2. Open the download view and select the "Download from Overpass API" options
  3. Enter the query below (you actually only need to do this once; it will remember it)
 [out:xml][timeout:25][bbox:{{bbox}}];
  (
    node[""name:ko_rm""];
    way[""name:ko_rm""];
    relation[""name:ko_rm""];
    node[""addr:city:ko_rm""];
    way[""addr:city:ko_rm""];
    relation[""addr:city:ko_rm""];
    node[""addr:street:ko_rm""];
    way[""addr:street:ko_rm""];
    relation[""addr:street:ko_rm""];
    node[""alt_name:ko_rm""];
    way[""alt_name:ko_rm""];
    relation[""alt_name:ko_rm""];
    node[""bridge:name:ko_rm""];
    way[""bridge:name:ko_rm""];
    relation[""bridge:name:ko_rm""];
    node[""name:kr""];
    way[""name:kr""];
    relation[""name:kr""];
  );
  (._;>;);
  out meta;
  1. Enter the tile number in the download window under "tile numbers" using the format specified and press Enter (it's silly; you have to do this or it won't register)
  2. Search for the following, and optionally set it to replace your current selection.
 "name:ko_rm" = * or "addr:city:ko_rm" = * or "addr:street:ko_rm" = * or "alt_name:ko_rm" = * or "bridge:name:ko_rm" = * or "name:kr" = *
  1. Look for any tags with something like ko_rm and replace the ko_rm with ko-Latn (NOTE THE SPELLING). Also keep an eye out for anything with name:kr, as this is wrong and should be name:ko
  2. Push your changeset and note the changeset in the edit log. I'd recommend using a chunk size of 500 to break things up. Repeat :)