AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Active Contributor
42 Posts
3 Kudos
Registered: ‎12-18-2008
Post 1 of 4

Wondering whether 2012 Map3D is correct tool for project?

185 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*
1,795 Posts
194 Kudos
Registered: ‎06-03-2011
Post 2 of 4

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
42 Posts
3 Kudos
Registered: ‎12-18-2008
Post 3 of 4

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
525 Posts
35 Kudos
Registered: ‎03-02-2011
Post 4 of 4

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
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!