Related Documentation Download this Manual
PDF (US Ltr) - 33.8Mb
PDF (A4) - 34.0Mb
PDF (RPM) - 33.2Mb
EPUB - 8.5Mb
HTML Download (TGZ) - 8.2Mb
HTML Download (Zip) - 8.2Mb
HTML Download (RPM) - 7.1Mb
Eclipse Doc Plugin (TGZ) - 9.0Mb
Eclipse Doc Plugin (Zip) - 11.1Mb
Man Pages (TGZ) - 219.4Kb
Man Pages (Zip) - 322.3Kb
Info (Gzip) - 3.2Mb
Info (Zip) - 3.2Mb
Excerpts from this Manual

multipolygon-property-functions

This page has moved or been replaced. The new page is located here:

http://dev.mysql.com/doc/refman/5.7/en/gis-property-functions.html

Please update any bookmarks that point to the old page.


User Comments
  Posted by Mircea LUTIC on February 1, 2005
The result of Area() depends on the type of Spatial Reference (SRID).

The value above is based on euclidian geometry.

The area of a triangle (and hence of a Polygon and MultiPolygon) is given by Heron's formula
SQRT ( s * (s-a) * (s-b) * (s-c) )
only in planar (euclidian) geometry.

Here a, b and c are the lengths of the sides of a triangle as given by GLength() (see also comment on MultiLineString functions) and s=(a+b+c)/2.

On a sphere where coordinates are lattitude and longitude and the lengths of the sides are measured in radians the formula to use for the area is

AreaInSteradians = 4*atan(sqrt( tan(s/2) * tan((s-a)/2) * tan((s-b)/2) * tan((s-c)/2) ))

AreaInSqMeters = AreaInSteradians * RadiusOfSphere^2

See also my comment on 19.5.2.4 MultiLineString Functions
Sign Up Login You must be logged in to post a comment.