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
Online
5789
Posts created
1512
Kudos given
555
Solutions
4789
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
|
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
|
1895
|
|
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
|
4491
|
|
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
|
7263
|
|
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
|
3754
|
|
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
|
2832
|
|
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
|
2916
|
|
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
|
1322
|
|
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
|
3376
|
|
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
|
5300
|
|
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
|
2675
|
|
POST
|
You are passing expression type, which is the fourth parameter, as the second parameter, which is field. Also, when you pass the second parameter, you don't put it in square brackets, which creates a Python list and will cause another error. Try: arcpy.management.CalculateField(out_fc, "SEGMENT", r"!STRUCTUREBEG! + ' to ' + !STRUCTUREEND!", "PYTHON3")
... View more
04-19-2024
04:43 PM
|
0
|
0
|
1826
|
|
POST
|
Providing representative code would be helpful because it is likely how you are calling the tool that is causing the issue. From Select Layer By Attribute (Data Management)—ArcGIS Pro | Documentation If the input is a feature class or dataset path, this tool will create and return a new layer with the result of the tool applied. Are you passing a feature class or dataset path to the tool or the name of a layer or view?
... View more
04-15-2024
07:07 AM
|
0
|
1
|
1790
|
|
POST
|
Have you tried using an UpdateCursor—ArcGIS Pro | Documentation? If so, any error messages?
... View more
04-10-2024
06:53 AM
|
0
|
1
|
1545
|
|
POST
|
What ArcGIS Desktop app, specifically, crashes? I assume ArcMap is crashing, what about ArcCatalog, what about ArcScene?
... View more
04-08-2024
07:25 AM
|
0
|
2
|
2276
|
|
POST
|
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
04-03-2024
03:16 PM
|
0
|
0
|
5376
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | yesterday | |
| 2 | 2 weeks ago | |
| 1 | 2 weeks ago | |
| 2 | 06-05-2026 10:30 AM | |
| 1 | 05-29-2026 08:22 AM |
Activity Feed
- Got a Kudo for Re: azure, arcgis enterprise 11.5 and poor browser performance. yesterday
- Posted Re: azure, arcgis enterprise 11.5 and poor browser performance on ArcGIS Enterprise in the cloud Questions. yesterday
- Kudoed Why Still Require a Security Question After Installing the ArcGIS Security 2026 Patch 2? for RyanUthoff. a week ago
- Posted Re: A workaoround to merging holes in larger polygons if eliminate tool is not available in basic version on ArcGIS Pro Questions. a week ago
- Posted Re: How to bypass raise Error in if else statement on ArcGIS Pro Questions. a week ago
- Got a Kudo for Re: New ParameterArray container. 2 weeks ago
- Got a Kudo for Re: New ParameterArray container. 2 weeks ago
- Posted Re: New ParameterArray container on Python Questions. 2 weeks ago
- Got a Kudo for Re: New ParameterArray container. 2 weeks ago
- Posted Re: New ParameterArray container on Python Questions. 2 weeks ago
- Kudoed Re: UNC Path Resolution in ArcGIS Pro 3.5.6+ for WilliamHarperAppDev. 2 weeks ago
- Got a Kudo for Re: Register ArcGIS Server without PSA. 2 weeks ago
- Got a Kudo for Re: Register ArcGIS Server without PSA. 2 weeks ago
- Posted Re: Support for Multiple Simultaneous SAML and/or OIDC Identity Providers in ArcGIS Enterprise on ArcGIS Enterprise Ideas. 2 weeks ago
- Kudoed Support for Multiple Simultaneous SAML and/or OIDC Identity Providers in ArcGIS Enterprise for ValeskaKolligs. 2 weeks ago
- Kudoed FeatureLayerCollection.replicas.create always returns the correct tables but 0 records in the tables for Trippetoe. 3 weeks ago
- Kudoed Re: GeoPackage (GPKG) versus File Geodatabase (GDB) for Joshua-Young. 3 weeks ago
- Kudoed Re: GeoPackage (GPKG) versus File Geodatabase (GDB) for DuncanHornby. 3 weeks ago
- Kudoed ArcGIS for Personal use new licensing from 2026 for IñakiLázaro_Cantera. 3 weeks ago
- Posted Re: Apply today: ArcGIS Enterprise 12.2 Beta Program on ArcGIS Enterprise Blog. 3 weeks ago
Contact Me
| Online Status |
Online
|
| Date Last Visited |
yesterday
|