Latest Contributions by Bud

‎11-26-2022

I have a wetland polygon FGDB FC in ArcGIS Pro 3.0.2. Bud_0-1669533488192.png I want to symbolize the polygons as wetland plant symbols (no solid fill). Like this: Bud_1-1669533703818.png (source: Land Information Ontario topographic tiles -- in provincial web maps like CLUPA) How can I use or create a symbol like that? I'm new to symbology in ArcGIS Pro. For other layers, I've seen a Gallery tab. But I don't see that option for this layer.

‎11-25-2022

I've seen LIO (Land information Ontario) Topographic tiles used in various Ontario government web maps, such as the Crown Land Use Policy Atlas web map: Bud_0-1669398306751.png I want to use those topo maps as a base layer in ArcGIS Pro 3.0.2. I'm aware that ArcGIS Pro has ESRI topographic base maps included OOTB. But in this case, the LIO Topographic maps are better suited to my purposes. I looked at Ontario GeoHub: https://geohub.lio.gov.on.ca/search?q=topographic. But I don't see downloadable topo tiles anywhere. I'd prefer to use the pre-built tiles rather than symbolize the vector topographic data that's available on GeoHub (and the vector data would be slower than raster tiles too, so raster tiles would be preferred). Is there a way to use the LIO Topographic tiles in ArcGIS Pro? Either as downloadable files or as a web service? Thanks.

‎11-25-2022

For cases when ArcGIS Pro is thinking due to a slow process: If I click elsewhere in the application while it’s thinking, there will of course be a lag. But when it does finish thinking, it should honour that next position I clicked, not apply the click to the last thing that was selected, such as a selected layer in the table of contents. I believe other applications and operating systems behave in a more intuitive way: when lagging, the current mouse position is honoured. More information in this post — about layer properties changes being slow, and what happens when I click elsewhere: https://community.esri.com/t5/forums/postpage/board-id/arcgis-pro-ideas ArcGIS Pro 3.0.2

‎11-24-2022

In a layer's properties, when changing the layer's name/alias: When I hit OK to commit the name change, it takes two full seconds for ArcGIS Pro to think/commit the change. Two seconds might not seem like much, but for something as simple as a layer name change, I think it should happen sooner (immediately). Between the time when I hit OK and when it stops thinking, I've already started to do my next task, such as change the name of a different layer. But when I double click a different layer in the Table of Contents, it doesn't work as expected. Once it's done thinking, the application doesn't transfer focus to the next layer that I double clicked. Instead, the former layer's properties get opened, since that's technically the layer that is selected, which is confusing and frustrating. I think the situation would be improved if name changes happened faster. I also think double-clicking should apply to the thing/position I clicked, not the thing that is currently selected. I'm using ArcGIS Pro 3.0.2.

‎11-24-2022

If I understand correctly, there isn't a button in the Attribute Table in ArcGIS Pro for Selecting All Records. We can select all records by hitting the Switch Selection button, when no records are selected, which will select all records. But that's not very user-friendly; it took me a while to figure out how to do that. I think it would be better if there were a straightforward Select All Records button or menu option. Similar to what we have in ArcMap: https://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/selecting-all-records-in-a-table.htm Thanks. ArcGIS Pro 3.0.2

‎11-24-2022

When I open the Definition Query window, the comparison operator pick-list value gets truncated: Bud_0-1669305628762.png Bud_1-1669305665354.png I could click the pick-list or resize the window to see the full comparison operator name. But I think it would be better if it were displayed in full by default. Could the pick-list or window be widened by default to show the full comparison operator? Thanks. ArcGIS Pro 3.0.2

‎11-24-2022

For non-GIS professionals, using ArcGIS Pro can be difficult. The two separate concepts of the layer legend/symbology vs. definition queries can be confusing. I think novices would find it easier if they could simply toggle attributes on/off directly in the legend in the table of contents. That would make basic data exploration easier for beginners. In this case, everything else was easy for the user, such as finding the data and adding it to the map. But doing basic filtering in ArcGIS Pro was cumbersome. They wanted to just check legend attributes on/off when exploring the data. But I don't think that's possible in ArcGIS Pro. Could Esri consider adding a checkbox functionality in the table of contents? Maybe the underlying mechanism would be: the toggled checkboxes would automatically generate a definition query behind the scenes. Related: Progressive Disclosure of Complexity (YouTube 22:57).

‎11-22-2022

I used an ESRI competitor called GISCloud.com. It was surprisingly easy. Unlike AGOL, GISCloud supports WMS directly. Related: How to create a WMS Service to display a geo-reference image?

‎11-21-2022

When idea A gets merged to idea B, does A’s kudos get automatically added to B?

‎11-19-2022

For our notes, here's an example of your syntax working in SQL Server (the test has nothing to do with ArcGIS Pro): https://dbfiddle.uk/shBxoaUj Bud_0-1668906696036.png

‎11-19-2022

Related post: Definition Query SQL shouldn't autocomplete WHEN to WHENEVER

‎11-19-2022

For what it's worth, your original syntax seems to work fine on Oracle tables in ArcGIS Pro, both on versioned and unversioned tables: FIELD1 = (case WHEN 1=1 THEN FIELD1 end) Bud_0-1668904644020.png The brackets were just for legibility. They're not a subquery. It works without the brackets too: FIELD1 = case WHEN 1=1 THEN FIELD1 end Oracle 18c; 10.7.1 EGDB; ArcGIS Pro 2.6.8

‎11-19-2022

In the Definition Query window in SQL mode: When typing the word “when “, it autocompletes to “WHENEVER”. I don't know what use case WHENEVER applies to, but 99.999% of the time we'd want WHEN, not WHENEVER. Example: I typed "field1 = case when ". Note the space at the end of "when ". Bud_0-1668904131798.png It autocompleted "when " to "WHENEVER". Bud_0-1668904298668.png That's not what I wanted. It changed valid SQL to invalid SQL. ArcGIS Pro 2.6.8. Related: Optionally disable SQL expression autocomplete

‎11-19-2022

In the Definition Query window, is there a way to set the default mode to SQL? Instead of clicking the toggle every time I create a definition query? I'm using ArcGIS Pro 2.6.8

‎11-19-2022

I wonder if you could post a question on Stack Overflow or DBA Stack Exchange, with details like this: You are using software that has a limitation where using the CASE in the predicate directly in the WHERE clause expression doesn't work. So, is there a way to do what you want, using CASE in the predicate, but not directly in the WHERE clause? For example, could you wrap it in a subquery? A long shot: I wonder, is it actually a bug in ArcGIS Pro -- specifically a bug with how it handles definition queries on versioned data? Does it work on an unversioned table? I ask because I had a similar issue: Using Oracle SDE.ST_GEOMETRY functions in a defection query or attribute table doesn't work -- due to a bug with versioning in ArcGIS Pro. But if I wrap it in a subquery, then it works fine. Or if the data is unversioned, it works fine too. Use SDE.ST_GEOMETRY functions in Select by Attributes window Find multi-part features using SQL (ST_GEOMETRY) Esri Canada Case: 03080875 Bug Report: BUG-000150273 If you submit a case to support, and it turns out to be a bug, I suspect a bug would get fixed before an idea would get implemented,.

My Ideas

Latest Contributions by Bud

Symbolize polygons as wetland plant symbols

Use Ontario/LIO Topographic tiles in ArcGIS Pro

When ArcGIS Pro is lagging, the current mouse position should be honoured when clicked

Layer Properties: Name changes should be faster

Attribute Table: Select all records

Definition Query window: Show full comparison operator by default

Checkboxes in symbology to toggle attributes (automatically generate definition query)

Re: Publish WMS, TMS, or XYZ layer for iHunter app

When idea A gets merged to idea B, does A’s kudos get added to B?

Re: CASE Statements in Definition Query

Re: CASE Statements in Definition Query

Re: CASE Statements in Definition Query

Definition Query SQL shouldn't autocomplete “when “ to “WHENEVER”

Definition Query: Set default mode to SQL

Re: CASE Statements in Definition Query

Integrate ArcGIS Data Pipelines in ArcGIS Enterpri...

Send configurable email notifications from ArcGIS ...

Re: How reliable are ArcGIS Online webhooks?

How reliable are ArcGIS Online webhooks?

Sharepoint List Connector

GIS Jobs

Roads and Highways User Group (RHUG)

Local Government Solutions Users

Mapping and Charting Enterprise Databases

ArcGIS Arcade