Hello,
I experience issues in creating a polyline from the coordinates using arcpy. I am getting the data from the WFS server, truncating the table in my local geodatabase and inserting the data from the WFS server into the local geodatabase. We do not need to edit the data, just viewing and creating a dashboard.
The problem is the following: When I create a polyline geometry from the coordinate value pairs and insert into the target source using InsertCursor, the lines appear around the origin of the coordinate system (0,0) despite having the right coordinates. The funny thing is that the length of the lines is correct but they are centered around the (0,0) of the CS.
I searched online, read a few posts here and there and used chatGPT but nothing works and I do not understand why. What confuses me is that I am actually copying the data from two layers on the WFS server using requests module and returning the JSON format, both are Multiline strings (with just one line actually) but one set of data is copied to the right location with the right geometry while the other one is placed around the origin (0,0). Both have identical coordinates and I even went line by line through the JSON file to check if the coordinates are the same. I also use the for-loop to get the data and insert it in the database so I am excluding that something is different for one feature service but not another. What a weird behavior... Anyone had similar experience and wants to hint how to fix it?
Here is the part of the code for this operation:
with arcpy.da.InsertCursor(target_layer, fieldnames) as cursor:
for feature in data["features"]:
# Get geometry and attributes from a feature
geometry = feature["geometry"]
attributes = feature["properties"]
gml_id = feature["id"]
# Create an array of points from geometry coordinates
if geometry["type"] == "MultiLineString":
array = arcpy.Array([arcpy.Point(*coords) for coords in geometry["coordinates"][0]])
geom = arcpy.Polyline(array, spatRef, True, True)
value = [geom] + [gml_id] + [attributes[field] for field in fieldnames[2:])
cursor.insertRow(value)
