I have performed a spatial join on some data and now I would like to take that data and create a list. I'm trying to do this dynamically so that it can be easily repeatable via a script or model.
I have two fields in my data that I care about: Station Name and Page Number. The overall purpose of my project is to take a 632 page mapbook and divide it into smaller books based on the Station Name Boundary. Exporting to pdf only the pages that are relevant to each station.
My spatial join table has given me One_To_Many list of each page and what station boundary it falls within.
Now I'd like to create a list that is something like:
Station1 Pages: 1,2,3,4,5,6... Station2 Pages: 8,9,10,11,12...
and so on.
For what its worth I'm using 9.3.1 and the maplogic extension for the mapbooks.