Latest Contributions by Bud

@AlyciaRajendran_esri  This idea is related: Consistent Terminology: FC >> Attribute Table vs. Table >> Open ... View more

@Kevin_MacLeod  Agree. Is your join a one-to-many join? Select By Attributes on joined data — For rows that are 1:M, all rows in the join table get selected, despite selection criteria Source: Is ArcGIS Pro the right tool for tabular/join-based geodatabase analysis? ... View more

@Heather_Hegi I think it was in the Table to Table geoprocessing tool's Field Map section. I believe that tool was replaced by the Export Table tool in later versions of Pro. ... View more

That functionality wasn't brought over from ArcMap to ArcGIS Pro. It's an equivalency issue. There is an idea for it somewhere but I can't find it right now. What kind of geodatabase (file, mobile, or enterprise) and what kind of enterprise database (Oracle, SQL Server, PostgreSQL)? If it's an enterprise geodatabase, then you might be able to query for it using SQL. What kind of spatial type? ST_GEOMETRY? Oracle's SDO_GEOMETRY? Or maybe someone can come up with a Python solution or an attribute rule that would put a flag in a field. @Laura The linear referencing M-value is a component of the SHAPE field. It's a type of coordinate, just like X, Y, or Z. Each vertex in an M-enabled FC has a X, Y, and M value, so it can be tricky to query the M values because there are multiple per line. Is it a line feature class? Do you need to find lines that have ANY vertices with missing M values? Or would it be good enough to find lines where the start vertex or end vertex are missing the M value? Calculate Geometry has options for getting the M value of the start and end of lines:   ... View more

@AlfredBaldenweck  It looks like XY Table to Point can produce a UTM FC. I suppose that might work as a last resort. But, as you said, it produces a copy of the original FC. How could the new FC's shape be used to update the existing features in the original FC? I don't want to delete and replace the rows, I want to update them. Maybe the new Upsert functionality in 3.1 could be used to update the features in the original FC: GP tool to batch-replace geometries from one FC to another (via related IDs). But I think that would only work if there was a user-defined unique ID other than the ObjectID to join on (the original FC's ObjectID won't be preserved in the new FC). Not all FCs have a user-defined unique ID column. Sure, I could add a new field in the original FC and use the Field Calculator to populate it with unique values such as the ObjectID (static). But that seems unnecessarily cumbersome. Idea: GP Tools — Include original ObjectID field in output FC ... View more

Related: GP tool to populate point shapes from X/Y number fields (in existing FC) ... View more

Related:  Modify Features — Editing tool to update shape from XY fields Append — Load XY table into point FC as point features ... View more

An alternative option: Create a table from scratch using Catalog and import the fields/schema from the CSV, instead of importing the CSV as a new table. Creating a table from scratch would allow me to easily adjust the imported field types and lengths while creating the table.   ... View more

I don’t know about model builder, but my comment in this post compares the different kinds of layers/layer tools. It might help make some sense of those tools. https://community.esri.com/t5/arcgis-pro-ideas/consistent-visible-sql-expressions-and-query/idc-p/1366709/highlight/true#M27874   ... View more

You need to generate a row number column in your query using SQL: Register with Geodatabase but No Object ID ... View more