In [1]:
import os
os.environ['USE_PYGEOS'] = '0'
os.environ['USE_PATH_FOR_GDAL_PYTHON'] = 'YES'
import pandas as pd
import numpy as np
import geopandas as gpd
import matplotlib.pyplot as plt
import folium
import georaster
from osgeo import gdal, ogr, osr
os.chdir('C:/Users/jtrum/world_bank/data/')
In [2]:
#import IHME raster
ihme = gdal.Open('sanitation/Percent/IHME_LMIC_WASH_2000_2017_S_IMP_PERCENT_MEAN_2017_Y2020M06D02.tif')
In [3]:
#visualize raster
ihme_array = ihme.ReadAsArray()
plt.imshow(ihme_array)
Out[3]:
<matplotlib.image.AxesImage at 0x1f7315fd730>
In [6]:
band = ihme.GetRasterBand(1)
# converting raster to shapefile
proj = raster.GetProjection()
shp_proj = osr.SpatialReference()
shp_proj.ImportFromWkt(proj)
out = 'output/WSF_Luanda.shp'
call_drive = ogr.GetDriverByName('ESRI Shapefile')
create_shp = call_drive.CreateDataSource(out)
shp = create_shp.CreateLayer('layername', srs=shp_proj)
new_field = ogr.FieldDefn(str('ID'), ogr.OFTInteger)
shp.CreateField(new_field)
gdal.Polygonize(band, None, shp, 0, [], callback=None)
create_shp.Destroy()
raster = None
In [7]:
out = 'output/IHME_Luanda.shp'
raster_path = 'sanitation/Percent/IHME_LMIC_WASH_2000_2017_S_IMP_PERCENT_MEAN_2017_Y2020M06D02.tif'
## Check if the output directory exists, and create it if necessary
output_dir = os.path.dirname(out)
if not os.path.exists(output_dir):
os.makedirs(output_dir, exist_ok=True)
# Open the raster dataset
raster = gdal.Open(raster_path)
if raster is None:
print("Failed to open the raster dataset.")
else:
proj = raster.GetProjection()
shp_proj = osr.SpatialReference()
shp_proj.ImportFromWkt(proj)
call_drive = ogr.GetDriverByName('ESRI Shapefile')
create_shp = call_drive.CreateDataSource(out)
if create_shp is None:
print("Failed to create the shapefile.")
else:
shp = create_shp.CreateLayer('layername', srs=shp_proj)
new_field = ogr.FieldDefn('ID', ogr.OFTInteger)
shp.CreateField(new_field)
# Assuming 'band' is correctly defined
gdal.Polygonize(band, None, shp, 0, [], callback=None)
# Clean up
create_shp.Destroy()
raster = None
print("Shapefile created successfully.")
Shapefile created successfully.
In [8]:
ihme = gpd.read_file('output/IHME_Luanda.shp')
In [9]:
ihme
Out[9]:
| ID | geometry | |
|---|---|---|
| 0 | 86 | POLYGON ((123.16670 53.58333, 123.20836 53.583... |
| 1 | 86 | POLYGON ((123.25003 53.58333, 123.37503 53.583... |
| 2 | -999999 | POLYGON ((123.37503 53.58333, 123.45836 53.583... |
| 3 | 85 | POLYGON ((122.95836 53.54166, 123.00003 53.541... |
| 4 | 85 | POLYGON ((123.04170 53.54166, 123.08336 53.541... |
| ... | ... | ... |
| 1235100 | 75 | POLYGON ((19.95835 -34.79167, 20.00002 -34.791... |
| 1235101 | 80 | POLYGON ((20.00002 -34.79167, 20.04168 -34.791... |
| 1235102 | 76 | POLYGON ((20.04168 -34.79167, 20.08335 -34.791... |
| 1235103 | 77 | POLYGON ((19.95835 -34.83333, 20.04168 -34.833... |
| 1235104 | -999999 | POLYGON ((-118.37500 53.58333, 123.16670 53.58... |
1235105 rows × 2 columns
In [13]:
aoi = gpd.read_file('aoiLuanda.geojson')
In [15]:
ihme = ihme.to_crs(aoi.crs)
print(ihme.crs)
print(aoi.crs)
GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4326"]] GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4326"]]
In [16]:
join = gpd.sjoin(ihme, aoi, how='inner', predicate='intersects')
In [17]:
len(join)
Out[17]:
142
In [22]:
#set max display rows to 142
pd.set_option('display.max_rows', 142)
join
Out[22]:
| ID | geometry | index_right | NAME_1 | GID_0 | COUNTRY | GID_1 | NL_NAME_1 | GID_2 | NAME_2 | VARNAME_2 | NL_NAME_2 | TYPE_2 | ENGTYPE_2 | CC_2 | HASC_2 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 946189 | 65 | POLYGON ((13.37502 -8.62500, 13.41668 -8.62500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 946190 | 59 | POLYGON ((13.41668 -8.62500, 13.45835 -8.62500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 946191 | 65 | POLYGON ((13.45835 -8.62500, 13.50002 -8.62500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 946192 | 58 | POLYGON ((13.50002 -8.62500, 13.54168 -8.62500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 946193 | 49 | POLYGON ((13.54168 -8.62500, 13.58335 -8.62500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 947044 | 62 | POLYGON ((13.37502 -8.66667, 13.41668 -8.66667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 947045 | 41 | POLYGON ((13.41668 -8.66667, 13.45835 -8.66667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 947046 | 58 | POLYGON ((13.45835 -8.66667, 13.50002 -8.66667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 947047 | 57 | POLYGON ((13.50002 -8.66667, 13.54168 -8.66667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 947871 | 59 | POLYGON ((13.37502 -8.70833, 13.41668 -8.70833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 947872 | 67 | POLYGON ((13.41668 -8.70833, 13.45835 -8.70833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 947873 | 47 | POLYGON ((13.45835 -8.70833, 13.50002 -8.70833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 947874 | 53 | POLYGON ((13.50002 -8.70833, 13.54168 -8.70833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 947875 | 54 | POLYGON ((13.54168 -8.70833, 13.58335 -8.70833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 948684 | 87 | POLYGON ((13.20835 -8.75000, 13.29168 -8.75000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 948685 | 88 | POLYGON ((13.29168 -8.75000, 13.33335 -8.75000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 948686 | 80 | POLYGON ((13.33335 -8.75000, 13.37502 -8.75000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 948687 | 70 | POLYGON ((13.37502 -8.75000, 13.41668 -8.75000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 948688 | 46 | POLYGON ((13.41668 -8.75000, 13.45835 -8.75000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 948689 | 20 | POLYGON ((13.45835 -8.75000, 13.50002 -8.75000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 948690 | 18 | POLYGON ((13.50002 -8.75000, 13.54168 -8.75000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 948691 | 28 | POLYGON ((13.54168 -8.75000, 13.58335 -8.75000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 948692 | 46 | POLYGON ((13.58335 -8.75000, 13.62502 -8.75000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 949496 | 97 | POLYGON ((13.20835 -8.79167, 13.25002 -8.79167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 949497 | 94 | POLYGON ((13.25002 -8.79167, 13.29168 -8.79167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 949498 | 84 | POLYGON ((13.29168 -8.79167, 13.33335 -8.79167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 949499 | 79 | POLYGON ((13.33335 -8.79167, 13.37502 -8.79167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 949500 | 67 | POLYGON ((13.37502 -8.79167, 13.41668 -8.79167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 949501 | 42 | POLYGON ((13.41668 -8.79167, 13.45835 -8.79167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 949502 | 29 | POLYGON ((13.45835 -8.79167, 13.50002 -8.79167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 949503 | 17 | POLYGON ((13.50002 -8.79167, 13.54168 -8.79167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 949504 | 20 | POLYGON ((13.54168 -8.79167, 13.58335 -8.79167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 949505 | 47 | POLYGON ((13.58335 -8.79167, 13.62502 -8.79167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 949506 | 38 | POLYGON ((13.62502 -8.79167, 13.66668 -8.79167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950300 | 72 | POLYGON ((13.12502 -8.83333, 13.16668 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950301 | 75 | POLYGON ((13.16668 -8.83333, 13.20835 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950302 | 92 | POLYGON ((13.20835 -8.83333, 13.25002 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950303 | 87 | POLYGON ((13.25002 -8.83333, 13.29168 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950304 | 92 | POLYGON ((13.29168 -8.83333, 13.33335 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950305 | 78 | POLYGON ((13.33335 -8.83333, 13.37502 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950306 | 57 | POLYGON ((13.37502 -8.83333, 13.41668 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950307 | 40 | POLYGON ((13.41668 -8.83333, 13.45835 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950308 | 38 | POLYGON ((13.45835 -8.83333, 13.50002 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950309 | 34 | POLYGON ((13.50002 -8.83333, 13.54168 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950310 | 45 | POLYGON ((13.54168 -8.83333, 13.58335 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950311 | 43 | POLYGON ((13.58335 -8.83333, 13.62502 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 950312 | 36 | POLYGON ((13.62502 -8.83333, 13.66668 -8.83333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951075 | 64 | POLYGON ((13.08335 -8.87500, 13.12502 -8.87500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951076 | 65 | POLYGON ((13.12502 -8.87500, 13.16668 -8.87500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951077 | 87 | POLYGON ((13.16668 -8.87500, 13.20835 -8.87500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951078 | 85 | POLYGON ((13.20835 -8.87500, 13.25002 -8.87500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951079 | 86 | POLYGON ((13.25002 -8.87500, 13.29168 -8.87500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951080 | 81 | POLYGON ((13.29168 -8.87500, 13.33335 -8.87500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951081 | 76 | POLYGON ((13.33335 -8.87500, 13.37502 -8.87500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951082 | 73 | POLYGON ((13.37502 -8.87500, 13.41668 -8.87500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951083 | 67 | POLYGON ((13.41668 -8.87500, 13.45835 -8.87500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951084 | 66 | POLYGON ((13.45835 -8.87500, 13.50002 -8.87500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951085 | 47 | POLYGON ((13.50002 -8.87500, 13.54168 -8.87500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951086 | 50 | POLYGON ((13.54168 -8.87500, 13.58335 -8.87500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951783 | 60 | POLYGON ((13.04168 -8.91667, 13.08335 -8.91667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951784 | 69 | POLYGON ((13.08335 -8.91667, 13.12502 -8.91667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951785 | 60 | POLYGON ((13.12502 -8.91667, 13.16668 -8.91667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951786 | 77 | POLYGON ((13.16668 -8.91667, 13.20835 -8.91667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951787 | 89 | POLYGON ((13.20835 -8.91667, 13.25002 -8.91667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951788 | 81 | POLYGON ((13.25002 -8.91667, 13.29168 -8.91667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951789 | 84 | POLYGON ((13.29168 -8.91667, 13.33335 -8.91667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951790 | 79 | POLYGON ((13.33335 -8.91667, 13.37502 -8.91667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951791 | 76 | POLYGON ((13.37502 -8.91667, 13.41668 -8.91667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951792 | 77 | POLYGON ((13.41668 -8.91667, 13.45835 -8.91667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951793 | 65 | POLYGON ((13.45835 -8.91667, 13.50002 -8.91667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 951794 | 58 | POLYGON ((13.50002 -8.91667, 13.54168 -8.91667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 952591 | 56 | POLYGON ((13.00002 -8.95833, 13.08335 -8.95833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 952592 | 49 | POLYGON ((13.08335 -8.95833, 13.12502 -8.95833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 952593 | 72 | POLYGON ((13.12502 -8.95833, 13.16668 -8.95833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 952594 | 81 | POLYGON ((13.16668 -8.95833, 13.20835 -8.95833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 952595 | 74 | POLYGON ((13.20835 -8.95833, 13.25002 -8.95833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 952596 | 75 | POLYGON ((13.25002 -8.95833, 13.29168 -8.95833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 952597 | 81 | POLYGON ((13.29168 -8.95833, 13.33335 -8.95833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 952598 | 62 | POLYGON ((13.33335 -8.95833, 13.37502 -8.95833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 952599 | 79 | POLYGON ((13.37502 -8.95833, 13.41668 -8.95833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 952600 | 85 | POLYGON ((13.41668 -8.95833, 13.45835 -8.95833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 952601 | 86 | POLYGON ((13.45835 -8.95833, 13.50002 -8.95833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 952602 | 62 | POLYGON ((13.50002 -8.95833, 13.54168 -8.95833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 953326 | 55 | POLYGON ((13.00002 -9.00000, 13.04168 -9.00000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 953327 | 53 | POLYGON ((13.04168 -9.00000, 13.08335 -9.00000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 953328 | 54 | POLYGON ((13.08335 -9.00000, 13.12502 -9.00000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 953329 | 65 | POLYGON ((13.12502 -9.00000, 13.16668 -9.00000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 953330 | 58 | POLYGON ((13.16668 -9.00000, 13.20835 -9.00000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 953331 | 78 | POLYGON ((13.20835 -9.00000, 13.25002 -9.00000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 953332 | 69 | POLYGON ((13.25002 -9.00000, 13.29168 -9.00000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 953333 | 59 | POLYGON ((13.29168 -9.00000, 13.33335 -9.00000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 953334 | 60 | POLYGON ((13.33335 -9.00000, 13.37502 -9.00000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 953335 | 77 | POLYGON ((13.37502 -9.00000, 13.41668 -9.00000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 953336 | 73 | POLYGON ((13.41668 -9.00000, 13.45835 -9.00000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 953337 | 67 | POLYGON ((13.45835 -9.00000, 13.50002 -9.00000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954091 | 49 | POLYGON ((12.95835 -9.04167, 13.04168 -9.04167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954092 | 52 | POLYGON ((13.04168 -9.04167, 13.12502 -9.04167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954093 | 53 | POLYGON ((13.12502 -9.04167, 13.16668 -9.04167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954094 | 54 | POLYGON ((13.16668 -9.04167, 13.20835 -9.04167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954095 | 58 | POLYGON ((13.20835 -9.04167, 13.25002 -9.04167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954096 | 59 | POLYGON ((13.25002 -9.04167, 13.29168 -9.04167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954097 | 56 | POLYGON ((13.29168 -9.04167, 13.33335 -9.04167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954098 | 50 | POLYGON ((13.33335 -9.04167, 13.37502 -9.04167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954099 | 44 | POLYGON ((13.37502 -9.04167, 13.41668 -9.04167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954100 | 61 | POLYGON ((13.41668 -9.04167, 13.45835 -9.04167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954101 | 51 | POLYGON ((13.45835 -9.04167, 13.50002 -9.04167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954799 | 53 | POLYGON ((13.08335 -9.08333, 13.12502 -9.08333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954800 | 52 | POLYGON ((13.12502 -9.08333, 13.16668 -9.08333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954801 | 53 | POLYGON ((13.16668 -9.08333, 13.20835 -9.08333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954802 | 55 | POLYGON ((13.20835 -9.08333, 13.25002 -9.08333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954803 | 52 | POLYGON ((13.25002 -9.08333, 13.29168 -9.08333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954804 | 48 | POLYGON ((13.29168 -9.08333, 13.33335 -9.08333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954805 | 40 | POLYGON ((13.33335 -9.08333, 13.37502 -9.08333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954806 | 39 | POLYGON ((13.37502 -9.08333, 13.41668 -9.08333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954807 | 46 | POLYGON ((13.41668 -9.08333, 13.45835 -9.08333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 954808 | 49 | POLYGON ((13.45835 -9.08333, 13.50002 -9.08333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 955509 | 48 | POLYGON ((13.00002 -9.12500, 13.04168 -9.12500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 955510 | 47 | POLYGON ((13.04168 -9.12500, 13.08335 -9.12500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 955511 | 50 | POLYGON ((13.08335 -9.12500, 13.12502 -9.12500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 955512 | 53 | POLYGON ((13.12502 -9.12500, 13.16668 -9.12500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 955513 | 51 | POLYGON ((13.16668 -9.12500, 13.25002 -9.12500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 955514 | 46 | POLYGON ((13.29168 -9.12500, 13.33335 -9.12500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 955515 | 39 | POLYGON ((13.33335 -9.12500, 13.37502 -9.12500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 955516 | 37 | POLYGON ((13.37502 -9.12500, 13.41668 -9.12500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 955517 | 45 | POLYGON ((13.41668 -9.12500, 13.45835 -9.12500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 955518 | 50 | POLYGON ((13.45835 -9.12500, 13.50002 -9.12500... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 956214 | 46 | POLYGON ((13.04168 -9.16667, 13.08335 -9.16667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 956215 | 47 | POLYGON ((13.08335 -9.16667, 13.12502 -9.16667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 956216 | 48 | POLYGON ((13.12502 -9.16667, 13.16668 -9.16667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 956217 | 47 | POLYGON ((13.16668 -9.16667, 13.29168 -9.16667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 956218 | 49 | POLYGON ((13.29168 -9.16667, 13.33335 -9.16667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 956219 | 54 | POLYGON ((13.33335 -9.16667, 13.37502 -9.16667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 956220 | 51 | POLYGON ((13.37502 -9.16667, 13.41668 -9.16667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 956222 | 47 | POLYGON ((13.45835 -9.16667, 13.50002 -9.16667... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 956916 | 45 | POLYGON ((13.16668 -9.20833, 13.25002 -9.20833... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 957570 | 43 | POLYGON ((13.08335 -9.25000, 13.12502 -9.25000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 957571 | 45 | POLYGON ((13.12502 -9.25000, 13.16668 -9.25000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 957572 | 44 | POLYGON ((13.20835 -9.25000, 13.25002 -9.25000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 958107 | 43 | POLYGON ((13.16668 -9.25000, 13.20835 -9.25000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 958324 | 55 | POLYGON ((13.12502 -9.29167, 13.16668 -9.29167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 958998 | 57 | POLYGON ((13.12502 -9.33333, 13.16668 -9.33333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 1235104 | -999999 | POLYGON ((-118.37500 53.58333, 123.16670 53.58... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
In [23]:
# drop last row of data
join = join[:-1]
len(join)
Out[23]:
141
In [24]:
join.tail(5)
Out[24]:
| ID | geometry | index_right | NAME_1 | GID_0 | COUNTRY | GID_1 | NL_NAME_1 | GID_2 | NAME_2 | VARNAME_2 | NL_NAME_2 | TYPE_2 | ENGTYPE_2 | CC_2 | HASC_2 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 957571 | 45 | POLYGON ((13.12502 -9.25000, 13.16668 -9.25000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 957572 | 44 | POLYGON ((13.20835 -9.25000, 13.25002 -9.25000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 958107 | 43 | POLYGON ((13.16668 -9.25000, 13.20835 -9.25000... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 958324 | 55 | POLYGON ((13.12502 -9.29167, 13.16668 -9.29167... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
| 958998 | 57 | POLYGON ((13.12502 -9.33333, 13.16668 -9.33333... | 0 | Luanda | AGO | Angola | AGO.11_1 | NA | AGO.11.1_1 | Cacuaco | NA | NA | Município | Municpality|City Council | 1108 | AO.LU.CC |
In [25]:
join.plot()
Out[25]:
<Axes: >
In [26]:
#plot join
fig, ax = plt.subplots(figsize=(10, 10))
ax.set_aspect('equal')
join.plot(ax=ax, column='ID', legend=True)
plt.title('IHME Sanitation Data for Luanda, Angola')
plt.show()
In [32]:
# make a folium map of the data with a colorbar
m = folium.Map(location=[-8.8383, 13.2344], zoom_start=11)
folium.Choropleth(
geo_data=join,
name='choropleth',
data=join,
columns=['ID', 'COUNTRY'],
key_on='feature.properties.ID',
fill_color='YlGn',
fill_opacity=0.7,
line_opacity=0.2,
legend_name='Sanitation Data'
).add_to(m)
folium.LayerControl().add_to(m)
m
--------------------------------------------------------------------------- TypeError Traceback (most recent call last) c:\Users\jtrum\world_bank\notebooks\ihme-data.ipynb Cell 17 line 4 <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=0'>1</a> # make a folium map of the data with a colorbar <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=1'>2</a> m = folium.Map(location=[-8.8383, 13.2344], zoom_start=11) ----> <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=3'>4</a> folium.Choropleth( <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=4'>5</a> geo_data=join, <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=5'>6</a> name='choropleth', <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=6'>7</a> data=join, <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=7'>8</a> columns=['ID', 'COUNTRY'], <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=8'>9</a> key_on='feature.properties.ID', <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=9'>10</a> fill_color='YlGn', <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=10'>11</a> fill_opacity=0.7, <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=11'>12</a> line_opacity=0.2, <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=12'>13</a> legend_name='Sanitation Data' <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=13'>14</a> ).add_to(m) <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=15'>16</a> folium.LayerControl().add_to(m) <a href='vscode-notebook-cell:/c%3A/Users/jtrum/world_bank/notebooks/ihme-data.ipynb#X23sZmlsZQ%3D%3D?line=17'>18</a> m File c:\Users\jtrum\miniconda3\envs\wash\lib\site-packages\folium\features.py:1487, in Choropleth.__init__(self, geo_data, data, columns, key_on, bins, fill_color, nan_fill_color, fill_opacity, nan_fill_opacity, line_color, line_weight, line_opacity, name, legend_name, overlay, control, show, topojson, smooth_factor, highlight, use_jenks, **kwargs) 1485 if color_data is not None and key_on is not None: 1486 real_values = np.array(list(color_data.values())) -> 1487 real_values = real_values[~np.isnan(real_values)] 1488 if use_jenks: 1489 from jenkspy import jenks_breaks TypeError: ufunc 'isnan' not supported for the input types, and the inputs could not be safely coerced to any supported types according to the casting rule ''safe''