create Buffer Area.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import geopandas as gpd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pd.set_option('display.width', 500)\n",
    "# pd.set_option('display.max_rows', 50)\n",
    "# pd.set_option('display.max_columns', 500)\n",
    "# pd.set_option('display.max_colwidth', 500)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "inbuilding = pd.read_excel('sample-folder/Renewal Pico_EID_10082023.xlsx')\n",
    "inbuilding = inbuilding.astype(str)\n",
    "inbuilding = gpd.GeoDataFrame(inbuilding, geometry=gpd.points_from_xy(inbuilding['Long'], inbuilding['Lat']), crs=4326)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/tmp/ipykernel_16039/2353560854.py:1: UserWarning: Geometry is in a geographic CRS. Results from 'buffer' are likely incorrect. Use 'GeoSeries.to_crs()' to re-project geometries to a projected CRS before this operation.\n",
      "\n",
      "  inbuilding['geometry'] = inbuilding['geometry'].buffer(0.0008985/3)\n"
     ]
    }
   ],
   "source": [
    "inbuilding['geometry'] = inbuilding['geometry'].buffer(0.0008985/3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "inbuilding['WKT'] = inbuilding['geometry']\n",
    "inbuilding.rename(columns={'Sitename':'polygon_name'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'towerid': 0,\n",
       " 'hana_contract_number': 1,\n",
       " 'Pico/Macro': 2,\n",
       " 'polygon_name': 3,\n",
       " 'tower_provider': 4,\n",
       " 'lease_end_date': 5,\n",
       " 'SOW': 6,\n",
       " 'Tech Part ': 7,\n",
       " 'Long': 8,\n",
       " 'Lat': 9,\n",
       " 'OK / Not OK': 10,\n",
       " 'Remark': 11,\n",
       " 'geometry': 12,\n",
       " 'WKT': 13}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "{c: i for i, c in enumerate(inbuilding.columns)}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "inbuilding = inbuilding[['polygon_name', 'WKT']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>polygon_name</th>\n",
       "      <th>WKT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CILEGON CENTER MALL</td>\n",
       "      <td>POLYGON ((106.06978 -6.02518, 106.06978 -6.025...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Summarecon Mall Serpong</td>\n",
       "      <td>POLYGON ((106.62919 -6.23994, 106.62919 -6.239...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Menara Matahari</td>\n",
       "      <td>POLYGON ((106.61005 -6.22919, 106.61005 -6.229...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sinarmasland Tangerang</td>\n",
       "      <td>POLYGON ((106.65172 -6.30136, 106.65171 -6.301...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Carrefour Harapan Indah</td>\n",
       "      <td>POLYGON ((106.97630 -6.18676, 106.97630 -6.186...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Summarecon Mall Bekasi</td>\n",
       "      <td>POLYGON ((107.00098 -6.22456, 107.00098 -6.224...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Cibinong City Mall</td>\n",
       "      <td>POLYGON ((106.84319 -6.48447, 106.84319 -6.484...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>RS Mitra Keluarga Depok</td>\n",
       "      <td>POLYGON ((106.82430 -6.39393, 106.82430 -6.393...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Pesona Square Depok</td>\n",
       "      <td>POLYGON ((106.84499 -6.38007, 106.84499 -6.380...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>RS Cito Karawang</td>\n",
       "      <td>POLYGON ((107.27840 -6.30541, 107.27840 -6.305...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Apartemen Patria Park (Pico &amp; 3G Pico Le</td>\n",
       "      <td>POLYGON ((106.87613 -6.24375, 106.87613 -6.243...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Bassura Tower ABCHJ</td>\n",
       "      <td>POLYGON ((106.87877 -6.22366, 106.87876 -6.223...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Cibubur Square</td>\n",
       "      <td>POLYGON ((106.89028 -6.34018, 106.89028 -6.340...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>RS Mitra Keluarga Kalideres</td>\n",
       "      <td>POLYGON ((106.70260 -6.14964, 106.70260 -6.149...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Millenium Centenial Center</td>\n",
       "      <td>POLYGON ((106.82139 -6.21457, 106.82139 -6.214...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>PAKUBUWONO_SPRING</td>\n",
       "      <td>POLYGON ((106.78720 -6.23296, 106.78720 -6.232...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>RSIA BRAWIJAYAJAKARTA</td>\n",
       "      <td>POLYGON ((106.80779 -6.25756, 106.80779 -6.257...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Menara Prima B</td>\n",
       "      <td>POLYGON ((106.82530 -6.22962, 106.82530 -6.229...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>LTE_RITZ_CARLTON</td>\n",
       "      <td>POLYGON ((106.82746 -6.22851, 106.82746 -6.228...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ROYAL KUNINGAN HOTEL</td>\n",
       "      <td>POLYGON ((106.82993 -6.20642, 106.82993 -6.206...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>HTLJSLUWANSAKUNINGAN</td>\n",
       "      <td>POLYGON ((106.83298 -6.22284, 106.83298 -6.222...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>KCA Belatera Kelapa Gading</td>\n",
       "      <td>POLYGON ((106.89608 -6.17460, 106.89608 -6.174...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>3G_RS_PLUIT</td>\n",
       "      <td>POLYGON ((106.79983 -6.12578, 106.79983 -6.125...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mall of Indonesia</td>\n",
       "      <td>POLYGON ((106.89215 -6.15152, 106.89215 -6.151...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>HtlHarrisKelapaGading</td>\n",
       "      <td>POLYGON ((106.91031 -6.15767, 106.91030 -6.157...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>3G_RS_GADING_PLUIT</td>\n",
       "      <td>POLYGON ((106.91616 -6.16619, 106.91616 -6.166...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>DOUBLE3 CIKINI</td>\n",
       "      <td>POLYGON ((106.84341 -6.19889, 106.84341 -6.198...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>3G_SCTV_TOWER</td>\n",
       "      <td>POLYGON ((106.79740 -6.22789, 106.79740 -6.227...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Blok B Tanah Abang</td>\n",
       "      <td>POLYGON ((106.81507 -6.18769, 106.81507 -6.187...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>TCC BATAVIA</td>\n",
       "      <td>POLYGON ((106.81644 -6.21119, 106.81644 -6.211...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>APARTEMENCEMPAKAMAS2</td>\n",
       "      <td>POLYGON ((106.87603 -6.16470, 106.87603 -6.164...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Bandara Adi Sumarmo</td>\n",
       "      <td>POLYGON ((110.75030 -7.51356, 110.75030 -7.513...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Transmart Setiabudi Semarang</td>\n",
       "      <td>POLYGON ((110.41122 -7.06688, 110.41122 -7.066...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Airport A Yani Semarang</td>\n",
       "      <td>POLYGON ((110.37521 -6.96560, 110.37521 -6.965...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Rusunawa Gemawang Sleman Yogyakarta</td>\n",
       "      <td>POLYGON ((110.36721 -7.75491, 110.36721 -7.754...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                polygon_name   \n",
       "0                        CILEGON CENTER MALL  \\\n",
       "1                    Summarecon Mall Serpong   \n",
       "2                            Menara Matahari   \n",
       "3                     Sinarmasland Tangerang   \n",
       "4                    Carrefour Harapan Indah   \n",
       "5                     Summarecon Mall Bekasi   \n",
       "6                         Cibinong City Mall   \n",
       "7                    RS Mitra Keluarga Depok   \n",
       "8                        Pesona Square Depok   \n",
       "9                           RS Cito Karawang   \n",
       "10  Apartemen Patria Park (Pico & 3G Pico Le   \n",
       "11                       Bassura Tower ABCHJ   \n",
       "12                            Cibubur Square   \n",
       "13               RS Mitra Keluarga Kalideres   \n",
       "14                Millenium Centenial Center   \n",
       "15                         PAKUBUWONO_SPRING   \n",
       "16                     RSIA BRAWIJAYAJAKARTA   \n",
       "17                            Menara Prima B   \n",
       "18                          LTE_RITZ_CARLTON   \n",
       "19                      ROYAL KUNINGAN HOTEL   \n",
       "20                      HTLJSLUWANSAKUNINGAN   \n",
       "21                KCA Belatera Kelapa Gading   \n",
       "22                               3G_RS_PLUIT   \n",
       "23                         Mall of Indonesia   \n",
       "24                     HtlHarrisKelapaGading   \n",
       "25                        3G_RS_GADING_PLUIT   \n",
       "26                            DOUBLE3 CIKINI   \n",
       "27                             3G_SCTV_TOWER   \n",
       "28                        Blok B Tanah Abang   \n",
       "29                               TCC BATAVIA   \n",
       "30                      APARTEMENCEMPAKAMAS2   \n",
       "31                       Bandara Adi Sumarmo   \n",
       "32              Transmart Setiabudi Semarang   \n",
       "33                   Airport A Yani Semarang   \n",
       "34       Rusunawa Gemawang Sleman Yogyakarta   \n",
       "\n",
       "                                                  WKT  \n",
       "0   POLYGON ((106.06978 -6.02518, 106.06978 -6.025...  \n",
       "1   POLYGON ((106.62919 -6.23994, 106.62919 -6.239...  \n",
       "2   POLYGON ((106.61005 -6.22919, 106.61005 -6.229...  \n",
       "3   POLYGON ((106.65172 -6.30136, 106.65171 -6.301...  \n",
       "4   POLYGON ((106.97630 -6.18676, 106.97630 -6.186...  \n",
       "5   POLYGON ((107.00098 -6.22456, 107.00098 -6.224...  \n",
       "6   POLYGON ((106.84319 -6.48447, 106.84319 -6.484...  \n",
       "7   POLYGON ((106.82430 -6.39393, 106.82430 -6.393...  \n",
       "8   POLYGON ((106.84499 -6.38007, 106.84499 -6.380...  \n",
       "9   POLYGON ((107.27840 -6.30541, 107.27840 -6.305...  \n",
       "10  POLYGON ((106.87613 -6.24375, 106.87613 -6.243...  \n",
       "11  POLYGON ((106.87877 -6.22366, 106.87876 -6.223...  \n",
       "12  POLYGON ((106.89028 -6.34018, 106.89028 -6.340...  \n",
       "13  POLYGON ((106.70260 -6.14964, 106.70260 -6.149...  \n",
       "14  POLYGON ((106.82139 -6.21457, 106.82139 -6.214...  \n",
       "15  POLYGON ((106.78720 -6.23296, 106.78720 -6.232...  \n",
       "16  POLYGON ((106.80779 -6.25756, 106.80779 -6.257...  \n",
       "17  POLYGON ((106.82530 -6.22962, 106.82530 -6.229...  \n",
       "18  POLYGON ((106.82746 -6.22851, 106.82746 -6.228...  \n",
       "19  POLYGON ((106.82993 -6.20642, 106.82993 -6.206...  \n",
       "20  POLYGON ((106.83298 -6.22284, 106.83298 -6.222...  \n",
       "21  POLYGON ((106.89608 -6.17460, 106.89608 -6.174...  \n",
       "22  POLYGON ((106.79983 -6.12578, 106.79983 -6.125...  \n",
       "23  POLYGON ((106.89215 -6.15152, 106.89215 -6.151...  \n",
       "24  POLYGON ((106.91031 -6.15767, 106.91030 -6.157...  \n",
       "25  POLYGON ((106.91616 -6.16619, 106.91616 -6.166...  \n",
       "26  POLYGON ((106.84341 -6.19889, 106.84341 -6.198...  \n",
       "27  POLYGON ((106.79740 -6.22789, 106.79740 -6.227...  \n",
       "28  POLYGON ((106.81507 -6.18769, 106.81507 -6.187...  \n",
       "29  POLYGON ((106.81644 -6.21119, 106.81644 -6.211...  \n",
       "30  POLYGON ((106.87603 -6.16470, 106.87603 -6.164...  \n",
       "31  POLYGON ((110.75030 -7.51356, 110.75030 -7.513...  \n",
       "32  POLYGON ((110.41122 -7.06688, 110.41122 -7.066...  \n",
       "33  POLYGON ((110.37521 -6.96560, 110.37521 -6.965...  \n",
       "34  POLYGON ((110.36721 -7.75491, 110.36721 -7.754...  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inbuilding"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "inbuilding.to_csv('csv_polygon/inbuilding-2.csv', index=False)\n",
    "\n",
    "# inbuilding.to_file('csv_polygon/inbuilding.csv', driver='MapInfo File')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".python-3.10",
   "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.10.11"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}