Skip to content

Instantly share code, notes, and snippets.

@fhk

fhk/Cali_broadband.ipynb

Created January 7, 2019 20:23
Show Gist options
  • Save fhk/4057ff75dfd918ff4adc24c1cc0d024e to your computer and use it in GitHub Desktop.
Save fhk/4057ff75dfd918ff4adc24c1cc0d024e to your computer and use it in GitHub Desktop.
Download ZIP
Cali_broadband
Display the source blob
Display the rendered blob
Raw
Cali_broadband.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# An exploration of the broadband speeds in Cali\n",
"\n",
"It always interesting that there may be data but it is prohibitvely expensive or lacks the detail required.\n",
"\n",
"Inspired by the recent post from the [Financial Times](https://ig.ft.com/gb-broadband-speed-map/#methodology) can we develop an analogous analysis for California?\n",
"\n",
"Our methodology is slighly different following the steps below to disaggregate the data collected by the FCC.\n",
"\n",
"Could this data be a treasure trove for consumers and operators? [link](https://morningconsult.com/opinions/fcc-form-477-is-a-marketing-opportunity-not-a-regulatory-burden/)\n",
"\n",
"## Create e2e test case for California\n",
"1. Get form 477 data\n",
"2. Source the census blocks\n",
"3. Source address points, streets, buildings etc\n",
"4. Join the Form 477 data to the polygon census blocks by ID - about the data, the data\n",
"5. Cut the data to each census block using ogr2ogr, or quad tree methodology\n",
"6. Develop feature extraction capability. This may be as simple as counts or as complex as distance from nearest street for addresses.\n",
"7. Create train, validate, test data set (No sure how we should sample as I think there will be a misrepresentation of different sizes of areas etc. will need to examine the distribution. Might need to to a research review on this? [example approach](https://www.esri.com/esri-news/arcuser/spring-2013/unequal-probability-based-spatial-sampling))\n",
"8. Build test model\n",
"9. Iterate on features\n",
"..."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"# Step 1: Get the data\n",
"\n",
"# Turns out there are multiple years of data, we are interested in the most\n",
"# recent but we should also examine the trends and data quality.\n",
"# It's also possible to get the data that shows satelite service to. Lets ignore that.\n",
"# The data is also somewhat latent and there are only 2 sample years at the moment.\n",
"# Hopefully we can revistit and update soon, with new data!\n",
"\n",
"all_2015_dec_v2 = \"http://transition.fcc.gov/form477/BroadbandData/Fixed/Dec15/Version%202/US-Fixed-without-Satellite-Dec2015.zip\"\n",
"ca_2015_dec_v2 = \"https://www.fcc.gov/form477/BroadbandData/Fixed/Dec15/Version%202/CA-Fixed-Dec2015.zip\"\n",
"ca_2015_jun_v2 = \"https://www.fcc.gov/form477/BroadbandData/Fixed/Jun15/Version%202/CA-Fixed-Jun2015.zip\"\n",
"ca_2014_dec_v2 = \"https://www.fcc.gov/form477/BroadbandData/Fixed/Dec14/Version2/CA-Fixed-Dec2014.zip\""
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" % Total % Received % Xferd Average Speed Time Time Time Current\n",
" Dload Upload Total Spent Left Speed\n",
" 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0\n",
"100 23.5M 100 23.5M 0 0 679k 0 0:00:35 0:00:35 --:--:-- 703k\n",
"Archive: CA-Fixed-Dec2015.zip\n",
" inflating: CA-Fixed-Dec2015-v2.csv \n",
" % Total % Received % Xferd Average Speed Time Time Time Current\n",
" Dload Upload Total Spent Left Speed\n",
" 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0\n",
"100 23.5M 100 23.5M 0 0 619k 0 0:00:38 0:00:38 --:--:-- 660k8M 0 0 599k 0 0:00:40 0:00:16 0:00:24 661k0 0 610k 0 0:00:39 0:00:19 0:00:20 672k\n",
"Archive: CA-Fixed-Jun2015.zip\n",
" inflating: CA-Fixed-Jun2015-v2.csv \n",
" % Total % Received % Xferd Average Speed Time Time Time Current\n",
" Dload Upload Total Spent Left Speed\n",
" 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0\n",
"100 22.1M 100 22.1M 0 0 638k 0 0:00:35 0:00:35 --:--:-- 673k\n",
"Archive: CA-Fixed-Dec2014.zip\n",
" inflating: CA-Fixed-dec2014-v2.csv \n"
]
}
],
"source": [
"!curl -LO \"$ca_2015_dec_v2\" && \\\n",
"unzip \"CA-Fixed-Dec2015.zip\" && \\\n",
"curl -LO \"$ca_2015_jun_v2\" && \\\n",
"unzip \"CA-Fixed-Jun2015.zip\" && \\\n",
"curl -LO \"$ca_2014_dec_v2\" && \\\n",
"unzip \"CA-Fixed-Dec2014.zip\""
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/anaconda3/envs/link/lib/python3.6/importlib/_bootstrap.py:219: RuntimeWarning: numpy.dtype size changed, may indicate binary incompatibility. Expected 96, got 88\n",
" return f(*args, **kwds)\n",
"/anaconda3/envs/link/lib/python3.6/importlib/_bootstrap.py:219: RuntimeWarning: numpy.dtype size changed, may indicate binary incompatibility. Expected 96, got 88\n",
" return f(*args, **kwds)\n"
]
}
],
"source": [
"import pandas as pd\n",
"import geopandas as gpd"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"ca_dec_15_df = pd.read_csv(\"CA-Fixed-Dec2015-v2.csv\")\n",
"ca_jun_15_df = pd.read_csv(\"CA-Fixed-Jun2015-v2.csv\")\n",
"ca_dec_14_df = pd.read_csv(\"CA-Fixed-Dec2014-v2.csv\")"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>LogRecNo</th>\n",
" <th>Provider_Id</th>\n",
" <th>FRN</th>\n",
" <th>ProviderName</th>\n",
" <th>DBAName</th>\n",
" <th>HoldingCompanyName</th>\n",
" <th>HocoNum</th>\n",
" <th>HocoFinal</th>\n",
" <th>StateAbbr</th>\n",
" <th>BlockCode</th>\n",
" <th>TechCode</th>\n",
" <th>Consumer</th>\n",
" <th>MaxAdDown</th>\n",
" <th>MaxAdUp</th>\n",
" <th>Business</th>\n",
" <th>MaxCIRDown</th>\n",
" <th>MaxCIRUp</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>139883</td>\n",
" <td>15905</td>\n",
" <td>14710388</td>\n",
" <td>FairPoint Communications Missouri, Inc.</td>\n",
" <td>Fairpoint Communications</td>\n",
" <td>FairPoint Communications, Inc.</td>\n",
" <td>130471</td>\n",
" <td>FairPoint Communications, Inc.</td>\n",
" <td>CA</td>\n",
" <td>60730206011016</td>\n",
" <td>10</td>\n",
" <td>1</td>\n",
" <td>15.0</td>\n",
" <td>1.000</td>\n",
" <td>1</td>\n",
" <td>15.0</td>\n",
" <td>1.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>140844</td>\n",
" <td>15905</td>\n",
" <td>14710388</td>\n",
" <td>FairPoint Communications Missouri, Inc.</td>\n",
" <td>Fairpoint Communications</td>\n",
" <td>FairPoint Communications, Inc.</td>\n",
" <td>130471</td>\n",
" <td>FairPoint Communications, Inc.</td>\n",
" <td>CA</td>\n",
" <td>60730206011016</td>\n",
" <td>11</td>\n",
" <td>1</td>\n",
" <td>15.0</td>\n",
" <td>1.000</td>\n",
" <td>1</td>\n",
" <td>15.0</td>\n",
" <td>1.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>411721</td>\n",
" <td>16009</td>\n",
" <td>1551837</td>\n",
" <td>Kerman Telephone Co</td>\n",
" <td>Sebastian - Audeamus</td>\n",
" <td>Sebastian Enterprises</td>\n",
" <td>131173</td>\n",
" <td>Sebastian Enterprises</td>\n",
" <td>CA</td>\n",
" <td>60190082003029</td>\n",
" <td>70</td>\n",
" <td>1</td>\n",
" <td>1.5</td>\n",
" <td>0.768</td>\n",
" <td>1</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>411722</td>\n",
" <td>16009</td>\n",
" <td>1551837</td>\n",
" <td>Kerman Telephone Co</td>\n",
" <td>Sebastian - Audeamus</td>\n",
" <td>Sebastian Enterprises</td>\n",
" <td>131173</td>\n",
" <td>Sebastian Enterprises</td>\n",
" <td>CA</td>\n",
" <td>60190082003015</td>\n",
" <td>70</td>\n",
" <td>1</td>\n",
" <td>1.5</td>\n",
" <td>0.768</td>\n",
" <td>1</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>411723</td>\n",
" <td>16009</td>\n",
" <td>1551837</td>\n",
" <td>Kerman Telephone Co</td>\n",
" <td>Sebastian - Audeamus</td>\n",
" <td>Sebastian Enterprises</td>\n",
" <td>131173</td>\n",
" <td>Sebastian Enterprises</td>\n",
" <td>CA</td>\n",
" <td>60190039002011</td>\n",
" <td>70</td>\n",
" <td>1</td>\n",
" <td>1.5</td>\n",
" <td>0.768</td>\n",
" <td>1</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" LogRecNo Provider_Id FRN ProviderName \\\n",
"0 139883 15905 14710388 FairPoint Communications Missouri, Inc. \n",
"1 140844 15905 14710388 FairPoint Communications Missouri, Inc. \n",
"2 411721 16009 1551837 Kerman Telephone Co \n",
"3 411722 16009 1551837 Kerman Telephone Co \n",
"4 411723 16009 1551837 Kerman Telephone Co \n",
"\n",
" DBAName HoldingCompanyName HocoNum \\\n",
"0 Fairpoint Communications FairPoint Communications, Inc. 130471 \n",
"1 Fairpoint Communications FairPoint Communications, Inc. 130471 \n",
"2 Sebastian - Audeamus Sebastian Enterprises 131173 \n",
"3 Sebastian - Audeamus Sebastian Enterprises 131173 \n",
"4 Sebastian - Audeamus Sebastian Enterprises 131173 \n",
"\n",
" HocoFinal StateAbbr BlockCode TechCode \\\n",
"0 FairPoint Communications, Inc. CA 60730206011016 10 \n",
"1 FairPoint Communications, Inc. CA 60730206011016 11 \n",
"2 Sebastian Enterprises CA 60190082003029 70 \n",
"3 Sebastian Enterprises CA 60190082003015 70 \n",
"4 Sebastian Enterprises CA 60190039002011 70 \n",
"\n",
" Consumer MaxAdDown MaxAdUp Business MaxCIRDown MaxCIRUp \n",
"0 1 15.0 1.000 1 15.0 1.0 \n",
"1 1 15.0 1.000 1 15.0 1.0 \n",
"2 1 1.5 0.768 1 0.0 0.0 \n",
"3 1 1.5 0.768 1 0.0 0.0 \n",
"4 1 1.5 0.768 1 0.0 0.0 "
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ca_dec_15_df.head()\n"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"# OK so now we have downloaded the block SHP file from the TIGER site\n",
"# https://www.census.gov/cgi-bin/geo/shapefiles/index.php?year=2018&layergroup=Blocks+%282010%29\n",
"\n",
"%matplotlib inline\n",
"census_blocks_gis = gpd.read_file(\"tl_2018_06_tabblock10.shp\")"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"image/svg+xml": [
"<svg xmlns=\"http://www.w3.org/2000/svg\" xmlns:xlink=\"http://www.w3.org/1999/xlink\" width=\"100.0\" height=\"100.0\" viewBox=\"-121.28782592 38.89186608 0.0013748400000110905 0.0013718399999973485\" preserveAspectRatio=\"xMinYMin meet\"><g transform=\"matrix(1,0,0,-1,0,77.78510399999999)\"><path fill-rule=\"evenodd\" fill=\"#66cc99\" stroke=\"#555555\" stroke-width=\"2.749680000022181e-05\" opacity=\"0.6\" d=\"M -121.287775,38.893172 L -121.287522,38.893175 L -121.286766,38.893183 L -121.286514,38.893187 L -121.28651099999999,38.892933 L -121.28650400000001,38.892171 L -121.286502,38.891918 L -121.286755,38.891917 L -121.287514,38.891917 L -121.287768,38.891917 L -121.287769,38.892168 L -121.287773,38.892921 L -121.287775,38.893172 z\" /></g></svg>"
],
"text/plain": [
"<shapely.geometry.polygon.Polygon at 0x11d4566d8>"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Let's make sure that there are objects\n",
"census_blocks_gis.geometry[0]"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" % Total % Received % Xferd Average Speed Time Time Time Current\n",
" Dload Upload Total Spent Left Speed\n",
"100 1007M 100 1007M 0 0 15.1M 0 0:01:06 0:01:06 --:--:-- 12.3M13 132M 0 0 17.3M 0 0:00:57 0:00:07 0:00:50 20.2M\n"
]
}
],
"source": [
"# Next let's get the address data\n",
"add_west_url = \"https://s3.amazonaws.com/data.openaddresses.io/openaddr-collected-us_west.zip\"\n",
"!curl -LO \"$add_west_url\"\n"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Archive: openaddr-collected-us_west.zip\n",
" inflating: README.txt \n",
" inflating: us/ca/calaveras.vrt \n",
" inflating: us/ca/calaveras.csv \n",
" inflating: summary/us/ca/calaveras-summary.csv \n",
" inflating: summary/us/ca/calaveras-summary.vrt \n",
" inflating: us/ca/shasta.vrt \n",
" inflating: us/ca/shasta.csv \n",
" inflating: summary/us/ca/shasta-summary.csv \n",
" inflating: summary/us/ca/shasta-summary.vrt \n",
" inflating: us/ca/city_of_san_diego.vrt \n",
" inflating: us/ca/city_of_san_diego.csv \n",
" inflating: summary/us/ca/city_of_san_diego-summary.csv \n",
" inflating: summary/us/ca/city_of_san_diego-summary.vrt \n",
" inflating: us/ca/city_of_huntington_beach.vrt \n",
" inflating: us/ca/city_of_huntington_beach.csv \n",
" inflating: summary/us/ca/city_of_huntington_beach-summary.csv \n",
" inflating: summary/us/ca/city_of_huntington_beach-summary.vrt \n",
" inflating: us/ca/city_of_santa_clara.vrt \n",
" inflating: us/ca/city_of_santa_clara.csv \n",
" inflating: summary/us/ca/city_of_santa_clara-summary.csv \n",
" inflating: summary/us/ca/city_of_santa_clara-summary.vrt \n",
" inflating: us/ca/city_of_san_juan_capistrano.vrt \n",
" inflating: us/ca/city_of_san_juan_capistrano.csv \n",
" inflating: summary/us/ca/city_of_san_juan_capistrano-summary.csv \n",
" inflating: summary/us/ca/city_of_san_juan_capistrano-summary.vrt \n",
" inflating: us/ca/imperial.vrt \n",
" inflating: us/ca/imperial.csv \n",
" inflating: summary/us/ca/imperial-summary.csv \n",
" inflating: summary/us/ca/imperial-summary.vrt \n",
" inflating: us/ca/modoc.vrt \n",
" inflating: us/ca/modoc.csv \n",
" inflating: summary/us/ca/modoc-summary.csv \n",
" inflating: summary/us/ca/modoc-summary.vrt \n",
" inflating: us/ca/alpine.vrt \n",
" inflating: us/ca/alpine.csv \n",
" inflating: summary/us/ca/alpine-summary.csv \n",
" inflating: summary/us/ca/alpine-summary.vrt \n",
" inflating: us/ca/city_of_fullerton.vrt \n",
" inflating: us/ca/city_of_fullerton.csv \n",
" inflating: summary/us/ca/city_of_fullerton-summary.csv \n",
" inflating: summary/us/ca/city_of_fullerton-summary.vrt \n",
" inflating: us/ca/city_of_garden_grove.vrt \n",
" inflating: us/ca/city_of_garden_grove.csv \n",
" inflating: summary/us/ca/city_of_garden_grove-summary.csv \n",
" inflating: summary/us/ca/city_of_garden_grove-summary.vrt \n",
" inflating: us/ak/haines.vrt \n",
" inflating: us/ak/haines.csv \n",
" inflating: summary/us/ak/haines-summary.csv \n",
" inflating: summary/us/ak/haines-summary.vrt \n",
" inflating: us/wa/franklin.vrt \n",
" inflating: us/wa/franklin.csv \n",
" inflating: summary/us/wa/franklin-summary.csv \n",
" inflating: summary/us/wa/franklin-summary.vrt \n",
" inflating: us/wy/lincoln.vrt \n",
" inflating: us/wy/lincoln.csv \n",
" inflating: summary/us/wy/lincoln-summary.csv \n",
" inflating: summary/us/wy/lincoln-summary.vrt \n",
" inflating: us/ut/city_of_morgan.vrt \n",
" inflating: us/ut/city_of_morgan.csv \n",
" inflating: summary/us/ut/city_of_morgan-summary.csv \n",
" inflating: summary/us/ut/city_of_morgan-summary.vrt \n",
" inflating: us/or/wheeler.vrt \n",
" inflating: us/or/wheeler.csv \n",
" inflating: summary/us/or/wheeler-summary.csv \n",
" inflating: summary/us/or/wheeler-summary.vrt \n",
" inflating: us/nm/de_baca.vrt \n",
" inflating: us/nm/de_baca.csv \n",
" inflating: summary/us/nm/de_baca-summary.csv \n",
" inflating: summary/us/nm/de_baca-summary.vrt \n",
" inflating: us/id/custer.vrt \n",
" inflating: us/id/custer.csv \n",
" inflating: summary/us/id/custer-summary.csv \n",
" inflating: summary/us/id/custer-summary.vrt \n",
" inflating: us/ak/yakutat_borough.vrt \n",
" inflating: us/ak/yakutat_borough.csv \n",
" inflating: summary/us/ak/yakutat_borough-summary.csv \n",
" inflating: summary/us/ak/yakutat_borough-summary.vrt \n",
" inflating: us/or/sherman.vrt \n",
" inflating: us/or/sherman.csv \n",
" inflating: summary/us/or/sherman-summary.csv \n",
" inflating: summary/us/or/sherman-summary.vrt \n",
" inflating: us/or/grant.vrt \n",
" inflating: us/or/grant.csv \n",
" inflating: summary/us/or/grant-summary.csv \n",
" inflating: summary/us/or/grant-summary.vrt \n",
" inflating: us/mt/wibaux.vrt \n",
" inflating: us/mt/wibaux.csv \n",
" inflating: summary/us/mt/wibaux-summary.csv \n",
" inflating: summary/us/mt/wibaux-summary.vrt \n",
" inflating: us/mt/treasure.vrt \n",
" inflating: us/mt/treasure.csv \n",
" inflating: summary/us/mt/treasure-summary.csv \n",
" inflating: summary/us/mt/treasure-summary.vrt \n",
" inflating: us/mt/golden_valley.vrt \n",
" inflating: us/mt/golden_valley.csv \n",
" inflating: summary/us/mt/golden_valley-summary.csv \n",
" inflating: summary/us/mt/golden_valley-summary.vrt \n",
" inflating: us/co/sedgwick.vrt \n",
" inflating: us/co/sedgwick.csv \n",
" inflating: summary/us/co/sedgwick-summary.csv \n",
" inflating: summary/us/co/sedgwick-summary.vrt \n",
" inflating: us/co/rio_blanco.vrt \n",
" inflating: us/co/rio_blanco.csv \n",
" inflating: summary/us/co/rio_blanco-summary.csv \n",
" inflating: summary/us/co/rio_blanco-summary.vrt \n",
" inflating: us/ak/kodiak_island_borough.vrt \n",
" inflating: us/ak/kodiak_island_borough.csv \n",
" inflating: summary/us/ak/kodiak_island_borough-summary.csv \n",
" inflating: summary/us/ak/kodiak_island_borough-summary.vrt \n",
" inflating: us/wy/sublette.vrt \n",
" inflating: us/wy/sublette.csv \n",
" inflating: summary/us/wy/sublette-summary.csv \n",
" inflating: summary/us/wy/sublette-summary.vrt \n",
" inflating: us/wy/park.vrt \n",
" inflating: us/wy/park.csv \n",
" inflating: summary/us/wy/park-summary.csv \n",
" inflating: summary/us/wy/park-summary.vrt \n",
" inflating: us/wa/city_of_snohomish.vrt \n",
" inflating: us/wa/city_of_snohomish.csv \n",
" inflating: summary/us/wa/city_of_snohomish-summary.csv \n",
" inflating: summary/us/wa/city_of_snohomish-summary.vrt \n",
" inflating: us/co/pitkin.vrt \n",
" inflating: us/co/pitkin.csv \n",
" inflating: summary/us/co/pitkin-summary.csv \n",
" inflating: summary/us/co/pitkin-summary.vrt \n",
" inflating: us/co/logan.vrt \n",
" inflating: us/co/logan.csv \n",
" inflating: summary/us/co/logan-summary.csv \n",
" inflating: summary/us/co/logan-summary.vrt \n",
" inflating: us/wy/city_of_sundance.vrt \n",
" inflating: us/wy/city_of_sundance.csv \n",
" inflating: summary/us/wy/city_of_sundance-summary.csv \n",
" inflating: summary/us/wy/city_of_sundance-summary.vrt \n",
" inflating: us/or/umatilla.vrt \n",
" inflating: us/or/umatilla.csv \n",
" inflating: summary/us/or/umatilla-summary.csv \n",
" inflating: summary/us/or/umatilla-summary.vrt \n",
" inflating: us/or/jefferson.vrt \n",
" inflating: us/or/jefferson.csv \n",
" inflating: summary/us/or/jefferson-summary.csv \n",
" inflating: summary/us/or/jefferson-summary.vrt \n",
" inflating: us/mt/wheatland.vrt \n",
" inflating: us/mt/wheatland.csv \n",
" inflating: summary/us/mt/wheatland-summary.csv \n",
" inflating: summary/us/mt/wheatland-summary.vrt \n",
" inflating: us/mt/prairie.vrt \n",
" inflating: us/mt/prairie.csv \n",
" inflating: summary/us/mt/prairie-summary.csv \n",
" inflating: summary/us/mt/prairie-summary.vrt \n",
" inflating: us/mt/fallon.vrt \n",
" inflating: us/mt/fallon.csv \n",
" inflating: summary/us/mt/fallon-summary.csv \n",
" inflating: summary/us/mt/fallon-summary.vrt \n",
" inflating: us/co/city_of_frederick.vrt \n",
" inflating: us/co/city_of_frederick.csv \n",
" inflating: summary/us/co/city_of_frederick-summary.csv \n",
" inflating: summary/us/co/city_of_frederick-summary.vrt \n",
" inflating: us/wa/ferry.vrt \n",
" inflating: us/wa/ferry.csv \n",
" inflating: summary/us/wa/ferry-summary.csv \n",
" inflating: summary/us/wa/ferry-summary.vrt \n",
" inflating: us/mt/sweet_grass.vrt \n",
" inflating: us/mt/sweet_grass.csv \n",
" inflating: summary/us/mt/sweet_grass-summary.csv \n",
" inflating: summary/us/mt/sweet_grass-summary.vrt \n",
" inflating: us/mt/petroleum.vrt \n",
" inflating: us/mt/petroleum.csv \n",
" inflating: summary/us/mt/petroleum-summary.csv \n",
" inflating: summary/us/mt/petroleum-summary.vrt \n",
" inflating: us/mt/daniels.vrt \n",
" inflating: us/mt/daniels.csv \n",
" inflating: summary/us/mt/daniels-summary.csv \n",
" inflating: summary/us/mt/daniels-summary.vrt \n",
" inflating: us/id/clearwater.vrt \n",
" inflating: us/id/clearwater.csv \n",
" inflating: summary/us/id/clearwater-summary.csv \n",
" inflating: summary/us/id/clearwater-summary.vrt \n",
" inflating: us/co/archuleta.vrt \n",
" inflating: us/co/archuleta.csv \n",
" inflating: summary/us/co/archuleta-summary.csv \n",
" inflating: summary/us/co/archuleta-summary.vrt \n",
" inflating: us/nv/eureka.vrt \n",
" inflating: us/nv/eureka.csv \n",
" inflating: summary/us/nv/eureka-summary.csv \n",
" inflating: summary/us/nv/eureka-summary.vrt \n",
" inflating: us/nm/torrance.vrt \n",
" inflating: us/nm/torrance.csv \n",
" inflating: summary/us/nm/torrance-summary.csv \n",
" inflating: summary/us/nm/torrance-summary.vrt \n",
" inflating: us/wy/teton.vrt \n",
" inflating: us/wy/teton.csv \n",
" inflating: summary/us/wy/teton-summary.csv \n",
" inflating: summary/us/wy/teton-summary.vrt \n",
" inflating: us/or/curry.vrt \n",
" inflating: us/or/curry.csv \n",
" inflating: summary/us/or/curry-summary.csv \n",
" inflating: summary/us/or/curry-summary.vrt \n",
" inflating: us/mt/meagher.vrt \n",
" inflating: us/mt/meagher.csv \n",
" inflating: summary/us/mt/meagher-summary.csv \n",
" inflating: summary/us/mt/meagher-summary.vrt \n",
" inflating: us/mt/mccone.vrt \n",
" inflating: us/mt/mccone.csv \n",
" inflating: summary/us/mt/mccone-summary.csv \n",
" inflating: summary/us/mt/mccone-summary.vrt \n",
" inflating: us/ca/plumas.vrt \n",
" inflating: us/ca/plumas.csv \n",
" inflating: summary/us/ca/plumas-summary.csv \n",
" inflating: summary/us/ca/plumas-summary.vrt \n",
" inflating: us/or/baker.vrt \n",
" inflating: us/or/baker.csv \n",
" inflating: summary/us/or/baker-summary.csv \n",
" inflating: summary/us/or/baker-summary.vrt \n",
" inflating: us/or/clatsop.vrt \n",
" inflating: us/or/clatsop.csv \n",
" inflating: summary/us/or/clatsop-summary.csv \n",
" inflating: summary/us/or/clatsop-summary.vrt \n",
" inflating: us/nv/lander.vrt \n",
" inflating: us/nv/lander.csv \n",
" inflating: summary/us/nv/lander-summary.csv \n",
" inflating: summary/us/nv/lander-summary.vrt \n",
" inflating: us/nm/bernalillo.vrt \n",
" inflating: us/nm/bernalillo.csv \n",
" inflating: summary/us/nm/bernalillo-summary.csv \n",
" inflating: summary/us/nm/bernalillo-summary.vrt \n",
" inflating: us/nm/luna.vrt \n",
" inflating: us/nm/luna.csv \n",
" inflating: summary/us/nm/luna-summary.csv \n",
" inflating: summary/us/nm/luna-summary.vrt \n",
" inflating: us/mt/mineral.vrt \n",
" inflating: us/mt/mineral.csv \n",
" inflating: summary/us/mt/mineral-summary.csv \n",
" inflating: summary/us/mt/mineral-summary.vrt \n",
" inflating: us/mt/broadwater.vrt \n",
" inflating: us/mt/broadwater.csv \n",
" inflating: summary/us/mt/broadwater-summary.csv \n",
" inflating: summary/us/mt/broadwater-summary.vrt \n",
" inflating: us/ca/siskiyou.vrt \n",
" inflating: us/ca/siskiyou.csv \n",
" inflating: summary/us/ca/siskiyou-summary.csv \n",
" inflating: summary/us/ca/siskiyou-summary.vrt \n",
" inflating: us/mt/sheridan.vrt \n",
" inflating: us/mt/sheridan.csv \n",
" inflating: summary/us/mt/sheridan-summary.csv \n",
" inflating: summary/us/mt/sheridan-summary.vrt \n",
" inflating: us/mt/dawson.vrt \n",
" inflating: us/mt/dawson.csv \n",
" inflating: summary/us/mt/dawson-summary.csv \n",
" inflating: summary/us/mt/dawson-summary.vrt \n",
" inflating: us/co/city_of_vail.vrt \n",
" inflating: us/co/city_of_vail.csv \n",
" inflating: summary/us/co/city_of_vail-summary.csv \n",
" inflating: summary/us/co/city_of_vail-summary.vrt \n",
" inflating: us/mt/toole.vrt \n",
" inflating: us/mt/toole.csv \n",
" inflating: summary/us/mt/toole-summary.csv \n",
" inflating: summary/us/mt/toole-summary.vrt \n",
" inflating: us/or/malheur.vrt \n",
" inflating: us/or/malheur.csv \n",
" inflating: summary/us/or/malheur-summary.csv \n",
" inflating: summary/us/or/malheur-summary.vrt \n",
" inflating: us/or/coos.vrt \n",
" inflating: us/or/coos.csv \n",
" inflating: summary/us/or/coos-summary.csv \n",
" inflating: summary/us/or/coos-summary.vrt \n",
" inflating: us/nm/los_alamos.vrt \n",
" inflating: us/nm/los_alamos.csv \n",
" inflating: summary/us/nm/los_alamos-summary.csv \n",
" inflating: summary/us/nm/los_alamos-summary.vrt \n",
" inflating: us/wy/converse.vrt \n",
" inflating: us/wy/converse.csv \n",
" inflating: summary/us/wy/converse-summary.csv \n",
" inflating: summary/us/wy/converse-summary.vrt \n",
" inflating: us/wa/asotin.vrt \n",
" inflating: us/wa/asotin.csv \n",
" inflating: summary/us/wa/asotin-summary.csv \n",
" inflating: summary/us/wa/asotin-summary.vrt \n",
" inflating: us/or/benton.vrt \n",
" inflating: us/or/benton.csv \n",
" inflating: summary/us/or/benton-summary.csv \n",
" inflating: summary/us/or/benton-summary.vrt \n",
" inflating: us/mt/rosebud.vrt \n",
" inflating: us/mt/rosebud.csv \n",
" inflating: summary/us/mt/rosebud-summary.csv \n",
" inflating: summary/us/mt/rosebud-summary.vrt \n",
" inflating: us/wa/douglas.vrt \n",
" inflating: us/wa/douglas.csv \n",
" inflating: summary/us/wa/douglas-summary.csv \n",
" inflating: summary/us/wa/douglas-summary.vrt \n",
" inflating: us/mt/pondera.vrt \n",
" inflating: us/mt/pondera.csv \n",
" inflating: summary/us/mt/pondera-summary.csv \n",
" inflating: summary/us/mt/pondera-summary.vrt \n",
" inflating: us/mt/liberty.vrt \n",
" inflating: us/mt/liberty.csv \n",
" inflating: summary/us/mt/liberty-summary.csv \n",
" inflating: summary/us/mt/liberty-summary.vrt \n",
" inflating: us/co/city_of_erie.vrt \n",
" inflating: us/co/city_of_erie.csv \n",
" inflating: summary/us/co/city_of_erie-summary.csv \n",
" inflating: summary/us/co/city_of_erie-summary.vrt \n",
" inflating: us/wy/fremont.vrt \n",
" inflating: us/wy/fremont.csv \n",
" inflating: summary/us/wy/fremont-summary.csv \n",
" inflating: summary/us/wy/fremont-summary.vrt \n",
" inflating: us/mt/granite.vrt \n",
" inflating: us/mt/granite.csv \n",
" inflating: summary/us/mt/granite-summary.csv \n",
" inflating: summary/us/mt/granite-summary.vrt \n",
" inflating: us/id/fremont.vrt \n",
" inflating: us/id/fremont.csv \n",
" inflating: summary/us/id/fremont-summary.csv \n",
" inflating: summary/us/id/fremont-summary.vrt \n",
" inflating: us/ak/ketchikan.vrt \n",
" inflating: us/ak/ketchikan.csv \n",
" inflating: summary/us/ak/ketchikan-summary.csv \n",
" inflating: summary/us/ak/ketchikan-summary.vrt \n",
" inflating: us/or/hood_river.vrt \n",
" inflating: us/or/hood_river.csv \n",
" inflating: summary/us/or/hood_river-summary.csv \n",
" inflating: summary/us/or/hood_river-summary.vrt \n",
" inflating: us/mt/powell.vrt \n",
" inflating: us/mt/powell.csv \n",
" inflating: summary/us/mt/powell-summary.csv \n",
" inflating: summary/us/mt/powell-summary.vrt \n",
" inflating: us/mt/powder_river.vrt \n",
" inflating: us/mt/powder_river.csv \n",
" inflating: summary/us/mt/powder_river-summary.csv \n",
" inflating: summary/us/mt/powder_river-summary.vrt \n",
" inflating: us/ca/trinity.vrt \n",
" inflating: us/ca/trinity.csv \n",
" inflating: summary/us/ca/trinity-summary.csv \n",
" inflating: summary/us/ca/trinity-summary.vrt \n",
" inflating: us/ca/san_benito.vrt \n",
" inflating: us/ca/san_benito.csv \n",
" inflating: summary/us/ca/san_benito-summary.csv \n",
" inflating: summary/us/ca/san_benito-summary.vrt \n",
" inflating: us/nv/lincoln.vrt \n",
" inflating: us/nv/lincoln.csv \n",
" inflating: summary/us/nv/lincoln-summary.csv \n",
" inflating: summary/us/nv/lincoln-summary.vrt \n",
" inflating: us/nm/lincoln.vrt \n",
" inflating: us/nm/lincoln.csv \n",
" inflating: summary/us/nm/lincoln-summary.csv \n",
" inflating: summary/us/nm/lincoln-summary.vrt \n",
" inflating: us/mt/musselshell.vrt \n",
" inflating: us/mt/musselshell.csv \n",
" inflating: summary/us/mt/musselshell-summary.csv \n",
" inflating: summary/us/mt/musselshell-summary.vrt \n",
" inflating: us/co/sanmiguel.vrt \n",
" inflating: us/co/sanmiguel.csv \n",
" inflating: summary/us/co/sanmiguel-summary.csv \n",
" inflating: summary/us/co/sanmiguel-summary.vrt \n",
" inflating: us/co/routt.vrt \n",
" inflating: us/co/routt.csv \n",
" inflating: summary/us/co/routt-summary.csv \n",
" inflating: summary/us/co/routt-summary.vrt \n",
" inflating: us/wy/goshen.vrt \n",
" inflating: us/wy/goshen.csv \n",
" inflating: summary/us/wy/goshen-summary.csv \n",
" inflating: summary/us/wy/goshen-summary.vrt \n",
" inflating: us/or/city_of_corvallis.vrt \n",
" inflating: us/or/city_of_corvallis.csv \n",
" inflating: summary/us/or/city_of_corvallis-summary.csv \n",
" inflating: summary/us/or/city_of_corvallis-summary.vrt \n",
" inflating: us/or/wasco.vrt \n",
" inflating: us/or/wasco.csv \n",
" inflating: summary/us/or/wasco-summary.csv \n",
" inflating: summary/us/or/wasco-summary.vrt \n",
" inflating: us/ca/inyo.vrt \n",
" inflating: us/ca/inyo.csv \n",
" inflating: summary/us/ca/inyo-summary.csv \n",
" inflating: summary/us/ca/inyo-summary.vrt \n",
" inflating: us/mt/jefferson.vrt \n",
" inflating: us/mt/jefferson.csv \n",
" inflating: summary/us/mt/jefferson-summary.csv \n",
" inflating: summary/us/mt/jefferson-summary.vrt \n",
" inflating: us/mt/beaverhead.vrt \n",
" inflating: us/mt/beaverhead.csv \n",
" inflating: summary/us/mt/beaverhead-summary.csv \n",
" inflating: summary/us/mt/beaverhead-summary.vrt \n",
" inflating: us/nm/taos.vrt \n",
" inflating: us/nm/taos.csv \n",
" inflating: summary/us/nm/taos-summary.csv \n",
" inflating: summary/us/nm/taos-summary.vrt \n",
" inflating: us/mt/roosevelt.vrt \n",
" inflating: us/mt/roosevelt.csv \n",
" inflating: summary/us/mt/roosevelt-summary.csv \n",
" inflating: summary/us/mt/roosevelt-summary.vrt \n",
" inflating: us/mt/phillips.vrt \n",
" inflating: us/mt/phillips.csv \n",
" inflating: summary/us/mt/phillips-summary.csv \n",
" inflating: summary/us/mt/phillips-summary.vrt \n",
" inflating: us/co/gunnison.vrt \n",
" inflating: us/co/gunnison.csv \n",
" inflating: summary/us/co/gunnison-summary.csv \n",
" inflating: summary/us/co/gunnison-summary.vrt \n",
" inflating: us/co/la_plata.vrt \n",
" inflating: us/co/la_plata.csv \n",
" inflating: summary/us/co/la_plata-summary.csv \n",
" inflating: summary/us/co/la_plata-summary.vrt \n",
" inflating: us/ca/colusa.vrt \n",
" inflating: us/ca/colusa.csv \n",
" inflating: summary/us/ca/colusa-summary.csv \n",
" inflating: summary/us/ca/colusa-summary.vrt \n",
" inflating: us/ca/del_norte.vrt \n",
" inflating: us/ca/del_norte.csv \n",
" inflating: summary/us/ca/del_norte-summary.csv \n",
" inflating: summary/us/ca/del_norte-summary.vrt \n",
" inflating: us/wa/mason.vrt \n",
" inflating: us/wa/mason.csv \n",
" inflating: summary/us/wa/mason-summary.csv \n",
" inflating: summary/us/wa/mason-summary.vrt \n",
" inflating: us/ca/city_of_cupertino.vrt \n",
" inflating: us/ca/city_of_cupertino.csv \n",
" inflating: summary/us/ca/city_of_cupertino-summary.csv \n",
" inflating: summary/us/ca/city_of_cupertino-summary.vrt \n",
" inflating: us/ca/amador.vrt \n",
" inflating: us/ca/amador.csv \n",
" inflating: summary/us/ca/amador-summary.csv \n",
" inflating: summary/us/ca/amador-summary.vrt \n",
" inflating: us/mt/custer.vrt \n",
" inflating: us/mt/custer.csv \n",
" inflating: summary/us/mt/custer-summary.csv \n",
" inflating: summary/us/mt/custer-summary.vrt \n",
" inflating: us/wy/carbon.vrt \n",
" inflating: us/wy/carbon.csv \n",
" inflating: summary/us/wy/carbon-summary.csv \n",
" inflating: summary/us/wy/carbon-summary.vrt \n",
" inflating: us/nm/dona_ana-2.vrt \n",
" inflating: us/nm/dona_ana-2.csv \n",
" inflating: summary/us/nm/dona_ana-2-summary.csv \n",
" inflating: summary/us/nm/dona_ana-2-summary.vrt \n",
" inflating: us/mt/teton.vrt \n",
" inflating: us/mt/teton.csv \n",
" inflating: summary/us/mt/teton-summary.csv \n",
" inflating: summary/us/mt/teton-summary.vrt \n",
" inflating: us/mt/judith_basin.vrt \n",
" inflating: us/mt/judith_basin.csv \n",
" inflating: summary/us/mt/judith_basin-summary.csv \n",
" inflating: summary/us/mt/judith_basin-summary.vrt \n",
" inflating: us/mt/blaine.vrt \n",
" inflating: us/mt/blaine.csv \n",
" inflating: summary/us/mt/blaine-summary.csv \n",
" inflating: summary/us/mt/blaine-summary.vrt \n",
" inflating: us/wa/jefferson.vrt \n",
" inflating: us/wa/jefferson.csv \n",
" inflating: summary/us/wa/jefferson-summary.csv \n",
" inflating: summary/us/wa/jefferson-summary.vrt \n",
" inflating: us/mt/richland.vrt \n",
" inflating: us/mt/richland.csv \n",
" inflating: summary/us/mt/richland-summary.csv \n",
" inflating: summary/us/mt/richland-summary.vrt \n",
" inflating: us/wa/city_of_pasco.vrt \n",
" inflating: us/wa/city_of_pasco.csv \n",
" inflating: summary/us/wa/city_of_pasco-summary.csv \n",
" inflating: summary/us/wa/city_of_pasco-summary.vrt \n",
" inflating: us/mt/glacier.vrt \n",
" inflating: us/mt/glacier.csv \n",
" inflating: summary/us/mt/glacier-summary.csv \n",
" inflating: summary/us/mt/glacier-summary.vrt \n",
" inflating: us/mt/madison.vrt \n",
" inflating: us/mt/madison.csv \n",
" inflating: summary/us/mt/madison-summary.csv \n",
" inflating: summary/us/mt/madison-summary.vrt \n",
" inflating: us/mt/garfield.vrt \n",
" inflating: us/mt/garfield.csv \n",
" inflating: summary/us/mt/garfield-summary.csv \n",
" inflating: summary/us/mt/garfield-summary.vrt \n",
" inflating: us/az/cochise.vrt \n",
" inflating: us/az/cochise.csv \n",
" inflating: summary/us/az/cochise-summary.csv \n",
" inflating: summary/us/az/cochise-summary.vrt \n",
" inflating: us/mt/big_horn.vrt \n",
" inflating: us/mt/big_horn.csv \n",
" inflating: summary/us/mt/big_horn-summary.csv \n",
" inflating: summary/us/mt/big_horn-summary.vrt \n",
" inflating: us/id/nez_perce.vrt \n",
" inflating: us/id/nez_perce.csv \n",
" inflating: summary/us/id/nez_perce-summary.csv \n",
" inflating: summary/us/id/nez_perce-summary.vrt \n",
" inflating: us/wa/san_juan.vrt \n",
" inflating: us/wa/san_juan.csv \n",
" inflating: summary/us/wa/san_juan-summary.csv \n",
" inflating: summary/us/wa/san_juan-summary.vrt \n",
" inflating: us/ca/lassen.vrt \n",
" inflating: us/ca/lassen.csv \n",
" inflating: summary/us/ca/lassen-summary.csv \n",
" inflating: summary/us/ca/lassen-summary.vrt \n",
" inflating: us/mt/carbon.vrt \n",
" inflating: us/mt/carbon.csv \n",
" inflating: summary/us/mt/carbon-summary.csv \n",
" inflating: summary/us/mt/carbon-summary.vrt \n",
" inflating: us/ca/yuba.vrt \n",
" inflating: us/ca/yuba.csv \n",
" inflating: summary/us/ca/yuba-summary.csv \n",
" inflating: summary/us/ca/yuba-summary.vrt \n",
" inflating: us/wa/city_of_bothell.vrt \n",
" inflating: us/wa/city_of_bothell.csv \n",
" inflating: summary/us/wa/city_of_bothell-summary.csv \n",
" inflating: summary/us/wa/city_of_bothell-summary.vrt \n",
" inflating: us/co/summit.vrt \n",
" inflating: us/co/summit.csv \n",
" inflating: summary/us/co/summit-summary.csv \n",
" inflating: summary/us/co/summit-summary.vrt \n",
" inflating: us/ca/glenn.vrt \n",
" inflating: us/ca/glenn.csv \n",
" inflating: summary/us/ca/glenn-summary.csv \n",
" inflating: summary/us/ca/glenn-summary.vrt \n",
" inflating: us/nm/city_of_santa_fe.vrt \n",
" inflating: us/nm/city_of_santa_fe.csv \n",
" inflating: summary/us/nm/city_of_santa_fe-summary.csv \n",
" inflating: summary/us/nm/city_of_santa_fe-summary.vrt \n",
" inflating: us/mt/hill.vrt \n",
" inflating: us/mt/hill.csv \n",
" inflating: summary/us/mt/hill-summary.csv \n",
" inflating: summary/us/mt/hill-summary.vrt \n",
" inflating: us/mt/deer_lodge.vrt \n",
" inflating: us/mt/deer_lodge.csv \n",
" inflating: summary/us/mt/deer_lodge-summary.csv \n",
" inflating: summary/us/mt/deer_lodge-summary.vrt \n",
" inflating: us/ca/berkeley.vrt \n",
" inflating: us/ca/berkeley.csv \n",
" inflating: summary/us/ca/berkeley-summary.csv \n",
" inflating: summary/us/ca/berkeley-summary.vrt \n",
" inflating: us/co/park.vrt \n",
" inflating: us/co/park.csv \n",
" inflating: summary/us/co/park-summary.csv \n",
" inflating: summary/us/co/park-summary.vrt \n",
" inflating: us/wa/city_of_richland.vrt \n",
" inflating: us/wa/city_of_richland.csv \n",
" inflating: summary/us/wa/city_of_richland-summary.csv \n",
" inflating: summary/us/wa/city_of_richland-summary.vrt \n",
" inflating: us/or/city_of_albany.vrt \n",
" inflating: us/or/city_of_albany.csv \n",
" inflating: summary/us/or/city_of_albany-summary.csv \n",
" inflating: summary/us/or/city_of_albany-summary.vrt \n",
" inflating: us/mt/chouteau.vrt \n",
" inflating: us/mt/chouteau.csv \n",
" inflating: summary/us/mt/chouteau-summary.csv \n",
" inflating: summary/us/mt/chouteau-summary.vrt \n",
" inflating: us/wa/pend_oreille.vrt \n",
" inflating: us/wa/pend_oreille.csv \n",
" inflating: summary/us/wa/pend_oreille-summary.csv \n",
" inflating: summary/us/wa/pend_oreille-summary.vrt \n",
" inflating: us/or/douglas.vrt \n",
" inflating: us/or/douglas.csv \n",
" inflating: summary/us/or/douglas-summary.csv \n",
" inflating: summary/us/or/douglas-summary.vrt \n",
" inflating: us/wy/albany.vrt \n",
" inflating: us/wy/albany.csv \n",
" inflating: summary/us/wy/albany-summary.csv \n",
" inflating: summary/us/wy/albany-summary.vrt \n",
" inflating: us/ut/box_elder.vrt \n",
" inflating: us/ut/box_elder.csv \n",
" inflating: summary/us/ut/box_elder-summary.csv \n",
" inflating: summary/us/ut/box_elder-summary.vrt \n",
" inflating: us/mt/silverbow.vrt \n",
" inflating: us/mt/silverbow.csv \n",
" inflating: summary/us/mt/silverbow-summary.csv \n",
" inflating: summary/us/mt/silverbow-summary.vrt \n",
" inflating: us/ca/sutter.vrt \n",
" inflating: us/ca/sutter.csv \n",
" inflating: summary/us/ca/sutter-summary.csv \n",
" inflating: summary/us/ca/sutter-summary.vrt \n",
" inflating: us/ca/city_of_san_luis_obispo.vrt \n",
" inflating: us/ca/city_of_san_luis_obispo.csv \n",
" inflating: summary/us/ca/city_of_san_luis_obispo-summary.csv \n",
" inflating: summary/us/ca/city_of_san_luis_obispo-summary.vrt \n",
" inflating: us/ak/fairbanks_north_star_borough.vrt \n",
" inflating: us/ak/fairbanks_north_star_borough.csv \n",
" inflating: summary/us/ak/fairbanks_north_star_borough-summary.csv \n",
" inflating: summary/us/ak/fairbanks_north_star_borough-summary.vrt \n",
" inflating: us/mt/valley.vrt \n",
" inflating: us/mt/valley.csv \n",
" inflating: summary/us/mt/valley-summary.csv \n",
" inflating: summary/us/mt/valley-summary.vrt \n",
" inflating: us/ca/city_of_lake_forest.vrt \n",
" inflating: us/ca/city_of_lake_forest.csv \n",
" inflating: summary/us/ca/city_of_lake_forest-summary.csv \n",
" inflating: summary/us/ca/city_of_lake_forest-summary.vrt \n",
" inflating: us/ak/kenai_peninsula_borough.vrt \n",
" inflating: us/ak/kenai_peninsula_borough.csv \n",
" inflating: summary/us/ak/kenai_peninsula_borough-summary.csv \n",
" inflating: summary/us/ak/kenai_peninsula_borough-summary.vrt \n",
" inflating: us/nm/city_of_ruidoso.vrt \n",
" inflating: us/nm/city_of_ruidoso.csv \n",
" inflating: summary/us/nm/city_of_ruidoso-summary.csv \n",
" inflating: summary/us/nm/city_of_ruidoso-summary.vrt \n",
" inflating: us/wa/walla_walla.vrt \n",
" inflating: us/wa/walla_walla.csv \n",
" inflating: summary/us/wa/walla_walla-summary.csv \n",
" inflating: summary/us/wa/walla_walla-summary.vrt \n",
" inflating: us/ca/city_of_palo_alto.vrt \n",
" inflating: us/ca/city_of_palo_alto.csv \n",
" inflating: summary/us/ca/city_of_palo_alto-summary.csv \n",
" inflating: summary/us/ca/city_of_palo_alto-summary.vrt \n",
" inflating: us/mt/helena.vrt \n",
" inflating: us/mt/helena.csv \n",
" inflating: summary/us/mt/helena-summary.csv \n",
" inflating: summary/us/mt/helena-summary.vrt \n",
" inflating: us/mt/fergus.vrt \n",
" inflating: us/mt/fergus.csv \n",
" inflating: summary/us/mt/fergus-summary.csv \n",
" inflating: summary/us/mt/fergus-summary.vrt \n",
" inflating: us/co/city_of_greeley.vrt \n",
" inflating: us/co/city_of_greeley.csv \n",
" inflating: summary/us/co/city_of_greeley-summary.csv \n",
" inflating: summary/us/co/city_of_greeley-summary.vrt \n",
" inflating: us/ca/santa_cruz.vrt \n",
" inflating: us/ca/santa_cruz.csv \n",
" inflating: summary/us/ca/santa_cruz-summary.csv \n",
" inflating: summary/us/ca/santa_cruz-summary.vrt \n",
" inflating: us/or/yamhill.vrt \n",
" inflating: us/or/yamhill.csv \n",
" inflating: summary/us/or/yamhill-summary.csv \n",
" inflating: summary/us/or/yamhill-summary.vrt \n",
" inflating: us/nm/dona_ana.vrt \n",
" inflating: us/nm/dona_ana.csv \n",
" inflating: summary/us/nm/dona_ana-summary.csv \n",
" inflating: summary/us/nm/dona_ana-summary.vrt \n",
" inflating: us/ca/city_of_laguna_niguel.vrt \n",
" inflating: us/ca/city_of_laguna_niguel.csv \n",
" inflating: summary/us/ca/city_of_laguna_niguel-summary.csv \n",
" inflating: summary/us/ca/city_of_laguna_niguel-summary.vrt \n",
" inflating: us/wa/city_of_bellevue.vrt \n",
" inflating: us/wa/city_of_bellevue.csv \n",
" inflating: summary/us/wa/city_of_bellevue-summary.csv \n",
" inflating: summary/us/wa/city_of_bellevue-summary.vrt \n",
" inflating: us/or/city_of_salem.vrt \n",
" inflating: us/or/city_of_salem.csv \n",
" inflating: summary/us/or/city_of_salem-summary.csv \n",
" inflating: summary/us/or/city_of_salem-summary.vrt \n",
" inflating: us/id/post_falls.vrt \n",
" inflating: us/id/post_falls.csv \n",
" inflating: summary/us/id/post_falls-summary.csv \n",
" inflating: summary/us/id/post_falls-summary.vrt \n",
" inflating: us/ca/napa.vrt \n",
" inflating: us/ca/napa.csv \n",
" inflating: summary/us/ca/napa-summary.csv \n",
" inflating: summary/us/ca/napa-summary.vrt \n",
" inflating: us/wa/city_of_tacoma.vrt \n",
" inflating: us/wa/city_of_tacoma.csv \n",
" inflating: summary/us/wa/city_of_tacoma-summary.csv \n",
" inflating: summary/us/wa/city_of_tacoma-summary.vrt \n",
" inflating: us/ut/duchesne.vrt \n",
" inflating: us/ut/duchesne.csv \n",
" inflating: summary/us/ut/duchesne-summary.csv \n",
" inflating: summary/us/ut/duchesne-summary.vrt \n",
" inflating: us/ca/city_of_carson.vrt \n",
" inflating: us/ca/city_of_carson.csv \n",
" inflating: summary/us/ca/city_of_carson-summary.csv \n",
" inflating: summary/us/ca/city_of_carson-summary.vrt \n",
" inflating: us/ca/city_of_temecula.vrt \n",
" inflating: us/ca/city_of_temecula.csv \n",
" inflating: summary/us/ca/city_of_temecula-summary.csv \n",
" inflating: summary/us/ca/city_of_temecula-summary.vrt \n",
" inflating: us/mt/lake.vrt \n",
" inflating: us/mt/lake.csv \n",
" inflating: summary/us/mt/lake-summary.csv \n",
" inflating: summary/us/mt/lake-summary.vrt \n",
" inflating: us/id/jefferson.vrt \n",
" inflating: us/id/jefferson.csv \n",
" inflating: summary/us/id/jefferson-summary.csv \n",
" inflating: summary/us/id/jefferson-summary.vrt \n",
" inflating: us/ca/madera.vrt \n",
" inflating: us/ca/madera.csv \n",
" inflating: summary/us/ca/madera-summary.csv \n",
" inflating: summary/us/ca/madera-summary.vrt \n",
" inflating: us/co/city_of_boulder.vrt \n",
" inflating: us/co/city_of_boulder.csv \n",
" inflating: summary/us/co/city_of_boulder-summary.csv \n",
" inflating: summary/us/co/city_of_boulder-summary.vrt \n",
" inflating: us/wy/natrona.vrt \n",
" inflating: us/wy/natrona.csv \n",
" inflating: summary/us/wy/natrona-summary.csv \n",
" inflating: summary/us/wy/natrona-summary.vrt \n",
" inflating: us/nv/elko.vrt \n",
" inflating: us/nv/elko.csv \n",
" inflating: summary/us/nv/elko-summary.csv \n",
" inflating: summary/us/nv/elko-summary.vrt \n",
" inflating: us/ca/city_of_burbank.vrt \n",
" inflating: us/ca/city_of_burbank.csv \n",
" inflating: summary/us/ca/city_of_burbank-summary.csv \n",
" inflating: summary/us/ca/city_of_burbank-summary.vrt \n",
" inflating: us/nm/eddy.vrt \n",
" inflating: us/nm/eddy.csv \n",
" inflating: summary/us/nm/eddy-summary.csv \n",
" inflating: summary/us/nm/eddy-summary.vrt \n",
" inflating: us/or/josephine.vrt \n",
" inflating: us/or/josephine.csv \n",
" inflating: summary/us/or/josephine-summary.csv \n",
" inflating: summary/us/or/josephine-summary.vrt \n",
" inflating: us/mt/ravalli.vrt \n",
" inflating: us/mt/ravalli.csv \n",
" inflating: summary/us/mt/ravalli-summary.csv \n",
" inflating: summary/us/mt/ravalli-summary.vrt \n",
" inflating: us/ca/city_of_santa_cruz.vrt \n",
" inflating: us/ca/city_of_santa_cruz.csv \n",
" inflating: summary/us/ca/city_of_santa_cruz-summary.csv \n",
" inflating: summary/us/ca/city_of_santa_cruz-summary.vrt \n",
" inflating: us/ca/city_of_elk_grove.vrt \n",
" inflating: us/ca/city_of_elk_grove.csv \n",
" inflating: summary/us/ca/city_of_elk_grove-summary.csv \n",
" inflating: summary/us/ca/city_of_elk_grove-summary.vrt \n",
" inflating: us/mt/gallatin.vrt \n",
" inflating: us/mt/gallatin.csv \n",
" inflating: summary/us/mt/gallatin-summary.csv \n",
" inflating: summary/us/mt/gallatin-summary.vrt \n",
" inflating: us/az/coconino.vrt \n",
" inflating: us/az/coconino.csv \n",
" inflating: summary/us/az/coconino-summary.csv \n",
" inflating: summary/us/az/coconino-summary.vrt \n",
" inflating: us/nv/mineral.vrt \n",
" inflating: us/nv/mineral.csv \n",
" inflating: summary/us/nv/mineral-summary.csv \n",
" inflating: summary/us/nv/mineral-summary.vrt \n",
" inflating: us/ca/kings.vrt \n",
" inflating: us/ca/kings.csv \n",
" inflating: summary/us/ca/kings-summary.csv \n",
" inflating: summary/us/ca/kings-summary.vrt \n",
" inflating: us/wy/laramie.vrt \n",
" inflating: us/wy/laramie.csv \n",
" inflating: summary/us/wy/laramie-summary.csv \n",
" inflating: summary/us/wy/laramie-summary.vrt \n",
" inflating: us/wa/skagit.vrt \n",
" inflating: us/wa/skagit.csv \n",
" inflating: summary/us/wa/skagit-summary.csv \n",
" inflating: summary/us/wa/skagit-summary.vrt \n",
" inflating: us/co/washington.vrt \n",
" inflating: us/co/washington.csv \n",
" inflating: summary/us/co/washington-summary.csv \n",
" inflating: summary/us/co/washington-summary.vrt \n",
" inflating: us/ca/lake.vrt \n",
" inflating: us/ca/lake.csv \n",
" inflating: summary/us/ca/lake-summary.csv \n",
" inflating: summary/us/ca/lake-summary.vrt \n",
" inflating: us/ca/city_of_orange.vrt \n",
" inflating: us/ca/city_of_orange.csv \n",
" inflating: summary/us/ca/city_of_orange-summary.csv \n",
" inflating: summary/us/ca/city_of_orange-summary.vrt \n",
" inflating: us/ca/butte.vrt \n",
" inflating: us/ca/butte.csv \n",
" inflating: summary/us/ca/butte-summary.csv \n",
" inflating: summary/us/ca/butte-summary.vrt \n",
" inflating: us/or/linn.vrt \n",
" inflating: us/or/linn.csv \n",
" inflating: summary/us/or/linn-summary.csv \n",
" inflating: summary/us/or/linn-summary.vrt \n",
" inflating: us/hi/maui.vrt \n",
" inflating: us/hi/maui.csv \n",
" inflating: summary/us/hi/maui-summary.csv \n",
" inflating: summary/us/hi/maui-summary.vrt \n",
" inflating: us/hi/kauai.vrt \n",
" inflating: us/hi/kauai.csv \n",
" inflating: summary/us/hi/kauai-summary.csv \n",
" inflating: summary/us/hi/kauai-summary.vrt \n",
" inflating: us/ca/mono.vrt \n",
" inflating: us/ca/mono.csv \n",
" inflating: summary/us/ca/mono-summary.csv \n",
" inflating: summary/us/ca/mono-summary.vrt \n",
" inflating: us/co/el_paso.vrt \n",
" inflating: us/co/el_paso.csv \n",
" inflating: summary/us/co/el_paso-summary.csv \n",
" inflating: summary/us/co/el_paso-summary.vrt \n",
" inflating: us/wa/lewis.vrt \n",
" inflating: us/wa/lewis.csv \n",
" inflating: summary/us/wa/lewis-summary.csv \n",
" inflating: summary/us/wa/lewis-summary.vrt \n",
" inflating: us/id/bonneville.vrt \n",
" inflating: us/id/bonneville.csv \n",
" inflating: summary/us/id/bonneville-summary.csv \n",
" inflating: summary/us/id/bonneville-summary.vrt \n",
" inflating: us/wa/island.vrt \n",
" inflating: us/wa/island.csv \n",
" inflating: summary/us/wa/island-summary.csv \n",
" inflating: summary/us/wa/island-summary.vrt \n",
" inflating: us/wa/city_of_spokane.vrt \n",
" inflating: us/wa/city_of_spokane.csv \n",
" inflating: summary/us/wa/city_of_spokane-summary.csv \n",
" inflating: summary/us/wa/city_of_spokane-summary.vrt \n",
" inflating: us/ca/city_of_sunnyvale.vrt \n",
" inflating: us/ca/city_of_sunnyvale.csv \n",
" inflating: summary/us/ca/city_of_sunnyvale-summary.csv \n",
" inflating: summary/us/ca/city_of_sunnyvale-summary.vrt \n",
" inflating: us/ca/city_of_newport_beach.vrt \n",
" inflating: us/ca/city_of_newport_beach.csv \n",
" inflating: summary/us/ca/city_of_newport_beach-summary.csv \n",
" inflating: summary/us/ca/city_of_newport_beach-summary.vrt \n",
" inflating: us/ca/city_of_riverside.vrt \n",
" inflating: us/ca/city_of_riverside.csv \n",
" inflating: summary/us/ca/city_of_riverside-summary.csv \n",
" inflating: summary/us/ca/city_of_riverside-summary.vrt \n",
" inflating: us/nv/nye.vrt \n",
" inflating: us/nv/nye.csv \n",
" inflating: summary/us/nv/nye-summary.csv \n",
" inflating: summary/us/nv/nye-summary.vrt \n",
" inflating: us/az/city_of_flagstaff.vrt \n",
" inflating: us/az/city_of_flagstaff.csv \n",
" inflating: summary/us/az/city_of_flagstaff-summary.csv \n",
" inflating: summary/us/az/city_of_flagstaff-summary.vrt \n",
" inflating: us/ut/city_of_provo.vrt \n",
" inflating: us/ut/city_of_provo.csv \n",
" inflating: summary/us/ut/city_of_provo-summary.csv \n",
" inflating: summary/us/ut/city_of_provo-summary.vrt \n",
" inflating: us/ak/anchorage.vrt \n",
" inflating: us/ak/anchorage.csv \n",
" inflating: summary/us/ak/anchorage-summary.csv \n",
" inflating: summary/us/ak/anchorage-summary.vrt \n",
" inflating: us/ca/city_of_roseville.vrt \n",
" inflating: us/ca/city_of_roseville.csv \n",
" inflating: summary/us/ca/city_of_roseville-summary.csv \n",
" inflating: summary/us/ca/city_of_roseville-summary.vrt \n",
" inflating: us/wa/pacific.vrt \n",
" inflating: us/wa/pacific.csv \n",
" inflating: summary/us/wa/pacific-summary.csv \n",
" inflating: summary/us/wa/pacific-summary.vrt \n",
" inflating: us/or/gresham.vrt \n",
" inflating: us/or/gresham.csv \n",
" inflating: summary/us/or/gresham-summary.csv \n",
" inflating: summary/us/or/gresham-summary.vrt \n",
" inflating: us/wa/kitsap.vrt \n",
" inflating: us/wa/kitsap.csv \n",
" inflating: summary/us/wa/kitsap-summary.csv \n",
" inflating: summary/us/wa/kitsap-summary.vrt \n",
" inflating: us/or/marion_and_polk.vrt \n",
" inflating: us/or/marion_and_polk.csv \n",
" inflating: summary/us/or/marion_and_polk-summary.csv \n",
" inflating: summary/us/or/marion_and_polk-summary.vrt \n",
" inflating: us/id/kootenai.vrt \n",
" inflating: us/id/kootenai.csv \n",
" inflating: summary/us/id/kootenai-summary.csv \n",
" inflating: summary/us/id/kootenai-summary.vrt \n",
" inflating: us/ca/placer.vrt \n",
" inflating: us/ca/placer.csv \n",
" inflating: summary/us/ca/placer-summary.csv \n",
" inflating: summary/us/ca/placer-summary.vrt \n",
" inflating: us/co/teller.vrt \n",
" inflating: us/co/teller.csv \n",
" inflating: summary/us/co/teller-summary.csv \n",
" inflating: summary/us/co/teller-summary.vrt \n",
" inflating: us/ut/washington.vrt \n",
" inflating: us/ut/washington.csv \n",
" inflating: summary/us/ut/washington-summary.csv \n",
" inflating: summary/us/ut/washington-summary.vrt \n",
" inflating: us/mt/cascade.vrt \n",
" inflating: us/mt/cascade.csv \n",
" inflating: summary/us/mt/cascade-summary.csv \n",
" inflating: summary/us/mt/cascade-summary.vrt \n",
" inflating: us/ca/city_of_irvine.vrt \n",
" inflating: us/ca/city_of_irvine.csv \n",
" inflating: summary/us/ca/city_of_irvine-summary.csv \n",
" inflating: summary/us/ca/city_of_irvine-summary.vrt \n",
" inflating: us/co/grand.vrt \n",
" inflating: us/co/grand.csv \n",
" inflating: summary/us/co/grand-summary.csv \n",
" inflating: summary/us/co/grand-summary.vrt \n",
" inflating: us/or/clackamas.vrt \n",
" inflating: us/or/clackamas.csv \n",
" inflating: summary/us/or/clackamas-summary.csv \n",
" inflating: summary/us/or/clackamas-summary.vrt \n",
" inflating: us/or/marion.vrt \n",
" inflating: us/or/marion.csv \n",
" inflating: summary/us/or/marion-summary.csv \n",
" inflating: summary/us/or/marion-summary.vrt \n",
" inflating: us/wa/cowlitz.vrt \n",
" inflating: us/wa/cowlitz.csv \n",
" inflating: summary/us/wa/cowlitz-summary.csv \n",
" inflating: summary/us/wa/cowlitz-summary.vrt \n",
" inflating: us/or/klamath.vrt \n",
" inflating: us/or/klamath.csv \n",
" inflating: summary/us/or/klamath-summary.csv \n",
" inflating: summary/us/or/klamath-summary.vrt \n",
" inflating: us/ca/marin.vrt \n",
" inflating: us/ca/marin.csv \n",
" inflating: summary/us/ca/marin-summary.csv \n",
" inflating: summary/us/ca/marin-summary.vrt \n",
" inflating: us/ca/city_of_brea.vrt \n",
" inflating: us/ca/city_of_brea.csv \n",
" inflating: summary/us/ca/city_of_brea-summary.csv \n",
" inflating: summary/us/ca/city_of_brea-summary.vrt \n",
" inflating: us/ca/san_luis_obispo.vrt \n",
" inflating: us/ca/san_luis_obispo.csv \n",
" inflating: summary/us/ca/san_luis_obispo-summary.csv \n",
" inflating: summary/us/ca/san_luis_obispo-summary.vrt \n",
" inflating: us/ca/nevada.vrt \n",
" inflating: us/ca/nevada.csv \n",
" inflating: summary/us/ca/nevada-summary.csv \n",
" inflating: summary/us/ca/nevada-summary.vrt \n",
" inflating: us/az/city_of_glendale.vrt \n",
" inflating: us/az/city_of_glendale.csv \n",
" inflating: summary/us/az/city_of_glendale-summary.csv \n",
" inflating: summary/us/az/city_of_glendale-summary.vrt \n",
" inflating: us/co/city_of_aurora.vrt \n",
" inflating: us/co/city_of_aurora.csv \n",
" inflating: summary/us/co/city_of_aurora-summary.csv \n",
" inflating: summary/us/co/city_of_aurora-summary.vrt \n",
" inflating: us/ca/merced.vrt \n",
" inflating: us/ca/merced.csv \n",
" inflating: summary/us/ca/merced-summary.csv \n",
" inflating: summary/us/ca/merced-summary.vrt \n",
" inflating: us/nv/henderson.vrt \n",
" inflating: us/nv/henderson.csv \n",
" inflating: summary/us/nv/henderson-summary.csv \n",
" inflating: summary/us/nv/henderson-summary.vrt \n",
" inflating: us/co/douglas.vrt \n",
" inflating: us/co/douglas.csv \n",
" inflating: summary/us/co/douglas-summary.csv \n",
" inflating: summary/us/co/douglas-summary.vrt \n",
" inflating: us/ca/mendocino.vrt \n",
" inflating: us/ca/mendocino.csv \n",
" inflating: summary/us/ca/mendocino-summary.csv \n",
" inflating: summary/us/ca/mendocino-summary.vrt \n",
" inflating: us/or/jackson.vrt \n",
" inflating: us/or/jackson.csv \n",
" inflating: summary/us/or/jackson-summary.csv \n",
" inflating: summary/us/or/jackson-summary.vrt \n",
" inflating: us/ca/tuolumne.vrt \n",
" inflating: us/ca/tuolumne.csv \n",
" inflating: summary/us/ca/tuolumne-summary.csv \n",
" inflating: summary/us/ca/tuolumne-summary.vrt \n",
" inflating: us/mt/yellowstone.vrt \n",
" inflating: us/mt/yellowstone.csv \n",
" inflating: summary/us/mt/yellowstone-summary.csv \n",
" inflating: summary/us/mt/yellowstone-summary.vrt \n",
" inflating: us/ca/san_francisco.vrt \n",
" inflating: us/ca/san_francisco.csv \n",
" inflating: summary/us/ca/san_francisco-summary.csv \n",
" inflating: summary/us/ca/san_francisco-summary.vrt \n",
" inflating: us/ca/monterey.vrt \n",
" inflating: us/ca/monterey.csv \n",
" inflating: summary/us/ca/monterey-summary.csv \n",
" inflating: summary/us/ca/monterey-summary.vrt \n",
" inflating: us/co/boulder.vrt \n",
" inflating: us/co/boulder.csv \n",
" inflating: summary/us/co/boulder-summary.csv \n",
" inflating: summary/us/co/boulder-summary.vrt \n",
" inflating: us/co/city_of_littleton.vrt \n",
" inflating: us/co/city_of_littleton.csv \n",
" inflating: summary/us/co/city_of_littleton-summary.csv \n",
" inflating: summary/us/co/city_of_littleton-summary.vrt \n",
" inflating: us/or/portland.vrt \n",
" inflating: us/or/portland.csv \n",
" inflating: summary/us/or/portland-summary.csv \n",
" inflating: summary/us/or/portland-summary.vrt \n",
" inflating: us/mt/flathead.vrt \n",
" inflating: us/mt/flathead.csv \n",
" inflating: summary/us/mt/flathead-summary.csv \n",
" inflating: summary/us/mt/flathead-summary.vrt \n",
" inflating: us/co/larimer.vrt \n",
" inflating: us/co/larimer.csv \n",
" inflating: summary/us/co/larimer-summary.csv \n",
" inflating: summary/us/co/larimer-summary.vrt \n",
" inflating: us/ca/el_dorado.vrt \n",
" inflating: us/ca/el_dorado.csv \n",
" inflating: summary/us/ca/el_dorado-summary.csv \n",
" inflating: summary/us/ca/el_dorado-summary.vrt \n",
" inflating: us/hi/honolulu.vrt \n",
" inflating: us/hi/honolulu.csv \n",
" inflating: summary/us/hi/honolulu-summary.csv \n",
" inflating: summary/us/hi/honolulu-summary.vrt \n",
" inflating: us/wa/city_of_yakima.vrt \n",
" inflating: us/wa/city_of_yakima.csv \n",
" inflating: summary/us/wa/city_of_yakima-summary.csv \n",
" inflating: summary/us/wa/city_of_yakima-summary.vrt \n",
" inflating: us/wa/thurston.vrt \n",
" inflating: us/wa/thurston.csv \n",
" inflating: summary/us/wa/thurston-summary.csv \n",
" inflating: summary/us/wa/thurston-summary.vrt \n",
" inflating: us/ca/ventura.vrt \n",
" inflating: us/ca/ventura.csv \n",
" inflating: summary/us/ca/ventura-summary.csv \n",
" inflating: summary/us/ca/ventura-summary.vrt \n",
" inflating: us/co/city_of_thornton.vrt \n",
" inflating: us/co/city_of_thornton.csv \n",
" inflating: summary/us/co/city_of_thornton-summary.csv \n",
" inflating: summary/us/co/city_of_thornton-summary.vrt \n",
" inflating: us/ca/yolo.vrt \n",
" inflating: us/ca/yolo.csv \n",
" inflating: summary/us/ca/yolo-summary.csv \n",
" inflating: summary/us/ca/yolo-summary.vrt \n",
" inflating: us/wa/clallam.vrt \n",
" inflating: us/wa/clallam.csv \n",
" inflating: summary/us/wa/clallam-summary.csv \n",
" inflating: summary/us/wa/clallam-summary.vrt \n",
" inflating: us/co/denver.vrt \n",
" inflating: us/co/denver.csv \n",
" inflating: summary/us/co/denver-summary.csv \n",
" inflating: summary/us/co/denver-summary.vrt \n",
" inflating: us/ca/sonoma.vrt \n",
" inflating: us/ca/sonoma.csv \n",
" inflating: summary/us/ca/sonoma-summary.csv \n",
" inflating: summary/us/ca/sonoma-summary.vrt \n",
" inflating: us/id/ada.vrt \n",
" inflating: us/id/ada.csv \n",
" inflating: summary/us/id/ada-summary.csv \n",
" inflating: summary/us/id/ada-summary.vrt \n",
" inflating: us/co/weld.vrt \n",
" inflating: us/co/weld.csv \n",
" inflating: summary/us/co/weld-summary.csv \n",
" inflating: summary/us/co/weld-summary.vrt \n",
" inflating: us/az/city_of_scottsdale.vrt \n",
" inflating: us/az/city_of_scottsdale.csv \n",
" inflating: summary/us/az/city_of_scottsdale-summary.csv \n",
" inflating: summary/us/az/city_of_scottsdale-summary.vrt \n",
" inflating: us/co/arapahoe.vrt \n",
" inflating: us/co/arapahoe.csv \n",
" inflating: summary/us/co/arapahoe-summary.csv \n",
" inflating: summary/us/co/arapahoe-summary.vrt \n",
" inflating: us/or/deschutes.vrt \n",
" inflating: us/or/deschutes.csv \n",
" inflating: summary/us/or/deschutes-summary.csv \n",
" inflating: summary/us/or/deschutes-summary.vrt \n",
" inflating: us/ca/city_of_long_beach.vrt \n",
" inflating: us/ca/city_of_long_beach.csv \n",
" inflating: summary/us/ca/city_of_long_beach-summary.csv \n",
" inflating: summary/us/ca/city_of_long_beach-summary.vrt \n",
" inflating: us/az/city_of_gilbert.vrt \n",
" inflating: us/az/city_of_gilbert.csv \n",
" inflating: summary/us/az/city_of_gilbert-summary.csv \n",
" inflating: summary/us/az/city_of_gilbert-summary.vrt \n",
" inflating: us/ca/city_of_bakersfield.vrt \n",
" inflating: us/ca/city_of_bakersfield.csv \n",
" inflating: summary/us/ca/city_of_bakersfield-summary.csv \n",
" inflating: summary/us/ca/city_of_bakersfield-summary.vrt \n",
" inflating: us/ca/stanislaus.vrt \n",
" inflating: us/ca/stanislaus.csv \n",
" inflating: summary/us/ca/stanislaus-summary.csv \n",
" inflating: summary/us/ca/stanislaus-summary.vrt \n",
" inflating: us/ca/kern.vrt \n",
" inflating: us/ca/kern.csv \n",
" inflating: summary/us/ca/kern-summary.csv \n",
" inflating: summary/us/ca/kern-summary.vrt \n",
" inflating: us/nm/valencia.vrt \n",
" inflating: us/nm/valencia.csv \n",
" inflating: summary/us/nm/valencia-summary.csv \n",
" inflating: summary/us/nm/valencia-summary.vrt \n",
" inflating: us/ca/fresno.vrt \n",
" inflating: us/ca/fresno.csv \n",
" inflating: summary/us/ca/fresno-summary.csv \n",
" inflating: summary/us/ca/fresno-summary.vrt \n",
" inflating: us/ca/solano.vrt \n",
" inflating: us/ca/solano.csv \n",
" inflating: summary/us/ca/solano-summary.csv \n",
" inflating: summary/us/ca/solano-summary.vrt \n",
" inflating: us/az/pinal.vrt \n",
" inflating: us/az/pinal.csv \n",
" inflating: summary/us/az/pinal-summary.csv \n",
" inflating: summary/us/az/pinal-summary.vrt \n",
" inflating: us/ca/santa_clara.vrt \n",
" inflating: us/ca/santa_clara.csv \n",
" inflating: summary/us/ca/santa_clara-summary.csv \n",
" inflating: summary/us/ca/santa_clara-summary.vrt \n",
" inflating: us/wa/clark.vrt \n",
" inflating: us/wa/clark.csv \n",
" inflating: summary/us/wa/clark-summary.csv \n",
" inflating: summary/us/wa/clark-summary.vrt \n",
" inflating: us/wa/pierce.vrt \n",
" inflating: us/wa/pierce.csv \n",
" inflating: summary/us/wa/pierce-summary.csv \n",
" inflating: summary/us/wa/pierce-summary.vrt \n",
" inflating: us/az/pima.vrt \n",
" inflating: us/az/pima.csv \n",
" inflating: summary/us/az/pima-summary.csv \n",
" inflating: summary/us/az/pima-summary.vrt \n",
" inflating: us/or/lane.vrt \n",
" inflating: us/or/lane.csv \n",
" inflating: summary/us/or/lane-summary.csv \n",
" inflating: summary/us/or/lane-summary.vrt \n",
" inflating: us/ca/orange.vrt \n",
" inflating: us/ca/orange.csv \n",
" inflating: summary/us/ca/orange-summary.csv \n",
" inflating: summary/us/ca/orange-summary.vrt \n",
" inflating: us/wa/snohomish.vrt \n",
" inflating: us/wa/snohomish.csv \n",
" inflating: summary/us/wa/snohomish-summary.csv \n",
" inflating: summary/us/wa/snohomish-summary.vrt \n",
" inflating: us/wa/snohomish_county.vrt \n",
" inflating: us/wa/snohomish_county.csv \n",
" inflating: summary/us/wa/snohomish_county-summary.csv \n",
" inflating: summary/us/wa/snohomish_county-summary.vrt \n",
" inflating: us/ca/tulare.vrt \n",
" inflating: us/ca/tulare.csv \n",
" inflating: summary/us/ca/tulare-summary.csv \n",
" inflating: summary/us/ca/tulare-summary.vrt \n",
" inflating: us/mt/statewide.vrt \n",
" inflating: us/mt/statewide.csv \n",
" inflating: summary/us/mt/statewide-summary.csv \n",
" inflating: summary/us/mt/statewide-summary.vrt \n",
" inflating: us/or/multnomah.vrt \n",
" inflating: us/or/multnomah.csv \n",
" inflating: summary/us/or/multnomah-summary.csv \n",
" inflating: summary/us/or/multnomah-summary.vrt \n",
" inflating: us/nm/statewide.vrt \n",
" inflating: us/nm/statewide.csv \n",
" inflating: summary/us/nm/statewide-summary.csv \n",
" inflating: summary/us/nm/statewide-summary.vrt \n",
" inflating: us/ca/city_of_anaheim.vrt \n",
" inflating: us/ca/city_of_anaheim.csv \n",
" inflating: summary/us/ca/city_of_anaheim-summary.csv \n",
" inflating: summary/us/ca/city_of_anaheim-summary.vrt \n",
" inflating: us/ca/alameda.vrt \n",
" inflating: us/ca/alameda.csv \n",
" inflating: summary/us/ca/alameda-summary.csv \n",
" inflating: summary/us/ca/alameda-summary.vrt \n",
" inflating: us/ca/city_of_san_jose.vrt \n",
" inflating: us/ca/city_of_san_jose.csv \n",
" inflating: summary/us/ca/city_of_san_jose-summary.csv \n",
" inflating: summary/us/ca/city_of_san_jose-summary.vrt \n",
" inflating: us/ca/riverside.vrt \n",
" inflating: us/ca/riverside.csv \n",
" inflating: summary/us/ca/riverside-summary.csv \n",
" inflating: summary/us/ca/riverside-summary.vrt \n",
" inflating: us/wa/king.vrt \n",
" inflating: us/wa/king.csv \n",
" inflating: summary/us/wa/king-summary.csv \n",
" inflating: summary/us/wa/king-summary.vrt \n",
" inflating: us/co/statewide.vrt \n",
" inflating: us/co/statewide.csv \n",
" inflating: summary/us/co/statewide-summary.csv \n",
" inflating: summary/us/co/statewide-summary.vrt \n",
" inflating: us/ca/city_of_los_angeles.vrt \n",
" inflating: us/ca/city_of_los_angeles.csv \n",
" inflating: summary/us/ca/city_of_los_angeles-summary.csv \n",
" inflating: summary/us/ca/city_of_los_angeles-summary.vrt \n",
" inflating: us/wy/statewide.vrt \n",
" inflating: us/wy/statewide.csv \n",
" inflating: summary/us/wy/statewide-summary.csv \n",
" inflating: summary/us/wy/statewide-summary.vrt \n",
" inflating: us/ca/los_angeles.vrt \n",
" inflating: us/ca/los_angeles.csv \n",
" inflating: summary/us/ca/los_angeles-summary.csv \n",
" inflating: summary/us/ca/los_angeles-summary.vrt \n",
" inflating: us/az/maricopa.vrt \n",
" inflating: us/az/maricopa.csv \n",
" inflating: summary/us/az/maricopa-summary.csv \n",
" inflating: summary/us/az/maricopa-summary.vrt \n",
" inflating: us/nv/clark.vrt \n",
" inflating: us/nv/clark.csv \n",
" inflating: summary/us/nv/clark-summary.csv \n",
" inflating: summary/us/nv/clark-summary.vrt \n",
" inflating: us/nm/albuquerque.vrt \n",
" inflating: us/nm/albuquerque.csv \n",
" inflating: summary/us/nm/albuquerque-summary.csv \n",
" inflating: summary/us/nm/albuquerque-summary.vrt \n",
" inflating: us/wy/crook.vrt \n",
" inflating: us/wy/crook.csv \n",
" inflating: summary/us/wy/crook-summary.csv \n",
" inflating: summary/us/wy/crook-summary.vrt \n",
" inflating: us/mt/carter.vrt \n",
" inflating: us/mt/carter.csv \n",
" inflating: summary/us/mt/carter-summary.csv \n",
" inflating: summary/us/mt/carter-summary.vrt \n",
" inflating: us/mt/stillwater.vrt \n",
" inflating: us/mt/stillwater.csv \n",
" inflating: summary/us/mt/stillwater-summary.csv \n",
" inflating: summary/us/mt/stillwater-summary.vrt \n",
" inflating: us/co/city_of_commerce_city.vrt \n",
" inflating: us/co/city_of_commerce_city.csv \n",
" inflating: summary/us/co/city_of_commerce_city-summary.csv \n",
" inflating: summary/us/co/city_of_commerce_city-summary.vrt \n",
" inflating: us/co/broomfield.vrt \n",
" inflating: us/co/broomfield.csv \n",
" inflating: summary/us/co/broomfield-summary.csv \n",
" inflating: summary/us/co/broomfield-summary.vrt \n",
" inflating: us/ca/mariposa.vrt \n",
" inflating: us/ca/mariposa.csv \n",
" inflating: summary/us/ca/mariposa-summary.csv \n",
" inflating: summary/us/ca/mariposa-summary.vrt \n",
" inflating: us/az/yavapai.vrt \n",
" inflating: us/az/yavapai.csv \n",
" inflating: summary/us/az/yavapai-summary.csv \n",
" inflating: summary/us/az/yavapai-summary.vrt \n",
" inflating: us/nv/las_vegas.vrt \n",
" inflating: us/nv/las_vegas.csv \n",
" inflating: summary/us/nv/las_vegas-summary.csv \n",
" inflating: summary/us/nv/las_vegas-summary.vrt \n",
" inflating: us/ca/city_of_san_jose2.vrt \n",
" inflating: us/ca/city_of_san_jose2.csv \n",
" inflating: summary/us/ca/city_of_san_jose2-summary.csv \n",
" inflating: summary/us/ca/city_of_san_jose2-summary.vrt \n",
" inflating: us/co/city_of_arvada.vrt \n",
" inflating: us/co/city_of_arvada.csv \n",
" inflating: summary/us/co/city_of_arvada-summary.csv \n",
" inflating: summary/us/co/city_of_arvada-summary.vrt \n",
" inflating: us/ut/statewide.vrt \n",
" inflating: us/ut/statewide.csv \n",
" inflating: summary/us/ut/statewide-summary.csv \n",
" inflating: summary/us/ut/statewide-summary.vrt \n",
" inflating: us/wy/hot_springs.vrt \n",
" inflating: us/wy/hot_springs.csv \n",
" inflating: summary/us/wy/hot_springs-summary.csv \n",
" inflating: summary/us/wy/hot_springs-summary.vrt \n",
" inflating: us/nv/carson_city.vrt \n",
" inflating: us/nv/carson_city.csv \n",
" inflating: summary/us/nv/carson_city-summary.csv \n",
" inflating: summary/us/nv/carson_city-summary.vrt \n",
" inflating: us/wa/okanogan.vrt \n",
" inflating: us/wa/okanogan.csv \n",
" inflating: summary/us/wa/okanogan-summary.csv \n",
" inflating: summary/us/wa/okanogan-summary.vrt \n",
" inflating: us/ca/san_diego.vrt \n",
" inflating: us/ca/san_diego.csv \n",
" inflating: summary/us/ca/san_diego-summary.csv \n",
" inflating: summary/us/ca/san_diego-summary.vrt \n",
" inflating: us/co/montezuma.vrt \n",
" inflating: us/co/montezuma.csv \n",
" inflating: summary/us/co/montezuma-summary.csv \n",
" inflating: summary/us/co/montezuma-summary.vrt \n",
" inflating: us/az/santa_cruz.vrt \n",
" inflating: us/az/santa_cruz.csv \n",
" inflating: summary/us/az/santa_cruz-summary.csv \n",
" inflating: summary/us/az/santa_cruz-summary.vrt \n",
" inflating: us/id/canyon.vrt \n",
" inflating: us/id/canyon.csv \n",
" inflating: summary/us/id/canyon-summary.csv \n",
" inflating: summary/us/id/canyon-summary.vrt \n",
" inflating: us/nv/washoe.vrt \n",
" inflating: us/nv/washoe.csv \n",
" inflating: summary/us/nv/washoe-summary.csv \n",
" inflating: summary/us/nv/washoe-summary.vrt \n",
" inflating: us/az/mohave.vrt \n",
" inflating: us/az/mohave.csv \n",
" inflating: summary/us/az/mohave-summary.csv \n",
" inflating: summary/us/az/mohave-summary.vrt \n",
" inflating: us/or/crook.vrt \n",
" inflating: us/or/crook.csv \n",
" inflating: summary/us/or/crook-summary.csv \n",
" inflating: summary/us/or/crook-summary.vrt \n",
" inflating: us/id/bannock.vrt \n",
" inflating: us/id/bannock.csv \n",
" inflating: summary/us/id/bannock-summary.csv \n",
" inflating: summary/us/id/bannock-summary.vrt \n",
" inflating: us/ca/city_of_visalia.vrt \n",
" inflating: us/ca/city_of_visalia.csv \n",
" inflating: summary/us/ca/city_of_visalia-summary.csv \n",
" inflating: summary/us/ca/city_of_visalia-summary.vrt \n",
" inflating: us/id/madison.vrt \n",
" inflating: us/id/madison.csv \n",
" inflating: summary/us/id/madison-summary.csv \n",
" inflating: summary/us/id/madison-summary.vrt \n",
" inflating: us/id/bingham.vrt \n",
" inflating: us/id/bingham.csv \n",
" inflating: summary/us/id/bingham-summary.csv \n",
" inflating: summary/us/id/bingham-summary.vrt \n",
" inflating: us/nm/san_juan.vrt \n",
" inflating: us/nm/san_juan.csv \n",
" inflating: summary/us/nm/san_juan-summary.csv \n",
" inflating: summary/us/nm/san_juan-summary.vrt \n",
" inflating: us/az/yuma.vrt \n",
" inflating: us/az/yuma.csv \n",
" inflating: summary/us/az/yuma-summary.csv \n",
" inflating: summary/us/az/yuma-summary.vrt \n",
" inflating: us/ca/tehama.vrt \n",
" inflating: us/ca/tehama.csv \n",
" inflating: summary/us/ca/tehama-summary.csv \n",
" inflating: summary/us/ca/tehama-summary.vrt \n",
" inflating: us/ca/humboldt.vrt \n",
" inflating: us/ca/humboldt.csv \n",
" inflating: summary/us/ca/humboldt-summary.csv \n",
" inflating: summary/us/ca/humboldt-summary.vrt \n",
" inflating: us/id/latah.vrt \n",
" inflating: us/id/latah.csv \n",
" inflating: summary/us/id/latah-summary.csv \n",
" inflating: summary/us/id/latah-summary.vrt \n",
" inflating: us/mt/missoula.vrt \n",
" inflating: us/mt/missoula.csv \n",
" inflating: summary/us/mt/missoula-summary.csv \n",
" inflating: summary/us/mt/missoula-summary.vrt \n",
" inflating: us/ak/matanuska_susitna_borough.vrt \n",
" inflating: us/ak/matanuska_susitna_borough.csv \n",
" inflating: summary/us/ak/matanuska_susitna_borough-summary.csv \n",
" inflating: summary/us/ak/matanuska_susitna_borough-summary.vrt \n",
" inflating: us/id/city_of_boise.vrt \n",
" inflating: us/id/city_of_boise.csv \n",
" inflating: summary/us/id/city_of_boise-summary.csv \n",
" inflating: summary/us/id/city_of_boise-summary.vrt \n",
" inflating: us/id/lemhi.vrt \n",
" inflating: us/id/lemhi.csv \n",
" inflating: summary/us/id/lemhi-summary.csv \n",
" inflating: summary/us/id/lemhi-summary.vrt \n",
" inflating: us/co/city_of_westminster.vrt \n",
" inflating: us/co/city_of_westminster.csv \n",
" inflating: summary/us/co/city_of_westminster-summary.csv \n",
" inflating: summary/us/co/city_of_westminster-summary.vrt \n",
" inflating: us/wa/chelan.vrt \n",
" inflating: us/wa/chelan.csv \n",
" inflating: summary/us/wa/chelan-summary.csv \n",
" inflating: summary/us/wa/chelan-summary.vrt \n",
" inflating: us/or/washington.vrt \n",
" inflating: us/or/washington.csv \n",
" inflating: summary/us/or/washington-summary.csv \n",
" inflating: summary/us/or/washington-summary.vrt \n",
"replace us/or/washington.vrt? [y]es, [n]o, [A]ll, [N]one, [r]ename: ^C\n"
]
}
],
"source": [
"!unzip \"openaddr-collected-us_west.zip\""
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"'/Users/fkauker/Documents/code/test-suite/notebooks'"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import os\n",
"os.getcwd()"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [],
"source": [
"!sed -n 1p ./us/ca/humboldt.csv > all_ca.csv"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [],
"source": [
"!sed 1d ./us/ca/*.csv >> all_ca.csv"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/anaconda3/envs/link/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2785: DtypeWarning: Columns (0,1,2,3,4,5,6,7,8,9) have mixed types. Specify dtype option on import or set low_memory=False.\n",
" interactivity=interactivity, compiler=compiler, result=result)\n"
]
}
],
"source": [
"address_df = pd.read_csv(\"all_ca.csv\")"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>LON</th>\n",
" <th>LAT</th>\n",
" <th>NUMBER</th>\n",
" <th>STREET</th>\n",
" <th>UNIT</th>\n",
" <th>CITY</th>\n",
" <th>DISTRICT</th>\n",
" <th>REGION</th>\n",
" <th>POSTCODE</th>\n",
" <th>ID</th>\n",
" <th>HASH</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>-122.076</td>\n",
" <td>37.6965</td>\n",
" <td>20630</td>\n",
" <td>PATIO DR</td>\n",
" <td>NaN</td>\n",
" <td>CASTRO VALLEY</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>94546</td>\n",
" <td>84A-80-16-8</td>\n",
" <td>61e5aeb691307e14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>-122.076</td>\n",
" <td>37.6979</td>\n",
" <td>3563</td>\n",
" <td>JAMISON WY</td>\n",
" <td>NaN</td>\n",
" <td>CASTRO VALLEY</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>94546</td>\n",
" <td>84A-80-10-12</td>\n",
" <td>c1209fa4c910a753</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>-122.076</td>\n",
" <td>37.6979</td>\n",
" <td>3579</td>\n",
" <td>JAMISON WY</td>\n",
" <td>NaN</td>\n",
" <td>CASTRO VALLEY</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>94546</td>\n",
" <td>84A-80-10-12</td>\n",
" <td>b2937bff35d04fb7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>-122.075</td>\n",
" <td>37.6979</td>\n",
" <td>3597</td>\n",
" <td>JAMISON WY</td>\n",
" <td>NaN</td>\n",
" <td>CASTRO VALLEY</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>94546</td>\n",
" <td>84A-80-10-12</td>\n",
" <td>0072398c846e2fb8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>-121.814</td>\n",
" <td>37.7057</td>\n",
" <td>477</td>\n",
" <td>NORTH CANYONS PW</td>\n",
" <td>NaN</td>\n",
" <td>LIVERMORE</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>94551</td>\n",
" <td>905-14-24</td>\n",
" <td>9b613ed58f0127ec</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" LON LAT NUMBER STREET UNIT CITY DISTRICT \\\n",
"0 -122.076 37.6965 20630 PATIO DR NaN CASTRO VALLEY NaN \n",
"1 -122.076 37.6979 3563 JAMISON WY NaN CASTRO VALLEY NaN \n",
"2 -122.076 37.6979 3579 JAMISON WY NaN CASTRO VALLEY NaN \n",
"3 -122.075 37.6979 3597 JAMISON WY NaN CASTRO VALLEY NaN \n",
"4 -121.814 37.7057 477 NORTH CANYONS PW NaN LIVERMORE NaN \n",
"\n",
" REGION POSTCODE ID HASH \n",
"0 NaN 94546 84A-80-16-8 61e5aeb691307e14 \n",
"1 NaN 94546 84A-80-10-12 c1209fa4c910a753 \n",
"2 NaN 94546 84A-80-10-12 b2937bff35d04fb7 \n",
"3 NaN 94546 84A-80-10-12 0072398c846e2fb8 \n",
"4 NaN 94551 905-14-24 9b613ed58f0127ec "
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"address_df.head()"
]
},
{
"cell_type": "code",
"execution_count": 24,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" % Total % Received % Xferd Average Speed Time Time Time Current\n",
" Dload Upload Total Spent Left Speed\n",
"100 375M 100 375M 0 0 46.9M 0 0:00:07 0:00:07 --:--:-- 58.9M\n",
"Archive: California.zip\n",
" inflating: California.geojson \n"
]
}
],
"source": [
"# now lets get some building data\n",
"building_url = \"https://usbuildingdata.blob.core.windows.net/usbuildings-v1-1/California.zip\"\n",
"!curl -LO \"$building_url\" && \\\n",
"unzip \"California.zip\""
]
},
{
"cell_type": "code",
"execution_count": 27,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" % Total % Received % Xferd Average Speed Time Time Time Current\n",
" Dload Upload Total Spent Left Speed\n",
"100 585M 100 585M 0 0 7543k 0 0:01:19 0:01:19 --:--:-- 10.1M\n",
"Archive: norcal-latest-free.shp.zip\n",
" inflating: README \n",
" extracting: gis_osm_buildings_a_free_1.cpg \n",
" inflating: gis_osm_buildings_a_free_1.dbf \n",
" inflating: gis_osm_buildings_a_free_1.prj \n",
" inflating: gis_osm_buildings_a_free_1.shp \n",
" inflating: gis_osm_buildings_a_free_1.shx \n",
" extracting: gis_osm_landuse_a_free_1.cpg \n",
" inflating: gis_osm_landuse_a_free_1.dbf \n",
" inflating: gis_osm_landuse_a_free_1.prj \n",
" inflating: gis_osm_landuse_a_free_1.shp \n",
" inflating: gis_osm_landuse_a_free_1.shx \n",
" extracting: gis_osm_natural_a_free_1.cpg \n",
" inflating: gis_osm_natural_a_free_1.dbf \n",
" inflating: gis_osm_natural_a_free_1.prj \n",
" inflating: gis_osm_natural_a_free_1.shp \n",
" inflating: gis_osm_natural_a_free_1.shx \n",
" extracting: gis_osm_natural_free_1.cpg \n",
" inflating: gis_osm_natural_free_1.dbf \n",
" inflating: gis_osm_natural_free_1.prj \n",
" inflating: gis_osm_natural_free_1.shp \n",
" inflating: gis_osm_natural_free_1.shx \n",
" extracting: gis_osm_places_a_free_1.cpg \n",
" inflating: gis_osm_places_a_free_1.dbf \n",
" inflating: gis_osm_places_a_free_1.prj \n",
" inflating: gis_osm_places_a_free_1.shp \n",
" inflating: gis_osm_places_a_free_1.shx \n",
" extracting: gis_osm_places_free_1.cpg \n",
" inflating: gis_osm_places_free_1.dbf \n",
" inflating: gis_osm_places_free_1.prj \n",
" inflating: gis_osm_places_free_1.shp \n",
" inflating: gis_osm_places_free_1.shx \n",
" extracting: gis_osm_pofw_a_free_1.cpg \n",
" inflating: gis_osm_pofw_a_free_1.dbf \n",
" inflating: gis_osm_pofw_a_free_1.prj \n",
" inflating: gis_osm_pofw_a_free_1.shp \n",
" inflating: gis_osm_pofw_a_free_1.shx \n",
" extracting: gis_osm_pofw_free_1.cpg \n",
" inflating: gis_osm_pofw_free_1.dbf \n",
" inflating: gis_osm_pofw_free_1.prj \n",
" inflating: gis_osm_pofw_free_1.shp \n",
" inflating: gis_osm_pofw_free_1.shx \n",
" extracting: gis_osm_pois_a_free_1.cpg \n",
" inflating: gis_osm_pois_a_free_1.dbf \n",
" inflating: gis_osm_pois_a_free_1.prj \n",
" inflating: gis_osm_pois_a_free_1.shp \n",
" inflating: gis_osm_pois_a_free_1.shx \n",
" extracting: gis_osm_pois_free_1.cpg \n",
" inflating: gis_osm_pois_free_1.dbf \n",
" inflating: gis_osm_pois_free_1.prj \n",
" inflating: gis_osm_pois_free_1.shp \n",
" inflating: gis_osm_pois_free_1.shx \n",
" extracting: gis_osm_railways_free_1.cpg \n",
" inflating: gis_osm_railways_free_1.dbf \n",
" inflating: gis_osm_railways_free_1.prj \n",
" inflating: gis_osm_railways_free_1.shp \n",
" inflating: gis_osm_railways_free_1.shx \n",
" extracting: gis_osm_roads_free_1.cpg \n",
" inflating: gis_osm_roads_free_1.dbf \n",
" inflating: gis_osm_roads_free_1.prj \n",
" inflating: gis_osm_roads_free_1.shp \n",
" inflating: gis_osm_roads_free_1.shx \n",
" extracting: gis_osm_traffic_a_free_1.cpg \n",
" inflating: gis_osm_traffic_a_free_1.dbf \n",
" inflating: gis_osm_traffic_a_free_1.prj \n",
" inflating: gis_osm_traffic_a_free_1.shp \n",
" inflating: gis_osm_traffic_a_free_1.shx \n",
" extracting: gis_osm_traffic_free_1.cpg \n",
" inflating: gis_osm_traffic_free_1.dbf \n",
" inflating: gis_osm_traffic_free_1.prj \n",
" inflating: gis_osm_traffic_free_1.shp \n",
" inflating: gis_osm_traffic_free_1.shx \n",
" extracting: gis_osm_transport_a_free_1.cpg \n",
" inflating: gis_osm_transport_a_free_1.dbf \n",
" inflating: gis_osm_transport_a_free_1.prj \n",
" inflating: gis_osm_transport_a_free_1.shp \n",
" inflating: gis_osm_transport_a_free_1.shx \n",
" extracting: gis_osm_transport_free_1.cpg \n",
" inflating: gis_osm_transport_free_1.dbf \n",
" inflating: gis_osm_transport_free_1.prj \n",
" inflating: gis_osm_transport_free_1.shp \n",
" inflating: gis_osm_transport_free_1.shx \n",
" extracting: gis_osm_water_a_free_1.cpg \n",
" inflating: gis_osm_water_a_free_1.dbf \n",
" inflating: gis_osm_water_a_free_1.prj \n",
" inflating: gis_osm_water_a_free_1.shp \n",
" inflating: gis_osm_water_a_free_1.shx \n",
" extracting: gis_osm_waterways_free_1.cpg \n",
" inflating: gis_osm_waterways_free_1.dbf \n",
" inflating: gis_osm_waterways_free_1.prj \n",
" inflating: gis_osm_waterways_free_1.shp \n",
" inflating: gis_osm_waterways_free_1.shx \n",
" % Total % Received % Xferd Average Speed Time Time Time Current\n",
" Dload Upload Total Spent Left Speed\n",
"100 678M 100 678M 0 0 4233k 0 0:02:44 0:02:44 --:--:-- 4433k 5057k 0 0:02:17 0:00:54 0:01:23 4065k1M 0 0 3910k 0 0:02:57 0:01:45 0:01:12 3180k 4035k 0 0:02:52 0:02:17 0:00:35 6134k0 0 4102k 0 0:02:49 0:02:22 0:00:27 5944k 617M 0 0 4188k 0 0:02:45 0:02:31 0:00:14 5433k\n",
"Archive: socal-latest-free.shp.zip\n",
"replace README? [y]es, [n]o, [A]ll, [N]one, [r]ename: ^C\n"
]
}
],
"source": [
"# now let get the street data\n",
"north_ca_link = \"https://download.geofabrik.de/north-america/us/california/norcal-latest-free.shp.zip\"\n",
"south_ca_link = \"https://download.geofabrik.de/north-america/us/california/socal-latest-free.shp.zip\"\n",
"\n",
"!curl -LO \"$north_ca_link\" && \\\n",
"curl -LO \"$south_ca_link\"\n"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Archive: norcal-latest-free.shp.zip\n",
" inflating: norcal/README \n",
" extracting: norcal/gis_osm_buildings_a_free_1.cpg \n",
" inflating: norcal/gis_osm_buildings_a_free_1.dbf \n",
" inflating: norcal/gis_osm_buildings_a_free_1.prj \n",
" inflating: norcal/gis_osm_buildings_a_free_1.shp \n",
" inflating: norcal/gis_osm_buildings_a_free_1.shx \n",
" extracting: norcal/gis_osm_landuse_a_free_1.cpg \n",
" inflating: norcal/gis_osm_landuse_a_free_1.dbf \n",
" inflating: norcal/gis_osm_landuse_a_free_1.prj \n",
" inflating: norcal/gis_osm_landuse_a_free_1.shp \n",
" inflating: norcal/gis_osm_landuse_a_free_1.shx \n",
" extracting: norcal/gis_osm_natural_a_free_1.cpg \n",
" inflating: norcal/gis_osm_natural_a_free_1.dbf \n",
" inflating: norcal/gis_osm_natural_a_free_1.prj \n",
" inflating: norcal/gis_osm_natural_a_free_1.shp \n",
" inflating: norcal/gis_osm_natural_a_free_1.shx \n",
" extracting: norcal/gis_osm_natural_free_1.cpg \n",
" inflating: norcal/gis_osm_natural_free_1.dbf \n",
" inflating: norcal/gis_osm_natural_free_1.prj \n",
" inflating: norcal/gis_osm_natural_free_1.shp \n",
" inflating: norcal/gis_osm_natural_free_1.shx \n",
" extracting: norcal/gis_osm_places_a_free_1.cpg \n",
" inflating: norcal/gis_osm_places_a_free_1.dbf \n",
" inflating: norcal/gis_osm_places_a_free_1.prj \n",
" inflating: norcal/gis_osm_places_a_free_1.shp \n",
" inflating: norcal/gis_osm_places_a_free_1.shx \n",
" extracting: norcal/gis_osm_places_free_1.cpg \n",
" inflating: norcal/gis_osm_places_free_1.dbf \n",
" inflating: norcal/gis_osm_places_free_1.prj \n",
" inflating: norcal/gis_osm_places_free_1.shp \n",
" inflating: norcal/gis_osm_places_free_1.shx \n",
" extracting: norcal/gis_osm_pofw_a_free_1.cpg \n",
" inflating: norcal/gis_osm_pofw_a_free_1.dbf \n",
" inflating: norcal/gis_osm_pofw_a_free_1.prj \n",
" inflating: norcal/gis_osm_pofw_a_free_1.shp \n",
" inflating: norcal/gis_osm_pofw_a_free_1.shx \n",
" extracting: norcal/gis_osm_pofw_free_1.cpg \n",
" inflating: norcal/gis_osm_pofw_free_1.dbf \n",
" inflating: norcal/gis_osm_pofw_free_1.prj \n",
" inflating: norcal/gis_osm_pofw_free_1.shp \n",
" inflating: norcal/gis_osm_pofw_free_1.shx \n",
" extracting: norcal/gis_osm_pois_a_free_1.cpg \n",
" inflating: norcal/gis_osm_pois_a_free_1.dbf \n",
" inflating: norcal/gis_osm_pois_a_free_1.prj \n",
" inflating: norcal/gis_osm_pois_a_free_1.shp \n",
" inflating: norcal/gis_osm_pois_a_free_1.shx \n",
" extracting: norcal/gis_osm_pois_free_1.cpg \n",
" inflating: norcal/gis_osm_pois_free_1.dbf \n",
" inflating: norcal/gis_osm_pois_free_1.prj \n",
" inflating: norcal/gis_osm_pois_free_1.shp \n",
" inflating: norcal/gis_osm_pois_free_1.shx \n",
" extracting: norcal/gis_osm_railways_free_1.cpg \n",
" inflating: norcal/gis_osm_railways_free_1.dbf \n",
" inflating: norcal/gis_osm_railways_free_1.prj \n",
" inflating: norcal/gis_osm_railways_free_1.shp \n",
" inflating: norcal/gis_osm_railways_free_1.shx \n",
" extracting: norcal/gis_osm_roads_free_1.cpg \n",
" inflating: norcal/gis_osm_roads_free_1.dbf \n",
" inflating: norcal/gis_osm_roads_free_1.prj \n",
" inflating: norcal/gis_osm_roads_free_1.shp \n",
" inflating: norcal/gis_osm_roads_free_1.shx \n",
" extracting: norcal/gis_osm_traffic_a_free_1.cpg \n",
" inflating: norcal/gis_osm_traffic_a_free_1.dbf \n",
" inflating: norcal/gis_osm_traffic_a_free_1.prj \n",
" inflating: norcal/gis_osm_traffic_a_free_1.shp \n",
" inflating: norcal/gis_osm_traffic_a_free_1.shx \n",
" extracting: norcal/gis_osm_traffic_free_1.cpg \n",
" inflating: norcal/gis_osm_traffic_free_1.dbf \n",
" inflating: norcal/gis_osm_traffic_free_1.prj \n",
" inflating: norcal/gis_osm_traffic_free_1.shp \n",
" inflating: norcal/gis_osm_traffic_free_1.shx \n",
" extracting: norcal/gis_osm_transport_a_free_1.cpg \n",
" inflating: norcal/gis_osm_transport_a_free_1.dbf \n",
" inflating: norcal/gis_osm_transport_a_free_1.prj \n",
" inflating: norcal/gis_osm_transport_a_free_1.shp \n",
" inflating: norcal/gis_osm_transport_a_free_1.shx \n",
" extracting: norcal/gis_osm_transport_free_1.cpg \n",
" inflating: norcal/gis_osm_transport_free_1.dbf \n",
" inflating: norcal/gis_osm_transport_free_1.prj \n",
" inflating: norcal/gis_osm_transport_free_1.shp \n",
" inflating: norcal/gis_osm_transport_free_1.shx \n",
" extracting: norcal/gis_osm_water_a_free_1.cpg \n",
" inflating: norcal/gis_osm_water_a_free_1.dbf \n",
" inflating: norcal/gis_osm_water_a_free_1.prj \n",
" inflating: norcal/gis_osm_water_a_free_1.shp \n",
" inflating: norcal/gis_osm_water_a_free_1.shx \n",
" extracting: norcal/gis_osm_waterways_free_1.cpg \n",
" inflating: norcal/gis_osm_waterways_free_1.dbf \n",
" inflating: norcal/gis_osm_waterways_free_1.prj \n",
" inflating: norcal/gis_osm_waterways_free_1.shp \n",
" inflating: norcal/gis_osm_waterways_free_1.shx \n",
"Archive: socal-latest-free.shp.zip\n",
" inflating: socal/README \n",
" extracting: socal/gis_osm_buildings_a_free_1.cpg \n",
" inflating: socal/gis_osm_buildings_a_free_1.dbf \n",
" inflating: socal/gis_osm_buildings_a_free_1.prj \n",
" inflating: socal/gis_osm_buildings_a_free_1.shp \n",
" inflating: socal/gis_osm_buildings_a_free_1.shx \n",
" extracting: socal/gis_osm_landuse_a_free_1.cpg \n",
" inflating: socal/gis_osm_landuse_a_free_1.dbf \n",
" inflating: socal/gis_osm_landuse_a_free_1.prj \n",
" inflating: socal/gis_osm_landuse_a_free_1.shp \n",
" inflating: socal/gis_osm_landuse_a_free_1.shx \n",
" extracting: socal/gis_osm_natural_a_free_1.cpg \n",
" inflating: socal/gis_osm_natural_a_free_1.dbf \n",
" inflating: socal/gis_osm_natural_a_free_1.prj \n",
" inflating: socal/gis_osm_natural_a_free_1.shp \n",
" inflating: socal/gis_osm_natural_a_free_1.shx \n",
" extracting: socal/gis_osm_natural_free_1.cpg \n",
" inflating: socal/gis_osm_natural_free_1.dbf \n",
" inflating: socal/gis_osm_natural_free_1.prj \n",
" inflating: socal/gis_osm_natural_free_1.shp \n",
" inflating: socal/gis_osm_natural_free_1.shx \n",
" extracting: socal/gis_osm_places_a_free_1.cpg \n",
" inflating: socal/gis_osm_places_a_free_1.dbf \n",
" inflating: socal/gis_osm_places_a_free_1.prj \n",
" inflating: socal/gis_osm_places_a_free_1.shp \n",
" inflating: socal/gis_osm_places_a_free_1.shx \n",
" extracting: socal/gis_osm_places_free_1.cpg \n",
" inflating: socal/gis_osm_places_free_1.dbf \n",
" inflating: socal/gis_osm_places_free_1.prj \n",
" inflating: socal/gis_osm_places_free_1.shp \n",
" inflating: socal/gis_osm_places_free_1.shx \n",
" extracting: socal/gis_osm_pofw_a_free_1.cpg \n",
" inflating: socal/gis_osm_pofw_a_free_1.dbf \n",
" inflating: socal/gis_osm_pofw_a_free_1.prj \n",
" inflating: socal/gis_osm_pofw_a_free_1.shp \n",
" inflating: socal/gis_osm_pofw_a_free_1.shx \n",
" extracting: socal/gis_osm_pofw_free_1.cpg \n",
" inflating: socal/gis_osm_pofw_free_1.dbf \n",
" inflating: socal/gis_osm_pofw_free_1.prj \n",
" inflating: socal/gis_osm_pofw_free_1.shp \n",
" inflating: socal/gis_osm_pofw_free_1.shx \n",
" extracting: socal/gis_osm_pois_a_free_1.cpg \n",
" inflating: socal/gis_osm_pois_a_free_1.dbf \n",
" inflating: socal/gis_osm_pois_a_free_1.prj \n",
" inflating: socal/gis_osm_pois_a_free_1.shp \n",
" inflating: socal/gis_osm_pois_a_free_1.shx \n",
" extracting: socal/gis_osm_pois_free_1.cpg \n",
" inflating: socal/gis_osm_pois_free_1.dbf \n",
" inflating: socal/gis_osm_pois_free_1.prj \n",
" inflating: socal/gis_osm_pois_free_1.shp \n",
" inflating: socal/gis_osm_pois_free_1.shx \n",
" extracting: socal/gis_osm_railways_free_1.cpg \n",
" inflating: socal/gis_osm_railways_free_1.dbf \n",
" inflating: socal/gis_osm_railways_free_1.prj \n",
" inflating: socal/gis_osm_railways_free_1.shp \n",
" inflating: socal/gis_osm_railways_free_1.shx \n",
" extracting: socal/gis_osm_roads_free_1.cpg \n",
" inflating: socal/gis_osm_roads_free_1.dbf \n",
" inflating: socal/gis_osm_roads_free_1.prj \n",
" inflating: socal/gis_osm_roads_free_1.shp \n",
" inflating: socal/gis_osm_roads_free_1.shx \n",
" extracting: socal/gis_osm_traffic_a_free_1.cpg \n",
" inflating: socal/gis_osm_traffic_a_free_1.dbf \n",
" inflating: socal/gis_osm_traffic_a_free_1.prj \n",
" inflating: socal/gis_osm_traffic_a_free_1.shp \n",
" inflating: socal/gis_osm_traffic_a_free_1.shx \n",
" extracting: socal/gis_osm_traffic_free_1.cpg \n",
" inflating: socal/gis_osm_traffic_free_1.dbf \n",
" inflating: socal/gis_osm_traffic_free_1.prj \n",
" inflating: socal/gis_osm_traffic_free_1.shp \n",
" inflating: socal/gis_osm_traffic_free_1.shx \n",
" extracting: socal/gis_osm_transport_a_free_1.cpg \n",
" inflating: socal/gis_osm_transport_a_free_1.dbf \n",
" inflating: socal/gis_osm_transport_a_free_1.prj \n",
" inflating: socal/gis_osm_transport_a_free_1.shp \n",
" inflating: socal/gis_osm_transport_a_free_1.shx \n",
" extracting: socal/gis_osm_transport_free_1.cpg \n",
" inflating: socal/gis_osm_transport_free_1.dbf \n",
" inflating: socal/gis_osm_transport_free_1.prj \n",
" inflating: socal/gis_osm_transport_free_1.shp \n",
" inflating: socal/gis_osm_transport_free_1.shx \n",
" extracting: socal/gis_osm_water_a_free_1.cpg \n",
" inflating: socal/gis_osm_water_a_free_1.dbf \n",
" inflating: socal/gis_osm_water_a_free_1.prj \n",
" inflating: socal/gis_osm_water_a_free_1.shp \n",
" inflating: socal/gis_osm_water_a_free_1.shx \n",
" extracting: socal/gis_osm_waterways_free_1.cpg \n",
" inflating: socal/gis_osm_waterways_free_1.dbf \n",
" inflating: socal/gis_osm_waterways_free_1.prj \n",
" inflating: socal/gis_osm_waterways_free_1.shp \n",
" inflating: socal/gis_osm_waterways_free_1.shx \n"
]
}
],
"source": [
"!mkdir \"norcal\" && \\\n",
"mkdir \"socal\" && \\\n",
"unzip -o \"norcal-latest-free.shp.zip\" -d \"norcal\" && \\\n",
"unzip -o \"socal-latest-free.shp.zip\" -d \"socal\""
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Data gathering complete\n",
"\n",
"So now that we have the following:\n",
"\n",
"1. 477 data\n",
"2. census blocks\n",
"3. address points\n",
"4. building outlines\n",
"5. OSM streets etc.\n"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.6"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Raw
Cali_broadband.py
# coding: utf-8
# # An exploration of the broadband speeds in Cali
#
# It always interesting that there may be data but it is prohibitvely expensive or lacks the detail required.
#
# Inspired by the recent post from the [Financial Times](https://ig.ft.com/gb-broadband-speed-map/#methodology) can we develop an analogous analysis for California?
#
# Our methodology is slighly different following the steps below to disaggregate the data collected by the FCC.
#
# Could this data be a treasure trove for consumers and operators? [link](https://morningconsult.com/opinions/fcc-form-477-is-a-marketing-opportunity-not-a-regulatory-burden/)
#
# ## Create e2e test case for California
# 1. Get form 477 data
# 2. Source the census blocks
# 3. Source address points, streets, buildings etc
# 4. Join the Form 477 data to the polygon census blocks by ID - about the data, the data
# 5. Cut the data to each census block using ogr2ogr, or quad tree methodology
# 6. Develop feature extraction capability. This may be as simple as counts or as complex as distance from nearest street for addresses.
# 7. Create train, validate, test data set (No sure how we should sample as I think there will be a misrepresentation of different sizes of areas etc. will need to examine the distribution. Might need to to a research review on this? [example approach](https://www.esri.com/esri-news/arcuser/spring-2013/unequal-probability-based-spatial-sampling))
# 8. Build test model
# 9. Iterate on features
# ...
# In[1]:
# Step 1: Get the data
# Turns out there are multiple years of data, we are interested in the most
# recent but we should also examine the trends and data quality.
# It's also possible to get the data that shows satelite service to. Lets ignore that.
# The data is also somewhat latent and there are only 2 sample years at the moment.
# Hopefully we can revistit and update soon, with new data!
all_2015_dec_v2 = "http://transition.fcc.gov/form477/BroadbandData/Fixed/Dec15/Version%202/US-Fixed-without-Satellite-Dec2015.zip"
ca_2015_dec_v2 = "https://www.fcc.gov/form477/BroadbandData/Fixed/Dec15/Version%202/CA-Fixed-Dec2015.zip"
ca_2015_jun_v2 = "https://www.fcc.gov/form477/BroadbandData/Fixed/Jun15/Version%202/CA-Fixed-Jun2015.zip"
ca_2014_dec_v2 = "https://www.fcc.gov/form477/BroadbandData/Fixed/Dec14/Version2/CA-Fixed-Dec2014.zip"
# In[2]:
get_ipython().system('curl -LO "$ca_2015_dec_v2" && unzip "CA-Fixed-Dec2015.zip" && curl -LO "$ca_2015_jun_v2" && unzip "CA-Fixed-Jun2015.zip" && curl -LO "$ca_2014_dec_v2" && unzip "CA-Fixed-Dec2014.zip"')
# In[1]:
import pandas as pd
import geopandas as gpd
# In[2]:
ca_dec_15_df = pd.read_csv("CA-Fixed-Dec2015-v2.csv")
ca_jun_15_df = pd.read_csv("CA-Fixed-Jun2015-v2.csv")
ca_dec_14_df = pd.read_csv("CA-Fixed-Dec2014-v2.csv")
# In[3]:
ca_dec_15_df.head()
# In[4]:
# OK so now we have downloaded the block SHP file from the TIGER site
# https://www.census.gov/cgi-bin/geo/shapefiles/index.php?year=2018&layergroup=Blocks+%282010%29
get_ipython().run_line_magic('matplotlib', 'inline')
census_blocks_gis = gpd.read_file("tl_2018_06_tabblock10.shp")
# In[5]:
# Let's make sure that there are objects
census_blocks_gis.geometry[0]
# In[6]:
# Next let's get the address data
add_west_url = "https://s3.amazonaws.com/data.openaddresses.io/openaddr-collected-us_west.zip"
get_ipython().system('curl -LO "$add_west_url"')
# In[7]:
get_ipython().system('unzip "openaddr-collected-us_west.zip"')
# In[17]:
import os
os.getcwd()
# In[16]:
get_ipython().system('sed -n 1p ./us/ca/humboldt.csv > all_ca.csv')
# In[18]:
get_ipython().system('sed 1d ./us/ca/*.csv >> all_ca.csv')
# In[19]:
address_df = pd.read_csv("all_ca.csv")
# In[20]:
address_df.head()
# In[24]:
# now lets get some building data
building_url = "https://usbuildingdata.blob.core.windows.net/usbuildings-v1-1/California.zip"
get_ipython().system('curl -LO "$building_url" && unzip "California.zip"')
# In[27]:
# now let get the street data
north_ca_link = "https://download.geofabrik.de/north-america/us/california/norcal-latest-free.shp.zip"
south_ca_link = "https://download.geofabrik.de/north-america/us/california/socal-latest-free.shp.zip"
get_ipython().system('curl -LO "$north_ca_link" && curl -LO "$south_ca_link"')
# In[31]:
get_ipython().system('mkdir "norcal" && mkdir "socal" && unzip -o "norcal-latest-free.shp.zip" -d "norcal" && unzip -o "socal-latest-free.shp.zip" -d "socal"')
# ## Data gathering complete
#
# So now that we have the following:
#
# 1. 477 data
# 2. census blocks
# 3. address points
# 4. building outlines
# 5. OSM streets etc.
#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment