Skip to content

Instantly share code, notes, and snippets.

@kinverarity1

kinverarity1/gds_cache_pr31.ipynb

Last active October 31, 2023 03:42
Show Gist options
  • Save kinverarity1/a93ff5a275840dc7eb466fee37449dd9 to your computer and use it in GitHub Desktop.
Save kinverarity1/a93ff5a275840dc7eb466fee37449dd9 to your computer and use it in GitHub Desktop.
Download ZIP
python-sa-gwdata#31 Example notebook
Display the source blob
Display the rendered blob
Raw
gds_cache_pr31.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "a81e07c3",
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"INFO:sa_gwdata.local_cache:The local drillhole cache is 14 days old. You may wish to run sa_gwdata.cache.update() to download a new version.\n"
]
}
],
"source": [
"import logging; logging.basicConfig(level=logging.INFO)\n",
"\n",
"import sa_gwdata"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "63d92d93",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"WindowsPath('C:/Users/KINVERARITY/AppData/Local/sa_gwdata/sa_gwdata/drillholes_2023-10-17.feather')"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sa_gwdata.cache.dh_layer_path"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "225565e3",
"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>UNIT_NO</th>\n",
" <th>DHNO</th>\n",
" <th>NAME</th>\n",
" <th>EASTING</th>\n",
" <th>NORTHING</th>\n",
" <th>ZONE</th>\n",
" <th>LAT</th>\n",
" <th>LON</th>\n",
" <th>REF_ELEV</th>\n",
" <th>GRND_ELEV</th>\n",
" <th>...</th>\n",
" <th>MIN_DIAM</th>\n",
" <th>TITLE_PREF</th>\n",
" <th>TITLE_VOLU</th>\n",
" <th>TITLE_FOLI</th>\n",
" <th>TITLE_ID</th>\n",
" <th>GRND_ELEV_</th>\n",
" <th>HGUID</th>\n",
" <th>FTYPE</th>\n",
" <th>NGIS</th>\n",
" <th>LATEST_REF</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>692200095</td>\n",
" <td>88351</td>\n",
" <td>ARGONAUT 1A</td>\n",
" <td>435539.64</td>\n",
" <td>5797248.23</td>\n",
" <td>54</td>\n",
" <td>-37.970102</td>\n",
" <td>140.266108</td>\n",
" <td>28.35</td>\n",
" <td>-77.11</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>692200048</td>\n",
" <td>88304</td>\n",
" <td></td>\n",
" <td>447903.58</td>\n",
" <td>5803431.49</td>\n",
" <td>54</td>\n",
" <td>-37.915169</td>\n",
" <td>140.407313</td>\n",
" <td>3.52</td>\n",
" <td>2.57</td>\n",
" <td>...</td>\n",
" <td>76.0</td>\n",
" <td>CT</td>\n",
" <td>5334</td>\n",
" <td>961</td>\n",
" <td>CT5334/961</td>\n",
" <td>1.379426</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>692200050</td>\n",
" <td>88306</td>\n",
" <td></td>\n",
" <td>448623.30</td>\n",
" <td>5802445.93</td>\n",
" <td>54</td>\n",
" <td>-37.924093</td>\n",
" <td>140.415431</td>\n",
" <td>NaN</td>\n",
" <td>4.89</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>CT</td>\n",
" <td>6071</td>\n",
" <td>400</td>\n",
" <td>CT6071/400</td>\n",
" <td>4.231566</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>692200051</td>\n",
" <td>88307</td>\n",
" <td></td>\n",
" <td>448660.30</td>\n",
" <td>5802445.94</td>\n",
" <td>54</td>\n",
" <td>-37.924095</td>\n",
" <td>140.415852</td>\n",
" <td>NaN</td>\n",
" <td>3.47</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>CT</td>\n",
" <td>6071</td>\n",
" <td>402</td>\n",
" <td>CT6071/402</td>\n",
" <td>5.714929</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>692200053</td>\n",
" <td>88309</td>\n",
" <td></td>\n",
" <td>449053.23</td>\n",
" <td>5802380.93</td>\n",
" <td>54</td>\n",
" <td>-37.924703</td>\n",
" <td>140.420318</td>\n",
" <td>NaN</td>\n",
" <td>1.71</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>CT</td>\n",
" <td>6178</td>\n",
" <td>75</td>\n",
" <td>CT6178/75</td>\n",
" <td>3.426570</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 81 columns</p>\n",
"</div>"
],
"text/plain": [
" UNIT_NO DHNO NAME EASTING NORTHING ZONE LAT \\\n",
"0 692200095 88351 ARGONAUT 1A 435539.64 5797248.23 54 -37.970102 \n",
"1 692200048 88304 447903.58 5803431.49 54 -37.915169 \n",
"2 692200050 88306 448623.30 5802445.93 54 -37.924093 \n",
"3 692200051 88307 448660.30 5802445.94 54 -37.924095 \n",
"4 692200053 88309 449053.23 5802380.93 54 -37.924703 \n",
"\n",
" LON REF_ELEV GRND_ELEV ... MIN_DIAM TITLE_PREF TITLE_VOLU \\\n",
"0 140.266108 28.35 -77.11 ... NaN \n",
"1 140.407313 3.52 2.57 ... 76.0 CT 5334 \n",
"2 140.415431 NaN 4.89 ... NaN CT 6071 \n",
"3 140.415852 NaN 3.47 ... NaN CT 6071 \n",
"4 140.420318 NaN 1.71 ... NaN CT 6178 \n",
"\n",
" TITLE_FOLI TITLE_ID GRND_ELEV_ HGUID FTYPE NGIS LATEST_REF \n",
"0 NaN 0 \n",
"1 961 CT5334/961 1.379426 0 \n",
"2 400 CT6071/400 4.231566 0 \n",
"3 402 CT6071/402 5.714929 0 \n",
"4 75 CT6178/75 3.426570 0 \n",
"\n",
"[5 rows x 81 columns]"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sa_gwdata.cache.dh_layer.head()"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "f1a7852f",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"CPU times: total: 0 ns\n",
"Wall time: 0 ns\n"
]
},
{
"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>UNIT_NO</th>\n",
" <th>DHNO</th>\n",
" <th>NAME</th>\n",
" <th>EASTING</th>\n",
" <th>NORTHING</th>\n",
" <th>ZONE</th>\n",
" <th>LAT</th>\n",
" <th>LON</th>\n",
" <th>REF_ELEV</th>\n",
" <th>GRND_ELEV</th>\n",
" <th>...</th>\n",
" <th>MIN_DIAM</th>\n",
" <th>TITLE_PREF</th>\n",
" <th>TITLE_VOLU</th>\n",
" <th>TITLE_FOLI</th>\n",
" <th>TITLE_ID</th>\n",
" <th>GRND_ELEV_</th>\n",
" <th>HGUID</th>\n",
" <th>FTYPE</th>\n",
" <th>NGIS</th>\n",
" <th>LATEST_REF</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>692200095</td>\n",
" <td>88351</td>\n",
" <td>ARGONAUT 1A</td>\n",
" <td>435539.64</td>\n",
" <td>5797248.23</td>\n",
" <td>54</td>\n",
" <td>-37.970102</td>\n",
" <td>140.266108</td>\n",
" <td>28.35</td>\n",
" <td>-77.11</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>692200048</td>\n",
" <td>88304</td>\n",
" <td></td>\n",
" <td>447903.58</td>\n",
" <td>5803431.49</td>\n",
" <td>54</td>\n",
" <td>-37.915169</td>\n",
" <td>140.407313</td>\n",
" <td>3.52</td>\n",
" <td>2.57</td>\n",
" <td>...</td>\n",
" <td>76.0</td>\n",
" <td>CT</td>\n",
" <td>5334</td>\n",
" <td>961</td>\n",
" <td>CT5334/961</td>\n",
" <td>1.379426</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>692200050</td>\n",
" <td>88306</td>\n",
" <td></td>\n",
" <td>448623.30</td>\n",
" <td>5802445.93</td>\n",
" <td>54</td>\n",
" <td>-37.924093</td>\n",
" <td>140.415431</td>\n",
" <td>NaN</td>\n",
" <td>4.89</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>CT</td>\n",
" <td>6071</td>\n",
" <td>400</td>\n",
" <td>CT6071/400</td>\n",
" <td>4.231566</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>692200051</td>\n",
" <td>88307</td>\n",
" <td></td>\n",
" <td>448660.30</td>\n",
" <td>5802445.94</td>\n",
" <td>54</td>\n",
" <td>-37.924095</td>\n",
" <td>140.415852</td>\n",
" <td>NaN</td>\n",
" <td>3.47</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>CT</td>\n",
" <td>6071</td>\n",
" <td>402</td>\n",
" <td>CT6071/402</td>\n",
" <td>5.714929</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>692200053</td>\n",
" <td>88309</td>\n",
" <td></td>\n",
" <td>449053.23</td>\n",
" <td>5802380.93</td>\n",
" <td>54</td>\n",
" <td>-37.924703</td>\n",
" <td>140.420318</td>\n",
" <td>NaN</td>\n",
" <td>1.71</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>CT</td>\n",
" <td>6178</td>\n",
" <td>75</td>\n",
" <td>CT6178/75</td>\n",
" <td>3.426570</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>361740</th>\n",
" <td>574600002</td>\n",
" <td>5405</td>\n",
" <td>BLOODWOOD BORE</td>\n",
" <td>429282.71</td>\n",
" <td>7149738.42</td>\n",
" <td>53</td>\n",
" <td>-25.768728</td>\n",
" <td>134.294762</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>361741</th>\n",
" <td>584600003</td>\n",
" <td>7002</td>\n",
" <td>FINKE BORE</td>\n",
" <td>456862.59</td>\n",
" <td>7173276.43</td>\n",
" <td>53</td>\n",
" <td>-25.557252</td>\n",
" <td>134.570560</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>361742</th>\n",
" <td>584600004</td>\n",
" <td>7003</td>\n",
" <td>FINKE SPRING</td>\n",
" <td>458634.68</td>\n",
" <td>7174895.41</td>\n",
" <td>53</td>\n",
" <td>-25.542683</td>\n",
" <td>134.588251</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>361743</th>\n",
" <td>604600001</td>\n",
" <td>14304</td>\n",
" <td>MC.DILLS 1</td>\n",
" <td>579400.60</td>\n",
" <td>7154081.35</td>\n",
" <td>53</td>\n",
" <td>-25.729069</td>\n",
" <td>135.791567</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>361744</th>\n",
" <td>674600002</td>\n",
" <td>78569</td>\n",
" <td>ADRIA DOWNS 1</td>\n",
" <td>333812.69</td>\n",
" <td>7157190.99</td>\n",
" <td>54</td>\n",
" <td>-25.693733</td>\n",
" <td>139.343833</td>\n",
" <td>6.25</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>361745 rows × 81 columns</p>\n",
"</div>"
],
"text/plain": [
" UNIT_NO DHNO NAME EASTING NORTHING ZONE \\\n",
"0 692200095 88351 ARGONAUT 1A 435539.64 5797248.23 54 \n",
"1 692200048 88304 447903.58 5803431.49 54 \n",
"2 692200050 88306 448623.30 5802445.93 54 \n",
"3 692200051 88307 448660.30 5802445.94 54 \n",
"4 692200053 88309 449053.23 5802380.93 54 \n",
"... ... ... ... ... ... ... \n",
"361740 574600002 5405 BLOODWOOD BORE 429282.71 7149738.42 53 \n",
"361741 584600003 7002 FINKE BORE 456862.59 7173276.43 53 \n",
"361742 584600004 7003 FINKE SPRING 458634.68 7174895.41 53 \n",
"361743 604600001 14304 MC.DILLS 1 579400.60 7154081.35 53 \n",
"361744 674600002 78569 ADRIA DOWNS 1 333812.69 7157190.99 54 \n",
"\n",
" LAT LON REF_ELEV GRND_ELEV ... MIN_DIAM TITLE_PREF \\\n",
"0 -37.970102 140.266108 28.35 -77.11 ... NaN \n",
"1 -37.915169 140.407313 3.52 2.57 ... 76.0 CT \n",
"2 -37.924093 140.415431 NaN 4.89 ... NaN CT \n",
"3 -37.924095 140.415852 NaN 3.47 ... NaN CT \n",
"4 -37.924703 140.420318 NaN 1.71 ... NaN CT \n",
"... ... ... ... ... ... ... ... \n",
"361740 -25.768728 134.294762 NaN NaN ... NaN \n",
"361741 -25.557252 134.570560 NaN NaN ... NaN \n",
"361742 -25.542683 134.588251 NaN NaN ... NaN \n",
"361743 -25.729069 135.791567 NaN NaN ... NaN \n",
"361744 -25.693733 139.343833 6.25 NaN ... NaN \n",
"\n",
" TITLE_VOLU TITLE_FOLI TITLE_ID GRND_ELEV_ HGUID FTYPE NGIS \\\n",
"0 NaN 0 \n",
"1 5334 961 CT5334/961 1.379426 0 \n",
"2 6071 400 CT6071/400 4.231566 0 \n",
"3 6071 402 CT6071/402 5.714929 0 \n",
"4 6178 75 CT6178/75 3.426570 0 \n",
"... ... ... ... ... ... ... ... \n",
"361740 NaN 0 \n",
"361741 NaN 0 \n",
"361742 NaN 0 \n",
"361743 NaN 0 \n",
"361744 NaN 0 \n",
"\n",
" LATEST_REF \n",
"0 \n",
"1 \n",
"2 \n",
"3 \n",
"4 \n",
"... ... \n",
"361740 \n",
"361741 \n",
"361742 \n",
"361743 \n",
"361744 \n",
"\n",
"[361745 rows x 81 columns]"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%%time\n",
"sa_gwdata.cache.dh_layer"
]
},
{
"cell_type": "code",
"execution_count": 5,
"id": "1978309c",
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"INFO:sa_gwdata.local_cache:Downloading https://www.waterconnect.sa.gov.au/Content/Downloads/DEW/WATER_Drillholes_shp.zip (~80MB) temporarily to C:\\Users\\KINVERARITY\\AppData\\Local\\sa_gwdata\\sa_gwdata\\drillholes_shapefiles.zip\n",
"INFO:sa_gwdata.local_cache:Processing ~350K rows drillhole records for local cache...\n"
]
}
],
"source": [
"sa_gwdata.cache.update(force=True) # force=True is needed when the layer is less than ndays=30 days old"
]
},
{
"cell_type": "code",
"execution_count": 7,
"id": "57702f04",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"CPU times: total: 0 ns\n",
"Wall time: 0 ns\n"
]
},
{
"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>UNIT_NO</th>\n",
" <th>DHNO</th>\n",
" <th>NAME</th>\n",
" <th>EASTING</th>\n",
" <th>NORTHING</th>\n",
" <th>ZONE</th>\n",
" <th>LAT</th>\n",
" <th>LON</th>\n",
" <th>REF_ELEV</th>\n",
" <th>GRND_ELEV</th>\n",
" <th>...</th>\n",
" <th>MIN_DIAM</th>\n",
" <th>TITLE_PREFIX</th>\n",
" <th>TITLE_VOLUME</th>\n",
" <th>TITLE_FOLIO</th>\n",
" <th>TITLE_ID</th>\n",
" <th>GRND_ELEV_DEM</th>\n",
" <th>HGUID</th>\n",
" <th>FTYPE</th>\n",
" <th>NGIS</th>\n",
" <th>LATEST_REF_POINT_TYP</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>692200095</td>\n",
" <td>88351</td>\n",
" <td>ARGONAUT 1A</td>\n",
" <td>435539.64</td>\n",
" <td>5797248.23</td>\n",
" <td>54</td>\n",
" <td>-37.970102</td>\n",
" <td>140.266108</td>\n",
" <td>28.35</td>\n",
" <td>-77.11</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>692200048</td>\n",
" <td>88304</td>\n",
" <td></td>\n",
" <td>447903.58</td>\n",
" <td>5803431.49</td>\n",
" <td>54</td>\n",
" <td>-37.915169</td>\n",
" <td>140.407313</td>\n",
" <td>3.52</td>\n",
" <td>2.57</td>\n",
" <td>...</td>\n",
" <td>76.0</td>\n",
" <td>CT</td>\n",
" <td>5334</td>\n",
" <td>961</td>\n",
" <td>CT5334/961</td>\n",
" <td>1.379426</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>692200050</td>\n",
" <td>88306</td>\n",
" <td></td>\n",
" <td>448623.30</td>\n",
" <td>5802445.93</td>\n",
" <td>54</td>\n",
" <td>-37.924093</td>\n",
" <td>140.415431</td>\n",
" <td>NaN</td>\n",
" <td>4.89</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>CT</td>\n",
" <td>6071</td>\n",
" <td>400</td>\n",
" <td>CT6071/400</td>\n",
" <td>4.231566</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>692200051</td>\n",
" <td>88307</td>\n",
" <td></td>\n",
" <td>448660.30</td>\n",
" <td>5802445.94</td>\n",
" <td>54</td>\n",
" <td>-37.924095</td>\n",
" <td>140.415852</td>\n",
" <td>NaN</td>\n",
" <td>3.47</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>CT</td>\n",
" <td>6071</td>\n",
" <td>402</td>\n",
" <td>CT6071/402</td>\n",
" <td>5.714929</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>692200053</td>\n",
" <td>88309</td>\n",
" <td></td>\n",
" <td>449053.23</td>\n",
" <td>5802380.93</td>\n",
" <td>54</td>\n",
" <td>-37.924703</td>\n",
" <td>140.420318</td>\n",
" <td>NaN</td>\n",
" <td>1.71</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>CT</td>\n",
" <td>6178</td>\n",
" <td>75</td>\n",
" <td>CT6178/75</td>\n",
" <td>3.426570</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 81 columns</p>\n",
"</div>"
],
"text/plain": [
" UNIT_NO DHNO NAME EASTING NORTHING ZONE LAT \\\n",
"0 692200095 88351 ARGONAUT 1A 435539.64 5797248.23 54 -37.970102 \n",
"1 692200048 88304 447903.58 5803431.49 54 -37.915169 \n",
"2 692200050 88306 448623.30 5802445.93 54 -37.924093 \n",
"3 692200051 88307 448660.30 5802445.94 54 -37.924095 \n",
"4 692200053 88309 449053.23 5802380.93 54 -37.924703 \n",
"\n",
" LON REF_ELEV GRND_ELEV ... MIN_DIAM TITLE_PREFIX TITLE_VOLUME \\\n",
"0 140.266108 28.35 -77.11 ... NaN \n",
"1 140.407313 3.52 2.57 ... 76.0 CT 5334 \n",
"2 140.415431 NaN 4.89 ... NaN CT 6071 \n",
"3 140.415852 NaN 3.47 ... NaN CT 6071 \n",
"4 140.420318 NaN 1.71 ... NaN CT 6178 \n",
"\n",
" TITLE_FOLIO TITLE_ID GRND_ELEV_DEM HGUID FTYPE NGIS \\\n",
"0 NaN 0 \n",
"1 961 CT5334/961 1.379426 0 \n",
"2 400 CT6071/400 4.231566 0 \n",
"3 402 CT6071/402 5.714929 0 \n",
"4 75 CT6178/75 3.426570 0 \n",
"\n",
" LATEST_REF_POINT_TYP \n",
"0 \n",
"1 \n",
"2 \n",
"3 \n",
"4 \n",
"\n",
"[5 rows x 81 columns]"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%%time\n",
"sa_gwdata.cache.dh_layer.head()"
]
},
{
"cell_type": "code",
"execution_count": 11,
"id": "56299365",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"['UNIT_NO',\n",
" 'DHNO',\n",
" 'NAME',\n",
" 'EASTING',\n",
" 'NORTHING',\n",
" 'ZONE',\n",
" 'LAT',\n",
" 'LON',\n",
" 'REF_ELEV',\n",
" 'GRND_ELEV',\n",
" 'HUND',\n",
" 'PARCEL',\n",
" 'PARCELNO',\n",
" 'PARCELID',\n",
" 'STATE',\n",
" 'MAP',\n",
" 'NUM',\n",
" 'MAPNUM',\n",
" 'STATUS',\n",
" 'STAT_DESC',\n",
" 'PURPOSE',\n",
" 'PURP_DESC',\n",
" 'PURPOSE2',\n",
" 'PURP2_DESC',\n",
" 'PURPOSE3',\n",
" 'PURP3_DESC',\n",
" 'ANALFULL',\n",
" 'PH',\n",
" 'TDS',\n",
" 'TDSDATE',\n",
" 'YIELD',\n",
" 'YIELD_DATE',\n",
" 'WATER_CUT',\n",
" 'DTW',\n",
" 'SWL',\n",
" 'SWLDATE',\n",
" 'DRILL_DATE',\n",
" 'LAT_DEPTH',\n",
" 'ORIG_DEPTH',\n",
" 'MAX_DEPTH',\n",
" 'PERMIT_NO',\n",
" 'PERMIT_EX',\n",
" 'LOGGEOPHYS',\n",
" 'LOGDRILL',\n",
" 'LOGGEOL',\n",
" 'LOGSTRAT',\n",
" 'LOGHYDROSTRAT',\n",
" 'LOGGER_DATA',\n",
" 'TELEMETRY_DATA',\n",
" 'OBSHUND',\n",
" 'OBSSEQ',\n",
" 'OBSNUMBER',\n",
" 'CLASS',\n",
" 'WW_CLASS',\n",
" 'PRIVATE',\n",
" 'EC',\n",
" 'RSWL',\n",
" 'AQ_MON',\n",
" 'PHOTO',\n",
" 'OWNER_CODE',\n",
" 'STATE_ASSET',\n",
" 'AQ_MONDESC',\n",
" 'SUBURB',\n",
" 'LGA',\n",
" 'HUNDRED',\n",
" 'SW_CATCHMENT',\n",
" 'LANDSCAPESA_CODE',\n",
" 'NRM_REGION_CODE',\n",
" 'PRESCRIBED_WELL_AREA',\n",
" 'PRESC_WATER_RES_AREA',\n",
" 'CASE_TO',\n",
" 'MIN_DIAM',\n",
" 'TITLE_PREFIX',\n",
" 'TITLE_VOLUME',\n",
" 'TITLE_FOLIO',\n",
" 'TITLE_ID',\n",
" 'GRND_ELEV_DEM',\n",
" 'HGUID',\n",
" 'FTYPE',\n",
" 'NGIS',\n",
" 'LATEST_REF_POINT_TYP']\n"
]
}
],
"source": [
"from pprint import pprint\n",
"pprint(list(sa_gwdata.cache.dh_layer.columns))"
]
},
{
"cell_type": "code",
"execution_count": 12,
"id": "f57bba1a",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"WindowsPath('C:/Users/KINVERARITY/AppData/Local/sa_gwdata/sa_gwdata/drillholes_2023-10-31.feather')"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sa_gwdata.cache.dh_layer_path"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "5c422905",
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3 (ipykernel)",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.10.10"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment