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

Popular posts from this blog

How to Create a 3D Surface

In my last post, I talked about going 3D with your GIS.  But how do you do it? Let's say you want to create a 3D surface and use it in a 3D scene online, and you have a Microstation XML in Utah State Plane Central Foot. Where do you start? Open a new Pro project.   First, you will convert the XML to a TIN. Convert TIN to Raster Change the sample distance to cell size  Sampling Value is 1 foot Optional - Mosaic to new Raster If you are working with multiple surfaces, it is easiest to mosaic them into one raster at this point. Doing this allows the remaining steps to be done on one raster, instead of multiple. Change the pixel type to 32 bit float to maintain the elevation. Define Projection Up to this point in the conversion process, it is finally time to tell the data where in the world it is located.  Use the Define Projection tool and set it to Utah State Plane Central Foot. Project Raster Since you will be using your 3D surface in ...
Read more

Harvey

My friend Harvey is retiring. I learned one of the most valuable GIS lessons of my career so far from Harvey. I met Harvey about a year into my GIS career.  Harvey was a cowboy fireman with the most impressive mustache.  He was in the office on light duty following a surgery. We were paired up to work on a few projects together, creating spreadsheets and maps. Harvey has bad eye sight.  The mapbook I made for the fire department had 27 pages covering the city.  But Harvey couldn't see it and would throw the mapbook at someone else to look at it while on their way to a call.  For Christmas later that year, we made Harvey his own special mapbook, with 108 pages covering the city.  He chuckled.  And used it. To this day, every map I make, I make with Harvey in mind.  Harvey is an old soul that doesn't like computers.  He has no use for complex maps.  While GIS is complex and ever-growing, I try to make every map a map that Ha...
Read more