Wrong Calculated distance in PostGIS

How do I find the distance between two points in PostGIS?

ST_Distance in PostGIS



To construct a basic query in SQL to find the distance between two points, use the ST_Distance function. ST_Distance is flexible in that you can pass in geometry or geography type object (see here for more information on these object types).
 

What is ST_Distance?

Definition. ST_Distance returns the distance between two geometries. The distance is measured from the closest vertices of the two geometries.

What is the difference between geometry and geography data in PostGIS?

PostGIS gives you a choice of two different ways to store geospatial data: Geometry, where it assumes all of your data lives on a Cartesian plane (like a map projection); Geography, where it assumes that your data is made up of points on the earth’s surface, as specified by latitudes and longitudes.
 

How do you find the distance between two waypoints?

To measure the distance between two points:

1. On your computer, open Google Maps.
2. Right-click on your starting point.
3. Select Measure distance.
4. To create a path to measure, click anywhere on the map. To add another point, click anywhere on the map.
5. When finished, on the card at the bottom, click Close .

How do I calculate the distance between two points?

Distance between two points is the length of the line segment that connects the two points in a plane. The formula to find the distance between the two points is usually given by d=√((x₂ – x₁)² + (y₂ – y₁)²).

What is Srid in geometry?

A spatial reference identifier (SRID) is a unique identifier associated with a specific coordinate system, tolerance, and resolution.