Extract

Below is the summary of data sources in this project: Python script for downloading the files from Seattle Open Data to Azure file share.

Paid Parking Data is available for the city of Seattle from 2012 to the Present. Except for the year 2020 (pandemic) all other years had file size of about 42 GB. Downloading the files was not straightforward as each file has a unique code associated with it. To fully automate the ingestion process, the code was extracted via an python automation script using Selenium and Headless Chrome browser.

Method	Source	Feature/Key	Frequency	Description
Python/Selenium	Seattle Open Data	2012 Year-to-Date Historic	Once	Entire Paid Parking records for the year 2012
Python/Selenium	Seattle Open Data	2013 Year-to-Date Historic	Once	Entire Paid Parking records for the year 2013
Python/Selenium	Seattle Open Data	2014 Year-to-Date Historic	Once	Entire Paid Parking records for the year 2014
Python/Selenium	Seattle Open Data	2015 Year-to-Date Historic	Once	Entire Paid Parking records for the year 2015
Python/Selenium	Seattle Open Data	2016 Year-to-Date Historic	Once	Entire Paid Parking records for the year 2016
Python/Selenium	Seattle Open Data	2017 Year-to-Date Historic	Once	Entire Paid Parking records for the year 2017
Python/Selenium	Seattle Open Data	2018 Year-to-Date Historic	Once	Entire Paid Parking records for the year 2018
Python/Selenium	Seattle Open Data	2019 Year-to-Date Historic	Once	Entire Paid Parking records for the year 2019
Python/Selenium	Seattle Open Data	2020 Year-to-Date Historic	Once	Entire Paid Parking records for the year 2020
Python/Selenium	Seattle Open Data	2021 Year-to-Date Delta	Daily	Delta Paid Parking records for the year 2021
Python/Selenium	Blockface	Daily	2021 Year-to-Date Delta	Entire Paid Parking records for the year 2021