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. […]
Map Typography – Route Station Labels in ArcMap
Setting up labels for stationing in ArcMap can be a little tricky. First, you’ve got to have a route – if your line isn’t a route, use either the Route Editing toolbar or the Linear Referencing tools to turn it into a route. The first step in creating the stationing ticks and labels is to […]
Map Typography – A Python Label Expression
Recently, I had to label parcels with APN & owner information. The parcel feature class has the APNs and the ownership table is joined based on the APNs. I’ve been commiting to using python in labeling expressions whenever possible and this was a good chance to use an advanced expression. One problem was that the […]