Clean up the address field

Change Boulevard to Blvd update locations set street = replace(street, 'Boulevard', 'Blvd') where street ilike '%Boulevard'

update locations set street = replace(street, 'Drive', 'Dr') where street ilike '%Drive'

update locations set street = replace(street, 'Street', 'St') where street ilike '%Street'

update locations set street = replace(street, 'Avenue', 'Ave') where street ilike '%Avenue'

update locations set street = replace(street, 'Southwest', 'SW') where street ilike '%Southwest%'

update locations set street = replace(street, 'Southeast', 'SE') where street ilike '%Southeast%'

update locations set street = replace(street, 'Northwest', 'NW') where street ilike '%Northwest%'

update locations set street = replace(street, 'Northeast', 'NE') where street ilike '%Northeast%'

Also look for lowercase select name from locations where street like '%street%';