The Field calculator in ArcGIS-related products can recalculate the values of a single field on all or selected records within a table based on a symbolic expression in a programming language.
2
votes
1answer
214 views
Counting occurrences across a record in ArcGIS 10.0
I'm a student at Millersville University, PA studying for a BA in Geography with a concentration in GIS. I've stumbled across this site for questions I've had over the past year or so with getting ...
2
votes
2answers
973 views
Multiple input tables for Add Field in ModelBuilder
My model requires field1 to be added to fc1 and fc2, and then calculated according to a Python expression calc1. field2 is then added to fc2, and calculated using calc1. How do I add the multiple ...
2
votes
1answer
328 views
Field Calculator Runs In IDLE (2.6.5) but not ArcGIS 10 SP3
just wondering if anyone else is having issues with the field calculator in ArcGIS 10 SP3. In the following code I do a pretty simple field calculation with a variable (an array) as one of the ...
1
vote
3answers
814 views
field calculator syntax error
I'm trying to calculate the direction the 'generate near table' function gives me into actual directions, N, NW etc. Azimuth would be a start too.
I tried this script in the field calculator but it ...
1
vote
4answers
50 views
Field Calculator: Add “0” to the front of all values in a column
I have a table for each state with Zip Code values. The 5-digit Zip Codes that start with "0" have been reduced to 4-digits. I cannot figure out how to add a "0" to the front of all the values in the ...
1
vote
3answers
376 views
python: Replace Variable in VB-Expression-File (.cal) [ArcGis 9.3]
I'm trying to modify a VB-Expression saved in a cal-file:
dim out
if [D19830701]=-9999 then
out= [D19830501]
else
out= [D19830701]
end if
__esri_field_calculator_splitter__
out
with this ...
1
vote
1answer
56 views
How to fill inn A, B, C …Y, Z, A, B, …Y, Z, A, B, and so on? [duplicate]
as a second part of a problem i am trying to solve. I need help to figure out how to fill in serial letters.. Starting at A.. going to Z and starting over at A again.. I have a tabel with numbers ...
1
vote
2answers
50 views
How to get a string from a Double with a fixed number of decimals?
I have a featureclass (in a File Geodatabase), with a particular field of type Double. I want to copy it over to a text field, so that only 3 decimal places are shown.
For example: 34.78902345 ...
1
vote
1answer
111 views
How do you calculate values of a field based on two others using Field Calculator in ArcGIS 10.0?
I need to combine two fields in an attribute table. I want to do this using the field calculator. What is the proper script to write to combine a field called "name" and "type", so that it produces ...
1
vote
3answers
209 views
Automatically assign numbers to point file in various order in QGIS
I know how to automatically assign numbers to a new point files using the $rownum function in the field calculator. However it does it from the top-left over and down like reading a book.
I could ...
1
vote
2answers
78 views
area values determined with field calculator become null when saving
using field calculator in Qgis 1.8.0 to get the area, it shows just right at first but when I save it, the values become Null. help please
1
vote
2answers
240 views
FieldPyculator Plugin - How to Classify Fields?
Could someone tell me how to classify/populate fields with QGIS FieldPyculator Plugin?
In the Attribute Table, I have a field named POPULACAO with population data:
I want to apply a weight to ...
1
vote
1answer
163 views
Small issue with 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"
...
1
vote
1answer
131 views
Why does Field Calculator return 0 values when decimals are expected?
I realize I posed this question, and got answers, several days ago (see (Field calculator error)) , but none seem to really be working, and so am posing again.
Below are two screenshots that show the ...
1
vote
1answer
177 views
Arc 10 Python .shp attributes - usings fields to populate other fields - if/then/else statement
Ive been looking for a solution and unable to find one so please help if able:
I'm trying to avoid manually inputting Begin and End engineering station values already inputted into a seperate field. ...
1
vote
1answer
584 views
How to do a simple find and replace in QGIS field calculator?
I'm trying to replace selected string values in an attribute table, eg. "Text1" for "Text2" (QGIS 1.8.0), patriculary for those rows with NULL values. I have been trying to use the replace expression ...
1
vote
2answers
766 views
Use Round in ArcMap 10.x Field Calculator on field with both numeric and NULL values
With older versions of ArcMap (9.3, 9.2, etc) I was always able to round numbers down to 2 decimal places using field calculator even if that field had both numeric values and a bunch of NULL values. ...
1
vote
2answers
784 views
ArcGIS field calculator: VBScript get data from previous row
When using the field calculator, how do I get data from the previous row in VBScript? In Python I'd do something like this:
for index, row in enumerate(rows,start=1):
row[index-1] += 5
I'm ...
1
vote
1answer
143 views
How to implent a “maketrans” python function on field calculator
i'm traying to implent python string translate function at field calculatore
http://www.tutorialspoint.com/python/string_translate.htm
in order to fix hebrew imported from cad. here is the code -
def ...
1
vote
1answer
453 views
Concatenate Fields into One Field in QGIS
I have seen some posts on this, but only for ArcMap. I am looking to take a range of values from two fields and concatenate them into one field to make a unique value. For example:
XMAX YMAX ...
1
vote
1answer
303 views
How to tranform a column field into a list using Field Calculator
I'm trying to make a simple field calculation with ArcGIS 9.3:
New field = Old field - Old field(first value)
which in Calculate Field with python code should be
Expression:
!Old field! - first
...
1
vote
1answer
30 views
QGIS Field Calculation convert to ArcGIS
I have a field calculator expression I use in QGIS to generate unique IDs that are sequential, but start with a text string. I now need to perform the same thing in ArcGIS, but I am unsure of how to ...
1
vote
1answer
686 views
ArcGIS 10.0 \ arcpy - CalculateField_management : help with syntax for updating text in attribute table of feature classes
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
290 views
How to calculate field as cursor name?
First time dealing with cursor.
I have lines intersecting polygons, I want to get a table with all attributes of the lines, add a field and calculate the field as the name of the polygon.
I was able ...
1
vote
1answer
83 views
How to import text only out of a string field to a new field
I want to import data out of a string field in my shapefile to a new field for labeling. The string field contains river names and codes and I just want to display the text i.e river names
1
vote
1answer
870 views
Do QGIS Field Calculator xat(n) and yat(n) functions work in version 1.7.x?
I'm trying to use the xat(n) and yat(n) in the Field Calculator but can't get them to work.
Does anybody have an example how to use them?
I need the start and end coordinates for line segments, does ...
1
vote
1answer
89 views
How do you calculate a column value based on the value of another column?
I am trying to select data based on whether it starts with certain characters and then update a field. For example if [Asbuilt] starts with "WL" then do something. Here are the two methods I have ...
1
vote
1answer
85 views
How to create a label formatted like “ 1,000' ” from a numeric field?
This question builds on a previous question I came across at gis.stackexchange:
How to easily edit attribute data using Regular Expressions?
Perhaps someone can point me in the right direction?
I ...
1
vote
1answer
273 views
How to use field calculator for area calculations in QGis? [duplicate]
Possible Duplicate:
Calculate area between contour lines on a DEM with Qgis 1.8.0-Lisboa
Based on a DEM of a whole country I have reclassified altitudinal bands with steps of 100 metres ...
1
vote
0answers
148 views
How to calculate column average in Arcmap using VBA [closed]
I'm really new in gis and programming... So could anyone write VBA code for counting average.
For example I have 3 columns which are named as JAN, FEB, MART...Each of them have 50 values in column. ...
0
votes
1answer
90 views
Delete first two letters from a string field
I'm looking for a field calculator python statement to delete only the first two letters of string entries.
For Ex:
!Name!.strip([0:2])
I know this syntax is incorrect.
Thanks a lot
0
votes
1answer
210 views
How to use VBA in the field calculator, to copy the last 7 characters to a new field?
Im using ArcMap 9.3. Im looking for a VBA code to use in the field calculator to make a new field of the last 7 digits of a "pin" field. For example. my pin is 00-00-999-999 and i want it to ...
0
votes
1answer
21 views
ArcPy Field Calculation with special characters
I'm trying to calculate a string field, using "µSv/h". Running this in the manual field calculator works just fine, but I've tried this in the Python window in ArcMap as well as the IDLE, but both ...
0
votes
1answer
74 views
How to calculate polygon areas in acres or square miles instead of feet?
I have a layer in State Plane NAD83. When I use "Vector|Geometry Tools|Add/export geometry columns" or Field Calculator they both create the area in feet. What if I want acres or square miles? Thanks
...
0
votes
3answers
70 views
How can I easily detect gaps in a polyline using arcmap 10.0 (arcview license)?
I'm making routes by selecting links from a streets layer which I export as a new temporarely layer in arcmap 10. This layer which I call route_temp unfortunately can be very long and contain gaps, ...
0
votes
1answer
68 views
Add sequence numbering based on attributes in a table [duplicate]
Is there a way to auto populate a sequence of numbers based on another attribute in a table? For example, if field "Name" has a sequence of numbers from 1 to 10, and I want to number all the rows in ...
0
votes
2answers
694 views
Update NULL values MDB table
How do you update NULL values within mdb geodatabase table using ArcGIS Field Calculator (service pack 4) without changing other values to NULL? I've tried the suggestions on this previous question:
...
0
votes
1answer
104 views
FieldPyculator Plugin - How to concatenate fields?
How can i concatenate two fields using pyculator plugin? There is any document with all pyculator functions that i can use in "field expression"?
0
votes
2answers
309 views
How to auto populate multiple fields in attribute table?
i have Feature Class Buildings, it has many fields like ...
0
votes
1answer
369 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
67 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
20 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
34 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
24 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
65 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
27 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
294 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
134 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:
...
