How to calculate the area of a polygon given its coordinates?
{"type":"MultiPolygon","coordinates": [[[[40.92344999,57.76796047], [40.92299938,57.76776019], [40.92268825,57.76796619], [40.92312813,57.76816647], [40.92312813,57.76816647], [40.92344999,57.76796047]]]]}
It uses the same method as in Area of a polygon but does the arithmetic for you. Polygon area calculator Area=1.551079549
You can find the area using SQL/PostGIS in CartoDB by using ST_Area. You can run this in your SQL editor:
SELECT *, ST_Area(the_geom::geography) area FROM untitled_table_1
It will calculate the area for the object in each row and adds a temporary column to your table called area that give the area in square meters.
SELECT ST_Area(ST_GeomFromText('MULTIPOLYGON (((40.92344999 57.76796047,40.92299938 57.76776019,40.92268825 57.76796619, 40.92312813 57.76816647, 40.92312813 57.76816647, 40.92344999 57.76796047)))',4326)::geography); And the result is 1028.11563305801.
Apr 10, 2015 at 13:32
The shoelace formula is what you need. A full example is given in this answer in python.
