Data Scenario: Vector data needs reformatting

Data issue
File Name Modified
kcbcc_DS4_final_v2_final.xlsx 8/2/23, 8:53:13 PM
kcbcc_DS4_final_v2_final.vrt 8/2/23, 8:53:13 PM
solution-ogr2ogr_with_sql.sh 8/2/23, 8:53:13 PM
solution-ogr2ogr_with_vrt.sh 8/2/23, 8:53:13 PM
No matching items

You read a research publication about correlation between the chemistry of blood samples taken from 12 kittens found on the Greenland Ice Sheet and their subjective cuteness as rated by 100 randomly-selected graduate students. The paper includes graphs and some limited data tables, but after searching for hours you can not find the full data file(s) used to draw the conclusions in this study.

You email Dr. Foobarbaz to ask them for help. Where can you get the source data so you can do your own analyses?

Dr. Foobarbaz responds:

Fellow scientist,

Thank you for your interest in my work. I appreciate that you would like to see the source
data. I wish I remembered where I was keeping that data, but I do not. I have several
laptops in storage that I will need to boot up and search for this file.

I will get back to you!

Dr. Foobarbaz

Three weeks later, Dr. Foobarbaz diligently follows up:

Fellow scientist,

I found several candidates for the final dataset used to produce that study. I am almost
completely certain that the attached file is the correct one. Please let me know if you
have any issues using this. The x/y spatial coordinates are in lat/lon WGS84 projection.

Best of luck.

Dr. Foobarbaz

You download the attachment kcbcc_DS4_final_v2_final.xlsx.

kcbcc_DS4_final_v2_final.xlsx

Validation

The resulting solution file should be openable in QGIS and display data points over Greenland.

Solution shown along with QGreenland