PageRenderTime 1536ms CodeModel.GetById 374ms app.highlight 688ms RepoModel.GetById 116ms app.codeStats 8ms

/old/cvhousing/data/location_location.sql

https://github.com/srosro/HackerHouses
SQL | 8791 lines | 8767 code | 6 blank | 18 comment | 0 complexity | e9803ee0cdcab56e2e16fd41dee7cf8a MD5 | raw file

Large files files are truncated, but you can click here to view the full file

  1-- phpMyAdmin SQL Dump
  2-- version 2.11.3deb1ubuntu1.1
  3-- http://www.phpmyadmin.net
  4--
  5-- Host: localhost
  6-- Generation Time: Jun 13, 2009 at 07:13 PM
  7-- Server version: 5.0.51
  8-- PHP Version: 5.2.4-2ubuntu5.5
  9
 10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 11
 12--
 13-- Database: `omarish_cvh_dev`
 14--
 15
 16-- --------------------------------------------------------
 17
 18--
 19-- Table structure for table `location_location`
 20--
 21use cvh;
 22DROP TABLE IF EXISTS `location_location`;
 23CREATE TABLE IF NOT EXISTS `location_location` (
 24  `id` int(11) NOT NULL auto_increment,
 25  `zipcode` varchar(9) NOT NULL,
 26  `state` varchar(2) NOT NULL,
 27  `city` varchar(25) NOT NULL,
 28  `lat` double default NULL,
 29  `lng` double default NULL,
 30  PRIMARY KEY  (`id`)
 31) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33179 ;
 32
 33--
 34-- Dumping data for table `location_location`
 35--
 36
 37INSERT INTO `location_location` (`id`, `zipcode`, `state`, `city`, `lat`, `lng`) VALUES
 38(1, '35004', 'AL', 'Moody', 33.606379, -86.50249),
 39(2, '35005', 'AL', 'Adamsville', 33.592585, -86.95969),
 40(3, '35006', 'AL', 'Adger', 33.451714, -87.23957),
 41(4, '35007', 'AL', 'Alabaster', 33.232422, -86.80871),
 42(5, '35010', 'AL', 'AlexanderCity', 32.903432, -85.92669),
 43(6, '35014', 'AL', 'Alpine', 33.35596, -86.2772),
 44(7, '35016', 'AL', 'Arab', 34.323715, -86.49278),
 45(8, '35019', 'AL', 'Baileyton', 34.29254, -86.63505),
 46(9, '35020', 'AL', 'Bessemer', 33.405559, -86.95141),
 47(10, '35022', 'AL', 'Bessemer', 33.346817, -86.95252),
 48(11, '35023', 'AL', 'Bessemer', 33.443039, -87.0193),
 49(12, '35031', 'AL', 'Blountsville', 34.111425, -86.5338),
 50(13, '35033', 'AL', 'Bremen', 33.952939, -87.02889),
 51(14, '35034', 'AL', 'Brent', 32.915182, -87.21488),
 52(15, '35035', 'AL', 'Brierfield', 33.041166, -86.95117),
 53(16, '35036', 'AL', 'Brookside', 33.63815, -86.91956),
 54(17, '35040', 'AL', 'Calera', 33.107572, -86.74996),
 55(18, '35042', 'AL', 'Centreville', 32.963486, -87.13867),
 56(19, '35043', 'AL', 'Chelsea', 33.317093, -86.66295),
 57(20, '35044', 'AL', 'Childersburg', 33.268471, -86.35582),
 58(21, '35045', 'AL', 'Clanton', 32.834501, -86.64355),
 59(22, '35046', 'AL', 'Clanton', 32.894351, -86.56504),
 60(23, '35049', 'AL', 'Cleveland', 33.963435, -86.5954),
 61(24, '35051', 'AL', 'Columbiana', 33.201789, -86.61584),
 62(25, '35052', 'AL', 'CookSprings', 33.593115, -86.4084),
 63(26, '35053', 'AL', 'CraneHill', 34.041061, -87.06771),
 64(27, '35054', 'AL', 'Cropwell', 33.506012, -86.31547),
 65(28, '35055', 'AL', 'Cullman', 34.167893, -86.82506),
 66(29, '35057', 'AL', 'Cullman', 34.139198, -86.92449),
 67(30, '35058', 'AL', 'Cullman', 34.223732, -86.7562),
 68(31, '35060', 'AL', 'Docena', 33.559455, -86.92968),
 69(32, '35061', 'AL', 'Dolomite', 33.462541, -86.95736),
 70(33, '35062', 'AL', 'Dora', 33.731278, -87.0361),
 71(34, '35063', 'AL', 'Empire', 33.805216, -87.00192),
 72(35, '35064', 'AL', 'Fairfield', 33.476908, -86.91684),
 73(36, '35068', 'AL', 'Fultondale', 33.611297, -86.81518),
 74(37, '35070', 'AL', 'GardenCity', 34.011027, -86.74877),
 75(38, '35071', 'AL', 'Gardendale', 33.67933, -86.8206),
 76(39, '35072', 'AL', 'Goodwater', 33.089342, -86.04682),
 77(40, '35073', 'AL', 'Graysville', 33.640865, -86.96885),
 78(41, '35074', 'AL', 'GreenPond', 33.22584, -87.12515),
 79(42, '35077', 'AL', 'Hanceville', 34.043589, -86.80644),
 80(43, '35078', 'AL', 'Harpersville', 33.337092, -86.44085),
 81(44, '35079', 'AL', 'Hayden', 33.922179, -86.7607),
 82(45, '35080', 'AL', 'Helena', 33.280625, -86.88411),
 83(46, '35082', 'AL', 'Hollins', 33.116909, -86.1698),
 84(47, '35083', 'AL', 'HollyPond', 34.198738, -86.59814),
 85(48, '35085', 'AL', 'Jemison', 32.96512, -86.74405),
 86(49, '35087', 'AL', 'Joppa', 34.303718, -86.58323),
 87(50, '35089', 'AL', 'Kellyton', 32.941708, -86.06098),
 88(51, '35091', 'AL', 'Kimberly', 33.77109, -86.80672),
 89(52, '35094', 'AL', 'Leeds', 33.530698, -86.55506),
 90(53, '35096', 'AL', 'Lincoln', 33.605233, -86.12079),
 91(54, '35097', 'AL', 'LocustFork', 33.896526, -86.63056),
 92(55, '35098', 'AL', 'Logan', 34.120006, -87.05075),
 93(56, '350HH', 'AL', '', 33.464476, -86.57757),
 94(57, '350XX', 'AL', '', 32.978292, -86.49926),
 95(58, '35111', 'AL', 'McCalla', 33.279946, -87.10148),
 96(59, '35112', 'AL', 'Margaret', 33.681899, -86.48237),
 97(60, '35114', 'AL', 'Maylene', 33.225377, -86.86443),
 98(61, '35115', 'AL', 'Montevallo', 33.114972, -86.8738),
 99(62, '35116', 'AL', 'Morris', 33.74137, -86.78543),
100(63, '35117', 'AL', 'MountOlive', 33.665823, -86.87111),
101(64, '35118', 'AL', 'Mulga', 33.529224, -87.01546),
102(65, '35119', 'AL', 'NewCastle', 33.640823, -86.77574),
103(66, '35120', 'AL', 'Odenville', 33.668341, -86.43641),
104(67, '35121', 'AL', 'Oneonta', 33.944897, -86.45813),
105(68, '35124', 'AL', 'Pelham', 33.317471, -86.78726),
106(69, '35125', 'AL', 'PellCity', 33.606663, -86.28912),
107(70, '35126', 'AL', 'Pinson', 33.728568, -86.66052),
108(71, '35127', 'AL', 'PleasantGrove', 33.487675, -86.97331),
109(72, '35128', 'AL', 'PellCity', 33.561597, -86.30285),
110(73, '35130', 'AL', 'Quinton', 33.640629, -87.11584),
111(74, '35131', 'AL', 'Ragland', 33.721107, -86.17492),
112(75, '35133', 'AL', 'Remlap', 33.827521, -86.60703),
113(76, '35135', 'AL', 'Riverside', 33.614465, -86.20067),
114(77, '35136', 'AL', 'Rockford', 32.8697, -86.2822),
115(78, '35139', 'AL', 'Sayre', 33.712204, -86.97203),
116(79, '35143', 'AL', 'Shelby', 33.080971, -86.53875),
117(80, '35146', 'AL', 'Springville', 33.781133, -86.45052),
118(81, '35147', 'AL', 'Sterrett', 33.397441, -86.54218),
119(82, '35148', 'AL', 'Sumiton', 33.753474, -87.04756),
120(83, '35149', 'AL', 'Sycamore', 33.252906, -86.20523),
121(84, '35150', 'AL', 'Sylacauga', 33.185782, -86.25105),
122(85, '35151', 'AL', 'Sylacauga', 33.137515, -86.33414),
123(86, '35160', 'AL', 'Talladega', 33.415449, -86.10908),
124(87, '35171', 'AL', 'Thorsby', 32.907616, -86.71868),
125(88, '35172', 'AL', 'Trafford', 33.823416, -86.71537),
126(89, '35173', 'AL', 'Trussville', 33.623485, -86.58546),
127(90, '35175', 'AL', 'UnionGrove', 34.426844, -86.51841),
128(91, '35176', 'AL', 'Vandiver', 33.4776, -86.5126),
129(92, '35178', 'AL', 'Vincent', 33.414831, -86.3925),
130(93, '35179', 'AL', 'Vinemont', 34.256106, -86.92158),
131(94, '35180', 'AL', 'Warrior', 33.82343, -86.81569),
132(95, '35183', 'AL', 'Weogufka', 33.016558, -86.33936),
133(96, '35184', 'AL', 'WestBlocton', 33.118259, -87.13548),
134(97, '35186', 'AL', 'Wilsonville', 33.241272, -86.50614),
135(98, '35188', 'AL', 'Woodstock', 33.195743, -87.16252),
136(99, '351HH', 'AL', '', 33.464016, -86.57741),
137(100, '351XX', 'AL', '', 32.953689, -86.38354),
138(101, '35203', 'AL', 'Birmingham', 33.519055, -86.8097),
139(102, '35204', 'AL', 'Birmingham', 33.519855, -86.83534),
140(103, '35205', 'AL', 'Birmingham', 33.497055, -86.8057),
141(104, '35206', 'AL', 'Birmingham', 33.568573, -86.72163),
142(105, '35207', 'AL', 'Birmingham', 33.560652, -86.81897),
143(106, '35208', 'AL', 'Birmingham', 33.494545, -86.88115),
144(107, '35209', 'AL', 'Birmingham', 33.468306, -86.80814),
145(108, '35210', 'AL', 'Birmingham', 33.546051, -86.66963),
146(109, '35211', 'AL', 'Birmingham', 33.479306, -86.85878),
147(110, '35212', 'AL', 'Birmingham', 33.542004, -86.74896),
148(111, '35213', 'AL', 'Birmingham', 33.507637, -86.74161),
149(112, '35214', 'AL', 'Birmingham', 33.558772, -86.89199),
150(113, '35215', 'AL', 'Birmingham', 33.636102, -86.69506),
151(114, '35216', 'AL', 'Birmingham', 33.420558, -86.78489),
152(115, '35217', 'AL', 'Birmingham', 33.590003, -86.76708),
153(116, '35218', 'AL', 'Birmingham', 33.506456, -86.89524),
154(117, '35221', 'AL', 'Birmingham', 33.450267, -86.8965),
155(118, '35222', 'AL', 'Birmingham', 33.524254, -86.77335),
156(119, '35223', 'AL', 'Birmingham', 33.488355, -86.73402),
157(120, '35224', 'AL', 'Birmingham', 33.517706, -86.93189),
158(121, '35226', 'AL', 'Birmingham', 33.406409, -86.8295),
159(122, '35228', 'AL', 'Birmingham', 33.454262, -86.92273),
160(123, '35233', 'AL', 'Birmingham', 33.509623, -86.7997),
161(124, '35234', 'AL', 'Birmingham', 33.538504, -86.80602),
162(125, '35235', 'AL', 'Birmingham', 33.609779, -86.65507),
163(126, '35242', 'AL', 'Birmingham', 33.409582, -86.69684),
164(127, '35243', 'AL', 'Birmingham', 33.437667, -86.74586),
165(128, '35244', 'AL', 'Birmingham', 33.356981, -86.81577),
166(129, '352HH', 'AL', '', 33.522499, -86.64097),
167(130, '35401', 'AL', 'Tuscaloosa', 33.193818, -87.56843),
168(131, '35403', 'AL', 'Tuscaloosa', 33.205073, -87.52749),
169(132, '35404', 'AL', 'Tuscaloosa', 33.217168, -87.49461),
170(133, '35405', 'AL', 'Tuscaloosa', 33.149246, -87.52303),
171(134, '35406', 'AL', 'Tuscaloosa', 33.271585, -87.50611),
172(135, '35441', 'AL', 'Akron', 32.871514, -87.73326),
173(136, '35442', 'AL', 'Aliceville', 33.095505, -88.18653),
174(137, '35443', 'AL', 'Boligee', 32.772835, -88.0321),
175(138, '35444', 'AL', 'Brookwood', 33.276411, -87.3052),
176(139, '35446', 'AL', 'Buhl', 33.207547, -87.75054),
177(140, '35447', 'AL', 'Carrollton', 33.254197, -88.16866),
178(141, '35452', 'AL', 'Coker', 33.249332, -87.67217),
179(142, '35453', 'AL', 'Cottondale', 33.170357, -87.39889),
180(143, '35456', 'AL', 'Duncanville', 33.068806, -87.43974),
181(144, '35457', 'AL', 'Echola', 33.301003, -87.77187),
182(145, '35458', 'AL', 'Elrod', 33.274081, -87.80211),
183(146, '35459', 'AL', 'Emelle', 32.80728, -88.31069),
184(147, '35460', 'AL', 'Epes', 32.716468, -88.15261),
185(148, '35461', 'AL', 'Ethelsville', 33.421827, -88.22013),
186(149, '35462', 'AL', 'Eutaw', 32.931143, -87.93837),
187(150, '35463', 'AL', 'Fosters', 33.081289, -87.68988),
188(151, '35464', 'AL', 'Gainesville', 32.811241, -88.1648),
189(152, '35466', 'AL', 'Gordo', 33.299935, -87.88368),
190(153, '35469', 'AL', 'Knoxville', 33.012557, -87.79793),
191(154, '35470', 'AL', 'Livingston', 32.558949, -88.12485),
192(155, '35471', 'AL', 'McShan', 33.402134, -88.14732),
193(156, '35473', 'AL', 'Northport', 33.260567, -87.58945),
194(157, '35474', 'AL', 'Moundville', 32.962981, -87.61717),
195(158, '35475', 'AL', 'Northport', 33.388654, -87.57913),
196(159, '35476', 'AL', 'Northport', 33.227736, -87.58819),
197(160, '35477', 'AL', 'Panola', 32.915891, -88.25764),
198(161, '35480', 'AL', 'Ralph', 33.102981, -87.83382),
199(162, '35481', 'AL', 'Reform', 33.399471, -88.02086),
200(163, '35490', 'AL', 'Vance', 33.197284, -87.25156),
201(164, '354HH', 'AL', '', 33.163724, -87.69916),
202(165, '354XX', 'AL', '', 32.715432, -87.9776),
203(166, '35501', 'AL', 'Jasper', 33.828412, -87.27632),
204(167, '35503', 'AL', 'Jasper', 33.907546, -87.29957),
205(168, '35504', 'AL', 'Jasper', 33.883566, -87.2125),
206(169, '35540', 'AL', 'Addison', 34.223057, -87.17232),
207(170, '35541', 'AL', 'Arley', 34.059527, -87.18344),
208(171, '35542', 'AL', 'Bankston', 33.703682, -87.67155),
209(172, '35543', 'AL', 'BearCreek', 34.247898, -87.72171),
210(173, '35544', 'AL', 'Beaverton', 33.939291, -88.01367),
211(174, '35545', 'AL', 'Belk', 33.641227, -87.92911),
212(175, '35546', 'AL', 'Berry', 33.628719, -87.58251),
213(176, '35548', 'AL', 'Brilliant', 34.043457, -87.7594),
214(177, '35549', 'AL', 'CarbonHill', 33.87798, -87.52728),
215(178, '35550', 'AL', 'Cordova', 33.754767, -87.16587),
216(179, '35552', 'AL', 'Detroit', 34.061266, -88.15462),
217(180, '35553', 'AL', 'DoubleSprings', 34.146713, -87.39317),
218(181, '35554', 'AL', 'Eldridge', 33.903299, -87.65194),
219(182, '35555', 'AL', 'Fayette', 33.681768, -87.83026),
220(183, '35559', 'AL', 'GlenAllen', 33.909001, -87.73186),
221(184, '35563', 'AL', 'Guin', 33.972007, -87.90302),
222(185, '35564', 'AL', 'Hackleburg', 34.262751, -87.83441),
223(186, '35565', 'AL', 'Haleyville', 34.225425, -87.6118),
224(187, '35570', 'AL', 'Hamilton', 34.149717, -88.00384),
225(188, '35571', 'AL', 'Hodges', 34.341907, -87.94612),
226(189, '35572', 'AL', 'Houston', 34.16678, -87.26526),
227(190, '35574', 'AL', 'Kennedy', 33.586897, -87.97695),
228(191, '35575', 'AL', 'Lynn', 34.049426, -87.57065),
229(192, '35576', 'AL', 'Millport', 33.581135, -88.10835),
230(193, '35578', 'AL', 'Nauvoo', 33.97173, -87.45746),
231(194, '35579', 'AL', 'Oakman', 33.673236, -87.37169),
232(195, '35580', 'AL', 'Parrish', 33.701484, -87.27103),
233(196, '35581', 'AL', 'PhilCampbell', 34.343017, -87.71277),
234(197, '35582', 'AL', 'RedBay', 34.448328, -88.12041),
235(198, '35584', 'AL', 'Sipsey', 33.823683, -87.08699),
236(199, '35585', 'AL', 'SprucePine', 34.428048, -87.80695),
237(200, '35586', 'AL', 'Sulligent', 33.864591, -88.13117),
238(201, '35587', 'AL', 'Townley', 33.807412, -87.446),
239(202, '35592', 'AL', 'Vernon', 33.752857, -88.0996),
240(203, '35593', 'AL', 'Vina', 34.369264, -88.06745),
241(204, '35594', 'AL', 'Winfield', 33.925454, -87.78949),
242(205, '355HH', 'AL', '', 34.100013, -87.32392),
243(206, '355XX', 'AL', '', 34.327834, -87.44986),
244(207, '35601', 'AL', 'Decatur', 34.595332, -86.98786),
245(208, '35603', 'AL', 'Decatur', 34.539072, -86.95732),
246(209, '35610', 'AL', 'Anderson', 34.944113, -87.24921),
247(210, '35611', 'AL', 'Athens', 34.784028, -87.02767),
248(211, '35613', 'AL', 'Athens', 34.808165, -86.89623),
249(212, '35614', 'AL', 'Athens', 34.860179, -87.06231),
250(213, '35616', 'AL', 'Cherokee', 34.748498, -87.9986),
251(214, '35618', 'AL', 'Courtland', 34.665033, -87.30978),
252(215, '35619', 'AL', 'Danville', 34.404908, -87.12915),
253(216, '35620', 'AL', 'Elkmont', 34.930354, -86.9809),
254(217, '35621', 'AL', 'Eva', 34.334972, -86.71847),
255(218, '35622', 'AL', 'Falkville', 34.340484, -86.89176),
256(219, '35630', 'AL', 'Florence', 34.817537, -87.66253),
257(220, '35633', 'AL', 'Florence', 34.898897, -87.77379),
258(221, '35634', 'AL', 'Florence', 34.888897, -87.60731),
259(222, '35640', 'AL', 'Hartselle', 34.442184, -86.94027),
260(223, '35643', 'AL', 'Hillsboro', 34.648768, -87.20394),
261(224, '35645', 'AL', 'Killen', 34.904208, -87.50776),
262(225, '35646', 'AL', 'Leighton', 34.660322, -87.53577),
263(226, '35647', 'AL', 'Lester', 34.967939, -87.11732),
264(227, '35648', 'AL', 'Lexington', 34.966009, -87.38262),
265(228, '35649', 'AL', 'Mooresville', 34.625704, -86.8784),
266(229, '35650', 'AL', 'Moulton', 34.496476, -87.27802),
267(230, '35651', 'AL', 'MountHope', 34.476048, -87.48875),
268(231, '35652', 'AL', 'Rogersville', 34.843309, -87.29937),
269(232, '35653', 'AL', 'Russellville', 34.519453, -87.78077),
270(233, '35654', 'AL', 'Russellville', 34.516472, -87.65265),
271(234, '35660', 'AL', 'Sheffield', 34.759738, -87.69317),
272(235, '35661', 'AL', 'MuscleShoals', 34.759947, -87.62705),
273(236, '35670', 'AL', 'Somerville', 34.481885, -86.7525),
274(237, '35671', 'AL', 'Tanner', 34.67373, -86.94986),
275(238, '35672', 'AL', 'TownCreek', 34.64248, -87.41166),
276(239, '35673', 'AL', 'Trinity', 34.581591, -87.11884),
277(240, '35674', 'AL', 'Tuscumbia', 34.70017, -87.7142),
278(241, '35677', 'AL', 'Waterloo', 34.950648, -88.02603),
279(242, '356HH', 'AL', '', 34.78251, -87.31906),
280(243, '356XX', 'AL', '', 34.339055, -87.3972),
281(244, '35739', 'AL', 'Ardmore', 34.972309, -86.81352),
282(245, '35740', 'AL', 'Bridgeport', 34.943871, -85.73077),
283(246, '35741', 'AL', 'Brownsboro', 34.720813, -86.48932),
284(247, '35742', 'AL', 'Capshaw', 34.813577, -86.80405),
285(248, '35744', 'AL', 'Dutton', 34.610055, -85.91553),
286(249, '35745', 'AL', 'Estillfork', 34.929269, -86.20726),
287(250, '35746', 'AL', 'Fackler', 34.830058, -85.97048),
288(251, '35747', 'AL', 'Grant', 34.500216, -86.27889),
289(252, '35748', 'AL', 'Gurley', 34.710942, -86.38995),
290(253, '35749', 'AL', 'Harvest', 34.815817, -86.76003),
291(254, '35750', 'AL', 'HazelGreen', 34.948321, -86.58988),
292(255, '35751', 'AL', 'Hollytree', 34.815033, -86.27258),
293(256, '35752', 'AL', 'Hollywood', 34.745259, -85.94729),
294(257, '35754', 'AL', 'LaceysSpring', 34.520438, -86.61977),
295(258, '35755', 'AL', 'Langston', 34.501178, -86.11516),
296(259, '35756', 'AL', 'Madison', 34.630103, -86.80159),
297(260, '35757', 'AL', 'Madison', 34.776638, -86.75164),
298(261, '35758', 'AL', 'Madison', 34.715065, -86.73964),
299(262, '35759', 'AL', 'Meridianville', 34.863236, -86.56137),
300(263, '35760', 'AL', 'NewHope', 34.541285, -86.39852),
301(264, '35761', 'AL', 'NewMarket', 34.902137, -86.44272),
302(265, '35763', 'AL', 'OwensCrossRoads', 34.624533, -86.47069),
303(266, '35764', 'AL', 'PaintRock', 34.694662, -86.31816),
304(267, '35765', 'AL', 'Pisgah', 34.695645, -85.80484),
305(268, '35766', 'AL', 'Princeton', 34.842944, -86.23149),
306(269, '35768', 'AL', 'Scottsboro', 34.712327, -86.08387),
307(270, '35769', 'AL', 'Scottsboro', 34.606124, -86.06464),
308(271, '35771', 'AL', 'Section', 34.546397, -85.98279),
309(272, '35772', 'AL', 'Stevenson', 34.877531, -85.84528),
310(273, '35773', 'AL', 'Toney', 34.90267, -86.71367),
311(274, '35774', 'AL', 'Trenton', 34.752369, -86.22634),
312(275, '35775', 'AL', 'ValhermosoSprings', 34.550375, -86.70576),
313(276, '35776', 'AL', 'Woodville', 34.664895, -86.23363),
314(277, '357HH', 'AL', '', 34.62713, -86.12504),
315(278, '357XX', 'AL', '', 34.634355, -86.71051),
316(279, '35801', 'AL', 'Huntsville', 34.72879, -86.57316),
317(280, '35802', 'AL', 'Huntsville', 34.666041, -86.55929),
318(281, '35803', 'AL', 'Huntsville', 34.603017, -86.54293),
319(282, '35805', 'AL', 'Huntsville', 34.711291, -86.61691),
320(283, '35806', 'AL', 'Huntsville', 34.748066, -86.68317),
321(284, '35808', 'AL', 'Huntsville', 34.623075, -86.6647),
322(285, '35810', 'AL', 'Huntsville', 34.77624, -86.61339),
323(286, '35811', 'AL', 'Huntsville', 34.78108, -86.53163),
324(287, '35816', 'AL', 'Huntsville', 34.73969, -86.62464),
325(288, '35824', 'AL', 'Huntsville', 34.654126, -86.73987),
326(289, '358HH', 'AL', '', 34.583728, -86.59332),
327(290, '358XX', 'AL', '', 34.646512, -86.6285),
328(291, '35901', 'AL', 'Gadsden', 34.016747, -85.99282),
329(292, '35903', 'AL', 'Gadsden', 33.996698, -85.92496),
330(293, '35904', 'AL', 'Gadsden', 34.032097, -86.0353),
331(294, '35905', 'AL', 'Gadsden', 33.942031, -85.93993),
332(295, '35906', 'AL', 'RainbowCity', 33.943964, -86.06154),
333(296, '35907', 'AL', 'Gadsden', 33.906415, -86.02665),
334(297, '35950', 'AL', 'Albertville', 34.261878, -86.22835),
335(298, '35951', 'AL', 'Albertville', 34.313014, -86.19282),
336(299, '35952', 'AL', 'Altoona', 34.057496, -86.32225),
337(300, '35953', 'AL', 'Ashville', 33.825516, -86.24231),
338(301, '35954', 'AL', 'Attalla', 34.043263, -86.08904),
339(302, '35956', 'AL', 'Boaz', 34.155318, -86.13237),
340(303, '35957', 'AL', 'Boaz', 34.203621, -86.1728),
341(304, '35958', 'AL', 'Bryant', 34.921827, -85.63784),
342(305, '35959', 'AL', 'CedarBluff', 34.237989, -85.61277),
343(306, '35960', 'AL', 'Centre', 34.141067, -85.60472),
344(307, '35961', 'AL', 'Collinsville', 34.279268, -85.85634),
345(308, '35962', 'AL', 'Crossville', 34.297717, -86.036),
346(309, '35963', 'AL', 'Dawson', 34.359766, -85.92825),
347(310, '35966', 'AL', 'FlatRock', 34.788306, -85.67642),
348(311, '35967', 'AL', 'FortPayne', 34.429472, -85.71078),
349(312, '35968', 'AL', 'FortPayne', 34.460537, -85.76744),
350(313, '35971', 'AL', 'Fyffe', 34.457657, -85.92772),
351(314, '35972', 'AL', 'Gallant', 33.987653, -86.25523),
352(315, '35973', 'AL', 'Gaylesville', 34.333048, -85.55172),
353(316, '35974', 'AL', 'Geraldine', 34.361787, -86.0098),
354(317, '35975', 'AL', 'Groveoak', 34.431683, -86.06169),
355(318, '35976', 'AL', 'Guntersville', 34.350835, -86.30475),
356(319, '35978', 'AL', 'Henagar', 34.637589, -85.73274),
357(320, '35979', 'AL', 'Higdon', 34.831242, -85.61564),
358(321, '35980', 'AL', 'Horton', 34.179277, -86.36882),
359(322, '35981', 'AL', 'Ider', 34.717362, -85.65353),
360(323, '35983', 'AL', 'Leesburg', 34.189256, -85.76816),
361(324, '35984', 'AL', 'Mentone', 34.557735, -85.5751),
362(325, '35986', 'AL', 'Rainsville', 34.500878, -85.83763),
363(326, '35987', 'AL', 'Steele', 33.9117, -86.24408),
364(327, '35988', 'AL', 'Sylvania', 34.56838, -85.79646),
365(328, '35989', 'AL', 'ValleyHead', 34.5852, -85.65125),
366(329, '35990', 'AL', 'WalnutGrove', 34.066644, -86.30438),
367(330, '359HH', 'AL', '', 34.068431, -85.90095),
368(331, '36003', 'AL', 'Autaugaville', 32.439967, -86.68801),
369(332, '36005', 'AL', 'Banks', 31.859531, -85.75558),
370(333, '36006', 'AL', 'Billingsley', 32.65279, -86.7143),
371(334, '36009', 'AL', 'Brantley', 31.579451, -86.3188),
372(335, '36010', 'AL', 'Brundidge', 31.678393, -85.82425),
373(336, '36013', 'AL', 'Cecil', 32.295289, -85.99653),
374(337, '36016', 'AL', 'Clayton', 31.843675, -85.43298),
375(338, '36017', 'AL', 'Clio', 31.692576, -85.55787),
376(339, '36020', 'AL', 'Coosada', 32.496067, -86.33073),
377(340, '36022', 'AL', 'Deatsville', 32.612619, -86.39497),
378(341, '36024', 'AL', 'Eclectic', 32.697561, -86.016),
379(342, '36025', 'AL', 'Elmore', 32.538878, -86.33358),
380(343, '36026', 'AL', 'Equality', 32.776549, -86.0477),
381(344, '36027', 'AL', 'Eufaula', 31.876168, -85.17362),
382(345, '36028', 'AL', 'Dozier', 31.474803, -86.37618),
383(346, '36029', 'AL', 'Fitzpatrick', 32.214818, -85.93281),
384(347, '36030', 'AL', 'ForestHome', 31.847964, -86.86441),
385(348, '36031', 'AL', 'FortDavis', 32.251957, -85.73589),
386(349, '36032', 'AL', 'FortDeposit', 31.984289, -86.57087),
387(350, '36033', 'AL', 'Georgiana', 31.655458, -86.76737),
388(351, '36034', 'AL', 'Glenwood', 31.637696, -86.13578),
389(352, '36035', 'AL', 'Goshen', 31.756986, -86.14489),
390(353, '36036', 'AL', 'Grady', 31.985456, -86.15741),
391(354, '36037', 'AL', 'Greenville', 31.8007, -86.60591),
392(355, '36039', 'AL', 'Hardaway', 32.28032, -85.81979),
393(356, '36040', 'AL', 'Hayneville', 32.182677, -86.66877),
394(357, '36041', 'AL', 'HighlandHome', 31.913456, -86.30083),
395(358, '36042', 'AL', 'Honoraville', 31.860078, -86.44607),
396(359, '36043', 'AL', 'HopeHull', 32.22381, -86.39798),
397(360, '36046', 'AL', 'Lapine', 32.025367, -86.34182),
398(361, '36047', 'AL', 'Letohatchee', 32.070433, -86.49437),
399(362, '36048', 'AL', 'Louisville', 31.776734, -85.58908),
400(363, '36049', 'AL', 'Luverne', 31.737407, -86.26946),
401(364, '36051', 'AL', 'Marbury', 32.682598, -86.47451),
402(365, '36052', 'AL', 'Mathews', 32.171705, -86.06661),
403(366, '36053', 'AL', 'Midway', 32.011153, -85.46827),
404(367, '36054', 'AL', 'Millbrook', 32.492335, -86.36692),
405(368, '36064', 'AL', 'PikeRoad', 32.318234, -86.09585),
406(369, '36065', 'AL', 'PineLevel', 32.042813, -86.0514),
407(370, '36066', 'AL', 'Prattville', 32.459435, -86.42746),
408(371, '36067', 'AL', 'Prattville', 32.488113, -86.52962),
409(372, '36069', 'AL', 'Ramer', 32.07955, -86.14911),
410(373, '36071', 'AL', 'Rutledge', 31.708837, -86.38617),
411(374, '36075', 'AL', 'Shorter', 32.399994, -85.9237),
412(375, '36078', 'AL', 'Tallassee', 32.553036, -85.9136),
413(376, '36079', 'AL', 'Troy', 31.780847, -85.992),
414(377, '36080', 'AL', 'Titus', 32.691057, -86.29429),
415(378, '36081', 'AL', 'Troy', 31.852825, -85.92314),
416(379, '36083', 'AL', 'Tuskegee', 32.427987, -85.69542),
417(380, '36088', 'AL', 'TuskegeeInstitute', 32.419862, -85.71699),
418(381, '36089', 'AL', 'UnionSprings', 32.145437, -85.70998),
419(382, '36091', 'AL', 'Verbena', 32.759543, -86.51111),
420(383, '36092', 'AL', 'Wetumpka', 32.592889, -86.21902),
421(384, '36093', 'AL', 'Wetumpka', 32.505741, -86.15644),
422(385, '360HH', 'AL', '', 32.451844, -85.87781),
423(386, '360XX', 'AL', '', 31.728209, -86.53667),
424(387, '36104', 'AL', 'Montgomery', 32.377509, -86.31068),
425(388, '36105', 'AL', 'Montgomery', 32.30234, -86.30504),
426(389, '36106', 'AL', 'Montgomery', 32.354888, -86.27161),
427(390, '36107', 'AL', 'Montgomery', 32.378138, -86.27905),
428(391, '36108', 'AL', 'Montgomery', 32.353188, -86.36037),
429(392, '36109', 'AL', 'Montgomery', 32.386088, -86.24511),
430(393, '36110', 'AL', 'Montgomery', 32.426372, -86.27007),
431(394, '36111', 'AL', 'Montgomery', 32.338989, -86.27316),
432(395, '36113', 'AL', 'Montgomery', 32.359588, -86.34434),
433(396, '36115', 'AL', 'Montgomery', 32.404754, -86.24963),
434(397, '36116', 'AL', 'Montgomery', 32.31324, -86.23672),
435(398, '36117', 'AL', 'Montgomery', 32.373714, -86.16443),
436(399, '361HH', 'AL', '', 32.384675, -86.32983),
437(400, '36201', 'AL', 'Anniston', 33.658803, -85.85178),
438(401, '36203', 'AL', 'Oxford', 33.591301, -85.83571),
439(402, '36205', 'AL', 'Anniston', 33.711314, -85.78527),
440(403, '36206', 'AL', 'Anniston', 33.719701, -85.83166),
441(404, '36207', 'AL', 'Anniston', 33.651673, -85.75895),
442(405, '36250', 'AL', 'Alexandria', 33.766057, -85.88969),
443(406, '36251', 'AL', 'Ashland', 33.243964, -85.84503),
444(407, '36255', 'AL', 'Cragford', 33.185338, -85.72548),
445(408, '36256', 'AL', 'Daviston', 33.032076, -85.69962),
446(409, '36258', 'AL', 'Delta', 33.473789, -85.71409),
447(410, '36260', 'AL', 'Eastaboga', 33.593189, -85.99551),
448(411, '36262', 'AL', 'Fruithurst', 33.761052, -85.45227),
449(412, '36263', 'AL', 'Graham', 33.469709, -85.36139),
450(413, '36264', 'AL', 'Heflin', 33.613541, -85.55457),
451(414, '36265', 'AL', 'Jacksonville', 33.824496, -85.77037),
452(415, '36266', 'AL', 'Lineville', 33.328958, -85.72073),
453(416, '36267', 'AL', 'Millerville', 33.200704, -85.94159),
454(417, '36268', 'AL', 'Munford', 33.51179, -85.94756),
455(418, '36269', 'AL', 'Muscadine', 33.740158, -85.37813),
456(419, '36270', 'AL', 'Newell', 33.423088, -85.47202),
457(420, '36271', 'AL', 'Ohatchee', 33.79933, -86.0286),
458(421, '36272', 'AL', 'Piedmont', 33.948018, -85.61491),
459(422, '36273', 'AL', 'Ranburne', 33.535491, -85.36312),
460(423, '36274', 'AL', 'Roanoke', 33.159848, -85.36865),
461(424, '36276', 'AL', 'Wadley', 33.142612, -85.57418),
462(425, '36277', 'AL', 'Weaver', 33.754308, -85.81991),
463(426, '36278', 'AL', 'Wedowee', 33.338853, -85.509),
464(427, '36279', 'AL', 'Wellington', 33.862349, -85.89512),
465(428, '36280', 'AL', 'Woodland', 33.366136, -85.36501),
466(429, '362HH', 'AL', '', 33.279589, -85.61856),
467(430, '362XX', 'AL', '', 33.711116, -85.88805),
468(431, '36301', 'AL', 'Dothan', 31.180076, -85.4045),
469(432, '36303', 'AL', 'Dothan', 31.249042, -85.40605),
470(433, '36305', 'AL', 'Dothan', 31.214832, -85.47402),
471(434, '36310', 'AL', 'Abbeville', 31.599256, -85.2094),
472(435, '36311', 'AL', 'Ariton', 31.589226, -85.69097),
473(436, '36312', 'AL', 'Ashford', 31.178688, -85.2429),
474(437, '36313', 'AL', 'Bellwood', 31.174249, -85.79562),
475(438, '36314', 'AL', 'Black', 31.013308, -85.75742),
476(439, '36316', 'AL', 'Chancellor', 31.172641, -85.86482),
477(440, '36317', 'AL', 'Clopton', 31.645125, -85.37812),
478(441, '36318', 'AL', 'CoffeeSprings', 31.16782, -85.94917),
479(442, '36319', 'AL', 'Columbia', 31.312599, -85.14456),
480(443, '36320', 'AL', 'Cottonwood', 31.051843, -85.31561),
481(444, '36322', 'AL', 'Daleville', 31.284499, -85.72111),
482(445, '36323', 'AL', 'Elba', 31.428389, -86.07271),
483(446, '36330', 'AL', 'Enterprise', 31.32579, -85.84117),
484(447, '36340', 'AL', 'Geneva', 31.043454, -85.87941),
485(448, '36343', 'AL', 'Gordon', 31.087556, -85.13116),
486(449, '36344', 'AL', 'Hartford', 31.096994, -85.7001),
487(450, '36345', 'AL', 'Headland', 31.381263, -85.3149),
488(451, '36346', 'AL', 'Jack', 31.567171, -85.93102),
489(452, '36350', 'AL', 'MidlandCity', 31.319083, -85.48718),
490(453, '36351', 'AL', 'NewBrockton', 31.406536, -85.9175),
491(454, '36352', 'AL', 'Newton', 31.262955, -85.60789),
492(455, '36353', 'AL', 'Newville', 31.453069, -85.36241),
493(456, '36360', 'AL', 'Ozark', 31.447119, -85.62908),
494(457, '36362', 'AL', 'FortRucker', 31.352676, -85.70509),
495(458, '36370', 'AL', 'Pansey', 31.141962, -85.15675),
496(459, '36371', 'AL', 'Pinckard', 31.31201, -85.54722),
497(460, '36373', 'AL', 'Shorterville', 31.52151, -85.1146),
498(461, '36374', 'AL', 'Skipperville', 31.569287, -85.48581),
499(462, '36375', 'AL', 'Slocomb', 31.096836, -85.54403),
500(463, '36376', 'AL', 'Webb', 31.243717, -85.27681),
501(464, '363HH', 'AL', '', 31.083599, -85.83201),
502(465, '36401', 'AL', 'Evergreen', 31.461019, -86.96271),
503(466, '36420', 'AL', 'Andalusia', 31.279043, -86.48699),
504(467, '36425', 'AL', 'Beatrice', 31.737883, -87.17442),
505(468, '36426', 'AL', 'Brewton', 31.129008, -87.10173),
506(469, '36432', 'AL', 'Castleberry', 31.291038, -87.03109),
507(470, '36435', 'AL', 'Coy', 31.874887, -87.4311),
508(471, '36436', 'AL', 'Dickinson', 31.756797, -87.645),
509(472, '36441', 'AL', 'Flomaton', 31.023139, -87.23957),
510(473, '36442', 'AL', 'Florala', 31.042071, -86.34347),
511(474, '36444', 'AL', 'Franklin', 31.63857, -87.46772),
512(475, '36445', 'AL', 'FriscoCity', 31.429994, -87.41631),
513(476, '36446', 'AL', 'Fulton', 31.786539, -87.72688),
514(477, '36451', 'AL', 'GroveHill', 31.704736, -87.77773),
515(478, '36453', 'AL', 'Kinston', 31.203287, -86.15169),
516(479, '36455', 'AL', 'Lockhart', 31.011435, -86.35065),
517(480, '36456', 'AL', 'McKenzie', 31.54668, -86.77355),
518(481, '36460', 'AL', 'Monroeville', 31.509039, -87.32416),
519(482, '36467', 'AL', 'Opp', 31.280048, -86.25484),
520(483, '36470', 'AL', 'PerdueHill', 31.514262, -87.50401),
521(484, '36471', 'AL', 'Peterman', 31.612646, -87.24886),
522(485, '36473', 'AL', 'Range', 31.306814, -87.20327),
523(486, '36474', 'AL', 'RedLevel', 31.416059, -86.61397),
524(487, '36475', 'AL', 'Repton', 31.410205, -87.22474),
525(488, '36476', 'AL', 'RiverFalls', 31.356774, -86.54879),
526(489, '36477', 'AL', 'Samson', 31.091359, -86.04782),
527(490, '36480', 'AL', 'Uriah', 31.320897, -87.59607),
528(491, '36481', 'AL', 'Vredenburgh', 31.821448, -87.34313),
529(492, '36482', 'AL', 'Whatley', 31.614138, -87.63373),
530(493, '36483', 'AL', 'Wing', 31.03183, -86.70207),
531(494, '364HH', 'AL', '', 31.177782, -86.76855),
532(495, '364XX', 'AL', '', 31.238967, -87.02213),
533(496, '36501', 'AL', 'Alma', 31.463968, -87.73883),
534(497, '36502', 'AL', 'Atmore', 31.090528, -87.49715),
535(498, '36505', 'AL', 'Axis', 30.930065, -88.00103),
536(499, '36507', 'AL', 'BayMinette', 30.875697, -87.76592),
537(500, '36509', 'AL', 'BayouLaBatre', 30.401384, -88.24671),
538(501, '36511', 'AL', 'BonSecour', 30.312316, -87.73468),
539(502, '36513', 'AL', 'Calvert', 31.161966, -87.99588),
540(503, '36515', 'AL', 'Carlton', 31.375467, -87.78506),
541(504, '36518', 'AL', 'Chatom', 31.463383, -88.26781),
542(505, '36521', 'AL', 'Chunchula', 30.965694, -88.18697),
543(506, '36522', 'AL', 'Citronelle', 31.0753, -88.2633),
544(507, '36523', 'AL', 'Coden', 30.383724, -88.18466),
545(508, '36524', 'AL', 'Coffeeville', 31.790834, -88.06933),
546(509, '36525', 'AL', 'Creola', 30.886317, -88.02806),
547(510, '36526', 'AL', 'Daphne', 30.620594, -87.88312),
548(511, '36527', 'AL', 'SpanishFort', 30.684873, -87.89723),
549(512, '36528', 'AL', 'DauphinIsland', 30.250825, -88.11819),
550(513, '36529', 'AL', 'DeerPark', 31.309194, -88.26036),
551(514, '36530', 'AL', 'Elberta', 30.377657, -87.56159),
552(515, '36532', 'AL', 'Fairhope', 30.512458, -87.88559),
553(516, '36535', 'AL', 'Foley', 30.396876, -87.69616),
554(517, '36538', 'AL', 'Frankville', 31.646087, -88.14188),
555(518, '36539', 'AL', 'Fruitdale', 31.375241, -88.41557),
556(519, '36540', 'AL', 'Gainestown', 31.453836, -87.64373),
557(520, '36541', 'AL', 'GrandBay', 30.487783, -88.32722),
558(521, '36542', 'AL', 'GulfShores', 30.262276, -87.72784),
559(522, '36544', 'AL', 'Irvington', 30.479171, -88.23793),
560(523, '36545', 'AL', 'Jackson', 31.508231, -87.88346),
561(524, '36548', 'AL', 'Leroy', 31.495691, -87.9626),
562(525, '36549', 'AL', 'Lillian', 30.393983, -87.45664),
563(526, '36550', 'AL', 'LittleRiver', 31.242801, -87.76099),
564(527, '36551', 'AL', 'Loxley', 30.6316, -87.75299),
565(528, '36553', 'AL', 'McIntosh', 31.234589, -88.08089),
566(529, '36556', 'AL', 'Malcolm', 31.213801, -87.96228),
567(530, '36558', 'AL', 'Millry', 31.629578, -88.34737),
568(531, '36559', 'AL', 'Montrose', 30.564701, -87.90216),
569(532, '36560', 'AL', 'MountVernon', 31.088463, -88.03007),
570(533, '36561', 'AL', 'OrangeBeach', 30.291503, -87.56198),
571(534, '36562', 'AL', 'Perdido', 31.021335, -87.64417),
572(535, '36564', 'AL', 'PointClear', 30.471767, -87.91874),
573(536, '36567', 'AL', 'Robertsdale', 30.5822, -87.63936),
574(537, '36569', 'AL', 'SaintStephens', 31.529488, -88.06349),
575(538, '36570', 'AL', 'Salitpa', 31.613745, -88.01381),
576(539, '36571', 'AL', 'Saraland', 30.831636, -88.09386),
577(540, '36572', 'AL', 'Satsuma', 30.857435, -88.05414),
578(541, '36574', 'AL', 'Seminole', 30.511685, -87.4686),
579(542, '36575', 'AL', 'Semmes', 30.76635, -88.26553),
580(543, '36576', 'AL', 'Silverhill', 30.540664, -87.7549),
581(544, '36577', 'AL', 'SpanishFort', 30.668757, -87.93971),
582(545, '36578', 'AL', 'Stapleton', 30.744745, -87.81486),
583(546, '36579', 'AL', 'Stockton', 31.126122, -87.80317),
584(547, '36580', 'AL', 'Summerdale', 30.485351, -87.71292),
585(548, '36581', 'AL', 'Sunflower', 31.373999, -87.99791),
586(549, '36582', 'AL', 'Theodore', 30.533744, -88.16865),
587(550, '36583', 'AL', 'Tibbie', 31.35209, -88.20879),
588(551, '36584', 'AL', 'VinegarBend', 31.202048, -88.38071),
589(552, '36585', 'AL', 'Wagarville', 31.38122, -88.02433),
590(553, '36587', 'AL', 'Wilmer', 30.828988, -88.35079),
591(554, '365HH', 'AL', '', 30.65989, -87.93091),
592(555, '365XX', 'AL', '', 31.219771, -87.92633),
593(556, '36602', 'AL', 'Mobile', 30.693389, -88.04416),
594(557, '36603', 'AL', 'Mobile', 30.688457, -88.05341),
595(558, '36604', 'AL', 'Mobile', 30.68164, -88.06676),
596(559, '36605', 'AL', 'Mobile', 30.641191, -88.08222),
597(560, '36606', 'AL', 'Mobile', 30.674057, -88.10249),
598(561, '36607', 'AL', 'Mobile', 30.699539, -88.10474),
599(562, '36608', 'AL', 'Mobile', 30.69044, -88.19701),
600(563, '36609', 'AL', 'Mobile', 30.662735, -88.16255),
601(564, '36610', 'AL', 'Mobile', 30.737405, -88.08201),
602(565, '36611', 'AL', 'Mobile', 30.764938, -88.08505),
603(566, '36612', 'AL', 'Mobile', 30.753155, -88.11116),
604(567, '36613', 'AL', 'EightMile', 30.795637, -88.1577),
605(568, '36617', 'AL', 'Mobile', 30.717539, -88.09609),
606(569, '36618', 'AL', 'Mobile', 30.728488, -88.16845),
607(570, '36619', 'AL', 'Mobile', 30.586808, -88.18552),
608(571, '36693', 'AL', 'Mobile', 30.630441, -88.15397),
609(572, '36695', 'AL', 'Mobile', 30.646415, -88.23657),
610(573, '366HH', 'AL', '', 30.629458, -88.09946),
611(574, '36701', 'AL', 'Selma', 32.429066, -87.03809),
612(575, '36703', 'AL', 'Selma', 32.419846, -86.97783),
613(576, '36720', 'AL', 'Alberta', 32.170653, -87.36217),
614(577, '36722', 'AL', 'Arlington', 32.079894, -87.57551),
615(578, '36723', 'AL', 'Boykin', 32.08846, -87.28018),
616(579, '36726', 'AL', 'Camden', 32.008444, -87.25911),
617(580, '36727', 'AL', 'Campbell', 31.910694, -88.03148),
618(581, '36728', 'AL', 'Catherine', 32.147166, -87.45675),
619(582, '36732', 'AL', 'Demopolis', 32.495484, -87.84521),
620(583, '36736', 'AL', 'DixonsMills', 32.069338, -87.77893),
621(584, '36738', 'AL', 'Faunsdale', 32.41786, -87.62729),
622(585, '36740', 'AL', 'Forkland', 32.629096, -87.84004),
623(586, '36742', 'AL', 'Gallion', 32.454007, -87.75003),
624(587, '36744', 'AL', 'Greensboro', 32.703529, -87.60177),
625(588, '36748', 'AL', 'Linden', 32.297441, -87.78812),
626(589, '36749', 'AL', 'Jones', 32.54896, -86.87897),
627(590, '36750', 'AL', 'Maplesville', 32.789726, -86.8496),
628(591, '36751', 'AL', 'LowerPeachTree', 31.833493, -87.55005),
629(592, '36752', 'AL', 'Lowndesboro', 32.322266, -86.64395),
630(593, '36754', 'AL', 'Magnolia', 32.140637, -87.6801),
631(594, '36756', 'AL', 'Marion', 32.665966, -87.33889),
632(595, '36758', 'AL', 'Plantersville', 32.639376, -86.91034),
633(596, '36759', 'AL', 'MarionJunction', 32.420138, -87.27857),
634(597, '36761', 'AL', 'Minter', 32.080532, -86.95524),
635(598, '36763', 'AL', 'Myrtlewood', 32.249718, -87.96332),
636(599, '36765', 'AL', 'Newbern', 32.594818, -87.53543),
637(600, '36767', 'AL', 'Orrville', 32.29165, -87.23168),
638(601, '36768', 'AL', 'PineApple', 31.901412, -86.95505),
639(602, '36769', 'AL', 'PineHill', 31.990494, -87.55222),
640(603, '36773', 'AL', 'Safford', 32.291429, -87.39972),
641(604, '36775', 'AL', 'Sardis', 32.213369, -86.98313),
642(605, '36776', 'AL', 'Sawyerville', 32.739091, -87.7417),
643(606, '36779', 'AL', 'Sprott', 32.701812, -87.17423),
644(607, '36782', 'AL', 'SweetWater', 32.114999, -87.90187),
645(608, '36783', 'AL', 'Thomaston', 32.263473, -87.60214),
646(609, '36784', 'AL', 'Thomasville', 31.936003, -87.77013),
647(610, '36785', 'AL', 'Tyler', 32.282192, -86.8216),
648(611, '36786', 'AL', 'Uniontown', 32.440868, -87.49657),
649(612, '36790', 'AL', 'Stanton', 32.731866, -86.90004),
650(613, '36792', 'AL', 'Randolph', 32.917983, -86.89046),
651(614, '36793', 'AL', 'Lawley', 32.838805, -86.99911),
652(615, '367HH', 'AL', '', 32.164757, -87.38532),
653(616, '367XX', 'AL', '', 32.231245, -87.36672),
654(617, '36801', 'AL', 'Opelika', 32.660497, -85.39917),
655(618, '36804', 'AL', 'Opelika', 32.556296, -85.33465),
656(619, '36830', 'AL', 'Auburn', 32.577135, -85.47282),
657(620, '36832', 'AL', 'Auburn', 32.589553, -85.53991),
658(621, '36849', 'AL', 'AuburnUniversity', 32.602434, -85.4858),
659(622, '36850', 'AL', 'CampHill', 32.799998, -85.64621),
660(623, '36852', 'AL', 'Cusseta', 32.745844, -85.28076),
661(624, '36853', 'AL', 'Dadeville', 32.787441, -85.79955),
662(625, '36854', 'AL', 'Valley', 32.777662, -85.17623),
663(626, '36855', 'AL', 'FivePoints', 33.046756, -85.30102),
664(627, '36856', 'AL', 'FortMitchell', 32.282085, -84.98389),
665(628, '36858', 'AL', 'Hatchechubbee', 32.297792, -85.31205),
666(629, '36860', 'AL', 'Hurtsboro', 32.237339, -85.41029),
667(630, '36861', 'AL', 'JacksonsGap', 32.862333, -85.84588),
668(631, '36862', 'AL', 'Lafayette', 32.903922, -85.42905),
669(632, '36863', 'AL', 'Lanett', 32.871306, -85.21314),
670(633, '36866', 'AL', 'Notasulga', 32.551474, -85.69859),
671(634, '36867', 'AL', 'PhenixCity', 32.492304, -85.01943),
672(635, '36869', 'AL', 'PhenixCity', 32.433065, -85.04512),
673(636, '36870', 'AL', 'PhenixCity', 32.484671, -85.0752),
674(637, '36871', 'AL', 'Pittsview', 32.16827, -85.11621),
675(638, '36874', 'AL', 'Salem', 32.587751, -85.18539),
676(639, '36875', 'AL', 'Seale', 32.315128, -85.11348),
677(640, '36877', 'AL', 'SmithsStation', 32.545138, -85.09212),
678(641, '36879', 'AL', 'Waverly', 32.733511, -85.55322),
679(642, '368HH', 'AL', '', 32.73722, -85.7482),
680(643, '36901', 'AL', 'Bellamy', 32.451618, -88.131),
681(644, '36904', 'AL', 'Butler', 32.097363, -88.22647),
682(645, '36907', 'AL', 'Cuba', 32.403275, -88.36252),
683(646, '36908', 'AL', 'Gilbertown', 31.891177, -88.28508),
684(647, '36910', 'AL', 'Jachin', 32.220752, -88.15471),
685(648, '36912', 'AL', 'Lisman', 32.227905, -88.32468),
686(649, '36915', 'AL', 'Needham', 31.970871, -88.34902),
687(650, '36916', 'AL', 'Pennington', 32.209381, -88.05965),
688(651, '36919', 'AL', 'Silas', 31.779344, -88.30045),
689(652, '36921', 'AL', 'Toxey', 31.96958, -88.18661),
690(653, '36922', 'AL', 'Ward', 32.304709, -88.17081),
691(654, '36925', 'AL', 'York', 32.487726, -88.2679),
692(655, '369HH', 'AL', '', 32.069482, -88.08096),
693(656, '369XX', 'AL', '', 32.361096, -88.14029),
694(657, '38852', 'AL', 'Iuka', 34.803864, -88.10205),
695(658, '99501', 'AK', 'Anchorage', 61.216799, -149.87828),
696(659, '99502', 'AK', 'Anchorage', 61.153693, -149.95932),
697(660, '99503', 'AK', 'Anchorage', 61.19026, -149.89341),
698(661, '99504', 'AK', 'Anchorage', 61.204466, -149.74633),
699(662, '99505', 'AK', 'Fort', 61.261518, -149.66336),
700(663, '99506', 'AK', 'Elmendorf', 61.224384, -149.77461),
701(664, '99507', 'AK', 'Anchorage', 61.154834, -149.82865),
702(665, '99508', 'AK', 'Anchorage', 61.203953, -149.8144),
703(666, '99513', 'AK', 'Anchorage', 61.214877, -149.88617),
704(667, '99515', 'AK', 'Anchorage', 61.122943, -149.88852),
705(668, '99516', 'AK', 'Anchorage', 61.101142, -149.77311),
706(669, '99517', 'AK', 'Anchorage', 61.188276, -149.93438),
707(670, '99518', 'AK', 'Anchorage', 61.156565, -149.88335),
708(671, '99540', 'AK', 'Indian', 60.973454, -149.4583),
709(672, '99546', 'AK', 'Adak', 51.87957, -176.63675),
710(673, '99547', 'AK', 'Atka', 52.227555, -174.19628),
711(674, '99548', 'AK', 'ChignikLake', 56.252156, -158.74638),
712(675, '99549', 'AK', 'Port', 56.946256, -158.62832),
713(676, '99550', 'AK', 'PortLions', 57.867089, -152.88568),
714(677, '99551', 'AK', 'Akiachak', 60.88981, -161.42393),
715(678, '99552', 'AK', 'Akiak', 60.911865, -161.22577),
716(679, '99553', 'AK', 'Akutan', 54.098693, -165.88176),
717(680, '99554', 'AK', 'Alakanuk', 62.683391, -164.65455),
718(681, '99555', 'AK', 'Aleknagik', 59.269535, -158.62458),
719(682, '99556', 'AK', 'Nikolaevsk', 59.798363, -151.73566),
720(683, '99557', 'AK', 'Chuathbaluk', 61.570981, -158.88072),
721(684, '99558', 'AK', 'Anvik', 62.632905, -160.21336),
722(685, '99559', 'AK', 'Atmautluak', 60.766603, -161.88006),
723(686, '99561', 'AK', 'Chefornak', 60.143735, -164.25283),
724(687, '99563', 'AK', 'Chevak', 61.527953, -165.57029),
725(688, '99564', 'AK', 'Chignik', 56.298297, -158.4044),
726(689, '99565', 'AK', 'Chignik', 56.307535, -158.53502),
727(690, '99566', 'AK', 'Chitina', 61.555701, -144.14233),
728(691, '99567', 'AK', 'Chugiak', 61.413717, -149.42644),
729(692, '99568', 'AK', 'Clam', 60.23458, -151.3934),
730(693, '99569', 'AK', 'Clarks', 58.83256, -158.55254),
731(694, '99571', 'AK', 'Nelson', 55.315003, -162.634),
732(695, '99572', 'AK', 'Cooper', 60.484146, -149.78153),
733(696, '99573', 'AK', 'Copper', 61.832347, -145.2308),
734(697, '99574', 'AK', 'Chenega', 60.474512, -145.40256),
735(698, '99575', 'AK', 'Crooked', 61.859821, -158.12888),
736(699, '99576', 'AK', 'Koliganek', 59.068709, -158.44407),
737(700, '99577', 'AK', 'Eagle', 61.310222, -149.51689),
738(701, '99578', 'AK', 'Eek', 60.214239, -162.03799),
739(702, '99579', 'AK', 'Egegik', 58.217621, -157.34841),
740(703, '99580', 'AK', 'Ekwok', 59.360233, -157.4838),
741(704, '99581', 'AK', 'Emmonak', 62.729019, -164.29917),
742(705, '99583', 'AK', 'False', 54.849999, -163.42011),
743(706, '99585', 'AK', 'Marshall', 61.878073, -162.08481),
744(707, '99586', 'AK', 'Slana', 62.667589, -144.49059),
745(708, '99587', 'AK', 'Girdwood', 60.952049, -149.0838),
746(709, '99588', 'AK', 'Glennallen', 62.12042, -145.58592),
747(710, '99589', 'AK', 'Goodnews', 59.125873, -161.59999),
748(711, '99590', 'AK', 'Grayling', 62.90813, -160.06675),
749(712, '99591', 'AK', 'Saint', 56.605546, -169.55958),
750(713, '995HH', 'AK', '', 61.198519, -146.93673),
751(714, '995XX', 'AK', '', 60.003158, -156.08723),
752(715, '99602', 'AK', 'Holy', 62.198048, -159.77341),
753(716, '99603', 'AK', 'Port', 59.665074, -151.4493),
754(717, '99604', 'AK', 'Hooper', 61.52898, -166.09619),
755(718, '99605', 'AK', 'Hope', 60.911003, -149.62708),
756(719, '99606', 'AK', 'Kokhanok', 59.748806, -154.8124),
757(720, '99607', 'AK', 'Kalskag', 61.535511, -160.30165),
758(721, '99608', 'AK', 'Karluk', 57.578081, -154.36255),
759(722, '99609', 'AK', 'Kasigluk', 60.873178, -162.5196),
760(723, '99610', 'AK', 'Kasilof', 60.318451, -151.28948),
761(724, '99611', 'AK', 'Kenai', 60.587598, -151.23355),
762(725, '99612', 'AK', 'King', 55.063736, -162.3124),
763(726, '99613', 'AK', 'Igiugig', 58.687446, -156.64007),
764(727, '99614', 'AK', 'Kipnuk', 59.937619, -164.04392),
765(728, '99615', 'AK', 'Akhiok', 57.74663, -152.51142),
766(729, '99620', 'AK', 'Kotlik', 62.945434, -163.76142),
767(730, '99621', 'AK', 'Kwethluk', 60.810509, -161.4219),
768(731, '99622', 'AK', 'Kwigillingok', 59.870295, -163.16752),
769(732, '99624', 'AK', 'LarsenBay', 57.529161, -154.00286),
770(733, '99625', 'AK', 'Levelock', 59.116273, -156.84802),
771(734, '99626', 'AK', 'Lower', 61.518175, -160.37019),
772(735, '99627', 'AK', 'Mcgrath', 62.94914, -155.57265),
773(736, '99628', 'AK', 'Manokotak', 58.981087, -159.0558),
774(737, '99630', 'AK', 'Mekoryuk', 60.364246, -166.28601),
775(738, '99631', 'AK', 'Moose', 60.499602, -149.40247),
776(739, '99632', 'AK', 'Mountain', 62.090075, -163.72393),
777(740, '99633', 'AK', 'Naknek', 58.745436, -156.95331),
778(741, '99634', 'AK', 'Napakiak', 60.695049, -161.9909),
779(742, '99635', 'AK', 'Nikiski', 60.784804, -151.06473),
780(743, '99636', 'AK', 'New', 59.452339, -157.31368),
781(744, '99637', 'AK', 'ToksookBay', 60.532936, -165.10529),
782(745, '99638', 'AK', 'Nikolski', 52.785684, -169.19469),
783(746, '99639', 'AK', 'Ninilchik', 59.992821, -151.54194),
784(747, '99640', 'AK', 'Nondalton', 59.971286, -154.85008),
785(748, '99641', 'AK', 'Nunapitchuk', 60.898967, -162.43712),
786(749, '99643', 'AK', 'OldHarbor', 57.19926, -153.30438),
787(750, '99644', 'AK', 'Ouzinkie', 57.929664, -152.46085),
788(751, '99645', 'AK', 'Butte', 61.598203, -149.04109),
789(752, '99647', 'AK', 'Pedro', 59.781241, -154.10833),
790(753, '99648', 'AK', 'Perryville', 55.91076, -159.15591),
791(754, '99649', 'AK', 'Pilot', 57.508178, -157.39907),
792(755, '99650', 'AK', 'Pilot', 61.93605, -162.8834),
793(756, '99651', 'AK', 'Platinum', 59.00689, -161.81529),
794(757, '99652', 'AK', 'BigLake', 61.556311, -149.89098),
795(758, '99653', 'AK', 'Port', 60.102331, -154.55708),
796(759, '99654', 'AK', 'Wasilla', 61.580187, -149.48821),
797(760, '99655', 'AK', 'Quinhagak', 59.754016, -161.90079),
798(761, '99656', 'AK', 'Red', 61.810587, -157.3437),
799(762, '99657', 'AK', 'Russian', 61.785228, -161.36476),
800(763, '99658', 'AK', 'Saint', 62.048263, -163.1937),
801(764, '99659', 'AK', 'Saint', 63.477448, -162.03841),
802(765, '99660', 'AK', 'Saint', 57.130894, -170.27203),
803(766, '99661', 'AK', 'Sand', 55.311735, -160.48813),
804(767, '99662', 'AK', 'Scammon', 61.783788, -165.53972),
805(768, '99663', 'AK', 'Seldovia', 59.422698, -151.71513),
806(769, '99664', 'AK', 'Seward', 60.151652, -149.41271),
807(770, '99665', 'AK', 'Shageluk', 62.655998, -159.53113),
808(771, '99666', 'AK', 'NunamIqua', 62.495675, -164.97188),
809(772, '99667', 'AK', 'Skwentna', 61.898872, -151.51587),
810(773, '99668', 'AK', 'Sleetmute', 61.683931, -157.15202),
811(774, '99669', 'AK', 'Soldotna', 60.489536, -151.02091),
812(775, '99670', 'AK', 'South', 58.71163, -157.01746),
813(776, '99671', 'AK', 'Stebbins', 63.511893, -162.27463),
814(777, '99672', 'AK', 'Sterling', 60.532394, -150.74033),
815(778, '99674', 'AK', 'Sutton', 61.751348, -148.69632),
816(779, '99675', 'AK', 'Takotna', 62.969642, -156.10264),
817(780, '99676', 'AK', 'Talkeetna', 62.298254, -149.87542),
818(781, '99677', 'AK', 'Tatitlek', 60.863764, -146.68013),
819(782, '99678', 'AK', 'Togiak', 59.101934, -160.50353),
820(783, '99679', 'AK', 'Tuluksak', 61.102912, -160.96325),
821(784, '99680', 'AK', 'Tuntutuliak', 60.343879, -162.66587),
822(785, '99681', 'AK', 'Tununak', 60.582127, -165.25645),
823(786, '99682', 'AK', 'Tyonek', 61.067777, -151.14169),
824(787, '99683', 'AK', 'Trapper', 62.415294, -150.37044),
825(788, '99684', 'AK', 'Unalakleet', 63.882081, -160.76294),
826(789, '99685', 'AK', 'Unalaska', 53.872017, -166.52287),
827(790, '99686', 'AK', 'Valdez', 61.128176, -146.2357),
828(791, '99687', 'AK', 'Wasilla', 61.391728, -149.99002),
829(792, '99688', 'AK', 'Willow', 61.796774, -150.07792),
830(793, '99689', 'AK', 'Yakutat', 59.538728, -139.71052),
831(794, '99690', 'AK', 'Nightmute', 60.527618, -164.81976),
832(795, '99691', 'AK', 'Nikolai', 62.999213, -154.41957),
833(796, '99692', 'AK', 'Dutch', 53.883729, -166.5485),
834(797, '99693', 'AK', 'Whittier', 60.639257, -148.54211),
835(798, '99694', 'AK', 'Houston', 61.629635, -149.79507),
836(799, '99695', 'AK', 'Anchorage', 61.402544, -150.57485),
837(800, '99697', 'AK', 'Kodiak', 57.564289, -153.40755),
838(801, '996HH', 'AK', '', 59.724281, -150.46488),
839(802, '996XX', 'AK', '', 60.938037, -153.43502),
840(803, '99701', 'AK', 'Coldfoot', 64.83507, -147.72045),
841(804, '99702', 'AK', 'Eielson', 64.661627, -147.02121),
842(805, '99703', 'AK', 'Fort', 64.827164, -147.6265),
843(806, '99704', 'AK', 'Clear', 64.289856, -149.17778),
844(807, '99705', 'AK', 'North', 64.777233, -147.3649),
845(808, '99709', 'AK', 'Fairbanks', 64.854937, -147.87406),
846(809, '99712', 'AK', 'Fairbanks', 64.926041, -147.49573),
847(810, '99714', 'AK', 'Salcha', 64.464105, -146.91648),
848(811, '99720', 'AK', 'Allakaket', 66.557586, -152.6559),
849(812, '99721', 'AK', 'Anaktuvuk', 68.148216, -151.72854),
850(813, '99722', 'AK', 'Arctic', 68.121828, -145.52768),
851(814, '99723', 'AK', 'Barrow', 71.299525, -156.74891),
852(815, '99724', 'AK', 'Beaver', 66.359719, -147.39743),
853(816, '99725', 'AK', 'Ester', 64.842326, -148.02197),
854(817, '99726', 'AK', 'Bettles', 66.917381, -151.50508),
855(818, '99727', 'AK', 'Buckland', 65.979144, -161.12225),
856(819, '99729', 'AK', 'Cantwell', 63.255516, -148.39873),
857(820, '99730', 'AK', 'Central', 65.551022, -144.71982),
858(821, '99732', 'AK', 'Chicken', 64.070738, -141.87489),
859(822, '99733', 'AK', 'Circle', 65.796306, -144.06388),
860(823, '99736', 'AK', 'Deering', 66.075713, -162.71822),
861(824, '99737', 'AK', 'Dot', 63.978355, -145.4623),
862(825, '99738', 'AK', 'Eagle', 64.778099, -141.19257),
863(826, '99739', 'AK', 'Elim', 64.620513, -162.27718),
864(827, '99740', 'AK', 'Fort', 66.566652, -145.28231),
865(828, '99741', 'AK', 'Galena', 64.739082, -156.89456),
866(829, '99742', 'AK', 'Gambell', 63.776098, -171.70088),
867(830, '99743', 'AK', 'Healy', 64.010218, -149.10712),
868(831, '99744', 'AK', 'Anderson', 64.349263, -149.19265),
869(832, '99745', 'AK', 'Hughes', 66.044094, -154.25703),
870(833, '99746', 'AK', 'Huslia', 65.701858, -156.38713),
871(834, '99747', 'AK', 'Kaktovik', 70.13346, -143.62436),
872(835, '99748', 'AK', 'Kaltag', 64.324887, -158.73204),
873(836, '99749', 'AK', 'Kiana', 66.97172, -160.43016),
874(837, '99750', 'AK', 'Kivalina', 67.733313, -164.54522),
875(838, '99751', 'AK', 'Kobuk', 66.908604, -156.88828),
876(839, '99752', 'AK', 'Kotzebue', 66.897192, -162.58544),
877(840, '99753', 'AK', 'Koyuk', 64.932225, -161.15597),
878(841, '99754', 'AK', 'Koyukuk', 64.881745, -157.70439),
879(842, '99755', 'AK', 'DenaliNational', 63.657441, -148.83396),
880(843, '99756', 'AK', 'ManleyHotSprin', 65.021337, -150.50318),
881(844, '99757', 'AK', 'LakeMinchumina', 63.893902, -152.30201),
882(845, '99758', 'AK', 'Minto', 65.152583, -149.39156),
883(846, '99759', 'AK', 'PointLay', 69.741023, -163.00861),
884(847, '99760', 'AK', 'Nenana', 64.560888, -149.07674),
885(848, '99761', 'AK', 'Noatak', 67.572031, -162.97508),
886(849, '99762', 'AK', 'Golovin', 64.532616, -165.10883),
887(850, '99763', 'AK', 'Noorvik', 66.83713, -161.03664),
888(851, '99764', 'AK', 'Northway', 62.980725, -141.82852),
889(852, '99765', 'AK', 'Nulato', 64.730035, -158.11178),
890(853, '99766', 'AK', 'PointHope', 68.347052, -166.76291),
891(854, '99767', 'AK', 'Rampart', 65.507883, -150.1636),
892(855, '99768', 'AK', 'Ruby', 64.737306, -155.48769),
893(856, '99769', 'AK', 'Savoonga', 63.686038, -170.4087),
894(857, '99770', 'AK', 'Selawik', 66.597998, -160.01772),
895(858, '99771', 'AK', 'Shaktoolik', 64.343258, -161.16785),
896(859, '99772', 'AK', 'Shishmaref', 66.259417, -165.73202),
897(860, '99773', 'AK', 'Shungnak', 66.887401, -157.14287),
898(861, '99774', 'AK', 'StevensVillage', 66.005296, -149.10303),
899(862, '99775', 'AK', 'Fairbanks', 64.860846, -147.82681),
900(863, '99776', 'AK', 'Tanacross', 63.376206, -143.35699),
901(864, '99777', 'AK', 'Tanana', 65.172029, -152.08258),
902(865, '99778', 'AK', 'Teller', 65.250432, -166.35474),
903(866, '99779', 'AK', 'Tetlin', 63.135294, -142.5323),
904(867, '99780', 'AK', 'Border', 63.341767, -142.93704),
905(868, '99781', 'AK', 'Venetie', 67.015569, -146.41736),
906(869, '99782', 'AK', 'Wainwright', 70.640902, -160.02481),
907(870, '99783', 'AK', 'Wales', 65.612116, -168.08928),
908(871, '99784', 'AK', 'WhiteMountain', 64.684323, -163.44257),
909(872, '99785', 'AK', 'BrevigMission', 65.342744, -166.51023),
910(873, '99786', 'AK', 'Ambler', 67.083658, -157.86225),
911(874, '99788', 'AK', 'Chalkyitsik', 66.653222, -143.72717),
912(875, '99789', 'AK', 'Nuiqsut', 70.215197, -151.02746),
913(876, '99791', 'AK', 'Atqasuk', 70.477663, -157.41805),
914(877, '997HH', 'AK', '', 64.815413, -141.1768),
915(878, '997XX', 'AK', '', 66.360999, -152.6151),
916(879, '99801', 'AK', 'Juneau', 58.358599, -134.54749),
917(880, '99820', 'AK', 'Angoon', 57.48765, -134.57222),
918(881, '99824', 'AK', 'Douglas', 58.276192, -134.39781),
919(882, '99825', 'AK', 'ElfinCove', 58.068878, -136.27833),
920(883, '99826', 'AK', 'Gustavus', 58.434052, -135.73088),
921(884, '99827', 'AK', 'Haines', 59.279037, -135.6122),
922(885, '99829', 'AK', 'Hoonah', 58.109608, -135.43154),
923(886

Large files files are truncated, but you can click here to view the full file