If you are familiar with the coordinate systems in Civil 3D, you may be aware that the transformation tab allows you to transform a local coordinate system to a known coordinate system. In other words, Ground (project coordinates) to Grid (known coordinates). Now, how does this tab affect bringing survey data into the survey database? Well, it all depends on where the data is coming from.
<begin disclaimer>I am not a surveyor nor do I pretend to be one on TV. I’ve just learned a lot about this stuff in recent years. I’m by nature an engineer and engineers aren’t allowed to play with survey data so everything I have, I made myself.<end disclaimer>
So what happens when you have transformations set to your drawing and you import survey data from a point file? Well, point files typically don’t have coordinate systems assigned to them (can they ever?). When using the import survey command, the points come into the database as if they were collected using the same coordinate system as the survey database. Since I live in Colorado, I’ll use NAD83 Colorado State Planes, North Zone, US Foot as the coordinate system. I create a point file that has the following points in it:
2,50016.9791,40018.2566,100.0000,GS
3,50053.5856,40023.9971,100.0000,GS
4,50068.3375,40063.0876,100.0000,GS
5,50060.6884,40110.9256,100.0000,GS
6,50012.0618,40132.2476,100.0000,GS
7,50002.7736,40084.4096,100.0000,GS
8,50036.3751,40087.9633,100.0000,GS
9,50036.1019,40056.5269,100.0000,GS
10,50082.2699,40017.9832,100.0000,GS
11,50102.7586,40075.3888,100.0000,GS
12,50104.9441,40162.5906,100.0000,GS
13,50039.9265,40165.3242,100.0000,GS
14,49981.1921,40022.0836,100.0000,GS
15,50051.4002,39978.8927,100.0000,GS
The survey database has the same coordinate system as the drawing, NAD83 Colorado State Planes, North Zone, US Foot and has a very simple transformation assigned to it. Basically, it will translate the ground coordinate N=40,000 E=50,000 to the grid coordinate N=1,040,000 E=3,050,000.
When the point file is imported into the survey database, the points are brought in and the transformation settings in the drawing are not honored. I don’t know exactly why but, this is my theory on what is happening. When you bring the points directly into the survey database, they don’t come into the drawing and then into the database, they are brought directly into the database from the point file bypassing the drawing altogether. Since the point file has no coordinate system (yet alone a transformation setting), they are simply brought directly into the database.
As you can see, the points coordinate match the points in the point file and do not reflect the transformation settings. If you need the points to honor the transformation settings, import the points into the drawing first, and then import the points into the survey database from the drawing. Since the points are in the drawing, the settings of the drawing will be used and the points will be transformed as they are brought into the database. In this image, you can see that the points in the drawing are in the project coordinates:
And after the points are brought into the survey database, they are in the known coordinate system:
Hopefully, this will help clarify some of the mystery of the survey database.



December 31, 2009 at 9:14 am
In response to your question about a point file having a coordinate system, I know that a CSV or plain TXT file cannot have an assigned system. But a FBK, Trimble DC or Carlson RW5 file can have a coordinate System assigned. the trick is get your Surveyor to code the points in fieldbook style or setup the linework codesets in Civil 3D to accept raw data from 3d party add-ons from Trimble, and carlson
December 31, 2009 at 9:57 am
Thanks for the info Andy. That’s kind of what I thought. So a basic point file can’t have a coordinate system but a survey file can. Based on this, I would assume the data collector software would be able to convert the survey data to a point file in the necessary coordinate system.
January 19, 2010 at 8:12 am
Brian
that is correct, the improtant thing is to make sure the survey file, the survey database, and the drawing units and coordinate systems are all the same when you import the file. If you need to doa translation or coordinate zone shift you can then do it afterwards. I hope this helps