Latest Contributions by Bud

Sometimes it's easier to read content if it's inverted or in dark mode. For example, I inverted an old land survey in GIMP the other day and it was much easier to read—I noticed some details I had missed previously. I suspect some Pro maps would be easier to explore and read if the colors were inverted. Could an option be added to temporarily invert map colors in the map pane? It would just be enabled while exploring a specific area in the map. I'd disable it when done. Source: @AlfredBaldenweck 's comment in Temporarily invert image colors for dark mode georeferencing. Maybe not what you're thinking of, but I think this would be a great addition to the View tab to just invert the entire map. ... View more

ArcGIS Pro 3.4.3; Oracle 19c 11.3 EGDB; Traditional versioning moving edits to base. My organization has recently upgraded from Pro 2.9.5 (had attribute rule limitations) to 3.4.3. And ArcMap has been phased out. So now, we are taking the plunge into calculation attribute rules. We're planning to use attribute rules to automatically generate IDs in ASSET_ID fields in various existing FCs.   Question: What do we need to consider when using an attribute rule to generate unique IDs for new rows in an existing FC? We may want to use use the attribute rule to enforce data integrity in general as well. How to start/continue the sequence at the largest existing number in the field? How to pad the numbers with zeros? Should the field allow nulls? Should the field be manually editable? Or should we disallow edits? Consider data dependencies/syncs to external systems like a work order management system. We could check to make sure there is a unique database index that enforces unique IDs. Or alternatively, switch from a database index to an attribute rule for this, since the database index causes issues when splitting linear assets. Consider relationship classes to other FCs or tables. I don't think we have any for our asset FCs, but it's still good to think about this. Should we prevent row deletions, for the purpose of integrations to external systems? Is there anything else we should consider? ... View more

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB I have an EVENTS non-spatial table (input table) joined to a ROADS FC (join table) via Add Join. I want to do a field calculation on an EVENTS field, utilizing the shape length from ROADS in the field calculation. However, the shape length has not been included in the joined attribute table, so I can't use it in Calculate Field. Could the shape length (or shape area) fields be included in joins for field calculations? I understand that the shape length isn't a real field in the database table; it's generated on the fly in Pro via ArcObjects. And I understand why the SHAPE field isn't included in the join; we wouldn't want multiple SHAPE fields in the same attribute table if joining from a FC to a FC. But that doesn't mean the shape length can't be included. I can't add a temporary SHAPE_LENGTH field in the FC because this is a corporate enterprise geodatabase that is locked, and I don't own it. And I would prefer not to copy data to a FGDB (and add a helper field) every time I need to do something like this in Pro. Creating a query layer with a length field via SQL wouldn't be suitable because joining to query layers is too slow in Pro. For what it's worth, sometimes this happens accidentally. Sometimes the shape length does get included in joins. I don't know why it happens, maybe it's a bug, but I suppose it proves that it's possible under certain circumstances. I thought I already had an idea for this, but I can't find it right now. ... View more

For non-Python users, I’m wondering if a pick-list or search box could be used to load pre-canned field calculations into ArcGIS Pro. Similar to Calculate Geometry, but it would work for non-spatial requirements as well. Maybe it would be called ‘Calculate Attribute’. Such as getting the count of attribute occurrences from a different field in a standalone table. GP tool to populate COUNT field with count of attribute occurrences ... View more

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB I have a ROADS line FC (has an ID field) and an EVENTS standalone table. EVENTS is a linear referencing table with ID, FMEAS (double), and TMEAS (double) fields. The relationship between ROADS and EVENTS is 1:M. One road to 0, 1, or more events. Some of the EVENTS.TMEAS values are larger than the length of the related road, which is incorrect. I want to: Select EVENTS where there is only one event per road. Join EVENTS to ROADS to bring the ROAD shape length field into the EVENTS attribute table. Calculate field: For the selected EVENTS, update the FMEAS field to the ROAD's shape length. How can I do that? I am running into join errors when trying to use a SQL subquery for the selection, so am looking for a different approach. ... View more

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB or file geodatabase A user who is not a SQL or Python person has a standalone table with an ID field. The user wants to populate a COUNT field with counts of the IDs. ID COUNT 1 1 2 1 3 2 3 2 4 1 If I understand correctly, there isn't a GP tool that can do that. Could a tool be added? ... View more

ArcGIS 3.4.3; Oracle 19c 11.3 EGDB Is it possible to publish custom mosaic dataset band symbology to Portal? View raster band-4 near infrared in ArcGIS Pro       ... View more