AutoCAD Arch 2014 AECC POINT data extraction

[Anonymous]

I've also posted this in the AutoCAD Arch 2014 forum but thought you guys might know a better solution.

I've received a survey file from our land surveyor. It includes AECC_POINT objects and I'm looking to extract the data so that I can import the x,y,z point cloud information into SketchUp to create a quick point cloud and terrain. I have installed the Civil 3D 2014 Object enabler for my AutoCAD Architecture 2014. I'm now able to LIST the information but only a few points come up in the command line every time I run LIST. With over 140 points this might take some time to list, copy, extract, etc.

Here is a sample of two points:

AECC_POINT Layer: "POINTS"

Space: Model space
Linetype scaling = 0.40
Handle = a01e
Text Location : (3875.36, 7787.37, 0.00)
Text Rotation :
Normal : (0.00, 0.00, 1.00)
Group Name :
Point Number : 48
Point Name :
Northing : 4775.85
Easting : 5019.43
Elevation : 5344.23 XDRef:
Raw Description : SW XDRef:
Full Description : SW
Marker Location : (3875.36, 7787.37, 0.00)

AECC_POINT Layer: "POINTS"
Space: Model space
Linetype scaling = 0.40
Handle = a01b
Text Location : (3852.68, 7800.41, 0.00)
Text Rotation :
Normal : (0.00, 0.00, 1.00)
Group Name :
Point Number : 47
Point Name :
Northing : 4776.93
Easting : 5017.54
Elevation : 5343.98 XDRef:
Raw Description : SW XDRef:
Full Description : SW
Marker Location : (3852.68, 7800.41, 0.00)

If I could just get all of the points at once I could work some Excel magic with the MID function and get the data I'm looking for and create the CSV file required to import this into SketchUp. Does anyone know how to quickly get all of the data points at once?

The main information I'm looking to extract are:

Point Number : 48
Northing : 4775.85
Easting : 5019.43
Elevation : 5344.23

Any help is greatly appreciated. I've also attached the .dwg file for your use. From what I've been reading so far maybe someone with Civil3D can help me export this information quickly with AECC COGO POINT. I'm sure I could contact the surveyor and ask him to export this data to CSV for me but it is the weekend and I would like to learn how to do this for future projects as well.

Thanks in advance for any and all help!!

[Pointdump]

B,

I used "Convert Land Desktop Points" to turn those points into C3D COGO Points. Then I exported them as a CSV file. Here ya go.

Dave

[Anonymous]

Thank you so much Dave!

I really appreciate you taking the time to convert all of those points for me. Now I can happily import these into SketchUp! I might have to learn some LISP programming to convert all the points in the future without the use of Civil 3D.