GiveToken / GiftBox

Repository for Sizzle
0 stars 0 forks source link

city name truncated at 16 characters #1040

Closed wogsland closed 8 years ago

wogsland commented 8 years ago
SELECT length(`name`), `name` FROM giftbox.city 
where length(`name`) = 20
wogsland commented 8 years ago

update city set name = 'Aberdeen Proving Ground, MD' WHERE id = 9576; update city set name = 'Crestline Heights, AL' WHERE id = 152; update city set name = 'Valhermoso Spring, AL' WHERE id = 277; update city set name = 'Tuskegee Institute, AL' WHERE id = 360; update city set name = 'Saint George Island, AK' WHERE id = 619; update city set name = 'Saint Paul Island, AK' WHERE id = 660; update city set name = 'Manley Hot Spring, AK' WHERE id = 718; update city set name = 'Eleven Mile Corner, AZ' WHERE id = 770; update city set name = 'Arizona Boys Ranch, AZ' WHERE id = 780; update city set name = 'Yuma Proving Ground, AZ' WHERE id = 823; update city set name = 'Kykotsmovi Village, AZ' WHERE id = 894; update city set name = 'Hot Springs Village, AR' WHERE id = 1038; update city set name = 'North Little Rock, AR' WHERE id = 1148; update city set name = 'Camp Joseph T Robinson, AR' WHERE id = 1150; update city set name = 'East Rancho Dominguez, CA' WHERE id = 1516; update city set name = 'Pacific Palisades, CA' WHERE id = 1530; update city set name = 'Palos Verdes Estates, CA' WHERE id = 1531; update city set name = 'Rancho Palos Verdes, CA' WHERE id = 1559; update city set name = 'Cardiff By The Sea, CA' WHERE id = 1671; update city set name = 'Desert Hot Spring, CA' WHERE id = 1711; update city set name = 'Spring Valley Lake, CA' WHERE id = 1770; update city set name = 'Gilman Hot Springs, CA' WHERE id = 1791; update city set name = 'Rancho Santa Margarita, CA' WHERE id = 1823; update city set name = 'Santa Ana Heights, CA' WHERE id = 1826; update city set name = 'El Toro Marine Corps Air Station, CA' WHERE id = 1828; update city set name = 'California Hot Springs, CA' WHERE id = 1855; update city set name = 'Lemoore Naval Air Station, CA' WHERE id = 1877; update city set name = 'California Valley, CA' WHERE id = 1929; update city set name = 'Bear Valley Springs, CA' WHERE id = 1966; update city set name = 'Kings Canyon National Park, CA' WHERE id = 1989; update city set name = 'South San Francisco, CA' WHERE id = 2058; update city set name = 'Coast Guard Island, CA' WHERE id = 2067; update city set name = 'Point Reyes Station, CA' WHERE id = 2149; update city set name = 'Univ Of The Pacific, CA' WHERE id = 2187; update city set name = 'Peninsula Village, CA' WHERE id = 2576; update city set name = 'Cherry Hills Village, CO' WHERE id = 2600; update city set name = 'Greenwood Village, CO' WHERE id = 2606; update city set name = 'Steamboat Springs, CO' WHERE id = 2654; update city set name = 'United States Air Force Academy, CO' WHERE id = 2756; update city set name = 'South Glastonbury, CT' WHERE id = 2954; update city set name = 'North Grosvenordale, CT' WHERE id = 2991; update city set name = 'New Preston Marble, CT' WHERE id = 3107; update city set name = 'Green Cove Spring, FL' WHERE id = 3197; update city set name = 'Ponte Vedra Beach, FL' WHERE id = 3214; update city set name = 'Jacksonville Beach, FL' WHERE id = 3254; update city set name = 'Saint George Island, FL' WHERE id = 3264; update city set name = 'Panama City Beach, FL' WHERE id = 3279; update city set name = 'De Funiak Springs, FL' WHERE id = 3291;

wogsland commented 8 years ago

update city set name = 'Fort Walton Beach, FL' WHERE id = 3317; update city set name = 'Altamonte Springs, FL' WHERE id = 3375; update city set name = 'Naval Training Center, FL' WHERE id = 3418; update city set name = 'Kennedy Space Center, FL' WHERE id = 3419; update city set name = 'Melbourne Village, FL' WHERE id = 3426; update city set name = 'Indian Harbor Beach, FL' WHERE id = 3434; update city set name = 'Indian River Shores, FL' WHERE id = 3441; update city set name = 'Homestead Air Force Base, FL' WHERE id = 3454; update city set name = 'Naval Air Station, FL' WHERE id = 3455; update city set name = 'North Coral Springs, FL' WHERE id = 3465; update city set name = 'North Bay Village, FL' WHERE id = 3471; update city set name = 'North Miami Beach, FL' WHERE id = 3477; update city set name = 'Palm Beach Gardens, FL' WHERE id = 3496; update city set name = 'Ridge Manor Estates, FL' WHERE id = 3540; update city set name = 'Howey In The Hill, FL' WHERE id = 3651; update city set name = 'Buena Ventura Lakes, FL' WHERE id = 3654; update city set name = 'Saint Simons Island, GA' WHERE id = 4084; update city set name = 'Marine Corps Logistics Base, GA' WHERE id = 4139; update city set name = 'Georgia Southwestern State University, GA' WHERE id = 4141; update city set name = 'Pine Mountain Valley, GA' WHERE id = 4222; update city set name = 'Arlington Heights, IL' WHERE id = 4540; update city set name = 'Elk Grove Village, IL' WHERE id = 4541; update city set name = 'Lake In The Hills, IL' WHERE id = 4600; update city set name = 'Country Club Hills, IL' WHERE id = 4717; update city set name = 'Saint Francisville, IL' WHERE id = 5417; update city set name = 'Frankfort Heights, IL' WHERE id = 5569; update city set name = 'Fort Benjamin Harrison, IN' WHERE id = 5777; update city set name = 'Grissom Air Force Base, IN' WHERE id = 5946; update city set name = 'Ball State University, IN' WHERE id = 6059; update city set name = 'West Baden Springs, IN' WHERE id = 6131; update city set name = 'Crane Naval Depot, IN' WHERE id = 6143; update city set name = 'North Terre Haute, IN' WHERE id = 6213;

wogsland commented 8 years ago

update city set name = 'North Buena Vista, IA' WHERE id = 6923; update city set name = 'Columbus Junction, IA' WHERE id = 7153; update city set name = 'Lake Of The Forest, KS' WHERE id = 7184; update city set name = 'Industrial Airport, KS' WHERE id = 7198; update city set name = 'Pleasure Ridge Park, KY' WHERE id = 7924; update city set name = 'Mammoth Cave National Park, KY' WHERE id = 8478; update city set name = 'Saint Martinville, LA' WHERE id = 8754; update city set name = 'French Settlement, LA' WHERE id = 8803; update city set name = 'Greenwell Springs, LA' WHERE id = 8807; update city set name = 'Cumberland Center, ME' WHERE id = 9058; update city set name = 'Old Orchard Beach, ME' WHERE id = 9084; update city set name = 'Cumberland Forest, ME' WHERE id = 9114; update city set name = 'Greenville Junction, ME' WHERE id = 9209; update city set name = 'North New Portland, ME' WHERE id = 9421; update city set name = 'Annapolis Junction, MD' WHERE id = 9499; update city set name = 'Fort George G Meade, MD' WHERE id = 9525; update city set name = 'Cockeysville Hunt, MD' WHERE id = 9586; update city set name = 'Linthicum Heights, MD' WHERE id = 9614;

wogsland commented 8 years ago

update city set name = 'Village Of Nagog Woods, MA' WHERE id = 9987; update city set name = 'Newton Upper Falls, MA' WHERE id = 10118; update city set name = 'Padanaram Village, MA' WHERE id = 10216; update city set name = 'Saint Clair Shore, MI' WHERE id = 10270; update city set name = 'Commerce Township, MI' WHERE id = 10355; update city set name = 'University Center, MI' WHERE id = 10460; update city set name = 'Sault Sainte Marie, MI' WHERE id = 10903; update city set name = 'Cedar East Bethel, MN' WHERE id = 11006; update city set name = 'Inver Grove Heights, MN' WHERE id = 11054; update city set name = 'International Falls, MN' WHERE id = 11742; update city set name = 'Thief River Falls, MN' WHERE id = 11776; update city set name = 'Greenwood Springs, MS' WHERE id = 11907; update city set name = 'Portage Des Sioux, MO' WHERE id = 12260; update city set name = 'Lake Forest Estates, MO' WHERE id = 12374; update city set name = 'Excelsior Springs, MO' WHERE id = 12484; update city set name = 'North Kansas City, MO' WHERE id = 12521; update city set name = 'Burlington Junction, MO' WHERE id = 12538; update city set name = 'Conception Junction, MO' WHERE id = 12544; update city set name = 'El Dorado Springs, MO' WHERE id = 12677; update city set name = 'Fort Leonard Wood, MO' WHERE id = 12883; update city set name = 'Brookline Station, MO' WHERE id = 12935; update city set name = 'East Glacier Park, MT' WHERE id = 13215; update city set name = 'White Sulphur Springs, MT' WHERE id = 13283; update city set name = 'West Chesterfield, NH' WHERE id = 14068; update city set name = 'Center Tuftonboro, NH' WHERE id = 14124; update city set name = 'Gilmanton Iron Works, NH' WHERE id = 14137;

wogsland commented 8 years ago

update city set name = 'Upper Saddle River, NJ' WHERE id = 14281; update city set name = 'Hasbrouck Heights, NJ' WHERE id = 14296; update city set name = 'Atlantic Highlands, NJ' WHERE id = 14336; update city set name = 'Cape May Court House, NJ' WHERE id = 14509; update city set name = 'Princeton University, NJ' WHERE id = 14574; update city set name = 'Princeton Junction, NJ' WHERE id = 14575; update city set name = 'Monmouth Junction, NJ' WHERE id = 14642; update city set name = 'South Bound Brook, NJ' WHERE id = 14656; update city set name = 'Whitehouse Station, NJ' WHERE id = 14661; update city set name = 'Santo Domingo Pueblo, NM' WHERE id = 14700;

wogsland commented 8 years ago

update city set name = 'Continental Divide, NM' WHERE id = 14714; update city set name = 'Truth Or Consequences, NM' WHERE id = 14806; update city set name = 'White Sands Missile Range, NM' WHERE id = 14818; update city set name = 'Holloman Air Force Base, NM' WHERE id = 14879; update city set name = 'East White Plains, NY' WHERE id = 14980; update city set name = 'Hastings On Hudson, NY' WHERE id = 14982; update city set name = 'Brooklyn Navy Yard, NY' WHERE id = 15050; update city set name = 'Springfield Gardens, NY' WHERE id = 15069; update city set name = 'Cold Spring Harbor, NY' WHERE id = 15136; update city set name = 'South Farmingdale, NY' WHERE id = 15145; update city set name = 'Port Jefferson Station, NY' WHERE id = 15171; update city set name = 'Shelter Island Heights, NY' WHERE id = 15218; update city set name = 'Westhampton Beach, NY' WHERE id = 15224; update city set name = 'Castleton On Hudson, NY' WHERE id = 15244; update city set name = 'Rotterdam Junction, NY' WHERE id = 15314; update city set name = 'Cornwall On Hudson, NY' WHERE id = 15434; update city set name = 'Hopewell Junction, NY' WHERE id = 15444; update city set name = 'White Sulphur Springs, NY' WHERE id = 15529; update city set name = 'South Glens Falls, NY' WHERE id = 15536; update city set name = 'Blue Mountain Lake, NY' WHERE id = 15540; update city set name = 'Greenfield Center, NY' WHERE id = 15555; update city set name = 'Upper Saint Regis, NY' WHERE id = 15620; update city set name = 'Saint Regis Falls, NY' WHERE id = 15645; update city set name = 'Richfield Springs, NY' WHERE id = 15817; update city set name = 'Springfield Center, NY' WHERE id = 15828; update city set name = 'Sanitaria Springs, NY' WHERE id = 15970; update city set name = 'Farmersville Station, NY' WHERE id = 16026; update city set name = 'Slaterville Springs, NY' WHERE id = 16278; update city set name = 'Research Triangle Park, NC' WHERE id = 16445; update city set name = 'Lewiston Woodville, NC' WHERE id = 16481; update city set name = 'East Fayetteville, NC' WHERE id = 16626; update city set name = 'Boiling Spring Lakes, NC' WHERE id = 16719; update city set name = 'Wrightsville Beach, NC' WHERE id = 16732; update city set name = 'Pine Knoll Shores, NC' WHERE id = 16737; update city set name = 'Connellys Springs, NC' WHERE id = 16792;

wogsland commented 8 years ago

update city set name = 'Warren Wilson College, NC' WHERE id = 16901; update city set name = 'South Bloomingvi, OH' WHERE id = 17382; update city set name = 'Isle Saint George, OH' WHERE id = 17445; update city set name = 'Saint Clairsville, OH' WHERE id = 17586; update city set name = 'Cleveland Heights, OH' WHERE id = 17652; update city set name = 'Lyndhurst Mayfield, OH' WHERE id = 17656; update city set name = 'Broadview Heights, OH' WHERE id = 17675; update city set name = 'Mount Hood Parkdale, OR' WHERE id = 18707; update city set name = 'Black Butte Ranch, OR' WHERE id = 18952; update city set name = 'Crooked River Ranch, OR' WHERE id = 18953; update city set name = 'Upper Saint Clair, PA' WHERE id = 19140; update city set name = 'South Connellsville, PA' WHERE id = 19191; update city set name = 'Westmoreland City, PA' WHERE id = 19305; update city set name = 'Cambridge Springs, PA' WHERE id = 19530; update city set name = 'Pennsylvania Furnace, PA' WHERE id = 19655; update city set name = 'Columbia Cross Roads, PA' WHERE id = 19669; update city set name = 'Middlebury Center, PA' WHERE id = 19684; update city set name = 'Carlisle Barracks, PA' WHERE id = 19705; update city set name = 'Mount Holly Springs, PA' WHERE id = 19747; update city set name = 'Blue Ridge Summit, PA' WHERE id = 19775; update city set name = 'South Williamsport, PA' WHERE id = 19894; update city set name = 'Mount Pleasant Mills, PA' WHERE id = 19948; update city set name = 'Delaware Water Gap, PA' WHERE id = 20064; update city set name = 'College Misericordia, PA' WHERE id = 20141; update city set name = 'Huntingdon Valley, PA' WHERE id = 20244; update city set name = 'Feasterville Trevose, PA' WHERE id = 20275;

wogsland commented 8 years ago

update city set name = 'Lincoln University, PA' WHERE id = 20319; update city set name = 'West Conshohocken, PA' WHERE id = 20336; update city set name = 'Wood River Junction, RI' WHERE id = 20433; update city set name = 'South Of The Border, SC' WHERE id = 20615; update city set name = 'Cherry Grove Beach, SC' WHERE id = 20636; update city set name = 'Hilton Head Island, SC' WHERE id = 20744; update city set name = 'Wessington Springs, SD' WHERE id = 20941; update city set name = 'Cumberland Furnace, TN' WHERE id = 21166; update city set name = 'Castalian Springs, TN' WHERE id = 21153; update city set name = 'Red Boiling Springs, TN' WHERE id = 21215; update city set name = 'Thompsons Station, TN' WHERE id = 21226; update city set name = 'Beersheba Springs, TN' WHERE id = 21244; update city set name = 'Washington College, TN' WHERE id = 21334; update city set name = 'Strawberry Plains, TN' WHERE id = 21421; update city set name = 'Kimberlin Heights, TN' WHERE id = 21440; update city set name = 'Bloomington Springs, TN' WHERE id = 21607; update city set name = 'East Texas Center, TX' WHERE id = 21828; update city set name = 'North Richland Hills, TX' WHERE id = 21952; update city set name = 'Clear Lake Shores, TX' WHERE id = 22314; update city set name = 'Sutherland Springs, TX' WHERE id = 22464;

wogsland commented 8 years ago

update city set name = 'Kingsville Naval Air Station, TX' WHERE id = 22497; update city set name = 'South Padre Island, TX' WHERE id = 22551; update city set name = 'Big Bend National Park, TX' WHERE id = 22864; update city set name = 'Hill Air Force Base, UT' WHERE id = 22920; update city set name = 'White River Junction, VT' WHERE id = 23061; update city set name = 'Bridgewater Corner, VT' WHERE id = 23065; update city set name = 'North Springfield, VT' WHERE id = 23110; update city set name = 'South Londonderry, VT' WHERE id = 23115; update city set name = 'Manchester Center, VT' WHERE id = 23123; update city set name = 'Montgomery Center, VT' WHERE id = 23173; update city set name = 'Middletown Springs, VT' WHERE id = 23238; update city set name = 'Leicester Junction, VT' WHERE id = 23257; update city set name = 'Craftsbury Common, VT' WHERE id = 23265; update city set name = 'Baileys Crossroads, VA' WHERE id = 23323; update city set name = 'North Springfield, VA' WHERE id = 23353; update city set name = 'Rappahannock Academy, VA' WHERE id = 23403; update city set name = 'Saint Davids Church, VA' WHERE id = 23436; update city set name = 'Shenandoah Caverns, VA' WHERE id = 23497; update city set name = 'Amelia Court House, VA' WHERE id = 23536; update city set name = 'King And Queen Court House, VA' WHERE id = 23579; update city set name = 'Blackwater Bridge, VA' WHERE id = 23676; update city set name = 'Naval Amphibious Base Little Creek, VA' WHERE id = 23681; update city set name = 'Natural Bridge Station, VA' WHERE id = 24005; update city set name = 'Mountlake Terrace, WA' WHERE id = 24059; update city set name = 'Bainbridge Island, WA' WHERE id = 24070;

wogsland commented 8 years ago

update city set name = 'Puget Sound Naval Shipyard, WA' WHERE id = 24124; update city set name = 'South Park Village, WA' WHERE id = 24152; update city set name = 'Fairchild Air Force Base, WA' WHERE id = 24330; update city set name = 'Minnehaha Springs, WV' WHERE id = 24495; update city set name = 'Williams Mountain, WV' WHERE id = 24587; update city set name = 'Shenandoah Junction, WV' WHERE id = 24669; update city set name = 'Green Sulphur Springs, WV' WHERE id = 24788; update city set name = 'North Parkersburg, WV' WHERE id = 24821;

wogsland commented 8 years ago

update city set name = 'Keslers Cross Lanes, WV' WHERE id = 25020; update city set name = 'Saint Croix Falls, WI' WHERE id = 25350; update city set name = 'Washington Island, WI' WHERE id = 25430; update city set name = 'Black River Falls, WI' WHERE id = 25557; update city set name = 'North Woods Beach, WI' WHERE id = 25675; update city set name = 'North Fond Du Lac, WI' WHERE id = 25719;