Help With Lat And Lon Excel Into Carlson ?

Paul,

I have a utility I wrote to do conversions from DD.MMdddd or DD MM.ddddd to DD.MMSSdddd
If you send me the xls I'll convert it.

Thanks,
Terry

> A Forestry student has a project underway and located 200 trees with GPS. He has Lat/Lon Degrees Minutes.minutes currently in an Excel spreadsheet. What is the best way to convert all to SPC PA South?
>
> Also is there a direct import of Lat/Lon into Carlson Survey 2004?

I'm not sure if all of the functionality is in Carlson 2004 but would think you'd be able to accomplish this with the following process:

1. Use the spreadsheet to convert the Degrees Minutes.minutes to either ddd.dddddddd or ddd.mmssssss.
2. Use the Points -- Import Text/ASCII file routine to bring this list of lat/longs into an empty CRD file.
3. Use the Points -- Coordinate File Utilities -- Coordinate Transformation command with the following options:

You should then be given an option to specify the desired input/output parameters to generate SPC PA South.

4. Use the Points -- Draw-Locate Points or the Survey -- Draw Field-to-Finish routine to place the CRD entries onto the screen.

Thanks Ladd. Second Question ?

It works in Carlson Survey 2004, so very many thanks for the lesson.

I created an ascii file with points 1 and 2, and then separately transformed each to 11 and 12. See below:

"List Points Report 11/25/2012 14:45
File> C:Program FilesCarlson Software 2004WORKLat-Lon.crd
Job Description>
Job Number> 0.000 Job Date> 2012.1125
PointNo. Northing(Y) Easting(X) Elev(Z) Description
1 39.9000 74.6000 100.000 dd.dd
2 39.5730 74.5330 101.000 dd.mmss
11 222189.943 2852116.849 100.000 dd.dd to SPC
12 240645.317 2769642.843 101.000 dd.mmss to SPC
Number of points listed> 4"

QUESTION?

Point 1 is 74.6000° = 74°36'00"W and is East of 2 at 74°53'30"W.

I would have thought that my Easting in Lon format should have been negative?

Not complaining we can make it work either way, but did I miss something?

Paul in PA

CORPSCON Batchfile Lat And Lon To SPC ?

I have used CORPSCON but not in batchfile mode.

Any hints or is it simple and straightforward?

Looking for a check to the Carlson transformation.

CORPSCON or an Excel macro would do?

Paul in PA

I "googled" to find an old Chinese proverb - "Give a man a fish and he will eat for a day. Teach a man to fish and you feed him for a lifetime."

With that in mind, my suggestion is to get a copy of "NOAA Manual NOS NGS 5 - State Plane Coordinate System of 1983." It is available from NGS.

Anyone conversant with Excel should be able to develop their own conversions and establish "ownership" of the process. Yes, it takes more time initially, but future dividends will be enormous.

That is a 2-D solution based upon 3-D measurements - why throw away 1/3 of the data? The global spatial data model (GSDM) provides a way to get the needed answers without discarding valuable information - for more information, see http://www.globalcogo.com

Lat And Lon To SPC Is 2D To 2D

A mapping grade GPS reciever was used, elevation was not collected.

I am fairly certain from personal experience that available topographic contours from recent LIDAR would be more accurate that any mapping grade GPS.

While this student may be well capable of what you suggest, it is not my job to burden or discourage him.

Paul in PA

Lat And Lon To SPC Is 2D To 2D

You make valid points.

I remain convinced:

1. A portion of the value in our data is not being recovered or used.

2. Inquiring minds should be encouraged to learn and "take ownership" of the process.

Lat And Lon To SPC Is 2D To 2D

> You make valid points.
>
> I remain convinced:
>
> 1. A portion of the value in our data is not being recovered or used.
>
> 2. Inquiring minds should be encouraged to learn and "take ownership" of the process.

:good: :good: