I have created a different kind of table that includes the first 5030 streets (sorted by alphabetic order by name field).
https://docs.google.com/spreadsheet/ccc?key=0AjoRSMeOZcXDdGFaYjFZcXB6eS1RTVR1RGhmWjI3M2c
How is this table different from the one yrtimiD created?
- It includes all streets no matter if there is something missing or not (this makes it searchable and you can most probably copy paste the street names, no need to translate).
- It marks all missing fields for name:he and name:en with a different color. If somebody writes something in this field, it is changing the background color to white.
- It also includes the update field that will change its color if somebody wrote something in it.
- It includes the russian and arabic translation. As it is very easy to copy paste things, it could help a lot to add those translations to existing streets.
Why did I create this list only for the first 5030 entries?
Because Google is not capable to load all 21.000 entries in one table in Google Drive.
And because I think we should start with a small chunk and then extend it.
This way we will not cause any damage.
For everybody that would like to know how to create this list by yourself … here is the command line “code”.
After it I loaded it in Excel and used the sort function.
osmconvert israel_and_palestine.osm.pbf --all-to-nodes --drop-author -o=temp\israel_nodes.o5m
osmfilter temp\israel_nodes.o5m --keep="highway=residential and name=* and is_in!=Egypt and is_in!=Jordan and is_in!=Syria and is_in!=Lebanon and is_in!=Gaza" -o=temp\israel_streets.o5m
osmconvert temp\israel_streets.o5m -B=poly\israel.poly --csv-headline --csv="@id @lon @lat is_in highway name name:he name:he1 name:he2 name:he3 name:ar name:ru name:en name:en1 name:en2 name:en3 name:en4 name:en5 name:en6" -o=israel_streets_withArRuEnHe.csv
pause