PageRenderTime 1875ms CodeModel.GetById 92ms app.highlight 1606ms RepoModel.GetById 58ms app.codeStats 8ms

/data/obsolete/zip_code.sql

http://github.com/Quixotix/PHP-ZipCode-Class
SQL | 4251 lines | 4250 code | 1 blank | 0 comment | 0 complexity | a0b970f68d9cf35cd1159f23d6029245 MD5 | raw file

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

  1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  2/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  3/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  4/*!40101 SET NAMES utf8 */;
  5/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  6/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  7/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  8/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  9DROP TABLE IF EXISTS `zip_code`;
 10/*!40101 SET @saved_cs_client     = @@character_set_client */;
 11/*!40101 SET character_set_client = utf8 */;
 12CREATE TABLE `zip_code` (
 13  `zip_code_id` int(11) NOT NULL,
 14  `zip_code` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
 15  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
 16  `county` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
 17  `state_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
 18  `state_prefix` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
 19  `area_code` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
 20  `time_zone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
 21  `lat` float NOT NULL,
 22  `lon` float NOT NULL,
 23  PRIMARY KEY (`zip_code_id`),
 24  UNIQUE KEY `zip_code` (`zip_code`),
 25  KEY `city_state` (`city`,`state_prefix`)
 26);
 27/*!40101 SET character_set_client = @saved_cs_client */;
 28
 29LOCK TABLES `zip_code` WRITE;
 30/*!40000 ALTER TABLE `zip_code` DISABLE KEYS */;
 31INSERT INTO `zip_code` VALUES (1,'00501','Holtsville','Suffolk','New York','NY','631','Eastern',40.8131,-73.0464);
 32INSERT INTO `zip_code` VALUES (2,'00544','Holtsville','Suffolk','New York','NY','631','Eastern',40.8132,-73.0493);
 33INSERT INTO `zip_code` VALUES (3,'00601','Adjuntas','Adjuntas','Puerto Rico','PR','787','Atlantic',18.166,-66.7236);
 34INSERT INTO `zip_code` VALUES (4,'00602','Aguada','Aguada','Puerto Rico','PR','787','Atlantic',18.383,-67.1866);
 35INSERT INTO `zip_code` VALUES (5,'00603','Aguadilla','Aguadilla','Puerto Rico','PR','787','Atlantic',18.4332,-67.152);
 36INSERT INTO `zip_code` VALUES (6,'00604','Aguadilla','Aguadilla','Puerto Rico','PR','787','Atlantic',18.5053,-67.1359);
 37INSERT INTO `zip_code` VALUES (7,'00605','Aguadilla','Aguadilla','Puerto Rico','PR','787','Atlantic',18.4361,-67.1513);
 38INSERT INTO `zip_code` VALUES (8,'00606','Maricao','Maricao','Puerto Rico','PR','787','Atlantic',18.1856,-66.9774);
 39INSERT INTO `zip_code` VALUES (9,'00610','Anasco','Anasco','Puerto Rico','PR','787','Atlantic',18.2859,-67.1442);
 40INSERT INTO `zip_code` VALUES (10,'00611','Angeles','Utuado','Puerto Rico','PR','787','Atlantic',18.2877,-66.7976);
 41INSERT INTO `zip_code` VALUES (11,'00612','Arecibo','Arecibo','Puerto Rico','PR','787','Atlantic',18.4713,-66.7281);
 42INSERT INTO `zip_code` VALUES (12,'00613','Arecibo','Arecibo','Puerto Rico','PR','787','Atlantic',18.4727,-66.7193);
 43INSERT INTO `zip_code` VALUES (13,'00614','Arecibo','Arecibo','Puerto Rico','PR','787','Atlantic',18.4569,-66.7359);
 44INSERT INTO `zip_code` VALUES (14,'00616','Bajadero','Arecibo','Puerto Rico','PR','787','Atlantic',18.4265,-66.6738);
 45INSERT INTO `zip_code` VALUES (15,'00617','Barceloneta','Barceloneta','Puerto Rico','PR','787','Atlantic',18.4588,-66.5372);
 46INSERT INTO `zip_code` VALUES (16,'00622','Boqueron','Cabo Rojo','Puerto Rico','PR','787','Atlantic',18.018,-67.1706);
 47INSERT INTO `zip_code` VALUES (17,'00623','Cabo Rojo','Cabo Rojo','Puerto Rico','PR','787','Atlantic',18.0867,-67.1518);
 48INSERT INTO `zip_code` VALUES (18,'00624','Penuelas','Penuelas','Puerto Rico','PR','787','Atlantic',18.0635,-66.7236);
 49INSERT INTO `zip_code` VALUES (19,'00627','Camuy','Camuy','Puerto Rico','PR','787','Atlantic',18.4859,-66.8441);
 50INSERT INTO `zip_code` VALUES (20,'00631','Castaner','Lares','Puerto Rico','PR','787','Atlantic',18.1803,-66.8329);
 51INSERT INTO `zip_code` VALUES (21,'00636','Rosario','San German','Puerto Rico','PR','787','Atlantic',18.1621,-67.0779);
 52INSERT INTO `zip_code` VALUES (22,'00637','Sabana Grande','Sabana Grande','Puerto Rico','PR','787','Atlantic',18.0817,-66.968);
 53INSERT INTO `zip_code` VALUES (23,'00638','Ciales','Ciales','Puerto Rico','PR','787','Atlantic',18.3388,-66.4664);
 54INSERT INTO `zip_code` VALUES (24,'00641','Utuado','Utuado','Puerto Rico','PR','787','Atlantic',18.2689,-66.7044);
 55INSERT INTO `zip_code` VALUES (25,'00646','Dorado','Dorado','Puerto Rico','PR','787','Atlantic',18.4666,-66.2705);
 56INSERT INTO `zip_code` VALUES (26,'00647','Ensenada','Guanica','Puerto Rico','PR','787','Atlantic',17.9673,-66.9399);
 57INSERT INTO `zip_code` VALUES (27,'00650','Florida','Florida','Puerto Rico','PR','787','Atlantic',18.3626,-66.5654);
 58INSERT INTO `zip_code` VALUES (28,'00652','Garrochales','Arecibo','Puerto Rico','PR','787','Atlantic',18.4662,-66.5694);
 59INSERT INTO `zip_code` VALUES (29,'00653','Guanica','Guanica','Puerto Rico','PR','787','Atlantic',17.974,-66.9087);
 60INSERT INTO `zip_code` VALUES (30,'00656','Guayanilla','Guayanilla','Puerto Rico','PR','787','Atlantic',18.026,-66.7876);
 61INSERT INTO `zip_code` VALUES (31,'00659','Hatillo','Hatillo','Puerto Rico','PR','787','Atlantic',18.4854,-66.8249);
 62INSERT INTO `zip_code` VALUES (32,'00660','Hormigueros','Hormigueros','Puerto Rico','PR','787','Atlantic',18.1409,-67.1282);
 63INSERT INTO `zip_code` VALUES (33,'00662','Isabela','Isabela','Puerto Rico','PR','787','Atlantic',18.5012,-67.0228);
 64INSERT INTO `zip_code` VALUES (34,'00664','Jayuya','Jayuya','Puerto Rico','PR','787','Atlantic',18.2198,-66.5914);
 65INSERT INTO `zip_code` VALUES (35,'00667','Lajas','Lajas','Puerto Rico','PR','787','Atlantic',18.0452,-67.0579);
 66INSERT INTO `zip_code` VALUES (36,'00669','Lares','Lares','Puerto Rico','PR','787','Atlantic',18.2944,-66.8844);
 67INSERT INTO `zip_code` VALUES (37,'00670','Las Marias','Las Marias','Puerto Rico','PR','787','Atlantic',18.2964,-67.1466);
 68INSERT INTO `zip_code` VALUES (38,'00674','Manati','Manati','Puerto Rico','PR','787','Atlantic',18.4306,-66.4847);
 69INSERT INTO `zip_code` VALUES (39,'00676','Moca','Moca','Puerto Rico','PR','787','Atlantic',18.3994,-67.1133);
 70INSERT INTO `zip_code` VALUES (40,'00677','Rincon','Rincon','Puerto Rico','PR','787','Atlantic',18.3433,-67.2559);
 71INSERT INTO `zip_code` VALUES (41,'00678','Quebradillas','Quebradillas','Puerto Rico','PR','787','Atlantic',18.4749,-66.9373);
 72INSERT INTO `zip_code` VALUES (42,'00680','Mayaguez','Mayaguez','Puerto Rico','PR','787','Atlantic',18.2038,-67.1453);
 73INSERT INTO `zip_code` VALUES (43,'00681','Mayaguez','Mayaguez','Puerto Rico','PR','787','Atlantic',18.2043,-67.1447);
 74INSERT INTO `zip_code` VALUES (44,'00682','Mayaguez','Mayaguez','Puerto Rico','PR','787','Atlantic',18.2038,-67.1435);
 75INSERT INTO `zip_code` VALUES (45,'00683','San German','San German','Puerto Rico','PR','787','Atlantic',18.084,-67.0463);
 76INSERT INTO `zip_code` VALUES (46,'00685','San Sebastian','San Sebastian','Puerto Rico','PR','787','Atlantic',18.3415,-66.9963);
 77INSERT INTO `zip_code` VALUES (47,'00687','Morovis','Morovis','Puerto Rico','PR','787','Atlantic',18.3291,-66.4042);
 78INSERT INTO `zip_code` VALUES (48,'00688','Sabana Hoyos','Arecibo','Puerto Rico','PR','787','Atlantic',18.4302,-66.6126);
 79INSERT INTO `zip_code` VALUES (49,'00690','San Antonio','Aguadilla','Puerto Rico','PR','787','Atlantic',18.4954,-67.0977);
 80INSERT INTO `zip_code` VALUES (50,'00692','Vega Alta','Vega Alta','Puerto Rico','PR','787','Atlantic',18.4137,-66.319);
 81INSERT INTO `zip_code` VALUES (51,'00693','Vega Baja','Vega Baja','Puerto Rico','PR','787','Atlantic',18.4419,-66.3989);
 82INSERT INTO `zip_code` VALUES (52,'00694','Vega Baja','Vega Baja','Puerto Rico','PR','787','Atlantic',18.4446,-66.4026);
 83INSERT INTO `zip_code` VALUES (53,'00698','Yauco','Yauco','Puerto Rico','PR','787','Atlantic',18.0353,-66.8633);
 84INSERT INTO `zip_code` VALUES (54,'00703','Aguas Buenas','Aguas Buenas','Puerto Rico','PR','787','Atlantic',18.2616,-66.1039);
 85INSERT INTO `zip_code` VALUES (55,'00704','Aguirre','Guayama','Puerto Rico','PR','787','Atlantic',18.2512,-66.1014);
 86INSERT INTO `zip_code` VALUES (56,'00705','Aibonito','Aibonito','Puerto Rico','PR','787','Atlantic',18.1421,-66.2676);
 87INSERT INTO `zip_code` VALUES (57,'00707','Maunabo','Maunabo','Puerto Rico','PR','787','Atlantic',18.0103,-65.8969);
 88INSERT INTO `zip_code` VALUES (58,'00714','Arroyo','Arroyo','Puerto Rico','PR','787','Atlantic',17.9701,-66.0642);
 89INSERT INTO `zip_code` VALUES (59,'00715','Mercedita','Ponce','Puerto Rico','PR','787','Atlantic',18.0149,-66.5865);
 90INSERT INTO `zip_code` VALUES (60,'00716','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0146,-66.6147);
 91INSERT INTO `zip_code` VALUES (61,'00717','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0133,-66.6145);
 92INSERT INTO `zip_code` VALUES (62,'00718','Naguabo','Naguabo','Puerto Rico','PR','787','Atlantic',18.2149,-65.7324);
 93INSERT INTO `zip_code` VALUES (63,'00719','Naranjito','Naranjito','Puerto Rico','PR','787','Atlantic',18.3016,-66.2443);
 94INSERT INTO `zip_code` VALUES (64,'00720','Orocovis','Orocovis','Puerto Rico','PR','787','Atlantic',18.2291,-66.3915);
 95INSERT INTO `zip_code` VALUES (65,'00721','Palmer','Rio Grande','Puerto Rico','PR','787','Atlantic',18.3718,-65.7745);
 96INSERT INTO `zip_code` VALUES (66,'00723','Patillas','Patillas','Puerto Rico','PR','787','Atlantic',18.0107,-66.0152);
 97INSERT INTO `zip_code` VALUES (67,'00725','Caguas','Caguas','Puerto Rico','PR','787','Atlantic',18.2362,-66.0413);
 98INSERT INTO `zip_code` VALUES (68,'00726','Caguas','Caguas','Puerto Rico','PR','787','Atlantic',18.233,-66.036);
 99INSERT INTO `zip_code` VALUES (69,'00727','Caguas','Caguas','Puerto Rico','PR','787','Atlantic',18.234,-66.0364);
100INSERT INTO `zip_code` VALUES (70,'00728','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0131,-66.614);
101INSERT INTO `zip_code` VALUES (71,'00729','Canovanas','Canovanas','Puerto Rico','PR','787','Atlantic',18.3799,-65.909);
102INSERT INTO `zip_code` VALUES (72,'00730','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0137,-66.6134);
103INSERT INTO `zip_code` VALUES (73,'00731','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0141,-66.6172);
104INSERT INTO `zip_code` VALUES (74,'00732','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0361,-66.6114);
105INSERT INTO `zip_code` VALUES (75,'00733','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0208,-66.6201);
106INSERT INTO `zip_code` VALUES (76,'00734','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',17.9867,-66.609);
107INSERT INTO `zip_code` VALUES (77,'00735','Ceiba','Ceiba','Puerto Rico','PR','787','Atlantic',18.2605,-65.6403);
108INSERT INTO `zip_code` VALUES (78,'00736','Cayey','Cayey','Puerto Rico','PR','787','Atlantic',18.1183,-66.161);
109INSERT INTO `zip_code` VALUES (79,'00737','Cayey','Cayey','Puerto Rico','PR','787','Atlantic',18.1154,-66.161);
110INSERT INTO `zip_code` VALUES (80,'00738','Fajardo','Fajardo','Puerto Rico','PR','787','Atlantic',18.3323,-65.6593);
111INSERT INTO `zip_code` VALUES (81,'00739','Cidra','Cidra','Puerto Rico','PR','787','Atlantic',18.1774,-66.1561);
112INSERT INTO `zip_code` VALUES (82,'00740','Puerto Real','Fajardo','Puerto Rico','PR','787','Atlantic',18.3333,-65.633);
113INSERT INTO `zip_code` VALUES (83,'00741','Punta Santiago','Humacao','Puerto Rico','PR','787','Atlantic',18.1687,-65.7472);
114INSERT INTO `zip_code` VALUES (84,'00742','Roosevelt Roads','Ceiba','Puerto Rico','PR','787','Atlantic',18.2389,-65.6274);
115INSERT INTO `zip_code` VALUES (85,'00744','Rio Blanco','Naguabo','Puerto Rico','PR','787','Atlantic',18.2177,-65.7956);
116INSERT INTO `zip_code` VALUES (86,'00745','Rio Grande','Rio Grande','Puerto Rico','PR','787','Atlantic',18.3834,-65.8381);
117INSERT INTO `zip_code` VALUES (87,'00751','Salinas','Salinas','Puerto Rico','PR','787','Atlantic',17.9888,-66.2875);
118INSERT INTO `zip_code` VALUES (88,'00754','San Lorenzo','San Lorenzo','Puerto Rico','PR','787','Atlantic',18.1885,-65.9589);
119INSERT INTO `zip_code` VALUES (89,'00757','Santa Isabel','Santa Isabel','Puerto Rico','PR','787','Atlantic',17.9682,-66.4027);
120INSERT INTO `zip_code` VALUES (90,'00765','Vieques','Vieques','Puerto Rico','PR','787','Atlantic',18.1309,-65.4534);
121INSERT INTO `zip_code` VALUES (91,'00766','Villalba','Villalba','Puerto Rico','PR','787','Atlantic',18.1296,-66.4905);
122INSERT INTO `zip_code` VALUES (92,'00767','Yabucoa','Yabucoa','Puerto Rico','PR','787','Atlantic',18.0515,-65.8809);
123INSERT INTO `zip_code` VALUES (93,'00769','Coamo','Coamo','Puerto Rico','PR','787','Atlantic',18.0821,-66.36);
124INSERT INTO `zip_code` VALUES (94,'00771','Las Piedras','Las Piedras','Puerto Rico','PR','787','Atlantic',18.1821,-65.8692);
125INSERT INTO `zip_code` VALUES (95,'00772','Loiza','Loiza','Puerto Rico','PR','787','Atlantic',18.4339,-65.8808);
126INSERT INTO `zip_code` VALUES (96,'00773','Luquillo','Luquillo','Puerto Rico','PR','787','Atlantic',18.3757,-65.7206);
127INSERT INTO `zip_code` VALUES (97,'00775','Culebra','Culebra','Puerto Rico','PR','787','Atlantic',18.3115,-65.3055);
128INSERT INTO `zip_code` VALUES (98,'00777','Juncos','Juncos','Puerto Rico','PR','787','Atlantic',18.2291,-65.9184);
129INSERT INTO `zip_code` VALUES (99,'00778','Gurabo','Gurabo','Puerto Rico','PR','787','Atlantic',18.2571,-65.9757);
130INSERT INTO `zip_code` VALUES (100,'00780','Coto Laurel','Ponce','Puerto Rico','PR','787','Atlantic',18.0468,-66.5502);
131INSERT INTO `zip_code` VALUES (101,'00782','Comerio','Comerio','Puerto Rico','PR','787','Atlantic',18.2219,-66.2272);
132INSERT INTO `zip_code` VALUES (102,'00783','Corozal','Corozal','Puerto Rico','PR','787','Atlantic',18.3426,-66.3111);
133INSERT INTO `zip_code` VALUES (103,'00784','Guayama','Guayama','Puerto Rico','PR','787','Atlantic',17.9798,-66.1115);
134INSERT INTO `zip_code` VALUES (104,'00785','Guayama','Guayanilla','Puerto Rico','PR','787','Atlantic',17.9789,-66.1102);
135INSERT INTO `zip_code` VALUES (105,'00786','La Plata','Aibonito','Puerto Rico','PR','787','Atlantic',18.1582,-66.236);
136INSERT INTO `zip_code` VALUES (106,'00791','Humacao','Humacao','Puerto Rico','PR','787','Atlantic',18.1545,-65.8208);
137INSERT INTO `zip_code` VALUES (107,'00792','Humacao','Humacao','Puerto Rico','PR','787','Atlantic',18.1513,-65.8219);
138INSERT INTO `zip_code` VALUES (108,'00794','Barranquitas','Barranquitas','Puerto Rico','PR','787','Atlantic',18.1876,-66.3074);
139INSERT INTO `zip_code` VALUES (109,'00795','Juana Diaz','Juana Diaz','Puerto Rico','PR','787','Atlantic',18.0539,-66.5053);
140INSERT INTO `zip_code` VALUES (110,'00801','Saint Thomas','Saint Thomas','Virgin Islands','VI','340','Atlantic',18.3498,-64.9432);
141INSERT INTO `zip_code` VALUES (111,'00802','Saint Thomas','Saint Thomas','Virgin Islands','VI','340','Atlantic',18.3488,-64.9354);
142INSERT INTO `zip_code` VALUES (112,'00803','Saint Thomas','Saint Thomas','Virgin Islands','VI','340','Atlantic',18.3503,-64.9356);
143INSERT INTO `zip_code` VALUES (113,'00804','Saint Thomas','Saint Thomas','Virgin Islands','VI','340','Atlantic',18.349,-64.9321);
144INSERT INTO `zip_code` VALUES (114,'00805','Saint Thomas','Saint Thomas','Virgin Islands','VI','340','Atlantic',18.3505,-64.9351);
145INSERT INTO `zip_code` VALUES (115,'00820','Christiansted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7459,-64.7073);
146INSERT INTO `zip_code` VALUES (116,'00821','Christiansted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7461,-64.7066);
147INSERT INTO `zip_code` VALUES (117,'00822','Christiansted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7448,-64.7097);
148INSERT INTO `zip_code` VALUES (118,'00823','Christiansted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7442,-64.7083);
149INSERT INTO `zip_code` VALUES (119,'00824','Christiansted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7452,-64.7043);
150INSERT INTO `zip_code` VALUES (120,'00830','Saint John','Saint John','Virgin Islands','VI','340','Atlantic',18.3352,-64.7907);
151INSERT INTO `zip_code` VALUES (121,'00831','Saint John','Saint John','Virgin Islands','VI','340','Atlantic',18.3335,-64.793);
152INSERT INTO `zip_code` VALUES (122,'00840','Frederiksted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7124,-64.8828);
153INSERT INTO `zip_code` VALUES (123,'00841','Frederiksted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7151,-64.8834);
154INSERT INTO `zip_code` VALUES (124,'00850','Kingshill','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7308,-64.7981);
155INSERT INTO `zip_code` VALUES (125,'00851','Kingshill','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7335,-64.7989);
156INSERT INTO `zip_code` VALUES (126,'00901','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4639,-66.1098);
157INSERT INTO `zip_code` VALUES (127,'00902','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4463,-66.0983);
158INSERT INTO `zip_code` VALUES (128,'00906','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4055,-66.0627);
159INSERT INTO `zip_code` VALUES (129,'00907','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4543,-66.0766);
160INSERT INTO `zip_code` VALUES (130,'00908','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4442,-66.0795);
161INSERT INTO `zip_code` VALUES (131,'00909','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4473,-66.0679);
162INSERT INTO `zip_code` VALUES (132,'00910','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.443,-66.0715);
163INSERT INTO `zip_code` VALUES (133,'00911','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4514,-66.0616);
164INSERT INTO `zip_code` VALUES (134,'00912','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4466,-66.0611);
165INSERT INTO `zip_code` VALUES (135,'00913','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.451,-66.0451);
166INSERT INTO `zip_code` VALUES (136,'00914','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4483,-66.0167);
167INSERT INTO `zip_code` VALUES (137,'00915','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.438,-66.0474);
168INSERT INTO `zip_code` VALUES (138,'00916','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3765,-66.1627);
169INSERT INTO `zip_code` VALUES (139,'00917','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4206,-66.0539);
170INSERT INTO `zip_code` VALUES (140,'00918','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4174,-66.0612);
171INSERT INTO `zip_code` VALUES (141,'00919','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.411,-66.0649);
172INSERT INTO `zip_code` VALUES (142,'00920','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4102,-66.0877);
173INSERT INTO `zip_code` VALUES (143,'00921','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3917,-66.0906);
174INSERT INTO `zip_code` VALUES (144,'00922','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.41,-66.0926);
175INSERT INTO `zip_code` VALUES (145,'00923','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4124,-66.0391);
176INSERT INTO `zip_code` VALUES (146,'00924','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4044,-66.0125);
177INSERT INTO `zip_code` VALUES (147,'00925','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3989,-66.0503);
178INSERT INTO `zip_code` VALUES (148,'00926','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3792,-66.0602);
179INSERT INTO `zip_code` VALUES (149,'00927','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3888,-66.0733);
180INSERT INTO `zip_code` VALUES (150,'00928','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3932,-66.0617);
181INSERT INTO `zip_code` VALUES (151,'00929','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.402,-66.0232);
182INSERT INTO `zip_code` VALUES (152,'00930','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4053,-66.0624);
183INSERT INTO `zip_code` VALUES (153,'00931','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4098,-66.063);
184INSERT INTO `zip_code` VALUES (154,'00933','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4702,-66.1079);
185INSERT INTO `zip_code` VALUES (155,'00934','Fort Buchanan','Bayamon','Puerto Rico','PR','787','Atlantic',18.4132,-66.1316);
186INSERT INTO `zip_code` VALUES (156,'00935','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4105,-66.0656);
187INSERT INTO `zip_code` VALUES (157,'00936','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3852,-66.0631);
188INSERT INTO `zip_code` VALUES (158,'00937','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4109,-66.0638);
189INSERT INTO `zip_code` VALUES (159,'00938','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4106,-66.063);
190INSERT INTO `zip_code` VALUES (160,'00939','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4083,-66.0647);
191INSERT INTO `zip_code` VALUES (161,'00940','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4109,-66.0651);
192INSERT INTO `zip_code` VALUES (162,'00949','Toa Baja','Toa Baja','Puerto Rico','PR','787','Atlantic',18.4522,-66.1783);
193INSERT INTO `zip_code` VALUES (163,'00950','Toa Baja','Toa Baja','Puerto Rico','PR','787','Atlantic',18.4487,-66.1725);
194INSERT INTO `zip_code` VALUES (164,'00951','Toa Baja','Toa Baja','Puerto Rico','PR','787','Atlantic',18.4431,-66.2558);
195INSERT INTO `zip_code` VALUES (165,'00952','Sabana Seca','Toa Baja','Puerto Rico','PR','787','Atlantic',18.4238,-66.185);
196INSERT INTO `zip_code` VALUES (166,'00953','Toa Alta','Toa Alta','Puerto Rico','PR','787','Atlantic',18.3893,-66.2481);
197INSERT INTO `zip_code` VALUES (167,'00954','Toa Alta','Toa Alta','Puerto Rico','PR','787','Atlantic',18.39,-66.2462);
198INSERT INTO `zip_code` VALUES (168,'00955','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4093,-66.0647);
199INSERT INTO `zip_code` VALUES (169,'00956','Bayamon','Bayamon','Puerto Rico','PR','787','Atlantic',18.1792,-66.1134);
200INSERT INTO `zip_code` VALUES (170,'00957','Bayamon','Bayamon','Puerto Rico','PR','787','Atlantic',18.1783,-66.1111);
201INSERT INTO `zip_code` VALUES (171,'00958','Bayamon','Bayamon','Puerto Rico','PR','787','Atlantic',18.1772,-66.1162);
202INSERT INTO `zip_code` VALUES (172,'00959','Bayamon','Bayamon','Puerto Rico','PR','787','Atlantic',18.1781,-66.1167);
203INSERT INTO `zip_code` VALUES (173,'00960','Bayamon','Bayamon','Puerto Rico','PR','787','Atlantic',18.1803,-66.1163);
204INSERT INTO `zip_code` VALUES (174,'00961','Bayamon','Bayamon','Puerto Rico','PR','787','Atlantic',18.1808,-66.1122);
205INSERT INTO `zip_code` VALUES (175,'00962','Catano','Catano','Puerto Rico','PR','787','Atlantic',18.4443,-66.1386);
206INSERT INTO `zip_code` VALUES (176,'00963','Catano','Catano','Puerto Rico','PR','787','Atlantic',18.4462,-66.1402);
207INSERT INTO `zip_code` VALUES (177,'00965','Guaynabo','Guaynabo','Puerto Rico','PR','787','Atlantic',18.3863,-66.1175);
208INSERT INTO `zip_code` VALUES (178,'00966','Guaynabo','Guaynabo','Puerto Rico','PR','787','Atlantic',18.3882,-66.1144);
209INSERT INTO `zip_code` VALUES (179,'00968','Guaynabo','San Juan','Puerto Rico','PR','787','Atlantic',18.3868,-66.1158);
210INSERT INTO `zip_code` VALUES (180,'00969','Guaynabo','Guaynabo','Puerto Rico','PR','787','Atlantic',18.3866,-66.1135);
211INSERT INTO `zip_code` VALUES (181,'00970','Guaynabo','Guaynabo','Puerto Rico','PR','787','Atlantic',18.3851,-66.1157);
212INSERT INTO `zip_code` VALUES (182,'00971','Guaynabo','Guaynabo','Puerto Rico','PR','787','Atlantic',18.3885,-66.115);
213INSERT INTO `zip_code` VALUES (183,'00975','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4104,-66.0656);
214INSERT INTO `zip_code` VALUES (184,'00976','Trujillo Alto','Trujillo Alto','Puerto Rico','PR','787','Atlantic',18.3633,-66.0173);
215INSERT INTO `zip_code` VALUES (185,'00977','Trujillo Alto','Trujillo Alto','Puerto Rico','PR','787','Atlantic',18.3628,-66.0173);
216INSERT INTO `zip_code` VALUES (186,'00978','Saint Just','Trujillo Alto','Puerto Rico','PR','787','Atlantic',18.3682,-66.0117);
217INSERT INTO `zip_code` VALUES (187,'00979','Carolina','San Juan','Puerto Rico','PR','787','Atlantic',18.4048,-65.9789);
218INSERT INTO `zip_code` VALUES (188,'00981','Carolina','San Juan','Puerto Rico','PR','787','Atlantic',18.4065,-65.9786);
219INSERT INTO `zip_code` VALUES (189,'00982','Carolina','San Juan','Puerto Rico','PR','787','Atlantic',18.4078,-65.9794);
220INSERT INTO `zip_code` VALUES (190,'00983','Carolina','Carolina','Puerto Rico','PR','787','Atlantic',18.4091,-65.9811);
221INSERT INTO `zip_code` VALUES (191,'00984','Carolina','Carolina','Puerto Rico','PR','787','Atlantic',18.4089,-65.9819);
222INSERT INTO `zip_code` VALUES (192,'00985','Carolina','Carolina','Puerto Rico','PR','787','Atlantic',18.4092,-65.9814);
223INSERT INTO `zip_code` VALUES (193,'00986','Carolina','Carolina','Puerto Rico','PR','787','Atlantic',18.4089,-65.9812);
224INSERT INTO `zip_code` VALUES (194,'00987','Carolina','Carolina','Puerto Rico','PR','787','Atlantic',18.4102,-65.9794);
225INSERT INTO `zip_code` VALUES (195,'00988','Carolina','Carolina','Puerto Rico','PR','787','Atlantic',18.4067,-65.9803);
226INSERT INTO `zip_code` VALUES (196,'01001','Agawam','Hampden','Massachusetts','MA','413','Eastern',42.0715,-72.6243);
227INSERT INTO `zip_code` VALUES (197,'01002','Amherst','Hampshire','Massachusetts','MA','413','Eastern',42.3742,-72.5052);
228INSERT INTO `zip_code` VALUES (198,'01003','Amherst','Hampshire','Massachusetts','MA','413','Eastern',42.4052,-72.5284);
229INSERT INTO `zip_code` VALUES (199,'01004','Amherst','Hampshire','Massachusetts','MA','413','Eastern',42.3839,-72.5118);
230INSERT INTO `zip_code` VALUES (200,'01005','Barre','Worcester','Massachusetts','MA','978','Eastern',42.4333,-72.1145);
231INSERT INTO `zip_code` VALUES (201,'01007','Belchertown','Hampshire','Massachusetts','MA','413','Eastern',42.2819,-72.4095);
232INSERT INTO `zip_code` VALUES (202,'01008','Blandford','Hampden','Massachusetts','MA','413','Eastern',42.1432,-72.9319);
233INSERT INTO `zip_code` VALUES (203,'01009','Bondsville','Hampden','Massachusetts','MA','413','Eastern',42.208,-72.345);
234INSERT INTO `zip_code` VALUES (204,'01010','Brimfield','Hampden','Massachusetts','MA','413','Eastern',42.1292,-72.1961);
235INSERT INTO `zip_code` VALUES (205,'01011','Chester','Hampden','Massachusetts','MA','413','Eastern',42.2837,-72.9669);
236INSERT INTO `zip_code` VALUES (206,'01012','Chesterfield','Hampshire','Massachusetts','MA','413','Eastern',42.3872,-72.834);
237INSERT INTO `zip_code` VALUES (207,'01013','Chicopee','Hampden','Massachusetts','MA','413','Eastern',42.1623,-72.6045);
238INSERT INTO `zip_code` VALUES (208,'01014','Chicopee','Hampden','Massachusetts','MA','413','Eastern',42.1748,-72.5723);
239INSERT INTO `zip_code` VALUES (209,'01020','Chicopee','Hampden','Massachusetts','MA','413','Eastern',42.1756,-72.57);
240INSERT INTO `zip_code` VALUES (210,'01021','Chicopee','Hampden','Massachusetts','MA','413','Eastern',42.178,-72.5728);
241INSERT INTO `zip_code` VALUES (211,'01022','Chicopee','Hampden','Massachusetts','MA','413','Eastern',42.1948,-72.5619);
242INSERT INTO `zip_code` VALUES (212,'01026','Cummington','Hampshire','Massachusetts','MA','413','Eastern',42.4005,-72.8496);
243INSERT INTO `zip_code` VALUES (213,'01027','Easthampton','Hampshire','Massachusetts','MA','413','Eastern',42.2723,-72.6993);
244INSERT INTO `zip_code` VALUES (214,'01028','East Longmeadow','Hampden','Massachusetts','MA','413','Eastern',42.0684,-72.5043);
245INSERT INTO `zip_code` VALUES (215,'01029','East Otis','Berkshire','Massachusetts','MA','413','Eastern',42.1598,-73.0434);
246INSERT INTO `zip_code` VALUES (216,'01030','Feeding Hills','Hampden','Massachusetts','MA','413','Eastern',42.0724,-72.6752);
247INSERT INTO `zip_code` VALUES (217,'01031','Gilbertville','Worcester','Massachusetts','MA','413','Eastern',42.3122,-72.2025);
248INSERT INTO `zip_code` VALUES (218,'01032','Goshen','Hampshire','Massachusetts','MA','413','Eastern',42.4411,-72.8059);
249INSERT INTO `zip_code` VALUES (219,'01033','Granby','Hampshire','Massachusetts','MA','413','Eastern',42.2564,-72.5195);
250INSERT INTO `zip_code` VALUES (220,'01034','Granville','Hampden','Massachusetts','MA','413','Eastern',42.0733,-72.8966);
251INSERT INTO `zip_code` VALUES (221,'01035','Hadley','Hampshire','Massachusetts','MA','413','Eastern',42.36,-72.5775);
252INSERT INTO `zip_code` VALUES (222,'01036','Hampden','Hampden','Massachusetts','MA','413','Eastern',42.0629,-72.4303);
253INSERT INTO `zip_code` VALUES (223,'01037','Hardwick','Worcester','Massachusetts','MA','413','Eastern',42.3494,-72.2008);
254INSERT INTO `zip_code` VALUES (224,'01038','Hatfield','Hampshire','Massachusetts','MA','413','Eastern',42.3815,-72.6075);
255INSERT INTO `zip_code` VALUES (225,'01039','Haydenville','Hampshire','Massachusetts','MA','413','Eastern',42.3796,-72.6968);
256INSERT INTO `zip_code` VALUES (226,'01040','Holyoke','Hampden','Massachusetts','MA','413','Eastern',42.204,-72.6301);
257INSERT INTO `zip_code` VALUES (227,'01041','Holyoke','Hampden','Massachusetts','MA','413','Eastern',42.2075,-72.6114);
258INSERT INTO `zip_code` VALUES (228,'01050','Huntington','Hampshire','Massachusetts','MA','413','Eastern',42.2723,-72.8652);
259INSERT INTO `zip_code` VALUES (229,'01053','Leeds','Hampshire','Massachusetts','MA','413','Eastern',42.3544,-72.7015);
260INSERT INTO `zip_code` VALUES (230,'01054','Leverett','Franklin','Massachusetts','MA','413','Eastern',42.4747,-72.4825);
261INSERT INTO `zip_code` VALUES (231,'01056','Ludlow','Hampden','Massachusetts','MA','413','Eastern',42.1712,-72.4725);
262INSERT INTO `zip_code` VALUES (232,'01057','Monson','Hampden','Massachusetts','MA','413','Eastern',42.094,-72.324);
263INSERT INTO `zip_code` VALUES (233,'01059','North Amherst','Hampshire','Massachusetts','MA','413','Eastern',42.4133,-72.5305);
264INSERT INTO `zip_code` VALUES (234,'01060','Northampton','Hampshire','Massachusetts','MA','413','Eastern',42.3247,-72.6559);
265INSERT INTO `zip_code` VALUES (235,'01061','Northampton','Hampshire','Massachusetts','MA','413','Eastern',42.3233,-72.6904);
266INSERT INTO `zip_code` VALUES (236,'01062','Florence','Hampshire','Massachusetts','MA','413','Eastern',42.3316,-72.6926);
267INSERT INTO `zip_code` VALUES (237,'01063','Northampton','Hampshire','Massachusetts','MA','413','Eastern',42.3191,-72.6444);
268INSERT INTO `zip_code` VALUES (238,'01066','North Hatfield','Hampshire','Massachusetts','MA','413','Eastern',42.4106,-72.6256);
269INSERT INTO `zip_code` VALUES (239,'01068','Oakham','Worcester','Massachusetts','MA','508','Eastern',42.3464,-72.0492);
270INSERT INTO `zip_code` VALUES (240,'01069','Palmer','Hampden','Massachusetts','MA','413','Eastern',42.1655,-72.3144);
271INSERT INTO `zip_code` VALUES (241,'01070','Plainfield','Hampshire','Massachusetts','MA','413','Eastern',42.5368,-72.9331);
272INSERT INTO `zip_code` VALUES (242,'01071','Russell','Hampden','Massachusetts','MA','413','Eastern',42.1713,-72.8631);
273INSERT INTO `zip_code` VALUES (243,'01072','Shutesbury','Franklin','Massachusetts','MA','413','Eastern',42.4678,-72.4299);
274INSERT INTO `zip_code` VALUES (244,'01073','Southampton','Hampshire','Massachusetts','MA','413','Eastern',42.2256,-72.7217);
275INSERT INTO `zip_code` VALUES (245,'01074','South Barre','Worcester','Massachusetts','MA','978','Eastern',42.3829,-72.1005);
276INSERT INTO `zip_code` VALUES (246,'01075','South Hadley','Hampshire','Massachusetts','MA','413','Eastern',42.236,-72.5828);
277INSERT INTO `zip_code` VALUES (247,'01077','Southwick','Hampden','Massachusetts','MA','413','Eastern',42.0536,-72.7719);
278INSERT INTO `zip_code` VALUES (248,'01079','Thorndike','Hampden','Massachusetts','MA','413','Eastern',42.1889,-72.3298);
279INSERT INTO `zip_code` VALUES (249,'01080','Three Rivers','Hampden','Massachusetts','MA','413','Eastern',42.1815,-72.3721);
280INSERT INTO `zip_code` VALUES (250,'01081','Wales','Hampden','Massachusetts','MA','413','Eastern',42.0612,-72.2276);
281INSERT INTO `zip_code` VALUES (251,'01082','Ware','Hampshire','Massachusetts','MA','413','Eastern',42.2627,-72.2654);
282INSERT INTO `zip_code` VALUES (252,'01083','Warren','Worcester','Massachusetts','MA','413','Eastern',42.2127,-72.1941);
283INSERT INTO `zip_code` VALUES (253,'01084','West Chesterfield','Hampshire','Massachusetts','MA','413','Eastern',42.4087,-72.8892);
284INSERT INTO `zip_code` VALUES (254,'01085','Westfield','Hampden','Massachusetts','MA','413','Eastern',42.1319,-72.7495);
285INSERT INTO `zip_code` VALUES (255,'01086','Westfield','Hampden','Massachusetts','MA','413','Eastern',42.1402,-72.7561);
286INSERT INTO `zip_code` VALUES (256,'01088','West Hatfield','Hampshire','Massachusetts','MA','413','Eastern',42.3865,-72.6398);
287INSERT INTO `zip_code` VALUES (257,'01089','West Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1171,-72.6394);
288INSERT INTO `zip_code` VALUES (258,'01090','West Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1213,-72.6549);
289INSERT INTO `zip_code` VALUES (259,'01092','West Warren','Worcester','Massachusetts','MA','413','Eastern',42.2074,-72.234);
290INSERT INTO `zip_code` VALUES (260,'01093','Whately','Franklin','Massachusetts','MA','413','Eastern',42.4357,-72.6484);
291INSERT INTO `zip_code` VALUES (261,'01094','Wheelwright','Worcester','Massachusetts','MA','413','Eastern',42.3495,-72.1401);
292INSERT INTO `zip_code` VALUES (262,'01095','Wilbraham','Hampden','Massachusetts','MA','413','Eastern',42.1208,-72.4433);
293INSERT INTO `zip_code` VALUES (263,'01096','Williamsburg','Hampshire','Massachusetts','MA','413','Eastern',42.3993,-72.749);
294INSERT INTO `zip_code` VALUES (264,'01097','Woronoco','Hampden','Massachusetts','MA','413','Eastern',42.1607,-72.8398);
295INSERT INTO `zip_code` VALUES (265,'01098','Worthington','Hampshire','Massachusetts','MA','413','Eastern',42.3077,-72.8781);
296INSERT INTO `zip_code` VALUES (266,'01101','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.0999,-72.5896);
297INSERT INTO `zip_code` VALUES (267,'01102','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1161,-72.5386);
298INSERT INTO `zip_code` VALUES (268,'01103','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.102,-72.5871);
299INSERT INTO `zip_code` VALUES (269,'01104','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1281,-72.5715);
300INSERT INTO `zip_code` VALUES (270,'01105','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1011,-72.5792);
301INSERT INTO `zip_code` VALUES (271,'01106','Longmeadow','Hampden','Massachusetts','MA','413','Eastern',42.0524,-72.5678);
302INSERT INTO `zip_code` VALUES (272,'01107','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1229,-72.6072);
303INSERT INTO `zip_code` VALUES (273,'01108','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.0821,-72.5544);
304INSERT INTO `zip_code` VALUES (274,'01109','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1187,-72.5483);
305INSERT INTO `zip_code` VALUES (275,'01111','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.118,-72.5479);
306INSERT INTO `zip_code` VALUES (276,'01114','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1029,-72.5927);
307INSERT INTO `zip_code` VALUES (277,'01115','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.104,-72.5918);
308INSERT INTO `zip_code` VALUES (278,'01116','Longmeadow','Hampden','Massachusetts','MA','413','Eastern',42.0458,-72.5708);
309INSERT INTO `zip_code` VALUES (279,'01118','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.0939,-72.5279);
310INSERT INTO `zip_code` VALUES (280,'01119','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1229,-72.5064);
311INSERT INTO `zip_code` VALUES (281,'01128','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.094,-72.4948);
312INSERT INTO `zip_code` VALUES (282,'01129','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1229,-72.487);
313INSERT INTO `zip_code` VALUES (283,'01133','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1063,-72.5953);
314INSERT INTO `zip_code` VALUES (284,'01138','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.0886,-72.561);
315INSERT INTO `zip_code` VALUES (285,'01139','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1163,-72.5469);
316INSERT INTO `zip_code` VALUES (286,'01144','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1016,-72.5948);
317INSERT INTO `zip_code` VALUES (287,'01151','Indian Orchard','Hampden','Massachusetts','MA','413','Eastern',42.151,-72.5065);
318INSERT INTO `zip_code` VALUES (288,'01152','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1528,-72.5113);
319INSERT INTO `zip_code` VALUES (289,'01199','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1191,-72.6034);
320INSERT INTO `zip_code` VALUES (290,'01201','Pittsfield','Berkshire','Massachusetts','MA','413','Eastern',42.4555,-73.25);
321INSERT INTO `zip_code` VALUES (291,'01202','Pittsfield','Berkshire','Massachusetts','MA','413','Eastern',42.4579,-73.322);
322INSERT INTO `zip_code` VALUES (292,'01203','Pittsfield','Berkshire','Massachusetts','MA','413','Eastern',42.4532,-73.2628);
323INSERT INTO `zip_code` VALUES (293,'01220','Adams','Berkshire','Massachusetts','MA','413','Eastern',42.62,-73.1208);
324INSERT INTO `zip_code` VALUES (294,'01222','Ashley Falls','Berkshire','Massachusetts','MA','413','Eastern',42.0564,-73.3188);
325INSERT INTO `zip_code` VALUES (295,'01223','Becket','Berkshire','Massachusetts','MA','413','Eastern',42.3813,-73.1437);
326INSERT INTO `zip_code` VALUES (296,'01224','Berkshire','Berkshire','Massachusetts','MA','413','Eastern',42.4893,-73.1956);
327INSERT INTO `zip_code` VALUES (297,'01225','Cheshire','Berkshire','Massachusetts','MA','413','Eastern',42.5552,-73.156);
328INSERT INTO `zip_code` VALUES (298,'01226','Dalton','Berkshire','Massachusetts','MA','413','Eastern',42.4697,-73.1627);
329INSERT INTO `zip_code` VALUES (299,'01227','Dalton','Berkshire','Massachusetts','MA','413','Eastern',42.4724,-73.162);
330INSERT INTO `zip_code` VALUES (300,'01229','Glendale','Berkshire','Massachusetts','MA','413','Eastern',42.2861,-73.3468);
331INSERT INTO `zip_code` VALUES (301,'01230','Great Barrington','Berkshire','Massachusetts','MA','413','Eastern',42.2049,-73.3602);
332INSERT INTO `zip_code` VALUES (302,'01235','Hinsdale','Berkshire','Massachusetts','MA','413','Eastern',42.4334,-73.1067);
333INSERT INTO `zip_code` VALUES (303,'01236','Housatonic','Berkshire','Massachusetts','MA','413','Eastern',42.2534,-73.3675);
334INSERT INTO `zip_code` VALUES (304,'01237','Lanesboro','Berkshire','Massachusetts','MA','413','Eastern',42.5144,-73.2421);
335INSERT INTO `zip_code` VALUES (305,'01238','Lee','Berkshire','Massachusetts','MA','413','Eastern',42.312,-73.2477);
336INSERT INTO `zip_code` VALUES (306,'01240','Lenox','Berkshire','Massachusetts','MA','413','Eastern',42.3631,-73.2739);
337INSERT INTO `zip_code` VALUES (307,'01242','Lenox Dale','Berkshire','Massachusetts','MA','413','Eastern',42.33,-73.2503);
338INSERT INTO `zip_code` VALUES (308,'01243','Middlefield','Hampshire','Massachusetts','MA','413','Eastern',42.3465,-73.0083);
339INSERT INTO `zip_code` VALUES (309,'01244','Mill River','Berkshire','Massachusetts','MA','413','Eastern',42.1145,-73.2672);
340INSERT INTO `zip_code` VALUES (310,'01245','Monterey','Berkshire','Massachusetts','MA','413','Eastern',42.2052,-73.2281);
341INSERT INTO `zip_code` VALUES (311,'01247','North Adams','Berkshire','Massachusetts','MA','413','Eastern',42.6945,-73.1132);
342INSERT INTO `zip_code` VALUES (312,'01252','North Egremont','Berkshire','Massachusetts','MA','413','Eastern',42.1967,-73.4363);
343INSERT INTO `zip_code` VALUES (313,'01253','Otis','Berkshire','Massachusetts','MA','413','Eastern',42.1847,-73.0985);
344INSERT INTO `zip_code` VALUES (314,'01254','Richmond','Berkshire','Massachusetts','MA','413','Eastern',42.4017,-73.3482);
345INSERT INTO `zip_code` VALUES (315,'01255','Sandisfield','Berkshire','Massachusetts','MA','413','Eastern',42.1153,-73.1204);
346INSERT INTO `zip_code` VALUES (316,'01256','Savoy','Berkshire','Massachusetts','MA','413','Eastern',42.5763,-73.0309);
347INSERT INTO `zip_code` VALUES (317,'01257','Sheffield','Berkshire','Massachusetts','MA','413','Eastern',42.0771,-73.3953);
348INSERT INTO `zip_code` VALUES (318,'01258','South Egremont','Berkshire','Massachusetts','MA','413','Eastern',42.1207,-73.4742);
349INSERT INTO `zip_code` VALUES (319,'01259','Southfield','Berkshire','Massachusetts','MA','413','Eastern',42.0681,-73.2879);
350INSERT INTO `zip_code` VALUES (320,'01260','South Lee','Berkshire','Massachusetts','MA','413','Eastern',42.2812,-73.2789);
351INSERT INTO `zip_code` VALUES (321,'01262','Stockbridge','Berkshire','Massachusetts','MA','413','Eastern',42.304,-73.3159);
352INSERT INTO `zip_code` VALUES (322,'01263','Stockbridge','Berkshire','Massachusetts','MA','413','Eastern',42.289,-73.3195);
353INSERT INTO `zip_code` VALUES (323,'01264','Tyringham','Berkshire','Massachusetts','MA','413','Eastern',42.2435,-73.2055);
354INSERT INTO `zip_code` VALUES (324,'01266','West Stockbridge','Berkshire','Massachusetts','MA','413','Eastern',42.3331,-73.3804);
355INSERT INTO `zip_code` VALUES (325,'01267','Williamstown','Berkshire','Massachusetts','MA','413','Eastern',42.6995,-73.2102);
356INSERT INTO `zip_code` VALUES (326,'01270','Windsor','Berkshire','Massachusetts','MA','413','Eastern',42.3364,-73.2544);
357INSERT INTO `zip_code` VALUES (327,'01301','Greenfield','Franklin','Massachusetts','MA','413','Eastern',42.6029,-72.5986);
358INSERT INTO `zip_code` VALUES (328,'01302','Greenfield','Franklin','Massachusetts','MA','413','Eastern',42.652,-72.6096);
359INSERT INTO `zip_code` VALUES (329,'01330','Ashfield','Franklin','Massachusetts','MA','413','Eastern',42.5225,-72.7857);
360INSERT INTO `zip_code` VALUES (330,'01331','Athol','Worcester','Massachusetts','MA','978','Eastern',42.5889,-72.2241);
361INSERT INTO `zip_code` VALUES (331,'01337','Bernardston','Franklin','Massachusetts','MA','413','Eastern',42.6654,-72.5373);
362INSERT INTO `zip_code` VALUES (332,'01338','Buckland','Franklin','Massachusetts','MA','413','Eastern',42.5989,-72.7409);
363INSERT INTO `zip_code` VALUES (333,'01339','Charlemont','Franklin','Massachusetts','MA','413','Eastern',42.6339,-72.8756);
364INSERT INTO `zip_code` VALUES (334,'01340','Colrain','Franklin','Massachusetts','MA','413','Eastern',42.7117,-72.7191);
365INSERT INTO `zip_code` VALUES (335,'01341','Conway','Franklin','Massachusetts','MA','413','Eastern',42.511,-72.6881);
366INSERT INTO `zip_code` VALUES (336,'01342','Deerfield','Franklin','Massachusetts','MA','413','Eastern',42.5537,-72.5893);
367INSERT INTO `zip_code` VALUES (337,'01343','Drury','Berkshire','Massachusetts','MA','413','Eastern',42.6438,-72.9879);
368INSERT INTO `zip_code` VALUES (338,'01344','Erving','Franklin','Massachusetts','MA','978','Eastern',42.606,-72.4107);
369INSERT INTO `zip_code` VALUES (339,'01346','Heath','Franklin','Massachusetts','MA','413','Eastern',42.6822,-72.8382);
370INSERT INTO `zip_code` VALUES (340,'01347','Lake Pleasant','Franklin','Massachusetts','MA','413','Eastern',42.5576,-72.5187);
371INSERT INTO `zip_code` VALUES (341,'01349','Turners Falls','Franklin','Massachusetts','MA','413','Eastern',42.5787,-72.4921);
372INSERT INTO `zip_code` VALUES (342,'01350','Monroe Bridge','Franklin','Massachusetts','MA','413','Eastern',42.717,-72.9473);
373INSERT INTO `zip_code` VALUES (343,'01351','Montague','Franklin','Massachusetts','MA','413','Eastern',42.5367,-72.5301);
374INSERT INTO `zip_code` VALUES (344,'01354','Northfield','Franklin','Massachusetts','MA','413','Eastern',42.6759,-72.4485);
375INSERT INTO `zip_code` VALUES (345,'01355','New Salem','Franklin','Massachusetts','MA','978','Eastern',42.4857,-72.3413);
376INSERT INTO `zip_code` VALUES (346,'01360','Northfield','Franklin','Massachusetts','MA','413','Eastern',42.7005,-72.4509);
377INSERT INTO `zip_code` VALUES (347,'01364','Orange','Franklin','Massachusetts','MA','978','Eastern',42.6,-72.3056);
378INSERT INTO `zip_code` VALUES (348,'01366','Petersham','Worcester','Massachusetts','MA','978','Eastern',42.4723,-72.2041);
379INSERT INTO `zip_code` VALUES (349,'01367','Rowe','Franklin','Massachusetts','MA','413','Eastern',42.6894,-72.9354);
380INSERT INTO `zip_code` VALUES (350,'01368','Royalston','Worcester','Massachusetts','MA','978','Eastern',42.6849,-72.196);
381INSERT INTO `zip_code` VALUES (351,'01370','Shelburne Falls','Franklin','Massachusetts','MA','413','Eastern',42.5959,-72.7334);
382INSERT INTO `zip_code` VALUES (352,'01373','South Deerfield','Franklin','Massachusetts','MA','413','Eastern',42.4764,-72.6107);
383INSERT INTO `zip_code` VALUES (353,'01375','Sunderland','Franklin','Massachusetts','MA','413','Eastern',42.4613,-72.5637);
384INSERT INTO `zip_code` VALUES (354,'01376','Turners Falls','Franklin','Massachusetts','MA','413','Eastern',42.6047,-72.5465);
385INSERT INTO `zip_code` VALUES (355,'01378','Warwick','Franklin','Massachusetts','MA','413','Eastern',42.6773,-72.3431);
386INSERT INTO `zip_code` VALUES (356,'01379','Wendell','Franklin','Massachusetts','MA','978','Eastern',42.5616,-72.3856);
387INSERT INTO `zip_code` VALUES (357,'01380','Wendell Depot','Franklin','Massachusetts','MA','978','Eastern',42.5695,-72.4064);
388INSERT INTO `zip_code` VALUES (358,'01420','Fitchburg','Worcester','Massachusetts','MA','978','Eastern',42.5763,-71.8021);
389INSERT INTO `zip_code` VALUES (359,'01430','Ashburnham','Worcester','Massachusetts','MA','978','Eastern',42.6536,-71.9243);
390INSERT INTO `zip_code` VALUES (360,'01431','Ashby','Middlesex','Massachusetts','MA','978','Eastern',42.6778,-71.8112);
391INSERT INTO `zip_code` VALUES (361,'01432','Ayer','Middlesex','Massachusetts','MA','978','Eastern',42.5598,-71.5753);
392INSERT INTO `zip_code` VALUES (362,'01436','Baldwinville','Worcester','Massachusetts','MA','978','Eastern',42.6046,-72.0707);
393INSERT INTO `zip_code` VALUES (363,'01438','East Templeton','Worcester','Massachusetts','MA','978','Eastern',42.5637,-72.0404);
394INSERT INTO `zip_code` VALUES (364,'01440','Gardner','Worcester','Massachusetts','MA','978','Eastern',42.5745,-71.9954);
395INSERT INTO `zip_code` VALUES (365,'01441','Westminster','Worcester','Massachusetts','MA','978','Eastern',42.5736,-71.9946);
396INSERT INTO `zip_code` VALUES (366,'01450','Groton','Middlesex','Massachusetts','MA','978','Eastern',42.6084,-71.5566);
397INSERT INTO `zip_code` VALUES (367,'01451','Harvard','Worcester','Massachusetts','MA','978','Eastern',42.5031,-71.5759);
398INSERT INTO `zip_code` VALUES (368,'01452','Hubbardston','Worcester','Massachusetts','MA','978','Eastern',42.4879,-72.0071);
399INSERT INTO `zip_code` VALUES (369,'01453','Leominster','Worcester','Massachusetts','MA','978','Eastern',42.5253,-71.7535);
400INSERT INTO `zip_code` VALUES (370,'01460','Littleton','Middlesex','Massachusetts','MA','978','Eastern',42.5435,-71.4842);
401INSERT INTO `zip_code` VALUES (371,'01462','Lunenburg','Worcester','Massachusetts','MA','978','Eastern',42.5889,-71.7314);
402INSERT INTO `zip_code` VALUES (372,'01463','Pepperell','Middlesex','Massachusetts','MA','978','Eastern',42.6734,-71.5914);
403INSERT INTO `zip_code` VALUES (373,'01464','Shirley','Middlesex','Massachusetts','MA','978','Eastern',42.5595,-71.6464);
404INSERT INTO `zip_code` VALUES (374,'01467','Still River','Worcester','Massachusetts','MA','978','Eastern',42.4837,-71.6216);
405INSERT INTO `zip_code` VALUES (375,'01468','Templeton','Worcester','Massachusetts','MA','978','Eastern',42.5499,-72.0658);
406INSERT INTO `zip_code` VALUES (376,'01469','Townsend','Middlesex','Massachusetts','MA','978','Eastern',42.6537,-71.6916);
407INSERT INTO `zip_code` VALUES (377,'01470','Groton','Middlesex','Massachusetts','MA','978','Eastern',42.6083,-71.5719);
408INSERT INTO `zip_code` VALUES (378,'01471','Groton','Middlesex','Massachusetts','MA','978','Eastern',42.6079,-71.5723);
409INSERT INTO `zip_code` VALUES (379,'01472','West Groton','Middlesex','Massachusetts','MA','978','Eastern',42.6066,-71.6291);
410INSERT INTO `zip_code` VALUES (380,'01473','Westminster','Worcester','Massachusetts','MA','978','Eastern',42.5409,-71.9061);
411INSERT INTO `zip_code` VALUES (381,'01474','West Townsend','Middlesex','Massachusetts','MA','978','Eastern',42.6698,-71.7455);
412INSERT INTO `zip_code` VALUES (382,'01475','Winchendon','Worcester','Massachusetts','MA','978','Eastern',42.678,-72.0451);
413INSERT INTO `zip_code` VALUES (383,'01477','Winchendon Springs','Worcester','Massachusetts','MA','978','Eastern',42.6959,-72.0178);
414INSERT INTO `zip_code` VALUES (384,'01501','Auburn','Worcester','Massachusetts','MA','508','Eastern',42.205,-71.8405);
415INSERT INTO `zip_code` VALUES (385,'01503','Berlin','Worcester','Massachusetts','MA','978','Eastern',42.3741,-71.6324);
416INSERT INTO `zip_code` VALUES (386,'01504','Blackstone','Worcester','Massachusetts','MA','508','Eastern',42.0263,-71.5285);
417INSERT INTO `zip_code` VALUES (387,'01505','Boylston','Worcester','Massachusetts','MA','508','Eastern',42.3316,-71.7341);
418INSERT INTO `zip_code` VALUES (388,'01506','Brookfield','Worcester','Massachusetts','MA','508','Eastern',42.2033,-72.1001);
419INSERT INTO `zip_code` VALUES (389,'01507','Charlton','Worcester','Massachusetts','MA','508','Eastern',42.1484,-71.9413);
420INSERT INTO `zip_code` VALUES (390,'01508','Charlton City','Worcester','Massachusetts','MA','508','Eastern',42.1514,-71.9896);
421INSERT INTO `zip_code` VALUES (391,'01509','Charlton Depot','Worcester','Massachusetts','MA','508','Eastern',42.173,-71.9756);
422INSERT INTO `zip_code` VALUES (392,'01510','Clinton','Worcester','Massachusetts','MA','978','Eastern',42.4193,-71.6851);
423INSERT INTO `zip_code` VALUES (393,'01515','East Brookfield','Worcester','Massachusetts','MA','508','Eastern',42.2226,-72.053);
424INSERT INTO `zip_code` VALUES (394,'01516','Douglas','Worcester','Massachusetts','MA','508','Eastern',42.0926,-71.7167);
425INSERT INTO `zip_code` VALUES (395,'01517','East Princeton','Worcester','Massachusetts','MA','508','Eastern',42.4702,-71.8402);
426INSERT INTO `zip_code` VALUES (396,'01518','Fiskdale','Worcester','Massachusetts','MA','508','Eastern',42.1209,-72.1102);
427INSERT INTO `zip_code` VALUES (397,'01519','Grafton','Worcester','Massachusetts','MA','508','Eastern',42.201,-71.688);
428INSERT INTO `zip_code` VALUES (398,'01520','Holden','Worcester','Massachusetts','MA','508','Eastern',42.3458,-71.8463);
429INSERT INTO `zip_code` VALUES (399,'01521','Holland','Hampden','Massachusetts','MA','413','Eastern',42.0425,-72.1498);
430INSERT INTO `zip_code` VALUES (400,'01522','Jefferson','Worcester','Massachusetts','MA','508','Eastern',42.3746,-71.8668);
431INSERT INTO `zip_code` VALUES (401,'01523','Lancaster','Worcester','Massachusetts','MA','978','East…

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