Create polylines from sets of coordinates and convert to feature class

wavey — Tue, 13 Jun 2023 23:58:34 GMT

I have a csv with data that contains 4 sets of coordinates per line. start_x, start_y, end_x, and end_y which correspond to the start and end of individual line segments. The goal is to take these coordinates, load them into a dataframe, create polylines, and then save them as a feature class in the database.

I'm able to get the points loaded into a pandas dataframe, use the Polyline function from arcgis.geometry to create polyline objects, and store them in the pandas dataframe. Before storing them back in the dataframe I check to make sure that the resulting polyline objects are valid with .is_valid and they all return true. However when I try to convert to a spatially enabled dataframe I get an error saying: Invalid geometry type for method.

I'm not entirely sure where to go from here. Any suggestions about a better way to accomplish this or how to deal with converting to SEDF and then feature class would be greatly appreciated.

# Import the csv file as a df df = pd.read_csv('sample_vals.csv') # Define the function which takes x, y, and wkid inputs and converts them into an arcgis geometry polyline object def coordToPolyline(coord_list, input_wkid): line_dict = {"paths": coord_list, "spatialReference": {"wkid": input_wkid}} output_polyline = Polyline(line_dict) return output_polyline # Create the SHAPE column in the pandas dataframe df['SHAPE'] = '' print(df) # Run through the pandas dataframe and calculate the lines for i in range(0, len(df)): # Grab the start_x, start_y, end_x, and end_y and put into a list to use for Polyline initial_x = df.iloc[i]['start_x'] initial_y = df.iloc[i]['start_y'] end_x = df.iloc[i]['end_x'] end_y = df.iloc[i]['end_y'] # Populate the list iter_coord_list = [] iter_coord_list.append([initial_x, initial_y]) iter_coord_list.append([end_x, end_y]) # Call the function and pass the coord list and wkid=2276 iter_polyline_obj = coordToPolyline(iter_coord_list, 2276) # Verify that the polyline object created is valid if iter_polyline_obj.is_valid(): # If Polyline object is valid then add it to the pandas dataframe in the SHAPE column at index i df.at[i, 'SHAPE'] = iter_polyline_obj print(iter_polyline_obj.is_valid()) else: print('One or more of the calculated Polyline objects is not valid.') # Try to go to an sdf sdf = GeoAccessor.from_df(df, geometry_column='SHAPE')

Re: Create polylines from sets of coordinates and convert to feature class

FrédéricPRALLY — Wed, 14 Jun 2023 08:11:27 GMT

Hi wavey,

Why not simply use tool XY to lines ?

import arcgis input_table = r'C:\temp\sample_vals.csv' out_lines = r'C:\temp\Default.gdb\sample_vals' # XY To Line arcpy.XYToLine_management(input_table, out_lines, "start_x", "start_y", "end_x", "end_y", "PLANAR","","NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_Feet" )

Best regards,

Fred

Re: Create polylines from sets of coordinates and convert to feature class

wavey — Thu, 15 Jun 2023 18:38:49 GMT

Thank you so much! I had no idea the XY to lines tool existed but it is exactly what I was looking for.

Re: Create polylines from sets of coordinates and convert to feature class

sofoo — Thu, 27 Jul 2023 19:52:54 GMT

Sorry but that solution still doesn't solve the question. How is one suppose to do this with spatial dataframes (pandas or esri)??

topic Re: Create polylines from sets of coordinates and convert to feature class in ArcGIS API for Python Questions

Create polylines from sets of coordinates and convert to feature class

Re: Create polylines from sets of coordinates and convert to feature class

Re: Create polylines from sets of coordinates and convert to feature class

Re: Create polylines from sets of coordinates and convert to feature class