[OKGIS] Field Calculations

Tue Mar 27 13:00:30 CST 2007

Just a few other additions to this information.

Now in 9.2 you do have to start an edit session in order to do field
calculations. ;-o. Also the attached a link to a pdf which has quite a few
good suggestions.

http://www.esri.com/news/arcuser/0405/files/fieldcalc_1.pdf

  _____  

From: okgis-bounces at gis.gis.ou.edu [mailto:okgis-bounces at gis.gis.ou.edu] On
Behalf Of Todd Fagin
Sent: Tuesday, March 27, 2007 12:30 PM
To: 'Oklahoma GIS Community'
Subject: RE: [OKGIS] Field Calculations

The only things I would add to this discussion thus far is that if you need
to add a field first, you cannot do this in edit mode.  Also, it is not
necessary to be in edit mode to calculate values of a field.  When
calculating outside of edit mode, though, you will receive a warning message
stating that you cannot undo your results once a calculation begins.

Also, if you are only wishing to calculate a subset of your data, you do
need to first select these records (as Mike pointed out).  It may be easiest
(with 2000 or so records) to do this with a query, though, rather than by
manually selecting them. (It appears as if you need to calculate all
records, though, so just ensure nothing is selected in the beginning and all
records will be updated by the field calculation).

Todd Fagin

Coordinate Solutions, Inc.

501 N.E. 15th St.

Oklahoma City, OK 73104

405.740.4324 (voice)

904.471.5548 (fax)

www.coordinatesolutions.com

  _____  

From: okgis-bounces at gis.gis.ou.edu [mailto:okgis-bounces at gis.gis.ou.edu] On
Behalf Of asweethometx
Sent: Tuesday, March 27, 2007 12:08 PM
To: 'Oklahoma GIS Community'
Subject: RE: [OKGIS] Field Calculations

Nick,

I see that David, Mike and others have posted their suggestions, but below
was my notes:

Start an editing session with this feature class, select the only records
that needs to be edited (if not all records; and make the table show only
Selected records); then select this column (field) that you are going to
edit, and right-click on the column (field) name and open up "Field
Calculator":

Put the desired field value into the text area; 

Text strings are enclosed in double quotes: "text" (yours could be "FULL").

There are some more explanations on how to write up the value in the Help
text (click on the "Help" button in the right side area of the dialogue)

If you happen to have made any mistake during the process, you can "undo"
the edits, or stop editing without saving changes and try editing again.

Hope it helps.

Alicia Nicely

Associate Planner

Transportation Planning & Data Services

 <http://www.acogok.org/> Association of Central Oklahoma Governments

21 E. Main, Suite 100 Oklahoma City, OK 73104
Telephone: (405) 234-2264  ext. 139

Email:  <mailto:anicely at acogok.org> anicely at acogok.org 

  _____  

From: okgis-bounces at gis.gis.ou.edu [mailto:okgis-bounces at gis.gis.ou.edu] On
Behalf Of Nick Nelson
Sent: Tuesday, March 27, 2007 12:45 PM
To: GIS Users Forum; okgis at gis.gis.ou.edu
Subject: [OKGIS] Field Calculations

All,

Does anyone know how to populate a text column using a field calculator?  

For Example:  I need to put FULL into a column for all of my 2000 records
and I want to avoid typing it in 2000 times.  

Any help would be great.

Thank you,

Nick

Nick Nelson

GIS Analyst

Petro-Hunt L.L.C.

1601 Elm St., Ste 3400 

Dallas, TX 75201

214-880-7141 Office

214-880-7171 Fax

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gis.ou.edu/pipermail/okgis/attachments/20070327/c02b8f1e/attachment.htm