nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can I import csv file of line data?

asdfjljwg

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?

Find more posts tagged with

Analysis

Desktop

Feature Services

Accepted answers

AhmedFathy74

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

All comments

AhmedFathy74

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

asdfjljwg

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

JB1234510

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.