[Imports] Proposed import of San Francisco addresses

[Eliot]

On 10/02/23 10:50, Belov, Charles wrote:
> I am proposing importing all San Francisco addresses with their corresponding latitude and longitude, as served by DataSF at Addresses - Enterprise Addressing System <https://data.sfgov.org/Geographic-Locations-and-Boundaries/Addresses-Enterprise-Addressing-System/3mea-di5p> (https://data.sfgov.org/Geographic-Locations-and-Boundaries/Addresses-Enterprise-Addressing-System/3mea-di5p <https://data.sfgov.org/Geographic-Locations-and-Boundaries/Addresses-Enterprise-Addressing-System/3mea-di5p>) as open data. Specifically, I am seeking to import the columns Address, Latitude, and Longitude. This is because not all San Francisco addresses are in OpenStreetMap, leading to unsuccessful matches when trying to retrieve missing addresses.
> 
> My concern is that many San Francisco addresses are already in OpenStreetMap, and there may be a conflict as to the Latitude and Longitude between those existing addresses and the San Francisco address data, leading to duplicate and mismatched data.

An import that creates duplicate data must not happen.

The most obvious solution to this is to remove all addresses that are already in OSM from your import dataset. I.e. import only the missing addresses.
The process of finding existing addresses that are wrong (location,  name, number etc) and fixing them could be considered as a separate project.

  
> I note there is an OpenStreetMap wiki page San Francisco Address Import <https://wiki.openstreetmap.org/wiki/San_Francisco_Address_Import> (https://wiki.openstreetmap.org/wiki/San_Francisco_Address_Import <https://wiki.openstreetmap.org/wiki/San_Francisco_Address_Import>) which was last updated in 2020 and noted as ready for review. I’ve requested access to the review.
> 

The files linked from the wiki page are not publicly accessible (requires google login).  They probably should be made publicly readable.

Tyler also said
> The most important thing to note is that addresses should be applied to buildings and not as points

Food for thought (I'm not local, so no opinions on what is right for you)
Does this imply that every building has at most one address?  An OSM object can't have more than one address.
How are units/apartments within multi-unit buildings addressed?

-- 
Eliot