Question: Greatest Hits 1978-1997 is the second DVD by an American rock band formed in what city?

Context paragraphs:
David Denny (musician): David Denny (born February 5, 1948, Berkeley, California) is an American rock guitar player who was a founding member of Frumious Bandersnatch, a seminal psychedelic rock band from 1960s San Francisco.  Denny was a member of the Steve Miller Band, playing on 1977's "Book of Dreams", "Greatest Hits 1974-1978" (released in 1978, sold over 13 million copies), and 1993's "Wide River".  Denny wrote the hit song "The Stake," which was on the "Book of Dreams" and "Greatest Hits 1974-1978" albums.  While running a Mission District studio during the late 1980s, Denny contributed his guitar and vocal talents as a founding member of the Bombay Crawlers and played several Bay Area gigs with the swampy, powerful rock ensemble.  He later released two solo albums, 1991's Diesel Harmonics and 1997's Louisiana Melody.  David Denny and his ex-wife Kathy Peck (Executive Director and Co-founder of H.E.A.R. and former bass player with The Contractions) are artists, songwriters, film score composers, and music publisher owners of Monima Music.

Another Station: Another Mile: Another Station: Another Mile is the second DVD from rock band Rise Against.  It was released on October 5, 2010, through Interscope Records.  This DVD contains live, raw, and unreleased footage of the band's performances as well as documentary segments directed by Davy Rothbart, Rachel Dengiz & David Meiklejohn.  The live footage is intervened with the documentary segments, which vary from the band backstage, on tour and on the road, to each band member revealing the creative process that goes into making a Rise Against song and the history of each individual band member.  The band also stated that all the live footage on the DVD is raw and unedited, capturing exactly the same energy of the live show.  The trailer for the DVD features the intro riff to the song "Wait For Me" as well as an early version of "Endgame", both from the 2011 album, "Endgame."  The DVD features no actual menu, and all of the footage included is bunched into a single feature.  The DVD features a total of 14 tracks performed live, recorded on different dates and at different locations.  The title for the DVD come's from the lyrics of the song "The Dirt Whispered" from Rise Against's album "Appeal to Reason".

Steve Miller Band: The Steve Miller Band is an American rock band formed in 1966 in San Francisco, California.  The band is led by Steve Miller on guitar and lead vocals.  It is best known today for a string of (mainly) mid-1970s hit singles that are staples of classic rock radio, as well as several earlier acid rock albums.  Miller left his first band to move to San Francisco and form the Steve Miller Blues Band.  Shortly after Harvey Kornspan negotiated the band’s landmark contract with Capitol Records in 1967, the band shortened its name to the Steve Miller Band.  In February 1968, the band recorded its debut album, "Children of the Future".  It went on to produce the albums "Sailor", "Brave New World", "Your Saving Grace", "Number 5", "Rock Love" and more.  The band's "Greatest Hits 1974–78", released in 1978, sold over 13 million copies.  The band continued to produce more albums and in 2014 toured with the rock band Journey.  In 2016, Steve Miller was inducted as a solo artist in the Rock and Roll Hall of Fame.

Greatest Hits 1978–1997: Greatest Hits DVD 1978-1997 - Music Videos and Live Performances is the second DVD by the American rock band Journey, released in 2003.  It contains music videos and live performances of songs from the band's history with longtime lead vocalist Steve Perry, who left the band in 1998.  It is Journey's best selling concert video going 4× Multi-Platinum since its 2003 release.

The Platinum Collection (Queen album): The Platinum Collection: Greatest Hits I, II & III is a box set by British rock band Queen which comprises their three greatest hits albums, "Greatest Hits", "Greatest Hits II" and "Greatest Hits III".  The album was originally released on 13 November 2000 on the Parlophone label.  A booklet with song facts and images is also included with the three CD set.  The album's US release was delayed by Hollywood Records until September 2002 and featured the 2001 Japanese release remastered versions of "Greatest Hits Volumes 1" and "2" on the US and Canadian versions of "The Platinum Collection".

Greatest Hits (Westlife album): Greatest Hits is the second greatest hits album and final release by Irish boy band Westlife.  It was released on 18 November 2011 by RCA Records and Sony Music.  "Greatest Hits" is the group's second greatest hits album following "" (2002).  The album is the group's first album not under Syco Music and not under the tutelage of Simon Cowell, having left Syco and Cowell in March 2011.  The greatest hits album contains numerous singles that span throughout the band's career, as well as four new songs produced by John Shanks, which includes the lead single "Lighthouse", which was released on 14 November 2011.  The compilation was released in two different formats, a standard edition containing the album's eighteen tracks, and a deluxe edition featuring numerous other singles of the band's discography, as well as a DVD containing almost all of the band's music videos.

Greatest Hits (Blink-182 album): Greatest Hits is the first greatest hits album of American rock band Blink-182.  It was released on October 31, 2005 by Geffen Records.  "Greatest Hits" was created by Geffen shortly after the band's February 2005 breakup, termed an "indefinite hiatus" by the label.  Tensions had risen in the group and guitarist Tom DeLonge desired to take time off.  Bassist Mark Hoppus and Travis Barker argued with DeLonge regarding the band's future and their possible next album, and heated exchanges led to DeLonge's exit.  In the interim, Hoppus and Barker continued playing together in +44, and DeLonge formed his new outfit Angels & Airwaves.

Journey (band): Journey is an American rock band that formed in San Francisco in 1973, composed of former members of Santana and Frumious Bandersnatch.  The band has gone through several phases; its strongest commercial success occurred between 1978 and 1987.  During that period, the band released a series of hit songs, including "Don't Stop Believin' (1981), which in 2009 became the top-selling track in iTunes history among songs not released in the 21st century.  Its parent studio album, "Escape", the band's eighth and most successful, reached No. 1 on the "Billboard" 200 and yielded another of their most popular singles, "Open Arms".  Its 1983 follow-up album, "Frontiers", was almost as successful in the United States, reaching No. 2 and spawning several successful singles; it broadened the band's appeal in the United Kingdom, where it reached No. 6 on the UK Albums Chart.  Journey enjoyed a successful reunion in the mid-1990s and later regrouped with a series of lead singers.

The Byrds' Greatest Hits Volume II: The Byrds' Greatest Hits Volume II is the second greatest hits album by the American rock band The Byrds.  It was released in the United Kingdom on October 29, 1971 by CBS Records ("see" 1971 in music) as a follow-up to the band's first compilation album, "The Byrds' Greatest Hits".  The album appeared following the band's successful appearance at the Lincoln Folk Festival on July 24, 1971 and may have been issued by CBS as a reaction to the band's previous studio album, "Byrdmaniax", having failed to chart in the UK.

The Byrds' Greatest Hits: The Byrds' Greatest Hits is the first greatest hits album by the American rock band The Byrds and was released in August 1967 on Columbia Records ("see" 1967 in music).  It is the top-selling album in The Byrds' catalogue and reached #6 on the "Billboard" Top LPs chart, but failed to break into the UK Albums Chart.  The album provides a summary of The Byrds' history during Gene Clark and David Crosby's tenure with the band and also functions as a survey of the group's hit singles from 1965 to 1967, a period when the band had its greatest amount of success on the singles chart.  Most of the band's U.S. A-sides from this period are included on the album, along with three of their more important album tracks: "I'll Feel a Whole Lot Better", "The Bells of Rhymney", and "Chimes of Freedom".  The three U.S. singles from this period that are not included on the album are "Set You Free This Time", "Have You Seen Her Face" and "Lady Friend" (although these songs have been included as bonus tracks on various CD reissues of the album).  All of the songs included on the original "Greatest Hits" album can also be found on the band's first four albums, "Mr. Tambourine Man", "Turn!  Turn!  Turn! ", "Fifth Dimension" and "Younger Than Yesterday".

Supporting paragraphs: Greatest Hits 1978–1997 Journey (band)
Answer: San Francisco