Paleo Localities Project

[CyndiAndersen]

What GIS product are you requesting?

New feature class

Check all that apply

• [ ] ArcMap
• [X] ArcGIS Pro
• [ ] This is a StateMap Project

Describe your requested GIS product.

Create a new feature class from the Paleo Access DB and add fields to hyperlink the Localities form and Supplemental information. New FC will be accessible in Portal for internal use.

When is this GIS product needed?

n/a

How Urgent is this?

Medium

If high urgency, please explain.

No response

Where is existing GIS, map and/or supporting info currently stored?

Access DB - G:\Shared drives\UGS_Paleo\Paleo

Where to save new GIS product?

postgres.geology.utah.gov

Please list Project Code to charge time.

No response

[CyndiAndersen]

5/4/2022

• Met with Martha to discuss comparing the two databases:
• Martha created a folder on the Shared Drive (Martha- Paleo), within each she put a notepad document that describes the files in each folder. "G:\Shared drives\UGS_Shared\Martha\Paleo\NotesAboutThisData.txt" "G:\Shared drives\UGS_Shared\Martha\Paleo\Project_start_data_2017\NotesAboutThisData.txt" and "G:\Shared drives\UGS_Shared\Martha\Paleo\domains\NotesAboutThisData.txt"

4/12/2022

• Tried to publish the new FC to Portal

3/30/2022

• Export from Access DB: rt. click table>Export>txt file and change to .csv, be sure to check comma delimited
• Add the new table to Pro, rt. click, Display XY data
• Export the displayed localities layer to an FC
• Add editor tracking
• Added URL fields for PDF locality and the Supplement folder

3/15/2022 Currently Paleo creates a .pdf of every locality form

• G:\Shared drives\UGS_Paleo\2022 Archive Project\ <#county> \Localities
• Access DB - G:\Shared drives\UGS_Paleo\Paleo Database\ULDS_v2.9.3.accdb
• Need to create new fields in the feature class
  • Locality_URL
  • Sup_URL ??? Can we create a hyperlink to a folder??? NEED TO:
• Create a web enabled folder(s) for Paleo on the Portal Server (RDT) Use similar path as the G:\
• Martha - will create a new empty DB for all new entries on the Portal Server
• We will use the existing DB to transition and upload to Portal
• Cyndi - need to create users for Martha and Paleo group
• Have Atilio create Web Folder - \portal.geology.utah.gov\PaleoWeb

[CyndiAndersen]

5/19/2022

• Moved the Paleo working folder to G:\Shared drives\UGS_Shared\GIS\Paleo

5/18/2022

• Met with Martha J to share progress on this project.
• Hyperlink fields work on the test feature class
• New db connection to postres.geology.utah.gov and the mapping.sde.paleo.Localities_TEST feature class.
• Published PaleoLocalities_TEST to Portal in the Paleo folder

[marthajensen]

Meeting 8/30/22 Martha J notes

The plan is: Add auto update date field to Access database Create an Arcgis web database on the UGS portal web server using the Access database and Don's database (merge the two) Add URL fields to the web database that have links to open a locality form and any supplemental information Create an interface for editing the web database

Access database: The location of a copy of the Access database is at: "G:\Shared drives\UGS_Paleo\Paleo Database\ULDS_v2.9.3.accdb" (there is a newer version on Martha H's computer)

Access database notes in more detail: Martha J asked if we should add a date modified field to the Access database so that we can track updates. This is a YES - I will add auto-update date field to Martha H's main access database. Her database is currently on her home computer but she is going to reach out to Marshall and get Google Drive on her home computer. Once she does that, she will start using Google Drive as the main database location. Once she is ready to use Google Drive, I will add the record_update field (date tracking of last edit/date data was added).

ArcGIS web database in more detail: Martha J will merge the Access database with Don's database. She will also add URL fields to the web database. Martha J. will meet with Ben and show him how to create URL's for each locality so that we can have live links to the data. Once this is done, Martha J. will create an interface for editing data

Powerpoint slides: Stefan asked for a couple of powerpoint slides that summarize the locality database. Martha J. will convert the access database data to ArcGIS and show Ben how to run statistics on the data.

Geologic Map: Martha could use a copy of the Notch Peak map in her GIS. Stefan thinks there may be a hard copy of the map in Mapping.