Latest Contributions by 2Quiker

‎05-16-2023

I need to permanently sort a feature class field so I can add a sequential number based on the sort. I know I can use the sort tool, but I want to sort the existing feature without having to create another feature class. I am able to do the sequential number with the following but I need the feature class "Sub_Name" sorted. anyone have an example of how to accomplish this? import arcpy from itertools import count cntr = count() fc = 'C:\Temp\SUBS.shp' with arcpy.da.UpdateCursor(fc,["ID","SUB_NAME"],sql_clause=(None,"ORDER BY SUB_NAME")) as cur: for i, j in cur: cur.updateRow([next(cntr), j])

‎05-11-2023

Sorry for the delayed response, I got caught up on on something else. I ran you code and I see, or at least I think I do. Maybe I didn't explain well what I am trying to do. Maybe I am not going about it the correct way? The "States" field of the StSele layer will always most likely be blank. I need the States field updated, like so. if StSele "State" field is empty/blank, check sjpoints (spatialjoin)--> if sjpints field "State_1" has "Ala" I need StSele layer field "States" updated with "Alaska. Again StSele "State" field will most likely be empty or blank. My first table example was wrong, my apologies. attributes after spatial join. StStates Layer StSele layer Spaital Join State State State_1 OR Org Ala Ala Cal Cal Wa Wa What I need the StStates Layer StSele layer Spaital Join State State State_1 OR Oregon Org Ala Alaska Ala Cal California Cal Wa Washington Wa

‎04-20-2023

How can you print out the field index and fields name of all the fields in a feature class? print out something like this, 0 OBJECTID 1 Shape 2 GlobalID 3 field1 4 field2 5 field3 6 field4 7 field5 etc...

‎03-15-2023

I guess I am confused. I thought that .get would get the place_dict value, e.g, Alabama, Alaska etc. There is empty/ blanks in the StSel layers "State" field,which is why I am trying to update, and which is why I lift out ' if row[0] in place_dict.keys()' I was able to do what I needed by the following, but I would like to know how to dictionary keys and and dictionary values e.g. [0] import arcpy, os,sys ## Works in file geodatabase arcpy.env.overwriteOutput = True arcpy.env.workspace = r'C:\Temp\Sates.gdb' StSele = "States" StStates = 'Statefile' sjpoints = "In_memory\sjpoints" arcpy.SpatialJoin_analysis(StSele, StStates, sjpoints) search_feats ={f[0] for f in arcpy.da.SearchCursor(sjpoints,"State_1")} print(search_feats) place_dict = {"AL": "Alabama", "Ala": "Alaska", "OR": "Oregon", "Cal": "California", "WA": "Wasington"} #print(place_dict) with arcpy.da.UpdateCursor(StSele, "State") as upd_cur: for upd_row in upd_cur: for key, value in search_feats.items(): val = place_dict.get(value) upd_row[0] = val upd_cur.updateRow(upd_row)

‎03-09-2023

Is my issue, value of None that was causing the issue in line 8? The StSele layer "States" filed does have "blanks" or/and "Nulls", that is correct as I am trying to update the StSele layers "State" field.

‎03-08-2023

I did add print statements but 'None' is being printed. search_feats ={f[0] for f in arcpy.da.SearchCursor(sjpoints,"State_1")} print(search_feats) place_dict = {"AL": "Alabama", "Ala": "Alaska", "OR": "Oregen", "Cal": "California", "WA": "Wasington"} print(place_dict) with arcpy.da.UpdateCursor(StSele, "State") as upd_cur: for upd_row in upd_cur: print(str(upd_row[0])) upd_row[0] = place_dict.get(upd_row[0], upd_row[0]) print (str(upd_row[0])) upd_cur.updateRow(upd_row) Print out set([u'OR']) {'OR': 'Oregen'} None None

‎03-07-2023

Have you added those new values as domain values? Those domains were already there and I didn't not add them as new. I can't delete the domain as i am an editor on this feature class. Part of this snippet of code is ran when one of a few features are selected. If I were to click on that field attribute, I get a list to select from. So is the issue that there is domains?

‎03-07-2023

I am using the following but I get no error but it doesn't update the "State" field. I've tested this on a different field and it works. The only thing about the "State" field is that it has a domain. Is there something different I have to do in order for this to update the "State" field? Also, this is in Pro. import arcpy, os,sys ## Works in file geodatabase arcpy.env.overwriteOutput = True arcpy.env.workspace = r'C:\Temp\Sates.gdb' StSele = "States" StStates = 'Statefile' sjpoints = "In_memory\sjpoints" arcpy.SpatialJoin_analysis(StSele, StStates, sjpoints) search_feats ={f[0] for f in arcpy.da.SearchCursor(sjpoints,"State_1")} print(search_feats) place_dict = {"AL": "Alabama", "Ala": "Alaska", "OR": "Oregen", "Cal": "California", "WA": "Wasington"} #print(place_dict) with arcpy.da.UpdateCursor(StSele, "State") as upd_cur: for upd_row in upd_cur: upd_row[0] = place_dict.get(upd_row[0], upd_row[0]) upd_cur.updateRow(upd_row)

‎01-17-2023

I was given a project with some models that are scheduled. I am trying to figure what project the actual scheduled model resides. It would be nice to right click or hover the scheduled model and see properties with location of where the schedule model is coming from. I know I can hover over the Model Builder view tab will display the model's location and that's great but that doesn't help if you don't know what project that model is coming from. Unless I am totally missing something?

‎01-05-2023

After trying your suggestion but, but after I run the code the zoomed scale changed. I am curious to see how people, if anyone is getting zoomed scale like in Arcmap with Python.

‎12-09-2022

Is there a way to set the scale of the layout view in Pro, similar to ArcMap? For example in Arcmap lyr = arcpy.mapping.ListLayers(mxd, "lyr")[0] df.extent = lyr.getSelectedExtent() df.scale = 24000 arcpy.RefreshActiveView() arcpy.RefreshTOC() In pro I can't seem to get set aprx = arcpy.mp.ArcGISProject("CURRENT") map = aprx.listMaps()[0] #lyr = map.listLayers("SUBJECT_PROPERTY")[0] lyt = aprx.listLayouts("Map")[0] mf = lyt.listElements("MAPFRAME_ELEMENT")[0] #mf.camera.setExtent(mf.getLayerExtent(lyr, False, True)) ext = map.defaultCamera.getExtent() mf.camera.scale *= 1.25 #some how set this to 1:24,000

‎11-18-2022

I need to transfer an entire layers features to another layer. I am trying to use the SearchCursor and InsertCursor to do this( I know I can use append, but I am trying to this way). Both Features have the same fields and same type of geometry, both are polygons. in_features = "FeatureClass" out_path = = "OtherFeatureClass" dsc = arcpy.Describe(in_features) fields = dsc.fields # List all field names except the OID field out_fields = [dsc.OIDFieldName, dsc.lengthFieldName, dsc.areaFieldName] fieldnames = [field.name if field.name != 'Shape' else 'SHAPE@' for field in fields if field.name not in out_fields] #out_fields = [dsc.OIDFieldName] #fieldnames = [fields.name for fields in fields if fields.name not in out_fields] # Create cursors and insert new rows # with arcpy.da.SearchCursor(in_features,fieldnames) as sCur: with arcpy.da.InsertCursor(out_path,fieldnames) as iCur: for row in sCur: iCur.insertRow(row) del sCur I get the following error. iCur.insertRow(row) RuntimeError: Number of parts in shape is incorrect for its geometry type

‎11-04-2022

Awesome, that worked. Thank you.

‎11-04-2022

I have a feature class that I need to concentrate multiple fields into one, but the issue is that some have blanks or nulls. I need Field1, Field2, Field3 concentrated into Field4. The feature class tables looks like this after I run my code below. Field1 Field2 Feild3 Field4 /Blue/ /yellow/ /Blue/none/yellow/ /Red/ /Yellow/ none/Red/Yellow /Purple/ /Pink/ /Purple/Pink/none I need this. If there is a blank or null I don't need it in Field4. Field1 Field2 Feild3 Field4 /Blue/ /yellow/ /Blue/yellow/ /Red/ /Yellow/ /Red/Yellow/ /Purple/ /Pink/ /Purple/Pink/ I have the following code. PTa = "feature class" with arcpy.da.UpdateCursor(PTa, ['Field1','Field2','Field3','Field4']) as cursor: for row in cursor: row[3] = '{} {} {}'.format(row[0],row[1],row[2]) cursor.updateRow(row)

‎09-27-2022

Sorry for the delay, I got caught up. I get the following with what you suggested. ERROR 000539: Traceback (most recent call last): File "<expression>", line 1, in <module> File "<string>", line 3, in calcYear TypeError: strptime() argument 1 must be str, not int I get the following If I do this . WARNING 002858: Certain rows set to NULL due to error while evaluating python expression: File "<string>", line 3, in calcYear calcYear(!Year!) import datetime def calcYear(strYear): return datetime.datetime.strptime("{}".format(strYear), '%Y') There is nulls in this field, how do I get past those nulls? import datetime def calcYear(strYear): if (strYear == None): return 0 else: return datetime.datetime.strptime("{}".format(strYear), '%Y')

Online Status	Offline
Date Last Visited	‎02-12-2026 12:36 PM

My Ideas

Latest Contributions by 2Quiker

Sort feature class field permanently

Re: Dictionary upatecursor with domains

Print fields indexes of featur class

Re: Dictionary upatecursor with domains

Re: Dictionary upatecursor with domains

Re: Dictionary upatecursor with domains

Re: Dictionary upatecursor with domains

Dictionary upatecursor with domains

ArcGIS Pro - Model Task Schedule location on ModelBuilder,

Re: How to set layout view scale in Pro

How to set layout view scale in Pro

Insert Cursor to insert entire layer rows

Re: Concentrate multiple fields, some have blanks.

Concentrate multiple fields, some have blanks.

Re: Field Calculator with Python parser convert text to date

Re: Reording of OBJECTID

Reording of OBJECTID

Re: Remove prefixes

Dictionary upatecursor with domains

Re: ArcGIS Pro List Elments