{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Seattle Building Permits" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "I've been wanting to do some research into the building boom here in Seattle for a while. Thanks to the city's [open data initiative](https://data.seattle.gov/browse?sortBy=most_accessed&sortPeriod=week) powered by Socrata, there is readily available information to get started. Perhaps ultimately this could be tied into a larger project around affordable housing. I know that there is a basic supply and demand arguement to be made for how all these cranes are going to help the situation, but just based on my own observations, there seem to be way more luxury high rises than modest housing units going up." ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [], "source": [ "%matplotlib inline\n", "import pandas as pd\n", "import numpy as np\n", "import seaborn as sns\n", "import matplotlib.pyplot as plt\n", "from datetime import datetime\n", "import re" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Get Data" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | :@computed_region_2day_rhn5 | \n", ":@computed_region_cyqu_gs94 | \n", ":@computed_region_kuhn_3gp2 | \n", ":@computed_region_q256_3sug | \n", "action_type | \n", "address | \n", "applicant_name | \n", "application_date | \n", "application_permit_number | \n", "category | \n", "... | \n", "latitude | \n", "location | \n", "location_address | \n", "longitude | \n", "master_use_permit | \n", "permit_and_complaint_status_url | \n", "permit_type | \n", "status | \n", "value | \n", "work_type | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "NaN | \n", "NaN | \n", "28.0 | \n", "18792.0 | \n", "NEW | \n", "1233 NE 88TH ST | \n", "BIDDLE, DAVE | \n", "2016-12-19T00:00:00.000 | \n", "6564183 | \n", "SINGLE FAMILY / DUPLEX | \n", "... | \n", "47.691846 | \n", "{'type': 'Point', 'coordinates': [-122.313688,... | \n", "1233 NE 88TH ST | \n", "-122.313688 | \n", "3025890.0 | \n", "http://web6.seattle.gov/dpd/PermitStatus/Proje... | \n", "Construction | \n", "Application Accepted | \n", "478973 | \n", "Plan Review | \n", "
1 | \n", "NaN | \n", "NaN | \n", "48.0 | \n", "18792.0 | \n", "ADD/ALT | \n", "6008 29TH AVE NE | \n", "JACKSON, LEIF | \n", "2016-12-21T00:00:00.000 | \n", "6563910 | \n", "SINGLE FAMILY / DUPLEX | \n", "... | \n", "47.672460 | \n", "{'type': 'Point', 'coordinates': [-122.29612, ... | \n", "6008 29TH AVE NE | \n", "-122.296120 | \n", "NaN | \n", "http://web6.seattle.gov/dpd/PermitStatus/Proje... | \n", "Construction | \n", "Permit Issued | \n", "5655 | \n", "Plan Review | \n", "
2 | \n", "NaN | \n", "NaN | \n", "13.0 | \n", "18385.0 | \n", "ADD/ALT | \n", "5214 DELRIDGE WAY SW | \n", "MIHLON, MATTHEW D | \n", "2016-09-12T00:00:00.000 | \n", "6536904 | \n", "COMMERCIAL | \n", "... | \n", "47.554495 | \n", "{'type': 'Point', 'coordinates': [-122.362727,... | \n", "5214 DELRIDGE WAY SW | \n", "-122.362727 | \n", "NaN | \n", "http://web6.seattle.gov/dpd/PermitStatus/Proje... | \n", "Construction | \n", "Permit Issued | \n", "5000 | \n", "Plan Review | \n", "
3 | \n", "NaN | \n", "NaN | \n", "43.0 | \n", "18800.0 | \n", "ADD/ALT | \n", "5425 57TH AVE S | \n", "MOODY, WILLIAM | \n", "2017-01-23T00:00:00.000 | \n", "6561114 | \n", "SINGLE FAMILY / DUPLEX | \n", "... | \n", "47.552729 | \n", "{'type': 'Point', 'coordinates': [-122.262284,... | \n", "5425 57TH AVE S | \n", "-122.262284 | \n", "NaN | \n", "http://web6.seattle.gov/dpd/PermitStatus/Proje... | \n", "Construction | \n", "Permit Issued | \n", "1000 | \n", "No plan review | \n", "
4 | \n", "NaN | \n", "NaN | \n", "7.0 | \n", "18390.0 | \n", "SHORELINE EXEMPTION ONLY | \n", "2145R WESTLAKE AVE N | \n", "ANTIEAU, CLAYTON | \n", "2017-02-07T00:00:00.000 | \n", "6562603 | \n", "NaN | \n", "... | \n", "47.638863 | \n", "{'type': 'Point', 'coordinates': [-122.341316,... | \n", "2145R WESTLAKE AVE N | \n", "-122.341316 | \n", "NaN | \n", "http://web6.seattle.gov/dpd/PermitStatus/Proje... | \n", "Site Development | \n", "AP Closed | \n", "0 | \n", "Plan Review | \n", "
5 rows × 25 columns
\n", "