Export points to site

[rdavisMX6RG]

Hi,

I am VERY new to civil 3D so learning on the fly...

I have a 10x10 grid with spot elevations shown, relative to a reduced level surface.

I need to get this to site so as they can strip the ground to the levels noted.

What is the easiest way to get this over to the lads on site so as they can input the data in?  .csv file?

If so, how is this done?

Any help appreciated.

Thanks in advance

[Pointdump]

Hi Ray,
Probably best to ask the folks doing the grading. Are they using machine control GPS?
Dave

[Joe-Bouza]

right clicking the point group in the prospector gives you export options

[rdavisMX6RG · Accepted solution]

Hi,

Thanks for the response.

I got it sorted by:

Select all spot levels and isolate in .dwg.

Explode (x2) to make basic MText.

Make WBlock out of text.  (Include CAD Map info in report=NO)

Close main C3D .dwg

Open new .dwg and insert wblock.

Under Home=>Palettes, select map task pane (On)

Drag WBlock into Map Explorer tab. Zoom extents to confirm dwg into in wblock ok.

Under Query library, select Current query

Select Define: confirm location = ok.

Property => confirm layer properties set.

Under query mode select Report & options.

Here select MText and add X, Y & Z values for text.

Output file name as .txt file.

Open excel and .txt file from above.

Save as .csv.

Surveyor opened file in .dxf and all info there.

(It was a video in spanish by Mr. Rivero - I don't speak the language but his process was very clearly shown.)

There has to be an easier way to do it but only learning the package, and loads of people shouting for the data yesterday, so quick fix to get me over the line)

[tcorey]

Exploding the COGO points was your first mistake. Read about Point File Format and how to export COGO Points to a file. Once an appropriate Point File Format is identified, you can create your CSV in thirty seconds. One step.

[sboon]

Reading the original post, I'm not sure that he had cogo points.  It may have been elevation labels, which would not work with the advice posted so far.

[rdavisMX6RG]

sboon,

Correct, I had elevation labels from a 10x10m Grid on a surface.

Surely there has to be a cleaner way to export label elevations than the way I did it so as they can be used on site.  

Thanks for the reply.

[sboon]

Create cogo points on top of the labels and export those.

https://knowledge.autodesk.com/support/civil-3d/learn-explore/caas/CloudHelp/cloudhelp/2017/ENU/Civi...

[tcorey]

Yeah, I mis-read that. 

[Pointdump]

Hi Ray,
"There has to be an easier way..."
Well, maybe. Can you post your drawing?
Dave

[ChicagoLooper]

@rdavisMX6RG wrote

<<…Under query mode select Report & options. Here select MText and add X, Y & Z values for text…>>

When you say 10x10 grid, do you mean horizontal & vertical lines, like graph paper? Your method works but you need to verify the INSERTION POINT of the mtext.  The x and y values must coincide with the the 10x10 grid. If the insertion point is offset, and I’m not saying it is, then the x,y’s will be off and that means the field work won’t be accurate.

Your query reports the x,y values of the mtext which is where the mtext itself is position in modelspace and that may, or may not, be the same as the intersection of those horizontal and vertical lines. Jus sayin.  

[rdavisMX6RG]

Chicago Looper,

It was a grid I put on via the "Spot Elevations on grid" command to the surface. The .dwg is geo referenced "ITM local system here" so insertion point is typical.  I know what you mean, when we get architects dwgs in that are scaled up to millimeters if plays havoc with us....

I had to do another site yesterday, same idea, used same process and it worked a treat for him too.

If I discover another method that's quicker I'll be back 🙂

[ChicagoLooper]

@rdavisMX6RG wrote in post #4

<<...Select all spot levels and isolate in .dwg. Explode (x2) to make basic MText...>>

Okay.......so what is the insertion point of the basic MText after exploding.

[rdavisMX6RG]

When the MText is exploded, you must make a WBlock out of it. The insertion pt of the WB is 0,0,0.

When this is dragged into a new blank dwg, to continue this process, it defaults to 0,0,0 so the geo-reference will be the same.

[ChicagoLooper · Accepted solution]

@rdavisMX6RG wrote on post #12

<<It was a grid I put on via the "Spot Elevations on grid" command to the surface....>>

That's from the Annotate Tab=>Labels & Tables Panel. There’s a better tool for the job. 

You don't need to explode.
You don't need to make a block.

You don't need to use a secondary drawing.

You can use this:

Here's a >>VIDEO<< that demonstrates how to create a grid on a surface with elevations. It demonstrates how to create cogos points based on your grid. You can customize your grid basepoint, x-distance spacing, y-distance spacing and grid orientation. You may add the the cogos to a point group. You may even export the points to an external file such as txt or csv.