Owners of multiple parcels

SELECT owner, count(*) parcels FROM parcel96

WHERE owner LIKE '%BOSTON%'

GROUP BY owner HAVING count(*) > 1

ORDER BY count(*) desc;

OWNER PARCELS

------------------------------ ----------

CITY OF BOSTON 2876

CITY OF BOSTON BY FCL 1258

BOSTON REDEVELOPMENT AUTH 231

BOSTON HOUSING AUTHORITY 215

BOSTON KENMORE REALTY CORP 131

BOSTON UNIVERSITY TRSTS OF 111

CITY OF BOSTON FCL 98

BOSTON WHARF CO GPS 88

BOSTON REDEVELOPMENTAUTH 83

BOSTON REDEVELOPMNT AUTH 82

ROMAN CATH ARCH BOSTON 63

BOSTON REDVLPMNT AUTH 60

BOSTON UNIVERSITY TRSTS 56

BOSTON HOUSING AUTH 46

BOSTON UNIVERSITY TRS OF 44

Previous slide

Next slide

Back to first slide

View graphic version