#Calculate distance using PostGIS

1 messages · Page 1 of 1 (latest)

jolly imp
#

This is what I am currently using, it shows inaccurate results

    @Query(value = "SELECT ST_Distance(" +
            "ST_SetSRID(ST_MakePoint(:userLng, :userLat), 4326), " +
            "ST_SetSRID(ST_MakePoint(:hotelLng, :hotelLat), 4326)" +
            ") AS distance", nativeQuery = true)
    Double hotelDistanceBetweenUser2(@Param("userLng") Double userLongitude,
                                     @Param("userLat") Double userLatitude,
                                     @Param("hotelLng") Double hotelLongitude,
                                     @Param("hotelLat") Double hotelLatitude);

The distanceFromRepo is where I used PostGIS, distanceFromAlgorithm is where I used Vincenty's algorithm. It is the accurate result, please tell me what I am doing wrong here?

tranquil sorrelBOT
#

<@&1004656351647117403> please have a look, thanks.

jolly imp
lilac vector
#

ST_distance returns degrees, your method returns kilometers