Spreadsheet: 715445d1611707654-create-table-that-returns-maximum-date-for-multiple-rows-of-matching-data-except-date-sample_data_for-max_date
Sheet: Site_Details_Year

Site | UTM Zone | UTM Easting | UTM Northing | Species | Survey Year | Estimated Area
117357 | 9 | 319620 | 5888268 | Bull thistle (CIRS VUL) | 2019-09-11 00:00:00 | 0.1
117357 | 9 | 319620 | 5888268 | Bull thistle (CIRS VUL) | 2018-08-31 00:00:00 | 0.85
117357 | 9 | 319620 | 5888268 | Burdock species (ARCT SPP) | 2020-07-09 00:00:00 | 3.5
117357 | 9 | 319620 | 5888268 | Burdock species (ARCT SPP) | 2019-09-19 00:00:00 | 1
117357 | 9 | 319620 | 5888268 | Burdock species (ARCT SPP) | 2018-08-31 00:00:00 | 0.002
117357 | 9 | 319620 | 5888268 | Canada thistle (CIRS ARV) | 2019-09-11 00:00:00 | 0.005
117357 | 9 | 319620 | 5888268 | Canada thistle (CIRS ARV) | 2018-08-31 00:00:00 | 0.7
117357 | 9 | 319620 | 5888268 | Cudweed (GNAP ULI) | 2019-09-11 00:00:00 | 0
117357 | 9 | 319620 | 5888268 | Cudweed (GNAP ULI) | 2018-08-31 00:00:00 | 0
117357 | 9 | 319620 | 5888268 | Groundsel (SENE VUL) | 2019-09-11 00:00:00 | 0.005
117357 | 9 | 319620 | 5888268 | Groundsel (SENE VUL) | 2018-08-31 00:00:00 | 0.1
117357 | 9 | 319620 | 5888268 | Oxeye daisy (LEUC VUL) | 2019-09-11 00:00:00 | 0.0002
117357 | 9 | 319620 | 5888268 | Oxeye daisy (LEUC VUL) | 2018-08-31 00:00:00 | 0.006
117357 | 9 | 319620 | 5888268 | Sowthistle species (SONC SPP) | 2019-09-11 00:00:00 | 0
117357 | 9 | 319620 | 5888268 | Sowthistle species (SONC SPP) | 2018-08-31 00:00:00 | 0.3
117357 | 9 | 319620 | 5888268 | Tansy ragwort (SENE JAC) | 2020-07-09 00:00:00 | 0
117357 | 9 | 319620 | 5888268 | Tansy ragwort (SENE JAC) | 2019-09-11 00:00:00 | 0
117357 | 9 | 319620 | 5888268 | Tansy ragwort (SENE JAC) | 2018-08-31 00:00:00 | 0
117357 | 9 | 319620 | 5888268 | Yellow [NAME] (IRIS PSE) | 2020-07-09 00:00:00 | 0
117357 | 9 | 319620 | 5888268 | Yellow [NAME] (IRIS PSE) | 2019-09-11 00:00:00 | 0
117357 | 9 | 319620 | 5888268 | Yellow [NAME] (IRIS PSE) | 2018-08-31 00:00:00 | 0
202963 | 9 | 424042 | 6009368 | Common tansy (TANA VUL) | 2020-09-06 00:00:00 | 0
202963 | 9 | 424042 | 6009368 | Common tansy (TANA VUL) | 2019-09-04 00:00:00 | 0.001
202963 | 9 | 424042 | 6009368 | Common tansy (TANA VUL) | 2019-07-09 00:00:00 | 0
202963 | 9 | 424042 | 6009368 | Common tansy (TANA VUL) | 2018-07-04 00:00:00 | 0
202963 | 9 | 424042 | 6009368 | Creeping [NAME] (RANU REP) | 2020-09-06 00:00:00 | 0.03
202963 | 9 | 424042 | 6009368 | Creeping [NAME] (RANU REP) | 2019-09-04 00:00:00 | 0.025
202963 | 9 | 424042 | 6009368 | Creeping [NAME] (RANU REP) | 2019-07-09 00:00:00 | 0.025
202963 | 9 | 424042 | 6009368 | Creeping [NAME] (RANU REP) | 2018-07-04 00:00:00 | 0.025
202963 | 9 | 424042 | 6009368 | Creeping [NAME] (RANU REP) | 2017-05-31 00:00:00 | 0.09
202963 | 9 | 424042 | 6009368 | Groundsel (SENE VUL) | 2020-09-06 00:00:00 | 0
202963 | 9 | 424042 | 6009368 | Groundsel (SENE VUL) | 2019-09-04 00:00:00 | 0.0005
202963 | 9 | 424042 | 6009368 | Groundsel (SENE VUL) | 2019-07-09 00:00:00 | 0.0005
202963 | 9 | 424042 | 6009368 | Groundsel (SENE VUL) | 2018-09-20 00:00:00 | 0.0005
202963 | 9 | 424042 | 6009368 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2020-09-06 00:00:00 | 0.005
202963 | 9 | 424042 | 6009368 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2019-09-04 00:00:00 | 0.01
202963 | 9 | 424042 | 6009368 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2019-07-09 00:00:00 | 0.0001
202963 | 9 | 424042 | 6009368 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2018-07-04 00:00:00 | 0.0015
202963 | 9 | 424042 | 6009368 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2017-05-31 00:00:00 | 0.0001
202963 | 9 | 424042 | 6009368 | Oxeye daisy (LEUC VUL) | 2020-09-06 00:00:00 | 0.02
202963 | 9 | 424042 | 6009368 | Oxeye daisy (LEUC VUL) | 2019-09-04 00:00:00 | 0.015
202963 | 9 | 424042 | 6009368 | Oxeye daisy (LEUC VUL) | 2019-07-09 00:00:00 | 0.015
202963 | 9 | 424042 | 6009368 | Oxeye daisy (LEUC VUL) | 2018-07-04 00:00:00 | 0.015
202963 | 9 | 424042 | 6009368 | Oxeye daisy (LEUC VUL) | 2017-05-31 00:00:00 | 0.05
202963 | 9 | 424042 | 6009368 | St. John's wort/Saint John's wort/ [NAME] (HYPE PER) | 2020-09-06 00:00:00 | 0
202963 | 9 | 424042 | 6009368 | St. John's wort/Saint John's wort/ [NAME] (HYPE PER) | 2019-09-04 00:00:00 | 0
202963 | 9 | 424042 | 6009368 | St. John's wort/Saint John's wort/ [NAME] (HYPE PER) | 2019-07-09 00:00:00 | 0.0001
204727 | 9 | 424001 | 6009485 | Creeping [NAME] (RANU REP) | 2020-09-06 00:00:00 | 0.03
204727 | 9 | 424001 | 6009485 | Creeping [NAME] (RANU REP) | 2019-09-04 00:00:00 | 0.03
204727 | 9 | 424001 | 6009485 | Creeping [NAME] (RANU REP) | 2019-07-09 00:00:00 | 0.03
204727 | 9 | 424001 | 6009485 | Creeping [NAME] (RANU REP) | 2018-07-04 00:00:00 | 0.03
204727 | 9 | 424001 | 6009485 | Creeping [NAME] (RANU REP) | 2017-05-31 00:00:00 | 0.1
204727 | 9 | 424001 | 6009485 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2020-09-06 00:00:00 | 0
204727 | 9 | 424001 | 6009485 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2019-09-04 00:00:00 | 0
204727 | 9 | 424001 | 6009485 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2019-07-09 00:00:00 | 0
204727 | 9 | 424001 | 6009485 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2018-07-04 00:00:00 | 0.0001
204727 | 9 | 424001 | 6009485 | Oxeye daisy (LEUC VUL) | 2020-09-06 00:00:00 | 0.02
204727 | 9 | 424001 | 6009485 | Oxeye daisy (LEUC VUL) | 2019-09-04 00:00:00 | 0.015
204727 | 9 | 424001 | 6009485 | Oxeye daisy (LEUC VUL) | 2019-07-09 00:00:00 | 0.015
204727 | 9 | 424001 | 6009485 | Oxeye daisy (LEUC VUL) | 2018-07-04 00:00:00 | 0.015
204727 | 9 | 424001 | 6009485 | Oxeye daisy (LEUC VUL) | 2017-05-31 00:00:00 | 0.05
204727 | 9 | 424001 | 6009485 | Yellow hawkweed (HIER PRA) | 2020-09-06 00:00:00 | 0.01
209012 | 9 | 305579 | 5939964 | Bull thistle (CIRS VUL) | 2019-05-16 00:00:00 | 0.0001
209012 | 9 | 305579 | 5939964 | Bull thistle (CIRS VUL) | 2018-05-28 00:00:00 | 0.05
209012 | 9 | 305579 | 5939964 | Canada thistle (CIRS ARV) | 2019-05-16 00:00:00 | 0.1
209012 | 9 | 305579 | 5939964 | Canada thistle (CIRS ARV) | 2018-05-28 00:00:00 | 0.1
209012 | 9 | 305579 | 5939964 | Scotch broom (CYTI SCO) | 2020-06-14 00:00:00 | 1
209012 | 9 | 305579 | 5939964 | Scotch broom (CYTI SCO) | 2019-05-16 00:00:00 | 0.35
209012 | 9 | 305579 | 5939964 | Scotch broom (CYTI SCO) | 2018-05-28 00:00:00 | 1
220414 | 9 | 306202 | 5940644 | Scotch broom (CYTI SCO) | 2019-05-15 00:00:00 | 6.5
220414 | 9 | 306202 | 5940644 | Scotch broom (CYTI SCO) | 2018-05-23 00:00:00 | 6.4
220414 | 9 | 306202 | 5940644 | Scotch broom (CYTI SCO) | 2017-11-08 00:00:00 | 6.5
221570 | 9 | 423990 | 6008813 | Creeping [NAME] (RANU REP) | 2020-09-06 00:00:00 | 0.03
221570 | 9 | 423990 | 6008813 | Creeping [NAME] (RANU REP) | 2019-09-04 00:00:00 | 0.03
221570 | 9 | 423990 | 6008813 | Creeping [NAME] (RANU REP) | 2019-07-09 00:00:00 | 0.03
221570 | 9 | 423990 | 6008813 | Creeping [NAME] (RANU REP) | 2018-07-04 00:00:00 | 0.03
221570 | 9 | 423990 | 6008813 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2020-09-06 00:00:00 | 0
221570 | 9 | 423990 | 6008813 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2019-09-04 00:00:00 | 0
221570 | 9 | 423990 | 6008813 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2019-07-09 00:00:00 | 0.001
221570 | 9 | 423990 | 6008813 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2018-07-04 00:00:00 | 0.0001
221570 | 9 | 423990 | 6008813 | Oxeye daisy (LEUC VUL) | 2020-09-06 00:00:00 | 0.03
221570 | 9 | 423990 | 6008813 | Oxeye daisy (LEUC VUL) | 2019-09-04 00:00:00 | 0.025
221570 | 9 | 423990 | 6008813 | Oxeye daisy (LEUC VUL) | 2019-07-09 00:00:00 | 0.025
221570 | 9 | 423990 | 6008813 | Oxeye daisy (LEUC VUL) | 2018-07-04 00:00:00 | 0.025
221570 | 9 | 423990 | 6008813 | Yellow hawkweed (HIER PRA) | 2020-09-06 00:00:00 | 0.02
246083 | 9 | 305672 | 5942541 | Scotch broom (CYTI SCO) | 2020-08-23 00:00:00 | 2.25
246083 | 9 | 305672 | 5942541 | Scotch broom (CYTI SCO) | 2019-05-16 00:00:00 | 0.0001
246515 | 9 | 305464 | 5940283 | Bull thistle (CIRS VUL) | 2018-05-28 00:00:00 | 0.25
246515 | 9 | 305464 | 5940283 | Canada thistle (CIRS ARV) | 2018-05-28 00:00:00 | 0.5
246515 | 9 | 305464 | 5940283 | Scotch broom (CYTI SCO) | 2020-06-14 00:00:00 | 1.5
246515 | 9 | 305464 | 5940283 | Scotch broom (CYTI SCO) | 2018-05-28 00:00:00 | 2
246515 | 9 | 305464 | 5940283 | Scotch broom (CYTI SCO) | 2017-05-01 00:00:00 | 1
268607 | 9 | 305367 | 5940167 | Scotch broom (CYTI SCO) | 2020-06-14 00:00:00 | 1
278893 | 9 | 305676 | 5939953 | Scotch broom (CYTI SCO) | 2019-05-25 00:00:00 | 1
293242 | 9 | 424002 | 6008698 | Creeping [NAME] (RANU REP) | 2020-09-06 00:00:00 | 0.04
293242 | 9 | 424002 | 6008698 | Creeping [NAME] (RANU REP) | 2019-09-04 00:00:00 | 0.04
293242 | 9 | 424002 | 6008698 | Creeping [NAME] (RANU REP) | 2019-07-09 00:00:00 | 0.04
293242 | 9 | 424002 | 6008698 | Creeping [NAME] (RANU REP) | 2018-07-04 00:00:00 | 0.04
293242 | 9 | 424002 | 6008698 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2020-09-06 00:00:00 | 0.015
293242 | 9 | 424002 | 6008698 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2019-09-04 00:00:00 | 0.015
293242 | 9 | 424002 | 6008698 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2019-07-09 00:00:00 | 0.005
293242 | 9 | 424002 | 6008698 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2018-07-04 00:00:00 | 0.005
293242 | 9 | 424002 | 6008698 | Oxeye daisy (LEUC VUL) | 2020-09-06 00:00:00 | 0.02
293242 | 9 | 424002 | 6008698 | Oxeye daisy (LEUC VUL) | 2019-09-04 00:00:00 | 0.02
293242 | 9 | 424002 | 6008698 | Oxeye daisy (LEUC VUL) | 2019-07-09 00:00:00 | 0.02
293242 | 9 | 424002 | 6008698 | Oxeye daisy (LEUC VUL) | 2018-07-04 00:00:00 | 0.02
293242 | 9 | 424002 | 6008698 | Yellow hawkweed (HIER PRA) | 2020-09-06 00:00:00 | 0.02
293242 | 9 | 424002 | 6008698 | Yellow hawkweed (HIER PRA) | 2019-09-04 00:00:00 | 0.02
293242 | 9 | 424002 | 6008698 | Yellow hawkweed (HIER PRA) | 2019-07-09 00:00:00 | 0.02
293242 | 9 | 424002 | 6008698 | Yellow hawkweed (HIER PRA) | 2018-07-04 00:00:00 | 0.02
293246 | 9 | 424065 | 6008897 | Common tansy (TANA VUL) | 2020-09-06 00:00:00 | 0
293246 | 9 | 424065 | 6008897 | Common tansy (TANA VUL) | 2019-09-04 00:00:00 | 0.001
293246 | 9 | 424065 | 6008897 | Common tansy (TANA VUL) | 2019-07-09 00:00:00 | 0.0005
293246 | 9 | 424065 | 6008897 | Common tansy (TANA VUL) | 2018-07-04 00:00:00 | 0.0005
293246 | 9 | 424065 | 6008897 | Creeping [NAME] (RANU REP) | 2020-09-06 00:00:00 | 0.03
293246 | 9 | 424065 | 6008897 | Creeping [NAME] (RANU REP) | 2019-09-04 00:00:00 | 0.03
293246 | 9 | 424065 | 6008897 | Creeping [NAME] (RANU REP) | 2019-07-09 00:00:00 | 0.03
293246 | 9 | 424065 | 6008897 | Creeping [NAME] (RANU REP) | 2018-07-04 00:00:00 | 0.03
293246 | 9 | 424065 | 6008897 | Creeping [NAME] (RANU REP) | 2017-05-31 00:00:00 | 0.1
293246 | 9 | 424065 | 6008897 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2020-09-06 00:00:00 | 0.01
293246 | 9 | 424065 | 6008897 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2019-09-04 00:00:00 | 0.015
293246 | 9 | 424065 | 6008897 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2019-07-09 00:00:00 | 0
293246 | 9 | 424065 | 6008897 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2018-07-04 00:00:00 | 0.0025
293246 | 9 | 424065 | 6008897 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2017-05-31 00:00:00 | 0.0001
293246 | 9 | 424065 | 6008897 | Orange hawkweed (HIER AUR) | 2020-09-06 00:00:00 | 0.001
293246 | 9 | 424065 | 6008897 | Orange hawkweed (HIER AUR) | 2019-07-09 00:00:00 | 0.001
293246 | 9 | 424065 | 6008897 | Oxeye daisy (LEUC VUL) | 2020-09-06 00:00:00 | 0.02
293246 | 9 | 424065 | 6008897 | Oxeye daisy (LEUC VUL) | 2019-09-04 00:00:00 | 0.02
293246 | 9 | 424065 | 6008897 | Oxeye daisy (LEUC VUL) | 2019-07-09 00:00:00 | 0.02
293246 | 9 | 424065 | 6008897 | Oxeye daisy (LEUC VUL) | 2018-07-04 00:00:00 | 0.02
293246 | 9 | 424065 | 6008897 | Oxeye daisy (LEUC VUL) | 2017-05-31 00:00:00 | 0.005
293246 | 9 | 424065 | 6008897 | Yellow hawkweed (HIER PRA) | 2020-09-06 00:00:00 | 0.01
293246 | 9 | 424065 | 6008897 | Yellow hawkweed (HIER PRA) | 2019-09-04 00:00:00 | 0.001
293246 | 9 | 424065 | 6008897 | Yellow hawkweed (HIER PRA) | 2019-07-09 00:00:00 | 0.001
293246 | 9 | 424065 | 6008897 | Yellow hawkweed (HIER PRA) | 2018-07-04 00:00:00 | 0.001
312115 | 9 | 318845 | 5889987 | Bull thistle (CIRS VUL) | 2020-07-09 00:00:00 | 0.02
312115 | 9 | 318845 | 5889987 | Bull thistle (CIRS VUL) | 2019-09-11 00:00:00 | 0.1
312115 | 9 | 318845 | 5889987 | Canada thistle (CIRS ARV) | 2019-09-11 00:00:00 | 0.01
312115 | 9 | 318845 | 5889987 | Tansy ragwort (SENE JAC) | 2020-07-09 00:00:00 | 0
312115 | 9 | 318845 | 5889987 | Tansy ragwort (SENE JAC) | 2019-09-11 00:00:00 | 0
312115 | 9 | 318845 | 5889987 | Tansy ragwort (SENE JAC) | 2018-08-31 00:00:00 | 0
312115 | 9 | 318845 | 5889987 | Tansy ragwort (SENE JAC) | 2017-09-19 00:00:00 | 0
320036 | 9 | 417531 | 6018392 | Oxeye daisy (LEUC VUL) | 2017-06-01 00:00:00 | 0.002
320036 | 9 | 417531 | 6018392 | Spotted hawkweed (HIER MAC) | 2017-06-01 00:00:00 | 0.005
320036 | 9 | 417531 | 6018392 | St. John's wort/Saint John's wort/ [NAME] (HYPE PER) | 2017-06-01 00:00:00 | 0.002
320037 | 9 | 417499 | 6017949 | Bull thistle (CIRS VUL) | 2018-07-27 00:00:00 | 0.005
320037 | 9 | 417499 | 6017949 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2018-07-27 00:00:00 | 0.04
320037 | 9 | 417499 | 6017949 | Marsh plume thistle/Marsh thistle (CIRS PAL) | 2017-06-01 00:00:00 | 0.006
320037 | 9 | 417499 | 6017949 | Meadow [NAME] (RANU ACR) | 2018-07-27 00:00:00 | 0.03
320037 | 9 | 417499 | 6017949 | Oxeye daisy (LEUC VUL) | 2018-07-27 00:00:00 | 0.025
320037 | 9 | 417499 | 6017949 | Spotted knapweed (CENT BIE) | 2018-07-27 00:00:00 | 0.04
320037 | 9 | 417499 | 6017949 | St. John's wort/Saint John's wort/ [NAME] (HYPE PER) | 2018-07-27 00:00:00 | 0.0075
320037 | 9 | 417499 | 6017949 | Yellow hawkweed (HIER PRA) | 2018-07-27 00:00:00 | 0.02
336785 | 9 | 305673 | 5943676 | Scotch broom (CYTI SCO) | 2018-04-25 00:00:00 | 0.001
337985 | 9 | 305829 | 5942689 | Scotch broom (CYTI SCO) | 2019-05-26 00:00:00 | 0.1
337985 | 9 | 305829 | 5942689 | Scotch broom (CYTI SCO) | 2018-09-06 00:00:00 | 0.15
340014 | 9 | 305959 | 5945011 | Scotch broom (CYTI SCO) | 2018-08-29 00:00:00 | 0
340015 | 9 | 305858 | 5944465 | Scotch broom (CYTI SCO) | 2018-08-29 00:00:00 | 0
341689 | 9 | 317223 | 5994980 | Yellow archangel (LAMI GAL) | 2019-04-05 00:00:00 | 0.001
342113 | 9 | 306154 | 5940312 | Scotch broom (CYTI SCO) | 2020-06-19 00:00:00 | 1.5
342113 | 9 | 306154 | 5940312 | Scotch broom (CYTI SCO) | 2019-05-16 00:00:00 | 0.5
344413 | 9 | 424196 | 6008730 | Creeping [NAME] (RANU REP) | 2020-09-06 00:00:00 | 1
344413 | 9 | 424196 | 6008730 | Meadow [NAME] (RANU ACR) | 2020-09-06 00:00:00 | 0.5
344413 | 9 | 424196 | 6008730 | Oxeye daisy (LEUC VUL) | 2020-09-06 00:00:00 | 0.5
344413 | 9 | 424196 | 6008730 | St. John's wort/Saint John's wort/ [NAME] (HYPE PER) | 2020-09-06 00:00:00 | 0.01
344413 | 9 | 424196 | 6008730 | St. John's wort/Saint John's wort/ [NAME] (HYPE PER) | 2019-09-04 00:00:00 | 0.005
344413 | 9 | 424196 | 6008730 | Yellow hawkweed (HIER PRA) | 2020-09-06 00:00:00 | 0.5
344932 | 9 | 318926 | 5890300 | Tansy ragwort (SENE JAC) | 2019-09-11 00:00:00 | 0.0001
349792 | 8 | 694649 | 5991077 | Scotch broom (CYTI SCO) | 2020-06-26 00:00:00 | 1.5
350834 | 9 | 424033 | 6009053 | Common tansy (TANA VUL) | 2020-09-06 00:00:00 | 0.0001
350834 | 9 | 424033 | 6009053 | Creeping [NAME] (RANU REP) | 2020-09-06 00:00:00 | 0.02
350834 | 9 | 424033 | 6009053 | Oxeye daisy (LEUC VUL) | 2020-09-06 00:00:00 | 0.01
350834 | 9 | 424033 | 6009053 | Yellow hawkweed (HIER PRA) | 2020-09-06 00:00:00 | 0.01