For questions about ArcGIS's Python Parser
4
votes
4answers
45 views
Normalizing raster using raster calculator in ArcGIS 10.3.1?
I have been trying to 'range standardise' or normalise my raster values from 0-100 and I know how to do this mathematically:
("raster"-min("raster"))/(max("raster")-min("raster"))*100
and I have ...
1
vote
1answer
26 views
Stacked label with parentheses and exclusion
I'm doing some labeling and have my labels stacked using python by using the following: [field1] + 'n\' + [field2]. But I'd like to keep the label stacked and add parentheses to [field2] as well as ...
0
votes
0answers
20 views
Adding row to new empty table using ModelBuilder? [closed]
I can create a point feature class and start an edit session in ArcMap which adds a row and I can enter data. So far i haven't created a point - just added data to the table. What i want to do is ...
-3
votes
0answers
28 views
Naming output file as the absolute path name [closed]
I have a model for a class that outputs files with an iterator to get all files in directories and sub-directories and output them to a File geodatabase. The professor wants me to have the model ...
1
vote
0answers
35 views
Populating an attribute field using calculations based off fields of another feature class
I have hundreds of 'agriculture' polygons in one feature class, and each polygon is surround by numerous 'margin' polygons in a separate feature class. What I would like to do is select all the ...
5
votes
0answers
39 views
How to update null geometries from an attribute [duplicate]
I have a large point feature class and have realised that there are several hundred features with null geometry. Fortunately the coordinates are stored as an attribute. So What I need to do is update ...
2
votes
2answers
46 views
Parsing new field into calculate field
I have a pivot table that has 11 ShipTypeGroup fields with "Long" field properties that cant be divided by 12, due to decimal places. Therefore I am trying to create a new field, copy attributes ...
1
vote
1answer
25 views
ArcMap function in field calculator not working
Trying to return everything except the last element in a field after splitting it. Using ArcMap 10.2.2 in the field calculator.
!ST_NAME!.split(" ")[:-1]
This returns a null value in attribute ...
4
votes
1answer
95 views
Using ArcGIS Field Calculator to populate new field from old field
I'm trying to assign speed values to street types using TIGER street shapefiles. So I created the new field for the speed, and I was going to use the field calculator to take the MTFCC classifications ...
0
votes
2answers
43 views
Using Asterisks in Python parser of ArcGIS Label Expression Builder?
I am trying to create a label expression that labels features that contain hike in their name (versus those that don't).
I have tried something like this:
def FindLabel ([Name]):
if [Name] is ...
1
vote
3answers
81 views
Replace occasional Space with Underscore using Python parser of ArcGIS Field Calculator?
I am creating a model which will give me two string values, one which reads exactly what is in a field and another which automatically replaces any Space with an "_". I have used Calculate Value tool, ...
0
votes
2answers
47 views
Trying to use Python to clean up null/bad data in Lat/Lon Load
I'm using ArcMap 10.4. Trying to load a list of Lat/Lons and connect the surface hole and bottom holes with a line connector (Toolbox XY to Line). I have two issues:
1) Values which have BHL and ...
0
votes
1answer
32 views
Using elif statements in Python parser of ArcGIS Field Calculator?
Looking for some help. I have a continuous variable (PCT_B100P) of the percentage of folks in a census tract that are under the 100% federal poverty line. I'm trying to use this variable to assign a ...
2
votes
2answers
65 views
Field Calculate to remove certain values in field
I have a field named "ZIP" which has the zip code information for numerous records. Some of them have 9 numbers, but I only want them to have the first 5. What should my Pre-Logic Script look like to ...
1
vote
1answer
21 views
ArcGIS 10 Split string from OSM data
maybe you can help
I have a string:
"width"=>"6","name:be"=>"Калінавы завулак","name:ru"=>"Калиновый переулок","surface"=>"asphalt","int_name"=>"Kalinavy zavulak","maxspeed"=>"40"
necessary as a ...
1
vote
1answer
24 views
ERROR 000539: Invalid Field !FULLNAME!
I am very new to Python and my first attempt hasn't gone too well. I'm trying to overwrite a field that is a spatial join of a couple of features in order to, in the end, generate a beginning and ...
2
votes
4answers
112 views
Setting up Concatenation using Python expression in field calculator?
I am having trouble creating a Python expression in Field Calculator in ArcMap 10.3.1. I’m attempting to concatenate two field values (double and short integer) to a third (double) field, (CON_IN). I ...
2
votes
1answer
39 views
Inserting substring in ArcGIS Field Calculator
Trying to use the split tool in ARCGIS to add an underscore. Trying to make "ABC11111" look like "ABC_11111". Don't have much experience using Python or VB Script but this is what I have created with ...
1
vote
1answer
61 views
Python/VB Script Field Calculator
I'm new to Python/VB Script and am needing some help. I have tried several different If/Then statements but can't seem to get it straight. I am hoping for some help. I have 3 fields. ZONING, ...
2
votes
1answer
41 views
Dealing with zeros while iterating a model for percent change
I'm using ArcGIS to examine some aquatic vegetation changes over time and I have created a model that adds two fields: Area_percentLoss and Biomass_percentLoss. My model is iterating over feature ...
0
votes
1answer
44 views
Getting “real time” occurence count of values in attribute table for displaying purposes
I'm working with ArcMap 10.2 on a layer of points that I have to move. I'm using the editor to move them. What I also need is to display these points based on how many are sharing the same coordinates ...
5
votes
1answer
102 views
Field Calculator text field to new shapefile
I have point features being selected by a polygon feature and copied to their own shapefile. I also have certain values of the polygon feature being applied to the newly created point file. The ...
6
votes
2answers
133 views
ArcMap sometimes ignores labeling expression
I'm using this python script as an expression for labeling in ArcMap:
def FindLabel ( [volkorrekt] ):
if [volkorrekt] >= '5':
return "<FNT size = '20'>"+ str( [volkorrekt] ...
2
votes
1answer
48 views
Concatenate fields in Field Calculator using Python [duplicate]
I'm trying to concatenate fields together and used this post as a guide:
<Adding hyphen in ArcGIS Field Calculator to merge two columns?> ; however, I'm still getting a 989 parsing error. Here's ...
1
vote
2answers
58 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 ...
4
votes
2answers
117 views
How to concatenate two fields (type double) into a single field?
In arcgis 10.3 using the field calculator I'm trying to concatenate a census tract field (double) with a census block field (double) into a single field that has the two values separated by a decimal ...
1
vote
1answer
28 views
ArcGIS Issue with Python wildcard in Label Expression?
Here is my current expression:
def FindLabel ( [FULL_NAME] ):
fn = [FULL_NAME]
if "COUNTY ROAD" in fn:
return "CR " + fn[11:]
elif "% COUNTY ROAD" in fn:
return fn[:1] + "CR" + fn[13:]
else:
...
4
votes
2answers
83 views
How do I use Python to edit a field in an attribute table?
I have a few data tables full of information on salt water injection wells, with injection volumes given on a monthly basis. I need to add these monthly values up in order to get an annual value for ...
1
vote
1answer
48 views
Calculate field tool vs Field Calculator
I have successfully populated a field in Arc using the Field Calculator, however I would like to re-create this in python as part of a tool I am making. I was going to do this buy using 'Calculate ...
1
vote
3answers
98 views
Script for Sum of Rows in field calculator - VB or Python?
I wrote the TOTAL_FREQUENCY values manually. But I want to automatically write this values with a script. Namely, I want to write sum of column 3 to all of the the column 5 rows. How can I do it with ...
6
votes
1answer
80 views
Python Labeling using dictionary not printing all values
I am labeling manhole inverts using python and ArcMap 10.3. When I use a dictionary to control the label order some manholes don't print all of the inverts while other manholes do. I can post field ...
3
votes
1answer
43 views
Maplex Label Expression in Python Parser of ArcGIS for Desktop?
I am using a python code in ArcGIS to define the size of the labels of a point feature class. Therefore I am using a label expression (Maplex). The label size of the TEXTSTRING (string) should be ...
1
vote
1answer
25 views
Python not appearing as option for parser in label expression dialog of ArcGIS Desktop 10.0?
I have ArcMap 10.0 and python is not appearing as a parser option in the label expression dialog box, only VBScript and JScript. Python is installed and the python window works fine.
Any idea how I ...
1
vote
1answer
43 views
Date different in field calculator using python method
I would like to calculate date different between two fields of date format.
The idea is to know if Field_1 is greater than Field_2.
My calculate code is something like this:
def date(f1,f2):
if f1 ...
1
vote
1answer
44 views
Calculate Field throws an error when parsing python with backslashes
I have an FTP I need to access through a python script. It works fine with forward slashes, but I don't need it to be read as an html. Below are both sets of code:
Working:
...
4
votes
1answer
80 views
Using UNC pathname with Calculate Field tool in ArcPy?
This question is different to Using Calculate Field to fix hyperlinks in ArcPy gives Cannot use VB for services?
which was asked previously because it is using the Python parser specifically, rather ...
3
votes
2answers
140 views
Field calculator if and elseif statement with <Null> values in ArcGis 10.1
Trying to figure out how to get this "Headwater" column to indicate "Yes" (or 1) if the value of "NextDown_Copy" is "" and "No" (or 0) if it has any other value (eg. 7100381010).
I attempted to ...
1
vote
3answers
82 views
Create a stacked Python label expression in ArcGIS for Desktop 10.3
I have a number of polygons representing exploration licences and a series of attributes including licence name, operator, partners and associated interests (%) within each licence. I am trying to ...
10
votes
4answers
339 views
Need to find strings that contain the same word twice
I have attribute data with owner names. I need to select data that contains the last name twice.
For example, I may have an owner name that reads "BENNETT MCCARL & ARNETTE BENNETT".
I would like ...
2
votes
2answers
61 views
Field Calculator - conditional function and string variable?
I know this question has been asked before in different fashions, but I can't seem to get my python script to work despite looking at all the relevant questions I could find.
I am simply trying to ...
1
vote
1answer
39 views
Iterating through list of fields using field calculator?
import arcpy, sys, itertools
arcpy.env.workspace = r'path to geodatabase'
fields1 = ['gearqty', 'cnemarea', 'fzone', 'qdsq', 'tensmsq', 'crew', 'nanglers', 'port', 'totalquant', 'trip_days', ...
1
vote
0answers
53 views
Converting Atn function of VB Script for Python parser of ArcGIS Field Calculator? [closed]
I would like to convert the Atn function (which returns the arctangent of a number) of VB Script to Python but I cannot find exactly the same function. Any help?
I want to convert the slope of ...
1
vote
2answers
91 views
Calculate field more wisely
I first classified firstCol into groups and then I want to give the groups with different weighted values in another field, SecondCol. I will need to give different weighted values very often. I find ...
0
votes
0answers
27 views
Calculate field for each Feature Class in Dataset using Python and different arguments
I have Dataset with Feature Classes in it. I'm building this in ModelBuilder.
I want to calculate new field (SMB_ID) depending on attributes for each feature class.
I was trying to make it simple ...
1
vote
1answer
44 views
failed to Writing conditional (if/then) statements into Field Calculator of ArcGIS for Desktop using Python parser?
I wrote this following several examples but it is still wrong. I need to populate a new field based on 5 ranges of values.
def marks(Wards for try.JHRatio ):
if (Wards for try.JHRatio <= ...
1
vote
2answers
122 views
“CountIf” or alternative function in ArcMap field calculator?
Within ArcMap 10.3 field calculator, I am looking to count the number of features in a column that match the current value, and output that count. Ideally, the output would look like this:
Number ...
1
vote
0answers
61 views
Replacing Null values with field calculator
My goal is to use the field calculator to replace null values. I am trying to replace nulls in the ToDate_Time with the FmDate_Time. When I run the code below the results window says that it worked ...
2
votes
3answers
245 views
How to get around “The field is not nullable” error?
I have a shapefile of lines.
I want the angle of every line calculated in a field.
I am using the script below in arcmap, but when it encounters a line that is horizontal, it stops calculating any ...
0
votes
1answer
72 views
Calculate percentages with field calculator in arcgis?
I am trying to calculate the percentage of each the area of each polygon in the selected area.
I tried using ( math.fsum(!shape.area!) / !PolygonArea! )*100 and other codes but I cannot make it work.
...
1
vote
1answer
59 views
Labeling Count values from Arcgis attribute field
Today at work I was facing some challenges to Label the count values from attribute tables of the feature class. We have all the data stored in geodatabase that is server based. I wrote python code in ...
