I'm going straight to the task; I start with the following list of Florida counties:
counties = Dataset[{<|"County" -> "ALACHUA"|>, <|"County" -> "BAKER"|>, <|
"County" -> "BAY"|>, <|"County" -> "BRADFORD"|>, <|
"County" -> "BREVARD"|>, <|"County" -> "BROWARD"|>, <|
"County" -> "CALHOUN"|>, <|"County" -> "CHARLOTTE"|>, <|
"County" -> "CITRUS"|>, <|"County" -> "CLAY"|>, <|
"County" -> "COLLIER"|>, <|"County" -> "COLUMBIA"|>, <|
"County" -> "DESOTO"|>, <|"County" -> "DIXIE"|>, <|
"County" -> "DUVAL"|>, <|"County" -> "ESCAMBIA"|>, <|
"County" -> "FLAGLER"|>, <|"County" -> "FRANKLIN"|>, <|
"County" -> "GADSDEN"|>, <|"County" -> "GILCHRIST"|>, <|
"County" -> "GLADES"|>, <|"County" -> "GULF"|>, <|
"County" -> "HAMILTON"|>, <|"County" -> "HARDEE"|>, <|
"County" -> "HENDRY"|>, <|"County" -> "HERNANDO"|>, <|
"County" -> "HIGHLANDS"|>, <|"County" -> "HILLBOUROUGH"|>, <|
"County" -> "HOLMES"|>, <|"County" -> "INDIANRIVER"|>, <|
"County" -> "JACKSON"|>, <|"County" -> "JEFFERSON"|>, <|
"County" -> "LAFAYETTE"|>, <|"County" -> "LAKE"|>, <|
"County" -> "LEE"|>, <|"County" -> "LEON"|>, <|
"County" -> "LEVY"|>, <|"County" -> "LIBERTY"|>, <|
"County" -> "MADISON"|>, <|"County" -> "MANATEE"|>, <|
"County" -> "MARION"|>, <|"County" -> "MARTIN"|>, <|
"County" -> "MIAMI-DADE"|>, <|"County" -> "MONROE"|>, <|
"County" -> "NASSAU"|>, <|"County" -> "OKALOOSA"|>, <|
"County" -> "OKEECHOBEE"|>, <|"County" -> "ORANGE"|>, <|
"County" -> "OSCEOLA"|>, <|"County" -> "PALMBEACH"|>, <|
"County" -> "PASCO"|>, <|"County" -> "PINELLAS"|>, <|
"County" -> "POLK"|>, <|"County" -> "PUTNAM"|>, <|
"County" -> "SANTAROSA"|>, <|"County" -> "SARASOTA"|>, <|
"County" -> "SEMINOLE"|>, <|"County" -> "SAINTJOHNS"|>, <|
"County" -> "SAINTLUCIE"|>, <|"County" -> "SUMTER"|>, <|
"County" -> "SUWANNEE"|>, <|"County" -> "TAYLOR"|>, <|
"County" -> "UNION"|>, <|"County" -> "VOLUSIA"|>, <|
"County" -> "WAKULLA"|>, <|"County" -> "WALTON"|>, <|
"County" -> "WASHINGTON"|>}]
Next; is a list of adjacent counties corresponding to each of the above 67 counties. For example : ALACHUA county have the following adjacent counties: BRADFORD, COLUMBIA, GILCHRIST, LEVY, MARION, PUTNAM and UNION.
adjacentcounties =
Dataset[{<|"County" -> "ALACHUA",
"AdjacentCounty" -> {"BRADFORD", "COLUMBIA", "GILCHRIST", "LEVY",
"MARION", "PUTNAM", "UNION"}|>, <|"County" -> "BAKER",
"AdjacentCounty" -> {"BRADFORD", "CLAY", "COLUMBIA", "DUVAL",
"NASSAU", "UNION"}|>, <|"County" -> "BAY",
"AdjacentCounty" -> {"CALHOUN", "GULF", "JACKSON", "WALTON",
"WASHINGTON"}|>, <|"County" -> "BRADFORD",
"AdjacentCounty" -> {"ALACHUA", "BAKER", "CLAY", "PUTNAM",
"UNION"}|>, <|"County" -> "BREVARD",
"AdjacentCounty" -> {"INDIANRIVER", "ORANGE", "OSCEOLA",
"SEMINOLE", "VOLUSIA"}|>, <|"County" -> "BROWARD",
"AdjacentCounty" -> {"COLLIER", "HENDRY", "MIAMI-DADE",
"PALMBEACH"}|>, <|"County" -> "CALHOUN",
"AdjacentCounty" -> {"BAY", "GADSDEN", "GULF", "JACKSON",
"LIBERTY"}|>, <|"County" -> "CHARLOTTE",
"AdjacentCounty" -> {"DESOTO", "GLADES", "HENDRY", "HIGHLANDS",
"LEE", "SARASOTA"}|>, <|"County" -> "CITRUS",
"AdjacentCounty" -> {"HERNANDO", "LEVY", "MARION", "SUMTER"}|>, <|
"County" -> "CLAY",
"AdjacentCounty" -> {"BAKER", "BRADFORD", "DUVAL", "PUTNAM",
"SAINTJOHNS"}|>, <|"County" -> "COLLIER",
"AdjacentCounty" -> {"BROWARD", "HENDRY", "LEE", "MIAMI-DADE",
"MONROE"}|>, <|"County" -> "COLUMBIA",
"AdjacentCounty" -> {"ALACHUA", "BAKER", "GILCHRIST", "HAMILTON",
"SUWANNEE", "UNION"}|>, <|"County" -> "DESOTO",
"AdjacentCounty" -> {"CHARLOTTE", "GLADES", "HARDEE", "HIGHLANDS",
"MANATEE", "SARASOTA"}|>, <|"County" -> "DIXIE",
"AdjacentCounty" -> {"GILCHRIST", "LAFAYETTE", "LEVY",
"TAYLOR"}|>, <|"County" -> "DUVAL",
"AdjacentCounty" -> {"BAKER", "CLAY", "NASSAU", "SAINTJOHNS"}|>, <|
"County" -> "ESCAMBIA", "AdjacentCounty" -> {"SANTAROSA"}|>, <|
"County" -> "FLAGLER",
"AdjacentCounty" -> {"PUTNAM", "SAINTJOHNS", "VOLUSIA"}|>, <|
"County" -> "FRANKLIN",
"AdjacentCounty" -> {"GULF", "LIBERTY", "WAKULLA"}|>, <|
"County" -> "GADSDEN",
"AdjacentCounty" -> {"CALHOUN", "JACKSON", "LEON", "LIBERTY"}|>, <|
"County" -> "GILCHRIST",
"AdjacentCounty" -> {"ALACHUA", "COLUMBIA", "DIXIE", "LAFAYETTE",
"LEVY", "SUWANNEE"}|>, <|"County" -> "GLADES",
"AdjacentCounty" -> {"CHARLOTTE", "DESOTO", "HENDRY", "HIGHLANDS",
"LEE", "MARTIN", "OKEECHOBEE", "PALMBEACH"}|>, <|
"County" -> "GULF",
"AdjacentCounty" -> {"BAY", "CALHOUN", "FRANKLIN", "LIBERTY"}|>, <|
"County" -> "HAMILTON",
"AdjacentCounty" -> {"COLUMBIA", "MADISON", "SUWANNEE"}|>, <|
"County" -> "HARDEE",
"AdjacentCounty" -> {"DESOTO", "HIGHLANDS", "HILLSBOROUGH",
"MANATEE", "POLK"}|>, <|"County" -> "HENDRY",
"AdjacentCounty" -> {"BROWARD", "CHARLOTTE", "COLLIER", "GLADES",
"LEE", "MARTIN", "OKEECHOBEE", "PALMBEACH"}|>, <|
"County" -> "HERNANDO",
"AdjacentCounty" -> {"CITRUS", "PASCO", "SUMTER"}|>, <|
"County" -> "HIGHLANDS",
"AdjacentCounty" -> {"CHARLOTTE", "DESOTO", "GLADES", "HARDEE",
"OKEECHOBEE", "OSCEOLA", "POLK"}|>, <|
"County" -> "HILLSBOROUGH",
"AdjacentCounty" -> {"HARDEE", "MANATEE", "PASCO", "PINELLAS",
"POLK"}|>, <|"County" -> "HOLMES",
"AdjacentCounty" -> {"JACKSON", "WALTON", "WASHINGTON"}|>, <|
"County" -> "INDIANRIVER",
"AdjacentCounty" -> {"BREVARD", "OKEECHOBEE", "OSCEOLA",
"SAINTLUCIE"}|>, <|"County" -> "JACKSON",
"AdjacentCounty" -> {"BAY", "CALHOUN", "GADSDEN", "HOLMES",
"LIBERTY", "WASHINGTON"}|>, <|"County" -> "JEFFERSON",
"AdjacentCounty" -> {"LEON", "MADISON", "TAYLOR", "WAKULLA"}|>, <|
"County" -> "LAFAYETTE",
"AdjacentCounty" -> {"DIXIE", "GILCHRIST", "MADISON", "SUWANNEE",
"TAYLOR"}|>, <|"County" -> "LAKE",
"AdjacentCounty" -> {"MARION", "ORANGE", "OSCEOLA", "POLK",
"SEMINOLE", "SUMTER", "VOLUSIA"}|>, <|"County" -> "LEE",
"AdjacentCounty" -> {"CHARLOTTE", "COLLIER", "GLADES",
"HENDRY"}|>, <|"County" -> "LEON",
"AdjacentCounty" -> {"GADSDEN", "JEFFERSON", "LIBERTY",
"WAKULLA"}|>, <|"County" -> "LEVY",
"AdjacentCounty" -> {"ALACHUA", "CITRUS", "DIXIE", "GILCHRIST",
"MARION"}|>, <|"County" -> "LIBERTY",
"AdjacentCounty" -> {"CALHOUN", "FRANKLIN", "GADSDEN", "GULF",
"JACKSON", "LEON", "WAKULLA"}|>, <|"County" -> "MADISON",
"AdjacentCounty" -> {"HAMILTON", "JEFFERSON", "LAFAYETTE",
"SUWANNEE", "TAYLOR"}|>, <|"County" -> "MANATEE",
"AdjacentCounty" -> {"DESOTO", "HARDEE", "HILLSBOROUGH", "POLK",
"SARASOTA"}|>, <|"County" -> "MARION",
"AdjacentCounty" -> {"ALACHUA", "CITRUS", "LAKE", "LEVY",
"PUTNAM", "SUMTER", "VOLUSIA"}|>, <|"County" -> "MARTIN",
"AdjacentCounty" -> {"GLADES", "HENDRY", "OKEECHOBEE",
"PALMBEACH", "SAINTLUCIE"}|>, <|"County" -> "MIAMI-DADE",
"AdjacentCounty" -> {"BROWARD", "COLLIER", "MONROE"}|>, <|
"County" -> "MONROE",
"AdjacentCounty" -> {"COLLIER", "MIAMI-DADE"}|>, <|
"County" -> "NASSAU", "AdjacentCounty" -> {"BAKER", "DUVAL"}|>, <|
"County" -> "OKALOOSA",
"AdjacentCounty" -> {"SANTAROSA", "WALTON"}|>, <|
"County" -> "OKEECHOBEE",
"AdjacentCounty" -> {"GLADES", "HENDRY", "HIGHLANDS",
"INDIANRIVER", "MARTIN", "OSCEOLA", "PALMBEACH", "POLK",
"SAINTLUCIE"}|>, <|"County" -> "ORANGE",
"AdjacentCounty" -> {"BREVARD", "LAKE", "OSCEOLA", "POLK",
"SEMINOLE", "VOLUSIA"}|>, <|"County" -> "OSCEOLA",
"AdjacentCounty" -> {"BREVARD", "HIGHLANDS", "INDIANRIVER",
"LAKE", "OKEECHOBEE", "ORANGE", "POLK"}|>, <|
"County" -> "PALMBEACH",
"AdjacentCounty" -> {"BROWARD", "GLADES", "HENDRY", "MARTIN",
"OKEECHOBEE"}|>, <|"County" -> "PASCO",
"AdjacentCounty" -> {"HERNANDO", "HILLSBOROUGH", "PINELLAS",
"POLK", "SUMTER"}|>, <|"County" -> "PINELLAS",
"AdjacentCounty" -> {"HILLSBOROUGH", "PASCO"}|>, <|
"County" -> "POLK",
"AdjacentCounty" -> {"HARDEE", "HIGHLANDS", "HILLSBOROUGH",
"LAKE", "MANATEE", "OKEECHOBEE", "ORANGE", "OSCEOLA", "PASCO",
"SUMTER"}|>, <|"County" -> "PUTNAM",
"AdjacentCounty" -> {"ALACHUA", "BRADFORD", "CLAY", "FLAGLER",
"MARION", "SAINTJOHNS", "VOLUSIA"}|>, <|"County" -> "SANTAROSA",
"AdjacentCounty" -> {"ESCAMBIA", "OKALOOSA"}|>, <|
"County" -> "SARASOTA",
"AdjacentCounty" -> {"CHARLOTTE", "DESOTO", "MANATEE"}|>, <|
"County" -> "SEMINOLE",
"AdjacentCounty" -> {"BREVARD", "LAKE", "ORANGE", "VOLUSIA"}|>, <|
"County" -> "SAINTJOHNS",
"AdjacentCounty" -> {"CLAY", "DUVAL", "FLAGLER", "PUTNAM"}|>, <|
"County" -> "SAINTLUCIE",
"AdjacentCounty" -> {"INDIANRIVER", "MARTIN", "OKEECHOBEE"}|>, <|
"County" -> "SUMTER",
"AdjacentCounty" -> {"CITRUS", "HERNANDO", "LAKE", "MARION",
"PASCO", "POLK"}|>, <|"County" -> "SUWANNEE",
"AdjacentCounty" -> {"COLUMBIA", "GILCHRIST", "HAMILTON",
"LAFAYETTE", "MADISON"}|>, <|"County" -> "TAYLOR",
"AdjacentCounty" -> {"DIXIE", "JEFFERSON", "LAFAYETTE",
"MADISON"}|>, <|"County" -> "UNION",
"AdjacentCounty" -> {"ALACHUA", "BAKER", "BRADFORD",
"COLUMBIA"}|>, <|"County" -> "VOLUSIA",
"AdjacentCounty" -> {"BREVARD", "FLAGLER", "LAKE", "MARION",
"ORANGE", "PUTNAM", "SEMINOLE"}|>, <|"County" -> "WAKULLA",
"AdjacentCounty" -> {"FRANKLIN", "JEFFERSON", "LEON", "LEVY",
"LIBERTY"}|>, <|"County" -> "WALTON",
"AdjacentCounty" -> {"BAY", "HOLMES", "OKALOOSA",
"WASHINGTON"}|>, <|"County" -> "WASHINGTON",
"AdjacentCounty" -> {"BAY", "HOLMES", "JACKSON", "WALTON"}|>}]
Then we have a list of cities corresponding to each adjacent county.
The names of the counties are completely capitalized to distinguish their name from those belonging to cities. For example; ALACHUA is a county and Alachua is a city :
cities = Dataset[{<|"AdjacentCounty" -> "ALACHUA",
"City" -> {"Alachua", "Archer", "Gainesville", "Hawthorne",
"Newberry", "Waldo"}|>, <|"AdjacentCounty" -> "BAKER",
"City" -> {"Macclenny"}|>, <|"AdjacentCounty" -> "BAY",
"City" -> {"Callaway", "LynnHaven", "MexicoBeach", "PanamaCity",
"PanamaCityBeach", "Parker", "Springfield"}|>, <|
"AdjacentCounty" -> "BRADFORD",
"City" -> {"Brooker", "Hampton", "Lawtey", "Starke"}|>, <|
"AdjacentCounty" -> "BREVARD",
"City" -> {"CapeCanaveral", "Cocoa", "CocoaBeach",
"IndianHarbourBeach", "Melbourne", "PalmBay", "Rockledge",
"SatelliteBeach", "Titusville", "WestMelbourne"}|>, <|
"AdjacentCounty" -> "BROWARD",
"City" -> {"CoconutCreek", "CooperCity", "CoralSprings",
"DaniaBeach", "DeerfieldBeach", "FortLauderdale",
"HallandaleBeach", "Hollywood", "LauderdaleLakes", "Lauderhill",
"LighthousePoint", "Margate", "Miramar", "NorthLauderdale",
"OaklandPark", "Parkland", "PembrokePines", "Plantation",
"PompanoBeach", "Sunrise", "Tamarac", "WestPark", "Weston",
"WiltonManors"}|>, <|"AdjacentCounty" -> "CALHOUN",
"City" -> {"Blountstown"}|>, <|"AdjacentCounty" -> "CHARLOTTE",
"City" -> {"PuntaGorda"}|>, <|"AdjacentCounty" -> "CITRUS",
"City" -> {"CrystalRiver", "Inverness"}|>, <|
"AdjacentCounty" -> "CLAY",
"City" -> {"GreenCoveSprings", "KeystoneHeights"}|>, <|
"AdjacentCounty" -> "COLLIER",
"City" -> {"Everglades", "MarcoIsland", "Naples"}|>, <|
"AdjacentCounty" -> "COLUMBIA", "City" -> {"LakeCity"}|>, <|
"AdjacentCounty" -> "DESOTO", "City" -> {"Arcadia"}|>, <|
"AdjacentCounty" -> "DIXIE",
"City" -> {"No city is associated with this county."}|>, <|
"AdjacentCounty" -> "DUVAL",
"City" -> {"AtlanticBeach", "Jacksonville", "JacksonvilleBeach",
"NeptuneBeach"}|>, <|"AdjacentCounty" -> "ESCAMBIA",
"City" -> {"Pensacola"}|>, <|"AdjacentCounty" -> "FLAGLER",
"City" -> {"Bunnell", "FlaglerBeach", "PalmCoast"}|>, <|
"AdjacentCounty" -> "FRANKLIN",
"City" -> {"Apalachicola", "Carrabelle"}|>, <|
"AdjacentCounty" -> "GADSDEN",
"City" -> {"Chattahoochee", "Gretna", "Midway", "Quincy"}|>, <|
"AdjacentCounty" -> "GILCHRIST",
"City" -> {"FanningSprings", "Trenton"}|>, <|
"AdjacentCounty" -> "GLADES", "City" -> {"MooreHaven"}|>, <|
"AdjacentCounty" -> "GULF",
"City" -> {"PortSaintJoe", "Wewahitchka"}|>, <|
"AdjacentCounty" -> "HAMILTON", "City" -> {"Jasper"}|>, <|
"AdjacentCounty" -> "HARDEE",
"City" -> {"BowlingGreen", "Wauchula"}|>, <|
"AdjacentCounty" -> "HENDRY",
"City" -> {"Clewiston", "LaBelle"}|>, <|
"AdjacentCounty" -> "HERNANDO",
"City" -> {"Brooksville", "WeekiWachee"}|>, <|
"AdjacentCounty" -> "HIGHLANDS",
"City" -> {"AvonPark", "Sebring"}|>, <|
"AdjacentCounty" -> "HILLSBOROUGH",
"City" -> {"PlantCity", "Tampa", "TempleTerrace"}|>, <|
"AdjacentCounty" -> "HOLMES", "City" -> {"Bonifay"}|>, <|
"AdjacentCounty" -> "INDIANRIVER",
"City" -> {"Fellsmere", "Sebastian", "VeroBeach"}|>, <|
"AdjacentCounty" -> "JACKSON",
"City" -> {"Graceville", "Greenwood", "JacobCity",
"Marianna"}|>, <|"AdjacentCounty" -> "JEFFERSON",
"City" -> {"Monticello"}|>, <|"AdjacentCounty" -> "LAFAYETTE",
"City" -> {"No city is associated with this county."}|>, <|
"AdjacentCounty" -> "LAKE",
"City" -> {"Clermont", "Eustis", "FruitlandPark", "Groveland",
"Leesburg", "Mascotte", "Minneola", "MountDora", "Tavares",
"Umatilla"}|>, <|"AdjacentCounty" -> "LEE",
"City" -> {"BonitaSprings", "CapeCoral", "FortMyers",
"FortMyersBeach", "Sanibel"}|>, <|"AdjacentCounty" -> "LEON",
"City" -> {"Tallahassee"}|>, <|"AdjacentCounty" -> "LEVY",
"City" -> {"CedarKey", "Chiefland", "FanningSprings",
"Willinston"}|>, <|"AdjacentCounty" -> "LIBERTY",
"City" -> {"Bristol"}|>, <|"AdjacentCounty" -> "MADISON",
"City" -> {"Madison"}|>, <|"AdjacentCounty" -> "MANATEE",
"City" -> {"AnnaMaria", "Bradenton", "BradentonBeach",
"HolmesBeach", "Palmetto"}|>, <|"AdjacentCounty" -> "MARION",
"City" -> {"Belleview", "Dunnellon", "Ocala"}|>, <|
"AdjacentCounty" -> "MARTIN", "City" -> {"Stuart"}|>, <|
"AdjacentCounty" -> "MIAMI-DADE",
"City" -> {"Aventura", "CoralGables", "Doral", "FloridaCity",
"Hialeath", "HialeathGardens", "Homestead", "Miami",
"MiamiBeach", "MiamiGardens", "MiamiSprings", "NorthBayVillage",
"NorthMiami", "NorthMiamiBeach", "Opa-locka", "SouthMiami",
"SunnyIslesBeach", "Sweetwater", "WestMiami"}|>, <|
"AdjacentCounty" -> "MONROE",
"City" -> {"KeyColonyBeach", "KeyWest", "Layton", "Marathon"}|>, <|
"AdjacentCounty" -> "NASSAU", "City" -> {"FernandinaBeach"}|>, <|
"AdjacentCounty" -> "OKALOOSA",
"City" -> {"Crestview", "Destin", "FortWaltonBeach", "LaurelHill",
"MaryEsther", "Niceville", "Valparaiso"}|>, <|
"AdjacentCounty" -> "OKEECHOBEE", "City" -> {"Okeechobee"}|>, <|
"AdjacentCounty" -> "ORANGE",
"City" -> {"Apopka", "BayLee", "BelleIsle", "Edgewood",
"LakeBuenaVista", "Maitland", "Ocoe", "Orlando", "WinterGarden",
"WinterPark"}|>, <|"AdjacentCounty" -> "OSCEOLA",
"City" -> {"Kissimmee", "SaintCloud"}|>, <|
"AdjacentCounty" -> "PALMBEACH",
"City" -> {"Atlantis", "BelleGlade", "BocaRaton", "BoyntonBeach",
"DelrayBeach", "Greenacres", "LakeWorth", "Pahokee",
"PalmBeachGardens", "RivieraBeach", "SouthBay", "WestPalmBeach",
"Westlake"}|>, <|"AdjacentCounty" -> "PASCO",
"City" -> {"DadeCity", "NewPortRichey", "PortRichey",
"SanAntonio", "Zephyrhills"}|>, <|
"AdjacentCounty" -> "PINELLAS",
"City" -> {"BelleairBeach", "BelleairBluffs", "Clearwater",
"Dunellin", "Gulfport", "IndianRocksBeach", "Largo",
"MadeiraBeach", "Oldsmar", "PinellasPark", "SafetyHarbor",
"SaintPetersburg", "Seminole", "SouthPasadena", "TarponSprings",
"TreasureIsland"}|>, <|"AdjacentCounty" -> "POLK",
"City" -> {"Auburndale", "Bartow", "Davenport", "EagleLake",
"FortMeade", "Frostproof", "HainesCity", "LakeAlfred",
"LakeWales", "Lakeland", "Mulberry", "WinterHaven"}|>, <|
"AdjacentCounty" -> "PUTNAM",
"City" -> {"CrescentCity", "Palatka"}|>, <|
"AdjacentCounty" -> "SAINTJOHNS",
"City" -> {"SaintAugustine", "SaintAugustineBeach"}|>, <|
"AdjacentCounty" -> "SAINTLUCIE",
"City" -> {"FortPierce", "PortSaintLucie"}|>, <|
"AdjacentCounty" -> "SANTAROSA",
"City" -> {"GulfBreeze", "Milton"}|>, <|
"AdjacentCounty" -> "SARASOTA",
"City" -> {"NorthPort", "Sarasota", "Venice"}|>, <|
"AdjacentCounty" -> "SEMINOLE",
"City" -> {"AltamonteSprings", "Casselberry", "LakeMary",
"Longwood", "Oviedo", "Sanford", "WinterSprings"}|>, <|
"AdjacentCounty" -> "SUMTER",
"City" -> {"Bushnell", "CenterHill", "Coleman", "Webster",
"Wildwood"}|>, <|"AdjacentCounty" -> "SUWANNEE",
"City" -> {"LiveOak"}|>, <|"AdjacentCounty" -> "TAYLOR",
"City" -> {"Perry"}|>, <|"AdjacentCounty" -> "UNION",
"City" -> {"LakeButler"}|>, <|"AdjacentCounty" -> "VOLUSIA",
"City" -> {"DaytonaBeach", "DayonaBeachShores", "DeLand",
"Edgewater", "FlaglerBeach", "HollyHill", "LakeHellen",
"NewSmyrnaBeach", "OakHill", "OrangeCity", "OrmondBeach",
"PortOrange", "SouthDaytona"}|>, <|
"AdjacentCounty" -> "WAKULLA",
"City" -> {"SaintMark", "Sopchoppy"}|>, <|
"AdjacentCounty" -> "WALTON",
"City" -> {"DeFuniakSprings", "Freeport"}|>, <|
"AdjacentCounty" -> "WASHINGTON",
"City" -> {"Chipley", "Vernon"}|>}]
My goal is to build the following structured data set table. The table starts like this :
Dataset[{
<|"County" -> "ALACHUA", "Adjacent_County" -> "BRADFORD",
"City" -> "Brooker"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "BRADFORD",
"City" -> "Hampton"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "BRADFORD",
"City" -> "Lawtey"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "BRADFORD",
"City" -> "Starke"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "COLUMBIA",
"City" -> "LakeCity"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "GILCHRIST",
"City" -> "FanningSprings"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "GILCHRIST",
"City" -> "Trenton"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "LEVY",
"City" -> "CedarKey"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "LEVY",
"City" -> "Chiefland"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "LEVY",
"City" -> "FanningSprings"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "LEVY",
"City" -> "Williston"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "MARION",
"City" -> "Belleview"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "MARION",
"City" -> "Dunnellon"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "MARION",
"City" -> "Ocala"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "PUTNAM",
"City" -> "CrescentCity"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "PUTNAM",
"City" -> "Palatka"|>,
<|"County" -> "ALACHUA", "Adjacent_County" -> "UNION",
"City" -> "LakeButler"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "BRADFORD",
"City" -> "Brooker"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "BRADFORD",
"City" -> "Hampton"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "BRADFORD",
"City" -> "Lawtey"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "BRADFORD",
"City" -> "Starke"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "CLAY",
"City" -> "GereenCoveSprings"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "CLAY",
"City" -> "KeyStoneHeights"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "COLUMBIA",
"City" -> "LakeCity"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "DUVAL",
"City" -> "AtlanticBeach"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "DUVAL",
"City" -> "Jacksonville"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "DUVAL",
"City" -> "JacksonvilleBeach"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "DUVAL",
"City" -> "NeptuneBeach"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "NASSAU",
"City" -> "FernandinaBeach"|>,
<|"County" -> "BAKER", "Adjacent_County" -> "UNION",
"City" -> "LakeButler"|>}]
etcetera... The table ends like this:
Dataset[{
<|"County" -> "WASHINGTON", "Adjacent_County" -> "BAY",
"City" -> "Callaway"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "BAY",
"City" -> "LynnHaven"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "BAY",
"City" -> "MexicoBeach"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "BAY",
"City" -> "PanamaCity"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "BAY",
"City" -> "PanamaCityBeach"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "BAY",
"City" -> "Parker"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "BAY",
"City" -> "Springfield"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "HOLMES",
"City" -> "Bonifay"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "JACKSON",
"City" -> "Graceville"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "JACKSON",
"City" -> "Greenwood"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "JACKSON",
"City" -> "JacobCity"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "JACKSON",
"City" -> "Marianna"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "WALTON",
"City" -> "DeFuniakSprings"|>,
<|"County" -> "WASHINGTON", "Adjacent_County" -> "WALTON",
"City" -> "Freeport"|>}]
I have used several commands; for example :
JoinAcross[counties, adjacentcounties, cities, "city", "Inner"]
but, none of them give me the desired table. Thank you for your help!