shrug-l: Excel, Time formats and ArcGis
McClean, James
James.McClean@dep.state.fl.us
Thu, 15 Apr 2004 14:03:48 -0400
This is a multi-part message in MIME format.
------_=_NextPart_001_01C42314.0018369A
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
All, Can y'all help a fellow out of a deep funk? The issue is tab =
delimited
GPS files saved as .txt files. I download the files from a Garmin =
GPSmap168S
using Garmin's Mapsource, which exports the .txt file. My process is to =
open
in Excel; filter, format, apply decimal degree formulas... and export to =
.dbf
files for import to ArcGis 8.3. =20
In the past I have defined the Time stamp field as text when
importing to Excel, then it carries over to .dbf with the time info as =
human
readable text. However, sometimes I need to use the time stamp for =
charting,
filtering etc. Excel will not recognise the text field as a time =
value, so
I cannot use it as a chart variable, nor can I use it to categorise =
values in
ArcGis. Any ideas on how to have my cake and chart it too? Will gladly
summarise on list the best solutions. Cheers, =20
=20
James McClean
Environmental Specialist
=20
Florida Geological Survey
903 W. Tennessee Street
Tallahassee, FL 32304
=20
Phone: (850) 487-9455 ext 164
Fax: (850) 488-8086
Mobile: (850) 339-5294
=20
------_=_NextPart_001_01C42314.0018369A
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:"Times New Roman";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt'>All, Can y’all help a fellow out of a =
deep funk?
The issue is tab delimited GPS files saved as .txt files. I =
download the files
from a Garmin GPSmap168S using Garmin’s Mapsource, which exports =
the .txt
file. My process is to open in Excel; filter, format, apply =
decimal degree
formulas… and export to .dbf files for import to ArcGis 8.3. =
</span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt'> &nbs=
p; In the past I have defined the Time stamp
field as text when importing to Excel, then it carries over to .dbf with =
the
time info as human readable text. However, sometimes I need to use =
the time
stamp for charting, filtering etc. Excel will not recognise =
the text field as
a time value, so I cannot use it as a chart variable, nor can I use it =
to
categorise values in ArcGis. Any ideas on how to have my cake and =
chart it too?
Will gladly summarise on list the best solutions. Cheers, =
</span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt'> </span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt'>James McClean</span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt'>Environmental Specialist</span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:10.0pt'> Florida Geological =
Survey</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:10.0pt'> 903 W. Tennessee =
Street</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:10.0pt'> Tallahassee, FL =
32304</span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:10.0pt'> Phone: (850) =
487-9455 ext 164</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:10.0pt'> Fax: (850) =
488-8086</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:10.0pt'> Mobile: (850) =
339-5294</span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt'> </span></font></p>
</div>
</body>
</html>
------_=_NextPart_001_01C42314.0018369A--