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
yesterday
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
|
POST
|
It is "Esri JSON," no 'geo' prefix, and "GeoJSON," no 'Esri' or 'general' qualifier. I took the GeoJSON shared in the question and tested it at GeoJSON Viewer & Validator, it fails with: Line 1: Polygons and MultiPolygons should follow the right-hand rule
... View more
02-27-2025
05:44 AM
|
2
|
0
|
1639
|
|
POST
|
In general, don't upload a screenshot when you can write out the SQL and error code in text. No matter how busy you are, the people volunteering to read questions and provide replies are just as busy or more. There are at least a couple issues with the syntax being used. Firstly, the Select by Attributes tool expects a SQL WHERE clause, so your current syntax results in a complete SQL statement of: SELECT * FROM SDE.PassengerStartAndStops WHERE SELECT MAX(sys_timestamp) FROM SDE.PassengerStartAndStops The statement is invalid, as Pro is already informing you. The second issue I can't say exactly because I am confused what you are trying to do. sys_timestamp is a DBMS function and not a field in the table. Maybe take a step back and share what exactly you are trying to do, not in code but in words.
... View more
02-26-2025
06:18 AM
|
0
|
1
|
1489
|
|
POST
|
Walk - ArcGIS Pro | Documentation is more functional, idiomatic, and performant then relying on the older ArcPy List functions.
... View more
02-26-2025
06:06 AM
|
1
|
2
|
4906
|
|
POST
|
The best way to know if it works is to test it, that is why you should have a test or staging environment, or maybe even just a development environment. Without testing, even the best plan that should work can go wrong and have unexpected consequences. Overall, the steps look fine, but there will be a brief outage between step 2 and 4 since there will be no registered Web Adaptors but users may still be attempting to connect using the Web Adaptor address.
... View more
02-21-2025
12:22 PM
|
1
|
0
|
2418
|
|
POST
|
Short answer, you can't download the geometry information because the service has been published in a way to prevent it. All of the non-spatial attributes are available, but they have decided to prevent access to the geometry information. There is nothing you can do on the end-user side. You can try contacting the organization and inquire how to get a copy of the data that includes geometry. The reason the one link shows the geometries on a map is that it is a different REST function. The link that works is returning images of data and not data itself.
... View more
02-05-2025
02:42 PM
|
1
|
0
|
1263
|
|
POST
|
If unregistering and reregistering improves performance for a while, I would look into what the state tree looks like over time. Diagnose Version Tables only looks for specific kinds of issues, and the tool doesn't look at overall shape and length of state tree. Unfortunately I don't think Esri has gotten around to including a state tree diagram tool in Pro yet, but one can still query the system tables to get the state tree information.
... View more
02-05-2025
06:11 AM
|
0
|
0
|
1981
|
|
POST
|
What you have is JSON data stored in a text field, so you should process it like JSON. Expression: sum_json_key(!FieldName!, "antal") Code block: import json
def sum_json_key(json_text, key):
j = json.loads(json_text)
return sum(i[key] for i in j)
... View more
01-24-2025
07:39 AM
|
2
|
1
|
3473
|
|
POST
|
For a geodatabase table or feature class, "aliasName" is an inherited from Geodatabase Table properties - ArcGIS Pro | Documentation
... View more
01-23-2025
01:56 PM
|
1
|
0
|
3561
|
|
IDEA
|
Now that CPython has a definitive roadmap for removing the global interpreter lock (GIL) and supporting true multi-threading, i.e., free-threading, (https://peps.python.org/pep-0703/); Esri should start to lay out its roadmap to support free-threading with ArcPy. Supporting free-threading is no small undertaking for a package like ArcPy, but it all starts with a plan and taking steps to implement the plan. Many scientific computing Python packages are already releasing versions that support free-threading (https://py-free-threading.github.io/tracking/). Supporting multi-/free-threading is crucial for ArPy. Although ArcPy can be run using Python's multiprocessing module, there are significant performance reductions and some functional limitations that come with running code in other processes versus other threads within the same process. Although I have forced ArcPy into multi-threading, it is clear that some functions, methods, and geoprocessing tools work fine while others get corrupted very easily.
... View more
01-23-2025
10:46 AM
|
2
|
1
|
1303
|
|
POST
|
The ArcGIS Relational Data Store is based on PostgreSQL, which doesn't support DATEADD. Try using native PostgreSQL Date/Time functions: https://www.postgresql.org/docs/current/functions-datetime.html
... View more
01-23-2025
06:32 AM
|
1
|
0
|
1630
|
|
IDEA
|
@SSWoodward, I am very intrigued. Although the idea title states 'file geodatabase,' would this functionality be broader than that?
... View more
01-22-2025
02:00 PM
|
0
|
0
|
2912
|
|
POST
|
Manipulating dates and times are very data source specific, so it would be helpful if you shared the back-end data store the data resides in.
... View more
01-22-2025
07:29 AM
|
0
|
0
|
1694
|
|
POST
|
I have never seen any documentation stating or showing it is supported, so I am going with, "it isn't supported." Empirically, your testing also indicates it isn't possible.
... View more
01-21-2025
08:15 AM
|
1
|
0
|
5645
|
|
POST
|
As covered in Apache Tomcat vulnerability CVE-2024-50379 - Esri Community , the vulnerability is not applicable to ArcGIS Server I do not expect Esri to release a patch.
... View more
01-15-2025
08:18 AM
|
0
|
0
|
1823
|
|
POST
|
@SimonCrutchley , as an FYI, you can mark multiple responses as a solution if multiple responses work for you.
... View more
01-10-2025
10:23 AM
|
0
|
0
|
629
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 06-11-2026 07:04 AM | |
| 1 | 4 weeks 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. yesterday
- Kudoed Re: DA Search Cursor Ignoring sql_clause for RandyMcGregor_BMcD. Wednesday
- 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. 2 weeks ago
- Kudoed Re: Azure Virtual Desktop and ArcGIS Pro performance for Robert_LeClair. 2 weeks ago
- Kudoed Re: How to read server statistic correctly for berniejconnors. 2 weeks ago
- Kudoed Re: How to read server statistic correctly for HenryLindemann. 2 weeks ago
- Posted Re: How to use arcpy environment settings with python multiprocessing in arcgis pro? on Python Questions. 2 weeks ago
- Kudoed Re: Roadmap to Get Started with ArcGIS Enterprise for George_Thompson. 2 weeks ago
- Kudoed Re: Roadmap to Get Started with ArcGIS Enterprise for ArchitSrivastava. 2 weeks ago
- Posted Re: Select by Location on Selected Records on ArcGIS Pro Ideas. 2 weeks ago
- Got a Kudo for Re: Search on objectid. 3 weeks ago
- Kudoed Optional Governance Mode for MarGIS. 3 weeks ago
- Got a Kudo for Re: azure, arcgis enterprise 11.5 and poor browser performance. 4 weeks ago
- Posted Re: azure, arcgis enterprise 11.5 and poor browser performance on ArcGIS Enterprise in the cloud Questions. 4 weeks 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 |
yesterday
|