Posts

Showing posts with the label Horrocks Engineers

Sequential Numbers

In ArcMap, here is how you can calculate sequential numbers using Field Calculator. Set field calculate to python. Paste this in pre logic script: rec=0 def autoIncrement():  global rec  pStart = 1   pInterval = 1  if (rec == 0):    rec = pStart   else:    rec += pInterval   return rec Paste this in second box autoIncrement() Check out one of my other posts about how to Convert from Degrees Minutes Seconds to Decimal Degrees in Python here . Happy GISing! Lindsy Hales Bentley

How to pull numbers out of a string

Here’s a little function to pull numbers out of a string. import re def calculate(value):   newVal = re.sub("[^0-9]", "", value)   if newVal == "":     return 0   elif newVal is None:     return 0   else:     return newVal calculate( !Size! ) Happy GISing! Lindsy Hales Bentley

ESRI GIS Model Builder

Image
Who here loves Model Builder? Well, if you haven't had a reason to use it before, let's chat about it's benefits.  Prior to my working at an engineering firm, I never had a reason to use it.  There wasn't anything that I did on a regular basis that called for it.  I took all of the classes, read all of the books, and I just didn't get why it was useful. Then, I was asked to convert utilities for a project.  Not just once, but on a weekly basis.  Start to finish, it took me two weeks to convert and clean up the utilities from CAD on that beastly project.  Two.  VERY. PAINFUL. Weeks.  *Bang head against desk here.* This meant the utilities were never up to date in the project map.  After two months of figuring out the kinks in the conversion process, I was challenged to create a model of this process.  It looked something like this: Yes I'm OCD, and everything has to line up pretty. My first model.  I had my doubts ...