View previous topic :: View next topic |
Author |
Message |
Phillip Mathis
Joined: 10 Dec 2009 Posts: 21
|
Posted: Thu Aug 30, 2012 3:40 pm Post subject: Lat/Long |
|
|
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 |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2311 Location: Vicksburg, Mississippi
|
Posted: Thu Aug 30, 2012 4:21 pm Post subject: |
|
|
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 |
|
|
Lurking
Joined: 24 May 2010 Posts: 29
|
Posted: Sun Sep 02, 2012 3:56 pm Post subject: |
|
|
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 |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2311 Location: Vicksburg, Mississippi
|
Posted: Sun Sep 02, 2012 8:38 pm Post subject: |
|
|
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 |
|
|
Phillip Mathis
Joined: 10 Dec 2009 Posts: 21
|
Posted: Wed Sep 05, 2012 3:11 pm Post subject: |
|
|
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 |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2311 Location: Vicksburg, Mississippi
|
Posted: Wed Sep 05, 2012 4:14 pm Post subject: |
|
|
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 |
|
|
Phillip Mathis
Joined: 10 Dec 2009 Posts: 21
|
Posted: Thu Sep 06, 2012 1:20 pm Post subject: |
|
|
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 |
|
|
Lurking
Joined: 24 May 2010 Posts: 29
|
Posted: Sun Sep 09, 2012 12:53 am Post subject: |
|
|
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 |
|
|
|