<% '============= Create and Open Database Connection ============= 'OPEN THE DATABASE If blnConnectToDB Then dim blnDBconnectionDown blnDBconnectionDown = false Err.Clear on error resume next set dbConn = Server.CreateObject("ADODB.Connection") 'Open the Connnection 'dbConn.Open Application("dbConn_ConnectionString") dbConn.Open "DSN=PostgreSQL30", "eere_news", "33reNews" ''New Error trapping. KC added 2/23/2012 If Err.Number <> 0 Then ''Response.Write (Err.Description& "

") dbConn.Close Set dbConn = nothing blnDBconnectionDown = true End If On Error GoTo 0 ''error trapping not working here KC removed 2/23/2012 ''tmpDBErrorNativeError = 0 '' For Each dbErr In dbConn.Errors '' strErrMsg = strErrMsg & _ '' "Source: " & dbErr.Source & vbCrLF & _ '' "Description: " & dbErr.Description & vbCrLF & _ '' "SQL State: " & dbErr.SQLState & vbCrLF & _ '' "NativeError: " & dbErr.NativeError & vbCrLF & _ '' "Number: " & dbErr.Number & vbCrLF & vbCrLF '' tmpDBErrorNativeError = dbErr.NativeError '' Next '' If (dbConn.Errors.Count > 0) AND (tmpDBErrorNativeError <> 5703) Then '' dbConn.Close '' Set dbConn = nothing '' blnDBconnectionDown = true '' Response.write(strErrMsg) '' Response.end '' End If dim arrErrors() Redim arrErrors(2,0) End If '============================================================== Public Function GetRS2(myCommand) On Error GoTo 0 'objConn: local connection object 'objRS: local recordset object 'objComm: command object passed in to the function Dim objConn, objRS, blnErrorLogged, objComm 'Create the command object Set objComm = Server.CreateObject("ADODB.Command") Set objComm = myCommand 'Create the connection object Set objConn = Server.CreateObject("ADODB.Connection") 'Open the connection object objConn.Open "DSN=PostgreSQL30", "eere_news", "33reNews" 'Set the active connection objComm.ActiveConnection = objConn 'Create the recordset object Set objRS = Server.CreateObject("ADODB.Recordset") 'Set the cursor location for disconnected recordsets 'objRS.CursorLocation = adUseClient 'Turn on error handling for just a second ' On Error Resume Next 'Open the recordset 'objRS.Open SQL, objConn, adOpenStatic, adLockOptimistic Set objRS = objComm.Execute 'Response.Write "State = " & objRS.State & "
" 'objRS.MoveLast 'objRS.MoveFirst 'Response.Write "Count = " & objRS.RecordCount & "
" 'Response.End 'Check for an error ' If Err.Number <> 0 Then ' Response.Write "Database Error Occured

" ' Response.Write "Error #" & Err.Number & "
" ' Response.Write Err.Description & "

" ' Response.Write "SQL:
" ' Response.Write SQL ' Response.End ' End If 'Turn off error handling ' On Error GoTo 0 'Disconnect the recordset 'Set objComm.ActiveConnection = Nothing 'Close the connection 'objConn.Close 'Set the connection to Nothing 'Set objConn = Nothing 'Set the Command to Nothing 'Set objComm = Nothing 'Return the recordset Set GetRS2 = objRS On Error Resume Next End Function '=============================================================== Function GetRS(sSQL) 'Declarations dim rs 'Create Recordset Object set rs = Server.CreateObject("ADODB.Recordset") If blnConnectToDB Then 'Open Recordset based on SQL rs.Open sSQL, dbConn, 1, 3, 1 End If 'Return Recordset set GetRs = rs End Function '=============================================================== Function ExecSQL(sSQL) 'Open the Command Object dim lRecordsAffected dbConn.Execute sSQL, lRecordsAffected 'Return the Records Affected ExecSQL = lRecordsAffected End Function '======================================================================== Function sendEmail(strFrom,strTo,strSubject,strMessage) Dim sch ' Schema sch = "http://schemas.microsoft.com/cdo/configuration/" Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(sch & "sendusing") = 2 .Item(sch & "smtpserver") = "mxrelay.doe.gov" .update End With Set cdoMessage = CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = strFrom .To = strTo .Subject = strSubject .TextBody = strMessage .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing End Function Function removeBadChars(tmpString) tmpString = Replace(tmpString , "<", "") tmpString = Replace(tmpString , ">", "") tmpString = Replace(tmpString , "'", "") tmpString = Replace(tmpString , """", "") tmpString = Replace(tmpString , ";", "") tmpString = Replace(tmpString , "(", "") tmpString = Replace(tmpString , ")", "") removeBadChars = tmpString End Function %> <% 'If there is a mobile version of this site, check the user_agent, and forward to 'the mobile version of the site (unless cookie or querystring var is set) if "true" = "true" then tmpSeeFullPage = Mid(Request.Querystring("m"),1,1) if ((isMobile) and (tmpSeeFullPage <> "1")) then tmpMobileURL = Request.servervariables("HTTP_URL") tmpMobileFileName = mid(tmpMobileURL, InStrRev(tmpMobileURL, "/")+1) tmpMobileURL = Left(tmpMobileURL, InStrRev(tmpMobileURL, "/")) tmpMobileURL = tmpMobileURL & "m/" & tmpMobileFileName Response.Clear Response.Redirect(tmpMobileURL) end if end if %>

<% ''This code is strictly when a user clicks on a left nav and needs to be forwarded to another site/program/office if ("" <> "") then Response.Clear Response.Redirect ("") end if %>

FEMP Technology Brief: Doing Time under the Sun

This photo shows Alcatraz Island and Alcatraz Prison with San Francisco in the background.

George "Machine Gun" Kelly, Al Capone, and "Birdman" Robert Stroud-Alcatraz prison has had some infamous residents do time on the craggy island, known as "The Rock" in the middle of San Francisco Bay. Courtesy of the National Park

This photo shows the Cellhouse rooftop with the photovoltaic (PV) system mounted on the roof.

The National Park Service (NPS) decided to put the solar panels on Alcatraz's Cellhouse building. Courtesy of the NPS; NPS photo by Matt Connelly

Known as 'Broadway,' this photo shows the expansive walkway between the cells that housed many famous convicts.

"Broadway"–the walk of a lifetime for some special visitors. Courtesy of the National Park Service.

Costly fuel shipments and air pollution, coupled with growing oil spill concerns spur action!

An Urban PV Success Story

Sitting in the middle of the often-foggy San Francisco Bay is Alcatraz, one of the most iconic U.S. prisons. While it hasn't served as an operating prison for several decades, it now serves as host to a 307-kilowatt (kW) photovoltaic (PV) system, as well as to the 1.4 million visitors each year. The prison features 959 crystalline-silicon solar panels, powering computers, phones, appliances, pumps, and indoor and outdoor lighting, as well as a few large peak loads such as an elevator in the Cellhouse and lift at the dock.

Alcatraz Island, perched about 1 mile from San Francisco's Fisherman's Wharf, cannot operate without imported fuel, but uses only about 40% of the fuel previously used with the new PV system operating. The National Park Service (NPS) indicates that 2,000 gallons of diesel fuel were shipped to the island each week to keep the fossil-fuel generators in the power plant humming. Astutely, Golden Gate National Recreation Area applied for and used $3.6 million in 2009 from the American Recovery and Reinvestment Act (ARRA) to begin installing a solar-powered microgrid on the island.

Now a PV array sits on the roof of the main Cellhouse building, attached to two 2,000-amp-hour battery strings and an inverter plant. The solar battery system helps power the island when the sun isn't shining. Both the PV array and the battery system are hidden from view, which were crucial to the acceptance of the design during historical preservation review.

The new PV system should produce close to 400 MWh of electricity a year, reducing greenhouse gas emissions by about 337,000 kilograms of carbon dioxide a year and reducing the time the diesel generator runs by about 60%, with the PV system contribution peaking at about 90% under favorable environmental conditions. Prior to the PV and battery system installation, the diesel generator ran "24/7." The NPS also made some energy-efficiency changes, such as better light bulbs and tweaking operations to reduce energy consumption.

According to a 2010 NPS audit of the existing cost of energy, the cost of transporting diesel fuel (maintenance and the price of the fuel itself) to the island boosted the cost of electricity for the island to 58 cents per kWh (about four times the national average). The post-PV costs are expected to be lower than 58 cents per kWh, but additional operational time is needed to verify the reduction amount.

Blackberries and honeysuckles still grace Alcatraz Island, and black-crowned night herons and slender salamanders still circle above and below. Diesel fuel use has been slashed, leading to less corrosion of pipes and smokestacks and less pollution in and around the bay.

Escape to Sunlight

Island Power Systems
Islands, by nature, are not connected to the mainland, and typically contend with physical separation from mainland-based resources. Because of the physical isolation, power supply costs can be substantial. Power-cable interconnection to the mainland power grid can be prohibitively expensive and prone to abrupt failures. Importing fuel for power generation is expensive and entails environmental consequences and concerns. It is for this reason that even large islands like in Hawaii or the Caribbean have such high prices for electricity and other commodities. Even very small islands like Alcatraz Island can have significant electrical power needs, especially as a tourist attraction.

This photo shows the battery power storage system that is connected to the rooftop PV system on the Cellhouse.

The battery storage system, enclosed behind transparent plastic, is integral to the solar panel project on Alcatraz Island. Photo credit: NREL PIX 21417

The project was a long time coming. The National Renewable Energy Laboratory (NREL) has been working on the potential PV project since 1995 when FEMP enlisted NREL's assistance. NREL's Applying Technologies team was requested to assess the solar resource, do a feasibility study, and mock-up what a solar installation would look like up close and from across the bay. This original project was held up due to financial and historic preservation concerns.

In that earlier proposed project, the solar panels would have been visible from an exit door in the exercise yard, and that would mar the historic nature of the New Industries Building, where Al Capone once worked a sewing machine and "Machine Gun" Kelly did the laundry and was a church altar boy while serving time on the island.

Fortunately, during the ARRA subcontract performance study meetings, it was determined that the entire PV array could be placed on the Cellhouse because PV modules had become much more efficient in the last decade. Thankfully, the 2009 ARRA funding arrangement allowed that alternative to proceed. FEMP again supplied assistance by providing optimization of the new proposed system using the HOMER computer program and assistance with acceptance and commissioning of the completed system.

NPS also looked into re-establishing a link to the electrical grid in San Francisco after an anchor had severed the original transmission link to the mainland just before the island's prison closed in 1963. Alcatraz reopened, years later as an historic site managed by NPS, with a diesel-powered electrical grid. A 2007 feasibility study conducted by researchers at the University of Washington indicated that installing an undersea transmission cable to San Francisco would be too costly, reinforcing the proposal to install PV.

Funding and Financing Mechanisms
To assist government agencies with energy project development, the FEMP team has developed a variety of innovative financing mechanisms, detailed on the FEMP website:

Energy Savings Performance Contracts (ESPCs)–ESPCs allow Federal agencies to form partnerships with energy service companies (ESCOs) to avoid the up-front capital costs and special Congressional appropriations typically required for energy-savings projects.

Utility Energy Services Contracts (UESCs)–UESCs enable agencies to partner with their franchised or serving utilities to finance energy improvements.

Power Purchase Agreements (PPAs)–PPAs enable private financing of renewable projects. This allows developers to benefit from tax incentives and accelerated depreciation while allowing Federal agencies to reduce their exposure to risk and secure long-term electricity pricing. FEMP can support agencies interested in exploring this option with:

  • Renewable screening and assessments to determine cost effectiveness and project viability;
  • Project facilitation, including market research, requests for information, requests for proposals, and opportunity notices;
  • Assistance with land use agreements and similar requirements;
  • Bid evaluations.

More Information

National Park Service, Alcatraz Island: www.nps.gov/alca/index.htm

To learn more about this project, contact Andy Walker at NREL, 303-384-7531, andy.walker@nrel.gov, or Byron Stafford, 303-384-6426, byron.stafford@nrel.gov.