Questions tagged [field-calculator]

Use for questions about Field Calculators of QGIS, ArcGIS Desktop, etc and their Calculate Field tools

Filter by
Sorted by
Tagged with
1
vote
3answers
403 views

If/then Field Calculator

I have two fields in my model, the first is a spatial join return for the township, the second is a spatical join to a city. If there is not city, then the field is left blank. The column that has ...
1
vote
1answer
137 views

Use value of Field in Calculation in Modelbilder

In Modelbuilder I have set up a model, where in one step I do a "Calculate Field" like "round((!OID!-1- %MyField% /15)/452,1)+1" . For the calculation i use the value of %MyField%, which actually is ...
1
vote
2answers
181 views

Using Calculate Field to fix hyperlinks in ArcPy gives Cannot use VB for services?

Getting an error while trying to script it, specifically "Cannot use VB for services." Snippet and VB code block as follows: Raw block (works within ArcMap): "\ftp\raw\YYYYMMDD\Files\Charles" +[NAME]...
1
vote
2answers
209 views

Checking for values in one column and do something in another using ArcGIS Field Calculator?

I have two columns: "Street1" and "Verified". I need to check all rows in Street1 to see if they are of string "0" or null. I've attempted to come up with something in Field Calculator but it is ...
1
vote
2answers
118 views

Comparing two fields and printing result as 1 (if number matches) or 0 (if not) using Python Parser of ArcGIS Field Calculator?

I have two fields named as "sample no" and "data_all" trying to find out whether "sample no" exist on "data_all" or NOT. Using field calculator python 9.3. if exist print 1 if not print 0 in check_in ...
1
vote
1answer
571 views

Is it possible to calculate a value based on values of another row?

I have a point shape file in qgis. For one of the attributes, I would like to offset the values, i.e. the value for point 1 goes to point 10, the value for point 2 goes to point 11 and so on. I see ...
1
vote
1answer
582 views

Expression string builder QGIS

I created a virtual field in my layer where I want a specific value to be calculated. In my attribute table I have several columns. The expression I am trying to create is the following. I want to ...
1
vote
1answer
139 views

Reaching field value of record in ArcGIS field calculator?

I have two fields showing number of people in two age groups "young" and "old". these people also live in a cell (point) whose distance to a specific facility is calculated. then I categorized these ...
1
vote
2answers
50 views

Use a python expression in Field Calculator to sum each row across several columns

this seems like it should be easy but I am new to python and am having trouble... I have four columns. I would like perform a field calculation that sums the values by row for three of the columns and ...
1
vote
1answer
1k views

Remove Leading Zeros with QGIS Field Calculator

I'd like to take this attribute value: "MAP_PAR_ID": "0160011000", and populate a new field with "16-11". This works: concat(substr("MAP_PAR_ID",0,3), '-', substr("MAP_PAR_ID",5,3)) but i need to ...
1
vote
1answer
301 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
655 views

Am I over-complicating adding and then calculating fields? Suggestions for a better way? (Python)

I'm attempting to re-position a question I asked yesterday here. I am starting to think that the way I wrote my code just isn't the best way. Am I overcomplicating things? I know for a fact that ...
1
vote
0answers
65 views

Calculating distance between consecutive points using ArcGIS Desktop? [duplicate]

I am not able to get the answer to the question below to work for me using the information provided: Finding distance between consecutive points using ArcGIS Desktop? Could someone post a screenshot?...
0
votes
2answers
8k views

ERROR 000989: Python syntax error: Parsing error SyntaxError: invalid syntax (line 2)

I have a Field Calculator I am using with Python and I keep getting the above error. Below is the screenshot of my Field Calculator I am using. What am I doing wrong here?
0
votes
1answer
2k views

Auto incrementing field that begins with text in ArcGIS Desktop? [closed]

I am searching for a way to auto increment an ArcGIS field which begins with text and followed by numbers. Ex. SWCL0000. I have tried the auto increment code in the field calculator but once I added ...
0
votes
1answer
2k 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 ...
0
votes
1answer
1k views

ArcMap Calculate Field..if “text” in !Field!

Is it possible to use Field Calculator in ArcGIS to add text to a new field based on an if in statement? Example: In an attribute table I have a some fields called !X!, !Y!, !Z! where "A (xx%)", "B (...
0
votes
1answer
843 views

Replacing values in multiple columns using QGIS Field Calculator?

In QGIS I want to search for a specific case and if this is true then replace the text in multiple columns. Based on Use updatcursor to replace values in multiple fields, Update multiple fields/...
0
votes
5answers
13k views

Changing null value to specific numbers in ArcGIS for Desktop? [closed]

I have a Excel file showing annual precipitation and I add it on arcmap. When I tried to check it's attribute table the field calculator is passive. I want to change all the Null value to specific ...
0
votes
1answer
105 views

Sort selected points by latitude/northing with field calculator

I have bathimetry data in .shp format. The points (picture below shows one of multiple groups/profiles) do not have ID numbers and are randomly dispersed through the attribute table. I have selected ...
0
votes
1answer
93 views

Calculating field with ArcPy cursor?

I am trying to calculate field with the formula. I tried arcpy.calculate field management but still having difficulty. (10/10.4*(100*(math.exp(0.000871* !A!)-1+math.exp(0.000537* !B! )-1+math.exp(0....
0
votes
1answer
46 views

Identify same values and assign code to them using ArcGIS field calculator?

There is the attribute table the FID_lote_teste fields and selecao both integer. The selecao field receive zero (0) if the FID_lote_teste field number does not exist in memory. For example: First ...
0
votes
1answer
505 views

How to calculate/record attachments' file names using Field Calculator?

I have a point feature class containing attachments corresponding to jpg files (sometime more than one jpg per feature). I would like to use the "field calculator" to calculate/record a new field that ...