New gov data source

msayag · 2012-12-26 08:52:11

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?

eric22 · 2012-12-26 09:41:40

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/\'/&apos;/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.

Last edited by eric22 (2012-12-26 10:29:08)

msayag · 2012-12-26 09:45:35

Cool, thanks.

I'm going to adupt this for the Tel-Ofan bicycle_rental.

https://wiki.openstreetmap.org/wiki/Tag … cle_rental

yrtimiD · 2012-12-26 10:05:14

msayag wrote:

I'm going to adupt this for the Tel-Ofan bicycle_rental.

I asked Tel-O-Fun guys once if they want to share their database, but got no answer.
Were you more lucky?

msayag · 2012-12-26 10:10:41

yrtimiD wrote:

msayag wrote:
I'm going to adupt this for the Tel-Ofan bicycle_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.

yrtimiD · 2012-12-26 10:34:01

msayag wrote:

A list of stations, their addresses and coordinations is published under the Tel-Aviv muni data site

Then perfect! But we already have many of them, so need to carefully merge.

zstadler · 2013-01-28 07:51:03

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?

Mr_Israel · 2013-01-28 10:20:40

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

zstadler · 2013-02-02 08:24:39

Mr_Israel wrote:

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?

Announcement

#26 2012-12-26 08:52:11

Re: New gov data source

#27 2012-12-26 09:41:40

Re: New gov data source

#28 2012-12-26 09:45:35

Re: New gov data source

#29 2012-12-26 10:05:14

Re: New gov data source

#30 2012-12-26 10:10:41

Re: New gov data source

#31 2012-12-26 10:34:01

Re: New gov data source

#32 2013-01-28 07:51:03

Re: New gov data source

#33 2013-01-28 10:20:40

Re: New gov data source

#34 2013-02-02 08:24:39

Re: New gov data source

Board footer