Hi team, I’m working to map all the Florida counties with a filled map, but all the counties are not displaying in QS,
Please see the above SS, all the counties are not displaying.
My SQL :
SELECT ‘Alachua County’ AS county, ‘FL’ AS state, ‘Alachua County, FL’ AS county_state, 3 AS region_num, ‘B’ AS letter
UNION ALL SELECT ‘Baker County’, ‘FL’, ‘Baker County, FL’, 4, ‘B’
UNION ALL SELECT ‘Bay County’, ‘FL’, ‘Bay County, FL’, 2, ‘A’
UNION ALL SELECT ‘Bradford County’, ‘FL’, ‘Bradford County, FL’, 3, ‘B’
UNION ALL SELECT ‘Brevard County’, ‘FL’, ‘Brevard County, FL’, 7, ‘E’
UNION ALL SELECT ‘Broward County’, ‘FL’, ‘Broward County, FL’, 10, ‘H’
UNION ALL SELECT ‘Calhoun County’, ‘FL’, ‘Calhoun County, FL’, 2, ‘A’
UNION ALL SELECT ‘Charlotte County’, ‘FL’, ‘Charlotte County, FL’, 8, ‘F’
UNION ALL SELECT ‘Citrus County’, ‘FL’, ‘Citrus County, FL’, 3, ‘B’
UNION ALL SELECT ‘Clay County’, ‘FL’, ‘Clay County, FL’, 4, ‘B’
UNION ALL SELECT ‘Collier County’, ‘FL’, ‘Collier County, FL’, 8, ‘F’
UNION ALL SELECT ‘Columbia County’, ‘FL’, ‘Columbia County, FL’, 3, ‘B’
UNION ALL SELECT ‘DeSoto County’, ‘FL’, ‘DeSoto County, FL’, 8, ‘F’
UNION ALL SELECT ‘Dixie County’, ‘FL’, ‘Dixie County, FL’, 3, ‘B’
UNION ALL SELECT ‘Duval County’, ‘FL’, ‘Duval County, FL’, 4, ‘B’
UNION ALL SELECT ‘Escambia County’, ‘FL’, ‘Escambia County, FL’, 1, ‘A’
UNION ALL SELECT ‘Flagler County’, ‘FL’, ‘Flagler County, FL’, 4, ‘B’
UNION ALL SELECT ‘Franklin County’, ‘FL’, ‘Franklin County, FL’, 2, ‘A’
UNION ALL SELECT ‘Gadsden County’, ‘FL’, ‘Gadsden County, FL’, 2, ‘A’
UNION ALL SELECT ‘Gilchrist County’, ‘FL’, ‘Gilchrist County, FL’, 3, ‘B’
UNION ALL SELECT ‘Glades County’, ‘FL’, ‘Glades County, FL’, 8, ‘F’
UNION ALL SELECT ‘Gulf County’, ‘FL’, ‘Gulf County, FL’, 2, ‘A’
UNION ALL SELECT ‘Hamilton County’, ‘FL’, ‘Hamilton County, FL’, 3, ‘B’
UNION ALL SELECT ‘Hardee County’, ‘FL’, ‘Hardee County, FL’, 6, ‘D’
UNION ALL SELECT ‘Hendry County’, ‘FL’, ‘Hendry County, FL’, 8, ‘F’
UNION ALL SELECT ‘Hernando County’, ‘FL’, ‘Hernando County, FL’, 3, ‘B’
UNION ALL SELECT ‘Highlands County’, ‘FL’, ‘Highlands County, FL’, 6, ‘D’
UNION ALL SELECT ‘Hillsborough County’, ‘FL’, ‘Hillsborough County, FL’, 6, ‘D’
UNION ALL SELECT ‘Holmes County’, ‘FL’, ‘Holmes County, FL’, 2, ‘A’
UNION ALL SELECT ‘Indian River County’, ‘FL’, ‘Indian River County, FL’, 9, ‘G’
UNION ALL SELECT ‘Jackson County’, ‘FL’, ‘Jackson County, FL’, 2, ‘A’
UNION ALL SELECT ‘Jefferson County’, ‘FL’, ‘Jefferson County, FL’, 2, ‘A’
UNION ALL SELECT ‘Lafayette County’, ‘FL’, ‘Lafayette County, FL’, 3, ‘B’
UNION ALL SELECT ‘Lake County’, ‘FL’, ‘Lake County, FL’, 3, ‘B’
UNION ALL SELECT ‘Lee County’, ‘FL’, ‘Lee County, FL’, 8, ‘F’
UNION ALL SELECT ‘Leon County’, ‘FL’, ‘Leon County, FL’, 2, ‘A’
UNION ALL SELECT ‘Levy County’, ‘FL’, ‘Levy County, FL’, 3, ‘B’
UNION ALL SELECT ‘Liberty County’, ‘FL’, ‘Liberty County, FL’, 2, ‘A’
UNION ALL SELECT ‘Madison County’, ‘FL’, ‘Madison County, FL’, 2, ‘A’
UNION ALL SELECT ‘Manatee County’, ‘FL’, ‘Manatee County, FL’, 6, ‘D’
UNION ALL SELECT ‘Marion County’, ‘FL’, ‘Marion County, FL’, 3, ‘B’
UNION ALL SELECT ‘Martin County’, ‘FL’, ‘Martin County, FL’, 9, ‘G’
UNION ALL SELECT ‘Miami-Dade County’, ‘FL’, ‘Miami-Dade County, FL’, 11, ‘I’
UNION ALL SELECT ‘Monroe County’, ‘FL’, ‘Monroe County, FL’, 11, ‘I’
UNION ALL SELECT ‘Nassau County’, ‘FL’, ‘Nassau County, FL’, 4, ‘B’
UNION ALL SELECT ‘Okaloosa County’, ‘FL’, ‘Okaloosa County, FL’, 1, ‘A’
UNION ALL SELECT ‘Okeechobee County’, ‘FL’, ‘Okeechobee County, FL’, 9, ‘G’
UNION ALL SELECT ‘Orange County’, ‘FL’, ‘Orange County, FL’, 7, ‘E’
UNION ALL SELECT ‘Osceola County’, ‘FL’, ‘Osceola County, FL’, 7, ‘E’
UNION ALL SELECT ‘Palm Beach County’, ‘FL’, ‘Palm Beach County, FL’, 9, ‘G’
UNION ALL SELECT ‘Pasco County’, ‘FL’, ‘Pasco County, FL’, 5, ‘C’
UNION ALL SELECT ‘Pinellas County’, ‘FL’, ‘Pinellas County, FL’, 5, ‘C’
UNION ALL SELECT ‘Polk County’, ‘FL’, ‘Polk County, FL’, 6, ‘D’
UNION ALL SELECT ‘Putnam County’, ‘FL’, ‘Putnam County, FL’, 3, ‘B’
UNION ALL SELECT ‘Santa Rosa County’, ‘FL’, ‘Santa Rosa County, FL’, 1, ‘A’
UNION ALL SELECT ‘Sarasota County’, ‘FL’, ‘Sarasota County, FL’, 8, ‘F’
UNION ALL SELECT ‘Seminole County’, ‘FL’, ‘Seminole County, FL’, 7, ‘E’
UNION ALL SELECT ‘St. Johns County’, ‘FL’, ‘St. Johns County, FL’, 4, ‘B’
UNION ALL SELECT ‘St. Lucie County’, ‘FL’, ‘St. Lucie County, FL’, 9, ‘G’
UNION ALL SELECT ‘Sumter County’, ‘FL’, ‘Sumter County, FL’, 3, ‘B’
UNION ALL SELECT ‘Suwannee County’, ‘FL’, ‘Suwannee County, FL’, 3, ‘B’
UNION ALL SELECT ‘Taylor County’, ‘FL’, ‘Taylor County, FL’, 2, ‘A’ – fixed here
UNION ALL SELECT ‘Union County’, ‘FL’, ‘Union County, FL’, 3, ‘B’
UNION ALL SELECT ‘Volusia County’, ‘FL’, ‘Volusia County, FL’, 4, ‘B’
UNION ALL SELECT ‘Wakulla County’, ‘FL’, ‘Wakulla County, FL’, 2, ‘A’
UNION ALL SELECT ‘Walton County’, ‘FL’, ‘Walton County, FL’, 1, ‘A’
UNION ALL SELECT ‘Washington County’, ‘FL’, ‘Washington County, FL’, 2, ‘A’;