Hello everyone,
I've recently encountered some problems concerning the import of information from the attribute table - as available to see and edit in ArcGIS or QGIS - to AutoCAD.
I have been provided with a set of geodata that stores information about trees in various attributes. As a good geodataset should, these information are linked to their visual representation via the coordinates. What proves to be challenging is cloning the QGIS functionality and usability of the dataset so that it could be accessed in AutoCAD in a usable way.
I am aware of the method involving the conversion of .shp file into .dxf, but that does not quite do the trick for me, as it only converts a geometry into some other sort of geometry, while all the information linked to the original geometry (stored in a separate .dbf file) is lost.
I have also tried to export the .dxf in QGIS, but the result is similar.
The way I intend for this to work would be to have the original features from the .shp as the blocks in the .dxf/.dwg file, so that the attributes from the .dbf could then be linked to the attribute definitions within these blocks. I expect it to be possible to link both sets of data via the common piece of information, which is a set of X an Y coordinates in this case. While I can see the path to make it work, I yet lack the technical skills to implement the solution.
Please note that the software used in this process can be limited to QGIS and AutoCAD 2023 (that sadly does not support "map capable" utilities) and potentially Civil 3D. However, if there is a simple solution involving some other software or perhaps a LISP routine that does exactly the expected thing, feel free to share it as well.
I attach a sample dataset in case it was of any use.
Solved! Go to Solution.
Solved by p.piszcz. Go to Solution.
Solved by Pointdump. Go to Solution.
You need to use AutoCAD Map 3D. It is Autodesk's GIS app. It can read gis data (shp, dbf) directly. You can get access to all the metadata. Go to magage.autodesk.com/products and install Map 3D.
That's what I'm trying to tell you. That's exactly what Map 3D does...in a dwg. Map 3D is a free toolset add-on to AutoCAD. And if you choose, once you read the data into the dwg, you can convert the map geography (lines, points, polygons) into AutoCAD objects.
If for some reason you cannot upgrade to AutoCAD Map3D, DotSoft has an add-on that will add the capabilities you seek to vanilla AutoCAD
Hi Przemysław,
Did you click "Create Object Data" when you used MAPIMPORT?
Dave
Dave Stoll
Las Vegas, Nevada
Hi again,
I tried your solution and although I almost see what I would like to see, I am not quite satisfied yet.
In AutoCAD Map 3D I have been able to attach data to objects, and that data has then been displayed in the properties as Object Data. However, when I tried outputting it to DWG and then opened it in regular AutoCAD, the OD column disappeared. I suppose that the link between geometry and the data is still managed by Map 3D and is lost once opened in another context.
What I am after is the way to cement that link, so that each piece of data is hard-assigned to a piece of geometry and is still there when I open it in AutoCAD. I sifted through several threads in the Forum and the Knowledge Centre and I am beginning to doubt that my objective is even achievable. That said, I am deeply grateful for your input so far. If you still have some ideas, be sure to share it nevertheless.
Przemysław,
"...opened it in regular AutoCAD, the OD column disappeared."
Yes. Object Data only happens in Map 3D and Civil 3D.
"...is still there when I open it in AutoCAD."
The only way I can think of to do this in Vanilla AutoCAD, without 3rd party add-ons like DotSoft MapWorks, is to add the OD as attributes to blocks. Like >>>This<<<.
Dave
Dave Stoll
Las Vegas, Nevada
Thanks again for all the replies. I seem to have found the working solution for my problems, so I thought I should summarise the thread.
The solution posted by Dave is a very creative one and utilises little resources. I imagine it being very universal, and by that I mean only AutoCAD is required and even with no access to Excel, some online spreadsheet editors can be used instead.
During my search I also found the following thread which involves a bit of a workaround solution. Note that even the original question there was concerning Civil 3D, both the problem and its solution can be applied also to AutoCAD Map 3D, as they both offer the same set of commands that are used here.
Finally, by following the solution above I stumbled upon yet another youtube video with a solution that I find really elegant, with a potential of standardising the blocks and their labels.
Cheers everyone!
Can't find what you're looking for? Ask the community or share your knowledge.