Skip to content

Distance and heading sql extensions #917

Description

@aa1vs

Problem Statement

Sometimes for filters distances between multiple points are needed or one does not want to change the database center. Gsak supports this with sql extension functions.

It would.be nice to have 2 versions or more for distance and azimuth functions.One would be a great circle calculator. The other would be a Vincenty or libproj high accuracy version. Fizzy calc uses this model.

The reason for multiple is some challenges use the great cricle calculation for reduced computational loading. The 360 challenges are like this. Others just use distance. The edge cases can be significant.

Proposed Solution

4 functions added to sqlite interface to support a low and high accuracy mode to distance amd azimuth functions. The accuracy mode may be a flag to 2 functions. Each takes 2 lat lon pairs.

For validation of performance, fizzy calc, project-gc, and libproj scripts are all suggestions.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions