Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About JoshuaBixby
JoshuaBixby
MVP Esteemed Contributor
since
07-04-2014
Friday
5794
Posts created
1520
Kudos given
555
Solutions
4791
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(19 Idea Submissions)Latest Contributions by JoshuaBixby
|
IDEA
|
@HannesZiegler, thanks for the update. I am not sure if there is an existing separate idea or not, but it would be great to add additional Python data structures to what can be used with the ArcPy Data Access cursors. The default would have to remain the same to maintain compatibility but having a parameter/flag for returning SearchCursor records as named tuples and similar would be great.
... View more
05-20-2024
10:18 AM
|
0
|
0
|
2476
|
|
IDEA
|
What logging level are you speaking about? Are you saying that at DEBUG level it takes ArcGIS Server a minute or more before it starts logging events? I don't see that on any of my organization's deployments.
... View more
05-20-2024
10:15 AM
|
0
|
0
|
1027
|
|
POST
|
Make sure that WebView and ArcGIS Pro are both installed either Per-Machine or Per-User. If you install WebView as one and try to install ArcGIS Pro as the other, you will get an error.
... View more
05-14-2024
05:25 AM
|
1
|
0
|
6563
|
|
POST
|
It is a quote in that linked page that gets to the heart of the issue: Older ArcGIS clients can open, query, edit, and save data in newer release geodatabases, but they cannot open datasets that participate in newer functionality. You will encounter the following error messages when you try to access a newer type of dataset from an older ArcGIS client: The version of the Geodatabase client is incompatible with the dataset and cannot open it. Failed to add data, unsupported data type. First, that is not the error message one receives when accessing tables or feature classes with new functionality in file geodatabases. The actual error message is more verbose and yet less helpful in understanding what is actually happening. That quotes leads back to my question/issue, what tools are readily avaialble for an organization to determine compatibility beforehand? Simply having users try and get an error message isn't a very enterprise-y way of going about it, not to mention the time it wastes.
... View more
05-12-2024
02:57 PM
|
2
|
0
|
4320
|
|
POST
|
@RyanUthoff, if you use GDAL at all, you might be interested in reading my answer to qgis - How to tell file geodatabase' version using open source tools? - GIS SE where I give ogrinfo code for querying the RequiredGeodatabaseClientVersion for objects in a geodatabase.
... View more
05-07-2024
08:38 AM
|
1
|
0
|
4507
|
|
POST
|
If money is no object, there is always Entity Extraction Software | Unstructured Data Analysis | ArcGIS LocateXT (esri.com), but I think your situation is simple enough Excel's Text to Columns should work.
... View more
05-07-2024
07:55 AM
|
0
|
0
|
1928
|
|
POST
|
I posted the following in Pro 3.3 beta forums, but I wanted to post on Esri Community in case someone or some organization has found an elegant solution to managing compatibility and interoperability between products and versions as Esri adds more functionality to geodatabase objects. When Esri simplified the Geodatabase schema back at ArcGIS 10.0, it allowed for the addition of new functionality to geodatabase objects without having to update the Geodatabase schema itself. In and of itself, I think it was a really wise move that made the Geodatabase schema much more robust to survive the test of time; however, it hasn't been without its issue. As Esri has added new features to geodatabase objects, e.g., attribute rules in ArcGIS Pro 2.1 and new data types in ArcGIS Pro 3.2, it is great that feature classes, tables, etc... that don't rely on that new functionality can continue to work in older Esri software; BUT, Esri hasn't really provided many tools for helping organizations and users manage compatibility and interoperability across software and versions. I know in a perfect world no one would be using ArcGIS Desktop/ArcMap any longer, and every ArcGIS Pro user would already be using 3.2 (soon 3.3), but the reality for large organizations is that transitions to new software and versions takes time, as in years sometimes. I recently spent some time in the bowels of the Geodatabase schema and the schemas of its objects, and I realized there is a RequiredGeodatabaseClientVersion XML element for feature classes and tables. Not only is the element specific, it appears to be extremely accurate, which is great. However, outside of querying GDB system tables, how are organizations and users supposed to be able to access that information to easily and accurately determine whether a given geodatabase object is compatible with the software they are using or plan on using? If I am missing the obvious, mea culpa, just point me to the documentation for the tools I can use because I haven't had any luck.
... View more
05-07-2024
07:50 AM
|
3
|
7
|
4570
|
|
POST
|
I am a big fan of regular expressions, which is why I am so disappointed the Python builtin re module has such weak support for Unicode categories. Fortunately, it is quite common that people will bundle regex · PyPI with their Python deployments, including Esri. Using regex instead of re allows for people to use Unicode categories to write regular expressions that are much more portable in this global world we live in: import regex
def remove_alpha(value):
return regex.sub("[^\p{NUMBER}\p{DASH}]", "", str(value))
... View more
05-06-2024
01:33 PM
|
2
|
0
|
7345
|
|
POST
|
I believe the OP wants to sum over all columns for each row, which is the opposite of what Summary Statistics does.
... View more
05-03-2024
07:06 AM
|
0
|
2
|
3875
|
|
POST
|
If the field does not allow NULL, then returning None would create an error since Python None gets converted to SQL NULL.
... View more
05-01-2024
02:09 PM
|
1
|
0
|
2891
|
|
POST
|
With multiple processes accessing the same file geodatabase, especially to make edits, you will run into locking issues. Might be worth reading through: FAQ: How Are the Various Lock Mechanisms Implemented in ArcGIS Enterprise and the Geodatab (esri.com)
... View more
05-01-2024
10:12 AM
|
2
|
0
|
3005
|
|
POST
|
The function hasn't been updated to understand how to interpret a database connection string. The results from CreateDatabaseConnectionString are a Python string, and Describe interprets a Python string to either be a path to a suitable item or the name of an instantiated ArcGIS Pro object, which the string from CreateDatabaseConnectionString is neither. It is similar to passing the path of a CSV file vs passing the contents of a CSV file to Describe. The function would know what to do with the former, but would give the same OSError on the latter because it doesn't understand that contents of a CSV file were just passed to it.
... View more
04-29-2024
04:50 PM
|
0
|
1
|
1363
|
|
POST
|
This can be done with a Python 6.13. Conditional expressions; Python 3.x documentation, aka ternary operator, and doesn't require a code block: !DateField![3:5] if !DateTypeField! == "D" else None
... View more
04-29-2024
08:43 AM
|
1
|
1
|
3433
|
|
POST
|
A Python if statement will be far from the slowest part of this process.
... View more
04-24-2024
02:07 PM
|
0
|
0
|
5430
|
|
POST
|
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
04-23-2024
07:48 AM
|
1
|
0
|
2714
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 06-11-2026 07:04 AM | |
| 1 | a month ago | |
| 2 | 07-06-2026 12:29 PM | |
| 1 | 07-06-2026 12:00 PM | |
| 2 | 06-05-2026 10:30 AM |
Activity Feed
- Got a Kudo for Re: Regedit values to start up ArcGIS Pro as named user. Tuesday
- Kudoed Re: DA Search Cursor Ignoring sql_clause for RandyMcGregor_BMcD. 2 weeks ago
- Posted Re: Arcade Expression on ArcGIS Pro Questions. 2 weeks ago
- Posted Re: Arcade Expression on ArcGIS Pro Questions. 2 weeks ago
- Posted Re: Add IP Allowlist Control for ArcGIS Enterprise REST Directory Browsing on ArcGIS Enterprise Ideas. 2 weeks ago
- Kudoed Re: What is wrong with this code? for JoseSanchez. 3 weeks ago
- Kudoed Re: Azure Virtual Desktop and ArcGIS Pro performance for Robert_LeClair. 3 weeks ago
- Kudoed Re: How to read server statistic correctly for berniejconnors. 3 weeks ago
- Kudoed Re: How to read server statistic correctly for HenryLindemann. 3 weeks ago
- Posted Re: How to use arcpy environment settings with python multiprocessing in arcgis pro? on Python Questions. 3 weeks ago
- Kudoed Re: Roadmap to Get Started with ArcGIS Enterprise for George_Thompson. 3 weeks ago
- Kudoed Re: Roadmap to Get Started with ArcGIS Enterprise for ArchitSrivastava. 3 weeks ago
- Posted Re: Select by Location on Selected Records on ArcGIS Pro Ideas. 3 weeks ago
- Got a Kudo for Re: Search on objectid. 4 weeks ago
- Kudoed Optional Governance Mode for MarGIS. 4 weeks ago
- Got a Kudo for Re: azure, arcgis enterprise 11.5 and poor browser performance. a month ago
- Posted Re: azure, arcgis enterprise 11.5 and poor browser performance on ArcGIS Enterprise in the cloud Questions. a month ago
- Kudoed Why Still Require a Security Question After Installing the ArcGIS Security 2026 Patch 2? for RyanUthoff. 07-10-2026 10:18 AM
- Posted Re: A workaoround to merging holes in larger polygons if eliminate tool is not available in basic version on ArcGIS Pro Questions. 07-10-2026 06:10 AM
- Posted Re: How to bypass raise Error in if else statement on ArcGIS Pro Questions. 07-10-2026 05:28 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
Friday
|