Latest Contributions by AllenDailey1

* Edit: I like BlakeTerhune's reply! That's better than my idea. * That's great that you're trying out cursors! When you say "each row in a field," by "row" do you mean feature/record, and by "field" do you mean an actual field/attribute?  I ask because usually with cursors, the word "row" can be a variable that might refer to attributes of one feature/record, in certain forms of syntax.  Just wanting to make sure I understand what you're getting at.   Say you are wanting to assign those values in your list to three separate features/records in your table.  One way to achieve what you mentioned is to use a counter.  There might be a better way to do it; I'm experienced but not an expert.  Just keep in mind that the first item in your list is index number 0, of course. Also keep in mind that which value gets applied to which record in your table depends on how the table is sorted when you run your code.  It does not necessarily run in order of ObjectID's.  I'm not sure what the scenario could be where you are doing what you're describing - maybe it would help if you explain that. Here's an example of using a counter:   import arcpy arcpy.env.workspace = r"path\to\geodatabase" fc = "fc_name" field = "fieldname" valuelist = ["a", "b", "e", "z"] # Values to be inserted with arcpy.da.UpdateCursor(fc, field) as cursor: count = 0 # Starts at zero because list index starts with zero for row in cursor: # For each record in the table: # This is supposed to prevent the following line from erroring # out if count exceeds the length of the list while count < len(valuelist): # Assign value from the valuelist to the record in the table row = valuelist[count] # Increment count to select next valuelist item next time count += 1 cursor.updateRow(row)   ... View more

I agree with the previous two comments! ... View more

I came up with a workaround.  Instead of using a "where clause," I just added an "if" statement later in the script to exclude records that would have been excluded by the "where clause." Basically, within a Search Cursor, I put lines to this effect:   with arcpy.da.SearchCursor(fc, fields) as cursor: for row in cursor: # Only include records where APN exists: if row[0]: # row[0] is the APN # then do stuff     This works, but it would be less clunky to just be able to use a "where clause" in MakeTableView.  I'd still be very interested to find out why it doesn't seem to work with the type of table I'm using. ... View more

Later in the script, data from the table view is manipulated - hyphens are inserted between the numbers in the field "APN".  This throws an error, because that action can't be done on Nulls.  So that means the records where APN is null were mistakenly included in the table view (meaning the Where Clause was ignored).  For troubleshooting, I also included a print statement that prints out the APN's of the records included in the table view - print("APN is " + APN).  For the records that have a value in the APN field, it prints, but for other records it errors out, saying it can't concatenate string and NoneType. For troubleshooting, I tried running MakeTableView, including a Where Clause, on a geodatabase feature class rather than a SQL Server database table (which was the original data format I was running it on), and the Where Clause worked!  So now my theory is that the problem is the data table type.  Maybe I will try adding code to my script to first convert the database table into a geodatabase table or something, before doing MakeTableView.  That would defeat the purpose of having intermediate products just be in memory, but that could be okay. ... View more

Thank you very much for your suggestion! I tried your suggestions, and sadly, the "where clause" is still being ignored.  So weird. ... View more

I also got this error, and for me, the solution was this: I had added a new feature class to an enterprise geodatabase in a dataset, and this undid the original settings like making the geodatabase versioned.  So I eventually found that I needed to re-enable versioning for this enterprise geodatabase.  This solved the problem, and I was then able to edit the feature class. ... View more

Ok, thank you!  I am using Pro 3.0.3. ... View more

How about if you use "Contains the text" instead of "is equal to," in the middle drop-down? ... View more

Hello, I'm not an expert in SQL, but I looked around a little and found something that worked for me when I tested it.  It's the last comment on this page: https://ask.sqlservercentral.com/questions/1743/how-to-select-records-with-letters-in-an-nvarchar.html It looks like this in ArcGIS Pro, select by attributes: You could add another clause for lower case, as in the last comment on that website above. I hope that helps! ... View more

This would be helpful! ... View more

Great idea! ... View more

Good idea! I have a way of doing this with Python, but of course that's a lot more complicated than simply being able to perform a selection.  You use an arcpy Update Cursor, add each row's value for that field to a list if the value is not in the list already, and if it is in the list, then you put a value in a different field to indicate that it's a duplicate value.  Like, the field could be "Duplicate" and the value you enter for that row would be "yes."  Then later you can select all the rows that have "yes."  That wouldn't select the first row that had the duplicate value, but I know it would be possible to do that, with different use of the value list or what you put into the "Duplicate" field. ... View more