Latest Contributions by JustinWolff

I'm using the usaddress library to split single-line addresses into their various components. Below is the functioning script that I'm using for testing: import arcpy from arcpy import env import os import usaddress from collections import OrderedDict # Get input table through parameter table = arcpy.GetParameterAsText(0) # Get the field containing the single-line addresses through parameter infield = arcpy.GetParameterAsText(1) # List of fields to be updated fields = ["addr", "addrNum", "stNm", "zip"] with arcpy.da.UpdateCursor(table, fields) as cursor:      for addr, addrNum, stNm, zip in cursor:           try:                parse = usaddress.tag(addr)[0]                addrNum = parse.get("AddressNumber", "")                stNm = parse.get("StreetName", "")                zip = parse.get("ZipCode", "")                cursor.updateRow([addr, addrNum, stNm, zip])                continue           except Exception:                arcpy.AddMessage("Error")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Here's what the testing input table looks like before: And after: My goal is to write the records that error out to a separate table.  (Errors include situations where multiple areas of an address have the same label, like "5318 S 86 CT APT 3 APT 412, Omaha, NE 68137" - multiple APT entries, or "PO Box 291 PO BOX 291, Genoa, NE 68640" - multiple PO Box entries.)  I've reviewed the examples in the error handling page, but they seem to be very focused on geoprocessing. Also, this is the first time I've used cursors in this manner, which prevents me from using something like the following:      except Exception:           arcpy.AddMessage(str(row.getValue("OBJECTID")) + " Error")     ‍‍‍‍‍‍‍‍‍‍‍‍ At least I can't figure it out so far.  Any suggestions or bump in the right direction are greatly appreciated. Thanks Justin ... View more

Yesterday I posted this in the incorrect area instead of Python.  I have a file gdb with a couple thousand features, a few hundred of which have duplicate attribute values.  I want to merge these features with duplicate attribute values to become multipart lines.  Because I'm working in a FGDB I cannot use a SQL query and the Find Identical helps me identify the records, but not much else.  The source data is being created from linear referencing of SQL table data nightly, and I'll need to automate this select/merge as well.  I need a nudge in the right direction. (I'll also need to do this to a point feature class, but I'm aware that's another set of problems with multipoint geometry.) Any help is appreciated.  Thanks Justin ... View more

I understand I cannot use a SQL query to select multiple records that have duplicate values within a FGDB (only personal or SDE).  Does anyone have a workaround?  My goal is to select features that have duplicate attribute values in a particular field and merge them together to create multipart polylines...then delete the original, separate features and replace them with the new, multipart features.  (I have to do this for a point feature class as well, but I know that will take additional effort to create a multipoint feature class and integration with single point feature class is difficult.)  Right now I'm stuck on go just trying to select the duplicate records. Thanks Justin ... View more