[Mobilitydb-dev] Error in function ST_Azimuth in PostGIS version 3.1.1?

Esteban Zimanyi esteban.zimanyi at ulb.be
Sun Aug 29 07:37:54 PDT 2021


I am working on the workflow for integrating MobilityDB and PostGIS 3.
Travis is easier than Github Actions for this, since it enables to see
immediately the log file of the test database.
https://app.travis-ci.com/github/MobilityDB/MobilityDB/jobs/534416657
The PostGIS version installed is 3.1.1

I receive an error in the tests working with azimuth. I added an additional
test to trace the problem as follows.

----------------------------------------
SELECT postgis_full_version();

POSTGIS="3.1.1 aaf4c79" [EXTENSION] PGSQL="130" GEOS="3.7.1-CAPI-1.11.1
27a5e771" PROJ="Rel. 4.9.2, 08 September 2015" LIBXML="2.9.3"
LIBJSON="0.11.99" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)"
(1 row)

SELECT degrees(st_azimuth(geography 'Point(2.5 2.5)', 'Point(1.5 1.5)'));

 314.8067300104262
(1 row)
----------------------------------------

When I execute the same query in version 3.1.3 I have a correct result

----------------------------------------
select postgis_full_version();

 POSTGIS="3.1.3 008d2db" [EXTENSION] PGSQL="130" GEOS="3.8.0-CAPI-1.13.1 "
PROJ="6.3.1" LIBXML="2.9.10" LIBJSON="0.13.1"
 LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"
(1 row)

select degrees(st_azimuth(geography 'Point(2.5 2.5)', 'Point(1.5 1.5)'));

 225.19326998957385
(1 row)
----------------------------------------

@Regina Obe <lr at pcorp.us> Any idea how to solve this issue ?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mobilitydb-dev/attachments/20210829/ce054d8f/attachment.html>


More information about the Mobilitydb-dev mailing list