Question: How long is the US border with the country sharing a border with the state where Some Like It Hot was filmed?

full_context: Document 1: American Horror Story: Hotel: According to creators Brad Falchuk and Ryan Murphy, thematically, Hotel is much darker than previous seasons. Inspiration came from old hotel horror films and actual hotels situated in downtown Los Angeles with a reputation for sinister events, including the Cecil. The cycle also marks a return to filming in Los Angeles, where the first two seasons were shot. Hotel features one of the most expansive sets in American Horror Story history, with production designer Mark Worthington building two stories on a soundstage, along with a working elevator and stairway. In July 2015, FX launched a marketing campaign for the series, with most trailers and teasers touting Gaga's involvement.
Document 2: Mexico: Mexico (Spanish: México [ˈmexiko] (listen); Nahuatl languages: Mēxihco), officially the United Mexican States (Spanish: Estados Unidos Mexicanos [esˈtaðos uˈniðoz mexiˈkanos] (listen)), is a country in the southern portion of North America. It is bordered to the north by the United States; to the south and west by the Pacific Ocean; to the southeast by Guatemala, Belize, and the Caribbean Sea; and to the east by the Gulf of Mexico. Covering almost 2,000,000 square kilometers (770,000 sq mi), the nation is the fifth largest country in the Americas by total area and the 13th largest independent state in the world. With an estimated population of over 120 million people, the country is the tenth most populous state and the most populous Spanish-speaking state in the world, while being the second most populous nation in Latin America after Brazil. Mexico is a federation comprising 31 states and Mexico City, a special federal entity that is also the capital city and its most populous city. Other metropolises in the state include Guadalajara, Monterrey, Puebla, Toluca, Tijuana and León.
Document 3: Texas: Texas (/ ˈtɛksəs /, locally / ˈtɛksəz /; Spanish: Texas or Tejas, pronounced (ˈtexas)) is the second largest state in the United States by both area and population. Geographically located in the South Central region of the country, Texas shares borders with the U.S. states of Louisiana to the east, Arkansas to the northeast, Oklahoma to the north, New Mexico to the west, and the Mexican states of Chihuahua, Coahuila, Nuevo León, and Tamaulipas to the southwest, while the Gulf of Mexico is to the southeast.
Document 4: San Diego: The city shares a 15-mile (24 km) border with Mexico that includes two border crossings. San Diego hosts the busiest international border crossing in the world, in the San Ysidro neighborhood at the San Ysidro Port of Entry. A second, primarily commercial border crossing operates in the Otay Mesa area; it is the largest commercial crossing on the California-Baja California border and handles the third-highest volume of trucks and dollar value of trade among all United States-Mexico land crossings.
Document 5: Canada–United States border: The Canada -- United States border (French: Frontière entre le Canada et les États - Unis), officially known as the International Boundary (French: Frontière internationale), is the longest international border in the world between two countries. It is shared between Canada and the United States, the second - and fourth - largest countries by area, respectively. The terrestrial boundary (including portions of maritime boundaries in the Great Lakes, and on the Atlantic, Pacific, and Arctic coasts) is 8,891 kilometres (5,525 mi) long, of which 2,475 kilometres (1,538 mi) is Canada's border with Alaska. Eight Canadian provinces and territories (Yukon, British Columbia, Alberta, Saskatchewan, Manitoba, Ontario, Quebec, and New Brunswick), and thirteen U.S. states (Alaska, Washington, Idaho, Montana, North Dakota, Minnesota, Michigan, Ohio, Pennsylvania, New York, Vermont, New Hampshire, and Maine) are located along the border.
Document 6: Southern California: To the east is the Colorado Desert and the Colorado River at the border with Arizona, and the Mojave Desert at the border with the state of Nevada. To the south is the Mexico–United States border.
Document 7: 500 Days of Summer: David Ng of the Los Angeles Times describes architecture as a star of the film. Tom is seen reading Alain de Botton's The Architecture of Happiness. The film was originally set in San Francisco but was later moved to Los Angeles and the script rewritten to make better use of the location. Buildings used include the Los Angeles Music Center (which includes the Dorothy Chandler Pavilion) and the towers of California Plaza. The older Fine Arts Building is featured in the film, in a scene where Tom shows it to Summer and mentions its designers, Walker and Eisen, two of his favorite architects, although he incorrectly gives the partners' names as ``Walker and Eisner. ''
Document 8: History of Texas (1845–1860): When Texas was annexed, Mexico broke diplomatic relations with the United States. The annexation bill did not specifically define the boundaries of Texas. The former republic claimed the Rio Grande as its southern border, while Mexican authorities had always considered the Nueces River, situated further north, to be the boundary of Mexican Texas. The United States sent John Slidell to negotiate with the Mexican government, offering $25 million ($707,115,385 today) to set the Texas border at the Rio Grande and to purchase Mexico's provinces of Alta California and Santa Fe de Nuevo México. Popular sentiment in Mexico was against any sale, and the army deposed President José Joaquín de Herrera when he appeared inclined to negotiate with Slidell.
Document 9: Mexico–United States border: Among the U.S. states, Texas has the longest stretch of the border with Mexico, while California has the shortest. Among the states in Mexico, Chihuahua has the longest border with the United States, while Nuevo León has the shortest.
Document 10: Canada–United States border: The Canada -- United States border (French: Frontière entre le Canada et les États - Unis), officially known as the International Boundary, is the longest international border in the world between two countries. It is shared between Canada and the United States, the second - and fourth - largest countries by area, respectively. The terrestrial boundary (including portions of maritime boundaries in the Great Lakes, and on the Atlantic, Pacific, and Arctic coasts) is 8,891 kilometres (5,525 mi) long, of which 2,475 kilometres (1,538 mi) is Canada's border with Alaska. Eight Canadian provinces and territories (Yukon, British Columbia, Alberta, Saskatchewan, Manitoba, Ontario, Quebec, and New Brunswick), and thirteen U.S. states (Alaska, Washington, Idaho, Montana, North Dakota, Minnesota, Michigan, Ohio, Pennsylvania, New York, Vermont, New Hampshire, and Maine) are located along the border.
Document 11: Alamo Square, San Francisco: A row of Victorian houses facing the park on Steiner Street, known as the ``Painted Ladies '', are often shown in the foreground of panoramic pictures of the city's downtown area. A number of movies, television shows and commercials have been filmed in or around Alamo Square. The park features heavily in the 1978 horror film The Invasion of the Body Snatchers, and the romantic comedy The Five - Year Engagement. The opening sequence of the American sitcom Full House (1987 - 1995) features a romp in Alamo Square Park with the famous row of Victorians in the background.
Document 12: Mexico–United States border: The total length of the continental border is 1,954 miles (3,145 km). From the Gulf of Mexico, it follows the course of the Rio Grande (Río Bravo del Norte) to the border crossing at Ciudad Juárez, Chihuahua, and El Paso, Texas. Westward from El Paso -- Juárez, it crosses vast tracts of the Chihuahuan and Sonoran deserts to the Colorado River Delta and San Diego -- Tijuana, before reaching the Pacific Ocean.
Document 13: Some Like It Hot: The film was made in California during the summer and autumn of 1958. Many scenes were shot at the Hotel del Coronado in San Diego which appeared as the ``Seminole Ritz Hotel ''in Miami in the film. The Hotel in San Diego fitted into the era of the 1920s and was near Hollywood, so Wilder chose it although it was not in Florida.
Document 14: Santa Monica, California: Hundreds of movies have been shot or set in part within the city of Santa Monica. One of the oldest exterior shots in Santa Monica is Buster Keaton's Spite Marriage (1929) which shows much of 2nd Street. The comedy It's a Mad, Mad, Mad, Mad World (1963) included several scenes shot in Santa Monica, including those along the California Incline, which led to the movie's treasure spot, "The Big W". The Sylvester Stallone film Rocky III (1982) shows Rocky Balboa and Apollo Creed training to fight Clubber Lang by running on the Santa Monica Beach, and Stallone's Demolition Man (1993) includes Santa Monica settings. Henry Jaglom's indie Someone to Love (1987), the last film in which Orson Welles appeared, takes place in Santa Monica's venerable Mayfair Theatre. Heathers (1989) used Santa Monica's John Adams Middle School for many exterior shots. The Truth About Cats & Dogs (1996) is set entirely in Santa Monica, particularly the Palisades Park area, and features a radio station that resembles KCRW at Santa Monica College. 17 Again (2009) was shot at Samohi. Other films that show significant exterior shots of Santa Monica include Fletch (1985), Species (1995), Get Shorty (1995), and Ocean's Eleven (2001). Richard Rossi's biopic Aimee Semple McPherson opens and closes at the beach in Santa Monica. Iron Man features the Santa Monica pier and surrounding communities as Tony Stark tests his experimental flight suit.
Document 15: Mexico–United States border: The total length of the continental border is 3,201 kilometers (1,989 mi). From the Gulf of Mexico, it follows the course of the Rio Grande (Río Bravo del Norte) to the border crossing at Ciudad Juárez, Chihuahua and El Paso, Texas. Westward from El Paso -- Juárez, it crosses vast tracts of the Chihuahuan and Sonoran deserts to the Colorado River Delta and San Diego -- Tijuana, before reaching the Pacific Ocean.
ground_truth: 1,989 mi
sub_queries: where did they film some like it hot Answer: in California
the country of shares a border with in California Answer: Mexico
how long is the us border with Mexico Answer: 1,989 mi