Field calculators (available in QGIS, ArcGIS Desktop, etc) can recalculate the values of a single field on all, or selected, records within a table using an expression.

learn more… | top users | synonyms (1)

1
vote
2answers
111 views

Replicating Summary Statistics tool with case field using own calculation within ModelBuilder?

I thought this would be a simple problem to solve, by my googling hasn't provided the answers so far. I have created a near table (Using the 'Generate Near Table' in Arc) comparing two sets of ...
6
votes
3answers
6k views

Field Calculator syntax?

I can't get the syntax correct for a fairly simple if statement. Right now it looks like this: dim Output as Integer If [HECTARES] >= 30 AND [HEIGHT] >= 17 AND [CROWN] >= 59 THEN Output = ...
6
votes
1answer
3k views

ArcMap Field Calculator syntax (again)

I'm trying to string together a field calculator script that will populate all the records of a field at once based upon values in a number of fields. I can't even get the first part of the command ...
2
votes
1answer
4k views

Receiving error 000539 from CalculateField_management?

I am trying to add (ie "Author", "LastUpdated") to feature classes within a gdb and then populate each of those fields. I have been able to get my code to run properly for the numerical field but I ...
1
vote
1answer
339 views

Debugging error 000539 from ArcGIS Field Calculator?

What am I doing wrong in this field calculator logic? Pre-logic def re_score(elev_t,f2, contour): f2=contour if elev_t.endswith('.5'): f2 = "Midi" return f2 Expression for field "Contourtyp" ...
0
votes
1answer
149 views

Using Function in Field Calculator gives error 000539?

I'm trying to populate a field using a function. When I run this in Pyscripter, it works fine: d = {} # Function # def find_dups(val): d[val] = d.setdefault(val, -1) + 1 return d[val] # ...
1
vote
1answer
40 views

Field calculations and existing domains

I have feature layer which needs to be updated with new attribute information. The text field I need to populate already has an established coded domain. I need to update hundreds of records and don't ...
3
votes
1answer
5k views

Setting value of field in all selected rows of table using ArcGIS Desktop?

I have an attribute table in ArcGIS 10 (it's large - around 300,000 elements). I've selected some rows of the table using 'Select by attributes' and I want to set the value of a field for all of those ...
7
votes
1answer
1k views

Editing tables using SQL in ArcMap [duplicate]

We've recently started working with ArcMap, having used MapInfo previously. I've created a shapefile in ArcCatalog and want to update some columns using SQL. In MapInfo I'd write the following command ...
0
votes
2answers
442 views

What is expression for finding perimeter in ArcPy and Field Calculator?

What is the correct format for finding perimeter as an expression for arcpy. I was able to use expression !shape.Area! to find the area of my polygon. However when I use the expression ...
2
votes
2answers
60 views

Sequential attribute field calculations with null values using Arcpy

I have a series of x,y co-ordinates converted from a .ply file. I was able to extract the file into a suitable x,y format for arcmap, the issue I have is that they are co-ordinate points representing ...
1
vote
0answers
59 views

Converting UTM to Lat Long inside a Game Engine(Untiy 3d)

This is my first post on Stack Exchange. I have exhausted my research through the game engine forums, so I am trying this forum since you guys seem to be the experts. I have an external device that ...
1
vote
1answer
52 views

How do I round the coordinates of a point before insert into attribute table in ArcGIS?

Until now I doing the following steps to get rounded coordinates: create a new x and y column in the attribute table use Calculate Geometry round the column value with the Field Calculator using VBS ...
0
votes
1answer
65 views

What expression needed for universal naming of parts polygon feature class?

For example, i have n count of polygons and little parts of it. I want in field [Name] get string: "PNum1(1)". where "1" - number of main polygon [Num], "(1)" - number of part of main polygon ...
3
votes
1answer
275 views

Extract string between special characters - and / into a new field ArcGIS Field Calculator

Can I create a field calc expression in ArcGIS 10.3 to print a selection between special characters? I would like to extract a selection of string from field [FolderPath] to a new field [Name]. The ...
1
vote
1answer
71 views

Spatial join multiple attributes from smaller polygons to the bigger one

I'm trying to join (to the rectangle) values from multiple polygons intersecting for this rectangle. I've tried to use some Reference functions in Field Calculator like geomintersects() but it joins ...
1
vote
1answer
45 views

Referencing external CSV file within ArcMap field calculator using python codeblock?

I would like to know if there is a way to incorporate an external csv file into a custom made python script in ArcMap field calculator. I am inputting fields from the current layer, but need to access ...
-1
votes
1answer
65 views

Adding Rasters with multiple Field Values using Map Algebra in ArcGIS for Desktop? [duplicate]

Embarrassed that I haven't looked at this for some time (can't quite get the syntax down). (ArcGIS 10.2, Win7x64). Within Map Algebra (Raster Calculator) Trying to add the cell values of 3 rasters, ...
2
votes
2answers
197 views

Randomly choosing one from multiple fields in Field Calculator of ArcGIS for Desktop?

Using the Field Calculator in ArcGIS for Desktop, I want to randomly choose one field from a list of 10 fields (strings). The Excel equivalent, which is working, is: =INDEX(A2:J2;rnd()*10+1). How ...
1
vote
1answer
192 views

How to convert text to proper case using the field calculator?

I am working on a set of data that has over 40,000 records on ArcGIS and I want to use a Proper Case for several fields/columns on the table. Is there a Python or Java Script that can help me automate ...
2
votes
3answers
138 views

How to calculate Statistics of an attribute field to use it in another calculation

I want the statistics of an attribute field to use in another calculation, i can view the statistics using the field properties menu I want these to normalised the data of field 'Ia' using the ...
1
vote
1answer
49 views

Capitalizing The First Letter Of Each Word In Attribute Field QGIS

I have tried capitalizing the first letter of each string in my field/column called "COMMUNITY" by referencing this post: Capitalizing The First Letter Of Each Word In Attribute Field Particularly: ...
7
votes
1answer
134 views

Filling fields with conditional clauses

I have four fields in my shapefile. I would like to fill only one of them (cell of attribute table) and automatically after to write one cell the others one will be filled by conditional clause. I ...
1
vote
1answer
28 views

Summarize multiple columns in field calculator [closed]

I am performing the Huff model with 10.000+ facilities and dwellings. As a result, each facility has a value between 0 and 1 that determines the probability a consumer patronages a facility from a ...
4
votes
3answers
220 views

Using IF operator with Python parser of ArcGIS Field Calculator?

I want to assign numbers to a certain types of building and I need to use field calculator. I tried many different versions of this and I still cant find whats wrong. Could you tell me where do I ...
0
votes
0answers
9 views

Replacing null values in cell with integer using Python parser of ArcGIS Calculate Field tool? [duplicate]

In one field I have certain cells that are filled with null values. I am trying to change all those null values to 0 or say even as random as 100. I tried with the Calculate Field tool the following ...
3
votes
1answer
47 views

How to convert a “yyyy/mm” field to “yyyy/mm/dd”?

I am trying to edit an existing date field of the form "yyyy/mm" to a format that the TimeManager Plugin for QGIS can handle - I guess "yyyy/mm/dd" will do it. I've got as far as opening the ...
3
votes
1answer
131 views

Field calculator uses wrong fields when working with joined data

I am having an issue in qgis table joins. i have a joined a csv file to a sqlite database and common id is used for join. the join is displays correctly in attribute table. the attributes in sqlite ...
3
votes
2answers
126 views

Arcmap field calculator python script returns no data

I am running ArcMap 10.2 I have 4 fields with which I am working. many have duplicate entries. in order to find the single correct entry from all the duplicates I am trying to calculate out the ...
1
vote
1answer
262 views

How to copy same values to another field in attribute table in QGIS using field calculator?

I am trying to copy values from Parsel_ID to Parsel_NO using an equation ( look at pictures) in field calculator but it is not working. What is the problem and how can I success this task??enter image ...
0
votes
1answer
164 views

Use Get Field Value tool to calculate field?

I am running a summary statistic on a clip to get acre counts by area type. I want to then add a second field that has the acre count from the total area. A third field be added so that it shows as ...
6
votes
3answers
5k views

Doing If/Then over multiple data columns in Python Parser of ArcGIS Field Calculator?

I have some VB code saved that looks at two columns of data, and populates a third with the low value. Pre-logic Script Code: Dim output as double if [MIN_LEFT] < [MIN_RIGHT] Then output = ...
5
votes
1answer
3k views

Using Range in Python expression of ArcGIS Field Calculator?

what is the python expression for defining a range of numbers? I have tried numerous combinations but cannot get a simple range of angles (100 -200) to compute correctly. Screen shot :
3
votes
2answers
223 views

Updating new field from existing field using ArcGIS Desktop?

I need to update my new field/column (Property Type) with either "detached", "semi", or "terrace" depending on an existing column (Property Count): where the count = 1 I need to populate Property ...
1
vote
0answers
38 views

Using timestamp field to auto complete source field in QGIS

I am trying to use my timestamp field to autocomplete my source field in QGIS using the field calculator. I want my source field to be completed with a saved string e.g "Sam_Sam". I want my source ...
1
vote
1answer
132 views

Trying to export stacked text to CAD using ArcGIS 10.2

I've been experiencing some unwanted results when trying to export stacked text to CAD using ArcGIS 10.2 for desktop. With the Export to CAD tool I can easily export polygons. However, I'm also trying ...
7
votes
2answers
2k views

Fnding wildcard string using Field Calculator script code?

I'm trying to find part of a text string in the CLASS_NAME field and return a text string to the Abrv_Name field using the Field Calculator in ArcGIS 10 via a Python parser. Here is what I have tried ...
0
votes
1answer
79 views

Python if/then Statement in Field Calculator to return 0 or 1 based on numbers divisible by 28?

I don't use python all the time. In a point feature class, I'm trying to populate an ID field with 1's and 0's based on whether the FID is divisible by 28. I've started the following code but ...
0
votes
2answers
80 views

Understanding if-else statements in ArcGIS field calculator when coded value domain used?

I am attempting to set a newly created field based on the strings in another field 'TNMFRC'. I am pretty sure that I have the code write, and yet everything is set to a value of '6'. Here's my code: ...
1
vote
1answer
153 views

Python script for if/elif condition in field calculator [duplicate]

I need some help in calculating the last column (OD_pairs.Ai_) based on the condition; if travel_cost has a value below 10, OD-pairs.Ai_ takes the value of the first column(Aij_OjFCij..) if ...
2
votes
1answer
50 views

Help with else/if else in arcMap? [closed]

I'm attempting to create quick code that simply assigns a gps coordinate to a certain station on the map. Here's my current code Pre-logic script code: def update_nones(lat,bay_statio): if ...
0
votes
1answer
61 views

Getting different values for area field calculations using ArcGIS Desktop?

We have self developed application based on ArcGIS 9.3.1 SP2. Our agents use that application to edit parcels. The parcel layer has a field SHAPE_AREA that is calculated by ArcGIS. Our application ...
3
votes
2answers
86 views

Using ArcGIS Desktop field calculator (python) to parse date

I'm trying to parse a datetime field using python (but have never used python for it before). I have a field that contains a valid date, but not a valid time... and other fields that have valid hour ...
0
votes
1answer
39 views

ArcGIS 10.2: VB to Python

I have the following VB code to produce a percentage in a field calculator. " [FIELD_1] / [Total]*100 " It works in VB. I've tried the following without luck. !FIELD_1! / !Total! * 100 Can anyone ...
2
votes
3answers
178 views

Unable to replace Null values using Python parser of ArcGIS 10.0 Field Calculator?

I'm using the following python code to replace Null values by 0, using field calculator: def nulls(p1): if p1 is None: return 0 else: return p1 But nothing happens, Null values stay. I'm ...
5
votes
1answer
3k views

Converting state name abbreviations to full names using ArcGIS Field Calculator?

I have a data table with columns that includes city names (ex: San Jose) and state name abbreviations (ex: CA). Is there a way to define the state names as their full names (i.e., CA = California) and ...
10
votes
8answers
13k views

How to Remove return/newline (\n) character from Field using Python and Field Calculator?

I have a geodatabase table with a field that I'm trying to remove return characters (new line). I found this post (How can I remove (chomp) a newline in Python?) of how to do it, however it is not ...
3
votes
0answers
68 views

ArcGIS 10.0 Python script won't recognize null [duplicate]

Has anybody ran into in issue where Python field calculations and/or scripts won't properly query Null (None) values? The calculation I'm working on is a little more complex, but even the simple ...
2
votes
1answer
45 views

Using Arcmap to update a field based on data from another fields

I'm trying to update latitude and longitude data per individual station for a lab I'm working for. Here's some code I have that's supposed to assign any all bay stations of a certain name the ...
1
vote
1answer
56 views

Using python to do a interpolation on field calculator [duplicate]

I need to increment a row in attribute table: def func (w,v,pot): return pot + ((pot+1 - pot)/(v+1 - v))*(w-v) The "+1" is not the addition of number one to the variable, is the intention to ...