![](\"../images/tutorial30_cover.png\")
\n",
"\n",
"Image Source: https://gisgeography.com/geodatabase-personal-file/\n",
"Map Source: https://open.nrw/dataset/11ed9860-d540-4f77-8af8-97cee14ce91f"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Set File Paths and download Tutorial Data\n",
"\n",
"If you downloaded the latest `GemGIS` version from the Github repository, append the path so that the package can be imported successfully. Otherwise, it is recommended to install `GemGIS` via `pip install gemgis` and import `GemGIS` using `import gemgis as gg`. In addition, the file path to the folder where the data is being stored is set. The tutorial data is downloaded using Pooch (https://www.fatiando.org/pooch/latest/index.html) and stored in the specified folder. Use `pip install pooch` if Pooch is not installed on your system yet."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"ExecuteTime": {
"end_time": "2021-03-17T11:25:33.572195Z",
"start_time": "2021-03-17T11:25:31.158414Z"
}
},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"WARNING (theano.configdefaults): g++ not available, if using conda: `conda install m2w64-toolchain`\n",
"C:\\Users\\ale93371\\Anaconda3\\envs\\test_gempy\\lib\\site-packages\\theano\\configdefaults.py:560: UserWarning: DeprecationWarning: there is no c++ compiler.This is deprecated and with Theano 0.11 a c++ compiler will be mandatory\n",
" warnings.warn(\"DeprecationWarning: there is no c++ compiler.\"\n",
"WARNING (theano.configdefaults): g++ not detected ! Theano will be unable to execute optimized C-implementations (for both CPU and GPU) and will default to Python implementations. Performance will be severely degraded. To remove this warning, set Theano flags cxx to an empty string.\n",
"WARNING (theano.tensor.blas): Using NumPy C-API based implementation for BLAS functions.\n"
]
}
],
"source": [
"import gemgis as gg\n",
"file_path ='data/30_opening_geodatabases_for_gemgis/'"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"ExecuteTime": {
"end_time": "2021-03-17T11:25:38.328568Z",
"start_time": "2021-03-17T11:25:33.606173Z"
}
},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"Downloading file '30_opening_geodatabases_for_gemgis.zip' from 'https://rwth-aachen.sciebo.de/s/AfXRsZywYDbUF34/download?path=%2F30_opening_geodatabases_for_gemgis.zip' to 'C:\\Users\\ale93371\\Documents\\gemgis\\docs\\getting_started\\tutorial\\data\\30_opening_geodatabases_for_gemgis'.\n"
]
}
],
"source": [
"gg.download_gemgis_data.download_tutorial_data(filename=\"30_opening_geodatabases_for_gemgis.zip\", dirpath=file_path)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Load Layer Data\n",
"\n",
"The used GeoDataBase was downloaded from https://www.opengeodata.nrw.de/produkte/geologie/geologie/GK/ISGK100/ISGK100vektor/ and will be used under Datenlizenz Deutschland Namensnennung 2.0. \n",
"\n",
"A list of the different layers within the GeoDataBase can be obtained using fionas ``listlayers(..)`` function. Subsequently, the different layers in the GeoDataBase can be loaded as GeoDataFrames using GeoPandas."
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {
"ExecuteTime": {
"end_time": "2020-12-22T10:06:32.393332Z",
"start_time": "2020-12-22T10:06:32.374325Z"
}
},
"outputs": [
{
"data": {
"text/plain": [
"['GK100_Tektonik', 'GK100_Hauptschichten', 'GK100_Deckschichten']"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import geopandas as gpd\n",
"import fiona\n",
"\n",
"layer_list = fiona.listlayers(file_path + 'ISGK100.gdb')\n",
"layer_list"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Loading and Plotting different Layers of GeoDataBase"
]
},
{
"cell_type": "code",
"execution_count": 25,
"metadata": {
"ExecuteTime": {
"end_time": "2020-12-22T10:33:55.067571Z",
"start_time": "2020-12-22T10:33:53.787423Z"
}
},
"outputs": [
{
"data": {
"text/html": [
"| \n", " | TYP | \n", "DATUM | \n", "SHAPE_Length | \n", "geometry | \n", "
|---|---|---|---|---|
| 0 | \n", "Überschiebung, gesichert | \n", "20140911 | \n", "809.45 | \n", "MULTILINESTRING ((400321.058 5653696.880, 4001... | \n", "
| 1 | \n", "Überschiebung, gesichert | \n", "20140911 | \n", "695.09 | \n", "MULTILINESTRING ((399433.510 5653415.030, 3992... | \n", "
| 2 | \n", "Überschiebung, gesichert | \n", "20140911 | \n", "2021.76 | \n", "MULTILINESTRING ((402635.674 5654612.215, 4023... | \n", "
| 3 | \n", "Überschiebung, gesichert | \n", "20140911 | \n", "1016.71 | \n", "MULTILINESTRING ((403501.564 5651765.422, 4037... | \n", "
| 4 | \n", "Überschiebung, gesichert | \n", "20140911 | \n", "1085.76 | \n", "MULTILINESTRING ((404140.075 5652650.414, 4050... | \n", "
| \n", " | ID | \n", "EINHEIT | \n", "SYMBOL | \n", "LITHOLOGIE | \n", "LITHOLOGIE_KURZ | \n", "STEINART | \n", "SYSTEM | \n", "SERIE | \n", "STUFE | \n", "LEGENDE | \n", "DATUM | \n", "SHAPE_Length | \n", "SHAPE_Area | \n", "geometry | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "4109 | \n", "Sprockhövel-Schichten | \n", "cnS | \n", "Schluff- und Tonstein, schwach bis stark sandi... | \n", "Tonstein, Schluffstein, Steinkohle | \n", "Festgestein | \n", "Karbon | \n", "Oberkarbon | \n", "Namur C | \n", "4109, Sprockhövel-Schichten | \n", "20140911 | \n", "3008.74 | \n", "172425.08 | \n", "MULTIPOLYGON (((352879.326 5697940.476, 352924... | \n", "
| 1 | \n", "4109 | \n", "Sprockhövel-Schichten | \n", "cnS | \n", "Schluff- und Tonstein, schwach bis stark sandi... | \n", "Tonstein, Schluffstein, Steinkohle | \n", "Festgestein | \n", "Karbon | \n", "Oberkarbon | \n", "Namur C | \n", "4109, Sprockhövel-Schichten | \n", "20140911 | \n", "2585.06 | \n", "200323.96 | \n", "MULTIPOLYGON (((392856.502 5695841.097, 392721... | \n", "
| 2 | \n", "4109 | \n", "Sprockhövel-Schichten | \n", "cnS | \n", "Schluff- und Tonstein, schwach bis stark sandi... | \n", "Tonstein, Schluffstein, Steinkohle | \n", "Festgestein | \n", "Karbon | \n", "Oberkarbon | \n", "Namur C | \n", "4109, Sprockhövel-Schichten | \n", "20140911 | \n", "4025.19 | \n", "300520.77 | \n", "MULTIPOLYGON (((358582.349 5698046.058, 358435... | \n", "
| 3 | \n", "4109 | \n", "Sprockhövel-Schichten | \n", "cnS | \n", "Schluff- und Tonstein, schwach bis stark sandi... | \n", "Tonstein, Schluffstein, Steinkohle | \n", "Festgestein | \n", "Karbon | \n", "Oberkarbon | \n", "Namur C | \n", "4109, Sprockhövel-Schichten | \n", "20140911 | \n", "2634.66 | \n", "448870.72 | \n", "MULTIPOLYGON (((391719.954 5695960.055, 391591... | \n", "
| 4 | \n", "4109 | \n", "Sprockhövel-Schichten | \n", "cnS | \n", "Schluff- und Tonstein, schwach bis stark sandi... | \n", "Tonstein, Schluffstein, Steinkohle | \n", "Festgestein | \n", "Karbon | \n", "Oberkarbon | \n", "Namur C | \n", "4109, Sprockhövel-Schichten | \n", "20140911 | \n", "2260.89 | \n", "143180.71 | \n", "MULTIPOLYGON (((375148.274 5696852.140, 375087... | \n", "
| \n", " | ID | \n", "EINHEIT | \n", "SYMBOL | \n", "LITHOLOGIE | \n", "LITHOLOGIE_KURZ | \n", "STEINART | \n", "SYSTEM | \n", "SERIE | \n", "STUFE | \n", "LEGENDE | \n", "DATUM | \n", "SHAPE_Length | \n", "SHAPE_Area | \n", "geometry | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1132 | \n", "Auenlehm | \n", "Lf | \n", "Schluff und Ton, sandig, z.T. kalkhaltig, grau... | \n", "Schluff, Ton | \n", "Lockergestein | \n", "Quartär | \n", "Holozän | \n", "None | \n", "1132, Auenlehm | \n", "20140911 | \n", "19229.40 | \n", "1569937.10 | \n", "MULTIPOLYGON (((322257.871 5728988.642, 322320... | \n", "
| 1 | \n", "1132 | \n", "Auenlehm | \n", "Lf | \n", "Schluff und Ton, sandig, z.T. kalkhaltig, grau... | \n", "Schluff, Ton | \n", "Lockergestein | \n", "Quartär | \n", "Holozän | \n", "None | \n", "1132, Auenlehm | \n", "20140911 | \n", "3177.70 | \n", "348742.93 | \n", "MULTIPOLYGON (((323863.620 5728974.644, 323892... | \n", "
| 2 | \n", "1132 | \n", "Auenlehm | \n", "Lf | \n", "Schluff und Ton, sandig, z.T. kalkhaltig, grau... | \n", "Schluff, Ton | \n", "Lockergestein | \n", "Quartär | \n", "Holozän | \n", "None | \n", "1132, Auenlehm | \n", "20140911 | \n", "5298.13 | \n", "755121.53 | \n", "MULTIPOLYGON (((323481.893 5729792.005, 323501... | \n", "
| 3 | \n", "1132 | \n", "Auenlehm | \n", "Lf | \n", "Schluff und Ton, sandig, z.T. kalkhaltig, grau... | \n", "Schluff, Ton | \n", "Lockergestein | \n", "Quartär | \n", "Holozän | \n", "None | \n", "1132, Auenlehm | \n", "20140911 | \n", "2120.11 | \n", "274024.58 | \n", "MULTIPOLYGON (((322560.368 5730041.085, 322782... | \n", "
| 4 | \n", "1203 | \n", "Hanglehm, Hangschutt und Fließerde | \n", "hg | \n", "Schluff, tonig, sandig, grusig, steinig, braun... | \n", "Schluff | \n", "Lockergestein | \n", "Quartär | \n", "Pleistozän bis Holozän | \n", "None | \n", "1203, Hanglehm, Hangschutt und Fließerde | \n", "20140911 | \n", "3788.10 | \n", "859667.50 | \n", "MULTIPOLYGON (((472748.270 5713137.549, 472740... | \n", "