-
Notifications
You must be signed in to change notification settings - Fork 1
/
sample.sql
1391 lines (1357 loc) · 82.8 KB
/
sample.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
CREATE TABLE IF NOT EXISTS `aircraft_types` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` char(1) NOT NULL,
`mfgr` varchar(30) DEFAULT NULL,
`model` varchar(30) DEFAULT NULL,
`code` varchar(4) DEFAULT NULL,
`engineqty` tinyint(4) DEFAULT NULL,
`enginetype` char(1) DEFAULT NULL,
`weightclass` char(1) DEFAULT NULL,
`descentrate` varchar(10) DEFAULT NULL,
`serviceceiling` varchar(10) DEFAULT NULL,
`cruisetas` varchar(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=764 ;
INSERT INTO `aircraft_types` (`id`, `type`, `mfgr`, `model`, `code`, `engineqty`, `enginetype`, `weightclass`, `descentrate`, `serviceceiling`, `cruisetas`) VALUES
(154, 'F', 'MCDONNELL-DOUGLAS', 'MD-11', 'MD11', 3, 'J', 'H', '', '', ''),
(267, 'F', 'BOEING', '737-700', 'B737', 2, 'J', 'L', '4000', '4000', ''),
(268, 'F', 'BOEING', '737-800', 'B738', 2, 'J', 'L', '4000', '4000', ''),
(274, 'F', 'BOEING', '747-400 (WINGLETS)', 'B744', 4, 'J', 'H', '3000', '3000', ''),
(283, 'F', 'BOEING', '777-300', 'B773', 2, 'J', 'H', '2500', '2500', ''),
(317, 'F', 'BRITISH AERO', 'BAe-4100 JETSTREAM 41', 'JS41', 2, 'T', 'S', '2200', '', ''),
(459, 'F', 'EMBRAER', 'EMB-190/195', 'E190', 2, 'J', 'L', '', '', ''),
(470, 'F', 'FAIRCHILD', 'C-119 FLYING BOX CAR', 'C119', 2, 'P', 'L', '750', '750', ''),
(484, 'F', 'FOKKER', '70', 'F70', 2, 'J', 'L', '4500', '3000', ''),
(606, 'F', 'PIPER', 'PA-34 SENECA', 'PA34', 2, 'P', 'S', '1300', '1300', '');
CREATE TABLE IF NOT EXISTS `airlines` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`icao` varchar(10) DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`radio` varchar(100) DEFAULT NULL,
`website` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `icao` (`icao`),
FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1073 ;
INSERT INTO `airlines` (`id`, `icao`, `name`, `radio`, `website`) VALUES
(4, 'AAL', 'American Airlines', 'American', NULL),
(35, 'AFR', 'Air France', 'Air France', NULL),
(124, 'BRA', 'Braathens', 'Braathens', NULL),
(247, 'EIN', 'Aer Lingus', 'Shamrock', NULL),
(386, 'KAL', 'Korean Air', 'Korean Air', NULL),
(506, 'PAL', 'Philippine Airlines', 'Philippine', NULL),
(513, 'PGT', 'Pegasus', 'Sunturk', NULL),
(589, 'SWA', 'Southwest Airlines', 'Southwest', NULL),
(623, 'TYR', 'Tyrolean Airways', 'Tyrolean', NULL),
(978, 'AGJ', 'Air GREECE Virtual', 'Air Greece', 'http://www.airgreeceva.gr/');
CREATE TABLE IF NOT EXISTS `airports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`icao` varchar(6) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`lat` double DEFAULT NULL,
`lon` double DEFAULT NULL,
`alt` int(10) DEFAULT NULL,
`iata` varchar(4) DEFAULT NULL,
`city` varchar(50) DEFAULT NULL,
`iso` varchar(2) DEFAULT NULL,
`FIR` varchar(4) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `icao` (`icao`),
KEY `iso` (`iso`),
KEY `FIR` (`FIR`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=23900 ;
INSERT INTO `airports` (`id`, `icao`, `name`, `lat`, `lon`, `alt`, `iata`, `city`, `iso`, `FIR`) VALUES
(7553, 'BIKF', 'Keflavik', 63.985, -22.605556, 170, 'KEF', 'KEFLAVIK', 'is', 'BIRD'),
(9156, 'EBBR', 'Brussels National', 50.901389, 4.484445, 183, 'BRU', 'BRUSSELS', 'be', 'EBBU'),
(9257, 'EDDF', 'Frankfurt/Main', 50.033334, 8.570555, 363, 'FRA', 'FRANKFURT', 'de', 'EDFF'),
(12680, 'KAUS', 'Austin Bergstrom Intl', 30.194528, -97.669889, 541, 'AUS', 'AUSTIN', 'us', 'KZHU'),
(13001, 'KDAL', 'Dallas Love', 32.847114, -96.851772, 486, 'DAL', 'DALLAS', 'us', 'KZFW'),
(13638, 'KLAX', 'Los Angeles Intl', 33.942536, -118.408075, 125, 'LAX', 'LOS ANGELES', 'us', 'KZLA'),
(13763, 'KMCO', 'Orlando Intl', 28.428889, -81.316028, 95, 'MCO', 'ORLANDO', 'us', 'KZJX'),
(13805, 'KMIA', 'Miami Intl', 25.79325, -80.290556, 7, 'MIA', 'MIAMI', 'us', 'KZMA'),
(14350, 'KSFO', 'San Francisco Intl', 37.618972, -122.374889, 12, 'SFO', 'SAN FRANCISCO', 'us', 'KZOA'),
(15183, 'LFPG', 'Charles-De-Gaulle', 49.009722, 2.547778, 389, 'CDG', 'PARIS', 'fr', 'LFFF'),
(15188, 'LFPN', 'Toussus-Le-Noble', 48.749756, 2.111178, 537, 'TNF', 'TOUSSOUS-LE-NOBLE', 'fr', 'LFFF'),
(15295, 'LGIR', 'Nikos Kazantzakis', 35.340646, 25.17918, 114, 'HER', 'HERAKLION', 'gr', 'LGGG'),
(15310, 'LGLM', 'Limnos', 39.92062, 25.238732, 14, 'LXS', 'LIMNOS', 'gr', 'LGGG'),
(15623, 'LOWI', 'Innsbruck', 47.260278, 11.343889, 1899, 'INN', 'INNSBRUCK', 'at', 'LOVV'),
(15651, 'LPMA', 'Madeira', 32.694167, -16.778056, 191, NULL, 'Madeira', 'pt', 'LPPC'),
(15790, 'LTAN', 'Konya AB', 37.982222, 32.566389, 3381, 'KYA', 'KONYA', 'tr', 'LTAA'),
(15847, 'LTFJ', 'Sabiha Gokcen', 40.898333, 29.309167, 311, NULL, NULL, 'tr', 'LTBB'),
(16611, 'MPMG', 'Marcos A Gelabert Intl', 8.97353, -79.555627, 30, 'PAC', 'PANAMA', 'pa', 'MPZL'),
(16636, 'MROC', 'Juan Santamaria Intl', 9.9998, -84.195718, 3020, 'SJO', 'SAN JOSE', 'cr', 'MHTG'),
(18816, 'PGUM', 'Guam Intl', 13.48345, 144.795983, 297, 'GUM', 'AGANA', 'gu', 'PGZU'),
(19271, 'RPLL', 'Ninoy Aquino Intl', 14.509942, 121.013858, 74, 'MNL', 'MANILA', 'ph', 'RPHI'),
(19750, 'SBEG', 'Eduardo Gomes Intl', -3.039167, -60.047778, 263, 'MAO', 'MANAUS', 'br', 'SBAZ'),
(21687, 'UKBB', 'Boryspil''', 50.345, 30.895, 426, 'KBP', 'KIEV', 'ua', 'UKBV');
CREATE TABLE IF NOT EXISTS `atc` (
`aid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`cid` mediumint(8) unsigned NOT NULL,
`callsign` varchar(10) NOT NULL,
`start` datetime NOT NULL,
`end` datetime DEFAULT NULL,
`facility` tinyint(3) unsigned NOT NULL,
`rating` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`aid`),
KEY `cid` (`cid`),
KEY `call` (`callsign`),
KEY `start` (`start`),
KEY `end` (`end`),
KEY `fac` (`facility`),
KEY `rate` (`rating`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1665157 ;
CREATE TABLE IF NOT EXISTS `exclude_pilots` (
`cid` mediumint(9) NOT NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `flights` (
`fid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`startdate` date NOT NULL DEFAULT '0000-00-00',
`callsign` varchar(10) NOT NULL DEFAULT '',
`carrier` varchar(10) DEFAULT NULL,
`cid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`dep` varchar(5) NOT NULL,
`dep_iso` char(2) NOT NULL DEFAULT '',
`arr` varchar(5) NOT NULL,
`arr_iso` char(2) NOT NULL DEFAULT '',
`route` varchar(600) NOT NULL,
`rmks` varchar(256) NOT NULL,
`alt` varchar(15) NOT NULL DEFAULT '0',
`spd` smallint(5) unsigned NOT NULL DEFAULT '0',
`state` tinyint(3) unsigned NOT NULL DEFAULT '0',
`acft` varchar(20) NOT NULL,
`clean_acft` varchar(10) DEFAULT NULL,
`time_dep` datetime DEFAULT NULL,
`time_arr` datetime DEFAULT NULL,
`last_lat` decimal(10,6) DEFAULT NULL,
`last_lon` decimal(10,6) DEFAULT NULL,
PRIMARY KEY (`fid`),
KEY `startdate` (`startdate`),
KEY `cid` (`cid`),
KEY `callsign` (`callsign`),
KEY `dep` (`dep`),
KEY `arr` (`arr`),
KEY `dep_iso` (`dep_iso`),
KEY `arr_iso` (`arr_iso`),
KEY `state` (`state`),
KEY `carrier` (`carrier`),
KEY `time_dep` (`time_dep`),
KEY `time_arr` (`time_arr`),
KEY `NewIndex1` (`clean_acft`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11807811 ;
INSERT INTO `flights` (`fid`, `startdate`, `callsign`, `carrier`, `cid`, `dep`, `dep_iso`, `arr`, `arr_iso`, `route`, `rmks`, `alt`, `spd`, `state`, `acft`, `clean_acft`, `time_dep`, `time_arr`, `last_lat`, `last_lon`) VALUES
(11805315, '2013-06-04', 'AAL1', 'AAL', 1184536, 'PGUM', 'gu', 'KLAX', 'us', 'UNZ DEWSS A450 HOOPA JULLE OGG EBBER R577 ELKEY SADDE6', 'CEO JOINAVA.ORG / FSDT LAX', '39000', 500, 1, 'H/MD11/Q', 'MD11', '2013-06-04 11:56:03', NULL, 29.138860, -135.312360),
(11805687, '2013-06-04', 'PAL104', 'PAL', 1253455, 'RPLL', 'ph', 'KSFO', 'us', 'DIRECT', '+VFPS+/V/REG/B744 PAX/502 STD/1212Z STA/0106Z RMK/FLIGHT TRACKED BY SIMMILES WWW.SIMMILES.COM', '35000', 480, 0, 'B744', 'B744', NULL, NULL, 37.616770, -122.382090),
(11806721, '2013-06-04', 'KSX2159', 'KSX', 1209665, 'UKBB', 'ua', 'BIKF', 'is', 'UKBB/36R BO B246 LASDA M850 GOMAD L32 BABUN L33 LUPAN L33 OSMUS M996 NOPKA M996 DUKAT M870 MILTA L199 IBGAX N623 VALDI G3 SKARD', '+VFPS+/V/OPR / WWW.SMART-EXPRESS.INFO CALLSIGN / SMART-EXPRESS', 'F340', 470, 1, 'T/E190/W', 'E190', '2013-06-04 19:12:13', NULL, 60.255970, 6.730090),
(11807277, '2013-06-04', 'AEK193', 'AEK', 1023330, 'MPMG', 'pa', 'MROC', 'cr', 'TBG KIKES BDT ISEBA DCT', '// aerocostarica carga // // /V/', '14000', 350, 0, 'C119', 'C119', NULL, NULL, 9.997290, -84.214540),
(11807369, '2013-06-04', 'AGJ108', 'AGJ', 1026408, 'LGIR', 'gr', 'LGLM', 'gr', 'EPALO B26 MIL A10 KEA G33 LUPIS', '', '150', 280, 1, 'T/JS41/F', 'JS41', '2013-06-04 20:22:02', NULL, 39.855730, 25.160180),
(11807606, '2013-06-04', 'TYR1270', 'TYR', 921087, 'EDDF', 'de', 'LOWI', 'at', 'NOMBO Y161 MAH Y162 MANAL M736 TULSI TULS3A/26', '', '29000', 450, 2, 'T/F70/G', 'F70', '2013-06-04 20:44:09', '2013-06-04 21:26:05', 47.258330, 11.346350),
(11807610, '2013-06-04', 'EIN013', 'EIN', 1123282, 'EBBR', 'be', 'LFPG', 'fr', 'CIV Y50 MATIX', 'www.shamrockvirtual.net/Dublin Hub Tour/Leg 4 /V/', '18000', 465, 2, 'B737', 'B737', '2013-06-04 20:44:06', '2013-06-04 21:22:03', 49.016590, 2.544330),
(11807621, '2013-06-04', 'KAL254', 'KAL', 1250425, 'KMCO', 'us', 'KMIA', 'us', 'KMCO RWY 18L ORL. MTHNB DAVALL CURSO MNNDY , KMIA 27', '', '18000', 530, 2, 'B/B744/G', 'B744', '2013-06-04 20:48:06', '2013-06-04 21:22:03', 25.788140, -80.266050),
(11807654, '2013-06-04', 'AFR643', 'AFR', 1254141, 'LPMA', 'pt', 'LFPN', 'fr', 'DEGUN DCT ROLAR DCT VERAM DCT ASMAR DCT DEMOS UN741 NTS UN741 ANG UN482 NIMER', '/V/', '330', 460, 2, 'B744', 'B744', '2013-06-04 20:50:02', '2013-06-04 20:54:03', 44.825510, -0.700380),
(11807713, '2013-06-04', 'SWA1015', 'SWA', 1102087, 'KAUS', 'us', 'KDAL', 'us', 'CWK4 NAVYS DUMPY4', 'SWAVIRTUAL.COM', '22000', 470, 0, 'T/B737/F', 'B737', NULL, NULL, 30.200310, -97.669490),
(11807743, '2013-06-04', 'N133WB', 'N', 893019, 'KAUS', 'us', 'R39', '', '+265', 'Capt ADM with AMERICAN AIRLINES CHARTS on Board private N133WB Also EGF 604 flying for joinava.org HOME BASE CHICAGO. /V/', '2500', 210, 1, 'PA34/E', 'PA34', '2013-06-04 21:16:04', NULL, 30.358650, -97.994050),
(11807784, '2013-06-04', 'PGT0294', 'PGT', 1125750, 'LTFJ', 'tr', 'LTAN', 'tr', 'EDASA UW715 KFK UB545 HISAR', '/V/', '36000', 261, 0, 'B738', 'B738', NULL, NULL, 40.902750, 29.307350),
(11807810, '2013-06-04', 'BRA1726', 'BRA', 1004183, 'SBEG', 'br', 'SBVP', '', 'UW3 MUPEG', '', '340', 520, 0, 'B/B773/F', 'B773', NULL, NULL, -8.713100, -63.900680);
CREATE TABLE IF NOT EXISTS `isocodes` (
`code` varchar(2) NOT NULL,
`country` varchar(100) DEFAULT NULL,
`cleaned` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `isocodes` (`code`, `country`, `cleaned`) VALUES
('AT', 'Austria ', 0),
('BE', 'Belgium ', 0),
('BR', 'Brazil ', 0),
('CR', 'Costa Rica ', 0),
('DE', 'Germany ', 0),
('FR', 'France ', 0),
('GR', 'Greece ', 0),
('GU', 'Guam ', 0),
('IS', 'Iceland ', 0),
('PA', 'Panama ', 0),
('PH', 'Philippines ', 0),
('PT', 'Portugal ', 0),
('TR', 'Turkey ', 0),
('UA', 'Ukraine ', 0),
('US', 'United States ', 0);
CREATE TABLE IF NOT EXISTS `pilots` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cid` mediumint(8) unsigned NOT NULL,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `cid` (`cid`),
FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=131650 ;
INSERT INTO `pilots` (`id`, `cid`, `name`) VALUES
(3626, 893019, 'Stanley Lakin'),
(3650, 1023330, 'Jayne Cruickshank'),
(8116, 921087, 'Laverna Daniel'),
(8623, 1026408, 'Magnus Upton'),
(38004, 1004183, 'Yasmeen Beier'),
(62941, 1102087, 'Hermann Leuschke'),
(66475, 1123282, 'Mason Goyette'),
(67373, 1125750, 'Addison Tromp'),
(94864, 1184536, 'Darien Kunze'),
(107652, 1209665, 'Rosalyn Bednar'),
(126630, 1250425, 'Agnes Fahey'),
(128542, 1254141, 'Carson Waters'),
(128562, 1253455, 'Ephraim Barton');
CREATE TABLE IF NOT EXISTS `position` (
`pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`updateid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`lat` decimal(10,6) DEFAULT NULL,
`lon` decimal(10,6) DEFAULT NULL,
`alt` varchar(6) DEFAULT NULL,
`gs` smallint(5) unsigned DEFAULT NULL,
`hdg` smallint(5) unsigned DEFAULT NULL,
`groundelev` smallint(6) DEFAULT NULL,
PRIMARY KEY (`pid`),
KEY `update` (`updateid`),
KEY `fid` (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=449657793 ;
INSERT INTO `position` (`pid`, `fid`, `updateid`, `lat`, `lon`, `alt`, `gs`, `hdg`, `groundelev`) VALUES
(449570537, 11805315, 1334748, 17.413780, 159.354220, '34991', 497, 76, 0),
(449557906, 11805315, 1334702, 13.618410, 145.210340, '15324', 428, 71, 0),
(449559511, 11805315, 1334708, 14.247900, 147.071650, '33016', 502, 70, 0),
(449564486, 11805315, 1334727, 15.992610, 153.267380, '35051', 499, 75, 0),
(449586965, 11805315, 1334797, 20.067750, 174.863790, '37100', 464, 81, 0),
(449556294, 11805315, 1334696, 13.492280, 144.804440, '311', 0, 334, 138),
(449556018, 11805315, 1334695, 13.492280, 144.804440, '311', 0, 334, 138),
(449556569, 11805315, 1334697, 13.492540, 144.805000, '311', 0, 334, 138),
(449557108, 11805315, 1334699, 13.492950, 144.809240, '311', 21, 87, 161),
(449641541, 11805315, 1334925, 24.408270, -147.489130, '41130', 487, 61, 0),
(449558453, 11805315, 1334704, 13.796500, 145.731420, '23568', 494, 70, 0),
(449558180, 11805315, 1334703, 13.704810, 145.462920, '20278', 465, 71, 0),
(449558996, 11805315, 1334706, 13.989110, 146.300380, '29354', 505, 71, 0),
(449558724, 11805315, 1334705, 13.892420, 146.014220, '26351', 508, 70, 0),
(449559765, 11805315, 1334709, 14.345780, 147.366210, '33030', 504, 70, 0),
(449560021, 11805315, 1334710, 14.444350, 147.663500, '33039', 506, 69, 0),
(449560530, 11805315, 1334712, 14.703790, 148.455030, '33040', 508, 70, 0),
(449560791, 11805315, 1334713, 14.800940, 148.753040, '33040', 508, 70, 0),
(449561050, 11805315, 1334714, 14.891630, 149.042190, '33040', 508, 73, 0),
(449561303, 11805315, 1334715, 14.974110, 149.348270, '33040', 508, 73, 0),
(449561817, 11805315, 1334717, 15.193430, 150.166590, '33040', 508, 73, 0),
(449562327, 11805315, 1334719, 15.405720, 150.971390, '34274', 502, 74, 0),
(449556838, 11805315, 1334698, 13.492540, 144.805000, '311', 0, 334, 138),
(449562844, 11805315, 1334721, 15.561760, 151.572150, '35050', 499, 74, 0),
(449563111, 11805315, 1334722, 15.636550, 151.862090, '35050', 500, 74, 0),
(449563380, 11805315, 1334723, 15.710570, 152.151120, '35050', 499, 74, 0),
(449557374, 11805315, 1334700, 13.441540, 144.777610, '3063', 188, 123, 79),
(449565043, 11805315, 1334729, 16.199970, 154.104390, '35050', 498, 75, 0),
(449564763, 11805315, 1334728, 16.110900, 153.742380, '35050', 498, 75, 0),
(449565319, 11805315, 1334730, 16.267740, 154.381900, '35050', 498, 75, 0),
(449569035, 11805315, 1334743, 17.110290, 157.978800, '34991', 497, 76, 0),
(449566154, 11805315, 1334733, 16.470700, 155.221400, '35044', 498, 75, 0),
(449565876, 11805315, 1334732, 16.403250, 154.940330, '35050', 498, 75, 0),
(449560274, 11805315, 1334711, 14.541560, 147.959450, '33040', 506, 70, 0),
(449566714, 11805315, 1334735, 16.600720, 155.768320, '35041', 498, 75, 0),
(449557640, 11805315, 1334701, 13.500830, 144.892690, '6599', 278, 65, 276),
(449575768, 11805315, 1334765, 18.410730, 164.258130, '36970', 502, 78, 0),
(449566992, 11805315, 1334736, 16.663860, 156.036710, '35021', 498, 75, 0),
(449567276, 11805315, 1334737, 16.727240, 156.307420, '34999', 498, 75, 0),
(449567860, 11805315, 1334739, 16.849270, 156.832040, '34991', 498, 75, 0),
(449568741, 11805315, 1334742, 17.052790, 157.723180, '34991', 497, 76, 0),
(449568448, 11805315, 1334741, 16.991540, 157.453620, '34991', 497, 76, 0),
(449559253, 11805315, 1334707, 14.088390, 146.594860, '31914', 501, 71, 0),
(449610204, 11805315, 1334857, 21.169520, -168.065270, '37111', 488, 88, 0),
(449570234, 11805315, 1334747, 17.359610, 159.105140, '34991', 497, 76, 0),
(449564203, 11805315, 1334726, 15.922540, 152.987470, '35051', 499, 75, 0),
(449563651, 11805315, 1334724, 15.781850, 152.431050, '35051', 500, 74, 0),
(449570838, 11805315, 1334749, 17.487660, 159.695270, '34991', 497, 76, 0),
(449569930, 11805315, 1334746, 17.303550, 158.848530, '34991', 497, 76, 0),
(449571143, 11805315, 1334750, 17.542440, 159.952270, '34991', 497, 76, 0),
(449563924, 11805315, 1334725, 15.852310, 152.708180, '35050', 499, 74, 0),
(449561560, 11805315, 1334716, 15.111720, 149.859830, '33040', 508, 73, 0),
(449572051, 11805315, 1334753, 17.722360, 160.803820, '34991', 498, 77, 0),
(449572968, 11805315, 1334756, 17.896100, 161.644100, '34971', 498, 77, 0),
(449572656, 11805315, 1334755, 17.844550, 161.393900, '34972', 498, 77, 0),
(449562071, 11805315, 1334718, 15.273720, 150.469750, '33049', 503, 74, 0),
(449572353, 11805315, 1334754, 17.776390, 161.063500, '34989', 498, 77, 0),
(449577057, 11805315, 1334769, 18.623450, 165.400450, '36961', 502, 78, 0),
(449573282, 11805315, 1334757, 17.965700, 161.986800, '36087', 498, 77, 0),
(449562586, 11805315, 1334720, 15.484070, 151.271960, '35049', 500, 74, 0),
(449566433, 11805315, 1334734, 16.534480, 155.490020, '35041', 498, 75, 0),
(449573599, 11805315, 1334758, 18.015710, 162.235330, '36966', 499, 77, 0),
(449573906, 11805315, 1334759, 18.065550, 162.484780, '36969', 495, 78, 0),
(449574220, 11805315, 1334760, 18.133550, 162.825970, '36970', 496, 78, 0),
(449574527, 11805315, 1334761, 18.184900, 163.086900, '36970', 494, 77, 0),
(449575143, 11805315, 1334763, 18.297080, 163.662670, '36970', 494, 78, 0),
(449574836, 11805315, 1334762, 18.233110, 163.333710, '36970', 494, 77, 0),
(449576408, 11805315, 1334767, 18.519150, 164.835100, '36970', 502, 78, 0),
(449577718, 11805315, 1334771, 18.725780, 165.963830, '36951', 502, 79, 0),
(449588095, 11805315, 1334800, 20.168480, 175.721070, '37100', 462, 81, 0),
(449568158, 11805315, 1334740, 16.929900, 157.183290, '34991', 497, 76, 0),
(449576729, 11805315, 1334768, 18.565940, 165.087520, '36969', 502, 78, 0),
(449565597, 11805315, 1334731, 16.335910, 154.661580, '35050', 498, 75, 0),
(449579073, 11805315, 1334775, 19.023190, 167.678160, '36960', 491, 80, 0),
(449578049, 11805315, 1334772, 18.826590, 166.528750, '36958', 499, 79, 0),
(449578723, 11805315, 1334774, 18.971160, 167.370120, '36960', 492, 79, 0),
(449567563, 11805315, 1334738, 16.790120, 156.576660, '34992', 498, 75, 0),
(449579420, 11805315, 1334776, 19.072000, 167.971640, '36945', 486, 80, 0),
(449580110, 11805315, 1334778, 19.204380, 168.782180, '36940', 478, 80, 0),
(449592943, 11805315, 1334813, 20.539320, 179.262900, '37100', 466, 83, 0),
(449581179, 11805315, 1334781, 19.339820, 169.635850, '36941', 478, 80, 0),
(449585877, 11805315, 1334794, 19.932270, 173.764480, '37100', 477, 81, 0),
(449569332, 11805315, 1334744, 17.170770, 158.249390, '34991', 497, 76, 0),
(449580462, 11805315, 1334779, 19.250350, 169.069490, '36940', 478, 80, 0),
(449569629, 11805315, 1334745, 17.246510, 158.589750, '34991', 497, 76, 0),
(449581538, 11805315, 1334782, 19.382970, 169.913930, '36940', 478, 80, 0),
(449582256, 11805315, 1334784, 19.469350, 170.480420, '36940', 476, 81, 0),
(449581897, 11805315, 1334783, 19.427340, 170.203470, '36941', 477, 81, 0),
(449571450, 11805315, 1334751, 17.595070, 160.199840, '34991', 498, 76, 0),
(449571752, 11805315, 1334752, 17.667720, 160.543370, '34991', 498, 76, 0),
(449583703, 11805315, 1334788, 19.668380, 171.831250, '36950', 477, 81, 0),
(449583341, 11805315, 1334787, 19.626490, 171.541520, '36949', 475, 81, 0),
(449584068, 11805315, 1334789, 19.707690, 172.107110, '36950', 475, 81, 0),
(449584426, 11805315, 1334790, 19.748400, 172.396200, '36950', 477, 80, 0),
(449585152, 11805315, 1334792, 19.828590, 172.975100, '36951', 476, 80, 0),
(449584788, 11805315, 1334791, 19.789000, 172.686670, '36950', 477, 80, 0),
(449579764, 11805315, 1334777, 19.157640, 168.494200, '36940', 478, 80, 0),
(449578383, 11805315, 1334773, 18.880380, 166.836610, '36960', 492, 79, 0),
(449585516, 11805315, 1334793, 19.866640, 173.254910, '37084', 477, 80, 0),
(449586596, 11805315, 1334796, 20.002620, 174.329760, '37100', 467, 81, 0),
(449619579, 11805315, 1334879, 21.094990, -161.631170, '39150', 482, 90, 0),
(449575450, 11805315, 1334764, 18.347290, 163.924620, '36971', 504, 77, 0),
(449587339, 11805315, 1334798, 20.098630, 175.123360, '37100', 460, 81, 0),
(449576087, 11805315, 1334766, 18.458570, 164.511480, '36970', 502, 78, 0),
(449588842, 11805315, 1334802, 20.229080, 176.254990, '37100', 466, 82, 0),
(449589219, 11805315, 1334803, 20.258110, 176.516750, '37100', 466, 81, 0),
(449588470, 11805315, 1334801, 20.198270, 175.981540, '37100', 466, 81, 0),
(449577072, 11805315, 1334770, 18.667100, 165.639100, '36952', 502, 78, 0),
(449589960, 11805315, 1334805, 20.316820, 177.055260, '37100', 466, 82, 0),
(449589590, 11805315, 1334804, 20.288300, 176.791440, '37100', 466, 82, 0),
(449590326, 11805315, 1334806, 20.345840, 177.327870, '37100', 466, 82, 0),
(449590697, 11805315, 1334807, 20.374760, 177.602920, '37100', 466, 82, 0),
(449582980, 11805315, 1334786, 19.584170, 171.251810, '36943', 476, 81, 0),
(449587716, 11805315, 1334799, 20.130370, 175.393850, '37100', 459, 81, 0),
(449591069, 11805315, 1334808, 20.401850, 177.865770, '37100', 466, 82, 0),
(449591445, 11805315, 1334809, 20.428570, 178.128250, '37100', 466, 82, 0),
(449591820, 11805315, 1334810, 20.456130, 178.403250, '37100', 466, 82, 0),
(449592198, 11805315, 1334811, 20.489070, 178.736880, '37100', 466, 82, 0),
(449592567, 11805315, 1334812, 20.514360, 178.999930, '37100', 466, 82, 0),
(449580818, 11805315, 1334780, 19.294650, 169.349150, '36940', 478, 80, 0),
(449593693, 11805315, 1334815, 20.589420, 179.802370, '37100', 466, 83, 0),
(449593316, 11805315, 1334814, 20.565250, 179.539120, '37100', 466, 83, 0),
(449594074, 11805315, 1334816, 20.613020, -179.933880, '37100', 466, 83, 0),
(449586233, 11805315, 1334795, 19.967200, 174.043630, '37100', 471, 81, 0),
(449594837, 11805315, 1334818, 20.661820, -179.338230, '37100', 464, 84, 0),
(449596376, 11805315, 1334822, 20.763220, -178.012620, '37100', 481, 84, 0),
(449582617, 11805315, 1334785, 19.543540, 170.975640, '36940', 476, 81, 0),
(449595599, 11805315, 1334820, 20.723890, -178.541740, '37100', 474, 83, 0),
(449595990, 11805315, 1334821, 20.744090, -178.273070, '37100', 474, 84, 0),
(449597155, 11805315, 1334824, 20.806160, -177.406900, '37110', 481, 84, 0),
(449596766, 11805315, 1334823, 20.787050, -177.679540, '37108', 481, 84, 0),
(449597541, 11805315, 1334825, 20.823660, -177.148930, '37110', 473, 84, 0),
(449598312, 11805315, 1334827, 20.862960, -176.551580, '37110', 473, 84, 0),
(449598702, 11805315, 1334828, 20.879280, -176.295570, '37110', 473, 84, 0),
(449600260, 11805315, 1334832, 20.945790, -175.172320, '37110', 474, 85, 0),
(449599090, 11805315, 1334829, 20.895850, -176.026430, '37110', 473, 84, 0),
(449599870, 11805315, 1334831, 20.931170, -175.429030, '37110', 473, 85, 0),
(449601041, 11805315, 1334834, 20.978100, -174.575430, '37110', 474, 85, 0),
(449601434, 11805315, 1334835, 20.991440, -174.316530, '37110', 474, 85, 0),
(449602982, 11805315, 1334839, 21.045090, -173.190980, '37110', 474, 85, 0),
(449602207, 11805315, 1334837, 21.020870, -173.718300, '37110', 474, 85, 0),
(449604934, 11805315, 1334844, 21.100600, -171.771940, '37111', 474, 86, 0),
(449602594, 11805315, 1334838, 21.033510, -173.448400, '37110', 474, 85, 0),
(449601822, 11805315, 1334836, 21.005030, -174.046060, '37110', 474, 85, 0),
(449603372, 11805315, 1334840, 21.058680, -172.875700, '37110', 474, 86, 0),
(449605730, 11805315, 1334846, 21.116350, -171.207490, '37110', 474, 86, 0),
(449604152, 11805315, 1334842, 21.079990, -172.358180, '37110', 474, 86, 0),
(449594456, 11805315, 1334817, 20.634730, -179.670010, '37100', 466, 84, 0),
(449620050, 11805315, 1334880, 21.089140, -161.368880, '39150', 482, 90, 0),
(449595217, 11805315, 1334819, 20.703390, -178.811030, '37100', 475, 83, 0),
(449606537, 11805315, 1334848, 21.129810, -170.656790, '37110', 474, 87, 0),
(449606135, 11805315, 1334847, 21.123930, -170.903400, '37110', 474, 86, 0),
(449608149, 11805315, 1334852, 21.151800, -169.536390, '37111', 479, 87, 0),
(449607743, 11805315, 1334851, 21.147590, -169.786260, '37111', 479, 86, 0),
(449605331, 11805315, 1334845, 21.107670, -171.526440, '37111', 474, 86, 0),
(449609382, 11805315, 1334855, 21.164410, -168.620240, '37111', 488, 87, 0),
(449609795, 11805315, 1334856, 21.166860, -168.379420, '37111', 488, 87, 0),
(449597923, 11805315, 1334826, 20.846150, -176.810510, '37110', 473, 84, 0),
(449624843, 11805315, 1334890, 20.998180, -158.476900, '39142', 502, 92, 0),
(449606936, 11805315, 1334849, 21.136900, -170.337730, '37110', 474, 87, 0),
(449611839, 11805315, 1334861, 21.174610, -166.902110, '37111', 494, 89, 0),
(449600648, 11805315, 1334833, 20.963780, -174.844690, '37110', 474, 85, 0),
(449607339, 11805315, 1334850, 21.141900, -170.092920, '37112', 474, 87, 0),
(449611024, 11805315, 1334859, 21.172940, -167.513190, '37111', 494, 89, 0),
(449608970, 11805315, 1334854, 21.160800, -168.924200, '37111', 488, 87, 0),
(449611433, 11805315, 1334860, 21.174080, -167.207940, '37111', 494, 89, 0),
(449612243, 11805315, 1334862, 21.174530, -166.583380, '37111', 494, 89, 0),
(449613062, 11805315, 1334864, 21.173110, -166.031040, '37111', 494, 90, 0),
(449613874, 11805315, 1334866, 21.169450, -165.417390, '37111', 494, 90, 0),
(449614707, 11805315, 1334868, 21.163710, -164.829470, '37111', 494, 90, 0),
(449612652, 11805315, 1334863, 21.173920, -166.277350, '37111', 494, 89, 0),
(449615130, 11805315, 1334869, 21.160350, -164.549280, '37111', 494, 90, 0),
(449614286, 11805315, 1334867, 21.166890, -165.124680, '37111', 494, 90, 0),
(449621003, 11805315, 1334882, 21.074990, -160.795770, '39150', 482, 90, 0),
(449599482, 11805315, 1334830, 20.915490, -175.697990, '37110', 473, 84, 0),
(449615558, 11805315, 1334870, 21.156350, -164.253960, '37111', 494, 90, 0),
(449616431, 11805315, 1334872, 21.142450, -163.626860, '38477', 497, 91, 0),
(449604540, 11805315, 1334843, 21.092630, -172.029070, '37110', 474, 86, 0),
(449615992, 11805315, 1334871, 21.152000, -163.973100, '37111', 494, 90, 0),
(449616870, 11805315, 1334873, 21.133820, -163.347620, '39128', 490, 91, 0),
(449617315, 11805315, 1334874, 21.124670, -163.067940, '39130', 490, 91, 0),
(449619119, 11805315, 1334878, 21.100430, -161.895190, '39150', 482, 90, 0),
(449621485, 11805315, 1334883, 21.066890, -160.497660, '39150', 482, 91, 0),
(449618216, 11805315, 1334876, 21.110990, -162.480600, '39149', 482, 90, 0),
(449603762, 11805315, 1334841, 21.069550, -172.615910, '37110', 474, 86, 0),
(449622452, 11805315, 1334885, 21.050180, -159.935990, '39150', 482, 91, 0),
(449623408, 11805315, 1334887, 21.029870, -159.323740, '39169', 488, 91, 0),
(449622932, 11805315, 1334886, 21.040510, -159.637870, '39161', 489, 91, 0),
(449623880, 11805315, 1334888, 21.020830, -159.069620, '39170', 488, 91, 0),
(449621966, 11805315, 1334884, 21.057930, -160.186850, '39150', 482, 91, 0),
(449625812, 11805315, 1334892, 20.972060, -157.852550, '39141', 504, 93, 0),
(449625329, 11805315, 1334891, 20.985430, -158.165410, '39141', 503, 92, 0),
(449626295, 11805315, 1334893, 20.958440, -157.542530, '39143', 501, 92, 0),
(449630164, 11805315, 1334901, 21.565680, -153.769120, '39155', 507, 74, 0),
(449624360, 11805315, 1334889, 21.008410, -158.738130, '39146', 501, 92, 0),
(449627260, 11805315, 1334895, 20.933320, -156.982430, '39157', 504, 93, 7),
(449608562, 11805315, 1334853, 21.156660, -169.226460, '37111', 488, 87, 0),
(449626778, 11805315, 1334894, 20.945250, -157.245120, '39149', 502, 92, 0),
(449610614, 11805315, 1334858, 21.171630, -167.758120, '37111', 494, 89, 0),
(449628234, 11805315, 1334897, 20.920480, -156.359870, '39138', 505, 73, 56),
(449618667, 11805315, 1334877, 21.106330, -162.206060, '39150', 482, 90, 0),
(449629681, 11805315, 1334900, 21.492050, -154.074350, '39149', 503, 74, 0),
(449631149, 11805315, 1334903, 21.714810, -153.147500, '39158', 505, 68, 0),
(449613469, 11805315, 1334865, 21.171550, -165.725180, '37111', 494, 90, 0),
(449632616, 11805315, 1334906, 22.110760, -152.355810, '39153', 485, 59, 0),
(449629199, 11805315, 1334899, 21.074900, -155.760450, '39148', 497, 73, 0),
(449631637, 11805315, 1334904, 21.830260, -152.915650, '39160', 503, 59, 0),
(449632127, 11805315, 1334905, 21.973970, -152.629520, '39160', 503, 59, 0),
(449633593, 11805315, 1334908, 22.353470, -151.866250, '39151', 473, 59, 0),
(449630654, 11805315, 1334902, 21.637870, -153.466690, '39159', 506, 74, 0),
(449633105, 11805315, 1334907, 22.219290, -152.137270, '39151', 473, 59, 0),
(449620526, 11805315, 1334881, 21.081690, -161.059350, '39150', 482, 90, 0),
(449635066, 11805315, 1334911, 22.721410, -151.110890, '39150', 473, 59, 0),
(449635552, 11805315, 1334912, 22.827630, -150.890440, '39150', 473, 59, 0),
(449617765, 11805315, 1334875, 21.116150, -162.802960, '39137', 482, 90, 0),
(449636520, 11805315, 1334914, 23.085850, -150.350870, '39150', 473, 60, 0),
(449634080, 11805315, 1334909, 22.481580, -151.604000, '39150', 473, 59, 0),
(449637480, 11805315, 1334916, 23.326260, -149.843150, '39132', 473, 60, 0),
(449637004, 11805315, 1334915, 23.191290, -150.128890, '39141', 473, 60, 0),
(449627745, 11805315, 1334896, 20.918560, -156.670100, '39160', 505, 93, 410),
(449637955, 11805315, 1334917, 23.451130, -149.577160, '39131', 473, 60, 0),
(449638212, 11805315, 1334918, 23.560840, -149.342850, '39130', 473, 60, 0),
(449639158, 11805315, 1334920, 23.798410, -148.830630, '39130', 476, 60, 0),
(449642949, 11805315, 1334928, 24.872760, -146.441230, '41131', 487, 61, 0),
(449628717, 11805315, 1334898, 20.999010, -156.059210, '39131', 500, 73, 0),
(449639638, 11805315, 1334921, 23.907030, -148.594460, '39563', 478, 60, 0),
(449640114, 11805315, 1334922, 24.037500, -148.309270, '40634', 488, 60, 0),
(449641063, 11805315, 1334924, 24.278470, -147.777860, '41130', 487, 61, 0),
(449640591, 11805315, 1334923, 24.168130, -148.021850, '41128', 487, 61, 0),
(449642011, 11805315, 1334926, 24.517240, -147.245760, '41130', 487, 61, 0),
(449644808, 11805315, 1334932, 25.339120, -145.363320, '41130', 489, 63, 0),
(449643418, 11805315, 1334929, 24.980550, -146.194540, '41130', 487, 61, 0),
(449655620, 11805315, 1334959, 28.450110, -137.343940, '41038', 491, 68, 0),
(449645710, 11805315, 1334934, 25.569300, -144.821050, '41130', 489, 63, 0),
(449644349, 11805315, 1334931, 25.227150, -145.624470, '41131', 489, 63, 0),
(449643887, 11805315, 1334930, 25.115690, -145.883090, '41130', 486, 63, 0),
(449645261, 11805315, 1334933, 25.454410, -145.092380, '41130', 489, 63, 0),
(449649240, 11805315, 1334942, 26.582090, -142.349510, '41140', 490, 65, 0),
(449646612, 11805315, 1334936, 25.794240, -144.284550, '41130', 490, 64, 0),
(449647053, 11805315, 1334937, 25.913250, -143.997810, '41139', 490, 64, 0),
(449650901, 11805315, 1334946, 27.037120, -141.188190, '41112', 494, 65, 0),
(449648803, 11805315, 1334941, 26.374040, -142.868490, '41140', 490, 65, 0),
(449649670, 11805315, 1334943, 26.698460, -142.055690, '41140', 494, 65, 0),
(449650500, 11805315, 1334945, 26.914420, -141.504420, '41128', 494, 65, 0),
(449634574, 11805315, 1334910, 22.589240, -151.383590, '39150', 473, 59, 0),
(449650090, 11805315, 1334944, 26.794650, -141.810880, '41140', 494, 65, 0),
(449651694, 11805315, 1334948, 27.232260, -140.679820, '41120', 494, 66, 0),
(449652458, 11805315, 1334950, 27.460310, -140.076860, '41112', 494, 66, 0),
(449636034, 11805315, 1334913, 22.959130, -150.616180, '39151', 473, 60, 0),
(449652828, 11805315, 1334951, 27.562400, -139.804820, '41111', 489, 67, 0),
(449652082, 11805315, 1334949, 27.357660, -140.349660, '41119', 494, 66, 0),
(449653192, 11805315, 1334952, 27.667000, -139.523330, '41111', 488, 67, 0),
(449638685, 11805315, 1334919, 23.688990, -149.067240, '39130', 473, 60, 0),
(449654252, 11805315, 1334955, 27.944850, -138.765230, '41060', 488, 68, 0),
(449653900, 11805315, 1334954, 27.841680, -139.048320, '41126', 488, 67, 0),
(449654600, 11805315, 1334956, 28.051830, -138.468480, '41043', 491, 68, 0),
(449653551, 11805315, 1334953, 27.771030, -139.241380, '41111', 488, 67, 0),
(449656593, 11805315, 1334962, 28.862290, -136.142680, '41040', 495, 69, 0),
(449655283, 11805315, 1334958, 28.264800, -137.871240, '41036', 491, 68, 0),
(449656912, 11805315, 1334963, 28.943810, -135.900250, '41040', 495, 69, 0),
(449656275, 11805315, 1334961, 28.750170, -136.473570, '41040', 495, 69, 0),
(449657230, 11805315, 1334964, 29.054240, -135.568880, '41040', 495, 69, 0),
(449647493, 11805315, 1334938, 26.026500, -143.723100, '41140', 490, 65, 0),
(449657553, 11805315, 1334965, 29.138860, -135.312360, '41048', 495, 69, 0),
(449642478, 11805315, 1334927, 24.759070, -146.699900, '41130', 487, 61, 0),
(449655952, 11805315, 1334960, 28.558970, -137.031150, '41040', 491, 68, 0),
(449646160, 11805315, 1334935, 25.680050, -144.557620, '41130', 489, 64, 0),
(449647751, 11805315, 1334939, NULL, NULL, NULL, NULL, NULL, NULL),
(449648369, 11805315, 1334940, 26.257210, -143.157620, '41140', 490, 65, 0),
(449651303, 11805315, 1334947, 27.132150, -140.941520, '41118', 494, 66, 0),
(449654944, 11805315, 1334957, 28.159070, -138.168830, '41041', 491, 68, 0),
(449571343, 11805687, 1334750, 37.616770, -122.382090, '27', 0, 24, 3),
(449653778, 11805687, 1334953, 37.616770, -122.382090, '27', 0, 24, 3),
(449625666, 11805687, 1334891, 37.616770, -122.382090, '27', 0, 24, 3),
(449597791, 11805687, 1334825, 37.616770, -122.382090, '27', 0, 24, 3),
(449655500, 11805687, 1334958, 37.616770, -122.382090, '27', 0, 24, 3),
(449571649, 11805687, 1334751, 37.616770, -122.382090, '27', 0, 24, 3),
(449571948, 11805687, 1334752, 37.616770, -122.382090, '27', 0, 24, 3),
(449572248, 11805687, 1334753, 37.616770, -122.382090, '27', 0, 24, 3),
(449572551, 11805687, 1334754, 37.616770, -122.382090, '27', 0, 24, 3),
(449572859, 11805687, 1334755, 37.616770, -122.382090, '27', 0, 24, 3),
(449573174, 11805687, 1334756, 37.616770, -122.382090, '27', 0, 24, 3),
(449573492, 11805687, 1334757, 37.616770, -122.382090, '27', 0, 24, 3),
(449573803, 11805687, 1334758, 37.616770, -122.382090, '27', 0, 24, 3),
(449574112, 11805687, 1334759, 37.616770, -122.382090, '27', 0, 24, 3),
(449574422, 11805687, 1334760, 37.616770, -122.382090, '27', 0, 24, 3),
(449574730, 11805687, 1334761, 37.616770, -122.382090, '27', 0, 24, 3),
(449575041, 11805687, 1334762, 37.616770, -122.382090, '27', 0, 24, 3),
(449575350, 11805687, 1334763, 37.616770, -122.382090, '27', 0, 24, 3),
(449575666, 11805687, 1334764, 37.616770, -122.382090, '27', 0, 24, 3),
(449575982, 11805687, 1334765, 37.616770, -122.382090, '27', 0, 24, 3),
(449576305, 11805687, 1334766, 37.616770, -122.382090, '27', 0, 24, 3),
(449576625, 11805687, 1334767, 37.616770, -122.382090, '27', 0, 24, 3),
(449576952, 11805687, 1334768, 37.616770, -122.382090, '27', 0, 24, 3),
(449577514, 11805687, 1334770, 37.616770, -122.382090, '27', 0, 24, 3),
(449577516, 11805687, 1334769, 37.616770, -122.382090, '27', 0, 24, 3),
(449577946, 11805687, 1334771, 37.616770, -122.382090, '27', 0, 24, 3),
(449578280, 11805687, 1334772, 37.616770, -122.382090, '27', 0, 24, 3),
(449619432, 11805687, 1334878, 37.616770, -122.382090, '27', 0, 24, 3),
(449578621, 11805687, 1334773, 37.616770, -122.382090, '27', 0, 24, 3),
(449578966, 11805687, 1334774, 37.616770, -122.382090, '27', 0, 24, 3),
(449579314, 11805687, 1334775, 37.616770, -122.382090, '27', 0, 24, 3),
(449579658, 11805687, 1334776, 37.616770, -122.382090, '27', 0, 24, 3),
(449580005, 11805687, 1334777, 37.616770, -122.382090, '27', 0, 24, 3),
(449580353, 11805687, 1334778, 37.616770, -122.382090, '27', 0, 24, 3),
(449580708, 11805687, 1334779, 37.616770, -122.382090, '27', 0, 24, 3),
(449581064, 11805687, 1334780, 37.616770, -122.382090, '27', 0, 24, 3),
(449581423, 11805687, 1334781, 37.616770, -122.382090, '27', 0, 24, 3),
(449581782, 11805687, 1334782, 37.616770, -122.382090, '27', 0, 24, 3),
(449582141, 11805687, 1334783, 37.616770, -122.382090, '27', 0, 24, 3),
(449582500, 11805687, 1334784, 37.616770, -122.382090, '27', 0, 24, 3),
(449582862, 11805687, 1334785, 37.616770, -122.382090, '27', 0, 24, 3),
(449583225, 11805687, 1334786, 37.616770, -122.382090, '27', 0, 24, 3),
(449583586, 11805687, 1334787, 37.616770, -122.382090, '27', 0, 24, 3),
(449583950, 11805687, 1334788, 37.616770, -122.382090, '27', 0, 24, 3),
(449584310, 11805687, 1334789, 37.616770, -122.382090, '27', 0, 24, 3),
(449584671, 11805687, 1334790, 37.616770, -122.382090, '27', 0, 24, 3),
(449585035, 11805687, 1334791, 37.616770, -122.382090, '27', 0, 24, 3),
(449585402, 11805687, 1334792, 37.616770, -122.382090, '27', 0, 24, 3),
(449585761, 11805687, 1334793, 37.616770, -122.382090, '27', 0, 24, 3),
(449586116, 11805687, 1334794, 37.616770, -122.382090, '27', 0, 24, 3),
(449586476, 11805687, 1334795, 37.616770, -122.382090, '27', 0, 24, 3),
(449586841, 11805687, 1334796, 37.616770, -122.382090, '27', 0, 24, 3),
(449587210, 11805687, 1334797, 37.616770, -122.382090, '27', 0, 24, 3),
(449587587, 11805687, 1334798, 37.616770, -122.382090, '27', 0, 24, 3),
(449587966, 11805687, 1334799, 37.616770, -122.382090, '27', 0, 24, 3),
(449588341, 11805687, 1334800, 37.616770, -122.382090, '27', 0, 24, 3),
(449588715, 11805687, 1334801, 37.616770, -122.382090, '27', 0, 24, 3),
(449589089, 11805687, 1334802, 37.616770, -122.382090, '27', 0, 24, 3),
(449589461, 11805687, 1334803, 37.616770, -122.382090, '27', 0, 24, 3),
(449589830, 11805687, 1334804, 37.616770, -122.382090, '27', 0, 24, 3),
(449590201, 11805687, 1334805, 37.616770, -122.382090, '27', 0, 24, 3),
(449590571, 11805687, 1334806, 37.616770, -122.382090, '27', 0, 24, 3),
(449590941, 11805687, 1334807, 37.616770, -122.382090, '27', 0, 24, 3),
(449591312, 11805687, 1334808, 37.616770, -122.382090, '27', 0, 24, 3),
(449591682, 11805687, 1334809, 37.616770, -122.382090, '27', 0, 24, 3),
(449592056, 11805687, 1334810, 37.616770, -122.382090, '27', 0, 24, 3),
(449592430, 11805687, 1334811, 37.616770, -122.382090, '27', 0, 24, 3),
(449592807, 11805687, 1334812, 37.616770, -122.382090, '27', 0, 24, 3),
(449593179, 11805687, 1334813, 37.616770, -122.382090, '27', 0, 24, 3),
(449593554, 11805687, 1334814, 37.616770, -122.382090, '27', 0, 24, 3),
(449593933, 11805687, 1334815, 37.616770, -122.382090, '27', 0, 24, 3),
(449594317, 11805687, 1334816, 37.616770, -122.382090, '27', 0, 24, 3),
(449594699, 11805687, 1334817, 37.616770, -122.382090, '27', 0, 24, 3),
(449595081, 11805687, 1334818, 37.616770, -122.382090, '27', 0, 24, 3),
(449595465, 11805687, 1334819, 37.616770, -122.382090, '27', 0, 24, 3),
(449595854, 11805687, 1334820, 37.616770, -122.382090, '27', 0, 24, 3),
(449596241, 11805687, 1334821, 37.616770, -122.382090, '27', 0, 24, 3),
(449596629, 11805687, 1334822, 37.616770, -122.382090, '27', 0, 24, 3),
(449597021, 11805687, 1334823, 37.616770, -122.382090, '27', 0, 24, 3),
(449597411, 11805687, 1334824, 37.616770, -122.382090, '27', 0, 24, 3),
(449598177, 11805687, 1334826, 37.616770, -122.382090, '27', 0, 24, 3),
(449598563, 11805687, 1334827, 37.616770, -122.382090, '27', 0, 24, 3),
(449598952, 11805687, 1334828, 37.616770, -122.382090, '27', 0, 24, 3),
(449599344, 11805687, 1334829, 37.616770, -122.382090, '27', 0, 24, 3),
(449599735, 11805687, 1334830, 37.616770, -122.382090, '27', 0, 24, 3),
(449600119, 11805687, 1334831, 37.616770, -122.382090, '27', 0, 24, 3),
(449600508, 11805687, 1334832, 37.616770, -122.382090, '27', 0, 24, 3),
(449600898, 11805687, 1334833, 37.616770, -122.382090, '27', 0, 24, 3),
(449601292, 11805687, 1334834, 37.616770, -122.382090, '27', 0, 24, 3),
(449601681, 11805687, 1334835, 37.616770, -122.382090, '27', 0, 24, 3),
(449602067, 11805687, 1334836, 37.616770, -122.382090, '27', 0, 24, 3),
(449602454, 11805687, 1334837, 37.616770, -122.382090, '27', 0, 24, 3),
(449602845, 11805687, 1334838, 37.616770, -122.382090, '27', 0, 24, 3),
(449603236, 11805687, 1334839, 37.616770, -122.382090, '27', 0, 24, 3),
(449603630, 11805687, 1334840, 37.616770, -122.382090, '27', 0, 24, 3),
(449604018, 11805687, 1334841, 37.616770, -122.382090, '27', 0, 24, 3),
(449604405, 11805687, 1334842, 37.616770, -122.382090, '27', 0, 24, 3),
(449604799, 11805687, 1334843, 37.616770, -122.382090, '27', 0, 24, 3),
(449605196, 11805687, 1334844, 37.616770, -122.382090, '27', 0, 24, 3),
(449605597, 11805687, 1334845, 37.616770, -122.382090, '27', 0, 24, 3),
(449605998, 11805687, 1334846, 37.616770, -122.382090, '27', 0, 24, 3),
(449606404, 11805687, 1334847, 37.616770, -122.382090, '27', 0, 24, 3),
(449606803, 11805687, 1334848, 37.616770, -122.382090, '27', 0, 24, 3),
(449645113, 11805687, 1334932, 37.616770, -122.382090, '27', 0, 24, 3),
(449607205, 11805687, 1334849, 37.616770, -122.382090, '27', 0, 24, 3),
(449607612, 11805687, 1334850, 37.616770, -122.382090, '27', 0, 24, 3),
(449608018, 11805687, 1334851, 37.616770, -122.382090, '27', 0, 24, 3),
(449608430, 11805687, 1334852, 37.616770, -122.382090, '27', 0, 24, 3),
(449608839, 11805687, 1334853, 37.616770, -122.382090, '27', 0, 24, 3),
(449609254, 11805687, 1334854, 37.616770, -122.382090, '27', 0, 24, 3),
(449609667, 11805687, 1334855, 37.616770, -122.382090, '27', 0, 24, 3),
(449610076, 11805687, 1334856, 37.616770, -122.382090, '27', 0, 24, 3),
(449610487, 11805687, 1334857, 37.616770, -122.382090, '27', 0, 24, 3),
(449610898, 11805687, 1334858, 37.616770, -122.382090, '27', 0, 24, 3),
(449611308, 11805687, 1334859, 37.616770, -122.382090, '27', 0, 24, 3),
(449611715, 11805687, 1334860, 37.616770, -122.382090, '27', 0, 24, 3),
(449612120, 11805687, 1334861, 37.616770, -122.382090, '27', 0, 24, 3),
(449612524, 11805687, 1334862, 37.616770, -122.382090, '27', 0, 24, 3),
(449612932, 11805687, 1334863, 37.616770, -122.382090, '27', 0, 24, 3),
(449613342, 11805687, 1334864, 37.616770, -122.382090, '27', 0, 24, 3),
(449613747, 11805687, 1334865, 37.616770, -122.382090, '27', 0, 24, 3),
(449614157, 11805687, 1334866, 37.616770, -122.382090, '27', 0, 24, 3),
(449614575, 11805687, 1334867, 37.616770, -122.382090, '27', 0, 24, 3),
(449615000, 11805687, 1334868, 37.616770, -122.382090, '27', 0, 24, 3),
(449615427, 11805687, 1334869, 37.616770, -122.382090, '27', 0, 24, 3),
(449615857, 11805687, 1334870, 37.616770, -122.382090, '27', 0, 24, 3),
(449616295, 11805687, 1334871, 37.616770, -122.382090, '27', 0, 24, 3),
(449616728, 11805687, 1334872, 37.616770, -122.382090, '27', 0, 24, 3),
(449617173, 11805687, 1334873, 37.616770, -122.382090, '27', 0, 24, 3),
(449617618, 11805687, 1334874, 37.616770, -122.382090, '27', 0, 24, 3),
(449618068, 11805687, 1334875, 37.616770, -122.382090, '27', 0, 24, 3),
(449618521, 11805687, 1334876, 37.616770, -122.382090, '27', 0, 24, 3),
(449645565, 11805687, 1334933, 37.616770, -122.382090, '27', 0, 24, 3),
(449618973, 11805687, 1334877, 37.616770, -122.382090, '27', 0, 24, 3),
(449619902, 11805687, 1334879, 37.616770, -122.382090, '27', 0, 24, 3),
(449620379, 11805687, 1334880, 37.616770, -122.382090, '27', 0, 24, 3),
(449620858, 11805687, 1334881, 37.616770, -122.382090, '27', 0, 24, 3),
(449621337, 11805687, 1334882, 37.616770, -122.382090, '27', 0, 24, 3),
(449621819, 11805687, 1334883, 37.616770, -122.382090, '27', 0, 24, 3),
(449622304, 11805687, 1334884, 37.616770, -122.382090, '27', 0, 24, 3),
(449622786, 11805687, 1334885, 37.616770, -122.382090, '27', 0, 24, 3),
(449623264, 11805687, 1334886, 37.616770, -122.382090, '27', 0, 24, 3),
(449623741, 11805687, 1334887, 37.616770, -122.382090, '27', 0, 24, 3),
(449624216, 11805687, 1334888, 37.616770, -122.382090, '27', 0, 24, 3),
(449624699, 11805687, 1334889, 37.616770, -122.382090, '27', 0, 24, 3),
(449625183, 11805687, 1334890, 37.616770, -122.382090, '27', 0, 24, 3),
(449626149, 11805687, 1334892, 37.616770, -122.382090, '27', 0, 24, 3),
(449626633, 11805687, 1334893, 37.616770, -122.382090, '27', 0, 24, 3),
(449644659, 11805687, 1334931, 37.616770, -122.382090, '27', 0, 24, 3),
(449627114, 11805687, 1334894, 37.616770, -122.382090, '27', 0, 24, 3),
(449627597, 11805687, 1334895, 37.616770, -122.382090, '27', 0, 24, 3),
(449628090, 11805687, 1334896, 37.616770, -122.382090, '27', 0, 24, 3),
(449654126, 11805687, 1334954, 37.616770, -122.382090, '27', 0, 24, 3),
(449628576, 11805687, 1334897, 37.616770, -122.382090, '27', 0, 24, 3),
(449629057, 11805687, 1334898, 37.616770, -122.382090, '27', 0, 24, 3),
(449629539, 11805687, 1334899, 37.616770, -122.382090, '27', 0, 24, 3),
(449630022, 11805687, 1334900, 37.616770, -122.382090, '27', 0, 24, 3),
(449630507, 11805687, 1334901, 37.616770, -122.382090, '27', 0, 24, 3),
(449630999, 11805687, 1334902, 37.616770, -122.382090, '27', 0, 24, 3),
(449631490, 11805687, 1334903, 37.616770, -122.382090, '27', 0, 24, 3),
(449631979, 11805687, 1334904, 37.616770, -122.382090, '27', 0, 24, 3),
(449632471, 11805687, 1334905, 37.616770, -122.382090, '27', 0, 24, 3),
(449632958, 11805687, 1334906, 37.616770, -122.382090, '27', 0, 24, 3),
(449633445, 11805687, 1334907, 37.616770, -122.382090, '27', 0, 24, 3),
(449633931, 11805687, 1334908, 37.616770, -122.382090, '27', 0, 24, 3),
(449634423, 11805687, 1334909, 37.616770, -122.382090, '27', 0, 24, 3),
(449634914, 11805687, 1334910, 37.616770, -122.382090, '27', 0, 24, 3),
(449635402, 11805687, 1334911, 37.616770, -122.382090, '27', 0, 24, 3),
(449635887, 11805687, 1334912, 37.616770, -122.382090, '27', 0, 24, 3),
(449636372, 11805687, 1334913, 37.616770, -122.382090, '27', 0, 24, 3),
(449636852, 11805687, 1334914, 37.616770, -122.382090, '27', 0, 24, 3),
(449637329, 11805687, 1334915, 37.616770, -122.382090, '27', 0, 24, 3),
(449637804, 11805687, 1334916, 37.616770, -122.382090, '27', 0, 24, 3),
(449638536, 11805687, 1334918, 37.616770, -122.382090, '27', 0, 24, 3),
(449639005, 11805687, 1334919, 37.616770, -122.382090, '27', 0, 24, 3),
(449639482, 11805687, 1334920, 37.616770, -122.382090, '27', 0, 24, 3),
(449639959, 11805687, 1334921, 37.616770, -122.382090, '27', 0, 24, 3),
(449640436, 11805687, 1334922, 37.616770, -122.382090, '27', 0, 24, 3),
(449640916, 11805687, 1334923, 37.616770, -122.382090, '27', 0, 24, 3),
(449641392, 11805687, 1334924, 37.616770, -122.382090, '27', 0, 24, 3),
(449641864, 11805687, 1334925, 37.616770, -122.382090, '27', 0, 24, 3),
(449656483, 11805687, 1334961, 37.616770, -122.382090, '27', 0, 24, 3),
(449642331, 11805687, 1334926, 37.616770, -122.382090, '27', 0, 24, 3),
(449642800, 11805687, 1334927, 37.616770, -122.382090, '27', 0, 24, 3),
(449643267, 11805687, 1334928, 37.616770, -122.382090, '27', 0, 24, 3),
(449643735, 11805687, 1334929, 37.616770, -122.382090, '27', 0, 24, 3),
(449644199, 11805687, 1334930, 37.616770, -122.382090, '27', 0, 24, 3),
(449646014, 11805687, 1334934, 37.616770, -122.382090, '27', 0, 24, 3),
(449646464, 11805687, 1334935, 37.616770, -122.382090, '27', 0, 24, 3),
(449646904, 11805687, 1334936, 37.616770, -122.382090, '27', 0, 24, 3),
(449647345, 11805687, 1334937, 37.616770, -122.382090, '27', 0, 24, 3),
(449647828, 11805687, 1334938, 37.616770, -122.382090, '27', 0, 24, 3),
(449648224, 11805687, 1334939, 37.616770, -122.382090, '27', 0, 24, 3),
(449648660, 11805687, 1334940, 37.616770, -122.382090, '27', 0, 24, 3),
(449649097, 11805687, 1334941, 37.616770, -122.382090, '27', 0, 24, 3),
(449649528, 11805687, 1334942, 37.616770, -122.382090, '27', 0, 24, 3),
(449649953, 11805687, 1334943, 37.616770, -122.382090, '27', 0, 24, 3),
(449650366, 11805687, 1334944, 37.616770, -122.382090, '27', 0, 24, 3),
(449650771, 11805687, 1334945, 37.616770, -122.382090, '27', 0, 24, 3),
(449651171, 11805687, 1334946, 37.616770, -122.382090, '27', 0, 24, 3),
(449651564, 11805687, 1334947, 37.616770, -122.382090, '27', 0, 24, 3),
(449651949, 11805687, 1334948, 37.616770, -122.382090, '27', 0, 24, 3),
(449652328, 11805687, 1334949, 37.616770, -122.382090, '27', 0, 24, 3),
(449652701, 11805687, 1334950, 37.616770, -122.382090, '27', 0, 24, 3),
(449653066, 11805687, 1334951, 37.616770, -122.382090, '27', 0, 24, 3),
(449653426, 11805687, 1334952, 37.616770, -122.382090, '27', 0, 24, 3),
(449654474, 11805687, 1334955, 37.616770, -122.382090, '27', 0, 24, 3),
(449654820, 11805687, 1334956, 37.616770, -122.382090, '27', 0, 24, 3),
(449655163, 11805687, 1334957, 37.616770, -122.382090, '27', 0, 24, 3),
(449655834, 11805687, 1334959, 37.616770, -122.382090, '27', 0, 24, 3),
(449656161, 11805687, 1334960, 37.616770, -122.382090, '27', 0, 24, 3),
(449641329, 11806721, 1334924, 54.830750, 25.218630, '38023', 468, 326, 574),
(449654090, 11806721, 1334954, 59.931810, 13.311740, '38231', 472, 281, 869),
(449625609, 11806721, 1334891, 50.350730, 30.900880, '437', 0, 92, 390),
(449655464, 11806721, 1334958, 60.075380, 11.301800, '38319', 451, 279, 722),
(449653742, 11806721, 1334953, 59.883480, 13.825400, '38230', 474, 280, 938),
(449644607, 11806721, 1334931, 56.561170, 23.118870, '38053', 469, 318, 272),
(449645061, 11806721, 1334932, 56.749180, 22.817530, '38053', 474, 317, 394),
(449619375, 11806721, 1334878, 50.350730, 30.900880, '437', 0, 92, 390),
(449613295, 11806721, 1334864, NULL, NULL, NULL, NULL, NULL, NULL),
(449613698, 11806721, 1334865, 50.350730, 30.900880, '437', 0, 92, 390),
(449614107, 11806721, 1334866, 50.350730, 30.900880, '437', 0, 92, 390),
(449614524, 11806721, 1334867, 50.350730, 30.900880, '437', 0, 92, 390),
(449614947, 11806721, 1334868, 50.350730, 30.900880, '437', 0, 92, 390),
(449615374, 11806721, 1334869, 50.350730, 30.900880, '437', 0, 92, 390),
(449615803, 11806721, 1334870, 50.350730, 30.900880, '437', 0, 92, 390),
(449616239, 11806721, 1334871, 50.350730, 30.900880, '437', 0, 92, 390),
(449616676, 11806721, 1334872, 50.350730, 30.900880, '437', 0, 92, 390),
(449617120, 11806721, 1334873, 50.350730, 30.900880, '437', 0, 92, 390),
(449617564, 11806721, 1334874, 50.350730, 30.900880, '437', 0, 92, 390),
(449618014, 11806721, 1334875, 50.350730, 30.900880, '437', 0, 92, 390),
(449618466, 11806721, 1334876, 50.350730, 30.900880, '437', 0, 92, 390),
(449618918, 11806721, 1334877, 50.350730, 30.900880, '437', 0, 92, 390),
(449619845, 11806721, 1334879, 50.350730, 30.900880, '437', 0, 92, 390),
(449620321, 11806721, 1334880, 50.350730, 30.900880, '437', 0, 92, 390),
(449620798, 11806721, 1334881, 50.350730, 30.900880, '437', 0, 92, 390),
(449621278, 11806721, 1334882, 50.350730, 30.900880, '437', 0, 92, 390),
(449621755, 11806721, 1334883, 50.350730, 30.900880, '437', 0, 92, 390),
(449622239, 11806721, 1334884, 50.350730, 30.900880, '437', 0, 92, 390),
(449622722, 11806721, 1334885, 50.350730, 30.900880, '437', 0, 92, 390),
(449645511, 11806721, 1334933, 56.945830, 22.496200, '38079', 471, 316, 295),
(449623202, 11806721, 1334886, 50.350730, 30.900880, '437', 0, 92, 390),
(449623681, 11806721, 1334887, 50.350730, 30.900880, '437', 0, 92, 390),
(449624155, 11806721, 1334888, 50.350730, 30.900880, '437', 0, 92, 390),
(449624639, 11806721, 1334889, 50.350730, 30.900880, '437', 0, 92, 390),
(449625124, 11806721, 1334890, 50.350730, 30.900880, '437', 0, 92, 390),
(449626092, 11806721, 1334892, 50.350730, 30.900880, '437', 0, 92, 390),
(449626578, 11806721, 1334893, 50.350730, 30.900880, '437', 0, 92, 390),
(449627059, 11806721, 1334894, 50.350730, 30.900880, '437', 0, 92, 390),
(449627541, 11806721, 1334895, 50.350730, 30.900750, '437', 2, 92, 390),
(449628031, 11806721, 1334896, 50.351510, 30.899450, '437', 0, 181, 390),
(449628517, 11806721, 1334897, 50.348930, 30.900060, '437', 11, 117, 390),
(449628999, 11806721, 1334898, 50.340780, 30.901760, '437', 19, 182, 394),
(449629481, 11806721, 1334899, 50.329530, 30.900940, '437', 16, 182, 400),
(449656445, 11806721, 1334961, 60.184430, 8.787610, '38290', 470, 276, 3963),
(449629969, 11806721, 1334900, 50.396400, 30.909280, '2401', 218, 4, 390),
(449630451, 11806721, 1334901, 50.545480, 30.906850, '9107', 269, 353, 351),
(449630942, 11806721, 1334902, 50.715540, 30.828440, '13421', 359, 336, 348),
(449631434, 11806721, 1334903, 50.918640, 30.679960, '18702', 392, 335, 325),
(449631921, 11806721, 1334904, 51.098790, 30.546360, '22248', 417, 335, 305),
(449632414, 11806721, 1334905, 51.321790, 30.379020, '25770', 441, 334, 344),
(449632901, 11806721, 1334906, 51.556250, 30.201500, '30119', 419, 334, 302),
(449633388, 11806721, 1334907, 51.741960, 30.060230, '32437', 417, 334, 387),
(449633875, 11806721, 1334908, 51.915830, 29.820000, '34064', 426, 290, 420),
(449634365, 11806721, 1334909, 52.016240, 29.413530, '34054', 460, 292, 384),
(449634855, 11806721, 1334910, 52.103650, 29.079270, '34000', 460, 292, 413),
(449635346, 11806721, 1334911, 52.235290, 28.710310, '34000', 463, 323, 404),
(449635831, 11806721, 1334912, 52.430310, 28.491370, '34630', 467, 324, 397),
(449636311, 11806721, 1334913, 52.649330, 28.236610, '35950', 464, 324, 358),
(449636793, 11806721, 1334914, 52.878200, 27.965250, '36007', 463, 323, 449),
(449649902, 11806721, 1334943, 58.692220, 18.301460, '38201', 475, 299, 0),
(449637269, 11806721, 1334915, 53.060910, 27.745900, '36003', 465, 323, 512),
(449637743, 11806721, 1334916, 53.287600, 27.472110, '36008', 461, 323, 531),
(449638473, 11806721, 1334918, 53.705910, 26.958350, '36779', 468, 323, 705),
(449638941, 11806721, 1334919, 53.926800, 26.663030, '37790', 466, 308, 640),
(449639420, 11806721, 1334920, 54.084740, 26.360400, '37994', 470, 311, 538),
(449639898, 11806721, 1334921, 54.243660, 26.054470, '38023', 467, 310, 784),
(449640373, 11806721, 1334922, 54.409090, 25.734610, '38024', 466, 310, 627),
(449640854, 11806721, 1334923, 54.638680, 25.430340, '38024', 468, 327, 755),
(449641806, 11806721, 1334925, 55.067580, 24.952960, '38024', 468, 326, 440),
(449642275, 11806721, 1334926, 55.267990, 24.725010, '38023', 466, 325, 266),
(449642745, 11806721, 1334927, 55.717190, 24.202320, '38053', 467, 325, 171),
(449643213, 11806721, 1334928, 55.916540, 23.965500, '38053', 467, 324, 223),
(449643682, 11806721, 1334929, 56.121980, 23.718300, '38053', 467, 324, 269),
(449644146, 11806721, 1334930, 56.371550, 23.411370, '38052', 466, 318, 154),
(449645959, 11806721, 1334934, 57.146180, 22.192090, '38113', 472, 322, 95),
(449646408, 11806721, 1334935, 57.349430, 21.918760, '38112', 473, 322, 95),
(449646850, 11806721, 1334936, 57.561300, 21.629760, '38112', 472, 322, 0),
(449647291, 11806721, 1334937, 57.746430, 21.290480, '38115', 469, 299, 0),
(449647732, 11806721, 1334938, 57.886490, 20.855580, '38142', 469, 299, 0),
(449648169, 11806721, 1334939, 58.021180, 20.436880, '38146', 469, 299, 0),
(449648606, 11806721, 1334940, 58.164320, 19.996570, '38197', 469, 300, 0),
(449649044, 11806721, 1334941, 58.305390, 19.555610, '38201', 469, 299, 0),
(449649474, 11806721, 1334942, 58.554450, 18.755900, '38200', 471, 299, 0),
(449650315, 11806721, 1334944, 58.807780, 17.913040, '38201', 474, 298, 0),
(449650722, 11806721, 1334945, 58.956560, 17.445180, '38202', 478, 306, 141),
(449651123, 11806721, 1334946, 59.136610, 16.980200, '38201', 477, 306, 131),
(449651521, 11806721, 1334947, 59.272220, 16.622620, '38200', 464, 306, 135),
(449651907, 11806721, 1334948, 59.413550, 16.243910, '38202', 476, 305, 75),
(449652285, 11806721, 1334949, 59.594850, 15.748890, '38200', 478, 305, 256),
(449652658, 11806721, 1334950, 59.732360, 15.329870, '38202', 472, 284, 476),
(449653023, 11806721, 1334951, 59.782090, 14.843150, '38201', 469, 281, 709),
(449653386, 11806721, 1334952, 59.833240, 14.337070, '38200', 467, 281, 919),
(449654437, 11806721, 1334955, 59.977070, 12.808280, '38260', 443, 283, 656),
(449654784, 11806721, 1334956, 60.018710, 12.306850, '38289', 440, 281, 787),
(449655127, 11806721, 1334957, 60.048080, 11.800830, '38319', 447, 280, 1066),
(449655798, 11806721, 1334959, 60.122360, 10.350550, '38319', 468, 277, 394),
(449656123, 11806721, 1334960, 60.146830, 9.787870, '38319', 467, 277, 919),
(449656762, 11806721, 1334962, 60.202860, 8.202480, '38289', 468, 276, 4199),
(449657080, 11806721, 1334963, 60.214960, 7.764420, '38290', 467, 275, 4045),
(449657399, 11806721, 1334964, 60.235760, 7.184000, '38289', 463, 278, 3675),
(449657716, 11806721, 1334965, 60.255970, 6.730090, '38260', 462, 278, 4396),
(449654272, 11807277, 1334955, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449656612, 11807277, 1334962, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449657248, 11807277, 1334964, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449634103, 11807277, 1334909, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449639181, 11807277, 1334920, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449648823, 11807277, 1334941, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449642972, 11807277, 1334928, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449633616, 11807277, 1334908, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449635088, 11807277, 1334911, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449643910, 11807277, 1334930, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449645284, 11807277, 1334933, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449645733, 11807277, 1334934, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449637977, 11807277, 1334917, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449639663, 11807277, 1334921, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449641566, 11807277, 1334925, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449635574, 11807277, 1334912, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449649261, 11807277, 1334942, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449640615, 11807277, 1334923, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449637501, 11807277, 1334916, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449641087, 11807277, 1334924, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449655972, 11807277, 1334960, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449647073, 11807277, 1334937, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449652478, 11807277, 1334950, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449638234, 11807277, 1334918, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449653213, 11807277, 1334952, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449642035, 11807277, 1334926, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449652849, 11807277, 1334951, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449652102, 11807277, 1334949, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449650110, 11807277, 1334944, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449644372, 11807277, 1334931, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449644832, 11807277, 1334932, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449653572, 11807277, 1334953, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449650921, 11807277, 1334946, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449651714, 11807277, 1334948, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449653922, 11807277, 1334954, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449637025, 11807277, 1334915, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449654619, 11807277, 1334956, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449657571, 11807277, 1334965, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449634597, 11807277, 1334910, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449656294, 11807277, 1334961, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449655639, 11807277, 1334959, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449649691, 11807277, 1334943, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449636056, 11807277, 1334913, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449636543, 11807277, 1334914, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449656930, 11807277, 1334963, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449638707, 11807277, 1334919, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449640138, 11807277, 1334922, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449655302, 11807277, 1334958, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449642502, 11807277, 1334927, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449643441, 11807277, 1334929, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449650520, 11807277, 1334945, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449646183, 11807277, 1334935, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449646632, 11807277, 1334936, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449654963, 11807277, 1334957, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449647513, 11807277, 1334938, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449647796, 11807277, 1334939, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449648388, 11807277, 1334940, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449651323, 11807277, 1334947, 9.997290, -84.214540, '3029', 0, 340, 2936),
(449654278, 11807369, 1334955, 38.289950, 24.606090, '14923', 297, 11, 0),
(449641576, 11807369, 1334925, 35.337590, 25.175460, '120', 0, 273, 177),
(449645742, 11807369, 1334934, 35.360270, 25.130680, '2231', 151, 358, 0),
(449644840, 11807369, 1334932, 35.339090, 25.189940, '120', 0, 275, 157),
(449645291, 11807369, 1334933, 35.339090, 25.189910, '120', 0, 275, 157),
(449639189, 11807369, 1334920, 35.337590, 25.175450, '120', 0, 273, 177),
(449639671, 11807369, 1334921, 35.337590, 25.175450, '120', 0, 273, 177),
(449657579, 11807369, 1334965, 39.855730, 25.160180, '1280', 142, 42, 0),
(449649270, 11807369, 1334942, 36.313350, 24.727480, '15013', 275, 331, 0),
(449655980, 11807369, 1334960, 39.234880, 24.959360, '11004', 259, 9, 0),
(449641097, 11807369, 1334924, 35.337590, 25.175460, '120', 0, 273, 177),
(449650930, 11807369, 1334946, 36.919330, 24.472870, '14952', 279, 341, 0),
(449638243, 11807369, 1334918, 35.337590, 25.175450, '120', 0, 273, 177),
(449647082, 11807369, 1334937, 35.641600, 25.045710, '10553', 186, 333, 0),
(449653221, 11807369, 1334952, 37.818880, 24.415470, '14982', 296, 13, 0),
(449642045, 11807369, 1334926, 35.337590, 25.175450, '120', 0, 273, 177),
(449652857, 11807369, 1334951, 37.662920, 24.345030, '14981', 296, 13, 118),
(449637986, 11807369, 1334917, 35.337590, 25.175450, '120', 0, 273, 177),
(449652110, 11807369, 1334949, 37.368810, 24.349790, '14921', 280, 341, 0),
(449642983, 11807369, 1334928, 35.337590, 25.175430, '120', 0, 272, 177),
(449640623, 11807369, 1334923, 35.337590, 25.175460, '120', 0, 273, 177),
(449653580, 11807369, 1334953, 37.973340, 24.485320, '14974', 296, 13, 59),
(449644381, 11807369, 1334931, 35.338150, 25.189040, '120', 0, 85, 157),
(449655647, 11807369, 1334959, 39.077120, 24.907080, '14268', 278, 12, 0),
(449649700, 11807369, 1334943, 36.469970, 24.652820, '14978', 277, 332, 0),
(449656302, 11807369, 1334961, 39.480450, 25.040410, '7921', 208, 12, 0),
(449652486, 11807369, 1334950, 37.514080, 24.309760, '14921', 280, 341, 0),
(449656938, 11807369, 1334963, 39.714570, 25.114180, '4043', 235, 345, 0),
(449651722, 11807369, 1334948, 37.190630, 24.398690, '14923', 280, 341, 0),
(449655309, 11807369, 1334958, 38.780820, 24.793000, '14863', 299, 13, 0),
(449638715, 11807369, 1334919, 35.337590, 25.175450, '120', 0, 273, 177),
(449648832, 11807369, 1334941, 36.073130, 24.841640, '15012', 236, 330, 0),
(449643919, 11807369, 1334930, 35.338310, 25.186570, '120', 21, 94, 157),
(449653928, 11807369, 1334954, 38.131540, 24.546410, '14951', 297, 10, 1161),
(449640146, 11807369, 1334922, 35.337590, 25.175460, '120', 0, 273, 177),
(449654625, 11807369, 1334956, 38.455470, 24.668800, '14908', 298, 12, 0),
(449650119, 11807369, 1334944, 36.594490, 24.593150, '14980', 274, 332, 0),
(449642513, 11807369, 1334927, 35.337590, 25.175430, '120', 0, 272, 177),
(449643450, 11807369, 1334929, 35.338980, 25.175140, '120', 14, 50, 177),
(449646192, 11807369, 1334935, 35.452640, 25.131010, '5691', 170, 344, 0),
(449646641, 11807369, 1334936, 35.546430, 25.091170, '8306', 180, 333, 0),
(449654970, 11807369, 1334957, 38.614360, 24.729300, '14863', 299, 13, 0),
(449657256, 11807369, 1334964, 39.806680, 25.101690, '2189', 140, 43, 0);
INSERT INTO `position` (`pid`, `fid`, `updateid`, `lat`, `lon`, `alt`, `gs`, `hdg`, `groundelev`) VALUES
(449647522, 11807369, 1334938, 35.742380, 24.997700, '12546', 190, 331, 0),
(449647812, 11807369, 1334939, 35.842990, 24.950370, '14024', 195, 330, 0),
(449648396, 11807369, 1334940, 35.948280, 24.900480, '15097', 222, 330, 0),
(449650529, 11807369, 1334945, 36.749120, 24.521130, '14977', 277, 337, 636),
(449651331, 11807369, 1334947, 37.051960, 24.436740, '14951', 279, 341, 0),
(449656620, 11807369, 1334962, 39.609600, 25.084400, '7361', 226, 12, 0),
(449654200, 11807606, 1334954, 48.634630, 10.729060, '28891', 414, 131, 1332),
(449653849, 11807606, 1334953, 48.793330, 10.475370, '28925', 414, 131, 1516),
(449648307, 11807606, 1334939, 50.049800, 8.600010, '373', 0, 338, 354),
(449648742, 11807606, 1334940, 50.049800, 8.600010, '373', 0, 338, 354),
(449649180, 11807606, 1334941, 50.049800, 8.600010, '373', 0, 338, 354),
(449649611, 11807606, 1334942, 50.049570, 8.600480, '373', 0, 249, 354),
(449650034, 11807606, 1334943, 50.047900, 8.590260, '373', 25, 249, 354),
(449650446, 11807606, 1334944, 50.038800, 8.560500, '736', 151, 249, 344),
(449650847, 11807606, 1334945, 49.886740, 8.547130, '5195', 350, 114, 305),
(449651247, 11807606, 1334946, 49.845360, 8.836560, '13078', 331, 111, 545),
(449651639, 11807606, 1334947, 49.765730, 9.079530, '18101', 358, 115, 978),
(449652026, 11807606, 1334948, 49.669600, 9.325140, '22286', 384, 129, 1270),
(449652402, 11807606, 1334949, 49.462050, 9.557490, '26574', 412, 147, 1115),
(449652773, 11807606, 1334950, 49.282990, 9.752820, '28920', 415, 132, 1345),
(449653138, 11807606, 1334951, 49.126410, 9.992600, '28976', 414, 132, 1499),
(449653497, 11807606, 1334952, 48.959590, 10.235460, '28956', 415, 134, 1644),
(449654547, 11807606, 1334955, 48.476710, 10.978350, '28891', 414, 131, 1608),
(449654894, 11807606, 1334956, 48.309110, 11.240350, '28942', 414, 131, 1673),
(449655233, 11807606, 1334957, 48.142750, 11.474140, '28997', 413, 136, 1726),
(449655569, 11807606, 1334958, 47.962780, 11.714590, '26959', 419, 136, 2028),
(449655903, 11807606, 1334959, 47.580040, 11.855510, '17584', 324, 156, 3281),
(449656226, 11807606, 1334960, 47.420740, 11.865020, '10329', 247, 241, 1657),
(449656547, 11807606, 1334961, 47.273790, 11.603720, '6099', 203, 241, 2762),
(449656865, 11807606, 1334962, 47.269850, 11.424500, '3340', 173, 266, 1850),
(449657183, 11807606, 1334963, 47.259460, 11.338120, '1909', 37, 260, 2083),
(449657504, 11807606, 1334964, 47.258330, 11.346350, '1909', 27, 78, 1867),
(449652221, 11807610, 1334949, 50.091900, 3.914870, '18199', 361, 175, 617),
(449649831, 11807610, 1334943, 50.911340, 4.499400, '195', 8, 343, 108),
(449655743, 11807610, 1334959, 48.994480, 2.242350, '2989', 184, 112, 187),
(449653685, 11807610, 1334953, 49.494520, 3.590350, '14304', 318, 252, 361),
(449654032, 11807610, 1334954, 49.441740, 3.337580, '14198', 318, 252, 479),
(449656395, 11807610, 1334961, 49.024110, 2.550440, '401', 19, 168, 377),
(449655407, 11807610, 1334958, 49.157050, 2.419610, '8422', 292, 219, 105),
(449648532, 11807610, 1334940, 50.903800, 4.487020, '195', 0, 156, 128),
(449648970, 11807610, 1334941, 50.903800, 4.487020, '195', 0, 156, 128),
(449649402, 11807610, 1334942, 50.905600, 4.489500, '195', 20, 65, 128),
(449650247, 11807610, 1334944, 50.900280, 4.460510, '1376', 212, 246, 115),
(449650655, 11807610, 1334945, 50.782220, 4.275520, '14427', 330, 219, 89),
(449651056, 11807610, 1334946, 50.644410, 4.009630, '18172', 358, 232, 256),
(449651456, 11807610, 1334947, 50.497410, 3.869760, '18203', 378, 162, 240),
(449651841, 11807610, 1334948, 50.320480, 3.896740, '18194', 357, 179, 499),
(449652594, 11807610, 1334950, 49.903020, 3.947090, '18197', 355, 172, 643),
(449652963, 11807610, 1334951, 49.706510, 3.979980, '18197', 355, 173, 358),
(449653326, 11807610, 1334952, 49.556440, 3.848580, '16936', 332, 240, 295),
(449654380, 11807610, 1334955, 49.363170, 3.082010, '14197', 318, 242, 289),
(449654724, 11807610, 1334956, 49.282900, 2.855870, '14189', 267, 241, 404),
(449655069, 11807610, 1334957, 49.208410, 2.648230, '14197', 267, 241, 285),
(449656072, 11807610, 1334960, 49.017820, 2.392200, '2108', 148, 80, 322),
(449656713, 11807610, 1334962, 49.016620, 2.544370, '401', 7, 221, 348),
(449657032, 11807610, 1334963, 49.016590, 2.544330, '401', 0, 222, 348),
(449657353, 11807610, 1334964, 49.016590, 2.544330, '401', 0, 222, 348),
(449649894, 11807621, 1334943, 28.436880, -81.314160, '108', 4, 337, 89),
(449653736, 11807621, 1334953, 26.628020, -81.195990, '17970', 730, 170, 23),
(449654084, 11807621, 1334954, 26.213270, -81.124860, '17970', 724, 170, 16),
(449656442, 11807621, 1334961, 25.786940, -80.296850, '20', 8, 277, 13),
(449655460, 11807621, 1334958, 25.669280, -80.514920, '13028', 344, 74, 10),
(449649037, 11807621, 1334941, 28.435860, -81.312830, '108', 0, 142, 89),
(449649467, 11807621, 1334942, 28.436220, -81.313140, '108', 2, 142, 89),
(449650307, 11807621, 1334944, 28.441590, -81.319080, '108', 36, 354, 82),
(449650714, 11807621, 1334945, 28.448090, -81.321060, '108', 1, 270, 92),
(449651115, 11807621, 1334946, 28.429460, -81.322080, '421', 213, 178, 89),
(449651513, 11807621, 1334947, 28.407470, -81.225570, '8468', 301, 23, 82),
(449651900, 11807621, 1334948, 28.475470, -81.357940, '14194', 392, 233, 79),
(449652278, 11807621, 1334949, 28.182310, -81.327750, '17402', 652, 178, 52),
(449652651, 11807621, 1334950, 27.820480, -81.288800, '17988', 701, 176, 69),
(449653016, 11807621, 1334951, 27.433930, -81.264130, '17973', 740, 176, 36),
(449653379, 11807621, 1334952, 27.021090, -81.238040, '17972', 744, 176, 30),
(449654431, 11807621, 1334955, 25.813700, -81.055260, '17971', 731, 170, 10),