Store Corrections in ‘Lookup Table’
select oldowner, owner, owngrp
where owner like '%CITY%';
------------------------------ ------------------------------ --------------------
BOSTON CITYWIDE LAND TRUST I BOSTON CITYWIDE LAND TRUST I xxxxxxxxxxxxxxxxxxxx
CITY DEVELOPMENT CORP TRST CITY DEVELOPMENT CORP TRST xxxxxxxxxxxxxxxxxxxx
CITY DEVELOPNMENT CORP CITY DEVELOPNMENT CORP xxxxxxxxxxxxxxxxxxxx
CITY HEIGHTS CONDOMINIUM TR CITY HEIGHTS CONDOMINIUM TR xxxxxxxxxxxxxxxxxxxx
CITY OF BOSTON CITY OF BOSTON BOSTON
CITY OF BOSTON CITY OF BOSTON BOSTON
CITY OF BOSTON MUNICIPAL CITY OF BOSTON BOSTON
CITY OF BOSTON BY FCL CITY OF BOSTON BY FCL BOSTON FORECLOSURE
CITY OF BOSTON BY F CL CITY OF BOSTON BY FCL BOSTON FORECLOSURE
BOSTON HOSPITAL FOR WOMEN BOSTON HOSPITAL FOR WOMEN xxxxxxxxxxxxxxxxxxxx
BOSTON HOTEL LP BOSTON HOTEL LP xxxxxxxxxxxxxxxxxxxx
BOSTON HOUSING AUTH BOSTON HOUSING AUTHORITY BOSTON BHA
BOSTON HOUSING AUTHORITY BOSTON HOUSING AUTHORITY BOSTON BHA
BOSTON HOUSING AUTHOURTY BOSTON HOUSING AUTHORITY BOSTON BHA
BOSTON INDIAN COMMUNITY BOSTON INDIAN COMMUNITY xxxxxxxxxxxxxxxxxxxx
145-149 W SIXTH ST CONDO TR 145-149 W SIXTH ST CONDO TR xxxxxxxxxxxxxxxxxxxx
176 FEDERAL REALTY CP 176 FEDERAL REALTY CP xxxxxxxxxxxxxxxxxxxx
21R UNION AVE CONDO TRUST 21R UNION AVE CONDO TRUST xxxxxxxxxxxxxxxxxxxx
236 BEACON CONDO TRUST 236 BEACON CONDO TRUST xxxxxxxxxxxxxxxxxxxx