NBMG-UNR / resourcespace-migration

Code and tasks related to migrating GBSSRL into a CMS
0 stars 1 forks source link

General Geology #4

Open emilyodean opened 4 years ago

emilyodean commented 4 years ago

Our general geology files should also be formatted, cleaned, and readied for ingestion into ResourceSpace.

general_geology_01212020.xlsx

emilyodean commented 4 years ago

This will look very similar to the work done for the engineering files. https://github.com/NBMG-UNR/resourcespace-migration/blob/master/clean_engineering_files.py.

Need to read the file in, rename columns, and also convert the UTMs to lat/lon columns. Column names should be translated as follows:

NUM -> id AREA -> index_location TITLE -> title AUTHOR -> author DATE -> date NOTES -> notes UTMN_NAD27 -> latitude UTME_NAD27 -> longitude

Also, as in the engineering files, I want all of the IDs to be replaced with a keyword and 4 digits. In this case, it should be "geo0001," geo0002," etc.

emilyodean commented 4 years ago

@lweeks20 work on this after the mining district file counties and districts are cleaned up. This is a little more straightforward than the other airphotos ticket, so I'm going to remove you from that one and assign you to this one for now.

emilyodean commented 4 years ago

@lweeks20 to finish out this ticket, please print the dataframe to a new excel file (named with the current date) and attach it to this ticket, then tag me.

lweeks20 commented 4 years ago

general_geology_03032020.xlsx @emilyodean