DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Lat/Long

 
Post new topic   Reply to topic    DPlot Forum Index -> General discussion
View previous topic :: View next topic  
Author Message
Phillip Mathis



Joined: 10 Dec 2009
Posts: 21

PostPosted: Thu Aug 30, 2012 3:40 pm    Post subject: Lat/Long Reply with quote

I'm trying to overlay GPS coordinates over a Google Map similar to what is displayed on the features web page. The Lat/Longs are seperate columns and produce two seperate line instead of a blended solution. Referenced the manual with no luck. Tried XYYY and XYXY with no luck. Any suggestions?
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Thu Aug 30, 2012 4:21 pm    Post subject: Reply with quote

How are you getting this data into DPlot? It sounds like whatever you're doing that X is automatically generated, starting at X=0 and incremented by 1.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Lurking



Joined: 24 May 2010
Posts: 29

PostPosted: Sun Sep 02, 2012 3:56 pm    Post subject: Reply with quote

Using Excel, I highlight the Longitude column, then the Latitude column, and select plot xyxy.

If I'm using a third or forth axis -> Lon, Lat, Value, Value. and then the appropriate plot.

The first column you select winds up being X.
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Sun Sep 02, 2012 8:38 pm    Post subject: Reply with quote

Perhaps I'm confused, but

"The first column you select winds up being X."

is what you want if you select Longitude first. Right?
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Phillip Mathis



Joined: 10 Dec 2009
Posts: 21

PostPosted: Wed Sep 05, 2012 3:11 pm    Post subject: Reply with quote

I first tried to plot Lat as X and Long as Y. This gave me a error code (4008, I believe). I then tried time as X (got two lines as expected). The recording device records time in sexigesmal. So, I thought this format may be the problem (38:24:67.0). So, I took the decimal recorded lat /long and using a vba script converted this value to deg/min/sec(38* 24' 67" (asterix used to show degree symbol)). Still errors out. Is there a specific format the cell numbers should be in?
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Wed Sep 05, 2012 4:14 pm    Post subject: Reply with quote

Quote:
I first tried to plot Lat as X and Long as Y


That's backwards, but I can't see a reason for that to cause that particular error message.

Quote:
Is there a specific format the cell numbers should be in?


Decimal degrees only. Excel does not have a native DMS format. There are tricks you can use (see http://www.pcmag.com/article2/0,2817,1828931,00.asp, for example) to get the right appearance in Excel, but all of those involve either converting your values to text or, as in that example, modifying the numbers (which you don't want) and using a custom time format.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Phillip Mathis



Joined: 10 Dec 2009
Posts: 21

PostPosted: Thu Sep 06, 2012 1:20 pm    Post subject: Reply with quote

I was incorrect in my statement, I'm just too familar with the term Lat/Long. Thanks for the info and link. I was sure that I was doing something wrong. Fortunately, Google Earth allows the use of decimal and DMS. I was quite impressed with how the overlays turned out.

Keep up the good work!

Phil
Back to top
View user's profile Send private message
Lurking



Joined: 24 May 2010
Posts: 29

PostPosted: Sun Sep 09, 2012 12:53 am    Post subject: Reply with quote

DPlotAdmin wrote:
Perhaps I'm confused, but

"The first column you select winds up being X."

is what you want if you select Longitude first. Right?


Yes, that's the way I do it. Works like a champ.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> General discussion All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group