-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathresttest.sql
10428 lines (10407 loc) · 786 KB
/
resttest.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
-- phpMyAdmin SQL Dump
-- version 3.5.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 05, 2014 at 01:23 AM
-- Server version: 5.5.29
-- PHP Version: 5.4.10
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 */;
--
-- Database: `resttest`
--
-- --------------------------------------------------------
--
-- Table structure for table `cities`
--
CREATE TABLE `cities` (
`id` int(255) NOT NULL,
`name` varchar(255) NOT NULL,
`state` varchar(2) NOT NULL,
`status` varchar(255) NOT NULL,
`latitude` decimal(17,14) NOT NULL,
`longitude` decimal(17,14) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cities`
--
INSERT INTO `cities` (`id`, `name`, `state`, `status`, `latitude`, `longitude`) VALUES
(1, 'Akron', 'AL', 'verified', 32.87802124023438, -87.74398803710938),
(2, 'Huntsville', 'AL', 'verified', 34.72913360595703, -86.58497619628906),
(3, 'Addison', 'AL', 'verified', 34.20217514038086, -87.18138122558594),
(4, 'Montgomery', 'AL', 'verified', 32.38011932373047, -86.30062866210938),
(5, 'Birmingham', 'AL', 'verified', 33.52029418945313, -86.81150054931640),
(6, 'Somerville', 'AL', 'verified', 34.47115325927734, -86.79939270019531),
(7, 'Albertville', 'AL', 'verified', 34.26951599121094, -86.20794677734375),
(8, 'Alexander City', 'AL', 'verified', 32.93884658813477, -85.95294952392578),
(9, 'Alexandria', 'AL', 'verified', 33.76697921752930, -85.89234924316406),
(10, 'Aliceville', 'AL', 'verified', 33.12942886352539, -88.15310668945312),
(11, 'Irvington', 'AL', 'verified', 30.51497268676758, -88.22212219238281),
(12, 'Andalusia', 'AL', 'verified', 31.31959915161133, -86.49542236328125),
(13, 'Anniston', 'AL', 'verified', 33.65710830688477, -85.81945037841797),
(14, 'Oneonta', 'AL', 'verified', 33.94831466674805, -86.47293853759766),
(15, 'Arab', 'AL', 'verified', 34.32287597656250, -86.49535369873047),
(16, 'Ashford', 'AL', 'verified', 31.18766593933106, -85.23482513427734),
(17, 'Ashville', 'AL', 'verified', 33.83650970458984, -86.25474548339844),
(18, 'Athens', 'AL', 'verified', 34.80450057983398, -86.97127532958984),
(19, 'Auburn', 'AL', 'verified', 32.60746383666992, -85.48173522949219),
(20, 'Prattville', 'AL', 'verified', 32.46185684204102, -86.45075225830078),
(21, 'Decatur', 'AL', 'verified', 34.60738754272461, -86.97976684570312),
(22, 'Mobile', 'AL', 'verified', 30.68639564514160, -88.05323791503906),
(23, 'Bay Minette', 'AL', 'verified', 30.88290405273438, -87.77356719970703),
(24, 'Clayton', 'AL', 'verified', 31.87877464294434, -85.44964599609375),
(25, 'Opelika', 'AL', 'verified', 32.65050125122070, -85.38064575195312),
(26, 'Berry', 'AL', 'verified', 33.66034317016602, -87.60008239746094),
(27, 'Valley', 'AL', 'verified', 32.84396362304688, -85.18093109130860),
(28, 'West Blocton', 'AL', 'verified', 33.11537551879883, -87.11899566650390),
(29, 'Centreville', 'AL', 'verified', 32.94488143920898, -87.13471221923828),
(30, 'Cleveland', 'AL', 'verified', 33.99151611328125, -86.57704925537110),
(31, 'Eight Mile', 'AL', 'verified', 30.77528190612793, -88.17752838134766),
(32, 'Boaz', 'AL', 'verified', 34.19763183593750, -86.16559600830078),
(33, 'Madison', 'AL', 'verified', 34.70588684082031, -86.75095367431640),
(34, 'Tuskegee', 'AL', 'verified', 32.42405319213867, -85.68978118896484),
(35, 'Florence', 'AL', 'verified', 34.80046463012695, -87.67525482177734),
(36, 'Brantley', 'AL', 'verified', 31.58242988586426, -86.25688171386719),
(37, 'Sylacauga', 'AL', 'verified', 33.17156600952148, -86.25025177001953),
(38, 'Killen', 'AL', 'verified', 34.85923004150391, -87.52957153320312),
(39, 'Brookwood', 'AL', 'verified', 33.25431823730469, -87.32672119140625),
(40, 'New Market', 'AL', 'verified', 34.90946578979492, -86.42778778076172),
(41, 'Union Springs', 'AL', 'verified', 32.14614486694336, -85.71267700195312),
(42, 'Hunstville', 'AL', 'verified', 32.61436080932617, -86.68074035644531),
(43, 'Letohatchee', 'AL', 'verified', 32.05220413208008, -86.54733276367188),
(44, 'Carbon Hill', 'AL', 'verified', 33.88848114013672, -87.52889251708984),
(45, 'Ozark', 'AL', 'verified', 31.45895576477051, -85.64071655273438),
(46, 'Cedar Bluff', 'AL', 'verified', 34.21765518188477, -85.60771179199219),
(47, 'Tuscaloosa', 'AL', 'verified', 33.21043395996094, -87.56621551513672),
(48, 'Rockford', 'AL', 'verified', 32.88993835449219, -86.21916961669922),
(49, 'Phenix City', 'AL', 'verified', 32.46763992309570, -85.00082397460938),
(50, 'Troy', 'AL', 'verified', 31.80967521667481, -85.97217559814453),
(51, 'Centre', 'AL', 'verified', 34.15218734741211, -85.67968750000000),
(52, 'Cherokee', 'AL', 'verified', 34.75548171997070, -87.97340393066406),
(53, 'Childersburg', 'AL', 'verified', 33.27673721313477, -86.36067199707031),
(54, 'Clanton', 'AL', 'verified', 32.84056854248047, -86.63186645507812),
(55, 'Butler', 'AL', 'verified', 32.08935546875000, -88.22127532958984),
(56, 'Citronelle', 'AL', 'verified', 31.09272384643555, -88.23812866210938),
(57, 'Grove Hill', 'AL', 'verified', 31.70933914184570, -87.77664184570312),
(58, 'CPinson', 'AL', 'verified', 32.61436080932617, -86.68074035644531),
(59, 'Ashland', 'AL', 'verified', 33.27431106567383, -85.83546447753906),
(60, 'Coffeeville', 'AL', 'verified', 31.75695991516113, -88.09113311767578),
(61, 'Leighton', 'AL', 'verified', 34.69780731201172, -87.52899169921875),
(62, 'Tuscumbia', 'AL', 'verified', 34.73128509521484, -87.70284271240234),
(63, 'Bremen', 'AL', 'verified', 33.96966552734375, -86.99086761474610),
(64, 'Cordova', 'AL', 'verified', 33.75491333007813, -87.18219757080078),
(65, 'Courtland', 'AL', 'verified', 34.66907501220703, -87.30847167968750),
(66, 'Cullman', 'AL', 'verified', 34.17437362670898, -86.84345245361328),
(67, 'Jasper', 'AL', 'verified', 33.83127975463867, -87.28137207031250),
(68, 'Dadeville', 'AL', 'verified', 32.82884979248047, -85.76454925537110),
(69, 'Daleville', 'AL', 'verified', 31.30706024169922, -85.71391296386719),
(70, 'Plantersville', 'AL', 'verified', 32.65961456298828, -86.92366027832031),
(71, 'Danville', 'AL', 'verified', 34.41476440429688, -87.08690643310547),
(72, 'Daphne', 'AL', 'verified', 30.60390472412109, -87.90151214599610),
(73, 'Verbena', 'AL', 'verified', 32.75364685058594, -86.51074218750000),
(74, 'Rainsville', 'AL', 'verified', 34.49528503417969, -85.84646606445312),
(75, 'Demopolis', 'AL', 'verified', 32.50476455688477, -87.83785247802734),
(76, 'Drdora', 'AL', 'verified', 32.61436080932617, -86.68074035644531),
(77, 'Dothan', 'AL', 'verified', 31.22323989868164, -85.39332580566406),
(78, 'Douglas', 'AL', 'verified', 34.17511367797852, -86.32109832763672),
(79, 'Elba', 'AL', 'verified', 31.41459083557129, -86.06735992431640),
(80, 'Gadsden', 'AL', 'verified', 34.01477050781250, -86.00717163085938),
(81, 'Eclectic', 'AL', 'verified', 32.63599014282227, -86.03462982177734),
(82, 'Enterprise', 'AL', 'verified', 31.31521415710449, -85.85467529296875),
(83, 'Attalla', 'AL', 'verified', 34.02144622802734, -86.08892059326172),
(84, 'Fairfield', 'AL', 'verified', 33.49061203002930, -86.91566467285156),
(85, 'Fairhope', 'AL', 'verified', 30.53635406494141, -87.88619995117188),
(86, 'Falkville', 'AL', 'verified', 34.36883163452148, -86.90722656250000),
(87, 'Prichard', 'AL', 'verified', 30.73797035217285, -88.08126068115234),
(88, 'Fayette', 'AL', 'verified', 33.68511581420898, -87.82897949218750),
(89, 'Florala', 'AL', 'verified', 31.01897430419922, -86.32664489746094),
(90, 'Foley', 'AL', 'verified', 30.40584945678711, -87.68379974365234),
(91, 'Greenville', 'AL', 'verified', 31.82944679260254, -86.63349151611328),
(92, 'Fort Payne', 'AL', 'verified', 34.44131851196289, -85.71437835693360),
(93, 'Russellville', 'AL', 'verified', 34.50743103027344, -87.72840881347656),
(94, 'Frisco City', 'AL', 'verified', 31.43425941467285, -87.39948272705078),
(95, 'Gardendale', 'AL', 'verified', 33.65116119384766, -86.81139373779297),
(96, 'Gaylesville', 'AL', 'verified', 34.26609039306641, -85.56026458740234),
(97, 'Hartford', 'AL', 'verified', 31.10224914550781, -85.69605255126953),
(98, 'Geneva', 'AL', 'verified', 31.04214859008789, -85.86701965332031),
(99, 'Skipperville', 'AL', 'verified', 31.56493186950684, -85.53166961669922),
(100, 'Glencoe', 'AL', 'verified', 33.95970535278320, -85.93445587158203),
(101, 'Gordo', 'AL', 'verified', 33.31878280639648, -87.90764617919922),
(102, 'Eutaw', 'AL', 'verified', 32.84059143066406, -87.88784027099610),
(103, 'Gulf Shores', 'AL', 'verified', 30.27732086181641, -87.68309020996094),
(104, 'Guntersville', 'AL', 'verified', 34.35113143920898, -86.29915618896484),
(105, 'Moundville', 'AL', 'verified', 32.99864959716797, -87.62227630615234),
(106, 'Haleyville', 'AL', 'verified', 34.22742462158203, -87.62143707275390),
(107, 'Hanceville', 'AL', 'verified', 34.06171035766602, -86.76950836181640),
(108, 'Roanoke', 'AL', 'verified', 33.15229034423828, -85.37529754638672),
(109, 'Hartselle', 'AL', 'verified', 34.44476318359375, -86.93524932861328),
(110, 'Town Creek', 'AL', 'verified', 34.68125915527344, -87.40748596191406),
(111, 'Hayden', 'AL', 'verified', 33.89269638061523, -86.75186920166016),
(112, 'Hazel Green', 'AL', 'verified', 34.92878341674805, -86.57184600830078),
(113, 'Headland', 'AL', 'verified', 31.35147285461426, -85.34242248535156),
(114, 'Trussville', 'AL', 'verified', 33.62138366699219, -86.60273742675781),
(115, 'Hokes Bluff', 'AL', 'verified', 33.98722839355469, -85.88375091552734),
(116, 'Holly Pond', 'AL', 'verified', 34.17431640625000, -86.61787414550781),
(117, 'Deatsville', 'AL', 'verified', 32.60942077636719, -86.39801788330078),
(118, 'Homewood', 'AL', 'verified', 33.47877502441406, -86.78967285156250),
(119, 'Columbia', 'AL', 'verified', 31.29276466369629, -85.11100769042969),
(120, 'Hueytown', 'AL', 'verified', 33.44280242919922, -86.99460601806640),
(121, 'Blountsville', 'AL', 'verified', 34.08661651611328, -86.58949279785156),
(122, 'Beatrice', 'AL', 'verified', 31.73187065124512, -87.20857238769531),
(123, 'Jackson', 'AL', 'verified', 31.50834083557129, -87.89501190185547),
(124, 'Jacksonville', 'AL', 'verified', 33.81422042846680, -85.76118469238281),
(125, 'Irondale', 'AL', 'verified', 33.53794097900391, -86.70671844482422),
(126, 'Jemison', 'AL', 'verified', 32.96035766601563, -86.74410247802734),
(127, 'Bessemer', 'AL', 'verified', 33.40203094482422, -86.95399475097656),
(128, 'Selma', 'AL', 'verified', 32.41178894042969, -87.02223205566406),
(129, 'Grant', 'AL', 'verified', 34.52619171142578, -86.25279998779297),
(130, 'Orrville', 'AL', 'verified', 32.30662155151367, -87.24693298339844),
(131, 'Carrollton', 'AL', 'verified', 33.26200485229492, -88.09446716308594),
(132, 'Lafayette', 'AL', 'verified', 32.89942169189453, -85.40123748779297),
(133, 'Vernon', 'AL', 'verified', 33.75854873657227, -88.10890197753906),
(134, 'Lanett', 'AL', 'verified', 32.87133789062500, -85.18611145019531),
(135, 'Moulton', 'AL', 'verified', 34.48111343383789, -87.29241180419922),
(136, 'Leeds', 'AL', 'verified', 33.54246902465820, -86.54081726074219),
(137, 'Lincoln', 'AL', 'verified', 33.60386657714844, -86.11952972412110),
(138, 'Linden', 'AL', 'verified', 32.30669403076172, -87.79796600341797),
(139, 'Lineville', 'AL', 'verified', 33.31061553955078, -85.75350189208984),
(140, 'Livingston', 'AL', 'verified', 32.58378601074219, -88.18687438964844),
(141, 'Loachapoka', 'AL', 'verified', 32.60434341430664, -85.59957885742188),
(142, 'Locust Fork', 'AL', 'verified', 33.90843582153320, -86.61601257324219),
(143, 'Hayneville', 'AL', 'verified', 32.18402862548828, -86.58038330078125),
(144, 'Lynn', 'AL', 'verified', 34.04676055908203, -87.54977416992188),
(145, 'Gurley', 'AL', 'verified', 34.69607543945313, -86.37628936767578),
(146, 'Marbury', 'AL', 'verified', 32.70058822631836, -86.46572875976562),
(147, 'Guin', 'AL', 'verified', 33.96564865112305, -87.91411590576172),
(148, 'Marion', 'AL', 'verified', 32.63463211059570, -87.31912994384766),
(149, 'Semmes', 'AL', 'verified', 30.77885437011719, -88.25884246826172),
(150, 'Arley', 'AL', 'verified', 34.07880783081055, -87.21240997314453),
(151, 'Midfield', 'AL', 'verified', 33.46678543090820, -86.90789794921875),
(152, 'Adamsville', 'AL', 'verified', 33.60055541992188, -86.95372009277344),
(153, 'Monroeville', 'AL', 'verified', 31.52731513977051, -87.32386779785156),
(154, 'Montevallo', 'AL', 'verified', 33.10061645507813, -86.86259460449219),
(155, 'Ramer', 'AL', 'verified', 32.05044174194336, -86.22106170654297),
(156, 'Moody', 'AL', 'verified', 33.59153366088867, -86.49481964111328),
(157, 'Morris', 'AL', 'verified', 33.74721145629883, -86.80886077880860),
(158, 'Mountain Brook', 'AL', 'verified', 33.50211334228516, -86.75550842285156),
(159, 'Munford', 'AL', 'verified', 33.52666473388672, -85.95352935791016),
(160, 'Muscle Shoals', 'AL', 'verified', 34.74243545532227, -87.66770935058594),
(161, 'New Brockton', 'AL', 'verified', 31.38565444946289, -85.92913818359375),
(162, 'New Hope', 'AL', 'verified', 34.53873062133789, -86.39521789550781),
(163, 'Stevenson', 'AL', 'verified', 34.86819076538086, -85.83801269531250),
(164, 'Northport', 'AL', 'verified', 33.24023818969727, -87.59152221679688),
(165, 'Oakman', 'AL', 'verified', 33.71368026733398, -87.38899230957031),
(166, 'Ohatchee', 'AL', 'verified', 33.78430175781250, -86.01842498779297),
(167, 'Ensley', 'AL', 'verified', 33.50951004028320, -86.88730621337890),
(168, 'Opp', 'AL', 'verified', 31.28679466247559, -86.25560760498047),
(169, 'Oxford', 'AL', 'verified', 33.61307525634766, -85.83570098876953),
(170, 'Parrish', 'AL', 'verified', 33.72664642333984, -87.28785705566406),
(171, 'Cottondale', 'AL', 'verified', 33.19016647338867, -87.44408416748047),
(172, 'Pelham', 'AL', 'verified', 33.28468704223633, -86.81022644042969),
(173, 'Pell City', 'AL', 'verified', 33.58608627319336, -86.28641510009766),
(174, 'Bear Creek', 'AL', 'verified', 34.27453613281250, -87.70060729980469),
(175, 'Reform', 'AL', 'verified', 33.37821960449219, -88.01348876953125),
(176, 'Piedmont', 'AL', 'verified', 33.92200088500977, -85.61351776123047),
(177, 'Brundidge', 'AL', 'verified', 31.72019958496094, -85.81677246093750),
(178, 'Pinson', 'AL', 'verified', 33.69121170043945, -86.68235778808594),
(179, 'Alpine', 'AL', 'verified', 33.34952545166016, -86.23610687255860),
(180, 'Pleasant Grove', 'AL', 'verified', 33.49085998535156, -86.97071075439453),
(181, 'Ranburne', 'AL', 'verified', 33.52232742309570, -85.34480285644531),
(182, 'Wedowee', 'AL', 'verified', 33.30921936035156, -85.48549652099610),
(183, 'Uniontown', 'AL', 'verified', 32.44947814941406, -87.51346588134766),
(184, 'Robertsdale', 'AL', 'verified', 30.55384063720703, -87.71017456054688),
(185, 'Seale', 'AL', 'verified', 32.31485748291016, -85.17709350585938),
(186, 'Samson', 'AL', 'verified', 31.11297035217285, -86.04529571533203),
(187, 'Sand Rock', 'AL', 'verified', 34.24237060546875, -85.75862121582031),
(188, 'Satsuma', 'AL', 'verified', 30.85240936279297, -88.05713653564453),
(189, 'Columbiana', 'AL', 'verified', 33.17789840698242, -86.60712432861328),
(190, 'Scottsboro', 'AL', 'verified', 34.68139266967773, -86.07931518554688),
(191, 'Sheffield', 'AL', 'verified', 34.75961685180664, -87.68702697753906),
(192, 'Alabaster', 'AL', 'verified', 33.24508666992188, -86.81622314453125),
(193, 'Slocomb', 'AL', 'verified', 31.10762023925781, -85.59298706054688),
(194, 'Smiths Station', 'AL', 'verified', 32.54085922241211, -85.08963012695312),
(195, 'Silas', 'AL', 'verified', 31.77032470703125, -88.32903289794922),
(196, 'Southside', 'AL', 'verified', 33.92641830444336, -86.02303314208984),
(197, 'Spanish Fort', 'AL', 'verified', 30.67512893676758, -87.87319183349610),
(198, 'Harvest', 'AL', 'verified', 34.85967636108398, -86.74927520751953),
(199, 'Spring Garden', 'AL', 'verified', 33.97288894653320, -85.55330657958984),
(200, 'Springville', 'AL', 'verified', 33.77239990234375, -86.47479248046875),
(201, 'Odenville', 'AL', 'verified', 33.68545913696289, -86.39459991455078),
(202, 'Millbrook', 'AL', 'verified', 32.48009109497070, -86.36215972900390),
(203, 'York', 'AL', 'verified', 32.48836517333984, -88.29884338378906),
(204, 'Talladega', 'AL', 'verified', 33.43450927734375, -86.10269165039062),
(205, 'Tallassee', 'AL', 'verified', 32.53602600097656, -85.89384460449219),
(206, 'Tarrant', 'AL', 'verified', 33.58458709716797, -86.77266693115234),
(207, 'Hillsboro', 'AL', 'verified', 34.63938903808594, -87.19107055664062),
(208, 'Theodore', 'AL', 'verified', 30.55433082580566, -88.17888641357422),
(209, 'Thomasville', 'AL', 'verified', 31.91363906860352, -87.74108123779297),
(210, 'Brewton', 'AL', 'verified', 31.10401344299316, -87.07205963134766),
(211, 'Vinemont', 'AL', 'verified', 34.24740219116211, -86.86954498291016),
(212, 'East Brewton', 'AL', 'verified', 31.08772468566895, -87.06018066406250),
(213, 'Weaver', 'AL', 'verified', 33.75093078613281, -85.81263732910156),
(214, 'Walnut Grove', 'AL', 'verified', 34.06753158569336, -86.30399322509766),
(215, 'Trinity', 'AL', 'verified', 34.60617065429688, -87.08797454833984),
(216, 'Camden', 'AL', 'verified', 31.99300193786621, -87.29048919677734),
(217, 'Winfield', 'AL', 'verified', 33.92858123779297, -87.81655883789062),
(218, 'Double Springs', 'AL', 'verified', 34.15031433105469, -87.39859008789062),
(219, 'Adak', 'AK', 'verified', 51.88000869750977, -176.65756225585938),
(220, 'Akhiok', 'AK', 'verified', 56.94559860229492, -154.16999816894530),
(221, 'Akiak', 'AK', 'verified', 60.90966033935547, -161.22344970703125),
(222, 'Kasigluk', 'AK', 'verified', 60.89527130126953, -162.51712036132812),
(223, 'Akutan', 'AK', 'verified', 54.13472366333008, -165.77055358886720),
(224, 'Wainwright', 'AK', 'verified', 70.64389801025390, -160.02378845214844),
(225, 'Alakanuk', 'AK', 'verified', 62.68715667724609, -164.66510009765625),
(226, 'Tok', 'AK', 'verified', 63.33567047119141, -142.98381042480470),
(227, 'Sand Point', 'AK', 'verified', 55.33700942993164, -160.49180603027344),
(228, 'Allakaket', 'AK', 'verified', 66.56403350830078, -152.65249633789062),
(229, 'Anchorage', 'AK', 'verified', 61.21754837036133, -149.85838317871094),
(230, 'Ambler', 'AK', 'verified', 67.08621215820312, -157.85700988769530),
(231, 'Anderson', 'AK', 'verified', 64.34358215332031, -149.17832946777344),
(232, 'St. Mary''s', 'AK', 'verified', 62.05032730102539, -163.17890930175780),
(233, 'Nulato', 'AK', 'verified', 64.73323822021484, -158.11474609375000),
(234, 'Angoon', 'AK', 'verified', 57.50214767456055, -134.58230590820312),
(235, 'Aniak', 'AK', 'verified', 61.58138656616211, -159.56800842285156),
(236, 'Elim', 'AK', 'verified', 64.61582946777344, -162.25607299804688),
(237, 'Nunapitchuk', 'AK', 'verified', 60.89705657958984, -162.45268249511720),
(238, 'St. Michael', 'AK', 'verified', 63.47347640991211, -162.05206298828125),
(239, 'Gambell', 'AK', 'verified', 63.77677917480469, -171.72613525390625),
(240, 'Noorvik', 'AK', 'verified', 66.83684539794922, -161.04092407226562),
(241, 'Platinum', 'AK', 'verified', 58.92160797119141, -161.72746276855470),
(242, 'Newtok', 'AK', 'verified', 60.94134902954102, -164.63050842285156),
(243, 'Beaver', 'AK', 'verified', 66.35902404785156, -147.39578247070312),
(244, 'Eielson AFB', 'AK', 'verified', 64.69052886962890, -147.10176086425780),
(245, 'Palmer', 'AK', 'verified', 61.59944152832031, -149.11737060546875),
(246, 'Bethel', 'AK', 'verified', 60.79429244995117, -161.76087951660156),
(247, 'Brevig Mission', 'AK', 'verified', 65.33196258544922, -166.48533630371094),
(248, 'Naknek', 'AK', 'verified', 58.72851181030273, -157.01356506347656),
(249, 'Buckland', 'AK', 'verified', 65.97855377197266, -161.12368774414062),
(250, 'Cantwell', 'AK', 'verified', 63.39229202270508, -148.94952392578125),
(251, 'Chefornak', 'AK', 'verified', 60.15777969360352, -164.27485656738280),
(252, 'Chenega Bay', 'AK', 'verified', 60.54970932006836, -145.75032043457030),
(253, 'Chevak', 'AK', 'verified', 61.52801132202148, -165.58061218261720),
(254, 'New Stuyahok', 'AK', 'verified', 59.45128631591797, -157.31694030761720),
(255, 'Kipnuk', 'AK', 'verified', 59.93708038330078, -164.04139709472656),
(256, 'Chignik Bay', 'AK', 'verified', 56.29859924316406, -158.41772460937500),
(257, 'Chignik Lagoon', 'AK', 'verified', 56.30487823486328, -158.49678039550780),
(258, 'Chignik Lake', 'AK', 'verified', 56.25501251220703, -158.76191711425780),
(259, 'Cold Bay', 'AK', 'verified', 55.20811843872070, -162.71119689941406),
(260, 'Cordova', 'AK', 'verified', 60.54140090942383, -145.74937438964844),
(261, 'Craig', 'AK', 'verified', 55.47502517700195, -133.15057373046875),
(262, 'Chuathbaluk', 'AK', 'verified', 61.57685852050781, -159.24426269531250),
(263, 'Grayling', 'AK', 'verified', 62.90531539916992, -160.06651306152344),
(264, 'Selawik', 'AK', 'verified', 66.60009765625000, -160.01097106933594),
(265, 'Deering', 'AK', 'verified', 66.07611846923828, -162.72003173828125),
(266, 'Delta Junction', 'AK', 'verified', 64.04660797119140, -145.73593139648438),
(267, 'Pedro Bay', 'AK', 'verified', 59.78676986694336, -154.10527038574220),
(268, 'Kongiganak', 'AK', 'verified', 59.95389938354492, -162.89500427246094),
(269, 'Dillingham', 'AK', 'verified', 59.03979492187500, -158.46238708496094),
(270, 'Diomede', 'AK', 'verified', 65.75700378417969, -168.94999694824220),
(271, 'Dot Lake', 'AK', 'verified', 63.66117858886719, -144.06373596191406),
(272, 'Eagle', 'AK', 'verified', 64.78768157958984, -141.20260620117188),
(273, 'Egegik', 'AK', 'verified', 58.21781921386719, -157.35514831542970),
(274, 'Emmonak', 'AK', 'verified', 62.77651596069336, -164.54934692382812),
(275, 'Fairbanks', 'AK', 'verified', 64.84508514404297, -147.72206115722656),
(276, 'False Pass', 'AK', 'verified', 54.85147857666016, -163.41282653808594),
(277, 'Central', 'AK', 'verified', 65.57208251953125, -144.80354309082030),
(278, 'Fort Yukon', 'AK', 'verified', 66.56370544433594, -145.24102783203125),
(279, 'Unalakleet', 'AK', 'verified', 63.87847518920898, -160.79306030273438),
(280, 'Galena', 'AK', 'verified', 64.73424530029297, -156.93316650390625),
(281, 'Upper Kalskag', 'AK', 'verified', 61.53815078735352, -160.31402587890625),
(282, 'Red Devil', 'AK', 'verified', 61.76454162597656, -157.31246948242188),
(283, 'Valdez', 'AK', 'verified', 61.13038635253906, -146.35411071777344),
(284, 'Manley Hot Springs', 'AK', 'verified', 64.98116302490234, -150.63731384277344),
(285, 'Glennallen', 'AK', 'verified', 62.10794448852539, -145.53318786621094),
(286, 'Gustavus', 'AK', 'verified', 58.41263961791992, -135.73300170898438),
(287, 'Haines', 'AK', 'verified', 59.23482894897461, -135.44305419921875),
(288, 'Kaktovik', 'AK', 'verified', 70.13362121582031, -143.61251831054688),
(289, 'Savoonga', 'AK', 'verified', 63.69509124755859, -170.46527099609375),
(290, 'Hollis', 'AK', 'verified', 55.56492996215820, -132.62397766113280),
(291, 'Homer', 'AK', 'verified', 59.64656066894531, -151.54423522949220),
(292, 'Hoonah', 'AK', 'verified', 58.10811233520508, -135.43769836425780),
(293, 'Hooper Bay', 'AK', 'verified', 61.53170394897461, -166.09809875488280),
(294, 'Hope', 'AK', 'verified', 60.91939926147461, -149.64077758789062),
(295, 'Big Lake', 'AK', 'verified', 61.51272964477539, -149.95443725585938),
(296, 'Coffman Cove', 'AK', 'verified', 56.01397705078125, -132.82629394531250),
(297, 'Hydaburg', 'AK', 'verified', 55.20497131347656, -132.82202148437500),
(298, 'Hyder', 'AK', 'verified', 55.91470336914063, -130.02804565429688),
(299, 'Yakutat', 'AK', 'verified', 59.55078887939453, -139.73089599609375),
(300, 'Mountain Village', 'AK', 'verified', 62.08943939208984, -163.72561645507812),
(301, 'Ivanof Bay', 'AK', 'verified', 55.90240097045898, -159.48287963867188),
(302, 'Sleetmute', 'AK', 'verified', 61.70222091674805, -157.16917419433594),
(303, 'Teller', 'AK', 'verified', 65.26418304443360, -166.36331176757812),
(304, 'Huslia', 'AK', 'verified', 65.70236968994140, -156.38719177246094),
(305, 'Atmautluak', 'AK', 'verified', 60.86296844482422, -162.27595520019530),
(306, 'Venetie', 'AK', 'verified', 67.00904846191406, -146.40596008300780),
(307, 'Crooked Creek', 'AK', 'verified', 61.87036895751953, -158.10830688476562),
(308, 'Juneau', 'AK', 'verified', 58.29973983764648, -134.40679931640625),
(309, 'Fritz Creek', 'AK', 'verified', 59.73765945434570, -151.31373596191406),
(310, 'Kake', 'AK', 'verified', 56.97483444213867, -133.94116210937500),
(311, 'Point Lay', 'AK', 'verified', 69.74359130859375, -163.01741027832030),
(312, 'Kaltag', 'AK', 'verified', 64.32482910156250, -158.72462463378906),
(313, 'Kodiak', 'AK', 'verified', 57.79515457153320, -152.39497375488280),
(314, 'Ketchikan', 'AK', 'verified', 55.34214019775391, -131.64785766601562),
(315, 'Kenai', 'AK', 'verified', 60.55308151245117, -151.25971984863280),
(316, 'Copper Center', 'AK', 'verified', 61.96078872680664, -145.31486511230470),
(317, 'Kwethluk', 'AK', 'verified', 60.81010818481445, -161.42602539062500),
(318, 'Kiana', 'AK', 'verified', 66.96992492675781, -160.42863464355470),
(319, 'King Cove', 'AK', 'verified', 55.06020355224609, -162.30340576171875),
(320, 'Klawock', 'AK', 'verified', 55.55077362060547, -133.08576965332030),
(321, 'Kokhanok', 'AK', 'verified', 59.43804168701172, -154.77381896972656),
(322, 'Koliganek', 'AK', 'verified', 59.72890090942383, -157.28477478027344),
(323, 'Kotlik', 'AK', 'verified', 63.03284835815430, -163.55357360839844),
(324, 'Koyuk', 'AK', 'verified', 64.93111419677734, -161.16036987304688),
(325, 'Quinhagak', 'AK', 'verified', 59.75114059448242, -161.90786743164062),
(326, 'Kwethiuk', 'AK', 'verified', 61.32538223266602, -154.56503295898438),
(327, 'Kwigillingok', 'AK', 'verified', 59.90773773193359, -163.02638244628906),
(328, 'King Salmon', 'AK', 'verified', 58.69601821899414, -156.69754028320312),
(329, 'Larsen Bay', 'AK', 'verified', 57.53834915161133, -153.98049926757812),
(330, 'Nome', 'AK', 'verified', 64.49955749511719, -165.40469360351562),
(331, 'Levelock', 'AK', 'verified', 59.11256790161133, -156.85574340820312),
(332, 'Tuntutuliak', 'AK', 'verified', 60.34315490722656, -162.66394042968750),
(333, 'Manokotak', 'AK', 'verified', 58.98172378540039, -159.05772399902344),
(334, 'Marshall', 'AK', 'verified', 61.87953186035156, -162.08792114257812),
(335, 'Golovin', 'AK', 'verified', 64.54331207275390, -163.03292846679688),
(336, 'Tanana', 'AK', 'verified', 65.17153167724610, -152.07771301269530),
(337, 'McGrath', 'AK', 'verified', 62.94911956787109, -155.55987548828125),
(338, 'Eagle River', 'AK', 'verified', 61.32160186767578, -149.56710815429688),
(339, 'Kivalina', 'AK', 'verified', 67.72975158691406, -164.54008483886720),
(340, 'Atqasuk', 'AK', 'verified', 70.48096466064453, -157.42228698730470),
(341, 'Mentasta Lake', 'AK', 'verified', 62.93294143676758, -143.77499389648438),
(342, 'Ruby', 'AK', 'verified', 64.73807525634766, -155.48915100097656),
(343, 'Port Heiden', 'AK', 'verified', 56.94108963012695, -158.63018798828125),
(344, 'Metlakatla', 'AK', 'verified', 55.13050460815430, -131.57653808593750),
(345, 'Lake Minchumina', 'AK', 'verified', 63.88254547119141, -152.31283569335938),
(346, 'Minto', 'AK', 'verified', 65.19866943359375, -149.52975463867188),
(347, 'Sitka', 'AK', 'verified', 57.05201339721680, -135.33375549316406),
(348, 'Nanwalek', 'AK', 'verified', 59.35095977783203, -151.91500854492188),
(349, 'Noatak', 'AK', 'verified', 67.57152557373047, -162.96502685546875),
(350, 'Toksook Bay', 'AK', 'verified', 60.53298568725586, -165.10424804687500),
(351, 'Nelson Lagoon', 'AK', 'verified', 56.00059890747070, -161.20399475097656),
(352, 'Nenana', 'AK', 'verified', 64.55804443359375, -149.09968566894530),
(353, 'Iliamna', 'AK', 'verified', 59.75982284545898, -154.91081237792970),
(354, 'Nightmute', 'AK', 'verified', 60.47724151611328, -164.72140502929688),
(355, 'Nikiski', 'AK', 'verified', 60.69010162353516, -151.29162597656250),
(356, 'Anchor Point', 'AK', 'verified', 59.77599334716797, -151.83105468750000),
(357, 'Nikolski', 'AK', 'verified', 52.93892669677734, -168.86779785156250),
(358, 'Ninilchik', 'AK', 'verified', 60.05239868164063, -151.66789245605470),
(359, 'Nondalton', 'AK', 'verified', 59.97172164916992, -154.84701538085938),
(360, 'North Pole', 'AK', 'verified', 64.74877929687500, -147.35256958007812),
(361, 'Nuiqsut', 'AK', 'verified', 70.21411132812500, -151.00413513183594),
(362, 'Anaktuvuk Pass', 'AK', 'verified', 68.14498901367188, -151.73254394531250),
(363, 'Mekoryuk', 'AK', 'verified', 60.39060974121094, -166.19050598144530),
(364, 'Old Harbor', 'AK', 'verified', 57.19861984252930, -153.30566406250000),
(365, 'Ouzinkie', 'AK', 'verified', 57.92245101928711, -152.50462341308594),
(366, 'Tununak', 'AK', 'verified', 60.58347320556641, -165.25825500488280),
(367, 'Pelican', 'AK', 'verified', 57.96030807495117, -136.22868347167970),
(368, 'Perryville', 'AK', 'verified', 55.91217041015625, -159.15426635742188),
(369, 'Petersburg', 'AK', 'verified', 56.80649185180664, -132.97091674804688),
(370, 'Pilot Point', 'AK', 'verified', 57.55914306640625, -157.57893371582030),
(371, 'Port Alexander', 'AK', 'verified', 56.25048828125000, -134.64648437500000),
(372, 'Port Graham', 'AK', 'verified', 59.34917068481445, -151.82810974121094),
(373, 'Port Lions', 'AK', 'verified', 57.86740875244141, -152.87992858886720),
(374, 'Oscarville', 'AK', 'verified', 60.72187042236328, -161.76771545410156),
(375, 'Goodnews Bay', 'AK', 'verified', 59.12179183959961, -161.58782958984375),
(376, 'Russian Mission', 'AK', 'verified', 61.78563690185547, -161.32435607910156),
(377, 'Scammon Bay', 'AK', 'verified', 61.84249114990234, -165.58021545410156),
(378, 'Seward', 'AK', 'verified', 60.11235809326172, -149.44291687011720),
(379, 'Shaktoolik', 'AK', 'verified', 64.35485076904297, -161.19274902343750),
(380, 'Sheldon Point', 'AK', 'verified', 62.58293914794922, -164.79208374023438),
(381, 'Shishmaref', 'AK', 'verified', 66.25679779052734, -166.06657409667970),
(382, 'Shungnak', 'AK', 'verified', 66.88624572753906, -157.13778686523438),
(383, 'Skagway', 'AK', 'verified', 59.46030426025391, -135.30848693847656),
(384, 'Soldotna', 'AK', 'verified', 60.50043106079102, -151.08973693847656),
(385, 'Slana', 'AK', 'verified', 62.68704986572266, -143.90283203125000),
(386, 'St. George', 'AK', 'verified', 56.60717010498047, -169.54974365234375),
(388, 'St. Paul', 'AK', 'verified', 44.94382095336914, -93.09332275390625),
(389, 'Stevens Village', 'AK', 'verified', 66.00437164306640, -149.09143066406250),
(390, 'Seldovia', 'AK', 'verified', 59.43991088867188, -151.71711730957030),
(391, 'Takotna', 'AK', 'verified', 62.98448181152344, -156.07020568847656),
(392, 'Port Alsworth', 'AK', 'verified', 60.39558029174805, -154.49446105957030),
(393, 'Tatitlek', 'AK', 'verified', 60.86516189575195, -146.67788696289062),
(394, 'Tyonek', 'AK', 'verified', 61.06761550903320, -151.13781738281250),
(395, 'Tenakee Springs', 'AK', 'verified', 57.77727508544922, -135.20756530761720),
(396, 'Tetlin', 'AK', 'verified', 63.13779830932617, -142.52400207519530),
(397, 'Thorne Bay', 'AK', 'verified', 55.68329238891602, -132.52850341796875),
(398, 'Point Hope', 'AK', 'verified', 68.34754180908203, -166.78982543945312),
(399, 'Togiak', 'AK', 'verified', 59.06034088134766, -160.37770080566406),
(400, 'Nikolai', 'AK', 'verified', 63.01227188110352, -154.38163757324220),
(401, 'Healy', 'AK', 'verified', 63.87157821655273, -148.99946594238280),
(402, 'Chalkyitsik', 'AK', 'verified', 66.65428924560547, -143.72265625000000),
(403, 'Northway', 'AK', 'verified', 62.96001815795898, -141.92890930175780),
(404, 'Wasilla', 'AK', 'verified', 61.58224487304688, -149.44535827636720),
(405, 'White Mountain', 'AK', 'verified', 64.68106842041016, -163.40844726562500),
(406, 'Whittier', 'AK', 'verified', 60.77318572998047, -148.68469238281250),
(407, 'Napakiak', 'AK', 'verified', 60.69433212280273, -161.96717834472656),
(408, 'Wiseman Village', 'AK', 'verified', 36.23791122436523, -91.83460235595703),
(409, 'Reid Street Wrangell', 'AK', 'verified', 56.47283935546875, -132.38302612304688),
(410, 'Atka', 'AK', 'verified', 52.19480514526367, -174.19712829589844),
(411, 'Mesa', 'AZ', 'verified', 33.41704559326172, -111.83145904541016),
(412, 'Phoenix', 'AZ', 'verified', 33.44826126098633, -112.07577514648438),
(413, 'Avondale', 'AZ', 'verified', 33.44049835205078, -112.34966278076172),
(414, 'Mohave Valley', 'AZ', 'verified', 34.92383956909180, -114.59786224365234),
(415, 'Whiteriver', 'AZ', 'verified', 33.83486557006836, -109.96493530273438),
(416, 'Tucson', 'AZ', 'verified', 32.22155380249023, -110.96975708007812),
(417, 'Wellton', 'AZ', 'verified', 32.67272186279297, -114.14716339111328),
(418, 'Apache Junction', 'AZ', 'verified', 33.42314147949219, -111.54611968994140),
(419, 'Glendale', 'AZ', 'verified', 33.53858184814453, -112.18627929687500),
(420, 'Ash Fork', 'AZ', 'verified', 35.22389984130859, -112.48142242431640),
(421, 'Yuma', 'AZ', 'verified', 32.68484878540039, -114.62461090087890),
(422, 'Sells', 'AZ', 'verified', 31.91646575927734, -111.88915252685547),
(423, 'Chandler', 'AZ', 'verified', 33.30338668823242, -111.84082794189453),
(424, 'Benson', 'AZ', 'verified', 31.96878433227539, -110.29868316650390),
(425, 'Bisbee', 'AZ', 'verified', 31.44182205200195, -109.91445922851562),
(426, 'Lakeside', 'AZ', 'verified', 34.13621902465820, -109.95088195800781),
(427, 'Bowie', 'AZ', 'verified', 32.32669448852539, -109.48690795898438),
(428, 'Prescott Valley', 'AZ', 'verified', 34.58599853515625, -112.32290649414062),
(429, 'Sierra Vista', 'AZ', 'verified', 31.56945037841797, -110.27468109130860),
(430, 'Camp Verde', 'AZ', 'verified', 34.56204605102539, -111.85355377197266),
(431, 'Oro Valley', 'AZ', 'verified', 32.40766143798828, -110.99568939208984),
(432, 'Prescott', 'AZ', 'verified', 34.54142379760742, -112.46872711181640),
(433, 'Cave Creek', 'AZ', 'verified', 33.82759475708008, -111.95509338378906),
(434, 'Casa Grande', 'AZ', 'verified', 32.87954330444336, -111.75032043457031),
(435, 'Peoria', 'AZ', 'verified', 33.57731246948242, -112.24090576171875),
(436, 'Laveen', 'AZ', 'verified', 33.36295318603516, -112.16481781005860),
(437, 'Scottsdale', 'AZ', 'verified', 33.49399948120117, -111.92069244384766),
(438, 'Chino Valley', 'AZ', 'verified', 34.75534439086914, -112.45398712158203),
(439, 'Vail', 'AZ', 'verified', 32.04787063598633, -110.71202087402344),
(440, 'Flagstaff', 'AZ', 'verified', 35.19820022583008, -111.65130615234375),
(441, 'Tempe', 'AZ', 'verified', 33.42551040649414, -111.93741607666016),
(442, 'Coolidge', 'AZ', 'verified', 32.97762680053711, -111.51702880859375),
(443, 'Goodyear', 'AZ', 'verified', 33.43630599975586, -112.35829925537110),
(444, 'Gilbert', 'AZ', 'verified', 33.32904052734375, -111.78976440429688),
(445, 'Winslow', 'AZ', 'verified', 35.02426147460938, -110.69624328613281),
(446, 'Douglas', 'AZ', 'verified', 31.34444427490234, -109.55213165283203),
(447, 'El Mirage', 'AZ', 'verified', 33.61528015136719, -112.32257843017578),
(448, 'Florence', 'AZ', 'verified', 33.03881454467773, -111.38754272460938),
(449, 'Fort Thomas', 'AZ', 'verified', 33.03737640380859, -109.96617889404297),
(450, 'Fredonia', 'AZ', 'verified', 36.95201873779297, -112.52641296386719),
(451, 'Thatcher', 'AZ', 'verified', 32.84915161132813, -109.76001739501953),
(452, 'Globe', 'AZ', 'verified', 33.39575958251953, -110.78912353515625),
(453, 'Grand Canyon', 'AZ', 'verified', 36.05488586425781, -112.12210083007812),
(454, 'Tuba City', 'AZ', 'verified', 36.12570571899414, -111.23689270019531),
(456, 'Winkelman', 'AZ', 'verified', 32.98775482177734, -110.77275085449219),
(457, 'Keams Canyon', 'AZ', 'verified', 35.81298446655273, -110.20190429687500),
(458, 'Joseph City', 'AZ', 'verified', 34.95599365234375, -110.33216094970703),
(459, 'Kingman', 'AZ', 'verified', 35.18882369995117, -114.05543518066406),
(460, 'Lake Havasu City', 'AZ', 'verified', 34.47397994995117, -114.34586334228516),
(461, 'Show Low', 'AZ', 'verified', 34.25018310546875, -110.04302215576172),
(462, 'Marana', 'AZ', 'verified', 32.46057128906250, -111.21810913085938),
(463, 'Mayer', 'AZ', 'verified', 34.39844131469727, -112.23101043701172),
(464, 'Miami', 'AZ', 'verified', 33.39852523803711, -110.87055206298828),
(465, 'Cottonwood', 'AZ', 'verified', 34.73995971679688, -112.00974273681640),
(466, 'Heber', 'AZ', 'verified', 34.43113327026367, -110.59655761718750),
(467, 'Bullhead City', 'AZ', 'verified', 35.12570571899414, -114.57844543457031),
(468, 'Kayenta', 'AZ', 'verified', 36.72445678710938, -110.25646972656250),
(469, 'Sfford', 'AZ', 'verified', 32.83436965942383, -109.70824432373047),
(470, 'Snowflake', 'AZ', 'verified', 34.51266098022461, -110.07897186279297),
(471, 'Nogales', 'AZ', 'verified', 31.33783531188965, -110.94006347656250),
(472, 'Taylor', 'AZ', 'verified', 34.46866607666016, -110.09103393554688),
(473, 'Humboldt', 'AZ', 'verified', 34.49876785278320, -112.23601531982422),
(474, 'Page', 'AZ', 'verified', 36.91983795166016, -111.46176147460938),
(475, 'Parker', 'AZ', 'verified', 34.14988327026367, -114.28879547119140),
(476, 'Patagonia', 'AZ', 'verified', 31.54079437255859, -110.75212097167969),
(477, 'Rimrock', 'AZ', 'verified', 34.64835739135742, -111.78523254394531),
(478, 'Payson', 'AZ', 'verified', 34.23131942749023, -111.32467651367188),
(479, 'Pima', 'AZ', 'verified', 32.89624023437500, -109.82828521728516),
(480, 'Pinon', 'AZ', 'verified', 36.10137557983398, -110.22562408447266),
(481, 'Queen Creek', 'AZ', 'verified', 33.24467086791992, -111.63452148437500),
(482, 'Kearny', 'AZ', 'verified', 33.05997848510742, -110.90518951416016),
(483, 'Teec Nos Pos', 'AZ', 'verified', 36.92334365844727, -109.09175872802734),
(484, 'Pinetop', 'AZ', 'verified', 34.12580871582031, -109.93547058105469),
(485, 'Springerville', 'AZ', 'verified', 34.13347625732422, -109.28532409667969),
(486, 'Rio Rico', 'AZ', 'verified', 31.47493934631348, -110.98313903808594),
(487, 'Eagar', 'AZ', 'verified', 34.11095046997070, -109.29262542724610),
(488, 'Safford', 'AZ', 'verified', 32.83436965942383, -109.70824432373047),
(489, 'Sahuarita', 'AZ', 'verified', 31.95766067504883, -110.95472717285156),
(490, 'Salome', 'AZ', 'verified', 33.78208160400391, -113.61318969726562),
(491, 'San Carlos', 'AZ', 'verified', 33.35138320922852, -110.45245361328125),
(492, 'San Manuel', 'AZ', 'verified', 32.61358642578125, -110.62765502929688),
(493, 'Sanders', 'AZ', 'verified', 35.21519851684570, -109.33273315429688),
(494, 'Eloy', 'AZ', 'verified', 32.75241851806641, -111.55555725097656),
(495, 'Quartzsite', 'AZ', 'verified', 33.67620086669922, -114.21707916259766),
(496, 'Sedona', 'AZ', 'verified', 34.86597824096680, -111.76381683349610),
(497, 'Seligman', 'AZ', 'verified', 35.32663345336914, -112.87484741210938),
(498, 'Hereford', 'AZ', 'verified', 31.43928146362305, -110.10031127929688),
(499, 'St. David', 'AZ', 'verified', 31.90526580810547, -110.21958923339844),
(500, 'St. Johns', 'AZ', 'verified', 34.50676345825195, -109.36558532714844),
(501, 'Superior', 'AZ', 'verified', 33.28909683227539, -111.10051727294922),
(502, 'WayTombstone', 'AZ', 'verified', 34.16787338256836, -111.93070220947266),
(503, 'Tonopah', 'AZ', 'verified', 33.49245834350586, -112.93693542480469),
(504, 'Elfrida', 'AZ', 'verified', 31.68165397644043, -109.68720245361328),
(505, 'Showlow', 'AZ', 'verified', 34.25018310546875, -110.04302215576172),
(506, 'Willcox', 'AZ', 'verified', 32.25313568115234, -109.83206939697266),
(507, 'Williams', 'AZ', 'verified', 35.25000000000000, -112.19075775146484),
(508, 'Surprise', 'AZ', 'verified', 33.63861083984375, -112.32694244384766),
(509, 'Fort Defiance', 'AZ', 'verified', 35.78794860839844, -109.08316802978516),
(510, 'Maumelle', 'AR', 'verified', 34.85606002807617, -92.40238189697266),
(511, 'Little Rock', 'AR', 'verified', 34.74865341186523, -92.27449035644531),
(512, 'Mena', 'AR', 'verified', 34.58710861206055, -94.23863220214844),
(513, 'Alma', 'AR', 'verified', 35.47666168212891, -94.22124481201172),
(514, 'Alpena', 'AR', 'verified', 36.29445648193359, -93.29313659667969),
(515, 'Clinton', 'AR', 'verified', 35.59232711791992, -92.45904541015625),
(516, 'Altheimer', 'AR', 'verified', 34.31931686401367, -91.84677124023438),
(517, 'Arkadelphia', 'AR', 'verified', 34.12097167968750, -93.05413055419922),
(518, 'Texarkana', 'AR', 'verified', 33.43096160888672, -94.03579711914062),
(519, 'Armorel', 'AR', 'verified', 35.91709899902344, -89.79868316650390),
(520, 'Ashdown', 'AR', 'verified', 33.67213821411133, -94.13199615478516),
(521, 'Atkins', 'AR', 'verified', 35.24201965332031, -92.93566131591797),
(522, 'Augusta', 'AR', 'verified', 35.28297042846680, -91.36542510986328),
(523, 'Bald Knob', 'AR', 'verified', 35.31101989746094, -91.56709289550781),
(524, 'Bearden', 'AR', 'verified', 33.72608947753906, -92.61660766601562),
(525, 'Lexa', 'AR', 'verified', 34.59883117675781, -90.75194549560547),
(526, 'Batesville', 'AR', 'verified', 35.76977157592773, -91.65000152587890),
(527, 'Bauxite', 'AR', 'verified', 34.55498886108398, -92.52712249755860),
(528, 'Bay', 'AR', 'verified', 35.74414062500000, -90.56441497802734),
(529, 'Beebe', 'AR', 'verified', 35.07075119018555, -91.88019561767578),
(530, 'Fort Smith', 'AR', 'verified', 35.38460159301758, -94.42130279541016),
(531, 'Benton', 'AR', 'verified', 34.56398391723633, -92.58685302734375),
(532, 'Bentonville', 'AR', 'verified', 36.37233352661133, -94.20949554443360),
(533, 'Harrison', 'AR', 'verified', 36.22864913940430, -93.11051177978516),
(534, 'Berryville', 'AR', 'verified', 36.36388397216797, -93.56693267822266),
(535, 'Bigelow', 'AR', 'verified', 35.00198745727539, -92.63108062744140),
(536, 'Biggers', 'AR', 'verified', 36.33210372924805, -90.80713653564453),
(537, 'Bismarck', 'AR', 'verified', 34.31607818603516, -93.17186737060547),
(538, 'Black Rock', 'AR', 'verified', 36.10803985595703, -91.09719085693360),
(539, 'Blevins', 'AR', 'verified', 33.87203598022461, -93.57678222656250),
(540, 'Blytheville', 'AR', 'verified', 35.92847824096680, -89.90473937988281),
(541, 'Booneville', 'AR', 'verified', 35.14022827148438, -93.92249298095703),
(542, 'Bradford', 'AR', 'verified', 35.42589950561523, -91.45414733886719),
(543, 'Bradley', 'AR', 'verified', 33.09778213500977, -93.65534973144531),
(544, 'Brinkley', 'AR', 'verified', 34.86737823486328, -91.18847656250000),
(545, 'Brookland', 'AR', 'verified', 35.90105819702148, -90.58040618896484),
(546, 'Everton', 'AR', 'verified', 36.15552139282227, -92.90608215332031),
(547, 'Bryant', 'AR', 'verified', 34.59203720092773, -92.48959350585938),
(548, 'Cabot', 'AR', 'verified', 34.97369384765625, -92.01750183105469),
(549, 'Norman', 'AR', 'verified', 34.45448684692383, -93.68013000488281),
(550, 'Calico Rock', 'AR', 'verified', 36.11692810058594, -92.14284515380860),
(551, 'Camden', 'AR', 'verified', 33.58697891235352, -92.82958221435547),
(552, 'Carlisle', 'AR', 'verified', 34.78083419799805, -91.74671173095703),
(553, 'Cave City', 'AR', 'verified', 35.94166564941406, -91.54563140869140),
(554, 'Cedarville', 'AR', 'verified', 35.56869506835938, -94.36693572998047),
(555, 'Charlestone', 'AR', 'verified', 35.29712677001953, -94.03847503662110),
(556, 'Clarendon', 'AR', 'verified', 34.69260406494141, -91.30857849121094),
(557, 'Clarksville', 'AR', 'verified', 35.47169876098633, -93.46634674072266),
(558, 'Concord', 'AR', 'verified', 35.66291427612305, -91.84896850585938),
(559, 'Conway', 'AR', 'verified', 35.09081649780273, -92.44023895263672),
(560, 'Corning', 'AR', 'verified', 36.40821838378906, -90.58049774169922),
(561, 'Cotter', 'AR', 'verified', 36.26649093627930, -92.54016113281250),
(562, 'Branch', 'AR', 'verified', 35.30551147460938, -93.95820617675781),
(563, 'Cherry Valley', 'AR', 'verified', 35.40296936035156, -90.75330352783203),
(564, 'Crossett', 'AR', 'verified', 33.13177871704102, -91.96147918701172),
(565, 'Cushman', 'AR', 'verified', 35.87202072143555, -91.75357055664062),
(566, 'Hot Springs', 'AR', 'verified', 34.50942230224609, -93.05231475830078),
(567, 'Danville', 'AR', 'verified', 35.05646514892578, -93.39382171630860),
(568, 'Dardanelle', 'AR', 'verified', 35.22370147705078, -93.15580749511719),
(569, 'DeQueen', 'AR', 'verified', 34.03674316406250, -94.33942413330078),
(570, 'Decatur', 'AR', 'verified', 36.33693313598633, -94.46067047119140),
(571, 'Deer', 'AR', 'verified', 35.82693099975586, -93.20914459228516),
(572, 'Delaplaine', 'AR', 'verified', 36.23320388793945, -90.72539520263672),
(573, 'Delight', 'AR', 'verified', 34.03142547607422, -93.50242614746094),
(574, 'Dermott', 'AR', 'verified', 33.52490997314453, -91.43347167968750),
(575, 'Des Arc', 'AR', 'verified', 34.97692871093750, -91.49579620361328),
(576, 'De Valls Bluff', 'AR', 'verified', 34.78473663330078, -91.45858001708984),
(577, 'DeWitt', 'AR', 'verified', 34.29319000244141, -91.33573150634766),
(578, 'Dierks', 'AR', 'verified', 34.11978530883789, -94.01688385009766),
(579, 'Pine Bluff', 'AR', 'verified', 34.22353363037109, -92.00340270996094),
(580, 'Dover', 'AR', 'verified', 35.40270233154297, -93.11425781250000),
(581, 'Monticello', 'AR', 'verified', 33.62778091430664, -91.79097747802734),
(582, 'Dumas', 'AR', 'verified', 33.88744354248047, -91.49027252197266),
(583, 'Earle', 'AR', 'verified', 35.27089309692383, -90.46479034423828),
(584, 'Lepanto', 'AR', 'verified', 35.61302566528320, -90.33077239990234),
(585, 'El Dorado', 'AR', 'verified', 33.21149826049805, -92.66545104980469),
(586, 'Elaine', 'AR', 'verified', 34.30802536010742, -90.85241699218750),
(587, 'Elkins', 'AR', 'verified', 36.00075912475586, -94.01052856445312),
(588, 'Emerson', 'AR', 'verified', 33.09889984130859, -93.19217681884766),
(589, 'Emmet', 'AR', 'verified', 33.72710037231445, -93.46905517578125),
(590, 'England', 'AR', 'verified', 34.54326248168945, -91.97046661376953),
(591, 'Eudora', 'AR', 'verified', 33.13624191284180, -91.26845550537110),
(592, 'Eureka Springs', 'AR', 'verified', 36.40104293823242, -93.73856353759766),
(593, 'Farmington', 'AR', 'verified', 36.04199218750000, -94.24746704101562),
(594, 'Fayetteville', 'AR', 'verified', 36.06320571899414, -94.15791320800781),
(595, 'Flippin', 'AR', 'verified', 36.27780532836914, -92.59799957275390),
(596, 'Fordyce', 'AR', 'verified', 33.81026458740234, -92.41053771972656),
(597, 'Foreman', 'AR', 'verified', 33.72180557250977, -94.39807128906250),
(598, 'Forrest City', 'AR', 'verified', 35.01142120361328, -90.78620147705078),
(599, 'Fouke', 'AR', 'verified', 33.26255416870117, -93.88537597656250),
(600, 'Briggsville', 'AR', 'verified', 34.93340682983398, -93.49587249755860),
(601, 'Hope', 'AR', 'verified', 33.66741561889648, -93.58983612060547),
(602, 'Gentry', 'AR', 'verified', 36.26755142211914, -94.48428344726562),
(603, 'Malvern', 'AR', 'verified', 34.36277389526367, -92.81272125244140),
(604, 'Gosnell', 'AR', 'verified', 35.95978927612305, -89.96839904785156),
(605, 'Gravette', 'AR', 'verified', 36.42137527465820, -94.45136260986328),
(606, 'Green Forest', 'AR', 'verified', 36.33544540405273, -93.43720245361328),
(607, 'Greenbrier', 'AR', 'verified', 35.23492813110352, -92.38787078857422),
(608, 'Paragould', 'AR', 'verified', 36.05672836303711, -90.48735809326172),
(609, 'Greenland', 'AR', 'verified', 35.99623870849609, -94.17384338378906),
(610, 'Greenwood', 'AR', 'verified', 35.21222686767578, -94.25528717041016),
(611, 'Gurdon', 'AR', 'verified', 33.92192077636719, -93.14939117431640),
(612, 'Guy', 'AR', 'verified', 35.32543563842773, -92.33522796630860),
(613, 'Hackett', 'AR', 'verified', 35.18839645385742, -94.41372680664062),
(614, 'Hamburg', 'AR', 'verified', 33.22766494750977, -91.79748535156250),
(615, 'Hampton', 'AR', 'verified', 33.53799057006836, -92.47011566162110),
(616, 'Springdale', 'AR', 'verified', 36.18505477905273, -94.13036346435547),
(617, 'Harrisburg', 'AR', 'verified', 35.56410598754883, -90.71682739257812),
(618, 'Hartford', 'AR', 'verified', 35.02239990234375, -94.38142395019531),
(619, 'Hazen', 'AR', 'verified', 34.78076171875000, -91.57569122314453),
(620, 'Heber Springs', 'AR', 'verified', 35.49190521240234, -92.03684997558594),
(621, 'Hector', 'AR', 'verified', 35.46763992309570, -92.97489166259766),
(622, 'Hermitage', 'AR', 'verified', 33.44958496093750, -92.17373657226562),
(623, 'Hardy', 'AR', 'verified', 36.31630325317383, -91.48695373535156),
(624, 'Horatio', 'AR', 'verified', 33.93848037719727, -94.35781097412110),
(625, 'Hoxie', 'AR', 'verified', 36.04870986938477, -90.98133850097656),
(626, 'Hughes', 'AR', 'verified', 34.94837570190430, -90.47144317626953),
(627, 'Huntsville', 'AR', 'verified', 36.08742141723633, -93.73674011230469),
(628, 'Huttig', 'AR', 'verified', 33.03864669799805, -92.18361663818360),
(629, 'Brockwell', 'AR', 'verified', 36.14311981201172, -91.92608642578125),
(630, 'Magazine', 'AR', 'verified', 35.15043640136719, -93.80718231201172),
(631, 'Jasper', 'AR', 'verified', 36.00799179077148, -93.18722534179688),
(632, 'Jessieville', 'AR', 'verified', 34.69569015502930, -93.06215667724610),
(633, 'Jonesboro', 'AR', 'verified', 35.83525466918945, -90.70505523681640),
(634, 'Kingston', 'AR', 'verified', 36.05043411254883, -93.51845550537110),
(635, 'Kirby', 'AR', 'verified', 34.25062561035156, -93.64312744140625),
(636, 'Stamps', 'AR', 'verified', 33.36003494262695, -93.49748992919922),
(637, 'Pearcy', 'AR', 'verified', 34.42858123779297, -93.29083251953125),
(638, 'Lamar', 'AR', 'verified', 35.44583511352539, -93.39440155029297),
(639, 'Lavaca', 'AR', 'verified', 35.33629989624023, -94.17842864990234),
(640, 'Lead Hill', 'AR', 'verified', 36.41947174072266, -92.91391754150390),
(641, 'Marianna', 'AR', 'verified', 34.77397155761719, -90.76666259765625),
(642, 'Lincoln', 'AR', 'verified', 35.94935989379883, -94.42290496826172),
(643, 'Lockesburg', 'AR', 'verified', 33.96731185913086, -94.16836547851562),
(644, 'Lonoke', 'AR', 'verified', 34.78392410278320, -91.90062713623047),
(645, 'Magnolia', 'AR', 'verified', 33.26748657226563, -93.24087524414062),
(646, 'Mammoth Spring', 'AR', 'verified', 36.49565124511719, -91.54103088378906),
(647, 'Manila', 'AR', 'verified', 35.87979507446289, -90.16624450683594),
(648, 'Mansfield', 'AR', 'verified', 35.06336593627930, -94.24999237060547),
(649, 'Marion', 'AR', 'verified', 35.21846771240234, -90.19954681396484),
(650, 'Marked Tree', 'AR', 'verified', 35.53303909301758, -90.42260742187500),
(651, 'Marmaduke', 'AR', 'verified', 36.18691635131836, -90.38336944580078),
(652, 'Marvell', 'AR', 'verified', 34.56039428710938, -90.91387176513672),
(653, 'Mayflower', 'AR', 'verified', 34.95692443847656, -92.42650604248047),
(654, 'Maynard', 'AR', 'verified', 36.41968917846680, -90.89727783203125),
(655, 'McCrory', 'AR', 'verified', 35.25691986083984, -91.19988250732422),
(656, 'McGehee', 'AR', 'verified', 33.62900924682617, -91.40386199951172),
(657, 'Melbourne', 'AR', 'verified', 36.05909347534180, -91.90567016601562),
(658, 'Pleasant Plains', 'AR', 'verified', 35.55249404907227, -91.62175750732422),
(659, 'Mineral Springs', 'AR', 'verified', 33.87520599365234, -93.91422271728516),
(660, 'Morrilton', 'AR', 'verified', 35.15333938598633, -92.74495697021484),
(661, 'Mount Ida', 'AR', 'verified', 34.55842971801758, -93.63290405273438),
(662, 'Mount Judea', 'AR', 'verified', 35.92032623291016, -93.05828857421875),
(663, 'Mount Pleasant', 'AR', 'verified', 35.96154403686523, -91.75573730468750),
(664, 'Mount Vernon', 'AR', 'verified', 35.22671890258789, -92.11602020263672),
(665, 'Mountain Home', 'AR', 'verified', 36.33510589599609, -92.38529968261719),
(666, 'Mountain Pine', 'AR', 'verified', 34.57152557373047, -93.17494201660156),
(667, 'Mountain View', 'AR', 'verified', 35.86843490600586, -92.12066650390625),
(668, 'Mulberry', 'AR', 'verified', 35.49750900268555, -94.05197143554688),
(669, 'Murfreesboro', 'AR', 'verified', 34.06198883056641, -93.68973541259766),
(670, 'Nashville', 'AR', 'verified', 33.94792175292969, -93.84701538085938),
(671, 'Rosston', 'AR', 'verified', 33.59362411499023, -93.28094482421875);
INSERT INTO `cities` (`id`, `name`, `state`, `status`, `latitude`, `longitude`) VALUES
(672, 'Center Ridge', 'AR', 'verified', 35.37458038330078, -92.56344604492188),
(673, 'Norfork', 'AR', 'verified', 36.20656967163086, -92.28589630126953),
(674, 'Norphlet', 'AR', 'verified', 33.31573867797852, -92.66298675537110),
(675, 'North Little Rock', 'AR', 'verified', 34.75605010986328, -92.26712036132812),
(676, 'Jacksonville', 'AR', 'verified', 34.86703872680664, -92.11230468750000),
(677, 'N Little Rock', 'AR', 'verified', 34.75605010986328, -92.26712036132812),
(678, 'Ravenden Springs', 'AR', 'verified', 36.31624984741211, -91.22540283203125),
(679, 'Oark', 'AR', 'verified', 35.68938827514648, -93.57312011718750),
(680, 'Oden', 'AR', 'verified', 34.61894607543945, -93.77796173095703),
(681, 'Ola', 'AR', 'verified', 35.03296279907227, -93.22338867187500),
(682, 'Omaha', 'AR', 'verified', 36.45106124877930, -93.18939208984375),
(683, 'Osceola', 'AR', 'verified', 35.70495986938477, -89.97074127197266),
(684, 'Donaldson', 'AR', 'verified', 34.23764038085938, -92.92676544189453),
(685, 'Ozark', 'AR', 'verified', 35.48739624023438, -93.83129119873047),
(686, 'Palestine', 'AR', 'verified', 34.97486114501953, -90.90209197998047),
(687, 'Pangburn', 'AR', 'verified', 35.42699050903320, -91.83699798583984),
(688, 'Paris', 'AR', 'verified', 35.29245376586914, -93.72991180419922),
(689, 'Paron', 'AR', 'verified', 34.77254104614258, -92.75816345214844),
(690, 'Pea Ridge', 'AR', 'verified', 36.45386123657227, -94.11434936523438),
(691, 'Perryville', 'AR', 'verified', 35.00542449951172, -92.80139923095703),
(692, 'Piggott', 'AR', 'verified', 36.38151931762695, -90.19161224365234),
(693, 'Plainview', 'AR', 'verified', 34.98952102661133, -93.29664611816406),
(694, 'Pocahontas', 'AR', 'verified', 36.28329849243164, -90.94396209716797),
(695, 'Pottsville', 'AR', 'verified', 35.25028610229492, -93.04879760742188),
(696, 'Poyen', 'AR', 'verified', 34.32397460937500, -92.64111328125000),
(697, 'Prairie Grove', 'AR', 'verified', 35.97565460205078, -94.31634521484375),
(698, 'Quitman', 'AR', 'verified', 35.38366317749023, -92.21598052978516),
(699, 'Rector', 'AR', 'verified', 36.26340103149414, -90.29277038574219),
(700, 'Rison', 'AR', 'verified', 33.95799636840820, -92.18985748291016),
(701, 'Wilson', 'AR', 'verified', 35.57035446166992, -90.03941345214844),
(702, 'Lake City', 'AR', 'verified', 35.82082366943359, -90.43280029296875),
(703, 'Searcy', 'AR', 'verified', 35.25082015991211, -91.74015045166016),
(704, 'Rogers', 'AR', 'verified', 36.33348464965820, -94.12468719482422),
(705, 'Rose Bud', 'AR', 'verified', 35.33161163330078, -92.08030700683594),
(706, 'Fox', 'AR', 'verified', 35.79035186767578, -92.29579162597656),
(707, 'Salem', 'AR', 'verified', 36.37123489379883, -91.82266235351562),
(708, 'Saratoga', 'AR', 'verified', 33.75276947021484, -93.90366363525390),
(709, 'Scotland', 'AR', 'verified', 35.51762008666992, -92.63143920898438),
(710, 'Scranton', 'AR', 'verified', 35.36035156250000, -93.53537750244140),
(711, 'Sheridan', 'AR', 'verified', 34.30828857421875, -92.39907836914062),
(712, 'Siloam Springs', 'AR', 'verified', 36.18862915039063, -94.54134368896484),
(713, 'Imboden', 'AR', 'verified', 36.20105361938477, -91.17211151123047),
(714, 'Smackover', 'AR', 'verified', 33.36501312255859, -92.72564697265625),
(715, 'Bee Branch', 'AR', 'verified', 35.45156097412109, -92.39508819580078),
(716, 'Sparkman', 'AR', 'verified', 33.91659545898438, -92.84857177734375),
(717, 'St. Joe', 'AR', 'verified', 36.03026962280273, -92.80171966552734),
(718, 'St. Paul', 'AR', 'verified', 35.82410812377930, -93.76566314697266),
(719, 'Star City', 'AR', 'verified', 33.94091415405273, -91.84615325927734),
(720, 'Stephens', 'AR', 'verified', 33.41144180297852, -93.07011413574219),
(721, 'Strong', 'AR', 'verified', 33.11076354980469, -92.35755920410156),
(722, 'Stuttgart', 'AR', 'verified', 34.49832153320313, -91.55261993408203),
(723, 'Swifton', 'AR', 'verified', 35.82425689697266, -91.13012695312500),
(724, 'Sherwood', 'AR', 'verified', 34.83263397216797, -92.20932769775390),
(725, 'Taylor', 'AR', 'verified', 33.10019683837891, -93.46154785156250),
(726, 'Timbo', 'AR', 'verified', 35.87040710449219, -92.31449127197266),
(727, 'Trumann', 'AR', 'verified', 35.66448974609375, -90.50873565673828),
(728, 'Tuckerman', 'AR', 'verified', 35.73150634765625, -91.19898986816406),
(729, 'Turrell', 'AR', 'verified', 35.37425994873047, -90.25611877441406),
(730, 'Umpire', 'AR', 'verified', 34.27865982055664, -94.05007171630860),
(731, 'Valley Springd', 'AR', 'verified', 36.15694046020508, -92.99388122558594),
(732, 'Van Buren', 'AR', 'verified', 35.43678665161133, -94.34877014160156),
(733, 'Cove', 'AR', 'verified', 34.43223571777344, -94.41176605224610),
(734, 'Vilonia', 'AR', 'verified', 35.08401107788086, -92.20604705810547),
(735, 'Waldo', 'AR', 'verified', 33.35322570800781, -93.29587554931640),
(736, 'Walnut Ridge', 'AR', 'verified', 36.06800079345703, -90.95640563964844),
(737, 'Weiner', 'AR', 'verified', 35.61975097656250, -90.89871215820312),
(738, 'West Fork', 'AR', 'verified', 35.92419815063477, -94.18931579589844),
(739, 'West Memphis', 'AR', 'verified', 35.14649581909180, -90.19219970703125),
(740, 'Western Grove', 'AR', 'verified', 36.10200500488281, -92.95340728759766),
(741, 'Havana', 'AR', 'verified', 35.10950088500977, -93.52847290039062),
(742, 'Judsonia', 'AR', 'verified', 35.26973342895508, -91.63968658447266),
(743, 'White Hall', 'AR', 'verified', 34.27481842041016, -92.09134674072266),
(744, 'Wickes', 'AR', 'verified', 34.30151367187500, -94.33816528320312),
(745, 'Wilburn', 'AR', 'verified', 35.50833892822266, -91.88631439208984),
(746, 'Hattieville', 'AR', 'verified', 35.28783416748047, -92.78890991210938),
(747, 'Wynne', 'AR', 'verified', 35.22203826904297, -90.78739166259766),
(748, 'San Diego', 'CA', 'verified', 32.71569442749023, -117.16172027587890),
(749, 'Fontana', 'CA', 'verified', 34.10205078125000, -117.43576049804688),
(750, 'Cerritos', 'CA', 'verified', 33.86854553222656, -118.06370544433594),
(751, 'Bakersfield', 'CA', 'verified', 35.36697006225586, -119.01885986328125),
(752, 'Los Angeles', 'CA', 'verified', 34.05348968505859, -118.24531555175781),
(753, 'San Francisco', 'CA', 'verified', 37.77712631225586, -122.41964721679688),
(754, 'Poway', 'CA', 'verified', 32.95458984375000, -117.04198455810547),
(755, 'Santa Rosa', 'CA', 'verified', 38.43773269653320, -122.71242523193360),
(756, 'Wheatland', 'CA', 'verified', 39.00956726074219, -121.42515563964844),
(757, 'Santa Clarita', 'CA', 'verified', 34.41344833374023, -118.55187225341797),
(758, 'Walnut Creek', 'CA', 'verified', 37.90118026733398, -122.06163024902344),
(759, 'Lafayette', 'CA', 'verified', 37.89073181152344, -122.12811279296875),
(760, 'Roseville', 'CA', 'verified', 38.74851989746094, -121.28455352783203),
(761, 'Camarillo', 'CA', 'verified', 34.22289657592773, -119.05072021484375),
(762, 'Santa Clara', 'CA', 'verified', 37.35551071166992, -121.95426177978516),
(763, 'Morgan Hill', 'CA', 'verified', 37.12538528442383, -121.66132354736328),
(764, 'Agoura', 'CA', 'verified', 34.14089965820313, -118.73948669433594),
(765, 'Oakhurst', 'CA', 'verified', 37.33283615112305, -119.65129089355469),
(766, 'Alameda', 'CA', 'verified', 37.76658630371094, -122.24473571777344),
(767, 'Albany', 'CA', 'verified', 37.88728332519531, -122.29800415039062),
(768, 'Hemet', 'CA', 'verified', 33.74937057495117, -116.96788787841797),
(769, 'Alhambra', 'CA', 'verified', 34.09370040893555, -118.12726593017578),
(770, 'Salinas', 'CA', 'verified', 36.67087936401367, -121.65481567382812),
(771, 'Aliso Viejo', 'CA', 'verified', 33.56737136840820, -117.72780609130860),
(772, 'Chester', 'CA', 'verified', 40.31115341186523, -121.22788238525390),
(773, 'Alpaugh', 'CA', 'verified', 35.88766860961914, -119.48667144775390),
(774, 'Weaverville', 'CA', 'verified', 40.72776031494141, -122.93669891357422),
(775, 'Mountain View', 'CA', 'verified', 37.38967132568359, -122.08161163330078),
(776, 'San Jose', 'CA', 'verified', 37.33847427368164, -121.88579559326172),
(777, 'Riverside', 'CA', 'verified', 33.98162841796875, -117.37387847900390),
(778, 'Sutter Creek', 'CA', 'verified', 38.39341354370117, -120.80303192138672),
(779, 'Pleasanton', 'CA', 'verified', 37.65803146362305, -121.87722015380860),
(780, 'Fremont', 'CA', 'verified', 37.55091094970703, -121.98217010498047),
(781, 'Sacramento', 'CA', 'verified', 38.57906341552734, -121.49101257324219),
(782, 'La Quinla', 'CA', 'verified', 37.27187347412109, -119.27022552490234),
(783, 'Anaheim', 'CA', 'verified', 33.83275985717773, -117.91571807861328),
(784, 'Sebastopol', 'CA', 'verified', 38.40174102783203, -122.82525634765625),
(785, 'Anderson', 'CA', 'verified', 40.45056152343750, -122.30124664306640),
(786, 'Boonville', 'CA', 'verified', 39.00795364379883, -123.36611175537110),
(787, 'La Crescenta', 'CA', 'verified', 34.22938919067383, -118.24836730957031),
(788, 'San Pedro', 'CA', 'verified', 33.73786926269531, -118.28461456298828),
(789, 'Angels Camp', 'CA', 'verified', 38.07003784179688, -120.54073333740234),
(790, 'Inglewood', 'CA', 'verified', 33.96178054809570, -118.35622406005860),
(791, 'Lancaster', 'CA', 'verified', 34.69890594482422, -118.14477539062500),
(792, 'Palmdale', 'CA', 'verified', 34.57923126220703, -118.11657714843750),
(793, 'Antelope', 'CA', 'verified', 38.71294021606445, -121.36448669433594),
(794, 'Antioch', 'CA', 'verified', 38.01582336425781, -121.81970214843750),
(795, 'San Juan Bautista', 'CA', 'verified', 36.84584426879883, -121.53872680664062),
(796, 'Simi Valley', 'CA', 'verified', 34.28945922851563, -118.71765899658203),
(797, 'Apple Valley', 'CA', 'verified', 34.52321243286133, -117.21574401855469),
(798, 'Aptos', 'CA', 'verified', 36.97566604614258, -121.88629150390625),
(799, 'San Mateo', 'CA', 'verified', 37.54703140258789, -122.31483459472656),
(800, 'Arbuckle', 'CA', 'verified', 39.01707077026367, -122.05716705322266),
(801, 'Arcadia', 'CA', 'verified', 34.13616561889648, -118.03885650634766),
(802, 'Arcata', 'CA', 'verified', 40.86743164062500, -124.08515167236328),
(803, 'Modesto', 'CA', 'verified', 37.63830184936523, -120.99958801269531),
(804, 'El Segundo', 'CA', 'verified', 33.91992568969727, -118.41596221923828),
(805, 'Jackson', 'CA', 'verified', 38.34711837768555, -120.77340698242188),
(806, 'Ceres', 'CA', 'verified', 37.59476089477539, -120.95629882812500),
(807, 'Santa Cruz', 'CA', 'verified', 36.97402572631836, -122.03095245361328),
(808, 'Fairfield', 'CA', 'verified', 38.24923324584961, -122.04388427734375),
(809, 'Glendora', 'CA', 'verified', 34.13602447509766, -117.86451721191406),
(810, 'Redlands', 'CA', 'verified', 34.05528259277344, -117.18257904052734),
(811, 'Arroyo Grande', 'CA', 'verified', 35.12419509887695, -120.57717132568360),
(812, 'San Lorenzo', 'CA', 'verified', 37.68048858642578, -122.12746429443360),
(813, 'El Monte', 'CA', 'verified', 34.07064056396484, -118.03037261962890),
(814, 'San Bernardino', 'CA', 'verified', 34.10524368286133, -117.29412078857422),
(815, 'Lakewood', 'CA', 'verified', 33.84881591796875, -118.13378143310547),
(816, 'Arvin', 'CA', 'verified', 35.20902633666992, -118.82898712158203),
(817, 'Atascadero', 'CA', 'verified', 35.48869323730469, -120.66906738281250),
(818, 'Atwater', 'CA', 'verified', 37.34587478637695, -120.60881042480469),
(819, 'Calexico', 'CA', 'verified', 32.67864608764648, -115.49877166748047),
(820, 'Wilmington', 'CA', 'verified', 33.78942489624023, -118.26319122314453),
(821, 'Avenal', 'CA', 'verified', 36.00358200073242, -120.13048553466797),
(822, 'Azusa', 'CA', 'verified', 34.13359832763672, -117.90558624267578),
(823, 'Costa Mesa', 'CA', 'verified', 33.66387939453125, -117.90342712402344),
(824, 'South San Francisco', 'CA', 'verified', 37.65589141845703, -122.41337585449219),
(825, 'Baker', 'CA', 'verified', 35.27392578125000, -116.07505035400390),
(826, 'Baldwin Park', 'CA', 'verified', 34.08518981933594, -117.96029663085938),
(827, 'Rancho Cucamonga', 'CA', 'verified', 34.10261535644531, -117.57383728027344),
(828, 'Banning', 'CA', 'verified', 33.92544555664063, -116.87564849853516),
(829, 'Barstow', 'CA', 'verified', 34.89296340942383, -117.02582550048828),
(830, 'La Puente', 'CA', 'verified', 34.02011489868164, -117.95086669921875),
(831, 'Moreno Valley', 'CA', 'verified', 33.91658020019531, -117.26113128662110),
(832, 'Stockton', 'CA', 'verified', 37.95367813110352, -121.29075622558594),
(833, 'Grass Valley', 'CA', 'verified', 39.21926879882813, -121.06150054931640),
(834, 'Bear Valley', 'CA', 'verified', 38.46041870117188, -120.04496765136719),
(835, 'Beaumont', 'CA', 'verified', 33.92937469482422, -116.97505950927734),
(836, 'Portola', 'CA', 'verified', 39.81034469604492, -120.47001647949219),
(837, 'Bell Gardens', 'CA', 'verified', 33.96892929077148, -118.14959716796875),
(838, 'Bell', 'CA', 'verified', 33.97932434082031, -118.18892669677734),
(839, 'Fair Oaks', 'CA', 'verified', 38.64307403564453, -121.27015686035156),
(840, 'Bellflower', 'CA', 'verified', 33.88274383544922, -118.12229156494140),
(841, 'Benicia', 'CA', 'verified', 38.05241012573242, -122.15254211425781),
(842, 'Berkeley', 'CA', 'verified', 37.86988449096680, -122.27053833007812),
(843, 'Beverly Hills', 'CA', 'verified', 34.07348632812500, -118.40034484863281),
(844, 'Elk Creek', 'CA', 'verified', 39.60292053222656, -122.53841400146484),
(845, 'Big Bear Lake', 'CA', 'verified', 34.23857116699219, -116.93552398681640),
(846, 'Big Pine', 'CA', 'verified', 37.16424560546875, -118.28952026367188),
(847, 'Bieber', 'CA', 'verified', 41.12141036987305, -121.14186096191406),
(848, 'Biggs', 'CA', 'verified', 39.41421508789063, -121.71050262451172),
(849, 'Winterhaven', 'CA', 'verified', 32.73850631713867, -114.63512420654297),
(850, 'Van Nuys', 'CA', 'verified', 34.18415832519531, -118.44651794433594),
(851, 'Mission Hills', 'CA', 'verified', 34.27337646484375, -118.46770477294922),
(852, 'Santa Barbara', 'CA', 'verified', 34.41925430297852, -119.69886779785156),
(853, 'Bishop', 'CA', 'verified', 37.36671447753906, -118.39535522460938),
(854, 'Pasadena', 'CA', 'verified', 34.14723587036133, -118.14426422119140),
(855, 'Bloomington', 'CA', 'verified', 34.06868743896484, -117.39994812011719),
(856, 'South Lake Tahoe', 'CA', 'verified', 38.91070938110352, -120.00712585449219),
(857, 'Garden Grove', 'CA', 'verified', 33.77606964111328, -117.93615722656250),
(858, 'La Verne', 'CA', 'verified', 34.11290359497070, -117.76525878906250),
(859, 'Chula Vista', 'CA', 'verified', 32.64089965820313, -117.08428192138672),
(860, 'Bonsall', 'CA', 'verified', 33.28620910644531, -117.24502563476562),
(861, 'Boron', 'CA', 'verified', 34.99945831298828, -117.64788055419922),
(862, 'Borrego Springs', 'CA', 'verified', 33.25653457641602, -116.37983703613281),
(863, 'Woodlake', 'CA', 'verified', 36.41647338867188, -119.09889221191406),
(864, 'Brawley', 'CA', 'verified', 32.97863006591797, -115.53460693359375),
(865, 'Brea', 'CA', 'verified', 33.91741943359375, -117.88821411132812),
(866, 'Hayward', 'CA', 'verified', 37.67119598388672, -122.08613586425781),
(867, 'Huntington Beach', 'CA', 'verified', 33.67889022827148, -118.00157165527344),
(868, 'Newark', 'CA', 'verified', 37.53639984130859, -122.02967834472656),
(869, 'King City', 'CA', 'verified', 36.21086120605469, -121.12660217285156),
(870, 'Canoga Park', 'CA', 'verified', 34.20196533203125, -118.60156250000000),
(871, 'Canyon Country', 'CA', 'verified', 34.41884231567383, -118.43953704833984),
(872, 'Monrovia', 'CA', 'verified', 34.14755630493164, -117.99877929687500),
(873, 'Ontario', 'CA', 'verified', 34.06457519531250, -117.64810180664062),
(874, 'San Juan Capistrano', 'CA', 'verified', 33.49789428710938, -117.66539764404297),
(875, 'Mission Viejo', 'CA', 'verified', 33.61941146850586, -117.67763519287110),
(876, 'Hoopa', 'CA', 'verified', 41.05224609375000, -123.67885589599610),
(877, 'San Bruno', 'CA', 'verified', 37.62442016601563, -122.41379547119140),
(878, 'Lower Lake', 'CA', 'verified', 38.91088104248047, -122.61225891113281),
(879, 'Belmont', 'CA', 'verified', 37.51834106445313, -122.27620697021484),
(880, 'Carlsbad', 'CA', 'verified', 33.16588592529297, -117.33822631835938),
(881, 'Carmel', 'CA', 'verified', 36.55442810058594, -121.92442321777344),
(882, 'Petaluma', 'CA', 'verified', 38.23247146606445, -122.64444732666016),
(883, 'Carpinteria', 'CA', 'verified', 34.38978958129883, -119.50330352783203),
(884, 'Slough House', 'CA', 'verified', 39.65064239501953, -121.02140808105469),
(885, 'Carson', 'CA', 'verified', 33.83161163330078, -118.26211547851562),
(886, 'Caruthers', 'CA', 'verified', 36.54718017578125, -119.83673858642578),
(887, 'Fowler', 'CA', 'verified', 36.62998580932617, -119.67834472656250),
(888, 'Orangevale', 'CA', 'verified', 38.67855453491211, -121.22994232177734),
(889, 'Dorris', 'CA', 'verified', 41.96684265136719, -121.91825866699219),
(890, 'Castro Valley', 'CA', 'verified', 37.69449615478516, -122.08589935302734),
(891, 'Cathedral City', 'CA', 'verified', 33.78101348876953, -116.46408081054688),
(892, 'North Fork', 'CA', 'verified', 37.22810745239258, -119.50968170166016),
(893, 'Corning', 'CA', 'verified', 39.92790985107422, -122.17906951904297),
(894, 'Escondido', 'CA', 'verified', 33.12316131591797, -117.08216857910156),
(895, 'Potter Valley', 'CA', 'verified', 39.32189178466797, -123.11002349853516),
(896, 'Marina', 'CA', 'verified', 36.68162155151367, -121.80230712890625),
(897, 'Santa Ana', 'CA', 'verified', 33.74958801269531, -117.87430572509766),
(898, 'Fresno', 'CA', 'verified', 36.74068450927734, -119.78573608398438),
(899, 'El Centro', 'CA', 'verified', 32.79580688476563, -115.56996917724610),
(900, 'Oroville', 'CA', 'verified', 39.51388168334961, -121.55610656738281),
(901, 'Soledad', 'CA', 'verified', 36.42843627929688, -121.32769012451172),
(902, 'Auburn', 'CA', 'verified', 38.89620590209961, -121.07887268066406),
(903, 'Oxnard', 'CA', 'verified', 34.20034027099609, -119.18044281005860),
(904, 'Ojai', 'CA', 'verified', 34.44382095336914, -119.24666595458984),
(905, 'El Cajon', 'CA', 'verified', 32.79494857788086, -116.95947265625000),
(906, 'Phelan', 'CA', 'verified', 34.42538833618164, -117.57254028320312),
(907, 'Temecula', 'CA', 'verified', 33.50248718261719, -117.16693115234375),
(908, 'Visalia', 'CA', 'verified', 36.33377075195313, -119.29291534423828),
(909, 'Covina', 'CA', 'verified', 34.08742523193359, -117.88902282714844),
(910, 'Chatsworth', 'CA', 'verified', 34.25724411010742, -118.59184265136719),
(911, 'Sugarloaf', 'CA', 'verified', 34.26241683959961, -116.82171630859375),
(912, 'Chico', 'CA', 'verified', 39.73200988769531, -121.84198760986328),
(913, 'Chino', 'CA', 'verified', 34.01280975341797, -117.68933105468750),
(914, 'Chino Hills', 'CA', 'verified', 33.99609756469727, -117.75806427001953),
(915, 'Perris', 'CA', 'verified', 33.78237152099609, -117.22734832763672),
(916, 'Chowchilla', 'CA', 'verified', 37.12319564819336, -120.25962066650390),
(917, 'Porterville', 'CA', 'verified', 36.07096481323242, -119.01618957519531),
(918, 'Claremont', 'CA', 'verified', 34.09609985351563, -117.71640777587890),
(919, 'Concord', 'CA', 'verified', 37.98081588745117, -122.02519226074219),
(920, 'Lakeport', 'CA', 'verified', 39.04352569580078, -122.91516113281250),
(921, 'Upper Lake', 'CA', 'verified', 39.16579437255859, -122.90897369384766),
(922, 'Cloverdale', 'CA', 'verified', 38.80609893798828, -123.01771545410156),
(923, 'Clovis', 'CA', 'verified', 36.82394790649414, -119.69658660888672),
(924, 'Coachella', 'CA', 'verified', 33.67909622192383, -116.17594909667969),
(925, 'Coalinga', 'CA', 'verified', 36.13702011108398, -120.36289215087890),
(926, 'Cambria', 'CA', 'verified', 35.55086135864258, -121.07206726074219),
(927, 'Coleville', 'CA', 'verified', 38.56830596923828, -119.50837707519531),
(928, 'Colfax', 'CA', 'verified', 39.09557342529297, -120.95070648193360),
(929, 'Pleasant Hill', 'CA', 'verified', 37.94795608520508, -122.06337738037110),
(930, 'Oakland', 'CA', 'verified', 37.80506515502930, -122.27302551269531),
(931, 'Downey', 'CA', 'verified', 33.94003677368164, -118.12823486328125),
(932, 'Colusa', 'CA', 'verified', 39.21419143676758, -122.00863647460938),
(933, 'Sunnyvale', 'CA', 'verified', 37.37161254882813, -122.03826141357422),
(934, 'Cialinga', 'CA', 'verified', 37.27187347412109, -119.27022552490234),
(935, 'Vallejo', 'CA', 'verified', 38.10083007812500, -122.25495147705078),
(936, 'Moorpark', 'CA', 'verified', 34.28689575195313, -118.88216400146484),
(937, 'Pacific Grove', 'CA', 'verified', 36.61933135986328, -121.91859436035156),
(938, 'Compton', 'CA', 'verified', 33.89528656005859, -118.22432708740234),
(939, 'Newbury Park', 'CA', 'verified', 34.18864059448242, -118.94055938720703),
(940, 'Tuolumne', 'CA', 'verified', 37.96468353271484, -120.23578643798828),
(941, 'Corcoran', 'CA', 'verified', 36.09804916381836, -119.55904388427734),
(942, 'Rancho Cordova', 'CA', 'verified', 38.57453918457031, -121.30350494384766),
(943, 'Newport Beach', 'CA', 'verified', 33.61683654785156, -117.93034362792969),
(944, 'Corona', 'CA', 'verified', 33.87789535522461, -117.57504272460938),
(945, 'West Covina', 'CA', 'verified', 34.07214736938477, -117.93802642822266),
(946, 'Coronado', 'CA', 'verified', 32.67618942260742, -117.17089080810547),
(947, 'Coulterville', 'CA', 'verified', 37.71102142333984, -120.19688415527344),
(948, 'Vacaville', 'CA', 'verified', 38.35135650634766, -121.99343109130860),
(949, 'Tulare', 'CA', 'verified', 36.20649337768555, -119.34304809570312),
(950, 'Susanville', 'CA', 'verified', 40.41566467285156, -120.64972686767578),
(951, 'Sonoma', 'CA', 'verified', 38.29188156127930, -122.45725250244140),
(952, 'Irvine', 'CA', 'verified', 33.68688583374023, -117.82534790039062),
(953, 'Murrieta', 'CA', 'verified', 33.55815124511719, -117.21148681640625),
(954, 'Culver City', 'CA', 'verified', 34.02161026000977, -118.39620971679688),
(955, 'Cupertino', 'CA', 'verified', 37.31884002685547, -122.02924346923828),
(956, 'Yettem', 'CA', 'verified', 36.48645019531250, -119.26528930664062),
(957, 'New Cuyama', 'CA', 'verified', 34.94764328002930, -119.68791961669922),
(958, 'Glendale', 'CA', 'verified', 34.14633178710938, -118.24836730957031),