topic Re: Import points into Eastings/Northings file in Civil 3D Forum

Import points into Eastings/Northings file

tmccar — Sat, 18 Mar 2023 13:13:29 GMT

I have imported a point file which has latitude, longitude and altitude into Civil 3D. The coordinate system is set to ITM-Ireland.

My problem is that the drawing I am importing into is using a different coordinate system. It's using Eastings and Northings. The points from the points file are coming in at a location that is north-east of where they should be. Can the points file be imported in such a way that it matches the Eastings and Northings?

Re: Import points into Eastings/Northings file

Pointdump — Sat, 18 Mar 2023 13:51:54 GMT

Hi Tom,
"...coming in at a location that is north-east of where they should be."
How far to the north east? Can you post your point file?
Dave

Re: Import points into Eastings/Northings file

tmccar — Sat, 18 Mar 2023 14:42:23 GMT

I have uploaded the csv (Latitude&Longitude) file. It comes in around 100,000 units too far north (100,000 in Y)

Re: Import points into Eastings/Northings file

Pointdump — Sat, 18 Mar 2023 15:13:04 GMT

Tom,
Thanks for posting your CSV point file. For me they're coming in at the intersection of Togher Pairc and An Tsraid Mhor Main Street in Togher Beg, Oldtown, Co. Wicklow, Ireland. Drawing attached.
Dave

Re: Import points into Eastings/Northings file

tmccar — Sat, 18 Mar 2023 16:56:24 GMT

@Pointdump wrote:
Tom,
Thanks for posting your CSV point file. For me they're coming in at the intersection of Togher Pairc and An Tsraid Mhor Main Street in Togher Beg, Oldtown, Co. Wicklow, Ireland. Drawing attached.
Dave

That's spot on Dave! Could you share your drawing units - coordinate system etc?

Re: Import points into Eastings/Northings file

Pointdump — Sat, 18 Mar 2023 20:57:43 GMT

Tom,
I used a Metric drawing and assigned "ITM" coordinate system. There are several different coordinate systems for Ireland that would also work.
That point file has lots of duplicates. For instance, point number 1 is also 2, 132, 133, 2461, and 2462.
Dave

Re: Import points into Eastings/Northings file

tmccar — Sat, 18 Mar 2023 18:03:39 GMT

@Pointdump wrote:
Charles,
I used a Metric drawing and assigned "ITM" coordinate system. There are several different coordinate systems for Ireland that would also work.
That point file has lots of duplicates. For instance, point number 1 is also 2, 132, 133, 2461, and 2462.
Dave

Great - could I also ask how you placed the map?

Re: Import points into Eastings/Northings file

Pointdump — Sat, 18 Mar 2023 20:55:28 GMT

Tom,
Sorry I called you Charles in the last post. I'm old, I get confused a lot. 😁
After assigning a coordinate system to your drawing, the Geolocation Tab should appear on your ribbon. In the Online Map Panel choose either Map Aerial, Map Road, or Map Hybrid.
Dave

Re: Import points into Eastings/Northings file

ChicagoLooper — Sat, 18 Mar 2023 22:59:43 GMT

Hello @tmccar

Wicklow, correct?

Yes, you can use the Civil3D method mentioned by @Pointdump

Here's another method. It doesn't involve creating a NEW point style either. Here's how:

Use MAPIMPORT command. Your your existng csv file is in NEZ format (Northing, Easting, Elevation) and this command already understands the Lat/Long format. See image-1.
Your points will import as BLOCKS but they'll be too big. You'll need to reduce their size. See image-2.
Select ALL the imported blocks so you can reduce them globally. Use Scale X, Y, Z=10. See image-3.
Finally, go to How to convert AutoCAD blocks to Civil 3D points. Choose and follow the instructions in the second option to complete the procedure and create cogo points from your Lat/Long csv file. See image-4.

Image-1

Image-2

Image-3

Image-4

Image-5

Your csv file was used as-is. Even though it's in Lat/Long format, it can be used to create the cogos as shown above.

Re: Import points into Eastings/Northings file

tmccar — Mon, 20 Mar 2023 08:12:38 GMT

@ChicagoLooper wrote:
Hello @tmccar
Wicklow, correct?

Yes, you can use the Civil3D method mentioned by @Pointdump

Here's another method. It doesn't involve creating a NEW point style either. Here's how:

Use MAPIMPORT command. Your your existng csv file is in NEZ format (Northing, Easting, Elevation) and this command already understands the Lat/Long format. See image-1.
Your points will import as BLOCKS but they'll be too big. You'll need to reduce their size. See image-2.
Select ALL the imported blocks so you can reduce them globally. Use Scale X, Y, Z=10. See image-3.
Finally, go to How to convert AutoCAD blocks to Civil 3D points. Choose and follow the instructions in the second option to complete the procedure and create cogo points from your Lat/Long csv file. See image-4.
Image-1

Image-2

Image-3

Image-4

Image-5
Your csv file was used as-is. Even though it's in Lat/Long format, it can be used to create the cogos as shown
above.

Thank you @ChicagoLooper - that's a big help! I didn't know about the NEZ format.
Yes - Roundwood, Co. Wicklow