topic Re: TypeError: value #1 - unsupported type: Polygon in Python Questions

TypeError: value #1 - unsupported type: Polygon

OrRubinstein — Wed, 14 Jul 2021 13:52:22 GMT

Hey,

I'm trying to add new rows into empty polygon feature.

this is the code:

try:

cur = arcpy.da.InsertCursor(outshp, ["Id" , 'Floor_area'])
file = open(csvfile)
reader = csv.reader(file)
line = next(reader)
cnt = 0

for line in reader:
new_row = [line[0]]
points = []

for i in line[1:]:
p = i.split(',')
point = arcpy.Point(p[0], p[1])
points.append(point)
arr = arcpy.Array(points)
polygn = arcpy.Polygon(arr)
new_row.append(polygn)
cur.insertRow(new_row)
cnt += 1
del cur

except:
traceback.print_exc()
del cur

sadly, I'm getting this error:

Traceback (most recent call last):
  File "<ipython-input-8-44580ffd528c>", line 21, in <module>
    cur.insertRow(new_row)
TypeError: value #1 - unsupported type: Polygon

Can you understand why?

Thanks

Re: TypeError: value #1 - unsupported type: Polygon

DavidPike — Wed, 14 Jul 2021 13:56:53 GMT

I'm finding the code very hard to read without indentation.

Re: TypeError: value #1 - unsupported type: Polygon

OrRubinstein — Wed, 14 Jul 2021 14:03:23 GMT

Sorry, had trouble copying the code/

here it is:

try:

cur = arcpy.da.InsertCursor(outshp, ["Id" , 'Floor_area'])
file = open(csvfile)
reader = csv.reader(file)
line = next(reader)
cnt = 0

except:
traceback.print_exc()
del cur

Re: TypeError: value #1 - unsupported type: Polygon

DanPatterson — Wed, 14 Jul 2021 14:04:37 GMT

Code formatting ... the Community Version - Esri Community will help with that and provide line numbers

Re: TypeError: value #1 - unsupported type: Polygon

DanPatterson — Wed, 14 Jul 2021 14:09:46 GMT

you don't provide a value for your "Id" just for the polygon..

Re: TypeError: value #1 - unsupported type: Polygon

OrRubinstein — Wed, 14 Jul 2021 14:17:31 GMT

i rewrote it:

try: cur = arcpy.da.InsertCursor(outshp, ["Id" , 'Floor_area']) file = open(csvfile) reader = csv.reader(file) line = next(reader) cnt = 0 for line in reader: new_row = [cnt, line[0]] points = [] for i in line[1:]: p = i.split(',') point = arcpy.Point(p[0], p[1]) points.append(point) arr = arcpy.Array(points) polygn = arcpy.Polygon(arr) new_row.append(polygn) cur.insertRow(new_row) cnt += 1 del cur except: traceback.print_exc() del cur

but when I do provide value for Id get another error:

Traceback (most recent call last): File "<ipython-input-9-a3290e7f669b>", line 21, in <module> cur.insertRow(new_row) TypeError: sequence size must match size of the row

Re: TypeError: value #1 - unsupported type: Polygon

DanPatterson — Wed, 14 Jul 2021 14:17:49 GMT

check the examples in InsertCursor—ArcGIS Pro | Documentation

example 3 is what you are providing... just a shape, but you need to provide an Id value since you specified it in your fields

 ["Id" , 'Floor_area']

Re: TypeError: value #1 - unsupported type: Polygon

BlakeTerhune — Wed, 14 Jul 2021 14:40:32 GMT

First, I recommend using a with statement for opening files and cursors so they get closed automatically when exiting (with or without an error). Second, it looks like you're trying to insert a row with polygon geometry (shape) without specifying a shape field when you open the cursor. If Floor_area is just that, a double field representing the area measurement of a polygon, that's what you need to insert.

try: cnt = 0 with open(file, "r") as csv_reader: with arcpy.da.InsertCursor(outshp, ["Id", "Floor_area"]) as cur: for csv_line in csv_reader: polygon_points = [] for point in line[1:]: x, y = point.split(",") point_geometry = arcpy.Point(x, y) polygon_points.append(point_geometry) polygon_geometry = arcpy.Polygon(arcpy.Array(polygon_points)) polygon_geometry_sqft = polygon_geometry.getArea(units="SQUAREFEET") cur.insertRow((csv_line[0], polygon_geometry_sqft)) cnt += 1 except: traceback.print_exc()

If you do want to insert the polygon shape, you'll need to include "SHAPE@" in the fields and add the polygon_geometry into the values for insertRow().

Re: TypeError: value #1 - unsupported type: Polygon

OrRubinstein — Wed, 14 Jul 2021 15:05:48 GMT

Thanks.

'Floor area' field is actully not a geometry field, so I edite it:

try: cnt = 0 with open(csvfile, "r") as csv_reader: with arcpy.da.InsertCursor(outshp, ["Id", "Floor_area", 'SHAPE@']) as cur: for csv_line in csv_reader: polygon_points = [] for point in line[1:]: x, y = point.split(",") point_geometry = arcpy.Point(x, y) polygon_points.append(point_geometry) polygon_geometry = arcpy.Polygon(arcpy.Array(polygon_points)) polygon_geometry_sqft = polygon_geometry.getArea(units="SQUAREFEET") cur.insertRow((csv_line[0], polygon_geometry_sqft)) cnt += 1 except: traceback.print_exc()

but now i get this:

Traceback (most recent call last): File "<ipython-input-40-433ebdb7888e>", line 12, in <module> polygon_geometry_sqft = polygon_geometry.getArea(units="SQUAREFEET") File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\arcobjects\arcobjects.py", line 1609, in getArea return convertArcObjectToPythonObject(self._arc_object.GetArea(*gp_fixargs((method, units)))) TypeError: Invalid geometry type for method

Re: TypeError: value #1 - unsupported type: Polygon

BlakeTerhune — Wed, 14 Jul 2021 16:06:35 GMT

If you add SHAPE@ to the InsertCursor, you'll also need to include a value for that when you call insertRow(). Line 13 should be

cur.insertRow((csv_line[0], polygon_geometry_sqft, polygon_geometry))

As for the TypeError: Invalid geometry type for method, make sure the points in your CSV make a valid polygon. Alternatively, just leave out Floor_area completely, then calculate that field after you've inserted all the new features.

Re: TypeError: value #1 - unsupported type: Polygon

OrRubinstein — Wed, 14 Jul 2021 16:37:34 GMT

Thank to some of the advices here the error has been resolved, but the feature don't includes coordinates and doesn't appear on the map... i can't really understand why.

this is all of the code:

import csv import arcpy import traceback #Create Polygon layer from csv table csvfile = r'C:\Geography\Spatial Python\final\Final_Ex\Buildings_alternative_2.csv' outpath = r'C:\geography\Spatial Python\final' outshp = 'test.shp' outshp = arcpy.CreateFeatureclass_management ( outpath, outshp, geometry_type='POLYGON', spatial_reference=arcpy.SpatialReference(4326)) arcpy.AddField_management (outshp, 'Floor_area', "LONG") arcpy.AddField_management (outshp, 'SHAPE@', "DOUBLE") try: cur = arcpy.da.InsertCursor(outshp, ["Id" , 'Floor_area', 'SHAPE@']) file = open(csvfile) reader = csv.reader(file) line = next(reader) cnt = 1 for line in reader: new_row = [cnt, line[0]] points = [] for i in line[1:]: p = i.split(',') point = arcpy.Point(p[0], p[1]) points.append(point) arr = arcpy.Array(points) polygon = arcpy.Polygon(arr) new_row.append(polygon) cur.insertRow(new_row) cnt += 1 del cur except: traceback.print_exc() del cur

the table includes the 'floor area' field but not the spatial data.

Re: TypeError: value #1 - unsupported type: Polygon

BlakeTerhune — Wed, 14 Jul 2021 16:41:29 GMT

Could you post some sample rows from the CSV?

Re: TypeError: value #1 - unsupported type: Polygon

OrRubinstein — Wed, 14 Jul 2021 16:42:58 GMT

Re: TypeError: value #1 - unsupported type: Polygon

BlakeTerhune — Wed, 14 Jul 2021 17:51:51 GMT

It's hard to get the full picture of what's happening with this screenshot. It would help if you could post the raw text of a few rows (with header row).

From what I can see here, column A is your "Id" field? Is there a variable number of point coordinate columns? Also, I see you're creating a "SHAPE@" field in the shapefile. That's not how that's intended to work. It's what's called a field token. It's not a field name that actually exists.

InsertCursor—ArcMap | Documentation (arcgis.com)

Here's some updated code but I'm not certain it will solve your problem.

import csv import arcpy import traceback #Create Polygon layer from csv table csvfile = r'C:\Geography\Spatial Python\final\Final_Ex\Buildings_alternative_2.csv' outpath = r'C:\geography\Spatial Python\final' outshp = 'test.shp' try: outshp = arcpy.CreateFeatureclass_management( outpath, outshp, geometry_type='POLYGON', spatial_reference=arcpy.SpatialReference(4326) ) arcpy.AddField_management (outshp, 'Id', "TEXT") arcpy.AddField_management (outshp, 'Floor_area', "DOUBLE") with open(csvfile, "r") as csv_reader: with arcpy.da.InsertCursor(outshp, ["Id", "Floor_area", 'SHAPE@']) as cur: for csv_line in csv_reader: polygon_points = [] for point in line[1:]: x, y = point.split(",") point_geometry = arcpy.Point(x, y) polygon_points.append(point_geometry) polygon_geometry = arcpy.Polygon(arcpy.Array(polygon_points)) polygon_geometry_sqft = polygon_geometry.getArea(units="SQUAREFEET") cur.insertRow((csv_line[0], polygon_geometry_sqft, polygon_geometry)) except: traceback.print_exc()

Try grabbing a single row of point coordinates from your CSV and hard coding them into your script (no CSV looping). Use those values to try inserting a single record into the shapefile. Start small to troubleshoot.

Re: TypeError: value #1 - unsupported type: Polygon

OrRubinstein — Wed, 14 Jul 2021 18:21:42 GMT

thease are the first 2 rows, the coloumns are from left to right:

180	178168.85730000027,642304.1140000001	178228.20880000014,642355.0789000001	178319.57019999996,642248.6835999992	178260.21879999992,642197.7185999993	178168.85730000027,642304.1140000001
180	178303.8627000004,642163.7553000003	178358.5828999998,642219.6634999998	178458.8058000002,642121.5704999994	178404.08559999987,642065.6622000001	178303.8627000004,642163.7553000003

Column A is Floor area and the rest are coodinates (x,y in every cell). the Id added automatically to the table, i'm not sure how but i can see that on arcGis pro. The variable for the id it "cnt".

there are varaibles for the coordinates and i'm looping on them here:

for p in line[1:]: #looping the coordinates in every line pnt = p.split(',') #split x and y coordinates point = arcpy.Point(pnt[0], pnt[1]) #create a point feature points.append(point) #add to the point list arr = arcpy.Array(points) polygon = arcpy.Polygon(arr) new_row.append(polygon) cur.insertRow(new_row) cnt += 1 del cur

I'm not familiar with the commands you wrote in the code, but the table i get is partial and i get this error:

File "<ipython-input-26-e60a0c54162d>", line 17, in <module> arcpy.AddField_management (outshp, 'Id', "TEXT") File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 4337, in AddField raise e File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 4334, in AddField retval = convertArcObjectToPythonObject(gp.AddField_management(*gp_fixargs((in_table, field_name, field_type, field_precision, field_scale, field_length, field_alias, field_is_nullable, field_is_required, field_domain), True))) File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 511, in <lambda> return lambda *args: val(*gp_fixargs(args, True)) arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid. ERROR 000012: Id already exists Failed to execute (AddField).

Re: TypeError: value #1 - unsupported type: Polygon

OrRubinstein — Thu, 15 Jul 2021 14:17:00 GMT

Turns out that the problem was with the projection.

thanks for the help.

this is the code that works:

import csv import arcpy import traceback #Create polygon feature from csv file csvfile = r'C:\Geography\Spatial Python\final\Final_Ex\Buildings_alternative_2.csv' outpath = r'C:\geography\Spatial Python\final' outshp = 'build.shp' outshp = arcpy.CreateFeatureclass_management ( outpath, outshp, geometry_type='POLYGON', spatial_reference=arcpy.SpatialReference(2039)) arcpy.AddField_management (outshp, 'Floor_area', "LONG") #add field for Floor area try: cur = arcpy.da.InsertCursor(outshp, ['Id', 'Floor_area', 'SHAPE@']) f = open(csvfile) reader = csv.reader(f) lne = next(reader) cnt = 1 for line in reader: #looping lines in the csv file new_row = [cnt, line[0]] # index of the row and the floor area field points = [] for p in line[1:]: #looping the coordinates in every line pnt = p.split(',') #split x and y coordinates point = arcpy.Point(float(pnt[0]), float(pnt[1])) #create a point feature points.append(point) #add to the point list arr = arcpy.Array(points) polygon = arcpy.Polygon(arr) new_row.append(polygon) cur.insertRow(new_row) cnt += 1 del cur