arcpy.da.InsertCursor: TypeError: cannot read geometry sequence. expected list of floats

Question

I'm kind of at my wits' end here. My insert cursor is not letting me use a polygon object for input into my SHAPE@ for a polygon feature class. The workflow is: get a layer from a source using OGR, then, for each feature in the layer, grab its geometry as JSON, feed that into an array, create an arcpy.Polygon object from it, and feed it into the SHAPE@ of my polygon feature class. I have tried arcpy.AsShape() in the following ways: * JSON as given* Fails on AsShape()* "Invalid geometry type for method" * Fails on insert, if plugged in directly* "SystemError: returned NULL without setting an exception" * JSON modified to match esri GeoJSON format* Fails on insert* "Object of type Polygon is not JSON serializable" * {"type:"Polygon", "rings":[[[x1, y1]]], "spatialReference" : {"wkid":102962, "latestWkid": 102962}}* arcpy.AsShape(gJSON, True) * JSON modified to match general geoJSON* Fails on insert* "cannot read geometry sequence. expected list of floats" * {"type:"Polygon", "coordinates":[[[x1, y1]]]}* arcpy.AsShape(gJSON) Since they all failed, I'm trying to create a Polygon object directly and feed that in instead. I'm doing this because ogr2ogr produces a broken feature class in the desired location. from osgeo import ogr import json tbl =r"...\Default.gdb\work" source = r"filepath" spat_ref = arcpy.SpatialReference(102962) in_ds = ogr.Open(source) lay = in_ds.ExecuteSQL("select * from Townships") with arcpy.da.InsertCursor(tbl, ["SHAPE@"]) as cursor: for l in lay: gJSON = json.loads(l.GetGeometryRef().ExportToJson()) coors = arcpy.Array() for cor in gJSON["coordinates"][0][0]: coors.append(arcpy.Point(cor[0], cor[1])) coors = arcpy.Polygon(coors, spat_ref) cursor.insertRow(tuple(coors)) Traceback (most recent call last): File "", line 15, in TypeError: cannot read geometry sequence. expected list of floats Here's the thing. I'm getting valid coordinates from the JSON. I can plot them manually and verify that they are what they're supposed to be. I have done a similar workflow before, where I fed a geometry object into the SHAPE@ with no problem. I have even tried actually feeding Pro a Geometry object instead of a Polygon object, and it crashed instantly. Here's the JSON exactly as given in line11 for the first polygon. Spoiler (Highlight to read){'type': 'MultiPolygon', 'coordinates': [[[[40228.96130000055, -102137.65980000049], [40630.914200000465, -102144.1754999999], [41025.03810000047, -102128.7014000006], [41419.07189999893, -102113.20900000073], [41816.53720000014, -102118.36639999971], [41821.81769999862, -102118.44129999913], [42213.283500000834, -102122.15469999984], [42616.51089999825, -102134.57169999927], [42737.95919999853, -102138.40179999918], [43019.82310000062, -102145.9684999995], [43044.39079999924, -102488.64970000088], [43073.44649999961, -102892.5549999997], [43102.68290000036, -103296.5700000003], [43131.92179999873, -103700.58449999988], [43160.89779999852, -104104.7109999992], [43189.78779999912, -104508.9486999996], [43218.77160000056, -104913.63020000048], [43247.84629999846, -105318.1995000001], [43270.43360000104, -105721.35679999925], [43293.0223999992, -106124.40249999985], [43304.9833999984, -106325.86610000022], [43317.03460000083, -106527.55150000006], [43340.43250000104, -106931.70360000059], [43364.18690000102, -107335.7424999997], [43387.94299999997, -107739.66980000027], [43411.34120000154, -108142.70910000056], [43434.830899998546, -108545.85879999958], [43458.32310000062, -108949.11910000071], [43481.81679999828, -109352.2678999994], [43505.21970000118, -109754.63859999925], [43528.53579999879, -110157.0092999991], [43551.68019999936, -110560.15860000066], [43574.737100001425, -110963.19669999927], [43597.797899998724, -111366.56790000014], [43620.860599998385, -111769.9386], [43209.20399999991, -111763.39149999991], [42797.45879999921, -111756.7137000002], [42385.895300000906, -111750.68170000054], [41974.24309999868, -111744.51879999973], [41563.03759999946, -111738.6671999991], [41151.92110000178, -111732.6838000007], [40754.2536999993, -111732.83999999985], [40356.675200000405, -111732.97699999996], [39956.60750000179, -111732.88470000029], [39556.53990000114, -111732.7731999997], [39156.56129999831, -111732.6425999999], [38756.49399999902, -111732.49340000004], [38321.52710000053, -111737.59710000083], [37886.55939999968, -111742.56719999947], [37451.67509999871, -111746.40300000086], [37016.70129999891, -111750.1054999996], [36584.449400000274, -111746.3264000006], [36152.19849999994, -111742.63639999926], [35719.94799999893, -111738.92410000041], [35287.69759999961, -111735.07850000076], [34854.740899998695, -111732.21399999969], [34421.78460000083, -111729.32729999907], [33988.650899998844, -111726.00280000083], [33981.87510000169, -111725.9924999997], [33540.49610000104, -111722.54800000042], [33526.2686999999, -111319.5605999995], [33512.042399998754, -110916.57279999927], [33497.81700000167, -110513.47360000014], [33484.689199998975, -110140.26999999955], [33483.59219999984, -110110.26270000078], [33481.090100001544, -110039.80079999939], [33469.36910000071, -109707.16259999946], [33455.05750000104, -109303.84009999968], [33440.74769999832, -108900.62839999981], [33426.527800001204, -108497.41589999944], [33411.95380000025, -108094.20450000092], [33397.381400000304, -107691.1037000008], [33403.694899998605, -107291.14330000058], [33409.91869999841, -106891.18280000053], [33412.65139999986, -106484.45529999956], [33415.2947999984, -106077.72780000046], [33428.332600001246, -105672.29250000045], [33441.27980000153, -105266.74609999917], [33440.03269999847, -104864.70150000043], [33438.875, -104462.76730000041], [33432.10350000113, -104055.74190000072], [33425.42179999873, -103648.82699999958], [33422.22049999982, -103246.34420000017], [33419.01920000091, -102843.86089999974], [33416.616099998355, -102441.15179999918], [33414.21319999918, -102038.44239999913], [33815.1576000005, -102040.17459999956], [34216.1911999993, -102041.8872999996], [34616.35099999979, -102046.91909999959], [35016.59970000014, -102051.82039999962], [35415.61430000141, -102058.59740000032], [35814.62999999896, -102065.46690000035], [36213.55680000037, -102072.09530000016], [36612.57349999994, -102078.81570000015], [37013.98800000176, -102085.61769999936], [37415.49210000038, -102092.40020000003], [37816.9952000007, -102098.83000000007], [38218.587900001556, -102105.24029999971], [38621.6911999993, -102111.84679999948], [39022.57620000094, -102118.4441999998], [39424.792199999094, -102124.79419999942], [39827.009500000626, -102131.23589999974], [40228.96130000055, -102137.65980000049]]]]}{'type': 'MultiPolygon', 'coordinates': [[[[40228.96130000055, -102137.65980000049], [40630.914200000465, -102144.1754999999], [41025.03810000047, -102128.7014000006], [41419.07189999893, -102113.20900000073], [41816.53720000014, -102118.36639999971], [41821.81769999862, -102118.44129999913], [42213.283500000834, -102122.15469999984], [42616.51089999825, -102134.57169999927], [42737.95919999853, -102138.40179999918], [43019.82310000062, -102145.9684999995], [43044.39079999924, -102488.64970000088], [43073.44649999961, -102892.5549999997], [43102.68290000036, -103296.5700000003], [43131.92179999873, -103700.58449999988], [43160.89779999852, -104104.7109999992], [43189.78779999912, -104508.9486999996], [43218.77160000056, -104913.63020000048], [43247.84629999846, -105318.1995000001], [43270.43360000104, -105721.35679999925], [43293.0223999992, -106124.40249999985], [43304.9833999984, -106325.86610000022], [43317.03460000083, -106527.55150000006], [43340.43250000104, -106931.70360000059], [43364.18690000102, -107335.7424999997], [43387.94299999997, -107739.66980000027], [43411.34120000154, -108142.70910000056], [43434.830899998546, -108545.85879999958], [43458.32310000062, -108949.11910000071], [43481.81679999828, -109352.2678999994], [43505.21970000118, -109754.63859999925], [43528.53579999879, -110157.0092999991], [43551.68019999936, -110560.15860000066], [43574.737100001425, -110963.19669999927], [43597.797899998724, -111366.56790000014], [43620.860599998385, -111769.9386], [43209.20399999991, -111763.39149999991], [42797.45879999921, -111756.7137000002], [42385.895300000906, -111750.68170000054], [41974.24309999868, -111744.51879999973], [41563.03759999946, -111738.6671999991], [41151.92110000178, -111732.6838000007], [40754.2536999993, -111732.83999999985], [40356.675200000405, -111732.97699999996], [39956.60750000179, -111732.88470000029], [39556.53990000114, -111732.7731999997], [39156.56129999831, -111732.6425999999], [38756.49399999902, -111732.49340000004], [38321.52710000053, -111737.59710000083], [37886.55939999968, -111742.56719999947], [37451.67509999871, -111746.40300000086], [37016.70129999891, -111750.1054999996], [36584.449400000274, -111746.3264000006], [36152.19849999994, -111742.63639999926], [35719.94799999893, -111738.92410000041], [35287.69759999961, -111735.07850000076], [34854.740899998695, -111732.21399999969], [34421.78460000083, -111729.32729999907], [33988.650899998844, -111726.00280000083], [33981.87510000169, -111725.9924999997], [33540.49610000104, -111722.54800000042], [33526.2686999999, -111319.5605999995], [33512.042399998754, -110916.57279999927], [33497.81700000167, -110513.47360000014], [33484.689199998975, -110140.26999999955], [33483.59219999984, -110110.26270000078], [33481.090100001544, -110039.80079999939], [33469.36910000071, -109707.16259999946], [33455.05750000104, -109303.84009999968], [33440.74769999832, -108900.62839999981], [33426.527800001204, -108497.41589999944], [33411.95380000025, -108094.20450000092], [33397.381400000304, -107691.1037000008], [33403.694899998605, -107291.14330000058], [33409.91869999841, -106891.18280000053], [33412.65139999986, -106484.45529999956], [33415.2947999984, -106077.72780000046], [33428.332600001246, -105672.29250000045], [33441.27980000153, -105266.74609999917], [33440.03269999847, -104864.70150000043], [33438.875, -104462.76730000041], [33432.10350000113, -104055.74190000072], [33425.42179999873, -103648.82699999958], [33422.22049999982, -103246.34420000017], [33419.01920000091, -102843.86089999974], [33416.616099998355, -102441.15179999918], [33414.21319999918, -102038.44239999913], [33815.1576000005, -102040.17459999956], [34216.1911999993, -102041.8872999996], [34616.35099999979, -102046.91909999959], [35016.59970000014, -102051.82039999962], [35415.61430000141, -102058.59740000032], [35814.62999999896, -102065.46690000035], [36213.55680000037, -102072.09530000016], [36612.57349999994, -102078.81570000015], [37013.98800000176, -102085.61769999936], [37415.49210000038, -102092.40020000003], [37816.9952000007, -102098.83000000007], [38218.587900001556, -102105.24029999971], [38621.6911999993, -102111.84679999948], [39022.57620000094, -102118.4441999998], [39424.792199999094, -102124.79419999942], [39827.009500000626, -102131.23589999974], [40228.96130000055, -102137.65980000049]]]]}What is going on? Thanks!

JoshuaBixby · Answer

It is "Esri JSON," no 'geo' prefix, and "GeoJSON," no 'Esri' or 'general' qualifier.

I took the GeoJSON shared in the question and tested it at GeoJSON Viewer & Validator, it fails with:

Line 1: Polygons and MultiPolygons should follow the right-hand rule

HaydenWelch · Answer

Have you tried re-building the geometry with the spatial reference after getting the WGS84 AsShape result?

from osgeo import ogr
import json
tbl =r"...\Default.gdb\work"
source = r"filepath"
spat_ref = arcpy.SpatialReference(102962)
in_ds = ogr.Open(source)
lay = in_ds.ExecuteSQL("select * from Townships")

# Do the risky processing outside the cursor so
# if something goes wrong, you wont have a partial insert
to_insert = []
for l in lay:
    # Load Geojson
    gJSON = json.loads(l.GetGeometryRef().ExportToJson())

# Get as ESRI shape
    shape = arcpy.AsShape(gJSON)

# Re-build shape with correct spatial reference
    proj_shape = arcpy.Polygon(arcpy.Array(part for part in shape), spat_ref)

# Add shape to insert list
    to_insert.append(proj_shape)

with arcpy.da.InsertCursor(tbl, ["SHAPE@"]) as cursor:
    for proj_shape in to_insert:
        cursor.insertRow([proj_shape])

When I test this with your sample geojson, I get this:

So it seems to be properly re-building the shape.

AlfredBaldenweck · Answer

Well, that does explain the AsShape issue, but the Polygon and Geometry objects' problems remain a mystery.

I got around this by still using ogr2ogr after all.

I had been copying everything to a geopackage (long story), then doing stuff to it.

I was able to copy everything  to a file gdb instead, and the problem geometry came along with no issues.

Unfortunately, not everything made it to the file gdb, so what I really ended up doing was copying everything to a geopackage AND the file gdb, then copying everything from the geopackage to the file gdb and skipping anything that failed.

Gross, probably pretty inefficient, and ultimately one step forward and one step back, but it does work now.

Find more posts tagged with

Accepted answers

All comments

Join the Conversation

Quick Links