Skip to content

Instantly share code, notes, and snippets.

@cwerner

cwerner/et0_extract.ipynb

Created May 27, 2020 15:13
Show Gist options
  • Save cwerner/648fe78a2e8b5e3e59341cf26343e31c to your computer and use it in GitHub Desktop.
Save cwerner/648fe78a2e8b5e3e59341cf26343e31c to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
et0_extract.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Extract ET0 values by coordinate"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"%matplotlib inline\n",
"%load_ext autoreload\n",
"%autoreload 2"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"import xarray as xr\n",
"import pandas as pd\n",
"import re"
]
},
{
"cell_type": "raw",
"metadata": {},
"source": [
"\n",
"\n",
"#https://stackoverflow.com/questions/33997361\n",
"def dms2dd(s):\n",
" # example: s = \"\"\"0°51'56.29\"S\"\"\"\n",
" degrees, minutes, direction = re.split('[°\\']+', s)\n",
" dd = float(degrees) + float(minutes)/60 #+ float(seconds)/(60*60);\n",
" if direction in ('S','W'):\n",
" dd*= -1\n",
" return dd"
]
},
{
"cell_type": "code",
"execution_count": 17,
"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>Observation</th>\n",
" <th>Study</th>\n",
" <th>First_author</th>\n",
" <th>Year_of_pub</th>\n",
" <th>Jounal_source</th>\n",
" <th>Country</th>\n",
" <th>LatitudeDeg</th>\n",
" <th>LongitudeDeg</th>\n",
" <th>Studytype</th>\n",
" <th>Latitude</th>\n",
" <th>Longitude</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>Abalos</td>\n",
" <td>2013</td>\n",
" <td>Plant Soil</td>\n",
" <td>Spain</td>\n",
" <td>40°32'N</td>\n",
" <td>3°17'W</td>\n",
" <td>Field</td>\n",
" <td>40.533</td>\n",
" <td>3.283</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>Abalos</td>\n",
" <td>2013</td>\n",
" <td>Plant Soil</td>\n",
" <td>Spain</td>\n",
" <td>40°32'N</td>\n",
" <td>3°17'W</td>\n",
" <td>Field</td>\n",
" <td>40.533</td>\n",
" <td>3.283</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>Abalos</td>\n",
" <td>2013</td>\n",
" <td>Plant Soil</td>\n",
" <td>Spain</td>\n",
" <td>40°32'N</td>\n",
" <td>3°17'W</td>\n",
" <td>Field</td>\n",
" <td>40.533</td>\n",
" <td>3.283</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>2</td>\n",
" <td>Baggs</td>\n",
" <td>2003</td>\n",
" <td>Plant Soil</td>\n",
" <td>England</td>\n",
" <td>51°29'N</td>\n",
" <td>0°10'E</td>\n",
" <td>Field</td>\n",
" <td>51.483</td>\n",
" <td>0.166</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>Baggs</td>\n",
" <td>2003</td>\n",
" <td>Plant Soil</td>\n",
" <td>England</td>\n",
" <td>51°29'N</td>\n",
" <td>0°10'E</td>\n",
" <td>Field</td>\n",
" <td>51.483</td>\n",
" <td>0.166</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>326</th>\n",
" <td>329</td>\n",
" <td>71</td>\n",
" <td>Pinto</td>\n",
" <td>2004</td>\n",
" <td>Nutrient Cycling in Agroecosystems</td>\n",
" <td>Spain</td>\n",
" <td>43°25'N</td>\n",
" <td>2°56'W</td>\n",
" <td>Field</td>\n",
" <td>43.416</td>\n",
" <td>2.933</td>\n",
" </tr>\n",
" <tr>\n",
" <th>327</th>\n",
" <td>330</td>\n",
" <td>72</td>\n",
" <td>Ernfors</td>\n",
" <td>NaN</td>\n",
" <td>Unpublished</td>\n",
" <td>Sweden</td>\n",
" <td>55°39'N</td>\n",
" <td>13°6'W</td>\n",
" <td>Field</td>\n",
" <td>55.666</td>\n",
" <td>13.116</td>\n",
" </tr>\n",
" <tr>\n",
" <th>328</th>\n",
" <td>331</td>\n",
" <td>72</td>\n",
" <td>Ernfors</td>\n",
" <td>NaN</td>\n",
" <td>Unpublished</td>\n",
" <td>Sweden</td>\n",
" <td>55°39'N</td>\n",
" <td>13°6'W</td>\n",
" <td>Field</td>\n",
" <td>55.666</td>\n",
" <td>13.116</td>\n",
" </tr>\n",
" <tr>\n",
" <th>329</th>\n",
" <td>332</td>\n",
" <td>72</td>\n",
" <td>Ernfors</td>\n",
" <td>NaN</td>\n",
" <td>Unpublished</td>\n",
" <td>Sweden</td>\n",
" <td>55°39'N</td>\n",
" <td>13°6'W</td>\n",
" <td>Field</td>\n",
" <td>55.666</td>\n",
" <td>13.116</td>\n",
" </tr>\n",
" <tr>\n",
" <th>330</th>\n",
" <td>333</td>\n",
" <td>72</td>\n",
" <td>Ernfors</td>\n",
" <td>NaN</td>\n",
" <td>Unpublished</td>\n",
" <td>Sweden</td>\n",
" <td>55°39'N</td>\n",
" <td>13°6'W</td>\n",
" <td>Field</td>\n",
" <td>55.666</td>\n",
" <td>13.116</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>290 rows × 11 columns</p>\n",
"</div>"
],
"text/plain": [
" Observation Study First_author Year_of_pub \\\n",
"0 1 1 Abalos 2013 \n",
"1 2 1 Abalos 2013 \n",
"2 3 1 Abalos 2013 \n",
"3 4 2 Baggs 2003 \n",
"4 5 2 Baggs 2003 \n",
".. ... ... ... ... \n",
"326 329 71 Pinto 2004 \n",
"327 330 72 Ernfors NaN \n",
"328 331 72 Ernfors NaN \n",
"329 332 72 Ernfors NaN \n",
"330 333 72 Ernfors NaN \n",
"\n",
" Jounal_source Country LatitudeDeg LongitudeDeg \\\n",
"0 Plant Soil Spain 40°32'N 3°17'W \n",
"1 Plant Soil Spain 40°32'N 3°17'W \n",
"2 Plant Soil Spain 40°32'N 3°17'W \n",
"3 Plant Soil England 51°29'N 0°10'E \n",
"4 Plant Soil England 51°29'N 0°10'E \n",
".. ... ... ... ... \n",
"326 Nutrient Cycling in Agroecosystems Spain 43°25'N 2°56'W \n",
"327 Unpublished Sweden 55°39'N 13°6'W \n",
"328 Unpublished Sweden 55°39'N 13°6'W \n",
"329 Unpublished Sweden 55°39'N 13°6'W \n",
"330 Unpublished Sweden 55°39'N 13°6'W \n",
"\n",
" Studytype Latitude Longitude \n",
"0 Field 40.533 3.283 \n",
"1 Field 40.533 3.283 \n",
"2 Field 40.533 3.283 \n",
"3 Field 51.483 0.166 \n",
"4 Field 51.483 0.166 \n",
".. ... ... ... \n",
"326 Field 43.416 2.933 \n",
"327 Field 55.666 13.116 \n",
"328 Field 55.666 13.116 \n",
"329 Field 55.666 13.116 \n",
"330 Field 55.666 13.116 \n",
"\n",
"[290 rows x 11 columns]"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df = pd.read_csv(\"/Users/werner-ch/Downloads/locations_v2.csv\")\n",
"df = df.dropna(subset=['Latitude', 'Longitude'])\n",
"# df[\"Latitude\"] = df.Latitude.str.replace(\"′ \", \"'\").str.replace(\" \",\"\")\n",
"# df[\"Longitude\"] = df.Longitude.str.replace(\"′ \", \"'\").str.replace(\" \",\"\")\n",
"# display(df)\n",
"# df['Latitude'] = df['Latitude'].apply(dms2dd)\n",
"# df['Longitude'] = df['Longitude'].apply(dms2dd)\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"ds = xr.open_rasterio(\"/Users/werner-ch/Downloads/et0_yr/et0_yr.tif\").squeeze(drop=True)\n",
"ds = ds.where(ds>-32768)"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"0 - found next best with eps=1.0 in direction (-1.0, 1.0)\n",
"1 - found next best with eps=1.0 in direction (-1.0, 1.0)\n",
"2 - found next best with eps=1.0 in direction (-1.0, 1.0)\n",
"49 - found next best with eps=0.025 in direction (-0.025, 0.025)\n",
"50 - found next best with eps=0.025 in direction (-0.025, 0.025)\n",
"51 - found next best with eps=0.025 in direction (-0.025, 0.025)\n",
"52 - found next best with eps=0.025 in direction (-0.025, 0.025)\n",
"109 - found next best with eps=0.05 in direction (-0.05, -0.05)\n",
"110 - found next best with eps=0.05 in direction (-0.05, -0.05)\n",
"227 - found next best with eps=0.25 in direction (-0.25, -0.25)\n",
"228 - found next best with eps=0.25 in direction (-0.25, -0.25)\n",
"229 - found next best with eps=0.25 in direction (-0.25, -0.25)\n",
"230 - found next best with eps=0.25 in direction (-0.25, -0.25)\n",
"231 - found next best with eps=0.25 in direction (-0.25, -0.25)\n",
"232 - found next best with eps=0.25 in direction (-0.25, -0.25)\n",
"233 - found next best with eps=0.25 in direction (-0.25, -0.25)\n",
"234 - found next best with eps=0.25 in direction (-0.25, -0.25)\n",
"273 - found next best with eps=0.5 in direction (0.5, 0.0)\n",
"274 - found next best with eps=0.5 in direction (0.5, 0.0)\n",
"275 - found next best with eps=0.5 in direction (0.5, 0.0)\n",
"276 - found next best with eps=0.5 in direction (0.5, 0.0)\n",
"277 - found next best with eps=0.5 in direction (0.5, 0.0)\n",
"278 - found next best with eps=0.5 in direction (0.5, 0.0)\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>Observation</th>\n",
" <th>Study</th>\n",
" <th>First_author</th>\n",
" <th>Year_of_pub</th>\n",
" <th>Jounal_source</th>\n",
" <th>Country</th>\n",
" <th>LatitudeDeg</th>\n",
" <th>LongitudeDeg</th>\n",
" <th>Studytype</th>\n",
" <th>Latitude</th>\n",
" <th>Longitude</th>\n",
" <th>ET0</th>\n",
" <th>ET0_dist</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>Abalos</td>\n",
" <td>2013</td>\n",
" <td>Plant Soil</td>\n",
" <td>Spain</td>\n",
" <td>40°32'N</td>\n",
" <td>3°17'W</td>\n",
" <td>Field</td>\n",
" <td>40.533</td>\n",
" <td>3.283</td>\n",
" <td>1338.0</td>\n",
" <td>1.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>Abalos</td>\n",
" <td>2013</td>\n",
" <td>Plant Soil</td>\n",
" <td>Spain</td>\n",
" <td>40°32'N</td>\n",
" <td>3°17'W</td>\n",
" <td>Field</td>\n",
" <td>40.533</td>\n",
" <td>3.283</td>\n",
" <td>1338.0</td>\n",
" <td>1.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>Abalos</td>\n",
" <td>2013</td>\n",
" <td>Plant Soil</td>\n",
" <td>Spain</td>\n",
" <td>40°32'N</td>\n",
" <td>3°17'W</td>\n",
" <td>Field</td>\n",
" <td>40.533</td>\n",
" <td>3.283</td>\n",
" <td>1338.0</td>\n",
" <td>1.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>2</td>\n",
" <td>Baggs</td>\n",
" <td>2003</td>\n",
" <td>Plant Soil</td>\n",
" <td>England</td>\n",
" <td>51°29'N</td>\n",
" <td>0°10'E</td>\n",
" <td>Field</td>\n",
" <td>51.483</td>\n",
" <td>0.166</td>\n",
" <td>869.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>Baggs</td>\n",
" <td>2003</td>\n",
" <td>Plant Soil</td>\n",
" <td>England</td>\n",
" <td>51°29'N</td>\n",
" <td>0°10'E</td>\n",
" <td>Field</td>\n",
" <td>51.483</td>\n",
" <td>0.166</td>\n",
" <td>869.0</td>\n",
" <td>0.0</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",
" </tr>\n",
" <tr>\n",
" <th>326</th>\n",
" <td>329</td>\n",
" <td>71</td>\n",
" <td>Pinto</td>\n",
" <td>2004</td>\n",
" <td>Nutrient Cycling in Agroecosystems</td>\n",
" <td>Spain</td>\n",
" <td>43°25'N</td>\n",
" <td>2°56'W</td>\n",
" <td>Field</td>\n",
" <td>43.416</td>\n",
" <td>2.933</td>\n",
" <td>1355.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>327</th>\n",
" <td>330</td>\n",
" <td>72</td>\n",
" <td>Ernfors</td>\n",
" <td>NaN</td>\n",
" <td>Unpublished</td>\n",
" <td>Sweden</td>\n",
" <td>55°39'N</td>\n",
" <td>13°6'W</td>\n",
" <td>Field</td>\n",
" <td>55.666</td>\n",
" <td>13.116</td>\n",
" <td>767.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>328</th>\n",
" <td>331</td>\n",
" <td>72</td>\n",
" <td>Ernfors</td>\n",
" <td>NaN</td>\n",
" <td>Unpublished</td>\n",
" <td>Sweden</td>\n",
" <td>55°39'N</td>\n",
" <td>13°6'W</td>\n",
" <td>Field</td>\n",
" <td>55.666</td>\n",
" <td>13.116</td>\n",
" <td>767.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>329</th>\n",
" <td>332</td>\n",
" <td>72</td>\n",
" <td>Ernfors</td>\n",
" <td>NaN</td>\n",
" <td>Unpublished</td>\n",
" <td>Sweden</td>\n",
" <td>55°39'N</td>\n",
" <td>13°6'W</td>\n",
" <td>Field</td>\n",
" <td>55.666</td>\n",
" <td>13.116</td>\n",
" <td>767.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>330</th>\n",
" <td>333</td>\n",
" <td>72</td>\n",
" <td>Ernfors</td>\n",
" <td>NaN</td>\n",
" <td>Unpublished</td>\n",
" <td>Sweden</td>\n",
" <td>55°39'N</td>\n",
" <td>13°6'W</td>\n",
" <td>Field</td>\n",
" <td>55.666</td>\n",
" <td>13.116</td>\n",
" <td>767.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>290 rows × 13 columns</p>\n",
"</div>"
],
"text/plain": [
" Observation Study First_author Year_of_pub \\\n",
"0 1 1 Abalos 2013 \n",
"1 2 1 Abalos 2013 \n",
"2 3 1 Abalos 2013 \n",
"3 4 2 Baggs 2003 \n",
"4 5 2 Baggs 2003 \n",
".. ... ... ... ... \n",
"326 329 71 Pinto 2004 \n",
"327 330 72 Ernfors NaN \n",
"328 331 72 Ernfors NaN \n",
"329 332 72 Ernfors NaN \n",
"330 333 72 Ernfors NaN \n",
"\n",
" Jounal_source Country LatitudeDeg LongitudeDeg \\\n",
"0 Plant Soil Spain 40°32'N 3°17'W \n",
"1 Plant Soil Spain 40°32'N 3°17'W \n",
"2 Plant Soil Spain 40°32'N 3°17'W \n",
"3 Plant Soil England 51°29'N 0°10'E \n",
"4 Plant Soil England 51°29'N 0°10'E \n",
".. ... ... ... ... \n",
"326 Nutrient Cycling in Agroecosystems Spain 43°25'N 2°56'W \n",
"327 Unpublished Sweden 55°39'N 13°6'W \n",
"328 Unpublished Sweden 55°39'N 13°6'W \n",
"329 Unpublished Sweden 55°39'N 13°6'W \n",
"330 Unpublished Sweden 55°39'N 13°6'W \n",
"\n",
" Studytype Latitude Longitude ET0 ET0_dist \n",
"0 Field 40.533 3.283 1338.0 1.0 \n",
"1 Field 40.533 3.283 1338.0 1.0 \n",
"2 Field 40.533 3.283 1338.0 1.0 \n",
"3 Field 51.483 0.166 869.0 0.0 \n",
"4 Field 51.483 0.166 869.0 0.0 \n",
".. ... ... ... ... ... \n",
"326 Field 43.416 2.933 1355.0 0.0 \n",
"327 Field 55.666 13.116 767.0 0.0 \n",
"328 Field 55.666 13.116 767.0 0.0 \n",
"329 Field 55.666 13.116 767.0 0.0 \n",
"330 Field 55.666 13.116 767.0 0.0 \n",
"\n",
"[290 rows x 13 columns]"
]
},
"execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import numpy as np\n",
"\n",
"def find_valid(df, idx, row):\n",
" value = df.loc[idx, \"ET0\"] = ds.sel(x=row.Longitude, y=row.Latitude, method='nearest').values\n",
" if np.isnan(value):\n",
" for eps in [0.01, 0.025, 0.05, 0.1, 0.25, 0.5, 1.0]:\n",
" for i, j in [(-1,0), (-1,1), (0,1), (1,1), (1,0), (1,-1), (0,-1), (-1,-1)]:\n",
" LO, LA = i*eps, j*eps\n",
" next_best = ds.sel(x=row.Longitude+LO, y=row.Latitude+LA, method='nearest').values\n",
" if np.isnan(next_best) == False:\n",
" print(f\"{idx} - found next best with eps={eps} in direction {(LO,LA)}\")\n",
" df.loc[idx, \"ET0\"] = next_best\n",
" df.loc[idx, \"ET0_dist\"] = eps\n",
" return df\n",
" else:\n",
" df.loc[idx, \"ET0\"] = value\n",
" return df\n",
"\n",
"df[\"ET0\"] = np.nan\n",
"df[\"ET0_dist\"] = 0\n",
"for idx, row in df.iterrows():\n",
" df = find_valid(df, idx, row)\n",
"df "
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [],
"source": [
"df.to_csv(\"results_with_et0.csv\")"
]
},
{
"cell_type": "code",
"execution_count": 56,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"total 6016\n",
"-rw-r--r-- 1 werner-ch 901 2661 May 20 11:32 Untitled.ipynb\n",
"-rw-r--r-- 1 werner-ch 901 31078 May 20 13:48 Untitled1.ipynb\n",
"-rw-r--r-- 1 werner-ch 901 529 May 20 13:49 sample.csv\n",
"-rwx------ 1 werner-ch 901 406515 May 18 18:33 \u001b[31mtileSG-032-028_1-1.tif\u001b[m\u001b[m\n",
"-rwx------ 1 werner-ch 901 257375 May 18 18:33 \u001b[31mtileSG-032-028_1-2.tif\u001b[m\u001b[m\n",
"-rwx------ 1 werner-ch 901 406515 May 18 18:33 \u001b[31mtileSG-032-028_2-1.tif\u001b[m\u001b[m\n",
"-rwx------ 1 werner-ch 901 406513 May 18 18:33 \u001b[31mtileSG-032-028_2-2.tif\u001b[m\u001b[m\n",
"-rwx------ 1 werner-ch 901 274987 May 18 18:33 \u001b[31mtileSG-032-028_2-3.tif\u001b[m\u001b[m\n",
"-rwx------ 1 werner-ch 901 45263 May 18 18:33 \u001b[31mtileSG-032-028_2-4.tif\u001b[m\u001b[m\n",
"-rwx------ 1 werner-ch 901 297509 May 18 18:33 \u001b[31mtileSG-032-028_3-1.tif\u001b[m\u001b[m\n",
"-rwx------ 1 werner-ch 901 406515 May 18 18:33 \u001b[31mtileSG-032-028_3-2.tif\u001b[m\u001b[m\n",
"-rwx------ 1 werner-ch 901 406515 May 18 18:33 \u001b[31mtileSG-032-028_3-3.tif\u001b[m\u001b[m\n",
"-rwx------ 1 werner-ch 901 83103 May 18 18:33 \u001b[31mtileSG-032-028_3-4.tif\u001b[m\u001b[m\n",
"-rwx------ 1 werner-ch 901 3155 May 18 18:33 \u001b[31mtileSG-032-028_4-2.tif\u001b[m\u001b[m\n",
"-rwx------ 1 werner-ch 901 14977 May 18 18:33 \u001b[31mtileSG-032-028_4-3.tif\u001b[m\u001b[m\n"
]
}
],
"source": [
"! ls -l"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "datascience",
"language": "python",
"name": "datascience"
},
"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.7.4"
}
},
"nbformat": 4,
"nbformat_minor": 4
}
Raw
gistfile1.txt
,Observation,Study ,First_author,Year_of_pub,Jounal_source,Country,LatitudeDeg,LongitudeDeg,Studytype,Latitude,Longitude,ET0,ET0_dist
0,1,1,Abalos,2013,Plant Soil,Spain,40°32'N,3°17'W,Field,40.533,3.283,1338.0,1.0
1,2,1,Abalos,2013,Plant Soil,Spain,40°32'N,3°17'W,Field,40.533,3.283,1338.0,1.0
2,3,1,Abalos,2013,Plant Soil,Spain,40°32'N,3°17'W,Field,40.533,3.283,1338.0,1.0
3,4,2,Baggs,2003,Plant Soil,England,51°29'N, 0°10'E,Field,51.483000000000004,0.166,869.0,0.0
4,5,2,Baggs,2003,Plant Soil,England,51°29'N, 0°10'E,Field,51.483000000000004,0.166,869.0,0.0
5,6,2,Baggs,2003,Plant Soil,England,51°29'N, 0°10'E,Field,51.483000000000004,0.166,869.0,0.0
6,7,2,Baggs,2003,Plant Soil,England,51°29'N, 0°10'E,Field,51.483000000000004,0.166,869.0,0.0
7,8,2,Baggs,2003,Plant Soil,England,51°29'N, 0°10'E,Field,51.483000000000004,0.166,869.0,0.0
8,9,2,Baggs,2003,Plant Soil,England,51°29'N, 0°10'E,Field,51.483000000000004,0.166,869.0,0.0
9,10,3,Nett,2015,Agricultural Science,Germany,52°21′ N,13°18′E,Field,52.35,13.3,881.0,0.0
10,11,3,Nett,2015,Agricultural Science,Germany,52°21′ N,13°18′E,Field,52.35,13.3,881.0,0.0
11,12,4,Gregorutti,2017,"Agriculture, Ecosystems and Environment",Argentina,31° 50.9′ S,60° 32.3′ W,Field,31.85,60.533,2642.0,0.0
12,13,4,Gregorutti,2017,"Agriculture, Ecosystems and Environment",Argentina,31° 50.9′ S,60° 32.3′ W,Field,31.85,60.533,2642.0,0.0
13,14,4,Gregorutti,2017,"Agriculture, Ecosystems and Environment",Argentina,31° 50.9′ S,60° 32.3′ W,Field,31.85,60.533,2642.0,0.0
14,15,4,Gregorutti,2017,"Agriculture, Ecosystems and Environment",Argentina,31° 50.9′ S,60° 32.3′ W,Field,31.85,60.533,2642.0,0.0
15,16,5,Kesenheimer,2018,Plant Nutrition and Soil Science,Germany,48°44′ N,8°55′E,Field,48.733000000000004,8.916,866.0,0.0
16,17,5,Kesenheimer,2018,Plant Nutrition and Soil Science,Germany,48°44′ N,8°55′E,Field,48.733000000000004,8.916,866.0,0.0
17,18,6,Pitombo,2017,Soil Use and Management,Brazil,22°22'S,47°30' W,Field,22.366,47.5,3370.0,0.0
18,19,6,Pitombo,2017,Soil Use and Management,Brazil,22°22'S,47°30' W,Field,22.366,47.5,3370.0,0.0
19,20,6,Pitombo,2017,Soil Use and Management,Brazil,22°22'S,47°30' W,Field,22.366,47.5,3370.0,0.0
20,21,7,Carmo,2013,GCB Bioenergy,Brazil,22°41'S,47°30' W,Field,22.366,47.5,3370.0,0.0
21,22,7,Carmo,2013,GCB Bioenergy,Brazil,22°41'S,47°30' W,Field,22.366,47.5,3370.0,0.0
22,23,7,Carmo,2013,GCB Bioenergy,Brazil,22°41'S,47°30' W,Field,22.366,47.5,3370.0,0.0
23,24,7,Carmo,2013,GCB Bioenergy,Brazil,22°41'S,47°30' W,Field,22.366,47.5,3370.0,0.0
24,25,7,Carmo,2013,GCB Bioenergy,Brazil,22°41'S,47°30' W,Field,22.366,47.5,3370.0,0.0
25,26,7,Carmo,2013,GCB Bioenergy,Brazil,22°41'S,47°30' W,Field,22.366,47.5,3370.0,0.0
26,27,8,Hu,2016,"Agriculture, Ecosystems and Environment",China,32°56'N,118°59'E,Field,32.933,118.98299999999999,1303.0,0.0
27,28,8,Hu,2016,"Agriculture, Ecosystems and Environment",China,32°56'N,118°59'E,Field,32.933,118.98299999999999,1303.0,0.0
28,29,8,Hu,2016,"Agriculture, Ecosystems and Environment",China,32°56'N,118°59'E,Field,32.933,118.98299999999999,1303.0,0.0
29,30,8,Hu,2016,"Agriculture, Ecosystems and Environment",China,32°56'N,118°59'E,Field,32.933,118.98299999999999,1303.0,0.0
30,31,8,Hu,2016,"Agriculture, Ecosystems and Environment",China,32°56'N,118°59'E,Field,32.933,118.98299999999999,1303.0,0.0
31,32,8,Hu,2016,"Agriculture, Ecosystems and Environment",China,32°56'N,118°59'E,Field,32.933,118.98299999999999,1303.0,0.0
32,33,9,Congreves,2017,GCB Bioenergy,Canada,43°38'N,80°25' W,Field,43.633,80.416,1518.0,0.0
33,34,9,Congreves,2017,GCB Bioenergy,Canada,43°38'N,80°25' W,Field,43.633,80.416,1518.0,0.0
34,35,9,Congreves,2017,GCB Bioenergy,Canada,43°38'N,80°25' W,Field,43.633,80.416,1518.0,0.0
35,36,9,Congreves,2017,GCB Bioenergy,Canada,43°38'N,80°25' W,Field,43.633,80.416,1518.0,0.0
47,48,11,Yao,2009,Soil biology and Biochemistry,China,32°35'N,119°42' E,Field,32.583,119.7,1281.0,0.0
48,49,11,Yao,2009,Soil biology and Biochemistry,China,32°35'N,119°42' E,Field,32.583,119.7,1281.0,0.0
49,50,12,Sarkodie-Addo,2003,Soil Use and Management,England,51°N,1° E,Field,51.0,1.0,764.0,0.025
50,51,12,Sarkodie-Addo,2003,Soil Use and Management,England,51°N,1° E,Field,51.0,1.0,764.0,0.025
51,52,12,Sarkodie-Addo,2003,Soil Use and Management,England,51°N,1° E,Field,51.0,1.0,764.0,0.025
52,53,12,Sarkodie-Addo,2003,Soil Use and Management,England,51°N,1° E,Field,51.0,1.0,764.0,0.025
56,57,14,Liu,2011,"Agriculture, Ecosystems and Environment",China,34°55'N,110°42'E,Field,34.916,110.7,1418.0,0.0
57,58,15,Li,2015,"Agriculture, Ecosystems and Environment",Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
58,59,15,Li,2015,"Agriculture, Ecosystems and Environment",Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
59,60,15,Li,2015,"Agriculture, Ecosystems and Environment",Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
60,61,15,Li,2015,"Agriculture, Ecosystems and Environment",Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
61,62,15,Li,2015,"Agriculture, Ecosystems and Environment",Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
62,63,15,Li,2015,"Agriculture, Ecosystems and Environment",Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
63,64,15,Li,2015,"Agriculture, Ecosystems and Environment",Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
64,65,15,Li,2015,"Agriculture, Ecosystems and Environment",Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
65,66,15,Li,2015,"Agriculture, Ecosystems and Environment",Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
66,67,15,Li,2015,"Agriculture, Ecosystems and Environment",Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
67,68,16,Buchen,2016,Soil Biology and Biochemistry,Germany,53°15'N,7°50'E,Field,53.25,7.832999999999999,767.0,0.0
68,69,16,Buchen,2016,Soil Biology and Biochemistry,Germany,53°10'N,8°20'E,Field,53.166000000000004,8.333,766.0,0.0
69,70,17,Romasanta,2017,"Agriculture, Ecosystems and Environment",Philippines,14°8'53''N,121°16'1.2''E,Field,14.148,121.26700000000001,1472.0,0.0
70,71,17,Romasanta,2017,"Agriculture, Ecosystems and Environment",Philippines,14°8'53''N,121°16'1.2''E,Field,14.148,121.26700000000001,1472.0,0.0
71,72,17,Romasanta,2017,"Agriculture, Ecosystems and Environment",Philippines,14°8'53''N,121°16'1.2''E,Field,14.148,121.26700000000001,1472.0,0.0
72,73,17,Romasanta,2017,"Agriculture, Ecosystems and Environment",Philippines,14°8'53''N,121°16'1.2''E,Field,14.148,121.26700000000001,1472.0,0.0
73,74,18,Buchen,2017,"Agriculture, Ecosystems and Environment",Germany,53°15'N,7°50'E,Field,53.25,7.832999999999999,767.0,0.0
74,75,18,Buchen,2017,"Agriculture, Ecosystems and Environment",Germany,53°10'N,8°20'E,Field,53.166000000000004,8.333,766.0,0.0
75,76,18,Buchen,2017,"Agriculture, Ecosystems and Environment",Germany,53°15'N,7°50'E,Field,53.25,7.832999999999999,767.0,0.0
76,77,18,Buchen,2017,"Agriculture, Ecosystems and Environment",Germany,53°10'N,8°20'E,Field,53.166000000000004,8.333,766.0,0.0
77,78,19,Fracetto,2017,Soil Biology and Biochemistry,Brazil,22°40'S,47°45' W,Field,22.666,47.75,3359.0,0.0
78,79,19,Fracetto,2017,Soil Biology and Biochemistry,Brazil,22°40'S,47°45' W,Field,22.666,47.75,3359.0,0.0
79,80,20,Nadeem,2012,Biogeosciences,norway,59°40'N,10°47'E,Field,59.666000000000004,10.783,746.0,0.0
80,81,20,Nadeem,2012,Biogeosciences,norway,59°40'N,10°47'E,Field,59.666000000000004,10.783,746.0,0.0
81,82,20,Nadeem,2012,Biogeosciences,norway,59°40'N,10°47'E,Field,59.666000000000004,10.783,746.0,0.0
82,83,20,Nadeem,2012,Biogeosciences,norway,59°40'N,10°47'E,Field,59.666000000000004,10.783,746.0,0.0
87,88,22,Liu,2019,Pedosphere,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
88,89,22,Liu,2019,Pedosphere,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
89,90,22,Liu,2019,Pedosphere,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
90,91,22,Liu,2019,Pedosphere,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
91,92,22,Liu,2019,Pedosphere,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
92,93,22,Liu,2019,Pedosphere,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
93,94,23,Hu,2013,Environmental Pollution,China,36°52'N,115°10'E,Field,36.866,115.166,1451.0,0.0
94,95,23,Hu,2013,Environmental Pollution,China,36°52'N,115°10'E,Field,36.866,115.166,1451.0,0.0
95,96,23,Hu,2013,Environmental Pollution,China,36°52'N,115°10'E,Field,36.866,115.166,1451.0,0.0
96,97,23,Hu,2013,Environmental Pollution,China,36°52'N,115°10'E,Field,36.866,115.166,1451.0,0.0
97,98,23,Hu,2013,Environmental Pollution,China,36°52'N,115°10'E,Field,36.866,115.166,1451.0,0.0
98,99,23,Hu,2013,Environmental Pollution,China,36°52'N,115°10'E,Field,36.866,115.166,1451.0,0.0
99,100,23,Hu,2013,Environmental Pollution,China,36°52'N,115°10'E,Field,36.866,115.166,1451.0,0.0
100,101,23,Hu,2013,Environmental Pollution,China,36°52'N,115°10'E,Field,36.866,115.166,1451.0,0.0
101,102,24,Kandel,2019,Renewable Agriculture and Food Systems,USA,35°40′N,98°00′W,Field,35.666,98.0,1114.0,0.0
102,103,25,Xiong,2002,Nutrient Cycling in Agroecosystems,China,28°15′N,116°55'E,Field,28.25,116.916,1330.0,0.0
103,104,25,Xiong,2002,Nutrient Cycling in Agroecosystems,China,28°15′N,116°55'E,Field,28.25,116.916,1330.0,0.0
104,105,26,Petersen,2011,Soil Biology and Biochemistry,Denmark,56°30'N,9°35'E,Field,56.5,9.583,720.0,0.0
105,106,26,Petersen ,2011,Soil Biology and Biochemistry,Denmark,56°30'N,9°35'E,Field,56.5,9.583,720.0,0.0
106,107,26,Petersen,2011,Soil Biology and Biochemistry,Denmark,56°30'N,9°35'E,Field,56.5,9.583,720.0,0.0
107,108,27,Pramanik,2014,Science of the Total Environment,South Korea,36°50'N,128°26'E,Field,36.833,128.433,1041.0,0.0
108,109,27,Pramanik,2014,Science of the Total Environment,South Korea,36°50'N,128°26'E,Field,36.833,128.433,1041.0,0.0
109,110,28,Kallenbach,2010,"Agriculture, Ecosystems and Environment",USA,32°N,121°50′W,Field,32.0,121.833,1226.0,0.05
110,111,28,Kallenbach,2010,"Agriculture, Ecosystems and Environment",USA,32°N,121°50′W,Field,32.0,121.833,1226.0,0.05
111,112,29,Mitchell,2013,Soil Science Society of America Journal,USA,42°1'N,93°46'W,Field,42.02,93.77,2071.0,0.0
112,113,29,Mitchell,2013,Soil Science Society of America Journal,USA,42°1'N,93°46'W,Field,42.02,93.77,2071.0,0.0
113,114,29,Mitchell,2013,Soil Science Society of America Journal,USA,42°1'N,93°46'W,Field,42.02,93.77,2071.0,0.0
114,115,30,Koga,2016,Soil Science and Plant Nutrition,Japan,42°53ʹN,143°03ʹE,Field,42.883,143.05,834.0,0.0
115,116,30,Koga,2016,Soil Science and Plant Nutrition,Japan,42°53ʹN,143°03ʹE,Field,42.883,143.05,834.0,0.0
116,117,31,Duan,2018,Frontiers in Microbiology,Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
117,118,31,Duan,2018,Frontiers in Microbiology,Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
118,119,31,Duan,2018,Frontiers in Microbiology,Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
119,120,31,Duan,2018,Frontiers in Microbiology,Denmark,56°30'N,9°34'E,Field,56.5,9.566,715.0,0.0
120,121,32,Bent,2016,Applied Soil Ecology,Canada,43°22'N,80°15'W,Field,43.38,80.25,1044.0,0.0
121,122,33,Zhang,2011,Atmospheric Environment,China,38°42'N,115°09'E,Field,38.71,115.15,1478.0,0.0
122,123,34,Shen,2014,"Agriculture, Ecosystems and Environment",China,28°33'N,113°19'E,Field,28.55,113.316,1214.0,0.0
123,124,34,Shen,2014,"Agriculture, Ecosystems and Environment",China,28°33'N,113°19'E,Field,28.55,113.316,1214.0,0.0
124,125,34,Shen,2014,"Agriculture, Ecosystems and Environment",China,28°33'N,113°19'E,Field,28.55,113.316,1214.0,0.0
125,126,34,Shen,2014,"Agriculture, Ecosystems and Environment",China,28°33'N,113°19'E,Field,28.55,113.316,1214.0,0.0
126,127,35,Zhang,2014,The Scientific World Journal,China,29°55'N,115°30'E,Field,29.916,115.5,1349.0,0.0
127,128,35,Zhang,2014,The Scientific World Journal,China,29°55'N,115°30'E,Field,29.916,115.5,1349.0,0.0
128,129,35,Zhang,2014,The Scientific World Journal,China,29°55'N,115°30'E,Field,29.916,115.5,1349.0,0.0
129,130,36,Wang,2010,Plant soil environment,China,31°16'N,105°27'E,Field,31.266,105.45,982.0,0.0
130,131,36,Wang,2010,Plant soil environment,China,31°16'N,105°27'E,Field,31.266,105.45,982.0,0.0
131,132,36,Wang,2010,Plant soil environment,China,31°16'N,115°30'E,Field,31.266,115.5,1215.0,0.0
132,133,37,Fan,2016,Ecology and Evolution,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
133,134,38,Sander,2014,Geoderma,Philippines,14°10'N,121°15'E,Field,14.165999999999999,121.25,1464.0,0.0
134,135,38,Sander,2014,Geoderma,Philippines,14°10'N,121°15'E,Field,14.165999999999999,121.25,1464.0,0.0
135,136,38,Sander,2014,Geoderma,Philippines,14°10'N,121°15'E,Field,14.165999999999999,121.25,1464.0,0.0
136,137,38,Sander,2014,Geoderma,Philippines,14°10'N,121°15'E,Field,14.165999999999999,121.25,1464.0,0.0
137,138,39,Pathak,2006,Paddy Water Environment ,India,28°40'N,77°12'E,Field,28.666,77.2,1972.0,0.0
138,139,39,Pathak,2006,Paddy Water Environment ,India,28°40'N,77°12'E,Field,28.666,77.2,1972.0,0.0
139,140,40,Hao,2001,Nutrient Cycling in Agroecosystems,Canada,49°42'N,112°48'W,Field,49.7,112.8,983.0,0.0
140,141,40,Hao,2001,Nutrient Cycling in Agroecosystems,Canada,49°42'N,112°48'W,Field,49.7,112.8,983.0,0.0
141,142,40,Hao,2001,Nutrient Cycling in Agroecosystems,Canada,49°42'N,112°48'W,Field,49.7,112.8,983.0,0.0
142,143,40,Hao,2001,Nutrient Cycling in Agroecosystems,Canada,49°42'N,112°48'W,Field,49.7,112.8,983.0,0.0
143,144,41,Zou,2005,Atmospheric Environment,China,31°52'N,118°50'E,Field,31.866,118.833,1288.0,0.0
144,145,42,Xu-bo,2014,Jounal of integrative Agriculture,China,26°45'N,111°52'E,Field,26.75,111.866,1178.0,0.0
145,146,42,Xu-bo,2014,Jounal of integrative Agriculture,China,26°45'N,111°52'E,Field,26.75,111.866,1178.0,0.0
146,147,43,Ma,2007,Australian Journal of Soil Research,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
147,148,43,Ma,2007,Australian Journal of Soil Research,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
148,149,43,Ma,2007,Australian Journal of Soil Research,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
149,150,43,Ma,2007,Australian Journal of Soil Research,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
150,151,43,Ma,2007,Australian Journal of Soil Research,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
151,152,43,Ma,2007,Australian Journal of Soil Research,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
152,153,43,Ma,2007,Australian Journal of Soil Research,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
153,154,43,Ma,2007,Australian Journal of Soil Research,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
154,155,43,Ma,2007,Australian Journal of Soil Research,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
155,156,44,Nett,2016,Nutrient Cycling in Agroecosystems,Germany,52°21'N,13°18'E,Field,52.35,13.3,881.0,0.0
156,157,44,Nett,2016,Nutrient Cycling in Agroecosystems,Germany,52°21'N,13°18'E,Field,52.35,13.3,881.0,0.0
157,158,44,Nett,2016,Nutrient Cycling in Agroecosystems,Germany,52°21'N,13°18'E,Field,52.35,13.3,881.0,0.0
158,159,44,Nett,2016,Nutrient Cycling in Agroecosystems,Germany,52°21'N,13°18'E,Field,52.35,13.3,881.0,0.0
159,160,44,Nett,2016,Nutrient Cycling in Agroecosystems,Germany,52°21'N,13°18'E,Field,52.35,13.3,881.0,0.0
160,161,44,Nett,2016,Nutrient Cycling in Agroecosystems,Germany,52°21'N,13°18'E,Field,52.35,13.3,881.0,0.0
161,162,44,Nett,2016,Nutrient Cycling in Agroecosystems,Germany,52°21'N,13°18'E,Field,52.35,13.3,881.0,0.0
162,163,44,Nett,2016,Nutrient Cycling in Agroecosystems,Germany,52°21'N,13°18'E,Field,52.35,13.3,881.0,0.0
163,164,44,Nett,2016,Nutrient Cycling in Agroecosystems,Germany,52°21'N,13°18'E,Field,52.35,13.3,881.0,0.0
164,165,45,Huang,2013,Biogeosciences,China,39°48'N,116°28'E,Field,39.8,116.46600000000001,1441.0,0.0
165,166,45,Huang,2013,Biogeosciences,China,39°48'N,116°28'E,Field,39.8,116.46600000000001,1441.0,0.0
166,167,45,Huang,2013,Biogeosciences,China,39°48'N,116°28'E,Field,39.8,116.46600000000001,1441.0,0.0
167,168,45,Huang,2013,Biogeosciences,China,39°48'N,116°28'E,Field,39.8,116.46600000000001,1441.0,0.0
168,169,45,Huang,2013,Biogeosciences,China,39°48'N,116°28'E,Field,39.8,116.46600000000001,1441.0,0.0
169,170,46,Wang,2016,Scientific Reports,China,28°55'N,111°30'E,Field,28.916,111.5,1203.0,0.0
170,171,46,Wang,2016,Scientific Reports,China,28°55'N,111°30'E,Field,28.916,111.5,1203.0,0.0
171,172,47,Zou,2005,Global Biogeochemical Cycles,China,31°52'N,118°50'E,Field,31.866,118.833,1288.0,0.0
172,173,47,Zou,2005,Global Biogeochemical Cycles,China,31°52'N,118°50'E,Field,31.866,118.833,1288.0,0.0
173,174,47,Zou,2005,Global Biogeochemical Cycles,China,31°52'N,118°50'E,Field,31.866,118.833,1288.0,0.0
174,175,47,Zou,2005,Global Biogeochemical Cycles,China,31°52'N,118°50'E,Field,31.866,118.833,1288.0,0.0
175,176,48,Xu,2017,Atmospheric Environment,China,32°12'N,119°27'E,Field,32.2,119.45,1284.0,0.0
176,177,48,Xu,2017,Atmospheric Environment,China,32°12'N,119°27'E,Field,32.2,119.45,1284.0,0.0
177,178,49,Htun ,2017,Atmospheric Environment,China,34°17'N,108°00'E,Field,34.283,108.0,1245.0,0.0
178,179,49,Htun ,2017,Atmospheric Environment,China,34°17'N,108°00'E,Field,34.283,108.0,1245.0,0.0
179,180,49,Htun ,2017,Atmospheric Environment,China,34°17'N,108°00'E,Field,34.283,108.0,1245.0,0.0
180,181,49,Htun ,2017,Atmospheric Environment,China,34°17'N,108°00'E,Field,34.283,108.0,1245.0,0.0
181,182,49,Htun ,2017,Atmospheric Environment,China,34°17'N,108°00'E,Field,34.283,108.0,1245.0,0.0
182,183,50,Wang,2011,"Agriculture, Ecosystems and Environment",China,31°52'N,118°50'E,Field,31.866999999999997,108.833,1082.0,0.0
183,184,50,Wang,2011,"Agriculture, Ecosystems and Environment",China,31°52'N,118°50'E,Field,31.866999999999997,108.833,1082.0,0.0
184,185,50,Wang,2011,"Agriculture, Ecosystems and Environment",China,31°52'N,118°50'E,Field,31.866999999999997,108.833,1082.0,0.0
185,186,50,Wang,2011,"Agriculture, Ecosystems and Environment",China,31°52'N,118°50'E,Field,31.866999999999997,108.833,1082.0,0.0
186,187,51,Toma,2007,Japanese Society of Soil Science and Plant Nutrition,Japan,43°14'N,141°50'E,Field,43.233000000000004,141.833,861.0,0.0
187,188,51,Toma,2007,Japanese Society of Soil Science and Plant Nutrition,Japan,43°14'N,141°50'E,Field,43.233000000000004,141.833,861.0,0.0
188,189,51,Toma,2007,Japanese Society of Soil Science and Plant Nutrition,Japan,43°14'N,141°50'E,Field,43.233000000000004,141.833,861.0,0.0
189,190,51,Toma,2007,Japanese Society of Soil Science and Plant Nutrition,Japan,43°14'N,141°50'E,Field,43.233000000000004,141.833,861.0,0.0
190,191,52,Rees,not published ,https://cereals.ahdb.org.uk/publications/2015/october/29/minimising-nitrous-oxide-intensities-of-arable-crop-products-(min-no).aspx,UK,55°52'N,3°12'W,Field,55.87,3.2,,0.0
191,192,52,Rees,not published ,https://cereals.ahdb.org.uk/publications/2015/october/29/minimising-nitrous-oxide-intensities-of-arable-crop-products-(min-no).aspx,UK,55°52'N,3°12'W,Field,55.87,3.2,,0.0
192,193,52,Rees,not published ,https://cereals.ahdb.org.uk/publications/2015/october/29/minimising-nitrous-oxide-intensities-of-arable-crop-products-(min-no).aspx,UK,55°52'N,3°12'W,Field,55.87,3.2,,0.0
193,194,52,Rees,not published ,https://cereals.ahdb.org.uk/publications/2015/october/29/minimising-nitrous-oxide-intensities-of-arable-crop-products-(min-no).aspx,UK,55°52'N,3°12'W,Field,55.87,3.2,,0.0
194,195,52,Rees,not published ,https://cereals.ahdb.org.uk/publications/2015/october/29/minimising-nitrous-oxide-intensities-of-arable-crop-products-(min-no).aspx,UK,55°52'N,3°12'W,Field,55.87,3.2,,0.0
195,196,52,Rees,not published ,https://cereals.ahdb.org.uk/publications/2015/october/29/minimising-nitrous-oxide-intensities-of-arable-crop-products-(min-no).aspx,UK,55°52'N,3°12'W,Field,55.87,3.2,,0.0
196,197,52,Rees,not published ,https://cereals.ahdb.org.uk/publications/2015/october/29/minimising-nitrous-oxide-intensities-of-arable-crop-products-(min-no).aspx,UK,55°52'N,3°12'W,Field,55.87,3.2,,0.0
197,198,53,Wang,2019,Soil and Tillage Research,China,31°27'N,120°25'E,Field,31.45,120.416,1235.0,0.0
198,199,53,Wang,2019,Soil and Tillage Research,China,31°27'N,120°25'E,Field,31.45,120.416,1235.0,0.0
199,200,53,Wang,2019,Soil and Tillage Research,China,31°27'N,120°25'E,Field,31.45,120.416,1235.0,0.0
200,201,53,Wang,2019,Soil and Tillage Research,China,31°27'N,120°25'E,Field,31.45,120.416,1235.0,0.0
201,202,53,Wang,2019,Soil and Tillage Research,China,31°27'N,120°25'E,Field,31.45,120.416,1235.0,0.0
202,203,53,Wang,2019,Soil and Tillage Research,China,31°27'N,120°25'E,Field,31.45,120.416,1235.0,0.0
203,204,53,Wang,2019,Soil and Tillage Research,China,31°27'N,120°25'E,Field,31.45,120.416,1235.0,0.0
204,205,53,Wang,2019,Soil and Tillage Research,China,31°27'N,120°25'E,Field,31.45,120.416,1235.0,0.0
205,206,53,Wang,2019,Soil and Tillage Research,China,31°27'N,120°25'E,Field,31.45,120.416,1235.0,0.0
227,228,55,Sylvester-Bradley,2015,Project Report,England,53°13'N,1°06W,Field,53.216,1.1,754.0,0.25
228,229,55,Sylvester-Bradley,2015,Project Report,England,53°13'N,1°06W,Field,53.216,1.1,754.0,0.25
229,230,55,Sylvester-Bradley,2015,Project Report,England,53°13'N,1°06W,Field,53.216,1.1,754.0,0.25
230,231,55,Sylvester-Bradley,2015,Project Report,England,53°13'N,1°06W,Field,53.216,1.1,754.0,0.25
231,232,55,Sylvester-Bradley,2015,Project Report,England,53°13'N,1°06W,Field,53.216,1.1,754.0,0.25
232,233,55,Sylvester-Bradley,2015,Project Report,England,53°13'N,1°06W,Field,53.216,1.1,754.0,0.25
233,234,55,Sylvester-Bradley,2015,Project Report,England,53°13'N,1°06W,Field,53.216,1.1,754.0,0.25
234,235,55,Sylvester-Bradley,2015,Project Report,England,53°13'N,1°06W,Field,53.216,1.1,754.0,0.25
235,236,55,Sylvester-Bradley,2015,Project Report,England,52°46'N,0°19E,Field,52.766000000000005,0.316,757.0,0.0
236,237,55,Sylvester-Bradley,2015,Project Report,England,52°46'N,0°19E,Field,52.766000000000005,0.316,757.0,0.0
237,238,55,Sylvester-Bradley,2015,Project Report,England,52°46'N,0°19E,Field,52.766000000000005,0.316,757.0,0.0
238,239,55,Sylvester-Bradley,2015,Project Report,England,52°46'N,0°19E,Field,52.766000000000005,0.316,757.0,0.0
239,240,55,Sylvester-Bradley,2015,Project Report,England,52°46'N,0°19E,Field,52.766000000000005,0.316,757.0,0.0
240,241,55,Sylvester-Bradley,2015,Project Report,England,52°46'N,0°19E,Field,52.766000000000005,0.316,757.0,0.0
241,242,55,Sylvester-Bradley,2015,Project Report,England,52°46'N,0°19E,Field,52.766000000000005,0.316,757.0,0.0
242,243,55,Sylvester-Bradley,2015,Project Report,England,52°46'N,0°19E,Field,52.766000000000005,0.316,757.0,0.0
243,244,56,Kim,2017,Atmospheric Environment,Korea,36°50'N,128°26E,Field,36.833,128.433,1041.0,0.0
244,245,56,Kim,2017,Atmospheric Environment,Korea,36°50'N,128°26E,Field,36.833,128.433,1041.0,0.0
245,246,56,Kim,2017,Atmospheric Environment,Korea,36°50'N,128°26E,Field,36.833,128.433,1041.0,0.0
246,247,56,Kim,2017,Atmospheric Environment,Korea,36°50'N,128°26E,Field,36.833,128.433,1041.0,0.0
247,248,56,Kim,2017,Atmospheric Environment,Korea,36°50'N,128°26E,Field,36.833,128.433,1041.0,0.0
248,249,56,Kim,2017,Atmospheric Environment,Korea,36°50'N,128°26E,Field,36.833,128.433,1041.0,0.0
249,250,56,Kim,2017,Atmospheric Environment,Korea,36°50'N,128°26E,Field,36.833,128.433,1041.0,0.0
250,251,56,Kim,2017,Atmospheric Environment,Korea,36°50'N,128°26E,Field,36.833,128.433,1041.0,0.0
251,252,56,Kim,2017,Atmospheric Environment,Korea,36°50'N,128°26E,Field,36.833,128.433,1041.0,0.0
252,253,56,Kim,2017,Atmospheric Environment,Korea,36°50'N,128°26E,Field,36.833,128.433,1041.0,0.0
253,254,56,Kim,2017,Atmospheric Environment,Korea,36°50'N,128°26E,Field,36.833,128.433,1041.0,0.0
254,255,56,Kim,2017,Atmospheric Environment,Korea,36°50'N,128°26E,Field,36.833,128.433,1041.0,0.0
255,256,57,Parkin,2016,Soil Biology and Biochemistry,USA,42°3'N,93.42°W,Field,42.05,93.71,2119.0,0.0
256,257,57,Parkin,2016,Soil Biology and Biochemistry,USA,42°3'N,93.42°W,Field,42.05,93.71,2119.0,0.0
257,258,57,Parkin,2016,Soil Biology and Biochemistry,USA,42°3'N,93.42°W,Field,42.05,93.71,2119.0,0.0
258,259,57,Parkin,2016,Soil Biology and Biochemistry,USA,42°3'N,93.42°W,Field,42.05,93.71,2119.0,0.0
259,260,57,Parkin,2016,Soil Biology and Biochemistry,USA,42°3'N,93.42°W,Field,42.05,93.71,2119.0,0.0
260,261,57,Parkin,2016,Soil Biology and Biochemistry,USA,42°3'N,93.42°W,Field,42.05,93.71,2119.0,0.0
261,262,57,Parkin,2016,Soil Biology and Biochemistry,USA,42°3'N,93.42°W,Field,42.05,93.71,2119.0,0.0
262,263,57,Parkin,2016,Soil Biology and Biochemistry,USA,42°3'N,93.42°W,Field,42.05,93.71,2119.0,0.0
263,264,57,Parkin,2016,Soil Biology and Biochemistry,USA,42°3'N,93.42°W,Field,42.05,93.71,2119.0,0.0
264,265,57,Parkin,2016,Soil Biology and Biochemistry,USA,42°3'N,93.42°W,Field,42.05,93.71,2119.0,0.0
265,266,58,Tang,2014,Plos One,China,28°11'N,113°04'E,Field,28.183000000000003,113.066,1182.0,0.0
266,267,58,Tang,2014,Plos One,China,28°11'N,113°04'E,Field,28.183000000000003,113.066,1182.0,0.0
267,268,58,Tang,2014,Plos One,China,28°11'N,113°04'E,Field,28.183000000000003,113.066,1182.0,0.0
268,269,58,Tang,2014,Plos One,China,28°11'N,113°04'E,Field,28.183000000000003,113.066,1182.0,0.0
269,270,59,Tang,2015,Environmental Science and Pollution Research,China,28°11'N,113°04'E,Field,28.183000000000003,113.066,1182.0,0.0
270,271,59,Tang,2015,Environmental Science and Pollution Research,China,28°11'N,113°04'E,Field,28.183000000000003,113.066,1182.0,0.0
271,272,59,Tang,2015,Environmental Science and Pollution Research,China,28°11'N,113°04'E,Field,28.183000000000003,113.066,1182.0,0.0
272,273,59,Tang,2015,Environmental Science and Pollution Research,China,28°11'N,113°04'E,Field,28.183000000000003,113.066,1182.0,0.0
273,274,60,Sanz-Cobena,2014,Science of the Total Environment,Spain,40°03'N,3°31'E,Field,40.05,3.516,1484.0,0.5
274,275,60,Sanz-Cobena,2014,Science of the Total Environment,Spain,40°03'N,3°31'E,Field,40.05,3.516,1484.0,0.5
275,276,60,Sanz-Cobena,2014,Science of the Total Environment,Spain,40°03'N,3°31'E,Field,40.05,3.516,1484.0,0.5
276,277,60,Sanz-Cobena,2014,Science of the Total Environment,Spain,40°03'N,3°31'E,Field,40.05,3.516,1484.0,0.5
277,278,60,Sanz-Cobena,2014,Science of the Total Environment,Spain,40°03'N,3°31'E,Field,40.05,3.516,1484.0,0.5
278,279,60,Sanz-Cobena,2014,Science of the Total Environment,Spain,40°03'N,3°31'E,Field,40.05,3.516,1484.0,0.5
279,280,61,Chantigny,2001,Can.J.Soil Scien.,Canada,46°48'N,71°23'W,Field,46.8,71.383,1469.0,0.0
280,281,61,Chantigny,2001,Can.J.Soil Scien.,Canada,46°48'N,71°23'W,Field,46.8,71.383,1469.0,0.0
281,282,62,Vasconcelos,2018,Biomass and Bioenergy,Brazil,22°41'S,47°33'W,Field,22.683000000000003,47.55,3324.0,0.0
282,283,62,Vasconcelos,2018,Biomass and Bioenergy,Brazil,22°41'S,47°33'W,Field,22.683000000000003,47.55,3324.0,0.0
283,284,62,Vasconcelos,2018,Biomass and Bioenergy,Brazil,22°41'S,47°33'W,Field,22.683000000000003,47.55,3324.0,0.0
284,285,63,Haque,2014,Plant and Soil,South Korea,36°50'N,128°26'E,Field,36.833,128.433,1041.0,0.0
285,286,63,Haque,2014,Plant and Soil,South Korea,36°50'N,128°26'E,Field,36.833,128.433,1041.0,0.0
286,289,64,Jacinthe,2003,Biology and Fertility of Soils,USA,40°00'N,83°01'W,Field,40.0,83.016,1812.0,0.0
287,290,64,Jacinthe,2003,Biology and Fertility of Soils,USA,40°00'N,83°01'W,Field,40.0,83.016,1812.0,0.0
288,291,64,Jacinthe,2003,Biology and Fertility of Soils,USA,40°00'N,83°01'W,Field,40.0,83.016,1812.0,0.0
289,292,64,Jacinthe,2003,Biology and Fertility of Soils,USA,40°00'N,83°01'W,Field,40.0,83.016,1812.0,0.0
290,293,65,Ma,2010,Nutrient Cycling in Agroecosystems,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
291,294,65,Ma,2010,Nutrient Cycling in Agroecosystems,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
292,295,65,Ma,2010,Nutrient Cycling in Agroecosystems,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
293,296,65,Ma,2010,Nutrient Cycling in Agroecosystems,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
294,297,66,Ma,2009,Soil Biology and Biochemistry,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
295,298,66,Ma,2009,Soil Biology and Biochemistry,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
296,299,66,Ma,2009,Soil Biology and Biochemistry,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
297,300,66,Ma,2009,Soil Biology and Biochemistry,China,31°17'N,119°54'E,Field,31.283,119.9,1253.0,0.0
298,301,66,Ma,2009,Soil Biology and Biochemistry,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
299,302,66,Ma,2009,Soil Biology and Biochemistry,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
300,303,66,Ma,2009,Soil Biology and Biochemistry,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
301,304,66,Ma,2009,Soil Biology and Biochemistry,China,31°58'N,119°18'E,Field,31.965999999999998,119.3,1285.0,0.0
302,305,67,Biegemann,2013,proc. grassland Science in Europe,Germany,54°27'N,9°27'E,Field,54.45,9.45,727.0,0.0
303,306,67,Biegemann,2013,proc. grassland Science in Europe,Germany,54°27'N,9°27'E,Field,54.45,9.45,727.0,0.0
304,307,67,Biegemann,2013,proc. grassland Science in Europe,Germany,54°27'N,9°27'E,Field,54.45,9.45,727.0,0.0
305,308,67,Biegemann,2013,proc. grassland Science in Europe,Germany,54°27'N,9°27'E,Field,54.45,9.45,727.0,0.0
306,309,67,Biegemann,2013,proc. grassland Science in Europe,Germany,54°27'N,9°27'E,Field,54.45,9.45,727.0,0.0
307,310,67,Biegemann,2013,proc. grassland Science in Europe,Germany,54°27'N,9°27'E,Field,54.45,9.45,727.0,0.0
308,311,67,Biegemann,2013,proc. grassland Science in Europe,Germany,54°27'N,9°27'E,Field,54.45,9.45,727.0,0.0
309,312,67,Biegemann,2013,proc. grassland Science in Europe,Germany,54°27'N,9°27'E,Field,54.45,9.45,727.0,0.0
310,313,68,Veltholf,2010,Nutrient Cycling in Agroecosystems,The Netherlands,52°26'N,6°13'E,Field,52.433,6.216,757.0,0.0
311,314,68,Veltholf,2010,Nutrient Cycling in Agroecosystems,The Netherlands,52°26'N,6°13'E,Field,52.433,6.216,757.0,0.0
312,315,68,Veltholf,2010,Nutrient Cycling in Agroecosystems,The Netherlands,52°26'N,6°13'E,Field,52.433,6.216,757.0,0.0
313,316,68,Veltholf,2010,Nutrient Cycling in Agroecosystems,The Netherlands,51°18'N,5°36'E,Field,51.3,5.6,826.0,0.0
314,317,68,Veltholf,2010,Nutrient Cycling in Agroecosystems,The Netherlands,51°18'N,5°36'E,Field,51.3,5.6,826.0,0.0
315,318,68,Veltholf,2010,Nutrient Cycling in Agroecosystems,The Netherlands,51°18'N,5°36'E,Field,51.3,5.6,826.0,0.0
316,319,68,Veltholf,2010,Nutrient Cycling in Agroecosystems,The Netherlands,53°10'N,5°48'E,Field,53.166000000000004,5.8,730.0,0.0
317,320,68,Veltholf,2010,Nutrient Cycling in Agroecosystems,The Netherlands,53°10'N,5°48'E,Field,53.166000000000004,5.8,730.0,0.0
318,321,68,Veltholf,2010,Nutrient Cycling in Agroecosystems,The Netherlands,53°10'N,5°48'E,Field,53.166000000000004,5.8,730.0,0.0
319,322,69,Mori,2007,Soil Science and Plant Nutrition,Japan,36°55'N,139°55'E,Field,36.916,139.916,1061.0,0.0
320,323,69,Mori,2007,Soil Science and Plant Nutrition,Japan,36°55'N,139°55'E,Field,36.916,139.916,1061.0,0.0
323,326,71,Pinto,2004,Nutrient Cycling in Agroecosystems,Spain,43°25'N,2°56'W,Field,43.416000000000004,2.9330000000000003,1355.0,0.0
324,327,71,Pinto,2004,Nutrient Cycling in Agroecosystems,Spain,43°25'N,2°56'W,Field,43.416000000000004,2.9330000000000003,1355.0,0.0
325,328,71,Pinto,2004,Nutrient Cycling in Agroecosystems,Spain,43°25'N,2°56'W,Field,43.416000000000004,2.9330000000000003,1355.0,0.0
326,329,71,Pinto,2004,Nutrient Cycling in Agroecosystems,Spain,43°25'N,2°56'W,Field,43.416000000000004,2.9330000000000003,1355.0,0.0
327,330,72,Ernfors,,Unpublished,Sweden,55°39'N,13°6'W,Field,55.666000000000004,13.116,767.0,0.0
328,331,72,Ernfors,,Unpublished,Sweden,55°39'N,13°6'W,Field,55.666000000000004,13.116,767.0,0.0
329,332,72,Ernfors,,Unpublished,Sweden,55°39'N,13°6'W,Field,55.666000000000004,13.116,767.0,0.0
330,333,72,Ernfors,,Unpublished,Sweden,55°39'N,13°6'W,Field,55.666000000000004,13.116,767.0,0.0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment