17 Spellings of BRA
SELECT owner, count(*) parcels, sum(totalval)/1000 totval_k,
WHERE owner LIKE '%BOSTON%' AND
(owner LIKE '%REDEV%' or owner LIKE '%REDV%')
OWNER PARCELS TOTVAL_K ACRES
------------------------------ ------- ---------- ---------
BOSTON REDEVELOMENT AUTH 1 327 0.2
BOSTON REDEVELOPMENT 5 157 0.5
BOSTON REDEVELOPMENT AUTH 231 106,863 123.9
BOSTON REDEVELOPMENT AUTHRTY 3 61 0.1
BOSTON REDEVELOPMENTAUTH 83 0 11.9
BOSTON REDEVELOPMENTAUTHRTY 1 0 0.1
BOSTON REDEVELOPMNT AUTH 82 32,975 23.3
BOSTON REDEVELPMENT AUTH 41 1,418 3.0
BOSTON REDEVELPMNT AUTH 22 5,073 2.4
BOSTON REDEVELPOMENT AUTH 1 33 0.2
BOSTON REDEVLPMNT AUTH 28 7,488 3.2
BOSTON REDEVLPMNT AUTHOR 29 2,955 3.3
BOSTON REDEVLPMNT AV 1 0 0.0
BOSTON REDVLPMNT AUTH 60 2,472 7.8
BOSTON REDVLPMNT AUTHOR 15 3,416 1.8
BOSTON REDVLPMNT AUTHORITY 1 1,095 0.5
BOSTON REDVLPMNT CORP 1 662 0.1
------------------------------ ------- ---------- ---------
BOSTON REDEVELOPMENT AUTH 605 164,991 182.3