Skip to main content
Geographic Information Systems

Return to Question

deleted 22 characters in body
Source Link
nora
nora
  • 131
  • 8

I have a table in excel format with the following two columns:

excle table

Now, I need to import this table to ArcMap and calculate the distance between the two points for each row and write the calculated distance (kilometer) automatically in a new column "C". Firstly, I use the tool “Excel to table”, but then:

What is the quickest way to convert the two columns in a format to use the “x,y, coordinate tool”? and has ArcMap a tool to calculate the distance between the two points of each row, when I do not integrate the whole street network?

I guess that I need to iterate through the table, but I have no straightforward idea which tools are the best to use.

I am working with ArcMap 10.5.1.

I have a table in excel format with the following two columns:

excle table

Now, I need to import this table to ArcMap and calculate the distance between the two points for each row and write the calculated distance (kilometer) automatically in a new column "C". Firstly, I use the tool “Excel to table”, but then:

What is the quickest way to convert the two columns in a format to use the “x,y, coordinate tool”? and has ArcMap a tool to calculate the distance between the two points of each row, when I do not integrate the whole street network?

I guess that I need to iterate through the table, but I have no straightforward idea which tools are the best to use.

I am working with ArcMap 10.5.1.

I have a table in excel format with the following two columns:

Now, I need to import this table to ArcMap and calculate the distance between the two points for each row and write the calculated distance (kilometer) automatically in a new column "C". Firstly, I use the tool “Excel to table”, but then:

What is the quickest way to convert the two columns in a format to use the “x,y, coordinate tool”? and has ArcMap a tool to calculate the distance between the two points of each row, when I do not integrate the whole street network?

I guess that I need to iterate through the table, but I have no straightforward idea which tools are the best to use.

I am working with ArcMap 10.5.1.

deleted 35 characters in body; edited tags; edited title
Source Link
PolyGeo ♦
PolyGeo ♦
  • 65.4k
  • 29
  • 114
  • 345

How to import Importing and convertconverting coordinates to ArcMap and calculate thecalculating distance between them?

I have a table in excel format with the following two columns:   

excle table

Now, I need to import this table to ArcMap and calculate the distance between the two points for each row and write the calculated distance (kilometer) automatically in a new column "C". Firstly, I use the tool “Excel to table”, but then: What

What is the quickest way to convert the two columns in a format to use the “x,y, coordinate tool”? and has ArcMap a tool to calculate the distance between the two points of each row, when I do not integrate the whole street network? I

I guess that I need to iterate through the table, but I have no straightforward idea which tools are the best to use. Thanks for supporting in advance. 

I am working with ArcMap 10.5.1;

Nora1.

How to import and convert coordinates to ArcMap and calculate the distance between them?

I have a table in excel format with the following two columns:  excle table

Now, I need to import this table to ArcMap and calculate the distance between the two points for each row and write the calculated distance (kilometer) automatically in a new column "C". Firstly, I use the tool “Excel to table”, but then: What is the quickest way to convert the two columns in a format to use the “x,y, coordinate tool”? and has ArcMap a tool to calculate the distance between the two points of each row, when I do not integrate the whole street network? I guess that I need to iterate through the table, but I have no straightforward idea which tools are the best to use. Thanks for supporting in advance. I am working with ArcMap 10.5.1;

Nora

Importing and converting coordinates to ArcMap and calculating distance between them?

I have a table in excel format with the following two columns: 

excle table

Now, I need to import this table to ArcMap and calculate the distance between the two points for each row and write the calculated distance (kilometer) automatically in a new column "C". Firstly, I use the tool “Excel to table”, but then:

What is the quickest way to convert the two columns in a format to use the “x,y, coordinate tool”? and has ArcMap a tool to calculate the distance between the two points of each row, when I do not integrate the whole street network?

I guess that I need to iterate through the table, but I have no straightforward idea which tools are the best to use. 

I am working with ArcMap 10.5.1.

Source Link
nora
nora
  • 131
  • 8

How to import and convert coordinates to ArcMap and calculate the distance between them?

I have a table in excel format with the following two columns: excle table

Now, I need to import this table to ArcMap and calculate the distance between the two points for each row and write the calculated distance (kilometer) automatically in a new column "C". Firstly, I use the tool “Excel to table”, but then: What is the quickest way to convert the two columns in a format to use the “x,y, coordinate tool”? and has ArcMap a tool to calculate the distance between the two points of each row, when I do not integrate the whole street network? I guess that I need to iterate through the table, but I have no straightforward idea which tools are the best to use. Thanks for supporting in advance. I am working with ArcMap 10.5.1;

Nora