I've got a long list of borehole locations measured in station/offset along an alignment. All of these are outside of geopak (in gINT and in a basic spreadsheet). I would like to convert them to latitude/longitude, so that I'll have some greater flexibility when working with gINT and Google Earth. I'm assuming I'd first have to convert it to state plane coordinates, then to lat/long.
Anyone know how I can accomplish this? I have a basic to very limited knowledge of the geographic tools, which I'm assume would be needed in the conversion.
Thanks!
Jeff
Jeff, do you have GEOPAK? we have a conversion tool inside GEOPAK
For more information about the Road and Site design tools, visit the Road and Site design WIKI at: http://communities.bentley.com/products/road___site_design/w/road_and_site_design__wiki
I have geopak, but I am not aware of how to do the conversion. I've checked the help and I've googled, but have not found what I'm needing.
I guess I essentially need a hand-holding through this process. Sorry.
The endgame here is to export the borehole locations in lat/long back into a spreadsheet so I can use the info in gINT.
Jeff, I am an InRoads user and I have an effective workflow for me at least. Maybe it will help you or at least give you some ideas. It involves using Corpcon software to convert XY to LL. You are on the right path. First step is to convert SO data to XY. For that you need to get the SO data into geometery and use the reporting tools to bulk capture the XY data of those points. I use the inroads text import wizard when I have an extremly large number of points. You can also draw a line using an "SO=" text file. import the points to cogo or lines to alignment. You could use survey if available. Any means that allows you to use reporting tools to extract XY dat. There is other software than Corpscon to convert XY to LL. Even spreadsheets. Should not take a lot of searching to find something you can deal with. Good luck
Jody Barker Senior Highway Designer Palmer Engineering 400 Shoppers Drive | Winchester, KY 40391 DD 859 355.1541 | O 859 744.1218 | M 859 432.0622jbarker@palmernet.com
ok. do this
1. open coordinate geometry in geopak, create a new job
2. go to file > import ascii points
3. set the dialog to match your excell or ascii file. (ie. columns, point number, station offset, xyz etc)
once the points are stored in cogo (check them with the cogo navigator)
4. open geopak survey
5. go to Geometry > conversions > geodetic
6. go to file and select save to ascii
7. select your geodetic data
you can refer to the help files for more info on the individual tools and their options.
pressing F1 while the focus is on a dialog should bring up the corresponding help file
Answer Verified By: Jeff Geist
Thank you, Nico.
It gave me some output to work with. One thing of note: my boreholes, which were my Point# selection, were not all numeric, so it gave me errors in a few places.
1. Spaces are not allowed, so "PA 001" should be named "PA001"
2. Alpha characters following numeric characters weren't allowed, so PA341A used the error coding.
3. Non-alphanumeric characters were not allowed, such as "PA01-P"
I don't know if the output format of the Lat/Long (DMS vs DD) can be altered by the settings in Microstation, but I got DMS and needed DD. I opened the output file as a delimited csv spreadsheet and used a formula to convert it. Since I had to use that spreadsheet format to extract the Lat/Long info (for copy and paste purposes), it didn't really add any extra work.
Thanks again!