Shopping Cart

Free Newsletter
Signup

Contact

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

FileMaker Pro Custom Functions

List | Show Random | Upload | Add This to Your Site

PolygonArea ( xlist ; ylist )

Rate this function:

Average rating: 4.3 (29 votes)
Discuss this Custom Function

Jeremiah Small, Soliant Consulting
http://jsmall.us

Calculate area of a polygon from array of XY coordinates

Sample Input:

PolygonArea ( List ( 0;3;0 ) ; List ( 0;0;3 ) )

Sample Output:

4.5

//20060806 jsmall@soliantconsulting.com //purpose: calculates area of polygon using Double Meridian Distance //dependency: PolygonAreaHelper //key: Lat is Latitude; Dep is Departure If ( ValueCount ( xlist ) ≥ 3 and ValueCount ( xlist ) = ValueCount ( ylist ) ; Let ([ Lat = MiddleValues ( ylist ; 2 ; 1 ) - MiddleValues ( ylist ; 1 ; 1 ) ; Dep = MiddleValues ( xlist ; 2 ; 1 ) - MiddleValues ( xlist ; 1 ; 1 ) ; DMD = Dep ; DArea = Lat * DMD ; TotalDArea = DArea + PolygonAreaHelper ( xlist ; ylist ; Dep ; DMD ; 2 ; ValueCount ( xlist ) ) ]; Abs ( TotalDArea ) / 2 ) ;//endLet "Lists must contain same number of values, minimum 3." )//endIf
Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

Calculate the area of a polygon from an arbitrary number of xy coordinates. It uses an old surveying technique called Double Meridian Distance.

Requires helper function: PolygonAreaHelper

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

Discuss:

There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:

Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1.	ListSort ( ValueList )
	(Mon, Aug 21, 11:04am)
2.	AddSortOrder ( values ; padWidth ; delimiter ; currentValue )
	(Wed, Aug 16, 10:37am)
3.	AddAddHiddenSortOrder ( values ; currentValue )
	(Wed, Aug 16, 10:31am)
4.	String_to_Number_in_Scientific_Notation ( text )
	(Tue, Aug 15, 9:20am)
5.	Quartic_Solver ( a, b, c , d, e, which_x )
	(Sun, Aug 13, 1:05pm)
6.	SQLRefSimple ( FldRef ; Option1TO2Fld3Both )
	(Fri, Aug 11, 3:19pm)
7.	BinaryStringXOR ( a ; b )
	(Mon, Aug 07, 1:46pm)
8.	VarListCreatorPro ( VarType, VarName, VarValue, Mode)
	(Mon, Aug 07, 1:05pm)