Center Line Coordinates as Lat Long

[nglatne]

HI,

Its Urgent, Please anybody can help me to export Center Line coordinates as Latitude and Longitude.

I got C line coordinates in Northing and Easting from the Reports Manager on the Tool space, Toolbox Tab.

[AllenJessup]

Set Cogo Points along the Alignment and include the Lat/Long in the export file format.

alig.pnglatlong.PNG

[Jeew-m]

Hi,

There is another way to export the lat long. By default it may give deg and seconds. But with settings you may change them to decimals if needed.

Thanks

[nglatne]

Thanks for ur reply.

I couldn't get what I want. Let me elaborate on my requirements. I have a Design Center Line in my drawing (Civil 3D 2018). I want to export only C Line Point coordinates at an increment of 10m. means at station 0+000, 0+010, 0+020...….. like wise. The export format shud be like "Station, Lat, Long" a csv file (as shown below)

Station         Latitude             Longitude

0+0000        19.16Deg N         73.5deg E

Please elaborate ur reply stepwise. 

Attaching

1) Drg screen shot. The red line is Center Line. 

2) Export File Format as text file

[AllenJessup]

I don't know of any way to create that format. That doesn't mean there isn't one. Just that I don't know it.

[AllenJessup]

You're best bet might to create the cogo points having the parameter "Prompt for Descriptions" set to "Automatic - Object". Then export a point file with columns - Latitude, Longitude and Description. Then open that file in Excel of a text editor and alter it as needed.

[nglatne · Accepted solution]

Hi all,

I found the easiest way of transforming the Cogo Points ( Northing Easting) to Lat Long by using the Global Mapper as a medium.

In this exercise

1) Generate file of Center Line (or any other Points/Group) Coordinates by generating Incremental station report at required interval (which gives you report having column headings  Station, Northing and Easting). Convert this file to csv file by keeping only Northing and easting.

2) Then set the Global Mapper projection to your UTM Zone with WGS 84 as datum. then open the csv file in the Global Mapper.

3) After opening the csv file, change the projection from UTM to Geographic (Lat Long) 

4) then export the file to csv format by using the File --> Export -----> Vector/Lidar Format ----> choose the format as csv.

5) That's it, you got the points converted to from N E to Lat Long.

Happy Learning

[lynn_zhang]

Hello @nglatne 

Glad to hear you figured out a way to fix the problem and thanks so much for sharing the solution! This will benefit other users in the community with the same issue.