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.
ShipwreckID ~ Number
Shipwreck Name ~ Text
Shipwreck Latitude ~ Number
Shipwreck Longitude ~ Number
PolygonID ~ Number
Polygon Name ~ Text
Polygon Points ~ Text (or another solution)
|ShipwreckID||Shipwreck Name||Shipwreck Latitude||Shipwreck Longitude|
|1||Shipwreck The First||26.168543||-70.379781|
|2||Shipwreck The Second||26.157647||-70.274311|
|3||Shipwreck The Third||25.004188||-57.969806|
|PolygonID||Polygon Name||Polygon Points|
So if someone enters the third shipwreck, we need Filemaker to flag up that it's outside the Bermuda triangle.
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?