/build/sql/place.sql
SQL | 4385 lines | 4384 code | 1 blank | 0 comment | 0 complexity | 44cb90abe9fc37d5bcebea99024edde8 MD5 | raw file
Possible License(s): LGPL-3.0
Large files files are truncated, but you can click here to view the full file
- PRAGMA foreign_keys=OFF;
- BEGIN TRANSACTION;
- DROP TABLE IF EXISTS place;
- CREATE TABLE place(
- zip CHAR(5),
- city VARCHAR(100),
- state CHAR(2),
- city_phone VARCHAR(5),
- lat NUMERIC(9,6),
- lon NUMERIC(9,6),
- status CHAR(1),
- fips_class CHAR(2),
- fips_place CHAR(7),
- fips_county CHAR(5),
- priority char(1));
- INSERT INTO "place" VALUES('00210','Portsmouth','NH','PRTSM',43.005895,-71.013202,'U','C5','3362900','33015','1');
- INSERT INTO "place" VALUES('00211','Portsmouth','NH','PRTSM',43.005895,-71.013202,'U','C5','3362900','33015','1');
- INSERT INTO "place" VALUES('00212','Portsmouth','NH','PRTSM',43.005895,-71.013202,'U','C5','3362900','33015','1');
- INSERT INTO "place" VALUES('00213','Portsmouth','NH','PRTSM',43.005895,-71.013202,'U','C5','3362900','33015','1');
- INSERT INTO "place" VALUES('00214','Portsmouth','NH','PRTSM',43.005895,-71.013202,'U','C5','3362900','33015','1');
- INSERT INTO "place" VALUES('00215','Portsmouth','NH','PRTSM',43.005895,-71.013202,'U','C5','3362900','33015','1');
- INSERT INTO "place" VALUES('00501','Holtsville','NY','HLTSF',40.922326,-72.637078,'U','U1','3635254','36103','1');
- INSERT INTO "place" VALUES('00544','Holtsville','NY','HLTSF',40.922326,-72.637078,'U','U1','3635254','36103','1');
- INSERT INTO "place" VALUES('00601','Adjuntas','PR','ATJNT',18.165273,-66.722583,'P','H1','7200358','72001','1');
- INSERT INTO "place" VALUES('00602','Aguada','PR','AKT',18.393103,-67.180953,'P','H1','7200616','72003','1');
- INSERT INTO "place" VALUES('00603','Aguadilla','PR','AKTL',18.455913,-67.14578,'P','H1','7200745','72005','1');
- INSERT INTO "place" VALUES('00604','Aguadilla','PR','AKTL',18.49352,-67.135883,'T','H1','7200745','72005','1');
- INSERT INTO "place" VALUES('00605','Aguadilla','PR','AKTL',18.465162,-67.141486,'B','H1','7200745','72005','1');
- INSERT INTO "place" VALUES('00606','Maricao','PR','MRK',18.172947,-66.944111,'P','H1','7251270','72093','1');
- INSERT INTO "place" VALUES('00609','Asomante','PR','ASMNT',18.12996,-66.278224,'N','U6','7204228','72009','3');
- INSERT INTO "place" VALUES('00610','Anasco','PR','ANSK',18.288685,-67.139696,'P','H1','7202637','72011','1');
- INSERT INTO "place" VALUES('00610','Tres Hermanos','PR','TRXRM',18.284395,-67.189903,'N','U6','7283520','72011','3');
- INSERT INTO "place" VALUES('00611','Angeles','PR','ANJLS',18.279531,-66.80217,'B','Z1','7202938','72141','1');
- INSERT INTO "place" VALUES('00612','Arecibo','PR','ARSB',18.402239,-66.7114,'C','H1','7203368','72013','1');
- INSERT INTO "place" VALUES('00612','Hato Viejo','PR','HTFJ',18.402239,-66.7114,'C','U6','7234242','72039','2');
- INSERT INTO "place" VALUES('00612','San Francisco','PR','SNFRN',18.402239,-66.7114,'C','U6','7275995','72013','2');
- INSERT INTO "place" VALUES('00613','Arecibo','PR','ARSB',18.458093,-66.732732,'B','H1','7203368','72013','1');
- INSERT INTO "place" VALUES('00614','Arecibo','PR','ARSB',18.429675,-66.674506,'B','H1','7203368','72013','1');
- INSERT INTO "place" VALUES('00615','Pitahaya','PR','PTHY',17.994133,-66.050998,'A','U6','7262149','72015','2');
- INSERT INTO "place" VALUES('00615','Yaurel','PR','YRL',18.026909,-66.057109,'N','U1','7288121','72015','3');
- INSERT INTO "place" VALUES('00616','Bajadero','PR','BJTR',18.420413,-66.671979,'C','U1','7204658','72013','1');
- INSERT INTO "place" VALUES('00617','Barceloneta','PR','BRSLN',18.447092,-66.544255,'P','H1','7205346','72017','1');
- INSERT INTO "place" VALUES('00620','Bayamon Gardens','PR','BYMNK',18.377727,-66.179889,'A','U6','7206980','72021','2');
- INSERT INTO "place" VALUES('00622','Boqueron','PR','BKRN',17.998531,-67.187318,'P','Z1','7207969','72023','1');
- INSERT INTO "place" VALUES('00623','Cabo Rojo','PR','KBRJ',18.062201,-67.149541,'P','H1','7209818','72023','1');
- INSERT INTO "place" VALUES('00624','Penuelas','PR','PNLS',18.023535,-66.726156,'P','H1','7261074','72111','1');
- INSERT INTO "place" VALUES('00627','Camuy','PR','KM',18.477891,-66.85477,'P','H1','7211925','72027','1');
- INSERT INTO "place" VALUES('00631','Castaner','PR','KSTNR',18.190607,-66.832041,'C','U6','7215150','72081','1');
- INSERT INTO "place" VALUES('00632','Juana Matos','PR','JNMTS',18.436613,-66.129889,'N','U6','7239144','72033','3');
- INSERT INTO "place" VALUES('00636','Rosario','PR','RSR',18.113284,-67.039706,'B','U6','7272383','72125','1');
- INSERT INTO "place" VALUES('00637','Sabana Grande','PR','SBNKR',18.087322,-66.934911,'P','H1','7273544','72121','1');
- INSERT INTO "place" VALUES('00638','Ciales','PR','XLS',18.33616,-66.472087,'P','H1','7217730','72039','1');
- INSERT INTO "place" VALUES('00639','Nogueras','PR','NKRS',18.144959,-66.165722,'N','U6','7256602','72041','3');
- INSERT INTO "place" VALUES('00640','Los Llanos','PR','LSLNS',18.055241,-66.405726,'A','U1','7247013','72043','2');
- INSERT INTO "place" VALUES('00641','Utuado','PR','UTT',18.250027,-66.698957,'P','H1','7284509','72141','1');
- INSERT INTO "place" VALUES('00646','Dorado','PR','TRT',18.43606,-66.281954,'P','H1','7224008','72051','1');
- INSERT INTO "place" VALUES('00647','Ensenada','PR','ENSNT',17.969594,-66.939754,'P','Z1','7226717','72055','1');
- INSERT INTO "place" VALUES('00650','Florida','PR','FLRT',18.360125,-66.562311,'P','H1','7228824','72054','1');
- INSERT INTO "place" VALUES('00652','Garrochales','PR','KRXLS',18.451935,-66.603113,'C','U1','7230286','72017','3');
- INSERT INTO "place" VALUES('00653','Guanica','PR','KNK',17.972468,-66.898661,'P','H1','7231189','72055','1');
- INSERT INTO "place" VALUES('00656','Guayanilla','PR','KYNL',18.02328,-66.786909,'P','H1','7232307','72059','1');
- INSERT INTO "place" VALUES('00656','Macana','PR','MKN',18.055796,-66.773509,'N','U6','7248045','72059','3');
- INSERT INTO "place" VALUES('00656','Magas Arriba','PR','MKSRB',18.017465,-66.769064,'N','U1','7248604','72059','3');
- INSERT INTO "place" VALUES('00657','Camarones','PR','KMRNS',18.336783,-66.111442,'N','Z1','7211280','72061','3');
- INSERT INTO "place" VALUES('00657','Munoz Rivera','PR','MNSRF',18.374116,-66.106555,'A','U6','7255656','72061','2');
- INSERT INTO "place" VALUES('00659','Hatillo','PR','HTL',18.481391,-66.808696,'P','H1','7233296','72065','1');
- INSERT INTO "place" VALUES('00660','Hormigueros','PR','HRMKR',18.145486,-67.135323,'P','H1','7235059','72067','1');
- INSERT INTO "place" VALUES('00662','Isabela','PR','ISBL',18.480285,-67.028155,'P','H1','7236478','72071','1');
- INSERT INTO "place" VALUES('00664','Jayuya','PR','JYY',18.217606,-66.598306,'P','H1','7238370','72073','1');
- INSERT INTO "place" VALUES('00667','Lajas','PR','LJS',18.015099,-67.055973,'P','H1','7240950','72079','1');
- INSERT INTO "place" VALUES('00669','Lares','PR','LRS',18.295952,-66.881925,'P','H1','7242498','72081','1');
- INSERT INTO "place" VALUES('00670','Las Marias','PR','LSMRS',18.236832,-66.990114,'C','U1','7243702','72011','2');
- INSERT INTO "place" VALUES('00674','Manati','PR','MNT',18.44553,-66.490268,'P','H1','7250152','72091','1');
- INSERT INTO "place" VALUES('00676','Moca','PR','MK',18.383727,-67.080799,'P','H1','7253807','72099','1');
- INSERT INTO "place" VALUES('00677','Rincon','PR','RNKN',18.335781,-67.252547,'P','H1','7269588','72117','1');
- INSERT INTO "place" VALUES('00678','Quebradillas','PR','KBRTL',18.45303,-66.933689,'P','H1','7268040','72115','1');
- INSERT INTO "place" VALUES('00680','Mayaguez','PR','MYKS',18.181938,-67.133802,'C','H1','7252431','72097','1');
- INSERT INTO "place" VALUES('00681','Mayaguez','PR','MYKS',18.219023,-67.508068,'B','H1','7252431','72097','1');
- INSERT INTO "place" VALUES('00682','Mayaguez','PR','MYKS',18.221443,-67.156062,'C','H1','7252431','72097','1');
- INSERT INTO "place" VALUES('00683','San German','PR','SNJRM',18.113284,-67.039706,'P','H1','7276167','72125','1');
- INSERT INTO "place" VALUES('00685','San Sebastian','PR','SNSBS',18.3236,-66.972227,'P','H1','7277500','72131','1');
- INSERT INTO "place" VALUES('00687','Morovis','PR','MRFS',18.316976,-66.415207,'P','H1','7255097','72101','1');
- INSERT INTO "place" VALUES('00688','Sabana Hoyos','PR','SBNHY',18.382264,-66.626438,'C','Z1','7273716','72013','1');
- INSERT INTO "place" VALUES('00690','San Antonio','PR','SNNTN',18.49551,-67.098671,'C','U1','7275608','72005','1');
- INSERT INTO "place" VALUES('00692','Vega Alta','PR','FKLT',18.435818,-66.338523,'P','H1','7285197','72143','1');
- INSERT INTO "place" VALUES('00693','Vega Baja','PR','FKBJ',18.443109,-66.398302,'P','H1','7285326','72145','1');
- INSERT INTO "place" VALUES('00694','Vega Baja','PR','FKBJ',18.48237,-66.391079,'C','H1','7285326','72145','1');
- INSERT INTO "place" VALUES('00698','Yauco','PR','YK',18.06104,-66.861164,'P','H1','7288035','72153','1');
- INSERT INTO "place" VALUES('00701','Boquillas','PR','BKLS',18.462446,-66.488227,'N','U6','7208270','72091','3');
- INSERT INTO "place" VALUES('00701','Montebello','PR','MNTBL',18.368005,-66.523227,'N','U6','7254237','72091','3');
- INSERT INTO "place" VALUES('00703','Aguas Buenas','PR','AKSBN',18.250398,-66.12845,'P','H1','7200874','72007','1');
- INSERT INTO "place" VALUES('00704','Aguirre','PR','AKR',17.96577,-66.219555,'C','B ','7201125','72057','1');
- INSERT INTO "place" VALUES('00705','Aibonito','PR','ABNT',18.128092,-66.268717,'P','H1','7201218','72009','1');
- INSERT INTO "place" VALUES('00707','Maunabo','PR','MNB',18.007014,-65.898719,'P','H1','7252302','72095','1');
- INSERT INTO "place" VALUES('00714','Arroyo','PR','ARY',17.96751,-66.04138,'P','H1','7203927','72015','1');
- INSERT INTO "place" VALUES('00715','Mercedita','PR','MRSTT',18.011854,-66.563721,'P','U6','7253033','72113','1');
- INSERT INTO "place" VALUES('00716','Ponce','PR','PNS',17.990567,-66.607542,'C','H1','7263820','72113','1');
- INSERT INTO "place" VALUES('00717','Ponce','PR','PNS',18.001995,-66.607429,'T','H1','7263820','72113','1');
- INSERT INTO "place" VALUES('00718','Duque','PR','TK',18.239401,-65.75044,'N','U1','7224395','72103','3');
- INSERT INTO "place" VALUES('00718','Naguabo','PR','NKB',18.22139,-65.77831,'P','H1','7255828','72103','1');
- INSERT INTO "place" VALUES('00719','Naranjito','PR','NRNJT',18.298017,-66.229751,'P','H1','7256129','72105','1');
- INSERT INTO "place" VALUES('00720','Orocovis','PR','ORKFS',18.226862,-66.39402,'P','H1','7257290','72107','1');
- INSERT INTO "place" VALUES('00721','Palmer','PR','PLMR',18.364161,-65.778288,'B','U1','7258666','72119','1');
- INSERT INTO "place" VALUES('00721','Rio Grande','PR','RKRNT',18.380227,-65.831275,'T','U1','7271136','72119','2');
- INSERT INTO "place" VALUES('00723','Patillas','PR','PTLS',18.009994,-66.010572,'P','H1','7260472','72109','1');
- INSERT INTO "place" VALUES('00725','Caguas','PR','KKS',18.218819,-66.042375,'C','H1','7210334','72025','1');
- INSERT INTO "place" VALUES('00726','Caguas','PR','KKS',18.212965,-66.058033,'B','H1','7210334','72025','1');
- INSERT INTO "place" VALUES('00727','Bayamón','PR','BYMN',18.177309,-66.103429,'Q',NULL,NULL,NULL,'4');
- INSERT INTO "place" VALUES('00727','Caguas','PR','KKS',18.230135,-66.054848,'Q',NULL,NULL,NULL,'4');
- INSERT INTO "place" VALUES('00727','Hacienda San Jose','PR','HSNTS',18.240897,-66.072085,'Q',NULL,NULL,NULL,'4');
- INSERT INTO "place" VALUES('00727','Las Carolinas','PR','LSKRL',18.253848,-66.065961,'Q',NULL,NULL,NULL,'4');
- INSERT INTO "place" VALUES('00727','Los Panes','PR','LSPNS',18.187108,-66.07624,'Q',NULL,NULL,NULL,'4');
- INSERT INTO "place" VALUES('00727','Los Prados','PR','LSPRT',18.233037,-66.062108,'Q',NULL,NULL,NULL,'4');
- INSERT INTO "place" VALUES('00728','Ponce','PR','PNS',17.989853,-66.664116,'C','H1','7263820','72113','1');
- INSERT INTO "place" VALUES('00729','Canovanas','PR','KNFNS',18.333093,-65.883864,'P','H1','7212828','72029','1');
- INSERT INTO "place" VALUES('00730','Ponce','PR','PNS',18.030831,-66.616838,'C','H1','7263820','72113','1');
- INSERT INTO "place" VALUES('00731','Ponce','PR','PNS',18.108039,-66.634653,'C','H1','7263820','72113','1');
- INSERT INTO "place" VALUES('00732','Ponce','PR','PNS',18.021781,-66.613742,'B','H1','7263820','72113','1');
- INSERT INTO "place" VALUES('00733','Ponce','PR','PNS',18.019331,-66.619165,'B','H1','7263820','72113','1');
- INSERT INTO "place" VALUES('00734','Ponce','PR','PNS',17.999499,-66.643934,'B','H1','7263820','72113','1');
- INSERT INTO "place" VALUES('00735','Ceiba','PR','SB',18.252604,-65.682494,'C','H1','7215924','72037','1');
- INSERT INTO "place" VALUES('00736','Cayey','PR','KY',18.102967,-66.139274,'P','H1','7215494','72035','1');
- INSERT INTO "place" VALUES('00737','Cayey','PR','KY',18.102967,-66.139274,'B','H1','7215494','72035','1');
- INSERT INTO "place" VALUES('00738','Fajardo','PR','FJRT',18.359381,-65.611361,'T','H1','7227964','72053','1');
- INSERT INTO "place" VALUES('00739','Cidra','PR','STR',18.181469,-66.169519,'P','H1','7218074','72041','1');
- INSERT INTO "place" VALUES('00740','Puerto Real','PR','PRTRL',18.33116,-65.63412,'C','U1','7265589','72023','2');
- INSERT INTO "place" VALUES('00741','Punta Santiago','PR','PNTSN',18.162156,-65.753485,'P','Z1','7266492','72069','1');
- INSERT INTO "place" VALUES('00744','Rio Blanco','PR','RBLNK',18.206329,-65.743058,'B','Z1','7270448','72103','1');
- INSERT INTO "place" VALUES('00745','Rio Grande','PR','RKRNT',18.367347,-65.816583,'P','H1','7271136','72119','1');
- INSERT INTO "place" VALUES('00751','Salinas','PR','SLNS',17.99852,-66.264825,'P','H1','7274877','72123','1');
- INSERT INTO "place" VALUES('00754','San Lorenzo','PR','SNLRN',18.187584,-65.962389,'P','H1','7277027','72129','1');
- INSERT INTO "place" VALUES('00757','Paso Seco','PR','PSSK',18.002743,-66.389892,'N','U6','7259870','72133','3');
- INSERT INTO "place" VALUES('00757','Playa Cortada','PR','PLYKR',17.976632,-66.441282,'N','U6','7262880','72133','3');
- INSERT INTO "place" VALUES('00757','Santa Isabel','PR','SNTSB',17.991233,-66.395543,'P','H1','7278145','72133','1');
- INSERT INTO "place" VALUES('00763','La Trocha','PR','LTRX',18.441058,-66.381559,'N','U6','7244906','72145','3');
- INSERT INTO "place" VALUES('00765','Esperanza','PR','ESPRN',18.097187,-65.470714,'A','U1','7227190','72147','2');
- INSERT INTO "place" VALUES('00765','Santa Maria','PR','SNTMR',18.152185,-65.432103,'A','U6','7278532','72147','2');
- INSERT INTO "place" VALUES('00765','Vieques','PR','FKS',18.123347,-65.460356,'P','H1','7286014','72147','1');
- INSERT INTO "place" VALUES('00766','Villalba','PR','FLLB',18.120519,-66.496607,'P','H1','7286831','72149','1');
- INSERT INTO "place" VALUES('00767','Yabucoa','PR','YBK',18.045522,-65.886988,'P','H1','7287863','72151','1');
- INSERT INTO "place" VALUES('00768','Palomas','PR','PLMS',18.013576,-66.873232,'A','U1','7259053','72153','2');
- INSERT INTO "place" VALUES('00769','Coamo','PR','KM',18.095992,-66.35081,'P','H1','7218719','72043','1');
- INSERT INTO "place" VALUES('00771','Las Piedras','PR','LSPTR',18.196576,-65.87197,'P','H1','7244390','72085','1');
- INSERT INTO "place" VALUES('00772','Loiza','PR','LS',18.447406,-65.899357,'P','H1','7246368','72087','1');
- INSERT INTO "place" VALUES('00773','Luquillo','PR','LKL',18.366027,-65.708138,'P','H1','7247787','72089','1');
- INSERT INTO "place" VALUES('00775','Culebra','PR','KLBR',18.323736,-65.296467,'B','H1','7222589','72049','1');
- INSERT INTO "place" VALUES('00777','Juncos','PR','JNKS',18.206489,-65.901774,'P','H1','7239574','72077','1');
- INSERT INTO "place" VALUES('00778','Gurabo','PR','KRB',18.259092,-65.974641,'P','H1','7232823','72063','1');
- INSERT INTO "place" VALUES('00780','Coto Laurel','PR','KTLRL',18.102834,-66.568105,'C','Z1','7221213','72113','1');
- INSERT INTO "place" VALUES('00782','Comerio','PR','KMR',18.224958,-66.219885,'P','H1','7219665','72045','1');
- INSERT INTO "place" VALUES('00783','Corozal','PR','KRSL',18.304369,-66.330525,'P','H1','7220783','72047','1');
- INSERT INTO "place" VALUES('00784','Guayama','PR','KYM',18.010721,-66.133613,'C','H1','7232221','72057','1');
- INSERT INTO "place" VALUES('00785','Guayama','PR','KYM',18.018822,-66.795603,'B','H1','7232221','72057','1');
- INSERT INTO "place" VALUES('00786','La Plata','PR','LPLT',18.155424,-66.229907,'C','U6','7241982','72009','1');
- INSERT INTO "place" VALUES('00791','Humacao','PR','HMK',18.138029,-65.788499,'P','H1','7235532','72069','1');
- INSERT INTO "place" VALUES('00792','Humacao','PR','HMK',18.138029,-65.788499,'B','H1','7235532','72069','1');
- INSERT INTO "place" VALUES('00794','Barranquitas','PR','BRNKT',18.200898,-66.307236,'P','H1','7205690','72019','1');
- INSERT INTO "place" VALUES('00795','Juana Diaz','PR','JNTS',17.997367,-66.493218,'P','H1','7238972','72075','1');
- INSERT INTO "place" VALUES('00801','Altona','VI','ALTN',18.338846,-64.948758,'N','U6','7801900','78030','3');
- INSERT INTO "place" VALUES('00801','Anna''s Retreat','VI','ANSRT',18.340799,-64.888479,'N','U2','7805500','78030','3');
- INSERT INTO "place" VALUES('00801','Charlotte Amalie','VI','XRLTM',18.3419,-64.930701,'A','C9','7816300','78030','2');
- INSERT INTO "place" VALUES('00801','Charlotte Amalie East','VI','XRLTM',18.335469,-64.913403,'N','U2','7818100','78030','3');
- INSERT INTO "place" VALUES('00801','Charlotte Amalie West','VI','XRLTM',18.336723,-64.961563,'N','U2','7819000','78030','3');
- INSERT INTO "place" VALUES('00801','Contant','VI','KNTNT',18.341901,-64.95598,'N','U6','7826200','78030','3');
- INSERT INTO "place" VALUES('00801','Frenchtown','VI','FRNXT',18.33829,-64.94209,'N','U6','7840600','78030','3');
- INSERT INTO "place" VALUES('00801','Frydendal','VI','FRTNT',18.345788,-64.872364,'N','U6','7842400','78030','3');
- INSERT INTO "place" VALUES('00801','Mandal','VI','MNTL',18.35551,-64.898476,'N','U6','7856800','78030','3');
- INSERT INTO "place" VALUES('00801','Pearson Gardens','VI','PRSNK',18.340233,-64.9182,'N','U6','7864000','78030','3');
- INSERT INTO "place" VALUES('00801','Saint Thomas','VI','SNTMS',18.322285,-64.963715,'B','H4','7899030','78030','1');
- INSERT INTO "place" VALUES('00802','Saint Thomas','VI','SNTMS',18.322285,-64.963715,'P','H4','7899030','78030','1');
- INSERT INTO "place" VALUES('00803','Saint Thomas','VI','SNTMS',18.322285,-64.963715,'B','H4','7899030','78030','1');
- INSERT INTO "place" VALUES('00804','Saint Thomas','VI','SNTMS',18.322285,-64.963715,'B','H4','7899030','78030','1');
- INSERT INTO "place" VALUES('00805','Saint Thomas','VI','SNTMS',18.322285,-64.963715,'B','H4','7899030','78030','1');
- INSERT INTO "place" VALUES('00820','Altona','VI','ALTN',17.744696,-64.694031,'N','U6','7801000','78010','3');
- INSERT INTO "place" VALUES('00820','Anguilla','VI','ANKL',17.706641,-64.779868,'N','U6','7802400','78010','3');
- INSERT INTO "place" VALUES('00820','Annas Hope','VI','ANXP',17.728307,-64.728755,'N','U6','7803700','78010','3');
- INSERT INTO "place" VALUES('00820','Bethlehem Old Work','VI','B0LHM',17.731363,-64.793757,'N','U6','7807300','78010','3');
- INSERT INTO "place" VALUES('00820','Butler Bay','VI','BTLRB',17.748584,-64.891535,'N','U6','7810000','78010','3');
- INSERT INTO "place" VALUES('00820','Camporico','VI','KMPRK',17.693587,-64.86848,'N','U6','7810900','78010','3');
- INSERT INTO "place" VALUES('00820','Canebay','VI','KNB',17.771639,-64.810145,'N','U6','7811800','78010','3');
- INSERT INTO "place" VALUES('00820','Carlton','VI','KRLTN',17.702753,-64.849868,'N','U6','7812700','78010','3');
- INSERT INTO "place" VALUES('00820','Castle Coakley','VI','KSTLK',17.723307,-64.745422,'N','U6','7814500','78010','3');
- INSERT INTO "place" VALUES('00820','Christiansted','VI','KRSXN',17.734211,-64.734694,'P','Z5','7819900','78010','1');
- INSERT INTO "place" VALUES('00820','Coble','VI','KBL',17.740251,-64.806812,'N','U6','7822600','78010','3');
- INSERT INTO "place" VALUES('00820','Concordia','VI','KNKRT',17.686087,-64.87348,'N','U6','7824400','78010','3');
- INSERT INTO "place" VALUES('00820','Diamond','VI','TMNT',17.730529,-64.754033,'N','U6','7829800','78010','3');
- INSERT INTO "place" VALUES('00820','Fredensborg','VI','FRTNS',17.734974,-64.781534,'N','U6','7836100','78010','3');
- INSERT INTO "place" VALUES('00820','Fredensdal','VI','FRTNS',17.739973,-64.712087,'N','U6','7837000','78010','3');
- INSERT INTO "place" VALUES('00820','Frederiksted Southeast','VI','FRTRK',17.70619,-64.878851,'N','U2','7839700','78010','3');
- INSERT INTO "place" VALUES('00820','Friedensfeld','VI','FRTNS',17.746084,-64.780423,'N','U6','7841500','78010','3');
- INSERT INTO "place" VALUES('00820','Glynn','VI','KLN',17.748306,-64.774589,'N','U6','7843300','78010','3');
- INSERT INTO "place" VALUES('00820','Golden Grove','VI','KLTNK',17.71553,-64.800979,'N','U6','7844200','78010','3');
- INSERT INTO "place" VALUES('00820','Grange','VI','KRNJ',17.731085,-64.721532,'N','U6','7845100','78010','3');
- INSERT INTO "place" VALUES('00820','Grove Place','VI','KRFPL',17.72553,-64.822646,'N','U1','7846000','78010','3');
- INSERT INTO "place" VALUES('00820','Hesselberg','VI','HSLBR',17.697475,-64.879869,'N','U6','7847800','78010','3');
- INSERT INTO "place" VALUES('00820','Jealousy','VI','JLS',17.735529,-64.803757,'N','U6','7848700','78010','3');
- INSERT INTO "place" VALUES('00820','Jerusalem and Figtree Hill','VI','JRSLM',17.712474,-64.750423,'N','U6','7849600','78010','3');
- INSERT INTO "place" VALUES('00820','La Grande Princesse','VI','LKRNT',17.757472,-64.736254,'N','U6','7852300','78010','3');
- INSERT INTO "place" VALUES('00820','La Grange','VI','LKRNJ',17.719141,-64.87848,'N','U6','7853200','78010','3');
- INSERT INTO "place" VALUES('00820','La Vallee','VI','LFL',17.783583,-64.802089,'N','U6','7854100','78010','3');
- INSERT INTO "place" VALUES('00820','Longford','VI','LNKFR',17.716085,-64.694865,'N','U6','7855000','78010','3');
- INSERT INTO "place" VALUES('00820','Lower Love','VI','LWRLF',17.722197,-64.807646,'N','U6','7855900','78010','3');
- INSERT INTO "place" VALUES('00820','Mount Pleasant','VI','MNTPL',17.745807,-64.800701,'N','U6','7857700','78010','3');
- INSERT INTO "place" VALUES('00820','Negro Bay','VI','NKRB',17.70803,-64.807368,'N','U6','7858600','78010','3');
- INSERT INTO "place" VALUES('00820','North Side','VI','NR0ST',17.758584,-64.888202,'N','U6','7860400','78010','3');
- INSERT INTO "place" VALUES('00820','Prosperity','VI','PRSPR',17.726085,-64.882091,'N','U6','7864900','78010','3');
- INSERT INTO "place" VALUES('00820','Richmond','VI','RXMNT',17.745251,-64.715976,'N','U6','7865800','78010','3');
- INSERT INTO "place" VALUES('00820','Ruby','VI','RB',17.736918,-64.754867,'N','U6','7866700','78010','3');
- INSERT INTO "place" VALUES('00820','Saint John','VI','SNTJN',17.763583,-64.747088,'N','U6','7867600','78010','3');
- INSERT INTO "place" VALUES('00820','Sallys Fancy','VI','SLSFN',17.735807,-64.666809,'N','U6','7868500','78010','3');
- INSERT INTO "place" VALUES('00820','Shoys','VI','XS',17.755251,-64.682364,'N','U6','7869400','78010','3');
- INSERT INTO "place" VALUES('00820','Sion Farm','VI','XNFRM',17.732474,-64.7432,'N','U6','7870300','78010','3');
- INSERT INTO "place" VALUES('00820','Slob','VI','SLB',17.730807,-64.780423,'N','U6','7872100','78010','3');
- INSERT INTO "place" VALUES('00820','Smithfield','VI','SM0FL',17.699698,-64.880424,'N','U6','7873000','78010','3');
- INSERT INTO "place" VALUES('00820','Strawberry Hill','VI','STRBR',17.732196,-64.760978,'N','U6','7876600','78010','3');
- INSERT INTO "place" VALUES('00820','Two Brothers','VI','TWBR0',17.706364,-64.879313,'N','U6','7879300','78010','3');
- INSERT INTO "place" VALUES('00820','Upper Bethlehem','VI','UPRB0',17.71553,-64.79209,'N','U6','7880200','78010','3');
- INSERT INTO "place" VALUES('00820','Wheel of Fortune','VI','WLFRT',17.712197,-64.87098,'N','U6','7883800','78010','3');
- INSERT INTO "place" VALUES('00820','Whim','VI','WM',17.699975,-64.862091,'N','U6','7884700','78010','3');
- INSERT INTO "place" VALUES('00821','Christiansted','VI','KRSXN',17.734211,-64.734694,'B','Z5','7819900','78010','1');
- INSERT INTO "place" VALUES('00822','Christiansted','VI','KRSXN',17.734211,-64.734694,'B','Z5','7819900','78010','1');
- INSERT INTO "place" VALUES('00823','Christiansted','VI','KRSXN',17.734211,-64.734694,'B','Z5','7819900','78010','1');
- INSERT INTO "place" VALUES('00824','Christiansted','VI','KRSXN',17.734211,-64.734694,'B','Z5','7819900','78010','1');
- INSERT INTO "place" VALUES('00830','Bethany','VI','B0N',18.331065,-64.782916,'N','U6','7806400','78020','3');
- INSERT INTO "place" VALUES('00830','Bordeaux','VI','BRTK',18.335232,-64.72097,'N','U6','7808200','78020','3');
- INSERT INTO "place" VALUES('00830','Carolina','VI','KRLN',18.347176,-64.721525,'N','U6','7813600','78020','3');
- INSERT INTO "place" VALUES('00830','Contant','VI','KNTNT',18.32551,-64.792361,'N','U6','7825300','78020','3');
- INSERT INTO "place" VALUES('00830','Cruz Bay','VI','KRSB',18.331343,-64.79375,'A','U1','7828000','78020','2');
- INSERT INTO "place" VALUES('00830','East End','VI','ESTNT',18.339677,-64.67458,'N','U6','7832500','78020','3');
- INSERT INTO "place" VALUES('00830','Enighed','VI','ENKT',18.328288,-64.791527,'N','U6','7835200','78020','3');
- INSERT INTO "place" VALUES('00830','Palestina','VI','PLSTN',18.348843,-64.706803,'N','U6','7863100','78020','3');
- INSERT INTO "place" VALUES('00830','Saint John','VI','SNTJN',18.32816,-64.740737,'P','H4','7899020','78020','1');
- INSERT INTO "place" VALUES('00831','Saint John','VI','SNTJN',18.32816,-64.740737,'B','H4','7899020','78020','1');
- INSERT INTO "place" VALUES('00840','Frederiksted','VI','FRTRK',17.734211,-64.734694,'P','Z5','7837900','78010','1');
- INSERT INTO "place" VALUES('00841','Frederiksted','VI','FRTRK',17.734211,-64.734694,'B','Z5','7837900','78010','1');
- INSERT INTO "place" VALUES('00850','Kingshill','VI','KNKXL',17.734211,-64.734694,'P','U6','7850500','78010','1');
- INSERT INTO "place" VALUES('00851','Kingshill','VI','KNKXL',17.734211,-64.734694,'B','U6','7850500','78010','1');
- INSERT INTO "place" VALUES('00901','San Juan','PR','SNJN',18.465901,-66.103568,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00902','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00903','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00904','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00905','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00906','San Juan','PR','SNJN',18.46446,-66.094995,'C','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00907','Condado','PR','KNTT',18.45439,-66.070721,'A','U6','7219923','72127','2');
- INSERT INTO "place" VALUES('00907','San Juan','PR','SNJN',18.451647,-66.077003,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00907','Santurce','PR','SNTRS',18.452679,-66.078113,'C','U6','7279650','72097','2');
- INSERT INTO "place" VALUES('00908','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00909','San Juan','PR','SNJN',18.443384,-66.068133,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00910','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00911','San Juan','PR','SNJN',18.450828,-66.057859,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00912','San Juan','PR','SNJN',18.444187,-66.059859,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00913','San Juan','PR','SNJN',18.450735,-66.043352,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00914','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00915','San Juan','PR','SNJN',18.437896,-66.048087,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00916','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00917','San Juan','PR','SNJN',18.422018,-66.050602,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00918','San Juan','PR','SNJN',18.419069,-66.062319,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00919','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00920','Puerto Nuevo','PR','PRTNF',18.411614,-66.081833,'N','U6','7265460','72127','3');
- INSERT INTO "place" VALUES('00920','San Juan','PR','SNJN',18.406808,-66.091885,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00921','San Juan','PR','SNJN',18.392273,-66.088552,'C','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00922','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00923','Rio Piedras','PR','RPTRS',18.409307,-66.038888,'C','U6','7271566','72127','2');
- INSERT INTO "place" VALUES('00923','San Juan','PR','SNJN',18.410775,-66.036708,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00924','San Juan','PR','SNJN',18.396392,-66.01146,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00925','San Juan','PR','SNJN',18.401055,-66.049773,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00926','La Cumbre','PR','LKMBR',18.35995,-66.075722,'A','U6','7240305','72127','2');
- INSERT INTO "place" VALUES('00926','San Juan','PR','SNJN',18.369376,-66.062804,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00927','San Juan','PR','SNJN',18.385174,-66.071959,'T','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00928','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00929','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00930','San Jose','PR','SNJS',18.398282,-66.255724,'N','U1','7276640','72137','3');
- INSERT INTO "place" VALUES('00930','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00931','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00932','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00933','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00934','Fort Buchanan','PR','FRTBX',18.411313,-66.124234,'C','M1','7229125','72021','1');
- INSERT INTO "place" VALUES('00935','San Juan','PR','SNJN',18.410462,-66.060533,'U','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00936','San Juan','PR','SNJN',18.395463,-66.073773,'C','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00937','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00938','San Juan','PR','SNJN',18.410462,-66.060533,'P','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00939','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00940','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00941','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00942','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00943','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00944','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00945','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00946','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00947','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00948','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00949','Levittown','PR','LFTN',18.449946,-66.181556,'A','U1','7245336','72137','2');
- INSERT INTO "place" VALUES('00949','Toa Baja','PR','TBJ',18.431911,-66.199692,'T','H1','7282617','72137','1');
- INSERT INTO "place" VALUES('00950','Toa Baja','PR','TBJ',18.463693,-66.234559,'C','H1','7282617','72137','1');
- INSERT INTO "place" VALUES('00951','Toa Baja','PR','TBJ',18.42753,-66.253789,'C','H1','7282617','72137','1');
- INSERT INTO "place" VALUES('00952','Sabana Seca','PR','SBNSK',18.427441,-66.182032,'C','Z1','7274189','72137','1');
- INSERT INTO "place" VALUES('00953','Toa Alta','PR','TLT',18.356795,-66.25701,'P','H1','7282488','72135','1');
- INSERT INTO "place" VALUES('00954','Toa Alta','PR','TLT',18.358939,-66.258108,'B','H1','7282488','72135','1');
- INSERT INTO "place" VALUES('00955','San Juan','PR','SNJN',18.410462,-66.060533,'B','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00956','Bayamon','PR','BYMN',18.326702,-66.174176,'P','H1','7206593','72021','1');
- INSERT INTO "place" VALUES('00957','Bayamon','PR','BYMN',18.366645,-66.183907,'P','H1','7206593','72021','1');
- INSERT INTO "place" VALUES('00958','Bayamon','PR','BYMN',18.34487,-66.166014,'B','H1','7206593','72021','1');
- INSERT INTO "place" VALUES('00959','Bayamon','PR','BYMN',18.387058,-66.159044,'P','H1','7206593','72021','1');
- INSERT INTO "place" VALUES('00960','Bayamon','PR','BYMN',18.416919,-66.145795,'C','H1','7206593','72021','1');
- INSERT INTO "place" VALUES('00961','Bayamon','PR','BYMN',18.413195,-66.168651,'P','H1','7206593','72021','1');
- INSERT INTO "place" VALUES('00962','Catano','PR','KTN',18.437644,-66.140407,'P','H1','7215193','72033','1');
- INSERT INTO "place" VALUES('00963','Catano','PR','KTN',18.443217,-66.139293,'B','H1','7215193','72033','1');
- INSERT INTO "place" VALUES('00964','San Juan','PR','SNJN',18.466334,-66.105722,'I','U1','7276770','72127','4');
- INSERT INTO "place" VALUES('00965','Guaynabo','PR','KNB',18.433757,-66.114752,'C','H1','7232522','72061','1');
- INSERT INTO "place" VALUES('00966','Guaynabo','PR','KNB',18.396815,-66.114889,'P','H1','7232522','72061','1');
- INSERT INTO "place" VALUES('00968','Guaynabo','PR','KNB',18.406077,-66.101223,'C','H1','7232522','72061','1');
- INSERT INTO "place" VALUES('00969','Guaynabo','PR','KNB',18.362322,-66.113729,'P','H1','7232522','72061','1');
- INSERT INTO "place" VALUES('00970','Guaynabo','PR','KNB',18.359143,-66.112295,'B','H1','7232522','72061','1');
- INSERT INTO "place" VALUES('00971','Guaynabo','PR','KNB',18.30942,-66.113606,'P','H1','7232522','72061','1');
- INSERT INTO "place" VALUES('00975','San Juan','PR','SNJN',18.410462,-66.060533,'U','H1','7276770','72127','1');
- INSERT INTO "place" VALUES('00976','Trujillo Alto','PR','TRJLL',18.338133,-65.989229,'P','H1','7283606','72139','1');
- INSERT INTO "place" VALUES('00977','Trujillo Alto','PR','TRJLL',18.337004,-65.990099,'B','H1','7283606','72139','1');
- INSERT INTO "place" VALUES('00978','Saint Just','PR','SNTJS',18.368005,-66.011832,'N','U6','7274662','72139','3');
- INSERT INTO "place" VALUES('00979','Carolina','PR','KRLN',18.444389,-66.030129,'C','H1','7214290','72031','1');
- INSERT INTO "place" VALUES('00981','Carolina','PR','KRLN',18.410462,-66.060533,'P','H1','7214290','72031','1');
- INSERT INTO "place" VALUES('00982','Carolina','PR','KRLN',18.411261,-65.992045,'C','H1','7214290','72031','1');
- INSERT INTO "place" VALUES('00983','Carolina','PR','KRLN',18.413452,-65.977659,'P','H1','7214290','72031','1');
- INSERT INTO "place" VALUES('00984','Carolina','PR','KRLN',18.393355,-65.972495,'B','H1','7214290','72031','1');
- INSERT INTO "place" VALUES('00985','Carolina','PR','KRLN',18.408588,-65.946933,'C','H1','7214290','72031','1');
- INSERT INTO "place" VALUES('00986','Carolina','PR','KRLN',18.393355,-65.972495,'B','H1','7214290','72031','1');
- INSERT INTO "place" VALUES('00987','Carolina','PR','KRLN',18.373466,-65.959932,'T','H1','7214290','72031','1');
- INSERT INTO "place" VALUES('00988','Carolina','PR','KRLN',18.393355,-65.972495,'B','H1','7214290','72031','1');
- INSERT INTO "place" VALUES('01001','Agawam','MA','AKWM',42.06954,-72.61481,'G','X3','2500765','25013','1');
- INSERT INTO "place" VALUES('01002','Amherst','MA','AMHRS',42.367092,-72.464571,'P','T1','2501290','25015','1');
- INSERT INTO "place" VALUES('01002','Cushman','MA','KXMN',42.413978,-72.506476,'A','U6','2516075','25015','2');
- INSERT INTO "place" VALUES('01002','Dwight','MA','TWT',42.363977,-72.458507,'C','U6','2517965','25015','3');
- INSERT INTO "place" VALUES('01002','Factory Hollow','MA','FKTRH',42.415367,-72.518699,'N','U6','2522060','25015','3');
- INSERT INTO "place" VALUES('01002','Pelham','MA','PLHM',42.393146,-72.403696,'N','U6','2552525','25015','3');
- INSERT INTO "place" VALUES('01002','South Amherst','MA','S0MHR',42.340368,-72.505087,'N','U1','2562675','25015','3');
- INSERT INTO "place" VALUES('01002','West Pelham','MA','WSTPL',42.377868,-72.470364,'N','U6','2577500','25015','3');
- INSERT INTO "place" VALUES('01003','Amherst','MA','AMHRS',42.389941,-72.524108,'C','T1','2501290','25015','1');
- INSERT INTO "place" VALUES('01004','Amherst','MA','AMHRS',42.384494,-72.513183,'B','T1','2501290','25015','1');
- INSERT INTO "place" VALUES('01005','Barre','MA','BR',42.42301,-72.10638,'G','T1','2503705','25027','1');
- INSERT INTO "place" VALUES('01006','Barre Plains','MA','BRPLN',42.377869,-72.109245,'N','U6','2503810','25027','3');
- INSERT INTO "place" VALUES('01007','Belchertown','MA','BLXRT',42.280267,-72.402056,'P','T1','2504790','25015','1');
- INSERT INTO "place" VALUES('01008','Blandford','MA','BLNTF',42.177833,-72.958359,'P','T1','2506050','25013','1');
- INSERT INTO "place" VALUES('01008','North Blandford','MA','NR0BL',42.210368,-72.981491,'N','U6','2546715','25013','3');
- INSERT INTO "place" VALUES('01009','Bondsville','MA','BNTSF',42.206092,-72.340486,'B','U1','2506400','25013','1');
- INSERT INTO "place" VALUES('01010','Brimfield','MA','BRMFL',42.108585,-72.20448,'P','T1','2508435','25013','1');
- INSERT INTO "place" VALUES('01010','East Brimfield','MA','ESTBR',42.111206,-72.148411,'N','U6','2518490','25013','3');
- INSERT INTO "place" VALUES('01011','Becket Center','MA','BKTSN',42.300282,-72.968716,'C','U6','2504580','25003','3');
- INSERT INTO "place" VALUES('01011','Chester','MA','XSTR',42.294259,-72.952776,'P','T1','2513450','25013','1');
- INSERT INTO "place" VALUES('01011','Chester Center','MA','XSTRS',42.290366,-72.924543,'N','U6','2513520','25013','3');
- INSERT INTO "place" VALUES('01012','Chesterfield','MA','XSTRF',42.392274,-72.825607,'P','T1','2513555','25015','1');
- INSERT INTO "place" VALUES('01013','Chicopee','MA','XKP',42.154904,-72.602804,'C','C5','2513660','25013','1');
- INSERT INTO "place" VALUES('01014','Chicopee','MA','XKP',42.170731,-72.604842,'B','C5','2513660','25013','1');
- INSERT INTO "place" VALUES('01015','Chicopee','MA','XKP',42.148704,-72.607867,'I','C5','2513660','25013','4');
- INSERT INTO "place" VALUES('01016','Chicopee','MA','XKP',42.148704,-72.607867,'I','C5','2513660','25013','4');
- INSERT INTO "place" VALUES('01017','Chicopee','MA','XKP',42.148704,-72.607867,'I','C5','2513660','25013','4');
- INSERT INTO "place" VALUES('01018','Chicopee','MA','XKP',42.148704,-72.607867,'I','C5','2513660','25013','4');
- INSERT INTO "place" VALUES('01019','Chicopee','MA','XKP',42.148704,-72.607867,'I','C5','2513660','25013','4');
- INSERT INTO "place" VALUES('01020','Chicopee','MA','XKP',42.177492,-72.562563,'P','C5','2513660','25013','1');
- INSERT INTO "place" VALUES('01021','Chicopee','MA','XKP',42.170731,-72.604842,'B','C5','2513660','25013','1');
- INSERT INTO "place" VALUES('01022','Chicopee','MA','XKP',42.193392,-72.55436,'P','C5','2513660','25013','1');
- INSERT INTO "place" VALUES('01026','Cummington','MA','KMNKT',42.46175,-72.89398,'G','T1','2516005','25015','1');
- INSERT INTO "place" VALUES('01026','Swift River','MA','SWFTR',42.447309,-72.857873,'N','U6','2568890','25015','3');
- INSERT INTO "place" VALUES('01026','West Cummington','MA','WSTKM',42.491752,-72.967598,'N','U6','2575715','25015','3');
- INSERT INTO "place" VALUES('01027','Easthampton','MA','ES0MP',42.26676,-72.66898,'G','X3','2519330','25015','1');
- INSERT INTO "place" VALUES('01027','Loudville','MA','LTFL',42.287589,-72.737593,'N','U6','2536475','25015','3');
- INSERT INTO "place" VALUES('01027','Mount Tom','MA','MNTM',42.286202,-72.616201,'A','U6','2543230','25015','2');
- INSERT INTO "place" VALUES('01027','Westhampton','MA','WS0MP',42.302867,-72.774538,'N','U6','2576345','25015','3');
- INSERT INTO "place" VALUES('01028','Baptist Village','MA','BPTST',42.047318,-72.470363,'N','U6','2503495','25013','3');
- INSERT INTO "place" VALUES('01028','East Longmeadow','MA','ESTLN',42.062009,-72.49874,'P','U6','2519645','25013','1');
- INSERT INTO "place" VALUES('01029','East Otis','MA','ESTTS',42.190904,-73.051661,'B','U6','2520240','25003','1');
- INSERT INTO "place" VALUES('01030','Feeding Hills','MA','FTNKL',42.06815,-72.6787,'G','U6','2523455','25013','1');
- INSERT INTO "place" VALUES('01031','Gilbertville','MA','JLBRT',42.31259,-72.20786,'G','U6','2525695','25027','1');
- INSERT INTO "place" VALUES('01032','Goshen','MA','KXN',42.443837,-72.819446,'T','T1','2526255','25015','1');
- INSERT INTO "place" VALUES('01032','Lithia','MA','L0',42.456198,-72.835094,'A','U6','2535670','25015','2');
- INSERT INTO "place" VALUES('01033','Granby','MA','KRNB',42.262285,-72.504086,'P','T1','2526500','25015','1');
- INSERT INTO "place" VALUES('01034','Granville','MA','KRNFL',42.112748,-72.952003,'P','T1','2526640','25013','1');
- INSERT INTO "place" VALUES('01034','Granville Center','MA','KRNFL',42.067316,-72.87871,'N','U6','2526710','25013','3');
- INSERT INTO "place" VALUES('01034','West Granville','MA','WSTKR',42.077315,-72.943435,'N','U6','2576275','25013','3');
- INSERT INTO "place" VALUES('01035','Hadley','MA','HTL',42.356804,-72.576613,'P','T1','2527655','25015','1');
- INSERT INTO "place" VALUES('01035','North Hadley','MA','NR0TL',42.3862,-72.581478,'N','U6','2548045','25015','3');
- INSERT INTO "place" VALUES('01036','Hampden','MA','HMPTN',42.067614,-72.417507,'P','H4','2528040','25013','1');
- INSERT INTO "place" VALUES('01037','Hardwick','MA','HRTWK',42.347856,-72.225251,'B','T1','2528705','25027','1');
- INSERT INTO "place" VALUES('01038','Bradstreet','MA','BRTST',42.410644,-72.591756,'N','U6','2507630','25015','3');
- INSERT INTO "place" VALUES('01038','Hatfield','MA','HTFLT',42.37194,-72.60689,'G','X3','2529230','25015','1');
- INSERT INTO "place" VALUES('01039','Haydenville','MA','HTNFL',42.37509,-72.70092,'G','U6','2529545','25015','1');
- INSERT INTO "place" VALUES('01039','West Whately','MA','WSTHT',42.404278,-72.688922,'C','U6','2578515','25011','3');
- INSERT INTO "place" VALUES('01040','Brightside','MA','BRTST',42.162593,-72.632868,'N','U4','2508365','25013','3');
- INSERT INTO "place" VALUES('01040','Elmwood','MA','ELMWT',42.195925,-72.624534,'N','U4','2521605','25013','3');
- INSERT INTO "place" VALUES('01040','Highland Park','MA','HFLNT',42.222314,-72.620368,'N','U4','2530000','25013','3');
- INSERT INTO "place" VALUES('01040','Highlands','MA','HFLNT',42.219536,-72.624534,'N','U4','2530035','25013','3');
- INSERT INTO "place" VALUES('01040','Holyoke','MA','HLYK',42.198291,-72.64207,'P','C5','2530840','25013','1');
- INSERT INTO "place" VALUES('01040','Oakdale','MA','OKTL',42.204259,-72.624534,'N','U4','2550460','25013','3');
- INSERT INTO "place" VALUES('01040','Rock Valley','MA','RKFL',42.193981,-72.675925,'N','U4','2557985','25013','3');
- INSERT INTO "place" VALUES('01040','Smiths Ferry','MA','SM0SF',42.258424,-72.614256,'N','U4','2562325','25013','3');
- INSERT INTO "place" VALUES('01040','Springdale','MA','SPRNK',42.191759,-72.620368,'N','U4','2566210','25013','3');
- INSERT INTO "place" VALUES('01041','Holyoke','MA','HLYK',42.170731,-72.604842,'B','C5','2530840','25013','1');
- INSERT INTO "place" VALUES('01050','Crescent Mills','MA','KRSNT',42.286751,-72.869693,'C','U6','2515865','25013','3');
- INSERT INTO "place" VALUES('01050','Goss Heights','MA','KSTS',42.262589,-72.873153,'N','U6','2526360','25015','3');
- INSERT INTO "place" VALUES('01050','Huntington','MA','HNTNK',42.313427,-72.903677,'P','T1','2531750','25015','1');
- INSERT INTO "place" VALUES('01050','Knightville','MA','NFTFL',42.283422,-72.866208,'N','U6','2533360','25015','3');
- INSERT INTO "place" VALUES('01050','North Chester','MA','NR0XS',42.323699,-72.927321,'N','U6','2547345','25013','3');
- INSERT INTO "place" VALUES('01050','South Worthington','MA','S0WR0',42.286751,-72.869693,'C','U6','2566000','25015','3');
- INSERT INTO "place" VALUES('01053','Leeds','MA','LTS',42.353838,-72.704385,'P','U4','2534725','25015','1');
- INSERT INTO "place" VALUES('01054','East Leverett','MA','ESTLF',42.439811,-72.480087,'N','U6','2519575','25011','3');
- INSERT INTO "place" VALUES('01054','Leverett','MA','LFRT',42.474681,-72.467543,'P','T1','2535110','25011','1');
- INSERT INTO "place" VALUES('01054','Moores Corner','MA','MRSKR',42.494533,-72.46842,'N','U6','2542740','25011','3');
- INSERT INTO "place" VALUES('01054','North Leverett','MA','NR0LF',42.508421,-72.492587,'N','U6','2548325','25011','3');
- INSERT INTO "place" VALUES('01056','Ludlow','MA','LTL',42.16009,-72.47592,'G','U6','2537175','25013','1');
- INSERT INTO "place" VALUES('01056','Ludlow Center','MA','LTLSN',42.19176,-72.459252,'N','U6','2537280','25013','3');
- INSERT INTO "place" VALUES('01057','Monson','MA','MNSN',42.095323,-72.282063,'P','T1','2542110','25013','1');
- INSERT INTO "place" VALUES('01057','South Monson','MA','S0MNS',42.091761,-72.310636,'N','U6','2564810','25013','3');
- INSERT INTO "place" VALUES('01059','North Amherst','MA','NR0MH',42.369562,-72.63599,'B','U1','2546295','25015','1');
- INSERT INTO "place" VALUES('01060','Bay State','MA','BSTT',42.321488,-72.630588,'C','U4','2504125','25015','3');
- INSERT INTO "place" VALUES('01060','Florence','MA','FLRNS',42.321488,-72.630588,'C','U4','2524050','25015','2');
- INSERT INTO "place" VALUES('01060','Laurel Park','MA','LRLPR',42.358422,-72.641201,'N','U4','2534480','25015','3');
- INSERT INTO "place" VALUES('01060','Northampton','MA','NR0MP',42.321488,-72.630588,'C','C5','2546330','25015','1');
- INSERT INTO "place" VALUES('01060','North Farms','MA','NR0FR',42.321488,-72.630588,'C','U4','2547765','25015','3');
- INSERT INTO "place" VALUES('01060','Pine Grove','MA','PNKRF',42.321488,-72.630588,'C','U4','2553610','25015','3');
- INSERT INTO "place" VALUES('01060','West Farms','MA','WSTFR',42.321488,-72.630588,'C','U4','2575995','25015','3');
- INSERT INTO "place" VALUES('01061','Northampton','MA','NR0MP',42.369562,-72.63599,'B','C5','2546330','25015','1');
- INSERT INTO "place" VALUES('01062','Florence','MA','FLRNS',42.328314,-72.703923,'C','U4','2524050','25015','1');
- INSERT INTO "place" VALUES('01063','Northampton','MA','NR0MP',42.318882,-72.63853,'C','C5','2546330','25015','1');
- INSERT INTO "place" VALUES('01066','North Hatfield','MA','NR0TF',42.406903,-72.655018,'C','U6','2548185','25015','1');
- INSERT INTO "place" VALUES('01068','Oakham','MA','OKHM',42.346144,-72.058847,'P','T1','2550635','25027','1');
- INSERT INTO "place" VALUES('01069','Palmer','MA','PLMR',42.176131,-72.31457,'P','T1','2552070','25013','1');
- INSERT INTO "place" VALUES('01069','Tennyville','MA','TNFL',42.151483,-72.313415,'N','U6','2569345','25013','3');
- INSERT INTO "place" VALUES('01069','West Brimfield','MA','WSTBR',42.187794,-72.308469,'C','U6','2575330','25013','3');
- INSERT INTO "place" VALUES('01070','Plainfield','MA','PLNFL',42.51536,-72.91621,'G','T1','2553995','25015','1');
- INSERT INTO "place" VALUES('01071','Russell','MA','RSL',42.177432,-72.864558,'P','T1','2558615','25013','1');
- INSERT INTO "place" VALUES('01072','Locks Village','MA','LKSFL',42.500088,-72.434253,'N','U6','2536125','25011','3');
- INSERT INTO "place" VALUES('01072','Shutesbury','MA','XTSBR',42.471562,-72.44017,'P','T1','2561870','25011','1');
- INSERT INTO "place" VALUES('01073','Southampton','MA','S0MPT',42.230008,-72.728463,'P','T1','2562710','25015','1');
- INSERT INTO "place" VALUES('01074','South Barre','MA','S0BR',42.38537,-72.09536,'G','U6','2562920','25027','1');
- INSERT INTO "place" VALUES('01075','Moody Corner','MA','MTKRN',42.280647,-72.558699,'N','U6','2542700','25015','3');
- INSERT INTO "place" VALUES('01075','South Hadley','MA','S0TL',42.24984,-72.58152,'P','T1','2564110','25015','1');
- INSERT INTO "place" VALUES('01075','South Hadley Falls','MA','S0TLF',42.216759,-72.599534,'N','U6','2564180','25015','3');
- INSERT INTO "place" VALUES('01077','Congamond','MA','KNKMN',42.01954,-72.769539,'N','U6','2515095','25013','3');
- INSERT INTO "place" VALUES('01077','Gillett Corner','MA','JLTKR',42.025651,-72.785651,'N','U6','2525765','25013','3');
- INSERT INTO "place" VALUES('01077','Southwick','MA','S0WK',42.05482,-72.77037,'G','T1','2565790','25013','1');
- INSERT INTO "place" VALUES('01079','Thorndike','MA','0RNTK',42.192892,-72.329574,'B','U6','2569695','25013','1');
- INSERT INTO "place" VALUES('01080','Three Rivers','MA','0RRFR',42.17781,-72.36887,'G','U1','2569730','25013','1');
- INSERT INTO "place" VALUES('01081','Wales','MA','WLS',42.061948,-72.213598,'P','T1','2572355','25013','1');
- INSERT INTO "place" VALUES('01082','Ware','MA','WR',42.25485,-72.24602,'G','T1','2572845','25015','1');
- INSERT INTO "place" VALUES('01083','Warren','MA','WRN',42.204027,-72.199439,'B','T1','2573055','25027','1');
- INSERT INTO "place" VALUES('01084','West Chesterfield','MA','WSXST',42.390303,-72.870857,'B','U6','2575610','25015','1');
- INSERT INTO "place" VALUES('01085','Little River','MA','LTLRF',42.100094,-72.719537,'N','U4','2535880','25013','3');
- INSERT INTO "place" VALUES('01085','Montgomery','MA','MNTKM',42.206757,-72.805096,'N','U6','2542495','25013','3');
- INSERT INTO "place" VALUES('01085','Mundale','MA','MNTL',42.118426,-72.811207,'N','U4','2543335','25013','3');
- INSERT INTO "place" VALUES('01085','Russellville','MA','RSLFL',42.153503,-72.771602,'C','U6','2558720','25015','3');
- INSERT INTO "place" VALUES('01085','Westfield','MA','WSTFL',42.153503,-72.771602,'C','C5','2576030','25013','1');
- INSERT INTO "place" VALUES('01085','Wyben','MA','BN',42.172314,-72.777317,'N','U4','2582385','25013','3');
- INSERT INTO "place" VALUES('01086','Westfield','MA','WSTFL',42.130446,-72.793967,'C','C5','2576030','25013','1');
- INSERT INTO "place" VALUES('01088','West Hatfield','MA','WS0TF',42.390583,-72.646894,'P','U6','2576485','25015','1');
- INSERT INTO "place" VALUES('01089','Merrick','MA','MRK',42.11676,-72.624534,'N','U6','2540360','25013','3');
- INSERT INTO "place" VALUES('01089','West Springfield','MA','WSTSP',42.125793,-72.645334,'P','X3','2577850','25013','1');
- INSERT INTO "place" VALUES('01090','West Springfield','M…
Large files files are truncated, but you can click here to view the full file