PostGIS distance calculation gives in-accurate 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);
Was this page helpful?