|
IDEA
|
Somewhat related: Event layers for lines, polygons, and multi-part points (via WKT) Custom Event Layers Fields to Rectangle geoprocessing tool
... View more
08-23-2024
06:58 AM
|
0
|
0
|
1874
|
|
POST
|
Can you provide some sample data in an Excel export or in a mobile geodatabse export (you might need to zip the mobile geodatabase in order to attach it to your original post above). What kind of geodatabase? For example, Oracle 18c 10.7.1 enterprise geodatabase. What version of ArcGIS Pro? For anyone using Oracle, this is what it might look like using SDO_GEOMETRY (untested): sdo_geometry('polygon(('||x1||' '||y1||', '||x2||' '||y2||', '||x3||' '||y3||', '||x4||' '||(y4)||', '||x1||' '||y1||'))',26917) as shape Source: https://community.esri.com/t5/arcgis-pro-questions/convert-grid-lines-to-polygons/m-p/1183793/highlight/true#M56283. I would think the same kind of thing could be done using SDE.ST_GEOMETRY SQL functions. At least, that would generate the rectangle polygon. It doesn't help with the buffered points part. https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/st-buffer.htm https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/st-convexhull.htm https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/st-aggr-convexhull.htm
... View more
08-23-2024
06:53 AM
|
0
|
0
|
3608
|
|
IDEA
|
For our notes, here is your related question: Generate geometry by expression tool similar to QGIS
... View more
08-23-2024
06:50 AM
|
0
|
0
|
1875
|
|
POST
|
For our notes, here is your related idea: generate geometry from expression
... View more
08-23-2024
06:49 AM
|
0
|
0
|
3609
|
|
IDEA
|
@JonathanNeal Thanks. At first glance, that script doesn't seem to order the sequential numbers by the VALUES field (descending), which is a requirement.
... View more
08-22-2024
06:42 PM
|
0
|
0
|
2189
|
|
IDEA
|
Comment from Esri on August 16, 2024: “…ArcGIS Pro 3.4 planned for Oct/Nov 2024” https://community.esri.com/t5/arcgis-pro-ideas/toggle-visibility-for-individual-categories-on/idc-p/1523092/highlight/true#M31603
... View more
08-22-2024
11:38 AM
|
0
|
0
|
2057
|
|
POST
|
Comment from Esri on August 16, 2024: “…ArcGIS Pro 3.4 planned for Oct/Nov 2024” https://community.esri.com/t5/arcgis-pro-ideas/toggle-visibility-for-individual-categories-on/idc-p/1523092/highlight/true#M31603
... View more
08-22-2024
11:38 AM
|
2
|
4
|
7334
|
|
POST
|
I’m inexperienced with Python, so I assumed a field calculation would be easiest. I hadn’t considered a Python cursor script in the Python Window as an option. But if that’s easier, then it would be fine.
... View more
08-22-2024
11:31 AM
|
0
|
1
|
1254
|
|
IDEA
|
Calculate Field with sequential numbers, partition by GROUP_ID field, order by VALUES field
... View more
08-22-2024
11:12 AM
|
0
|
0
|
2493
|
|
IDEA
|
ArcGIS Pro 3.3.1; file geodatabase
I want to use the field calculator to populate a new/blank field called ROW_NUM.
For each group, using sequential numbers starting at 1, ordered by the VALUES field (descending)…populate the ROW_NUM field.
GROUP_ID VALUES ROW_NUM 1 0 2 1 1 1 1 0 3 2 0 1 2 0 2 3 1 1 3 0 3 3 1 2
It is my understanding that can’t currently be done using the Calculate Field tool (Python). Could that functionality be added?
If it were an Oracle SQL query, it would look like this:
select GROUP_ID, VALUES, row_number() over (partition by GROUP_ID order by VALUES desc) as rn from MY_TABLE
... View more
08-22-2024
11:04 AM
|
1
|
4
|
2253
|
|
POST
|
ArcGIS Pro 3.3.1; file geodatabase GROUP_ID VALUES 1 0 1 1 1 0 2 0 2 0 3 1 3 0 3 1 I want to rearrange the VALUES data so that the values are sorted descending, sorted within each GROUP_ID partition. GROUP_ID VALUES 1 1 1 0 1 0 2 0 2 0 3 1 3 1 3 0 How can I do that using the Field Calculator? I’m aware of the Sort geoprocessing tool. But I don’t want to use Sort because it outputs a separate FC. I want to update the original FC directly. And I would prefer not to use the Sort tool, join it back to the original FC, and then do a filed calculation to bring in the joined/sorted values. I don’t want to sort the rows, I want to edit the values and leave the row order as-is.
... View more
08-22-2024
10:42 AM
|
1
|
3
|
1282
|
|
POST
|
This issue continues to trip me up. When cancelling an edit to a post, I expect the browser to go back to that same post. Instead, it goes to a different post that I had navigated to previously.
... View more
08-22-2024
10:06 AM
|
0
|
1
|
1015
|
|
POST
|
Idea: Using a single tool: Sort within groupings, join, and fill gaps
... View more
08-21-2024
09:35 PM
|
1
|
0
|
2043
|
|
IDEA
|
ArcGIS Pro 3.3.1
The Make Query Table tool produces Query Tables that have a hidden SQL Expression.
The SQL expression behaves similarly to a definition query but with some differences:
The SQL expression is obscured in ArcGIS Pro. It cannot be viewed or edited (unless a .LYRX file is exported and the JSON is viewed/edited in a text editor).
The SQL expression acts as a pre-filter when the layer is used in a join, which solves the following issue: Definition query on join table will effectively result in an inner join
It is very important to know if a Query Table has a hidden SQL expression.
Could Pro be enhanced so that there is an indication that the SQL expression exists? Such as a warning bar in the feature layer properties.
Related: Layer description in feature layer properties (including Contents hover-over functionality)
... View more
08-21-2024
09:04 PM
|
2
|
0
|
496
|
| 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 |