Postgrep SQL Geometry measurement function

1. Measuring area st_area (geometry)

2, according to the latitude and longitude points to calculate the distance on the earth surface, unit meters, the earth radius value of 6370986 meters st_distance_sphere (point, point)

Similarly, using the specified earth ellipsoid parameter st_distance_spheroid (point, Point, spheroid)

3. Measuring 2D object length st_length2d (geometry)

4. Measuring 3D object length st_length3d (geometry)

5, calculate the length on the earth surface according to the latitude and longitude object St_length_spheroid (geometry,spheroid)

St_length3d_spheroid (geometry,spheroid)

6. Measurement of two objects distance st_distance (geometry, geometry)

7, measuring the maximum distance between two lines st_max_distance (linestring,linestring)

8. Measure the perimeter of the 2D object St_perimeter (geometry)

St_perimeter2d (geometry)

9. Measure the perimeter of the 3D object St_perimeter3d (geometry)

10. Measuring the azimuth angle of two points, Unit radian St_azimuth (geometry, geometry)

This article from the "Simple can rely on" blog, reproduced please contact the author!

Postgrep SQL Geometry measurement function