Borash, Kyle

Teter, Rachel

English

ScholarWorks@UA

The Alaska Energy Data Gateway: Bringing You More Information, More EasilyRachael Teter and Kyle BorashFAI● Mission○ True to identity, heritage, and values, Alaska Natives are informed and engaged in leading the decisions that shape the future.● Vision○ Progress for the Next Ten Thousand Years● Connects interns to different companies throughout AKfirstalaskans.orgISER● ISER’s Mission○ ISER enhances the well-being of Alaskans and others, through non-partisan research that helps people understand social and economic systems and supports informed public and private decision-making.iser.uaa.alaska.eduISER● Learning experience○ Youngest in office● My “Tasks”○ Weekly mentoring■ Always interacting with professionals with experience○ The Alaska Energy Data Gateway (AEDG)■ Updated and added to the siteiser.uaa.alaska.eduAlaska Energy Data Gateway: Past● The project was started in 2011, with a public launch in 2013● The AEDG was one task of a DOE EPSCOR grant to the UA System● Initially we only had the data search tool○ Community members indicated the site wasn’t as helpful as it could be○ The Community Data Summary tool was added○ 2/3rds of users now use the Community Data Summary tool● We focused on energy data○ PCE Program Data○ Energy Statistics○ Fuel pricesAlaska Energy Data Gateway: Present● We’ve greatly expanded the number of data sets housed on the AEDG○ Employment information from the ALARI portal○ Education data○ Erosion Information○ AEA’s Renewable Energy Fund data● We’ve added new data to the Community Data Summary page● Continued investment in data sets and system upkeep○ ISER○ AEAAlaska Energy Data Gateway: Future● Funding through Lawrence Berkeley National Laboratory○ A task of the Alaska Microgrid Partnership● Partnering with the Alaska Center for Energy and Power (ACEP)● Project Goals:○ Add data sets that help fill in holes in the AEDG○ Modernize the look of the AEDG○ Add a user friendly tool to quickly view data availability and compare data availability between communitiesWhat have I updated?AHFC Fuel Survey DataFCS Utilities DataALARI DataIndustry - Occupation - SummaryAlaska Housing Finance Corporation Fuel Survey Data● Biyearly Survey includes:○ Fuel price 1 & 2, Propane price, and prices of various cords of woods● Not publicly accessible○ Emailed directly with Jimmy Ord and Scott Waterman● Sporadic historical data○ Uploaded 2015-2017○ Date checked AEDG dataUAF Food Cost Survey Utilities Data● Quarterly Survey Includes○ Food costs broken down by male, female, age, family throughout AK○ Utilities included: Electricity 1,000 kwh, Heating oil, Regular Gas, Propane 100lbs, 2x4x8● Downloadable public data○ Last report on AEDG was Q2 of 2013○ Emailed Bret Luick○ Looked through FCS data from Q2 of 2013-present■ Found 3 non-consecutive quarters containing utility■ Updated the AEDG to contain most recent dataAlaska Local and Regional Information Data● Community Data Includes○ Population, Worker information,  and Unemployment information○ 3 Sub-categories for the AEDG■ Employment by Industry■ Employment by Occupation■ Employment Summary DataAlaska Local and Regional Information Data● Employment by Industry (2015)- scraped from site○ City, Year, Industry name, # of employed, female, male, age 45 up, age 50 up● Employment by Occupation (2015)- scraped from site○ Gov’t/private sector, quarter breakdown, new hires, unemployment, industry● Employment Summary Data (2012-2015)- emailed from Jeanne Biller○ Everything from occupation, plus workers with previous industry experienceWhat’s new?Alaska Taxable DataAEA Sponsored AVTEC training DataCommunity Aid Program DataAlaska Taxable Data (2001-2016)● Per Capita Tax Revenues Include○ Municipality, Property Tax (Inc. Oil & Gas), Sales Tax, Other Taxes*, Total Taxes Reported, and Per Capita Revenue by city where municipality collects both city and borough taxes● Downloadable public data from DCRA site○ Many more downloadable reports than just Per Capita○ Per Capita is Consistently reported for all years (2001-2016)● *Other Taxes include:● Bed, Alcohol, Car Rental Tax, Raw Fish, Tobacco, Misc SpecialAlaska Public Lands Information CentersAEA Sponsored AVTEC Training Data (1995-2017)● Data-Set Includes○ Community, Fiscal Year of training, Course Title, and how many people completed the course (e.g. Akiachak, 2005, Bulk Fuel Operator, 2)● Not Publicly Accessible○ Sent to us by Neil McMahon of AEA● Since it wasn’t previously available, and the data is very specific, I worked with Neil a lot to work out the metadatawww.aidea.orgCommunity Assistance Program Data (formerly Community Revenue Sharing)● CAP Background○ Established in 2008 as the Community Revenue Sharing Program○ Provides funds to deliver basic public services each fiscal year■ The exact services is the decision of the community“If the amount of funding available exceeds the amount necessary to fully fund all the basic community revenue sharing payments, the balance is distributed on a per capita basis excluding the unincorporated communities located within organized boroughs.” Community Revenue Sharing OverviewCommunity Assistance Program Data (formerly Community Revenue Sharing)● Status Report Includes○ Community (Municipality or Unincorporated), Program year, Payment amount, Application information, Payment Authorization○ Application Includes: Actual Application (sent out to eligible communities), Budget for fiscal year of grant or of calendar year from year prior, and Audit or certified financial statement of fiscal year two years prior● Downloadable PDF files○ We needed it in Excel or CSV files● Emailed a few people and reached out to the FAI cohort○ Historic data (2009-2017) and instructions for PDF to ExcelWhat can one do with this data?Community Specific Trend Analyses of Alaska Taxable and Community Assistance ProgramSt. Mary’s Revenue AnalysisUS BeaconSt. Mary’s Revenue Analysis● CAP Begins in 2009○ Spikes in 2012-2013● Other Taxes Begin in 2007○ Jumps in 2014● Sales Tax remains through all years○ Jumps in 2011○ Spikes in 2015St. Mary’s Revenue Analysis● Pre-CAP○ Steady○ Low Total Rev● Post-CAP○ Jump in 2009○ Spikes in 2012 & 2015● Despite spikes, steady rise in total revenuePilot Point Revenue AnalysisPilot Point Revenue Analysis● CAP Begins in 2009○ Spikes in 2012 &2013● Other Taxes○ Drops 2004-2006○ Ends in 2016○ Drops 2010 & 2014● Sales Taxes○ Begins in 2016Pilot Point Revenue Analysis● Pre-CAP○ Inconsistent○ Low Total Rev○ Rising quickly● Post-CAP○ Drops in 2010 & 2014-2015● Despite drops, slight curveSt. Mary’s (KSM) vs. Pilot Point (PIP)Similarities● Rural communities● Dramatic increase in Total Revenue Post-CAP● CAP spiked in 2012-2013● Inconsistencies Post-CAP became more dramaticDifferences● PIP= fishing community● KSM= relied on Sales, increasing Other● PIP= relied on Other, switched to SalesQuestions this raises● Why was there a spike in CAP im 2012-2013?● Has the CAP affected Tax revenue for communities?● Has changes in Tax income sources for one community affected Tax income sources for those in the same region?● Will these trends continue through time?● Mouhcine Guettabi- Professor of Economics at ISER○ Report on CAP effecting Boroughs throughout Alaska● There are so many more questions, all you have to do is ask!What Have I Learned?ISER Mentoring TimeFAI Leadership TrainingThe Big Takeaways● Your background doesn’t have to define you● Each obstacle has its own paths to a solution○ “It’s always the question that guides the actions”● Excel is a wonderful tool… when you know how to use it● Speak up about your problems, because you never know who has connections to get you answersQuestions?MemeGenData LinksISER- http://www.iser.uaa.alaska.edu/AEDG- https://akenergygateway.alaska.edu/UAF FCS- https://www.uaf.edu/ces/hhfd/fcs/ALARI- http://live.laborstats.alaska.gov/alari/AK Taxable- https://www.commerce.alaska.gov/dcra/dcrarepoext/Pages/AlaskaTaxableDatabase.aspxCAP- https://www.commerce.alaska.gov/dcra/eGrantsOnLine/Pages/RevenueSharing.aspxMouhcine Guettabi- http://www.iser.uaa.alaska.edu/Publications/2017_06-RegionalAssessmentBorGovFinEmployment.pdf

The Alaska Energy Data Gateway: Bringing You More Information, More Easily

https://scholarworks.alaska.edu/bitstream/11122/9267/1/2017_08_09-LT_AEDG.pdf

The Alaska Energy Data Gateway: Bringing You More Information, More Easily

Abstract

Similar works

Full text

Available Versions

ScholarWorks@UA