Added distance_from_parent column to locations
 Added example for self join with extra join condition of distance