added altitude and direction to locations
separated create SQL from default inserts