topic Re: Coordinate conversion using AutoCad in AutoCAD Forum

Coordinate conversion using AutoCad

OceanaPolynom — Mon, 18 Mar 2024 16:24:46 GMT

Hello

A number of points were surveyed around the open end of a large pipe that was laying on the ground. The measured coordinates are attached in the file points.csv. When shown on the measured coordinate system the result is marked A in the attached PDF file. I would like to know how to use AutoCad to create the result marked B in the PDF file.

Re: Coordinate conversion using AutoCad

autoid374ceb4990 — Mon, 18 Mar 2024 20:57:53 GMT

Are the coordinates in your CSV file in E,N,Z order?

When I open your PDF file I do not see anything marked "B". I am assuming you want a drawing like the circle with the inscribed points?

Re: Coordinate conversion using AutoCad

OceanaPolynom — Mon, 18 Mar 2024 23:31:46 GMT

The coordinates in the csv file are in Point Name E,N,Z order. All the Point Names begin with B in the csv file. I want a drawing like the circle with the inscribed points.

Thanks,

John

Re: Coordinate conversion using AutoCad

leeminardi — Tue, 19 Mar 2024 01:51:15 GMT

In Excel add the formula in cell F1 and fill down.

=CONCATENATE("_point ",B1,",",C1,",",D1)

Copy column F1 to F11 to the clipboard.

In AutoCAD

Declare a point style, e.g.,

pdmode 35

paste the clipboard and zoom extent and rotate view as shown.

Create a UCS with three points.

If you just want to view these points head on use the plan command.

If you want to pace the point in the XY plane use align.

Re: Coordinate conversion using AutoCad

autoid374ceb4990 — Tue, 19 Mar 2024 11:13:32 GMT

An even more simple solution since I do not have a newer version of AutoCAD. Visualize looking at the end of the culvert and use the X coordinate from your CSV file. For the Y coordinate use the Z coordinate from your CSV file. Use 0 (zero) for the Z coordinate). Now your coordinate file would look like this:

1,184476.5974,19.4834,0,B1
2,184476.8268,20.1722,0,B2
3,184476.8049,20.758,0,B3
4,184476.5472,21.4266,0,B4
5,184476.1285,21.819,0,B5
6,184475.2061,22.0817,0,B6
7,184474.5603,21.8908,0,B7
8,184473.9719,21.3034,0,B8
9,184473.7467,20.6118,0,B9
10,184473.8047,19.8834,0,B10
11,184475.2898,20.3948,0,cen

I was in the land surveying business so I have a routine to read this type comma delimited file into AutoCAD. I would assume that you could also change the coordinates in your CSV file and read them into whatever version of AutoCAD you have.

The result is shown in the attached JPG. I manually drew the lines between points and the red circle.

Re: Coordinate conversion using AutoCad

richard_387 — Tue, 19 Mar 2024 20:06:43 GMT

I am sorry you have chosen @ autoid374ceb4990 method to give you the answer. In this case, it is not accurate and only gives an oblique view of the end of the pipe. The method only works when the coordinate system is aligned to the face of the pipe, so the coordinates have to be rectified.

I plotted the original coordinates and joined them with lines. By rotating in 2D and in 3D in various views, the coordinates show the true elevation of the end of the pipe. In the picture attached, your chosen false solution is shown as a dashed green line and the true solution in blue.