Create a 2D Polyline from a list of lat/lon coordinates

[FJankovsky]

I have a list of coordinates in LL83 format and I would like to be able to either cut and paste from excel or write a script to draw a 2D Polyline from one end of the points to the other.  This would not be a closed Polyline. 

I know how to do this in plain vanilla Autocad but I have not been able to figure out how to do this is Map.

[Pointdump]

Hi @FJankovsky,
Do it the same way you'd do it with Vanilla. In QGIS you can use the Linestring Command in WKT(Well Know Text) Format, but I don't think Map has anything like that.
Dave

[FJankovsky]

PD,

Two problems, the first is when I select LL83 from the list of CRS in the Library I cant get a map to show up, and the second, when I copy and paste the A column in the attached sheet the path seems to be rotated 90 degrees out of phase and perhaps mirrored.

[АлексЮстасу]

What does "I can't get a map to show up" mean? What is "the A column"? And what are the quotes in the csv for?

The point reversal is due to the coordinate sequence in AutoCAD - it has the coordinate to the right first.
Change the coordinates in the csv.

In general - as Pointdump wrote: Ctrl C, Ctrl V.
(After deleting quotes and reversing coordinates)

[FJankovsky]

@АлексЮстасу 

Ok,

I switched the coordinates around and now the line looks properly oriented.  Thank you.

I don't see the quotes that you are referring to on the file I uploaded but I did use the concat formula when combining two columns into one which requires quotes around the comma to make it into a text object-=CONCAT(D2,",",E2).  Interesting that these quotation marks do not show up when the file is opened in excel but they do show up when opened in a text editor.

Column A was just the reference location in the CSV file when opened in Excel.  I guess that you opened the file in a text editor.

"I couldn't get the map to show up" means that when I click on the Map Icon on the Ribbon for some reason it is opening the Hatch and Gradient dialog instead of loading a map in the location of my drawing objects.  I'm sure that there is something that I'm doing incorrectly in this step but I'm not sure what it is.

This happened before when I was first learning Map before I learned how to turn on the proper local CRS for State Planes. 

Thank you for your response.

[Pointdump]

@FJankovsky,
"...when I select LL83 from the list of CRS in the Library I cant get a map to show up..."
Bing Live Maps only works with a Projected Coordinate System. LL83 is a Geographic Coordinate System.
Dave

[Pointdump]

@FJankovsky,
If you're using Civil 3D, the easiest way would be to import those Longs and Lats as points and then use Transparent Command 'PN to draw lines from Point to Point. You'd need to create a LongLat Point File Format first.
Dave

[FJankovsky]

@Pointdump 

I'm working in Map3D and that command does not seem to work.  The line you drew is exactly where it should be. 

I will take a look at the QGIS suggestion from above. 

Thanks

[FJankovsky · Accepted solution]

@Pointdump 

Before I tried QGIS I tried mapexport on my line to both KML and SDF.  This works and then the line can be brought into the appropriate drawing with mapimport.

This workaround is not too complicated. 

Thanks to @Pointdump  & @АлексЮстасу for your input on my problem.