Exporting cogo points with layer information & marker rotation

[mabrman]

I've tried DATAEXTRACTION, MAPEXPORT and EXPORTPOINTS for this one, but it seems like I'm looking a little more functionality.

Coming from a web-development background, I've been given a fairly complex landfill infrastructure drawing to make a GIS application where on-site people can quickly find a location by it's name on a map. (Basically google maps with search functionality) on their tablets/phones.

Ideally I'd want to make a selection of points and export them as a *.csv with the following columns:

- Northing

- Easting

- Elevation

- (RAW) Description

- Rotation (as seen in Properties of the Cogo Point, "Marker Rotation" under "Annotation")

- Layer (the Cogo point appears on)

Is this possible?

I'm thinking a LISP command might be the only way to achieve this. If someone has a good introduction for AutoLISP development a reference would be appreciated.

[Pointdump]

Hi Matthew,
Welcome to the Autodesk Forums.
Combining results in Excel from both DATAEXTRACTION and EXPORTPOINTS should give you what you want. Can you post a small sample of your drawing?
For a LISP you might try posting in the >>>Civil 3D Customization Forum<<<.
Dave

[mabrman]

I believe DATAEXTRACTION could be useful for the Cogo point Layer, however marker rotation doesn't seem to be available in there.

Do you think joining tables from DATAEXTRACTION and EXPORTPOINTS reliably left join by appending the column on the side? I don't see Point number, Northing, Easting, Elevation or Raw Description available in DATAEXTRACTION which would help connect the tables. Sounds like I'd be relying on the under the hood consistency of Civil 3d to loop through the points in the same order.

Thank you for pointing me to the Civil 3D Customization Forum.

[Pointdump]

Matthew,
Use EXPORTPOINTS to get Point Number, Northing, Easting, Elevation and Raw Description, then explode your COGO Points. DATAEXTRACTION can then grab Layer and Rotation. There's probably more sophisticated options available before resorting to LISP, like Property Sets and Project Explorer. Another option might be Dynamo. The Dynamo for Civil 3D Forum is >>>Here<<<.
Dave

[Pointdump · Accepted solution]

Matthew,
I figured out an easy way. In Point Editor choose what column headings you want to display, select all points and choose "Copy to clipboard". You can paste those into Excel and Save As a CSV file.
Dave

[mabrman]

Hey Pointdump! You found a way without LISP! That's incredible!

I followed up on your suggestion to post in Civil 3D customization forum too and got help on that end too with a simple lisp routine! Linking to it for future coders who might stumble upon this thread. 

https://forums.autodesk.com/t5/civil-3d-customization/exporting-cogo-points-with-layer-information-a...

Marking your answer as a great solution to this question as I'm sure people who don't like fiddling with code will appreciate this more.

Thank you again!