fixed failing unit tests and added one for the spot_location in schema

refs SPOT-624