## SpatiaLite Cookbook Chapter 07: Exotic Cooking aspects, which are often forgotten (or avoided) |

last updated: 2018-10-08

Back to the SpatiaLite home page. Previous Chapter Chapter 06: Cooking basics, which are useful to know. Back to the Cookbook home page. Next Chapter SpatiaLite Cookbook: How to Sql samples

Central angleis shown asΘ(theta)

Segmentis the area betweenchordandarc length.

Sagitta(short) is the height of thesegment/Arc.

- Geodesic
**ArcLength**

Surface measurement from point 1 to 2, on the outer circle arc / earth surface.

The distance along the curved line making up the arc.

- Geodesic
**ChordLength**

Shortest line (chord) from point 1 to 2, through the circle / earth.

The region between a chord of a circle and its associated arc.

- Geodesic
**CentralAngle**

Central angle from arc length in meters together with the radius (a) in meters.

Central Angle - the center of a circle by two given points on the circle.

- Geodesic
**ArcHeight**

Height of segment [short-sagitta] in meters**yellow line in image -->**

Sagitta - The height of an arc or segment.

- Geodesic
**ArcArea**

Area of arc [short-sagitta] in meters**cyan area in image-->**

Area of a circle segment given the central angle.

since all projections use

From: North/Western point of the North Island.

To: Southern most point of the South Island.

SELECT

1450994.109302

surface distance, without any hills/moutains

SELECT

1447867.187222

shortest distance,

SELECT

13.034502

angle from the center of the earth to the points

SELECT

41217.263818

from the middle point of the shortest line to the surface (ocean)

SELECT

39810530621.627159

area between points, along Shortest Line and Surface measurement

Back to the SpatiaLite home page. Previous chapter Chapter 06: Cooking basics, which are useful to know. Back to the Cookbook home page. Next Chapter SpatiaLite Cookbook: How to Sql samples

last updated: 2018-10-08