[OSM-talk-be] the state of OpenStreetmap in Antwerpen

[ivom]

Cool idea you've worked out Luc! This thread is already open for some 
time, but I thought to pick in on this, since I just had another one with 
the same data:

Currently there are some landuse=residential polygons to fill the 
residential areas (mapnik), but they are not mapped to the district 
borders, as you might have noticed.

>From the list you grabbed from the antwerpen.be site, I thinks it is 
doable to determine the borders of every district. I am uncertain if using 
this data for this purpose is legal, any ideas?

First idea to practically work this out is, by matching every street to 
it's neighbours and check, where the postcode changes = where the border 
is. As I am a total noob with postgis, I probably will take some time make 
this promise a reality....

Kind regards,
Ivo

On Thu, 7 Aug 2008, Luc Van den Troost wrote:

> As I needed to extract all the streets from Antwerpen from the OSM
> database (needed for a custom streetfinder - see previous mail), I
> wanted to compare the list of streets with the 'official streetname
> list' of Antwerpen. 
>
>
> The official streetname list is an official and open document. It is
> presented on the city of Antwerpen website as a PDF document. 
>
>
> Antwerpen has something over 3000 streets. I didn't want to compare them
> manualy and decided this was something for a computer to do...
>
>
> I converted the PDF document to a TXT document, and had a simple perl
> script extracting all the streetnames and postcodes. 
>
>
> Most of the streets are converted fine, some got corrupted trough the
> whole process. This is particularly the case for streetnames having
> signs with a 'trema' (ë ü ï) in it. 
>
>
> I had a script comparing the streetnames from the official list with the
> names from the OSM database. 
>
>
> This is the summarized result:
>
>
> postcode
>
>
> description
>
>
> number of
> streets
>
>
> missing or
> incorrect
>
>
> % done
>
>
> 2000
>
>
> centrum
>
>
> 437
>
>
> 40
>
>
> 91
>
>
> 2018
>
>
> zuid + Berchem
>
>
> 233
>
>
> 48
>
>
> 79
>
>
> 2020
>
>
> Kiel
>
>
> 144
>
>
> 68
>
>
> 53
>
>
> 2030
>
>
> Luchtbal
>
>
> 236
>
>
> 175
>
>
> 26
>
>
> 2040
>
>
> Stabroek
>
>
> 151
>
>
> 135
>
>
> 11
>
>
> 2050
>
>
> Linkeroever
>
>
> 95
>
>
> 79
>
>
> 17
>
>
> 2060
>
>
> A'pen noord
>
>
> 201
>
>
> 90
>
>
> 55
>
>
> 2100
>
>
> Deurne
>
>
> 288
>
>
> 103
>
>
> 64
>
>
> 2140
>
>
> Borgerhout
>
>
> 211
>
>
> 61
>
>
> 71
>
>
> 2170
>
>
> Merksem
>
>
> 250
>
>
> 220
>
>
> 12
>
>
> 2180
>
>
> Ekeren
>
>
> 165
>
>
> 101
>
>
> 39
>
>
> 2600
>
>
> Berchem
>
>
> 242
>
>
> 14
>
>
> 94
>
>
> 2610
>
>
> Wilrijk
>
>
> 302
>
>
> 174
>
>
> 42
>
>
> 2660
>
>
> Hoboken
>
>
> 239
>
>
> 151
>
>
> 37
>
>
>
>
> Some remarks on 'wrong results':
>
>
> Streets falsely marked: streets that come out of the official list with
> 'extra descriptions' like 'pair numbers' or 'nr. 75 to 85'; streets that
> are still in the official streetlist but are no real streets
> (Falcompoort, is just a – closed – gate) or are disappeared (4 streets
> now occupied by the MAS building warf), also some streets containing
> special characters like d'Herbouville. 
>
>
> Streets falsely not marked:
>
> our script will do a lookup of every street from the official list in
> the OSM database. If the street is found within the OSM name it will not
> appear. For instance Meir would also match 'Meirbrug'. If meir would not
> be on the map, it would not be displayed. 
>
> If a long street is mapped in different parts, and one part is named
> correctly, the name will not appear in the list. 
>
>
> The list of 'missing' streetnames, with postcode, is available in CSV
> file on 
>
>
> http://www.bb2000.be/stratenzoeker/vergelijkstraten.csv
>
> This is based on the streets available in openstreetmap on 2nd of august
> 2008.
>
> I'll try to make an updated list something like monthly... 
>
> Who is doing mapping in Antwerpen, and knows some streets, might have a
> look at the list. 
> Streets on this list are (either)
> - misspelled
> - tagged with wrong name
> - unnamed
> - missing
>
> Unless something went wrong with the transformations. 
>
> Luc.
>
>
>
>
> _______________________________________________
> Talk-be mailing list
> Talk-be at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk-be