Pages

Total Pageviews

Friday 2 December 2016

AUTOCAD to GIS Headache

Source : Autodesk community forum

Recently, I was facing challenges in converting AUTOCAD Drawing files (.dwg) into useful shapefiles for both my work and (my own consultancy projects).

It is known that some organizations have GIS files for small scale sites while their engineering teams keep the large scale plans of the sites. Hence, there is an issue where the management is not able to see the big and the small picture of their assets.

Secondly, not everyone knows how to relate AUTOCAD plans to their daily life. They would like to see their site in a user friendly format (i.e. Google Maps, Google Earth).

Now we have looked at potentially scenarios, we need to ask ourselves what we should be prepared for when conversion of AUTOCAD to a GIS software (i.e. ArcMap). Below here are the things to be considered:
  1. Is your file in dwg or dxf file format? 
  2. Do you know the projection of the AUTOCAD drawing is done?
  3. Are you potentially aware that conversion will only bring spatial drawings (not the attributes)?

1. DWG or DXF Format?

.dwg file is native format for AUTOCAD. A .dxf file is interchangeable format of AUTOCAD product.

In ArcMap, one can freely add dwg file and all the layers (including attribute annotation) will come out. You can save them as a shapefile. 

For QGIS, it will ONLY open a .dxf file. How can I convert .dwg to .dxf file? Refer to this article here for the procedure

2. Projection Issue

Everyone should realise one thing about conversion of AUTOCAD file to GIS file - there is no projection for the exported data. None at all!

How can I find the projection of AUTOCAD file. One is to open the dwg file on A360 Viewer. If you look at the survey plan, the mention of coordinate system or projections would be located at one of the corners of the plan.

If no (which I have encountered), please contact the source and obtain the projection name from the client or the surveyor.

Once we identified the name, we need to incorporate this projection to the GIS file. How?

QGIS

When you open the .dxf file or converted shapefile (adding vector), the system prompts you to add the coordinate system. Input the projection name and apply to all layers of AUTOCAD that is to be migrated into QGIS.

ArcGIS

In the case of ArcMap, the process is bit more complex. Bring the dxf file or converted shapefiles as unprojected files. Ignore all the error message. To ensure the shapefiles are to have the correct projection, we are going to do vector georeferencing. Vector georeferencing only works if the survey plan (AUTOCAD file viewed on A360) has coordinates marked on it or you find equivalent coordinates on another system.

To activate vector georeferencing, you must use Spatial Adjustment. When I was made aware of it by ESRI support, it worked wonders. Refer to the video below on how to use the tool.

3. Attributes?

While I do not have clear answers on this, it is important for you to be aware that conversion of AUTOCAD files to shapefiles WILL NOT BRING attributes (names, heights, feature types). If the file has limited attributes, one can manually add them as separate columns to the shapefiles (which I have done before).

However, if there are many attributes, I would like to hear your answers on bringing attributes effectively during the conversion.

Hope it helps!







9 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Interesting read. How about "AutoCad dwg" to XML and XML to GIS? I believe it comes with attributes (but ETL such as FME is required), many LGs in Australia are doing it.

    ReplyDelete
    Replies
    1. The article was meant for those who have limited financial capacity to purchase FME. For me, buying FME should not be confined only just converting files - it is expensive resource with a case needed. I have no idea on how to do DWG to XML to GIS? Have you done that approach before? Thanks for your input

      Delete
  3. I know the projection of all *.dwg files that I open in ArcMap. I usually just add the polyline or point layer (ignore the warning about no projection). Then I right-click on the layer and select "convert to feature dataset". The tool requires you to browse to an existing file geodatabase and to select the projection. All feature attributes are visible. If you really want shapefiles you could save each of the feature dataset layers as shapefiles. I have the standard version of ArcGIS, unsure if this tool is available with the basic licence.

    I also use QGIS and from memory, yes it did drop the attributes.

    ReplyDelete
    Replies
    1. Hi Emma, I will give a go on the ArcMap option you mentioned and inform you the update. Will do another round of testing in QGIS

      Delete
  4. A free to download full featured CAD is DraftSight, which can be used convert DWG to DXF: http://www.3ds.com/products-services/draftsight-cad-software/

    ReplyDelete
  5. Simple answer would be "ask a favour at your friend with access to AutoCAD Map3D"

    ReplyDelete
  6. In Vietnam, this is becoming increasingly popular. So, a salient feature of Vietnam’s software development services is that they are cost-effective. Low quality and reasonable price without compromise. You can find experienced dedicated software development for your needs.

    ReplyDelete