here is a spatial view for address points

this is the base view used for creating bc address points
removed junk, unabbrev things

removed parts unneeded and decoded abbreviated things
working on isolating Mc names

Doing some sql testing to find and replace Special words that don't
capitalize well