Latest Contributions by JoshuaBixby

A Python if statement will be far from the slowest part of this process. ... View more

Even with ArcGIS Desktop/ArcMap, if you define a function with only a pass statement and nothing else, it will return None and then Calculate Field turns that None into a SQL NULL.  Although Calculate Field does iterate over the records, your pass statement is in a function that is being called on each row and not within the loop itself.  A Python function has to return something, either a value or an error.  If you don't return something, then Python None is returned. ... View more

Have you tried using an UpdateCursor—ArcGIS Pro | Documentation?  If so, any error messages? ... View more

What ArcGIS Desktop app, specifically, crashes?  I assume ArcMap is crashing, what about ArcCatalog, what about ArcScene? ... View more

Where are you expecting a Publish "button" to be?  What is described in the documentation, and how it works, is through a context-menu option and not a button somewhere.  However, we may be talking about the same thing but using different terms. ... View more

Is the FGDB feature class hosted on a local drive on your machine or a network share? ... View more

The issue likely has to do with the data store or workspace and not your code.  Are you updating a feature service, enterprise geodatabase feature class, shape file, etc...?   ... View more

If the max number goes to 115, do you want the result to be "001" so that all the values are 3 characters.  ... View more

The answer lies in the fact that you are relying on dot density symbology for some polygons that have perimeters that span water and land.  If you want to ensure all the dots are in land, you will have to intersect the census layer with some kind of water/land layer to get census area definitions that only include land. ... View more

If new data is being created in the enterprise geodatabase and not seen on the published service, I would check whether the new data and published data are using the same geodatabase version (not software version, but geodatabase version as in versioned data).  It might be necessary to reconcile and post the data to a parent version before it shows up in the service. ... View more

Thanks.  Yeah, it helps to know not to expect anything else in the near to mid term. ... View more

@DerekLaw, any plans to support anything different besides Postgres? ... View more

Census data is commonly summarized by area, where are the points coming from?  If I download the ACS_2021_5YR_COUSUB_36_NEW_YORK geodatabase it doesn't have any points in it. ... View more