nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Python - Field Calculator Expression - Writing Bytearray to Text Field (WKB)

ColeAndrews

Need a little python help. This is for use in field calculator. Goal is to write the WKB representation of geometry objects (in a feature class) to a text field, for the purpose of exporting to csv.

ArcPy supports writing WKB of geometry objects. See: https://pro.arcgis.com/en/pro-app/latest/arcpy/classes/geometry.htm#P_GUID-BC466D06-360C-42BD-B198-DA4139B45F49

The basic expression to get the WKB is !Shape.WKB!, although that returns a bytearray. I believe it needs to be encoded and converted to a string. The output should look like this image:

The text in that image exports to csv as: "\001\006\000\000\000\001\000\000\000\001\003\000\000\000\001\000\000\000\012\023\000\000\314\276\362 . . . "

Find more posts tagged with

Analysis

Geodatabase

Desktop

Accepted answers

ColeAndrews

Confirmed, I took the string output of (!Shape.WKB!).hex() and input in to a few non-esri databases using spatial SQL functions. The databases can properly parse the hexidecimal WKB in to GEOMETRY/GEOGRAPHY data.

All comments

ColeAndrews

@DanPatterson , thanks for the response. Trying to simplify this as a field expression. Looks like I just need to use the hex function on the bytearray. If my empty field is called "WKB_String", then [WKB_String] = (!Shape.WKB!).hex() is populating the field. I would have thought the syntax was [WKB_String] = hex.(!Shape.WKB!), but that throws an error that bytearray cannot be converted to integer. Does this image look like it is accomplishing the same end result as your script?

danretired

from arcpy.da import SearchCursor
in_fc = r"C:\arcpro_npg\npg\Project_npg\tests.gdb\sq"
with SearchCursor(in_fc, ['SHAPE@WKB']) as cursor:
    shps = [row[0] for row in cursor]
s0 = shps[0]
# --- first shape
s0
bytearray(b'\x01\x03\x00\x00\x00\x02\x00\x00\x00\x07\x00\x00\x00\x00\x00\x00\x00\xa4O\x12A\x00\x00\x00@\xd0\x12SA\x00\x00\x00\x00\xa8O\x12A\x00\x00\x00\x00\xd2\x12SA\x00\x00\x00\x00\xa8O\x12A\x00\x00\x00\x80\xd2\x12SA\x00\x00\x00\x00\xa0O\x12A\x00\x00\x00\x80\xd2\x12SA\x00\x00\x00\x00\x88O\x12A\x00\x00\x00\x00\xd2\x12SA\x00\x00\x00\x00\x80O\x12A\x00\x00\x00\x00\xd0\x12SA\x00\x00\x00\x00\xa4O\x12A\x00\x00\x00@\xd0\x12SA\x04\x00\x00\x00\x00\x00\x00\x00\x8cO\x12A\x00\x00\x00\xc0\xd0\x12SA\x00\x00\x00\x00\x94O\x12A\x00\x00\x00\xc0\xd1\x12SA\x00\x00\x00\x00\x9cO\x12A\x00\x00\x00\xc0\xd0\x12SA\x00\x00\x00\x00\x8cO\x12A\x00\x00\x00\xc0\xd0\x12SA')

# ---- as hex
s0.hex()
'0103000000020000000700000000000000a44f124100000040d012534100000000a84f124100000000d212534100000000a84f124100000080d212534100000000a04f124100000080d212534100000000884f124100000000d212534100000000804f124100000000d012534100000000a44f124100000040d012534104000000000000008c4f1241000000c0d012534100000000944f1241000000c0d1125341000000009c4f1241000000c0d0125341000000008c4f1241000000c0d0125341'

then

Well-known text representation of geometry - Wikipedia

if you can test with your inputs

Other options

ColeAndrews

Here is a similar question:

https://gis.stackexchange.com/questions/75967/pyqgis-converting-wkb-to-string

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.