topic Re: create and update feature class in Python Questions

create and update feature class

suhanatssuhanats — Sat, 21 Jan 2012 00:36:43 GMT

I have a python script to create featureclass from an sql server database table
the sql table gets updated everyday. So i want to find the max(id) from featureclass and select only those newer rows in sql table where id
greater than featureclass id and update it to feature class.

Re: create and update feature class

JakeSkinner — Sun, 12 Dec 2021 06:31:06 GMT

Hi Suhanats,

You can find the max OBJECTID by appending the OIDs to a list and then retrieving the max value from the list. Ex:

fc = "Airports"

OID_list = []

rows = arcpy.SearchCursor(fc, "", "", "OBJECTID")
for row in rows:
    OID_list.append(row.OBJECTID)

del row, rows

maxOID = max(OID_list)

Next you can use maxOID variable to select only the new records within the SQL table.

Re: create and update feature class

RussellBrennan — Mon, 23 Jan 2012 13:57:41 GMT

There is a Summary Statistics tool in the analysis toolbox that will get you to get the max value for a field and output this value to a new table.

Re: create and update feature class

suhanatssuhanats — Thu, 26 Jan 2012 03:23:20 GMT

thank you. i did a sort desc in the cursor and got the value of the field. i had to do this since the id value that i want is not the standard objectid field, but a user created field.