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

1
vote
1answer
37 views

Calculating Field B from Field A, except where Field B has existing value, using ArcGIS Desktop 9.3?

Im trying to calculate Field B from Field A except where Field B has existing value in ArcGIS Desktop 9.3. (I suspect its straight forward but I have 'searched' and havent cracked it yet) Any ...
1
vote
1answer
48 views

Calculation of a text value, The value of which is separated by a special character

How can I calculate a text value, the value of which is separated by a special character? For example: dog | duck, I would like to keep the first value: dog or elephant | cat, I want to keep ...
3
votes
1answer
299 views

Adding an “m” to the end of every number in a row

What function do i need to use to add an space and an m after every item in a row, using the field calculator in the attributes table. I have a load of numbers (as strings) and would like to add m ...
2
votes
1answer
45 views

How to convert unix time to qt time type?

How can I convert unix timestamp to qt time type using qgis field calculator? I would like to avoid importing my table into excel and convert the timestamp to qt time type.
2
votes
1answer
134 views

Python Syntax Error when running Python Snippet of successful geoprocess

I am having an issue with a simple python snippet. Here's the background: I wanted to include an additional step in a nightly update script that replaces characters in a field that simply do not play ...
4
votes
1answer
56 views

Calculate Field in ModelBuilder gives General error executing calculator. ERROR 999999: Error executing function. Expected end of statement?

I am attempting to do zonal statistics for multiple images and I need to add an extra field that will have the name of each raster file in each row to the finally appended file. I have added a field ...
0
votes
1answer
41 views

Field Calculator If/Then in ArcGis 10.1

I've been looking through these threads, i found something similar and thought it could be the answer, but it doen't seem to work for me... I could do this the slow way with Select By Attributes, but ...
1
vote
0answers
40 views

Cause of Field Calculator UnicodeEncodeError: 'ascii' codec can't encode character u'\xf6' in position 5: ordinal not in range(128)? [closed]

def Befahrung(value1,value2): if value1 is ' ': return ' ' else: return "G:\\Example\\" + str(value1) + "\\File_" + str(value2) + ".pdf" I try to create a field with a hyperlink. It works ...
2
votes
3answers
187 views

Setting Zero values back to NULL

I'm working with ArcGIS 10.2 for Desktop and OS Windows 7. I need to set numeric vales from Zero back to NULL, but I can't from the field calculator. I'm working with a vector file and I need to ...
0
votes
0answers
52 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 ...
3
votes
0answers
57 views

How to calculate percentages using QGIS field calculator expression?

I am new to QGIS. I am wanting to calculate a field using other fields and some operators. Here is my expression: case When "RVM_CAT" = 'B' OR "RVM_CAT" = 'C' Then ("PC1" /100) * "RE_ha" When ...
3
votes
0answers
39 views

Can you use wildcards for column headers in Field Calculator?

I know you can use wildcards for fields like so (in the Field Calculator): case when "column" ILIKE '%example%' then 1 else 0 end Can you do something similar for the column headers themselves? I ...
2
votes
1answer
42 views

Populate field with current time

I am trying to populate a field with the current time. Here is what I tried that did not work: Start editing Open Attribute Table Add Field -> Name: time Type: Date Right Click on Field Name ...
2
votes
0answers
31 views

How to get Subtype name in Field using field calculator [duplicate]

I would like to get feature subtype name in another field using field calculator. Any one can advise to make this success? I am expecting ".Cal" file code using with Field calculator.
2
votes
1answer
53 views

Problem with Python codeblock recognizing a field

'<'First Post Alert> I've been through multiple iterations / gyrations, and while there may be multiple problems here (and I'll appreciate feedback on all of them), the recurring issue is that the ...
3
votes
2answers
91 views

Calculate Field Syntax: If statement over many fields

Apologies if this has already being asked but I couldn't find a page pointing to this problem. I'm struggling with the python syntax in the Calculate Field so that, in the table above: if b, c, d, ...
4
votes
1answer
105 views

How to SUM field and then insert into NULL column?

I am only in the beginning stages of learning Python. I have a column, 'QUANTITY_SOLID', that I want to take the sum of all of its rows. I understand I can do this with 'SUMMARY_STATISTICS', but i'm ...
3
votes
0answers
41 views

Warning 000405 when trying to calculate field [closed]

I am trying to create a model but am getting hung up on my first step. I need to calculate an ID field from an FID field so that I can join it to another table based on the ID field. So I have a ...
2
votes
1answer
52 views

How to find and replace a singe word in a string?

How do i find and replace a single word of a string? e.g. Calle Iparraguirre to Iparraguirre I've tried: replace( 'Calle\\s', 'Calle\\s', '') replace( "name",'calle','') and all combinations ...
1
vote
1answer
45 views

Sum a field in buffer intersection

I have looked and do not see this answered in any other discussions. Purpose: Site suitability analysis for brewers spent grain processing facility Method: Locate intersecting buffers with greatest ...
1
vote
1answer
25 views

Use Field Calculator to change “Status” field in Annotations

I am trying to turn off a lot of annotations at once by using Field Calculator to set status to Unplaced. Just typing "Unplaced" into the expression, I get this error: The calculated value is ...
3
votes
2answers
57 views

assign a number for each group in field calculator

I have several thousand features each of which has a name. The names are not unique. what I want to do with the field calculator is assign a number to each name so I can refer to a number and always ...
0
votes
0answers
24 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 > ...
1
vote
1answer
143 views

Adding count of features in categories to legend using ArcGIS for Desktop?

I am using ArcGIS 10.1 for Desktop and I would like to know How to add the Count (which is visible on the Symbology tab of the Layer Properties dialog) to the legend?
0
votes
3answers
32 views

Debugging CalculateField_management ERROR 000623: Invalid value type for parameter field?

I am trying to select records in my table that have certain words in the "Name" field and then code them as 0 (not pharmacy) or 1 (pharmacy) This is just a test searching for two words to select ...
0
votes
2answers
50 views

Field calculator fails when computing First X coordinate in ArcGIS10

I have this line in python to compute First X coordinates into the Field Calculator from each polyline: !Shape!.firstPoint.X Then, when I inspected the attributes I see this rare thing: You may ...
2
votes
1answer
48 views

How to return end of string up to a certain character using Field Calculator?

I am trying to accomplish this task: http://stackoverflow.com/questions/15851568/how-to-get-the-last-part-of-a-string-before-a-certain-character within the Field Calculator. I have the below but ...
0
votes
1answer
38 views

Field Calculator not showing some fields

When I open my attribute table, click on a column, and select Field Calculator it opens and doesn't list all of the Fields in my attribute table. Why can't Field Calculator find these Fields?
1
vote
1answer
38 views

ArcMap 10.1 Crashing when using field calculator

I keep getting a serious error message when I try to use the field calculator. I've joined a .csv to my SDE feature class and am trying to set one of the columns equal to one of the columns from the ...
1
vote
1answer
67 views

Updating a feature class

I am working on ArcGIS 10.2.1. I have a feature class containing more than 4000 records and a table having approximately 1000 records. Both feature class and table have some common fields however, ...
4
votes
1answer
180 views

Extract one GPS fix per day from data?

I am in the fortunate position of having 2 years worth of animal movement data. With such a large amount of data I would like to extract only one fix per day to make it easier to work with. Data = 14 ...
0
votes
0answers
28 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
1answer
60 views

What is the syntax for Python 2.7 to permanent display in percent in a field column?

What is the syntax to build to calculate field, for example, Acres to Percent? 841173.00 to 82 % What I want the field column in Percent to be display numbers with percent with the alignment to ...
2
votes
1answer
50 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 ...
5
votes
3answers
100 views

Calculation based on features in shapefile

I hope I get the terminilogy right! Correct me if I mess something up. I need to perform some calculations for a scoring system for different habitat types. The Problem is that I have two different ...
6
votes
1answer
179 views

How to classify time periods in a new field, using Python?

I have a datetime field (Horario) in my feature class, showing only the time. Although the date doesn't appear, it seem to be stored automatically as 30 Dec 1899, I'm not sure why. I want to use ...
0
votes
1answer
29 views

Calculating Area of Raster Classes

I have a raster in a GRID format that was created by Image Classification. The GRID is projected in StatePlane meters, but I would like the area in square feet. I'm assuming I will need to use the ...
1
vote
5answers
113 views

Calculations in if statement

I want to perform a simple calculation with the Field Calculator using this piece of script (note that all the elif statements are attempts for another syntax and non of the worked): def ...
0
votes
4answers
54 views

Populate a field from another field with a conditional

I am working in SDE geodatabase where I have a feature class 'Mange_Waste' and "Q1", "Q2" are two fields. I wanted to use python script for populating "Q2" from "Q1" with a condition. Like, if the ...
2
votes
1answer
53 views

QGIS: Expression WHEN property1 = 'FOO' THEN property2 = 'BAR'

Our Foundation is adding additional properties to points. If property1 = FOO , then add property2 = BAR WHEN property1 = 'FOO' THEN property2 = 'BAR' END When I run this the ...
2
votes
2answers
66 views

Call field from zip() into Field Calculator expression ArcGIS

I've been trying to find a way to call in field names from a zip(). Basically I have 12 fields called "Flw_days1", "Flw_days2" etc and corresponding "Depth" fields that need to be calculated using the ...
0
votes
1answer
24 views

Interaction with two variables as parameters, saving the raster properties output into a table (.dbf)

The draft of the model below TASK: I need to calculate the percentage of river channel that is covered with shadow in each timestep RESOURCS: I have values for azimuth and elevation of the sun ...
0
votes
1answer
28 views

How to implement a Gaussian function in field calculator?

Are there any build-in functions like Gaussian or Epanechnikov functions in field calculator? Or I have to write that by myself?
1
vote
1answer
64 views

How to use Fields in the Field Calculator? [duplicate]

I'm using the Field Calculator in ArcMap and I need to create a unique ID for every storm drain in my county. An ID Should look something like this: 16-I-003 The first number is the municipal number ...
1
vote
2answers
93 views

Conditional Calculate Field Many to One

Anyone have experience calculating a field based on a many to one scenario? I have a feature class in a geodatabase with a field of unique names. Feature Class Table (let's call this ...
0
votes
2answers
66 views

Using the Rule-based style to calculate each grid cell from overlaps

I am using the Rule-based styling properties (QGIS 2.2) to determine the colour of grid cells for a merged shapefile. Each grid cell defined by its ID may be overlapped by several layers as defined by ...
0
votes
4answers
145 views

Calculating acreage using ArcGIS Field Calculator?

What is the expression to calculate an acreage in USA ? I am aware that there is a geometry calculate but when you convert raster to polygon it doesn't do it's job and I have to use the field ...
0
votes
2answers
70 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
2answers
44 views

If clause within if clause VBA Arcgis10

I'm using ArcGIS10. I do not know what's wrong with this VBA code in the Field Calculator: *All the fields are String type If [StartY] < [EndY] Then If [DOT_OSM] ="1" Then Output = "F" ...
0
votes
1answer
32 views

Filling Field2 to icorresponding values in Field1 of shapefile using Field Calculator of ArcGIS for Desktop?

I have to give explanation in a new field of the existing field which contains abbreviation. Example: Field "Geology" has values Q, Qs,N....(abbreviation), I have to give explanation of those in a ...