AnsweredAssumed Answered

LatLngs, mapping and searching within polygons

Question asked by tvrv8s on Feb 14, 2017
Latest reply on Feb 14, 2017 by jbante

Hi,

 

We have a large number of objects geocoded with their location in Lat/Lng.

 

When a new object record is entered by a user, we need to identify whether the object's lat/lng falls within an area defined separately by a polygon of lat/lngs. Let's say we're adding shipwrecks in and around the Bermuda Triangle. We want to know which fall within that triangle and which outside it.


Example tables:

 

"Shipwrecks" Table

ShipwreckID ~ Number

Shipwreck Name ~ Text

Shipwreck Latitude ~ Number

Shipwreck Longitude ~ Number

 

"AreaPolygons" Table

PolygonID ~ Number

Polygon Name ~ Text

Polygon Points ~ Text   (or another solution)

 

Example data:

 

ShipwreckIDShipwreck NameShipwreck LatitudeShipwreck Longitude
1Shipwreck The First26.168543-70.379781
2Shipwreck The Second26.157647-70.274311
3Shipwreck The Third25.004188-57.969806

 

 

PolygonIDPolygon NamePolygon Points
1Bermuda Triangle32.155952,-65.207827_22.782545,-73.935260_33.342647,-79.082878

 

 

So if someone enters the third shipwreck, we need Filemaker to flag up that it's outside the Bermuda triangle.

 

FURTHER PROBLEM

 

There will be several polygons and we need the shipwreck's lat/lng checked against each.

 

Has anyone any ideas how to go about this?

 

Cheers!

Outcomes