topic GetCount_management & InsertCursor in Python Questions

GetCount_management & InsertCursor

LarryAdgate — Mon, 22 Jan 2018 21:10:04 GMT

#This scrip is working to a point, but is not what I expected. If Someone could help me with this,
#it would be greatly appricated.......Thank You in advance.

#The GetCount_management "COUNT" for the wHydrant Feature Class is 4457.
#After running the script, the result is four separtate rows in one column. See attached.
#My expectation is only one row and one column.

import arcpy

lyrfile ="C:\\Projects\\DavidSchultise_Southwest_GIs\\SouthwestTesting.gdb\\HydrantTesting\\wHydrant"
result = arcpy.GetCount_management(lyrfile)
print('{} has {} records'.format(lyrfile, result[0]))

#My Table
fc ="C:\\Projects\\DavidSchultise_Southwest_GIs\\Testing.dbf"

for row in (result[0]):
cursor = arcpy.da.InsertCursor(fc, ["NUMBER"])
cursor.insertRow(row[0])

Re: GetCount_management & InsertCursor

ChrisSmith7 — Mon, 22 Jan 2018 21:17:38 GMT

Hmmm, can you just use the below snippet for your count?

int(arcpy.GetCount_management(lyrfile).getOutput(0))  ‍‍

Re: GetCount_management & InsertCursor

LarryAdgate — Mon, 22 Jan 2018 21:30:30 GMT

I apologize, I forgot to add that eventually I need to loop through aprox four hundred features classes for an inventory project..............Thank You

Re: GetCount_management & InsertCursor

ChrisSmith7 — Sat, 11 Dec 2021 11:12:50 GMT

First, for the issue at hand with it printing over multiple rows, running this doesn't work?

import arcpy

lyrfile ="C:\\Projects\\DavidSchultise_Southwest_GIs\\SouthwestTesting.gdb\\HydrantTesting\\wHydrant"
fc ="C:\\Projects\\DavidSchultise_Southwest_GIs\\Testing.dbf"

result = int(arcpy.GetCount_management(lyrfile).getOutput(0))

cursor = arcpy.da.InsertCursor(fc, ["NUMBER"])
cursor.insertRow([result])‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: GetCount_management & InsertCursor

ChrisSmith7 — Mon, 22 Jan 2018 22:13:10 GMT

Regarding the fc loop, let us know if you encounter any issues! Are they all in the same gdb?

Re: GetCount_management & InsertCursor

LarryAdgate — Mon, 22 Jan 2018 22:40:16 GMT

Hi Chris,

We are a very large Public Water Utility Company with over thirty eight Geodatabases and our asset management group requires an inventory of all their assets. It will be a challenge looping through all of them and with a little help I will get there..................Thank you for checking back with me.

Larry

Re: GetCount_management & InsertCursor

ChrisSmith7 — Tue, 23 Jan 2018 14:09:37 GMT

Larry,

There's a discussion on StackExchange (GIS) that might help you down that path, no pun intended - arcpy - Listing Feature Classes of Multiple geodatabase in Multiple Folder? - Geographic Information Systems Stack Excha…