Data Extraction - Line Geometry and Handle/Object ID

[Schwinn.Zhang]

Hi, 

I am trying to extract information for over 100 line objects:

1. Geometry
   • Start & End Coordinates
   • Length
2. Some sort of identification
   • Handle, or 
   • Object ID, or 
   • A user-defined ID would be the best

The ultimate goal is to generate a spreadsheet with the geometry information and a used-defined ID for each line.

I am currently putting user-defined ID in a Property Set. But I realized DATAEXTRACTION only gives me geometry, and EXPORTPROPERTYDATA can give me Handle/Object ID/user-defined ID. So I am trying to find a way to link the data exported from these two ways.

I do notice that Line Length can be exported using both ways so maybe that could be my linking parameter. If two lines have exactly the same length, I just need to check these objects individually. 

Is there other or better way to do this? 

Thanks in advance.

[samir.rezk · Accepted solution]

Hi @Schwinn.Zhang 

One way is to export it to SDF then copy the AutoCAD Map Data Table to Excel:

1. Start the MAPEXPORT command
2. Select all the AutoCAD LINE objects
3. Go to the Feature Class tab
4. Click the Select Attributes button
5. Checkmark the desired properties to attach to the geometry
6. Then open a new blank drawing
7. Drag and drop the SDF in the model space
8. Select one feature, right-click and select Show Data Table
9. Select all to copy/paste in Excel

see attached video for demo of workflow, Hope this helps,

[Pointdump]

Hi Samir,
Good job on the video!
Dave

[Schwinn.Zhang]

Thank you much Samir! It solved my problem perfectly.