Latest Contributions by DanPatterson_Retired

Try getting both into a geodatabase first, then try the join ... View more

start by printing the keys line line 42.5 print(keys) Short of guessing where they might be, I don't know where the header line is stored. If it is actually stored as the first line in "table", then that would be an issue. Go with the guess first ... View more

You might have to throw in some print statements to find out where the field names are coming from, but just guessing... keys = ['A.Long', 'A.Lat', 'A.SomethingElse'] keys = [k.replace(".", "_") for k in keys] keys ['A_Long', 'A_Lat', 'A_SomethingElse']‍‍‍‍‍‍ ... View more

"AIS.LONGITUDE You shouldn't use punctuation in field names, only letters, numbers and the _ and don't begin with a number. That is why changing the csv field name worked. from an error message 010085: is an invalid field name.—Help | Documentation  Field names should only contain characters a–z, 0–9, and underscores. Do not use spaces, hyphens, parentheses, brackets, and other special characters, such as $, %, and #. Plus a whole load more recommendations. ... View more

They may be in the arcgis module Do you want the additions there? or here? ... View more

Any other corner cases?  Nulls?  Permits that will kill a simple case( B1 BBQ and Bar   B245010000   0 ... View more

If you have <null> in the data field, you have to query first for "not null" What expression did you put in exactly?  You were using the field calculator with a python parser? You replace what I had between the !...! marks with your source field name? And your destination field is a text field, right? ... View more

Cold start (both computer and operator) Named User license === 2020-03-06 18:15:53.214205 --- import arcpy overhead: 0:00:07.948694 === Total Elapsed Time: 0:00:07.949882 Spyder, kernel restart === 2020-03-06 18:17:48.751537 --- import arcpy overhead: 0:00:07.402486 === Total Elapsed Time: 0:00:07.403328 Sadly, just about everything in the stream imports arcpy at some point but if you just import what you need, you keep the namespace uncluttered. Also, import python modules and other 3rd party modules "before" you import arcpy My favorite... just run it again with no restart === 2020-03-06 18:19:29.711990 --- import arcpy overhead: 0:00:00.000067 === Total Elapsed Time: 0:00:00.000738 ... View more

s = !YourFieldName! Field calculator expression for your field BP s[s.index("B"):s.index("B")+11] # ---- using slicing‍‍ ... View more

2020 Esri Developer Summit: March 10, 2020 | Sign Up for the Livestream  The Developer Summit will be a virtual event and not a live, in-person conference due to the continuously evolving circumstances surrounding the coronavirus. ... View more

Make the folder where your zip is located a parameter, even if you provide defaults, since I can only assume that your next two inputs come from there.  that won't necessarily work since the zip may take more time that you need to use it as an input to something else.  You could alternately add another boolean parameter to your script... "continue" and check for its value after the download and unzip in your script.  You could even add a time.sleep to delay completion of the script to allow for unzip ... View more

sounds like you can make one of your inputs the precondition ... View more

is it a precondition? Preconditions—ArcGIS Pro | Documentation  ... View more