1.2-tcad-exploratory.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# TCAD Exploratory Analysis\n",
    "\n",
    "Prerequisites: This notebook relies on the raw TCAD already being parsed and stored as parquet files."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The autoreload extension is already loaded. To reload it, use:\n",
      "  %reload_ext autoreload\n"
     ]
    }
   ],
   "source": [
    "%load_ext autoreload\n",
    "%autoreload 2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "First, the preprocessed parquet files are loaded in from the specified directory using a custom package (tcad).\n",
    "The required files include prop.parquet, imp_info.parquet, imp_det.parquet, and imp_atr.parquet."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tcad.selector as tcs\n",
    "\n",
    "tables = tcs.Selector('data/processed/TCAD')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The dataframes can be accessed directly as properties of the Selector object."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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>prop_id</th>\n",
       "      <th>prop_type_cd</th>\n",
       "      <th>prop_val_yr</th>\n",
       "      <th>geo_id</th>\n",
       "      <th>partial_owner</th>\n",
       "      <th>udi_group</th>\n",
       "      <th>situs_street_prefx</th>\n",
       "      <th>situs_street</th>\n",
       "      <th>situs_street_suffix</th>\n",
       "      <th>situs_city</th>\n",
       "      <th>...</th>\n",
       "      <th>dataset_id</th>\n",
       "      <th>deed_num</th>\n",
       "      <th>exemption_percentage</th>\n",
       "      <th>sic_code</th>\n",
       "      <th>omitted_imprv_hstd_val</th>\n",
       "      <th>omitted_imprv_non_hstd_val</th>\n",
       "      <th>pp_late_interstate_allocation_val</th>\n",
       "      <th>appraised_val_reflecting_productivity_loss</th>\n",
       "      <th>assessed_val_reflecting_productivity_loss</th>\n",
       "      <th>late_correction_val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>100008</td>\n",
       "      <td>R</td>\n",
       "      <td>2023</td>\n",
       "      <td>0100030105</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>S</td>\n",
       "      <td>LAMAR</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2014035621TR</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>100012</td>\n",
       "      <td>R</td>\n",
       "      <td>2023</td>\n",
       "      <td>0100030109</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>S</td>\n",
       "      <td>LAMAR</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2011172140TR</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 57 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   prop_id prop_type_cd  prop_val_yr      geo_id partial_owner  udi_group  \\\n",
       "0   100008            R         2023  0100030105             F          0   \n",
       "1   100012            R         2023  0100030109             F          0   \n",
       "\n",
       "  situs_street_prefx situs_street situs_street_suffix situs_city  ...  \\\n",
       "0                  S        LAMAR                BLVD        NaN  ...   \n",
       "1                  S        LAMAR                BLVD        NaN  ...   \n",
       "\n",
       "  dataset_id      deed_num  exemption_percentage  sic_code  \\\n",
       "0          0  2014035621TR                     0       NaN   \n",
       "1          0  2011172140TR                     0       NaN   \n",
       "\n",
       "  omitted_imprv_hstd_val omitted_imprv_non_hstd_val  \\\n",
       "0                      0                          0   \n",
       "1                      0                          0   \n",
       "\n",
       "  pp_late_interstate_allocation_val  \\\n",
       "0                                 0   \n",
       "1                                 0   \n",
       "\n",
       "  appraised_val_reflecting_productivity_loss  \\\n",
       "0                                          0   \n",
       "1                                          0   \n",
       "\n",
       "   assessed_val_reflecting_productivity_loss  late_correction_val  \n",
       "0                                          0                    0  \n",
       "1                                          0                    0  \n",
       "\n",
       "[2 rows x 57 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>prop_id</th>\n",
       "      <th>prop_val_yr</th>\n",
       "      <th>imprv_id</th>\n",
       "      <th>imprv_type_cd</th>\n",
       "      <th>imprv_type_desc</th>\n",
       "      <th>imprv_state_cd</th>\n",
       "      <th>imprv_homesite</th>\n",
       "      <th>imprv_val</th>\n",
       "      <th>imprv_homesite_pct</th>\n",
       "      <th>omitted</th>\n",
       "      <th>omitted_imprv_val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>100008</td>\n",
       "      <td>2023</td>\n",
       "      <td>5225541</td>\n",
       "      <td>00</td>\n",
       "      <td>Detail Only</td>\n",
       "      <td>F1</td>\n",
       "      <td>N</td>\n",
       "      <td>12278</td>\n",
       "      <td>100.0</td>\n",
       "      <td>N</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>100008</td>\n",
       "      <td>2023</td>\n",
       "      <td>5225542</td>\n",
       "      <td>32</td>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>F1</td>\n",
       "      <td>N</td>\n",
       "      <td>176710</td>\n",
       "      <td>100.0</td>\n",
       "      <td>N</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   prop_id  prop_val_yr  imprv_id imprv_type_cd imprv_type_desc  \\\n",
       "0   100008         2023   5225541            00     Detail Only   \n",
       "1   100008         2023   5225542            32      RESTAURANT   \n",
       "\n",
       "  imprv_state_cd imprv_homesite  imprv_val  imprv_homesite_pct omitted  \\\n",
       "0             F1              N      12278               100.0       N   \n",
       "1             F1              N     176710               100.0       N   \n",
       "\n",
       "   omitted_imprv_val  \n",
       "0                  0  \n",
       "1                  0  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>prop_id</th>\n",
       "      <th>prop_val_yr</th>\n",
       "      <th>imprv_id</th>\n",
       "      <th>imprv_det_id</th>\n",
       "      <th>Imprv_det_type_cd</th>\n",
       "      <th>Imprv_det_type_desc</th>\n",
       "      <th>Imprv_det_class_cd</th>\n",
       "      <th>yr_built</th>\n",
       "      <th>depreciation_yr</th>\n",
       "      <th>imprv_det_area</th>\n",
       "      <th>imprv_det_val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>100008</td>\n",
       "      <td>2023</td>\n",
       "      <td>5225541</td>\n",
       "      <td>41038597</td>\n",
       "      <td>551</td>\n",
       "      <td>PAVED AREA</td>\n",
       "      <td>AA</td>\n",
       "      <td>1984</td>\n",
       "      <td>1984</td>\n",
       "      <td>17100</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>100008</td>\n",
       "      <td>2023</td>\n",
       "      <td>5225542</td>\n",
       "      <td>41038598</td>\n",
       "      <td>1ST</td>\n",
       "      <td>1st Floor</td>\n",
       "      <td>C</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013</td>\n",
       "      <td>2986</td>\n",
       "      <td>161525</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   prop_id  prop_val_yr  imprv_id  imprv_det_id Imprv_det_type_cd  \\\n",
       "0   100008         2023   5225541      41038597               551   \n",
       "1   100008         2023   5225542      41038598               1ST   \n",
       "\n",
       "  Imprv_det_type_desc Imprv_det_class_cd  yr_built  depreciation_yr  \\\n",
       "0          PAVED AREA                 AA      1984             1984   \n",
       "1           1st Floor                  C      2013             2013   \n",
       "\n",
       "   imprv_det_area  imprv_det_val  \n",
       "0           17100              0  \n",
       "1            2986         161525  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>prop_id</th>\n",
       "      <th>prop_val_yr</th>\n",
       "      <th>imprv_id</th>\n",
       "      <th>imprv_type_cd</th>\n",
       "      <th>imprv_type_desc</th>\n",
       "      <th>imprv_state_cd</th>\n",
       "      <th>imprv_homesite</th>\n",
       "      <th>imprv_val</th>\n",
       "      <th>imprv_homesite_pct</th>\n",
       "      <th>omitted</th>\n",
       "      <th>omitted_imprv_val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>100008</td>\n",
       "      <td>2023</td>\n",
       "      <td>5225541</td>\n",
       "      <td>00</td>\n",
       "      <td>Detail Only</td>\n",
       "      <td>F1</td>\n",
       "      <td>N</td>\n",
       "      <td>12278</td>\n",
       "      <td>100.0</td>\n",
       "      <td>N</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>100008</td>\n",
       "      <td>2023</td>\n",
       "      <td>5225542</td>\n",
       "      <td>32</td>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>F1</td>\n",
       "      <td>N</td>\n",
       "      <td>176710</td>\n",
       "      <td>100.0</td>\n",
       "      <td>N</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   prop_id  prop_val_yr  imprv_id imprv_type_cd imprv_type_desc  \\\n",
       "0   100008         2023   5225541            00     Detail Only   \n",
       "1   100008         2023   5225542            32      RESTAURANT   \n",
       "\n",
       "  imprv_state_cd imprv_homesite  imprv_val  imprv_homesite_pct omitted  \\\n",
       "0             F1              N      12278               100.0       N   \n",
       "1             F1              N     176710               100.0       N   \n",
       "\n",
       "   omitted_imprv_val  \n",
       "0                  0  \n",
       "1                  0  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(tables.prop_df.head(2))\n",
    "display(tables.imp_info_df.head(2))\n",
    "display(tables.imp_det_df.head(2))\n",
    "display(tables.imp_info_df.head(2))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can also search for specific zip codes or building types provided as a string or list of strings. This will return a new selector object, which you use the above functions to access the dataframes. This also makes it possible to chain function calls to an extent"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "tables2 = tables.query(bldg_types='1 FAM DWELLING',zip_codes=['78733','78741'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The get_single_family_building_summary combines data from the four dataframes in the Selector into a single dataframe and returns it. Internally, it will also limit results to single family buildings as data for other types is structured differently and not handled correctly at this time.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>prop_id</th>\n",
       "      <th>imprv_id</th>\n",
       "      <th>prop_val_yr_x</th>\n",
       "      <th>situs_num</th>\n",
       "      <th>situs_street_prefx</th>\n",
       "      <th>situs_street</th>\n",
       "      <th>situs_street_suffix</th>\n",
       "      <th>situs_unit</th>\n",
       "      <th>situs_city</th>\n",
       "      <th>situs_zip</th>\n",
       "      <th>...</th>\n",
       "      <th>imprv_non_hstd_val</th>\n",
       "      <th>market_value</th>\n",
       "      <th>ten_percent_cap</th>\n",
       "      <th>assessed_val</th>\n",
       "      <th>imprv_homesite</th>\n",
       "      <th>imprv_homesite_pct</th>\n",
       "      <th>en_exempt</th>\n",
       "      <th>pc_exempt</th>\n",
       "      <th>so_exempt</th>\n",
       "      <th>eco_exempt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>100027</td>\n",
       "      <td>5225554</td>\n",
       "      <td>2023</td>\n",
       "      <td>1008</td>\n",
       "      <td>S</td>\n",
       "      <td>8</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78704</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1005168</td>\n",
       "      <td>244300</td>\n",
       "      <td>760868</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>100037</td>\n",
       "      <td>5225569</td>\n",
       "      <td>2023</td>\n",
       "      <td>1107</td>\n",
       "      <td>W</td>\n",
       "      <td>MONROE</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78704</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2164466</td>\n",
       "      <td>550786</td>\n",
       "      <td>1613680</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>100038</td>\n",
       "      <td>5225571</td>\n",
       "      <td>2023</td>\n",
       "      <td>1105</td>\n",
       "      <td>W</td>\n",
       "      <td>MONROE</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78704</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2242846</td>\n",
       "      <td>0</td>\n",
       "      <td>2242846</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>100039</td>\n",
       "      <td>5225572</td>\n",
       "      <td>2023</td>\n",
       "      <td>1103</td>\n",
       "      <td>W</td>\n",
       "      <td>MONROE</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>78704</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1619220</td>\n",
       "      <td>46220</td>\n",
       "      <td>1573000</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100040</td>\n",
       "      <td>5225573</td>\n",
       "      <td>2023</td>\n",
       "      <td>1011</td>\n",
       "      <td>W</td>\n",
       "      <td>MONROE</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78704</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1346000</td>\n",
       "      <td>260714</td>\n",
       "      <td>1085286</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296777</th>\n",
       "      <td>975099</td>\n",
       "      <td>5784718</td>\n",
       "      <td>2023</td>\n",
       "      <td>801</td>\n",
       "      <td>W</td>\n",
       "      <td>JOHANNA</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78704</td>\n",
       "      <td>...</td>\n",
       "      <td>134857</td>\n",
       "      <td>1051063</td>\n",
       "      <td>0</td>\n",
       "      <td>1051063</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296778</th>\n",
       "      <td>975133</td>\n",
       "      <td>5786764</td>\n",
       "      <td>2023</td>\n",
       "      <td>1610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HOUSTON</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1911868</td>\n",
       "      <td>0</td>\n",
       "      <td>1911868</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296779</th>\n",
       "      <td>975190</td>\n",
       "      <td>5784797</td>\n",
       "      <td>2023</td>\n",
       "      <td>5408</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JEFF DAVIS</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78756</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2566535</td>\n",
       "      <td>0</td>\n",
       "      <td>2566535</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296780</th>\n",
       "      <td>975415</td>\n",
       "      <td>5785429</td>\n",
       "      <td>2023</td>\n",
       "      <td>8401</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HUB</td>\n",
       "      <td>CV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78759</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1266721</td>\n",
       "      <td>0</td>\n",
       "      <td>1266721</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296781</th>\n",
       "      <td>976808</td>\n",
       "      <td>5802762</td>\n",
       "      <td>2023</td>\n",
       "      <td>20722</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORDILL</td>\n",
       "      <td>LN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78669</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>935058</td>\n",
       "      <td>0</td>\n",
       "      <td>935058</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>296782 rows × 47 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        prop_id  imprv_id  prop_val_yr_x situs_num situs_street_prefx  \\\n",
       "0        100027   5225554           2023      1008                  S   \n",
       "1        100037   5225569           2023      1107                  W   \n",
       "2        100038   5225571           2023      1105                  W   \n",
       "3        100039   5225572           2023      1103                  W   \n",
       "4        100040   5225573           2023      1011                  W   \n",
       "...         ...       ...            ...       ...                ...   \n",
       "296777   975099   5784718           2023       801                  W   \n",
       "296778   975133   5786764           2023      1610                NaN   \n",
       "296779   975190   5784797           2023      5408                NaN   \n",
       "296780   975415   5785429           2023      8401                NaN   \n",
       "296781   976808   5802762           2023     20722                NaN   \n",
       "\n",
       "       situs_street situs_street_suffix situs_unit situs_city situs_zip  ...  \\\n",
       "0                 8                  ST        NaN        NaN     78704  ...   \n",
       "1            MONROE                  ST        NaN        NaN     78704  ...   \n",
       "2            MONROE                  ST        NaN        NaN     78704  ...   \n",
       "3            MONROE                  ST        NaN     AUSTIN     78704  ...   \n",
       "4            MONROE                  ST        NaN        NaN     78704  ...   \n",
       "...             ...                 ...        ...        ...       ...  ...   \n",
       "296777      JOHANNA                  ST        NaN        NaN     78704  ...   \n",
       "296778      HOUSTON                  ST        NaN        NaN       NaN  ...   \n",
       "296779   JEFF DAVIS                 AVE        NaN        NaN     78756  ...   \n",
       "296780          HUB                  CV        NaN        NaN     78759  ...   \n",
       "296781      CORDILL                  LN        NaN        NaN     78669  ...   \n",
       "\n",
       "        imprv_non_hstd_val  market_value  ten_percent_cap  assessed_val  \\\n",
       "0                        0       1005168           244300        760868   \n",
       "1                        0       2164466           550786       1613680   \n",
       "2                        0       2242846                0       2242846   \n",
       "3                        0       1619220            46220       1573000   \n",
       "4                        0       1346000           260714       1085286   \n",
       "...                    ...           ...              ...           ...   \n",
       "296777              134857       1051063                0       1051063   \n",
       "296778                   0       1911868                0       1911868   \n",
       "296779                   0       2566535                0       2566535   \n",
       "296780                   0       1266721                0       1266721   \n",
       "296781                   0        935058                0        935058   \n",
       "\n",
       "        imprv_homesite  imprv_homesite_pct  en_exempt  pc_exempt  so_exempt  \\\n",
       "0                    Y               100.0          F          F          F   \n",
       "1                    Y               100.0          F          F          F   \n",
       "2                    Y               100.0          F          F          F   \n",
       "3                    Y               100.0          F          F          F   \n",
       "4                    Y               100.0          F          F          F   \n",
       "...                ...                 ...        ...        ...        ...   \n",
       "296777               Y               100.0          F          F          F   \n",
       "296778               Y               100.0          F          F          F   \n",
       "296779               Y               100.0          F          F          F   \n",
       "296780               Y               100.0          F          F          F   \n",
       "296781               Y               100.0          F          F          F   \n",
       "\n",
       "       eco_exempt  \n",
       "0               F  \n",
       "1               F  \n",
       "2               F  \n",
       "3               F  \n",
       "4               F  \n",
       "...           ...  \n",
       "296777          F  \n",
       "296778          F  \n",
       "296779          F  \n",
       "296780          F  \n",
       "296781          F  \n",
       "\n",
       "[296782 rows x 47 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables.get_single_family_building_summary()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "An example of chaining:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "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>prop_id</th>\n",
       "      <th>imprv_id</th>\n",
       "      <th>prop_val_yr_x</th>\n",
       "      <th>situs_num</th>\n",
       "      <th>situs_street_prefx</th>\n",
       "      <th>situs_street</th>\n",
       "      <th>situs_street_suffix</th>\n",
       "      <th>situs_unit</th>\n",
       "      <th>situs_city</th>\n",
       "      <th>situs_zip</th>\n",
       "      <th>...</th>\n",
       "      <th>imprv_non_hstd_val</th>\n",
       "      <th>market_value</th>\n",
       "      <th>ten_percent_cap</th>\n",
       "      <th>assessed_val</th>\n",
       "      <th>imprv_homesite</th>\n",
       "      <th>imprv_homesite_pct</th>\n",
       "      <th>en_exempt</th>\n",
       "      <th>pc_exempt</th>\n",
       "      <th>so_exempt</th>\n",
       "      <th>eco_exempt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>108470</td>\n",
       "      <td>5232774</td>\n",
       "      <td>2023</td>\n",
       "      <td>3107</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POINT O WOODS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>78733</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1907098</td>\n",
       "      <td>597771</td>\n",
       "      <td>1309327</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>108472</td>\n",
       "      <td>5232776</td>\n",
       "      <td>2023</td>\n",
       "      <td>3103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POINT O WOODS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78733</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>3404582</td>\n",
       "      <td>1247031</td>\n",
       "      <td>2157551</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>113905</td>\n",
       "      <td>5237403</td>\n",
       "      <td>2023</td>\n",
       "      <td>3001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CREEKS EDGE</td>\n",
       "      <td>PKWY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>78733</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1869601</td>\n",
       "      <td>720989</td>\n",
       "      <td>1148612</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>113907</td>\n",
       "      <td>5237404</td>\n",
       "      <td>2023</td>\n",
       "      <td>3005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CREEKS EDGE</td>\n",
       "      <td>PKWY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>78733</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1467199</td>\n",
       "      <td>508996</td>\n",
       "      <td>958203</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>113908</td>\n",
       "      <td>5237405</td>\n",
       "      <td>2023</td>\n",
       "      <td>3007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CREEKS EDGE</td>\n",
       "      <td>PKWY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>78733</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1534618</td>\n",
       "      <td>519997</td>\n",
       "      <td>1014621</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6426</th>\n",
       "      <td>971361</td>\n",
       "      <td>5783031</td>\n",
       "      <td>2023</td>\n",
       "      <td>6206</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FELIX</td>\n",
       "      <td>AVE</td>\n",
       "      <td>B</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78741</td>\n",
       "      <td>...</td>\n",
       "      <td>189236</td>\n",
       "      <td>227236</td>\n",
       "      <td>0</td>\n",
       "      <td>227236</td>\n",
       "      <td>N</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6427</th>\n",
       "      <td>971372</td>\n",
       "      <td>5783040</td>\n",
       "      <td>2023</td>\n",
       "      <td>6215</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HOGAN</td>\n",
       "      <td>AVE</td>\n",
       "      <td>A</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78741</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>519224</td>\n",
       "      <td>0</td>\n",
       "      <td>519224</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6428</th>\n",
       "      <td>971373</td>\n",
       "      <td>5783044</td>\n",
       "      <td>2023</td>\n",
       "      <td>6215</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HOGAN</td>\n",
       "      <td>AVE</td>\n",
       "      <td>B</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78741</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>278006</td>\n",
       "      <td>0</td>\n",
       "      <td>278006</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6429</th>\n",
       "      <td>974334</td>\n",
       "      <td>5784149</td>\n",
       "      <td>2023</td>\n",
       "      <td>6215</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CLUB</td>\n",
       "      <td>TER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78741</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>585314</td>\n",
       "      <td>0</td>\n",
       "      <td>585314</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6430</th>\n",
       "      <td>974335</td>\n",
       "      <td>5784145</td>\n",
       "      <td>2023</td>\n",
       "      <td>1012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MONTOPOLIS</td>\n",
       "      <td>DR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78741</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>43000</td>\n",
       "      <td>0</td>\n",
       "      <td>43000</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6431 rows × 44 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      prop_id  imprv_id  prop_val_yr_x situs_num situs_street_prefx  \\\n",
       "0      108470   5232774           2023      3107                NaN   \n",
       "1      108472   5232776           2023      3103                NaN   \n",
       "2      113905   5237403           2023      3001                NaN   \n",
       "3      113907   5237404           2023      3005                NaN   \n",
       "4      113908   5237405           2023      3007                NaN   \n",
       "...       ...       ...            ...       ...                ...   \n",
       "6426   971361   5783031           2023      6206                NaN   \n",
       "6427   971372   5783040           2023      6215                NaN   \n",
       "6428   971373   5783044           2023      6215                NaN   \n",
       "6429   974334   5784149           2023      6215                NaN   \n",
       "6430   974335   5784145           2023      1012                NaN   \n",
       "\n",
       "       situs_street situs_street_suffix situs_unit situs_city situs_zip  ...  \\\n",
       "0     POINT O WOODS                 NaN        NaN     AUSTIN     78733  ...   \n",
       "1     POINT O WOODS                 NaN        NaN        NaN     78733  ...   \n",
       "2       CREEKS EDGE                PKWY        NaN     AUSTIN     78733  ...   \n",
       "3       CREEKS EDGE                PKWY        NaN     AUSTIN     78733  ...   \n",
       "4       CREEKS EDGE                PKWY        NaN     AUSTIN     78733  ...   \n",
       "...             ...                 ...        ...        ...       ...  ...   \n",
       "6426          FELIX                 AVE          B        NaN     78741  ...   \n",
       "6427          HOGAN                 AVE          A        NaN     78741  ...   \n",
       "6428          HOGAN                 AVE          B        NaN     78741  ...   \n",
       "6429           CLUB                 TER        NaN        NaN     78741  ...   \n",
       "6430     MONTOPOLIS                  DR        NaN        NaN     78741  ...   \n",
       "\n",
       "      imprv_non_hstd_val  market_value  ten_percent_cap  assessed_val  \\\n",
       "0                      0       1907098           597771       1309327   \n",
       "1                      0       3404582          1247031       2157551   \n",
       "2                      0       1869601           720989       1148612   \n",
       "3                      0       1467199           508996        958203   \n",
       "4                      0       1534618           519997       1014621   \n",
       "...                  ...           ...              ...           ...   \n",
       "6426              189236        227236                0        227236   \n",
       "6427                   0        519224                0        519224   \n",
       "6428                   0        278006                0        278006   \n",
       "6429                   0        585314                0        585314   \n",
       "6430                   0         43000                0         43000   \n",
       "\n",
       "      imprv_homesite  imprv_homesite_pct  en_exempt pc_exempt  so_exempt  \\\n",
       "0                  Y               100.0          F         F          F   \n",
       "1                  Y               100.0          F         F          F   \n",
       "2                  Y               100.0          F         F          F   \n",
       "3                  Y               100.0          F         F          F   \n",
       "4                  Y               100.0          F         F          F   \n",
       "...              ...                 ...        ...       ...        ...   \n",
       "6426               N               100.0          F         F          F   \n",
       "6427               Y               100.0          F         F          F   \n",
       "6428               Y               100.0          F         F          F   \n",
       "6429               Y               100.0          F         F          F   \n",
       "6430               Y               100.0          F         F          F   \n",
       "\n",
       "      eco_exempt  \n",
       "0              F  \n",
       "1              F  \n",
       "2              F  \n",
       "3              F  \n",
       "4              F  \n",
       "...          ...  \n",
       "6426           F  \n",
       "6427           F  \n",
       "6428           F  \n",
       "6429           F  \n",
       "6430           F  \n",
       "\n",
       "[6431 rows x 44 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables.query(bldg_types='1 FAM DWELLING',zip_codes=['78733','78741']).get_single_family_building_summary()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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>prop_id</th>\n",
       "      <th>prop_type_cd</th>\n",
       "      <th>prop_val_yr</th>\n",
       "      <th>geo_id</th>\n",
       "      <th>partial_owner</th>\n",
       "      <th>udi_group</th>\n",
       "      <th>situs_street_prefx</th>\n",
       "      <th>situs_street</th>\n",
       "      <th>situs_street_suffix</th>\n",
       "      <th>situs_city</th>\n",
       "      <th>...</th>\n",
       "      <th>dataset_id</th>\n",
       "      <th>deed_num</th>\n",
       "      <th>exemption_percentage</th>\n",
       "      <th>sic_code</th>\n",
       "      <th>omitted_imprv_hstd_val</th>\n",
       "      <th>omitted_imprv_non_hstd_val</th>\n",
       "      <th>pp_late_interstate_allocation_val</th>\n",
       "      <th>appraised_val_reflecting_productivity_loss</th>\n",
       "      <th>assessed_val_reflecting_productivity_loss</th>\n",
       "      <th>late_correction_val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>100008</td>\n",
       "      <td>R</td>\n",
       "      <td>2023</td>\n",
       "      <td>0100030105</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>S</td>\n",
       "      <td>LAMAR</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2014035621TR</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>100012</td>\n",
       "      <td>R</td>\n",
       "      <td>2023</td>\n",
       "      <td>0100030109</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>S</td>\n",
       "      <td>LAMAR</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2011172140TR</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>100015</td>\n",
       "      <td>R</td>\n",
       "      <td>2023</td>\n",
       "      <td>0100030112</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>S</td>\n",
       "      <td>LAMAR</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2001096152TR</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>100018</td>\n",
       "      <td>R</td>\n",
       "      <td>2023</td>\n",
       "      <td>0100030115</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>S</td>\n",
       "      <td>LAMAR</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2014043470TR</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>100020</td>\n",
       "      <td>R</td>\n",
       "      <td>2023</td>\n",
       "      <td>0100030201</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>S</td>\n",
       "      <td>LAMAR</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2007035338TR</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477141</th>\n",
       "      <td>977395</td>\n",
       "      <td>P</td>\n",
       "      <td>2023</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KEVIN</td>\n",
       "      <td>LN</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477142</th>\n",
       "      <td>977396</td>\n",
       "      <td>P</td>\n",
       "      <td>2023</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VARIOUS LOCATIONS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477143</th>\n",
       "      <td>977397</td>\n",
       "      <td>MH</td>\n",
       "      <td>2023</td>\n",
       "      <td>0259410216</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KILLINGSWORTH</td>\n",
       "      <td>LN</td>\n",
       "      <td>PFLUGERVILLE</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477144</th>\n",
       "      <td>977401</td>\n",
       "      <td>P</td>\n",
       "      <td>2023</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PANTHER</td>\n",
       "      <td>LN</td>\n",
       "      <td>PFLUGERVILLE</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477145</th>\n",
       "      <td>977402</td>\n",
       "      <td>P</td>\n",
       "      <td>2023</td>\n",
       "      <td>NaN</td>\n",
       "      <td>F</td>\n",
       "      <td>0</td>\n",
       "      <td>E</td>\n",
       "      <td>STASSNEY</td>\n",
       "      <td>LN</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>477146 rows × 57 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        prop_id prop_type_cd  prop_val_yr      geo_id partial_owner  \\\n",
       "0        100008            R         2023  0100030105             F   \n",
       "1        100012            R         2023  0100030109             F   \n",
       "2        100015            R         2023  0100030112             F   \n",
       "3        100018            R         2023  0100030115             F   \n",
       "4        100020            R         2023  0100030201             F   \n",
       "...         ...          ...          ...         ...           ...   \n",
       "477141   977395            P         2023         NaN             F   \n",
       "477142   977396            P         2023         NaN             F   \n",
       "477143   977397           MH         2023  0259410216             F   \n",
       "477144   977401            P         2023         NaN             F   \n",
       "477145   977402            P         2023         NaN             F   \n",
       "\n",
       "        udi_group situs_street_prefx       situs_street situs_street_suffix  \\\n",
       "0               0                  S              LAMAR                BLVD   \n",
       "1               0                  S              LAMAR                BLVD   \n",
       "2               0                  S              LAMAR                BLVD   \n",
       "3               0                  S              LAMAR                BLVD   \n",
       "4               0                  S              LAMAR                BLVD   \n",
       "...           ...                ...                ...                 ...   \n",
       "477141          0                NaN              KEVIN                  LN   \n",
       "477142          0                NaN  VARIOUS LOCATIONS                 NaN   \n",
       "477143          0                NaN      KILLINGSWORTH                  LN   \n",
       "477144          0                NaN            PANTHER                  LN   \n",
       "477145          0                  E           STASSNEY                  LN   \n",
       "\n",
       "          situs_city  ... dataset_id      deed_num  exemption_percentage  \\\n",
       "0                NaN  ...          0  2014035621TR                     0   \n",
       "1                NaN  ...          0  2011172140TR                     0   \n",
       "2                NaN  ...          0  2001096152TR                     0   \n",
       "3                NaN  ...          0  2014043470TR                     0   \n",
       "4                NaN  ...          0  2007035338TR                     0   \n",
       "...              ...  ...        ...           ...                   ...   \n",
       "477141        AUSTIN  ...          0           NaN                     0   \n",
       "477142           NaN  ...          0           NaN                     0   \n",
       "477143  PFLUGERVILLE  ...          0           NaN                     0   \n",
       "477144  PFLUGERVILLE  ...          0           NaN                     0   \n",
       "477145        AUSTIN  ...          0           NaN                     0   \n",
       "\n",
       "        sic_code omitted_imprv_hstd_val omitted_imprv_non_hstd_val  \\\n",
       "0            NaN                      0                          0   \n",
       "1            NaN                      0                          0   \n",
       "2            NaN                      0                          0   \n",
       "3            NaN                      0                          0   \n",
       "4            NaN                      0                          0   \n",
       "...          ...                    ...                        ...   \n",
       "477141       NaN                      0                          0   \n",
       "477142       NaN                      0                          0   \n",
       "477143       NaN                      0                          0   \n",
       "477144       NaN                      0                          0   \n",
       "477145       NaN                      0                          0   \n",
       "\n",
       "       pp_late_interstate_allocation_val  \\\n",
       "0                                      0   \n",
       "1                                      0   \n",
       "2                                      0   \n",
       "3                                      0   \n",
       "4                                      0   \n",
       "...                                  ...   \n",
       "477141                                 0   \n",
       "477142                                 0   \n",
       "477143                                 0   \n",
       "477144                                 0   \n",
       "477145                                 0   \n",
       "\n",
       "       appraised_val_reflecting_productivity_loss  \\\n",
       "0                                               0   \n",
       "1                                               0   \n",
       "2                                               0   \n",
       "3                                               0   \n",
       "4                                               0   \n",
       "...                                           ...   \n",
       "477141                                          0   \n",
       "477142                                          0   \n",
       "477143                                          0   \n",
       "477144                                          0   \n",
       "477145                                          0   \n",
       "\n",
       "        assessed_val_reflecting_productivity_loss  late_correction_val  \n",
       "0                                               0                    0  \n",
       "1                                               0                    0  \n",
       "2                                               0                    0  \n",
       "3                                               0                    0  \n",
       "4                                               0                    0  \n",
       "...                                           ...                  ...  \n",
       "477141                                          0                    0  \n",
       "477142                                          0                    0  \n",
       "477143                                          0                    0  \n",
       "477144                                          0                    0  \n",
       "477145                                          0                    0  \n",
       "\n",
       "[477146 rows x 57 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables.prop_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "View the available building types for the current selector using this property."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['01 SFR COMM',\n",
       " '02 DUPLEX COMM',\n",
       " '03 TRIPLEX COMM',\n",
       " '04 FOURPLEX COMM',\n",
       " '1 FAM DWELLING',\n",
       " '2 FAM DWELLING',\n",
       " 'ADDITIONAL LIVING QUARTER',\n",
       " 'ADU COMM',\n",
       " 'ALT LIVING CTR',\n",
       " 'APARTMENT 100+',\n",
       " 'APARTMENT 26-49',\n",
       " 'APARTMENT 5-25',\n",
       " 'APARTMENT 50-100',\n",
       " 'ASSISTED LIVING/MEMORY',\n",
       " 'Accessory Dwelling Unit (',\n",
       " 'BANK - OFFICE',\n",
       " 'BANK BRANCH OFF',\n",
       " 'BANK DRIVE THRU',\n",
       " 'BED/BKFAST(SFR)',\n",
       " 'BOWLING CENTER',\n",
       " 'CAR WASH (FULL SERVICE)',\n",
       " 'CLASSROOM',\n",
       " 'CLUBHOUSE',\n",
       " 'COMM SHOP CTR',\n",
       " 'COMMERCIAL SPACE CONDOS',\n",
       " 'COMPUTER DATA CENTER',\n",
       " 'CONDO (STACKED)',\n",
       " 'CONTINUING CARE',\n",
       " 'CONVENIENCE STOR',\n",
       " 'COUNTRY CLUB',\n",
       " 'DAY CARE CENTER',\n",
       " 'DEALERSHIP',\n",
       " 'DEPT STR >25,000',\n",
       " 'DISC STR >25,000',\n",
       " 'DORMITORY',\n",
       " 'DORMITORY HIRISE',\n",
       " 'DRUGSTORE',\n",
       " 'Detail Only',\n",
       " 'FAST FOOD REST',\n",
       " 'FOURPLEX',\n",
       " 'FRAT/SORORITY',\n",
       " 'GARAGE APARTMENT',\n",
       " 'GARAGE APT COMM',\n",
       " 'GROCERY STORE',\n",
       " 'HEALTH CLUB',\n",
       " 'HIRISE CONDO/APT',\n",
       " 'HOSPITAL',\n",
       " 'HOTEL-FULL SERVC',\n",
       " 'HOTEL-LMTD SERVC',\n",
       " 'INDEPENDENT LIVING',\n",
       " 'INDL 20K+ 25-49%',\n",
       " 'INDL 20K+ 50-74%',\n",
       " 'INDL 20K+ <25%FO',\n",
       " 'INDL 20K+ >75%FO',\n",
       " 'LG OFFICE CONDO',\n",
       " 'LSEHLD XMT PROP',\n",
       " 'LUXURY HI-RISE APTS 100+',\n",
       " 'MAJOR IND ENG',\n",
       " 'MAJOR IND MFG',\n",
       " 'MAJOR IND OFFICE',\n",
       " 'MARINA',\n",
       " 'MEDICAL OFF <10K',\n",
       " 'MEDICAL OFF >10K',\n",
       " \"MF'D COMMCL BLDG\",\n",
       " \"MFG/ENG'G/LAB INDUSTRIAL\",\n",
       " 'MINI-WAREHOUSE',\n",
       " 'MINILUBE/TUNE-UP',\n",
       " 'MOHO DOUBLE PP',\n",
       " 'MOHO DOUBLE REAL',\n",
       " 'MOHO SINGLE PP',\n",
       " 'MOHO SINGLE REAL',\n",
       " 'MORTUARY/FUNERAL',\n",
       " 'MOTEL-EXTND STAY',\n",
       " 'NGHBOR SHOP CTR',\n",
       " 'NIGHT CLUB/BAR',\n",
       " 'OFF HI-RISE >= 6',\n",
       " 'OFF/RETAIL (SFR)',\n",
       " 'OFFICE (SMALL)',\n",
       " 'OFFICE LG >35000',\n",
       " 'OFFICE MED 10-35',\n",
       " 'OUTPATIENT (SURGICAL) CEN',\n",
       " 'PARKING GARAGE',\n",
       " 'R (Required by Prodigy)',\n",
       " 'REGIONAL SHOP CT',\n",
       " 'RES UNMEASURED',\n",
       " 'RESTAURANT',\n",
       " 'RESTAURANT (SFR)',\n",
       " 'RETAIL STORE',\n",
       " 'RETIREMENT CTR',\n",
       " 'SELF-SER BOOTH',\n",
       " 'SERVICE STATION',\n",
       " 'SKILLED NURSING',\n",
       " 'SM OFFICE CONDO',\n",
       " 'SM STORE <10K SF',\n",
       " 'SPECIAL (F-V)',\n",
       " 'SPECIAL (NODEPR)',\n",
       " 'STRIP CTR <10000',\n",
       " 'STRIP CTR >10000',\n",
       " \"SVC/REPAIR GAR'G\",\n",
       " 'THEATER',\n",
       " 'TOWNHOMES',\n",
       " 'TRANSIT WHSE',\n",
       " 'TREATMENT/REHAB',\n",
       " 'TRIPLEX',\n",
       " 'WAREHOUSE <20000',\n",
       " nan]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables.bldg_types"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "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>prop_id</th>\n",
       "      <th>prop_val_yr</th>\n",
       "      <th>imprv_id</th>\n",
       "      <th>imprv_det_id</th>\n",
       "      <th>Imprv_det_type_cd</th>\n",
       "      <th>Imprv_det_type_desc</th>\n",
       "      <th>Imprv_det_class_cd</th>\n",
       "      <th>yr_built</th>\n",
       "      <th>depreciation_yr</th>\n",
       "      <th>imprv_det_area</th>\n",
       "      <th>imprv_det_val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60121</th>\n",
       "      <td>108470</td>\n",
       "      <td>2023</td>\n",
       "      <td>5232774</td>\n",
       "      <td>41099107</td>\n",
       "      <td>1ST</td>\n",
       "      <td>1st Floor</td>\n",
       "      <td>R3</td>\n",
       "      <td>1997</td>\n",
       "      <td>1997</td>\n",
       "      <td>3337</td>\n",
       "      <td>345905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60122</th>\n",
       "      <td>108470</td>\n",
       "      <td>2023</td>\n",
       "      <td>5232774</td>\n",
       "      <td>41099108</td>\n",
       "      <td>2ND</td>\n",
       "      <td>2nd Floor</td>\n",
       "      <td>R3</td>\n",
       "      <td>1997</td>\n",
       "      <td>1997</td>\n",
       "      <td>958</td>\n",
       "      <td>89375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60123</th>\n",
       "      <td>108470</td>\n",
       "      <td>2023</td>\n",
       "      <td>5232774</td>\n",
       "      <td>41099109</td>\n",
       "      <td>011</td>\n",
       "      <td>PORCH OPEN 1ST F</td>\n",
       "      <td>R3</td>\n",
       "      <td>1997</td>\n",
       "      <td>1997</td>\n",
       "      <td>91</td>\n",
       "      <td>3969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60124</th>\n",
       "      <td>108470</td>\n",
       "      <td>2023</td>\n",
       "      <td>5232774</td>\n",
       "      <td>41099110</td>\n",
       "      <td>011</td>\n",
       "      <td>PORCH OPEN 1ST F</td>\n",
       "      <td>R3</td>\n",
       "      <td>1997</td>\n",
       "      <td>1997</td>\n",
       "      <td>344</td>\n",
       "      <td>12698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60125</th>\n",
       "      <td>108470</td>\n",
       "      <td>2023</td>\n",
       "      <td>5232774</td>\n",
       "      <td>41099111</td>\n",
       "      <td>041</td>\n",
       "      <td>GARAGE ATT 1ST F</td>\n",
       "      <td>R3</td>\n",
       "      <td>1997</td>\n",
       "      <td>1997</td>\n",
       "      <td>924</td>\n",
       "      <td>26076</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60126</th>\n",
       "      <td>108470</td>\n",
       "      <td>2023</td>\n",
       "      <td>5232774</td>\n",
       "      <td>41099112</td>\n",
       "      <td>095</td>\n",
       "      <td>HVAC RESIDENTIAL</td>\n",
       "      <td>R3</td>\n",
       "      <td>1997</td>\n",
       "      <td>1997</td>\n",
       "      <td>4295</td>\n",
       "      <td>8367</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60127</th>\n",
       "      <td>108470</td>\n",
       "      <td>2023</td>\n",
       "      <td>5232774</td>\n",
       "      <td>41099113</td>\n",
       "      <td>251</td>\n",
       "      <td>BATHROOM</td>\n",
       "      <td>R3</td>\n",
       "      <td>1997</td>\n",
       "      <td>1997</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60128</th>\n",
       "      <td>108470</td>\n",
       "      <td>2023</td>\n",
       "      <td>5232774</td>\n",
       "      <td>41099114</td>\n",
       "      <td>447</td>\n",
       "      <td>SPA CONCRETE</td>\n",
       "      <td>R3</td>\n",
       "      <td>1997</td>\n",
       "      <td>1997</td>\n",
       "      <td>1</td>\n",
       "      <td>4870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60129</th>\n",
       "      <td>108470</td>\n",
       "      <td>2023</td>\n",
       "      <td>5232774</td>\n",
       "      <td>41099115</td>\n",
       "      <td>522</td>\n",
       "      <td>FIREPLACE</td>\n",
       "      <td>R3</td>\n",
       "      <td>1997</td>\n",
       "      <td>1997</td>\n",
       "      <td>4</td>\n",
       "      <td>24055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60130</th>\n",
       "      <td>108470</td>\n",
       "      <td>2023</td>\n",
       "      <td>5232774</td>\n",
       "      <td>41099116</td>\n",
       "      <td>604</td>\n",
       "      <td>POOL RES CONC</td>\n",
       "      <td>R3</td>\n",
       "      <td>1997</td>\n",
       "      <td>1997</td>\n",
       "      <td>1</td>\n",
       "      <td>24351</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       prop_id  prop_val_yr  imprv_id  imprv_det_id Imprv_det_type_cd  \\\n",
       "60121   108470         2023   5232774      41099107               1ST   \n",
       "60122   108470         2023   5232774      41099108               2ND   \n",
       "60123   108470         2023   5232774      41099109               011   \n",
       "60124   108470         2023   5232774      41099110               011   \n",
       "60125   108470         2023   5232774      41099111               041   \n",
       "60126   108470         2023   5232774      41099112               095   \n",
       "60127   108470         2023   5232774      41099113               251   \n",
       "60128   108470         2023   5232774      41099114               447   \n",
       "60129   108470         2023   5232774      41099115               522   \n",
       "60130   108470         2023   5232774      41099116               604   \n",
       "\n",
       "      Imprv_det_type_desc Imprv_det_class_cd  yr_built  depreciation_yr  \\\n",
       "60121           1st Floor                 R3      1997             1997   \n",
       "60122           2nd Floor                 R3      1997             1997   \n",
       "60123    PORCH OPEN 1ST F                 R3      1997             1997   \n",
       "60124    PORCH OPEN 1ST F                 R3      1997             1997   \n",
       "60125    GARAGE ATT 1ST F                 R3      1997             1997   \n",
       "60126    HVAC RESIDENTIAL                 R3      1997             1997   \n",
       "60127            BATHROOM                 R3      1997             1997   \n",
       "60128        SPA CONCRETE                 R3      1997             1997   \n",
       "60129           FIREPLACE                 R3      1997             1997   \n",
       "60130       POOL RES CONC                 R3      1997             1997   \n",
       "\n",
       "       imprv_det_area  imprv_det_val  \n",
       "60121            3337         345905  \n",
       "60122             958          89375  \n",
       "60123              91           3969  \n",
       "60124             344          12698  \n",
       "60125             924          26076  \n",
       "60126            4295           8367  \n",
       "60127               4              0  \n",
       "60128               1           4870  \n",
       "60129               4          24055  \n",
       "60130               1          24351  "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables.imp_det_df[tables.imp_det_df['prop_id']==108470]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "29         False\n",
       "40         False\n",
       "54         False\n",
       "66         False\n",
       "73         False\n",
       "           ...  \n",
       "3361911    False\n",
       "3361916     True\n",
       "3362186    False\n",
       "3362196    False\n",
       "3362205    False\n",
       "Name: prop_id, Length: 426272, dtype: bool"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables.imp_atr_df[(tables.imp_atr_df['imprv_attr_desc']=='Roof Covering')]['prop_id'].duplicated()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "427735"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(tables.imp_atr_df[tables.imp_atr_df['imprv_attr_desc']=='Foundation'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['SLAB', 'PIER AND B', 'BLOCKS', 'FLOATING S', 'OTHER', 'WOOD POST']\n",
       "Categories (170, object): ['07', '08', '09', '1', ..., 'UQ', 'W', 'WOOD POST', 'WOOD SHING']"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables.imp_atr_df[tables.imp_atr_df['imprv_attr_desc']=='Foundation']['imprv_attr_cd'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['METAL', 'COMPOSITIO', 'BUILT-UP', 'OTHER', 'TILE', 'WOOD SHING']\n",
       "Categories (170, object): ['07', '08', '09', '1', ..., 'UQ', 'W', 'WOOD POST', 'WOOD SHING']"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables.imp_atr_df[tables.imp_atr_df['imprv_attr_desc']=='Roof Covering']['imprv_attr_cd'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "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>prop_id</th>\n",
       "      <th>prop_val_yr</th>\n",
       "      <th>imprv_id</th>\n",
       "      <th>imprv_det_id</th>\n",
       "      <th>imprv_attr_id</th>\n",
       "      <th>imprv_attr_desc</th>\n",
       "      <th>imprv_attr_cd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3360516</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784144</td>\n",
       "      <td>45369179</td>\n",
       "      <td>39867665</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>BUILT-UP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360517</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784144</td>\n",
       "      <td>45369179</td>\n",
       "      <td>39867666</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>COMPOSITIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360518</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784144</td>\n",
       "      <td>45369179</td>\n",
       "      <td>39867667</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>METAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360519</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784144</td>\n",
       "      <td>45369179</td>\n",
       "      <td>39867668</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>OTHER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360520</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784144</td>\n",
       "      <td>45369179</td>\n",
       "      <td>39867669</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>TILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360521</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784144</td>\n",
       "      <td>45369179</td>\n",
       "      <td>39867670</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>WOOD SHING</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360569</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784144</td>\n",
       "      <td>45369182</td>\n",
       "      <td>39867718</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>BUILT-UP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360570</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784144</td>\n",
       "      <td>45369182</td>\n",
       "      <td>39867719</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>COMPOSITIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360571</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784144</td>\n",
       "      <td>45369182</td>\n",
       "      <td>39867720</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>METAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360572</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784144</td>\n",
       "      <td>45369182</td>\n",
       "      <td>39867721</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>OTHER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360573</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784144</td>\n",
       "      <td>45369182</td>\n",
       "      <td>39867722</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>TILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360574</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784144</td>\n",
       "      <td>45369182</td>\n",
       "      <td>39867723</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>WOOD SHING</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360622</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784145</td>\n",
       "      <td>45369186</td>\n",
       "      <td>39867792</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>BUILT-UP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360623</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784145</td>\n",
       "      <td>45369186</td>\n",
       "      <td>39867793</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>COMPOSITIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360624</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784145</td>\n",
       "      <td>45369186</td>\n",
       "      <td>39867794</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>METAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360625</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784145</td>\n",
       "      <td>45369186</td>\n",
       "      <td>39867795</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>OTHER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360626</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784145</td>\n",
       "      <td>45369186</td>\n",
       "      <td>39867796</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>TILE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360627</th>\n",
       "      <td>974335</td>\n",
       "      <td>2023</td>\n",
       "      <td>5784145</td>\n",
       "      <td>45369186</td>\n",
       "      <td>39867797</td>\n",
       "      <td>Roof Covering</td>\n",
       "      <td>WOOD SHING</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         prop_id  prop_val_yr  imprv_id  imprv_det_id  imprv_attr_id  \\\n",
       "3360516   974335         2023   5784144      45369179       39867665   \n",
       "3360517   974335         2023   5784144      45369179       39867666   \n",
       "3360518   974335         2023   5784144      45369179       39867667   \n",
       "3360519   974335         2023   5784144      45369179       39867668   \n",
       "3360520   974335         2023   5784144      45369179       39867669   \n",
       "3360521   974335         2023   5784144      45369179       39867670   \n",
       "3360569   974335         2023   5784144      45369182       39867718   \n",
       "3360570   974335         2023   5784144      45369182       39867719   \n",
       "3360571   974335         2023   5784144      45369182       39867720   \n",
       "3360572   974335         2023   5784144      45369182       39867721   \n",
       "3360573   974335         2023   5784144      45369182       39867722   \n",
       "3360574   974335         2023   5784144      45369182       39867723   \n",
       "3360622   974335         2023   5784145      45369186       39867792   \n",
       "3360623   974335         2023   5784145      45369186       39867793   \n",
       "3360624   974335         2023   5784145      45369186       39867794   \n",
       "3360625   974335         2023   5784145      45369186       39867795   \n",
       "3360626   974335         2023   5784145      45369186       39867796   \n",
       "3360627   974335         2023   5784145      45369186       39867797   \n",
       "\n",
       "        imprv_attr_desc imprv_attr_cd  \n",
       "3360516   Roof Covering      BUILT-UP  \n",
       "3360517   Roof Covering    COMPOSITIO  \n",
       "3360518   Roof Covering         METAL  \n",
       "3360519   Roof Covering         OTHER  \n",
       "3360520   Roof Covering          TILE  \n",
       "3360521   Roof Covering    WOOD SHING  \n",
       "3360569   Roof Covering      BUILT-UP  \n",
       "3360570   Roof Covering    COMPOSITIO  \n",
       "3360571   Roof Covering         METAL  \n",
       "3360572   Roof Covering         OTHER  \n",
       "3360573   Roof Covering          TILE  \n",
       "3360574   Roof Covering    WOOD SHING  \n",
       "3360622   Roof Covering      BUILT-UP  \n",
       "3360623   Roof Covering    COMPOSITIO  \n",
       "3360624   Roof Covering         METAL  \n",
       "3360625   Roof Covering         OTHER  \n",
       "3360626   Roof Covering          TILE  \n",
       "3360627   Roof Covering    WOOD SHING  "
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables.imp_atr_df[(tables.imp_atr_df['imprv_attr_desc']=='Roof Covering')&(tables.imp_atr_df['prop_id']==974335)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "tables.query(bldg_types='1 FAM DWELLING',zip_codes=['78733','78741']).get_single_family_building_summary().to_parquet(\"data/processed/TCAD_78733_78741_merged_tables.parquet\")\n",
    "#prop_df = tables.process_prop_df()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Interesting finds in tcad database.\n",
    "2100 TRIPSHAW LN 64C, TX 78741 - Some times single family homes can have 3 stories - townhouse area\n",
    "\n",
    "1504 Miami Dr, 78733 - no hvac\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "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>prop_id</th>\n",
       "      <th>imprv_id</th>\n",
       "      <th>prop_val_yr_x</th>\n",
       "      <th>situs_num</th>\n",
       "      <th>situs_street_prefx</th>\n",
       "      <th>situs_street</th>\n",
       "      <th>situs_street_suffix</th>\n",
       "      <th>situs_unit</th>\n",
       "      <th>situs_city</th>\n",
       "      <th>situs_zip</th>\n",
       "      <th>...</th>\n",
       "      <th>imprv_non_hstd_val</th>\n",
       "      <th>market_value</th>\n",
       "      <th>ten_percent_cap</th>\n",
       "      <th>assessed_val</th>\n",
       "      <th>imprv_homesite</th>\n",
       "      <th>imprv_homesite_pct</th>\n",
       "      <th>en_exempt</th>\n",
       "      <th>pc_exempt</th>\n",
       "      <th>so_exempt</th>\n",
       "      <th>eco_exempt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>239674</td>\n",
       "      <td>5333296</td>\n",
       "      <td>2023</td>\n",
       "      <td>405</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PRIMROSE</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>78753</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>383435</td>\n",
       "      <td>0</td>\n",
       "      <td>383435</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393</th>\n",
       "      <td>239683</td>\n",
       "      <td>5333316</td>\n",
       "      <td>2023</td>\n",
       "      <td>411</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PRIMROSE</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78753</td>\n",
       "      <td>...</td>\n",
       "      <td>3278</td>\n",
       "      <td>512028</td>\n",
       "      <td>0</td>\n",
       "      <td>512028</td>\n",
       "      <td>N</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397</th>\n",
       "      <td>239693</td>\n",
       "      <td>5333330</td>\n",
       "      <td>2023</td>\n",
       "      <td>410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PRIMROSE</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78753</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>368991</td>\n",
       "      <td>0</td>\n",
       "      <td>368991</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>398</th>\n",
       "      <td>239694</td>\n",
       "      <td>5333331</td>\n",
       "      <td>2023</td>\n",
       "      <td>404</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PRIMROSE</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78753</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>311142</td>\n",
       "      <td>0</td>\n",
       "      <td>311142</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>537</th>\n",
       "      <td>240472</td>\n",
       "      <td>5334157</td>\n",
       "      <td>2023</td>\n",
       "      <td>207</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BEAVER</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>78753</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>409353</td>\n",
       "      <td>157241</td>\n",
       "      <td>252112</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6506</th>\n",
       "      <td>774294</td>\n",
       "      <td>5562142</td>\n",
       "      <td>2023</td>\n",
       "      <td>11708</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HORNSBY</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>78753</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>435000</td>\n",
       "      <td>0</td>\n",
       "      <td>435000</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6561</th>\n",
       "      <td>816996</td>\n",
       "      <td>5574996</td>\n",
       "      <td>2023</td>\n",
       "      <td>11802</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HORNSBY</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>78753</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>641032</td>\n",
       "      <td>118207</td>\n",
       "      <td>522825</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6907</th>\n",
       "      <td>898912</td>\n",
       "      <td>5621175</td>\n",
       "      <td>2023</td>\n",
       "      <td>211</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BEAVER</td>\n",
       "      <td>ST</td>\n",
       "      <td>CD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78753</td>\n",
       "      <td>...</td>\n",
       "      <td>281702</td>\n",
       "      <td>556702</td>\n",
       "      <td>0</td>\n",
       "      <td>556702</td>\n",
       "      <td>N</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6908</th>\n",
       "      <td>898913</td>\n",
       "      <td>5621177</td>\n",
       "      <td>2023</td>\n",
       "      <td>211</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BEAVER</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78753</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>577567</td>\n",
       "      <td>0</td>\n",
       "      <td>577567</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6909</th>\n",
       "      <td>898914</td>\n",
       "      <td>5621179</td>\n",
       "      <td>2023</td>\n",
       "      <td>209</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BEAVER</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78753</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>585719</td>\n",
       "      <td>0</td>\n",
       "      <td>585719</td>\n",
       "      <td>Y</td>\n",
       "      <td>100.0</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "      <td>F</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>328 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      prop_id  imprv_id  prop_val_yr_x situs_num situs_street_prefx  \\\n",
       "389    239674   5333296           2023       405                NaN   \n",
       "393    239683   5333316           2023       411                NaN   \n",
       "397    239693   5333330           2023       410                NaN   \n",
       "398    239694   5333331           2023       404                NaN   \n",
       "537    240472   5334157           2023       207                NaN   \n",
       "...       ...       ...            ...       ...                ...   \n",
       "6506   774294   5562142           2023     11708                NaN   \n",
       "6561   816996   5574996           2023     11802                NaN   \n",
       "6907   898912   5621175           2023       211                NaN   \n",
       "6908   898913   5621177           2023       211                NaN   \n",
       "6909   898914   5621179           2023       209                NaN   \n",
       "\n",
       "     situs_street situs_street_suffix situs_unit situs_city situs_zip  ...  \\\n",
       "389      PRIMROSE                  ST        NaN     AUSTIN     78753  ...   \n",
       "393      PRIMROSE                  ST        NaN        NaN     78753  ...   \n",
       "397      PRIMROSE                  ST        NaN        NaN     78753  ...   \n",
       "398      PRIMROSE                  ST        NaN        NaN     78753  ...   \n",
       "537        BEAVER                  ST        NaN     AUSTIN     78753  ...   \n",
       "...           ...                 ...        ...        ...       ...  ...   \n",
       "6506      HORNSBY                  ST        NaN     AUSTIN     78753  ...   \n",
       "6561      HORNSBY                  ST        NaN     AUSTIN     78753  ...   \n",
       "6907       BEAVER                  ST         CD        NaN     78753  ...   \n",
       "6908       BEAVER                  ST        NaN        NaN     78753  ...   \n",
       "6909       BEAVER                  ST        NaN        NaN     78753  ...   \n",
       "\n",
       "      imprv_non_hstd_val  market_value  ten_percent_cap  assessed_val  \\\n",
       "389                    0        383435                0        383435   \n",
       "393                 3278        512028                0        512028   \n",
       "397                    0        368991                0        368991   \n",
       "398                    0        311142                0        311142   \n",
       "537                    0        409353           157241        252112   \n",
       "...                  ...           ...              ...           ...   \n",
       "6506                   0        435000                0        435000   \n",
       "6561                   0        641032           118207        522825   \n",
       "6907              281702        556702                0        556702   \n",
       "6908                   0        577567                0        577567   \n",
       "6909                   0        585719                0        585719   \n",
       "\n",
       "      imprv_homesite  imprv_homesite_pct en_exempt  pc_exempt  so_exempt  \\\n",
       "389                Y               100.0         F          F          F   \n",
       "393                N               100.0         F          F          F   \n",
       "397                Y               100.0         F          F          F   \n",
       "398                Y               100.0         F          F          F   \n",
       "537                Y               100.0         F          F          F   \n",
       "...              ...                 ...       ...        ...        ...   \n",
       "6506               Y               100.0         F          F          F   \n",
       "6561               Y               100.0         F          F          F   \n",
       "6907               N               100.0         F          F          F   \n",
       "6908               Y               100.0         F          F          F   \n",
       "6909               Y               100.0         F          F          F   \n",
       "\n",
       "     eco_exempt  \n",
       "389           F  \n",
       "393           F  \n",
       "397           F  \n",
       "398           F  \n",
       "537           F  \n",
       "...         ...  \n",
       "6506          F  \n",
       "6561          F  \n",
       "6907          F  \n",
       "6908          F  \n",
       "6909          F  \n",
       "\n",
       "[328 rows x 43 columns]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables.query(bldg_types='1 FAM DWELLING',zip_codes=['78753']).get_single_family_building_summary().query('situs_street_suffix == \"ST\"')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables.query(bldg_types='1 FAM DWELLING',zip_codes=['78733','78741']).get_single_family_building_summary()['prop_id'].duplicated().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.12.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}