idea Add Geometry as Text Options to 'Calculate Geometry Attributes' (WKT, WKB, GeoJSON) in ArcGIS Pro Ideas

Add Geometry as Text Options to 'Calculate Geometry Attributes' (WKT, WKB, GeoJSON)

ColeAndrews — Fri, 16 Oct 2020 14:30:02 GMT

As mentioned here by Kory Kramer, ArcPy now has functions to calculate spatial objects as text, such as WKT and GeoJSON. Please add this to an out of the box GP tool-- I believe Calculate Geometry Attributes is the perfect place for it.

Purpose: populate a text field with the string representation of valid geometric objects, with options including WKT, WKB, and GeoJSON.

Use case: Portability of GIS data. We need the ability to load a delimited csv of all tabular attributes of a feature class to data warehouses, including one text field containing the text representation of a spatial object. Once the csv is loaded to a data warehouse as a table, most of the database platforms can convert the geometry text to a spatial object using SQL functions like ST_FromText and TO_GEOGRAPHY.

Re: Add Geometry as Text Options to 'Calculate Geometry Attributes' (WKT, WKB, GeoJSON)

JoshuaBixby — Fri, 16 Oct 2020 15:13:44 GMT

You got my vote, I think this it quite a good idea.

Re: Add Geometry as Text Options to 'Calculate Geometry Attributes' (WKT, WKB, GeoJSON)

ColeAndrews — Tue, 20 Oct 2020 16:23:08 GMT

This is a relatively simple enhancement that would make this task much easier to work with, especially in model builder, so I requested it be logged as a formal enhancement. Here is the enhancement number:

Re: Add Geometry as Text Options to 'Calculate Geometry Attributes' (WKT, WKB, GeoJSON)

Zartico-GIS — Wed, 01 Mar 2023 22:42:47 GMT

not sure if you are aware or not, but you can accomplish this by simply inputting "!shape.wkt!" into the python command a calculate field dialog.

Re: Add Geometry as Text Options to 'Calculate Geometry Attributes' (WKT, WKB, GeoJSON)

Bud — Thu, 02 Mar 2023 20:57:22 GMT

Somewhat related:

ArcMap: Field Calculator to get JSON text
This is basically the inverse of what you're asking for, but it might be of interest: Idea - Event layers for lines, polygons, and multi-part points (via WKT)