Object Table Creation

[charles.langdaleUEXEH]

I'd like to create a table with object data for parcel information adjacent to my subject parcel.  The way I've been doing it is by following this very helpful video, but I feel like I'm missing something and taking the long way to do this.

My steps right now:

• import a shape file from county gis site
• MAPEXPORT a different shapefile that just has the object data fields I want to display
• Drag THAT shapefile into the drawing
• Right click on the newly created map features and click "show data table"
• Copy this into an excel sheet, modify as necessary, then data link back in with a table

Is there a way to create a table for display from the object table data instead of the "show data table" in the map feature?  Ideally I'd like to import the GIS as polylines, select the ones I want and then create a table that displays the attributes that show up down at the bottom of the properties pane "OD:Parcel" or whatever the table name is.

Thanks for your help!

[brian.strandberg]

Take your polylines and turn them into Parcels.  They really should have a command "Create Parcels from GIS data".

I would use the MAPIMPORT command, make sure you specify limits to your data (don't import entire county), and check the box to import as closed polygons.  

You can then easily create those into Parcels and label them as needed.

[Pointdump]

Hi Charles,
Welcome to the Autodesk Forums.
Instead of drag-n-dropping the modified shapefile into your drawing, use MAPIMPORT which will convert Map Features to AutoCAD linework. Then you can modify the OD Table.

Dave

[charles.langdaleUEXEH]

Thanks for the reply.  Once I have everything in, how do I display the OD table? For exapmle, if I wanted to have a table showing Parcel ID, Owner and Deed Book, is there a way to create a table showing these attributes? 

[charles.langdaleUEXEH]

Thank you for the reply. So once I have the parcels created, how would I create a table showing that GIS data?

[Pointdump]

Charles,
Use Command ADEDEFDATA to access your Data Table.
Dave

[charles.langdaleUEXEH]

Perfect, thanks. Is there a way to display this table? My end goal is to have an actual table displaying this information on the map.

[charles.langdaleUEXEH]

I think I've got it to a pretty quick workflow.  I MAPIMPORT the GIS data, then MAPEXPORT and select the parcels I want.  From there I can drag and drop the .dbf created from the MAPEXPORT into a blank excel book and then data link that back into the drawing.

I always have to clean up the data from the GIS anyway, so the step I was trying to bypass by just creating a table for display from the object data table won't work anyway for this application. Thank you guys for your help. 

[ChicagoLooper]

Hi @charles.langdaleUEXEH 

You can still streamline your workflow.

1. Use MAPIMPORT to convert from ESRI shapefile parcels to AutoCAD linework.
2. Drag-and-drop the same parcel shapefile from Windows folder to modelspace, then open the Table view of the newly added parcel shapefile.
3. With the parcel Table open, highlight all rows and columns then right-click and Export to csv format. (If you wish, you can open csv in Excel and perform a Save As to xlsx format).
4. Delete the shapefile from modelspace (right-click shapefile in task Pane then select 'Remove'). 

[charles.langdaleUEXEH]

That definitley does work, the issue I have is while I can control the area to bring in with the MAPIMPORT, when I drag and drop the the same parcel shapefile, it brings in the entire county.

So I'd have to export the parcels that I filtered through from the initial MAPIMPORT, then drag and drop that new smaller shapefile back in, right?

From there, I didn't realize you could export to a csv from the parcel table (I've been copying/pasting), that is very helpful.

[ChicagoLooper]

@charles.langdaleUEXEH wrote

<<.....when I drag and drop the the same parcel shapefile, it brings in the entire county....>>

OK, understood. You don't necessarily have to bring in the whole county. You can limit the 'area' of the shapefile to a smaller subset of parcels by capturing only the parcels you need. Here's a better workflow

1. Before you bring in your parcels using the DATA CONNECT PALETTE, draw a rectangle surrounding your area of interest making sure your target parcel(s) is somewhere near the center of the rectangle. Make this rectangle RED (or any other color) so it stands out against the shapefile parcels you are capturing. Make this rectangle slightly bigger (taller and wider) than than what's displayed in your viewport (I'm assuming you print from a Layout Tab) so the final print area inside your VP doesn't have 'empty white space' due to an inadequately sized rectangle.Image-1
2. In the Data Connect Palette, instead of clicking 'Add to Map' click the dropdown and select Add to Map with Query.Image-2
3. Next, in the Create Query window that pops up, do this.Image-3
4. Next, go to command line and choose SELECT.Image-4
5.  As soon as you choose Select, you'll return to modelspace and your cursor will be a small square instead of crosshairs. Using your cursor, Click directly on your Red Rectangle using your cursor.Image-5 
6. Back in the Create Query window, AutoCAD will write the EXPRESSION that corresponds to the polygon you clicked, or your Red Rectangle. The expression will be in blue text. View but don't edit the expression. Click the OK button.Image-6
7. The result will 'limit' the shapefile to a smaller subset of parcels. Parcels that are entirely 'inside' the Red Rectangle are captured and parcels that are only partly 'inside' are captured too. Parcels that are completely outside the rectangle are ignored. If you draw your rectangle big enough, your Layout Tab's viewport will display parcels that 'fill up' the VP's view.Image-7