from Civil to Inventor

The Autodesk enthusiast exile

Civil 3D – Google Earth export

image Everything in the world seems to point into Google Earth.  The problem is that we receive GE KML files coming and going.  Client’s send them to us, we send them to crews, we send them to clients and contractors.  Generally these get sent to everyone. 

I found that everyone seems to have converters for Google Map to Google Earth, Excel to GE, ESRI SHP to GE, you name it.  I bet my wife has something that will export one of her Facebook games to GE.

I figured there were numerous options when my VP asked for something to export a KML file to ascii LAT/LON, or even to UTM/SP Grid.  I think he’ll take it any way he can get it.  I know he’s looking at ME to write it in .NET, but my working with Tekni takes all my personal time, so I need to head this off quickly.

“You know it will cost you more for me to code and debug it, than if we outsourced it. “ I said, “But I know a guy  who’ll do it for next to nothing”.  Yeah… the look I was getting said he wasn’t too hip on paying anything beyond my salary.   “Ok ok, let me go online and try to find something, then we’ll talk about outsourcing”.

After searching the wrong keywords (google and Excel) for half an hour, I found this under “KML to CSV”: 

http://freegeographytools.com/2009/online-kml-to-shapefile-converter

These folks have a slough of data outputs.  You can Import the file, or paste the KML string.  It’s online PHP, and convenient.  The output formatting is a bit caste,  but very little rework will be needed.  It’s free, and there are many options, as well as other programs. 

It got me off the hook, and it might help you.

As for using GE with Civil, I still have not seen the scaling fix yet.

February 15, 2010 Posted by | AutoCAD Civil 3D | , , , , , | Leave a comment

Civil 3D – Export Group for CSO

6/25/2009

This is just an organization idea, not a revelation.  I was tired of posting problems, and wanted to post something useful.

Problem with exchanging construction data

I used to rewrite all the data out to the crews, and give them a new file.  I had to bring in the old file each time, recover all the check data for review, as well as any new control.  A genuine PITA.  I did not mind so much, but once in a while the crews would level through horizontal control, and revised elevations.  I’d miss those.  The next day was quite frustrating if they did not notice my mistake.

I decided to stop the madness by exporting only new data, and merging the data into their files.  They have 2 free ranges; 1 for control, and 1 for recollect checks.  I have 1 free range for calcs.  This way I can merge the points without worry of overwrite.  When I need the recollects, I pickup new control at the same time, so those control points show up on the calc plots.

Export Group

Each time I export the NEW data, I assign the NEW point to an export group, from which I export out of.  The trick is to use this as an organizational tool.  I have assigned sort point and label styles, and the group lies below the All Points group.

Continue reading

June 25, 2009 Posted by | 2009, 2010, Points | , , , , , , , | Leave a comment