| 22 | |
| 23 | * Distance - Spherical |
| 24 | {{{ |
| 25 | select distance_sphere( |
| 26 | (transform(GeomFromText('Point(lon lat)'), 900913), |
| 27 | (transform(GeomFromText('Point(lon lat)'), 900913); |
| 28 | }}} |
| 29 | |
| 30 | * Distance - Spheroid |
| 31 | {{{ |
| 32 | select distance_spheroid( |
| 33 | (GeomFromText('Point(lon lat)'), 900913), |
| 34 | (GeomFromText('Point(lon lat)'), 900913), |
| 35 | 'SPHEROID["GRS 1980", 6378137, 298.257222101]'); |
| 36 | }}} |
38 | | * Spherical distance |
39 | | {{{ |
40 | | select distance_sphere( |
41 | | (transform(GeomFromText('Point(lon lat)'), 900913), |
42 | | (transform(GeomFromText('Point(lon lat)'), 900913); |
43 | | }}} |
44 | | |
45 | | * Spheroid distance |
46 | | {{{ |
47 | | select distance_spheroid( |
48 | | (GeomFromText('Point(lon lat)'), 900913), |
49 | | (GeomFromText('Point(lon lat)'), 900913), |
50 | | 'SPHEROID["GRS 1980", 6378137, 298.257222101]'); |
51 | | }}} |