Solutions Export Format
Posted By Jeff Austin on 9/15/2001 at 10:03 AM

In Solutions 2.5, is there any way to modify the export "format" of the lat, long values? It seems I can get:

DDD MM SS.ss
or
DDD°MM'SS.ss"

but I need

DDD.MMSSss

Any suggestions greatly appreciated.

-Jeff
Modified By Jeff Austin on 9/15/2001 at 10:48 AM

Re: Solutions Export Format
Posted By Richard Phelan on 9/15/2001 at 3:29 PM

Hi:

Solutions 2.50 does not support the export of Latitudes and Longitudes in the format you are requesting -- example:

-121.5959517

(which would correspond to -121 degrees 59 minutes 59.517 seconds West longitude)

What software package requires this input format?

I will pass this along to the Project Manager as a possible future enhancement of Solutions.

Best regards,
Richard




Perhaps...
Posted By Mike Margolis on 9/15/2001 at 3:50 PM

he could make a comma delimed ascii file and then make the changes in Excel, then export. Not easy, but possible.


Re: Another workaround
Posted By James Webb on 9/15/2001 at 4:17 PM

in an ascii file import it into wordpad...search for ° replace with .
search for ' replace with nothing search for " replace with nothing save back out as ascii file.

Jimbo
Modified By James Webb on 9/15/2001 at 4:18 PM

Re: Solutions Export Format
Posted By Jim Frame on 9/15/2001 at 4:29 PM

Richard Phelan wrote:

On the subject of output formatting, I'd also like to see an option for decimal degrees. California's GeoTracker database (a statewide repository for groundwater monitoring data) requires NAD83 lat & long in decimal degrees format, and it would be very handy to be able to do the conversion in Solutions rather than having to resort to an external program.




Re: Solutions Export Format
Posted By Richard Phelan on 9/15/2001 at 5:19 PM

Hello:

Solutions 2.50 allows our users to export latitude and longitude in decimal degrees in 2 different formats:

DDD.d with up to 10 decimal places

DDD.d° with up to 10 decimal places


We welcome your input on these issues.


Richard


Re: Solutions Export Format
Posted By James Webb on 9/15/2001 at 7:53 PM

After thinking about it, if u use the wordpad method you need to search for . first so that the decimal seconds do not contain the .

Jimbo


Re: Solutions Export Format
Posted By Jeff Austin on 9/16/2001 at 9:58 AM

Thanks for the suggestions. I had been using TextPad to do the search and destroy routine Jimbo describes, but true to the nature of a surveyor, I was looking for an easier way. :)

I use Microsurvey that allows one to import an ASCII lat-long file and convert it to almost any coordinate system for use in the ortho environment. In WI we are blessed (?) with a local coordinate system for each county, so I was thinking it might be simpler to keep everything geodetic in Solutions and use MS to convert to the given coord system. I guess I could setup a "local grid" in Solutions as well.

Thanks again for the input.

-Jeff