Transcription of Using Reports as a Quick Reference to Map Books
1 gis tips & tricks March 2014 1 Using Reports as a Quick Reference to Map Books So you ve created a map book (Data Driven Pages) for your project area, but it contains hundreds or thousands of wells. How can you easily figure out which map page a particular well is on? Follow these few steps: Generate Data Driven Pages Using a Fishnet Grid Perform a Spatial Join to add the Grid Coordinate to the Wells Generate a report of the Spatially-Joined Wells Generate Data Driven Pages Using a Fishnet Grid The first step is to create a fishnet grid with Cartesian coordinates (A1, A2, A3, B1, B2, B3, etc.) so that each page in your map book will have a clearly identifiable name. 1: Use the Create Fishnet geoprocessing tool (ArcToolbox Data Management Tools Feature Class) to generate a grid around your study area.
2 gis tips & tricks 2 March 2014 2: Add a Name field to the grid s attribute table and then use the Field Calculator to populate the values. HINT: For Quick numbering, populate the values Using the OID field. NOTE: Though it is generally discouraged to use the OID field for anything, in this case it is just being used to generate some Quick identifying numbers for your grid. Once copied into the Name field, these numbers will not change. 3: Open the Data Driven Pages toolbar and open the Setup window , assigning the grid layer and Name field appropriately. gis tips & tricks March 2014 3 4: Setup each page layout as you Perform a Spatial Join to add the Grid Name to the Wells Once the grid has been defined and the map book pages setup, you ll need to make sure each well has its map book page (grid cell) number listed in its attributes.
3 This can be accomplished by performing a spatial join. 1: Right-click your wells layer and choose Joins and Relates Join. 2: Choose to join data from another layer based on spatial location and make sure each point is assigned the attributes from the grid cell that it falls inside. 3: The output feature class will have the fishnet grid cell Name field assigned to each well, which can now be used to generate the report . gis tips & tricks 4 March 2014 Generate a report of the Spatially-Joined Wells Now everything is prepared and ready for the report to be created. All you ll need is the spatially-joined wells dataset, with an attribute field for API numbers and the fishnet grid cell Name field. 1: Open the report Wizard by going to View Reports Create report .
4 2: Build the report Using the new wells feature class, adding the attribute fields you wish to include in the report (at the very least, the API number and the fishnet grid cell Name). 3: Finish designing the report however you see fit. gis tips & tricks March 2014 5 The End! For more great gis tips & tricks , visit our website at and subscribe to our newsletter!
