query, compare and match against values in date and time columns

Question

query, compare and match against values in date and time columns

brian.cook

Default port

Points: 1484
More actions
December 7, 2022 at 2:41 pm

#4122960
So, I need to calculate the distance between the UNIT for example LPKC1 to LPKC2, LPKC2 to LPKC3, LPKC3 to LPKC4, etc. using Haversine calculation.
This query does order them and in some instances it matches up the Date and Time row. I am unsure how to match each row of the data based on the date and time values in the columns.
```
BEGIN
    SELECT *
    FROM [Cranes].[dbo].[LPKCColmnized]
    ORDER BY LPKC1Date,
             LPKC1Time,
             LPKC2Date,
             LPKC2Time,
             LPKC3Date,
             LPKC3Time,
             LPKC4Date,
             LPKC4Time,
             LPKC5Date,
             LPKC5Time,
             LPKC6Date,
             LPKC6Time,
             LPKC7Date,
             LPKC7Time;
END;
```
I am including a sample of what the table looks like. I have only provided a single row in this instance. I can add additional sample rows if needed for context.
Thanks,
Attachments:
You must be logged in to view attached files.
Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner

December 10, 2022 at 5:59 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246695 More actions · Answer 1

Please provide a CREATE TABLE script for [Cranes].[dbo].[LPKCColmnized], along with your desired results, based on the provided sample data (which would be easier to use if it were provided as an INSERT ... VALUES () statement).

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

brian.cook Default port Points: 1484 More actions · Answer 2

My apologies Phil. I should have included that in the original.

In the DistanceX Columns is the results I am trying to find and only for the Date and times that match under each UnitX.

In the sample below I chose 2022-10-28 and 19:15:00 to populate the DistanceX columns. As there is no data for that time and date for LPKC6, then the Distance5 is NULL as is Distance6 since no match for it to LPKC7.

CREATE TABLE LPKCColumnized ( [Unit1] nvarchar(50), [LPKC1Date] date, [LPKC1Time] time(7), [Lat1] float(8), [Long1] float(8), [LPKCSat1] tinyint, [RadLat1] float(8), [RadLong1] float(8), [Distance1] decimal(18,0), [Unit2] nvarchar(50), [LPKC2Date] date, [LPKC2Time] time(7), [Lat2] float(8), [Long2] float(8), [LPKC2Sat] tinyint, [RadLat2] float(8), [RadLong2] float(8), [Distance2] decimal(18,0), [Unit3] nvarchar(50), [LPKC3Date] date, [LPKC3Time] time(7), [Lat3] float(8), [Long3] float(8), [LPKC3Sat] tinyint, [RadLat3] float(8), [RadLong3] float(8), [Distance3] decimal(18,0), [Unit4] nvarchar(50), [LPKC4Date] date, [LPKC4Time] time(7), [Lat4] float(8), [Long4] float(8), [LPKC4Sat] tinyint, [RadLat4] float(8), [RadLong4] float(8), [Distance4] decimal(18,0), [Unit5] nvarchar(50), [LPKC5Date] date, [LPKC5Time] time(7), [Lat5] float(8), [Long5] float(8), [LPKCSat5] tinyint, [RadLat5] float(8), [RadLong5] float(8), [Distance5] decimal(18,0), [Unit6] nvarchar(50), [LPKC6Date] date, [LPKC6Time] time(7), [Lat6] float(8), [Long6] float(8), [LPKC6Sat] tinyint, [RadLat6] float(8), [RadLong6] float(8), [Distance6] decimal(18,0), [Unit] nvarchar(50), [LPKC7Date] date, [LPKC7Time] time(7), [Lat7] float(8), [Long7] float(8), [LPKC7Sat] tinyint, [RadLat7] float(8), [RadLong7] float(8), [Dikstance7] decimal(18,0), [Unit8] nvarchar(50), [LPKC8Date] date, [LPKC8Time] time(7), [Lat8] float(8), [Long8] float(8), [LPKCSat8] tinyint, [RadLat8] float(8), [RadLong8] float(8), [Distance8] decimal(18,0) )
GO
INSERT INTO LPKCCOlumnized ([Unit1], [LPKC1Date], [LPKC1Time], [Lat1], [Long1], [LPKCSat1], [RadLat1], [RadLong1], [Distance1], [Unit2], [LPKC2Date], [LPKC2Time], [Lat2], [Long2], [LPKC2Sat], [RadLat2], [RadLong2], [Distance2], [Unit3], [LPKC3Date], [LPKC3Time], [Lat3], [Long3], [LPKC3Sat], [RadLat3], [RadLong3], [Distance3], [Unit4], [LPKC4Date], [LPKC4Time], [Lat4], [Long4], [LPKC4Sat], [RadLat4], [RadLong4], [Distance4], [Unit5], [LPKC5Date], [LPKC5Time], [Lat5], [Long5], [LPKCSat5], [RadLat5], [RadLong5], [Distance5], [Unit6], [LPKC6Date], [LPKC6Time], [Lat6], [Long6], [LPKC6Sat], [RadLat6], [RadLong6], [Distance6], [Unit], [LPKC7Date], [LPKC7Time], [Lat7], [Long7], [LPKC7Sat], [RadLat7], [RadLong7], [Dikstance7], [Unit8], [LPKC8Date], [LPKC8Time], [Lat8], [Long8], [LPKCSat8], [RadLat8], [RadLong8], [Distance8])
VALUES
( N'LPKC1', N'2022-10-28', N'00:00:00', 38.7967720031738, -94.9485015869141, 17, 0.677131414413452, -1.65716397762299, NULL, N'LPKC2', N'2022-10-28', N'00:00:00', 38.7966079711914, -94.9488220214844, 17, 0.677128553390503, -1.65716958045959, NULL, N'LPKC3', N'2022-10-28', N'00:00:00', 38.7951316833496, -94.9516220092773, 17, 0.677102744579315, -1.65721845626831, NULL, N'LPKC4', N'2022-10-28', N'00:00:00', 38.7898368835449, -94.9601058959961, 17, 0.677010357379913, -1.65736651420593, NULL, N'LPKC5', N'2022-10-28', N'00:00:00', 38.7881278991699, -94.9633178710938, 17, 0.676980555057526, -1.65742254257202, NULL, N'LPKC6', N'2022-10-28', N'00:00:00', 38.7853393554688, -94.9685363769531, 17, 0.676931858062744, -1.65751361846924, NULL, N'LPKC7', N'2022-10-28', N'00:00:00', 38.7843132019043, -94.9704513549805, 16, 0.676913976669312, -1.6575471162796, NULL, N'LPKC8', N'2022-10-28', N'00:00:00', 38.7841644287109, -94.9707717895508, 17, 0.676911354064941, -1.65755259990692, NULL ),
( N'LPKC1', N'2022-10-28', N'18:33:00', 38.7967681884766, -94.9485244750977, 17, 0.677131354808807, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'18:53:00', 38.7947883605957, -94.9522552490234, 15, 0.677096784114838, -1.65722942352295, NULL, N'LPKC3', N'2022-10-28', N'19:08:00', 38.7941474914551, -94.9534454345703, 17, 0.67708557844162, -1.65725028514862, NULL, N'LPKC4', N'2022-10-28', N'18:25:00', 38.7908630371094, -94.9581069946289, 7, 0.677028298377991, -1.65733158588409, NULL, N'LPKC5', N'2022-10-28', N'18:48:00', 38.7889175415039, -94.9617919921875, 16, 0.676994323730469, -1.65739595890045, NULL, N'LPKC6', N'2022-10-28', N'19:27:00', 38.7889938354492, -94.961669921875, 17, 0.676995635032654, -1.65739381313324, NULL, N'LPKC7', N'2022-10-28', N'18:52:00', 38.7862548828125, -94.966796875, 16, 0.676947832107544, -1.6574832201004, NULL, N'LPKC8', N'2022-10-28', N'19:12:00', 38.7845191955566, -94.9700469970703, 11, 0.676917552947998, -1.65753996372223, NULL ),
( N'LPKC1', N'2022-10-28', N'18:34:00', 38.7967681884766, -94.9485244750977, 17, 0.677131354808807, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'18:54:00', 38.7947807312012, -94.9522476196289, 15, 0.677096664905548, -1.65722930431366, NULL, N'LPKC3', N'2022-10-28', N'19:09:00', 38.7941436767578, -94.9534454345703, 16, 0.677085518836975, -1.65725028514862, NULL, N'LPKC4', N'2022-10-28', N'18:26:00', 38.7908935546875, -94.9580612182617, 16, 0.677028775215149, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'18:49:00', 38.7889213562012, -94.9617919921875, 16, 0.676994383335114, -1.65739595890045, NULL, N'LPKC6', N'2022-10-28', N'19:28:00', 38.7889137268066, -94.9618377685547, 17, 0.676994264125824, -1.65739667415619, NULL, N'LPKC7', N'2022-10-28', N'18:53:00', 38.7862510681152, -94.966796875, 16, 0.676947772502899, -1.6574832201004, NULL, N'LPKC8', N'2022-10-28', N'19:13:00', 38.7845115661621, -94.9700698852539, 15, 0.676917433738709, -1.65754044055939, NULL ),
( N'LPKC1', N'2022-10-28', N'18:35:00', 38.7967643737793, -94.9485168457031, 17, 0.677131295204163, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'18:55:00', 38.794921875, -94.9519577026367, 16, 0.677099108695984, -1.6572242975235, NULL, N'LPKC3', N'2022-10-28', N'19:10:00', 38.794132232666, -94.9534530639648, 17, 0.677085340023041, -1.65725040435791, NULL, N'LPKC4', N'2022-10-28', N'18:27:00', 38.7909049987793, -94.9580612182617, 16, 0.677029013633728, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'18:50:00', 38.7889137268066, -94.9617767333984, 16, 0.676994264125824, -1.65739560127258, NULL, N'LPKC6', N'2022-10-28', N'19:29:00', 38.7889938354492, -94.9616775512695, 17, 0.676995635032654, -1.65739393234253, NULL, N'LPKC7', N'2022-10-28', N'18:54:00', 38.7862548828125, -94.9667892456055, 16, 0.676947832107544, -1.65748310089111, NULL, N'LPKC8', N'2022-10-28', N'19:14:00', 38.7845115661621, -94.9700698852539, 15, 0.676917433738709, -1.65754044055939, NULL ),
( N'LPKC1', N'2022-10-28', N'18:36:00', 38.7967643737793, -94.9485168457031, 17, 0.677131295204163, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'18:56:00', 38.7953147888184, -94.9512100219727, 17, 0.677105963230133, -1.65721118450165, NULL, N'LPKC3', N'2022-10-28', N'19:11:00', 38.7942886352539, -94.9531555175781, 17, 0.6770880818367, -1.65724515914917, NULL, N'LPKC4', N'2022-10-28', N'18:28:00', 38.7909049987793, -94.9580535888672, 16, 0.677029013633728, -1.65733063220978, NULL, N'LPKC5', N'2022-10-28', N'18:51:00', 38.7889137268066, -94.9617767333984, 17, 0.676994264125824, -1.65739560127258, NULL, N'LPKC6', N'2022-10-28', N'19:30:00', 38.7889976501465, -94.961669921875, 17, 0.676995694637299, -1.65739381313324, NULL, N'LPKC7', N'2022-10-28', N'18:55:00', 38.7862548828125, -94.9667816162109, 16, 0.676947832107544, -1.65748298168182, NULL, N'LPKC8', N'2022-10-28', N'19:15:00', 38.7845077514648, -94.9700775146484, 16, 0.676917374134064, -1.65754055976868, NULL ),
( N'LPKC1', N'2022-10-28', N'18:37:00', 38.7967643737793, -94.9485092163086, 17, 0.677131295204163, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'18:57:00', 38.7953109741211, -94.9512176513672, 17, 0.677105903625488, -1.65721142292023, NULL, N'LPKC3', N'2022-10-28', N'19:12:00', 38.7942886352539, -94.9531631469727, 17, 0.6770880818367, -1.65724527835846, NULL, N'LPKC4', N'2022-10-28', N'18:29:00', 38.7909088134766, -94.9580612182617, 16, 0.677029073238373, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'18:52:00', 38.7891235351563, -94.9614181518555, 17, 0.676997900009155, -1.65738940238953, NULL, N'LPKC6', N'2022-10-28', N'19:31:00', 38.7889251708984, -94.961799621582, 17, 0.676994442939758, -1.65739607810974, NULL, N'LPKC7', N'2022-10-28', N'18:56:00', 38.7866020202637, -94.9661560058594, 17, 0.676953911781311, -1.65747213363647, NULL, N'LPKC8', N'2022-10-28', N'19:16:00', 38.7848320007324, -94.9694747924805, 16, 0.676923036575317, -1.6575300693512, NULL ),
( N'LPKC1', N'2022-10-28', N'18:38:00', 38.796760559082, -94.9485092163086, 17, 0.677131175994873, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'18:58:00', 38.7953109741211, -94.9512176513672, 17, 0.677105903625488, -1.65721142292023, NULL, N'LPKC3', N'2022-10-28', N'19:13:00', 38.7942695617676, -94.9532165527344, 16, 0.677087724208832, -1.65724623203278, NULL, N'LPKC4', N'2022-10-28', N'18:30:00', 38.7909088134766, -94.9580612182617, 16, 0.677029073238373, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'18:53:00', 38.789363861084, -94.9609756469727, 17, 0.67700207233429, -1.65738165378571, NULL, N'LPKC6', N'2022-10-28', N'19:32:00', 38.7890663146973, -94.9615249633789, 16, 0.676996886730194, -1.65739130973816, NULL, N'LPKC7', N'2022-10-28', N'18:57:00', 38.7868614196777, -94.9656829833984, 17, 0.676958441734314, -1.65746378898621, NULL, N'LPKC8', N'2022-10-28', N'19:17:00', 38.7847785949707, -94.969596862793, 16, 0.676922082901001, -1.65753209590912, NULL ),
( N'LPKC1', N'2022-10-28', N'18:39:00', 38.7967643737793, -94.9485092163086, 17, 0.677131295204163, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'18:59:00', 38.7953071594238, -94.9512176513672, 17, 0.677105844020844, -1.65721142292023, NULL, N'LPKC3', N'2022-10-28', N'19:14:00', 38.79443359375, -94.9529495239258, 16, 0.677090585231781, -1.65724158287048, NULL, N'LPKC4', N'2022-10-28', N'18:31:00', 38.7909049987793, -94.9580535888672, 16, 0.677029013633728, -1.65733063220978, NULL, N'LPKC5', N'2022-10-28', N'18:54:00', 38.789363861084, -94.9609680175781, 17, 0.67700207233429, -1.65738153457642, NULL, N'LPKC6', N'2022-10-28', N'19:33:00', 38.7890625, -94.9615249633789, 17, 0.676996827125549, -1.65739130973816, NULL, N'LPKC7', N'2022-10-28', N'18:58:00', 38.7868614196777, -94.9656829833984, 17, 0.676958441734314, -1.65746378898621, NULL, N'LPKC8', N'2022-10-28', N'19:18:00', 38.7849311828613, -94.9692993164063, 16, 0.676924765110016, -1.65752696990967, NULL ),
( N'LPKC1', N'2022-10-28', N'18:40:00', 38.7967643737793, -94.9485092163086, 17, 0.677131295204163, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'19:00:00', 38.7953109741211, -94.9512252807617, 17, 0.677105903625488, -1.65721154212952, NULL, N'LPKC3', N'2022-10-28', N'19:15:00', 38.7944374084473, -94.9529418945313, 16, 0.677090644836426, -1.65724146366119, 0.392720841, N'LPKC4', N'2022-10-28', N'18:32:00', 38.7909088134766, -94.9580612182617, 17, 0.677029073238373, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'18:55:00', 38.7892417907715, -94.9611968994141, 16, 0.676999986171722, -1.65738558769226, NULL, N'LPKC6', N'2022-10-28', N'19:34:00', 38.7890701293945, -94.9615249633789, 17, 0.676997005939484, -1.65739130973816, NULL, N'LPKC7', N'2022-10-28', N'18:59:00', 38.7868576049805, -94.9656829833984, 17, 0.676958382129669, -1.65746378898621, NULL, N'LPKC8', N'2022-10-28', N'19:19:00', 38.7848358154297, -94.969482421875, 16, 0.676923096179962, -1.65753018856049, NULL ),
( N'LPKC1', N'2022-10-28', N'18:41:00', 38.796760559082, -94.9485092163086, 18, 0.677131175994873, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'19:01:00', 38.7953186035156, -94.9512329101563, 17, 0.677106022834778, -1.65721166133881, NULL, N'LPKC3', N'2022-10-28', N'19:16:00', 38.7947235107422, -94.9523544311523, 16, 0.677095651626587, -1.65723121166229, NULL, N'LPKC4', N'2022-10-28', N'18:33:00', 38.7909088134766, -94.9580688476563, 17, 0.677029073238373, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'18:56:00', 38.7891044616699, -94.9614562988281, 16, 0.676997601985931, -1.65739011764526, NULL, N'LPKC6', N'2022-10-28', N'19:35:00', 38.7886238098145, -94.9623947143555, 17, 0.676989197731018, -1.65740644931793, NULL, N'LPKC7', N'2022-10-28', N'19:00:00', 38.7869606018066, -94.9654922485352, 17, 0.676960170269012, -1.65746057033539, NULL, N'LPKC8', N'2022-10-28', N'19:20:00', 38.784969329834, -94.9692459106445, 16, 0.676925420761108, -1.65752601623535, NULL ),
( N'LPKC1', N'2022-10-28', N'18:42:00', 38.796760559082, -94.9485168457031, 18, 0.677131175994873, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:02:00', 38.7953224182129, -94.9512329101563, 17, 0.677106082439423, -1.65721166133881, NULL, N'LPKC3', N'2022-10-28', N'19:17:00', 38.7949829101563, -94.9518890380859, 16, 0.67710018157959, -1.6572231054306, NULL, N'LPKC4', N'2022-10-28', N'18:34:00', 38.7909126281738, -94.9580688476563, 17, 0.677029132843018, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'18:57:00', 38.7891082763672, -94.9614486694336, 16, 0.676997661590576, -1.65738987922668, NULL, N'LPKC6', N'2022-10-28', N'19:36:00', 38.7885627746582, -94.962516784668, 17, 0.676988124847412, -1.65740859508514, NULL, N'LPKC7', N'2022-10-28', N'19:01:00', 38.7869033813477, -94.9656295776367, 17, 0.676959156990051, -1.65746295452118, NULL, N'LPKC8', N'2022-10-28', N'19:21:00', 38.7848434448242, -94.9695053100586, 16, 0.676923215389252, -1.65753054618835, NULL ),
( N'LPKC1', N'2022-10-28', N'18:43:00', 38.796760559082, -94.9485244750977, 18, 0.677131175994873, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'19:03:00', 38.7953186035156, -94.9512329101563, 17, 0.677106022834778, -1.65721166133881, NULL, N'LPKC3', N'2022-10-28', N'19:18:00', 38.7949142456055, -94.9520111083984, 16, 0.677098989486694, -1.65722525119781, NULL, N'LPKC4', N'2022-10-28', N'18:35:00', 38.7909126281738, -94.9580688476563, 17, 0.677029132843018, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'18:58:00', 38.7891159057617, -94.9614486694336, 17, 0.676997780799866, -1.65738987922668, NULL, N'LPKC6', N'2022-10-28', N'19:37:00', 38.7883682250977, -94.962890625, 17, 0.67698472738266, -1.65741515159607, NULL, N'LPKC7', N'2022-10-28', N'19:02:00', 38.7865295410156, -94.9663162231445, 17, 0.676952660083771, -1.65747487545013, NULL, N'LPKC8', N'2022-10-28', N'19:22:00', 38.7850456237793, -94.969108581543, 16, 0.676926732063293, -1.65752363204956, NULL ),
( N'LPKC1', N'2022-10-28', N'18:44:00', 38.796760559082, -94.9485321044922, 17, 0.677131175994873, -1.65716445446014, NULL, N'LPKC2', N'2022-10-28', N'19:04:00', 38.7953186035156, -94.9512252807617, 17, 0.677106022834778, -1.65721154212952, NULL, N'LPKC3', N'2022-10-28', N'19:19:00', 38.7950401306152, -94.9517517089844, 16, 0.677101194858551, -1.65722072124481, NULL, N'LPKC4', N'2022-10-28', N'18:36:00', 38.7909164428711, -94.9580688476563, 17, 0.677029192447662, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'18:59:00', 38.7894477844238, -94.960823059082, 17, 0.677003562450409, -1.65737903118134, NULL, N'LPKC6', N'2022-10-28', N'19:38:00', 38.7883834838867, -94.9628524780273, 17, 0.676984965801239, -1.65741443634033, NULL, N'LPKC7', N'2022-10-28', N'19:03:00', 38.7862854003906, -94.966796875, 17, 0.676948368549347, -1.6574832201004, NULL, N'LPKC8', N'2022-10-28', N'19:23:00', 38.7848625183105, -94.9694671630859, 16, 0.676923513412476, -1.65752983093262, NULL ),
( N'LPKC1', N'2022-10-28', N'18:45:00', 38.796760559082, -94.9485321044922, 17, 0.677131175994873, -1.65716445446014, NULL, N'LPKC2', N'2022-10-28', N'19:05:00', 38.7956123352051, -94.9506912231445, 17, 0.677111148834229, -1.65720224380493, NULL, N'LPKC3', N'2022-10-28', N'19:20:00', 38.7949867248535, -94.9518432617188, 16, 0.677100241184235, -1.65722227096558, NULL, N'LPKC4', N'2022-10-28', N'18:37:00', 38.7909164428711, -94.9580688476563, 17, 0.677029192447662, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'19:00:00', 38.7897644042969, -94.9602279663086, 17, 0.677009105682373, -1.65736865997314, NULL, N'LPKC6', N'2022-10-28', N'19:39:00', 38.7882766723633, -94.9630432128906, 17, 0.676983118057251, -1.65741777420044, NULL, N'LPKC7', N'2022-10-28', N'19:04:00', 38.7861289978027, -94.967041015625, 17, 0.676945626735687, -1.65748751163483, NULL, N'LPKC8', N'2022-10-28', N'19:24:00', 38.7850494384766, -94.9690933227539, 16, 0.676926791667938, -1.65752339363098, NULL ),
( N'LPKC1', N'2022-10-28', N'18:46:00', 38.796760559082, -94.9485321044922, 17, 0.677131175994873, -1.65716445446014, NULL, N'LPKC2', N'2022-10-28', N'19:06:00', 38.7960090637207, -94.9499664306641, 17, 0.677118122577667, -1.65718948841095, NULL, N'LPKC3', N'2022-10-28', N'19:21:00', 38.795036315918, -94.9517593383789, 16, 0.677101135253906, -1.6572208404541, NULL, N'LPKC4', N'2022-10-28', N'18:38:00', 38.7909088134766, -94.9580688476563, 17, 0.677029073238373, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'19:01:00', 38.7897033691406, -94.9603729248047, 17, 0.677008032798767, -1.65737116336823, NULL, N'LPKC6', N'2022-10-28', N'19:40:00', 38.7883834838867, -94.9628601074219, 16, 0.676984965801239, -1.65741455554962, NULL, N'LPKC7', N'2022-10-28', N'19:05:00', 38.7861099243164, -94.9670715332031, 17, 0.676945328712463, -1.65748810768127, NULL, N'LPKC8', N'2022-10-28', N'19:25:00', 38.7850456237793, -94.9691009521484, 16, 0.676926732063293, -1.65752351284027, NULL ),
( N'LPKC1', N'2022-10-28', N'18:47:00', 38.796760559082, -94.9485244750977, 17, 0.677131175994873, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'19:07:00', 38.7960968017578, -94.9497680664063, 17, 0.677119612693787, -1.65718603134155, NULL, N'LPKC3', N'2022-10-28', N'19:22:00', 38.7950477600098, -94.9517440795898, 16, 0.677101314067841, -1.65722060203552, NULL, N'LPKC4', N'2022-10-28', N'18:39:00', 38.7909088134766, -94.9580764770508, 17, 0.677029073238373, -1.65733110904694, NULL, N'LPKC5', N'2022-10-28', N'19:02:00', 38.7897033691406, -94.9603576660156, 16, 0.677008032798767, -1.65737092494965, NULL, N'LPKC6', N'2022-10-28', N'19:41:00', 38.7885780334473, -94.9624938964844, 17, 0.676988422870636, -1.65740811824799, NULL, N'LPKC7', N'2022-10-28', N'19:06:00', 38.7862548828125, -94.9668045043945, 17, 0.676947832107544, -1.65748345851898, NULL, N'LPKC8', N'2022-10-28', N'19:26:00', 38.7845687866211, -94.9699935913086, 16, 0.676918387413025, -1.65753901004791, NULL ),
( N'LPKC1', N'2022-10-28', N'18:48:00', 38.7967643737793, -94.9485244750977, 17, 0.677131295204163, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'19:08:00', 38.7962303161621, -94.9495162963867, 17, 0.677121937274933, -1.65718162059784, NULL, N'LPKC3', N'2022-10-28', N'19:23:00', 38.7950477600098, -94.9517440795898, 16, 0.677101314067841, -1.65722060203552, NULL, N'LPKC4', N'2022-10-28', N'18:40:00', 38.7909088134766, -94.9580764770508, 17, 0.677029073238373, -1.65733110904694, NULL, N'LPKC5', N'2022-10-28', N'19:03:00', 38.7897491455078, -94.9602508544922, 17, 0.677008807659149, -1.65736901760101, NULL, N'LPKC6', N'2022-10-28', N'19:42:00', 38.7885437011719, -94.9625701904297, 17, 0.676987767219543, -1.65740954875946, NULL, N'LPKC7', N'2022-10-28', N'19:07:00', 38.786693572998, -94.9659881591797, 17, 0.67695552110672, -1.65746915340424, NULL, N'LPKC8', N'2022-10-28', N'19:27:00', 38.7847747802734, -94.9696273803711, 17, 0.676922023296356, -1.65753269195557, NULL ),
( N'LPKC1', N'2022-10-28', N'18:49:00', 38.7967643737793, -94.9485244750977, 17, 0.677131295204163, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'19:09:00', 38.7960891723633, -94.9497909545898, 17, 0.677119493484497, -1.65718650817871, NULL, N'LPKC3', N'2022-10-28', N'19:24:00', 38.7949104309082, -94.9520263671875, 16, 0.67709892988205, -1.65722548961639, NULL, N'LPKC4', N'2022-10-28', N'18:41:00', 38.7909126281738, -94.9580764770508, 18, 0.677029132843018, -1.65733110904694, NULL, N'LPKC5', N'2022-10-28', N'19:04:00', 38.7892570495605, -94.9611511230469, 17, 0.677000224590302, -1.65738475322723, NULL, N'LPKC6', N'2022-10-28', N'19:43:00', 38.7882652282715, -94.9630661010742, 17, 0.676982939243317, -1.65741813182831, NULL, N'LPKC7', N'2022-10-28', N'19:08:00', 38.7866249084473, -94.9661254882813, 17, 0.67695426940918, -1.65747153759003, NULL, N'LPKC8', N'2022-10-28', N'19:28:00', 38.7851982116699, -94.9688186645508, 17, 0.676929414272308, -1.65751850605011, NULL ),
( N'LPKC1', N'2022-10-28', N'18:50:00', 38.7967643737793, -94.9485244750977, 17, 0.677131295204163, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'19:10:00', 38.7961082458496, -94.9497528076172, 17, 0.677119851112366, -1.65718579292297, NULL, N'LPKC3', N'2022-10-28', N'19:25:00', 38.7947692871094, -94.9522933959961, 16, 0.677096426486969, -1.65723013877869, NULL, N'LPKC4', N'2022-10-28', N'18:42:00', 38.7909088134766, -94.9580688476563, 18, 0.677029073238373, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'19:05:00', 38.7893333435059, -94.961051940918, 17, 0.677001595497131, -1.65738296508789, NULL, N'LPKC6', N'2022-10-28', N'19:44:00', 38.7883110046387, -94.9629821777344, 17, 0.676983714103699, -1.65741670131683, NULL, N'LPKC7', N'2022-10-28', N'19:09:00', 38.7864990234375, -94.9663314819336, 17, 0.676952123641968, -1.65747511386871, NULL, N'LPKC8', N'2022-10-28', N'19:29:00', 38.7849617004395, -94.9692611694336, 17, 0.676925241947174, -1.65752625465393, NULL ),
( N'LPKC1', N'2022-10-28', N'18:51:00', 38.796760559082, -94.9485244750977, 17, 0.677131175994873, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'19:11:00', 38.7961463928223, -94.9496994018555, 17, 0.677120506763458, -1.65718483924866, NULL, N'LPKC3', N'2022-10-28', N'19:26:00', 38.7946739196777, -94.9524383544922, 16, 0.677094757556915, -1.65723264217377, NULL, N'LPKC4', N'2022-10-28', N'18:43:00', 38.7909088134766, -94.9580688476563, 18, 0.677029073238373, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'19:06:00', 38.7896270751953, -94.9605178833008, 17, 0.677006721496582, -1.65737366676331, NULL, N'LPKC6', N'2022-10-28', N'19:45:00', 38.7882881164551, -94.963020324707, 17, 0.67698335647583, -1.65741741657257, NULL, N'LPKC7', N'2022-10-28', N'19:10:00', 38.7862510681152, -94.9668197631836, 17, 0.676947772502899, -1.65748369693756, NULL, N'LPKC8', N'2022-10-28', N'19:30:00', 38.7849502563477, -94.9692916870117, 17, 0.67692506313324, -1.65752685070038, NULL ),
( N'LPKC1', N'2022-10-28', N'18:52:00', 38.796760559082, -94.9485244750977, 17, 0.677131175994873, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'19:12:00', 38.7964935302734, -94.9490356445313, 16, 0.677126526832581, -1.65717327594757, NULL, N'LPKC3', N'2022-10-28', N'19:27:00', 38.7944526672363, -94.9528656005859, 16, 0.67709094285965, -1.65724015235901, NULL, N'LPKC4', N'2022-10-28', N'18:44:00', 38.7909088134766, -94.9580688476563, 17, 0.677029073238373, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'19:07:00', 38.7896270751953, -94.9605178833008, 17, 0.677006721496582, -1.65737366676331, NULL, N'LPKC6', N'2022-10-28', N'19:46:00', 38.7881698608398, -94.9632415771484, 17, 0.676981270313263, -1.65742123126984, NULL, N'LPKC7', N'2022-10-28', N'19:11:00', 38.7864379882813, -94.9665145874023, 17, 0.676951050758362, -1.65747833251953, NULL, N'LPKC8', N'2022-10-28', N'19:31:00', 38.7851409912109, -94.9689254760742, 17, 0.676928400993347, -1.65752041339874, NULL ),
( N'LPKC1', N'2022-10-28', N'18:53:00', 38.796760559082, -94.9485244750977, 17, 0.677131175994873, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'19:13:00', 38.796558380127, -94.9489364624023, 16, 0.677127659320831, -1.65717160701752, NULL, N'LPKC3', N'2022-10-28', N'19:28:00', 38.7944221496582, -94.9529418945313, 17, 0.677090406417847, -1.65724146366119, NULL, N'LPKC4', N'2022-10-28', N'18:45:00', 38.7909049987793, -94.9580612182617, 17, 0.677029013633728, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'19:08:00', 38.789665222168, -94.9604339599609, 17, 0.677007377147675, -1.65737223625183, NULL, N'LPKC6', N'2022-10-28', N'19:47:00', 38.7880516052246, -94.9634780883789, 17, 0.676979184150696, -1.65742540359497, NULL, N'LPKC7', N'2022-10-28', N'19:12:00', 38.7865295410156, -94.9662933349609, 16, 0.676952660083771, -1.65747451782227, NULL, N'LPKC8', N'2022-10-28', N'19:32:00', 38.7851982116699, -94.9688339233398, 17, 0.676929414272308, -1.65751886367798, NULL ),
( N'LPKC1', N'2022-10-28', N'18:54:00', 38.7967567443848, -94.9485244750977, 16, 0.677131116390228, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'19:14:00', 38.796558380127, -94.9489364624023, 16, 0.677127659320831, -1.65717160701752, NULL, N'LPKC3', N'2022-10-28', N'19:29:00', 38.7944221496582, -94.9529342651367, 17, 0.677090406417847, -1.6572413444519, NULL, N'LPKC4', N'2022-10-28', N'18:46:00', 38.7909049987793, -94.9580688476563, 17, 0.677029013633728, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'19:09:00', 38.7898406982422, -94.9601211547852, 17, 0.677010416984558, -1.65736675262451, NULL, N'LPKC6', N'2022-10-28', N'19:48:00', 38.7878646850586, -94.9638137817383, 16, 0.676975965499878, -1.65743124485016, NULL, N'LPKC7', N'2022-10-28', N'19:13:00', 38.7866401672363, -94.9661178588867, 16, 0.676954567432404, -1.65747141838074, NULL, N'LPKC8', N'2022-10-28', N'19:33:00', 38.7853546142578, -94.9685287475586, 17, 0.676932156085968, -1.65751349925995, NULL ),
( N'LPKC1', N'2022-10-28', N'18:55:00', 38.7967567443848, -94.9485168457031, 16, 0.677131116390228, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:15:00', 38.796558380127, -94.9489364624023, 16, 0.677127659320831, -1.65717160701752, 0.419639095, N'LPKC3', N'2022-10-28', N'19:30:00', 38.7944679260254, -94.9528350830078, 17, 0.677091181278229, -1.65723955631256, NULL, N'LPKC4', N'2022-10-28', N'18:47:00', 38.790901184082, -94.9580688476563, 17, 0.677028954029083, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'19:10:00', 38.7899932861328, -94.9598159790039, 17, 0.677013099193573, -1.65736138820648, NULL, N'LPKC6', N'2022-10-28', N'19:49:00', 38.7878684997559, -94.9638290405273, 16, 0.676976025104523, -1.65743148326874, NULL, N'LPKC7', N'2022-10-28', N'19:14:00', 38.7862586975098, -94.9668273925781, 16, 0.676947891712189, -1.65748381614685, NULL, N'LPKC8', N'2022-10-28', N'19:34:00', 38.7853507995605, -94.9685516357422, 17, 0.676932036876678, -1.65751385688782, NULL ),
( N'LPKC1', N'2022-10-28', N'18:56:00', 38.7967567443848, -94.9485168457031, 16, 0.677131116390228, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:16:00', 38.7965469360352, -94.9489593505859, 16, 0.677127480506897, -1.65717196464539, NULL, N'LPKC3', N'2022-10-28', N'19:31:00', 38.7943115234375, -94.9531707763672, 17, 0.677088439464569, -1.65724539756775, NULL, N'LPKC4', N'2022-10-28', N'18:48:00', 38.7909049987793, -94.9580688476563, 17, 0.677029013633728, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'19:11:00', 38.790153503418, -94.9595336914063, 17, 0.677015900611877, -1.65735650062561, NULL, N'LPKC6', N'2022-10-28', N'19:50:00', 38.7879600524902, -94.9636688232422, 17, 0.676977634429932, -1.65742862224579, NULL, N'LPKC7', N'2022-10-28', N'19:15:00', 38.7861213684082, -94.9671020507813, 16, 0.676945507526398, -1.65748858451843, 0.314171629, N'LPKC8', N'2022-10-28', N'19:35:00', 38.7851867675781, -94.968864440918, 17, 0.676929175853729, -1.65751934051514, NULL ),
( N'LPKC1', N'2022-10-28', N'18:57:00', 38.7967567443848, -94.9485168457031, 17, 0.677131116390228, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:17:00', 38.7962760925293, -94.9494705200195, 16, 0.67712277173996, -1.6571809053421, NULL, N'LPKC3', N'2022-10-28', N'19:32:00', 38.7944145202637, -94.9530029296875, 17, 0.677090227603912, -1.6572425365448, NULL, N'LPKC4', N'2022-10-28', N'18:49:00', 38.790901184082, -94.9580612182617, 17, 0.677028954029083, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'19:12:00', 38.7899322509766, -94.9599533081055, 16, 0.677012026309967, -1.65736389160156, NULL, N'LPKC6', N'2022-10-28', N'19:51:00', 38.787899017334, -94.9637680053711, 17, 0.676976561546326, -1.65743041038513, NULL, N'LPKC7', N'2022-10-28', N'19:16:00', 38.7859916687012, -94.9673461914063, 16, 0.676943242549896, -1.65749287605286, NULL, N'LPKC8', N'2022-10-28', N'19:36:00', 38.7850456237793, -94.9690933227539, 17, 0.676926732063293, -1.65752339363098, NULL ),
( N'LPKC1', N'2022-10-28', N'18:58:00', 38.7967643737793, -94.9485168457031, 17, 0.677131295204163, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:18:00', 38.7959365844727, -94.9501113891602, 16, 0.677116811275482, -1.65719211101532, NULL, N'LPKC3', N'2022-10-28', N'19:33:00', 38.7945518493652, -94.9527206420898, 16, 0.677092671394348, -1.65723764896393, NULL, N'LPKC4', N'2022-10-28', N'18:50:00', 38.7909049987793, -94.9580612182617, 17, 0.677029013633728, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'19:13:00', 38.7899284362793, -94.9599456787109, 16, 0.677011966705322, -1.65736365318298, NULL, N'LPKC6', N'2022-10-28', N'19:52:00', 38.7881317138672, -94.9633255004883, 17, 0.67698061466217, -1.65742266178131, NULL, N'LPKC7', N'2022-10-28', N'19:17:00', 38.7862243652344, -94.966911315918, 16, 0.676947295665741, -1.65748524665833, NULL, N'LPKC8', N'2022-10-28', N'19:37:00', 38.7851982116699, -94.9688415527344, 17, 0.676929414272308, -1.65751898288727, NULL ),
( N'LPKC1', N'2022-10-28', N'18:59:00', 38.7967681884766, -94.9485168457031, 17, 0.677131354808807, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:19:00', 38.7957229614258, -94.9505081176758, 16, 0.677113056182861, -1.65719902515411, NULL, N'LPKC3', N'2022-10-28', N'19:34:00', 38.7939376831055, -94.9538955688477, 17, 0.677081942558289, -1.65725815296173, NULL, N'LPKC4', N'2022-10-28', N'18:51:00', 38.7909049987793, -94.9580612182617, 17, 0.677029013633728, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'19:14:00', 38.7899284362793, -94.9599456787109, 16, 0.677011966705322, -1.65736365318298, NULL, N'LPKC6', N'2022-10-28', N'19:53:00', 38.7878799438477, -94.9637908935547, 17, 0.676976203918457, -1.657430768013, NULL, N'LPKC7', N'2022-10-28', N'19:18:00', 38.7860450744629, -94.9672470092773, 16, 0.676944196224213, -1.65749108791351, NULL, N'LPKC8', N'2022-10-28', N'19:38:00', 38.7851715087891, -94.9688873291016, 17, 0.67692893743515, -1.65751981735229, NULL ),
( N'LPKC1', N'2022-10-28', N'19:00:00', 38.7967681884766, -94.9485168457031, 17, 0.677131354808807, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:20:00', 38.7957305908203, -94.9504852294922, 16, 0.677113234996796, -1.65719854831696, NULL, N'LPKC3', N'2022-10-28', N'19:35:00', 38.7938499450684, -94.9540710449219, 16, 0.677080392837524, -1.65726113319397, NULL, N'LPKC4', N'2022-10-28', N'18:52:00', 38.7909049987793, -94.9580612182617, 17, 0.677029013633728, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'19:15:00', 38.789608001709, -94.9605255126953, 16, 0.677006363868713, -1.6573737859726, NULL, N'LPKC6', N'2022-10-28', N'19:54:00', 38.7878684997559, -94.9638366699219, 17, 0.676976025104523, -1.65743160247803, NULL, N'LPKC7', N'2022-10-28', N'19:19:00', 38.7859535217285, -94.9673919677734, 16, 0.676942586898804, -1.65749371051788, NULL, N'LPKC8', N'2022-10-28', N'19:39:00', 38.785041809082, -94.969108581543, 17, 0.676926672458649, -1.65752363204956, NULL ),
( N'LPKC1', N'2022-10-28', N'19:01:00', 38.7967681884766, -94.9485168457031, 17, 0.677131354808807, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:21:00', 38.7957038879395, -94.9505310058594, 16, 0.677112758159637, -1.65719938278198, NULL, N'LPKC3', N'2022-10-28', N'19:36:00', 38.7938499450684, -94.9540634155273, 17, 0.677080392837524, -1.65726101398468, NULL, N'LPKC4', N'2022-10-28', N'18:53:00', 38.790901184082, -94.9580612182617, 17, 0.677028954029083, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'19:16:00', 38.7896118164063, -94.9605255126953, 16, 0.677006423473358, -1.6573737859726, NULL, N'LPKC6', N'2022-10-28', N'19:55:00', 38.7879104614258, -94.963752746582, 17, 0.67697674036026, -1.65743017196655, NULL, N'LPKC7', N'2022-10-28', N'19:20:00', 38.7859802246094, -94.9673461914063, 16, 0.676943063735962, -1.65749287605286, NULL, N'LPKC8', N'2022-10-28', N'19:40:00', 38.7847785949707, -94.9695816040039, 17, 0.676922082901001, -1.65753185749054, NULL ),
( N'LPKC1', N'2022-10-28', N'19:02:00', 38.7967720031738, -94.9485168457031, 17, 0.677131414413452, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:22:00', 38.79541015625, -94.9511032104492, 16, 0.677107632160187, -1.6572093963623, NULL, N'LPKC3', N'2022-10-28', N'19:37:00', 38.7940292358398, -94.9536895751953, 17, 0.677083551883698, -1.65725445747375, NULL, N'LPKC4', N'2022-10-28', N'18:54:00', 38.7909049987793, -94.9580688476563, 16, 0.677029013633728, -1.65733098983765, NULL, N'LPKC5', N'2022-10-28', N'19:17:00', 38.7899284362793, -94.9599304199219, 16, 0.677011966705322, -1.6573634147644, NULL, N'LPKC6', N'2022-10-28', N'19:56:00', 38.7874374389648, -94.9646301269531, 17, 0.676968455314636, -1.65744543075562, NULL, N'LPKC7', N'2022-10-28', N'19:21:00', 38.7858505249023, -94.9675827026367, 16, 0.67694079875946, -1.65749704837799, NULL, N'LPKC8', N'2022-10-28', N'19:41:00', 38.7849922180176, -94.9692001342773, 17, 0.676925837993622, -1.65752518177032, NULL ),
( N'LPKC1', N'2022-10-28', N'19:03:00', 38.7967681884766, -94.9485168457031, 17, 0.677131354808807, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:23:00', 38.7955169677734, -94.9508895874023, 16, 0.677109479904175, -1.65720558166504, NULL, N'LPKC3', N'2022-10-28', N'19:38:00', 38.7938079833984, -94.9540634155273, 16, 0.677079677581787, -1.65726101398468, NULL, N'LPKC4', N'2022-10-28', N'18:55:00', 38.7909049987793, -94.9580612182617, 16, 0.677029013633728, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'19:18:00', 38.7899284362793, -94.9599304199219, 16, 0.677011966705322, -1.6573634147644, NULL, N'LPKC6', N'2022-10-28', N'19:57:00', 38.787467956543, -94.9645767211914, 17, 0.676968991756439, -1.6574444770813, NULL, N'LPKC7', N'2022-10-28', N'19:22:00', 38.7857284545898, -94.9678039550781, 16, 0.676938652992249, -1.65750086307526, NULL, N'LPKC8', N'2022-10-28', N'19:42:00', 38.7846984863281, -94.9697570800781, 17, 0.676920652389526, -1.65753495693207, NULL ),
( N'LPKC1', N'2022-10-28', N'19:04:00', 38.7967681884766, -94.9485092163086, 17, 0.677131354808807, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'19:24:00', 38.7954483032227, -94.9510116577148, 16, 0.677108287811279, -1.65720772743225, NULL, N'LPKC3', N'2022-10-28', N'19:39:00', 38.7936744689941, -94.9543151855469, 17, 0.677077353000641, -1.65726542472839, NULL, N'LPKC4', N'2022-10-28', N'18:56:00', 38.7909049987793, -94.9580612182617, 16, 0.677029013633728, -1.65733087062836, NULL, N'LPKC5', N'2022-10-28', N'19:19:00', 38.7896957397461, -94.9604034423828, 16, 0.677007913589478, -1.65737164020538, NULL, N'LPKC6', N'2022-10-28', N'19:58:00', 38.7876968383789, -94.9641494750977, 17, 0.676972985267639, -1.65743708610535, NULL, N'LPKC7', N'2022-10-28', N'19:23:00', 38.7856674194336, -94.9679260253906, 16, 0.676937580108643, -1.65750300884247, NULL, N'LPKC8', N'2022-10-28', N'19:43:00', 38.78466796875, -94.9698104858398, 17, 0.676920115947723, -1.65753591060638, NULL ),
( N'LPKC1', N'2022-10-28', N'19:05:00', 38.7967681884766, -94.9485015869141, 17, 0.677131354808807, -1.65716397762299, NULL, N'LPKC2', N'2022-10-28', N'19:25:00', 38.7954444885254, -94.9510192871094, 16, 0.677108228206635, -1.65720796585083, NULL, N'LPKC3', N'2022-10-28', N'19:40:00', 38.7936782836914, -94.9543151855469, 16, 0.677077412605286, -1.65726542472839, NULL, N'LPKC4', N'2022-10-28', N'18:57:00', 38.7910079956055, -94.957878112793, 17, 0.677030801773071, -1.65732765197754, NULL, N'LPKC5', N'2022-10-28', N'19:20:00', 38.7895393371582, -94.9606552124023, 16, 0.677005171775818, -1.6573760509491, NULL, N'LPKC6', N'2022-10-28', N'19:59:00', 38.7879447937012, -94.9636764526367, 17, 0.676977336406708, -1.65742886066437, NULL, N'LPKC7', N'2022-10-28', N'19:24:00', 38.7855682373047, -94.9681091308594, 16, 0.676935851573944, -1.65750622749329, NULL, N'LPKC8', N'2022-10-28', N'19:44:00', 38.7847023010254, -94.9697647094727, 17, 0.676920771598816, -1.65753507614136, NULL ),
( N'LPKC1', N'2022-10-28', N'19:06:00', 38.7967681884766, -94.9485092163086, 17, 0.677131354808807, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'19:26:00', 38.7951927185059, -94.9514923095703, 16, 0.677103817462921, -1.65721619129181, NULL, N'LPKC3', N'2022-10-28', N'19:41:00', 38.7935676574707, -94.9545364379883, 17, 0.677075445652008, -1.65726923942566, NULL, N'LPKC4', N'2022-10-28', N'18:58:00', 38.7911720275879, -94.9575881958008, 17, 0.677033662796021, -1.65732252597809, NULL, N'LPKC5', N'2022-10-28', N'19:21:00', 38.7895431518555, -94.9606475830078, 16, 0.677005231380463, -1.65737593173981, NULL, N'LPKC6', N'2022-10-28', N'20:00:00', 38.7874069213867, -94.9646987915039, 18, 0.676967918872833, -1.65744662284851, NULL, N'LPKC7', N'2022-10-28', N'19:25:00', 38.7855567932129, -94.968132019043, 16, 0.67693567276001, -1.65750658512115, NULL, N'LPKC8', N'2022-10-28', N'19:45:00', 38.7847023010254, -94.9697570800781, 17, 0.676920771598816, -1.65753495693207, NULL ),
( N'LPKC1', N'2022-10-28', N'19:07:00', 38.7967681884766, -94.9485092163086, 17, 0.677131354808807, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'19:27:00', 38.7954063415527, -94.9510879516602, 17, 0.677107572555542, -1.65720903873444, NULL, N'LPKC3', N'2022-10-28', N'19:42:00', 38.7936134338379, -94.9544525146484, 17, 0.677076280117035, -1.65726780891418, NULL, N'LPKC4', N'2022-10-28', N'18:59:00', 38.7911643981934, -94.9576034545898, 17, 0.677033543586731, -1.65732276439667, NULL, N'LPKC5', N'2022-10-28', N'19:22:00', 38.7897262573242, -94.960334777832, 16, 0.677008450031281, -1.65737044811249, NULL, N'LPKC6', N'2022-10-28', N'20:01:00', 38.7872772216797, -94.9649200439453, 18, 0.676965713500977, -1.65745055675507, NULL, N'LPKC7', N'2022-10-28', N'19:26:00', 38.7854614257813, -94.9683151245117, 16, 0.676934003829956, -1.65750980377197, NULL, N'LPKC8', N'2022-10-28', N'19:46:00', 38.7846984863281, -94.9697570800781, 17, 0.676920652389526, -1.65753495693207, NULL ),
( N'LPKC1', N'2022-10-28', N'19:08:00', 38.7967681884766, -94.9485092163086, 17, 0.677131354808807, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'19:28:00', 38.7953453063965, -94.9512023925781, 17, 0.677106499671936, -1.65721106529236, NULL, N'LPKC3', N'2022-10-28', N'19:43:00', 38.7937469482422, -94.9542083740234, 17, 0.677078604698181, -1.65726351737976, NULL, N'LPKC4', N'2022-10-28', N'19:00:00', 38.7911834716797, -94.9575500488281, 17, 0.677033841609955, -1.65732192993164, NULL, N'LPKC5', N'2022-10-28', N'19:23:00', 38.7897644042969, -94.9602508544922, 16, 0.677009105682373, -1.65736901760101, NULL, N'LPKC6', N'2022-10-28', N'20:02:00', 38.7870559692383, -94.9653472900391, 18, 0.676961839199066, -1.65745794773102, NULL, N'LPKC7', N'2022-10-28', N'19:27:00', 38.7854423522949, -94.968376159668, 16, 0.676933646202087, -1.65751087665558, NULL, N'LPKC8', N'2022-10-28', N'19:47:00', 38.7846298217773, -94.9699020385742, 17, 0.676919460296631, -1.65753746032715, NULL ),
( N'LPKC1', N'2022-10-28', N'19:09:00', 38.7967681884766, -94.9485168457031, 17, 0.677131354808807, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:29:00', 38.7951545715332, -94.9515762329102, 17, 0.677103161811829, -1.65721762180328, NULL, N'LPKC3', N'2022-10-28', N'19:44:00', 38.793399810791, -94.9548492431641, 17, 0.677072525024414, -1.65727472305298, NULL, N'LPKC4', N'2022-10-28', N'19:01:00', 38.7914619445801, -94.9570617675781, 17, 0.677038729190826, -1.65731334686279, NULL, N'LPKC5', N'2022-10-28', N'19:24:00', 38.7897605895996, -94.9602355957031, 16, 0.677009046077728, -1.65736877918243, NULL, N'LPKC6', N'2022-10-28', N'20:03:00', 38.7871475219727, -94.9651641845703, 18, 0.676963448524475, -1.6574547290802, NULL, N'LPKC7', N'2022-10-28', N'19:28:00', 38.7856788635254, -94.9679260253906, 16, 0.676937758922577, -1.65750300884247, NULL, N'LPKC8', N'2022-10-28', N'19:48:00', 38.7845687866211, -94.9700088500977, 16, 0.676918387413025, -1.65753936767578, NULL ),
( N'LPKC1', N'2022-10-28', N'19:10:00', 38.7967681884766, -94.9485168457031, 17, 0.677131354808807, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:30:00', 38.7951011657715, -94.9516677856445, 17, 0.677102267742157, -1.65721917152405, NULL, N'LPKC3', N'2022-10-28', N'19:45:00', 38.7934188842773, -94.9548187255859, 17, 0.677072882652283, -1.65727424621582, NULL, N'LPKC4', N'2022-10-28', N'19:02:00', 38.7914199829102, -94.9571228027344, 17, 0.677037954330444, -1.6573144197464, NULL, N'LPKC5', N'2022-10-28', N'19:25:00', 38.7897262573242, -94.9603118896484, 16, 0.677008450031281, -1.65737009048462, NULL, N'LPKC6', N'2022-10-28', N'20:04:00', 38.7869148254395, -94.9655914306641, 18, 0.676959335803986, -1.65746223926544, NULL, N'LPKC7', N'2022-10-28', N'19:29:00', 38.7856750488281, -94.9679336547852, 16, 0.676937758922577, -1.65750312805176, NULL, N'LPKC8', N'2022-10-28', N'19:49:00', 38.7844429016113, -94.9702301025391, 16, 0.676916182041168, -1.65754318237305, NULL ),
( N'LPKC1', N'2022-10-28', N'19:11:00', 38.7967720031738, -94.9485168457031, 17, 0.677131414413452, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:31:00', 38.7951011657715, -94.9516754150391, 17, 0.677102267742157, -1.65721940994263, NULL, N'LPKC3', N'2022-10-28', N'19:46:00', 38.7934188842773, -94.9548187255859, 17, 0.677072882652283, -1.65727424621582, NULL, N'LPKC4', N'2022-10-28', N'19:03:00', 38.7918395996094, -94.9563217163086, 17, 0.677045285701752, -1.65730047225952, NULL, N'LPKC5', N'2022-10-28', N'19:26:00', 38.7896194458008, -94.9605407714844, 16, 0.677006542682648, -1.65737402439117, NULL, N'LPKC6', N'2022-10-28', N'20:05:00', 38.7869186401367, -94.9655838012695, 19, 0.676959455013275, -1.65746212005615, NULL, N'LPKC7', N'2022-10-28', N'19:30:00', 38.7855682373047, -94.9681091308594, 16, 0.676935851573944, -1.65750622749329, NULL, N'LPKC8', N'2022-10-28', N'19:50:00', 38.784481048584, -94.9701766967773, 17, 0.676916897296906, -1.65754222869873, NULL ),
( N'LPKC1', N'2022-10-28', N'19:12:00', 38.7967720031738, -94.9485168457031, 17, 0.677131414413452, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:32:00', 38.7951698303223, -94.9515533447266, 17, 0.677103459835052, -1.65721726417542, NULL, N'LPKC3', N'2022-10-28', N'19:47:00', 38.7933769226074, -94.9549102783203, 16, 0.677072167396545, -1.65727579593658, NULL, N'LPKC4', N'2022-10-28', N'19:04:00', 38.7918701171875, -94.9562301635742, 17, 0.677045881748199, -1.65729880332947, NULL, N'LPKC5', N'2022-10-28', N'19:27:00', 38.7896156311035, -94.9605331420898, 17, 0.677006483078003, -1.65737390518188, NULL, N'LPKC6', N'2022-10-28', N'20:06:00', 38.7870216369629, -94.9654083251953, 19, 0.676961243152618, -1.65745902061462, NULL, N'LPKC7', N'2022-10-28', N'19:31:00', 38.7855644226074, -94.9681167602539, 16, 0.676935791969299, -1.65750634670258, NULL, N'LPKC8', N'2022-10-28', N'19:51:00', 38.7845001220703, -94.9701385498047, 17, 0.676917195320129, -1.65754163265228, NULL ),
( N'LPKC1', N'2022-10-28', N'19:13:00', 38.7967758178711, -94.9485168457031, 16, 0.677131474018097, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:33:00', 38.7951393127441, -94.9516067504883, 17, 0.67710292339325, -1.65721809864044, NULL, N'LPKC3', N'2022-10-28', N'19:48:00', 38.7933883666992, -94.9548950195313, 16, 0.67707234621048, -1.65727555751801, NULL, N'LPKC4', N'2022-10-28', N'19:05:00', 38.7920303344727, -94.9559631347656, 17, 0.677048623561859, -1.65729415416718, NULL, N'LPKC5', N'2022-10-28', N'19:28:00', 38.7896118164063, -94.9605407714844, 17, 0.677006423473358, -1.65737402439117, NULL, N'LPKC6', N'2022-10-28', N'20:07:00', 38.7871208190918, -94.9652252197266, 19, 0.676962971687317, -1.65745580196381, NULL, N'LPKC7', N'2022-10-28', N'19:32:00', 38.7857055664063, -94.9678955078125, 17, 0.676938235759735, -1.65750241279602, NULL, N'LPKC8', N'2022-10-28', N'19:52:00', 38.7844200134277, -94.9702987670898, 17, 0.6769158244133, -1.65754437446594, NULL ),
( N'LPKC1', N'2022-10-28', N'19:14:00', 38.7967758178711, -94.9485244750977, 16, 0.677131474018097, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'19:34:00', 38.7951507568359, -94.9515838623047, 17, 0.677103102207184, -1.65721774101257, NULL, N'LPKC3', N'2022-10-28', N'19:49:00', 38.793384552002, -94.9548950195313, 17, 0.677072286605835, -1.65727555751801, NULL, N'LPKC4', N'2022-10-28', N'19:06:00', 38.7918701171875, -94.9562911987305, 17, 0.677045881748199, -1.65729987621307, NULL, N'LPKC5', N'2022-10-28', N'19:29:00', 38.7896270751953, -94.9604949951172, 16, 0.677006721496582, -1.65737330913544, NULL, N'LPKC6', N'2022-10-28', N'20:08:00', 38.7869644165039, -94.9655227661133, 19, 0.676960229873657, -1.65746104717255, NULL, N'LPKC7', N'2022-10-28', N'19:33:00', 38.7855834960938, -94.9681091308594, 17, 0.676936149597168, -1.65750622749329, NULL, N'LPKC8', N'2022-10-28', N'19:53:00', 38.7845001220703, -94.9701232910156, 17, 0.676917195320129, -1.6575413942337, NULL ),
( N'LPKC1', N'2022-10-28', N'19:15:00', 38.7967796325684, -94.9485168457031, 16, 0.677131533622742, -1.65716421604156, 0.043914955, N'LPKC2', N'2022-10-28', N'19:35:00', 38.7951507568359, -94.9515686035156, 17, 0.677103102207184, -1.65721750259399, NULL, N'LPKC3', N'2022-10-28', N'19:50:00', 38.7934684753418, -94.9547424316406, 17, 0.67707371711731, -1.65727293491364, NULL, N'LPKC4', N'2022-10-28', N'19:07:00', 38.7920265197754, -94.9559783935547, 17, 0.677048563957214, -1.65729451179504, NULL, N'LPKC5', N'2022-10-28', N'19:30:00', 38.7896194458008, -94.9605102539063, 17, 0.677006542682648, -1.65737354755402, NULL, N'LPKC6', N'2022-10-28', N'20:09:00', 38.7869911193848, -94.9654769897461, 19, 0.676960706710815, -1.65746021270752, NULL, N'LPKC7', N'2022-10-28', N'19:34:00', 38.7856674194336, -94.9679412841797, 16, 0.676937580108643, -1.65750324726105, NULL, N'LPKC8', N'2022-10-28', N'19:54:00', 38.7844581604004, -94.97021484375, 17, 0.676916480064392, -1.65754294395447, NULL ),
( N'LPKC1', N'2022-10-28', N'19:16:00', 38.7967796325684, -94.9485168457031, 16, 0.677131533622742, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:36:00', 38.7951545715332, -94.9515762329102, 17, 0.677103161811829, -1.65721762180328, NULL, N'LPKC3', N'2022-10-28', N'19:51:00', 38.7934684753418, -94.9547500610352, 16, 0.67707371711731, -1.65727305412292, NULL, N'LPKC4', N'2022-10-28', N'19:08:00', 38.7918395996094, -94.9563369750977, 17, 0.677045285701752, -1.6573007106781, NULL, N'LPKC5', N'2022-10-28', N'19:31:00', 38.7892837524414, -94.9611282348633, 17, 0.67700070142746, -1.65738439559937, NULL, N'LPKC6', N'2022-10-28', N'20:10:00', 38.7870445251465, -94.9653396606445, 19, 0.676961600780487, -1.65745782852173, NULL, N'LPKC7', N'2022-10-28', N'19:35:00', 38.7854843139648, -94.9682922363281, 17, 0.676934421062469, -1.65750932693481, NULL, N'LPKC8', N'2022-10-28', N'19:55:00', 38.7847290039063, -94.9697189331055, 17, 0.676921248435974, -1.65753424167633, NULL ),
( N'LPKC1', N'2022-10-28', N'19:17:00', 38.7967796325684, -94.9485168457031, 16, 0.677131533622742, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:37:00', 38.7947959899902, -94.9522476196289, 17, 0.677096903324127, -1.65722930431366, NULL, N'LPKC3', N'2022-10-28', N'19:52:00', 38.7934684753418, -94.9547576904297, 15, 0.67707371711731, -1.65727317333221, NULL, N'LPKC4', N'2022-10-28', N'19:09:00', 38.792106628418, -94.9558258056641, 17, 0.677049994468689, -1.65729176998138, NULL, N'LPKC5', N'2022-10-28', N'19:32:00', 38.7893142700195, -94.9610595703125, 17, 0.677001237869263, -1.65738308429718, NULL, N'LPKC6', N'2022-10-28', N'20:11:00', 38.7874717712402, -94.9645538330078, 19, 0.676969051361084, -1.65744411945343, NULL, N'LPKC7', N'2022-10-28', N'19:36:00', 38.7858047485352, -94.9676666259766, 17, 0.676939964294434, -1.65749847888947, NULL, N'LPKC8', N'2022-10-28', N'19:56:00', 38.7851600646973, -94.9689178466797, 17, 0.676928758621216, -1.65752029418945, NULL ),
( N'LPKC1', N'2022-10-28', N'19:18:00', 38.7967796325684, -94.9485168457031, 16, 0.677131533622742, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:38:00', 38.794677734375, -94.9524993896484, 17, 0.67709481716156, -1.65723371505737, NULL, N'LPKC3', N'2022-10-28', N'19:53:00', 38.7933959960938, -94.9548797607422, 16, 0.677072465419769, -1.65727531909943, NULL, N'LPKC4', N'2022-10-28', N'19:10:00', 38.7921371459961, -94.9558029174805, 17, 0.677050530910492, -1.65729141235352, NULL, N'LPKC5', N'2022-10-28', N'19:33:00', 38.789363861084, -94.9609680175781, 16, 0.67700207233429, -1.65738153457642, NULL, N'LPKC6', N'2022-10-28', N'20:12:00', 38.7874450683594, -94.9646148681641, 19, 0.676968634128571, -1.65744519233704, NULL, N'LPKC7', N'2022-10-28', N'19:37:00', 38.7858085632324, -94.9676742553711, 17, 0.676940023899078, -1.65749859809875, NULL, N'LPKC8', N'2022-10-28', N'19:57:00', 38.7851753234863, -94.9688949584961, 17, 0.676928997039795, -1.65751993656158, NULL ),
( N'LPKC1', N'2022-10-28', N'19:19:00', 38.7967796325684, -94.9485168457031, 16, 0.677131533622742, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:39:00', 38.7945938110352, -94.95263671875, 17, 0.677093386650085, -1.65723609924316, NULL, N'LPKC3', N'2022-10-28', N'19:54:00', 38.7935371398926, -94.9546203613281, 16, 0.67707496881485, -1.65727078914642, NULL, N'LPKC4', N'2022-10-28', N'19:11:00', 38.7918395996094, -94.9563217163086, 17, 0.677045285701752, -1.65730047225952, NULL, N'LPKC5', N'2022-10-28', N'19:34:00', 38.7893409729004, -94.9610137939453, 17, 0.677001714706421, -1.65738236904144, NULL, N'LPKC6', N'2022-10-28', N'20:13:00', 38.7873802185059, -94.9647369384766, 19, 0.67696750164032, -1.65744733810425, NULL, N'LPKC7', N'2022-10-28', N'19:38:00', 38.7856903076172, -94.9679107666016, 16, 0.676937997341156, -1.65750277042389, NULL, N'LPKC8', N'2022-10-28', N'19:58:00', 38.7852668762207, -94.9687347412109, 17, 0.676930606365204, -1.65751707553864, NULL ),
( N'LPKC1', N'2022-10-28', N'19:20:00', 38.7967758178711, -94.9485168457031, 16, 0.677131474018097, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:40:00', 38.7946281433105, -94.9525756835938, 17, 0.677093982696533, -1.65723502635956, NULL, N'LPKC3', N'2022-10-28', N'19:55:00', 38.7935447692871, -94.9546051025391, 16, 0.677075088024139, -1.65727055072784, NULL, N'LPKC4', N'2022-10-28', N'19:12:00', 38.7920417785645, -94.955940246582, 17, 0.677048861980438, -1.65729379653931, NULL, N'LPKC5', N'2022-10-28', N'19:35:00', 38.7891159057617, -94.9614562988281, 17, 0.676997780799866, -1.65739011764526, NULL, N'LPKC6', N'2022-10-28', N'20:14:00', 38.7872657775879, -94.9649429321289, 19, 0.676965475082397, -1.65745091438293, NULL, N'LPKC7', N'2022-10-28', N'19:39:00', 38.7857475280762, -94.9678268432617, 16, 0.676939010620117, -1.65750122070313, NULL, N'LPKC8', N'2022-10-28', N'19:59:00', 38.7852020263672, -94.9688339233398, 17, 0.676929473876953, -1.65751886367798, NULL ),
( N'LPKC1', N'2022-10-28', N'19:21:00', 38.7967758178711, -94.9485168457031, 16, 0.677131474018097, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:41:00', 38.7943840026855, -94.9530181884766, 16, 0.677089750766754, -1.65724277496338, NULL, N'LPKC3', N'2022-10-28', N'19:56:00', 38.793384552002, -94.9548797607422, 15, 0.677072286605835, -1.65727531909943, NULL, N'LPKC4', N'2022-10-28', N'19:13:00', 38.7919311523438, -94.9561386108398, 16, 0.677046895027161, -1.6572972536087, NULL, N'LPKC5', N'2022-10-28', N'19:36:00', 38.789005279541, -94.9616470336914, 17, 0.676995873451233, -1.65739345550537, NULL, N'LPKC6', N'2022-10-28', N'20:15:00', 38.7874717712402, -94.9645538330078, 19, 0.676969051361084, -1.65744411945343, NULL, N'LPKC7', N'2022-10-28', N'19:40:00', 38.7859268188477, -94.9674682617188, 17, 0.676942110061646, -1.65749502182007, NULL, N'LPKC8', N'2022-10-28', N'20:00:00', 38.7850952148438, -94.9690170288086, 18, 0.676927626132965, -1.6575220823288, NULL ),
( N'LPKC1', N'2022-10-28', N'19:22:00', 38.7967758178711, -94.9485168457031, 16, 0.677131474018097, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:42:00', 38.7943000793457, -94.9531784057617, 17, 0.677088260650635, -1.65724563598633, NULL, N'LPKC3', N'2022-10-28', N'19:57:00', 38.7933807373047, -94.9548797607422, 17, 0.67707222700119, -1.65727531909943, NULL, N'LPKC4', N'2022-10-28', N'19:14:00', 38.7920455932617, -94.9559555053711, 16, 0.677048921585083, -1.65729403495789, NULL, N'LPKC5', N'2022-10-28', N'19:37:00', 38.7892913818359, -94.9611434936523, 17, 0.677000820636749, -1.65738463401794, NULL, N'LPKC6', N'2022-10-28', N'20:16:00', 38.7875442504883, -94.9644470214844, 19, 0.676970362663269, -1.65744233131409, NULL, N'LPKC7', N'2022-10-28', N'19:41:00', 38.7862129211426, -94.966911315918, 17, 0.676947116851807, -1.65748524665833, NULL, N'LPKC8', N'2022-10-28', N'20:01:00', 38.7851371765137, -94.9689712524414, 18, 0.676928341388702, -1.65752124786377, NULL ),
( N'LPKC1', N'2022-10-28', N'19:23:00', 38.7967720031738, -94.9485168457031, 16, 0.677131414413452, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:43:00', 38.7944145202637, -94.9529647827148, 17, 0.677090227603912, -1.65724182128906, NULL, N'LPKC3', N'2022-10-28', N'19:58:00', 38.7930526733398, -94.9555435180664, 16, 0.677066504955292, -1.65728688240051, NULL, N'LPKC4', N'2022-10-28', N'19:15:00', 38.791934967041, -94.9561386108398, 16, 0.677046954631805, -1.6572972536087, 0.459853288, N'LPKC5', N'2022-10-28', N'19:38:00', 38.7893829345703, -94.9609680175781, 17, 0.677002429962158, -1.65738153457642, NULL, N'LPKC6', N'2022-10-28', N'20:17:00', 38.7875213623047, -94.964469909668, 19, 0.676969945430756, -1.65744268894196, NULL, N'LPKC7', N'2022-10-28', N'19:42:00', 38.7862892150879, -94.9667816162109, 16, 0.676948428153992, -1.65748298168182, NULL, N'LPKC8', N'2022-10-28', N'20:02:00', 38.7851219177246, -94.9690017700195, 18, 0.676928043365479, -1.65752172470093, NULL ),
( N'LPKC1', N'2022-10-28', N'19:24:00', 38.7967720031738, -94.9485168457031, 16, 0.677131414413452, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:44:00', 38.7944107055664, -94.9529647827148, 17, 0.677090167999268, -1.65724182128906, NULL, N'LPKC3', N'2022-10-28', N'19:59:00', 38.7925605773926, -94.9564437866211, 16, 0.677057921886444, -1.65730261802673, NULL, N'LPKC4', N'2022-10-28', N'19:16:00', 38.7919769287109, -94.9560546875, 16, 0.677047729492188, -1.65729582309723, NULL, N'LPKC5', N'2022-10-28', N'19:39:00', 38.7899017333984, -94.9599761962891, 17, 0.677011489868164, -1.65736424922943, NULL, N'LPKC6', N'2022-10-28', N'20:18:00', 38.7875671386719, -94.9643859863281, 19, 0.676970779895782, -1.65744113922119, NULL, N'LPKC7', N'2022-10-28', N'19:43:00', 38.7862243652344, -94.9668807983398, 17, 0.676947295665741, -1.65748476982117, NULL, N'LPKC8', N'2022-10-28', N'20:03:00', 38.7851295471191, -94.9689712524414, 18, 0.676928222179413, -1.65752124786377, NULL ),
( N'LPKC1', N'2022-10-28', N'19:25:00', 38.7967720031738, -94.9485168457031, 16, 0.677131414413452, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:45:00', 38.7948036193848, -94.9522247314453, 17, 0.677097022533417, -1.65722894668579, NULL, N'LPKC3', N'2022-10-28', N'20:00:00', 38.7923469543457, -94.9568328857422, 16, 0.677054166793823, -1.65730941295624, NULL, N'LPKC4', N'2022-10-28', N'19:17:00', 38.7919578552246, -94.9560928344727, 16, 0.677047371864319, -1.65729641914368, NULL, N'LPKC5', N'2022-10-28', N'19:40:00', 38.7898864746094, -94.9600067138672, 17, 0.677011251449585, -1.65736472606659, NULL, N'LPKC6', N'2022-10-28', N'20:19:00', 38.7870483398438, -94.9653625488281, 19, 0.676961719989777, -1.6574581861496, NULL, N'LPKC7', N'2022-10-28', N'19:44:00', 38.7863235473633, -94.9666900634766, 16, 0.676949024200439, -1.65748143196106, NULL, N'LPKC8', N'2022-10-28', N'20:04:00', 38.7846069335938, -94.9699478149414, 18, 0.676919102668762, -1.65753829479218, NULL ),
( N'LPKC1', N'2022-10-28', N'19:26:00', 38.7967720031738, -94.9485092163086, 16, 0.677131414413452, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'19:46:00', 38.7949867248535, -94.9518737792969, 17, 0.677100241184235, -1.65722286701202, NULL, N'LPKC3', N'2022-10-28', N'20:01:00', 38.7921981811523, -94.9571075439453, 17, 0.677051603794098, -1.65731418132782, NULL, N'LPKC4', N'2022-10-28', N'19:18:00', 38.7920265197754, -94.9559631347656, 16, 0.677048563957214, -1.65729415416718, NULL, N'LPKC5', N'2022-10-28', N'19:41:00', 38.7895050048828, -94.9607467651367, 17, 0.67700457572937, -1.65737771987915, NULL, N'LPKC6', N'2022-10-28', N'20:20:00', 38.7871246337891, -94.9652252197266, 19, 0.676963031291962, -1.65745580196381, NULL, N'LPKC7', N'2022-10-28', N'19:45:00', 38.7862968444824, -94.9667587280273, 16, 0.676948547363281, -1.65748262405396, NULL, N'LPKC8', N'2022-10-28', N'20:05:00', 38.784782409668, -94.9696197509766, 19, 0.676922142505646, -1.65753257274628, NULL ),
( N'LPKC1', N'2022-10-28', N'19:27:00', 38.7967681884766, -94.9485092163086, 16, 0.677131354808807, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'19:47:00', 38.7954788208008, -94.9509658813477, 17, 0.677108824253082, -1.65720701217651, NULL, N'LPKC3', N'2022-10-28', N'20:02:00', 38.7925682067871, -94.956428527832, 18, 0.677058041095734, -1.65730226039886, NULL, N'LPKC4', N'2022-10-28', N'19:19:00', 38.7923965454102, -94.9552764892578, 16, 0.677055060863495, -1.65728223323822, NULL, N'LPKC5', N'2022-10-28', N'19:42:00', 38.7894859313965, -94.9607772827148, 17, 0.677004218101501, -1.65737819671631, NULL, N'LPKC6', N'2022-10-28', N'20:21:00', 38.78759765625, -94.9643249511719, 19, 0.676971256732941, -1.65744018554688, NULL, N'LPKC7', N'2022-10-28', N'19:46:00', 38.7862510681152, -94.9668350219727, 16, 0.676947772502899, -1.65748393535614, NULL, N'LPKC8', N'2022-10-28', N'20:06:00', 38.7851371765137, -94.9689407348633, 19, 0.676928341388702, -1.65752065181732, NULL ),
( N'LPKC1', N'2022-10-28', N'19:28:00', 38.7967681884766, -94.9485168457031, 17, 0.677131354808807, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:48:00', 38.7959098815918, -94.9501647949219, 16, 0.677116334438324, -1.65719294548035, NULL, N'LPKC3', N'2022-10-28', N'20:03:00', 38.7923393249512, -94.9568710327148, 17, 0.677054047584534, -1.65731000900269, NULL, N'LPKC4', N'2022-10-28', N'19:20:00', 38.7923583984375, -94.9553527832031, 16, 0.677054345607758, -1.65728354454041, NULL, N'LPKC5', N'2022-10-28', N'19:43:00', 38.7891464233398, -94.9614410400391, 17, 0.676998317241669, -1.6573897600174, NULL, N'LPKC6', N'2022-10-28', N'20:22:00', 38.7878227233887, -94.9639358520508, 19, 0.676975190639496, -1.65743339061737, NULL, N'LPKC7', N'2022-10-28', N'19:47:00', 38.7861251831055, -94.9670867919922, 16, 0.676945567131042, -1.65748834609985, NULL, N'LPKC8', N'2022-10-28', N'20:07:00', 38.7852249145508, -94.9687957763672, 19, 0.676929831504822, -1.65751814842224, NULL ),
( N'LPKC1', N'2022-10-28', N'19:29:00', 38.7967720031738, -94.9485168457031, 17, 0.677131414413452, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:49:00', 38.7961692810059, -94.9496765136719, 16, 0.677120864391327, -1.65718448162079, NULL, N'LPKC3', N'2022-10-28', N'20:04:00', 38.7922134399414, -94.9570999145508, 17, 0.677051842212677, -1.65731406211853, NULL, N'LPKC4', N'2022-10-28', N'19:21:00', 38.7919006347656, -94.9562225341797, 16, 0.677046358585358, -1.65729868412018, NULL, N'LPKC5', N'2022-10-28', N'19:44:00', 38.788688659668, -94.9622421264648, 17, 0.676990330219269, -1.65740382671356, NULL, N'LPKC6', N'2022-10-28', N'20:23:00', 38.7879676818848, -94.9636611938477, 19, 0.676977753639221, -1.6574285030365, NULL, N'LPKC7', N'2022-10-28', N'19:48:00', 38.7858924865723, -94.967529296875, 16, 0.676941514015198, -1.65749609470367, NULL, N'LPKC8', N'2022-10-28', N'20:08:00', 38.7850723266602, -94.9690856933594, 19, 0.676927208900452, -1.65752327442169, NULL ),
( N'LPKC1', N'2022-10-28', N'19:30:00', 38.7967720031738, -94.9485168457031, 17, 0.677131414413452, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:50:00', 38.7960777282715, -94.9498748779297, 17, 0.677119255065918, -1.65718793869019, NULL, N'LPKC3', N'2022-10-28', N'20:05:00', 38.7924690246582, -94.9566497802734, 18, 0.677056312561035, -1.65730619430542, NULL, N'LPKC4', N'2022-10-28', N'19:22:00', 38.7915382385254, -94.9569244384766, 16, 0.677040040493011, -1.657310962677, NULL, N'LPKC5', N'2022-10-28', N'19:45:00', 38.7888488769531, -94.9619750976563, 16, 0.676993131637573, -1.65739917755127, NULL, N'LPKC6', N'2022-10-28', N'20:24:00', 38.7882499694824, -94.9630813598633, 18, 0.676982641220093, -1.65741848945618, NULL, N'LPKC7', N'2022-10-28', N'19:49:00', 38.7862091064453, -94.9668960571289, 17, 0.676947057247162, -1.65748500823975, NULL, N'LPKC8', N'2022-10-28', N'20:09:00', 38.7851371765137, -94.9689483642578, 19, 0.676928341388702, -1.65752077102661, NULL ),
( N'LPKC1', N'2022-10-28', N'19:31:00', 38.7967681884766, -94.9485168457031, 17, 0.677131354808807, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:51:00', 38.7960815429688, -94.9498596191406, 17, 0.677119374275208, -1.65718770027161, NULL, N'LPKC3', N'2022-10-28', N'20:06:00', 38.7926063537598, -94.9563598632813, 18, 0.677058696746826, -1.65730106830597, NULL, N'LPKC4', N'2022-10-28', N'19:23:00', 38.7914543151855, -94.9570617675781, 16, 0.677038609981537, -1.65731334686279, NULL, N'LPKC5', N'2022-10-28', N'19:46:00', 38.7888450622559, -94.9619979858398, 17, 0.676993072032928, -1.65739953517914, NULL, N'LPKC6', N'2022-10-28', N'20:25:00', 38.7881851196289, -94.9632186889648, 19, 0.676981568336487, -1.65742087364197, NULL, N'LPKC7', N'2022-10-28', N'19:50:00', 38.7862358093262, -94.9668426513672, 17, 0.67694753408432, -1.65748405456543, NULL, N'LPKC8', N'2022-10-28', N'20:10:00', 38.7849159240723, -94.969367980957, 19, 0.676924467086792, -1.65752816200256, NULL ),
( N'LPKC1', N'2022-10-28', N'19:32:00', 38.7967720031738, -94.9485168457031, 17, 0.677131414413452, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:52:00', 38.7960777282715, -94.9498519897461, 17, 0.677119255065918, -1.65718758106232, NULL, N'LPKC3', N'2022-10-28', N'20:07:00', 38.7926025390625, -94.9563751220703, 18, 0.677058637142181, -1.65730142593384, NULL, N'LPKC4', N'2022-10-28', N'19:24:00', 38.7910919189453, -94.9577560424805, 16, 0.677032232284546, -1.65732550621033, NULL, N'LPKC5', N'2022-10-28', N'19:47:00', 38.7889518737793, -94.9617767333984, 16, 0.676994919776917, -1.65739560127258, NULL, N'LPKC6', N'2022-10-28', N'20:26:00', 38.7878761291504, -94.9638137817383, 19, 0.676976144313812, -1.65743124485016, NULL, N'LPKC7', N'2022-10-28', N'19:51:00', 38.7862434387207, -94.9668502807617, 17, 0.67694765329361, -1.65748417377472, NULL, N'LPKC8', N'2022-10-28', N'20:11:00', 38.7849388122559, -94.9693069458008, 19, 0.676924884319305, -1.65752708911896, NULL ),
( N'LPKC1', N'2022-10-28', N'19:33:00', 38.7967796325684, -94.9485092163086, 17, 0.677131533622742, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'19:53:00', 38.7958831787109, -94.9502029418945, 17, 0.677115917205811, -1.65719366073608, NULL, N'LPKC3', N'2022-10-28', N'20:08:00', 38.7929153442383, -94.9558029174805, 17, 0.677064120769501, -1.65729141235352, NULL, N'LPKC4', N'2022-10-28', N'19:25:00', 38.7909812927246, -94.9579544067383, 16, 0.677030324935913, -1.65732896327972, NULL, N'LPKC5', N'2022-10-28', N'19:48:00', 38.788990020752, -94.9617004394531, 16, 0.676995575428009, -1.6573942899704, NULL, N'LPKC6', N'2022-10-28', N'20:27:00', 38.7881774902344, -94.963249206543, 19, 0.676981389522552, -1.65742135047913, NULL, N'LPKC7', N'2022-10-28', N'19:52:00', 38.786449432373, -94.9664993286133, 17, 0.676951229572296, -1.65747809410095, NULL, N'LPKC8', N'2022-10-28', N'20:12:00', 38.7851409912109, -94.9689483642578, 19, 0.676928400993347, -1.65752077102661, NULL ),
( N'LPKC1', N'2022-10-28', N'19:34:00', 38.7967796325684, -94.9485168457031, 17, 0.677131533622742, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:54:00', 38.795783996582, -94.9504165649414, 17, 0.677114129066467, -1.65719735622406, NULL, N'LPKC3', N'2022-10-28', N'20:09:00', 38.792911529541, -94.9558029174805, 19, 0.677064001560211, -1.65729141235352, NULL, N'LPKC4', N'2022-10-28', N'19:26:00', 38.7908401489258, -94.9582214355469, 16, 0.677027881145477, -1.65733361244202, NULL, N'LPKC5', N'2022-10-28', N'19:49:00', 38.7889518737793, -94.9617691040039, 17, 0.676994919776917, -1.65739548206329, NULL, N'LPKC6', N'2022-10-28', N'20:28:00', 38.7881469726563, -94.9633178710938, 19, 0.67698085308075, -1.65742254257202, NULL, N'LPKC7', N'2022-10-28', N'19:53:00', 38.7861824035645, -94.9669799804688, 17, 0.676946580410004, -1.65748643875122, NULL, N'LPKC8', N'2022-10-28', N'20:13:00', 38.7851409912109, -94.9689483642578, 19, 0.676928400993347, -1.65752077102661, NULL ),
( N'LPKC1', N'2022-10-28', N'19:35:00', 38.7967796325684, -94.9485168457031, 17, 0.677131533622742, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:55:00', 38.7958145141602, -94.9503555297852, 17, 0.67711466550827, -1.65719628334045, NULL, N'LPKC3', N'2022-10-28', N'20:10:00', 38.7929801940918, -94.9556732177734, 18, 0.677065253257751, -1.65728914737701, NULL, N'LPKC4', N'2022-10-28', N'19:27:00', 38.7904014587402, -94.9590454101563, 16, 0.677020192146301, -1.65734803676605, NULL, N'LPKC5', N'2022-10-28', N'19:50:00', 38.7888336181641, -94.9619827270508, 17, 0.676992833614349, -1.65739929676056, NULL, N'LPKC6', N'2022-10-28', N'20:29:00', 38.788158416748, -94.9633102416992, 18, 0.676981091499329, -1.65742242336273, NULL, N'LPKC7', N'2022-10-28', N'19:54:00', 38.7861862182617, -94.9669799804688, 16, 0.676946640014648, -1.65748643875122, NULL, N'LPKC8', N'2022-10-28', N'20:14:00', 38.7848434448242, -94.9695053100586, 19, 0.676923215389252, -1.65753054618835, NULL ),
( N'LPKC1', N'2022-10-28', N'19:36:00', 38.7967796325684, -94.9485168457031, 17, 0.677131533622742, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:56:00', 38.7957534790039, -94.9504623413086, 17, 0.677113652229309, -1.65719819068909, NULL, N'LPKC3', N'2022-10-28', N'20:11:00', 38.7924728393555, -94.9566116333008, 18, 0.67705637216568, -1.65730547904968, NULL, N'LPKC4', N'2022-10-28', N'19:28:00', 38.7902069091797, -94.9594116210938, 17, 0.677016794681549, -1.6573543548584, NULL, N'LPKC5', N'2022-10-28', N'19:51:00', 38.7889251708984, -94.9617614746094, 17, 0.676994442939758, -1.657395362854, NULL, N'LPKC6', N'2022-10-28', N'20:30:00', 38.787540435791, -94.9644546508789, 18, 0.676970303058624, -1.65744245052338, NULL, N'LPKC7', N'2022-10-28', N'19:55:00', 38.7861480712891, -94.9670333862305, 17, 0.676945984363556, -1.65748739242554, NULL, N'LPKC8', N'2022-10-28', N'20:15:00', 38.7851066589355, -94.9690170288086, 19, 0.676927804946899, -1.6575220823288, NULL ),
( N'LPKC1', N'2022-10-28', N'19:37:00', 38.7967796325684, -94.9485168457031, 17, 0.677131533622742, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:57:00', 38.7952575683594, -94.9513931274414, 17, 0.677104949951172, -1.65721440315247, NULL, N'LPKC3', N'2022-10-28', N'20:12:00', 38.7920951843262, -94.9573287963867, 19, 0.67704975605011, -1.65731799602509, NULL, N'LPKC4', N'2022-10-28', N'19:29:00', 38.7905426025391, -94.9587707519531, 16, 0.677022695541382, -1.65734314918518, NULL, N'LPKC5', N'2022-10-28', N'19:52:00', 38.7889366149902, -94.9617462158203, 17, 0.676994621753693, -1.65739512443542, NULL, N'LPKC6', N'2022-10-28', N'20:31:00', 38.7873077392578, -94.9648590087891, 18, 0.676966190338135, -1.65744948387146, NULL, N'LPKC7', N'2022-10-28', N'19:56:00', 38.7861785888672, -94.9669799804688, 17, 0.676946520805359, -1.65748643875122, NULL, N'LPKC8', N'2022-10-28', N'20:16:00', 38.7851867675781, -94.9688415527344, 19, 0.676929175853729, -1.65751898288727, NULL ),
( N'LPKC1', N'2022-10-28', N'19:38:00', 38.7967796325684, -94.9485168457031, 17, 0.677131533622742, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'19:58:00', 38.7952003479004, -94.9515228271484, 17, 0.677103996276855, -1.65721666812897, NULL, N'LPKC3', N'2022-10-28', N'20:13:00', 38.7919960021973, -94.9575119018555, 18, 0.677048027515411, -1.6573212146759, NULL, N'LPKC4', N'2022-10-28', N'19:30:00', 38.790283203125, -94.9592666625977, 17, 0.677018165588379, -1.65735185146332, NULL, N'LPKC5', N'2022-10-28', N'19:53:00', 38.7890930175781, -94.9615097045898, 16, 0.676997363567352, -1.65739095211029, NULL, N'LPKC6', N'2022-10-28', N'20:32:00', 38.7874069213867, -94.9646911621094, 18, 0.676967918872833, -1.65744650363922, NULL, N'LPKC7', N'2022-10-28', N'19:57:00', 38.7862205505371, -94.9668884277344, 17, 0.676947236061096, -1.65748488903046, NULL, N'LPKC8', N'2022-10-28', N'20:17:00', 38.7855682373047, -94.9681243896484, 19, 0.676935851573944, -1.65750646591187, NULL ),
( N'LPKC1', N'2022-10-28', N'19:39:00', 38.7967872619629, -94.9485244750977, 17, 0.677131652832031, -1.65716433525085, NULL, N'LPKC2', N'2022-10-28', N'19:59:00', 38.7952690124512, -94.9513854980469, 17, 0.677105188369751, -1.65721428394318, NULL, N'LPKC3', N'2022-10-28', N'20:14:00', 38.7919998168945, -94.9574966430664, 19, 0.677048087120056, -1.65732097625732, NULL, N'LPKC4', N'2022-10-28', N'19:31:00', 38.7901420593262, -94.9595413208008, 17, 0.677015721797943, -1.6573566198349, NULL, N'LPKC5', N'2022-10-28', N'19:54:00', 38.7890892028809, -94.9615097045898, 17, 0.676997303962708, -1.65739095211029, NULL, N'LPKC6', N'2022-10-28', N'20:33:00', 38.7871627807617, -94.9651412963867, 18, 0.676963686943054, -1.65745437145233, NULL, N'LPKC7', N'2022-10-28', N'19:58:00', 38.7864036560059, -94.9665374755859, 17, 0.676950454711914, -1.65747880935669, NULL, N'LPKC8', N'2022-10-28', N'20:18:00', 38.7855949401855, -94.9681015014648, 19, 0.676936328411102, -1.65750598907471, NULL ),
( N'LPKC1', N'2022-10-28', N'19:40:00', 38.7967872619629, -94.9485168457031, 17, 0.677131652832031, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'20:00:00', 38.7950744628906, -94.9517211914063, 18, 0.677101790904999, -1.65722012519836, NULL, N'LPKC3', N'2022-10-28', N'20:15:00', 38.7917251586914, -94.9580078125, 19, 0.677043318748474, -1.65732991695404, NULL, N'LPKC4', N'2022-10-28', N'19:32:00', 38.7907295227051, -94.9584503173828, 17, 0.6770259141922, -1.65733754634857, NULL, N'LPKC5', N'2022-10-28', N'19:55:00', 38.7891235351563, -94.9614410400391, 17, 0.676997900009155, -1.6573897600174, NULL, N'LPKC6', N'2022-10-28', N'20:34:00', 38.7871284484863, -94.965217590332, 18, 0.676963090896606, -1.65745568275452, NULL, N'LPKC7', N'2022-10-28', N'19:59:00', 38.7864112854004, -94.9665298461914, 17, 0.676950573921204, -1.65747857093811, NULL, N'LPKC8', N'2022-10-28', N'20:19:00', 38.7855949401855, -94.9681091308594, 19, 0.676936328411102, -1.65750622749329, NULL ),
( N'LPKC1', N'2022-10-28', N'19:41:00', 38.7967872619629, -94.9485168457031, 17, 0.677131652832031, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'20:01:00', 38.7947959899902, -94.9522552490234, 18, 0.677096903324127, -1.65722942352295, NULL, N'LPKC3', N'2022-10-28', N'20:16:00', 38.7917671203613, -94.9579391479492, 19, 0.677044034004211, -1.65732872486115, NULL, N'LPKC4', N'2022-10-28', N'19:33:00', 38.7907524108887, -94.9583892822266, 17, 0.677026331424713, -1.65733659267426, NULL, N'LPKC5', N'2022-10-28', N'19:56:00', 38.7895202636719, -94.9607543945313, 17, 0.677004814147949, -1.65737783908844, NULL, N'LPKC6', N'2022-10-28', N'20:35:00', 38.7869300842285, -94.9655838012695, 18, 0.676959633827209, -1.65746212005615, NULL, N'LPKC7', N'2022-10-28', N'20:00:00', 38.7860794067383, -94.9671859741211, 17, 0.67694479227066, -1.65749001502991, NULL, N'LPKC8', N'2022-10-28', N'20:20:00', 38.7852745056152, -94.9687118530273, 19, 0.676930725574493, -1.65751671791077, NULL ),
( N'LPKC1', N'2022-10-28', N'19:42:00', 38.7967872619629, -94.9485168457031, 17, 0.677131652832031, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'20:02:00', 38.7947616577148, -94.9523086547852, 18, 0.677096307277679, -1.65723037719727, NULL, N'LPKC3', N'2022-10-28', N'20:17:00', 38.7917251586914, -94.9580154418945, 19, 0.677043318748474, -1.65733003616333, NULL, N'LPKC4', N'2022-10-28', N'19:34:00', 38.7903594970703, -94.959114074707, 17, 0.677019476890564, -1.65734922885895, NULL, N'LPKC5', N'2022-10-28', N'19:57:00', 38.7897148132324, -94.9603042602539, 17, 0.677008211612701, -1.65736997127533, NULL, N'LPKC6', N'2022-10-28', N'20:36:00', 38.7869300842285, -94.965576171875, 18, 0.676959633827209, -1.65746200084686, NULL, N'LPKC7', N'2022-10-28', N'20:01:00', 38.7860450744629, -94.9672317504883, 18, 0.676944196224213, -1.65749084949493, NULL, N'LPKC8', N'2022-10-28', N'20:21:00', 38.7853698730469, -94.9685440063477, 19, 0.676932394504547, -1.65751373767853, NULL ),
( N'LPKC1', N'2022-10-28', N'19:43:00', 38.7967872619629, -94.9485168457031, 17, 0.677131652832031, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'20:03:00', 38.7946014404297, -94.9526214599609, 18, 0.677093505859375, -1.65723586082458, NULL, N'LPKC3', N'2022-10-28', N'20:18:00', 38.7918014526367, -94.957878112793, 19, 0.677044630050659, -1.65732765197754, NULL, N'LPKC4', N'2022-10-28', N'19:35:00', 38.7905120849609, -94.9588317871094, 17, 0.677022159099579, -1.65734422206879, NULL, N'LPKC5', N'2022-10-28', N'19:58:00', 38.789363861084, -94.9609985351563, 17, 0.67700207233429, -1.65738213062286, NULL, N'LPKC6', N'2022-10-28', N'20:37:00', 38.786937713623, -94.965576171875, 18, 0.676959753036499, -1.65746200084686, NULL, N'LPKC7', N'2022-10-28', N'20:02:00', 38.7863006591797, -94.9667587280273, 18, 0.676948666572571, -1.65748262405396, NULL, N'LPKC8', N'2022-10-28', N'20:22:00', 38.7854995727539, -94.96826171875, 19, 0.676934659481049, -1.65750885009766, NULL ),
( N'LPKC1', N'2022-10-28', N'19:44:00', 38.7967910766602, -94.9485168457031, 17, 0.677131712436676, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'20:04:00', 38.7944068908691, -94.952995300293, 18, 0.677090108394623, -1.65724241733551, NULL, N'LPKC3', N'2022-10-28', N'20:19:00', 38.7917251586914, -94.9580078125, 19, 0.677043318748474, -1.65732991695404, NULL, N'LPKC4', N'2022-10-28', N'19:36:00', 38.7905158996582, -94.9588317871094, 17, 0.677022218704224, -1.65734422206879, NULL, N'LPKC5', N'2022-10-28', N'19:59:00', 38.7892913818359, -94.9611282348633, 17, 0.677000820636749, -1.65738439559937, NULL, N'LPKC6', N'2022-10-28', N'20:38:00', 38.7871627807617, -94.9651412963867, 18, 0.676963686943054, -1.65745437145233, NULL, N'LPKC7', N'2022-10-28', N'20:03:00', 38.786304473877, -94.9667587280273, 18, 0.676948726177216, -1.65748262405396, NULL, N'LPKC8', N'2022-10-28', N'20:23:00', 38.7853584289551, -94.9685363769531, 19, 0.676932215690613, -1.65751361846924, NULL ),
( N'LPKC1', N'2022-10-28', N'19:45:00', 38.7967910766602, -94.9485168457031, 17, 0.677131712436676, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'20:05:00', 38.7941818237305, -94.9533920288086, 19, 0.677086174488068, -1.6572493314743, NULL, N'LPKC3', N'2022-10-28', N'20:20:00', 38.7921714782715, -94.9571533203125, 19, 0.67705112695694, -1.65731501579285, NULL, N'LPKC4', N'2022-10-28', N'19:37:00', 38.7905120849609, -94.9588317871094, 17, 0.677022159099579, -1.65734422206879, NULL, N'LPKC5', N'2022-10-28', N'20:00:00', 38.7889022827148, -94.9618682861328, 17, 0.676994025707245, -1.65739727020264, NULL, N'LPKC6', N'2022-10-28', N'20:39:00', 38.7878646850586, -94.9638290405273, 18, 0.676975965499878, -1.65743148326874, NULL, N'LPKC7', N'2022-10-28', N'20:04:00', 38.7865715026855, -94.9662475585938, 19, 0.676953375339508, -1.65747368335724, NULL, N'LPKC8', N'2022-10-28', N'20:24:00', 38.7850341796875, -94.9691314697266, 19, 0.676926553249359, -1.65752398967743, NULL ),
( N'LPKC1', N'2022-10-28', N'19:46:00', 38.7967948913574, -94.9485168457031, 17, 0.677131772041321, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'20:06:00', 38.7939949035645, -94.953742980957, 19, 0.677082896232605, -1.65725541114807, NULL, N'LPKC3', N'2022-10-28', N'20:21:00', 38.7925834655762, -94.9563903808594, 19, 0.677058279514313, -1.65730166435242, NULL, N'LPKC4', N'2022-10-28', N'19:38:00', 38.7904319763184, -94.9589767456055, 16, 0.677020728588104, -1.65734684467316, NULL, N'LPKC5', N'2022-10-28', N'20:01:00', 38.7885856628418, -94.9624481201172, 18, 0.676988542079926, -1.65740740299225, NULL, N'LPKC6', N'2022-10-28', N'20:40:00', 38.7882232666016, -94.9631500244141, 18, 0.676982223987579, -1.65741968154907, NULL, N'LPKC7', N'2022-10-28', N'20:05:00', 38.7865715026855, -94.9662399291992, 19, 0.676953375339508, -1.65747356414795, NULL, N'LPKC8', N'2022-10-28', N'20:25:00', 38.7852592468262, -94.9687118530273, 20, 0.676930487155914, -1.65751671791077, NULL ),
( N'LPKC1', N'2022-10-28', N'19:47:00', 38.7967948913574, -94.9485092163086, 16, 0.677131772041321, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'20:07:00', 38.7942161560059, -94.9533309936523, 19, 0.677086770534515, -1.6572482585907, NULL, N'LPKC3', N'2022-10-28', N'20:22:00', 38.7926750183105, -94.9561920166016, 19, 0.677059888839722, -1.65729820728302, NULL, N'LPKC4', N'2022-10-28', N'19:39:00', 38.7905464172363, -94.9587707519531, 17, 0.677022755146027, -1.65734314918518, NULL, N'LPKC5', N'2022-10-28', N'20:02:00', 38.7885551452637, -94.9625244140625, 18, 0.676988005638123, -1.65740871429443, NULL, N'LPKC6', N'2022-10-28', N'20:41:00', 38.7882308959961, -94.9631423950195, 18, 0.676982343196869, -1.65741944313049, NULL, N'LPKC7', N'2022-10-28', N'20:06:00', 38.7865371704102, -94.9662933349609, 19, 0.67695277929306, -1.65747451782227, NULL, N'LPKC8', N'2022-10-28', N'20:26:00', 38.7853469848633, -94.9685592651367, 19, 0.676931977272034, -1.6575140953064, NULL ),
( N'LPKC1', N'2022-10-28', N'19:48:00', 38.7967948913574, -94.9485092163086, 16, 0.677131772041321, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'20:08:00', 38.7942085266113, -94.9533462524414, 19, 0.677086651325226, -1.65724849700928, NULL, N'LPKC3', N'2022-10-28', N'20:23:00', 38.7928123474121, -94.9559478759766, 19, 0.677062273025513, -1.6572939157486, NULL, N'LPKC4', N'2022-10-28', N'19:40:00', 38.7907485961914, -94.958381652832, 16, 0.677026271820068, -1.65733635425568, NULL, N'LPKC5', N'2022-10-28', N'20:03:00', 38.7886276245117, -94.9623794555664, 17, 0.676989257335663, -1.65740621089935, NULL, N'LPKC6', N'2022-10-28', N'20:42:00', 38.7884254455566, -94.962760925293, 18, 0.676985740661621, -1.65741288661957, NULL, N'LPKC7', N'2022-10-28', N'20:07:00', 38.7865409851074, -94.9663009643555, 19, 0.676952838897705, -1.65747463703156, NULL, N'LPKC8', N'2022-10-28', N'20:27:00', 38.785285949707, -94.9686965942383, 19, 0.676930904388428, -1.65751647949219, NULL ),
( N'LPKC1', N'2022-10-28', N'19:49:00', 38.7967948913574, -94.9485168457031, 16, 0.677131772041321, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'20:09:00', 38.7938957214355, -94.9539184570313, 19, 0.677081167697906, -1.6572585105896, NULL, N'LPKC3', N'2022-10-28', N'20:24:00', 38.7927322387695, -94.9561080932617, 19, 0.677060902118683, -1.65729677677155, NULL, N'LPKC4', N'2022-10-28', N'19:41:00', 38.7909317016602, -94.9580535888672, 17, 0.677029490470886, -1.65733063220978, NULL, N'LPKC5', N'2022-10-28', N'20:04:00', 38.7889556884766, -94.9617462158203, 19, 0.676994979381561, -1.65739512443542, NULL, N'LPKC6', N'2022-10-28', N'20:43:00', 38.7884788513184, -94.9626770019531, 18, 0.676986634731293, -1.6574113368988, NULL, N'LPKC7', N'2022-10-28', N'20:08:00', 38.7865447998047, -94.96630859375, 19, 0.67695289850235, -1.65747475624084, NULL, N'LPKC8', N'2022-10-28', N'20:28:00', 38.7849006652832, -94.9693984985352, 19, 0.676924228668213, -1.65752863883972, NULL ),
( N'LPKC1', N'2022-10-28', N'19:50:00', 38.7967948913574, -94.9485168457031, 17, 0.677131772041321, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'20:10:00', 38.7939605712891, -94.9538269042969, 19, 0.677082359790802, -1.65725684165955, NULL, N'LPKC3', N'2022-10-28', N'20:25:00', 38.7928276062012, -94.955940246582, 18, 0.677062571048737, -1.65729379653931, NULL, N'LPKC4', N'2022-10-28', N'19:42:00', 38.7908935546875, -94.9581298828125, 16, 0.677028775215149, -1.65733194351196, NULL, N'LPKC5', N'2022-10-28', N'20:05:00', 38.7893676757813, -94.9609832763672, 19, 0.677002191543579, -1.657381772995, NULL, N'LPKC6', N'2022-10-28', N'20:44:00', 38.7884178161621, -94.9627914428711, 18, 0.676985561847687, -1.65741336345673, NULL, N'LPKC7', N'2022-10-28', N'20:09:00', 38.786376953125, -94.9665985107422, 19, 0.676949977874756, -1.65747976303101, NULL, N'LPKC8', N'2022-10-28', N'20:29:00', 38.7848434448242, -94.9695053100586, 18, 0.676923215389252, -1.65753054618835, NULL ),
( N'LPKC1', N'2022-10-28', N'19:51:00', 38.7967948913574, -94.9485168457031, 17, 0.677131772041321, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'20:11:00', 38.7940483093262, -94.9536514282227, 19, 0.677083849906921, -1.65725386142731, NULL, N'LPKC3', N'2022-10-28', N'20:26:00', 38.7928619384766, -94.9558715820313, 19, 0.677063167095184, -1.65729260444641, NULL, N'LPKC4', N'2022-10-28', N'19:43:00', 38.7908897399902, -94.958122253418, 17, 0.677028715610504, -1.65733182430267, NULL, N'LPKC5', N'2022-10-28', N'20:06:00', 38.7893981933594, -94.9609222412109, 19, 0.677002727985382, -1.65738070011139, NULL, N'LPKC6', N'2022-10-28', N'20:45:00', 38.788028717041, -94.9634628295898, 17, 0.676978826522827, -1.6574250459671, NULL, N'LPKC7', N'2022-10-28', N'20:10:00', 38.7859268188477, -94.9674987792969, 19, 0.676942110061646, -1.65749549865723, NULL, N'LPKC8', N'2022-10-28', N'20:30:00', 38.7848587036133, -94.9694671630859, 18, 0.676923453807831, -1.65752983093262, NULL ),
( N'LPKC1', N'2022-10-28', N'19:52:00', 38.7967948913574, -94.9485168457031, 17, 0.677131772041321, -1.65716421604156, NULL, N'LPKC2', N'2022-10-28', N'20:12:00', 38.7943992614746, -94.9530258178711, 19, 0.677089989185333, -1.65724289417267, NULL, N'LPKC3', N'2022-10-28', N'20:27:00', 38.7928428649902, -94.9559020996094, 19, 0.677062809467316, -1.65729308128357, NULL, N'LPKC4', N'2022-10-28', N'19:44:00', 38.7909927368164, -94.9579162597656, 17, 0.677030503749847, -1.65732824802399, NULL, N'LPKC5', N'2022-10-28', N'20:07:00', 38.7890319824219, -94.9616546630859, 19, 0.676996290683746, -1.65739357471466, NULL, N'LPKC6', N'2022-10-28', N'20:46:00', 38.7880477905273, -94.9634399414063, 17, 0.676979124546051, -1.65742468833923, NULL, N'LPKC7', N'2022-10-28', N'20:11:00', 38.7857093811035, -94.967903137207, 19, 0.67693829536438, -1.65750253200531, NULL, N'LPKC8', N'2022-10-28', N'20:31:00', 38.7847023010254, -94.9697341918945, 18, 0.676920771598816, -1.6575345993042, NULL ),
( N'LPKC1', N'2022-10-28', N'19:53:00', 38.7967910766602, -94.9485092163086, 17, 0.677131712436676, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'20:13:00', 38.795108795166, -94.9516830444336, 19, 0.677102386951447, -1.65721952915192, NULL, N'LPKC3', N'2022-10-28', N'20:28:00', 38.7926635742188, -94.9562301635742, 18, 0.677059710025787, -1.65729880332947, NULL, N'LPKC4', N'2022-10-28', N'19:45:00', 38.7905502319336, -94.9588241577148, 17, 0.677022814750671, -1.6573441028595, NULL, N'LPKC5', N'2022-10-28', N'20:08:00', 38.7886276245117, -94.9623870849609, 19, 0.676989257335663, -1.65740633010864, NULL, N'LPKC6', N'2022-10-28', N'20:47:00', 38.788330078125, -94.9629592895508, 17, 0.676984071731567, -1.65741634368896, NULL, N'LPKC7', N'2022-10-28', N'20:12:00', 38.7856979370117, -94.9679183959961, 19, 0.676938116550446, -1.65750288963318, NULL, N'LPKC8', N'2022-10-28', N'20:32:00', 38.7847175598145, -94.9697265625, 18, 0.676921010017395, -1.65753436088562, NULL ),
( N'LPKC1', N'2022-10-28', N'19:54:00', 38.7967910766602, -94.9485092163086, 17, 0.677131712436676, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'20:14:00', 38.795581817627, -94.9507827758789, 19, 0.677110612392426, -1.6572037935257, NULL, N'LPKC3', N'2022-10-28', N'20:29:00', 38.7924766540527, -94.9566192626953, 18, 0.677056431770325, -1.65730559825897, NULL, N'LPKC4', N'2022-10-28', N'19:46:00', 38.7899551391602, -94.9598922729492, 17, 0.67701244354248, -1.65736281871796, NULL, N'LPKC5', N'2022-10-28', N'20:09:00', 38.7886543273926, -94.9623336791992, 19, 0.676989734172821, -1.65740537643433, NULL, N'LPKC6', N'2022-10-28', N'20:48:00', 38.7883071899414, -94.9629669189453, 17, 0.676983654499054, -1.65741646289825, NULL, N'LPKC7', N'2022-10-28', N'20:13:00', 38.7858200073242, -94.9676895141602, 19, 0.676940262317657, -1.65749883651733, NULL, N'LPKC8', N'2022-10-28', N'20:33:00', 38.7845802307129, -94.9699859619141, 18, 0.676918625831604, -1.65753889083862, NULL ),
( N'LPKC1', N'2022-10-28', N'19:55:00', 38.7967872619629, -94.9485015869141, 17, 0.677131652832031, -1.65716397762299, NULL, N'LPKC2', N'2022-10-28', N'20:15:00', 38.7956619262695, -94.9506301879883, 19, 0.6771120429039, -1.65720117092133, NULL, N'LPKC3', N'2022-10-28', N'20:30:00', 38.7922973632813, -94.9569549560547, 18, 0.677053332328796, -1.65731143951416, NULL, N'LPKC4', N'2022-10-28', N'19:47:00', 38.7899360656738, -94.9598999023438, 16, 0.677012085914612, -1.65736293792725, NULL, N'LPKC5', N'2022-10-28', N'20:10:00', 38.7887687683105, -94.9621047973633, 19, 0.676991701126099, -1.65740132331848, NULL, N'LPKC6', N'2022-10-28', N'20:49:00', 38.7882652282715, -94.9630508422852, 17, 0.676982939243317, -1.65741789340973, NULL, N'LPKC7', N'2022-10-28', N'20:14:00', 38.7862892150879, -94.966796875, 19, 0.676948428153992, -1.6574832201004, NULL, N'LPKC8', N'2022-10-28', N'20:34:00', 38.7844886779785, -94.9701538085938, 18, 0.676917016506195, -1.65754187107086, NULL ),
( N'LPKC1', N'2022-10-28', N'19:56:00', 38.7967872619629, -94.9485092163086, 17, 0.677131652832031, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'20:16:00', 38.7956008911133, -94.9507369995117, 19, 0.677110970020294, -1.65720295906067, NULL, N'LPKC3', N'2022-10-28', N'20:31:00', 38.7923355102539, -94.9568634033203, 18, 0.677053987979889, -1.6573098897934, NULL, N'LPKC4', N'2022-10-28', N'19:48:00', 38.7899398803711, -94.9599075317383, 16, 0.677012145519257, -1.65736305713654, NULL, N'LPKC5', N'2022-10-28', N'20:11:00', 38.7886695861816, -94.9623336791992, 18, 0.6769899725914, -1.65740537643433, NULL, N'LPKC6', N'2022-10-28', N'20:50:00', 38.787899017334, -94.963752746582, 17, 0.676976561546326, -1.65743017196655, NULL, N'LPKC7', N'2022-10-28', N'20:15:00', 38.78662109375, -94.9661712646484, 19, 0.67695426940918, -1.65747237205505, NULL, N'LPKC8', N'2022-10-28', N'20:35:00', 38.7845077514648, -94.9701156616211, 18, 0.676917374134064, -1.65754115581512, NULL ),
( N'LPKC1', N'2022-10-28', N'19:57:00', 38.7967910766602, -94.9485015869141, 17, 0.677131712436676, -1.65716397762299, NULL, N'LPKC2', N'2022-10-28', N'20:17:00', 38.7956924438477, -94.9505310058594, 19, 0.677112579345703, -1.65719938278198, NULL, N'LPKC3', N'2022-10-28', N'20:32:00', 38.7923431396484, -94.9568557739258, 18, 0.677054107189178, -1.65730977058411, NULL, N'LPKC4', N'2022-10-28', N'19:49:00', 38.7899398803711, -94.9599075317383, 17, 0.677012145519257, -1.65736305713654, NULL, N'LPKC5', N'2022-10-28', N'20:12:00', 38.788646697998, -94.9623641967773, 19, 0.676989555358887, -1.65740597248077, NULL, N'LPKC6', N'2022-10-28', N'20:51:00', 38.7880630493164, -94.9634552001953, 17, 0.676979422569275, -1.65742492675781, NULL, N'LPKC7', N'2022-10-28', N'20:16:00', 38.78662109375, -94.9661712646484, 19, 0.67695426940918, -1.65747237205505, NULL, N'LPKC8', N'2022-10-28', N'20:36:00', 38.7847175598145, -94.9697341918945, 18, 0.676921010017395, -1.6575345993042, NULL ),
( N'LPKC1', N'2022-10-28', N'19:58:00', 38.7967948913574, -94.9485015869141, 17, 0.677131772041321, -1.65716397762299, NULL, N'LPKC2', N'2022-10-28', N'20:18:00', 38.795711517334, -94.9505157470703, 19, 0.677112877368927, -1.6571991443634, NULL, N'LPKC3', N'2022-10-28', N'20:33:00', 38.7923431396484, -94.9568557739258, 18, 0.677054107189178, -1.65730977058411, NULL, N'LPKC4', N'2022-10-28', N'19:50:00', 38.7905006408691, -94.9588470458984, 17, 0.677021920681, -1.65734457969666, NULL, N'LPKC5', N'2022-10-28', N'20:13:00', 38.7884712219238, -94.9626998901367, 19, 0.676986515522003, -1.65741181373596, NULL, N'LPKC6', N'2022-10-28', N'20:52:00', 38.7878379821777, -94.9638290405273, 17, 0.67697548866272, -1.65743148326874, NULL, N'LPKC7', N'2022-10-28', N'20:17:00', 38.7864189147949, -94.9665679931641, 19, 0.676950693130493, -1.65747928619385, NULL, N'LPKC8', N'2022-10-28', N'20:37:00', 38.784610748291, -94.9699249267578, 18, 0.676919162273407, -1.65753781795502, NULL ),
( N'LPKC1', N'2022-10-28', N'19:59:00', 38.7967948913574, -94.9485092163086, 17, 0.677131772041321, -1.65716409683228, NULL, N'LPKC2', N'2022-10-28', N'20:19:00', 38.795768737793, -94.9504165649414, 19, 0.677113890647888, -1.65719735622406, NULL, N'LPKC3', N'2022-10-28', N'20:34:00', 38.7926902770996, -94.9561920166016, 18, 0.677060186862946, -1.65729820728302, NULL, N'LPKC4', N'2022-10-28', N'19:51:00', 38.790771484375, -94.9583511352539, 17, 0.677026689052582, -1.65733587741852, NULL, N'LPKC5', N'2022-10-28', N'20:14:00', 38.7886543273926, -94.9623489379883, 19, 0.676989734172821, -1.65740561485291, NULL, N'LPKC6', N'2022-10-28', N'20:53:00', 38.7873878479004, -94.9646987915039, 17, 0.676967620849609, -1.65744662284851, NULL, N'LPKC7', N'2022-10-28', N'20:18:00', 38.7863998413086, -94.9665908813477, 19, 0.676950395107269, -1.65747964382172, NULL, N'LPKC8', N'2022-10-28', N'20:38:00', 38.784553527832, -94.9700546264648, 18, 0.676918148994446, -1.65754008293152, NULL ),
( N'LPKC1', N'2022-10-28', N'20:00:00', 38.7967987060547, -94.9485015869141, 18, 0.67713189125061, -1.65716397762299, NULL, N'LPKC2', N'2022-10-28', N'20:20:00', 38.7959175109863, -94.9501571655273, 19, 0.677116513252258, -1.65719282627106, NULL, N'LPKC3', N'2022-10-28', N'20:35:00', 38.7931861877441, -94.9552764892578, 18, 0.677068829536438, -1.65728223323822, NULL, N'LPKC4', N'2022-10-28', N'19:52:00', 38.7903747558594, -94.959098815918, 17, 0.677019715309143, -1.65734887123108, NULL, N'LPKC5', N'2022-10-28', N'20:15:00', 38.7886543273926, -94.9623489379883, 19, 0.676989734172821, -1.65740561485291, NULL, N'LPKC6', N'2022-10-28', N'20:54:00', 38.7873878479004, -94.9647064208984, 17, 0.676967620849609, -1.6574467420578, NULL, N'LPKC7', N'2022-10-28', N'20:19:00', 38.7864379882813, -94.9665298461914, 19, 0.676951050758362, -1.65747857093811, NULL, N'LPKC8', N'2022-10-28', N'20:39:00', 38.7846603393555, -94.969841003418, 18, 0.676919996738434, -1.65753638744354, NULL ),
( N'LPKC1', N'2022-10-28', N'20:01:00', 38.7967987060547, -94.9485015869141, 18, 0.67713189125061, -1.65716397762299, NULL, N'LPKC2', N'2022-10-28', N'20:21:00', 38.7959213256836, -94.9501571655273, 19, 0.677116572856903, -1.65719282627106, NULL, N'LPKC3', N'2022-10-28', N'20:36:00', 38.7934150695801, -94.9548492431641, 18, 0.677072823047638, -1.65727472305298, NULL, N'LPKC4', N'2022-10-28', N'19:53:00', 38.790599822998, -94.9586791992188, 17, 0.677023649215698, -1.65734159946442, NULL, N'LPKC5', N'2022-10-28', N'20:16:00', 38.7888679504395, -94.9619369506836, 19, 0.676993429660797, -1.65739846229553, NULL, N'LPKC6', N'2022-10-28', N'20:55:00', 38.7872924804688, -94.9648971557617, 17, 0.676965951919556, -1.65745007991791, NULL, N'LPKC7', N'2022-10-28', N'20:20:00', 38.7862739562988, -94.9668273925781, 19, 0.676948189735413, -1.65748381614685, NULL, N'LPKC8', N'2022-10-28', N'20:40:00', 38.7845191955566, -94.9701232910156, 18, 0.676917552947998, -1.6575413942337, NULL ),
( N'LPKC1', N'2022-10-28', N'20:02:00', 38.7967987060547, -94.9485015869141, 18, 0.67713189125061, -1.65716397762299, NULL, N'LPKC2', N'2022-10-28', N'20:22:00', 38.7958068847656, -94.9503479003906, 19, 0.677114546298981, -1.65719616413116, NULL, N'LPKC3', N'2022-10-28', N'20:37:00', 38.7933731079102, -94.9549179077148, 18, 0.677072107791901, -1.65727591514587, NULL, N'LPKC4', N'2022-10-28', N'19:54:00', 38.7906150817871, -94.9586410522461, 17, 0.677023947238922, -1.65734088420868, NULL, N'LPKC5', N'2022-10-28', N'20:17:00', 38.7888603210449, -94.9619369506836, 19, 0.676993310451508, -1.65739846229553, NULL, N'LPKC6', N'2022-10-28', N'20:56:00', 38.787296295166, -94.9648818969727, 17, 0.6769660115242, -1.65744984149933, NULL, N'LPKC7', N'2022-10-28', N'20:21:00', 38.7862548828125, -94.9668655395508, 19, 0.676947832107544, -1.65748453140259, NULL, N'LPKC8', N'2022-10-28', N'20:41:00', 38.7848625183105, -94.9694595336914, 18, 0.676923513412476, -1.65752971172333, NULL ),
( N'LPKC1', N'2022-10-28', N'20:03:00', 38.7967987060547, -94.9484939575195, 18, 0.67713189125061, -1.6571638584137, NULL, N'LPKC2', N'2022-10-28', N'20:23:00', 38.7958297729492, -94.9502944946289, 19, 0.677114963531494, -1.65719521045685, NULL, N'LPKC3', N'2022-10-28', N'20:38:00', 38.7934494018555, -94.9547882080078, 18, 0.677073419094086, -1.65727365016937, NULL, N'LPKC4', N'2022-10-28', N'19:55:00', 38.7906227111816, -94.958625793457, 16, 0.677024066448212, -1.6573406457901, NULL, N'LPKC5', N'2022-10-28', N'20:18:00', 38.7888603210449, -94.9619369506836, 19, 0.676993310451508, -1.65739846229553, NULL, N'LPKC6', N'2022-10-28', N'20:57:00', 38.7874031066895, -94.9646835327148, 17, 0.676967918872833, -1.65744638442993, NULL, N'LPKC7', N'2022-10-28', N'20:22:00', 38.7865295410156, -94.9663543701172, 19, 0.676952660083771, -1.65747559070587, NULL, N'LPKC8', N'2022-10-28', N'20:42:00', 38.7848320007324, -94.9695281982422, 18, 0.676923036575317, -1.65753090381622, NULL ),
( N'LPKC1', N'2022-10-28', N'20:04:00', 38.7967987060547, -94.9485015869141, 18, 0.67713189125061, -1.65716397762299, NULL, N'LPKC2', N'2022-10-28', N'20:24:00', 38.7961540222168, -94.9497222900391, 19, 0.677120625972748, -1.65718531608582, NULL, N'LPKC3', N'2022-10-28', N'20:39:00', 38.7936096191406, -94.954475402832, 18, 0.67707622051239, -1.65726828575134, NULL, N'LPKC4', N'2022-10-28', N'19:56:00', 38.7905960083008, -94.9586868286133, 17, 0.677023589611053, -1.65734171867371, NULL, N'LPKC5', N'2022-10-28', N'20:19:00', 38.7888603210449, -94.9619369506836, 19, 0.676993310451508, -1.65739846229553, NULL, N'LPKC6', N'2022-10-28', N'20:58:00', 38.7873382568359, -94.9647903442383, 17, 0.676966726779938, -1.65744829177856, NULL, N'LPKC7', N'2022-10-28', N'20:23:00', 38.7865905761719, -94.9662246704102, 19, 0.676953673362732, -1.65747332572937, NULL, N'LPKC8', N'2022-10-28', N'20:43:00', 38.7848129272461, -94.9695663452148, 18, 0.676922678947449, -1.65753161907196, NULL ),
( N'LPKC1', N'2022-10-28', N'20:05:00', 38.7967987060547, -94.9484939575195, 19, 0.67713189125061, -1.6571638584137, NULL, N'LPKC2', N'2022-10-28', N'20:25:00', 38.7961578369141, -94.94970703125, 18, 0.677120685577393, -1.65718495845795, NULL, N'LPKC3', N'2022-10-28', N'20:40:00', 38.793830871582, -94.9540557861328, 17, 0.677080035209656, -1.65726089477539, NULL, N'LPKC4', N'2022-10-28', N'19:57:00', 38.7906303405762, -94.9586181640625, 16, 0.677024185657501, -1.65734052658081, NULL, N'LPKC5', N'2022-10-28', N'20:20:00', 38.7888641357422, -94.9619445800781, 19, 0.676993370056152, -1.65739858150482, NULL, N'LPKC6', N'2022-10-28', N'20:59:00', 38.7873840332031, -94.9646759033203, 16, 0.676967561244965, -1.65744626522064, NULL, N'LPKC7', N'2022-10-28', N'20:24:00', 38.7866401672363, -94.9661331176758, 19, 0.676954567432404, -1.65747165679932, NULL, N'LPKC8', N'2022-10-28', N'20:44:00', 38.7848205566406, -94.9695510864258, 18, 0.676922798156738, -1.65753138065338, NULL ),
( N'LPKC1', N'2022-10-28', N'20:06:00', 38.7967910766602, -94.9484939575195, 19, 0.677131712436676, -1.6571638584137, NULL, N'LPKC2', N'2022-10-28', N'20:26:00', 38.7962493896484, -94.9495086669922, 19, 0.677122294902802, -1.65718150138855, NULL, N'LPKC3', N'2022-10-28', N'20:41:00', 38.7937889099121, -94.9541549682617, 18, 0.677079319953918, -1.65726268291473, NULL, N'LPKC4', N'2022-10-28', N'19:58:00', 38.7906074523926, -94.9586868286133, 17, 0.677023828029633, -1.65734171867371, NULL, N'LPKC5', N'2022-10-28', N'20:21:00', 38.7886085510254, -94.9624099731445, 19, 0.676988899707794, -1.65740668773651, NULL, N'LPKC6', N'2022-10-28', N'21:00:00', 38.7873916625977, -94.9646835327148, 16, 0.676967680454254, -1.65744638442993, NULL, N'LPKC7', N'2022-10-28', N'20:25:00', 38.7866325378418, -94.9661483764648, 18, 0.676954448223114, -1.65747201442719, NULL, N'LPKC8', N'2022-10-28', N'20:45:00', 38.785026550293, -94.9691390991211, 17, 0.676926374435425, -1.65752410888672, NULL ),
( N'LPKC1', N'2022-10-28', N'20:07:00', 38.7967948913574, -94.9484939575195, 19, 0.677131772041321, -1.6571638584137, NULL, N'LPKC2', N'2022-10-28', N'20:27:00', 38.7962455749512, -94.9495239257813, 19, 0.677122235298157, -1.65718185901642, NULL, N'LPKC3', N'2022-10-28', N'20:42:00', 38.7937927246094, -94.9541473388672, 17, 0.677079379558563, -1.65726244449615, NULL, N'LPKC4', N'2022-10-28', N'19:59:00', 38.7906036376953, -94.9586868286133, 17, 0.677023768424988, -1.65734171867371, NULL, N'LPKC5', N'2022-10-28', N'20:22:00', 38.7886123657227, -94.96240234375, 19, 0.676989018917084, -1.65740656852722, NULL, N'LPKC6', N'2022-10-28', N'21:01:00', 38.7877044677734, -94.9641189575195, 16, 0.676973164081573, -1.6574364900589, NULL, N'LPKC7', N'2022-10-28', N'20:26:00', 38.786548614502, -94.9663009643555, 19, 0.676952958106995, -1.65747463703156, NULL, N'LPKC8', N'2022-10-28', N'20:46:00', 38.7857284545898, -94.9678115844727, 17, 0.676938652992249, -1.65750098228455, NULL ),
( N'LPKC1', N'2022-10-28', N'20:08:00', 38.7967948913574, -94.9484939575195, 19, 0.677131772041321, -1.6571638584137, NULL, N'LPKC2', N'2022-10-28', N'20:28:00', 38.7962379455566, -94.9495315551758, 19, 0.677122056484222, -1.65718197822571, NULL, N'LPKC3', N'2022-10-28', N'20:43:00', 38.7939643859863, -94.9538040161133, 18, 0.677082419395447, -1.65725648403168, NULL, N'LPKC4', N'2022-10-28', N'20:00:00', 38.7908935546875, -94.958137512207, 16, 0.677028775215149, -1.65733218193054, NULL, N'LPKC5', N'2022-10-28', N'20:23:00', 38.7890319824219, -94.9616317749023, 19, 0.676996290683746, -1.6573930978775, NULL, N'LPKC6', N'2022-10-28', N'21:02:00', 38.7877082824707, -94.964111328125, 14, 0.676973223686218, -1.65743637084961, NULL, N'LPKC7', N'2022-10-28', N'20:27:00', 38.786548614502, -94.96630859375, 19, 0.676952958106995, -1.65747475624084, NULL, N'LPKC8', N'2022-10-28', N'20:47:00', 38.7857246398926, -94.9678268432617, 17, 0.676938593387604, -1.65750122070313, NULL ),
( N'LPKC1', N'2022-10-28', N'20:09:00', 38.7967948913574, -94.9485015869141, 19, 0.677131772041321, -1.65716397762299, NULL, N'LPKC2', N'2022-10-28', N'20:29:00', 38.7963256835938, -94.9493789672852, 18, 0.677123606204987, -1.65717923641205, NULL, N'LPKC3', N'2022-10-28', N'20:44:00', 38.7939643859863, -94.9538040161133, 18, 0.677082419395447, -1.65725648403168, NULL, N'LPKC4', N'2022-10-28', N'20:01:00', 38.7910614013672, -94.9578247070313, 17, 0.677031755447388, -1.65732669830322, NULL, N'LPKC5', N'2022-10-28', N'20:24:00', 38.7889251708984, -94.9618225097656, 18, 0.676994442939758, -1.65739643573761, NULL, N'LPKC6', N'2022-10-28', N'21:03:00', 38.7876472473145, -94.9642181396484, 14, 0.676972150802612, -1.65743827819824, NULL, N'LPKC7', N'2022-10-28', N'20:28:00', 38.786548614502, -94.9663009643555, 18, 0.676952958106995, -1.65747463703156, NULL, N'LPKC8', N'2022-10-28', N'20:48:00', 38.7856216430664, -94.9680328369141, 17, 0.676936805248261, -1.65750479698181, NULL ),
( N'LPKC1', N'2022-10-28', N'20:10:00', 38.796802520752, -94.9485015869141, 19, 0.677131950855255, -1.65716397762299, NULL, N'LPKC2', N'2022-10-28', N'20:30:00', 38.7964668273926, -94.949104309082, 18, 0.677126049995422, -1.65717446804047, NULL, N'LPKC3', N'2022-10-28', N'20:45:00', 38.7938003540039, -94.9540786743164, 18, 0.677079558372498, -1.65726125240326, NULL, N'LPKC4', N'2022-10-28', N'20:02:00', 38.7906227111816, -94.9586181640625, 17, 0.677024066448212, -1.65734052658081, NULL, N'LPKC5', N'2022-10-28', N'20:25:00', 38.7887382507324, -94.962158203125, 18, 0.676991164684296, -1.6574022769928, NULL, N'LPKC6', N'2022-10-28', N'21:04:00', 38.7878646850586, -94.9638214111328, 14, 0.676975965499878, -1.65743136405945, NULL, N'LPKC7', N'2022-10-28', N'20:29:00', 38.7861595153809, -94.9670028686523, 18, 0.67694616317749, -1.65748691558838, NULL, N'LPKC8', N'2022-10-28', N'20:49:00', 38.7859840393066, -94.9673385620117, 17, 0.676943123340607, -1.65749275684357, NULL ),
( N'LPKC1', N'2022-10-28', N'20:11:00', 38.796802520752, -94.9485015869141, 19, 0.677131950855255, -1.65716397762299, NULL, N'LPKC2', N'2022-10-28', N'20:31:00', 38.7961616516113, -94.9496383666992, 18, 0.677120745182037, -1.65718376636505, NULL, N'LPKC3', N'2022-10-28', N'20:46:00', 38.7937850952148, -94.9541015625, 17, 0.677079260349274, -1.65726172924042, NULL, N'LPKC4', N'2022-10-28', N'20:03:00', 38.7905197143555, -94.9588088989258, 18, 0.677022278308868, -1.65734386444092, NULL, N'LPKC5', N'2022-10-28', N'20:26:00', 38.788875579834, -94.9619140625, 19, 0.676993608474731, -1.65739810466766, NULL, N'LPKC6', N'2022-10-28', N'21:05:00', 38.7882957458496, -94.963020324707, 14, 0.67698347568512, -1.65741741657257, NULL, N'LPKC7', N'2022-10-28', N'20:30:00', 38.7862854003906, -94.9667739868164, 18, 0.676948368549347, -1.65748286247253, NULL, N'LPKC8', N'2022-10-28', N'20:50:00', 38.7858581542969, -94.9675979614258, 17, 0.67694091796875, -1.65749728679657, NULL )
GO

Please let me know what else I can provide to help.

Thanks, Brian.

Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner

Phil Parkin SSC Guru Points: 246695 More actions · Answer 3

That looks like a good dataset, and I'm sure that your explanation makes plenty of sense, to people who understand the data!

But I'm not one of those people, so would you be able to provide the results which you are expecting to see, based on this sample dataset?

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

brian.cook Default port Points: 1484 More actions · Answer 4

LOL! Ok.

The LPKCX are Cranes. The date and times are the location of the cranes as indicated by the Lat/Long. Calculating the distance between the given LPKCX location and the next one over will determine if we are able to mount a Microwave transceiver to them and provide coverage.

The DistanceX results provides the data that is needed to determine if we can do this. This is the data I am looking for and would ignore all the entries that do not match all the way across all 8 LPKC cranes.

I attached a CSV with the results laid out like I want the SQL result.

Does this help?

Thanks!

Attachments:

You must be logged in to view attached files.

Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 5

Quick suggestion, use the appropriate geography spatial data type rather than long/lat columns, makes the calculation a lot easier 😉

😎

brian.cook Default port Points: 1484 More actions · Answer 6

Thank you Eirikur. I will look into it.

Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 7

brian.cook wrote:

LOL! Ok.
The LPKCX are Cranes. The date and times are the location of the cranes as indicated by the Lat/Long. Calculating the distance between the given LPKCX location and the next one over will determine if we are able to mount a Microwave transceiver to them and provide coverage.
The DistanceX results provides the data that is needed to determine if we can do this. This is the data I am looking for and would ignore all the entries that do not match all the way across all 8 LPKC cranes.
I attached a CSV with the results laid out like I want the SQL result.
Does this help?
Thanks!

~~Again, for those of us that don't have to work with this type of data much, what is a "Crane"?~~

~~And, are those connected to the knutten valve on the anterior of the sawdust pump or do we just need a simple kleinschmidt to hammer out the result?~~ 😀

BWAAA-HAAA! Lordy... coffee is wearing off. You said "location of Cranes" and so you mean physical lift cranes. {headdesk} I though it was some geographic term that I hadn't heard of before.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

brian.cook Default port Points: 1484 More actions · Answer 8

Jeff, please see the video provided in the LINK. the Big Orange things are the cranes.

https://youtu.be/GjUVDtlPz0c

Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 9

Yeah... I just made that realization. Like I said in my edit of my previous post, the low level alarms for caffeine have sounded. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

brian.cook Default port Points: 1484 More actions · Answer 10

No problem Jeff. Were it not for Coffee, I would never have survived the 20 years in the Navy!

Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 11

brian.cook wrote:

No problem Jeff. Were it not for Coffee, I would never have survived the 20 years in the Navy!

I only did 8 1/2 in the Navy... Silent Service on fast attack subs. As you say, coffee was a necessity. Still is.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)