I have parcel and buildings layers.
In their attribute tables I want to replace "NULL" values with numbers from 1 to 2000, in "Parcel ID", or "Building ID" field.
How can I do this in ArcGIS Desktop?
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
Here is a code block for the Field Calculator that will do what you require.
NULLvalue in the desired field
Accumulative and sequential calculations
Calculate a sequential ID or number based on an interval.
Expression: autoIncrement() Expression Type: PYTHON_9.3 Code Block: rec=0 def autoIncrement(): global rec pStart = 1 #adjust start value, if req'd pInterval = 1 #adjust interval value, if req'd if (rec == 0): rec = pStart else: rec = rec + pInterval return rec
This code sequence is taken from the ArcGIS 10.0 Desktop Help: Calculate Field Examples
I would highly recommend that you browse through the help documentation in that file and in the other help sections for ArcGIS, as there are many useful examples and code samples to pull from.
Enter the code above, into the Field Calculator as shown in the screen shot below: You would enter the code into the sections as detailed below:
Pythonas the Parser
RD20FULL =: Enter code listed under Expression