In civil engineering jobs, local coordinate systems like mine grids and council grids can be a real headache. Transforming data between them is an ongoing headache throughout the life of that project.
This little cheat will help you create a custom Coordinate System that will allow you to transform data easily in both QGIS, Civil 3D and Infraworks.
Any questions hit me in the You tube comments or this blog post below.
Nice! Well done video. The QGIS Plug-in makes it easy. You can also get Affine Parameters in Excel using Matrix Algebra.
Please post this in the Civil 3D Forum.
Yeah, i used to use a python script that generated a proj4 CRS, but i never had to do it very often. Most of the time the surveyors on site provided the affine parameters. But it seems fewer and fewer sites still have surveyors around that know what they are doing. Sites are just paying for drone surveys and calling it a day.
P.S I always sucked at matrices… :p post an excel sheet if you got one.. im curious.