Via Cà Matta 2 - Peschiera Borromeo (MI)
+39 02 00704272
info@synaptica.info

The Haversine formula in Firebird SQL => Calculate distance between two WGS84 Points

Digital solution partner

The Haversine formula in Firebird SQL => Calculate distance between two WGS84 Points

haversine

Hi,
I think might be helpful, today for a customer i do the Haversine formulas for Firebird Sql as a stored procedure.

This formula allow you to calculate the distance in meter between two WGS84 datum points(degree points of Earth).

You can call the procedure like this:

The result wil be aprox 14Km, the distance from my office and my house aprox.

the parameters of the procedure are:

The procedure code is:

Leave a Reply