[Imports] Proposed import of San Francisco addresses

Belov, Charles Charles.Belov at sfmta.com
Thu Feb 9 21:50:04 UTC 2023


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) 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.

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) which was last updated in 2020 and noted as ready for review. I’ve requested access to the review.

That said, we now presumably have three more years of data and would want to re-generate the review data.

Please advise. I am cross-posting this proposal to the Imports and Talk-US-SFBay mailing lists.


Hope this helps,

Charles Belov
he/him
Acting Webmaster
Communications & Marketing

[cid:image001.png at 01D93C88.91A097A0]



San Francisco Municipal Transportation Agency
1 South Van Ness Avenue, 3rd floor
San Francisco, CA 94103
[cid:image002.jpg at 01D93C88.91A097A0]<https://www.instagram.com/sfmtaphoto/>[cid:image003.jpg at 01D93C88.91A097A0]<https://www.facebook.com/SFMTA.Muni/>[cid:image004.jpg at 01D93C88.91A097A0]<https://twitter.com/sfmta_muni>[cid:image005.png at 01D93C88.91A097A0]<https://www.sfmta.com/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20230209/1ce8561c/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 4802 bytes
Desc: image001.png
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20230209/1ce8561c/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 998 bytes
Desc: image002.jpg
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20230209/1ce8561c/attachment-0003.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 968 bytes
Desc: image003.jpg
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20230209/1ce8561c/attachment-0004.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 984 bytes
Desc: image004.jpg
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20230209/1ce8561c/attachment-0005.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 3271 bytes
Desc: image005.png
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20230209/1ce8561c/attachment-0003.png>


More information about the Imports mailing list