that are great news…
Anyway, adding “thank to data.gov.il” at http://wiki.openstreetmap.org/wiki/Contributors#Israel still be nice 
I am in the process of uploading Tel Aviv address based on this source…
I am in the process of uploading Tel Aviv address based on this source…
This looks really scary… the housenumbers are like tiny flies sitting on my monitor
Amazing result!!! GREAT JOB!!!
Yep, but now we can see where streets are missing.
Also, I’m thinking about deleting old addr info withing tel-aviv borders (with source other then muni data), otherwise we’ll have many duplicates.
Please don’t delete automatically… It took me soo much time to collect them 
(I know its not that much, but still)
Let us consider deleting them, and let me check if every manual insert from me is the same in the Tel Aviv Dataset.
Probably there is no change but still. Give me some time.
Ofcourse I’ll not delete them automatically 
It’s only proposition.
We can firstly export all old addresses and then decide what to do with them.
All finished now…
If you see only some of the numbers, refresh the image, because I uploaded in two batches and the image shows only the first batch.
Now we should finish adding buildings to the city where possible, and align the existing buildings and addresses where necessary so that they match each other.
Also, in Kfar Shalem (southeast corner of the city) there are entire streets missing, the addresses (including street name as well as number!) should allow us to reconstruct the streets there. Possibly also in Yafo too.
Lets export and delete all old address data in TelAviv. I don’t see a reason to keep it anymore. The new data seems very accurate and should be used in the future.
####################
Before we start adding buildings, we should look if there are any issues with the new data:
- There are for example a lot of double nodes on the same place now with housenumbers:
Examples:
http://www.openstreetmap.org/browse/node/2078995971
http://www.openstreetmap.org/browse/node/2079069558
http://www.openstreetmap.org/browse/node/2079170726
http://www.openstreetmap.org/browse/node/2079171381
and hundreds more.
- If I understand correctly there are house numbers only available for Tel Aviv municipality.
Meaning that this is the most accurate information so far what are the administrative borders for the Tel Aviv municipality.
Can we adjust the relation of TelAviv by this information?
http://www.openstreetmap.org/?lat=32.09262&lon=34.81025&zoom=17&layers=M&relation=1382494
- Letters in front of the number
Is it a mapnik bug to show all Hebrew letters on the left of the house number?
http://www.openstreetmap.org/browse/node/2078973169
Yes, but carefully.
This area is actually in TA, I think:
http://www.openstreetmap.org/?lat=32.06226&lon=34.80527&zoom=17&layers=M
This area is not:
http://www.openstreetmap.org/?lat=32.031081&lon=34.742138&zoom=18&layers=M
In general, one or two numbers are not sufficient proof that an area is in TA, but an entire street is sufficient proof.
This is really cool.
This data is collected and maintained by our money and it’s nice we can make use of it.
Eric,
Can you post the script you were using?
This is after exporting the XLS file to CSV, reordering the columns, doing some find/replace in the CSV to account for quotes in the street name, and deleting extra spaces/tabs in the CSV…
When exporting the CSV, I had to make sure the Hebrew encoding was correct (Unicode…)
#!/usr/bin/perl
sub trim($)
{
my $string = shift;
$string =~ s/^\s+//;
$string =~ s/\s+$//;
return $string;
}
open(SHAPES, "<c3.csv") or die ("Could not load file'\n");
open(OUT, ">out.osm") or die ("Could not open output file\n");
$count=0;
# Opening XML
print OUT "<?xml version='1.0' encoding='UTF-8'?>\n";
print OUT "<osm version='0.6' generator='addshapes.pl'>\n";
# Read/process lines
while(my $line = <SHAPES>) {
$count++;
$line =~ s/\r//g;
chomp $line;
unless($line) { next; }
my @linearray = split(/,/,$line);
@linearray[0]=~ s/\'/'/g; # Escape single quote in street name
print OUT "<node id=\"-".$count."\" lat=\"".@linearray[4]."\" lon=\"".@linearray[3]."\"><tag k='addr:street' v='".@linearray[0]."' /><tag k='addr:housenumber' v='".@linearray[1].trim(@linearray[2])."' /><tag k='source' v='Tel Aviv municipality' /><tag k='contact:website' v='http://www.tel-aviv.gov.il/OnlineServices/DataTLV/Pages/Data%20Tel-Aviv.aspx' /></node>\n";
}
# Closing XML
print OUT "</osm>\n";
close(SHAPES);
close(OUT);
Then I checked and uploaded the .osm file with JOSM.
Cool, thanks.
I’m going to adupt this for the Tel-Ofan bicycle_rental.
https://wiki.openstreetmap.org/wiki/Tag:amenity%3Dbicycle_rental
I asked Tel-O-Fun guys once if they want to share their database, but got no answer.
Were you more lucky?
Haven’t even tried.
A list of stations, their addresses and coordinations is published under the Tel-Aviv muni data site, under the same license so I see no problen using it.
Then perfect! But we already have many of them, so need to carefully merge.
Great Job on the Tel-Aviv house numbers import!!!
I see that the addr:city and addr:country tags are not used.
Is this on purpose?
If so, how would a search for a popular street name, like “הרצל”, select the desired city?
There is a relation for the city of Tel-Aviv Yafo that marks the border of the city.
Applications and search engines based on OSM are checking for this relations and if exist, they know the city name and country.
City relation : http://www.openstreetmap.org/browse/relation/1382494
Adding the addr:city and addr:country tag is only mandatory if there is no city relation- what is not the case in Israel.
We have very well defined city definitions all over Israel. No issue with that
I’d like to better understand how this can be done.
For example, is there a way to query the OSM DB for all the streets in Tel-Aviv based on this relation?
Similarly, is there a way to query the DB for items in Israel only based on its borders relations?