Import points from CSV file inserts points in incorrect location.

Import points from CSV file inserts points in incorrect location.

Anonymous
Not applicable
4,479 Views
35 Replies
Message 1 of 36

Import points from CSV file inserts points in incorrect location.

Anonymous
Not applicable

Ok lets cover the bases. I have been working with Civil 3d days and have done this process hundreds of times in my career. Yes I have purged, audited and cleaned regapps before coming here.

 

The original files should have no transformation.  It was surveyed by a field crew working in the same system we use. And also I use the same point file format I have used forever.

 

When the file is imported this time however, the group of points were shifted to the south about 1.6 kilometers from where it should be.  Now usually when something like this happens I attribute it to a survey error, wrong benchmark or whatever.  So I check an inserted point coordinate with 'ID' and cross reference it with the CSV file, there is a discrepancy.

 

I manually enter the correct coordinate in, and its where it should be, not where the point is.  So I click on the point and check its properties.  Oddly enough under properties, is a field called Northing and one called Easting, but its not the coordinates of where the point is inserted, its where it should have been inserted.

A coworker tried to solve the issue and was able to get it to work by defining the coordinate system, changing the import file format to use grid coordinates instead.  I tried to replicate his results to no avail.  In my reasoning it really should not have an effect, but I am at a loss what to do next.

0 Likes
4,480 Views
35 Replies
Replies (35)
Message 21 of 36

Anonymous
Not applicable

No.  You have already proven confrontational with me Jeff, and I expressed that I do not want your assistance.  Is that a crime to say please stop trolling my posts?

 

 

Edited by
Discussion_Admin

0 Likes
Message 22 of 36

cwr-pae
Mentor
Mentor

By what method are you determining the points are out of place?

0 Likes
Message 23 of 36

Anonymous
Not applicable

please look at the attached png and read the entirety of my post, but wth I will explain it again.

I have a published coordinate on a  drawing from our survey consultant.  The surveyed point in the CSV MATCHES the PUBLISHED point exactly, but when the point file is inserted into drawing the point objects get inserted ~1.6km to the south.


 

 

0 Likes
Message 24 of 36

cwr-pae
Mentor
Mentor

Have you tried loading a geomap image to confirm the error?

0 Likes
Message 25 of 36

Anonymous
Not applicable

No.  Why would I even consider that?  I have a PUBLISHED coordinate, and did you not read what I said?

 

 

Thanks
Discussion_Admin

0 Likes
Message 26 of 36

nate-hunt
Enthusiast
Enthusiast

He is asking for files so he can help you.

 

I would bet Jeff would quickly help you find what was wrong if you let him, he has been using this software a long time.

I bet I could tell you what is wrong if I had the files...  I support this software for a living. (have for 15 years)

 

But good luck figuring it out yourself...  I'm out.

 

Nate

 

Edited by
Discussion_Admin

 

 

 

 

 

 

 

 

 

Message 27 of 36

_Hathaway
Collaborator
Collaborator

We are trying to help you even with your replies.  We can only help you so much without your actual files.  As you have stated, you will not be supplying your files.  I am also out. Good luck.

 

Edited by
Discussion_Admin

Message 28 of 36

cwr-pae
Mentor
Mentor

"Why would I even consider that?" It would be one more piece of data to help determine what is wrong. 

 

"I have a PUBLISHED coordinate, and did you not read what I said?" Who published it? I read where you have a problem and the rant at the people who offer help.

 

You claim an error yet you will do nothing to prove the error and effects to those you ask for help.

Based on your original post and the image with it:

 

The ID command reads the current UCS, cogo points read the WCS. Hint, something differs between the current UCS and the WCS.

 

Edited by
Discussion_Admin

Message 29 of 36

Anonymous
Not applicable

Every. Single. Time.

I come to this forum, I expect intelligent responses, but every time I come
I get people asking me the most simpleton questions. Then when I
ask them to politely move along because they don't have an answer, they don't
stop, so I get a little short.

 

Edited by
Discussion_Admin

0 Likes
Message 30 of 36

tboehler
Collaborator
Collaborator

My intelligent response is to post the DWG and point file.  You would have had a solution by now.  It's just points and a txt file - pretty safe to post.

 

Edited by
Discussion_Admin

 

 

 

Message 31 of 36

rl_jackson
Mentor
Mentor
I see we are right back we're I had originally requested a drawing & point file. LOL

Rick Jackson
Survey CAD Technician VI

Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature

Message 32 of 36

Jeff_M
Consultant
Consultant

@Anonymous, at the risk of being chastised for helping you again, I would like to point out that your point issue has been solved by Mr. Jackson in message #8, and later by cwr in post 28. Notice your UCS Icon is showing that you are in a UCS which is not World. The Points were inserted correctly, as you noted the UCS has no effect on where they get inserted. However, the UCS coordinates ARE used when you use the ID command. So, place your dwg back to UCS World, then ID the point again.

 

2018-04-04_15-04-43.png

 

And then try apologizing to those fine folks who have been trying to assist you.

Jeff_M, also a frequent Swamper
EESignature
Message 33 of 36

Discussion_Admin
Alumni
Alumni

Just a reminder Smiley Sad

 

Please remember these are professional forums and as such deserve a professional decorum when participating.

Thanks
Discussion_Admin

Message 34 of 36

Anonymous
Not applicable

@Anonymous 

 

I know this is an old post, I'm reading it for the first time as i faced with the same problem. Were you able to find a solution to the issue of points being plotted in a different location???

 

Regards

 

 

0 Likes
Message 35 of 36

rl_jackson
Mentor
Mentor

Could you be a little more specific in your issue.

 

Have you checked your drawing setting to verify that your in US Survey Feet or Meters whichever the case may be...


I would recommend starting a new post regarding your issue, you'll get more quickly.


Rick Jackson
Survey CAD Technician VI

Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature

0 Likes
Message 36 of 36

Anonymous
Not applicable
Just wanted to share my solution for the problem.

In the Survey database setting, i turn the distance unit to meters and it works perfectly for me. Maybe it be that one should be in the correct drawing unit (metric/imperial) as not to conflict with the survey database which by default always load an imperial unit (inch).

Thanks a lot guy,

Cheers
0 Likes