AutoCAD Civil 3D General Discussion

AutoCAD Civil 3D General Discussion

Reply
Member
dave
Posts: 3
Registered: ‎07-15-2010
Message 1 of 4 (373 Views)

Linking Parcels to EXCEL

373 Views, 3 Replies
04-04-2012 09:30 AM

Here's what I'd like to do:

Create a large number of polygons (plines, parcels, whatever) that represent spaces on a building plan

Assign a space number to the polygon

Link the space number to an Excel spreadsheet (or Access DB) so that the characteristics of the polygon (line and fill color, for example) are chosen based on the "owner" of the space (e.g.; Engineering, Common Areas, etc.).

Display a label stating the space number and the space name.

 

Is this best done with "Parcels" in Civ3D, or with "Polygons" in Map, or some other way.

 

Thanks.

Distinguished Mentor
thepworth
Posts: 525
Registered: ‎03-02-2011
Message 2 of 4 (370 Views)

Re: Linking Parcels to EXCEL

04-04-2012 10:15 AM in reply to: dave

I'd say polygons (polygon topology) in Map - you end up creating "centroids" for each parcel/polygon and then link the exel data (ODBC FDO connection) to Civil/Map


C3D 2011
Intel Xeon E5630@2.53Ghz
NVIDA Quadro NVS420 Dual Monitor
12GB Ram / Win7 Professional 64bit SP1
*Expert Elite*
Neilw
Posts: 2,253
Registered: ‎09-04-2006
Message 3 of 4 (367 Views)

Re: Linking Parcels to EXCEL

04-04-2012 10:22 AM in reply to: dave

You might want to consider the _ADEGENLINK command in Map.

Neil Wilson (a.k.a. neilw)
Infrastructure Suite/C3D 2013, LDT 2004, Power Civil v8i SS1
WIN 7 64 PRO
HP Pavillion h8xt, i7 2600, 12 GB
RADEON 6450, 1 GB
http://www.sec-landmgt.com
*Expert Elite*
antoniovinci
Posts: 1,660
Registered: ‎06-03-2011
Message 4 of 4 (361 Views)

Re: Linking Parcels to EXCEL

04-04-2012 10:41 AM in reply to: dave

dave wrote:

the characteristics of the polygon (line and fill color, for example) are chosen based on the "owner" of the space


All you want is easily doable in Map, but the quoted in red, unless writing Lisp code...

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.