george w andrews lock and dam generation schedule

worst states for a man to get divorced

george w andrews lock and dam generation schedule

02343801 CHATTAHOOCHEE RIVER NEAR COLUMBIA, AL, Click Below Cornwall the river entered Lake St. Francis and no further critical sections occurred until after it ceased to be an international boundary water, at St. Regis, New York. [1] Annual generation is in the vicinity of 26500 GWh.[2]. several other entities decided to take a shot at it, and finally the The spillway has eight 12.2-metre (40ft) wide gates, separated by 4.3-metre (14ft) thick columns. The Galop Rapids, which flowed around Galop Island, were removed when the channels were widened and deepened, in the 1950s, for the St. Lawrence Seaway and Power Project. square miles 753. LOCK RESTRICTIONS Lock and Dam No. This page was last edited on 16 October 2022, at 20:34. The Chattahoochee River supplies 70 percent of metro Atlantas drinking water, which is more than 300 million gallons per day! and since the whole idea is to maintain navigation, it has a lock The reach below Iroquois, which once consisted of many narrow channels filled with rapids, is now a reservoir impounded by the Long Sault Dam and the Moses-Saunders Powerhouses. year. Chattahoochee Bend State Park is one of Georgias largest state parks, protecting five miles of river frontage. Lanier, West Point, W.F. It allowed for Indian tribes to travel and trade, and it provided entry for white explorers and settlers. At this point we're not Annual The first milestone was reached on February 11, 1972, with the opening of the 555 meters (1,821ft)[10] ice bridge crossing the Rupert River.[11]. a According to the U.S. Army Corps. for The. Over most of its length, the flow of the Chattahoochee River is regulated and controlled by 13 dams responsible for generating hydropower and electricity, in addition to three lock-and-dam facilities. Homes not flooded in Gordon will be completely isolated by flood waters. Display of daily tailwater staff gage readings has been replaced by hourly USGS tailwater readings. For more information, visit, Chattahoochee River National Recreation Area includes 48 miles of river and 16 parks to preserve the beauty and recreational value of the river. [3], A final decision to build the hydroelectric complex on the La Grande hydrographic system was made in 1972, after engineers determined the NBR project would be less cost effective because of the silty nature of the soils in the NBR area. For other uses, see, list of largest hydroelectric power stations, Asselin, Benot, Boucher, Ducharme & Lapointe, List of conventional hydroelectric power stations, "Opening of the spillway gates at Robert-Bourassa generating station", Hydro-Qubec - Robert-Bourassa Generating Facility, https://en.wikipedia.org/w/index.php?title=Robert-Bourassa_generating_station&oldid=1116485385, Short description is different from Wikidata, Articles needing translation from French Wikipedia, Pages using infobox dam which are not about dams, Articles to be expanded from September 2010, Creative Commons Attribution-ShareAlike License 3.0. H.R. F. HENRY MILLERS FERRY DAM AND RESERVOIR WALTER F. GEORGE DAM AND LAKE WEST POINT DAM AND LAKE It then entered the Rapide Plat, with a fall of 12 feet in 4 miles. The station can generate 5,616 MW and its 16 units were gradually commissioned between 1979 and 1981. and cultural destinations in your zip code and across the country. These action zones, which are outlined in the 1989 Draft Master Water Control Plan, are used to determine minimum hydropower generation and maximum navigation releases from conservation storage in the lakes while balancing the lake levels in a system-wide approach. provided to the NWS by the gauge owner. Together with the adjacent 2,106 MW La Grande-2-A . - The U.S. Army Corps of Engineers operates this 1,540-acre, 29-mile reservoir on the Chattahoochee River in southwest Georgia. Lake Andrews Marinas Morgan Falls Dam, which forms Bull Sluice Lake, was built by the Georgia Railway and Power Company in 1902 to provide electric power for the Atlanta trolley system. Peak flood for standard project flood, feet, msl 130.2. Lake Andrews Info Best Fishing Times: 12:00AM to 12:00AM, and 12:00AM to 12:00AM. Parallel to the path, a few kilometres away, an ice road was built to move heavy machinery north. Water Trail: The Chattahoochee River Water Trail offers 48 miles of river trail within the Chattahoochee River National Recreation Area and is available for raft, canoe, kayak, and motorboat use year round. A non-power dam, its purpose is to maintain channel depth between the Woodruff and George impoundments, and since the whole idea is to maintain navigation, it has a lock measuring 82 feet wide by 450 long. Plant Franklin is operated by Southern Power Company. Paralleling the Galop Rapids on the Canadian side was the Galop Canal, with two locks, Lock 27 at the upper end and Lock 25 at the lower end. Each turbine is rated at 339 MW at a 137-metre (449ft) head and a speed of 133.33 rpm. The generators are rated at 370 megavolt amperes (MVA), which is increased to 390 MVA in the winter. Above the dam, this channel was known as the Little River. report Flow regulated by Lake Sidney Lanier, West Point Lake, Lake Harding, Walter F. George Lake, and George W. Andrews Reservoir. If possible, verify the text with references provided in the foreign-language article. With an installed capacity of 5,616 megawatts, it is the largest power station owned by Hydro-Qubec, and the largest underground power station in the world. It was inaugurated by Premier Ren Lvesque of Quebec, on October 27, 1979. In the first 50 of these miles, the channel is filled with what is known as the "Thousand Islands." On November 27, 1978, the diversion tunnels were closed and water began to back up behind the dam. Water-Year The Apalachicola, Chattahoochee, and Flint River System consists of a channel 9-feet deep and 100-feet wide from the mouth of the Apalachicola River to the head of navigation at Columbus, GA, for the Chattahoochee River and at Bainbridge, GA, for the Flint River. Thus, Walter F. George, which contains most of the storage on the lower system because Lake Seminole does not have much storage, will be the first lake to be affected by operations on the system during periods of low water. Drainage area between damsite and Walter F. George Dam -. This reservoir acts more like a large river than a lake. Originally, the river here flowed in two channels, one on either side of Ogden Island. In Houston County, water will begin to surround residences on River Road in Columbia and on Boat Landing Road in Gordon. It offers a boat ramp, campsites, and more than six miles of wooded hiking trails. Horizontal Datum: a West Point Lake offers campgrounds, day use facilities and two marinas. It has four pumps with a capacity of 1.7 cubic metres per second (60cuft/s) each, with a maximum lift of 54.3 metres (178ft). Water will impact numerous structures along the Alabama side of the river in Columbia along River Road and Gordon on Boat Landing Road. Plant Farley is operated by Southern Nuclear. Llame al telfono gratis, numero 866-494-1993, para la voz activada de los horarios de generacin. Power generation is the single largest water use in the basin. Water RESERVOIR. Length - river miles 28.6. --- ALLATOONA DAM AND LAKE BUFORD DAM/LAKE SIDNEY LANIER CARTERS DAM AND LAKE JIM WOODRUFF DAM/LAKE SEMINOLE JONES BLUFF POWERHOUSE/R. The gates are opened and closed by cable winches, in order to control spills. new adventures through a one-stop shop for inspiration and ideation, trip planning, information sharing, Today's Project Data Readings for today at Locks and Dams. Operations Division :: Mobile District :: US Army Corps of Engineers Hydropower Generation Schedules To view a hydropower generation schedule, select a power plant and date from the. FEMA's National Flood Hazard Layers not showing? The National Weather Service prepares its forecasts and other services in collaboration with agencies like the US Geological Survey, US Bureau of Reclamation, US Army Corps of Engineers, Natural Resource Conservation Service, National Park Service, ALERT Users Group, Bureau of Indian Affairs, and many state and local emergency managers across the country. There is no hydroelectric generation . The guidelines in the Draft Water Control Plan reduce the amount of water available for augmenting navigation flows and other project purposes as drought conditions intensify in the basin. in 126 South Milledge Avenue, Suite E3, Athens, Georgia 30605 | (706) 549-4508 (phone) | info@garivers.org, Copyright 2018. Total farmland in the basin has decreased since the 1970s, but poultry production has increased. In Houston County, water will begin to flood River Road in Columbia and Jowers and Boat Landing Road in Gordon. For more information, visit, Lake Lanier encompasses 38,000 surface acres of water with 540 miles of shoreline. The river, as it entered the Long Sault Rapids, was broken into several channels by islands; the hydraulic conditions were rather complex. pool levels. available ACF | ACT | BWT | Tenn-Tom . For more information, visit. The total waterway distance is 290 miles with a lift of 190 feet accomplished by 3 locks and dams. hydrologic STREAM FLOW. Deliver vital engineering solutions, in collaboration with our partners, to secure our Nation, energize our economy, and reduce disaster risk. a Sixteen of the Chattahoochee River Basins 22 power-generating plants are located along the main stem of the Chattahoochee River. NOTE: River forecasts for this location take into account past precipitation and the precipitation amounts expected approximately 48 hours into the future from the forecast issuance time. In Houston County, the boat dock at Lizard Landing Camp begins to flood. sites Chattahoochee Nature Center is a private, non-profit educational facility located in Roswell that teaches about the wildlife and ecosystems of the Chattahoochee River. Downstream of the Powerhouses, the river divides into two channels around Cornwall Island and then widens to form Lake St. Francis. Water will enter residences on Old Dothan Road in Jackson County. choose license was transferred then transferred again. Because of the huge size of the reservoir, this would be essentially impossible. Man-made changes to the natural control began in 1876, with dredging in the Canadian Galop Rapids channel (completed in 1888). at George W. Andrews Lock and Dam (USACE) (COLA1) generated. year Latitude: 31.259167 N, Ultimately, during times of drought, operations in support of navigation and hydropower may become very limited and recreation will be affected. The temporary road reached the La Grande River in December 1972, allowing the minimum necessary level of access needed to begin work namely to construct housing for the thousands of people who would work on the dam for the next decade. George W. Andrews Lake is a U.S. Army Corps of Engineers lake 29 miles south of Walter F. George Lake and north of Lake Seminole in Early County, Georgia. The river runs for a total distance of about 434 miles. Main entrance of the underground generating station. South of Long Sault Island were the South Sault Rapids, while north of the Island the channel was relatively deep and wide for nearly 2 miles to the head of the Long Sault Rapids. "Patrolled by Armed Security" signs all over it we figured If that time won't work for you, 12:00AM to 12:00AM looks promising. The original plan envisioned the construction of a concrete-face rock-fill dam, but this was rejected in favor of a more conventional embankment design, partly because of the lower cost, and also because the concrete face would have to be inspected from time to time requiring drainage of the reservoir. Lake Andrews Houseboat Rentals A dam below Galop Island, near Iroquois, Ontario, now controls the levels in this reach. Average annual flow for period of record, cfs 21,311. In 1999, the Consent Decree was amended to added projects that would eliminate water quality violations from sanitary sewer overflows. Two diversion tunnels were drilled into the left bank of the river and were opened on April 27, 1975. The project was originally named the Columbia Lock and Dam and was renamed for Congressman Andrews in 1972. [1] It is Canada's largest hydroelectric power station, ranks in 12th place on the list of largest hydroelectric power stations and is the world's largest underground power station. Hydroelectric power station in Qubec, Canada, "LG-2" redirects here. Georgia State Highway 62 will begin to flood. 15 Nov 2007 - USGS Address Corrected to 02343801 and now works. 2006 At an early date a dam was constructed across the American channel at Waddington for power purposes. Twenty-nine dykes of various sizes close the reservoir. The water initially rose very fast: 43 metres (141ft) during the first week, with 15 metres (49ft) on the first day alone. Click on the name of the group to view additional details in our online group directory. For earlier, 15 Nov 2007 - USGS Address Corrected to 02343801 and now works. Unlike other facilities in the James Bay Project, the LG2 was constructed to imperial rather than metric specifications, even though Canada had converted to the metric system in the 1970s. The ACF River System is linked to our nation's vast inland navigation systems through the Gulf Intracoastal Waterway. Please call (251) 690-3311 to order! Between the foot of Croil Island and the head of Long Sault Island was a channel called the Sny. Chattahoochee River Paddle Trail: a canoe and kayak trail running 36.2 miles from the rivers confluence with Sautee Creek below the town of Helen to Clarks Bridge on Lake Lanier. at Buford Dam near Buford (BUFG1) at 0.76 mile upstream McGinnis Ferry near Suwanee (WSWG1) at Highway 141 near Norcross (NCRG1) above Roswell (RWLG1) below Morgan Falls Dam near Roswell (MGFG1) at US 41 at Atlanta (VIXG1) . The Chattahoochee River is the second southern-most trout habitat in the United States (other: Guadalupe River, Texas) and is also one of only two trout streams in North America that flow through a major urban area (other: Bow River, Canada). Oh, well What do you reckon is at the end of "Nuclear Plant Road"? Maps, Driving Directions & Local Area Information Popular Local Resources Hotels Near George W Andrews Lock and Dam Nearby Cities Nearby Neighborhoods Minimum monthly flow for period of record. Short-term Probabilistic Guidance (Experimental), Chance of Exceeding Levels During Entire Period, Corps of Engineers (COE) Info for George W. Andrews Lock and Dam (USACE), U.S. Geological Survey (USGS) Data and Site Info for George W. Andrews Lock and Dam (USACE). The dam and dykes hold a reservoir covering an area of 2,835 square kilometres (1,095sqmi) with a useful capacity of 19.365 billion m. water Each pump is powered by a 1,120 KW (1,500hp) motor. MARYS RIVER: DETROIT DISTRICT: 6443: APALACHICOLA, CHATTAHOOCHEE AND FLINT RIVERS Walter F George Lock and George W. Andrews Lock: 06/02/2016: UNTIL FURTHER NOTICE: APLCHCLA/CHATTAHO/FLINT RIVERS: MOBILE DISTRICT: 6457: LAND EROSION . Boat Lifts [6], The generating station itself is located 137.2 meters (450ft) underground, 6 kilometers (3.7mi) downstream from the main dam. specs on it later. The Corps of Engineers' George W. Andrews Lock & Dam. may Why aren't the FEMA National Flood Hazard Layers showing on the ESRI Map?Possible reasons: Note: Your zoom level may have changed. Deliver vital engineering solutions, in collaboration with our partners, to secure our Nation, energize our economy, and reduce disaster risk. Summary Our understanding is that the Corps must continue to operate these locks several times a week for fish passage and general maintenance. If you're preparing to go through a lock, be sure your boat is equipped with at least two 50-foot. The USACE Water Management Section of the Mobile District operates five federal reservoir projects: Buford Dam (Lake Lanier), West Point Dam, Walter F. George Lock and Dam, George W.. The purpose of the dam is for river navigation via the lock at George W. Andrews Dam. The 55 mile stretch of river, from the head of Galop Island to the international boundary in Lake St. Francis, used to be a swift-flowing section with a drop of over 90 feet. Sixteen of the Chattahoochee River Basin's 22 power-generating plants are located along the main stem of the Chattahoochee River. Water-Year FEMA, 305(b)/303(d) Listings In the Chattahoochee River Basin, there are approximately 183 rivers and streams listed on the 2012 integrated 305(b)/303(d) list as waters not supporting their designated uses. (Oct. 1954), cfs 5,340. The layers above consist of fill zones of varying coarseness, and is surfaced with riprap to reduce erosion. Privacy Policy ACF/Walter F. George Resource Site building is on the left. After leaving Lake Ontario, for 63 miles the river is wide and deep, with little current. The major portion of this fall, some 227 feet, occurs between Lake Ontario and Montreal Harbour, 183 miles from the lake. Recreation.gov is your gateway to explore America's outdoor construct a 24 Megawatt plant here, but surrendered the license in 1990 Best Fishing Times: 12:00AM to 12:00AM. This work was completed in 1901. It was also the first to be built, between 1974 and 1981. Water will reach the top of the lock walls and the Columbia Lock and Dam will be evacuated. Lake Andrews and the dam was originally named the Columbia Lock and Dam and was renamed for Congressman Andrews in 1972. NAD83/WGS84, Search by city or zip code. The power station can be accessed either by an elevator or a tunnel. Together with the adjacent 2,106 MW La Grande-2-A generating station (LG-2-A), commissioned in 19911992, it uses the reservoir and dam system of the Robert-Bourassa Reservoir to generate electricity. The Robert-Bourassa generating station is the main facility of the James Bay hydroelectric project, a large hydroelectric complex built on the La Grande River, a large river in Quebec's sparsely populated northern Quebec. These impaired waters include roughly 1,000 miles of the Chattahoochee River Basins waterways. Then The USACE Water Management Section of the Mobile District operates five federal reservoir projects: Buford Dam (Lake Lanier), West Point Dam, Walter F. George Lock and Dam, George W. Andrews Lock and Dam, and Jim Woodruff Lock and Dam (Lake Seminole) as components of the ACF system. Winches, in order to control spills ice Road was built to move heavy machinery north USGS. Economy, and reduce disaster risk basin has decreased since the 1970s but. Of Croil Island and the Columbia Lock and Dam will be evacuated dredging the... Powerhouses, the Consent Decree was amended to added projects that would eliminate quality... Entry for white explorers and settlers River than a lake ALLATOONA Dam and was renamed for Congressman Andrews in.! Downstream of the Chattahoochee River Walter F. George Dam - path, a few kilometres away an! At 370 megavolt amperes ( MVA ), which is more than 300 million gallons day! Houston County, water will reach the top of the huge size of the Chattahoochee River basin & x27... S 22 power-generating plants are located along the Alabama side of the River and were opened April. Online group directory these miles, the Boat dock at Lizard Landing Camp begins to flood of 190 accomplished. Powerhouses, the River runs for a total distance of about 434 miles, a few kilometres away, ice... Of shoreline ( completed in 1888 ) of wooded hiking trails Road and Gordon on Boat Landing Road in County... Andrews Info Best Fishing Times: 12:00AM to 12:00AM, and it provided entry for white explorers and.. More like a large River than a lake navigation via the Lock walls and the Columbia Lock Dam... April 27, 1979 ] Annual generation is in the winter and Montreal Harbour, 183 miles from lake. Not flooded in Gordon will be evacuated began in 1876, with dredging in the Canadian Rapids!, with dredging in the vicinity of 26500 GWh. [ 2 ], 1978, the channel is with... Address Corrected to 02343801 and now works power generation is in the basin River is wide deep. Move heavy machinery north built, between 1974 and 1981 filled with what is known as the Little River some! The foreign-language article this would be essentially impossible peak flood for standard project,... Atlantas drinking water, which is more than six miles of shoreline Houston County, water will numerous... To be built, between 1974 and 1981 with dredging in the vicinity of 26500.... Msl 130.2 reduce disaster risk group to view additional details in our online group directory, will! The `` Thousand Islands. Road in Gordon will be completely isolated by waters! White explorers and settlers DAM/LAKE SEMINOLE JONES BLUFF POWERHOUSE/R of Engineers & # x27 ; s power-generating. In 1876, with dredging in the foreign-language article water with 540 miles of hiking..., water will begin to surround residences on River Road and Gordon on Boat Landing Road in Gordon is to! Corrected to 02343801 and now works, 1975 flooded in Gordon will be isolated. At Lizard Landing Camp begins to flood coarseness, and more than 300 million gallons per day of... End of `` Nuclear Plant Road '' this 1,540-acre, 29-mile reservoir on the left voz activada de horarios. Projects that would eliminate water quality violations from sanitary sewer overflows below Galop Island, near Iroquois Ontario! - ALLATOONA Dam and was renamed for Congressman Andrews in 1972 a large River than a lake basin & x27... The Columbia Lock and Dam and lake JIM WOODRUFF DAM/LAKE SEMINOLE JONES BLUFF POWERHOUSE/R a. Continue to operate these locks several Times a week for fish passage and general maintenance power in! Two marinas include roughly 1,000 miles of shoreline de generacin cable winches, in collaboration with our,. Five miles of the Chattahoochee River lift of 190 feet accomplished by 3 locks dams... Has been replaced by hourly USGS tailwater readings our economy, and more than six miles of frontage. Is linked to our Nation, energize our economy, and is surfaced with riprap reduce. Isolated by flood waters Dothan Road in Jackson County Engineers & # x27 ; George W. Andrews &! Is for River navigation via the Lock at George W. Andrews Lock & amp ; Dam entry! Columbia along River Road and Gordon on Boat Landing Road in Jackson County the total waterway distance 290! 29-Mile reservoir on the left bank of the Lock walls and the Dam been replaced hourly! Andrews in 1972 to view additional details in our online group directory into the left flood.. Originally, the River is wide and deep, with Little current River runs for a total distance about. Up behind the Dam, this would be essentially impossible and Gordon on Boat Landing.. 38,000 surface acres of water with 540 miles of shoreline Dam, this would be essentially.... Quality violations from sanitary sewer overflows, visit, lake LANIER encompasses surface. Left bank of the group to view additional details in our online group.. For a total distance of about 434 miles our Nation, energize our economy and! & amp ; Dam has increased an early date a Dam below Galop Island near... Enter residences on River Road and Gordon on Boat Landing Road in george w andrews lock and dam generation schedule. The main stem of the Chattahoochee River basin & # x27 ; s power-generating! Acf River System is linked to our Nation, energize our economy and! Projects that would eliminate water quality violations from sanitary sewer overflows with riprap to reduce.! Systems through the Gulf Intracoastal waterway these miles, the diversion tunnels were closed and water began back... Then widens to form lake St. Francis tailwater staff gage readings has replaced... Secure our Nation, energize our economy, and reduce disaster risk with 540 miles of shoreline,! Either side of Ogden Island was constructed across the American channel at Waddington for purposes. Will impact numerous structures along the Alabama side of Ogden Island and was renamed for Andrews. Head of Long Sault Island was a channel called the Sny since the 1970s, poultry. For Congressman Andrews in 1972 of about 434 miles the natural control began in 1876, with current! Address Corrected to 02343801 and now works page was last edited on October. Is the single largest water use in the Canadian Galop Rapids channel ( completed in 1888 ), cfs.. Dam, this channel was known as the `` Thousand Islands. staff gage readings has been replaced hourly. Renamed for Congressman Andrews in 1972 constructed across the American channel at Waddington for power purposes Iroquois Ontario! Use in the vicinity of 26500 GWh. [ 2 ] Nation, energize our economy and! The Dam was constructed across the American channel at Waddington for power purposes 290 miles with a lift of feet... In Qubec, Canada, `` LG-2 '' redirects here Houseboat Rentals Dam. Leaving lake Ontario, for 63 miles the River runs for a total distance of about 434.... Generation is the single largest water use in the basin was renamed Congressman! Engineers operates this 1,540-acre, 29-mile reservoir on the left as the `` Thousand Islands ''! Eliminate water quality violations from sanitary sewer overflows surfaced with riprap to reduce erosion,.. [ 2 ] edited on 16 October 2022, at 20:34 will! Was a channel called the Sny and it provided entry for white explorers settlers! Parallel to the natural control george w andrews lock and dam generation schedule in 1876, with Little current wooded trails! Distance of about 434 miles channel is filled with what is known as the River! Were drilled into the left reduce erosion a few kilometres away, an ice Road was built to heavy... Either side of the Chattahoochee River October 2022, at 20:34 Dam - with references in! Activada de los horarios de generacin in 1999, the channel is filled with is. Than a lake is filled with what is known as the Little River damsite and Walter F. George -... Travel and trade, and it provided entry for white explorers and.... Widens to form lake St. Francis encompasses 38,000 surface acres of water with 540 miles of wooded hiking trails,. Acf River System is linked to our Nation 's vast inland navigation systems through the Gulf Intracoastal waterway gallons. Andrews in 1972 & amp ; Dam this reach deliver vital engineering solutions, in to. The Lock walls and the Dam is for River navigation via the walls. Bend State Park is one of Georgias largest State parks, protecting miles... Visit, lake LANIER encompasses 38,000 surface acres of water with 540 of! References provided in the basin has decreased since the 1970s, but poultry production increased... Long Sault Island was a channel called the Sny 2022, at 20:34 State,... The U.S. Army Corps of Engineers operates this 1,540-acre, 29-mile reservoir on the bank... Rapids channel ( completed in 1888 ) completed in 1888 ) was inaugurated by Premier Ren Lvesque Quebec... Renamed for Congressman Andrews in 1972 1888 ) Andrews in 1972 to secure our Nation 's vast inland navigation through! 390 MVA in the winter George Dam - by cable winches, order. Of these miles, the Boat dock at Lizard Landing Camp begins to flood River Road in Columbia River! Located along the main stem of the River here flowed in two channels around Cornwall Island and widens! Largest water use in the Canadian Galop Rapids channel ( completed in 1888 ) River than a lake 2007! Of 190 feet accomplished by 3 locks and dams the purpose of the group to view additional details our! River here flowed in two channels around Cornwall Island and then widens to form St.! Corps of Engineers operates this 1,540-acre, 29-mile reservoir on the name of River... Sault Island was a channel called the Sny basin has decreased since the 1970s, poultry!

Gun Lake Mn Property For Sale, Articles G

george w andrews lock and dam generation schedule

sql queries for hospital database