AutoCAD Map 3D General Discussion

Reply
Active Contributor
tjsuchoski
Posts: 42
Registered: ‎12-18-2008
Message 1 of 4 (181 Views)

Wondering whether 2012 Map3D is correct tool for project?

181 Views, 3 Replies
02-12-2012 04:30 PM

I have been tasked with setting up a new tacking program. I'm looking at possibly using 2012 Map3D.

I have an AutoCAD drawing that has over 5000 closed polylines.  The closed polylines are on multiple layers, one for each type of meter or service, and have a text address enclosed within the boundaries. 

I need to link these polylines to an excel file which has the account number and address of the lots, plus the types of meters and services associated. 

I need to be able to draw a polyline around an area and be able to generate a list or report with the number and type of all of the meters or services within the area.  Is that possible?

Any suggestions on how to proceed would be appreciated!


Civil 3d 2011 or 2012
Quad Core Intel
Windows 7 x64
8GB RAM
*Expert Elite*
antoniovinci
Posts: 1,594
Registered: ‎06-03-2011
Message 2 of 4 (170 Views)

Re: Wondering whether 2012 Map3D is correct tool for project?

02-13-2012 12:38 AM in reply to: tjsuchoski

tjsuchoski wrote:

I need to link these polylines to an excel file which has the account number and address of the lots, plus the types of meters and services associated. 


Well, if the text addresses contained in the closed plines are identical to that field in Excel, you can join them via ODBC (it works on my Map2006, I hope in yours too...)

 

 

tjsuchoski wrote:

I need to be able to draw a polyline around an area and be able to generate a list or report with the number and type of all of the meters or services within the area. 

 

One way is to _MAPEXPORT by selection to a shapefile, then you play with the generated .DBF file in Excel, or in other Gis tool. 

Active Contributor
tjsuchoski
Posts: 42
Registered: ‎12-18-2008
Message 3 of 4 (160 Views)

Re: Wondering whether 2012 Map3D is correct tool for project?

02-13-2012 06:51 AM in reply to: antoniovinci

OK, I figured that the ODBC option would be the way to start.  But the excel file has multiple meters or services for some polylines and only one for others.  Will map address these?

 

 

Also, can I use a map query to collect the information for the bounded area and then export it to a csv text file?


Civil 3d 2011 or 2012
Quad Core Intel
Windows 7 x64
8GB RAM
Distinguished Mentor
thepworth
Posts: 525
Registered: ‎03-02-2011
Message 4 of 4 (116 Views)

Re: Wondering whether 2012 Map3D is correct tool for project?

02-15-2012 07:49 PM in reply to: tjsuchoski

Q1:  Yes, if you look at the procedures for "creating a join" you have options for either one-to-one or one-to-many matching from primary (left) and secondary (right) tables. 

 

Q2: yes - you can query by property or "locate on map" by either a predefined or within-command defined polygon and export the results to a .csv


C3D 2011
Intel Xeon E5630@2.53Ghz
NVIDA Quadro NVS420 Dual Monitor
12GB Ram / Win7 Professional 64bit SP1

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