<div dir="ltr"><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">Interesting. My question for Massgis is "Jonathan Nutting Road" exists as and "ACTIVE" address in the Groton "AdvancedAddresses_M115" xls file I downloaded from <a href="http://massgis.maps.arcgis.com/apps/View/index.html?appid=530eb45188934e23a8703399fd37bf0f">http://massgis.maps.arcgis.com/apps/View/index.html?appid=530eb45188934e23a8703399fd37bf0f</a></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">
<table cellspacing="0" border="0" style="font-family:Calibri;font-size:x-small">
<colgroup width="141"></colgroup>
<colgroup width="135"></colgroup>
<colgroup width="155"></colgroup>
<colgroup span="25" width="64"></colgroup>
<tbody><tr>
<td height="20" align="right" valign="bottom" style="font-family:Calibri"><font color="#000000">126447097</font></td>
<td align="right" valign="bottom" style="font-family:Calibri"><font color="#000000">1094579</font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000">1 JONATHAN NUTTING ROAD</font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000">1</font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000">JONATHAN NUTTING ROAD</font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000">GROTON</font></td><td align="left" valign="bottom" style="font-family:Calibri"></td>
<td align="right" valign="bottom" style="font-family:Calibri"><font color="#000000">115</font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000">ACTIVE</font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="right" valign="bottom" style="font-family:Calibri"><font color="#000000">1</font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000"><br></font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000">JONATHAN NUTTING</font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000">ROAD</font></td>
<td align="left" valign="bottom" style="font-family:Calibri"><font color="#000000">RD<br><br><br></font></td>
</tr>
</tbody></table></div><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div dir="ltr"><div><font face="arial, helvetica, sans-serif" size="4"><br></font></div><div><font face="arial, helvetica, sans-serif" size="4">H<div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large;display:inline">owever, it cannot be found in the on-line massgis address viewer at </div></font><font face="trebuchet ms, sans-serif" size="4"><a href="http://massgis.maps.arcgis.com/home/webmap/viewer.html?useExisting=1&layers=a0049ad319674c439516b2df1173d8f5">http://massgis.maps.arcgis.com/home/webmap/viewer.html?useExisting=1&layers=a0049ad319674c439516b2df1173d8f5</a></font></div><div><font face="arial, helvetica, sans-serif" size="4"><br></font></div><div><font face="arial, helvetica, sans-serif" size="4">W<div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large;display:inline">hy do the two ways to view the same information differ?</div></font></div><div><font face="arial, helvetica, sans-serif" size="4"><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large;display:inline">Do we understand the address point data?</div></font></div><div><font face="arial, helvetica, sans-serif" size="4">Alan<br></font></div></div></div></div></div><br><br><div class="gmail_quote"><div dir="ltr">On Sat, Aug 11, 2018 at 1:37 PM Jason Remillard <<a href="mailto:remillard.jason@gmail.com">remillard.jason@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div>Hi Yury,</div><div><br></div><div><br></div><div><div>One point, JONATHAN NUTTING ROAD, had a road name that didn't match anything. The towns assessor database had a different address that matched a road name. I think MAD is incorrect.<br></div></div><br></div><div><br></div><div><br></div><div>Jason<br></div><div><div><br></div><div> <br></div><div><br></div><div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Fri, Aug 10, 2018 at 12:05 PM Yury Yatsynovich <<a href="mailto:yury.yatsynovich@gmail.com" target="_blank">yury.yatsynovich@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Greetings!<br clear="all"><div>I've modified my code so that now it does some fuzzy matches between OSM streets and MassGIS addresses and marks as problematic only those MassGIS point that do not pass this fuzzy match.</div><div><br></div><div>Details on the steps implemented for fuzzy matches:<br></div><div>1) the code expands abbreviations in OSM streets' names like "Str", "Ln", etc. to "Street", "Lane", etc.</div><div>2) the status parts at the end of the streets' names (like "Street", "Road", "Lane") are dropped. So "Sunset Street" and "Sunset Drive" turn into just "Sunset"<br></div><div>3) the code converts OSM and MassGIS street names to upper case.</div><div>4) the code removes symbols like ".", "'", "," and blanks <br></div><div>5) the code considers similar strings (up to 90% similarity) as the same<br></div><div><br></div><div>E.g., if OSM has "New Miller's Street", while MassGIS has nearby address points with "NEW MILLER ROAD", the above mentioned steps will convert the streets' names into "NEWMILLERS" and "NEWMILLER" and consider them as the same. For more details, please, see <a href="https://github.com/yyatsyn/MassGIS-address-import/blob/master/import_addresses_fuzzy_match_names_work_in_progress.py" target="_blank">https://github.com/yyatsyn/MassGIS-address-import/blob/master/import_addresses_fuzzy_match_names_work_in_progress.py</a>.<br><br></div><div>The resulting files are in the folder: <a href="https://mega.nz/#F!79Ny3KKL!JemAt7yZKSUctrza8QU4Tg" target="_blank">https://mega.nz/#F!79Ny3KKL!JemAt7yZKSUctrza8QU4Tg</a><br><br></div><div>The fuzzy match shows that there are not that many severe problems: around 300 points and 400 buildings with addresses in OSM need some attention (comparing to 1 and 2K when using exact matches for streets' names), as well as, maybe, 5-10 streets per town are found to need corrections after being compared to MassGIS (mostly those are the streets without names or with some extra words like "Main Street Extension" or "East Main Street" vs "Main Street"). <br></div><div><br></div><div>I would suggest that we add/correct names of the streets (350 towns, 5-10 streets in each town -- sounds doable for manual edits), re-run the fuzzy matching code again and whatever MassGIS points are marked as problematic after that -- will be inspected individually.<br></div><div><br></div><div>Any feedback is more than welcome!<br></div><div>-- <br><div dir="ltr" class="gmail-m_3773865227071589577m_161237198633173621gmail_signature">Yury Yatsynovich</div></div></div>
_______________________________________________<br>
Talk-us-massachusetts mailing list<br>
<a href="mailto:Talk-us-massachusetts@openstreetmap.org" target="_blank">Talk-us-massachusetts@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/talk-us-massachusetts" rel="noreferrer" target="_blank">https://lists.openstreetmap.org/listinfo/talk-us-massachusetts</a><br>
</blockquote></div>
_______________________________________________<br>
Talk-us-massachusetts mailing list<br>
<a href="mailto:Talk-us-massachusetts@openstreetmap.org" target="_blank">Talk-us-massachusetts@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/talk-us-massachusetts" rel="noreferrer" target="_blank">https://lists.openstreetmap.org/listinfo/talk-us-massachusetts</a><br>
</blockquote></div></div>