AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Active Contributor
archaeoman
Posts: 26
Registered: ‎05-27-2013
Message 1 of 4 (3,783 Views)
Accepted Solution

Export point coordinates as .csv

3783 Views, 3 Replies
05-28-2013 04:23 PM

Greetings all,

 

My quick question id for an alternative way of exporting a cluster of points as .shp files and then manipulating the .dbf file in order to create an excel/csv file.

 

Is there another way of exporting my data as .csv or excel from Map3D?

 

Thanks in advance

Gentlemen, the OP has no shapefiles: he just wanna avoid to create them.

He has a bunch of points, from which extracting the XYZ coords to an external .CSV, period.

There are several ways to accomplish that, either internal (command _DATAEXTRACTION) and external like this one.

Valued Mentor
parkr4st
Posts: 460
Registered: ‎03-24-2004
Message 2 of 4 (3,779 Views)

Re: Export point coordinates as .csv

05-28-2013 04:30 PM in reply to: archaeoman

if your .shp is in a map, open the data table and select the records to export, options export to .csv

 

 

Mentor
Robert_Fritz
Posts: 172
Registered: ‎12-08-2011
Message 3 of 4 (3,768 Views)

Re: Export point coordinates as .csv

05-28-2013 10:50 PM in reply to: archaeoman

Hi,

 

your approach exporting as SHP is probably the quickest but Map has a feature to create  CVS files - further details in Map help - "Running a Query in Report Mode":

 

http://docs.autodesk.com/MAP/2013/ENU/filesMAPUSE/GUID-82F678B9-EF66-4E42-B281-527E339E3BD8.htm

 

Basically you need to attach you drawing with the points,

create a query

create a report

execute query

 

Report can include ac-object properties (coordinates etc.) and map object data as well.

 

Good luck,

Rob

http://raumpatrouille3d.blogspot.ch/
*Expert Elite*
antoniovinci
Posts: 1,740
Registered: ‎06-03-2011
Message 4 of 4 (3,760 Views)

Re: Export point coordinates as .csv

05-29-2013 12:54 AM in reply to: archaeoman

Gentlemen, the OP has no shapefiles: he just wanna avoid to create them.

He has a bunch of points, from which extracting the XYZ coords to an external .CSV, period.

There are several ways to accomplish that, either internal (command _DATAEXTRACTION) and external like this one.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!