INMAPAREA ( CDLAT ; CDLONG )

Current location is inside the area of a rectangle on a map

Average rating: 5.0 (1 vote) Log in to vote

Payit4ward - Show more from this author

Sample input:

INMAPAREA(-23.453245 , 119.53453)

Sample output:

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
Purpose of function: IS A LAT AND LONG POINT INSIDE A RECTANGLE AREA ON A MAP?

CDLAT = CURRENT LOCATION LATITUDE
CDLONG = CURRENT LOCATION LONGITUDE 

THIS FUNCTION USES THE DECIMAL REPRESENTATION OF LAT AND LONG
EG.  INMAPAREA(-23.453245 , 119.53453)

THIS FUNCTION WILL GIVE A " 0 "  OR " 1"  AS THE RESULT
0 = NOT INSIDE RECTANGLE
1=  YES INSIDE RECTANGLE

/////////////////////////////////////////////////////////////////////////////////////
WHEN PUTTING IN THE LATITUDE OR LONGITUDE OF THE POINTS of a rectangle area  EVEN IF IT IS NEGATIVE REMOVE THE NEGATIVE.. 
EG...  IF THE LATITUDE IS -23.34142 THEN USE 23.34142

IF ANY NEGATIVE VALUES ARE USED WHEN PUTTING IN THE RECTANGLE AREA POINTS THEN IT WILL NOT GIVE YOU THE RIGHT RESULT
/////////////////////////////////////////////////////////////////////////////////////

XA= LONGITUDE OF POINT A WHICH IS TOP LEFT OF RECTANGLE
YA= LATITUDE OF POINT A WHICH IS TOP LEFT OF RECTANGLE

XB= LONGITUDE OF POINT B WHICH IS TOP RIGHT OF RECTANGLE
YB= LATITUDE OF POINT B WHICH IS TOP RIGHT OF RECTANGLE

XC= LONGITUDE OF POINT C WHICH IS BOTTOM RIGHT OF RECTANGLE
YC= LATITUDE OF POINT C WHICH IS BOTTOM RIGHT OF RECTANGLE

XD= LONGITUDE OF POINT D WHICH IS BOTTOM LEFT OF RECTANGLE
YD= LATITUDE OF POINT D WHICH IS BOTTOM  LEFT OF RECTANGLE

-------------------------------------------------------------------------------------
REPLACE THE VALUES IN THE FUNCTION BELOW FOR MAP AREA THAT YOU WILL USE CONSTANTLY 
-------------------------------------------------------------------------------------
eg...

XA=119.72024; <-- replace with your own value
YA=23.35425; <-- replace with your own value

-------------------------------------------------------------------------------------
OR IF YOU WANT TO CHANGE MAP AREA every time you use the function
-------------------------------------------------------------------------------------
***********************************************************
ADD THESE PARAMETERS under function parameters above
************************************************************
LATA
LONA
LATB
LONB
LATC
LONC
LATD
LOND

**************************************************************************
USE THE BELOW IN THE FUNCTION
(copy this section below and paste over the same ones in the function)
**************************************************************************
YA= ABS( LATA);
XA = ABS (LONA);
YB = Abs(LATB);
XB= Abs (LONB);
YC = Abs(LATC);
XC = Abs(LONC);
YD = Abs (LATD);
XD= Abs (LOND);


*/

Let ([

XP =Abs ( CDLON );
YP =Abs ( CDLAT );


XA=119.72024;
YA=23.35425;
XB=119.73929;
YB=23.34133;
XC=119.75295;
YC=23.36138;
XD=119.72548;
YD=23.37592;

F1=If ( IsEmpty ( XP ) or IsEmpty ( YP );"";(XA-XB)*(YP-YB)-(YA-YB)*(XP-XB));
F2=If ( IsEmpty ( XP ) or IsEmpty ( YP );"";(XB-XC)*(YP-YC)-(YB-YC)*(XP-XC));
F3=If ( IsEmpty ( XP ) or IsEmpty ( YP );"";(XC-XD)*(YP-YD)-(YC-YD)*(XP-XD));
F4=If ( IsEmpty ( XP ) or IsEmpty ( YP );"";(XD-XA)*(YP-YA)-(YD-YA)*(XP-XA));

RESULT = GetAsBoolean ( F1 ≤ 0 and F2 ≤ 0 and F3 ≤ 0 and F4 ≤ 0 )
];

RESULT

)

Current location is inside a rectangle area on a map

Purpose of function: IS A LAT AND LONG POINT INSIDE A RECTANGLE AREA ON A MAP?

CDLAT = CURRENT LOCATION LATITUDE
CDLONG = CURRENT LOCATION LONGITUDE

THIS FUNCTION USES THE DECIMAL REPRESENTATION OF LAT AND LONG
EG. INMAPAREA(-23.453245 , 119.53453)

THIS FUNCTION WILL GIVE A " 0 " OR " 1" AS THE RESULT
0 = NOT INSIDE RECTANGLE
1= YES INSIDE RECTANGLE

Comments

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

INMAPAREA ( CDLAT ; CDLONG )

Comments

Support this website.

Support this website.