Latest Contributions by JoshuaBixby

Kory, I agree with Stephen on thanking you for taking the time to put the video together.  I constantly try to tell users in my organization to submit their Ideas, that it can make a difference.  This video will help me promote that argument internally. ... View more

Can you share a stripped down sample of data that exhibits the behavior?  ... View more

SQL date functions tend to vary across data source, so there will be no single SQL that will be widely portable.  See SQL reference for query expressions used in ArcGIS—ArcGIS Pro | Documentation for more information and examples.  A purely Python cursor-based will be much more portable.  ... View more

The error message states some of the form fields are invalid, maybe some requirements changed sometime between 10.9.1 and 11.3 in terms of field values.  I suggest you start troubleshooting by revisiting the form fields and their values. ... View more

The Support analyst that logged this defect didn't realize Esri made intentional corrections to file geodatabase SQL support with Pro 3.3 to be consistent with the SQL standards, including changing how NULL is handled in certain situations.  I saw the documentation for the changes during Holistic testing, but I can't seem to find the public documentation about these changes.  I did find the originally logged defect around mishandling of NULL with file geodatabases that prompted Esri to make the updates, and it shows they made the change at Pro 3.3:  BUG-000168378 for ArcGIS Pro Regardless, I expect this defect gets closed as expected behavior.   ... View more

Ah Luke, don't fall for the Esri excuses!  ArcGIS Pro doesn't support personal geodatabases because Esri doesn't want it to, that is it.  The references to Microsoft retiring the Jet Database Engine and that the Jet Database Engine never had a 64-bit library are true, but that is only half the story, the half where Esri can blame another organization for their business decision to not support personal geodatabases in ArcGIS Pro. Shortly after the Microsoft SQL Server team announced retirement of the Jet Database Engine, the Microsoft Office team announced they would continue to support MS Access through a new Access Connectivity Engine (ACE).  All signs point to ACE being a forked version of Jet that the MS Office team continued development on themselves.  Additionally, and most importantly, the MS Office team already stated in 2005: From A discussion of what's new in Access 12 : Access 12's new data engine: This means Access 12 no longer uses the system Jet engine, but is tightly bound to its own version.  The new version is fully backwards compatible with the old, so it will read & write files from earlier versions without any problems.  So in 2005, ten years before ArcGIS Pro 1.0 was released, Microsoft had already stated they would have a 64-bit, backward compatible database engine that would work with Jet-based MDB files. The real kicker is that ArcGIS Pro accesses Excel files using the Microsoft Access Database Engine drivers. From Install the drivers to work with Microsoft Excel files—ArcGIS Pro | Documentation Microsoft Access Database Engine technology helps bridge communication and external data transfers between files that are proprietary to the Microsoft Office system and other non-Microsoft Office applications such as ArcGIS Pro. So the MS Access Database Engine drivers are necessary for ArcGIS Pro to open Excel files, the same drivers natively open old (*.mdb) and new (*.accdb) Access files, and yet somehow opening personal geodatabases in ArcGIS Pro is a bridge too far for Esri to cross.  <insert head shake> ... View more

What you are experiencing is expected behavior, not just for ArcGIS Pro but for SQL in general.  NULL is neither TRUE or FALSE, it is UNKNOWN.  In your case, the results do not return NULL records because the database engine evaluating the query has no idea whether the NULL record is one of the values you want to exclude.  Only results that are guaranteed to be TRUE are returned by the query. It is always best to handle NULL records explicitly, like you are already doing with the "IS NULL" logic. ... View more

The answer is yes, but it isn't out-of-the-box functionality.  What is an SOI | ArcGIS Enterprise SDK ... View more

@DrewFlater, I don't know if what Bud and I have in mind are exactly the same, but they are similar enough to merge for discussion on the requests. Looking at the original example, it appears the OP is asking for a pairwise combination, one might call it "zipping".  I am more interested in a cross product that results in a straight combination if multiple fields are selected.  For example, OBJECTID PRJTID MUNICIPALI ZIPCODE 2 2 A 1 3 2 A 2 4 2 B 1 5 2 B 2   The main use case I have run across is a form of re-normalizing tables from data warehouses.  Re-normalizing redundant attribution can be as straightforward as removing columns, but when information has been concatenated for reporting purposes the attribution needs to be exploded. I realize there is readily available code for doing this task, and I am a big advocate for scripting over GUI-driven clickops, but I also work in and support an organization with tens of thousands of GIS users and a vast majority of those users solely rely on the GUI and geoprocessing tools. ... View more

Bud, I thought I saw a similar idea in the past but couldn't find it while searching, hence me posting it.  For now, I will leave my idea up too and Esri can decide to merge them or not. ... View more

Now that Summary Statistics (Analysis)—ArcGIS Pro | Documentation supports concatenation, we need a tool to do the inverse.    Either Multipart To Singlepart (Data Management)—ArcGIS Pro | Documentation could be enhanced to support attributes beyond multi-part geometries. A new 'Multi-attribute to Single-attribute (Data Management)' tool could be created. The splitting tools in the Extract toolset do not address this need for several reasons.   ... View more

I am pretty sure you are out of luck, and it isn't just an Arcade limitation.  Calculate Field has to return something for each record, there is no way to tell Calculate Field to stop processing the current record and move onto the next. ... View more

Cross posted  at query - ArcGIS REST API returns no results when resultRecordCount parameter is added - GIS SE. As a comment to that question asks, are you sure the service supports pagination, which is a requirement for this option. ... View more

I agree this is a big shortcoming of Arcade.  I am hard pressed to think of another scripting language that doesn't support, at least partially, regular expressions.  ... View more