Field calculators (which are available in QGIS, ArcGIS-related products, etc.) can recalculate the values of a single field, on all, or selected records within a table based on a symbolic expression.

learn more… | top users | synonyms

0
votes
2answers
867 views

How to auto populate multiple fields in attribute table?

i have Feature Class Buildings, it has many fields like ...
0
votes
1answer
671 views

Null output from field calculator code block

I have a simple calculation to compare two columns and populate a new column with the lower value but I am getting null output...any ideas? expression ...
0
votes
0answers
24 views

How do I auto-populate more than one other attribute field with values based on the value of another field within the same record?

Based on value selection from one attribute field, would it be possible to auto-populate many fields within the same record with predefined values either from a range of values within another field or ...
0
votes
1answer
22 views

Many ELSE statement in Expression in QGIS (2.6) [duplicate]

is it possible to have more than one ELSE in the CASE WHEN statement in the Expression builder in QGIS? For example: CASE WHEN "population" > 5000 THEN 'big' ELIF WHEN "population" > 1500 THEN ...
0
votes
1answer
24 views

Copying the numeric portion of an address to a new field

I'm attempting to copy just the numeric portion of a street address into a new table using the Field Calculator in QGIS. The expression I'm trying to use is: left( "SITE_ADDR", strpos( "SITE_ADDR", ...
0
votes
0answers
21 views

Python script to get count of features that meet a certain criteria [duplicate]

I am in search of a Python script for use in the ArcGIS Field Calculator to return the number of features that meet a certain criteria. Here's where I am getting stuck: def ...
0
votes
0answers
99 views

Python script to get feature count in a feature class that fall in a specific range

I need to write a Python script to be used in the ArcGIS Field Calculator that will return a feature count for values between a range defined by the values in two other columns. Here is a graphic ...
0
votes
1answer
25 views

Is there a way to automate field calculations for ArcGIS Server?

I have a field that I'd like to be concatenated with each new objectID when a feature is created in my feature service. Workflow: Feature added, already contains objectID. Would like my Service ...
0
votes
0answers
78 views

Why will my field calculator python function always return Null if any inputs are Null?

I've written a simple python function that outputs a list based on yes/no fields. It appends a word to a list if it has a "yes" in another column then writes the list, formatted according to the ...
0
votes
0answers
47 views

Concatenate an object ID and string to publish gp service with field calculator?

I have a simple model which concatenates and object id and a string, to create something like 1SRS2567, the concatenate function of OID and the string field are able to be passed in VB, but not ...
0
votes
0answers
66 views

calculating decimal degrees from coordinates found in an excel table

What is the exact syntax to use when calculating decimal degrees in the field calculator? I know the general formula {i.e. Degree + (minute/60) + (second/3600)} but how do I put this into the gis? I ...
0
votes
0answers
25 views

Assigning values to new field using field calculator? [duplicate]

I have a polygon with attributes showing the service area of 300m from a busstop as well as 600m from a busstop. Attribute fields > From Break with values 0 and some with values 300 Attribute fields > ...
0
votes
0answers
36 views

Field is not nullable but Field is nullable Box is checked

I had this problem already a couple of times. I add a Field (float) to an existing feature class, the Field is Nullable is arleady checked. But performing a calculation with the Field Calculator on it ...
0
votes
2answers
122 views

ModelBuilder - How to calculate Field using part of path name

I am trying to calculate a field using part of the feature class path name (specifically, the last three characters of the geodatabase name). Is this possible? I've tried using the parse path tool and ...
0
votes
0answers
129 views

Using Code Block in Field Calculator with ArcObjects (VB.NET)

I'm having trouble using a code block in the Field Calculator with ArcObjects. Ideally, I'd like to be able to read a text file which contains the Python code for the code block. I've tested this code ...
0
votes
2answers
878 views

ArcGis Python Script, Calculate Field

Sorry for my English. I am trying to write a Python Script for ArcGis 10.2. #import system modules import arcpy import math from arcpy import env #Set environment options ...
0
votes
0answers
45 views

Calculating rows in a attribute table of a point shape with QGis or Saga

I have a point shape with an attribut ("test"). I need to calculate the sum of the 1st four (id 1-4) "test" values and then the next 4 (id 5-8). Is there a chance to calculate this with the field ...
0
votes
1answer
281 views

Join and Calculate vb.net

Im trying to join an excel table to a shapefile and then calculating those fields using vb.net. The code I have written has no errors, but won't work when I try it in ArcGIS 10.1 and I'm out of ideas. ...
0
votes
1answer
46 views

Formatting Cells in ArcMap

I am trying to join tables together and need the PLSS to line up correctly. In my table with geometries I have "CO060020N0650W0SN330" in a field. I want to make a new column and make it say 2N65W33 ...
0
votes
0answers
159 views

ArcGIS Python Field Calculation

Ok so i've got a problem with the field calculator in ArcGIS: I'm already pretty far with it since i got some help :P but it still doesnt work. What i've got: -A complete table of several states of ...
0
votes
0answers
74 views

Field Calculator: Error message

Field Calculator: using the x- or yat or (0 "or-1" ) expression, I keep receiving an error: An error occurred while evaluating the calculation string: Index is out of range. I have shut down and ...
0
votes
0answers
237 views

New values created with QGIS field calculator become null upon saving

I'm having a problem with QGIS. I'm trying to create a new column in the attribute table for a shapefile. The numbers in the fourth column (see screenshots) are currently strings, so I want to convert ...
0
votes
0answers
67 views

Populate a new field with list of the top 5 values of all fields for that record

I have 15 fields. I would like to add a new field that is populated with the field name and value of the top 5 highest values of the 15 fields for each record in the table. The new field would be a ...
0
votes
0answers
192 views

Select Expression and Field Calculator in ONE STEP with QGIS

I have an Open Street Map Shapefile and i want to use Field Calculator to add information to a field called a800900 according to the field TYPE of street, by different area (field called ID_2). The ...
0
votes
0answers
102 views

Doubt in Field Calculator

I am working in an project.I have a point Shapefile its projection is NAD83(HARN)Pennslyvaniasouth(ftUS)*EPSG3365* when I measure its distance(between two points) it gives me the answer in feet .yes ...
0
votes
0answers
49 views

Ádvance Python Field Calculator - Global Expressions [duplicate]

I am trying to create a global expression that populates a new field based upon existing values in an attribute table. I am using QGIS Dufour and the Sextante toolbox, and the "Advanced Python Field ...
0
votes
0answers
265 views

Using Field Calculator to Calculate a Mean for Multiple Rows

I am trying to calculate a mean across a multiple number of attribute rows and have this value added to a new field that I have entered in the attribute table. I have an attribute table which has a ...
0
votes
0answers
100 views

Import csv file and use “toggle editing” and “field calculator” without Saving it as a Shapefile.

I am importing a .csv file in QGIS and I have also made the *.csvt file where I have specified my data types. I still cannot use "Toggle editing" and "field calculator".Whether I must save it as a ...
0
votes
0answers
44 views

( how to use Field Calculator to count number of duplicated recordes at another field? [duplicate]

How To Use the Field Calculator python script to count the number of duplicated records of a field "A" and get the count at another field "B"
0
votes
0answers
227 views

python script to calculate and return values based on several conditions

I need to calculate and return the value "continuous" to those records in a polygon feature class with species records aggregated to a UTM grid considering the attributes are species name, grid code, ...
0
votes
0answers
29 views

Exporting QGIS attribute table to excel [duplicate]

I have a million rows in the attribute table, with lat/lon columns that I want to export to Excel. Selecting all the rows causes QGIS to crash. Is there another way to do the export? The million rows ...
0
votes
0answers
62 views

Replace Null Values Field Calculator [duplicate]

I am using ArcGIS 10 and have a polygon shapefile in which many of the numeric fields are Null. The polygon shapefile in question is produced by joining a polygon shapefile with a point shapefile and ...
0
votes
0answers
26 views

I need to add one table to another table as strings.

But all of this two table data is numeric. And one of them is float. So I need to add from the float table only integer and merge it with other table. What to write in field calculator?
0
votes
0answers
449 views

How can I get shape filename in attribute field using field calculator with VBA?

I want to store ths shapefile name in an attribute field using the field calculator and visual, but can't find the way to do it. Can anyone help me, please? Thanks!!!
0
votes
0answers
68 views

How to populate polygon extents to an attribute table in QGIS

Is there a way to calculate the XMIN, YMIN, XMAX and YMAX of a polygon and write it to a field in an attribute table? The Geometry functions available in the Field Calculator are for points. ...
0
votes
1answer
356 views

Python Field Calculation [duplicate]

Possible Duplicate: Iterative position within Field Calculator/Python I need to calculate a field for a data set that is grouped by county. At each change in county I need the column to ...
-1
votes
1answer
114 views

IF-Statement in Field Calculator [closed]

I want to use an IF/ELSE-Statement to define a field in the attribute table of my raster. Therefore I have a field "VALUE". The condition should be: If "VALUE" < 4 ...then use die field "A".....if ...
-1
votes
1answer
218 views

Python code in Field Calculator gives General error executing calculator ERROR 999999: Error executing function?

In a shapefile, I have Field named Elevation with a text field containing integer ranges stored as strings: 1 - 2 3 - 6 2 - 3 8.5 - 12 11 - 12 I need to categorize it using rule that if Elevation ...
-1
votes
1answer
77 views

Why does dividing two decimal field values using Field Calculator return/write Integer? [duplicate]

I have fields in my datasets such as HR60, HR70, HR80, HR90 When I tried to use field calculator using the following [HR70]/[HR60], all I got was 1, 2, 3, 4 as my values. Last time I checked ...
-1
votes
1answer
240 views

Field Calculator Does not Work in Arc10

I'm having a problem, described below, with Field Calculator in ArcGIS 10. I wonder if there is a known fix at this point. I'm updating to 10.1 soon, but this work cannot wait until then. Details: ...