All Questions
16 questions
0
votes
1
answer
157
views
Fetching data from ArcGIS attribute tables using ArcPy? [closed]
I want to fetch/extract data from ArcGIS attribute tables (to set some temporal series) using Python. Because of the structure of my tables and their disposition, I thought of using the "division"
...
- 25
2
votes
1
answer
556
views
ArcPy rollback update / insert cursors if error occurs
Is it possible to rollback an update made with an update cursor or an insert made with an insert cursor if an error occurs?
I need to go through a feature class and break numbers up into 100 groups. ...
- 329
2
votes
4
answers
1k
views
Retrieve last Row and specific field values with SearchCursor
I have a shapefile from which I want to retrieve the last row values for specific fields to use them as input in a tool. So far this is what I have which does not work.
length=int(arcpy....
- 35
-2
votes
1
answer
104
views
Calculating total numbers of wells that fall into each county of table using ArcPy?
Directions:
For each county calculate the total numbers of wells that fall into that county, and update the county table with the total count. This is the code I have so far.
Problems:
The ...
- 11
1
vote
1
answer
772
views
Sum Values for multiple unique field values
I am trying to modify an existing table that I can relate to a feature in Arcmap(v10.5).
Currently, the table fields and values look like this:
I would like to summarize the table. For each unique "...
1
vote
2
answers
267
views
Delete Table Rows Based On Two Field Values
How can I delete a row in a table if value A from Field 1 does not match value B from Field 4 ?
I attempted to use code from a previous post as I figured it would be a start but didn't work.
...
- 81
1
vote
1
answer
428
views
Arcpy.da.SearchCursor() help when attribute doesn't exist
I'm updating text elements off of an arcpy.da.SearchCursor script and needed to construct the script to return a response for when the attribute does NOT exist. Here is the snippet of the code THAT ...
- 33
0
votes
1
answer
1k
views
Finding field with maximum value and field name using ArcPy cursor?
I was wondering if an equivalent of summary statistics exists for finding such statistics across fields rather than records in a table. For example, of several fields, I wanted to find which one has ...
- 629
3
votes
1
answer
3k
views
Calculating summary statistics and access resulting value in table using ArcPy?
With arcpy, I want to calculate the mean value of a specific field in a shapefile and print the resulting value for the user.
I use the Summary Statistics tool and it works, but the resulting value ...
- 883
1
vote
2
answers
838
views
Error adding row - sequence size must match size of row
I have this table with one row
timestamp_pretty 3.1.2014 9:13
timestamp 1,38874E+12
msgid 3
targetType A
mmsi 205533000
lat 53.4346
long ...
- 497
1
vote
1
answer
177
views
What is the most efficient way to get the values of a previous row in a table using ArcPy? [duplicate]
I am very new to ArcGis and I would like to get a specific value of the previous row in a table.
I found this question here on gis.stackexchange.com and experimented a little bit. However, I found ...
- 113
1
vote
1
answer
194
views
Arcpy to append results of pivot table
I have a script that does some processing but the main part are two things
run a multiple ring buffer using arcpy.MultipleRingBuffer_analysis and four rings
do some zonal statistics using arcpy.sa....
- 237
1
vote
3
answers
841
views
Returning unique value from table using ArcPy?
Using Arcpy in Python, I would like to return / print '0.15' from the following table:
When I use the following code I get "(u'D', 0.20)" as my print statement in Python:
import arcpy
fc = "C:/...
- 371
1
vote
1
answer
232
views
table update w/ cursor geometry conflict
I'm creating a table using arcpy with a list of results (stored in 2d lists) following an update to some features. This can sometimes include geometry, so I've attempted to substitute those for a ...
- 397
2
votes
1
answer
639
views
Invalid SQL Error when using InsertCursor on table created using CreateTable
I am trying to write a list of items to a new table in Arc. When I attempt to add a new row to an Arc table, I get the following error:
Runtime error
Traceback (most recent call last):
File "<...
- 173
1
vote
1
answer
802
views
Help with Python Update Cursor syntax
I'm having trouble running a loop to update the values in a particular field in attribute table by reading from a csv file. Any input is greatly appreciated. The following is the sample code:
import ...
- 13