Unfortunately the data is coming to me from a tool I do not control. I simply will be importing the data and allowing someone to associate the data provided with areas and nodes on the map. Most of the data will be for the US, but there is no guarantee that the addresses are correctly formatted which is why I am worried about doing something simple like assuming the house number is always first and is even always present.
Seems to me like the best thing to do would be to skip the street address fields and simply use the ones which have a 1-1 mapping (city, country, state/province, postal code, phone). Leave the address for someone else. J.M. From: john whelan [mailto:jwhelan0...@gmail.com] Sent: Monday, February 28, 2011 3:58 PM To: John-Michael Wiley Cc: talk@openstreetmap.org Subject: Re: [OSM-talk] Addresses Tricky because of the accuracy. My money would be to add a two fields and put the lat and long coordinates in there. I'd also use a database rather than Excel such as SQL server there are better validation tools available. Then you really need manual verification you have the correct location. I've dropped some items in by address in Ottawa, you can get close but you need to verify because a shopping Mall may have a single street address so many stores have the same address. If I think in terms of a database for people that feeds multiple needs eg HR, phone etc. You sort of need a key such that you can key a building then link it to other information such as name, opening hours, phone number etc. Since you have a Microsoft email address think in terms of OSM is an XML file and then think Biztalk. You may want to email me a little off line on this since this is more electronic map than OSM normally likes to think of itself. Cheerio John On 28 February 2011 18:11, John-Michael Wiley <jmwi...@microsoft.com<mailto:jmwi...@microsoft.com>> wrote: I am working on a project which will be importing items from excel and putting them on the map. The items (shops, buildings,...) have got address but they do not have the house numbers separated the street name, nor is it always the case that the house number is included. It is not a simple parsing task to parse these field for every locale, so I am wondering what I should do with it. Should I put it into a new tag, should I use the full? How can I add this information to the entity without making errors in the street or house number fields? Thanks, J.M. Wiley _______________________________________________ talk mailing list talk@openstreetmap.org<mailto:talk@openstreetmap.org> http://lists.openstreetmap.org/listinfo/talk
_______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk