Complete Ownership Review | Open Data Quality Review - Initial Round 2024

[KaroEngstrom]

Wed 5/8/24

In This Issue

• Small Sets of Non-DTS Assets
• Legacy PWD Assets
• TPW PIO Assets
• Corridor Program Office CPO Assets
• Urban Trails and Safe Routes to School Story Assets
• Ownership Teams
• Transferring Ownership and ETLs
• SBO

Teams in EDP

• CTM added a basic ownership team; turned this into a DTS data owner team we can use for transportation.data
• Added two teams: TPW PIO and TPW CPO for expected teams
• More teams will be added as needed

Ownership Review

• Using the spreadsheet here, we need to review all asset ownership and move all asset into teams ownership (no more individual owners)

[KaroEngstrom]

Small Sets of Non-DTS Owner Assets

• [Future Fire Station Project Schedule ] (https://datahub.austintexas.gov/Public-Safety/Future-Fire-Station-Project-Schedule-April-3-2023/5t5f-iesb/about_data)

  • ➡️ Messaged Laura A. (listed as owner) at Fire 5/8/24
  • response: "I think we can go ahead and take it down at this point. I appreciate you asking!"
  • CTM Request to move this over to us to delete: INC0391206
  • made this an internal asset on 5/9/24 ✅

• Surbhi (1 asset)

  • ➡️ Reached out to Surbhi to transfer ownership to us; done ✅ Thu 5/9/24

[KaroEngstrom]

Legacy PWD Assets

• 64 assets owned by Public Works Department Publisher owned by John V. at Capital Services
• list of assets here with comments from OPM
• email to John V. and Bryan T. at Capital Delivery Services to ask for help with ownership transfer and any existing ETL knowledge - Fri 5/10/24
• talked to Adrianne Thu 5/16/24, her team will help facilitate the transfer of these assets to us

[KaroEngstrom]

TPW PIO Assets

• Wed 5/8/24 emailed Jeff S. and team regarding their assets, listed here
• TPW PIO team will assess and transfer ownership by Thu 5/16/24 🙏
• Melissa is helping with the transfer, multiple issues coming up in ServiceNow

Issue Number	Notes	Completed?	Updated in spreadsheet?
INC0392590	Transfer Ownership of 4 Private and Internal Assets in the City Data Hub owned by Giovanna B. to the TPW PIO Data Owners (Transportation Public Works) team	Yes	No
INC0392591	Removed 60 Shared Assets from Giovanna B. in the City Data Hub	Yes	Yes
INC0391988	Transfer Data Asset Ownership to TPW PIO Data Owners (Transportation Public Works) Team	-------	-------
INC0392616	Transfer Ownership of Private and Internal Assets in the City Data Hub - Kelly B.	Yes	Yes
INC0392622	Remove Shared Assets from non-TPW Users in the City Data Hub - Kelly B.	Yes	Yes
INC0392627	Transfer Ownership of Private and Internal Assets in the City Data Hub - Sarah B.	Yes	Yes
INC0392651	Transfer Ownership of Private and Internal Assets in the City Data Hub - Zach A.	-------	-------
--------	-------	-------	-------

Capital Delivery Services PIO Assets ✅

• four stories owned by Amy B., who is out until July 24
• emailed her referred contact Andres C. about how to proceed Mon 5/13/24
• Andres wants these to be CDS; put in an SN ticket 5/15/24 #️⃣ INC0393494
• moved to CDS, marked as no longer ours in our spreadsheet

Mon 7/8/24

• emailed Jeff for a promised update on the legacy CPO assets and how to deal with the PIO assets:
  • Legacy CPO Assets (61 items; 44 public)
  • TPW PIO Assets (71 items; 59 public)

[KaroEngstrom]

Corridor Program Office CPO Assets

• Jeff S. from PIO also noted that CPO is no longer a unit and those assets should go to either PIO or to Amy B. depending on how they were assigned last year with Trisha R. (then the point person)
• nearly all CPO assets were assigned to CPO
• [x] Request ownership of the CPO assets from CTM - Fri 5/10/24 INC0391988
  • this included the CPO assets and Giovanna B. assets, per PIO/Jeff S. request
• these are transferred by CTM, thank you 🙏

[KaroEngstrom]

Ownership Teams

• Liaisons: log in using personal SSO; navigate to Administration > Teams; search TPW
  0. Transportation Data Service Account ⭐
     • per Melissa on the EDA team, we can retain this account as an individual owner for our DTS assets because it's not a named account. This will also help keep our ETLs intact.
  1. CTM-created owner group turned into TPW DTS
     • DTS Liaisons and Service Account
  2. TPW PIO Data Owners
     • DTS Liaisons and Service Account
  3. TPW CPO
     • DTS Liaisons and Service Account

[KaroEngstrom]

Transferring Ownership and ETLs

• asking the CTM Enterprise Data Analytics team via Teams: I have a major concern about transferring ownership on assets that have active automation scripts coming into them, and in few cases out of them. We have a few that update every five minutes but most are daily or hourly. My worry is that the ETL will break when the owner is changed, even when that owner entity is now an Owner in the group that ownership was transferred to. 1. Is there a tutorial/documentation for this? I may have missed it in the guides. 2. Do we have vendor documentation confirming what happens in those situations? 3. When you tested everything with the two pilot departments, what did you find out? I used to work at DSD IT and can check with them if they've done this conversion.

[KaroEngstrom]

Urban Trails and Safe Routes to School Story Assets

• a small number of assets owned by Cheyenne listed [here] (https://cityofaustin.sharepoint.com/:x:/r/sites/tpwDTS/_layouts/15/Doc.aspx?sourcedoc=%7B085A812D-DB8E-4664-A52D-7B5C2BD9C185%7D&file=Cheyenne_Assets.xlsx&wdLOR=c027E8DA1-72CE-6243-9D2E-77DFF54828E2&action=default&mobileredirect=true)
• emailed Coleen (SRTS) and Nathan/John (Urban Trails) to request their input on ownership and public status 📧 Mon 5/13/24
• Coleen listed potential owners (mostly John E. and Amir E. )

Major Capital Improvements story

• Coleen suggested to check with Paulinda L. at CDS
• Paulinda says: "The program belongs to TPW. Laurie T. is managing the Longhorn Dam Bridge, Congress Avenue is being managed by Laura D., I am managing the Barton Springs Road Bridge, and I would check with Randy H. about the South Pleasant Valley Road Corridor project. I believe Anna M. from TPW is the Asst. Director over the program."
• [ ] Need to follow up on this asset

Mon 7/8/24

• emailed Amir E. with CDS assets:
  • District 6 Safe Routes to School Projects
  • District 4 Safe Routes to School Projects
  • District 7 Safe Routes to School Project
  • District 5 Safe Routes to School Projects
  • District 3 Safe Routes to School Projects
  • District 9 Safe Routes to School Projects
  • District 8 Safe Routes to School Projects
  • District 2 Safe Routes to School Projects
  • District 1 Safe Routes to School Projects
  • District 10 Safe Routes to School Projects
  • Safe Routes to School Improvement Projects
  • Austin Woods Drive Safe Routes to School Improvements
    • 📆 Meeting scheduled for Mon 7/15 with Amir, Coleen, Emily, and Anna; postponed to 8/5/24
• emailed John E. with Urban Trails assets
  • Country Club Creek Trail
  • Red Line Trail
  • Walnut Creek Trail System
  • La Loma Trail
  • Austin to Manor Trail
    • 📧 Heard back from John; reached out to Chris V. to discuss
    • Set up a meeting with Chris and Justin next Wed 7/17/24
    • met with the Urban Trails team and Robert A. from Capital Delivery
    • all these assets except La Loma Trail should be transferred over to Capital Delivery
    • put in a request for this and emailed CTM + Bryan T. the CDS Liaison to make sure everyone is in the loop
    • the La Loma asset is internal and John/Urban Trails will need to check with Jeff/PIO to see how to proceed; I also mentioned that we will collaborate with PIO in a few weeks
    • since most assets will move over to CDS or are created by them, there is no reason or plan at this time to have anyone from Urban Trails train for elevated permissions in the Enterprise Data Portal

[KaroEngstrom]

SBO

• ➡️ Dave is out of office; set up a review huddle with him for Wed 5/22
• Going to ask about other assets for SBO
• Met with Dave 5/22/24
  • Dave
    • will review the SBO assets (his and Arijit's)
    • has access to the PWD Legacy assets and can assign some from there to TPW SBO Data Owners
    • wants to add Richard to the owner team but Richard doesn't seem to have an account
  • Karo
    • [x] will put in a request to move over the Arijit's assets INC0395617
    • [x] create TPW SBO Data Owners team in the EDP
    • [x] Email Dave with legacy PWD and the SBO info for his review
    • [x] Notify CTM that we have owner access (via Dave) to the PWD legacy owner team