I need to produce multiple maps from a single excel file consisting of approximately 1,500 records. Each record contain two lat/long pairs (four points) and I need a PDF map of each record zoomed to the extents of the four points. Can this be done using data driven pages or through the ArcPy mapping python object? Thanks to all.

The records are part of a task related to public transport planning. Four points, four lat/long pairs. The four points are "pairs" (origin/destination and boarding/alighting). I'm using ArcGIS 10.1. Please forgive any confusion.

  • Two lat-long pairs would be two points, not four?
    – Simbamangu
    Commented Mar 11, 2014 at 3:22
  • 1
    @Simbamangu two lat/long pairs can define opposite corners of a rectangle but you are right that the wording is loose and should be revised
    – PolyGeo
    Commented Mar 11, 2014 at 4:28

1 Answer 1


I see the solution to this as being a two step process:

  1. Use ArcPy to create a polygon feature class from your lat/long pairs - a technique like this is described in Automatically create polygons from top right and bottom left coordinates?
  2. Use the polygon feature class created in step 1 as the index for Data Driven Pages from where exporting to a multi-page PDF is straightforward.
  • I like the solution, but what about overlapping polygons?
    – user27907
    Commented Mar 11, 2014 at 11:33
  • @user27907 Overlapping polygons should work just as well in a DDP index as non-overlapping.
    – PolyGeo
    Commented Mar 11, 2014 at 11:54

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.