Bilingual streets

Thanks you all!
unfortinatlly i couldnt find any way to export PDF file with the english street names of jerusalem
is there an easy and fast way to fix what i did?

I could not get http://developer.skobbler.de/mapcreator to show street names in any language except Hebrew, and http://toolserver.org/~osm/locale/en.html is gone, and so is http://www.maposmatic.org/. I also could not find how to access the http://osmand.net/ map.

The good news is that http://mlm.jochentopf.com/ can supply the necessary tiles for creating a PDF file using MOBAC - Mobile Atlas Creator

Please take a look at a map made of zoom 15, a map of zoom 16 as well as the map definition file for MOBAC on my public Dropbox folder.
No registration is required! However, if any of you do not have a Dropbox account, I would appreciate if you register using this link. You will get 2.5 Gb of free storage instead of the usual 2Gb, and I will also get an extra 0.5 Gb to keep sharing.

About fix: I think we can try to just overwrite all name tags with value from name:he.
Doron, are all you changes was in Jerusalem only?

Dimitry,
Please see http://overpass-turbo.eu/s/blu for all roads with mixed Hebrew and English names.
The “data” tab on the top right corner contains the way and node information in XML format.

Doron,
Did you also change names of other map entries except roads?

I have manually edited and reviewed an OSM XML file with the Bilingual names.

Can someone help me prepare it for uploading?

What’s the problem?
I usually upload such files via JOSM.

I’m not sure what is the required format for uploading.
Currently it’s an hand-edited version of a OSM file I copied from Overpass Turbo.
If uploading requires OsmChange format, for example, then how do I get the “version” info?

JOSM can open regular .osm file and will create change request on upload. the only condition - you should have exported full osm data (include metadata). If you don’t see fields like version and changesets - you probably don’t have them.

Once with Mr.Israel we used different approach: we edited data in excel like spreadsheet, and then exported it as csv. I wrote a tool which after parsed this csv file, get all metadata from osm servers by item ID and then uploaded it as a new changeset.
You can try to do the same and meantime I’ll try to recall how exactly we done that :slight_smile:

UPD: here is a link to code page with some very short instructions: https://github.com/yrtimiD/osm-bulk-tools
or you can send me your osm file, I’ll try to convert and/or upload it.

I would appreciate if you could revive that script and let me know how to construct the CSV file.

Well, for start try to import your xml into google docs, or any other spreadsheet application, and then save it as csv.

I’m unable to convert the XML to CVS without loosing all tags.

I can convert to CVS manually, if I knew what should be the contents of each CSV column

to properly upload I need to know next:
1 item type: 0 for node, 1 for way, 2 for relation
2 item id
3 and actually all other tags you want to add/change like name, name:en, etc.

After you have them, just execute the tool:
OsmBulkTools.exe --csv-to-osm --in=file.csv --out=update.xml.osm --id=“id” --type=“type”

just replace text in “…” to your column names.
after executing you should have proper osm file which can be opened and uploaded in JOSM.

Excellent.
A few questions:

  • Where can I find the executable?
  • Is there a need to include unmodified elements, such as unmodified nodes of a modified way?
  • Is there a way to delete tags with this utility?

Unmodified you can mark with special column, and pass this column name for one of parameters.
On github page you have a link to compiled executables and also usage examples.

I think making value empty will remove this tag from osm

@yrtimiD - Thanks for your help!

The update was done in two changesets: 35908519 and 35909345

Here are a few notes in case anyone will want to do similar tasks in the future:

  • Use Overpass Turbo to search and filter the objects of interest.
    [list=*]

  • Include a csv format directive, such as

    [out:csv(::id, ::otype, "name", "name:he", "name:en" ; true; "," )];
    
  • Use “Export” → “Data” → “raw data directly from Overpass API” and “Save as” to a file with a .csv suffix

[/*] [*]Edit the csv file in a spreadsheet editor or a text editor.
  • Replace “@otype” with “@type” in the header

  • Subtract 1 from the values in the “@type” column.
    OverpassTurbo’s otype values are 1 for node, 2 for way, 3 for relation,
    while OsmBulkTools type values are 0 for node, 1 for way, 2 for relation.

  • Edit the values as needed.

  • Removing a value from a tag column removes the tag.

[/*] [*]Use OsmBulkTools to convert the updated cvs file to osm format.
OsmBulkTools --csv-to-osm --id="@id" --type="@type" --in="filename.csv" and --out="filename.osm"

[/]
[
]Use JOSM to upload the update osm file

  • “File” → “Open” the osm file created by OsmBulkTools

  • “File” → “Upload Data”

  • Provide your OSM Username and Password, if requested.

  • Please provide a meaningful comment.

[/*] [/list]

Small correction:
you can use --csv-separator=, parameter for osmconvert to get a really comma-separated-values file.

Thanks!

I’ve updated the summary above.

I’ve also updated Bilingual nodes in changeset 35910828

Hi,

there’s also a (still somewhat experimental) CSV output available directly from Overpass API. Results can be opened from overpass turbo in LibreOffice, etc. via “Export” → “Data” → “raw data directly from Overpass API”. By default, csv separator is a tab character.

overpass turbo link: http://overpass-turbo.eu/s/df3

See: http://wiki.openstreetmap.org/wiki/Overpass_API/Overpass_QL#Output_Format_.28out.29

Thanks!
Apparently, you can also set the csv separator.

http://overpass-turbo.eu/s/dhQ