PageRenderTime 51ms CodeModel.GetById 24ms RepoModel.GetById 1ms app.codeStats 1ms

/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. 

  2. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    3. 

  3. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    4. 

  4. /*!40101 SET NAMES utf8 */;
    5. 

  5. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    6. 

  6. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    7. 

  7. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    8. 

  8. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    9. 

  9. DROP TABLE IF EXISTS `zip_code`;
    10. 

  10. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    11. 

  11. /*!40101 SET character_set_client = utf8 */;
    12. 

  12. CREATE TABLE `zip_code` (
    13. 

  13.   `zip_code_id` int(11) NOT NULL,
    14. 

  14.   `zip_code` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
    15. 

  15.   `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    16. 

  16.   `county` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    17. 

  17.   `state_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    18. 

  18.   `state_prefix` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
    19. 

  19.   `area_code` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
    20. 

  20.   `time_zone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    21. 

  21.   `lat` float NOT NULL,
    22. 

  22.   `lon` float NOT NULL,
    23. 

  23.   PRIMARY KEY (`zip_code_id`),
    24. 

  24.   UNIQUE KEY `zip_code` (`zip_code`),
    25. 

  25.   KEY `city_state` (`city`,`state_prefix`)
    26. 

  26. );
    27. 

  27. /*!40101 SET character_set_client = @saved_cs_client */;
    28. 

  28. 

  29. LOCK TABLES `zip_code` WRITE;
    30. 

  30. /*!40000 ALTER TABLE `zip_code` DISABLE KEYS */;
    31. 

  31. INSERT INTO `zip_code` VALUES (1,'00501','Holtsville','Suffolk','New York','NY','631','Eastern',40.8131,-73.0464);
    32. 

  32. INSERT INTO `zip_code` VALUES (2,'00544','Holtsville','Suffolk','New York','NY','631','Eastern',40.8132,-73.0493);
    33. 

  33. INSERT INTO `zip_code` VALUES (3,'00601','Adjuntas','Adjuntas','Puerto Rico','PR','787','Atlantic',18.166,-66.7236);
    34. 

  34. INSERT INTO `zip_code` VALUES (4,'00602','Aguada','Aguada','Puerto Rico','PR','787','Atlantic',18.383,-67.1866);
    35. 

  35. INSERT INTO `zip_code` VALUES (5,'00603','Aguadilla','Aguadilla','Puerto Rico','PR','787','Atlantic',18.4332,-67.152);
    36. 

  36. INSERT INTO `zip_code` VALUES (6,'00604','Aguadilla','Aguadilla','Puerto Rico','PR','787','Atlantic',18.5053,-67.1359);
    37. 

  37. INSERT INTO `zip_code` VALUES (7,'00605','Aguadilla','Aguadilla','Puerto Rico','PR','787','Atlantic',18.4361,-67.1513);
    38. 

  38. INSERT INTO `zip_code` VALUES (8,'00606','Maricao','Maricao','Puerto Rico','PR','787','Atlantic',18.1856,-66.9774);
    39. 

  39. INSERT INTO `zip_code` VALUES (9,'00610','Anasco','Anasco','Puerto Rico','PR','787','Atlantic',18.2859,-67.1442);
    40. 

  40. INSERT INTO `zip_code` VALUES (10,'00611','Angeles','Utuado','Puerto Rico','PR','787','Atlantic',18.2877,-66.7976);
    41. 

  41. INSERT INTO `zip_code` VALUES (11,'00612','Arecibo','Arecibo','Puerto Rico','PR','787','Atlantic',18.4713,-66.7281);
    42. 

  42. INSERT INTO `zip_code` VALUES (12,'00613','Arecibo','Arecibo','Puerto Rico','PR','787','Atlantic',18.4727,-66.7193);
    43. 

  43. INSERT INTO `zip_code` VALUES (13,'00614','Arecibo','Arecibo','Puerto Rico','PR','787','Atlantic',18.4569,-66.7359);
    44. 

  44. INSERT INTO `zip_code` VALUES (14,'00616','Bajadero','Arecibo','Puerto Rico','PR','787','Atlantic',18.4265,-66.6738);
    45. 

  45. INSERT INTO `zip_code` VALUES (15,'00617','Barceloneta','Barceloneta','Puerto Rico','PR','787','Atlantic',18.4588,-66.5372);
    46. 

  46. INSERT INTO `zip_code` VALUES (16,'00622','Boqueron','Cabo Rojo','Puerto Rico','PR','787','Atlantic',18.018,-67.1706);
    47. 

  47. INSERT INTO `zip_code` VALUES (17,'00623','Cabo Rojo','Cabo Rojo','Puerto Rico','PR','787','Atlantic',18.0867,-67.1518);
    48. 

  48. INSERT INTO `zip_code` VALUES (18,'00624','Penuelas','Penuelas','Puerto Rico','PR','787','Atlantic',18.0635,-66.7236);
    49. 

  49. INSERT INTO `zip_code` VALUES (19,'00627','Camuy','Camuy','Puerto Rico','PR','787','Atlantic',18.4859,-66.8441);
    50. 

  50. INSERT INTO `zip_code` VALUES (20,'00631','Castaner','Lares','Puerto Rico','PR','787','Atlantic',18.1803,-66.8329);
    51. 

  51. INSERT INTO `zip_code` VALUES (21,'00636','Rosario','San German','Puerto Rico','PR','787','Atlantic',18.1621,-67.0779);
    52. 

  52. INSERT INTO `zip_code` VALUES (22,'00637','Sabana Grande','Sabana Grande','Puerto Rico','PR','787','Atlantic',18.0817,-66.968);
    53. 

  53. INSERT INTO `zip_code` VALUES (23,'00638','Ciales','Ciales','Puerto Rico','PR','787','Atlantic',18.3388,-66.4664);
    54. 

  54. INSERT INTO `zip_code` VALUES (24,'00641','Utuado','Utuado','Puerto Rico','PR','787','Atlantic',18.2689,-66.7044);
    55. 

  55. INSERT INTO `zip_code` VALUES (25,'00646','Dorado','Dorado','Puerto Rico','PR','787','Atlantic',18.4666,-66.2705);
    56. 

  56. INSERT INTO `zip_code` VALUES (26,'00647','Ensenada','Guanica','Puerto Rico','PR','787','Atlantic',17.9673,-66.9399);
    57. 

  57. INSERT INTO `zip_code` VALUES (27,'00650','Florida','Florida','Puerto Rico','PR','787','Atlantic',18.3626,-66.5654);
    58. 

  58. INSERT INTO `zip_code` VALUES (28,'00652','Garrochales','Arecibo','Puerto Rico','PR','787','Atlantic',18.4662,-66.5694);
    59. 

  59. INSERT INTO `zip_code` VALUES (29,'00653','Guanica','Guanica','Puerto Rico','PR','787','Atlantic',17.974,-66.9087);
    60. 

  60. INSERT INTO `zip_code` VALUES (30,'00656','Guayanilla','Guayanilla','Puerto Rico','PR','787','Atlantic',18.026,-66.7876);
    61. 

  61. INSERT INTO `zip_code` VALUES (31,'00659','Hatillo','Hatillo','Puerto Rico','PR','787','Atlantic',18.4854,-66.8249);
    62. 

  62. INSERT INTO `zip_code` VALUES (32,'00660','Hormigueros','Hormigueros','Puerto Rico','PR','787','Atlantic',18.1409,-67.1282);
    63. 

  63. INSERT INTO `zip_code` VALUES (33,'00662','Isabela','Isabela','Puerto Rico','PR','787','Atlantic',18.5012,-67.0228);
    64. 

  64. INSERT INTO `zip_code` VALUES (34,'00664','Jayuya','Jayuya','Puerto Rico','PR','787','Atlantic',18.2198,-66.5914);
    65. 

  65. INSERT INTO `zip_code` VALUES (35,'00667','Lajas','Lajas','Puerto Rico','PR','787','Atlantic',18.0452,-67.0579);
    66. 

  66. INSERT INTO `zip_code` VALUES (36,'00669','Lares','Lares','Puerto Rico','PR','787','Atlantic',18.2944,-66.8844);
    67. 

  67. INSERT INTO `zip_code` VALUES (37,'00670','Las Marias','Las Marias','Puerto Rico','PR','787','Atlantic',18.2964,-67.1466);
    68. 

  68. INSERT INTO `zip_code` VALUES (38,'00674','Manati','Manati','Puerto Rico','PR','787','Atlantic',18.4306,-66.4847);
    69. 

  69. INSERT INTO `zip_code` VALUES (39,'00676','Moca','Moca','Puerto Rico','PR','787','Atlantic',18.3994,-67.1133);
    70. 

  70. INSERT INTO `zip_code` VALUES (40,'00677','Rincon','Rincon','Puerto Rico','PR','787','Atlantic',18.3433,-67.2559);
    71. 

  71. INSERT INTO `zip_code` VALUES (41,'00678','Quebradillas','Quebradillas','Puerto Rico','PR','787','Atlantic',18.4749,-66.9373);
    72. 

  72. INSERT INTO `zip_code` VALUES (42,'00680','Mayaguez','Mayaguez','Puerto Rico','PR','787','Atlantic',18.2038,-67.1453);
    73. 

  73. INSERT INTO `zip_code` VALUES (43,'00681','Mayaguez','Mayaguez','Puerto Rico','PR','787','Atlantic',18.2043,-67.1447);
    74. 

  74. INSERT INTO `zip_code` VALUES (44,'00682','Mayaguez','Mayaguez','Puerto Rico','PR','787','Atlantic',18.2038,-67.1435);
    75. 

  75. INSERT INTO `zip_code` VALUES (45,'00683','San German','San German','Puerto Rico','PR','787','Atlantic',18.084,-67.0463);
    76. 

  76. INSERT INTO `zip_code` VALUES (46,'00685','San Sebastian','San Sebastian','Puerto Rico','PR','787','Atlantic',18.3415,-66.9963);
    77. 

  77. INSERT INTO `zip_code` VALUES (47,'00687','Morovis','Morovis','Puerto Rico','PR','787','Atlantic',18.3291,-66.4042);
    78. 

  78. INSERT INTO `zip_code` VALUES (48,'00688','Sabana Hoyos','Arecibo','Puerto Rico','PR','787','Atlantic',18.4302,-66.6126);
    79. 

  79. INSERT INTO `zip_code` VALUES (49,'00690','San Antonio','Aguadilla','Puerto Rico','PR','787','Atlantic',18.4954,-67.0977);
    80. 

  80. INSERT INTO `zip_code` VALUES (50,'00692','Vega Alta','Vega Alta','Puerto Rico','PR','787','Atlantic',18.4137,-66.319);
    81. 

  81. INSERT INTO `zip_code` VALUES (51,'00693','Vega Baja','Vega Baja','Puerto Rico','PR','787','Atlantic',18.4419,-66.3989);
    82. 

  82. INSERT INTO `zip_code` VALUES (52,'00694','Vega Baja','Vega Baja','Puerto Rico','PR','787','Atlantic',18.4446,-66.4026);
    83. 

  83. INSERT INTO `zip_code` VALUES (53,'00698','Yauco','Yauco','Puerto Rico','PR','787','Atlantic',18.0353,-66.8633);
    84. 

  84. INSERT INTO `zip_code` VALUES (54,'00703','Aguas Buenas','Aguas Buenas','Puerto Rico','PR','787','Atlantic',18.2616,-66.1039);
    85. 

  85. INSERT INTO `zip_code` VALUES (55,'00704','Aguirre','Guayama','Puerto Rico','PR','787','Atlantic',18.2512,-66.1014);
    86. 

  86. INSERT INTO `zip_code` VALUES (56,'00705','Aibonito','Aibonito','Puerto Rico','PR','787','Atlantic',18.1421,-66.2676);
    87. 

  87. INSERT INTO `zip_code` VALUES (57,'00707','Maunabo','Maunabo','Puerto Rico','PR','787','Atlantic',18.0103,-65.8969);
    88. 

  88. INSERT INTO `zip_code` VALUES (58,'00714','Arroyo','Arroyo','Puerto Rico','PR','787','Atlantic',17.9701,-66.0642);
    89. 

  89. INSERT INTO `zip_code` VALUES (59,'00715','Mercedita','Ponce','Puerto Rico','PR','787','Atlantic',18.0149,-66.5865);
    90. 

  90. INSERT INTO `zip_code` VALUES (60,'00716','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0146,-66.6147);
    91. 

  91. INSERT INTO `zip_code` VALUES (61,'00717','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0133,-66.6145);
    92. 

  92. INSERT INTO `zip_code` VALUES (62,'00718','Naguabo','Naguabo','Puerto Rico','PR','787','Atlantic',18.2149,-65.7324);
    93. 

  93. INSERT INTO `zip_code` VALUES (63,'00719','Naranjito','Naranjito','Puerto Rico','PR','787','Atlantic',18.3016,-66.2443);
    94. 

  94. INSERT INTO `zip_code` VALUES (64,'00720','Orocovis','Orocovis','Puerto Rico','PR','787','Atlantic',18.2291,-66.3915);
    95. 

  95. INSERT INTO `zip_code` VALUES (65,'00721','Palmer','Rio Grande','Puerto Rico','PR','787','Atlantic',18.3718,-65.7745);
    96. 

  96. INSERT INTO `zip_code` VALUES (66,'00723','Patillas','Patillas','Puerto Rico','PR','787','Atlantic',18.0107,-66.0152);
    97. 

  97. INSERT INTO `zip_code` VALUES (67,'00725','Caguas','Caguas','Puerto Rico','PR','787','Atlantic',18.2362,-66.0413);
    98. 

  98. INSERT INTO `zip_code` VALUES (68,'00726','Caguas','Caguas','Puerto Rico','PR','787','Atlantic',18.233,-66.036);
    99. 

  99. INSERT INTO `zip_code` VALUES (69,'00727','Caguas','Caguas','Puerto Rico','PR','787','Atlantic',18.234,-66.0364);
    100. 

  100. INSERT INTO `zip_code` VALUES (70,'00728','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0131,-66.614);
    101. 

  101. INSERT INTO `zip_code` VALUES (71,'00729','Canovanas','Canovanas','Puerto Rico','PR','787','Atlantic',18.3799,-65.909);
    102. 

  102. INSERT INTO `zip_code` VALUES (72,'00730','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0137,-66.6134);
    103. 

  103. INSERT INTO `zip_code` VALUES (73,'00731','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0141,-66.6172);
    104. 

  104. INSERT INTO `zip_code` VALUES (74,'00732','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0361,-66.6114);
    105. 

  105. INSERT INTO `zip_code` VALUES (75,'00733','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',18.0208,-66.6201);
    106. 

  106. INSERT INTO `zip_code` VALUES (76,'00734','Ponce','Ponce','Puerto Rico','PR','787','Atlantic',17.9867,-66.609);
    107. 

  107. INSERT INTO `zip_code` VALUES (77,'00735','Ceiba','Ceiba','Puerto Rico','PR','787','Atlantic',18.2605,-65.6403);
    108. 

  108. INSERT INTO `zip_code` VALUES (78,'00736','Cayey','Cayey','Puerto Rico','PR','787','Atlantic',18.1183,-66.161);
    109. 

  109. INSERT INTO `zip_code` VALUES (79,'00737','Cayey','Cayey','Puerto Rico','PR','787','Atlantic',18.1154,-66.161);
    110. 

  110. INSERT INTO `zip_code` VALUES (80,'00738','Fajardo','Fajardo','Puerto Rico','PR','787','Atlantic',18.3323,-65.6593);
    111. 

  111. INSERT INTO `zip_code` VALUES (81,'00739','Cidra','Cidra','Puerto Rico','PR','787','Atlantic',18.1774,-66.1561);
    112. 

  112. INSERT INTO `zip_code` VALUES (82,'00740','Puerto Real','Fajardo','Puerto Rico','PR','787','Atlantic',18.3333,-65.633);
    113. 

  113. INSERT INTO `zip_code` VALUES (83,'00741','Punta Santiago','Humacao','Puerto Rico','PR','787','Atlantic',18.1687,-65.7472);
    114. 

  114. INSERT INTO `zip_code` VALUES (84,'00742','Roosevelt Roads','Ceiba','Puerto Rico','PR','787','Atlantic',18.2389,-65.6274);
    115. 

  115. INSERT INTO `zip_code` VALUES (85,'00744','Rio Blanco','Naguabo','Puerto Rico','PR','787','Atlantic',18.2177,-65.7956);
    116. 

  116. INSERT INTO `zip_code` VALUES (86,'00745','Rio Grande','Rio Grande','Puerto Rico','PR','787','Atlantic',18.3834,-65.8381);
    117. 

  117. INSERT INTO `zip_code` VALUES (87,'00751','Salinas','Salinas','Puerto Rico','PR','787','Atlantic',17.9888,-66.2875);
    118. 

  118. INSERT INTO `zip_code` VALUES (88,'00754','San Lorenzo','San Lorenzo','Puerto Rico','PR','787','Atlantic',18.1885,-65.9589);
    119. 

  119. INSERT INTO `zip_code` VALUES (89,'00757','Santa Isabel','Santa Isabel','Puerto Rico','PR','787','Atlantic',17.9682,-66.4027);
    120. 

  120. INSERT INTO `zip_code` VALUES (90,'00765','Vieques','Vieques','Puerto Rico','PR','787','Atlantic',18.1309,-65.4534);
    121. 

  121. INSERT INTO `zip_code` VALUES (91,'00766','Villalba','Villalba','Puerto Rico','PR','787','Atlantic',18.1296,-66.4905);
    122. 

  122. INSERT INTO `zip_code` VALUES (92,'00767','Yabucoa','Yabucoa','Puerto Rico','PR','787','Atlantic',18.0515,-65.8809);
    123. 

  123. INSERT INTO `zip_code` VALUES (93,'00769','Coamo','Coamo','Puerto Rico','PR','787','Atlantic',18.0821,-66.36);
    124. 

  124. INSERT INTO `zip_code` VALUES (94,'00771','Las Piedras','Las Piedras','Puerto Rico','PR','787','Atlantic',18.1821,-65.8692);
    125. 

  125. INSERT INTO `zip_code` VALUES (95,'00772','Loiza','Loiza','Puerto Rico','PR','787','Atlantic',18.4339,-65.8808);
    126. 

  126. INSERT INTO `zip_code` VALUES (96,'00773','Luquillo','Luquillo','Puerto Rico','PR','787','Atlantic',18.3757,-65.7206);
    127. 

  127. INSERT INTO `zip_code` VALUES (97,'00775','Culebra','Culebra','Puerto Rico','PR','787','Atlantic',18.3115,-65.3055);
    128. 

  128. INSERT INTO `zip_code` VALUES (98,'00777','Juncos','Juncos','Puerto Rico','PR','787','Atlantic',18.2291,-65.9184);
    129. 

  129. INSERT INTO `zip_code` VALUES (99,'00778','Gurabo','Gurabo','Puerto Rico','PR','787','Atlantic',18.2571,-65.9757);
    130. 

  130. INSERT INTO `zip_code` VALUES (100,'00780','Coto Laurel','Ponce','Puerto Rico','PR','787','Atlantic',18.0468,-66.5502);
    131. 

  131. INSERT INTO `zip_code` VALUES (101,'00782','Comerio','Comerio','Puerto Rico','PR','787','Atlantic',18.2219,-66.2272);
    132. 

  132. INSERT INTO `zip_code` VALUES (102,'00783','Corozal','Corozal','Puerto Rico','PR','787','Atlantic',18.3426,-66.3111);
    133. 

  133. INSERT INTO `zip_code` VALUES (103,'00784','Guayama','Guayama','Puerto Rico','PR','787','Atlantic',17.9798,-66.1115);
    134. 

  134. INSERT INTO `zip_code` VALUES (104,'00785','Guayama','Guayanilla','Puerto Rico','PR','787','Atlantic',17.9789,-66.1102);
    135. 

  135. INSERT INTO `zip_code` VALUES (105,'00786','La Plata','Aibonito','Puerto Rico','PR','787','Atlantic',18.1582,-66.236);
    136. 

  136. INSERT INTO `zip_code` VALUES (106,'00791','Humacao','Humacao','Puerto Rico','PR','787','Atlantic',18.1545,-65.8208);
    137. 

  137. INSERT INTO `zip_code` VALUES (107,'00792','Humacao','Humacao','Puerto Rico','PR','787','Atlantic',18.1513,-65.8219);
    138. 

  138. INSERT INTO `zip_code` VALUES (108,'00794','Barranquitas','Barranquitas','Puerto Rico','PR','787','Atlantic',18.1876,-66.3074);
    139. 

  139. INSERT INTO `zip_code` VALUES (109,'00795','Juana Diaz','Juana Diaz','Puerto Rico','PR','787','Atlantic',18.0539,-66.5053);
    140. 

  140. INSERT INTO `zip_code` VALUES (110,'00801','Saint Thomas','Saint Thomas','Virgin Islands','VI','340','Atlantic',18.3498,-64.9432);
    141. 

  141. INSERT INTO `zip_code` VALUES (111,'00802','Saint Thomas','Saint Thomas','Virgin Islands','VI','340','Atlantic',18.3488,-64.9354);
    142. 

  142. INSERT INTO `zip_code` VALUES (112,'00803','Saint Thomas','Saint Thomas','Virgin Islands','VI','340','Atlantic',18.3503,-64.9356);
    143. 

  143. INSERT INTO `zip_code` VALUES (113,'00804','Saint Thomas','Saint Thomas','Virgin Islands','VI','340','Atlantic',18.349,-64.9321);
    144. 

  144. INSERT INTO `zip_code` VALUES (114,'00805','Saint Thomas','Saint Thomas','Virgin Islands','VI','340','Atlantic',18.3505,-64.9351);
    145. 

  145. INSERT INTO `zip_code` VALUES (115,'00820','Christiansted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7459,-64.7073);
    146. 

  146. INSERT INTO `zip_code` VALUES (116,'00821','Christiansted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7461,-64.7066);
    147. 

  147. INSERT INTO `zip_code` VALUES (117,'00822','Christiansted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7448,-64.7097);
    148. 

  148. INSERT INTO `zip_code` VALUES (118,'00823','Christiansted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7442,-64.7083);
    149. 

  149. INSERT INTO `zip_code` VALUES (119,'00824','Christiansted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7452,-64.7043);
    150. 

  150. INSERT INTO `zip_code` VALUES (120,'00830','Saint John','Saint John','Virgin Islands','VI','340','Atlantic',18.3352,-64.7907);
    151. 

  151. INSERT INTO `zip_code` VALUES (121,'00831','Saint John','Saint John','Virgin Islands','VI','340','Atlantic',18.3335,-64.793);
    152. 

  152. INSERT INTO `zip_code` VALUES (122,'00840','Frederiksted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7124,-64.8828);
    153. 

  153. INSERT INTO `zip_code` VALUES (123,'00841','Frederiksted','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7151,-64.8834);
    154. 

  154. INSERT INTO `zip_code` VALUES (124,'00850','Kingshill','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7308,-64.7981);
    155. 

  155. INSERT INTO `zip_code` VALUES (125,'00851','Kingshill','Saint Croix','Virgin Islands','VI','340','Atlantic',17.7335,-64.7989);
    156. 

  156. INSERT INTO `zip_code` VALUES (126,'00901','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4639,-66.1098);
    157. 

  157. INSERT INTO `zip_code` VALUES (127,'00902','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4463,-66.0983);
    158. 

  158. INSERT INTO `zip_code` VALUES (128,'00906','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4055,-66.0627);
    159. 

  159. INSERT INTO `zip_code` VALUES (129,'00907','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4543,-66.0766);
    160. 

  160. INSERT INTO `zip_code` VALUES (130,'00908','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4442,-66.0795);
    161. 

  161. INSERT INTO `zip_code` VALUES (131,'00909','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4473,-66.0679);
    162. 

  162. INSERT INTO `zip_code` VALUES (132,'00910','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.443,-66.0715);
    163. 

  163. INSERT INTO `zip_code` VALUES (133,'00911','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4514,-66.0616);
    164. 

  164. INSERT INTO `zip_code` VALUES (134,'00912','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4466,-66.0611);
    165. 

  165. INSERT INTO `zip_code` VALUES (135,'00913','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.451,-66.0451);
    166. 

  166. INSERT INTO `zip_code` VALUES (136,'00914','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4483,-66.0167);
    167. 

  167. INSERT INTO `zip_code` VALUES (137,'00915','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.438,-66.0474);
    168. 

  168. INSERT INTO `zip_code` VALUES (138,'00916','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3765,-66.1627);
    169. 

  169. INSERT INTO `zip_code` VALUES (139,'00917','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4206,-66.0539);
    170. 

  170. INSERT INTO `zip_code` VALUES (140,'00918','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4174,-66.0612);
    171. 

  171. INSERT INTO `zip_code` VALUES (141,'00919','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.411,-66.0649);
    172. 

  172. INSERT INTO `zip_code` VALUES (142,'00920','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4102,-66.0877);
    173. 

  173. INSERT INTO `zip_code` VALUES (143,'00921','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3917,-66.0906);
    174. 

  174. INSERT INTO `zip_code` VALUES (144,'00922','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.41,-66.0926);
    175. 

  175. INSERT INTO `zip_code` VALUES (145,'00923','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4124,-66.0391);
    176. 

  176. INSERT INTO `zip_code` VALUES (146,'00924','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4044,-66.0125);
    177. 

  177. INSERT INTO `zip_code` VALUES (147,'00925','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3989,-66.0503);
    178. 

  178. INSERT INTO `zip_code` VALUES (148,'00926','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3792,-66.0602);
    179. 

  179. INSERT INTO `zip_code` VALUES (149,'00927','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3888,-66.0733);
    180. 

  180. INSERT INTO `zip_code` VALUES (150,'00928','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3932,-66.0617);
    181. 

  181. INSERT INTO `zip_code` VALUES (151,'00929','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.402,-66.0232);
    182. 

  182. INSERT INTO `zip_code` VALUES (152,'00930','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4053,-66.0624);
    183. 

  183. INSERT INTO `zip_code` VALUES (153,'00931','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4098,-66.063);
    184. 

  184. INSERT INTO `zip_code` VALUES (154,'00933','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4702,-66.1079);
    185. 

  185. INSERT INTO `zip_code` VALUES (155,'00934','Fort Buchanan','Bayamon','Puerto Rico','PR','787','Atlantic',18.4132,-66.1316);
    186. 

  186. INSERT INTO `zip_code` VALUES (156,'00935','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4105,-66.0656);
    187. 

  187. INSERT INTO `zip_code` VALUES (157,'00936','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.3852,-66.0631);
    188. 

  188. INSERT INTO `zip_code` VALUES (158,'00937','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4109,-66.0638);
    189. 

  189. INSERT INTO `zip_code` VALUES (159,'00938','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4106,-66.063);
    190. 

  190. INSERT INTO `zip_code` VALUES (160,'00939','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4083,-66.0647);
    191. 

  191. INSERT INTO `zip_code` VALUES (161,'00940','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4109,-66.0651);
    192. 

  192. INSERT INTO `zip_code` VALUES (162,'00949','Toa Baja','Toa Baja','Puerto Rico','PR','787','Atlantic',18.4522,-66.1783);
    193. 

  193. INSERT INTO `zip_code` VALUES (163,'00950','Toa Baja','Toa Baja','Puerto Rico','PR','787','Atlantic',18.4487,-66.1725);
    194. 

  194. INSERT INTO `zip_code` VALUES (164,'00951','Toa Baja','Toa Baja','Puerto Rico','PR','787','Atlantic',18.4431,-66.2558);
    195. 

  195. INSERT INTO `zip_code` VALUES (165,'00952','Sabana Seca','Toa Baja','Puerto Rico','PR','787','Atlantic',18.4238,-66.185);
    196. 

  196. INSERT INTO `zip_code` VALUES (166,'00953','Toa Alta','Toa Alta','Puerto Rico','PR','787','Atlantic',18.3893,-66.2481);
    197. 

  197. INSERT INTO `zip_code` VALUES (167,'00954','Toa Alta','Toa Alta','Puerto Rico','PR','787','Atlantic',18.39,-66.2462);
    198. 

  198. INSERT INTO `zip_code` VALUES (168,'00955','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4093,-66.0647);
    199. 

  199. INSERT INTO `zip_code` VALUES (169,'00956','Bayamon','Bayamon','Puerto Rico','PR','787','Atlantic',18.1792,-66.1134);
    200. 

  200. INSERT INTO `zip_code` VALUES (170,'00957','Bayamon','Bayamon','Puerto Rico','PR','787','Atlantic',18.1783,-66.1111);
    201. 

  201. INSERT INTO `zip_code` VALUES (171,'00958','Bayamon','Bayamon','Puerto Rico','PR','787','Atlantic',18.1772,-66.1162);
    202. 

  202. INSERT INTO `zip_code` VALUES (172,'00959','Bayamon','Bayamon','Puerto Rico','PR','787','Atlantic',18.1781,-66.1167);
    203. 

  203. INSERT INTO `zip_code` VALUES (173,'00960','Bayamon','Bayamon','Puerto Rico','PR','787','Atlantic',18.1803,-66.1163);
    204. 

  204. INSERT INTO `zip_code` VALUES (174,'00961','Bayamon','Bayamon','Puerto Rico','PR','787','Atlantic',18.1808,-66.1122);
    205. 

  205. INSERT INTO `zip_code` VALUES (175,'00962','Catano','Catano','Puerto Rico','PR','787','Atlantic',18.4443,-66.1386);
    206. 

  206. INSERT INTO `zip_code` VALUES (176,'00963','Catano','Catano','Puerto Rico','PR','787','Atlantic',18.4462,-66.1402);
    207. 

  207. INSERT INTO `zip_code` VALUES (177,'00965','Guaynabo','Guaynabo','Puerto Rico','PR','787','Atlantic',18.3863,-66.1175);
    208. 

  208. INSERT INTO `zip_code` VALUES (178,'00966','Guaynabo','Guaynabo','Puerto Rico','PR','787','Atlantic',18.3882,-66.1144);
    209. 

  209. INSERT INTO `zip_code` VALUES (179,'00968','Guaynabo','San Juan','Puerto Rico','PR','787','Atlantic',18.3868,-66.1158);
    210. 

  210. INSERT INTO `zip_code` VALUES (180,'00969','Guaynabo','Guaynabo','Puerto Rico','PR','787','Atlantic',18.3866,-66.1135);
    211. 

  211. INSERT INTO `zip_code` VALUES (181,'00970','Guaynabo','Guaynabo','Puerto Rico','PR','787','Atlantic',18.3851,-66.1157);
    212. 

  212. INSERT INTO `zip_code` VALUES (182,'00971','Guaynabo','Guaynabo','Puerto Rico','PR','787','Atlantic',18.3885,-66.115);
    213. 

  213. INSERT INTO `zip_code` VALUES (183,'00975','San Juan','San Juan','Puerto Rico','PR','787','Atlantic',18.4104,-66.0656);
    214. 

  214. INSERT INTO `zip_code` VALUES (184,'00976','Trujillo Alto','Trujillo Alto','Puerto Rico','PR','787','Atlantic',18.3633,-66.0173);
    215. 

  215. INSERT INTO `zip_code` VALUES (185,'00977','Trujillo Alto','Trujillo Alto','Puerto Rico','PR','787','Atlantic',18.3628,-66.0173);
    216. 

  216. INSERT INTO `zip_code` VALUES (186,'00978','Saint Just','Trujillo Alto','Puerto Rico','PR','787','Atlantic',18.3682,-66.0117);
    217. 

  217. INSERT INTO `zip_code` VALUES (187,'00979','Carolina','San Juan','Puerto Rico','PR','787','Atlantic',18.4048,-65.9789);
    218. 

  218. INSERT INTO `zip_code` VALUES (188,'00981','Carolina','San Juan','Puerto Rico','PR','787','Atlantic',18.4065,-65.9786);
    219. 

  219. INSERT INTO `zip_code` VALUES (189,'00982','Carolina','San Juan','Puerto Rico','PR','787','Atlantic',18.4078,-65.9794);
    220. 

  220. INSERT INTO `zip_code` VALUES (190,'00983','Carolina','Carolina','Puerto Rico','PR','787','Atlantic',18.4091,-65.9811);
    221. 

  221. INSERT INTO `zip_code` VALUES (191,'00984','Carolina','Carolina','Puerto Rico','PR','787','Atlantic',18.4089,-65.9819);
    222. 

  222. INSERT INTO `zip_code` VALUES (192,'00985','Carolina','Carolina','Puerto Rico','PR','787','Atlantic',18.4092,-65.9814);
    223. 

  223. INSERT INTO `zip_code` VALUES (193,'00986','Carolina','Carolina','Puerto Rico','PR','787','Atlantic',18.4089,-65.9812);
    224. 

  224. INSERT INTO `zip_code` VALUES (194,'00987','Carolina','Carolina','Puerto Rico','PR','787','Atlantic',18.4102,-65.9794);
    225. 

  225. INSERT INTO `zip_code` VALUES (195,'00988','Carolina','Carolina','Puerto Rico','PR','787','Atlantic',18.4067,-65.9803);
    226. 

  226. INSERT INTO `zip_code` VALUES (196,'01001','Agawam','Hampden','Massachusetts','MA','413','Eastern',42.0715,-72.6243);
    227. 

  227. INSERT INTO `zip_code` VALUES (197,'01002','Amherst','Hampshire','Massachusetts','MA','413','Eastern',42.3742,-72.5052);
    228. 

  228. INSERT INTO `zip_code` VALUES (198,'01003','Amherst','Hampshire','Massachusetts','MA','413','Eastern',42.4052,-72.5284);
    229. 

  229. INSERT INTO `zip_code` VALUES (199,'01004','Amherst','Hampshire','Massachusetts','MA','413','Eastern',42.3839,-72.5118);
    230. 

  230. INSERT INTO `zip_code` VALUES (200,'01005','Barre','Worcester','Massachusetts','MA','978','Eastern',42.4333,-72.1145);
    231. 

  231. INSERT INTO `zip_code` VALUES (201,'01007','Belchertown','Hampshire','Massachusetts','MA','413','Eastern',42.2819,-72.4095);
    232. 

  232. INSERT INTO `zip_code` VALUES (202,'01008','Blandford','Hampden','Massachusetts','MA','413','Eastern',42.1432,-72.9319);
    233. 

  233. INSERT INTO `zip_code` VALUES (203,'01009','Bondsville','Hampden','Massachusetts','MA','413','Eastern',42.208,-72.345);
    234. 

  234. INSERT INTO `zip_code` VALUES (204,'01010','Brimfield','Hampden','Massachusetts','MA','413','Eastern',42.1292,-72.1961);
    235. 

  235. INSERT INTO `zip_code` VALUES (205,'01011','Chester','Hampden','Massachusetts','MA','413','Eastern',42.2837,-72.9669);
    236. 

  236. INSERT INTO `zip_code` VALUES (206,'01012','Chesterfield','Hampshire','Massachusetts','MA','413','Eastern',42.3872,-72.834);
    237. 

  237. INSERT INTO `zip_code` VALUES (207,'01013','Chicopee','Hampden','Massachusetts','MA','413','Eastern',42.1623,-72.6045);
    238. 

  238. INSERT INTO `zip_code` VALUES (208,'01014','Chicopee','Hampden','Massachusetts','MA','413','Eastern',42.1748,-72.5723);
    239. 

  239. INSERT INTO `zip_code` VALUES (209,'01020','Chicopee','Hampden','Massachusetts','MA','413','Eastern',42.1756,-72.57);
    240. 

  240. INSERT INTO `zip_code` VALUES (210,'01021','Chicopee','Hampden','Massachusetts','MA','413','Eastern',42.178,-72.5728);
    241. 

  241. INSERT INTO `zip_code` VALUES (211,'01022','Chicopee','Hampden','Massachusetts','MA','413','Eastern',42.1948,-72.5619);
    242. 

  242. INSERT INTO `zip_code` VALUES (212,'01026','Cummington','Hampshire','Massachusetts','MA','413','Eastern',42.4005,-72.8496);
    243. 

  243. INSERT INTO `zip_code` VALUES (213,'01027','Easthampton','Hampshire','Massachusetts','MA','413','Eastern',42.2723,-72.6993);
    244. 

  244. INSERT INTO `zip_code` VALUES (214,'01028','East Longmeadow','Hampden','Massachusetts','MA','413','Eastern',42.0684,-72.5043);
    245. 

  245. INSERT INTO `zip_code` VALUES (215,'01029','East Otis','Berkshire','Massachusetts','MA','413','Eastern',42.1598,-73.0434);
    246. 

  246. INSERT INTO `zip_code` VALUES (216,'01030','Feeding Hills','Hampden','Massachusetts','MA','413','Eastern',42.0724,-72.6752);
    247. 

  247. INSERT INTO `zip_code` VALUES (217,'01031','Gilbertville','Worcester','Massachusetts','MA','413','Eastern',42.3122,-72.2025);
    248. 

  248. INSERT INTO `zip_code` VALUES (218,'01032','Goshen','Hampshire','Massachusetts','MA','413','Eastern',42.4411,-72.8059);
    249. 

  249. INSERT INTO `zip_code` VALUES (219,'01033','Granby','Hampshire','Massachusetts','MA','413','Eastern',42.2564,-72.5195);
    250. 

  250. INSERT INTO `zip_code` VALUES (220,'01034','Granville','Hampden','Massachusetts','MA','413','Eastern',42.0733,-72.8966);
    251. 

  251. INSERT INTO `zip_code` VALUES (221,'01035','Hadley','Hampshire','Massachusetts','MA','413','Eastern',42.36,-72.5775);
    252. 

  252. INSERT INTO `zip_code` VALUES (222,'01036','Hampden','Hampden','Massachusetts','MA','413','Eastern',42.0629,-72.4303);
    253. 

  253. INSERT INTO `zip_code` VALUES (223,'01037','Hardwick','Worcester','Massachusetts','MA','413','Eastern',42.3494,-72.2008);
    254. 

  254. INSERT INTO `zip_code` VALUES (224,'01038','Hatfield','Hampshire','Massachusetts','MA','413','Eastern',42.3815,-72.6075);
    255. 

  255. INSERT INTO `zip_code` VALUES (225,'01039','Haydenville','Hampshire','Massachusetts','MA','413','Eastern',42.3796,-72.6968);
    256. 

  256. INSERT INTO `zip_code` VALUES (226,'01040','Holyoke','Hampden','Massachusetts','MA','413','Eastern',42.204,-72.6301);
    257. 

  257. INSERT INTO `zip_code` VALUES (227,'01041','Holyoke','Hampden','Massachusetts','MA','413','Eastern',42.2075,-72.6114);
    258. 

  258. INSERT INTO `zip_code` VALUES (228,'01050','Huntington','Hampshire','Massachusetts','MA','413','Eastern',42.2723,-72.8652);
    259. 

  259. INSERT INTO `zip_code` VALUES (229,'01053','Leeds','Hampshire','Massachusetts','MA','413','Eastern',42.3544,-72.7015);
    260. 

  260. INSERT INTO `zip_code` VALUES (230,'01054','Leverett','Franklin','Massachusetts','MA','413','Eastern',42.4747,-72.4825);
    261. 

  261. INSERT INTO `zip_code` VALUES (231,'01056','Ludlow','Hampden','Massachusetts','MA','413','Eastern',42.1712,-72.4725);
    262. 

  262. INSERT INTO `zip_code` VALUES (232,'01057','Monson','Hampden','Massachusetts','MA','413','Eastern',42.094,-72.324);
    263. 

  263. INSERT INTO `zip_code` VALUES (233,'01059','North Amherst','Hampshire','Massachusetts','MA','413','Eastern',42.4133,-72.5305);
    264. 

  264. INSERT INTO `zip_code` VALUES (234,'01060','Northampton','Hampshire','Massachusetts','MA','413','Eastern',42.3247,-72.6559);
    265. 

  265. INSERT INTO `zip_code` VALUES (235,'01061','Northampton','Hampshire','Massachusetts','MA','413','Eastern',42.3233,-72.6904);
    266. 

  266. INSERT INTO `zip_code` VALUES (236,'01062','Florence','Hampshire','Massachusetts','MA','413','Eastern',42.3316,-72.6926);
    267. 

  267. INSERT INTO `zip_code` VALUES (237,'01063','Northampton','Hampshire','Massachusetts','MA','413','Eastern',42.3191,-72.6444);
    268. 

  268. INSERT INTO `zip_code` VALUES (238,'01066','North Hatfield','Hampshire','Massachusetts','MA','413','Eastern',42.4106,-72.6256);
    269. 

  269. INSERT INTO `zip_code` VALUES (239,'01068','Oakham','Worcester','Massachusetts','MA','508','Eastern',42.3464,-72.0492);
    270. 

  270. INSERT INTO `zip_code` VALUES (240,'01069','Palmer','Hampden','Massachusetts','MA','413','Eastern',42.1655,-72.3144);
    271. 

  271. INSERT INTO `zip_code` VALUES (241,'01070','Plainfield','Hampshire','Massachusetts','MA','413','Eastern',42.5368,-72.9331);
    272. 

  272. INSERT INTO `zip_code` VALUES (242,'01071','Russell','Hampden','Massachusetts','MA','413','Eastern',42.1713,-72.8631);
    273. 

  273. INSERT INTO `zip_code` VALUES (243,'01072','Shutesbury','Franklin','Massachusetts','MA','413','Eastern',42.4678,-72.4299);
    274. 

  274. INSERT INTO `zip_code` VALUES (244,'01073','Southampton','Hampshire','Massachusetts','MA','413','Eastern',42.2256,-72.7217);
    275. 

  275. INSERT INTO `zip_code` VALUES (245,'01074','South Barre','Worcester','Massachusetts','MA','978','Eastern',42.3829,-72.1005);
    276. 

  276. INSERT INTO `zip_code` VALUES (246,'01075','South Hadley','Hampshire','Massachusetts','MA','413','Eastern',42.236,-72.5828);
    277. 

  277. INSERT INTO `zip_code` VALUES (247,'01077','Southwick','Hampden','Massachusetts','MA','413','Eastern',42.0536,-72.7719);
    278. 

  278. INSERT INTO `zip_code` VALUES (248,'01079','Thorndike','Hampden','Massachusetts','MA','413','Eastern',42.1889,-72.3298);
    279. 

  279. INSERT INTO `zip_code` VALUES (249,'01080','Three Rivers','Hampden','Massachusetts','MA','413','Eastern',42.1815,-72.3721);
    280. 

  280. INSERT INTO `zip_code` VALUES (250,'01081','Wales','Hampden','Massachusetts','MA','413','Eastern',42.0612,-72.2276);
    281. 

  281. INSERT INTO `zip_code` VALUES (251,'01082','Ware','Hampshire','Massachusetts','MA','413','Eastern',42.2627,-72.2654);
    282. 

  282. INSERT INTO `zip_code` VALUES (252,'01083','Warren','Worcester','Massachusetts','MA','413','Eastern',42.2127,-72.1941);
    283. 

  283. INSERT INTO `zip_code` VALUES (253,'01084','West Chesterfield','Hampshire','Massachusetts','MA','413','Eastern',42.4087,-72.8892);
    284. 

  284. INSERT INTO `zip_code` VALUES (254,'01085','Westfield','Hampden','Massachusetts','MA','413','Eastern',42.1319,-72.7495);
    285. 

  285. INSERT INTO `zip_code` VALUES (255,'01086','Westfield','Hampden','Massachusetts','MA','413','Eastern',42.1402,-72.7561);
    286. 

  286. INSERT INTO `zip_code` VALUES (256,'01088','West Hatfield','Hampshire','Massachusetts','MA','413','Eastern',42.3865,-72.6398);
    287. 

  287. INSERT INTO `zip_code` VALUES (257,'01089','West Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1171,-72.6394);
    288. 

  288. INSERT INTO `zip_code` VALUES (258,'01090','West Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1213,-72.6549);
    289. 

  289. INSERT INTO `zip_code` VALUES (259,'01092','West Warren','Worcester','Massachusetts','MA','413','Eastern',42.2074,-72.234);
    290. 

  290. INSERT INTO `zip_code` VALUES (260,'01093','Whately','Franklin','Massachusetts','MA','413','Eastern',42.4357,-72.6484);
    291. 

  291. INSERT INTO `zip_code` VALUES (261,'01094','Wheelwright','Worcester','Massachusetts','MA','413','Eastern',42.3495,-72.1401);
    292. 

  292. INSERT INTO `zip_code` VALUES (262,'01095','Wilbraham','Hampden','Massachusetts','MA','413','Eastern',42.1208,-72.4433);
    293. 

  293. INSERT INTO `zip_code` VALUES (263,'01096','Williamsburg','Hampshire','Massachusetts','MA','413','Eastern',42.3993,-72.749);
    294. 

  294. INSERT INTO `zip_code` VALUES (264,'01097','Woronoco','Hampden','Massachusetts','MA','413','Eastern',42.1607,-72.8398);
    295. 

  295. INSERT INTO `zip_code` VALUES (265,'01098','Worthington','Hampshire','Massachusetts','MA','413','Eastern',42.3077,-72.8781);
    296. 

  296. INSERT INTO `zip_code` VALUES (266,'01101','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.0999,-72.5896);
    297. 

  297. INSERT INTO `zip_code` VALUES (267,'01102','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1161,-72.5386);
    298. 

  298. INSERT INTO `zip_code` VALUES (268,'01103','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.102,-72.5871);
    299. 

  299. INSERT INTO `zip_code` VALUES (269,'01104','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1281,-72.5715);
    300. 

  300. INSERT INTO `zip_code` VALUES (270,'01105','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1011,-72.5792);
    301. 

  301. INSERT INTO `zip_code` VALUES (271,'01106','Longmeadow','Hampden','Massachusetts','MA','413','Eastern',42.0524,-72.5678);
    302. 

  302. INSERT INTO `zip_code` VALUES (272,'01107','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1229,-72.6072);
    303. 

  303. INSERT INTO `zip_code` VALUES (273,'01108','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.0821,-72.5544);
    304. 

  304. INSERT INTO `zip_code` VALUES (274,'01109','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1187,-72.5483);
    305. 

  305. INSERT INTO `zip_code` VALUES (275,'01111','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.118,-72.5479);
    306. 

  306. INSERT INTO `zip_code` VALUES (276,'01114','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1029,-72.5927);
    307. 

  307. INSERT INTO `zip_code` VALUES (277,'01115','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.104,-72.5918);
    308. 

  308. INSERT INTO `zip_code` VALUES (278,'01116','Longmeadow','Hampden','Massachusetts','MA','413','Eastern',42.0458,-72.5708);
    309. 

  309. INSERT INTO `zip_code` VALUES (279,'01118','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.0939,-72.5279);
    310. 

  310. INSERT INTO `zip_code` VALUES (280,'01119','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1229,-72.5064);
    311. 

  311. INSERT INTO `zip_code` VALUES (281,'01128','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.094,-72.4948);
    312. 

  312. INSERT INTO `zip_code` VALUES (282,'01129','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1229,-72.487);
    313. 

  313. INSERT INTO `zip_code` VALUES (283,'01133','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1063,-72.5953);
    314. 

  314. INSERT INTO `zip_code` VALUES (284,'01138','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.0886,-72.561);
    315. 

  315. INSERT INTO `zip_code` VALUES (285,'01139','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1163,-72.5469);
    316. 

  316. INSERT INTO `zip_code` VALUES (286,'01144','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1016,-72.5948);
    317. 

  317. INSERT INTO `zip_code` VALUES (287,'01151','Indian Orchard','Hampden','Massachusetts','MA','413','Eastern',42.151,-72.5065);
    318. 

  318. INSERT INTO `zip_code` VALUES (288,'01152','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1528,-72.5113);
    319. 

  319. INSERT INTO `zip_code` VALUES (289,'01199','Springfield','Hampden','Massachusetts','MA','413','Eastern',42.1191,-72.6034);
    320. 

  320. INSERT INTO `zip_code` VALUES (290,'01201','Pittsfield','Berkshire','Massachusetts','MA','413','Eastern',42.4555,-73.25);
    321. 

  321. INSERT INTO `zip_code` VALUES (291,'01202','Pittsfield','Berkshire','Massachusetts','MA','413','Eastern',42.4579,-73.322);
    322. 

  322. INSERT INTO `zip_code` VALUES (292,'01203','Pittsfield','Berkshire','Massachusetts','MA','413','Eastern',42.4532,-73.2628);
    323. 

  323. INSERT INTO `zip_code` VALUES (293,'01220','Adams','Berkshire','Massachusetts','MA','413','Eastern',42.62,-73.1208);
    324. 

  324. INSERT INTO `zip_code` VALUES (294,'01222','Ashley Falls','Berkshire','Massachusetts','MA','413','Eastern',42.0564,-73.3188);
    325. 

  325. INSERT INTO `zip_code` VALUES (295,'01223','Becket','Berkshire','Massachusetts','MA','413','Eastern',42.3813,-73.1437);
    326. 

  326. INSERT INTO `zip_code` VALUES (296,'01224','Berkshire','Berkshire','Massachusetts','MA','413','Eastern',42.4893,-73.1956);
    327. 

  327. INSERT INTO `zip_code` VALUES (297,'01225','Cheshire','Berkshire','Massachusetts','MA','413','Eastern',42.5552,-73.156);
    328. 

  328. INSERT INTO `zip_code` VALUES (298,'01226','Dalton','Berkshire','Massachusetts','MA','413','Eastern',42.4697,-73.1627);
    329. 

  329. INSERT INTO `zip_code` VALUES (299,'01227','Dalton','Berkshire','Massachusetts','MA','413','Eastern',42.4724,-73.162);
    330. 

  330. INSERT INTO `zip_code` VALUES (300,'01229','Glendale','Berkshire','Massachusetts','MA','413','Eastern',42.2861,-73.3468);
    331. 

  331. INSERT INTO `zip_code` VALUES (301,'01230','Great Barrington','Berkshire','Massachusetts','MA','413','Eastern',42.2049,-73.3602);
    332. 

  332. INSERT INTO `zip_code` VALUES (302,'01235','Hinsdale','Berkshire','Massachusetts','MA','413','Eastern',42.4334,-73.1067);
    333. 

  333. INSERT INTO `zip_code` VALUES (303,'01236','Housatonic','Berkshire','Massachusetts','MA','413','Eastern',42.2534,-73.3675);
    334. 

  334. INSERT INTO `zip_code` VALUES (304,'01237','Lanesboro','Berkshire','Massachusetts','MA','413','Eastern',42.5144,-73.2421);
    335. 

  335. INSERT INTO `zip_code` VALUES (305,'01238','Lee','Berkshire','Massachusetts','MA','413','Eastern',42.312,-73.2477);
    336. 

  336. INSERT INTO `zip_code` VALUES (306,'01240','Lenox','Berkshire','Massachusetts','MA','413','Eastern',42.3631,-73.2739);
    337. 

  337. INSERT INTO `zip_code` VALUES (307,'01242','Lenox Dale','Berkshire','Massachusetts','MA','413','Eastern',42.33,-73.2503);
    338. 

  338. INSERT INTO `zip_code` VALUES (308,'01243','Middlefield','Hampshire','Massachusetts','MA','413','Eastern',42.3465,-73.0083);
    339. 

  339. INSERT INTO `zip_code` VALUES (309,'01244','Mill River','Berkshire','Massachusetts','MA','413','Eastern',42.1145,-73.2672);
    340. 

  340. INSERT INTO `zip_code` VALUES (310,'01245','Monterey','Berkshire','Massachusetts','MA','413','Eastern',42.2052,-73.2281);
    341. 

  341. INSERT INTO `zip_code` VALUES (311,'01247','North Adams','Berkshire','Massachusetts','MA','413','Eastern',42.6945,-73.1132);
    342. 

  342. INSERT INTO `zip_code` VALUES (312,'01252','North Egremont','Berkshire','Massachusetts','MA','413','Eastern',42.1967,-73.4363);
    343. 

  343. INSERT INTO `zip_code` VALUES (313,'01253','Otis','Berkshire','Massachusetts','MA','413','Eastern',42.1847,-73.0985);
    344. 

  344. INSERT INTO `zip_code` VALUES (314,'01254','Richmond','Berkshire','Massachusetts','MA','413','Eastern',42.4017,-73.3482);
    345. 

  345. INSERT INTO `zip_code` VALUES (315,'01255','Sandisfield','Berkshire','Massachusetts','MA','413','Eastern',42.1153,-73.1204);
    346. 

  346. INSERT INTO `zip_code` VALUES (316,'01256','Savoy','Berkshire','Massachusetts','MA','413','Eastern',42.5763,-73.0309);
    347. 

  347. INSERT INTO `zip_code` VALUES (317,'01257','Sheffield','Berkshire','Massachusetts','MA','413','Eastern',42.0771,-73.3953);
    348. 

  348. INSERT INTO `zip_code` VALUES (318,'01258','South Egremont','Berkshire','Massachusetts','MA','413','Eastern',42.1207,-73.4742);
    349. 

  349. INSERT INTO `zip_code` VALUES (319,'01259','Southfield','Berkshire','Massachusetts','MA','413','Eastern',42.0681,-73.2879);
    350. 

  350. INSERT INTO `zip_code` VALUES (320,'01260','South Lee','Berkshire','Massachusetts','MA','413','Eastern',42.2812,-73.2789);
    351. 

  351. INSERT INTO `zip_code` VALUES (321,'01262','Stockbridge','Berkshire','Massachusetts','MA','413','Eastern',42.304,-73.3159);
    352. 

  352. INSERT INTO `zip_code` VALUES (322,'01263','Stockbridge','Berkshire','Massachusetts','MA','413','Eastern',42.289,-73.3195);
    353. 

  353. INSERT INTO `zip_code` VALUES (323,'01264','Tyringham','Berkshire','Massachusetts','MA','413','Eastern',42.2435,-73.2055);
    354. 

  354. INSERT INTO `zip_code` VALUES (324,'01266','West Stockbridge','Berkshire','Massachusetts','MA','413','Eastern',42.3331,-73.3804);
    355. 

  355. INSERT INTO `zip_code` VALUES (325,'01267','Williamstown','Berkshire','Massachusetts','MA','413','Eastern',42.6995,-73.2102);
    356. 

  356. INSERT INTO `zip_code` VALUES (326,'01270','Windsor','Berkshire','Massachusetts','MA','413','Eastern',42.3364,-73.2544);
    357. 

  357. INSERT INTO `zip_code` VALUES (327,'01301','Greenfield','Franklin','Massachusetts','MA','413','Eastern',42.6029,-72.5986);
    358. 

  358. INSERT INTO `zip_code` VALUES (328,'01302','Greenfield','Franklin','Massachusetts','MA','413','Eastern',42.652,-72.6096);
    359. 

  359. INSERT INTO `zip_code` VALUES (329,'01330','Ashfield','Franklin','Massachusetts','MA','413','Eastern',42.5225,-72.7857);
    360. 

  360. INSERT INTO `zip_code` VALUES (330,'01331','Athol','Worcester','Massachusetts','MA','978','Eastern',42.5889,-72.2241);
    361. 

  361. INSERT INTO `zip_code` VALUES (331,'01337','Bernardston','Franklin','Massachusetts','MA','413','Eastern',42.6654,-72.5373);
    362. 

  362. INSERT INTO `zip_code` VALUES (332,'01338','Buckland','Franklin','Massachusetts','MA','413','Eastern',42.5989,-72.7409);
    363. 

  363. INSERT INTO `zip_code` VALUES (333,'01339','Charlemont','Franklin','Massachusetts','MA','413','Eastern',42.6339,-72.8756);
    364. 

  364. INSERT INTO `zip_code` VALUES (334,'01340','Colrain','Franklin','Massachusetts','MA','413','Eastern',42.7117,-72.7191);
    365. 

  365. INSERT INTO `zip_code` VALUES (335,'01341','Conway','Franklin','Massachusetts','MA','413','Eastern',42.511,-72.6881);
    366. 

  366. INSERT INTO `zip_code` VALUES (336,'01342','Deerfield','Franklin','Massachusetts','MA','413','Eastern',42.5537,-72.5893);
    367. 

  367. INSERT INTO `zip_code` VALUES (337,'01343','Drury','Berkshire','Massachusetts','MA','413','Eastern',42.6438,-72.9879);
    368. 

  368. INSERT INTO `zip_code` VALUES (338,'01344','Erving','Franklin','Massachusetts','MA','978','Eastern',42.606,-72.4107);
    369. 

  369. INSERT INTO `zip_code` VALUES (339,'01346','Heath','Franklin','Massachusetts','MA','413','Eastern',42.6822,-72.8382);
    370. 

  370. INSERT INTO `zip_code` VALUES (340,'01347','Lake Pleasant','Franklin','Massachusetts','MA','413','Eastern',42.5576,-72.5187);
    371. 

  371. INSERT INTO `zip_code` VALUES (341,'01349','Turners Falls','Franklin','Massachusetts','MA','413','Eastern',42.5787,-72.4921);
    372. 

  372. INSERT INTO `zip_code` VALUES (342,'01350','Monroe Bridge','Franklin','Massachusetts','MA','413','Eastern',42.717,-72.9473);
    373. 

  373. INSERT INTO `zip_code` VALUES (343,'01351','Montague','Franklin','Massachusetts','MA','413','Eastern',42.5367,-72.5301);
    374. 

  374. INSERT INTO `zip_code` VALUES (344,'01354','Northfield','Franklin','Massachusetts','MA','413','Eastern',42.6759,-72.4485);
    375. 

  375. INSERT INTO `zip_code` VALUES (345,'01355','New Salem','Franklin','Massachusetts','MA','978','Eastern',42.4857,-72.3413);
    376. 

  376. INSERT INTO `zip_code` VALUES (346,'01360','Northfield','Franklin','Massachusetts','MA','413','Eastern',42.7005,-72.4509);
    377. 

  377. INSERT INTO `zip_code` VALUES (347,'01364','Orange','Franklin','Massachusetts','MA','978','Eastern',42.6,-72.3056);
    378. 

  378. INSERT INTO `zip_code` VALUES (348,'01366','Petersham','Worcester','Massachusetts','MA','978','Eastern',42.4723,-72.2041);
    379. 

  379. INSERT INTO `zip_code` VALUES (349,'01367','Rowe','Franklin','Massachusetts','MA','413','Eastern',42.6894,-72.9354);
    380. 

  380. INSERT INTO `zip_code` VALUES (350,'01368','Royalston','Worcester','Massachusetts','MA','978','Eastern',42.6849,-72.196);
    381. 

  381. INSERT INTO `zip_code` VALUES (351,'01370','Shelburne Falls','Franklin','Massachusetts','MA','413','Eastern',42.5959,-72.7334);
    382. 

  382. INSERT INTO `zip_code` VALUES (352,'01373','South Deerfield','Franklin','Massachusetts','MA','413','Eastern',42.4764,-72.6107);
    383. 

  383. INSERT INTO `zip_code` VALUES (353,'01375','Sunderland','Franklin','Massachusetts','MA','413','Eastern',42.4613,-72.5637);
    384. 

  384. INSERT INTO `zip_code` VALUES (354,'01376','Turners Falls','Franklin','Massachusetts','MA','413','Eastern',42.6047,-72.5465);
    385. 

  385. INSERT INTO `zip_code` VALUES (355,'01378','Warwick','Franklin','Massachusetts','MA','413','Eastern',42.6773,-72.3431);
    386. 

  386. INSERT INTO `zip_code` VALUES (356,'01379','Wendell','Franklin','Massachusetts','MA','978','Eastern',42.5616,-72.3856);
    387. 

  387. INSERT INTO `zip_code` VALUES (357,'01380','Wendell Depot','Franklin','Massachusetts','MA','978','Eastern',42.5695,-72.4064);
    388. 

  388. INSERT INTO `zip_code` VALUES (358,'01420','Fitchburg','Worcester','Massachusetts','MA','978','Eastern',42.5763,-71.8021);
    389. 

  389. INSERT INTO `zip_code` VALUES (359,'01430','Ashburnham','Worcester','Massachusetts','MA','978','Eastern',42.6536,-71.9243);
    390. 

  390. INSERT INTO `zip_code` VALUES (360,'01431','Ashby','Middlesex','Massachusetts','MA','978','Eastern',42.6778,-71.8112);
    391. 

  391. INSERT INTO `zip_code` VALUES (361,'01432','Ayer','Middlesex','Massachusetts','MA','978','Eastern',42.5598,-71.5753);
    392. 

  392. INSERT INTO `zip_code` VALUES (362,'01436','Baldwinville','Worcester','Massachusetts','MA','978','Eastern',42.6046,-72.0707);
    393. 

  393. INSERT INTO `zip_code` VALUES (363,'01438','East Templeton','Worcester','Massachusetts','MA','978','Eastern',42.5637,-72.0404);
    394. 

  394. INSERT INTO `zip_code` VALUES (364,'01440','Gardner','Worcester','Massachusetts','MA','978','Eastern',42.5745,-71.9954);
    395. 

  395. INSERT INTO `zip_code` VALUES (365,'01441','Westminster','Worcester','Massachusetts','MA','978','Eastern',42.5736,-71.9946);
    396. 

  396. INSERT INTO `zip_code` VALUES (366,'01450','Groton','Middlesex','Massachusetts','MA','978','Eastern',42.6084,-71.5566);
    397. 

  397. INSERT INTO `zip_code` VALUES (367,'01451','Harvard','Worcester','Massachusetts','MA','978','Eastern',42.5031,-71.5759);
    398. 

  398. INSERT INTO `zip_code` VALUES (368,'01452','Hubbardston','Worcester','Massachusetts','MA','978','Eastern',42.4879,-72.0071);
    399. 

  399. INSERT INTO `zip_code` VALUES (369,'01453','Leominster','Worcester','Massachusetts','MA','978','Eastern',42.5253,-71.7535);
    400. 

  400. INSERT INTO `zip_code` VALUES (370,'01460','Littleton','Middlesex','Massachusetts','MA','978','Eastern',42.5435,-71.4842);
    401. 

  401. INSERT INTO `zip_code` VALUES (371,'01462','Lunenburg','Worcester','Massachusetts','MA','978','Eastern',42.5889,-71.7314);
    402. 

  402. INSERT INTO `zip_code` VALUES (372,'01463','Pepperell','Middlesex','Massachusetts','MA','978','Eastern',42.6734,-71.5914);
    403. 

  403. INSERT INTO `zip_code` VALUES (373,'01464','Shirley','Middlesex','Massachusetts','MA','978','Eastern',42.5595,-71.6464);
    404. 

  404. INSERT INTO `zip_code` VALUES (374,'01467','Still River','Worcester','Massachusetts','MA','978','Eastern',42.4837,-71.6216);
    405. 

  405. INSERT INTO `zip_code` VALUES (375,'01468','Templeton','Worcester','Massachusetts','MA','978','Eastern',42.5499,-72.0658);
    406. 

  406. INSERT INTO `zip_code` VALUES (376,'01469','Townsend','Middlesex','Massachusetts','MA','978','Eastern',42.6537,-71.6916);
    407. 

  407. INSERT INTO `zip_code` VALUES (377,'01470','Groton','Middlesex','Massachusetts','MA','978','Eastern',42.6083,-71.5719);
    408. 

  408. INSERT INTO `zip_code` VALUES (378,'01471','Groton','Middlesex','Massachusetts','MA','978','Eastern',42.6079,-71.5723);
    409. 

  409. INSERT INTO `zip_code` VALUES (379,'01472','West Groton','Middlesex','Massachusetts','MA','978','Eastern',42.6066,-71.6291);
    410. 

  410. INSERT INTO `zip_code` VALUES (380,'01473','Westminster','Worcester','Massachusetts','MA','978','Eastern',42.5409,-71.9061);
    411. 

  411. INSERT INTO `zip_code` VALUES (381,'01474','West Townsend','Middlesex','Massachusetts','MA','978','Eastern',42.6698,-71.7455);
    412. 

  412. INSERT INTO `zip_code` VALUES (382,'01475','Winchendon','Worcester','Massachusetts','MA','978','Eastern',42.678,-72.0451);
    413. 

  413. INSERT INTO `zip_code` VALUES (383,'01477','Winchendon Springs','Worcester','Massachusetts','MA','978','Eastern',42.6959,-72.0178);
    414. 

  414. INSERT INTO `zip_code` VALUES (384,'01501','Auburn','Worcester','Massachusetts','MA','508','Eastern',42.205,-71.8405);
    415. 

  415. INSERT INTO `zip_code` VALUES (385,'01503','Berlin','Worcester','Massachusetts','MA','978','Eastern',42.3741,-71.6324);
    416. 

  416. INSERT INTO `zip_code` VALUES (386,'01504','Blackstone','Worcester','Massachusetts','MA','508','Eastern',42.0263,-71.5285);
    417. 

  417. INSERT INTO `zip_code` VALUES (387,'01505','Boylston','Worcester','Massachusetts','MA','508','Eastern',42.3316,-71.7341);
    418. 

  418. INSERT INTO `zip_code` VALUES (388,'01506','Brookfield','Worcester','Massachusetts','MA','508','Eastern',42.2033,-72.1001);
    419. 

  419. INSERT INTO `zip_code` VALUES (389,'01507','Charlton','Worcester','Massachusetts','MA','508','Eastern',42.1484,-71.9413);
    420. 

  420. INSERT INTO `zip_code` VALUES (390,'01508','Charlton City','Worcester','Massachusetts','MA','508','Eastern',42.1514,-71.9896);
    421. 

  421. INSERT INTO `zip_code` VALUES (391,'01509','Charlton Depot','Worcester','Massachusetts','MA','508','Eastern',42.173,-71.9756);
    422. 

  422. INSERT INTO `zip_code` VALUES (392,'01510','Clinton','Worcester','Massachusetts','MA','978','Eastern',42.4193,-71.6851);
    423. 

  423. INSERT INTO `zip_code` VALUES (393,'01515','East Brookfield','Worcester','Massachusetts','MA','508','Eastern',42.2226,-72.053);
    424. 

  424. INSERT INTO `zip_code` VALUES (394,'01516','Douglas','Worcester','Massachusetts','MA','508','Eastern',42.0926,-71.7167);
    425. 

  425. INSERT INTO `zip_code` VALUES (395,'01517','East Princeton','Worcester','Massachusetts','MA','508','Eastern',42.4702,-71.8402);
    426. 

  426. INSERT INTO `zip_code` VALUES (396,'01518','Fiskdale','Worcester','Massachusetts','MA','508','Eastern',42.1209,-72.1102);
    427. 

  427. INSERT INTO `zip_code` VALUES (397,'01519','Grafton','Worcester','Massachusetts','MA','508','Eastern',42.201,-71.688);
    428. 

  428. INSERT INTO `zip_code` VALUES (398,'01520','Holden','Worcester','Massachusetts','MA','508','Eastern',42.3458,-71.8463);
    429. 

  429. INSERT INTO `zip_code` VALUES (399,'01521','Holland','Hampden','Massachusetts','MA','413','Eastern',42.0425,-72.1498);
    430. 

  430. INSERT INTO `zip_code` VALUES (400,'01522','Jefferson','Worcester','Massachusetts','MA','508','Eastern',42.3746,-71.8668);
    431. 

  431. INSERT INTO `zip_code` VALUES (401,'01523','Lancaster','Worcester','Massachusetts','MA','978','East…
    432.

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