I have a series of 1900 spatially continuous images that are georeferenced. Each image is a tif file paired with a tfw file.

These images are easily open and shown in ArcMap 10. However, I need a way to extract and tabulate all of their associated coordinates (in this case, the centerpoints of each image) into a spreadsheet.

How do I do this? Please note that I have no scripting abilities.


  • 1
    Learning to write a script or program will pay for itself the first time you don't have to process 1900 files manually :-).
    – whuber
    Commented Sep 15, 2011 at 21:19
  • @whuber Can't argue with that, unfortunately I need the results in a couple days, and I can't learn scripting fast enough to meet that deadline. :)
    – hpy
    Commented Sep 15, 2011 at 21:43
  • 2
    That's the classic argument. It has been keeping people from realizing their potential for a long time. I can't speak to your background or abilities, of course, but I would encourage you to learn how to automate your computing work as soon as you possibly can. You will discover the learning curve may be painful but it is likely faster than you imagine. You'll never look back.
    – whuber
    Commented Sep 15, 2011 at 22:13

1 Answer 1


In arcmap 10.
I think I would use the footprint feature (in mosaic dataset) and
then generate the centroid of those polygons.
add an x and a y field to my attribute table,
calculate the geometry,
then export to dbf and convert to xls.
Also found in this answer are several resources for esri help.

  • 2
    That works well - just use model builder to loop it 1900 times and the job is done.
    – Mapperz
    Commented Sep 15, 2011 at 21:24
  • 2
    actually there is no loop to it once you have all the images loaded to the mosaic (which does allow batch).
    – Brad Nesom
    Commented Sep 15, 2011 at 21:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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