<div dir="ltr"><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">I downloaded the address list for Bedford and Malden from <a href="https://docs.digital.mass.gov/dataset/massgis-data-master-address-data-basic-address-list" target="_blank">https://docs.digital.mass.gov/dataset/massgis-data-master-address-data-basic-address-list</a> </div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">I opened them in LibreOffice Calc and looked at the status code for each address.</div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large"><br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">Most had a status code of Active or Modified and should be imported. </div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">I think we should think hard about the other status codes.</div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large"><br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">Active: Bedford  6112, Malden 16,798</div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">

<span style="background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Modified Bedford 0, Malden 145</span>

<br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large"><br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">Inactive: Bedford 43, Malden 12</div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">

<span style="background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Unassigned Bedford 73, Malden 535</span></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">



<span style="background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Site Review: Bedford 24, Malden 4</span></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">



<span style="background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Review: Bedford 143, Malden 109</span>

<br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">Not Found: Bedford 2, Malden 61</div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large"><br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">Code Definitions</div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large"><br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">

<span style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;text-align:left;background-color:rgb(255,254,238);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Active: Address is assigned to an address point.</span>

<br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large"><br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large">

<div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal">INACTIVE: Address is obsolete.</span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal"><br></span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal">UNASSIGNED: Address not yet assigned to an address point.</span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal"><br></span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal">SITE_REVIEW: Address belongs to a site and requires review before becoming ACTIVE as the address can probably be further disaggregated to the building level.</span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal"><br></span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal">REVIEW: Address requires review before becoming active (for any reasons other than site disaggregation).</span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal"><br></span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal">NOT_FOUND: Address underwent review and a geographic location for it could not be found.</span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal"><br></span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal">GEOCODED: Address temporarily assigned to a geocoded point; still requires review to try to find a structure-based point instead.</span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal"><br></span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal">PARENT: Address record is temporary and represents an aggregation of other unit-specific addresses. This record's MASTER_ADDRESS_ID is equal to its PARENT_ADDRESS_ID.</span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal"><br></span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal">DCAM_REVIEW: Address record belongs to a state-owned property and requires review (preferably by DCAMM) before becoming active.</span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal"><br></span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal">MODIFIED: This address record is active and had one or more address component fields edited during FDC/local review.</span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal"><br></span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal">ADDED: This address record represents an address that was added as a new or missing address identified during FDC.  It should not have an address point ID.</span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal"><br></span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal">UNLINKED: </span><span style="font-weight:normal">The address point ID previously associated with this address record was removed during FDC/local review (but edit may have been overridden).</span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal"><br></span></div><div style="color:rgb(83,83,83);font-family:Texta,"Century Gothic",Helvetica,Arial,sans-serif;font-size:22px;font-weight:700;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;text-align:left"><span style="font-weight:normal">LINKED: This address is active and was associated with a non-geocoded address point during FDC/local review.</span></div>

<br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif;font-size:large"><br></div><div><div dir="ltr" class="m_-4530168303002803598m_7003596238949984192gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div><font face="arial, helvetica, sans-serif" size="4">Alan</font></div></div></div></div></div></div></div></div>