threw together an api to retrieve locations. not sure wise the db schema is, but it works for now