C:\Users\twil24\Desktop\_WeeklyChallenge\76\White_ranch.txt
28591
\t
False
254
False
False
DoubleQuotes
9
White_ranch.txt
RecordID
Int32
4
Empty
IF [Row-1:RecordID] = 0 THEN 1 ELSEIF [Field_1] = "</trkpt>" THEN 1 + [Row-1:RecordID] ELSE [Row-1:RecordID] ENDIF
IF [Row-1:RecordID] = 0 THEN 1 ELSEIF [Field_1] = "</trkpt>" ...
!Contains([Field_1], "</trkpt>")
Custom
!=
Field_1
True
fixed
2019-09-27 13:23:20
0
</trkpt>
2019-09-27 13:23:20
2019-09-27 13:23:20
!Contains([Field_1], "</trkpt>")
Concatenate_Field_1
ParseComplex
Concatenate_Field_1
Warn
Concatenate_Field_1_Matched
raw time
yyyy-MM-ddThh:mm:ss
DateTime
Convert raw time From:
Custom
Double
RecordID
Prior spot
SpatialObj
536870911
Empty
[Row-1:Centroid]
[Row-1:Centroid]
Centroid
Prior spot
Latest
Miles
RecordID
seconds
Double
8
Empty
DateTimeDiff([DateTime],[Row-1:DateTime],"seconds")
DateTimeDiff([DateTime],[Row-1:DateTime],"seconds")
Speed in mph = [DistanceMiles]/[seconds]*3600
elevation = ToNumber([elevation])*...
bar
markers
<b>Speed (MPH)</b>
v
RunTot_seconds
Speed in mph
None
0
rgb(22, 112, 80)
v
scatter
<b>Elevation (Feet)</b>
lines
RunTot_seconds
elevation
y2
2
rgb(14, 14, 255)
sans-serif
16
false
792
612
false
closest
-0.5
6582.5
true
<b>Time</b>
linear
12
0
false
0
70
false
<b>Speed (MPH)</b>
linear
false
16
right
false
y
linear
5500
8500
false
true
<b>Elevation (Feet)</b>
16
auto
true
0
101
79
79
79
rgb(127, 127, 127)
72
C:\Users\twil24\AppData\Local\Temp\1\Engine_19944_f8310e4dc7b44cc9b7482a170659d019_\Engine_12184_ffd482ab7fea49d1a6903798af07892d_.yxdb
Single
Report
C:\Users\twil24\AppData\Local\Temp\1\Engine_19944_f8310e4dc7b44cc9b7482a170659d019_\Engine_12184_7af985ba75534769a9c3490f9b4cef07_.xml
8
6
1
CartoDark
#fdfeff
False
Miles
10
0.5
IncomingConnection
#1
SpatialObj_Built
Base Layers - Points
Placeholder
Lines
#1
#1
Base Layers - Lines
Placeholder
Base Layers - Polygons
Placeholder
C:\Users\twil24\AppData\Local\Temp\1\Engine_19944_f8310e4dc7b44cc9b7482a170659d019_\Engine_12184_7756049a382640a2aca1461f0438e77d_.yxdb
Single
Report
SequencePolyline
!IsNull([latitude])
Simple
IsNotNull
latitude
True
fixed
2019-09-27 18:08:18
0
2019-09-27 18:08:18
2019-09-27 18:08:18
!IsNull([latitude])
Horizontal
Challenge 76_solution