Open marthajensen opened 3 years ago
marthajensen
commented
2 years ago @Vandenberg5
The data in the app has been replaced with the newest data. It looks like some UV photos had been relinked to our data but I went through and deleted all the UV photos I could find (like we did last time). It doesn't look like Katie is on Github yet or else I would tag her
Let me know if you see issues
marthajensen
commented
2 years ago @Vandenberg5
Below is the replacement database for the rockcore application. This database will replace the download in the "About" section of the app
DownloadReplacement_07Feb22_ucrc_cores.xlsx
I created the spreadsheet by joining the new wells data to the new inventory data. I noticed the "state" column has some integer values in it, rather than the abbreviation for the state (check closer to the bottom of the spreadsheet - you'll see the integer '49' data instead of the state abbreviation). I'm not sure what the integer values mean.
When you have time, please review the database before I make it live on the web. Once the downloadable database is replaced, all data on the app will be the newest data.
Thanks! Martha
Vandenberg5
commented
2 years ago Martha,
This spreadsheet is equivalent to the box inventory (90,000+ records), the download in question is a well inventory (7000+ records).
Mike
On Mon, Feb 7, 2022 at 2:04 PM Martha Jensen @.***> wrote:
@Vandenberg5 https://github.com/Vandenberg5
Below is the replacement database for the rockcore application. This database will replace the download in the "About" section of the app
DownloadReplacement_07Feb22_ucrc_cores.xlsx https://github.com/UGS-GIO/rockcore/files/8018674/DownloadReplacement_07Feb22_ucrc_cores.xlsx
[image: image] https://user-images.githubusercontent.com/11522897/152870725-0bfe7950-ce19-4dcf-9b30-7da7f3da76b5.png
I created the spreadsheet by joining the new wells data to the new inventory data. I noticed the "state" column has some integer values in it, rather than the abbreviation for the state (check closer to the bottom of the spreadsheet - you'll see the integer '49' data instead of the state abbreviation). I'm not sure what the integer values mean.
When you have time, please review the database before I make it live on the web. Once the downloadable database is replaced, all data on the app will be the newest data.
Thanks! Martha
— Reply to this email directly, view it on GitHub https://github.com/UGS-GIO/rockcore/issues/33#issuecomment-1031922140, or unsubscribe https://github.com/notifications/unsubscribe-auth/AQUWTZNIEOFYDRKTGUHR6A3U2AXW3ANCNFSM45FK3HOQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
You are receiving this because you were mentioned.Message ID: @.***>
-- Michael D. Vanden Berg, P.G. Energy and Minerals Program Manager, Senior Geologist Utah Geological Survey 1594 W. North Temple, Suite 3110, Salt Lake City, UT 84116 801-538-5419 (o); 801-419-6577 (m) @.***
Description of data you're adding to an existing layer/database
The UCRC inventory and well sites need to be updated (overwritten) with new data from Peter. He is currently working on updating his photographs table and will provide a new spreadsheet for that soon.
Email from Peter to Martha on 5/19/21:
"Martha
I have uploaded our latest three tables from the inventory dated 05-19-2021. It can be found at the same location below. I removed the older inventory directory. We converted all the UTMS to zone 12 as well as fixed a few locations that didn't plot where they should be. Let me know if you have any questions.
U:\UGSSharedResources\UCRC_Inventory\Inventory_05-19-2021"
Follow up email from Peter (5/19/21)
"Let me know if I can help. I use MS Access to manage the database here at the core center. It is located at the same location under UCRC_Catalog. You can probably connect to it with you Administrator data manager software and see the tables and add the data directly into your TEMP_DATABASE, or process the data as you add it to the TEMP_DATABASE. Besides the 3 main tables, I have a projects table that I'm building that will relate to the other tables and stores our UCRC projects relating to the inventory. There is also a codes table that has all my definitions for our different projects."