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.4 (31 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.	UnQuote ( string )
	(Tue, Apr 10, 12:34pm)
2.	TrimInvalidTrailingChars ( invalidChars ; textToTrim )
	(Wed, Apr 04, 10:31pm)
3.	ITA_PositionIndexValues( textList; searchList; searchValue; occurrence)
	(Wed, Apr 04, 6:29pm)
4.	@UniqueValuesToAdd ( existingValues ; addingValues ; ~datatype ; ~locale )
	(Sat, Mar 31, 12:52am)
5.	ExcludeValues(MyList ; Out)
	(Wed, Mar 21, 7:23am)
6.	PreviousMonthEndDate ( myDate )
	(Wed, Mar 07, 3:35am)
7.	PreviousMonthName (myDate)
	(Wed, Mar 07, 3:33am)
8.	FmTableFields ( tableName ; fieldsInclude ; fieldsExclude ; classExclude ; typeExclude ; prefixExclude )
	(Fri, Mar 02, 6:32am)