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
Wednesday
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
|
Are you asking how to taking a number like 0.123 (12.3%) and make it 12.3? If so, just multiply the current value by 100; otherwise, I am not sure what you are asking. The numeric field will never store the percent sign, that is simply a formatting option in a table view. If you want a percent sign with the actual data, you will have to use a string field.
... View more
12-18-2023
07:06 AM
|
1
|
2
|
2067
|
|
POST
|
It helps to provide information about data types and an example or two.
... View more
12-12-2023
05:57 AM
|
0
|
1
|
2824
|
|
POST
|
The vast majority of the patches to .NET 6.0.x are security patches, so it is strongly recommended to always run the latest version. In your case, I suspect it wasn't .NET 6.0.5 specifically that resolved the issue but more uninstalling and re-installing .NET 6.0.x that fixed any issues where .NET 8.0.x and previous .NET 6.0.x settings may have been conflicting.
... View more
12-02-2023
12:31 PM
|
0
|
2
|
5592
|
|
POST
|
Although a regular expression answer has been put forward, I believe there is a more straightforward regular expression than what has been already proposed. Also, all that is needed in terms of cursors is a single pass through the data set with an update cursor. First, the regular expression. You are trying to match pairs of species-values that have been concatenated into a single string, so there are 3 things to differentiate: 1) a species-value pair, 2) the species within that pair, and 3) the numeric value for the species in that pair. The following regular expression captures that logic: >>> import re
>>>
>>> reg_exp = "(?:([A-Za-z]+)\s*([0-9]+))+?"
>>>
>>> SPCOMP_samples = [
... "Pj 60Sb 40",
... "Pj 60Sb 40",
... "Sb 80Pj 10La 10",
... "Pj 60Sb 40",
... "Pj 80Sb 10Pt 10",
... "Pj 80Sb 10Pt 10"
... ]
>>>
>>> for sample in SPCOMP_samples:
... re.findall(reg_exp, sample)
...
[('Pj', '60'), ('Sb', '40')]
[('Pj', '60'), ('Sb', '40')]
[('Sb', '80'), ('Pj', '10'), ('La', '10')]
[('Pj', '60'), ('Sb', '40')]
[('Pj', '80'), ('Sb', '10'), ('Pt', '10')]
[('Pj', '80'), ('Sb', '10'), ('Pt', '10')]
>>> The regular expression uses a non-capturing outer group to find the species-value pairs, and then uses two internal capturing groups to differentiate the species from the numeric value. Using the expression with re.findall returns a list of tuples containing a species and a numeric value. Since each tuple contains the species and the value, you can use the species to look up the index of the species field in a cursor and update that field with the value. # Note: Code below hasn't been tested
reg_exp = "(?:([A-Za-z]+)\s*([0-9]+))+?"
fc = # path to feature class or shape file
with arcpy.da.UpdateCursor(fc, "*") as cur:
spcomp_idx = cur.fields.index("SPCOMP")
for row in cur:
for species, value in re.findall(reg_exp, row[spcomp_idx]):
species_idx = cur.fields.index(species.upper())
row[species_idx] = value
cur.updateRow(row)
... View more
12-02-2023
12:17 PM
|
2
|
3
|
8141
|
|
POST
|
Although ArcGIS Pro itself doesn't support a standardized regular expression implementation across all data sources, nearly all data sources do support a flavor of it. Without knowing the workspace or data source type, e.g., file geodatabase, mobile geodatabase, etc...., I can't offer any more specifics.
... View more
12-01-2023
07:17 AM
|
1
|
0
|
3556
|
|
POST
|
The views that can't be deleted from ArcGIS Pro can be deleted from any SQLite tool just fine. They can't be deleted in ArcGIS Pro because they are created in SQLite but not populated in various GDB system tables, so the delete tools can't really figure out what to do. The solution to the delete issue is to have them never created in SQLite in the first place if the SQL is invalid.
... View more
04-17-2023
08:08 AM
|
1
|
1
|
2740
|
|
POST
|
Too funny, I just logged a defect on this issue a couple weeks ago: BUG-000157051 for ArcGIS Pro (esri.com)
... View more
04-17-2023
06:57 AM
|
1
|
3
|
2747
|
|
POST
|
The answer lies mostly in the intro paragraph for each tool. Underlining is my emphasis. From Make Table View (Data Management)—ArcGIS Pro | Documentation Creates a table view from an input table or feature class.... From Make Query Table (Data Management)—ArcGIS Pro | Documentation Applies an SQL query to a database, and the results are represented in either a layer or table view. The query can be used to join several tables or return a subset of fields or rows from the original data in the database. Make Table View supports a broader range of data sources and is much more efficient because it is a one-to-one tool, i.e., one table per table view. Make Query Table allows for joining tables, but that expanded functionality comes at the cost of fewer supported data sources and less performance for simple cases.
... View more
03-13-2023
08:16 AM
|
1
|
0
|
5235
|
|
POST
|
According to the documentation you link to, ST_IsRing is a subset of ST_IsClosed that is also ST_IsSimple. So, a ring must be closed but not all closed geometries have to be rings.
... View more
03-01-2023
04:18 PM
|
0
|
0
|
2120
|
|
POST
|
George, I have seen several examples where ArcGIS 10.8.2 contains ArcGIS 10.9.1 code, and it appears that includes tools that create enterprise geodatabases as well.
... View more
02-28-2023
05:31 AM
|
1
|
1
|
1988
|
|
POST
|
I ended up creating two lists, one for the actual multiprocessing pool and a second with metadata I created and populated about the jobs I put into the pool. One of the items I tracked in the metadata pool was the start time of when the job was submitted to the pool. As I looped over the pool to retrieve results, I would check the jobs that were still running and see when their start time was, and I would calculate elapsed time. If a running job passed a designated elapsed time, I would issue a terminate command. I would also use the metadata pool list to check whether an existing process had crashed by keeping a list of PIDs. If a process had crashed, I would print a warning.
... View more
02-25-2023
10:49 AM
|
0
|
0
|
2102
|
|
POST
|
Christian, thanks for the updates. Here's hoping "later this year" is more like summer than 12/31/2022. 🙂
... View more
02-23-2023
08:36 AM
|
0
|
1
|
4571
|
|
POST
|
You can't pass an Arcade operator, &&, in a SQL statement because whatever is processing the SQL has no clue how to handle &&.
... View more
02-21-2023
08:55 AM
|
0
|
0
|
3752
|
|
POST
|
Beyond Python 2 to Python 3, ArcGIS Pro also involved going from 32-bit to 64-bit. Are you sure you have the proper database drivers installed since you are trying to access an enterprise geodatabase?
... View more
02-18-2023
07:22 AM
|
0
|
0
|
558
|
|
IDEA
|
QGIS handles the same situation by having actual NULL italicized and light-grey. QGIS_null.PNG
... View more
02-15-2023
09:45 AM
|
0
|
0
|
1631
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 06-11-2026 07:04 AM | |
| 1 | 07-17-2026 06:54 AM | |
| 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. 2 weeks ago
- Kudoed Re: DA Search Cursor Ignoring sql_clause for RandyMcGregor_BMcD. 2 weeks ago
- Posted Re: Arcade Expression on ArcGIS Pro Questions. 3 weeks ago
- Posted Re: Arcade Expression on ArcGIS Pro Questions. 3 weeks ago
- Posted Re: Add IP Allowlist Control for ArcGIS Enterprise REST Directory Browsing on ArcGIS Enterprise Ideas. 3 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. 4 weeks ago
- Kudoed Re: Roadmap to Get Started with ArcGIS Enterprise for ArchitSrivastava. 4 weeks ago
- Posted Re: Select by Location on Selected Records on ArcGIS Pro Ideas. 4 weeks ago
- Got a Kudo for Re: Search on objectid. 07-21-2026 02:23 PM
- Kudoed Optional Governance Mode for MarGIS. 07-21-2026 06:44 AM
- Got a Kudo for Re: azure, arcgis enterprise 11.5 and poor browser performance. 07-17-2026 11:55 AM
- Posted Re: azure, arcgis enterprise 11.5 and poor browser performance on ArcGIS Enterprise in the cloud Questions. 07-17-2026 06:54 AM
- 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 |
Wednesday
|