OSM POI Data Pulls_vf.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "86b208f2",
   "metadata": {},
   "outputs": [],
   "source": [
    "import osmnx as ox\n",
    "import geopandas as gpd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "8244cb52",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Setting the data path\n",
    "data_path = r'YOUR FILE PATH'"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8008fd18",
   "metadata": {},
   "source": [
    "## 1. Defining a search area"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "b04fa7ad",
   "metadata": {},
   "outputs": [],
   "source": [
    "search_area = \"OH, USA\"\n",
    "area = ox.geocode_to_gdf(search_area)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "4b299bab",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXEAAAGhCAYAAACXuYSLAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/NK7nSAAAACXBIWXMAAA9hAAAPYQGoP6dpAAA/8ElEQVR4nO3deVxTZ74/8E8SIKyJsgiyWhVEBARxAa1LK26DLbbTaqvFruPtNtX2N7eWOk7rdEE7vR21LlV7p9jxjrRzrdXbVkdtVWpdBoVQXKq0LoCAuEFYQ0jO7w9rNLIlISE55PN+vfKa8eSck29O8cPjc57zPBJBEAQQEZEoSe1dABERWY4hTkQkYgxxIiIRY4gTEYkYQ5yISMQY4kREIsYQJyISMYY4EZGIMcSJiESMIU5EJGJdCvGsrCxIJBIsWLAAAKDVarFw4ULExcXBy8sLwcHBmDt3LsrLyzs8T3Z2NiQSSatXU1NTV8ojIurxXCw9MC8vD+vXr0d8fLxhW0NDA/Lz87F48WIMHToU169fx4IFC3D//ffj6NGjHZ5PoVDg9OnTRtvc3d0tLY+IyClYFOJ1dXWYM2cONmzYgLffftuwXalUYvfu3Ub7fvjhhxg5ciRKSkoQHh7e7jklEgmCgoIsKQcAoNfrUV5eDh8fH0gkEovPQ0TkCARBQG1tLYKDgyGVtt9pYlGIv/DCC0hLS0NqaqpRiLelpqYGEokEvXr16nC/uro6REREQKfTISEhAW+99RYSExPb3V+j0UCj0Rj+fPHiRcTExJj1PYiIHF1paSlCQ0Pbfd/sEM/JyUF+fj7y8vI63bepqQmvvfYaZs+eDYVC0e5+0dHRyM7ORlxcHNRqNVasWIExY8agsLAQkZGRbR6TlZWFJUuWtNpeWlra4WcREYmBWq1GWFgYfHx8OtxPYs584qWlpRg+fDh27dqFoUOHAgAmTJiAhIQELF++3GhfrVaLhx9+GCUlJdi3b59ZwarX6zFs2DCMGzcOK1eubHOfO1viN79wTU0NQ5yIRE+tVkOpVHaaaWa1xI8dO4aqqiokJSUZtul0OuTm5mLVqlXQaDSQyWTQarWYOXMmzp07h++++87sUJVKpRgxYgSKi4vb3Ucul0Mul5t1XiKinsasEJ84cSKKioqMtj355JOIjo7GwoULjQK8uLgYe/fuhZ+fn9lFCYIAlUqFuLg4s48lInImZoW4j48PYmNjjbZ5eXnBz88PsbGxaGlpwUMPPYT8/Hx89dVX0Ol0qKysBAD4+vrCzc0NADB37lyEhIQgKysLALBkyRIkJycjMjISarUaK1euhEqlwurVq63xHYmIeiyLx4m3paysDNu3bwcAJCQkGL23d+9eTJgwAQBQUlJiNGSmuroa8+bNQ2VlJZRKJRITE5Gbm4uRI0daszwioh7HrBubjszUmwBERGJgaqZx7hQiIhFjiBMRiRhDnIhIxBjiREQixhAnIhIxhjgRkYgxxImIRIwhTkQkYlZ9YpOIiG64XKtBYWk1POUyjB7gb7PPYYgTEXVRbZMWRWU1KCyrQWFpNQrLqlFRc2ON4N+NvYshTkTkKJpb9DhVoUZhWTVUpdX4sawGZy/XQd/OBCa2ntiEIU5E1A69XsAvl+uMWtg/VdSiWac3+Ry2npyKIU5E9Kvy6kaofg3rwtJqHL+oRp2mpUvnZEuciMgGqhuaUVhWgx9vhnZZDS7Xajo/0EyCjdviDHEi6vGatDocv1hj6MMuLKvGhasN3fLZbIkTEZlBpxdw5lKtoQ+7sLQGZy7VoqW9O48ixxAnIlErudpg6MMuLLvRj92o1dm7LANbr7vDECci0bhSd+MBmhuBXYMfy6pxvUFr77I6xNEpROTUTparsXb/L8i/cB0XqxvtXY7Z2CdORE5J3aTFB7vO4O+HL0An4v5sjk4hIqfzRX4Z3v3mJ1yps/6Qv+7GljgROY3TlbVY/OVx/Pv8NXuXYjXsEyeiHq9O04K/7j6DjQfP97ihgGyJE1GPtk11Ee98fQpVNnha0jGwT5yIeqDiS7VYvO04Dp/tOV0nbWFLnIh6lHpNC1Z8W4xPfjgHra5ndZ20hSFORD3GVz+W4+2vTqFS3WTvUroNhxgSkej9crkOb24/ge+Lr9i7lG7HljgRiVZjsw6r9hZjQ+45sxZS6Ek4xJCIRGnn8Uq89dVJUT4qb01siRORqFy4Wo83t5/A3tOX7V2KQ2CfOBGJQpNWhzX7fsG6/b9A0+KcXSdtsnFLXNqVg7OysiCRSLBgwQIAgFarxcKFCxEXFwcvLy8EBwdj7ty5KC8v7/RcW7ZsQUxMDORyOWJiYrB169aulEZE3ei7ny5h8l9zsfLbYgb4HWzdJ25xiOfl5WH9+vWIj483bGtoaEB+fj4WL16M/Px8fPHFFzhz5gzuv//+Ds916NAhzJo1CxkZGSgsLERGRgZmzpyJI0eOWFoeEXWD0msNeGbjUTyVfRQl17pnuTMyJhEsWHairq4Ow4YNw5o1a/D2228jISEBy5cvb3PfvLw8jBw5EhcuXEB4eHib+8yaNQtqtRo7duwwbJs6dSp69+6NzZs3m1STWq2GUqlETU0NFAqFuV+JiMzQ3KLH+txfsGrvz2jSsuXdkRkJwVj+SKLZx5maaRa1xF944QWkpaUhNTW1031ramogkUjQq1evdvc5dOgQJk+ebLRtypQpOHjwYLvHaDQaqNVqoxcR2V7umcuYsjwX7+86wwA3gcMNMczJyUF+fj7y8vI63bepqQmvvfYaZs+e3eFvksrKSgQGBhptCwwMRGVlZbvHZGVlYcmSJaYXTkRdUlHTiLe+Oolvitr/e0mt2XqIoVkt8dLSUsyfPx+bNm2Cu7t7h/tqtVo88sgj0Ov1WLNmTafnlkgkRn8WBKHVtttlZmaipqbG8CotLTXtSxCRWbQ6Pdbt/wWp/7WfAW4Bh2qJHzt2DFVVVUhKSjJs0+l0yM3NxapVq6DRaCCTyaDVajFz5kycO3cO3333Xad91EFBQa1a3VVVVa1a57eTy+WQy+XmlE9EZjr0y1X8adtxFFfV2bsU0XKo1e4nTpyIoqIio21PPvkkoqOjsXDhQqMALy4uxt69e+Hn59fpeVNSUrB79268/PLLhm27du3C6NGjzSmPnNC1+mb4ernZu4wep6q2Ce98fQrbVJ0PD6aOOVRL3MfHB7GxsUbbvLy84Ofnh9jYWLS0tOChhx5Cfn4+vvrqK+h0OkML29fXF25uN/6yzZ07FyEhIcjKygIAzJ8/H+PGjcOyZcuQnp6Obdu2Yc+ePThw4IA1viP1QDq9gFf/90d4uEnx9ow4e5fTY1yvb8bffjiH7B/Oo1bTYu9yyARWfWKzrKwM27dvBwAkJCQYvbd3715MmDABAFBSUgKp9FZ3/OjRo5GTk4M//vGPWLx4MQYMGIDPPvsMo0aNsmZ51EO06PR4+fNC/F9hOfy83PDmfUPgIuvSc2tO75K6Cetzz2Lzv0vQ0KyzdzlkBovGiTsijhN3Di06PV7KKTC6wbbxqZEYHxVgx6rES9Oiw7r9Z7F23y9o1DK8bSEtvi9Wzx5m9nGmZhrnTiHR0Or0ePEf+fjXiUtG2/+vsJwhboF9p6vw5vYTOH+VT1qKGf8NSqLQ3KLHc5uOtQpwAPjXiUpoWtiKNFV5dSOe/fsxPPFJHgO8G7Q/UNo62BInh9ek1eHZTcewr52pTWubWrDv9GVMGRLUzZWJi1anx8ffn8OH3xWz37sHYYiTQ2vS6vC7T492uqzX9sJyhngHDv1yFYu3HcfPHO/d4zDEyWE1NLfg6eyjOHT2aqf7fneqCrVNWvi4u3ZDZeLB8d49H/vEySE1NLfgib/lmRTgANCo1WH6hwdwwAkX4m2LTi/gbwfOYeL7+xngPRxb4uRwGpt1ePKTPPz7/DWzjrtwtQGP/fcRPJAYgj+mDYaft3NOy3DswnUs/vI4TlZwZk9nwBAnh9Kk1eGp7DwcOWdegN9ua8FF7D1dhdd/Mxgzh4dZsTrHdq2+GUt3nMI/j5XZfOY8chzsTiGH0aTV4ZmNpvWBd6a6QYtX//dHPLL+EM5e7tk38/R6Af84UoJ7/2sfPj/KAHc2DHFyCPWaFjyVnYcDP1u3T/vw2WuYuuJ7rNhTjOYeuPbj8Ys1eGDtQby+tQjVDVp7l0N2wO4UsruaBi2eyP43CkqqbXL+5hY9/rrnDP7vx3JkPRiHEf18bfI53ammUYv3/3Ua/3PkAvRseTs1hjjZ1ZU6DTL++9841Q034X6uqsPMdYfwyIgwvDZtMJQe4hyOuOVYGbJ2nMKVumZ7l0IOgCFOdlNe3YjHPj6Cs1fqu+0zBQHY/O9S7DlVhT9Nj8F9Q4O77bO76sylWvzxy+P4dxdu+lLPwxAnuyi91oBH1h/GxepGu3z+5VoNfr+5AF/kl+GtGbEI7e1plzpMUa9pwfI9Z/DJD+fRwr4TugNvbFK3K7tu3wC/3d7TlzH5r7n4+Puz0DlgQH5TVIHUD/Zjw/fnGOAi5VAr+xB1Vdn1Bjy6wTEC/KaGZh3e/voUvlRdxNIH4xEborR3SbhY3YjML4qQe6btSb+IbmKIE4Abi7k2afXQtOjQqNWhoVmHxuYb/9vQ3AJ1UwsaNC3QtOjRqNWhSatDvaYFDc06aHV6NDTr0KTVo0l7Y/+b+zW36NH86//XaPVo1jnuML/jF9VIX/0DnhjdD/9vchQ83ezz1+N/jlxA1jc/oY7Lo5EJGOIOTqcXDCHY+Gtw3h6uN8O2qUWHeo0Ojc0t0Oj00OkENLXcCuObwazR6qD5NVjVTVpotHpodHpodXo+JIIb1/u/D5zDzuOVeGvGENwbHdhtn112vQGvbSmy+lh56tkY4h24GaCallvB13QzBHV6CIKA5hbB6P0bLU4dtDoBekGApkWPhuaWX89z43itTkCzTg+N9lbrtanlRku18ddtmhbHb7n2ZBerG/FU9lGkxfXFG/fHoI+Pu00/j61vshRDHMCxC9fwp20nUK9pQZ3mVneAI97oou71dVEFvi++jIXTojF7ZDgkEuuu01J2vQELt/yIH37u+lQD5JwY4gDUjS04Uc4Z36ht6qYWLNp6HF8WXMQb9w1BH4V1Zkf814lLWPrNKdRzlR3qAoY4kYnyzl/H9A8P2LsMIiMcJw5AsPlITiIi22CIA1bv5yQi6i4McQAyhjgRiRRDHLZ/LJaIyFYY4rjxtCIRkRgxxAFI2Z1CRCLFEAcgkzLEiUicGOJgS5yIxIshDrbEiUi8GOJgiBOReHUpxLOysiCRSLBgwQLDti+++AJTpkyBv78/JBIJVCpVp+fJzs6GRCJp9WpqaupKeSZjbwoR2YyNB79ZHOJ5eXlYv3494uPjjbbX19djzJgxWLp0qVnnUygUqKioMHq5u9t2+s+b2CdORGJl0QRYdXV1mDNnDjZs2IC3337b6L2MjAwAwPnz5806p0QiQVBQkCXldBmf2CQisbKoJf7CCy8gLS0NqampViukrq4OERERCA0NxfTp01FQUNDh/hqNBmq12uhFRORszA7xnJwc5OfnIysry2pFREdHIzs7G9u3b8fmzZvh7u6OMWPGoLi4uN1jsrKyoFQqDa+wsDCLP58NcSISK7NCvLS0FPPnz8emTZus2l+dnJyMxx57DEOHDsXYsWPx+eefIyoqCh9++GG7x2RmZqKmpsbwKi0ttfjzGeJEZCu2nurarD7xY8eOoaqqCklJSYZtOp0Oubm5WLVqFTQaDWQyWZeLkkqlGDFiRIctcblcDrncOiusSMAUJyJxMivEJ06ciKKiIqNtTz75JKKjo7Fw4UKrBDhwY0IqlUqFuLg4q5yvM1KOlicikTIrxH18fBAbG2u0zcvLC35+fobt165dQ0lJCcrLywEAp0+fBgAEBQUZRp/MnTsXISEhhn71JUuWIDk5GZGRkVCr1Vi5ciVUKhVWr17dtW9nIrbEiUisrN4G3b59OxITE5GWlgYAeOSRR5CYmIiPPvrIsE9JSQkqKioMf66ursa8efMwePBgTJ48GRcvXkRubi5Gjhxp7fLaxD5xIhIridBDJtNWq9VQKpWoqamBQqEw69gzl2ox+a+5NqqMiJzZb+KCsGZOUuc73sHUTGNvMBGRiDHEAfSMf4sQkTNiiIN94kQkXgxxgGNTiEi0GOJgS5yIxIshDoBtcSISK4Y42BInIvFiiIOjU4hIvBjiREQixhAnIhIxhjjYJ05E4sUQBxdKJiLxYoiDAwyJSLwY4mB3ChHZjq1HvzHEiYhEjCFORCRiDHFweTYiEi+GOAABfGSTiMSJIU5EJGIMcSIiEWOIg33iRCReDHGwT5yIxIshTkQkYgxxIiIb4hObRETULoY4EZEN2fqeG0OciEjEGOLgEEMiEi+GOBGRiDHEiYhEjCEOLgpBROLFECciErEuhXhWVhYkEgkWLFhg2PbFF19gypQp8Pf3h0QigUqlMulcW7ZsQUxMDORyOWJiYrB169aulEZE5BQsDvG8vDysX78e8fHxRtvr6+sxZswYLF261ORzHTp0CLNmzUJGRgYKCwuRkZGBmTNn4siRI5aWR0TkFFwsOaiurg5z5szBhg0b8Pbbbxu9l5GRAQA4f/68yedbvnw5Jk2ahMzMTABAZmYm9u/fj+XLl2Pz5s2WlGgW9okTkVhZ1BJ/4YUXkJaWhtTUVKsUcejQIUyePNlo25QpU3Dw4MF2j9FoNFCr1UYvIiJnY3ZLPCcnB/n5+cjLy7NaEZWVlQgMDDTaFhgYiMrKynaPycrKwpIlS6zy+RI2xYlIpMxqiZeWlmL+/PnYtGkT3N3drVrInUEqCEKH4ZqZmYmamhrDq7S01Kr1EBGJgVkt8WPHjqGqqgpJSUmGbTqdDrm5uVi1ahU0Gg1kMpnZRQQFBbVqdVdVVbVqnd9OLpdDLpeb/VltYTuciMTKrJb4xIkTUVRUBJVKZXgNHz4cc+bMgUqlsijAASAlJQW7d+822rZr1y6MHj3aovOZi70pRCRWZrXEfXx8EBsba7TNy8sLfn5+hu3Xrl1DSUkJysvLAQCnT58GcKO1HRQUBACYO3cuQkJCkJWVBQCYP38+xo0bh2XLliE9PR3btm3Dnj17cODAga59OxNxAiwiEiurP7G5fft2JCYmIi0tDQDwyCOPIDExER999JFhn5KSElRUVBj+PHr0aOTk5OCTTz5BfHw8srOz8dlnn2HUqFHWLq9NbIkTkVhJBMHWiwd1D7VaDaVSiZqaGigUCrOOrVI3YeS739qoMiJyZlOGBGJdxnCzjzM10zh3CjjEkIjEiyEOdqcQkXgxxMEhhkRkO7YeOMEQB7tTiMh2pDZOWYY42BInItthS7wbsCFORDZj43xhiIPdKUQkXgxxsCVOROLFEAf7xIlIvBjiAKRsihORrdj4mXiGOAB9z5h5gIicEEMcNv9FSUROTLBxwjDEAQh6e1dARGQZhjgRkYgxxGH7x2KJiGyF8UVEJGIMcSIiG7L14DeGOPjYPRGJF0McQA9ZoY6InBBDnIjIhtidQkRE7WKIExHZEJ/Y7Aa8sUlEYsUQJyKyIZnUto1EF5ueXSQ4OoWIrC02RIHf3xuJ8VEBNv0chjgRURfNGh6G+xOCMSDAG/P+fhQxfRV494E4SG3cCgcY4kREXZIW1xfLHoo3/Hn7i3d36+ezT5yIyELjogKQ9ds4u9bAljgAPbvEichMrjIJ1s4ZBi+5fWOULXGAS/sQkdm0OgGl1xvsXQZDHLD9YHwi6plmbziCy7Uau9bQpRDPysqCRCLBggULDNsEQcCbb76J4OBgeHh4YMKECThx4kSH58nOzoZEImn1ampq6kp5JuMIQyKyxLX6ZmR9c8quNVgc4nl5eVi/fj3i4+ONtr/33nv44IMPsGrVKuTl5SEoKAiTJk1CbW1th+dTKBSoqKgwerm7u1tanlmY4URkqS8KLuKL/DK7fb5FIV5XV4c5c+Zgw4YN6N27t2G7IAhYvnw5Fi1ahAcffBCxsbHYuHEjGhoa8I9//KPDc0okEgQFBRm9iIjEYOPB83b7bItC/IUXXkBaWhpSU1ONtp87dw6VlZWYPHmyYZtcLsf48eNx8ODBDs9ZV1eHiIgIhIaGYvr06SgoKLCkNIvwiU0i6opTFbV2yxGzx8bk5OQgPz8feXl5rd6rrKwEAAQGBhptDwwMxIULF9o9Z3R0NLKzsxEXFwe1Wo0VK1ZgzJgxKCwsRGRkZJvHaDQaaDS3biio1Wpzv4oBhxgSUVc06/Q4fPYaUgb4dftnm9USLy0txfz587Fp06YO+6vvnBVQEIQOZwpMTk7GY489hqFDh2Ls2LH4/PPPERUVhQ8//LDdY7KysqBUKg2vsLAwc76KET1b4kTURWv2/Qy9HVqEZoX4sWPHUFVVhaSkJLi4uMDFxQX79+/HypUr4eLiYmiB32yR31RVVdWqdd5hUVIpRowYgeLi4nb3yczMRE1NjeFVWlpqzlcxomNTnIi66PviK9jw/dlu/1yzQnzixIkoKiqCSqUyvIYPH445c+ZApVKhf//+CAoKwu7duw3HNDc3Y//+/Rg9erTJnyMIAlQqFfr27dvuPnK5HAqFwuhlKYY4EVlDybXuf/jHrD5xHx8fxMbGGm3z8vKCn5+fYfuCBQvw7rvvIjIyEpGRkXj33Xfh6emJ2bNnG46ZO3cuQkJCkJWVBQBYsmQJkpOTERkZCbVajZUrV0KlUmH16tVd/X4m0bTouuVziKhnmxrb/aPqrP7Q/6uvvorGxkY8//zzuH79OkaNGoVdu3bBx8fHsE9JSQmk0lv/CKiursa8efNQWVkJpVKJxMRE5ObmYuTIkdYuj4jIJgYF+mBspG3nDm+LROgh4+vUajWUSiVqamrM7lr5uaoWqR/k2qgyInIGL02MxCuToqx2PlMzjXOngEMMicgK7NQeZoiDQwyJqOvc3WR2+VyGOBFRF903NBizhlv+rEpXMMQBSDt4EImIqDN3+XvB290+i0MwxImIumjlt8V4flO+XT6bIQ6A7XAi6qqKmu5Z/+BODHG0nuuFiMhcSRG9O9/JBhjiAJjhRNRVlWq2xO2GGU5EXfXtqUuoqu3+IGeIg6NTiKjr9AJwprKu2z+XIQ5Ax4d9iKiLgpXuSAzv1e2fyxAHoNXp7V0CEYncc/cMhJe8+8eKM8QBtOjYEieirokO8ul8JxtgiINzpxBR13m52eeJTft8qoNp4TSGRGQhpYcrFv1mMGKCLV9drCsY4uDybERkGaWHK76ZPxYhvTzsVgO7U8A+cSKyzGPJ4XYNcIAhDoB94kRkmXF2WI7tTgxxcIghEVmmn7+XvUtgiAPsEyci84X08kCgwt3eZTDEAbbEicg8rjIJ3rx/iL3LAMAQBwA088YmEZnhkRHhmBQTaO8yADDEAQDNLWyJE5FpvOUueHlSlL3LMGCIg90pRGS6h5JC4evlZu8yDBjiAFoY4kRkouT+vvYuwQhDHICWfeJEZKIgpX0f7rkTQxxAi54tcSIyzYWr9fYuwQhDHAB7U4hIrBji4GP3RGSaabFBmBwTZO8yjHAWQ3ACLCLq3IOJIfhgVoK9y2iFLXEAOvaJE1EnxkXZf7KrtjDEwYWSiahzB3+5Yu8S2tSlEM/KyoJEIsGCBQsM2wRBwJtvvong4GB4eHhgwoQJOHHiRKfn2rJlC2JiYiCXyxETE4OtW7d2pTSz8MYmEXXmx7Iae5fQJotDPC8vD+vXr0d8fLzR9vfeew8ffPABVq1ahby8PAQFBWHSpEmora1t91yHDh3CrFmzkJGRgcLCQmRkZGDmzJk4cuSIpeWZhQ/7EFFnFO6u9i6hTRaFeF1dHebMmYMNGzagd+/ehu2CIGD58uVYtGgRHnzwQcTGxmLjxo1oaGjAP/7xj3bPt3z5ckyaNAmZmZmIjo5GZmYmJk6ciOXLl1tSntm4xiYRdeb+hGB7l9Ami0L8hRdeQFpaGlJTU422nzt3DpWVlZg8ebJhm1wux/jx43Hw4MF2z3fo0CGjYwBgypQpHR5jTc1siRNRJ+JClPYuoU1mDzHMyclBfn4+8vLyWr1XWVkJAAgMNJ6iMTAwEBcuXGj3nJWVlW0ec/N8bdFoNNBoNIY/q9Vqk+pvC7tTiKgznm4ye5fQJrNa4qWlpZg/fz42bdoEd/f2V7SQSCRGfxYEodW2rh6TlZUFpVJpeIWFhZnwDdrGuVOIqDMXrjbYu4Q2mRXix44dQ1VVFZKSkuDi4gIXFxfs378fK1euhIuLi6E1fWcLuqqqqlVL+3ZBQUFmH5OZmYmamhrDq7S01JyvYoRPbBJRZ1xkHTdE7cWsEJ84cSKKioqgUqkMr+HDh2POnDlQqVTo378/goKCsHv3bsMxzc3N2L9/P0aPHt3ueVNSUoyOAYBdu3Z1eIxcLodCoTB6WYo3NomoIyP69caIfo41Be1NZvWJ+/j4IDY21mibl5cX/Pz8DNsXLFiAd999F5GRkYiMjMS7774LT09PzJ4923DM3LlzERISgqysLADA/PnzMW7cOCxbtgzp6enYtm0b9uzZgwMHDnT1+5lEzxAnonZEBXpj8++S4SJzzGcjrT53yquvvorGxkY8//zzuH79OkaNGoVdu3bBx8fHsE9JSQmk0lsXZPTo0cjJycEf//hHLF68GAMGDMBnn32GUaNGWbu8NrElTkTtCVJ6OGyAA4BEEHpGh7BarYZSqURNTY3ZXStPZ+fh25+qbFQZEYlZmK8Hvn/13m7/XFMzzXF/vXQjtsSJ6HZyFymeGN0P0UE+KL3WiDOX2n/i3N44FS04OoWIjCWG98Kb9w+BVqdHTl4pAn3aH1JtbwxxAMxwIrrdyXI1apu08HF3RUZyhL3L6RC7U8A1NonImLqpBVk7frJ3GSZhiANghhPRnXaduGTvEkzCEAdb4kRkzEUqwexR4fYuwyTsEwfAqVOI6KZwX09senoUwv087V2KSdgSB5/YJKJbRt7lK5oABxjiADjEkIhuOX7RMZdhaw9DHEAL+1OI6FfNLeK6R8YQByCAIU5EN4T5iqcrBWCIExEZhPt6Ysn9Q+xdhlk4OgV8YpOIgLT4vnjvt/HwkosrFsVVLRGRDYT29sCqRxM7XUbSEbE7hYicXm1TC5q04rqheRNDHIAIf/kSkRXVNGrxp23H0aTV2bsUszHEAej4sA+R0/vnsTKs3feLvcswG0Mc4ABDIgIArM89i5KrDfYuwywMcYApTkQAgEatDicr1PYuwywcnUJEBGDMQD9kJPfDlCGB9i7FLAxxsCFORMCa2UlQerrauwyzsTsFgMCnfYicnpdcZu8SLMIQB0Q5wJ+IrEsr0onwGOLgOHEiZ+fv7QYPN7bERYuLQhA5t1F3+dm7BIsxxAEww4mc273RfexdgsU4OgVc2YfI2dwYThiBZp0ACYDfxPW1d0kWY4iDU9ESOZP7hgbj/YfjIXcRZx/4nRji4BBDImcgkQD/OWUQnp8w0N6lWBVDHHzYh8gZLPrNYDwztr+9y7A6hjjYnULUk8mkErwyKapHBjjAECeiHsxb7oKVjybg3mhxzYdiDrOGGK5duxbx8fFQKBRQKBRISUnBjh07DO9funQJTzzxBIKDg+Hp6YmpU6eiuLi4w3NmZ2dDIpG0ejU1NVn2jSzA1e6Jeh4XqQTvPhjXowMcMLMlHhoaiqVLl2LgwBs3BjZu3Ij09HQUFBQgJiYGM2bMgKurK7Zt2waFQoEPPvgAqampOHnyJLy8vNo9r0KhwOnTp422ubu7W/B1LMPuFKKexVUmwcYnR2L0QH97l2JzZoX4fffdZ/Tnd955B2vXrsXhw4fh6uqKw4cP4/jx4xgyZAgAYM2aNejTpw82b96MZ555pt3zSiQSBAUFWVC+dfBhH6Kew00mxV9nJThFgANdeGJTp9MhJycH9fX1SElJgUajAWDcgpbJZHBzc8OBAwc6PFddXR0iIiIQGhqK6dOno6CgoNPP12g0UKvVRi9L8WEfop7jnQdikRYv3od3zGV2iBcVFcHb2xtyuRzPPvsstm7dipiYGERHRyMiIgKZmZm4fv06mpubsXTpUlRWVqKioqLd80VHRyM7Oxvbt2/H5s2b4e7ujjFjxnTal56VlQWlUml4hYWFmftVDLjGJlHP8NyEAXh4uOVZIEYSwcwnXZqbm1FSUoLq6mps2bIFH3/8Mfbv34+YmBgcO3YMTz/9NAoLCyGTyZCamgqp9MbviW+++cak8+v1egwbNgzjxo3DypUr291Po9EYWv8AoFarERYWhpqaGigUCnO+EuLe+BdqNS1mHUNEjmXUXb7ImZfcY6aWVqvVUCqVnWaa2UMM3dzcDDc2hw8fjry8PKxYsQLr1q1DUlISVCoVampq0NzcjICAAIwaNQrDhw83+fxSqRQjRozotCUul8shl8vNLb9NOnanEInewmnRPSbAzdHlWQwFQTBqEQOAUqlEQEAAiouLcfToUaSnp5t1PpVKhb59u69Pq4XdKUSiNnVIEIaF97Z3GXZhVkv89ddfx7Rp0xAWFoba2lrk5ORg37592LlzJwDgn//8JwICAhAeHo6ioiLMnz8fM2bMwOTJkw3nmDt3LkJCQpCVlQUAWLJkCZKTkxEZGQm1Wo2VK1dCpVJh9erVVvyaHeN84kTi5S13waK0wfYuw27MCvFLly4hIyMDFRUVUCqViI+Px86dOzFp0iQAQEVFBV555RVcunQJffv2xdy5c7F48WKjc5SUlBj6yQGguroa8+bNQ2VlJZRKJRITE5Gbm4uRI0da4euZht0pROLiLXfBoyPDkBDWG4P7+iDM19PeJdmN2Tc2HZWpNwHuJAgC7so07aYrEdmfm4sUu18ehwi/9h8g7AlMzTSnX9lHrIujEjmrt2fE9vgAN4fThzjHiBN1j7v8vfDJEyPwxfOjMXqAZWta/nZYKGY62Tjwzjh9iGv1enuXQNTj9fJ0xWfzknFPdB8MC++Nvz89CqmDTVvXUiaVIEhx40nwhDClLcsUJaefilbH7hQim3JzkWLVo8PQR3HblBxSCV6ZNAh7TlW1e5yXmwx/To9FygA/BPfywLkr9Qh34huY7XH6ENfq2BInspXenq5YPXtYm5NRDe7rg96errjeoDXaLpUAL6feWMTBw+3WOph3+bMfvC1OH+J80IfI+nzkLpg9Khy/G9cf/t5tP1ktkUhwT3QffJF/0bAtpJcHlv42DmMjA7qrVNFz+hDnjU0i6/tgVgImxXS+GMMzd/dH7pnLaNLqkdzfD1kPxiHAxzrTaTgLpw9xTkNLZF1Dw3qZFOAAEBOswNE/TrJxRT2b049OYUucyLoCvN3sXYJTYYgzxImsKtyXNyC7k9OHOCOcyLpiQ8ybz5+6xulDnC1xIutykTl9rHQrp7+xyfuaROZxlUkwLjIA4X6eqNe04KfKWgQrPXD0wjVcqWuGq9T5FmawJ6cPcY5OITKdRAKsy0jCvdGtR5+om7T47lQVxkZxjHd3cvoQ58M+RKaLD+3VZoADgMLdFTMSQ7q5InL6ziu2xIlMV9ek7Xwn6lZOH+I9ZE0Mom7xy+V6XKnTdL4jdRun705hhhN1ztNNhrS4vhgXFdDuXChkH04f4hLeSCfq1CuTbswqSI6H3SlsiRN1SCIBxnPEicNy+hAnova5uUjxj2eSERnoY+9SqB0McSJql4tUgqSI3vYugzrg9CHOPnGi9jU063Do7FV7l0EdcPoQB4xT3M1FiskxgejDiemJAADf/Fhh7xKoA04/OuX2aR5kUgk+eWIExgz0h6ZFhwU5Kuw4Xmm/4ogcQH1zi71LoA44fUtcclt/SkZyBMb8uqCr3EWGvzw8FMFK9/YO7ZSP3AVety30SiRGfKrZsTl9iEslQC9PVzyUFIo/TBlk9J633AXvPBBn0XnHRwXg34tScWRRKkb0440hEq8qNZ/QdGROH+J3+Xth3x8m4P2Hh8Jb3rp36Z7oPnj67rugcO+45yk6yAfurjcup7+3HMt+Gw8PNxm85S548/4hNqmdqDv4cbk1h+b0feI+7q6d7rN4egwWT4/BkbNX8czGo6jVGPcRpg7ug48fH4HSaw04fPYq7onuY/RocoQfl6sicZK7SPE7Pqnp0Jw+xM0xqr8f1s1NwsufqXBJrcHYSH9MignEzOFhAIAwX0+E+Xq2Os5b7gIXqYTT3pIofPLkCJRXN+J0ZS1mjwpHdBCXW3NkDHEzjR7gj8OZE6Fp0cPd1fSblj7uLrjewGk8yfGF+3rinkF97F0Gmcjp+8QtIZFIzApwAJgW19dG1RBZ1w8/X7F3CWQGs0J87dq1iI+Ph0KhgEKhQEpKCnbs2GF4/9KlS3jiiScQHBwMT09PTJ06FcXFxZ2ed8uWLYiJiYFcLkdMTAy2bt1q/jdxcO8+EIdPnhiBN+6LwYv3DMQ9gwLgxgVlyQEt31OM4ku19i6DTGRWioSGhmLp0qU4evQojh49invvvRfp6ek4ceIEBEHAjBkzcPbsWWzbtg0FBQWIiIhAamoq6uvr2z3noUOHMGvWLGRkZKCwsBAZGRmYOXMmjhw50uUv52juie6DJ8fchT9MGYRPnhyJg5n3Ytav/elE1hYd5IOBfbzNPu5afTNmrP4BB39hi1wMJEIXl7bx9fXFX/7yF4wdOxaDBg3C8ePHMWTIjSF1Op0Offr0wbJly/DMM8+0efysWbOgVquNWvRTp05F7969sXnzZpPrUKvVUCqVqKmpgUIhrhsxWd+cwrrcs/Yug3qQt9KHICOlHwRBwPwcFbYXlpt9Di83Gf718jiE9m59s55sz9RMs/jf8zqdDjk5Oaivr0dKSgo0mhsPBLi733rCUSaTwc3NDQcOHGj3PIcOHcLkyZONtk2ZMgUHDx7s8PM1Gg3UarXRS6z+MGUQIi1oMRG1Z0psEIAb928WTou26Bz1zTrknb9mzbLIBswO8aKiInh7e0Mul+PZZ5/F1q1bERMTg+joaERERCAzMxPXr19Hc3Mzli5disrKSlRUtD+BTmVlJQIDjVfPDgwMRGVlx3OWZGVlQalUGl5hYeLtlnCVSfHEmH72LoN6iLsH+qOPz63GVEgvD8SGKJAU0RtxIUqTz+Pv7YbhEb62KJGsyOwQHzRoEFQqFQ4fPoznnnsOjz/+OE6ePAlXV1ds2bIFZ86cga+vLzw9PbFv3z5MmzYNMlnHIzkkd8wHKwhCq213yszMRE1NjeFVWlpq7ldxKKPu8rN3CSRybjIpnhjdD+vnJrV676vfj8WW50Zj+4tjMHN4qEnnmxQT1OZzD+RYzB4n7ubmhoEDBwIAhg8fjry8PKxYsQLr1q1DUlISVCoVampq0NzcjICAAIwaNQrDhw9v93xBQUGtWt1VVVWtWud3ksvlkMt7znSxob09IJFwuTiyjIerDNteHIOoTlbgkUgk+MPkQfj6xwrUN+s63Dc+1PRWO9lPl8e4CYJg6A+/SalUIiAgAMXFxTh69CjS09PbPT4lJQW7d+822rZr1y6MHj26q6WJirurDPGhvexdBonUhEEBnQb4TX0U7ngsJaLT/SwZ2ULdz6wQf/311/H999/j/PnzKCoqwqJFi7Bv3z7MmTMHAPDPf/4T+/btMwwznDRpEmbMmGF043Lu3LnIzMw0/Hn+/PnYtWsXli1bhp9++gnLli3Dnj17sGDBAut8QxF56d6B9i6BRMhVJsErk6LMOua3w0LbXNWqr9Idsl8n2f9g1xk0aTturZP9mRXily5dQkZGBgYNGoSJEyfiyJEj2LlzJyZNmgQAqKioQEZGBqKjo/HSSy8hIyOj1TDBkpISoxudo0ePRk5ODj755BPEx8cjOzsbn332GUaNGmWFrycuEwcH4rfDTOuvJLpp5F2+Zi9kHBXogwcSQoy2jY8KwIGF92LLc6Ph5iLFobNX8d7O09YslWygy+PEHYWYx4nfTtOiw2/XHsTxi+IdMknd660ZschI7rx75E6r9/6Mv/zrVkjveWUcBva58ctg709VWLbzJwwN7YVlD8VbrVYynamZxgmwHIzcRYb3Hx6KaSu+501O6lRUoDfmjAw3+7gjZ6/io/2/GG0L6XVrJMo90X1wTzQnwRIDTt7hgKKDFHiI3SrUCR+5C/7r4QRIpR0Px71TlboJL+UUoLbp1rz4vl5ucJWZdx5yDAxxB7UobTA8zJwpkZzL7ORwxFkwDLCsuhFX65oNf5ZJJXjz/iFw4YRsosT/ag6ql6cbwnw97F0GObAWnWX9bcPCe+PDRxPh5SZDSC8PfDYvGfcPDbZyddRd2CfuwKSdPLVKzq0r835Pi+uLcVEBcJFJIHfhv/jEjCHuwK7VN3e+EzkteRe727zaWBicxIfdKQ6Mg1OoI1F8opLAEHdo/t49Z24Ysi53VymeHnuXvcsgB8AQd2DJ/TkNKLXW398LHz2WxFXoCQD7xB3acxMGYPfJSyi73mjvUsgB9PJ0xYa5wzGiH3+50y0McQfWx8cdX/3+buw8XomfKmtxorwGP5bVQNOit3dp1M38vNzw5QtjOL83tcIQd3C9PN3wyG2PVTc0t+BfJyqxIfccTla0P7+K3EWKiYP7IEjhgfNX67HvdBX0vFMqWg8lhTLAqU0McZHxdHPBA4mheCAxFDuKKrC14CIOn70KvQBIJMCIfr6YkRiCe6P7wPu2IWS5Zy7j2U3H0NDJQgBEJC6cxdCJNGl1OH+1HqqSauQWX8buk5egtfCpP+peXm4yvDUjFg9yTh2nYWqmMcSdWGFpNR7dcNipWudxIUpMGRKIUf39sG7/L9hzqsreJZlMIgH2/WECIvy87F0KdQNORUudGhrWC+kJwdj8b3EvMm2KcF9PZD0YhzED/Q3bYvoqkPjn3WjWieNGsSAApypqGeJkhCHu5BLCevW4EO+rdMeUIUHo5emK/JJqBPrI8af7YuDj7mq0n5fcBYFKOUqviWcI53c/XcLU2CB7l0EOhCHu5O6NDkT/gLM4e7ne3qVYzYePJmK4CWOpW3R6XK7VdLqfI/mxrMbeJZCD4RObTi7AR46vfz8W7z0Uj7S4vjBzfYFWenu6YkiwAu6u9vnRGtGvt0kBDgBnr9SjSSuOrpSbzl6uh45jRek2bIkTPNxkmDk8DDOHh+Hdb05hfe5Zs47vq3THuMgAPDQ8FMMjekMikaCmUYv3dv6E/zlSYqOqWwvp5YH3Hx5q8v5i/NfHqP6+htXoiQCGON1hXGSASSHuI3fBsxMGYFh4b6QM8Gv1vtLDFe88EAdvdxes22/eLwVzDezjjQcSQ/DkmH7wdDP9R3pgH2+4yiSiGmaZGN7b3iWQg2GIk5FBQT4m7bcuIwmjbxvp0Z7XpkbjnkF9sPN4JUquNeDnqjqUXW+wytOjEgmw6tFhSIvva9HxA/t44+m7+7daMNiRnSxnnzgZY4iTkQAfOeJDlR3eQHN3lZoU4AAgkUiQ3N8Pyf1vtdabtDqcqlBj709V+NsP51GnaengDO27d1AfiwP8phmJwaIK8VMVtRAEARKu+kS/YohTK5t/l4zvi6/gZIUaP1fV4puiSqP37/Lv2mIE7q4yJIb3RmJ4bzyUFIZXtxTi8NlrZp+nrW4cc/UT2Zjri9WNOPTLVZN/iVLPx9Ep1IqX3AVTY4PwyqQorJmThK9+fzfuGRRgeH+aFccph/t54n+eScbE6D7m1egmQ3pCSJc/X+4ihdgatQe6sLYm9TxsiVOnYkOU+OTJkTh7uQ4VNU1I6d/1FvDtZFIJHh0Zjm9/uvUI/PCI3liQGgWtTo/3/nUapyrUkEgAN5kUbjIpVj6aiACfrq98JJFI4OkqQ72Iph74qbLW3iWQA2GIk8n6B3ijf4Bt1nW8fZrVfn6eyH5qpGEWxvFRATh3tR7+3nIoPVzbO4XFwv28cKqDaX0dja+Xm71LIAfC7hRyCIOCfLBwajSig3zw30+MMJpGVyqVYECAt00CHADGRTlm/3JfpTuS+/vC0+3WqvZebjJkJEfYsSpyNJzFkJxe6bUG/Gbl96htsmyUjC2MHuCHjU+NhKtMiiatDkfOXYO2RY/4UCX6KNztXR51A1MzjS1xcnphvp74/D9SrNLHbg19le742xMj4Cq78dfT3VWG8VEBSI0JZIBTKwxxIgCD+yqwc/5Y/HZYKFzs/Fh7cC8PuLvKOt+RCLyxSWTg5y3Hf80cij+nD0GLXoC7qxQ1DVr8crkef/hnIS5Wd8+UtZwahcxhVkt87dq1iI+Ph0KhgEKhQEpKCnbs2GF4v66uDi+++CJCQ0Ph4eGBwYMHY+3atR2eMzs7GxKJpNWrqanJsm9E1EVechcoPVwhd5Ghj8IdKQP8sOvlcXggsevj0k3Rx4ddJmQ6s1rioaGhWLp0KQYOHAgA2LhxI9LT01FQUIAhQ4bg5Zdfxt69e7Fp0yb069cPu3btwvPPP4/g4GCkp6e3e16FQoHTp08bbXN35w8yOQ4vuQveeyge+SXXceFqg00/a0Q/TnJFpjOrJX7ffffhN7/5DaKiohAVFYV33nkH3t7eOHz4MADg0KFDePzxxzFhwgT069cP8+bNw9ChQ3H06NEOzyuRSBAUFGT0InI0rjIpFqRG2vxzJgwy7+lVcm4W39jU6XTIyclBfX09UlJSAAB33303tm/fjosXL0IQBOzduxdnzpzBlClTOjxXXV0dIiIiEBoaiunTp6OgoKDTz9doNFCr1UYvIlt7IDEU9w8NtulnSMU2DwDZldkhXlRUBG9vb8jlcjz77LPYunUrYmJiAAArV65ETEwMQkND4ebmhqlTp2LNmjW4++672z1fdHQ0srOzsX37dmzevBnu7u4YM2YMiouLO6wjKysLSqXS8AoLCzP3qxBZ5N0H4zC4r22eRZBIAG93jjcg05n9sE9zczNKSkpQXV2NLVu24OOPP8b+/fsRExOD999/Hxs2bMD777+PiIgI5ObmIjMzE1u3bkVqaqpJ59fr9Rg2bBjGjRuHlStXtrufRqOBRnNrfUS1Wo2wsDA+7EPdorZJi/d2nsbnR0uhabHeEm8p/f2weV6y1c5H4mXqwz5dfmIzNTUVAwYMwPLly6FUKrF161akpaUZ3n/mmWdQVlaGnTt3mnzO3/3udygrKzMa+dIZPrFJ9nDuSj0eXPMDrjdorXK+5ycMwKtTo61yLhK3bntiUxAEaDQaaLVaaLVaSKXGp5TJZNDrTW+pCIIAlUqFvn27Ntk/UXe4y98LDw4Ltdr5Rt5l2iLPRDeZ1fn2+uuvY9q0aQgLC0NtbS1ycnKwb98+7Ny5EwqFAuPHj8d//ud/wsPDAxEREdi/fz8+/fRTfPDBB4ZzzJ07FyEhIcjKygIALFmyBMnJyYiMjIRarcbKlSuhUqmwevVq635TIhuJ7GOdmR1H3uWLcZEBne9IdBuzQvzSpUvIyMhARUUFlEol4uPjsXPnTkyaNAkAkJOTg8zMTMyZMwfXrl1DREQE3nnnHTz77LOGc5SUlBi11qurqzFv3jxUVlZCqVQiMTERubm5GDlypJW+IpFthd82ja4phoX3QnpCCPadrkIvTzfEhyoRFeiD5P5+kPJxTTITZzEk6qLGZh2Ss75FTWPb/eIyqQSJYb0wYdCNSayig/jzSZ0zNdM4lomoizzcZHh7Riz+3+eFaNbduv8TpHDHoyPDMSc5HP7ejjFDIvU8DHEiK7hvaDBG9PPFdz9VoaG5BTF9FRjV3w8ydo+QjTHEiawkSOmO2aPC7V0GORnOJ05EJGIMcSIiEWOIExGJGEOciEjEGOJERCLGECciEjGGOBGRiDHEiYhEjCFORCRiDHEiIhFjiBMRiRhDnIhIxBjiREQixhAnIhKxHjMV7c0FitRqtZ0rISLquptZ1tniaz0mxGtrawEAYWFhdq6EiMh6amtroVQq232/x6yxqdfrUV5eDkEQEB4ejtLSUqdda1OtViMsLMyprwHA6wDwGgDivQaCIKC2thbBwcFGi8vfqce0xKVSKUJDQw3/BFEoFKL6D2YLvAY38DrwGgDivAYdtcBv4o1NIiIRY4gTEYlYjwtxuVyON954A3K53N6l2A2vwQ28DrwGQM+/Bj3mxiYRkTPqcS1xIiJnwhAnIhIxhjgRkYgxxImIRKxHhfiZM2eQnp4Of39/KBQKjBkzBnv37jXaRyKRtHp99NFHdqrY+ky5BjddvXoVoaGhkEgkqK6u7t5Cbaiza3D16lVMnToVwcHBkMvlCAsLw4svvtjj5t3p7DoUFhbi0UcfRVhYGDw8PDB48GCsWLHCjhVbnyl/H+bPn4+kpCTI5XIkJCTYp9Au6FEhnpaWhpaWFnz33Xc4duwYEhISMH36dFRWVhrt98knn6CiosLwevzxx+1UsfWZeg0A4Omnn0Z8fLwdqrStzq6BVCpFeno6tm/fjjNnziA7Oxt79uzBs88+a+fKrauz63Ds2DEEBARg06ZNOHHiBBYtWoTMzEysWrXKzpVbjyl/HwRBwFNPPYVZs2bZsdIuEHqIy5cvCwCE3Nxcwza1Wi0AEPbs2WPYBkDYunWrHSq0PVOvgSAIwpo1a4Tx48cL3377rQBAuH79ejdXaxvmXIPbrVixQggNDe2OEruFpdfh+eefF+65557uKNHmzL0Gb7zxhjB06NBurNA6ekxL3M/PD4MHD8ann36K+vp6tLS0YN26dQgMDERSUpLRvi+++CL8/f0xYsQIfPTRR9Dr9Xaq2rpMvQYnT57En//8Z3z66acdTqwjRub8HNxUXl6OL774AuPHj+/mam3HkusAADU1NfD19e3GSm3H0msgOvb+LWJNZWVlQlJSkiCRSASZTCYEBwcLBQUFRvu89dZbwsGDB4WCggLh/fffFzw9PYW33nrLPgXbQGfXoKmpSYiPjxf+/ve/C4IgCHv37u1RLXFBMO3nQBAE4ZFHHhE8PDwEAMJ9990nNDY2dn+xNmTqdbjp4MGDgqurq7Br167uK9LGzLkGYm2JO3yIv/HGGwKADl95eXmCXq8X7r//fmHatGnCgQMHhGPHjgnPPfecEBISIpSXl7d7/vfff19QKBTd+I3MZ81r8PLLLwuzZs0ynFssIW6Ln4OKigrh1KlTwpdffinExMQIzz33nJ2+nels9ffh+PHjQkBAgCgaNLa6BmINcYd/7P7KlSu4cuVKh/v069cPP/zwAyZPnozr168bTTcZGRmJp59+Gq+99lqbx/7www+4++67UVlZicDAQKvWbi3WvAYJCQkoKiqCRCIBcOOmjl6vh0wmw6JFi7BkyRKbfhdL2frn4MCBAxg7dizKy8vRt29fq9ZuTba4DidPnsQ999yDZ555Bu+8847NarcWW/0svPnmm/jyyy+hUqlsUbbNOPx84v7+/vD39+90v4aGBgBo1ccrlUo77PMuKCiAu7s7evXq1aU6bcma12DLli1obGw0vJeXl4ennnoK33//PQYMGGDFqq3L1j8HN9syGo2mC1XanrWvw4kTJ3Dvvffi8ccfF0WAA7b/WRAd+/5DwHouX74s+Pn5CQ8++KCgUqmE06dPC3/4wx8EV1dXQaVSCYIgCNu3bxfWr18vFBUVCT///LOwYcMGQaFQCC+99JKdq7cOU67BncTSnWIqU67B119/Lfztb38TioqKhHPnzglff/21MGTIEGHMmDF2rt56TLkON7tQ5syZI1RUVBheVVVVdq7eOkz9+1BcXCwUFBQI//Ef/yFERUUJBQUFQkFBgaDRaOxYvel6TIgLgiDk5eUJkydPFnx9fQUfHx8hOTlZ+Oabbwzv79ixQ0hISBC8vb0FT09PITY2Vli+fLmg1WrtWLV1dXYN7tTTQlwQOr8G3333nZCSkiIolUrB3d1diIyMFBYuXNijroEgdH4d2utbjoiIsF/RVmbK34fx48e3eR3OnTtnn6LN5PB94kRE1L6eNUiYiMjJMMSJiESMIU5EJGIMcSIiEWOIExGJGEOciEjEGOJERCLGECciEjGGOBGRiDHEiYhEjCFORCRiDHEiIhH7/5GP+UX/bk33AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "area.plot()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e20946a9",
   "metadata": {},
   "source": [
    "## 2. Searching for Dollar General locations within the search area"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "27144979",
   "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></th>\n",
       "      <th>brand</th>\n",
       "      <th>brand:wikidata</th>\n",
       "      <th>brand:wikipedia</th>\n",
       "      <th>name</th>\n",
       "      <th>shop</th>\n",
       "      <th>geometry</th>\n",
       "      <th>addr:city</th>\n",
       "      <th>addr:housenumber</th>\n",
       "      <th>addr:postcode</th>\n",
       "      <th>addr:state</th>\n",
       "      <th>...</th>\n",
       "      <th>payment:cash</th>\n",
       "      <th>payment:credit_cards</th>\n",
       "      <th>alt_name</th>\n",
       "      <th>payment:american_express</th>\n",
       "      <th>payment:cheque</th>\n",
       "      <th>payment:debit_cards</th>\n",
       "      <th>payment:food_stamps</th>\n",
       "      <th>payment:mastercard</th>\n",
       "      <th>payment:visa</th>\n",
       "      <th>payment:visa_debit</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>element_type</th>\n",
       "      <th>osmid</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">node</th>\n",
       "      <th>8155671002</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-82.45860 38.42858)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9664519146</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-82.37589 38.43839)</td>\n",
       "      <td>Proctorville</td>\n",
       "      <td>510</td>\n",
       "      <td>45669</td>\n",
       "      <td>OH</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">way</th>\n",
       "      <th>769785598</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POLYGON ((-82.36632 38.44060, -82.36608 38.440...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>921158812</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POLYGON ((-82.28537 38.58989, -82.28536 38.590...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>node</th>\n",
       "      <th>9664700047</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-82.63385 39.04780)</td>\n",
       "      <td>Jackson</td>\n",
       "      <td>325</td>\n",
       "      <td>45640</td>\n",
       "      <td>OH</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 46 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  brand brand:wikidata    brand:wikipedia  \\\n",
       "element_type osmid                                                          \n",
       "node         8155671002  Dollar General        Q145168  en:Dollar General   \n",
       "             9664519146  Dollar General        Q145168  en:Dollar General   \n",
       "way          769785598   Dollar General        Q145168  en:Dollar General   \n",
       "             921158812   Dollar General        Q145168  en:Dollar General   \n",
       "node         9664700047  Dollar General        Q145168  en:Dollar General   \n",
       "\n",
       "                                   name           shop  \\\n",
       "element_type osmid                                       \n",
       "node         8155671002  Dollar General  variety_store   \n",
       "             9664519146  Dollar General  variety_store   \n",
       "way          769785598   Dollar General  variety_store   \n",
       "             921158812   Dollar General  variety_store   \n",
       "node         9664700047  Dollar General  variety_store   \n",
       "\n",
       "                                                                  geometry  \\\n",
       "element_type osmid                                                           \n",
       "node         8155671002                         POINT (-82.45860 38.42858)   \n",
       "             9664519146                         POINT (-82.37589 38.43839)   \n",
       "way          769785598   POLYGON ((-82.36632 38.44060, -82.36608 38.440...   \n",
       "             921158812   POLYGON ((-82.28537 38.58989, -82.28536 38.590...   \n",
       "node         9664700047                         POINT (-82.63385 39.04780)   \n",
       "\n",
       "                            addr:city addr:housenumber addr:postcode  \\\n",
       "element_type osmid                                                     \n",
       "node         8155671002           NaN              NaN           NaN   \n",
       "             9664519146  Proctorville              510         45669   \n",
       "way          769785598            NaN              NaN           NaN   \n",
       "             921158812            NaN              NaN           NaN   \n",
       "node         9664700047       Jackson              325         45640   \n",
       "\n",
       "                        addr:state  ... payment:cash payment:credit_cards  \\\n",
       "element_type osmid                  ...                                     \n",
       "node         8155671002        NaN  ...          NaN                  NaN   \n",
       "             9664519146         OH  ...          NaN                  NaN   \n",
       "way          769785598         NaN  ...          NaN                  NaN   \n",
       "             921158812         NaN  ...          NaN                  NaN   \n",
       "node         9664700047         OH  ...          NaN                  NaN   \n",
       "\n",
       "                        alt_name payment:american_express payment:cheque  \\\n",
       "element_type osmid                                                         \n",
       "node         8155671002      NaN                      NaN            NaN   \n",
       "             9664519146      NaN                      NaN            NaN   \n",
       "way          769785598       NaN                      NaN            NaN   \n",
       "             921158812       NaN                      NaN            NaN   \n",
       "node         9664700047      NaN                      NaN            NaN   \n",
       "\n",
       "                        payment:debit_cards payment:food_stamps  \\\n",
       "element_type osmid                                                \n",
       "node         8155671002                 NaN                 NaN   \n",
       "             9664519146                 NaN                 NaN   \n",
       "way          769785598                  NaN                 NaN   \n",
       "             921158812                  NaN                 NaN   \n",
       "node         9664700047                 NaN                 NaN   \n",
       "\n",
       "                        payment:mastercard payment:visa payment:visa_debit  \n",
       "element_type osmid                                                          \n",
       "node         8155671002                NaN          NaN                NaN  \n",
       "             9664519146                NaN          NaN                NaN  \n",
       "way          769785598                 NaN          NaN                NaN  \n",
       "             921158812                 NaN          NaN                NaN  \n",
       "node         9664700047                NaN          NaN                NaN  \n",
       "\n",
       "[5 rows x 46 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tags = {'brand':'Dollar General'} \n",
    "buildings = ox.geometries_from_place(search_area, tags)\n",
    "buildings.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "77a3ffe9",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\imdav\\Anaconda3\\envs\\GeospatialPython\\lib\\site-packages\\geopandas\\geodataframe.py:1472: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  super().__setitem__(key, value)\n",
      "C:\\Users\\imdav\\Anaconda3\\envs\\GeospatialPython\\lib\\site-packages\\geopandas\\geodataframe.py:1472: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  super().__setitem__(key, value)\n"
     ]
    },
    {
     "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></th>\n",
       "      <th>brand</th>\n",
       "      <th>brand:wikidata</th>\n",
       "      <th>brand:wikipedia</th>\n",
       "      <th>name</th>\n",
       "      <th>shop</th>\n",
       "      <th>geometry</th>\n",
       "      <th>addr:city</th>\n",
       "      <th>addr:housenumber</th>\n",
       "      <th>addr:postcode</th>\n",
       "      <th>addr:state</th>\n",
       "      <th>...</th>\n",
       "      <th>alt_name</th>\n",
       "      <th>payment:american_express</th>\n",
       "      <th>payment:cheque</th>\n",
       "      <th>payment:debit_cards</th>\n",
       "      <th>payment:food_stamps</th>\n",
       "      <th>payment:mastercard</th>\n",
       "      <th>payment:visa</th>\n",
       "      <th>payment:visa_debit</th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>element_type</th>\n",
       "      <th>osmid</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"10\" valign=\"top\">node</th>\n",
       "      <th>8155671002</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-82.45860 38.42858)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.458599</td>\n",
       "      <td>38.428581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9664519146</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-82.37589 38.43839)</td>\n",
       "      <td>Proctorville</td>\n",
       "      <td>510</td>\n",
       "      <td>45669</td>\n",
       "      <td>OH</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.375886</td>\n",
       "      <td>38.438389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9664700047</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-82.63385 39.04780)</td>\n",
       "      <td>Jackson</td>\n",
       "      <td>325</td>\n",
       "      <td>45640</td>\n",
       "      <td>OH</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.633850</td>\n",
       "      <td>39.047795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9699400098</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-82.44356 40.03412)</td>\n",
       "      <td>Heath</td>\n",
       "      <td>639</td>\n",
       "      <td>43056</td>\n",
       "      <td>OH</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.443563</td>\n",
       "      <td>40.034121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5610584322</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-82.33207 40.85606)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1289</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.332066</td>\n",
       "      <td>40.856058</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6541995221</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-82.54241 40.72486)</td>\n",
       "      <td>Mansfield</td>\n",
       "      <td>1280</td>\n",
       "      <td>44907</td>\n",
       "      <td>OH</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.542409</td>\n",
       "      <td>40.724856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8423631416</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-82.17904 41.46652)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>425</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.179043</td>\n",
       "      <td>41.466523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4016548521</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-81.80301 41.48486)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-81.803013</td>\n",
       "      <td>41.484860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9140123128</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>en:Dollar General</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-81.73789 41.46133)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-81.737891</td>\n",
       "      <td>41.461334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9738827142</th>\n",
       "      <td>Dollar General</td>\n",
       "      <td>Q145168</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dollar General</td>\n",
       "      <td>variety_store</td>\n",
       "      <td>POINT (-81.64130 41.46174)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-81.641295</td>\n",
       "      <td>41.461738</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  brand brand:wikidata    brand:wikipedia  \\\n",
       "element_type osmid                                                          \n",
       "node         8155671002  Dollar General        Q145168  en:Dollar General   \n",
       "             9664519146  Dollar General        Q145168  en:Dollar General   \n",
       "             9664700047  Dollar General        Q145168  en:Dollar General   \n",
       "             9699400098  Dollar General        Q145168  en:Dollar General   \n",
       "             5610584322  Dollar General        Q145168  en:Dollar General   \n",
       "             6541995221  Dollar General        Q145168  en:Dollar General   \n",
       "             8423631416  Dollar General        Q145168  en:Dollar General   \n",
       "             4016548521  Dollar General        Q145168  en:Dollar General   \n",
       "             9140123128  Dollar General        Q145168  en:Dollar General   \n",
       "             9738827142  Dollar General        Q145168                NaN   \n",
       "\n",
       "                                   name           shop  \\\n",
       "element_type osmid                                       \n",
       "node         8155671002  Dollar General  variety_store   \n",
       "             9664519146  Dollar General  variety_store   \n",
       "             9664700047  Dollar General  variety_store   \n",
       "             9699400098  Dollar General  variety_store   \n",
       "             5610584322  Dollar General  variety_store   \n",
       "             6541995221  Dollar General  variety_store   \n",
       "             8423631416  Dollar General  variety_store   \n",
       "             4016548521  Dollar General  variety_store   \n",
       "             9140123128  Dollar General  variety_store   \n",
       "             9738827142  Dollar General  variety_store   \n",
       "\n",
       "                                           geometry     addr:city  \\\n",
       "element_type osmid                                                  \n",
       "node         8155671002  POINT (-82.45860 38.42858)           NaN   \n",
       "             9664519146  POINT (-82.37589 38.43839)  Proctorville   \n",
       "             9664700047  POINT (-82.63385 39.04780)       Jackson   \n",
       "             9699400098  POINT (-82.44356 40.03412)         Heath   \n",
       "             5610584322  POINT (-82.33207 40.85606)           NaN   \n",
       "             6541995221  POINT (-82.54241 40.72486)     Mansfield   \n",
       "             8423631416  POINT (-82.17904 41.46652)           NaN   \n",
       "             4016548521  POINT (-81.80301 41.48486)           NaN   \n",
       "             9140123128  POINT (-81.73789 41.46133)           NaN   \n",
       "             9738827142  POINT (-81.64130 41.46174)           NaN   \n",
       "\n",
       "                        addr:housenumber addr:postcode addr:state  ...  \\\n",
       "element_type osmid                                                 ...   \n",
       "node         8155671002              NaN           NaN        NaN  ...   \n",
       "             9664519146              510         45669         OH  ...   \n",
       "             9664700047              325         45640         OH  ...   \n",
       "             9699400098              639         43056         OH  ...   \n",
       "             5610584322             1289           NaN        NaN  ...   \n",
       "             6541995221             1280         44907         OH  ...   \n",
       "             8423631416              425           NaN        NaN  ...   \n",
       "             4016548521              NaN           NaN        NaN  ...   \n",
       "             9140123128              NaN           NaN        NaN  ...   \n",
       "             9738827142              NaN           NaN        NaN  ...   \n",
       "\n",
       "                        alt_name payment:american_express payment:cheque  \\\n",
       "element_type osmid                                                         \n",
       "node         8155671002      NaN                      NaN            NaN   \n",
       "             9664519146      NaN                      NaN            NaN   \n",
       "             9664700047      NaN                      NaN            NaN   \n",
       "             9699400098      NaN                      NaN            NaN   \n",
       "             5610584322      NaN                      NaN            NaN   \n",
       "             6541995221      NaN                      NaN            NaN   \n",
       "             8423631416      NaN                      NaN            NaN   \n",
       "             4016548521      NaN                      NaN            NaN   \n",
       "             9140123128      NaN                      NaN            NaN   \n",
       "             9738827142      NaN                      NaN            NaN   \n",
       "\n",
       "                        payment:debit_cards payment:food_stamps  \\\n",
       "element_type osmid                                                \n",
       "node         8155671002                 NaN                 NaN   \n",
       "             9664519146                 NaN                 NaN   \n",
       "             9664700047                 NaN                 NaN   \n",
       "             9699400098                 NaN                 NaN   \n",
       "             5610584322                 NaN                 NaN   \n",
       "             6541995221                 NaN                 NaN   \n",
       "             8423631416                 NaN                 NaN   \n",
       "             4016548521                 NaN                 NaN   \n",
       "             9140123128                 NaN                 NaN   \n",
       "             9738827142                 NaN                 NaN   \n",
       "\n",
       "                        payment:mastercard payment:visa payment:visa_debit  \\\n",
       "element_type osmid                                                           \n",
       "node         8155671002                NaN          NaN                NaN   \n",
       "             9664519146                NaN          NaN                NaN   \n",
       "             9664700047                NaN          NaN                NaN   \n",
       "             9699400098                NaN          NaN                NaN   \n",
       "             5610584322                NaN          NaN                NaN   \n",
       "             6541995221                NaN          NaN                NaN   \n",
       "             8423631416                NaN          NaN                NaN   \n",
       "             4016548521                NaN          NaN                NaN   \n",
       "             9140123128                NaN          NaN                NaN   \n",
       "             9738827142                NaN          NaN                NaN   \n",
       "\n",
       "                                 X          Y  \n",
       "element_type osmid                             \n",
       "node         8155671002 -82.458599  38.428581  \n",
       "             9664519146 -82.375886  38.438389  \n",
       "             9664700047 -82.633850  39.047795  \n",
       "             9699400098 -82.443563  40.034121  \n",
       "             5610584322 -82.332066  40.856058  \n",
       "             6541995221 -82.542409  40.724856  \n",
       "             8423631416 -82.179043  41.466523  \n",
       "             4016548521 -81.803013  41.484860  \n",
       "             9140123128 -81.737891  41.461334  \n",
       "             9738827142 -81.641295  41.461738  \n",
       "\n",
       "[10 rows x 48 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DG_points = buildings[buildings.geom_type == 'Point']\n",
    "DG_points['X'] = DG_points.geometry.x\n",
    "DG_points['Y'] = DG_points.geometry.y\n",
    "DG_points.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "07b568f2",
   "metadata": {},
   "source": [
    "## 3. Searching for Family Dollar locations within the search area"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "6c169678",
   "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></th>\n",
       "      <th>addr:city</th>\n",
       "      <th>addr:housenumber</th>\n",
       "      <th>addr:postcode</th>\n",
       "      <th>addr:state</th>\n",
       "      <th>addr:street</th>\n",
       "      <th>brand</th>\n",
       "      <th>brand:wikidata</th>\n",
       "      <th>brand:wikipedia</th>\n",
       "      <th>name</th>\n",
       "      <th>ref</th>\n",
       "      <th>...</th>\n",
       "      <th>drive_through</th>\n",
       "      <th>wheelchair</th>\n",
       "      <th>source</th>\n",
       "      <th>operator</th>\n",
       "      <th>name:en</th>\n",
       "      <th>ref:family_dollar</th>\n",
       "      <th>advertising</th>\n",
       "      <th>area</th>\n",
       "      <th>building:colour</th>\n",
       "      <th>branch</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>element_type</th>\n",
       "      <th>osmid</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">node</th>\n",
       "      <th>9622630880</th>\n",
       "      <td>Coal Grove</td>\n",
       "      <td>324</td>\n",
       "      <td>45638</td>\n",
       "      <td>OH</td>\n",
       "      <td>Marion Pike</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>6025</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9630540643</th>\n",
       "      <td>South Point</td>\n",
       "      <td>301</td>\n",
       "      <td>45680</td>\n",
       "      <td>OH</td>\n",
       "      <td>Solida Road</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>1640</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">way</th>\n",
       "      <th>609808811</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>632676051</th>\n",
       "      <td>South Point</td>\n",
       "      <td>385</td>\n",
       "      <td>45680</td>\n",
       "      <td>OH</td>\n",
       "      <td>County Road 406</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>10690</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>769785597</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           addr:city addr:housenumber addr:postcode  \\\n",
       "element_type osmid                                                    \n",
       "node         9622630880   Coal Grove              324         45638   \n",
       "             9630540643  South Point              301         45680   \n",
       "way          609808811           NaN              NaN           NaN   \n",
       "             632676051   South Point              385         45680   \n",
       "             769785597           NaN              NaN           NaN   \n",
       "\n",
       "                        addr:state      addr:street          brand  \\\n",
       "element_type osmid                                                   \n",
       "node         9622630880         OH      Marion Pike  Family Dollar   \n",
       "             9630540643         OH      Solida Road  Family Dollar   \n",
       "way          609808811         NaN              NaN  Family Dollar   \n",
       "             632676051          OH  County Road 406  Family Dollar   \n",
       "             769785597         NaN              NaN  Family Dollar   \n",
       "\n",
       "                        brand:wikidata   brand:wikipedia           name  \\\n",
       "element_type osmid                                                        \n",
       "node         9622630880       Q5433101  en:Family Dollar  Family Dollar   \n",
       "             9630540643       Q5433101  en:Family Dollar  Family Dollar   \n",
       "way          609808811        Q5433101  en:Family Dollar  Family Dollar   \n",
       "             632676051        Q5433101  en:Family Dollar  Family Dollar   \n",
       "             769785597        Q5433101  en:Family Dollar  Family Dollar   \n",
       "\n",
       "                           ref  ... drive_through wheelchair source operator  \\\n",
       "element_type osmid              ...                                            \n",
       "node         9622630880   6025  ...           NaN        NaN    NaN      NaN   \n",
       "             9630540643   1640  ...           NaN        NaN    NaN      NaN   \n",
       "way          609808811     NaN  ...           NaN        NaN    NaN      NaN   \n",
       "             632676051   10690  ...           NaN        NaN    NaN      NaN   \n",
       "             769785597     NaN  ...           NaN        NaN    NaN      NaN   \n",
       "\n",
       "                        name:en ref:family_dollar advertising area  \\\n",
       "element_type osmid                                                   \n",
       "node         9622630880     NaN               NaN         NaN  NaN   \n",
       "             9630540643     NaN               NaN         NaN  NaN   \n",
       "way          609808811      NaN               NaN         NaN  NaN   \n",
       "             632676051      NaN               NaN         NaN  NaN   \n",
       "             769785597      NaN               NaN         NaN  NaN   \n",
       "\n",
       "                        building:colour branch  \n",
       "element_type osmid                              \n",
       "node         9622630880             NaN    NaN  \n",
       "             9630540643             NaN    NaN  \n",
       "way          609808811              NaN    NaN  \n",
       "             632676051              NaN    NaN  \n",
       "             769785597              NaN    NaN  \n",
       "\n",
       "[5 rows x 34 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tags = {'brand':'Family Dollar'} \n",
    "buildings = ox.geometries_from_place(search_area, tags)\n",
    "buildings.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "c7e48838",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\imdav\\Anaconda3\\envs\\GeospatialPython\\lib\\site-packages\\geopandas\\geodataframe.py:1472: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  super().__setitem__(key, value)\n",
      "C:\\Users\\imdav\\Anaconda3\\envs\\GeospatialPython\\lib\\site-packages\\geopandas\\geodataframe.py:1472: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  super().__setitem__(key, value)\n"
     ]
    },
    {
     "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></th>\n",
       "      <th>addr:city</th>\n",
       "      <th>addr:housenumber</th>\n",
       "      <th>addr:postcode</th>\n",
       "      <th>addr:state</th>\n",
       "      <th>addr:street</th>\n",
       "      <th>brand</th>\n",
       "      <th>brand:wikidata</th>\n",
       "      <th>brand:wikipedia</th>\n",
       "      <th>name</th>\n",
       "      <th>ref</th>\n",
       "      <th>...</th>\n",
       "      <th>source</th>\n",
       "      <th>operator</th>\n",
       "      <th>name:en</th>\n",
       "      <th>ref:family_dollar</th>\n",
       "      <th>advertising</th>\n",
       "      <th>area</th>\n",
       "      <th>building:colour</th>\n",
       "      <th>branch</th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>element_type</th>\n",
       "      <th>osmid</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"10\" valign=\"top\">node</th>\n",
       "      <th>9622630880</th>\n",
       "      <td>Coal Grove</td>\n",
       "      <td>324</td>\n",
       "      <td>45638</td>\n",
       "      <td>OH</td>\n",
       "      <td>Marion Pike</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>6025</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.648173</td>\n",
       "      <td>38.500873</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9630540643</th>\n",
       "      <td>South Point</td>\n",
       "      <td>301</td>\n",
       "      <td>45680</td>\n",
       "      <td>OH</td>\n",
       "      <td>Solida Road</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>1640</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.583572</td>\n",
       "      <td>38.420220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7006732723</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.416731</td>\n",
       "      <td>40.085096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6384997692</th>\n",
       "      <td>Mansfield</td>\n",
       "      <td>1219</td>\n",
       "      <td>44905</td>\n",
       "      <td>OH</td>\n",
       "      <td>Ashland Road</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.469251</td>\n",
       "      <td>40.781124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6515261461</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.655577</td>\n",
       "      <td>40.880246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4381516776</th>\n",
       "      <td>Sandusky</td>\n",
       "      <td>709</td>\n",
       "      <td>44870</td>\n",
       "      <td>OH</td>\n",
       "      <td>West Perkins Avenue</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>7280</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.710318</td>\n",
       "      <td>41.433865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8914211772</th>\n",
       "      <td>Sandusky</td>\n",
       "      <td>1112</td>\n",
       "      <td>44870</td>\n",
       "      <td>OH</td>\n",
       "      <td>Cleveland Road West</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-82.695520</td>\n",
       "      <td>41.444068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2687482976</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-81.704338</td>\n",
       "      <td>41.485050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3857294802</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-81.774575</td>\n",
       "      <td>41.477334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3992210600</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>Q5433101</td>\n",
       "      <td>en:Family Dollar</td>\n",
       "      <td>Family Dollar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-81.633062</td>\n",
       "      <td>41.505245</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           addr:city addr:housenumber addr:postcode  \\\n",
       "element_type osmid                                                    \n",
       "node         9622630880   Coal Grove              324         45638   \n",
       "             9630540643  South Point              301         45680   \n",
       "             7006732723          NaN              NaN           NaN   \n",
       "             6384997692    Mansfield             1219         44905   \n",
       "             6515261461          NaN              NaN           NaN   \n",
       "             4381516776     Sandusky              709         44870   \n",
       "             8914211772     Sandusky             1112         44870   \n",
       "             2687482976          NaN              NaN           NaN   \n",
       "             3857294802          NaN              NaN           NaN   \n",
       "             3992210600          NaN              NaN           NaN   \n",
       "\n",
       "                        addr:state          addr:street          brand  \\\n",
       "element_type osmid                                                       \n",
       "node         9622630880         OH          Marion Pike  Family Dollar   \n",
       "             9630540643         OH          Solida Road  Family Dollar   \n",
       "             7006732723        NaN                  NaN  Family Dollar   \n",
       "             6384997692         OH         Ashland Road  Family Dollar   \n",
       "             6515261461        NaN                  NaN  Family Dollar   \n",
       "             4381516776         OH  West Perkins Avenue  Family Dollar   \n",
       "             8914211772         OH  Cleveland Road West  Family Dollar   \n",
       "             2687482976        NaN                  NaN  Family Dollar   \n",
       "             3857294802        NaN                  NaN  Family Dollar   \n",
       "             3992210600        NaN                  NaN  Family Dollar   \n",
       "\n",
       "                        brand:wikidata   brand:wikipedia           name   ref  \\\n",
       "element_type osmid                                                              \n",
       "node         9622630880       Q5433101  en:Family Dollar  Family Dollar  6025   \n",
       "             9630540643       Q5433101  en:Family Dollar  Family Dollar  1640   \n",
       "             7006732723       Q5433101  en:Family Dollar  Family Dollar   NaN   \n",
       "             6384997692       Q5433101  en:Family Dollar  Family Dollar   NaN   \n",
       "             6515261461       Q5433101  en:Family Dollar  Family Dollar   NaN   \n",
       "             4381516776       Q5433101  en:Family Dollar  Family Dollar  7280   \n",
       "             8914211772       Q5433101  en:Family Dollar  Family Dollar   NaN   \n",
       "             2687482976       Q5433101  en:Family Dollar  Family Dollar   NaN   \n",
       "             3857294802       Q5433101  en:Family Dollar  Family Dollar   NaN   \n",
       "             3992210600       Q5433101  en:Family Dollar  Family Dollar   NaN   \n",
       "\n",
       "                         ... source operator name:en ref:family_dollar  \\\n",
       "element_type osmid       ...                                             \n",
       "node         9622630880  ...    NaN      NaN     NaN               NaN   \n",
       "             9630540643  ...    NaN      NaN     NaN               NaN   \n",
       "             7006732723  ...    NaN      NaN     NaN               NaN   \n",
       "             6384997692  ...    NaN      NaN     NaN               NaN   \n",
       "             6515261461  ...    NaN      NaN     NaN               NaN   \n",
       "             4381516776  ...    NaN      NaN     NaN               NaN   \n",
       "             8914211772  ...    NaN      NaN     NaN               NaN   \n",
       "             2687482976  ...    NaN      NaN     NaN               NaN   \n",
       "             3857294802  ...    NaN      NaN     NaN               NaN   \n",
       "             3992210600  ...    NaN      NaN     NaN               NaN   \n",
       "\n",
       "                        advertising area building:colour branch          X  \\\n",
       "element_type osmid                                                           \n",
       "node         9622630880         NaN  NaN             NaN    NaN -82.648173   \n",
       "             9630540643         NaN  NaN             NaN    NaN -82.583572   \n",
       "             7006732723         NaN  NaN             NaN    NaN -82.416731   \n",
       "             6384997692         NaN  NaN             NaN    NaN -82.469251   \n",
       "             6515261461         NaN  NaN             NaN    NaN -82.655577   \n",
       "             4381516776         NaN  NaN             NaN    NaN -82.710318   \n",
       "             8914211772         NaN  NaN             NaN    NaN -82.695520   \n",
       "             2687482976         NaN  NaN             NaN    NaN -81.704338   \n",
       "             3857294802         NaN  NaN             NaN    NaN -81.774575   \n",
       "             3992210600         NaN  NaN             NaN    NaN -81.633062   \n",
       "\n",
       "                                 Y  \n",
       "element_type osmid                  \n",
       "node         9622630880  38.500873  \n",
       "             9630540643  38.420220  \n",
       "             7006732723  40.085096  \n",
       "             6384997692  40.781124  \n",
       "             6515261461  40.880246  \n",
       "             4381516776  41.433865  \n",
       "             8914211772  41.444068  \n",
       "             2687482976  41.485050  \n",
       "             3857294802  41.477334  \n",
       "             3992210600  41.505245  \n",
       "\n",
       "[10 rows x 36 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "FD_points = buildings[buildings.geom_type == 'Point']\n",
    "FD_points['X'] = FD_points.geometry.x\n",
    "FD_points['Y'] = FD_points.geometry.y\n",
    "FD_points.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "950c2a72",
   "metadata": {},
   "source": [
    "## 4. Writing out the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "12d1a520",
   "metadata": {},
   "outputs": [],
   "source": [
    "DG_points.to_csv(data_path + 'OSM_DollarGeneralLocs.csv')\n",
    "FD_points.to_csv(data_path + 'OSM_FamilyDollarLocs.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f576df2f",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "GeospatialPython",
   "language": "python",
   "name": "geospatialpython"
  },
  "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.10.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}