Newer
Older
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# All the Mountains"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"*Extract all postcards depicting a mountain*"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"*(as far as we know from the metadata)*"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Setup"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"pd.set_option('display.max_columns', 100) # Output up to 100 columns"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Load Data"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/home/kst/tmp/dingsdi/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3049: DtypeWarning: Columns (13) have mixed types. Specify dtype option on import or set low_memory=False.\n",
" interactivity=interactivity, compiler=compiler, result=result)\n"
]
}
],
"df = pd.read_csv('https://labs.onb.ac.at/gitlab/labs-team/raw-metadata/raw/master/akon_postcards_public_domain.csv.bz2', compression='bz2')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## View Data"
]
},
{
"cell_type": "code",
"execution_count": 3,
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Unnamed: 0</th>\n",
" <th>akon_id</th>\n",
" <th>id</th>\n",
" <th>altitude</th>\n",
" <th>building</th>\n",
" <th>city</th>\n",
" <th>color</th>\n",
" <th>comment</th>\n",
" <th>mountain</th>\n",
" <th>other</th>\n",
" <th>photographer</th>\n",
" <th>publisher</th>\n",
" <th>publisher_place</th>\n",
" <th>region</th>\n",
" <th>water_body</th>\n",
" <th>year</th>\n",
" <th>inventory_number</th>\n",
" <th>signature</th>\n",
" <th>revision_date</th>\n",
" <th>date</th>\n",
" <th>feature_class</th>\n",
" <th>feature_code</th>\n",
" <th>geoname_id</th>\n",
" <th>latitude</th>\n",
" <th>longitude</th>\n",
" <th>name</th>\n",
" <th>country_id</th>\n",
" <th>admin_name_1</th>\n",
" <th>admin_code_1</th>\n",
" <th>geo</th>\n",
" <th>download_link</th>\n",
" <th>download_link_256x256</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>7125</th>\n",
" <td>7125</td>\n",
" <td>AK103_180</td>\n",
" <td>67901</td>\n",
" <td>Laurenskerk</td>\n",
" <td>Alkmaar</td>\n",
" <td>False</td>\n",
" <td>gel. 1911</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>79/59 K</td>\n",
" <td>2014-09-03 12:10:00.735</td>\n",
" <td>gelaufen 1911</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>2759899.0</td>\n",
" <td>52.63167</td>\n",
" <td>4.74861</td>\n",
" <td>Alkmaar</td>\n",
" <td>NL</td>\n",
" <td>Nord-Holland</td>\n",
" <td>07</td>\n",
" <td>52.63167, 4.74861</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK103_180/1...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK103_180/1...</td>\n",
" <th>6850</th>\n",
" <td>6850</td>\n",
" <td>AK080_116</td>\n",
" <td>49953</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Stuttgart</td>\n",
" <td>1913 gel</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Schaller</td>\n",
" <td>Stuttgart</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2014-08-25 14:42:50.107</td>\n",
" <td>gelaufen 1913</td>\n",
" <td>PPLA</td>\n",
" <td>2825297.0</td>\n",
" <td>48.78232</td>\n",
" <td>9.17702</td>\n",
" <td>Stuttgart</td>\n",
" <td>DE</td>\n",
" <td>Baden-Württemberg</td>\n",
" <td>01</td>\n",
" <td>48.78232, 9.17702</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK080_116/1...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK080_116/1...</td>\n",
" <th>9180</th>\n",
" <td>9180</td>\n",
" <td>AK092_417</td>\n",
" <td>58634</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Frankfurt a. M., Goetheplatz</td>\n",
" <td>False</td>\n",
" <td>v 1905</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kiement</td>\n",
" <td>Frankfurt a. M.</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Geogr. Topogr. Bilder-Samml. 1943, 13602</td>\n",
" <td>2014-09-01 10:38:38.387</td>\n",
" <td>vor 1905</td>\n",
" <td>P</td>\n",
" <td>PPLA3</td>\n",
" <td>2925533.0</td>\n",
" <td>50.11552</td>\n",
" <td>8.68417</td>\n",
" <td>Frankfurt am Main</td>\n",
" <td>DE</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>50.11552, 8.68417</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK092_417/4...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK092_417/4...</td>\n",
" <th>14579</th>\n",
" <td>14579</td>\n",
" <td>AK009_594</td>\n",
" <td>5432</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Mariazell</td>\n",
" <td>False</td>\n",
" <td>NaN</td>\n",
" <td>Oetscher</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ledermann</td>\n",
" <td>Wien</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1922.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2014-08-04 07:59:09.936</td>\n",
" <td>1922</td>\n",
" <td>PPLA3</td>\n",
" <td>2771893.0</td>\n",
" <td>47.77306</td>\n",
" <td>15.31639</td>\n",
" <td>Mariazell</td>\n",
" <td>AT</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>47.77306, 15.31639</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK009_594/5...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK009_594/5...</td>\n",
" <th>15018</th>\n",
" <td>15018</td>\n",
" <td>AK011_064</td>\n",
" <td>6115</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Waidhofen an der Ybbs</td>\n",
" <td>True</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Herzig</td>\n",
" <td>Waidhofen a. d. Ybbs</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1913.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2014-08-04 07:59:09.959</td>\n",
" <td>1913</td>\n",
" <td>P</td>\n",
" <td>PPLA3</td>\n",
" <td>2762077.0</td>\n",
" <td>47.96004</td>\n",
" <td>14.77361</td>\n",
" <td>Waidhofen an der Ybbs</td>\n",
" <td>AT</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>47.96004, 14.77361</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK011_064/0...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK011_064/0...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Unnamed: 0 akon_id id altitude building \\\n",
"7125 7125 AK103_180 67901 NaN Laurenskerk \n",
"6850 6850 AK080_116 49953 NaN NaN \n",
"9180 9180 AK092_417 58634 NaN NaN \n",
"14579 14579 AK009_594 5432 NaN NaN \n",
"15018 15018 AK011_064 6115 NaN NaN \n",
" city color comment mountain other \\\n",
"7125 Alkmaar False gel. 1911 NaN NaN \n",
"6850 Stuttgart False 1913 gel NaN NaN \n",
"9180 Frankfurt a. M., Goetheplatz False v 1905 NaN NaN \n",
"14579 Mariazell False NaN Oetscher NaN \n",
"15018 Waidhofen an der Ybbs True NaN NaN NaN \n",
" photographer publisher publisher_place region water_body year \\\n",
"7125 NaN NaN NaN NaN NaN NaN \n",
"6850 NaN Schaller Stuttgart NaN NaN NaN \n",
"9180 NaN Kiement Frankfurt a. M. NaN NaN NaN \n",
"14579 NaN Ledermann Wien NaN NaN 1922.0 \n",
"15018 NaN Herzig Waidhofen a. d. Ybbs NaN NaN 1913.0 \n",
" inventory_number signature \\\n",
"7125 79/59 K NaN \n",
"6850 NaN NaN \n",
"9180 NaN Geogr. Topogr. Bilder-Samml. 1943, 13602 \n",
"14579 NaN NaN \n",
"15018 NaN NaN \n",
"\n",
" revision_date date feature_class feature_code \\\n",
"7125 2014-09-03 12:10:00.735 gelaufen 1911 P PPL \n",
"6850 2014-08-25 14:42:50.107 gelaufen 1913 P PPLA \n",
"9180 2014-09-01 10:38:38.387 vor 1905 P PPLA3 \n",
"14579 2014-08-04 07:59:09.936 1922 P PPLA3 \n",
"15018 2014-08-04 07:59:09.959 1913 P PPLA3 \n",
"\n",
" geoname_id latitude longitude name country_id \\\n",
"7125 2759899.0 52.63167 4.74861 Alkmaar NL \n",
"6850 2825297.0 48.78232 9.17702 Stuttgart DE \n",
"9180 2925533.0 50.11552 8.68417 Frankfurt am Main DE \n",
"14579 2771893.0 47.77306 15.31639 Mariazell AT \n",
"15018 2762077.0 47.96004 14.77361 Waidhofen an der Ybbs AT \n",
" admin_name_1 admin_code_1 geo \\\n",
"7125 Nord-Holland 07 52.63167, 4.74861 \n",
"6850 Baden-Württemberg 01 48.78232, 9.17702 \n",
"9180 NaN NaN 50.11552, 8.68417 \n",
"14579 NaN NaN 47.77306, 15.31639 \n",
"15018 NaN NaN 47.96004, 14.77361 \n",
" download_link \\\n",
"7125 https://iiif.onb.ac.at/images/AKON/AK103_180/1... \n",
"6850 https://iiif.onb.ac.at/images/AKON/AK080_116/1... \n",
"9180 https://iiif.onb.ac.at/images/AKON/AK092_417/4... \n",
"14579 https://iiif.onb.ac.at/images/AKON/AK009_594/5... \n",
"15018 https://iiif.onb.ac.at/images/AKON/AK011_064/0... \n",
"\n",
" download_link_256x256 \n",
"7125 https://iiif.onb.ac.at/images/AKON/AK103_180/1... \n",
"6850 https://iiif.onb.ac.at/images/AKON/AK080_116/1... \n",
"9180 https://iiif.onb.ac.at/images/AKON/AK092_417/4... \n",
"14579 https://iiif.onb.ac.at/images/AKON/AK009_594/5... \n",
"15018 https://iiif.onb.ac.at/images/AKON/AK011_064/0... "
"execution_count": 3,
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.sample(5)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Filter Mountains"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Rows without an identified mountain have `'NaN'` in the column `'mountain'`"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"We can filter by those having NaN by using `'isnull'`:"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df)"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df[ df['mountain'].isnull() ])"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"and reverse the filter, so we get all rows where the 'mountain' entry *is not NaN*.\n",
"\n",
"Note that `'~'` means a logical *not*.\n",
"\n",
"Also note that the filter has to be inside parentheses."
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df[ ~ (df['mountain'].isnull()) ])"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"And now let's save the result."
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [],
"source": [
"mountains = df[ ~ (df['mountain'].isnull()) ]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Take a look at the data"
]
},
{
"cell_type": "code",
"execution_count": 8,
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Unnamed: 0</th>\n",
" <th>akon_id</th>\n",
" <th>id</th>\n",
" <th>altitude</th>\n",
" <th>building</th>\n",
" <th>city</th>\n",
" <th>color</th>\n",
" <th>comment</th>\n",
" <th>mountain</th>\n",
" <th>other</th>\n",
" <th>photographer</th>\n",
" <th>publisher</th>\n",
" <th>publisher_place</th>\n",
" <th>region</th>\n",
" <th>water_body</th>\n",
" <th>year</th>\n",
" <th>inventory_number</th>\n",
" <th>signature</th>\n",
" <th>revision_date</th>\n",
" <th>date</th>\n",
" <th>feature_class</th>\n",
" <th>feature_code</th>\n",
" <th>geoname_id</th>\n",
" <th>latitude</th>\n",
" <th>longitude</th>\n",
" <th>name</th>\n",
" <th>country_id</th>\n",
" <th>admin_name_1</th>\n",
" <th>admin_code_1</th>\n",
" <th>geo</th>\n",
" <th>download_link</th>\n",
" <th>download_link_256x256</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>7485</th>\n",
" <td>7485</td>\n",
" <td>AK084_275</td>\n",
" <td>52992</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>False</td>\n",
" <td>v 1905</td>\n",
" <td>Drei Zinnen</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Photoglob Co.</td>\n",
" <td>Zürich</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2014-08-27 10:53:09.020</td>\n",
" <td>vor 1905</td>\n",
" <td>T</td>\n",
" <td>PKS</td>\n",
" <td>3165272.0</td>\n",
" <td>46.61900</td>\n",
" <td>12.30185</td>\n",
" <td>Drei Zinnen</td>\n",
" <td>IT</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>46.619, 12.30185</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK084_275/2...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK084_275/2...</td>\n",
" <th>13042</th>\n",
" <td>13042</td>\n",
" <td>AK006_027</td>\n",
" <td>3076</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>False</td>\n",
" <td>NaN</td>\n",
" <td>Schareck</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Gutenberghaus</td>\n",
" <td>Klagenfurt</td>\n",
" <td>Bärenfall</td>\n",
" <td>1911.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2014-08-04 07:59:09.851</td>\n",
" <td>1911</td>\n",
" <td>PASS</td>\n",
" <td>2766151.0</td>\n",
" <td>47.04180</td>\n",
" <td>13.01590</td>\n",
" <td>Schareck</td>\n",
" <td>AT</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>47.0418, 13.0159</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK006_027/0...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK006_027/0...</td>\n",
" <th>31375</th>\n",
" <td>31375</td>\n",
" <td>AK100_503</td>\n",
" <td>64754</td>\n",
" <td>Rifugio Bolognini</td>\n",
" <td>NaN</td>\n",
" <td>False</td>\n",
" <td>1899</td>\n",
" <td>Bedole</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>79/66 G</td>\n",
" <td>2014-09-03 07:13:16.993</td>\n",
" <td>gelaufen 1899</td>\n",
" <td>PK</td>\n",
" <td>6696180.0</td>\n",
" <td>46.18410</td>\n",
" <td>11.80228</td>\n",
" <td>Bedole</td>\n",
" <td>IT</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>46.1841, 11.80228</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK100_503/5...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK100_503/5...</td>\n",
" <th>2166</th>\n",
" <td>2166</td>\n",
" <td>AK114_236</td>\n",
" <td>76661</td>\n",
" <td>Stutenhaus, Berghotel Adlersberg</td>\n",
" <td>Vesser</td>\n",
" <td>False</td>\n",
" <td>NaN</td>\n",
" <td>Adlersberg</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1907.0</td>\n",
" <td>13/41 G. KA.</td>\n",
" <td>Geographisch-topographische Bildersammlung 293...</td>\n",
" <td>2014-09-09 09:01:30.828</td>\n",
" <td>1907</td>\n",
" <td>P</td>\n",
" <td>PPL</td>\n",
" <td>2817527.0</td>\n",
" <td>50.59519</td>\n",
" <td>10.78953</td>\n",
" <td>Vesser</td>\n",
" <td>DE</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>50.59519, 10.78953</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK114_236/2...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK114_236/2...</td>\n",
" <th>4432</th>\n",
" <td>4432</td>\n",
" <td>AK048_462</td>\n",
" <td>28904</td>\n",
" <td>Habsburghaus</td>\n",
" <td>True</td>\n",
" <td>Rax</td>\n",
" <td>Alpengarten</td>\n",
" <td>NaN</td>\n",
" <td>Ledermann</td>\n",
" <td>Wien</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1908.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-16 11:05:32.590</td>\n",
" <td>1908</td>\n",
" <td>S</td>\n",
" <td>HTL</td>\n",
" <td>2777118.0</td>\n",
" <td>47.73333</td>\n",
" <td>15.70000</td>\n",
" <td>Habsburghaus</td>\n",
" <td>AT</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>47.73333, 15.7</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK048_462/4...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK048_462/4...</td>\n",
" <th>31396</th>\n",
" <td>31396</td>\n",
" <td>AK101_239</td>\n",
" <td>65894</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Wallis</td>\n",
" <td>v. 1907</td>\n",
" <td>Urner Alpen</td>\n",
" <td>Rhonegletscher</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>79/66 G</td>\n",
" <td>2014-09-03 08:27:15.774</td>\n",
" <td>vor 1907</td>\n",
" <td>H</td>\n",
" <td>GLCR</td>\n",
" <td>2659056.0</td>\n",
" <td>46.60454</td>\n",
" <td>8.38605</td>\n",
" <td>Rhonegletscher</td>\n",
" <td>CH</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>46.60454, 8.38605</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK101_239/2...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK101_239/2...</td>\n",
" <th>23714</th>\n",
" <td>23714</td>\n",
" <td>AK043_519</td>\n",
" <td>25852</td>\n",
" <td>959.0</td>\n",
" <td>Jubiläumswarte</td>\n",
" <td>NaN</td>\n",
" <td>True</td>\n",
" <td>NaN</td>\n",
" <td>Jauerling</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ledermann</td>\n",
" <td>Wien</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1912.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2014-08-04 07:59:10.342</td>\n",
" <td>1912</td>\n",
" <td>T</td>\n",
" <td>MT</td>\n",
" <td>2775112.0</td>\n",
" <td>48.34098</td>\n",
" <td>15.34050</td>\n",
" <td>Jauerling Gipfelkreuz</td>\n",
" <td>Niederösterreich</td>\n",
" <td>03</td>\n",
" <td>48.34098, 15.3405</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK043_519/5...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK043_519/5...</td>\n",
" <th>33482</th>\n",
" <td>33482</td>\n",
" <td>AK097_371</td>\n",
" <td>62297</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Brenta</td>\n",
" <td>1905 gel</td>\n",
" <td>Kaiser Franz-Josef-Spitze</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-02 11:19:10.995</td>\n",
" <td>vor 1905</td>\n",
" <td>T</td>\n",
" <td>PASS</td>\n",
" <td>3180988.0</td>\n",
" <td>46.23970</td>\n",
" <td>10.84110</td>\n",
" <td>Campo Carlo Magno</td>\n",
" <td>IT</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>46.2397, 10.8411</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK097_371/3...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK097_371/3...</td>\n",
" <th>25652</th>\n",
" <td>25652</td>\n",
" <td>AK034_222</td>\n",
" <td>20139</td>\n",
" <td>442.0</td>\n",
" <td>Gloggnitz</td>\n",
" <td>False</td>\n",
" <td>Rax, Feuchter</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Ledermann</td>\n",
" <td>Wien</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1918.0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-16 11:11:53.011</td>\n",
" <td>1918</td>\n",
" <td>P</td>\n",
" <td>PPLA3</td>\n",
" <td>2778455.0</td>\n",
" <td>47.67487</td>\n",
" <td>15.93893</td>\n",
" <td>Gloggnitz</td>\n",
" <td>AT</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>47.67487, 15.93893</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK034_222/2...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK034_222/2...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28730</th>\n",
" <td>28730</td>\n",
" <td>AK064_513</td>\n",
" <td>39161</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Hallein</td>\n",
" <td>False</td>\n",
" <td>NaN</td>\n",
" <td>Tennengebirge</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Huttegger</td>\n",
" <td>Salzburg</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>1916.0</td>\n",
" <td>NaN</td>\n",
" <td>Geographisch-topographische Bildersammlung I. ...</td>\n",
" <td>2015-04-15 10:58:33.373</td>\n",
" <td>1916</td>\n",
" <td>MTS</td>\n",
" <td>2763805.0</td>\n",
" <td>47.50000</td>\n",
" <td>13.25000</td>\n",
" <td>Tennengebirge</td>\n",
" <td>AT</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>47.5, 13.25</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK064_513/5...</td>\n",
" <td>https://iiif.onb.ac.at/images/AKON/AK064_513/5...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
" Unnamed: 0 akon_id id altitude \\\n",
"7485 7485 AK084_275 52992 NaN \n",
"13042 13042 AK006_027 3076 NaN \n",
"31375 31375 AK100_503 64754 NaN \n",
"2166 2166 AK114_236 76661 NaN \n",
"4432 4432 AK048_462 28904 NaN \n",
"31396 31396 AK101_239 65894 NaN \n",
"23714 23714 AK043_519 25852 959.0 \n",
"33482 33482 AK097_371 62297 NaN \n",
"25652 25652 AK034_222 20139 442.0 \n",
"28730 28730 AK064_513 39161 NaN \n",
"\n",
" building city color comment \\\n",
"7485 NaN NaN False v 1905 \n",
"13042 NaN NaN False NaN \n",
"31375 Rifugio Bolognini NaN False 1899 \n",
"2166 Stutenhaus, Berghotel Adlersberg Vesser False NaN \n",
"4432 Habsburghaus NaN True NaN \n",
"31396 NaN Wallis False v. 1907 \n",
"23714 Jubiläumswarte NaN True NaN \n",
"33482 NaN Brenta False 1905 gel \n",
"25652 NaN Gloggnitz False NaN \n",
"28730 NaN Hallein False NaN \n",
"\n",
" mountain other photographer publisher \\\n",
"7485 Drei Zinnen NaN NaN Photoglob Co. \n",
"13042 Schareck NaN NaN Gutenberghaus \n",
"31375 Bedole NaN NaN NaN \n",
"2166 Adlersberg NaN NaN NaN \n",
"4432 Rax Alpengarten NaN Ledermann \n",
"31396 Urner Alpen Rhonegletscher NaN NaN \n",
"23714 Jauerling NaN NaN Ledermann \n",
"33482 Kaiser Franz-Josef-Spitze NaN NaN NaN \n",
"25652 Rax, Feuchter NaN NaN Ledermann \n",
"28730 Tennengebirge NaN NaN Huttegger \n",
"\n",
" publisher_place region water_body year inventory_number \\\n",
"7485 Zürich NaN NaN NaN NaN \n",
"13042 Klagenfurt NaN Bärenfall 1911.0 NaN \n",
"31375 NaN NaN NaN NaN 79/66 G \n",
"2166 NaN NaN NaN 1907.0 13/41 G. KA. \n",
"4432 Wien NaN NaN 1908.0 NaN \n",
"31396 NaN NaN NaN NaN 79/66 G \n",
"23714 Wien NaN NaN 1912.0 NaN \n",
"33482 NaN NaN NaN NaN NaN \n",
"25652 Wien NaN NaN 1918.0 NaN \n",
"28730 Salzburg NaN NaN 1916.0 NaN \n",
" signature \\\n",
"7485 NaN \n",
"13042 NaN \n",
"31375 NaN \n",
"2166 Geographisch-topographische Bildersammlung 293... \n",
"4432 NaN \n",
"31396 NaN \n",
"23714 NaN \n",
"33482 NaN \n",
"25652 NaN \n",
"28730 Geographisch-topographische Bildersammlung I. ... \n",
" revision_date date feature_class feature_code \\\n",
"7485 2014-08-27 10:53:09.020 vor 1905 T PKS \n",
"13042 2014-08-04 07:59:09.851 1911 T PASS \n",
"31375 2014-09-03 07:13:16.993 gelaufen 1899 T PK \n",
"2166 2014-09-09 09:01:30.828 1907 P PPL \n",
"4432 2014-09-16 11:05:32.590 1908 S HTL \n",
"31396 2014-09-03 08:27:15.774 vor 1907 H GLCR \n",
"23714 2014-08-04 07:59:10.342 1912 T MT \n",
"33482 2014-09-02 11:19:10.995 vor 1905 T PASS \n",
"25652 2014-09-16 11:11:53.011 1918 P PPLA3 \n",
"28730 2015-04-15 10:58:33.373 1916 T MTS \n",
" geoname_id latitude longitude name country_id \\\n",
"7485 3165272.0 46.61900 12.30185 Drei Zinnen IT \n",
"13042 2766151.0 47.04180 13.01590 Schareck AT \n",
"31375 6696180.0 46.18410 11.80228 Bedole IT \n",
"2166 2817527.0 50.59519 10.78953 Vesser DE \n",
"4432 2777118.0 47.73333 15.70000 Habsburghaus AT \n",
"31396 2659056.0 46.60454 8.38605 Rhonegletscher CH \n",
"23714 2775112.0 48.34098 15.34050 Jauerling Gipfelkreuz AT \n",
"33482 3180988.0 46.23970 10.84110 Campo Carlo Magno IT \n",
"25652 2778455.0 47.67487 15.93893 Gloggnitz AT \n",
"28730 2763805.0 47.50000 13.25000 Tennengebirge AT \n",