Edmonton Public Library's mission is "we share." In our Shared Values document - PDF, we assert our public role as a champion of ideas, community activators, knowledge seekers and open to all. True to our mission and values, EPL declares our support for the open data movement and recognizes the principles of the G8 Charter on Open Data.
By recognizing the Charter, EPL accepts our responsibility as a public institution to work towards sharing all of our data by default, while recognising that there are legitimate reasons why some data cannot be released. Following the charter, the data we release will be:
- High-quality, timely, comprehensive and accurate
- Provided in plain clear language with thorough metadata
- Available in formats readable by both machines and people
Additionally, we accept responsibility for sharing our technical expertise and experience with other organizations, documenting our open data standards and publishing practices online in the interest of transparency, working to increase open data literacy and encouraging citizens to unlock the value of open data.
Each year, EPL celebrates International Open Data Day by hosting a free Open Data Day event where we invite hackers, developers, designers, statisticians and anyone with an interest in data to spend the day experimenting and creating with open data.
View the complete day-of schedule for Open Data Day 2020, including workshop descriptions, participant prerequisites and room locations.
|9:00 AM||Doors open||Register at our desk any time after 9 a.m. Free coat check is available.||Shaw Theatre Lobby|
|9:30 AM||Optional pre-conference session: Open Data 101||Interested in open data but not sure what it's about? Join us for a quick journey through the basics.
This optional session is intended for participants with no coding or open data experience.
|10:00_AM||Refreshments||Shaw Theatre Lobby|
|10:15 AM||Opening remarks||Shaw Theatre|
|10:30 AM||Lightning Talks||Shaw Theatre|
|Matt Dance||Edmonton's Problem with GHG: Building Citizen Driven Policy Using Open Data|
|Elisabeth Richardson||How Open Data Can Benefit Local Biodiversity|
|Angela Coutinho||Data for Good: Use of Open Data within Not for Profits|
|Michael McNally, Luc Fagnan||Learning about Copyright Doesn't Have to be Terrifying|
|Keith Wu||Fostering Data Literacy at the City of Edmonton|
|Paul Bellows||Automating Customer Service with Open Data|
|Eugene Chen||Turning Open Data into Magic|
|Fernando Meira||Finding Patterns in Book Holdings: An EPL Dataset Exploration|
|11:30 AM||Networking||Shaw Theatre|
|12:00 PM||Lunch (not provided)|
|Python for Beginners
|It's finally time to learn how to code! In this casual, gentle workshop, City of Edmonton Data Storyteller and long-time nerd Clayton Clemens will walk you through the basics of programming in Python. No past coding experience is necessary, we're beginning at the ground floor and taking you through the fundamentals: variables, data types, conditions, loops, and lists!||Install Python 3.8 (https://www.python.org/downloads/).
This session is suitable for participants with no coding or markup experience.
|Moving Beyond Spreadsheets - R, RStudio, RMarkdown
|R is a freely available statistical programming language and environment that has existed for more than 25 years. RStudio is an “integrated development environment” that greatly improves R’s user-friendliness, and RMarkdown is a file format that allows you to integrate calculations, graphics, and formatted text in a single document. In this session I will show you how to use RStudio to install and load packages to increase R’s functionality, to load in and analyze a data set using R commands, to construct graphics, and to generate a formatted document containing the results||Install R (www.rproject.org) and the free desktop version of RStudio (www.rstudio.com). Note that R needs to be installed before RStudio.
This session will not assume any familiarity with R, so while previous programming experience would help it is not required.
|Using Python to examine Electricity Generation and Air Quality in Edmonton
|In this workshop, we will be using publicly available meteorological, air quality, and power generation data to identify the drivers of air pollution in Edmonton. We will devote roughly half the workshop to strategies for data cleaning and preparation, and the other half to supervised learning and visualization. Discussion will focus on scalability and statistical validity.||Software Requirements: Python 3.7, plus the following libraries: Pandas 0.23+, Numpy 1.14+, Scikit-learn 0.19+, Matplotlib2.1+, Seaborn 0.8+
It is recommended that participants be familiar with basic Python syntax and paradigms (loops, attributes / methods, try / except blocks, etc.). Knowledge of linear regression and statistical concepts such as the bias variance tradeoff and overfitting vs. underfitting will also be helpful.
|2:30 PM||Refreshments||Shaw Theatre Lobby|
|Exploring Geo-Spatial Open Data with kepler.gl
|Developed and released by Uber, kepler.gl is a powerful web-based geospatial analysis tool that enables visual exploration of large-scale location data. You can make neat looking data-driven maps without having to code and waste time on cumbersome data pre-processing steps. In this workshop attendees will learn:
- Overview of kepler.gl
- Why use kepler.gl
- Importing data
- Visualizing data on a map using layers available in Kepler.gl
- Filtering and refining data
- Exporting data and maps
|This session is suitable for participants with no coding or markup experience.||Shaw Theatre|
|Jekyll: Static Sites for Open Data
|Jekyll is an open source static website builder written in Ruby. GitHub Pages are powered by Jekyll, and you can create a new Jekyll site and have it online in less than 10 minutes. The large community behind Jekyll has created instances of open data portals, linked data integration, and Jekyll has a built in data feature to aid in navigation or be used like a static database. In this workshop we will learn about Jekyll, use the command line to create a new Jekyll site, explore an open data Jekyll theme, and play around with Jekyll data features.||Install Jekyll (https://jekyllrb.com/docs/installation/).
This session is suitable for participants with some coding or markup experience.
|Automate Google Analytics Reports with G Suite
|If you’re familiar with Google Analytics (GA), but want to step up your data management game, then this workshop is for you! In this session, you’ll learn how to create and automate custom GA reports and visualizations using Google Sheets and Google Apps Script.||You must have or create a Google account.
This session is suitable for participants with basic spreadsheet skills (Excel or Google Sheets), and some coding or markup experience.
|3:45 PM||Break||Shaw Theatre Lobby|
|4:00 PM||Data Jeopardy||Test your knowledge and win cool prizes!||Shaw Theatre|
|4:20 PM||Closing remarks||Shaw Theatre|