Latest Contributions by WillHouston

Does the InsertCursor take a lock on the table? If so and the script fails in the for loop, is that lock returned? ... View more

You're looking for those strings ("Batteries;", "Batteries;Disposable Batters;...", etc.) in the category, not the keyword (if(Find(batteryType,cat) >=0) ... View more

I'm still not sure it makes sense to me. The USER_Categ field, to me, looks like what you want to use as the field for your "Unique Values" primary symbology. In your second graphic above where you have the four symbols (Appliances, Asbestos, Airplane, Building Material), you are pointing them one-to-one to values in the USER_Categ field. In which case, I would say to use USER_Categ as the field for your unique symbology, then manually change the label associated with each value to the simplified label ("Appliances" instead of "Appliance Recycling"). If you have too many values to do that manually, Arcade would be the quicker way. I will respond to your post there. ... View more

This is the community for ArcGIS online. The community for ArcGIS Pro might be able to help faster. When you hover over the triangle with the exclamation point beside the symbol for USA Counties, what does it say? Your layers also might be ordered such that the other layers are covering up the ones you're creating. Try dragging the layer you're having trouble with to the top in the contents pane. ... View more

Are you doing that manually in the USER_Categ field, or is that something else? That field looks like it has many fewer unique values. ... View more

Trying testing your regex: "3, 5, 3.9, 12.5 FAR Values" "3, 5, 3.9, 2.5 FAR Values."   This is a good case for using regex and a much better solution than the one I provided, but using regex does not mean you shouldn't check for exceptions in type conversions: import arcpy import re # find largest number in a string arcpy.env.workspace = r"D:\APRX_MXDS\USA_App_Project\usa_parcels_with_FARField.gdb" arcpy.env.overwriteOutput = True fc = "temp" with arcpy.da.UpdateCursor(fc, ["FAR_INTEGER", "MAX_VALUE"]) as cursor: # Loop through each feature for row in cursor: if row[0] is None: continue nbrs = [] for i in re.findall('(\d+\.?\d*|\d*\.\d+)', row[0]): try: nbrs.append(float(i)) except: pass if nbrs: row[1] = max(nbrs) cursor.updateRow(row)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ # if FAR_INTEGER contained no numbers, no need to update‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ That's a slightly improved regex, but I still wouldn't trust it to pass up every erroneous input. You could make an argument to wrap the list assignment in the try statement. But if the regex matches one erroneous input mixed in with some valid inputs, you would get no max value. ... View more

First, there are a number of problems your code: I usually pass the full path to the feature class of a file gdb to UpdateCursor, instead of setting the workspace and passing only the table name. Your method might work, though. I believe the second parameter of UpdateCursor requires an array (["FAR_INTEGER"] instead of just "FAR_INTEGER"). split() only splits strings on whitespace (spaces, tabs, newlines), so you should remove commas row[0].replace(',', '').split(). integer conversion will probably panic if it sees a number with a decimal (e.g. 3.9), so use float conversion instead (float(w) return statements end execution and return that value to the caller. If you want to store the max value, you could put it in a field on that feature class. Then your UpdateCursor call could be UpdateCursor(fc, ["FAR_INTEGER", "max_value"]) and you could use updateRow(row) to store that value. Python indentation separates blocks of code, so both those try statements would be called for every word in every string in every row of the table (if that second try statement didn't guarantee a return which ends execution). Resulting in something like: import arcpy # find largest number in a string arcpy.env.workspace = r"D:\APRX_MXDS\USA_App_Project\usa_parcels_with_FARField.gdb" arcpy.env.overwriteOutput = True fc = "temp" with arcpy.da.UpdateCursor(fc, ["FAR_INTEGER", "max_far"]) as cursor:     for row in cursor:         ls = []         for w in row[0].replace(',', '').split():             try:                 ls.append(float(w))             except:                 pass         try:             row[1] = max(ls) cursor.updateRow(row)         except:             pass I didn't test that, so I might have introduced more bugs. Now, executing that script is a different topic. What program are you using? I'm most familiar with ArcGIS Pro, in which you should be able to create a new Jupyter notebook (Insert Tab -> New Notebook) and copy-paste it in. ... View more

I originally thought this was a floating point error because when I went to edit the vertex data for the route, the 2282.2725 was actually 2282.27250000001. I have done a number of things to these tables, and now I cannot replicate the issue. One thing I did was change the Rounding Decimal places to 11. I don't really know if that fixed anything, but around the time I made that change the zero length records stopped showing up. However, when I change the rounding back to 6 (where it started), it started missing records that it should have included. Then I restarted ArcGIS Pro and it worked correctly (no zero length lines). I have no idea what is going on any more. Since this post, I have also seen this tool return zero length line events because of ignoring spatial gaps. I was able to recreate my routes with spatial gaps in the m-values, and everything worked properly. ... View more

I was working on a fairly new dataset for my organization, so I was able to rapidly change my data model to fit AGOL and make collection easier. The recommendation I got from my ESRI contacts was pretty simply to store what you can in AGOL and have most end users not use Pro. I changed from using the subtypes feature to a domain in AGOL, and I switched from using Collector to Survey123. Survey123 allowed me to mimic subtype domains with a choice_filter. I don't have enough experience with ArcMap or your workflows to be of much help to you. Are there any workflows you can transition to being entirely in an AGOL map? ... View more

Here's my experience with subtypes and domains in AGOL/Pro as of 2020-04-20: Subtypes and domains are added to AGOL when publishing from Pro. Neither subtypes nor domains will be visible when viewing that posted layer in Pro. (If you go to the domain tab, it will say something like, "Domains are read-only".) Neither subtypes nor Pro-style domains are easily editable in AGOL. Subtypes are very difficult to edit once published to AGOL because you have to use rest/admin/services and some of the data seems to be in multiple places. You can't edit them from Pro. The domains that are added to AGOL from Pro are different from the "Create List" domain functionality within AGOL. Adding to AGOL from Pro does not automatically create the AGOL-style domain. That means you have to edit the Pro-style domains through rest/admin/services. You can't edit them from Pro. Basic changes to the Pro-sourced domains in AGOL are possible through rest/admin/services. If a domain was used for multiple fields, those changes become more difficult. Pro-Based domains in AGOL are not done intelligently with the domains being a source that the fields reference. Instead, the domains and their values are copied to every field with the same name. So if you change the values for one domain and not the other, AGOL sees the same domain with different values and doesn't work. I haven't tested how AGOL generates lists for a field based on current values (does it read the Pro-style domain or just records the have values?). In short, using subtypes and AGOL doesn't work well. Using domains and AGOL isn't great, but it is manageable. Edit: Additionally, domains and subtypes for AGOL hosted feature layers that you view in Pro aren't visible when editing or viewing records. ... View more

The domains generated by ArcGIS Online have hyphens in them. This Survey123 Quick Reference doesn't exactly say, "Don't use hyphens in choice list_names", but it comes close. I did a very small test where I changed one of my list_choices from "sign_dimensions" to "sign-dimensions", and the choice filter stopped working. I'll go ahead and report this as a bug. ... View more

Sorry, those weren't actually my field names and I didn't realize they were keywords. I just generalized them for the example. I used fields sign_group (type) and sign_type (subtype). I'll edit the original post. ... View more

I posted another question to the community to see if anyone else has seen the issue. I did not reach out to support directly. Admittedly I never watched your full video, but I think what I had been doing was similar (copy the foreign key and primary keys to another GUID and then match them back up after the append). I wasn't ever able to get the GUID type to work, but I was able to copy the primary and foreign keys to string and match them up with a basic script I had written before I knew about your tutorial: import arcpy import os class CustomCancelException(Exception):    pass def my_function(post_layer, sign_layer): edit_started = False try:    with arcpy.da.SearchCursor(post_layer, ["GLOBALID", "preserve_guid"]) as scur:       key_map = {}       for srow in scur:          key_map[srow[1]] = srow[0] with arcpy.da.UpdateCursor(sign_layer, ["parentfk", "preserve_guid"]) as ucur:    for urow in ucur:          new_fk = key_map.get(urow[1], None)          urow[0] = new_fk          ucur.updateRow(urow) except CustomCancelException as err: arcpy.AddError(err) finally: if __name__ == '__main__': post_layer = arcpy.GetParameter(0) sign_layer = arcpy.GetParameter(1) my_function(post_layer, sign_layer) The quotations aren't preserving indentation, but that's the general idea. I never tried copying from a string into a GUID because I thought that wouldn't work and I already had this script. ... View more