topic Re: Can I import csv file of line data? in ArcGIS Pro Questions

Can I import csv file of line data?

asdfjljwg — Thu, 05 Jan 2023 02:05:43 GMT

Hello, I have a csv-structured dataset as follows :

ID	x1	y1	x2	y2
1	14184878	4442592	14184886	4442595
2	14184504	4443068	14184511	4443076
...	...	...	...	...

This is a line dataset, whose x values are latitude and y values are longitude of two points of each line.

But I have no idea how to import this in line form, because the only way importing csv file into GIS I've known so far is just dropping it and clicking 'XY data display' menu. And if I do this, I can use coordinates of only one point. Thus, I can only import this csv file in only point form.

So is there any way that I can import this in line form?

Re: Can I import csv file of line data?

JohannesBierer — Thu, 05 Jan 2023 11:51:25 GMT

I think you will need python to do this - someone posted a solution here:

https://gis.stackexchange.com/questions/34647/creating-lines-from-points-pair-coordinates-with-arcpy

I tried the code of Chad Cooper there with four points with the old cursors ... it seems to work.

Here is the code I used:

import arcpy fieldnames = ['X1', 'Y1', 'X2', 'Y2'] # Needed input/ output files inExcel = r"YOURPATH\Points.xlsx" FGDB = r"YOURPATH\Points2Lines.gdb" outTable = "Coords" outLines = "Lines" arcpy.env.workspace = FGDB arcpy.env.overwriteOutput = True # Change to your Sheet name! arcpy.conversion.ExcelToTable(inExcel, outTable, "Test") in_rows = arcpy.SearchCursor(outTable) point = arcpy.Point() array = arcpy.Array() # Without Spatial Reference, please change! arcpy.CreateFeatureclass_management(FGDB, outLines, "POLYLINE") featureList = [] cursor = arcpy.InsertCursor(outLines) feat = cursor.newRow() for in_row in in_rows: # Set X and Y for start and end points # Change here to your field names point.X = in_row.X1 point.Y = in_row.Y1 array.add(point) point.X = in_row.X2 point.Y = in_row.Y2 array.add(point) # Create a Polyline object based on the array of points polyline = arcpy.Polyline(array) # Clear the array for future use array.removeAll() # Append to the list of Polyline objects featureList.append(polyline) # Insert the feature feat.shape = polyline cursor.insertRow(feat) del feat del cursor

Re: Can I import csv file of line data?

asdfjljwg — Fri, 06 Jan 2023 07:46:40 GMT

Thank you! I didn't tried this yet, but this seems very fit for my purpose.

Re: Can I import csv file of line data?

AhmedFathy74 — Fri, 06 Jan 2023 12:38:23 GMT

Hi,

You can easily use xy to line geoprocessing tool and you will be able to add this CSV file in line form

Ahmed fathy