AutoCAD Civil 3D General Discussion

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

Linking Parcels to EXCEL

357 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 (354 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,224
Registered: ‎09-04-2006
Message 3 of 4 (351 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,600
Registered: ‎06-03-2011
Message 4 of 4 (345 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...

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

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 to get help installing your software.

Ask the Community


Civil 3D Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for AutoCAD Civil 3D helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Civil 3D

Twitter

Facebook

Blogs