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 […]
A Batch Download Workflow
I’ve used this hack/technique a couple times now and wanted to share it and document it. I was recently doing some web research on map production guidelines as I’m trying to put some together for my GIS department. I stumbled across this Map productions guidelines PDF from the Australian Local Government. It is a really […]