I have hundreds of employees spread around the country. I need them to fill a form and they need to fill a mandatory decimal coordinates field.

They often write wrong coordinates that end up in the sea or neighbour countries and that messes up my analysis.

I want to write an Excel formula that prevents them from entering GPS coordinates that are not in the area of their responsiblity. In order to do that, I need to know the farthest north, south, east and west coordinates of a polygon, for example their city, province or village in ArcMap.

Could you please tell me how or point me to right direction?

  • 1
    Knowing bounding box coordinates is not enough. You have to estimate if point sits inside relevant polygon .
    – FelixIP
    Dec 19 '16 at 19:53
  • @FelixIP Yes, that would force them to give the exact right coordinates. But I think that would complicate things way too much. I am not sure if I can do that, both in Arcmap and Excel.
    – gulyuks
    Dec 21 '16 at 6:38
  • one common mistake with untrained staff is entering the minute as if they were decimal values (e.g. 5'59° -> 5.59 ) Because GPS can usually project the coordinates on the fly, those errors can be avoided by asking to fill in XY coordinates.
    – radouxju
    Feb 12 at 13:48

This is called the bounding box coordinates. You can get those using the field calculator.

For instance, add a new field, right click on the field, launch "calculate field" and enter the following line of code (after checking "Python")


you can also use XMax, YMax, and YMin for the other values.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.