Excel GIS Measured Grid Spacing Calculation Option 2

0

 


In this article you will learn how to calculate the layout grid of your ArcMap files in a professional way, keeping the symmetry of the lines that represent the EAST / NORTH coordinates.


It used to happen to me that when generating the flat coordinate grids for the layout I would start guessing about the correct spacing of the XY axes, and I would spend a lot of time on that task trying to get a graphical output that looked a bit harmonious to the eye. However, I have seen cases where the person in charge of the geographic information system, simply assigns flat grids without paying attention to details and obtains results like the following, where there is no symmetry in the horizontal and/or vertical coordinates:  


Ejemplo de mapa con grillas sin simetría



So that you do not spend a lot of time like me or get results as in the previous example, I will show you how you can calculate that spacing of the XY axes (EAST-NORTH) with the following formulas that I devised:


Formulas for calculating flat grid spacing in ArcMap / ArcGIS.


X-spacing (EAST) = (Right - Left)/(Number of desired divisions)


Y Spacing (NORTH) = (Top - Bottom)/(Number of desired divisions)


“Right”, ‘Left’, ‘Top’ and ‘Bottom’ refer to the boundary coordinates of the extension that covers the visible window of the Data Frame; keep the ‘Left’ and ‘Bottom’ coordinates since later you will have to specify as custom origin the West coordinates for X and South for Y.


As you can see you will need the extreme coordinates of the Data Frame, these can be consulted in the following way:


How to query the boundary coordinates of a Data Frame in ArcMap / ArcGIS layout ?


0. Make sure that the scale is set to the desired number, for example 1000000 in the “Standard” toolbar and that the view is as you want it.

Establecimiento de escala de trabajo para el Data Frame

1. Right click on the Data Frame (a).


2. Click on the “Properties...” button of the displayed submenu (b).


3. Go to the “Data Frame” tab (c).


4. In the “Extent” section select the “Fixed Extent” option (d). (Make sure you are using a flat coordinate system).


Ilustración de como ver las coordenadas límite de un Data Frame





Although, having obtained this information you can do the calculation with the formulas that I present in the section “Formulas for calculating the spacing of flat grids in ArcMap / ArcGIS”, you can also download the following Excel workbook (Link)


With this spreadsheet you only have to copy the coordinates “Left” and “Right” in the cells indicated in the spreadsheet, the same with the coordinates “Top” and “Bottom”, and indicate the number of divisions in cell E8. The division of the XY axes will be in cells E9 and E10, and the origin of the XY axes in cells E12 and E13.


Whatever your choice is, once you have the calculations, follow the steps below:


How to define the grid spacing for a Data Frame in the ArcMap / ArcGIS layout?


1. Right click on the Data Frame (a). Click on the “Properties...” button of the displayed submenu (b).


2. Go to the Grids tab (c). Select the flat grid, which if it does not have a custom name should be called “Measured Grid” (d) and press the “Properties...” button of this window (e).


3. In the “Reference System Properties” window go to the “Intervals” tab (f) and paste there the result of the calculation in the items “X Axis Interval” and “Y Axis Interval” (g).


4. Make sure that the option “Define your own origin” is checked and paste there the corresponding result or simply write the coordinates “Left” and “Bottom” in “X Origin” and “Y Origin” respectively (h).


Descripción gráfica de como establecer los intervalos de una grilla plana para un Data Frame en el Layout



Result:


Ilustración de las grillas calculadas


This way of calculation allows you to have more control over the flat grids, however, it is not possible to modify the geographical extent and scale without losing the configuration. For jobs where you need more flexibility I recommend the procedure described in my article “Excel GIS Measured Grid Spacing Calculation Option 1”.


I also recommend you to visit my article for the calculation of grids with geographic coordinates “Excel GIS Geographic Grid Calculation”.


NOTES


  • It often happens that the NORTH-EAST coordinates collide at the corners, to solve this I recommend you to place some graphic elements like a white box in each corner.


I hope you enjoyed this article, soon I will upload a video explaining the procedure that you can consult in this blog. Save my blog among your favorite links, I will be uploading many more tricks of this style, remember that you can send me your concerns on the contact page or leave your comment, I will be attentive to respond.




You may like these posts

No comments