Interactive_mapping_of_wells.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "94dc81f7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    sl_no Well_code     Lat_DD    Long_DD  Altitude_of_WT(m)  \\\n",
      "0       1    JADW01  19.702500  76.973889                507   \n",
      "1       2    JADW04  19.708056  76.951111                495   \n",
      "2       3    JADW05  19.707500  76.950556                492   \n",
      "3       4    JADW08  19.701944  76.959444                491   \n",
      "4       5    JADW12  19.699167  76.957500                487   \n",
      "5       6    JADW13  19.694167  76.958333                482   \n",
      "6       7    JADW16  19.697500  76.954167                475   \n",
      "7       8    JADW17  19.700833  76.956111                481   \n",
      "8       9    JADW22  19.711389  76.954444                523   \n",
      "9      10    JADW30  19.704722  76.949722                487   \n",
      "10     11    JADW34  19.701944  76.953056                481   \n",
      "11     12    JADW36  19.701944  76.951944                485   \n",
      "12     13    JADW38  19.691389  76.957222                468   \n",
      "13     15    JADW44  19.689167  76.950833                469   \n",
      "14     16    JADW47  19.688889  76.948056                472   \n",
      "15     17    JADW52  19.704722  76.948056                491   \n",
      "16     18    JADW55  19.705833  76.944167                497   \n",
      "17     19    JADW59  19.690000  76.944444                477   \n",
      "18     20    JADW62  19.692222  76.940000                486   \n",
      "19     21    JADW64  19.693333  76.939722                490   \n",
      "20     22    JADW66  19.708611  76.936111                523   \n",
      "21     23    JADW70  19.686944  76.937222                497   \n",
      "22     24    JADW73  19.707222  76.933889                527   \n",
      "\n",
      "    Depth_Of_Well(m)  Jun_Sept_WL_From_WTL  Oct_Dec_WL_From_WTL  \\\n",
      "0               6.40                   0.0                 0.25   \n",
      "1               9.10                   0.8                 1.20   \n",
      "2               4.00                   1.0                 0.35   \n",
      "3               7.90                   2.3                 2.80   \n",
      "4               5.00                   2.5                 3.30   \n",
      "5               6.90                   0.8                 1.70   \n",
      "6               8.73                   0.8                 1.70   \n",
      "7               5.30                   1.5                 2.10   \n",
      "8               5.60                   1.8                 3.12   \n",
      "9              14.87                   0.0                 1.95   \n",
      "10              4.80                   0.5                 0.90   \n",
      "11              6.20                   2.5                 4.05   \n",
      "12              7.05                   1.0                 1.52   \n",
      "13              4.90                   1.0                 1.20   \n",
      "14              5.00                   0.5                 1.10   \n",
      "15              8.30                   1.0                 2.40   \n",
      "16              7.50                   2.0                 4.00   \n",
      "17             11.00                   1.0                 1.90   \n",
      "18              8.30                   2.0                 4.60   \n",
      "19              8.10                   2.0                 2.60   \n",
      "20              7.90                   1.0                 1.70   \n",
      "21              3.00                   1.0                 1.60   \n",
      "22             11.40                   1.0                 1.80   \n",
      "\n",
      "    Jan_Mar_WL_From_WTL  April_May_WL_From_WTL  Jun_Sept_Depth_WL_From_RFL  \\\n",
      "0                   3.0                   6.40                       507.0   \n",
      "1                   4.0                   7.00                       494.2   \n",
      "2                   4.0                   4.00                       491.0   \n",
      "3                   4.0                   7.70                       488.7   \n",
      "4                   5.0                   5.00                       484.5   \n",
      "5                   3.0                   6.90                       481.2   \n",
      "6                   3.0                   5.00                       474.2   \n",
      "7                   3.0                   5.30                       479.5   \n",
      "8                   4.0                   4.50                       521.2   \n",
      "9                  12.0                  14.87                       487.0   \n",
      "10                  4.8                   4.80                       480.5   \n",
      "11                  5.5                   6.20                       482.5   \n",
      "12                  3.0                   7.05                       467.0   \n",
      "13                  2.5                   4.00                       468.0   \n",
      "14                  4.5                   5.00                       471.5   \n",
      "15                  5.0                   8.30                       490.0   \n",
      "16                  6.0                   7.50                       495.0   \n",
      "17                  6.0                  11.00                       476.0   \n",
      "18                  6.0                   8.30                       484.0   \n",
      "19                  5.0                   8.10                       488.0   \n",
      "20                  5.0                   7.90                       522.0   \n",
      "21                  3.0                   3.00                       496.0   \n",
      "22                  3.0                   9.00                       526.0   \n",
      "\n",
      "    Oct_Dec_Depth_WL_From_RFL  Jan_March_Depth_WL_From_RFL  \\\n",
      "0                      506.75                        504.0   \n",
      "1                      493.80                        491.0   \n",
      "2                      491.65                        488.0   \n",
      "3                      488.20                        487.0   \n",
      "4                      483.70                        482.0   \n",
      "5                      480.30                        479.0   \n",
      "6                      473.30                        472.0   \n",
      "7                      478.90                        478.0   \n",
      "8                      519.88                        519.0   \n",
      "9                      485.05                        475.0   \n",
      "10                     480.10                        476.2   \n",
      "11                     480.95                        479.5   \n",
      "12                     466.48                        465.0   \n",
      "13                     467.80                        466.5   \n",
      "14                     470.90                        467.5   \n",
      "15                     488.60                        486.0   \n",
      "16                     493.00                        491.0   \n",
      "17                     475.10                        471.0   \n",
      "18                     481.40                        480.0   \n",
      "19                     487.40                        485.0   \n",
      "20                     521.30                        518.0   \n",
      "21                     495.40                        494.0   \n",
      "22                     525.20                        524.0   \n",
      "\n",
      "    April_May_Depth_WL_From_RFL  \\\n",
      "0                        500.60   \n",
      "1                        488.00   \n",
      "2                        488.00   \n",
      "3                        483.30   \n",
      "4                        482.00   \n",
      "5                        475.10   \n",
      "6                        470.00   \n",
      "7                        475.70   \n",
      "8                        518.50   \n",
      "9                        472.13   \n",
      "10                       476.20   \n",
      "11                       478.80   \n",
      "12                       460.95   \n",
      "13                       465.00   \n",
      "14                       467.00   \n",
      "15                       482.70   \n",
      "16                       489.50   \n",
      "17                       466.00   \n",
      "18                       477.70   \n",
      "19                       481.90   \n",
      "20                       515.10   \n",
      "21                       494.00   \n",
      "22                       518.00   \n",
      "\n",
      "                                             well_pic  \\\n",
      "0   https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "1   https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "2   https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "3   https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "4   https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "5   https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "6   https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "7   https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "8   https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "9   https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "10  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "11  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "12  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "13  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "14  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "15  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "16  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "17  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "18  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "19  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "20  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "21  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "22  https://github.com/UdayKumar0711/wells/blob/ma...   \n",
      "\n",
      "                                           month_plot  \n",
      "0   https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "1   https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "2   https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "3   https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "4   https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "5   https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "6   https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "7   https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "8   https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "9   https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "10  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "11  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "12  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "13  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "14  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "15  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "16  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "17  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "18  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "19  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "20  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "21  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "22  https://github.com/UdayKumar0711/wells/blob/ma...  \n",
      "C:\\Users\\udayk\\Downloads\n",
      "<class 'list'>\n",
      "<class 'list'>\n",
      "<class 'str'>\n",
      "<class 'list'>\n",
      "<class 'str'>\n",
      "<class 'list'>\n",
      "<class 'list'>\n"
     ]
    }
   ],
   "source": [
    "import folium\n",
    "from folium import plugins\n",
    "import pandas as pd\n",
    "well_data=pd.read_csv('Wells2.csv')\n",
    "print(well_data)\n",
    "import os\n",
    "print(os.getcwd())\n",
    "\n",
    "#create base map\n",
    "m = folium.Map(location=[19.7011, 76.8967], tiles=\"Stamen Terrain\",zoom_start=12,width=800,height=400,control_scale=True)\n",
    "\n",
    "# add tiles to map\n",
    "folium.raster_layers.TileLayer('Open Street Map').add_to(m)\n",
    "folium.raster_layers.TileLayer('Stamen Terrain').add_to(m)\n",
    "folium.raster_layers.TileLayer('Stamen Toner').add_to(m)\n",
    "folium.raster_layers.TileLayer('Stamen Watercolor').add_to(m)\n",
    "folium.raster_layers.TileLayer('CartoDB Positron').add_to(m)\n",
    "folium.raster_layers.TileLayer('CartoDB Dark_Matter').add_to(m)\n",
    "\n",
    "\n",
    "# add geojson file to map\n",
    "folium.GeoJson('well_boundary.geojson', name='Well_boundary ').add_to(m)\n",
    "\n",
    "\n",
    "# add layer control to show different maps\n",
    "folium.LayerControl().add_to(m)\n",
    "\n",
    "# plugin for mini map\n",
    "minimap = plugins.MiniMap(toggle_display=True)\n",
    "\n",
    "# add minimap to map\n",
    "m.add_child(minimap)\n",
    "\n",
    "# add scroll zoom toggler to map\n",
    "plugins.ScrollZoomToggler().add_to(m)\n",
    "\n",
    "# add full screen button to map\n",
    "plugins.Fullscreen(position='topright').add_to(m)\n",
    "\n",
    "\n",
    "#creating objects from dataframe \n",
    "lat=list(well_data[\"Lat_DD\"])\n",
    "lon=list(well_data[\"Long_DD\"])\n",
    "Wellname=list(well_data[\"Well_code\"])\n",
    "WellDepth=list(well_data[\"Depth_Of_Well(m)\"])\n",
    "WellDepth1=str(WellDepth)\n",
    "WellTopLevel=list(well_data[\"Altitude_of_WT(m)\"])\n",
    "WellTopLevel1=str(WellTopLevel)\n",
    "plot=list(well_data[\"month_plot\"])\n",
    "picture=list(well_data[\"well_pic\"])\n",
    "\n",
    "#to know data type of different objects generated\n",
    "print(type(Wellname))\n",
    "print(type(WellDepth))\n",
    "print(type(WellDepth1))\n",
    "print(type(WellTopLevel))\n",
    "print(type(WellTopLevel1))\n",
    "print(type(plot))\n",
    "print(type(picture))\n",
    "\n",
    "#Adding Marker\n",
    "\n",
    "for lt,ln,nm,dep,lev,pl,pic in zip(lat,lon,Wellname,WellDepth,WellTopLevel,plot,picture):\n",
    "\n",
    " folium.Marker(location=[lt,ln],popup=\"<b>Wellname  : </b>\"+nm+ \" <br> <b>WellDepth: </b> \"+str(dep)+ \n",
    "               \"<br> <b>WellTopLevel : </b> \"+str(lev)+\"<br> <img src=\"+pl+\" height=200 width=350>\"+\"<br> <img src=\"+\n",
    "               pic+\" height=200 width=350>\",tooltip='click for more info',icon=folium.Icon(color='green')).add_to(m)\n",
    "\n",
    "# measure control\n",
    "measure_control = plugins.MeasureControl(position='topleft', \n",
    "                                         active_color='red', \n",
    "                                         completed_color='red', \n",
    "                                         primary_length_unit='kilometers')\n",
    "\n",
    "# add measure control to map\n",
    "m.add_child(measure_control)\n",
    "\n",
    "# draw tools\n",
    "draw = plugins.Draw(export=True)\n",
    "\n",
    "# add draw tools to map\n",
    "draw.add_to(m)\n",
    "\n",
    "\n",
    "# display map\n",
    "m.add_child(folium.LatLngPopup())\n",
    "m\n",
    "#save map\n",
    "#m.save(\"map2.html\")\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a73ad69a",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "37127c60",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "hide_input": false,
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.10"
  },
  "latex_envs": {
   "LaTeX_envs_menu_present": true,
   "autoclose": false,
   "autocomplete": true,
   "bibliofile": "biblio.bib",
   "cite_by": "apalike",
   "current_citInitial": 1,
   "eqLabelWithNumbers": true,
   "eqNumInitial": 1,
   "hotkeys": {
    "equation": "Ctrl-E",
    "itemize": "Ctrl-I"
   },
   "labels_anchors": false,
   "latex_user_defs": false,
   "report_style_numbering": false,
   "user_envs_cfg": false
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}