text: /* select '(' + convert(varchar(10),ID) + ",'" + City + "','" + State + "'," + Convert(varchar(20),Lat_N) + "," + + Convert(varchar(20),LONG_W) + "),"  from Station Order by 1 */
  declare @Station Table (ID int, City Varchar(22), State Varchar(2), Lat_N Int, Long_W int)
  insert into @Station Values  (1,'Pfeifer','KS',37,66), (100,'North Monmouth','ME',131,78), (102,'Kirksville','MO',140,144), (104,'Yalaha','FL',120,120), (105,'Weldon','CA',134,119), (106,'Yuma','AZ',111,154), (108,'North Berwick','ME',71,27), 
  (109,'Bridgeport','MI',51,80), (11,'Crescent City','FL',58,118), (110,'Mesick','MI',82,109), (113,'Prescott','IA',40,66), (116,'Mc Henry','MD',93,113), (117,'West Grove','IA',127,99), (119,'Wildie','KY',70,112), (122,'Robertsdale','AL',98,85), 
  (124,'Pine City','MN',119,129), (127,'Oshtemo','MI',100,136), (130,'Hayneville','AL',110,157), (136,'Bass Harbor','ME',138,61), (14,'Forest','MS',120,50), (143,'Renville','MN',142,99), (144,'Eskridge','KS',108,63), (15,'Ducor','CA',141,102), 
  (154,'Baker','CA',31,148), (155,'Casco','MI',139,109), (156,'Heyburn','ID',82,121), (157,'Blue River','KY',117,162), (16,'Beaufort','MO',72,86), (160,'Grosse Pointe','MI',102,91), (161,'Alanson','MI',91,72), (162,'Montgomery City','MO',70,45), 
  (165,'Baileyville','IL',82,61), (166,'Mccomb','MS',74,43), (167,'Equality','AL',107,116), (17,'Fredericktown','MO',106,113), (171,'Springerville','AZ',125,151), (172,'Atlantic Mine','MI',131,99), (174,'Onaway','MI',109,56), (175,'Lydia','LA',42,40), 
  (176,'Grapevine','AR',92,85), (180,'Napoleon','IN',32,160), (181,'Fairview','KS',80,165), (182,'Winter Park','FL',133,33), (183,'Jordan','MN',69,35), (188,'Prairie Du Rocher','IL',76,71), (189,'West Somerset','KY',74,45), (190,'Oconee','GA',93,119), 
  (193,'Corcoran','CA',81,140), (196,'Compton','IL',107,99), (197,'Milledgeville','IL',91,113), (199,'Linden','MI',53,33), (200,'Franklin','LA',82,32), (202,'Hope','MN',140,44), (204,'Alba','MI',92,104), (207,'Olmitz','KS',29,38), (208,'Lottie','LA',110,83), 
  (213,'Calpine','CA',47,43), (215,'Kensett','IA',56,140), (218,'Round Pond','ME',127,124), (223,'Losantville','IN',113,107), (224,'West Hyannisport','MA',59,96), (225,'Garden City','IA',54,120), (226,'Decatur','MS',71,118), (228,'Rydal','GA',36,79), (23,'Honolulu','HI',110,140), 
  (231,'Arispe','IA',31,138), (232,'Grandville','MI',39,70), (233,'Pierre Part','LA',52,90), (234,'Rogers','CT',140,33), (235,'Haubstadt','IN',28,32), (237,'Winchester','ID',38,80), (240,'Saint Paul','KS',66,163), (241,'Woodsboro','MD',77,142), (242,'Macy','IN',139,152), 
  (243,'Hazlehurst','MS',49,109), (246,'Ludington','MI',30,120), (249,'Acme','LA',73,68), (25,'New Century','KS',135,79), (250,'Hampden','MA',76,26), (252,'Childs','MD',93,104), (253,'Winsted','MN',69,73), (255,'Brighton','IL',108,33), (257,'Eureka Springs','AR',72,35), 
  (259,'Baldwin','MD',82,40), (26,'Church Creek','MD',39,91), (260,'Sizerock','KY',116,113), (261,'Fulton','KY',111,52), (263,'Irvington','IL',97,68), (266,'Cahone','CO',116,127), (269,'Jack','AL',50,86), (270,'Shingletown','CA',61,102), (271,'Hillside','CO',99,69), 
  (273,'Rosie','AR',73,162), (278,'Cromwell','MN',129,54), (283,'Clipper Mills','CA',114,57), (286,'Five Points','AL',46,122), (287,'Madisonville','LA',112,53), (288,'Daleville','AL',122,136), (29,'South Carrollton','KY',58,117), (291,'Clarkdale','AZ',58,74), (294,'Orange Park','FL',59,137), 
  (299,'Goodman','MS',101,117), (3,'Hesperia','CA',106,71), (301,'Monona','IA',144,82), (302,'Saint Petersburg','FL',52,120), (303,'Cascade','ID',32,157), (305,'Bennington','KS',94,83), (306,'Bainbridge','GA',62,57), (31,'Novinger','MO',108,112), (311,'South Haven','MN',30,87), 
  (312,'Bentonville','AR',37,78), (315,'Ravenna','KY',79,106), (321,'Bowdon Junction','GA',86,34), (322,'White Horse Beach','MA',54,59), (323,'Barrigada','GU',61,148), (324,'Norwood','MN',144,35), (325,'Monument','KS',71,142), (326,'Rocheport','MO',114,64), (327,'Ridgway','CO',77,110), 
  (328,'Monroe','LA',28,108), (329,'Caseville','MI',103,98), (33,'Saint Elmo','AL',27,51), (331,'Cranks','KY',56,27), (332,'Elm Grove','LA',46,29), (336,'Dumont','MN',57,129), (337,'Mascotte','FL',121,146), (339,'Kirk','CO',141,136), (34,'Mcbrides','MI',74,36), (342,'Chignik Lagoon','AK',103,153), 
  (343,'Mechanic Falls','ME',72,71), (344,'Zachary','LA',61,152), (345,'Yoder','IN',83,144), (35,'Richmond Hill','GA',39,114), (350,'Cannonsburg','MI',91,121), (351,'Fredericksburg','IN',45,78), (352,'Clutier','IA',61,127), (354,'Larkspur','CA',107,66), (355,'Weldona','CO',33,58), (356,'Ludlow','CA',111,88), 
  (357,'Yellville','AR',36,42), (361,'Arrowsmith','IL',28,109), (362,'Magnolia','MS',113,32), (363,'Reasnor','IA',42,163), (364,'Howard Lake','MN',126,78), (365,'Payson','IL',82,92), (366,'Norvell','MI',125,94), (370,'Palm Desert','CA',107,146), (373,'Pawnee','IL',85,81), (375,'Culdesac','ID',48,78), 
  (376,'Gorham','KS',111,65), (377,'Koleen','IN',138,111), (378,'Clio','IA',46,115), (380,'Crane Lake','MN',73,43), (382,'Leavenworth','IN',100,122), (383,'Newbury','MA',128,85), (384,'Amo','IN',104,159), (387,'Ojai','CA',69,119), (389,'Midpines','CA',106,59), (391,'Berryton','KS',61,140), (392,'Delano','CA',126,92), 
  (394,'Centertown','MO',134,93), (396,'Dryden','MI',70,48), (399,'Republic','MI',75,130), (4,'South Britain','CT',66,34), (400,'New Ross','IN',134,121), (401,'Tennessee','IL',55,156), (403,'Zionsville','IN',58,36), (404,'Farmington','IL',92,72), (405,'Susanville','CA',128,80), (406,'Carver','MN',46,122), (409,'Columbus','GA',67,47), (410,'Calhoun','KY',96,57), (411,'Negreet','LA',99,105), (413,'Linthicum Heights','MD',128,68), 
  (414,'Manchester','MD',74,37), (417,'New Liberty','IA',140,95), (419,'Lindsay','MT',143,68), (420,'Frankfort Heights','IL',72,30), (423,'Soldier','KS',77,153), (426,'Millville','CA',33,146), (428,'Randall','KS',48,136), (429,'Lucerne Valley','CA',36,48), (430,'Rumsey','KY',71,50), (433,'Canton','ME',99,106), 
  (435,'Albion','IN',44,122), (436,'West Hills','CA',68,73), (438,'Bowdon','GA',89,78), (439,'Reeves','LA',35,51), (44,'Kismet','KS',100,157), (440,'Grand Terrace','CA',37,127), (441,'Hanna City','IL',51,137), (442,'Elkton','MD',103,157), (444,'Richland','GA',105,113), (446,'Mid Florida','FL',110,51), (447,'Arkadelphia','AR',99,50), 
  (448,'Canton','MN',124,151), (45,'Rives Junction','MI',94,117), (451,'Fort Atkinson','IA',143,141), (453,'Sedgwick','AR',69,75), (455,'Granger','IA',33,102), (457,'Chester','CA',70,124), (459,'Harmony','IN',135,71), (460,'Leakesville','MS',107,73), (464,'Gales Ferry','CT',105,37), (465,'Jerome','AZ',122,34), (467,'Roselawn','IN',88,52), 
  (470,'Healdsburg','CA',111,54), (471,'Cape Girardeau','MO',74,91), (473,'Highwood','IL',27,151), (474,'Grayslake','IL',61,33), (476,'Julian','CA',131,102), (478,'Tipton','IN',34,98), (479,'Cuba','MO',64,88), (482,'Jolon','CA',67,53), (486,'Delta','LA',137,50), (489,'Madden','MS',81,99), (49,'Osborne','KS',70,140), (492,'Regina','KY',132,90), 
  (493,'Groveoak','AL',53,88), (494,'Palatka','FL',95,52), (495,'Upperco','MD',114,30), (497,'Hills','MN',138,135), (498,'Glen Carbon','IL',61,141), (499,'Delavan','MN',33,65), (501,'Tefft','IN',93,150), (502,'Bellevue','KY',127,122), (503,'Northfield','MN',61,37), (504,'Melber','KY',37,56), (505,'Williams','AZ',73,112), 
  (506,'Firebrick','KY',50,95), (510,'Eastlake','MI',134,39), (512,'Garland','ME',109,134), (515,'Waresboro','GA',144,154), (518,'Vulcan','MO',109,92), (519,'Rio Oso','CA',29,106), (520,'Delray Beach','FL',27,159), (521,'Gowrie','IA',130,128), (522,'Harmony','MN',124,126), (524,'Montrose','CA',136,119), (526,'Tarzana','CA',136,81), (527,'Auburn','IA',95,137), 
  (528,'Crouseville','ME',37,82), (53,'Shasta','CA',99,156), (531,'North Middletown','KY',43,142), (536,'Henderson','IA',78,78), (537,'Hagatna','GU',97,152), (538,'Cheswold','DE',32,59), (539,'Montreal','MO',129,127), (540,'Mosca','CO',89,141), (541,'Siloam','GA',105,92), (543,'Lapeer','MI',129,114), (545,'Byron','CA',137,120), 
  (547,'Sandborn','IN',56,94), (55,'Coalgood','KY',57,149), (551,'San Simeon','CA',38,28), (554,'Brownsdale','MN',52,51), (555,'Westphalia','MI',33,144), (557,'Woodbury','GA',103,93), (560,'Osage City','KS',110,90), (566,'Marine On Saint Croix','MN',126,116), (57,'Clifton','AZ',30,136), (570,'Greenview','CA',81,58), (571,'Tyler','MN',133,59), (572,'Athens','IN',75,121), 
  (573,'Alton','MO',80,112), (581,'Carlos','MN',115,66), (582,'Curdsville','KY',85,150), (583,'Channing','MI',117,57), (586,'Ottertail','MN',100,44), (588,'Glencoe','KY',46,136), (59,'Whitewater','MO',83,71), (591,'Baton Rouge','LA',130,72), (593,'Aliso Viejo','CA',68,131), (595,'Grimes','IA',42,75), (596,'Brownstown','IL',49,63), (598,'Middleboro','MA',108,149), 
  (599,'Esmond','IL',76,91), (600,'Shreveport','LA',136,39), (603,'Sandy Hook','CT',72,148), (604,'Forest Lakes','AZ',145,114), (605,'Notasulga','AL',67,116), (606,'Morenci','AZ',105,110), (608,'Busby','MT',104,30), (609,'Marysville','MI',86,133), (61,'Brilliant','AL',86,160), (610,'Archie','MO',40,28), (611,'Richmond','IL',113,163), (612,'Sturdivant','MO',94,86), 
  (613,'East China','MI',109,42), (614,'Benedict','KS',138,96), (615,'Libertytown','MD',145,112), (617,'Sturgis','MS',36,126), (619,'Arlington','CO',75,93), (62,'Monroe','AR',132,150), (621,'Flowood','MS',65,149), (623,'Jackson','AL',111,67), (624,'Knobel','AR',95,62), (625,'Bristol','ME',88,95), (630,'Prince Frederick','MD',105,58), (631,'Urbana','IA',143,29), 
  (633,'Bertha','MN',40,105), (636,'Ukiah','CA',87,90), (637,'Beverly','KY',58,127), (638,'Clovis','CA',92,138), (640,'Walnut','MS',41,77), (642,'Lynnville','KY',25,146), (643,'Wellington','KY',100,32), (644,'Seward','AK',120,36), (646,'Greens Fork','IN',134,135), (647,'Portland','AR',84,45), (649,'Pengilly','MN',25,154), (65,'Buffalo Creek','CO',48,148), (650,'Clancy','MT',46,164), 
  (651,'Clopton','AL',41,85), (654,'Lee','IL',28,51), (656,'Pattonsburg','MO',138,32), (657,'Gridley','KS',118,56), (661,'Payson','AZ',126,154), (662,'Skanee','MI',70,130), (665,'Chelsea','IA',99,60), (666,'West Baden Springs','IN',30,96), (667,'Hawarden','IA',91,47), (668,'Rockton','IL',116,87), (67,'Reeds','MO',31,43), (672,'Lismore','MN',59,104), (673,'Showell','MD',44,164), 
  (675,'Dent','MN',71,137), (677,'Hayesville','IA',120,42), (678,'Bennington','IN',36,27), (679,'Gretna','LA',75,143), (682,'Pheba','MS',91,127), (684,'Mineral Point','MO',91,41), (685,'Anthony','KS',45,161), (69,'Kingsland','AR',78,85), (690,'Ravenden Springs','AR',68,108), (692,'Yellow Pine','ID',83,151), (694,'Ozona','FL',145,121), (695,'Amazonia','MO',46,148), (696,'Chilhowee','MO',80,49), 
  (698,'Albany','CA',50,80), (699,'North Branford','CT',38,95), (70,'Norphlet','AR',144,61), (700,'Pleasant Grove','AR',135,146), (701,'Seaton','IL',128,78), (702,'Everton','MO',119,51), (704,'Climax','MI',127,107), (705,'Hotchkiss','CO',70,72), (706,'Little Rock','AR',122,121), (709,'Nubieber','CA',133,49), (710,'Turners Falls','MA',31,125), (711,'Turner','AR',50,101), (712,'Dundee','IA',62,105), 
  (715,'Hyde Park','MA',65,156), (716,'Schleswig','IA',119,52), (718,'Taft','CA',108,147), (722,'Marion Junction','AL',53,31), (725,'Alpine','AR',117,115), (727,'Winslow','IL',113,39), (728,'Roy','MT',41,52), (731,'Emmett','ID',57,32), (733,'Pelahatchie','MS',39,28), (735,'Wilton','ME',57,157), (738,'Philipsburg','MT',96,72), (739,'Fort Meade','FL',44,35), (740,'Siler','KY',137,117), (741,'Jemison','AL',62,26), 
  (743,'De Tour Village','MI',25,25), (745,'Windom','KS',114,126), (746,'Orange City','IA',94,163), (750,'Neon','KY',102,148), (751,'Agency','MO',59,96), (752,'East Irvine','CA',106,115), (753,'Algonac','MI',119,80), (754,'South Haven','MI',145,53), (755,'Sturgis','MI',117,135), (756,'Garden City','AL',96,105), (757,'Lakeville','CT',60,95), (76,'Pico Rivera','CA',143,117), (766,'Gustine','CA',111,141), (767,'Pomona Park','FL',101,163), 
  (774,'Manchester','IA',130,123), (775,'Eleele','HI',81,153), (777,'Edgewater','MD',130,72), (778,'Pine Bluff','AR',60,146), (779,'Del Mar','CA',59,96), (780,'Cherry','IL',68,47), (781,'Hoffman Estates','IL',129,53), (783,'Strawn','IL',30,51), (784,'Biggsville','IL',86,139), (789,'Hopkinsville','KY',27,48), (791,'Scotts Valley','CA',120,91), (794,'Kissee Mills','MO',140,73), (799,'Corriganville','MD',141,154), (80,'Bridgton','ME',93,140), 
  (801,'Pocahontas','IL',110,83), (804,'Fort Lupton','CO',39,93), (805,'Tamms','IL',60,75), (81,'Cowgill','MO',137,28), (811,'Dorrance','KS',102,122), (813,'Verona','MO',110,153), (814,'Wickliffe','KY',80,46), (815,'Pomona','MO',52,50), (819,'Peaks Island','ME',59,111), (82,'Many','LA',36,95), (820,'Chokio','MN',81,134), (821,'Sanders','AZ',131,97), (824,'Loma Mar','CA',49,131), (825,'Addison','MI',96,142), (826,'Norris','MT',47,37), (827,'Greenville','IL',51,153), 
  (829,'Seward','IL',72,90), (830,'Greenway','AR',119,36), (833,'Hoskinston','KY',66,66), (834,'Bayville','ME',107,143), (836,'Kenner','LA',92,127), (838,'Strasburg','CO',89,48), (839,'Slidell','LA',85,152), (84,'Cobalt','CT',87,27), (841,'Freeport','MI',114,51), (842,'Decatur','MI',63,161), (843,'Talbert','KY',40,59), (844,'Aguanga','CA',80,66), (845,'Tina','MO',132,28), (849,'Harbor Springs','MI',141,149), (851,'Gatewood','MO',76,146), (853,'Coldwater','KS',48,26), 
  (854,'Kirkland','AZ',86,58), (861,'Peabody','KS',75,152), (866,'Haverhill','IA',62,109), (867,'Beaver Island','MI',82,165), (868,'Sherrill','AR',80,152), (871,'Clarkston','MI',94,81), (878,'Rantoul','KS',32,119), (88,'Eros','LA',95,58), (884,'Southport','CT',59,63), (885,'Deerfield','MO',40,36), (886,'Pony','MT',99,163), (888,'Bono','AR',133,150), (889,'Lena','LA',78,130), (890,'Eufaula','AL',140,103), (891,'Humeston','IA',75,122), (892,'Effingham','KS',133,98), 
  (896,'Yazoo City','MS',95,85), (897,'Samantha','AL',75,36), (899,'Fremont','MI',54,151), (901,'Manchester','MN',71,84), (904,'Ermine','KY',120,63), (905,'Newark','IL',73,130), (906,'Hayfork','CA',35,117), (907,'Veedersburg','IN',79,95), (908,'Bullhead City','AZ',95,30), (909,'Carlock','IL',117,85), (910,'Salem','KY',87,114), (914,'Hanscom Afb','MA',129,136), (919,'Knob Lick','KY',136,33), (92,'Watkins','CO',83,97), (920,'Eustis','FL',43,39), (921,'Lee Center','IL',96,77), 
  (922,'Kell','IL',70,59), (923,'Union Star','MO',79,133), (927,'Quinter','KS',60,25), (928,'Coaling','AL',144,52), (93,'Dale','IN',70,34), (938,'Andersonville','GA',141,73), (940,'Paron','AR',59,104), (941,'Allerton','IA',62,113), (944,'Ledyard','CT',135,144), (946,'Newton Center','MA',48,145), (948,'Lupton','MI',140,53), (949,'Norway','ME',84,88), (95,'Dupo','IL',41,29), (950,'Peachtree City','GA',80,156), (953,'Udall','KS',113,60), (955,'Netawaka','KS',109,120), 
  (957,'South El Monte','CA',74,80), (959,'Waipahu','HI',106,34), (96,'Raymondville','MO',71,148), (960,'Deep River','IA',75,39), (963,'Eriline','KY',94,65), (965,'Griffin','GA',39,152), (968,'Norris City','IL',54,76), (969,'Dixie','GA',27,36), (970,'East Haddam','CT',116,132), (971,'Graettinger','IA',95,150), (973,'Andover','CT',52,53), (975,'Panther Burn','MS',117,165), (977,'Odin','IL',53,116), (98,'Hackleburg','AL',120,121), (981,'Lakota','IA',56,92), (982,'Holbrook','AZ',135,104), 
  (983,'Patriot','IN',83,46), (985,'Winslow','AR',126,126), (987,'Hartland','MI',136,108), (988,'Mullan','ID',143,155), (99,'Woodstock Valley','CT',117,163), (990,'Bison','KS',132,75), (994,'Kanorado','KS',65,86), (996,'Keyes','CA',77,86), (998,'Oakfield','ME',48,132)
  
  select City, State from @Station;
  