search

agrc / planning-queue

A place to manage issues that do not have a dedicated repository or code... yet.
MIT License
0 stars 0 forks source link

UGRC MATT - DB Schema and Data links #76

Closed nathankota closed 1 year ago

nathankota commented 1 year ago

UGRC data stewardship - Metadata and Asset Tracking Tool (MATT)

Statement of Need/Objective

Over time, the existing sheet used by UGRC staff to inform our SGID data update process has become outdated and no longer suits the intricacies of the actual data update lifecycle. We need a more advanced and robust system to manage all aspects of the lifecycle of SGID data sets. Ultimately, we seek to create a centralized, single source of truth place and associated processes for SGID metadata (both UGRC and data layer) to be captured, managed, and distributed to all necessary SGID access points, whether the UGRC website, AGOL/open data, Open SGID, internal database, and so forth. A more fully integrated data stewardship process to merge all the existing disparate parts of SGID and data management. Having a single source of truth is an ideal goal so that all facets of the SGID (agol, open sgid, etc.) are updated and operating from the same data.

Benefit Hypothesis

Begin building the data foundation for the MATT system.

Acceptance Criteria

nathankota commented 1 year ago

Future Features/Tasks

References

Expected outcomes and action items are defined in the notes document and lucid board.

nathankota commented 1 year ago

Sprint 5 Tasks

gregbunce commented 1 year ago

is @ZachBeck out of town that day?

nathankota commented 1 year ago

is @ZachBeck out of town that day?

he said it should work

ZachBeck commented 1 year ago

I always have time for MATT

jacobdadams commented 1 year ago

Couple of links from the FOSS4G conference videos that have been trickling out the last week or so:

steveoh commented 1 year ago

Those links are confusing to me. They seem related to software that competes with arcgis online and open data. We aren't looking to replace those right?

jacobdadams commented 1 year ago

No, you're right. I'm just wondering if we can use some of the underlying tools for our metadata tracking/storage rather than roll our own. And maybe I'm conflating MATT with an idea for a new, all-in-one SGID Index.

On Wed, Sep 6, 2023 at 9:25 AM steveoh @.***> wrote:

Those links are confusing to me. They seem related to software that competes with arcgis online and open data. We aren't looking to replace those right?

— Reply to this email directly, view it on GitHub https://github.com/agrc/planning-queue/issues/76#issuecomment-1708597475, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJDGLXUMT2ERH4SK5IVDH5TXZCIUXANCNFSM6AAAAAAW4DSZEE . You are receiving this because you were assigned.Message ID: @.***>

nathankota commented 1 year ago

https://docs.google.com/spreadsheets/d/15klUwf3IGEi-1HvPeviFtnjfVO_HClVU7Qw9DSzp470/edit#gid=0

nathankota commented 1 year ago

Not as much time was spent on this as hoped, but we were able to do a first pass of the stewardship sheet and app list in service now.