Latest Contributions by DonMorrison1

‎02-10-2022

If you are sure your table and feature classes line up (after being sorted) as you show in your diagram then you should use a list to store your table data instead of a dict. This will preserve the order so you can step through one rows at a time and move the Par field over when you find an open slot. But I'd be surprised if your table and feature class really are lined up like that......

‎02-10-2022

The dict is exactly what I would expect. But, I still don't understand your objective - and will ask this again: Just curious - in your "I need the following" graphic, how do you know which values to put in the 'Par' column?

‎02-09-2022

I think your dict is being built with "PermitNum" as the key - and since that field is not unique the dictionary entry is being overwritten. Just curious - in your "I need the following" graphic, how do you know which values to put in the 'Par' column? Since 'PermitNum' is not unique you must be using some other piece of information (I assumed it was the date field but it appears that is wrong).

‎02-09-2022

You need to figure out how to uniquely identify each record and make that your dict key. From you example it looks like a combination of 'PermitNum' and 'Apps' is unique. In that case I would make my dict look like this: valueDict = {(r[0],r[2]): r for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)}

‎02-08-2022

I would start by printing out the parameters as your code receives them and also the where clause so you can inspect what they really look like - then run the commands interactively using those as inputs to see if they work. The AddMessage function can be used for writing to the custom tool message log.

‎02-03-2022

Hi. Can you please include your code snippet (formatted properly)? I assume you have tried this and it fails the same way every time?

‎01-31-2022

Good question - I had the same reaction when I first ran into this. I'm not a database expert but I believe SQL server has the ability to constrain a column to a set of values so I'm curious why this isn't enforced.

‎01-27-2022

That's it! I must have tried a hundred combinations and at some point I was using 4326 but must have had something else off at that point. Thanks Dan!

‎01-27-2022

I have a script that takes in lot, long values (in decimal degrees) and determines whether the points are contained within a polygon in another feature class. I assume I have to create a point object and get it into the same coordinate system as the polygon, but the projection comes back empty (no points). I don't fully understand all the ins and outs of projections so hopefully I'm doing something obviously incorrect here. x = -88.155675 y = 43.223869 f_cs = 'WGS 1984 Web Mercator (auxiliary sphere)' t_cs = 'NAD 1983 UTM Zone 16N' xform = 'WGS_1984_(ITRF00)_To_NAD_1983' pt = arcpy.Point(x,y) pg = arcpy.PointGeometry(pt, arcpy.SpatialReference(f_cs)) pgp = pg.projectAs(t_cs, xform) print (pgp.firstPoint)

‎01-18-2022

Thanks - this does indeed work - more elegantly than I was considering. I've been working in Python exclusively for the past 5 years so it's hard to get used to lots of loops and tricks like this again.

‎01-18-2022

I'm getting started with Arcade and can't figure out how to do something that I expect is quite simple. I have a function that returns a Dictionary object. There is a special case that the caller has to process where the returned Dictionary is empty (ie. it has no keys). How do I write that in Arcade? I would think at least I could get an Array of keys then check the length, but I don't see how to do that either var x = Dictionary () // My code here if (??????(x)) { // Dict is empty! } else { // Dict is not empty }

‎01-12-2022

You could try running Repair Geometry against the output and before you try to use it to see if that clears things up

‎01-12-2022

You can use the python '_file_' variable to get the path to your .py file. From there you can back it up to the root of your toolbox. Here is an example of how I do it: path_code_base = os.path.normpath(__file__ + '/../../../../')

‎01-11-2022

I took at look at one of the REST endpoints behind one of the layers ('Registered Two Unit Dwellings') and it did not have the EXTRACT capability enabled. I suspect this is why it is not working for your.

‎01-09-2022

I can't easily recreate the ExecutionError exception but one thing I would try is to see what you get with the exception's 'args' property, which will give you the arguments passed in by the ESRI code when the exception was created. try: my code here... except arcpy.ExecuteError as ex: print (str(ex.args)) # Maybe the specific error code is one of the args ?????? e = sys.exc_info()[1] print(e) except: handle of other errors

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by DonMorrison1

Re: Dictionary issue

Re: Dictionary issue

Re: Dictionary issue

Re: Dictionary issue

Re: Help with Select by Select by Attribute and Get Parameter as Text

Re: Update feature layer

Re: Unexpected behaviour using arcpy.da.InsertCursor on a column with an attribute domain

Re: Projecting single point in arcpy

Projecting single point in arcpy

Re: How to get list of keys from Arcade Dictionary

How to get list of keys from Arcade Dictionary

Re: Circumvent ERROR 000366: Invalid geometry type

Re: Get path to script tool inside of a toolset?

Re: Extracting Shapefile or geojson from ArcGIS web map

Re: Handle specify error in arcpy

Re: Log into ArcGIS Pro through a script

Re: ESRI python toolbox how to pass variables betw...

Re: Recommendations for speeding up python scripts...

Re: Field Parameters: Limit the fields available?

Re: Best Practices Document for setting up automat...