{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Spatial join\n",
"\n",
"[Spatial join](http://wiki.gis.com/wiki/index.php/Spatial_Join) is\n",
"yet another classic GIS problem. Getting attributes from one layer and\n",
"transferring them into another layer based on their spatial relationship\n",
"is something you most likely need to do on a regular basis.\n",
"\n",
"In the previous section we learned how to perform **a Point in Polygon query**.\n",
"We can now use the same logic to conduct **a spatial join** between two layers based on their\n",
"spatial relationship. We could, for example, join the attributes of a polygon layer into a point layer where each point would get the\n",
"attributes of a polygon that ``contains`` the point.\n",
"\n",
"Luckily, [spatial join is already implemented in Geopandas](http://geopandas.org/mergingdata.html#spatial-joins), thus we do not need to create our own function for doing it. There are three possible types of\n",
"join that can be applied in spatial join that are determined with ``op`` -parameter in the ``gpd.sjoin()`` -function:\n",
"\n",
"- ``\"intersects\"``\n",
"- ``\"within\"``\n",
"- ``\"contains\"``\n",
"\n",
"Sounds familiar? Yep, all of those spatial relationships were discussed\n",
"in the [Point in Polygon lesson](point-in-polygon.ipynb), thus you should know how they work. \n",
"\n",
"Furthermore, pay attention to the different options for the type of join via the `how` parameter; \"left\", \"right\" and \"inner\". You can read more about these options in the [geopandas sjoin documentation](http://geopandas.org/mergingdata.html#sjoin-arguments) and pandas guide for [merge, join and concatenate](https://pandas.pydata.org/pandas-docs/stable/user_guide/merging.html)\n",
"\n",
"Let's perform a spatial join between these two layers:\n",
"- **Addresses:** the geocoded address-point (we created this Shapefile in the geocoding tutorial)\n",
"- **Population grid:** 250m x 250m grid polygon layer that contains population information from the Helsinki Region.\n",
" - The population grid a dataset is produced by the **Helsinki Region Environmental\n",
"Services Authority (HSY)** (see [this page](https://www.hsy.fi/fi/asiantuntijalle/avoindata/Sivut/AvoinData.aspx?dataID=7) to access data from different years).\n",
" - You can download the data from [from this link](https://www.hsy.fi/sites/AvoinData/AvoinData/SYT/Tietoyhteistyoyksikko/Shape%20(Esri)/V%C3%A4est%C3%B6tietoruudukko/Vaestotietoruudukko_2018_SHP.zip) in the [Helsinki Region Infroshare\n",
"(HRI) open data portal](https://hri.fi/en_gb/).\n",
"\n",
"\n",
"\n",
"- Here, we will access the data directly from the HSY wfs:\n",
"\n"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import geopandas as gpd\n",
"from pyproj import CRS\n",
"import requests\n",
"import geojson\n",
"\n",
"# Specify the url for web feature service\n",
"url = 'https://kartta.hsy.fi/geoserver/wfs'\n",
"\n",
"# Specify parameters (read data in json format). \n",
"# Available feature types in this particular data source: http://geo.stat.fi/geoserver/vaestoruutu/wfs?service=wfs&version=2.0.0&request=describeFeatureType\n",
"params = dict(service='WFS', \n",
" version='2.0.0', \n",
" request='GetFeature', \n",
" typeName='asuminen_ja_maankaytto:Vaestotietoruudukko_2018', \n",
" outputFormat='json')\n",
"\n",
"# Fetch data from WFS using requests\n",
"r = requests.get(url, params=params)\n",
"\n",
"# Create GeoDataFrame from geojson\n",
"pop = gpd.GeoDataFrame.from_features(geojson.loads(r.content))"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Check the result: "
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
\n",
"
geometry
\n",
"
index
\n",
"
asukkaita
\n",
"
asvaljyys
\n",
"
ika0_9
\n",
"
ika10_19
\n",
"
ika20_29
\n",
"
ika30_39
\n",
"
ika40_49
\n",
"
ika50_59
\n",
"
ika60_69
\n",
"
ika70_79
\n",
"
ika_yli80
\n",
"
\n",
" \n",
" \n",
"
\n",
"
0
\n",
"
MULTIPOLYGON Z (((25476499.999 6674248.999 0.0...
\n",
"
3342
\n",
"
108
\n",
"
45
\n",
"
11
\n",
"
23
\n",
"
6
\n",
"
7
\n",
"
26
\n",
"
17
\n",
"
8
\n",
"
6
\n",
"
4
\n",
"
\n",
"
\n",
"
1
\n",
"
MULTIPOLYGON Z (((25476749.997 6674498.998 0.0...
\n",
"
3503
\n",
"
273
\n",
"
35
\n",
"
35
\n",
"
24
\n",
"
52
\n",
"
62
\n",
"
40
\n",
"
26
\n",
"
25
\n",
"
9
\n",
"
0
\n",
"
\n",
"
\n",
"
2
\n",
"
MULTIPOLYGON Z (((25476999.994 6675749.004 0.0...
\n",
"
3660
\n",
"
239
\n",
"
34
\n",
"
46
\n",
"
24
\n",
"
24
\n",
"
45
\n",
"
33
\n",
"
30
\n",
"
25
\n",
"
10
\n",
"
2
\n",
"
\n",
"
\n",
"
3
\n",
"
MULTIPOLYGON Z (((25476999.994 6675499.004 0.0...
\n",
"
3661
\n",
"
202
\n",
"
30
\n",
"
52
\n",
"
37
\n",
"
13
\n",
"
36
\n",
"
43
\n",
"
11
\n",
"
4
\n",
"
3
\n",
"
3
\n",
"
\n",
"
\n",
"
4
\n",
"
MULTIPOLYGON Z (((25476999.994 6675249.005 0.0...
\n",
"
3662
\n",
"
261
\n",
"
30
\n",
"
64
\n",
"
32
\n",
"
36
\n",
"
64
\n",
"
34
\n",
"
20
\n",
"
6
\n",
"
3
\n",
"
2
\n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" geometry index asukkaita \\\n",
"0 MULTIPOLYGON Z (((25476499.999 6674248.999 0.0... 3342 108 \n",
"1 MULTIPOLYGON Z (((25476749.997 6674498.998 0.0... 3503 273 \n",
"2 MULTIPOLYGON Z (((25476999.994 6675749.004 0.0... 3660 239 \n",
"3 MULTIPOLYGON Z (((25476999.994 6675499.004 0.0... 3661 202 \n",
"4 MULTIPOLYGON Z (((25476999.994 6675249.005 0.0... 3662 261 \n",
"\n",
" asvaljyys ika0_9 ika10_19 ika20_29 ika30_39 ika40_49 ika50_59 \\\n",
"0 45 11 23 6 7 26 17 \n",
"1 35 35 24 52 62 40 26 \n",
"2 34 46 24 24 45 33 30 \n",
"3 30 52 37 13 36 43 11 \n",
"4 30 64 32 36 64 34 20 \n",
"\n",
" ika60_69 ika70_79 ika_yli80 \n",
"0 8 6 4 \n",
"1 25 9 0 \n",
"2 25 10 2 \n",
"3 4 3 3 \n",
"4 6 3 2 "
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pop.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Okey so we have multiple columns in the dataset but the most important\n",
"one here is the column `asukkaita` (\"population\" in Finnish) that\n",
"tells the amount of inhabitants living under that polygon.\n",
"\n",
"- Let's change the name of that column into `pop18` so that it is\n",
" more intuitive. As you might remember, we can easily rename (Geo)DataFrame column names using the ``rename()`` function where we pass a dictionary of new column names like this: ``columns={'oldname': 'newname'}``."
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Index(['geometry', 'index', 'pop18', 'asvaljyys', 'ika0_9', 'ika10_19',\n",
" 'ika20_29', 'ika30_39', 'ika40_49', 'ika50_59', 'ika60_69', 'ika70_79',\n",
" 'ika_yli80'],\n",
" dtype='object')"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Change the name of a column\n",
"pop = pop.rename(columns={'asukkaita': 'pop18'})\n",
"\n",
"# Check the column names\n",
"pop.columns"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Let's also get rid of all unnecessary columns by selecting only columns that we need i.e. ``pop18`` and ``geometry``"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"# Subset columns\n",
"pop = pop[[\"pop18\", \"geometry\"]]"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
\n",
"
pop18
\n",
"
geometry
\n",
"
\n",
" \n",
" \n",
"
\n",
"
0
\n",
"
108
\n",
"
MULTIPOLYGON Z (((25476499.999 6674248.999 0.0...
\n",
"
\n",
"
\n",
"
1
\n",
"
273
\n",
"
MULTIPOLYGON Z (((25476749.997 6674498.998 0.0...
\n",
"
\n",
"
\n",
"
2
\n",
"
239
\n",
"
MULTIPOLYGON Z (((25476999.994 6675749.004 0.0...
\n",
"
\n",
"
\n",
"
3
\n",
"
202
\n",
"
MULTIPOLYGON Z (((25476999.994 6675499.004 0.0...
\n",
"
\n",
"
\n",
"
4
\n",
"
261
\n",
"
MULTIPOLYGON Z (((25476999.994 6675249.005 0.0...
\n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" pop18 geometry\n",
"0 108 MULTIPOLYGON Z (((25476499.999 6674248.999 0.0...\n",
"1 273 MULTIPOLYGON Z (((25476749.997 6674498.998 0.0...\n",
"2 239 MULTIPOLYGON Z (((25476999.994 6675749.004 0.0...\n",
"3 202 MULTIPOLYGON Z (((25476999.994 6675499.004 0.0...\n",
"4 261 MULTIPOLYGON Z (((25476999.994 6675249.005 0.0..."
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pop.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Now we have cleaned the data and have only those columns that we need\n",
"for our analysis."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Join the layers\n",
"\n",
"Now we are ready to perform the spatial join between the two layers that\n",
"we have. The aim here is to get information about **how many people live\n",
"in a polygon that contains an individual address-point** . Thus, we want\n",
"to join attributes from the population layer we just modified into the\n",
"addresses point layer ``addresses.shp`` that we created trough gecoding in the previous section.\n",
"\n",
"- Read the addresses layer into memory:"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [],
"source": [
"# Addresses filpath\n",
"addr_fp = r\"data/addresses.shp\"\n",
"\n",
"# Read data\n",
"addresses = gpd.read_file(addr_fp)"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
\n",
"
address
\n",
"
id
\n",
"
addr
\n",
"
geometry
\n",
"
\n",
" \n",
" \n",
"
\n",
"
0
\n",
"
Ruoholahti, 14, Itämerenkatu, Ruoholahti, Läns...
\n",
"
1000
\n",
"
Itämerenkatu 14, 00101 Helsinki, Finland
\n",
"
POINT (24.91556 60.16320)
\n",
"
\n",
"
\n",
"
1
\n",
"
Kamppi, 1, Kampinkuja, Kamppi, Eteläinen suurp...
\n",
"
1001
\n",
"
Kampinkuja 1, 00100 Helsinki, Finland
\n",
"
POINT (24.93169 60.16902)
\n",
"
\n",
"
\n",
"
2
\n",
"
Kauppakeskus Citycenter, 8, Kaivokatu, Keskust...
\n",
"
1002
\n",
"
Kaivokatu 8, 00101 Helsinki, Finland
\n",
"
POINT (24.94179 60.16989)
\n",
"
\n",
"
\n",
"
3
\n",
"
Hermannin rantatie, Verkkosaari, Kalasatama, S...
\n",
"
1003
\n",
"
Hermannin rantatie 1, 00580 Helsinki, Finland
\n",
"
POINT (24.97783 60.18892)
\n",
"
\n",
"
\n",
"
4
\n",
"
Hesburger, 9, Tyynenmerenkatu, Jätkäsaari, Län...
\n",
"
1005
\n",
"
Tyynenmerenkatu 9, 00220 Helsinki, Finland
\n",
"
POINT (24.92160 60.15665)
\n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" address id \\\n",
"0 Ruoholahti, 14, Itämerenkatu, Ruoholahti, Läns... 1000 \n",
"1 Kamppi, 1, Kampinkuja, Kamppi, Eteläinen suurp... 1001 \n",
"2 Kauppakeskus Citycenter, 8, Kaivokatu, Keskust... 1002 \n",
"3 Hermannin rantatie, Verkkosaari, Kalasatama, S... 1003 \n",
"4 Hesburger, 9, Tyynenmerenkatu, Jätkäsaari, Län... 1005 \n",
"\n",
" addr geometry \n",
"0 Itämerenkatu 14, 00101 Helsinki, Finland POINT (24.91556 60.16320) \n",
"1 Kampinkuja 1, 00100 Helsinki, Finland POINT (24.93169 60.16902) \n",
"2 Kaivokatu 8, 00101 Helsinki, Finland POINT (24.94179 60.16989) \n",
"3 Hermannin rantatie 1, 00580 Helsinki, Finland POINT (24.97783 60.18892) \n",
"4 Tyynenmerenkatu 9, 00220 Helsinki, Finland POINT (24.92160 60.15665) "
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Check the head of the file\n",
"addresses.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"In order to do a spatial join, the layers need to be in the same projection\n",
"\n",
"- Check the crs of input layers:"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"\n",
"Name: WGS 84\n",
"Axis Info [ellipsoidal]:\n",
"- Lat[north]: Geodetic latitude (degree)\n",
"- Lon[east]: Geodetic longitude (degree)\n",
"Area of Use:\n",
"- name: World\n",
"- bounds: (-180.0, -90.0, 180.0, 90.0)\n",
"Datum: World Geodetic System 1984\n",
"- Ellipsoid: WGS 84\n",
"- Prime Meridian: Greenwich"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"addresses.crs"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [],
"source": [
"pop.crs"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"If the crs information is missing from the population grid, we can **define the coordinate reference system** as **ETRS GK-25 (EPSG:3879)** because we know what it is based on the [population grid metadata](https://hri.fi/data/dataset/vaestotietoruudukko). "
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [],
"source": [
"# Define crs\n",
"pop.crs = CRS.from_epsg(3879).to_wkt()"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"\n",
"Name: ETRS89 / GK25FIN\n",
"Axis Info [cartesian]:\n",
"- N[north]: Northing (metre)\n",
"- E[east]: Easting (metre)\n",
"Area of Use:\n",
"- name: Finland - 24.5°E to 25.5°E onshore nominal\n",
"- bounds: (24.5, 59.94, 25.5, 68.9)\n",
"Coordinate Operation:\n",
"- name: Finland Gauss-Kruger zone 25\n",
"- method: Transverse Mercator\n",
"Datum: European Terrestrial Reference System 1989\n",
"- Ellipsoid: GRS 1980\n",
"- Prime Meridian: Greenwich"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pop.crs"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"False"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Are the layers in the same projection?\n",
"addresses.crs == pop.crs"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Let's re-project addresses to the projection of the population layer:"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [],
"source": [
"addresses = addresses.to_crs(pop.crs)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"- Let's make sure that the coordinate reference system of the layers\n",
"are identical"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"PROJCRS[\"ETRS89 / GK25FIN\",BASEGEOGCRS[\"ETRS89\",DATUM[\"European Terrestrial Reference System 1989\",ELLIPSOID[\"GRS 1980\",6378137,298.257222101,LENGTHUNIT[\"metre\",1]]],PRIMEM[\"Greenwich\",0,ANGLEUNIT[\"degree\",0.0174532925199433]],ID[\"EPSG\",4258]],CONVERSION[\"Finland Gauss-Kruger zone 25\",METHOD[\"Transverse Mercator\",ID[\"EPSG\",9807]],PARAMETER[\"Latitude of natural origin\",0,ANGLEUNIT[\"degree\",0.0174532925199433],ID[\"EPSG\",8801]],PARAMETER[\"Longitude of natural origin\",25,ANGLEUNIT[\"degree\",0.0174532925199433],ID[\"EPSG\",8802]],PARAMETER[\"Scale factor at natural origin\",1,SCALEUNIT[\"unity\",1],ID[\"EPSG\",8805]],PARAMETER[\"False easting\",25500000,LENGTHUNIT[\"metre\",1],ID[\"EPSG\",8806]],PARAMETER[\"False northing\",0,LENGTHUNIT[\"metre\",1],ID[\"EPSG\",8807]]],CS[Cartesian,2],AXIS[\"northing (N)\",north,ORDER[1],LENGTHUNIT[\"metre\",1]],AXIS[\"easting (E)\",east,ORDER[2],LENGTHUNIT[\"metre\",1]],USAGE[SCOPE[\"unknown\"],AREA[\"Finland - 24.5°E to 25.5°E onshore nominal\"],BBOX[59.94,24.5,68.9,25.5]],ID[\"EPSG\",3879]]\n",
"PROJCRS[\"ETRS89 / GK25FIN\",BASEGEOGCRS[\"ETRS89\",DATUM[\"European Terrestrial Reference System 1989\",ELLIPSOID[\"GRS 1980\",6378137,298.257222101,LENGTHUNIT[\"metre\",1]]],PRIMEM[\"Greenwich\",0,ANGLEUNIT[\"degree\",0.0174532925199433]],ID[\"EPSG\",4258]],CONVERSION[\"Finland Gauss-Kruger zone 25\",METHOD[\"Transverse Mercator\",ID[\"EPSG\",9807]],PARAMETER[\"Latitude of natural origin\",0,ANGLEUNIT[\"degree\",0.0174532925199433],ID[\"EPSG\",8801]],PARAMETER[\"Longitude of natural origin\",25,ANGLEUNIT[\"degree\",0.0174532925199433],ID[\"EPSG\",8802]],PARAMETER[\"Scale factor at natural origin\",1,SCALEUNIT[\"unity\",1],ID[\"EPSG\",8805]],PARAMETER[\"False easting\",25500000,LENGTHUNIT[\"metre\",1],ID[\"EPSG\",8806]],PARAMETER[\"False northing\",0,LENGTHUNIT[\"metre\",1],ID[\"EPSG\",8807]]],CS[Cartesian,2],AXIS[\"northing (N)\",north,ORDER[1],LENGTHUNIT[\"metre\",1]],AXIS[\"easting (E)\",east,ORDER[2],LENGTHUNIT[\"metre\",1]],USAGE[SCOPE[\"unknown\"],AREA[\"Finland - 24.5°E to 25.5°E onshore nominal\"],BBOX[59.94,24.5,68.9,25.5]],ID[\"EPSG\",3879]]\n"
]
},
{
"data": {
"text/plain": [
"True"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Check the crs of address points\n",
"print(addresses.crs)\n",
"\n",
"# Check the crs of population layer\n",
"print(pop.crs)\n",
"\n",
"# Do they match now?\n",
"addresses.crs == pop.crs"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Now they should be identical. Thus, we can be sure that when doing spatial\n",
"queries between layers the locations match and we get the right results\n",
"e.g. from the spatial join that we are conducting here.\n",
"\n",
"- Let's now join the attributes from ``pop`` GeoDataFrame into\n",
" ``addresses`` GeoDataFrame by using ``gpd.sjoin()`` -function:"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [],
"source": [
"# Make a spatial join\n",
"join = gpd.sjoin(addresses, pop, how=\"inner\", op=\"within\")"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
\n",
"
address
\n",
"
id
\n",
"
addr
\n",
"
geometry
\n",
"
index_right
\n",
"
pop18
\n",
"
\n",
" \n",
" \n",
"
\n",
"
0
\n",
"
Ruoholahti, 14, Itämerenkatu, Ruoholahti, Läns...
\n",
"
1000
\n",
"
Itämerenkatu 14, 00101 Helsinki, Finland
\n",
"
POINT (25495311.608 6672258.695)
\n",
"
1514
\n",
"
515
\n",
"
\n",
"
\n",
"
1
\n",
"
Kamppi, 1, Kampinkuja, Kamppi, Eteläinen suurp...
\n",
"
1001
\n",
"
Kampinkuja 1, 00100 Helsinki, Finland
\n",
"
POINT (25496207.840 6672906.173)
\n",
"
1600
\n",
"
182
\n",
"
\n",
"
\n",
"
4
\n",
"
Hesburger, 9, Tyynenmerenkatu, Jätkäsaari, Län...
\n",
"
1005
\n",
"
Tyynenmerenkatu 9, 00220 Helsinki, Finland
\n",
"
POINT (25495645.995 6671528.068)
\n",
"
1550
\n",
"
1435
\n",
"
\n",
"
\n",
"
6
\n",
"
Itäväylä, Vartioharju, Vartiokylä, Helsinki, H...
\n",
"
1007
\n",
"
Itäväylä 3, 00950 Helsinki, Finland
\n",
"
POINT (25506221.445 6678859.295)
\n",
"
3007
\n",
"
155
\n",
"
\n",
"
\n",
"
7
\n",
"
Tapulikaupungintie, Tapulikaupunki, Suutarila,...
\n",
"
1008
\n",
"
Tapulikaupungintie 3, 00750 Helsinki, Finland
\n",
"
POINT (25501664.428 6685108.440)
\n",
"
2264
\n",
"
262
\n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" address id \\\n",
"0 Ruoholahti, 14, Itämerenkatu, Ruoholahti, Läns... 1000 \n",
"1 Kamppi, 1, Kampinkuja, Kamppi, Eteläinen suurp... 1001 \n",
"4 Hesburger, 9, Tyynenmerenkatu, Jätkäsaari, Län... 1005 \n",
"6 Itäväylä, Vartioharju, Vartiokylä, Helsinki, H... 1007 \n",
"7 Tapulikaupungintie, Tapulikaupunki, Suutarila,... 1008 \n",
"\n",
" addr \\\n",
"0 Itämerenkatu 14, 00101 Helsinki, Finland \n",
"1 Kampinkuja 1, 00100 Helsinki, Finland \n",
"4 Tyynenmerenkatu 9, 00220 Helsinki, Finland \n",
"6 Itäväylä 3, 00950 Helsinki, Finland \n",
"7 Tapulikaupungintie 3, 00750 Helsinki, Finland \n",
"\n",
" geometry index_right pop18 \n",
"0 POINT (25495311.608 6672258.695) 1514 515 \n",
"1 POINT (25496207.840 6672906.173) 1600 182 \n",
"4 POINT (25495645.995 6671528.068) 1550 1435 \n",
"6 POINT (25506221.445 6678859.295) 3007 155 \n",
"7 POINT (25501664.428 6685108.440) 2264 262 "
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"join.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Awesome! Now we have performed a successful spatial join where we got\n",
"two new columns into our ``join`` GeoDataFrame, i.e. ``index_right``\n",
"that tells the index of the matching polygon in the population grid and\n",
"``pop18`` which is the population in the cell where the address-point is\n",
"located.\n",
"\n",
"- Let's still check how many rows of data we have now:"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"27"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(join)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Did we lose some data here? \n",
"\n",
"- Check how many addresses we had originally:"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"34"
]
},
"execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(addresses)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"If we plot the layers on top of each other, we can observe that some of the points are located outside the populated grid squares (increase figure size if you can't see this properly!)"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
""
]
},
"execution_count": 19,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAlgAAAHqCAYAAADYjDA/AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAz9ElEQVR4nO3df7BdZ3nY++8jy3SQE66MrON4BKqhg43AUzvWGSDiYuy6nRCSC6EXqGVaCKY4tMQlyaS3tmdIM5d7zQ+TYqet4zEGQiYgIC4padIqyVAbmCvbyTn8MMa6QAPGSPEPCWylscjF9nnuH3vJbG8d7bN/vHv9OPv7mfHonLXXWvtd715bfvS+z3reyEwkSZJUzoamGyBJkrTeGGBJkiQVZoAlSZJUmAGWJElSYQZYkiRJhRlgSZIkFda5ACsiPhwRD0XE3SPu//qIuCcivhYRH591+yRJkqJrdbAi4gLgb4Dfzcxz1tj3ecCngH+QmQ9HxEJmPlRHOyVJ0vzq3AhWZn4e+H7/toj4exGxNyKWI+ILEfH86qW3Av8xMx+ujjW4kiRJM9e5AOsEbgKuyMydwK8BN1TbzwLOioj/JyLuiIhXNNZCSZI0NzY23YBpRcSPAbuA34+IY5v/TvXnRuB5wIXAs4AvRMQ5mflIzc2UJElzpPMBFr1RuEcy87xVXjsA3JGZjwHfjoiv0wu4/qLG9kmSpDnT+SnCzPxresHT6wCi59zq5f8MXFRtP43elOG3mminJEmaH50LsCJiD3A7cHZEHIiItwBvAN4SEV8Bvga8utr9T4DvRcQ9wK3Av87M7zXRbkmSND86V6ZBkiSp7To3giVJktR2BliSJEmFdeopwtNOOy3PPPPMppshSZIEwPLy8uHM3Dq4vVMB1plnnsnS0lLTzZAkSQIgIr6z2nanCCVJkgozwJIkSSrMAEuSJKkwAyxJkqTCDLAkSZIKM8CSJEkqzABLkiSpMAMsSZKkwgywJEmSCjPAkiRJKswAS5IkqTADLEmSpMIMsCRJkgozwJIkSSrMAEuSJKkwAyxJkqTCDLAkSZIKM8CSJEkqbGPTDZAkqWvOvPKPn/L7ve/52YZaorZyBEuSJKkwAyxJkqTCRgqwImJzRNwSEf9vROyPiJ9aZZ8LI+LLEfG1iPhc3/Z3RMTd1fZf7tv+GxFxsDrmyxHxyiJXJEmS1LBRc7CuB/Zm5msj4mnApv4XI2IzcAPwisy8LyIWqu3nAG8FXgT8ENgbEX+cmd+sDv1AZr6/wHVIkiS1xpojWBHxDOAC4EMAmfnDzHxkYLdLgU9n5n3VPg9V23cAd2Tm0cx8HPgc8JpCbZckSWqlUaYInwscAj4SEV+KiJsj4pSBfc4CTo2I2yJiOSLeWG2/G7ggIrZExCbglcCz+477pYi4KyI+HBGnTnsxkiRJbTDKFOFG4Hzgisy8MyKuB64E3jmwz07gYuDpwO0RcUdm7o+I9wJ/BvwN8BXg8eqY3wbeBWT1528Clw2+eURcDlwOsH379rEvUJKkWZu0bIPlHtavUUawDgAHMvPO6vdb6AVcg/vszcxHM/Mw8HngXIDM/FBmnp+ZFwDfB75ZbX8wM5/IzBXgg/TytI6TmTdl5mJmLm7dunXc65MkSardmgFWZj4AfDcizq42XQzcM7DbZ4CXRcTGairwxcB+gL6E9+3APwb2VL+f0Xf8a+hNJ0qSJHXeqE8RXgF8rHqC8FvAmyPibQCZeWM1FbgXuAtYAW7OzGMB03+KiC3AY8DbM/Phavv7IuI8elOE9wK/WOKCJEmSmhaZ2XQbRra4uJhLS0tNN0OSpIkN5l0NY05W+0XEcmYuDm63krskSVJhBliSJEmFjZqDJUlSK3W51MFgWwevpf/3Ll2XHMGSJEkqzgBLkiSpMAMsSZKkwszBkiR1WhO5SWuVWph0qRytH45gSZIkFWaAJUmSVJhThJIkrWLY9N0005L9x3a5xISGcwRLkiSpMAMsSZKkwgywJEmSCjMHS5K0rtVRCmGcfK22LX9jHthsOIIlSZJUmAGWJElSYQZYkiRJhUVmNt2GkS0uLubS0lLTzZAkddSwfKNxcrWG5VVNY1j+01q5Um3L7ZoXEbGcmYuD2x3BkiRJKswAS5IkqTDLNEiS5kapqb1ZlX6oo6TEWu/p9GIZjmBJkiQVZoAlSZJUmAGWJElSYeZgSZLm1qRlGqS1OIIlSZJUmAGWJElSYQZYkiRJhZmDJUnSlJpYOmeafYcd55I7ZTiCJUmSVJgBliRJUmFOEUqSxOym+aZRx3TdOEvluKzO6BzBkiRJKswAS5IkqTADLEmSpMLMwZIkaRXj5BdNmq9VMu9r1Hytcd7DnKvJOYIlSZJUmAGWJElSYZGZTbdhZIuLi7m0tNR0MyRJKmKaKcFS03XD2uCU4NoiYjkzFwe3O4IlSZJUmAGWJElSYQZYkiRJhVmmQZLUenXkCY2TDzWr3KQ6luux9EI9HMGSJEkqzABLkiSpMAMsSZKkwszBkiS1wizyjWZlrbaOulTNWvlPs8iPMueqHo5gSZIkFWaAJUmSVJhL5UiSGjGsXEBdpQTqmJacVRkJp/rawaVyJEmSamKAJUmSVJgBliRJUmHmYEmq3bDH1OtYEkXNmfSzH2aa+2Kc+22c8gqjXkup84xyLs2GOViSJEk1McCSJEkqzABLkiSpMJfKkVTcOHkj1vaZX+PUwWrCrNrnPT4fHMGSJEkqzABLkiSpMKcIJbWW04frz7BptlIlCUqVexinfaVKTrR92lSjcwRLkiSpMAMsSZKkwgywJEmSChtpqZyI2AzcDJwDJHBZZt4+sM+FwHXAycDhzHx5tf0dwFuBAD6YmddV258JfBI4E7gXeH1mPjysHS6VI3WTy31oltqemzROvtg0uWV+d5ox7VI51wN7M/P5wLnA/oGTbwZuAF6VmS8EXldtP4decPWi6rifi4jnVYddCXw2M58HfLb6XZIkqfPWDLAi4hnABcCHADLzh5n5yMBulwKfzsz7qn0eqrbvAO7IzKOZ+TjwOeA11WuvBj5a/fxR4OcnvwxJkqT2GKVMw3OBQ8BHIuJcYBl4R2Y+2rfPWcDJEXEb8OPA9Zn5u8DdwP8dEVuAHwCvBI7N8Z2emfcDZOb9EbGw2ptHxOXA5QDbt28f8/IkNWGcqYxhj8KPM+VhSYduGHU6b1afX6lyCm3gPd5uo0wRbgTOB347M38SeJTjp/M2AjuBnwV+GnhnRJyVmfuB9wJ/BuwFvgI8Pk4DM/OmzFzMzMWtW7eOc6gkSVIjRgmwDgAHMvPO6vdb6AVcg/vszcxHM/Mw8Hl6OVdk5ocy8/zMvAD4PvDN6pgHI+IMgOrPh5AkSVoH1gywMvMB4LsRcXa16WLgnoHdPgO8LCI2RsQm4MVUifDHpv4iYjvwj4E91TF/CLyp+vlN1TkkSZI6b9QyDefRK9PwNOBbwJuBfwKQmTdW+/zravsKcHNfOYYvAFuAx4BfzczPVtu3AJ8CtgP3Aa/LzO8Pa4dlGqT2GGdJj3HyXmaVVzJpbpemU2rZmlm95yyW3FnrvOO8h/dq+52oTMNIaxFm5peBwYNvHNjnWuDaVY592QnO+T16o2GSJEnripXcJUmSCjPAkiRJKmykKUJJGjQsr6qNeSNtbJOeqtSSMuOct9Rxk9ZzW+s92v690ok5giVJklSYAZYkSVJhI5VpaAvLNEjrj0vcrG9tW4rG+0ulnahMgyNYkiRJhRlgSZIkFWaAJUmSVJhlGiQ1ypwYrWac5ZXGYc6f6uIIliRJUmEGWJIkSYUZYEmSJBVmDpYkqRX686GmybmaVf6WNA5HsCRJkgozwJIkSSrMKUJJ0sw0UQbBKUG1gSNYkiRJhRlgSZIkFWaAJUmSVJg5WNIIXF5DUpf4d1bzHMGSJEkqzABLkiSpMKcIpRMY9qh3/2trDb2Ps+88GjaV4TSHNBm/K81zBEuSJKkwAyxJkqTCDLAkSZIKi8xsug0jW1xczKWlpaaboXVqWM7VYD6DeVXljNPvKquOvi+VR1fH8jfDvudr7duEtrdvXkTEcmYuDm53BEuSJKkwAyxJkqTCDLAkSZIKsw6WVBknZ8H8Bq0HddzH47zHpDlF4+RnDcuzmibPqw012/x7qV0cwZIkSSrMAEuSJKkwyzRIkmZm0vInXdP26TlLy8yOZRokSZJqYoAlSZJUmAGWJElSYeZgSVKHtKEcwDS6nGc1TB2fw1p917V7Yb0wB0uSJKkmBliSJEmFGWBJkiQV5lI5ktQy4+QpdT0nqw79fTJNf63X/DHNhiNYkiRJhRlgSZIkFeYUoeZKqeUiXHZCs1RqCZk2TB+2bVptmj5o+3d91L5u+3WsF45gSZIkFWaAJUmSVJgBliRJUmHmYEmVcfJVmlgWw7yJ4Tkmbc8vmlX7xsnXauKeKlUGYZzrnJfvyrDrbNt9MI8cwZIkSSrMAEuSJKkwAyxJkqTCzMHSujYs12CcPIQ25CzMY+2tNiwZU6qO0zTtG3bflmpTG+6pYdc5zne5VH5WHfdUG/pds+EIliRJUmEGWJIkSYU5Rah1rY5SC3VNH3Z5KmGc6Z1hSi0hMyt1tK/kfdBEuZFh+ttT1/0+6XTdNCkGpbTt/tdTOYIlSZJUmAGWJElSYQZYkiRJhZmDJY2gy/lPTVgrN6TtuUmjnneaUgLrVRvzjUrlYg7L1xr22behNIR/h9XPESxJkqTCDLAkSZIKi8xce6eIzcDNwDlAApdl5u0D+1wIXAecDBzOzJdX238F+OfVcV8F3pyZfxsRvwG8FThUneLqzPyvw9qxuLiYS0tLo12ZNEOzqsRcqgJ10+qaDhtnCm7S/pvV1FSXlfp8p5k6A4hcYcvRIxzetBkiir9nG0xTxkT1iIjlzFwc3D5qDtb1wN7MfG1EPA3YNHDyzcANwCsy876IWKi2bwP+FfCCzPxBRHwKuAT4nerQD2Tm+ye5IEnS/IpcYc+eq9l5cD/L23awe/c1ZDgpo/ZY826MiGcAFwAfAsjMH2bmIwO7XQp8OjPvq/Z5qO+1jcDTI2IjvcDsrwq0W5I0x7YcPcLOg/s5eeUJdh7cz5ajR5pukvQUo4T7z6U3jfeRiPhSRNwcEacM7HMWcGpE3BYRyxHxRoDMPAi8H7gPuB84kpl/2nfcL0XEXRHx4Yg4dfrLkSTNg8ObNrO8bQePbTiJ5W07etOEUouMMkW4ETgfuCIz74yI64ErgXcO7LMTuBh4OnB7RNxBLzB7NfAc4BHg9yPin2bm7wG/DbyLXm7Wu4DfBC4bfPOIuBy4HGD79u0TXKLUTfOSTzHN8jJ15Ky1fXmecdS1rFOJ91iznyPYvfuaVXOwhn1mbc9zNOdq/RhlBOsAcCAz76x+v4VewDW4z97MfDQzDwOfB84F/iHw7cw8lJmPAZ8GdgFk5oOZ+URmrgAfBF602ptn5k2ZuZiZi1u3bh33+iRJ61TGBg6fcurICe5SndYMsDLzAeC7EXF2teli4J6B3T4DvCwiNkbEJuDFwH56U4MviYhNERHVsfsBIuKMvuNfA9w91ZVIkiS1xKhPEV4BfKx6gvBbwJsj4m0AmXljZu6PiL3AXcAKcHNm3g0QEbcAXwQeB74E3FSd830RcR69KcJ7gV8sckWSJEkNG6kOVltYB0tt0fY8jnHMoqbXODWputyXTeQ0rWUWOTyzyjsbZxmirqnruzSL99R4TlQHy6IhkiRJhRlgSZIkFTZqDpakPuMs0dIldU1HlOqzWS1ZNKo2Tsl06d4cNsXa9fIYddybbbz/mtamaXtHsCRJkgozwJIkSSrMAEuSJKkwc7CkCTSd+1PXY/OTvk/X82fmRdP38aBZ3W9N5KWVKoHRhs+lS9rUX45gSZIkFWaAJUmSVJgBliRJUmHmYEkT6HLe1aT5UW3KbdBopsmF61LeXBtqH42z7M847WtbnlwbdKVPHMGSJEkqzABLkiSpMKcIpY4YZwpimEmnfpp4nLxL01RNGdZHg59Jm6dTpjFOmYZS36MmtGEqtA26ct2OYEmSJBVmgCVJklSYAZYkqXMiVzjt0Ychs+mmSKsyB0taB6Z5HL/UMiKzeHR6nNyacXQ5l2VWeUJtzz/qF7nCnj1Xs/Pgfpa37eA5JBnTjxdMWj5h3NeHfVfGyalTuzmCJUnqlC1Hj7Dz4H5OXnmCnQf3s+XokaabJB3HAEuS1CmHN21medsOHttwEsvbdnB40+ammyQdxylCqUZ1TU2VmvZr2jjTMNP0ZdsrQ9fxGU4zzVyHwfY9h2TL0SO94Cpi6L51mNV3u433o0ZjgCVJ6pyMDRw+5dSmmyGdkFOEkiRJhRlgSZIkFeYUoTRjTeT3lFo6p+lcrlnlBbU9r6Vt+U9NaGP5gll8r8Z5Td3iCJYkSVJhBliSJEmFGWBJkiQVZg6WNGPj5DF1Of+i7W2fNK+pjfk9/dre75Pq8nJGg7rcdk3OESxJkqTCDLAkSZIKc4pQqtGspgrGeSS8icfHm1iGpVSfzKoN86JUXw+bMlxP04laPxzBkiRJKswAS5IkqTADLEmSpMIiM5tuw8gWFxdzaWmp6WaoQ5pYXmOcHJNh+Sml2tfG0hDT5CZFrrDl6BEOb9rMve/9uZHfo9SyP8P6qw05V7P4PGd9Xf2fKREjHdOlPKu6lnhqw3JC8ygiljNzcXC7Se6SOiNyhT17rmbnwf0sb9sB734lbHAgvssGP9Pdu68hw89U3eddLKkzthw9ws6D+zl55Ql2HtwPhw413SRNafAz3XL0SNNNkoowwJLUGYc3bWZ52w4e23BSbwRrYaHpJmlKg5/p4U2bm26SVIQ5WJors8hxGvYeJbU9h2LSvh2nhtGZV/7xyDlY47znOJrOwZqmrtSk99A4eXyT9MG0OVhtrIPVdD5eG/pgXpiDJWldyNjA4VNObboZKsjPVOuRU4SSJEmFOYKlzhtnampehs3rmAqdxrDpkyam2Wb1/qVKQ/RreuppNXWVISh93HrWxmnTeeMIliRJUmEGWJIkSYUZYEmSJBVmDpbWlSaWhZlVzk4bzjPMOHlUg+0Z9RH7tfq2jflI/WbRvmnKNLTNNPdpHeUpSr2/5pMjWJIkSYUZYEmSpha5wmmPPgwli1evrMCDD5Y9p1QTpwjVCXUMx0/6HmtN2YxTEmBYG+qoPD/sWsZ5/2n2ndepl1l8vnU9mt+/YPPJ/+tL4dZbR1qEe+h3ZWUFLroI9u2DXbtGPudx55lT9kHzHMGSJE2lf8Fm9u0rswj3oUO9cz3+eLlzSjUywJIkTaV/wWZ27SqzCPfCQu9cGzeWO6dUI6cIJUnTiWD37mvYcvQIS7/1hpEXbF7rnNx6a2/kamGhzDmlGhlgqRMmXXJkVnkIs1gCZVaaaN80y3SUWMYmcoUtR49weNPmRv/HPM51z+JzGqdsybRLqzy5YPNAf0+VV7hhA5x++mTHzjmXymmeAZakdaU/4Xp52w52776GDLMhJNXLv3UkrSv9Cdc7D+5ny9EjTTdJ0hwywJK0rvQnXC9v29GbJpSkmkV2qIDb4uJiLi0tNd0M1aBUPahpalI1oeklbprOGVqrDbPKwSrV703cQ6U+s7rOU6reXB3a8HfCMKVyDc3Pmk5ELGfm4uB2c7AkrTtPJlxL65S5hu3npyFJUseYa9h+jmCpFeoaih+29Muslmwp+Sj8JMa5jmmmfuooXVHqM2rjlMioU6Pj9MGsptPHeZ+ulQkZdtysltOaxLFcw2MjWOYato8BliRJs7SyUr5gal9x16brvWl1ThFKkjQjkdWi1c96Flx4YS/YKuRExV3VDgZYkiTNyJajR1y0ek6NNEUYEZuBm4FzgAQuy8zbB/a5ELgOOBk4nJkvr7b/CvDPq+O+Crw5M/82Ip4JfBI4E7gXeH1mPjzl9ahDSuWOjHrOkma1dM8s+mQa41xn20oUNJHvNk2uzaiffRvzFU903Cx1pW8Pb9rMHWc8v5crdcbzueTf/UWxEac2lFXRiY2ag3U9sDczXxsRTwM29b9YBWA3AK/IzPsiYqHavg34V8ALMvMHEfEp4BLgd4Argc9m5nsi4srq939T4JokSWoHc6Xm1ppThBHxDOAC4EMAmfnDzHxkYLdLgU9n5n3VPg/1vbYReHpEbKQXmP1Vtf3VwEernz8K/PxklyBJUnuZKzWfRsnBei5wCPhIRHwpIm6OiFMG9jkLODUibouI5Yh4I0BmHgTeD9wH3A8cycw/rY45PTPvr/a7H1gocD2SJEmNG2WKcCNwPnBFZt4ZEdfTm85758A+O4GLgacDt0fEHfQCs1cDzwEeAX4/Iv5pZv7eqA2MiMuBywG2b98+6mHSqkrljoyTK9Xl3Icutb2uHLE21tDqN4v2dS2frQ3fwVJ5msOOLfW5NPH5zoNRRrAOAAcy887q91voBVyD++zNzEcz8zDweeBc4B8C387MQ5n5GPBpYFd1zIMRcQZA9edDrCIzb8rMxcxc3Lp16zjXJklA71H50x59GDq09qqkblszwMrMB4DvRsTZ1aaLgXsGdvsM8LKI2BgRm4AXA/vpTQ2+JCI2RURUx+6vjvlD4E3Vz2+qziFJRR1bs+32G36BT+y5qleXaE4ZaEr1GfUpwiuAj1VPEH4LeHNEvA0gM2/MzP0RsRe4C1gBbs7MuwEi4hbgi8DjwJeAm6pzvgf4VES8hV4g9rpC1zS3ujzMO6vHjet4nLwN0xF1WOs6myglMIrV1mxbzwtBn6jvp1kcuOQ9Xsd3slS5k1JlN6aZ9hvWnnHes63fz/VspAArM78MLA5svnFgn2uBa1c59t8C/3aV7d+jN6IlSTPjmm098xZoSk1zLUJJ65t1iAADTaluBliS1r0n6xDNMwNNqVYGWOvINDlXk5YdmOY9S+VdNb2EzDTH1ZEL0bUcsUnvr2mWIZqVWS2pNKlZBZrDrnOcvz9K5QmV+rulVHmFus4zaX5bl/J1u8TFniVJkgozwJIkSSosskP1UBYXF3NpaanpZnTGpI8JD6pj+LjtVbanKYFRakp1VmbR97Oajqvr851FG9o+NTtonM+z1Ocy6d9Zs0qPmEbTZRFK9Ukb/85qm4hYzszBSguOYElqLwtjqku8X9XPJHdJrbRaYUyprQbvV979StjgGMY889OX1EqrFcaU2mrwfuXQoaabpIY5gqXj1DXnXkfe1Ti5U23IGxq1DW3MOSmex5QJd30Q9u3j5F27WPqtN6y+38pK739mCwsT13YaJ19mVmUkTvQe4ypVMmHU9yipDW2Y1GAh10v+3V/UVmsscoUtR4/0viMTvOc0pSra9jm0iQGWpHaKgFtvHR48razARRfBvn2wa1dv/zmYljn2P1QLhrZIQ4Vc+6cmueuDc/Md6AI/BUnttWEDnH76if9ndehQL7h6/PHen3MwLXPsf6i33/ALfGLPVUSuNN0kVZ4s5Fpj0Ns/NTkv34GuMMCS1F0LC72Rq40be38uLDTdopkzN039jk1NPrbhpLn5DnSFdbA6pg3LHZSqkdL2Wit19PWkuTZN5GCtVZdo0ly4aZcROdF02azy7Zq+V8/8N3/EJ/Zc9WSuz0u+c9dTrnsWNb2mqQPXNm2rSVWiPaNMGXe5Tl3bnagOljlYkjpt7hZyHsj1udccrLk3d9+BjjDAkqSO8X+oUvsZYGlspYaB2zacPM6wedPTm+M8fj+OUo/Jl5pSKnVd0x57ovO07R4e16RL03R5yrDUdF1dZTcm1aXPZL0yyV2SJKkwAyxJwnXkJJXlFKGkubfauocZ/vtT0uQMsDqu1OPu69U4uSLj5KBM2n915WKUeiR70ntqmvtrVvf0sNcXr/i942pLnSiJvA05d6O+NmjSHLsmcohKmnQJqjbk/DVhPX32TfKfaJLmXn+xxuVtO3r1hCRpCo5gSVJD68hJWr8MsCQJa0tJKssAq+VmVW+ma3VsRs2HWitfYNK8qmlq58yib9c6Zx15E3XUQxvnOsepDbael3gaZtLljbp+ncNMc/+N+p4lc7uGKVXjy7yrMszBkiRJKswAS5IkqTCnCFtumqVLZlFmYFATU5iDr81iCZRxrNXvszpvKV2b/uk36ZTINH1ZR3+V+qxndW92WRvu91JlENpwLToxR7AkSZIKM8CSJEkqzABLkqTCXNtS5mDNiVKPG6913kmPHecR+zraM46S/VXqkfE6SijMSl35R6WPa0qpR/PnRR0lagbXtnwO2fjalnUsf1NH3m+XOIIlSVJBW44eOW5tS80fAyxJkgpybUuBU4SdV2pIdtIh41lN50xqmvZMOnUwTdubeOS/bUP1bZ/GmuZ7NGlfTzPt1/b+nIXWTXmtsbZlm0t9RK64JmchBliSJBXWxbUtB3PHdu++pvHcsS6z5yRJkrljhRlgSZIkc8cKc4qwYyZdEb1knlAdS9PMqszAeslPKZlr1q+J/KxZlRmYVV7hpDlZbct9W0vX2jvMqNdS8rOf9H2meY8iy3K9+5UsvuPj5mAVYIAlSZJ6NnQvd6ytnCKUJEkqzABLkiSpMKcIazKrfKg6tCFvadRlHqZZimZSJfunVO2tOpYIqsM41znNvqVyG4edd5x7sa59u6yJa+lyTt0w6+m+aBNHsCRJkgozwJIkSSrMKcIGNLF0SduHgEtOBY1z3nnUpT4Z57H5tt/jaxnW/jqmprp0X6ylDdfShjaMappp5S5dZ90cwZIkSSrMAEuSJKkwAyxJaoHIFU579GHIbLopkgowB2sKRZYlaIkmHu2etB/asNRL2/N92niPTWKtcgpt/xxGtrLCt+94P+zbB7t28ZyX/BoZo/37d930QUNKlTTpUgkd81jr4QiWJDXt0KFecPX447BvH1uOHmm6RZKmZIAlSU1bWIBdu2DjRti1q7fQrqROM8CSpKZFwK23woEDcNttvd8ldZo5WGOYJtdhWL2eOua4Z7W0Sl35H6O+Z119O2nO2jRLtKgd/Tez7+uGDXD66bM59zrQhtzLtim1hJJmwxEsSZKkwgywJEmdYkkLdUFkh27QxcXFXFpaauz921auoI2aGMZv2wr300wRlipd0fSUdBNKLelRKhVg3PcZdRq8run+tt0nx9oXucKePVez8+B+lrftYPfua0YuabGaaT6zSc+j9SUiljNzcXC7I1iSpM7YcvQIOw/u5+SVJ9h5cL8lLdRaBliSpM44vGkzy9t28NiGk1jetsOSFmotnyKUJHVHBLt3X8OWo0d6wZUlLdRS5mCNodSSCtO8T9vn+duWDzWNYdfStvIAdd2bw3T5vu1X8rOdxXJQs9L2z2hWZXJKaXv/aXbMwZIkSaqJAZYkSVJhI+VgRcRm4GbgHCCByzLz9oF9LgSuA04GDmfmyyPibOCTfbs9F/j1zLwuIn4DeCtwqHrt6sz8r5NeSNMcHu5pez+Umvab1dTPsKkMq77Xo9Rj+4Ovj3PeuqakT9imlZXeAtQLC1PnOE3a9iZWYRi0Xqa91YxRk9yvB/Zm5msj4mnApv4XqwDsBuAVmXlfRCwAZObXgfOqfU4CDgJ/0HfoBzLz/VNdgSSpnJUVuOgi2LevtwD1rbf2lvEpJHLFBHXNhTW/NRHxDOAC4EMAmfnDzHxkYLdLgU9n5n3VPg+tcqqLgb/MzO9M1WJJ0sjGrnp+6FAvuHr88d6fhw6tfcwYbdmz52puv+EX+MSeq4hcKXZuqW1G+WfJc+lN430kIr4UETdHxCkD+5wFnBoRt0XEckS8cZXzXALsGdj2SxFxV0R8OCJOHb/5kqQTmSigWVjojVxt3Nj7c2GhWHssEqp5MsoU4UbgfOCKzLwzIq4HrgTeObDPTnqjVE8Hbo+IOzLzGwDVtOKrgKv6jvlt4F30crreBfwmcNngm0fE5cDlANu3bx/r4qRBw/ImSuW9mCtlfkpbrBbQHD5ljX/LRsCtt7L4jo/3pvGuOj41dtLP91iR0GPL3IxTJLSOvLRSyy1JMFqAdQA4kJl3Vr/fQi/AGtzncGY+CjwaEZ8HzgW+Ub3+M8AXM/PBYwf0/xwRHwT+aLU3z8ybgJugVwdrhPZKkpgioNmwYe1AbBIWCdUcWTPAyswHIuK7EXF2lbR+MXDPwG6fAf5DRGwEnga8GPhA3+u7GZgejIgzMvP+6tfXAHdPeA2SpNW0MKDJmFHwJrXMqE8RXgF8rJrq+xbw5oh4G0Bm3piZ+yNiL3AXsALcnJl3A0TEJuAfAb84cM73RcR59KYI713ldUnSlAxopGaMFGBl5peBwTLwNw7scy1w7SrHHgW2rLL9n43cygY1sfSL8/ztM5ibMeln1MQ9tFY9rVJtKnWe9bTcUr9x+r3Ly7mUWtJmnH3X6tu2LXul+WAld0mSpMIMsCRJkgobNQdrbsxq+mTSIeq6pkiaXkKm7aa5rib6ZJx7qtSU3DjnGbZvl+6hca6z1Hmb+D5Os8xPHdZ6zy7dU1o/HMGSJEkqzABLkiSpMAMsSZKkwiJHXQC0BRYXF3NpaanpZoxk0hyY1V6fdXvqsp7yIErlG5V4/7VMkyfURHtn8f51qSM/qq4yCOtVqb8L7UsdExHLmTlYysoRLEnqosgVTnv0YejQP5KleeJThJLUMZEr7Nlz9ZNrDO7efQ0Z/ntZahO/kZLUMVuOHmHnwf2cvPIEOw/uZ8vRI003SdIAR7BmpG11Y5pYHqKJXLNx1FVPaJwlPdqmVH7WOHWd2t4n/ab5Hk2zdM7hTZtZ3rbjyRGsw5s2r3qeNuReNmFecv7UbgZYktQ1EezefQ1bjh7pBVcRTbdI0gADLEnqoIwNHD7l1KabIekEDLDmRBOPds9qemKaqZVS71nKNOU8Jn2PSZemmVUfdHlapq6p93Hu8XmZFpyX61R3meQuSZJUmAGWJElSYQZYkiRJhZmDVZNJH3dfK89g1Eeyx8kVmSYnpolcpabVVWZgnMfvh+1bx9I4KmsWyy2px/7UrDiCJUmSVJgBliR1ycoKPPigaxBKLRfZoS/p4uJiLi0tNd2MiUxaNbwNj31POoW51tD7ONMeo+5b11TiONMKTU9v1jU9rOMVXy1gZYU7zjz3KWsQfvu9/9vI79mlz7eJciyDSvVXl1cr0NoiYjkzFwe3O4IlSW202kjVoUOuQSh1hAGWJLXNygpcdBE861lw4YVw//29QGthgeVtO3hsw0nHrUEoqV18ilCSGhS5wmmPPgwPPACnn95bV/DQIdi3Dx5/HL7wBXj2s+GlL4Vbb3UNQqkjDLBaaFi+UalV4qfJWWgip6gNeVeTvn+pfLdSbWp7/sc8lSSIXGHPx6/iRQe+xsp/hD9/1gvZfem7SYJPnPF8Fg/cw4ZcYcMTT/QCrkOHjsu5GjROiY5Jy7x02bC/C9fTdap5ThFKUkO2HD3CzoP72UDvL+PFY3lVEezefQ0v+Ze/w58/64WwcSPs2gULC003WdKIDLAkqSGHN21medsOVoAVYGnbC57Mq8rYwOEfeya7L303HDgAt93mlKDUIU4RSlJTIth96bs57dGHSYLDp5x6XBCVsaGXmyWpU6yDVZNx8qqG5UVMmiMwTT2eUjlOs8pFaltO2DBN54tB+/NMSuXEtK320DSffam/E4rX5WqpUrmqs2pDl/tWx7MOliRJUk0MsCSpBk+WY+jQrIGkyTlF2AJ1DCWPU0pgPU9j1THdOav3HOf9uzw9Mau2z+K8o362kSvs2XP1U5a4yZjNv28nvTfbfl9Mo4kpw3npWzlFKEmNOVaOwSVupPlhgCVJhZxoGvBYOQaXuJHmh2UaJKmAodOAVeFQl7iR5oc5WC1Qx+PkbS+DUFfOVakld8bJWZt030E+Yl+PScuUnPbow9x+wy9w8soTPLbhJH7qX/5Or65Vzbr82ddhVveX/T6/zMGSpBlyGlBSP6cIJakEpwEl9THAkqRCMjY0Mi0oqX0MsFpgnJyPSef5zQ/oKZV/Mc55Jt3Xz+x4s1rGqY73rKvt3kPDzaqWmjTIHCxJmhGrt0vzyxEsSZqBwbINvPuVsMF/00rzwgCrhbo0rD9OWYFpSkOUmhptYoh/WJmGYe2ro3xH10zz+Y3zOZR4z8Hq7Rw6BKefPtG5xjHpdWpt9p/G4T+nJGkG+ss23PUTz4OtW5tukqQaGWBJ0ixEcOkl/xd3/cTz+Pv3fwMuughWVppulaSaGGBJ0ow88wf/k7//wDc5OVdg377eNKGkuWAOVseUyiEaJ5egidIQw3KT2p4HMavH+jWdSe+hce7Fwc966bfeAHd9sBdc7doFCwvjNHmi9o36mqTZMsCSpFmJgFtv7Y1cLSxY3V2aIwZYkjRLGzbU8vSgpHYxB0uSJKmwyA5VGF5cXMylpaWmm9GoOnKwxqnV1OUcj1nVxFqv/dV2pWpkaX2zNphKi4jlzFwc3O4IliRJUmEGWJIkSYU5RdhxbVvdfZrlcIadp9Q02yz6yymGdhjns/Uzk1SKU4SSJEk1McCSJEkqzABLkiSpMAuNdlx/Lkkbyg60OVcKyuWIqdt8VH869p+0NkewJEmSCjPAkiRJKswpQh1nreH+UtMBk07XzWp6winBbnOaSlKbOIIlSZJUmAGWJElSYQZYkiRJhY20VE5EbAZuBs4BErgsM28f2OdC4DrgZOBwZr48Is4GPtm323OBX8/M6yLimdVrZwL3Aq/PzIeHtcOlcsYzaU7RsNIL4x47Cz4iLklqi2mXyrke2JuZzwfOBfYPnHwzcAPwqsx8IfA6gMz8emael5nnATuBo8AfVIddCXw2M58HfLb6XZIkqfPWDLAi4hnABcCHADLzh5n5yMBulwKfzsz7qn0eWuVUFwN/mZnfqX5/NfDR6uePAj8/buMlSZLaaJQRrOcCh4CPRMSXIuLmiDhlYJ+zgFMj4raIWI6IN65ynkuAPX2/n56Z9wNUfy5M0H5JkqTWGaUO1kbgfOCKzLwzIq6nN533zoF9dtIbpXo6cHtE3JGZ3wCIiKcBrwKuGreBEXE5cDnA9u3bxz1cLVIqd8qcK0lS240ygnUAOJCZd1a/30Iv4BrcZ29mPpqZh4HP08vVOuZngC9m5oN92x6MiDMAqj9Xm1YkM2/KzMXMXNy6desIzZUkSWrWmgFWZj4AfLd6IhB6o1T3DOz2GeBlEbExIjYBL+apifC7eer0IMAfAm+qfn5TdQ5JkqTOG3WpnCuAj1VTfd8C3hwRbwPIzBszc39E7AXuAlaAmzPzboAq4PpHwC8OnPM9wKci4i3AfVRPHqoew6bZZrVkjFN7kqR5MVKAlZlfBgZrPNw4sM+1wLWrHHsU2LLK9u/RGw2TJElaV6zkLkmSVJgBliRJUmEjLZXTFi6VMzuzyLsy50qStN5Nu1SOJEmSRmSAJUmSVJgBliRJUmGj1sHSOjdpXSzzrCRJOp4jWJIkSYUZYEmSJBXmFKHWNM40YP90otOHkqR55QiWJElSYQZYkiRJhRlgSZIkFWYOlooy70qSJEewJEmSijPAkiRJKswpQk1lWJX3QU4fSpLmhSNYkiRJhRlgSZIkFWaAJUmSVJg5WJqKeVWSJB3PESxJkqTCDLAkSZIKM8CSJEkqzABLkiSpMAMsSZKkwgywJEmSCjPAkiRJKswAS5IkqTADLEmSpMIMsCRJkgozwJIkSSrMAEuSJKkwAyxJkqTCDLAkSZIKM8CSJEkqzABLkiSpMAMsSZKkwgywJEmSCjPAkiRJKiwys+k2jCwiDgHfqX49DTjcYHO6wD4azv5Zm300nP2zNvtoOPtnbW3vo7+bmVsHN3YqwOoXEUuZudh0O9rMPhrO/lmbfTSc/bM2+2g4+2dtXe0jpwglSZIKM8CSJEkqrMsB1k1NN6AD7KPh7J+12UfD2T9rs4+Gs3/W1sk+6mwOliRJUlt1eQRLkiSplRoJsCLi2RFxa0Tsj4ivRcQ7Vtnnwog4EhFfrv779YHXT4qIL0XEH/Vt+2Tf/vdGxJer7WdGxA/6Xrtx5hc5pRn20XkRcUe1/1JEvKjvtasi4n9ExNcj4qdne4XTqbt/vIee0kfnRsTtEfHViPgvEfGMvtc6cw9B/X3Utfto2v6p/h7+6rHvU9/2Z0bEn0XEN6s/T+17ba7uoXH7yHvoye2vq863EhGLA+drxz2UmbX/B5wBnF/9/OPAN4AXDOxzIfBHQ87xq8DHT7QP8JvAr1c/nwnc3cS1tq2PgD8Ffqb6+ZXAbdXPLwC+Avwd4DnAXwInNd0PLeof76EfbfsL4OXVz5cB7+riPdRQH3XqPpq2f4B7gdNW2f4+4Mrq5yuB987rPTRBH3kP9bbvAM4GbgMW+7a35h5qZAQrM+/PzC9WP/9PYD+wbdTjI+JZwM8CN5/g9QBeD+yZvrXNmGEfJXBsxOF/Af6q+vnVwCcy8//LzG8D/wN4ES3VQP90zgz76Gzg89XPfwb879XPnbqHoJE+6pRp+2eIVwMfrX7+KPDzfdvn6h4a4kR91Cmz6p/M3J+ZX1/lpdbcQ43nYEXEmcBPAneu8vJPRcRXIuK/RcQL+7ZfB/wfwMoJTvsy4MHM/GbftudUw/ifi4iXFWh6bQr30S8D10bEd4H3A1dV27cB3+3b7wBl/pKYuZr6B7yHjrkbeFX18+uAZ1c/d/Yegtr6CDp6H03YPwn8aUQsR8TlfdtPz8z7ofc/YGCh2j6P99C4fQTeQ8O05h5qNMCKiB8D/hPwy5n51wMvf5Fe+flzgX8P/OfqmJ8DHsrM5SGn3s1TR6/uB7Zn5k9SDedHX95Im82gj/4F8CuZ+WzgV4APHXurVfZt/SOmNfaP99CPXAa8PSKW6Q35//DYW62yb+vvIai1jzp5H03SP5WXZub5wM/Q648L1nqrVbat23uoMm4feQ+t8VarbGvmHmpiXjJ786QnA38C/OqI+99Lbz2id9OLSO8FHgCOAr/Xt99G4EHgWUPOdRt9c7Zt/W8WfQQc4UflOQL46+rnq4Cr+s71J8BPNd0Hbekf76Gnfs/69j8L+POu3kN191EX76NJ+2eV7b8B/Fr189eBM6qfzwC+Po/30CR95D3U658TXX+b7qGmOjuA3wWuG7LPT/T9j+5FwH3Hfu/b50IGEuOAVwCfG9i2lSrJDXgucBB4ZtM3XRN9RG/++8Lq54uB5ernF/LUxMBv0eLk0gb6x3voR78vVH9uqM5/WRfvoYb6qFP30TT9A5wC/Hi1/RRgH/CK6vdreWoC9/vm8R6asI+8h5567G08NcBqzT20kWa8FPhnwFejKqUAXA1sB8jMG4HXAv8iIh4HfgBcklXvreESjk9uvwD4P6tzPQG8LTO/P/VVzNas+uitwPURsRH4W+Dy6nxfi4hPAfcAjwNvz8wnyl5SUbX2D95D/XZHxNurnz8NfKQ6X9fuIai5j+jefTRx/0TE6cAf9J45YiPw8czcW53jPcCnIuIt9P5n+rrqfHN1D03SR3gP7QWIiNfQm07cCvxxRHw5M3+6TfeQldwlSZIKa/wpQkmSpPXGAEuSJKkwAyxJkqTCDLAkSZIKM8CSJElzJyI+HBEPRcTdI+z7gfjRYtTfiIhH1jzGpwglSdK8qarC/w3wu5l5zhjHXQH8ZGZeNmw/R7AkSdLcyczPA0+pIRYRfy8i9lZrH34hIp6/yqGDy/GtqqlCo5IkSW1zE73ird+MiBcDNwD/4NiLEfF36VWI/+9rncgAS5Ikzb1qQepdwO9X1eOht+ROv0uAW0apDm+AJUmS1EubeiQzzxuyzyXA24e8/pSTSZIkzbXM/Gvg2xHxOoDoOffY6xFxNnAqcPso5zPAkiRJcyci9tALls6OiAPVwtpvAN4SEV8Bvga8uu+Q3cAnRljsvXd+yzRIkiSV5QiWJElSYQZYkiRJhRlgSZIkFWaAJUmSVJgBliRJUmEGWJIkSYUZYEmSJBVmgCVJklTY/w8Dl90Te9MiVAAAAABJRU5ErkJggg==\n",
"text/plain": [
"