Schedule of Changes to Florida newkeys
/* LIVE OAK */
if year = 1987 and FSCSKEY = 'FL0006' then newkey = 'FL0007';
/* SEMINOLE LIBRARY */
/* This one is a arguable but I think they are the same. */
if year = 1987 and FSCSKEY = 'FL0076' then newkey = 'FL0006';
/* PENSACOLA */
if year = 1987 and FSCSKEY = 'FL0007' then newkey = 'FL0008';
/* GAINESVILLE */
if year = 1987 and FSCSKEY = 'FL0008' then newkey = 'FL0009';
/* MACCLENNY */
if year = 1987 and FSCSKEY = 'FL0009' then newkey = 'FL9975';
/* PLANTATION */
if year = 1987 and FSCSKEY = 'FL0014' then newkey = 'FL0116';
/* GREEN COVE SPRING */
if year = 1987 and FSCSKEY = 'FL0018' then newkey = 'FL0019';
/* NAPLES */
if year = 1987 and FSCSKEY = 'FL0019' then newkey = 'FL0020';
/* LAKE CITY */
if year = 1987 and FSCSKEY = 'FL0020' then newkey = 'FL0021';
/* MIAMI SHORES */
if year = 1987 and FSCSKEY = 'FL0021' then newkey = 'FL0022';
/* HIALEAH */
if year = 1987 and FSCSKEY = 'FL0022' then newkey = 'FL0023';
/* NORTH MIAMI BEACH */
if year = 1987 and FSCSKEY = 'FL0023' then newkey = 'FL0024';
/* MIAMI */
if year = 1987 and FSCSKEY = 'FL0024' then newkey = 'FL0025';
/* SURFSIDE */
if year = 1987 and FSCSKEY = 'FL0025' then newkey = 'FL0026';
/* ARCADIA */
if year = 1987 and FSCSKEY = 'FL0026' then newkey = 'FL0027';
/* PALM COAST */
if year = 1987 and FSCSKEY = 'FL0027' then newkey = 'FL0029';
/* APALACHICOLA */
if year = 1987 and FSCSKEY = 'FL0028' then newkey = 'FL8002';
if year = 1989 and FSCSKEY = 'FL0105' then newkey = 'FL8002';
if year = 1990 and FSCSKEY = 'FL0105' then newkey = 'FL8002';
if year = 1991 and FSCSKEY = 'FL0105' then newkey = 'FL8002';
if year = 1992 and FSCSKEY = 'FL0105' then newkey = 'FL8002';
if year = 1993 and FSCSKEY = 'FL0105' then newkey = 'FL8002';
/* QUINCY */
if year = 1987 and FSCSKEY = 'FL0029' then newkey = 'FL0030';
/* WAUCHULA */
if year = 1987 and FSCSKEY = 'FL0030' then newkey = 'FL0031';
/* CLEWISTON */
if year = 1987 and FSCSKEY = 'FL0031' then newkey = 'FL0032';
/* HERNANDO */
if year = 1987 and FSCSKEY = 'FL0032' then newkey = 'FL0106';
if year = 1988 and FSCSKEY = 'FL0033' then newkey = 'FL0106';
/* SEBRING */
/* After 1996, is Sebring FL0150? I don't think so from the data */
if year = 1987 and FSCSKEY = 'FL0035' then newkey = 'FL0034';
/* LAKE PLACID */
if year = 1987 and FSCSKEY = 'FL0034' then newkey = 'FL9976';
/* TAMPA */
if year = 1987 and FSCSKEY = 'FL0036' then newkey = 'FL0035';
/* VERO BEACH */
if year = 1987 and FSCSKEY = 'FL0037' then newkey = 'FL0036';
/* MARIANNA */
/* WHAT ABOUT FL0136?*/
if year = 1987 and FSCSKEY = 'FL0038' then newkey = 'FL0037';
/* MONTICELLO */
if year = 1987 and FSCSKEY = 'FL0039' then newkey = 'FL0038';
/* TAVARES */
if year = 1987 and FSCSKEY = 'FL0040' then newkey = 'FL0039';
/* LEESBURG */
if year = 1987 and FSCSKEY = 'FL0041' then newkey = 'FL0040';
/* FORT MEYERS BEACH */
if year = 1987 and FSCSKEY = 'FL0042' then newkey = 'FL0041';
/* FORT MEYERS (LEE COUNTY) */
if year = 1987 and FSCSKEY = 'FL0043' then newkey = 'FL0042';
/* SANIBEL */
if year = 1987 and FSCSKEY = 'FL0044' then newkey = 'FL0043';
/* TALLAHASSEE */
if year = 1987 and FSCSKEY = 'FL0045' then newkey = 'FL0044';
/* BRADENTON BEACH */
if year = 1987 and FSCSKEY = 'FL0046' then newkey = 'FL0045';
/* BRADENTON (MANATEE COUNTY) */
if year = 1987 and FSCSKEY = 'FL0047' then newkey = 'FL0046';
/* STUART */
if year = 1987 and FSCSKEY = 'FL0048' then newkey = 'FL0047';
/* KEY WEST */
if year = 1987 and FSCSKEY = 'FL0049' then newkey = 'FL0048';
/* FORT WALTON BEACH */
if year = 1987 and FSCSKEY = 'FL0050' then newkey = 'FL0049';
/* MARY ESTHER */
if year = 1987 and FSCSKEY = 'FL0051' then newkey = 'FL0050';
/* VALPARAISO */
if year = 1987 and FSCSKEY = 'FL0052' then newkey = 'FL0051';
/* OKEECHOBEE */
if year = 1987 and FSCSKEY = 'FL0053' then newkey = 'FL0052';
/* MAITLAND */
if year = 1987 and FSCSKEY = 'FL0054' then newkey = 'FL0053';
/* WINTER PARK */
if year = 1987 and FSCSKEY = 'FL0055' then newkey = 'FL0054';
/* BOYNTON BEACH */
if year = 1987 and FSCSKEY = 'FL0056' then newkey = 'FL0055';
/* WEST PALM BEACH (PL) */
if year = 1987 and FSCSKEY = 'FL0061' then newkey = 'FL0062';
/* PAHOKEE */
if year = 1987 and FSCSKEY = 'FL0062' then newkey = 'FL0063';
/* NEW PORT RICHEY (NEW PORT RICHEY PL) */
if year = 1987 and FSCSKEY = 'FL0063' then newkey = 'FL0064';
/* [NEW] PORT RICHEY (PASCO COUNTY) */
if year = 1987 and FSCSKEY = 'FL0064' then newkey = 'FL0065';
/* ZEPHYRHILLS */
if year = 1987 and FSCSKEY = 'FL0065' then newkey = 'FL0066';
/* CLEARWATER */
/* FL0127? */
if year = 1987 and FSCSKEY = 'FL0066' then newkey = 'FL0067';
/* DUNEDIN */
if year = 1987 and FSCSKEY = 'FL0067' then newkey = 'FL0068';
/* MADEIRA BEACH */
if year = 1987 and FSCSKEY = 'FL0068' then newkey = 'FL0069';
/* GULF PORT */
if year = 1987 and FSCSKEY = 'FL0069' then newkey = 'FL0070';
/* LARGO */
if year = 1987 and FSCSKEY = 'FL0070' then newkey = 'FL0071';
/* OLDSMAR */
if year = 1987 and FSCSKEY = 'FL0071' then newkey = 'FL0073';
/* PINELLAS PARK */
/* FL0127? */
if year = 1987 and FSCSKEY = 'FL0072' then newkey = 'FL0074';
/* ST. PETERSBURG */
if year = 1987 and FSCSKEY = 'FL0073' then newkey = 'FL0075';
/* ST. PETERSBURG BEACH */
if year = 1987 and FSCSKEY = 'FL0074' then newkey = 'FL0076';
/* SAFETY HARBOR */
if year = 1987 and FSCSKEY = 'FL0075' then newkey = 'FL0077';
/* TARPON SPRINGS */
if year = 1987 and FSCSKEY = 'FL0077' then newkey = 'FL0079';
/* AUBURNDALE */
if year = 1987 and FSCSKEY = 'FL0078' then newkey = 'FL0080';
/* BARTOW */
if year = 1987 and FSCSKEY = 'FL0079' then newkey = 'FL0081';
/* FORT MEADE */
if year = 1987 and FSCSKEY = 'FL0080' then newkey = 'FL0082';
/* HAINES CITY */
if year = 1987 and FSCSKEY = 'FL0081' then newkey = 'FL0083';
/* LAKE ALFRED */
if year = 1987 and FSCSKEY = 'FL0082' then newkey = 'FL0084';
/* LAKE WALES */
if year = 1987 and FSCSKEY = 'FL0083' then newkey = 'FL0085';
/* LAKELAND */
if year = 1987 and FSCSKEY = 'FL0084' then newkey = 'FL0086';
/* FROSTPROOF */
if year = 1987 and FSCSKEY = 'FL0085' then newkey = 'FL0087';
/* WINTER HAVEN */
if year = 1987 and FSCSKEY = 'FL0086' then newkey = 'FL0089';
/* PALATKA */
if year = 1987 and FSCSKEY = 'FL0087' then newkey = 'FL0090';
/* ST. AUGUSTINE */
if year = 1987 and FSCSKEY = 'FL0088' then newkey = 'FL0091';
/* FORT PIERCE */
if year = 1987 and FSCSKEY = 'FL0089' then newkey = 'FL0092';
/* SARASOTA */
if year = 1987 and FSCSKEY = 'FL0090' then newkey = 'FL0093';
/* ALTAMONTE SPRINGS */
if year = 1987 and FSCSKEY = 'FL0091' then newkey = 'FL0094';
/* SANFORD */
if year = 1987 and FSCSKEY = 'FL0092' then newkey = 'FL0095';
/* WILDWOOD */
if year = 1987 and FSCSKEY = 'FL0093' then newkey = 'FL0096';
/* LAKE PANASOFFKEE */
if year = 1987 and FSCSKEY = 'FL0094' then newkey = 'FL0097';
/* PERRY */
if year = 1987 and FSCSKEY = 'FL0095' then newkey = 'FL0098';
/* DAYTONA BEACH */
if year = 1987 and FSCSKEY = 'FL0096' then newkey = 'FL0099';
/* CRAWFORDVILLE */
if year = 1987 and FSCSKEY = 'FL0097' then newkey = 'FL0100';
/* DEFUNIAK SPRINGS */
if year = 1987 and FSCSKEY = 'FL0098' then newkey = 'FL0101';
/*-------------------2009----------------------------------------------------*
/* PLANTATION */
if year = 1987 and FSCSKEY = 'FL0014' then newkey = 'FL0257';
if year = 1987 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 1988 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 1989 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 1990 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 1991 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 1992 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 1993 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 1994 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 1995 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 1996 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 1997 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 1998 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 1999 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 2000 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 2001 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 2002 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 2003 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 2004 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 2005 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 2006 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 2007 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
if year = 2008 and FSCSKEY = 'FL0116' then newkey = 'FL0257';
/* PORT CHARLOTTE */
if year = 1987 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 1988 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 1989 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 1990 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 1991 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 1992 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 1993 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 1994 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 1995 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 1996 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 1997 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 1998 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 1999 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 2000 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 2001 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 2002 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 2003 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 2004 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 2005 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 2006 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 2007 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
if year = 2008 and FSCSKEY = 'FL0002' then newkey = 'FL0258';
December 16, 2022