Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About Bud
Bud
Legendary Contributor
since
06-06-2016
3852
Posts created
1818
Kudos given
58
Solutions
2457
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(889 Idea Submissions)Latest Contributions by Bud
|
IDEA
|
ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB: The Fields View can modify the following properties of an empty FC: Data Type Allow NULLs Domain Default value But the Alter Field geoprocessing tool can't change those properties. It would be more intuitive if the Alter Fields tool had equivalent functionality to the Fields View.
... View more
08-16-2024
08:20 AM
|
1
|
6
|
1659
|
|
IDEA
|
ArcCatalog 10.7.1; Oracle 18c 10.7.1 EGDB: To my surprise, if the database view is registered with the geodatabase, then it's possible to set a domain using ArcCatalog > Properties or using the Assign Domain To Field tool in ArcGIS Pro 2.9.5. The domain is honored in the attribute table in both ArcMap 10.7.1 and ArcGIS Pro 2.9.5. Likewise, if the database view is registered with the geodatabase, then it's possible to set a field alias using ArcCatalog > Properties or using the Alter Field tool in ArcGIS Pro 2.9.5. More info in Updating registered view field alias and domains in Data Design Fields.
... View more
08-16-2024
08:05 AM
|
0
|
0
|
3284
|
|
IDEA
|
Oracle 18c 10.7.1 EGDB Like you said, with a registered database view, I was able to apply a domain and an alias to a field using ArcCatalog 10.7.1 > Properties: The domain and alias work as expected in the attribute table in both ArcMap 10.7.1 and ArcGIS Pro 2.9.5. I submitted a couple of Esri Support cases: Esri Case #03701138 Database view (registered with the geodatabase) — Can change field alias via Alter Field, but not via Fields View [ArcGIS Pro 2.9.5] New: BUG-000170076 - Unable to alter the Alias of a field for a registered View via the Fields menu in ArcGIS Pro Esri Case #03701213 Database view (registered with the geodatabase) — Can set field domain using ArcCatalog, but not ArcGIS Pro [ArcGIS Pro 2.9.5] Existing/closed; working as designed: BUG-000135931 - When changing the domain assignment on a database view, the table is shown as read-only and does not allow the change. Explanation - Views are read-only. Assigning domains to fields is supported using the Assign Domain To Field geoprocessing tool. Displaying a mixed state in the fields view of editable and non-editable properties is not in the current product plan.
... View more
08-16-2024
07:25 AM
|
0
|
0
|
2667
|
|
IDEA
|
Idea: File Geodatabase views should support domains
... View more
08-16-2024
07:11 AM
|
0
|
0
|
2673
|
|
POST
|
Related: Edit Log to capture Insert, Update, and Deletes via ArcGIS Arcade attribute rule https://community.esri.com/t5/arcgis-pro-questions/edit-log-to-capture-insert-update-and-deletes-via/m-p/1513089/highlight/true#M86261
... View more
08-15-2024
09:51 PM
|
0
|
0
|
1836
|
|
POST
|
You could look up Archiving. But I don't think many people use archiving; I suspect it has some pretty big tradeoffs and is buggy. Edit Log to capture Insert, Update, and Deletes via ArcGIS Arcade attribute rule Track Changes in Point Feature Class with Records
... View more
08-14-2024
04:42 AM
|
0
|
0
|
1363
|
|
IDEA
|
ArcGIS Pr 2.9.5 It's possible to rename a field in a feature class in a geodatabase. However, it doesn't look like it's possible to rename a field in shapefile. But I don't normally use shapefiles, so I could be missing something.
... View more
08-13-2024
11:31 AM
|
0
|
0
|
826
|
|
POST
|
Glad it helped. For anyone interested, here's an Oracle solution: select objectid, max(col_name) keep (dense_rank first order by col_val desc) max_col_name
from employment_by_industry
unpivot (
col_val
for col_name in (
agr_forest_fish, mining_quarry, mfg, electric, water_sew
)
)
group by objectid https://dbfiddle.uk/DeaRoikf Source: https://forums.oracle.com/ords/apexds/post/idea-function-to-get-the-column-name-that-has-the-maximum-v-5088
... View more
08-13-2024
07:34 AM
|
0
|
0
|
3805
|
|
IDEA
|
Typo: "ArcGIS Pro 3.3.1" should be "ArcGIS Pro 2.9.5". I'm having trouble editing this idea at the moment, so I'm replying instead.
... View more
08-13-2024
07:07 AM
|
0
|
0
|
749
|
|
POST
|
Idea: Symbolize using the field name that has the maximum value
... View more
08-12-2024
07:14 AM
|
1
|
0
|
776
|
|
IDEA
|
Symbolise by maximum value field's name by @HanliePetoors: I have some census data that shows how many people are employed in different industries, say Industry A, Industry B and Industry C. So each polygon has a value for Industry A, Industry B and Industry C. [I want to] symbolise the census polygons to show the name of the industry that employs the most people. So if polygon 1 employs most people in Industry C, I want to symbolise it with a specific colour corresponding to Industry C. For OBJECTID 1 and 3 I want to return the value 'Industry Agriculture Forestry Fisheries' and for OBJECTID 2 I want to return the value 'Industry Manufacturing'. Either as a label or a value that I can use for symbology. I'm looking for dynamic, out-of-the-box functionality (no code) in the symbology pane.
... View more
08-12-2024
07:13 AM
|
2
|
1
|
707
|
|
POST
|
I normally work with Oracle, not SQL Server, but I was able to quickly mock up the SQL Server solution from this answer: Getting the column name that holds the maximum value of a row I did it in db<>fiddle. with temp as (
select objectid, industry, count
from employment_by_industry
unpivot
(
count
for industry in (agr_forest_fish, mining_quarry, mfg, electric, water_sew)
) u
)
select distinct t1.objectid, t2.industry
from temp t1
cross apply (
select top 1 objectid, industry
from temp
where t1.objectid = objectid
order by count desc) t2 I don't know if that's the simplest solution or not. @AlfredBaldenweck, @JoshuaBixby, and @AJR might find this interesting.
... View more
08-12-2024
07:08 AM
|
1
|
2
|
3867
|
|
POST
|
What do you want to happen if there is a tie between two industries?
... View more
08-12-2024
04:06 AM
|
0
|
1
|
841
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-20-2026 02:12 PM | |
| 1 | 03-19-2026 11:42 AM | |
| 1 | 06-03-2026 04:02 AM | |
| 1 | 03-18-2026 07:08 PM | |
| 2 | a month ago |
Activity Feed
- Got a Kudo for Reduce ArcGIS Pro network traffic. Tuesday
- Posted Re: SharePoint/Power Platform support group for GIS people on ArcGIS Online Questions. Tuesday
- Posted SharePoint/Power Platform support group for GIS people on ArcGIS Online Questions. Tuesday
- Got a Kudo for Export Table GP tool — Option to remove field domain. a week ago
- Got a Kudo for Setting default units should be immediately reflected in measure tool. a week ago
- Posted Re: Are UTM coordinates at bottom of map view independent from UTM projection in Project's Map/FC? on ArcGIS Pro Questions. a week ago
- Got a Kudo for One-to-first join — Control what related record gets used. 2 weeks ago
- Got a Kudo for Spatial Join — "One-to-one (tiebreaker field)" join operation. 2 weeks ago
- Got a Kudo for Consistent one-to-one/one-to-first wording in GP tool parameters. 2 weeks ago
- Got a Kudo for Integrate ArcGIS Data Pipelines in ArcGIS Enterprise with Microsoft Power Automate. 2 weeks ago
- Got a Kudo for Spatial definition queries in ArcGIS Online. 3 weeks ago
- Got a Kudo for Send configurable email notifications from ArcGIS Enterprise Data Pipeline. 3 weeks ago
- Got a Kudo for Run Notebook from Enterprise Data Pipeline. 3 weeks ago
- Posted Re: How reliable are ArcGIS Online webhooks? on ArcGIS Online Questions. 3 weeks ago
- Kudoed Re: How reliable are ArcGIS Online webhooks? for LindsayRaabe_FPCWA. 3 weeks ago
- Got a Kudo for AGOL or Portal Lists app, including Active Directory people column. 3 weeks ago
- Got a Kudo for Re: How reliable are ArcGIS Online webhooks?. 4 weeks ago
- Got a Kudo for How reliable are ArcGIS Online webhooks?. 4 weeks ago
- Got a Kudo for Reduce ArcGIS Pro network traffic. a month ago
- Got a Kudo for Sharepoint List Connector. a month ago
Contact Me