AnsweredAssumed Answered

import of lines from a Excel/Access-table

Question asked by geonetadmin on Jun 4, 2012
Latest reply on Jun 5, 2012 by m.gasior

Like • Show 0 Likes0
Comment • 5

Original User: MagnusP

hello community,

i have a table (Excel/Access). This should be produced in a line-layer. In the table there is a column with an ID, two with the X and Y coordinates of the starting point and two with the X and Y coordinates of the end point of the line.

I would like to embed this table now so that I can see and use the lines in ArcGIS.

thanks

MagnusP

Attachments

Clip_100.jpg8.0 KB
Clip_99.jpg177.7 KB

No one else has this question

Outcomes

5 Replies

geonetadmin Jun 4, 2012 2:34 PM
Mark Correct
Correct Answer
Original User: pmcatnip

Here is a page that should help.
Like • Show 0 Likes0
Actions
geonetadmin Jun 5, 2012 1:03 AM
Mark Correct
Correct Answer
Original User: MagnusP

Thanks for your quickly answer,

with the funktion �??Add XY Data�?�, what is described in your link, I can import only points. What i need is the import of linestrings defined of two points.

In my ArcGIS is now an dbf-file included. It contains an ID, an attribute, an X- and Y- coordinate of an startingpoint an the X- and Ycoordinate of the Endpoint. The problem is the figure/mapping of the line.
Like • Show 0 Likes0
Actions
m.gasior Jun 5, 2012 1:18 AM
Mark Correct
Correct Answer
I think that for your data schema you can try XY To Line (Data Management) tool (Data Management -> Features -> XY To Line).
Like • Show 0 Likes0
Actions
geonetadmin Jun 5, 2012 2:42 AM
Mark Correct
Correct Answer
Original User: MagnusP

oh, thanks a lot. It looks very nice.

But tell me where i can type and execute this code. (adapted codes sample).
If it is possible, please describe a short procedure.

Is ist VBA?
Like • Show 0 Likes0
Actions
m.gasior Jun 5, 2012 3:01 AM
Mark Correct
Correct Answer
If you have only one table to process, you don't need to use a code - just run the tool from toolbox (Data Management -> Features -> XY To Line; or type "XY to line" in Search window).

Anyway, to execute a code you can use Python window in ArcMap/ArcCatalog or standalone application like IDLE (which is installed with ArcGIS).
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

import of lines from a Excel/Access-table

Attachments

Outcomes

Related Content

Recommended Content