Calculating index rotation angle
You’ve built your index layer and it might look something like this. If you’ve rotated these features manually and want to used them to control page rotation in data driven pages, you’ll need a field containing the page rotation value. This layer already has an angle field that I’m going to use to demonstrate how […]
2 (or more) maps, 1 mxd
This is a production technique I use to create multiple maps in one mxd utilizing data driven pages. The cool part about this is that I’m creating truly different maps here, not a series of the same map in different places. The first step is to create an index layer that controls the map title, […]
SQL definition query list
Here’s a quick one, I see a lot of sql expressions written like this: Name = “Roosevelt” OR Name = “Jackson” OR Name = “Jefferson” OR Name = “Lincoln” OR Name = “Franklin” OR Name = “Washington” This can be written using the IN function. This is a little more legible and easier to compose […]
MOD function for contours
Say you have 1’ or 5’ contours with an elevation field. Instead of calculating a new field or making selections, you can use the mod function. I find it extremely useful. In the definition query tab of your layer properties: mod(“Contour”,25)=0 The mod expression above divides the Contour value by 25 and throws out any […]
How to quickly see who’s locking your geodatabase (gdb)
Working in a team can cause some extra issues to arise that you don’t come across when working alone. I wanted to share this because I need to know how’s locking me out of editing my geodatabase constantly, I find it useful, and it’s not super obvious. 1. Navigate to gdb in windows explorer 2. […]
