By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| name | name | lat1 | lat | lat2 | lng1 | lng | lng2 |
|---|---|---|---|---|---|---|---|
| Auckland test | Auckland | -35.0000000000 | -36.0000000000 | -37.0000000000 | 173.0000000000 | 174.0000000000 | 175.0000000000 |
| Alaska test | Alaska | 64.0000000000 | 63.0000000000 | 62.0000000000 | -159.0000000000 | -158.0000000000 | -157.0000000000 |
| Lng 180 test | Auckland | 64.0000000000 | -36.0000000000 | -37.0000000000 | 173.0000000000 | 174.0000000000 | -157.0000000000 |
| Lng 180 test | Alaska | 64.0000000000 | 63.0000000000 | -37.0000000000 | 173.0000000000 | -158.0000000000 | -157.0000000000 |
| Lat 90 test | Auckland | -35.0000000000 | -36.0000000000 | 62.0000000000 | 173.0000000000 | 174.0000000000 | -157.0000000000 |
| Lat 90 test | Alaska | -35.0000000000 | 63.0000000000 | 62.0000000000 | 173.0000000000 | -158.0000000000 | -157.0000000000 |