data_extraction_xr_example.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "fef7edd4-dbef-49aa-b894-89473d661048",
   "metadata": {},
   "outputs": [],
   "source": [
    "import xarray as xr\n",
    "from glob import glob\n",
    "import pandas as pd\n",
    "import geopandas as gpd\n",
    "import cartopy.crs as ccrs\n",
    "import intake\n",
    "import regionmask\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "137b644e-e4a2-41bc-99d1-187fa6bded5f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<p><strong>nci-acs_bias_corrected catalog with 5890 dataset(s) from 72002 asset(s)</strong>:</p> <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>unique</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>institution_id</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>variable_id</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>table_id</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>source_id</th>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>downscaling_model</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>experiment_id</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>member_id</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>grid_label</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bias_adjustment</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>time_range</th>\n",
       "      <td>141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>path</th>\n",
       "      <td>72002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>derived_variable_id</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# see /g/data/mn51/users/gt3409/TimeSeriesExtraction/acs_catalogue_data.ipynb for building the catalogue\n",
    "# This is a catalogue for ACS bias adjust data in \n",
    "# /g/data/ia39/australian-climate-service/test-data/CORDEX-CMIP6/bias-adjustment-output/AGCD-05i\n",
    "col = intake.open_esm_datastore(f\"/g/data/mn51/users/gt3409/nci-acs_bias_corrected.json\")\n",
    "col"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "80d80918-59f3-4a72-9e06-ae1ddf6f6b74",
   "metadata": {
    "scrolled": true
   },
   "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>institution_id</th>\n",
       "      <th>variable_id</th>\n",
       "      <th>table_id</th>\n",
       "      <th>source_id</th>\n",
       "      <th>downscaling_model</th>\n",
       "      <th>experiment_id</th>\n",
       "      <th>member_id</th>\n",
       "      <th>grid_label</th>\n",
       "      <th>bias_adjustment</th>\n",
       "      <th>time_range</th>\n",
       "      <th>path</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BOM</td>\n",
       "      <td>tasmaxAdjust</td>\n",
       "      <td>day</td>\n",
       "      <td>ACCESS-CM2</td>\n",
       "      <td>BARPA-R</td>\n",
       "      <td>historical</td>\n",
       "      <td>r4i1p1f1</td>\n",
       "      <td>AGCD-05i</td>\n",
       "      <td>v1-r1-ACS-QME-AGCD-1960-2022</td>\n",
       "      <td>19600101-19601231</td>\n",
       "      <td>/g/data/ia39/australian-climate-service/test-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BOM</td>\n",
       "      <td>tasmaxAdjust</td>\n",
       "      <td>day</td>\n",
       "      <td>ACCESS-CM2</td>\n",
       "      <td>BARPA-R</td>\n",
       "      <td>historical</td>\n",
       "      <td>r4i1p1f1</td>\n",
       "      <td>AGCD-05i</td>\n",
       "      <td>v1-r1-ACS-QME-AGCD-1960-2022</td>\n",
       "      <td>19610101-19611231</td>\n",
       "      <td>/g/data/ia39/australian-climate-service/test-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BOM</td>\n",
       "      <td>tasmaxAdjust</td>\n",
       "      <td>day</td>\n",
       "      <td>ACCESS-CM2</td>\n",
       "      <td>BARPA-R</td>\n",
       "      <td>historical</td>\n",
       "      <td>r4i1p1f1</td>\n",
       "      <td>AGCD-05i</td>\n",
       "      <td>v1-r1-ACS-QME-AGCD-1960-2022</td>\n",
       "      <td>19620101-19621231</td>\n",
       "      <td>/g/data/ia39/australian-climate-service/test-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BOM</td>\n",
       "      <td>tasmaxAdjust</td>\n",
       "      <td>day</td>\n",
       "      <td>ACCESS-CM2</td>\n",
       "      <td>BARPA-R</td>\n",
       "      <td>historical</td>\n",
       "      <td>r4i1p1f1</td>\n",
       "      <td>AGCD-05i</td>\n",
       "      <td>v1-r1-ACS-QME-AGCD-1960-2022</td>\n",
       "      <td>19630101-19631231</td>\n",
       "      <td>/g/data/ia39/australian-climate-service/test-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BOM</td>\n",
       "      <td>tasmaxAdjust</td>\n",
       "      <td>day</td>\n",
       "      <td>ACCESS-CM2</td>\n",
       "      <td>BARPA-R</td>\n",
       "      <td>historical</td>\n",
       "      <td>r4i1p1f1</td>\n",
       "      <td>AGCD-05i</td>\n",
       "      <td>v1-r1-ACS-QME-AGCD-1960-2022</td>\n",
       "      <td>19640101-19641231</td>\n",
       "      <td>/g/data/ia39/australian-climate-service/test-d...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1822</th>\n",
       "      <td>CSIRO</td>\n",
       "      <td>tasmaxAdjust</td>\n",
       "      <td>day</td>\n",
       "      <td>EC-Earth3</td>\n",
       "      <td>CCAM-v2203-SN</td>\n",
       "      <td>ssp370</td>\n",
       "      <td>r1i1p1f1</td>\n",
       "      <td>AGCD-05i</td>\n",
       "      <td>v1-r1-ACS-QME-AGCD-1960-2022</td>\n",
       "      <td>20950101-20951231</td>\n",
       "      <td>/g/data/ia39/australian-climate-service/test-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1823</th>\n",
       "      <td>CSIRO</td>\n",
       "      <td>tasmaxAdjust</td>\n",
       "      <td>day</td>\n",
       "      <td>EC-Earth3</td>\n",
       "      <td>CCAM-v2203-SN</td>\n",
       "      <td>ssp370</td>\n",
       "      <td>r1i1p1f1</td>\n",
       "      <td>AGCD-05i</td>\n",
       "      <td>v1-r1-ACS-QME-AGCD-1960-2022</td>\n",
       "      <td>20960101-20961231</td>\n",
       "      <td>/g/data/ia39/australian-climate-service/test-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1824</th>\n",
       "      <td>CSIRO</td>\n",
       "      <td>tasmaxAdjust</td>\n",
       "      <td>day</td>\n",
       "      <td>EC-Earth3</td>\n",
       "      <td>CCAM-v2203-SN</td>\n",
       "      <td>ssp370</td>\n",
       "      <td>r1i1p1f1</td>\n",
       "      <td>AGCD-05i</td>\n",
       "      <td>v1-r1-ACS-QME-AGCD-1960-2022</td>\n",
       "      <td>20970101-20971231</td>\n",
       "      <td>/g/data/ia39/australian-climate-service/test-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1825</th>\n",
       "      <td>CSIRO</td>\n",
       "      <td>tasmaxAdjust</td>\n",
       "      <td>day</td>\n",
       "      <td>EC-Earth3</td>\n",
       "      <td>CCAM-v2203-SN</td>\n",
       "      <td>ssp370</td>\n",
       "      <td>r1i1p1f1</td>\n",
       "      <td>AGCD-05i</td>\n",
       "      <td>v1-r1-ACS-QME-AGCD-1960-2022</td>\n",
       "      <td>20980101-20981231</td>\n",
       "      <td>/g/data/ia39/australian-climate-service/test-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1826</th>\n",
       "      <td>CSIRO</td>\n",
       "      <td>tasmaxAdjust</td>\n",
       "      <td>day</td>\n",
       "      <td>EC-Earth3</td>\n",
       "      <td>CCAM-v2203-SN</td>\n",
       "      <td>ssp370</td>\n",
       "      <td>r1i1p1f1</td>\n",
       "      <td>AGCD-05i</td>\n",
       "      <td>v1-r1-ACS-QME-AGCD-1960-2022</td>\n",
       "      <td>20990101-20991231</td>\n",
       "      <td>/g/data/ia39/australian-climate-service/test-d...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1827 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     institution_id   variable_id table_id   source_id downscaling_model  \\\n",
       "0               BOM  tasmaxAdjust      day  ACCESS-CM2           BARPA-R   \n",
       "1               BOM  tasmaxAdjust      day  ACCESS-CM2           BARPA-R   \n",
       "2               BOM  tasmaxAdjust      day  ACCESS-CM2           BARPA-R   \n",
       "3               BOM  tasmaxAdjust      day  ACCESS-CM2           BARPA-R   \n",
       "4               BOM  tasmaxAdjust      day  ACCESS-CM2           BARPA-R   \n",
       "...             ...           ...      ...         ...               ...   \n",
       "1822          CSIRO  tasmaxAdjust      day   EC-Earth3     CCAM-v2203-SN   \n",
       "1823          CSIRO  tasmaxAdjust      day   EC-Earth3     CCAM-v2203-SN   \n",
       "1824          CSIRO  tasmaxAdjust      day   EC-Earth3     CCAM-v2203-SN   \n",
       "1825          CSIRO  tasmaxAdjust      day   EC-Earth3     CCAM-v2203-SN   \n",
       "1826          CSIRO  tasmaxAdjust      day   EC-Earth3     CCAM-v2203-SN   \n",
       "\n",
       "     experiment_id member_id grid_label               bias_adjustment  \\\n",
       "0       historical  r4i1p1f1   AGCD-05i  v1-r1-ACS-QME-AGCD-1960-2022   \n",
       "1       historical  r4i1p1f1   AGCD-05i  v1-r1-ACS-QME-AGCD-1960-2022   \n",
       "2       historical  r4i1p1f1   AGCD-05i  v1-r1-ACS-QME-AGCD-1960-2022   \n",
       "3       historical  r4i1p1f1   AGCD-05i  v1-r1-ACS-QME-AGCD-1960-2022   \n",
       "4       historical  r4i1p1f1   AGCD-05i  v1-r1-ACS-QME-AGCD-1960-2022   \n",
       "...            ...       ...        ...                           ...   \n",
       "1822        ssp370  r1i1p1f1   AGCD-05i  v1-r1-ACS-QME-AGCD-1960-2022   \n",
       "1823        ssp370  r1i1p1f1   AGCD-05i  v1-r1-ACS-QME-AGCD-1960-2022   \n",
       "1824        ssp370  r1i1p1f1   AGCD-05i  v1-r1-ACS-QME-AGCD-1960-2022   \n",
       "1825        ssp370  r1i1p1f1   AGCD-05i  v1-r1-ACS-QME-AGCD-1960-2022   \n",
       "1826        ssp370  r1i1p1f1   AGCD-05i  v1-r1-ACS-QME-AGCD-1960-2022   \n",
       "\n",
       "             time_range                                               path  \n",
       "0     19600101-19601231  /g/data/ia39/australian-climate-service/test-d...  \n",
       "1     19610101-19611231  /g/data/ia39/australian-climate-service/test-d...  \n",
       "2     19620101-19621231  /g/data/ia39/australian-climate-service/test-d...  \n",
       "3     19630101-19631231  /g/data/ia39/australian-climate-service/test-d...  \n",
       "4     19640101-19641231  /g/data/ia39/australian-climate-service/test-d...  \n",
       "...                 ...                                                ...  \n",
       "1822  20950101-20951231  /g/data/ia39/australian-climate-service/test-d...  \n",
       "1823  20960101-20961231  /g/data/ia39/australian-climate-service/test-d...  \n",
       "1824  20970101-20971231  /g/data/ia39/australian-climate-service/test-d...  \n",
       "1825  20980101-20981231  /g/data/ia39/australian-climate-service/test-d...  \n",
       "1826  20990101-20991231  /g/data/ia39/australian-climate-service/test-d...  \n",
       "\n",
       "[1827 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# select the relevant data\n",
    "variable_id = \"tasmaxAdjust\"\n",
    "table_id= \"day\"\n",
    "experiment_id = [\"historical\", \"ssp370\"]\n",
    "bias_adjustment = \"v1-r1-ACS-QME-AGCD-1960-2022\"\n",
    "domain = \"AGCD-05i\"\n",
    "downscaling_model = [\"CCAM-v2203-SN\",\"BARPA-R\"]\n",
    "\n",
    "cat = col.search(variable_id = variable_id,\n",
    "                 table_id= table_id,\n",
    "                 experiment_id = experiment_id, \n",
    "                 bias_adjustment = bias_adjustment,\n",
    "                grid_label=domain,\n",
    "                downscaling_model=downscaling_model,\n",
    "                )\n",
    "cat.df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "8962d5e8-f02a-4690-afe1-55608baaec81",
   "metadata": {},
   "outputs": [],
   "source": [
    "# get a list of the unique [\"institution_id\", \"source_id\", \"downscaling_model\", \"member_id\",] combinations\n",
    "_list = list(cat.df.groupby([\"institution_id\", \"source_id\", \"downscaling_model\", \"member_id\",])\n",
    "             .size()\n",
    "             .reset_index()[[\"institution_id\", \"source_id\", \"downscaling_model\", \"member_id\",]]\n",
    "             .itertuples(index=False, name=None))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "90242f70-fd56-41dc-9902-4fc9d6071104",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('BOM', 'ACCESS-CM2', 'BARPA-R', 'r4i1p1f1'),\n",
       " ('BOM', 'ACCESS-ESM1-5', 'BARPA-R', 'r6i1p1f1'),\n",
       " ('BOM', 'CESM2', 'BARPA-R', 'r11i1p1f1'),\n",
       " ('BOM', 'CMCC-ESM2', 'BARPA-R', 'r1i1p1f1'),\n",
       " ('BOM', 'EC-Earth3', 'BARPA-R', 'r1i1p1f1'),\n",
       " ('BOM', 'MPI-ESM1-2-HR', 'BARPA-R', 'r1i1p1f1'),\n",
       " ('BOM', 'NorESM2-MM', 'BARPA-R', 'r1i1p1f1'),\n",
       " ('CSIRO', 'ACCESS-CM2', 'CCAM-v2203-SN', 'r4i1p1f1'),\n",
       " ('CSIRO', 'ACCESS-ESM1-5', 'CCAM-v2203-SN', 'r6i1p1f1'),\n",
       " ('CSIRO', 'CESM2', 'CCAM-v2203-SN', 'r11i1p1f1'),\n",
       " ('CSIRO', 'CMCC-ESM2', 'CCAM-v2203-SN', 'r1i1p1f1'),\n",
       " ('CSIRO', 'CNRM-ESM2-1', 'CCAM-v2203-SN', 'r1i1p1f2'),\n",
       " ('CSIRO', 'EC-Earth3', 'CCAM-v2203-SN', 'r1i1p1f1')]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "15185acb-7cb7-4225-a575-f438265da84e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'BOM,ACCESS-CM2,BARPA-R,r4i1p1f1 BOM,ACCESS-ESM1-5,BARPA-R,r6i1p1f1 BOM,CESM2,BARPA-R,r11i1p1f1 BOM,CMCC-ESM2,BARPA-R,r1i1p1f1 BOM,EC-Earth3,BARPA-R,r1i1p1f1 BOM,MPI-ESM1-2-HR,BARPA-R,r1i1p1f1 BOM,NorESM2-MM,BARPA-R,r1i1p1f1 CSIRO,ACCESS-CM2,CCAM-v2203-SN,r4i1p1f1 CSIRO,ACCESS-ESM1-5,CCAM-v2203-SN,r6i1p1f1 CSIRO,CESM2,CCAM-v2203-SN,r11i1p1f1 CSIRO,CMCC-ESM2,CCAM-v2203-SN,r1i1p1f1 CSIRO,CNRM-ESM2-1,CCAM-v2203-SN,r1i1p1f2 CSIRO,EC-Earth3,CCAM-v2203-SN,r1i1p1f1'"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# rewrite the list in a way that bash can read\n",
    "str(_list).replace(\" \",\"\").replace(\"(\",\"\").replace(\"),\",\" \").replace(\"[\",\"\").replace(\"]\",\"\").replace(\")\", \"\").replace(\"'\", \"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e65dda78-9e53-408a-84ae-d2fca1cc20c7",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "51047719-0a8c-4827-826a-9a60bf67987c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "0c3aa63f-8755-4380-8c9f-210c0a05e142",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Below is an example of how you could access the data using xarray.\n",
    "# This is suitable for small numbers of files but was not used for the data extraction"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "d21fa7d0-e0f1-4b49-9352-8a97da5dba59",
   "metadata": {
    "scrolled": true
   },
   "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>OBJECTID</th>\n",
       "      <th>UCL_CODE21</th>\n",
       "      <th>UCL_NAME21</th>\n",
       "      <th>SSR_CODE21</th>\n",
       "      <th>SSR_NAME21</th>\n",
       "      <th>SOS_CODE21</th>\n",
       "      <th>SOS_NAME21</th>\n",
       "      <th>STE_CODE21</th>\n",
       "      <th>STE_NAME21</th>\n",
       "      <th>AUS_CODE21</th>\n",
       "      <th>AUS_NAME21</th>\n",
       "      <th>AREASQKM21</th>\n",
       "      <th>LOCI_URI21</th>\n",
       "      <th>ORIG_FID</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>101001</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>101</td>\n",
       "      <td>1 million or more</td>\n",
       "      <td>10</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>1</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>2194.1731</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>0</td>\n",
       "      <td>150.966927</td>\n",
       "      <td>-33.841693</td>\n",
       "      <td>POINT (150.967 -33.842)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>102001</td>\n",
       "      <td>Canberra - Queanbeyan (Queanbeyan Part)</td>\n",
       "      <td>102</td>\n",
       "      <td>250,000 to 999,999</td>\n",
       "      <td>10</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>1</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>28.7867</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>1</td>\n",
       "      <td>149.220229</td>\n",
       "      <td>-35.366418</td>\n",
       "      <td>POINT (149.220 -35.366)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>102002</td>\n",
       "      <td>Central Coast</td>\n",
       "      <td>102</td>\n",
       "      <td>250,000 to 999,999</td>\n",
       "      <td>10</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>1</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>332.9065</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>2</td>\n",
       "      <td>151.428768</td>\n",
       "      <td>-33.366007</td>\n",
       "      <td>POINT (151.429 -33.366)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>102003</td>\n",
       "      <td>Gold Coast - Tweed Heads (Tweed Heads Part)</td>\n",
       "      <td>102</td>\n",
       "      <td>250,000 to 999,999</td>\n",
       "      <td>10</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>1</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>67.6780</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>3</td>\n",
       "      <td>153.529595</td>\n",
       "      <td>-28.222369</td>\n",
       "      <td>POINT (153.530 -28.222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>102004</td>\n",
       "      <td>Newcastle</td>\n",
       "      <td>102</td>\n",
       "      <td>250,000 to 999,999</td>\n",
       "      <td>10</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>1</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>296.9898</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>4</td>\n",
       "      <td>151.677235</td>\n",
       "      <td>-32.950991</td>\n",
       "      <td>POINT (151.677 -32.951)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>102005</td>\n",
       "      <td>Wollongong</td>\n",
       "      <td>102</td>\n",
       "      <td>250,000 to 999,999</td>\n",
       "      <td>10</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>1</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>224.4836</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>5</td>\n",
       "      <td>150.846046</td>\n",
       "      <td>-34.471490</td>\n",
       "      <td>POINT (150.846 -34.471)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>111001</td>\n",
       "      <td>Albury - Wodonga (Albury Part)</td>\n",
       "      <td>111</td>\n",
       "      <td>50,000 to 99,999</td>\n",
       "      <td>11</td>\n",
       "      <td>Other Urban</td>\n",
       "      <td>1</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>74.9112</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>6</td>\n",
       "      <td>146.948827</td>\n",
       "      <td>-36.050311</td>\n",
       "      <td>POINT (146.949 -36.050)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>111002</td>\n",
       "      <td>Coffs Harbour</td>\n",
       "      <td>111</td>\n",
       "      <td>50,000 to 99,999</td>\n",
       "      <td>11</td>\n",
       "      <td>Other Urban</td>\n",
       "      <td>1</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>77.9672</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>7</td>\n",
       "      <td>153.095738</td>\n",
       "      <td>-30.312298</td>\n",
       "      <td>POINT (153.096 -30.312)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>111003</td>\n",
       "      <td>Maitland (NSW)</td>\n",
       "      <td>111</td>\n",
       "      <td>50,000 to 99,999</td>\n",
       "      <td>11</td>\n",
       "      <td>Other Urban</td>\n",
       "      <td>1</td>\n",
       "      <td>New South Wales</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>122.9001</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>8</td>\n",
       "      <td>151.587175</td>\n",
       "      <td>-32.750090</td>\n",
       "      <td>POINT (151.587 -32.750)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>537</td>\n",
       "      <td>201001</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>201</td>\n",
       "      <td>1 million or more</td>\n",
       "      <td>20</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>2</td>\n",
       "      <td>Victoria</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>2880.5725</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>538</td>\n",
       "      <td>145.077024</td>\n",
       "      <td>-37.892538</td>\n",
       "      <td>POINT (145.077 -37.893)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>538</td>\n",
       "      <td>203001</td>\n",
       "      <td>Ballarat</td>\n",
       "      <td>203</td>\n",
       "      <td>100,000 to 249,999</td>\n",
       "      <td>20</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>2</td>\n",
       "      <td>Victoria</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>132.2364</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>539</td>\n",
       "      <td>143.841720</td>\n",
       "      <td>-37.566501</td>\n",
       "      <td>POINT (143.842 -37.567)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>539</td>\n",
       "      <td>203002</td>\n",
       "      <td>Bendigo</td>\n",
       "      <td>203</td>\n",
       "      <td>100,000 to 249,999</td>\n",
       "      <td>20</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>2</td>\n",
       "      <td>Victoria</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>162.3864</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>540</td>\n",
       "      <td>144.285135</td>\n",
       "      <td>-36.756690</td>\n",
       "      <td>POINT (144.285 -36.757)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>540</td>\n",
       "      <td>203003</td>\n",
       "      <td>Geelong</td>\n",
       "      <td>203</td>\n",
       "      <td>100,000 to 249,999</td>\n",
       "      <td>20</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>2</td>\n",
       "      <td>Victoria</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>165.5844</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>541</td>\n",
       "      <td>144.357335</td>\n",
       "      <td>-38.165738</td>\n",
       "      <td>POINT (144.357 -38.166)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>541</td>\n",
       "      <td>211001</td>\n",
       "      <td>Albury - Wodonga (Wodonga Part)</td>\n",
       "      <td>211</td>\n",
       "      <td>50,000 to 99,999</td>\n",
       "      <td>21</td>\n",
       "      <td>Other Urban</td>\n",
       "      <td>2</td>\n",
       "      <td>Victoria</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>54.1941</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>542</td>\n",
       "      <td>146.882313</td>\n",
       "      <td>-36.122450</td>\n",
       "      <td>POINT (146.882 -36.122)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>542</td>\n",
       "      <td>211002</td>\n",
       "      <td>Melton</td>\n",
       "      <td>211</td>\n",
       "      <td>50,000 to 99,999</td>\n",
       "      <td>21</td>\n",
       "      <td>Other Urban</td>\n",
       "      <td>2</td>\n",
       "      <td>Victoria</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>57.1001</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>543</td>\n",
       "      <td>144.580835</td>\n",
       "      <td>-37.694019</td>\n",
       "      <td>POINT (144.581 -37.694)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>882</td>\n",
       "      <td>301001</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>301</td>\n",
       "      <td>1 million or more</td>\n",
       "      <td>30</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>3</td>\n",
       "      <td>Queensland</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>2026.9222</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>885</td>\n",
       "      <td>153.012016</td>\n",
       "      <td>-27.474843</td>\n",
       "      <td>POINT (153.012 -27.475)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>883</td>\n",
       "      <td>302001</td>\n",
       "      <td>Gold Coast - Tweed Heads (Gold Coast Part)</td>\n",
       "      <td>302</td>\n",
       "      <td>250,000 to 999,999</td>\n",
       "      <td>30</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>3</td>\n",
       "      <td>Queensland</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>552.7077</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>886</td>\n",
       "      <td>153.350817</td>\n",
       "      <td>-27.971991</td>\n",
       "      <td>POINT (153.351 -27.972)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>884</td>\n",
       "      <td>302002</td>\n",
       "      <td>Sunshine Coast</td>\n",
       "      <td>302</td>\n",
       "      <td>250,000 to 999,999</td>\n",
       "      <td>30</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>3</td>\n",
       "      <td>Queensland</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>368.7256</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>887</td>\n",
       "      <td>153.069216</td>\n",
       "      <td>-26.618301</td>\n",
       "      <td>POINT (153.069 -26.618)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>885</td>\n",
       "      <td>303001</td>\n",
       "      <td>Cairns</td>\n",
       "      <td>303</td>\n",
       "      <td>100,000 to 249,999</td>\n",
       "      <td>30</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>3</td>\n",
       "      <td>Queensland</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>198.5773</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>888</td>\n",
       "      <td>145.720768</td>\n",
       "      <td>-16.897858</td>\n",
       "      <td>POINT (145.721 -16.898)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>886</td>\n",
       "      <td>303002</td>\n",
       "      <td>Toowoomba</td>\n",
       "      <td>303</td>\n",
       "      <td>100,000 to 249,999</td>\n",
       "      <td>30</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>3</td>\n",
       "      <td>Queensland</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>119.9124</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>889</td>\n",
       "      <td>151.930438</td>\n",
       "      <td>-27.567502</td>\n",
       "      <td>POINT (151.930 -27.568)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>887</td>\n",
       "      <td>303003</td>\n",
       "      <td>Townsville</td>\n",
       "      <td>303</td>\n",
       "      <td>100,000 to 249,999</td>\n",
       "      <td>30</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>3</td>\n",
       "      <td>Queensland</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>265.9586</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>890</td>\n",
       "      <td>146.746791</td>\n",
       "      <td>-19.275347</td>\n",
       "      <td>POINT (146.747 -19.275)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>888</td>\n",
       "      <td>311001</td>\n",
       "      <td>Bundaberg</td>\n",
       "      <td>311</td>\n",
       "      <td>50,000 to 99,999</td>\n",
       "      <td>31</td>\n",
       "      <td>Other Urban</td>\n",
       "      <td>3</td>\n",
       "      <td>Queensland</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>104.3933</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>891</td>\n",
       "      <td>152.323193</td>\n",
       "      <td>-24.889083</td>\n",
       "      <td>POINT (152.323 -24.889)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>889</td>\n",
       "      <td>311002</td>\n",
       "      <td>Hervey Bay</td>\n",
       "      <td>311</td>\n",
       "      <td>50,000 to 99,999</td>\n",
       "      <td>31</td>\n",
       "      <td>Other Urban</td>\n",
       "      <td>3</td>\n",
       "      <td>Queensland</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>93.2156</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>892</td>\n",
       "      <td>152.812982</td>\n",
       "      <td>-25.291663</td>\n",
       "      <td>POINT (152.813 -25.292)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>890</td>\n",
       "      <td>311003</td>\n",
       "      <td>Mackay</td>\n",
       "      <td>311</td>\n",
       "      <td>50,000 to 99,999</td>\n",
       "      <td>31</td>\n",
       "      <td>Other Urban</td>\n",
       "      <td>3</td>\n",
       "      <td>Queensland</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>135.9538</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>893</td>\n",
       "      <td>149.174989</td>\n",
       "      <td>-21.102768</td>\n",
       "      <td>POINT (149.175 -21.103)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>891</td>\n",
       "      <td>311004</td>\n",
       "      <td>Rockhampton</td>\n",
       "      <td>311</td>\n",
       "      <td>50,000 to 99,999</td>\n",
       "      <td>31</td>\n",
       "      <td>Other Urban</td>\n",
       "      <td>3</td>\n",
       "      <td>Queensland</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>95.7052</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>894</td>\n",
       "      <td>150.514241</td>\n",
       "      <td>-23.345406</td>\n",
       "      <td>POINT (150.514 -23.345)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1294</td>\n",
       "      <td>401001</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>401</td>\n",
       "      <td>1 million or more</td>\n",
       "      <td>40</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>4</td>\n",
       "      <td>South Australia</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>854.2792</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>1299</td>\n",
       "      <td>138.588522</td>\n",
       "      <td>-34.920566</td>\n",
       "      <td>POINT (138.589 -34.921)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1466</td>\n",
       "      <td>501001</td>\n",
       "      <td>Perth (WA)</td>\n",
       "      <td>501</td>\n",
       "      <td>1 million or more</td>\n",
       "      <td>50</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>5</td>\n",
       "      <td>Western Australia</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>1720.3492</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>1473</td>\n",
       "      <td>115.872263</td>\n",
       "      <td>-32.039347</td>\n",
       "      <td>POINT (115.872 -32.039)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1467</td>\n",
       "      <td>511001</td>\n",
       "      <td>Bunbury</td>\n",
       "      <td>511</td>\n",
       "      <td>50,000 to 99,999</td>\n",
       "      <td>51</td>\n",
       "      <td>Other Urban</td>\n",
       "      <td>5</td>\n",
       "      <td>Western Australia</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>117.4000</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>1474</td>\n",
       "      <td>115.675630</td>\n",
       "      <td>-33.339038</td>\n",
       "      <td>POINT (115.676 -33.339)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1643</td>\n",
       "      <td>603001</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>603</td>\n",
       "      <td>100,000 to 249,999</td>\n",
       "      <td>60</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>6</td>\n",
       "      <td>Tasmania</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>237.2630</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>1652</td>\n",
       "      <td>147.349023</td>\n",
       "      <td>-42.846533</td>\n",
       "      <td>POINT (147.349 -42.847)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1644</td>\n",
       "      <td>611001</td>\n",
       "      <td>Launceston</td>\n",
       "      <td>611</td>\n",
       "      <td>50,000 to 99,999</td>\n",
       "      <td>61</td>\n",
       "      <td>Other Urban</td>\n",
       "      <td>6</td>\n",
       "      <td>Tasmania</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>95.1084</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>1653</td>\n",
       "      <td>147.137158</td>\n",
       "      <td>-41.439813</td>\n",
       "      <td>POINT (147.137 -41.440)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1738</td>\n",
       "      <td>703001</td>\n",
       "      <td>Darwin</td>\n",
       "      <td>703</td>\n",
       "      <td>100,000 to 249,999</td>\n",
       "      <td>70</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>7</td>\n",
       "      <td>Northern Territory</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>240.3244</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>1749</td>\n",
       "      <td>130.934203</td>\n",
       "      <td>-12.443588</td>\n",
       "      <td>POINT (130.934 -12.444)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1809</td>\n",
       "      <td>802001</td>\n",
       "      <td>Canberra - Queanbeyan (Canberra Part)</td>\n",
       "      <td>802</td>\n",
       "      <td>250,000 to 999,999</td>\n",
       "      <td>80</td>\n",
       "      <td>Major Urban</td>\n",
       "      <td>8</td>\n",
       "      <td>Australian Capital Territory</td>\n",
       "      <td>AUS</td>\n",
       "      <td>Australia</td>\n",
       "      <td>392.9671</td>\n",
       "      <td>https://linked.data.gov.au/dataset/asgsed3/UCL...</td>\n",
       "      <td>1822</td>\n",
       "      <td>149.106653</td>\n",
       "      <td>-35.302779</td>\n",
       "      <td>POINT (149.107 -35.303)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    OBJECTID  UCL_CODE21                                   UCL_NAME21  \\\n",
       "0          1      101001                                       Sydney   \n",
       "1          2      102001      Canberra - Queanbeyan (Queanbeyan Part)   \n",
       "2          3      102002                                Central Coast   \n",
       "3          4      102003  Gold Coast - Tweed Heads (Tweed Heads Part)   \n",
       "4          5      102004                                    Newcastle   \n",
       "5          6      102005                                   Wollongong   \n",
       "6          7      111001               Albury - Wodonga (Albury Part)   \n",
       "7          8      111002                                Coffs Harbour   \n",
       "8          9      111003                               Maitland (NSW)   \n",
       "9        537      201001                                    Melbourne   \n",
       "10       538      203001                                     Ballarat   \n",
       "11       539      203002                                      Bendigo   \n",
       "12       540      203003                                      Geelong   \n",
       "13       541      211001              Albury - Wodonga (Wodonga Part)   \n",
       "14       542      211002                                       Melton   \n",
       "15       882      301001                                     Brisbane   \n",
       "16       883      302001   Gold Coast - Tweed Heads (Gold Coast Part)   \n",
       "17       884      302002                               Sunshine Coast   \n",
       "18       885      303001                                       Cairns   \n",
       "19       886      303002                                    Toowoomba   \n",
       "20       887      303003                                   Townsville   \n",
       "21       888      311001                                    Bundaberg   \n",
       "22       889      311002                                   Hervey Bay   \n",
       "23       890      311003                                       Mackay   \n",
       "24       891      311004                                  Rockhampton   \n",
       "25      1294      401001                                     Adelaide   \n",
       "26      1466      501001                                   Perth (WA)   \n",
       "27      1467      511001                                      Bunbury   \n",
       "28      1643      603001                                       Hobart   \n",
       "29      1644      611001                                   Launceston   \n",
       "30      1738      703001                                       Darwin   \n",
       "31      1809      802001        Canberra - Queanbeyan (Canberra Part)   \n",
       "\n",
       "    SSR_CODE21          SSR_NAME21  SOS_CODE21   SOS_NAME21  STE_CODE21  \\\n",
       "0          101   1 million or more          10  Major Urban           1   \n",
       "1          102  250,000 to 999,999          10  Major Urban           1   \n",
       "2          102  250,000 to 999,999          10  Major Urban           1   \n",
       "3          102  250,000 to 999,999          10  Major Urban           1   \n",
       "4          102  250,000 to 999,999          10  Major Urban           1   \n",
       "5          102  250,000 to 999,999          10  Major Urban           1   \n",
       "6          111    50,000 to 99,999          11  Other Urban           1   \n",
       "7          111    50,000 to 99,999          11  Other Urban           1   \n",
       "8          111    50,000 to 99,999          11  Other Urban           1   \n",
       "9          201   1 million or more          20  Major Urban           2   \n",
       "10         203  100,000 to 249,999          20  Major Urban           2   \n",
       "11         203  100,000 to 249,999          20  Major Urban           2   \n",
       "12         203  100,000 to 249,999          20  Major Urban           2   \n",
       "13         211    50,000 to 99,999          21  Other Urban           2   \n",
       "14         211    50,000 to 99,999          21  Other Urban           2   \n",
       "15         301   1 million or more          30  Major Urban           3   \n",
       "16         302  250,000 to 999,999          30  Major Urban           3   \n",
       "17         302  250,000 to 999,999          30  Major Urban           3   \n",
       "18         303  100,000 to 249,999          30  Major Urban           3   \n",
       "19         303  100,000 to 249,999          30  Major Urban           3   \n",
       "20         303  100,000 to 249,999          30  Major Urban           3   \n",
       "21         311    50,000 to 99,999          31  Other Urban           3   \n",
       "22         311    50,000 to 99,999          31  Other Urban           3   \n",
       "23         311    50,000 to 99,999          31  Other Urban           3   \n",
       "24         311    50,000 to 99,999          31  Other Urban           3   \n",
       "25         401   1 million or more          40  Major Urban           4   \n",
       "26         501   1 million or more          50  Major Urban           5   \n",
       "27         511    50,000 to 99,999          51  Other Urban           5   \n",
       "28         603  100,000 to 249,999          60  Major Urban           6   \n",
       "29         611    50,000 to 99,999          61  Other Urban           6   \n",
       "30         703  100,000 to 249,999          70  Major Urban           7   \n",
       "31         802  250,000 to 999,999          80  Major Urban           8   \n",
       "\n",
       "                      STE_NAME21 AUS_CODE21 AUS_NAME21  AREASQKM21  \\\n",
       "0                New South Wales        AUS  Australia   2194.1731   \n",
       "1                New South Wales        AUS  Australia     28.7867   \n",
       "2                New South Wales        AUS  Australia    332.9065   \n",
       "3                New South Wales        AUS  Australia     67.6780   \n",
       "4                New South Wales        AUS  Australia    296.9898   \n",
       "5                New South Wales        AUS  Australia    224.4836   \n",
       "6                New South Wales        AUS  Australia     74.9112   \n",
       "7                New South Wales        AUS  Australia     77.9672   \n",
       "8                New South Wales        AUS  Australia    122.9001   \n",
       "9                       Victoria        AUS  Australia   2880.5725   \n",
       "10                      Victoria        AUS  Australia    132.2364   \n",
       "11                      Victoria        AUS  Australia    162.3864   \n",
       "12                      Victoria        AUS  Australia    165.5844   \n",
       "13                      Victoria        AUS  Australia     54.1941   \n",
       "14                      Victoria        AUS  Australia     57.1001   \n",
       "15                    Queensland        AUS  Australia   2026.9222   \n",
       "16                    Queensland        AUS  Australia    552.7077   \n",
       "17                    Queensland        AUS  Australia    368.7256   \n",
       "18                    Queensland        AUS  Australia    198.5773   \n",
       "19                    Queensland        AUS  Australia    119.9124   \n",
       "20                    Queensland        AUS  Australia    265.9586   \n",
       "21                    Queensland        AUS  Australia    104.3933   \n",
       "22                    Queensland        AUS  Australia     93.2156   \n",
       "23                    Queensland        AUS  Australia    135.9538   \n",
       "24                    Queensland        AUS  Australia     95.7052   \n",
       "25               South Australia        AUS  Australia    854.2792   \n",
       "26             Western Australia        AUS  Australia   1720.3492   \n",
       "27             Western Australia        AUS  Australia    117.4000   \n",
       "28                      Tasmania        AUS  Australia    237.2630   \n",
       "29                      Tasmania        AUS  Australia     95.1084   \n",
       "30            Northern Territory        AUS  Australia    240.3244   \n",
       "31  Australian Capital Territory        AUS  Australia    392.9671   \n",
       "\n",
       "                                           LOCI_URI21  ORIG_FID   Longitude  \\\n",
       "0   https://linked.data.gov.au/dataset/asgsed3/UCL...         0  150.966927   \n",
       "1   https://linked.data.gov.au/dataset/asgsed3/UCL...         1  149.220229   \n",
       "2   https://linked.data.gov.au/dataset/asgsed3/UCL...         2  151.428768   \n",
       "3   https://linked.data.gov.au/dataset/asgsed3/UCL...         3  153.529595   \n",
       "4   https://linked.data.gov.au/dataset/asgsed3/UCL...         4  151.677235   \n",
       "5   https://linked.data.gov.au/dataset/asgsed3/UCL...         5  150.846046   \n",
       "6   https://linked.data.gov.au/dataset/asgsed3/UCL...         6  146.948827   \n",
       "7   https://linked.data.gov.au/dataset/asgsed3/UCL...         7  153.095738   \n",
       "8   https://linked.data.gov.au/dataset/asgsed3/UCL...         8  151.587175   \n",
       "9   https://linked.data.gov.au/dataset/asgsed3/UCL...       538  145.077024   \n",
       "10  https://linked.data.gov.au/dataset/asgsed3/UCL...       539  143.841720   \n",
       "11  https://linked.data.gov.au/dataset/asgsed3/UCL...       540  144.285135   \n",
       "12  https://linked.data.gov.au/dataset/asgsed3/UCL...       541  144.357335   \n",
       "13  https://linked.data.gov.au/dataset/asgsed3/UCL...       542  146.882313   \n",
       "14  https://linked.data.gov.au/dataset/asgsed3/UCL...       543  144.580835   \n",
       "15  https://linked.data.gov.au/dataset/asgsed3/UCL...       885  153.012016   \n",
       "16  https://linked.data.gov.au/dataset/asgsed3/UCL...       886  153.350817   \n",
       "17  https://linked.data.gov.au/dataset/asgsed3/UCL...       887  153.069216   \n",
       "18  https://linked.data.gov.au/dataset/asgsed3/UCL...       888  145.720768   \n",
       "19  https://linked.data.gov.au/dataset/asgsed3/UCL...       889  151.930438   \n",
       "20  https://linked.data.gov.au/dataset/asgsed3/UCL...       890  146.746791   \n",
       "21  https://linked.data.gov.au/dataset/asgsed3/UCL...       891  152.323193   \n",
       "22  https://linked.data.gov.au/dataset/asgsed3/UCL...       892  152.812982   \n",
       "23  https://linked.data.gov.au/dataset/asgsed3/UCL...       893  149.174989   \n",
       "24  https://linked.data.gov.au/dataset/asgsed3/UCL...       894  150.514241   \n",
       "25  https://linked.data.gov.au/dataset/asgsed3/UCL...      1299  138.588522   \n",
       "26  https://linked.data.gov.au/dataset/asgsed3/UCL...      1473  115.872263   \n",
       "27  https://linked.data.gov.au/dataset/asgsed3/UCL...      1474  115.675630   \n",
       "28  https://linked.data.gov.au/dataset/asgsed3/UCL...      1652  147.349023   \n",
       "29  https://linked.data.gov.au/dataset/asgsed3/UCL...      1653  147.137158   \n",
       "30  https://linked.data.gov.au/dataset/asgsed3/UCL...      1749  130.934203   \n",
       "31  https://linked.data.gov.au/dataset/asgsed3/UCL...      1822  149.106653   \n",
       "\n",
       "     Latitude                 geometry  \n",
       "0  -33.841693  POINT (150.967 -33.842)  \n",
       "1  -35.366418  POINT (149.220 -35.366)  \n",
       "2  -33.366007  POINT (151.429 -33.366)  \n",
       "3  -28.222369  POINT (153.530 -28.222)  \n",
       "4  -32.950991  POINT (151.677 -32.951)  \n",
       "5  -34.471490  POINT (150.846 -34.471)  \n",
       "6  -36.050311  POINT (146.949 -36.050)  \n",
       "7  -30.312298  POINT (153.096 -30.312)  \n",
       "8  -32.750090  POINT (151.587 -32.750)  \n",
       "9  -37.892538  POINT (145.077 -37.893)  \n",
       "10 -37.566501  POINT (143.842 -37.567)  \n",
       "11 -36.756690  POINT (144.285 -36.757)  \n",
       "12 -38.165738  POINT (144.357 -38.166)  \n",
       "13 -36.122450  POINT (146.882 -36.122)  \n",
       "14 -37.694019  POINT (144.581 -37.694)  \n",
       "15 -27.474843  POINT (153.012 -27.475)  \n",
       "16 -27.971991  POINT (153.351 -27.972)  \n",
       "17 -26.618301  POINT (153.069 -26.618)  \n",
       "18 -16.897858  POINT (145.721 -16.898)  \n",
       "19 -27.567502  POINT (151.930 -27.568)  \n",
       "20 -19.275347  POINT (146.747 -19.275)  \n",
       "21 -24.889083  POINT (152.323 -24.889)  \n",
       "22 -25.291663  POINT (152.813 -25.292)  \n",
       "23 -21.102768  POINT (149.175 -21.103)  \n",
       "24 -23.345406  POINT (150.514 -23.345)  \n",
       "25 -34.920566  POINT (138.589 -34.921)  \n",
       "26 -32.039347  POINT (115.872 -32.039)  \n",
       "27 -33.339038  POINT (115.676 -33.339)  \n",
       "28 -42.846533  POINT (147.349 -42.847)  \n",
       "29 -41.439813  POINT (147.137 -41.440)  \n",
       "30 -12.443588  POINT (130.934 -12.444)  \n",
       "31 -35.302779  POINT (149.107 -35.303)  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"/g/data/mn51/users/gt3409/TimeSeriesExtraction/UCL_2021_AUST_with_location_top_33.csv\")\n",
    "gdf = gpd.GeoDataFrame(df, geometry=gpd.GeoSeries.from_xy(df['Longitude'], df['Latitude']), crs=ccrs.PlateCarree())\n",
    "gdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "36c1fa97-14b9-4156-ab2e-e1f0a19820f0",
   "metadata": {},
   "outputs": [],
   "source": [
    "aus_gdf = gpd.read_file(\n",
    "    \"/g/data/ia39/aus-ref-clim-data-nci/shapefiles/data/australia/australia.shp\"\n",
    ")\n",
    "aus_gdf[\"abbrevs\"] = [\"AUS\"]\n",
    "aus_gdf[\"NAME\"] = [\"Australia\"]\n",
    "regions = regionmask.from_geopandas(aus_gdf, names=\"NAME\", abbrevs=\"abbrevs\", overlap=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "7fedf18a-8d36-4d13-b7fe-76a00f97caec",
   "metadata": {},
   "outputs": [],
   "source": [
    "var=\"tasmaxAdjust\"\n",
    "institution_id, parent_model, downscaling_model, member_id = ('BOM', 'ACCESS-CM2', 'BARPA-R', 'r4i1p1f1')\n",
    "year = \"2015\"\n",
    "experiment_id = \"ssp370\"\n",
    "filename = f\"/g/data/ia39/australian-climate-service/test-data/CORDEX-CMIP6/bias-adjustment-output/AGCD-05i/{institution_id}/{parent_model}/{experiment_id}/{member_id}/{downscaling_model}/v1-r1-ACS-QME-AGCD-1960-2022/day/{var}/{var}_AGCD-05i_{parent_model}_{experiment_id}_{member_id}_{institution_id}_{downscaling_model}_v1-r1-ACS-QME-AGCD-1960-2022_day_{year}0101-{year}1231.nc\"\n",
    "ds = xr.open_dataset(filename, use_cftime = True,)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "ec758999-3920-4a81-815e-4bd893bea1ee",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><svg style=\"position: absolute; width: 0; height: 0; overflow: hidden\">\n",
       "<defs>\n",
       "<symbol id=\"icon-database\" viewBox=\"0 0 32 32\">\n",
       "<path d=\"M16 0c-8.837 0-16 2.239-16 5v4c0 2.761 7.163 5 16 5s16-2.239 16-5v-4c0-2.761-7.163-5-16-5z\"></path>\n",
       "<path d=\"M16 17c-8.837 0-16-2.239-16-5v6c0 2.761 7.163 5 16 5s16-2.239 16-5v-6c0 2.761-7.163 5-16 5z\"></path>\n",
       "<path d=\"M16 26c-8.837 0-16-2.239-16-5v6c0 2.761 7.163 5 16 5s16-2.239 16-5v-6c0 2.761-7.163 5-16 5z\"></path>\n",
       "</symbol>\n",
       "<symbol id=\"icon-file-text2\" viewBox=\"0 0 32 32\">\n",
       "<path d=\"M28.681 7.159c-0.694-0.947-1.662-2.053-2.724-3.116s-2.169-2.030-3.116-2.724c-1.612-1.182-2.393-1.319-2.841-1.319h-15.5c-1.378 0-2.5 1.121-2.5 2.5v27c0 1.378 1.122 2.5 2.5 2.5h23c1.378 0 2.5-1.122 2.5-2.5v-19.5c0-0.448-0.137-1.23-1.319-2.841zM24.543 5.457c0.959 0.959 1.712 1.825 2.268 2.543h-4.811v-4.811c0.718 0.556 1.584 1.309 2.543 2.268zM28 29.5c0 0.271-0.229 0.5-0.5 0.5h-23c-0.271 0-0.5-0.229-0.5-0.5v-27c0-0.271 0.229-0.5 0.5-0.5 0 0 15.499-0 15.5 0v7c0 0.552 0.448 1 1 1h7v19.5z\"></path>\n",
       "<path d=\"M23 26h-14c-0.552 0-1-0.448-1-1s0.448-1 1-1h14c0.552 0 1 0.448 1 1s-0.448 1-1 1z\"></path>\n",
       "<path d=\"M23 22h-14c-0.552 0-1-0.448-1-1s0.448-1 1-1h14c0.552 0 1 0.448 1 1s-0.448 1-1 1z\"></path>\n",
       "<path d=\"M23 18h-14c-0.552 0-1-0.448-1-1s0.448-1 1-1h14c0.552 0 1 0.448 1 1s-0.448 1-1 1z\"></path>\n",
       "</symbol>\n",
       "</defs>\n",
       "</svg>\n",
       "<style>/* CSS stylesheet for displaying xarray objects in jupyterlab.\n",
       " *\n",
       " */\n",
       "\n",
       ":root {\n",
       "  --xr-font-color0: var(--jp-content-font-color0, rgba(0, 0, 0, 1));\n",
       "  --xr-font-color2: var(--jp-content-font-color2, rgba(0, 0, 0, 0.54));\n",
       "  --xr-font-color3: var(--jp-content-font-color3, rgba(0, 0, 0, 0.38));\n",
       "  --xr-border-color: var(--jp-border-color2, #e0e0e0);\n",
       "  --xr-disabled-color: var(--jp-layout-color3, #bdbdbd);\n",
       "  --xr-background-color: var(--jp-layout-color0, white);\n",
       "  --xr-background-color-row-even: var(--jp-layout-color1, white);\n",
       "  --xr-background-color-row-odd: var(--jp-layout-color2, #eeeeee);\n",
       "}\n",
       "\n",
       "html[theme=dark],\n",
       "body[data-theme=dark],\n",
       "body.vscode-dark {\n",
       "  --xr-font-color0: rgba(255, 255, 255, 1);\n",
       "  --xr-font-color2: rgba(255, 255, 255, 0.54);\n",
       "  --xr-font-color3: rgba(255, 255, 255, 0.38);\n",
       "  --xr-border-color: #1F1F1F;\n",
       "  --xr-disabled-color: #515151;\n",
       "  --xr-background-color: #111111;\n",
       "  --xr-background-color-row-even: #111111;\n",
       "  --xr-background-color-row-odd: #313131;\n",
       "}\n",
       "\n",
       ".xr-wrap {\n",
       "  display: block !important;\n",
       "  min-width: 300px;\n",
       "  max-width: 700px;\n",
       "}\n",
       "\n",
       ".xr-text-repr-fallback {\n",
       "  /* fallback to plain text repr when CSS is not injected (untrusted notebook) */\n",
       "  display: none;\n",
       "}\n",
       "\n",
       ".xr-header {\n",
       "  padding-top: 6px;\n",
       "  padding-bottom: 6px;\n",
       "  margin-bottom: 4px;\n",
       "  border-bottom: solid 1px var(--xr-border-color);\n",
       "}\n",
       "\n",
       ".xr-header > div,\n",
       ".xr-header > ul {\n",
       "  display: inline;\n",
       "  margin-top: 0;\n",
       "  margin-bottom: 0;\n",
       "}\n",
       "\n",
       ".xr-obj-type,\n",
       ".xr-array-name {\n",
       "  margin-left: 2px;\n",
       "  margin-right: 10px;\n",
       "}\n",
       "\n",
       ".xr-obj-type {\n",
       "  color: var(--xr-font-color2);\n",
       "}\n",
       "\n",
       ".xr-sections {\n",
       "  padding-left: 0 !important;\n",
       "  display: grid;\n",
       "  grid-template-columns: 150px auto auto 1fr 20px 20px;\n",
       "}\n",
       "\n",
       ".xr-section-item {\n",
       "  display: contents;\n",
       "}\n",
       "\n",
       ".xr-section-item input {\n",
       "  display: none;\n",
       "}\n",
       "\n",
       ".xr-section-item input + label {\n",
       "  color: var(--xr-disabled-color);\n",
       "}\n",
       "\n",
       ".xr-section-item input:enabled + label {\n",
       "  cursor: pointer;\n",
       "  color: var(--xr-font-color2);\n",
       "}\n",
       "\n",
       ".xr-section-item input:enabled + label:hover {\n",
       "  color: var(--xr-font-color0);\n",
       "}\n",
       "\n",
       ".xr-section-summary {\n",
       "  grid-column: 1;\n",
       "  color: var(--xr-font-color2);\n",
       "  font-weight: 500;\n",
       "}\n",
       "\n",
       ".xr-section-summary > span {\n",
       "  display: inline-block;\n",
       "  padding-left: 0.5em;\n",
       "}\n",
       "\n",
       ".xr-section-summary-in:disabled + label {\n",
       "  color: var(--xr-font-color2);\n",
       "}\n",
       "\n",
       ".xr-section-summary-in + label:before {\n",
       "  display: inline-block;\n",
       "  content: '►';\n",
       "  font-size: 11px;\n",
       "  width: 15px;\n",
       "  text-align: center;\n",
       "}\n",
       "\n",
       ".xr-section-summary-in:disabled + label:before {\n",
       "  color: var(--xr-disabled-color);\n",
       "}\n",
       "\n",
       ".xr-section-summary-in:checked + label:before {\n",
       "  content: '▼';\n",
       "}\n",
       "\n",
       ".xr-section-summary-in:checked + label > span {\n",
       "  display: none;\n",
       "}\n",
       "\n",
       ".xr-section-summary,\n",
       ".xr-section-inline-details {\n",
       "  padding-top: 4px;\n",
       "  padding-bottom: 4px;\n",
       "}\n",
       "\n",
       ".xr-section-inline-details {\n",
       "  grid-column: 2 / -1;\n",
       "}\n",
       "\n",
       ".xr-section-details {\n",
       "  display: none;\n",
       "  grid-column: 1 / -1;\n",
       "  margin-bottom: 5px;\n",
       "}\n",
       "\n",
       ".xr-section-summary-in:checked ~ .xr-section-details {\n",
       "  display: contents;\n",
       "}\n",
       "\n",
       ".xr-array-wrap {\n",
       "  grid-column: 1 / -1;\n",
       "  display: grid;\n",
       "  grid-template-columns: 20px auto;\n",
       "}\n",
       "\n",
       ".xr-array-wrap > label {\n",
       "  grid-column: 1;\n",
       "  vertical-align: top;\n",
       "}\n",
       "\n",
       ".xr-preview {\n",
       "  color: var(--xr-font-color3);\n",
       "}\n",
       "\n",
       ".xr-array-preview,\n",
       ".xr-array-data {\n",
       "  padding: 0 5px !important;\n",
       "  grid-column: 2;\n",
       "}\n",
       "\n",
       ".xr-array-data,\n",
       ".xr-array-in:checked ~ .xr-array-preview {\n",
       "  display: none;\n",
       "}\n",
       "\n",
       ".xr-array-in:checked ~ .xr-array-data,\n",
       ".xr-array-preview {\n",
       "  display: inline-block;\n",
       "}\n",
       "\n",
       ".xr-dim-list {\n",
       "  display: inline-block !important;\n",
       "  list-style: none;\n",
       "  padding: 0 !important;\n",
       "  margin: 0;\n",
       "}\n",
       "\n",
       ".xr-dim-list li {\n",
       "  display: inline-block;\n",
       "  padding: 0;\n",
       "  margin: 0;\n",
       "}\n",
       "\n",
       ".xr-dim-list:before {\n",
       "  content: '(';\n",
       "}\n",
       "\n",
       ".xr-dim-list:after {\n",
       "  content: ')';\n",
       "}\n",
       "\n",
       ".xr-dim-list li:not(:last-child):after {\n",
       "  content: ',';\n",
       "  padding-right: 5px;\n",
       "}\n",
       "\n",
       ".xr-has-index {\n",
       "  font-weight: bold;\n",
       "}\n",
       "\n",
       ".xr-var-list,\n",
       ".xr-var-item {\n",
       "  display: contents;\n",
       "}\n",
       "\n",
       ".xr-var-item > div,\n",
       ".xr-var-item label,\n",
       ".xr-var-item > .xr-var-name span {\n",
       "  background-color: var(--xr-background-color-row-even);\n",
       "  margin-bottom: 0;\n",
       "}\n",
       "\n",
       ".xr-var-item > .xr-var-name:hover span {\n",
       "  padding-right: 5px;\n",
       "}\n",
       "\n",
       ".xr-var-list > li:nth-child(odd) > div,\n",
       ".xr-var-list > li:nth-child(odd) > label,\n",
       ".xr-var-list > li:nth-child(odd) > .xr-var-name span {\n",
       "  background-color: var(--xr-background-color-row-odd);\n",
       "}\n",
       "\n",
       ".xr-var-name {\n",
       "  grid-column: 1;\n",
       "}\n",
       "\n",
       ".xr-var-dims {\n",
       "  grid-column: 2;\n",
       "}\n",
       "\n",
       ".xr-var-dtype {\n",
       "  grid-column: 3;\n",
       "  text-align: right;\n",
       "  color: var(--xr-font-color2);\n",
       "}\n",
       "\n",
       ".xr-var-preview {\n",
       "  grid-column: 4;\n",
       "}\n",
       "\n",
       ".xr-index-preview {\n",
       "  grid-column: 2 / 5;\n",
       "  color: var(--xr-font-color2);\n",
       "}\n",
       "\n",
       ".xr-var-name,\n",
       ".xr-var-dims,\n",
       ".xr-var-dtype,\n",
       ".xr-preview,\n",
       ".xr-attrs dt {\n",
       "  white-space: nowrap;\n",
       "  overflow: hidden;\n",
       "  text-overflow: ellipsis;\n",
       "  padding-right: 10px;\n",
       "}\n",
       "\n",
       ".xr-var-name:hover,\n",
       ".xr-var-dims:hover,\n",
       ".xr-var-dtype:hover,\n",
       ".xr-attrs dt:hover {\n",
       "  overflow: visible;\n",
       "  width: auto;\n",
       "  z-index: 1;\n",
       "}\n",
       "\n",
       ".xr-var-attrs,\n",
       ".xr-var-data,\n",
       ".xr-index-data {\n",
       "  display: none;\n",
       "  background-color: var(--xr-background-color) !important;\n",
       "  padding-bottom: 5px !important;\n",
       "}\n",
       "\n",
       ".xr-var-attrs-in:checked ~ .xr-var-attrs,\n",
       ".xr-var-data-in:checked ~ .xr-var-data,\n",
       ".xr-index-data-in:checked ~ .xr-index-data {\n",
       "  display: block;\n",
       "}\n",
       "\n",
       ".xr-var-data > table {\n",
       "  float: right;\n",
       "}\n",
       "\n",
       ".xr-var-name span,\n",
       ".xr-var-data,\n",
       ".xr-index-name div,\n",
       ".xr-index-data,\n",
       ".xr-attrs {\n",
       "  padding-left: 25px !important;\n",
       "}\n",
       "\n",
       ".xr-attrs,\n",
       ".xr-var-attrs,\n",
       ".xr-var-data,\n",
       ".xr-index-data {\n",
       "  grid-column: 1 / -1;\n",
       "}\n",
       "\n",
       "dl.xr-attrs {\n",
       "  padding: 0;\n",
       "  margin: 0;\n",
       "  display: grid;\n",
       "  grid-template-columns: 125px auto;\n",
       "}\n",
       "\n",
       ".xr-attrs dt,\n",
       ".xr-attrs dd {\n",
       "  padding: 0;\n",
       "  margin: 0;\n",
       "  float: left;\n",
       "  padding-right: 10px;\n",
       "  width: auto;\n",
       "}\n",
       "\n",
       ".xr-attrs dt {\n",
       "  font-weight: normal;\n",
       "  grid-column: 1;\n",
       "}\n",
       "\n",
       ".xr-attrs dt:hover span {\n",
       "  display: inline-block;\n",
       "  background: var(--xr-background-color);\n",
       "  padding-right: 10px;\n",
       "}\n",
       "\n",
       ".xr-attrs dd {\n",
       "  grid-column: 2;\n",
       "  white-space: pre-wrap;\n",
       "  word-break: break-all;\n",
       "}\n",
       "\n",
       ".xr-icon-database,\n",
       ".xr-icon-file-text2,\n",
       ".xr-no-icon {\n",
       "  display: inline-block;\n",
       "  vertical-align: middle;\n",
       "  width: 1em;\n",
       "  height: 1.5em !important;\n",
       "  stroke-width: 0;\n",
       "  stroke: currentColor;\n",
       "  fill: currentColor;\n",
       "}\n",
       "</style><pre class='xr-text-repr-fallback'>&lt;xarray.DataArray &#x27;tasmaxAdjust&#x27; (time: 365, location: 32)&gt; Size: 47kB\n",
       "[11680 values with dtype=float32]\n",
       "Coordinates:\n",
       "  * time      (time) object 3kB 2015-01-01 12:00:00 ... 2015-12-31 12:00:00\n",
       "    lat       (location) float64 256B -33.85 -35.35 -33.35 ... -12.45 -35.3\n",
       "    lon       (location) float64 256B 150.9 149.2 151.4 ... 147.2 130.9 149.1\n",
       "  * location  (location) int64 256B 0 1 2 3 4 5 6 7 ... 24 25 26 27 28 29 30 31\n",
       "Attributes:\n",
       "    long_name:      Bias-Adjusted Daily Maximum Near-Surface Air Temperature\n",
       "    standard_name:  air_temperature\n",
       "    units:          degC\n",
       "    regrid_method:  bilinear</pre><div class='xr-wrap' style='display:none'><div class='xr-header'><div class='xr-obj-type'>xarray.DataArray</div><div class='xr-array-name'>'tasmaxAdjust'</div><ul class='xr-dim-list'><li><span class='xr-has-index'>time</span>: 365</li><li><span class='xr-has-index'>location</span>: 32</li></ul></div><ul class='xr-sections'><li class='xr-section-item'><div class='xr-array-wrap'><input id='section-e23da806-e92b-46f8-9116-2a55bd91a5d3' class='xr-array-in' type='checkbox' checked><label for='section-e23da806-e92b-46f8-9116-2a55bd91a5d3' title='Show/hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-array-preview xr-preview'><span>...</span></div><div class='xr-array-data'><pre>[11680 values with dtype=float32]</pre></div></div></li><li class='xr-section-item'><input id='section-b72347f9-c6a6-4cff-ab00-455d84e8e066' class='xr-section-summary-in' type='checkbox'  checked><label for='section-b72347f9-c6a6-4cff-ab00-455d84e8e066' class='xr-section-summary' >Coordinates: <span>(4)</span></label><div class='xr-section-inline-details'></div><div class='xr-section-details'><ul class='xr-var-list'><li class='xr-var-item'><div class='xr-var-name'><span class='xr-has-index'>time</span></div><div class='xr-var-dims'>(time)</div><div class='xr-var-dtype'>object</div><div class='xr-var-preview xr-preview'>2015-01-01 12:00:00 ... 2015-12-...</div><input id='attrs-54d8379a-17bb-4118-89ce-00a2cb8f5853' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-54d8379a-17bb-4118-89ce-00a2cb8f5853' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-353ce606-9a0e-48b2-80fc-4d16a13e7949' class='xr-var-data-in' type='checkbox'><label for='data-353ce606-9a0e-48b2-80fc-4d16a13e7949' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>axis :</span></dt><dd>T</dd><dt><span>standard_name :</span></dt><dd>time</dd><dt><span>long_name :</span></dt><dd>time</dd><dt><span>bounds :</span></dt><dd>time_bnds</dd></dl></div><div class='xr-var-data'><pre>array([cftime.DatetimeProlepticGregorian(2015, 1, 1, 12, 0, 0, 0, has_year_zero=True),\n",
       "       cftime.DatetimeProlepticGregorian(2015, 1, 2, 12, 0, 0, 0, has_year_zero=True),\n",
       "       cftime.DatetimeProlepticGregorian(2015, 1, 3, 12, 0, 0, 0, has_year_zero=True),\n",
       "       ...,\n",
       "       cftime.DatetimeProlepticGregorian(2015, 12, 29, 12, 0, 0, 0, has_year_zero=True),\n",
       "       cftime.DatetimeProlepticGregorian(2015, 12, 30, 12, 0, 0, 0, has_year_zero=True),\n",
       "       cftime.DatetimeProlepticGregorian(2015, 12, 31, 12, 0, 0, 0, has_year_zero=True)],\n",
       "      dtype=object)</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span>lat</span></div><div class='xr-var-dims'>(location)</div><div class='xr-var-dtype'>float64</div><div class='xr-var-preview xr-preview'>-33.85 -35.35 ... -12.45 -35.3</div><input id='attrs-a691b6c7-7c15-4302-9a9c-ed22b1e78806' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-a691b6c7-7c15-4302-9a9c-ed22b1e78806' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-dec3f836-525b-4dac-aedd-34adb706780d' class='xr-var-data-in' type='checkbox'><label for='data-dec3f836-525b-4dac-aedd-34adb706780d' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>units :</span></dt><dd>degrees_north</dd><dt><span>axis :</span></dt><dd>Y</dd><dt><span>bounds :</span></dt><dd>lat_bnds</dd><dt><span>long_name :</span></dt><dd>latitude</dd><dt><span>standard_name :</span></dt><dd>latitude</dd></dl></div><div class='xr-var-data'><pre>array([-33.85, -35.35, -33.35, -28.2 , -32.95, -34.45, -36.05, -30.3 , -32.75,\n",
       "       -37.9 , -37.55, -36.75, -38.15, -36.1 , -37.7 , -27.45, -27.95, -26.6 ,\n",
       "       -16.9 , -27.55, -19.3 , -24.9 , -25.3 , -21.1 , -23.35, -34.9 , -32.05,\n",
       "       -33.35, -42.85, -41.45, -12.45, -35.3 ])</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span>lon</span></div><div class='xr-var-dims'>(location)</div><div class='xr-var-dtype'>float64</div><div class='xr-var-preview xr-preview'>150.9 149.2 151.4 ... 130.9 149.1</div><input id='attrs-7b638598-bd51-44fd-8e93-8eb70d87b882' class='xr-var-attrs-in' type='checkbox' ><label for='attrs-7b638598-bd51-44fd-8e93-8eb70d87b882' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-4e20d309-d1b3-4b0b-8815-62e9fea4378b' class='xr-var-data-in' type='checkbox'><label for='data-4e20d309-d1b3-4b0b-8815-62e9fea4378b' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'><dt><span>units :</span></dt><dd>degrees_east</dd><dt><span>axis :</span></dt><dd>X</dd><dt><span>bounds :</span></dt><dd>lon_bnds</dd><dt><span>long_name :</span></dt><dd>longitude</dd><dt><span>standard_name :</span></dt><dd>longitude</dd></dl></div><div class='xr-var-data'><pre>array([150.95, 149.2 , 151.45, 153.55, 151.7 , 150.85, 146.95, 153.1 , 151.6 ,\n",
       "       145.1 , 143.85, 144.3 , 144.35, 146.9 , 144.6 , 153.  , 153.35, 153.05,\n",
       "       145.7 , 151.95, 146.75, 152.3 , 152.8 , 149.15, 150.5 , 138.6 , 115.85,\n",
       "       115.7 , 147.35, 147.15, 130.95, 149.1 ])</pre></div></li><li class='xr-var-item'><div class='xr-var-name'><span class='xr-has-index'>location</span></div><div class='xr-var-dims'>(location)</div><div class='xr-var-dtype'>int64</div><div class='xr-var-preview xr-preview'>0 1 2 3 4 5 6 ... 26 27 28 29 30 31</div><input id='attrs-356ab46a-ae4b-4a49-9966-52059118b155' class='xr-var-attrs-in' type='checkbox' disabled><label for='attrs-356ab46a-ae4b-4a49-9966-52059118b155' title='Show/Hide attributes'><svg class='icon xr-icon-file-text2'><use xlink:href='#icon-file-text2'></use></svg></label><input id='data-d9f0c086-073c-4325-a1cf-9098edffd704' class='xr-var-data-in' type='checkbox'><label for='data-d9f0c086-073c-4325-a1cf-9098edffd704' title='Show/Hide data repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-var-attrs'><dl class='xr-attrs'></dl></div><div class='xr-var-data'><pre>array([ 0,  1,  2,  3,  4,  5,  6,  7,  8,  9, 10, 11, 12, 13, 14, 15, 16, 17,\n",
       "       18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31])</pre></div></li></ul></div></li><li class='xr-section-item'><input id='section-1790927a-a29a-4f80-a2b0-41e2960a6c94' class='xr-section-summary-in' type='checkbox'  ><label for='section-1790927a-a29a-4f80-a2b0-41e2960a6c94' class='xr-section-summary' >Indexes: <span>(2)</span></label><div class='xr-section-inline-details'></div><div class='xr-section-details'><ul class='xr-var-list'><li class='xr-var-item'><div class='xr-index-name'><div>time</div></div><div class='xr-index-preview'>PandasIndex</div><div></div><input id='index-9468015b-d112-42e5-9dd3-ead4c8710104' class='xr-index-data-in' type='checkbox'/><label for='index-9468015b-d112-42e5-9dd3-ead4c8710104' title='Show/Hide index repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-index-data'><pre>PandasIndex(CFTimeIndex([2015-01-01 12:00:00, 2015-01-02 12:00:00, 2015-01-03 12:00:00,\n",
       "             2015-01-04 12:00:00, 2015-01-05 12:00:00, 2015-01-06 12:00:00,\n",
       "             2015-01-07 12:00:00, 2015-01-08 12:00:00, 2015-01-09 12:00:00,\n",
       "             2015-01-10 12:00:00,\n",
       "             ...\n",
       "             2015-12-22 12:00:00, 2015-12-23 12:00:00, 2015-12-24 12:00:00,\n",
       "             2015-12-25 12:00:00, 2015-12-26 12:00:00, 2015-12-27 12:00:00,\n",
       "             2015-12-28 12:00:00, 2015-12-29 12:00:00, 2015-12-30 12:00:00,\n",
       "             2015-12-31 12:00:00],\n",
       "            dtype=&#x27;object&#x27;,\n",
       "            length=365,\n",
       "            calendar=&#x27;proleptic_gregorian&#x27;,\n",
       "            freq=&#x27;D&#x27;))</pre></div></li><li class='xr-var-item'><div class='xr-index-name'><div>location</div></div><div class='xr-index-preview'>PandasIndex</div><div></div><input id='index-b3361c67-39fc-4dd6-81a6-85199d45f534' class='xr-index-data-in' type='checkbox'/><label for='index-b3361c67-39fc-4dd6-81a6-85199d45f534' title='Show/Hide index repr'><svg class='icon xr-icon-database'><use xlink:href='#icon-database'></use></svg></label><div class='xr-index-data'><pre>PandasIndex(RangeIndex(start=0, stop=32, step=1, name=&#x27;location&#x27;))</pre></div></li></ul></div></li><li class='xr-section-item'><input id='section-bf05fd1d-92cc-444b-afbe-d442ade32b69' class='xr-section-summary-in' type='checkbox'  checked><label for='section-bf05fd1d-92cc-444b-afbe-d442ade32b69' class='xr-section-summary' >Attributes: <span>(4)</span></label><div class='xr-section-inline-details'></div><div class='xr-section-details'><dl class='xr-attrs'><dt><span>long_name :</span></dt><dd>Bias-Adjusted Daily Maximum Near-Surface Air Temperature</dd><dt><span>standard_name :</span></dt><dd>air_temperature</dd><dt><span>units :</span></dt><dd>degC</dd><dt><span>regrid_method :</span></dt><dd>bilinear</dd></dl></div></li></ul></div></div>"
      ],
      "text/plain": [
       "<xarray.DataArray 'tasmaxAdjust' (time: 365, location: 32)> Size: 47kB\n",
       "[11680 values with dtype=float32]\n",
       "Coordinates:\n",
       "  * time      (time) object 3kB 2015-01-01 12:00:00 ... 2015-12-31 12:00:00\n",
       "    lat       (location) float64 256B -33.85 -35.35 -33.35 ... -12.45 -35.3\n",
       "    lon       (location) float64 256B 150.9 149.2 151.4 ... 147.2 130.9 149.1\n",
       "  * location  (location) int64 256B 0 1 2 3 4 5 6 7 ... 24 25 26 27 28 29 30 31\n",
       "Attributes:\n",
       "    long_name:      Bias-Adjusted Daily Maximum Near-Surface Air Temperature\n",
       "    standard_name:  air_temperature\n",
       "    units:          degC\n",
       "    regrid_method:  bilinear"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ds.sel(lon=xr.DataArray(gdf.Longitude, dims=\"location\"), lat=xr.DataArray(gdf.Latitude, dims = 'location'), method = \"nearest\").tasmaxAdjust"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9c86d9e6-439a-44d5-8cdd-1d7c861e5a0e",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:analysis3-24.04] *",
   "language": "python",
   "name": "conda-env-analysis3-24.04-py"
  },
  "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.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}