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.5 (30 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.	decFromHex ( hexValue )
	(Mon, Oct 16, 12:34pm)
2.	MonthYearList ( startmonth ; startyear ; numbermonth ; short )
	(Mon, Oct 16, 3:38am)
3.	ErrorDescription ( errorNumber )
	(Wed, Sep 27, 2:51am)
4.	decodeEntities (text)
	(Wed, Sep 27, 1:22am)
5.	HexidecimalToNumber ( HexidecimalValue ; counter )
	(Mon, Sep 25, 12:39pm)
6.	FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1
	(Fri, Sep 15, 12:34pm)
7.	ShannonEntropy ( text )
	(Thu, Sep 07, 5:59am)
8.	LetterCount ( text ; summary )
	(Thu, Sep 07, 5:53am)