Generate geometry by expression tool similar to QGIS

Question

I am trying to find a method of generating geometry based off a single point feature and 4 of its attributes to create a crown spread based on distances in each of the 4 cardinal directions.

In QGIS there is a tool called "Geometry by Expression" where it is fairly simple to generate these points, buffer them and convex hull to generate a polygon of the coverage, however i cannot find any similar tools in ArcGIS Pro.

I understand this could probably be done using python, however my skills are limited with python scripting, and hoping there is an easier way. I would ultimately like to build this into model builder alongside some other processes

Any ideas would be greatly appreciated

Bud · Answer

Have you tried using geoprocessing tools for this? Something like the following (untested):

* Export your hosted points layer to a geodatabase feature class.
* Create new fields: POINT_X and POINT_Y. Populate using Calculate Geometry.
* Create more new fields:* NORTH_X and NORTH_Y
* EAST_X and EAST_Y
* SOUTH_X and SOUTH_Y
* WEST_X and WEST_Y
Populate the new fields with mappable coordinates using Calculate Field. The math is up to you.

* Using a database view (or any other method, such as manually loading data into a newtable), unpivot the data so that you have a row for each cardinal direction vertex, producing a sort of vertical table. Fields: POINT_ID, X, Y.
* Use the XY Event Layer tool to generate a spatial point layer of the X and Y vertices.
* Buffer the points. Dissolve using the POINT_ID field.
* Use the Minimum Bounding Geometry tool to create convex hull polygons from your buffered multi-part/dissolved point polygons.

There are likely some details I've overlooked. But maybe the general idea is useful.

Edit:

Why do you want convex hulls? Why not a minimum bounding circle? A minimum bounding circle might eliminate the need for the buffered points step.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/minimum-bounding-geometry.htm

Or, better still, could you generate a circle using the longest cardinal direction measurement, using the point geometry as the middle of the circle? (Maybe using a simple technique like the Buffer tool.)
If not, can you show us a screenshot of your data, demonstrating why the technique you described is better? (buffering the cardinal directions points and then doing a convex hull to make a polygon from them)

Bud · Answer

* 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

Bud · Answer

For our notes, here is your related idea: generate geometry from expression