<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">Hi Chas, good to see you on here.<div><br></div><div>The most important thing to note is that addresses should be applied to buildings and not as points. The "Materials (inputs, code, output)” link on the import page doesn’t work so I can’t see how they’re being applied.</div><div><br></div><div>Please let me know if you’d like any help with the application of house numbers to buildings in bulk as I’ve done this elsewhere.</div><div><br></div><div>Tyler Brown Cifu Shuster<br><div><br><blockquote type="cite"><div>On Feb 9, 2023, at 1:50 PM, Belov, Charles <Charles.Belov@sfmta.com> wrote:</div><br class="Apple-interchange-newline"><div><meta charset="UTF-8"><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">I am proposing importing all San Francisco addresses with their corresponding latitude and longitude, as served by DataSF at<span class="Apple-converted-space"> </span><a href="https://data.sfgov.org/Geographic-Locations-and-Boundaries/Addresses-Enterprise-Addressing-System/3mea-di5p" style="color: blue; text-decoration: underline;">Addresses - Enterprise Addressing System</a><span class="Apple-converted-space"> </span>(<a href="https://data.sfgov.org/Geographic-Locations-and-Boundaries/Addresses-Enterprise-Addressing-System/3mea-di5p" style="color: blue; text-decoration: underline;">https://data.sfgov.org/Geographic-Locations-and-Boundaries/Addresses-Enterprise-Addressing-System/3mea-di5p</a>) 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.<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">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.<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">I note there is an OpenStreetMap wiki page<span class="Apple-converted-space"> </span><a href="https://wiki.openstreetmap.org/wiki/San_Francisco_Address_Import" style="color: blue; text-decoration: underline;">San Francisco Address Import</a>(<a href="https://wiki.openstreetmap.org/wiki/San_Francisco_Address_Import" style="color: blue; text-decoration: underline;">https://wiki.openstreetmap.org/wiki/San_Francisco_Address_Import</a>) which was last updated in 2020 and noted as ready for review. I’ve requested access to the review.<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">That said, we now presumably have three more years of data and would want to re-generate the review data.<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">Please advise. I am cross-posting this proposal to the Imports and Talk-US-SFBay mailing lists.<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">Hope this helps,<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><b><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><o:p> </o:p></span></b></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><b><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">Charles Belov<o:p></o:p></span></b></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">he/him<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">Acting Webmaster<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">Communications & Marketing<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><span id="cid:image001.png@01D93C88.91A097A0"><image001.png></span><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">San Francisco Municipal Transportation Agency<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">1 South Van Ness Avenue, 3rd floor<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;">San Francisco, CA 94103<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><a href="https://www.instagram.com/sfmtaphoto/" style="color: blue; text-decoration: underline;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif; color: windowtext; text-decoration: none;"><span id="cid:image002.jpg@01D93C88.91A097A0"><image002.jpg></span></span></a><a href="https://www.facebook.com/SFMTA.Muni/" style="color: blue; text-decoration: underline;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif; color: windowtext; text-decoration: none;"><span id="cid:image003.jpg@01D93C88.91A097A0"><image003.jpg></span></span></a><a href="https://twitter.com/sfmta_muni" style="color: blue; text-decoration: underline;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif; color: windowtext; text-decoration: none;"><span id="cid:image004.jpg@01D93C88.91A097A0"><image004.jpg></span></span></a><a href="https://www.sfmta.com/" style="color: blue; text-decoration: underline;"><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif; color: windowtext; text-decoration: none;"><span id="cid:image005.png@01D93C88.91A097A0"><image005.png></span></span></a><span style="font-size: 12pt; font-family: "Graphein Pro Light", sans-serif;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div></div><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">Imports mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><a href="mailto:Imports@openstreetmap.org" style="color: blue; text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;">Imports@openstreetmap.org</a><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><a href="https://lists.openstreetmap.org/listinfo/imports" style="color: blue; text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;">https://lists.openstreetmap.org/listinfo/imports</a></div></blockquote></div><br></div></body></html>