Latest Contributions by BlakeTerhune

No, I'm asking about the source data. How do you create the SUBS.shp? ... View more

Are you creating it from a shapefile or a geodatabase feature class? ... View more

When you create the shapefile, you'll have to do it row by row, no export or update. Do you need a shapefile (with geometry) or can it be just a table of values (CSV)?   ... View more

@2Quiker wrote: Blake, this is helpful but it doesn't physically change the order of the SUB_NAME field. I can't think of a practical reason why you would need to reorder the records in the table. Every method for viewing the data allows for sorting it as needed. If you wanted to change the order of the records in the table (beyond an ad hoc sort), you need to recreate the table. May I ask what your requirement is that you need to reorder the rows in the table? @2Quiker wrote: Would it best to place this shapefile in to a file geodatabase? Yes. When working with Esri products, I highly recommend using a file geodatabase over a shapefile. You can always export it back to a shapefile later if you need to share it that way. ... View more

You should read the documentation. DISTINCT, ORDER BY, and ALL are only supported when working with databases. They are not supported by other data sources (such as dBASE or INFO tables). TOP is only supported bySQL Serverdatabases. For a shapefile, you will need to read all the data into a list, and then enumerate the sorted list. Here's an untested code sample.   import arcpy subs_shp = 'C:\Temp\SUBS.shp' sub_name_values = [row[0] for row in arcpy.da.SearchCursor(subs_shp,["SUB_NAME"])] sub_name_id = {} for enum, sub_name in enumerate(sorted(sub_name_values)): sub_name_id[sub_name] = enum with arcpy.da.UpdateCursor(subs_shp,["ID","SUB_NAME"]) as u_cursor: for id, sub_name in u_cursor: id = sub_name_id[sub_name] u_cursor.updateRow([id, sub_name])       ... View more

Keep in mind you'll need to use the versioned view if you're editing versioned data with SQL. It's more complicated if you're working in a named version rather than the Default version. Edit versioned data in SQL Server using SQL—ArcMap | Documentation (arcgis.com) ... View more

Ha! That's a very unfortunate situation. Can you insert the row if you don't use the Order field? If so, do that, then update the row later with your Order value. Not efficient, but that is the first thing that comes to mind. Or if this feature class has little or no dependencies, then maybe consider renaming the field. ... View more

@bcarpenter87 wrote: Like what is seen in the gdb? Yes, that is what @DavidPike was getting at regarding the "feature class/table names rather than their aliases." You would need to update that text file, replacing the alias name you have with the actual name in the gdb. If that's not reasonable and those are infact the actual alias names, I suppose you can still do it, there'd just be a few extra steps. Either way, how I would do it is create a dictionary where the key is the gdb fc name and value is a list (or better yet a set, in case of duplicates) of field names that need to be deleted for that feature class. Then loop through your dictionary items and DeleteField one by one. It'll probably take a while with that many fields. Also keep in mind that you won't be able to delete system generated fields like ObjectID and GlobalID so prepare to handle that. ... View more

Thank you for confirming. Would it be appropriate to request this feature in ArcGIS Ideas? ... View more

@TheGamer Yes, use the geometryEngine. ... View more

I'm running into the same thing. I'm trying to export an item from an Open Data site so it doesn't need a user name. However, it errors on item.export(), yielding AttributeError: 'NoneType' object has no attribute 'username' traceback is from "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\arcgis\gis\__init__.py", line 11928, in export data_path = "content/users/%s/export" % self._gis.users.me.username It seems export requires a username? What should I do? ... View more

How is features being created? Maybe log features to the console before you call it in your function so you can inspect its contents and ensure there's a geometry property and you're accessing it correctly. ... View more