agrc / porter

UGRC tracks the additions, replacements, and deletions of SGID items (in the broadest sense of add, replace, or delete) through issues in this repository.
https://gis.utah.gov/documentation/policy/
MIT License
2 stars 0 forks source link

Add Housing Unit Inventory from WFRC zipfile #171

Closed brigsz closed 2 years ago

brigsz commented 2 years ago

Summary

This data came from WFRC, they did the work on some Wasatch front counties. Now Jake of UGRC is to do other counties

The data should be available in

1 Check [x] all the areas where you expect the data to show up.

The data is of high quality

Where is the data source

Choose one.

Action items

  1. Assign a person who should complete the task by replacing name with their github @name.
  2. Check [x] the box when the task is completed and add the date of completion.
  3. ~Strike~ out all items that do not apply.

:robot: Automation validation

  1. Assign yourself or someone to check the item by replacing name with their github @name.
  2. Check [x] the box and add the date of verification 2020/01/01 when the task is verified.
  3. ~Strike~ out all items that do not apply.

Notification

Group Task Assignments

  1. Check [x] the box when you have assigned all the tasks relevant to your group.
steveoh commented 2 years ago

conductor results for tasks - 171

check status
@gregbunce has completed 1 out of 6 tasks :no_entry:
brigsz has completed 1 out of 1 tasks :+1:
@steveoh has completed 1 out of 7 tasks :no_entry:
@stdavis has completed 0 out of 1 tasks :no_entry:
@jacobdadams has completed 0 out of 1 tasks :no_entry:
@rkelson has completed 0 out of 1 tasks :no_entry:
brigsz commented 2 years ago

Good Morning All, What is a reasonable time frame to wrap this up? I know the next two weeks are a bit busy, just wanted to check in.

gregbunce commented 2 years ago

I would say the end of next week is reasonable. the next step is to get it loaded into the Internal DB and wire up the Meta table.

brigsz commented 2 years ago

Be careful @gregbunce you have a bunch of stuff flying through the air. Just wanted to check in

gregbunce commented 2 years ago

also, @nathankota is chatting with me now about this porter issue and has offered to assist and also spread the fun. thanks, kota!

jacobdadams commented 2 years ago

@gregbunce, after talking with Nathan I'm gonna use my wide, knobby shoulders to butt in and take over a bunch of your tasks to get this out 😆 It'll also help me with my understanding of their code as I work on it for the non-WFRC counties.

steveoh commented 2 years ago

conductor results for tasks - 171

check status
@jacobdadams has completed 0 out of 5 tasks :no_entry:
brigsz has completed 1 out of 1 tasks :+1:
@nathankota has completed 1 out of 2 tasks :no_entry:
@steveoh has completed 1 out of 6 tasks :no_entry:
@stdavis has completed 0 out of 1 tasks :no_entry:
gregbunce has completed 1 out of 1 tasks :+1:
@rkelson has completed 0 out of 1 tasks :no_entry:
jacobdadams commented 2 years ago

Talked with Josh this morning about schema and getting data from MAG. A new dataset should be coming in a week or so that includes MAG's data as well. I'm going to wait on that and upload everything at once.

agrc-conductor commented 2 years ago

conductor results for tasks - 171

check status
@jacobdadams has completed 0 out of 5 tasks :no_entry:
brigsz has completed 1 out of 1 tasks :+1:
@nathankota has completed 1 out of 2 tasks :no_entry:
@steveoh has completed 1 out of 6 tasks :no_entry:
@stdavis has completed 0 out of 1 tasks :no_entry:
gregbunce has completed 1 out of 1 tasks :+1:
@rkelson has completed 0 out of 1 tasks :no_entry:
jacobdadams commented 2 years ago

Josh told me MAG is still trying to get their data out, so we're just going to upload what we've got. @gregbunce, @ZachBeck, or @MichaelAGRC, does one of you want to take on the task of adding the table to the internal SGID SDE so that we get all the permissions, etc set right?

Once it's uploaded, I'll get the metadata written up along with the data page and all that goodness.

agrc-conductor commented 2 years ago

conductor results for tasks - 171

check status
@jacobdadams has completed 1 out of 4 tasks :no_entry:
brigsz has completed 1 out of 1 tasks :+1:
@nathankota has completed 1 out of 2 tasks :no_entry:
@ZachBeck has completed 0 out of 1 tasks :no_entry:
@steveoh has completed 1 out of 6 tasks :no_entry:
@stdavis has completed 0 out of 1 tasks :no_entry:
gregbunce has completed 1 out of 1 tasks :+1:
@rkelson has completed 0 out of 1 tasks :no_entry:
agrc-conductor commented 2 years ago

conductor results for tasks - 171

check status
@jacobdadams has completed 1 out of 4 tasks :no_entry:
brigsz has completed 1 out of 1 tasks :+1:
@nathankota has completed 1 out of 2 tasks :no_entry:
ZachBeck has completed 1 out of 1 tasks :+1:
@steveoh has completed 1 out of 6 tasks :no_entry:
@stdavis has completed 0 out of 1 tasks :no_entry:
gregbunce has completed 1 out of 1 tasks :+1:
@rkelson has completed 0 out of 1 tasks :no_entry:
agrc-conductor commented 2 years ago

conductor results for planning.HousingUnitInventory

check status
internal sgid :+1:
meta table
- item id :no_entry:
- item name :no_entry:
- geometry type :no_entry:
stewardship :no_entry: Did not find planning.HousingUnitInventory in the worksheet
agrc-conductor commented 2 years ago

conductor results for tasks - 171

check status
@jacobdadams has completed 2 out of 4 tasks :no_entry:
brigsz has completed 1 out of 1 tasks :+1:
@nathankota has completed 1 out of 2 tasks :no_entry:
ZachBeck has completed 1 out of 1 tasks :+1:
@steveoh has completed 2 out of 6 tasks :no_entry:
@stdavis has completed 0 out of 1 tasks :no_entry:
gregbunce has completed 1 out of 1 tasks :+1:
@rkelson has completed 0 out of 1 tasks :no_entry:
agrc-conductor commented 2 years ago

conductor results for planning.HousingUnitInventory

check status
internal sgid :+1:
meta table
- item id :no_entry:
- item name :+1:
- geometry type :+1:
open sgid :+1:
open data :+1:
stewardship :no_entry: Did not find planning.HousingUnitInventory in the worksheet
nathankota commented 2 years ago

@jacobdadams I'm confused that conductor says it's in open data, but I cannot find an AGOL item for it to complete the stewardship doc (?)

jacobdadams commented 2 years ago

Yeah, that is interesting. The forklift process to get it uploaded got hung up by the database migration and we're still working through that. It isn't in AGOL yet.

stdavis commented 2 years ago

I deleted this data from hashing in forklift so that it would get a fresh push tomorrow night.

agrc-conductor commented 2 years ago

conductor results for tasks - 171

check status
@jacobdadams has completed 2 out of 4 tasks :no_entry:
brigsz has completed 1 out of 1 tasks :+1:
@nathankota has completed 1 out of 2 tasks :no_entry:
ZachBeck has completed 1 out of 1 tasks :+1:
@steveoh has completed 2 out of 6 tasks :no_entry:
@stdavis has completed 0 out of 1 tasks :no_entry:
gregbunce has completed 1 out of 1 tasks :+1:
@rkelson has completed 0 out of 1 tasks :no_entry:
agrc-conductor commented 2 years ago

conductor results for planning.HousingUnitInventory

check status
internal sgid :+1:
meta table
- item id :+1:
- item name :+1:
- geometry type :+1:
open sgid :+1:
open data :+1:
arcgis online :+1:
stewardship :no_entry: Did not find planning.HousingUnitInventory in the worksheet
steveoh commented 2 years ago

Did my checks today, i don't see any references in gis.utah.gov or the sgid index. Let me know if I missed something.

jacobdadams commented 2 years ago

Yeah, these are forthcoming (got pushed back by UGIC).

On Mon, May 16, 2022 at 9:55 AM steveoh @.***> wrote:

Did my checks today, i don't see any references in gis.utah.gov or the sgid index. Let me know if I missed something.

— Reply to this email directly, view it on GitHub https://github.com/agrc/porter/issues/171#issuecomment-1127846632, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJDGLXXZMOQ7G5EZRXM4MUDVKJVVTANCNFSM5MZQCRAA . You are receiving this because you were mentioned.Message ID: @.***>

nathankota commented 2 years ago

Change log/data stewardship sheet updated

agrc-conductor commented 2 years ago

conductor results for tasks - 171

check status
@jacobdadams has completed 3 out of 4 tasks :no_entry:
brigsz has completed 1 out of 1 tasks :+1:
nathankota has completed 2 out of 2 tasks :+1:
ZachBeck has completed 1 out of 1 tasks :+1:
@steveoh has completed 4 out of 6 tasks :no_entry:
stdavis has completed 1 out of 1 tasks :+1:
gregbunce has completed 1 out of 1 tasks :+1:
@rkelson has completed 0 out of 1 tasks :no_entry:
agrc-conductor commented 2 years ago

conductor results for planning.HousingUnitInventory

check status
internal sgid :+1:
meta table
- item id :+1:
- item name :+1:
- geometry type :+1:
open sgid :+1:
open data :+1:
arcgis online :+1:
stewardship
- Website URL :no_entry:
- Description :+1:
- Data Source :+1:
- Endpoint :+1:
- Data Type :+1:
jacobdadams commented 2 years ago

Ok, I forgot to update the issue last week when I pushed out the website update. I think everything is done on this now.

steveoh commented 2 years ago

I reran the sgid index action and it didn't make any changes. Did you add the website url to the stewardship sheet @jacobdadams?

jacobdadams commented 2 years ago

Ah, forgot that. I just added it in 👍

agrc-conductor commented 2 years ago

conductor results for tasks - 171

check status
jacobdadams has completed 4 out of 4 tasks :+1:
brigsz has completed 1 out of 1 tasks :+1:
nathankota has completed 2 out of 2 tasks :+1:
ZachBeck has completed 1 out of 1 tasks :+1:
steveoh has completed 6 out of 6 tasks :+1:
stdavis has completed 1 out of 1 tasks :+1:
gregbunce has completed 1 out of 1 tasks :+1:
@rkelson has completed 0 out of 1 tasks :no_entry:
agrc-conductor commented 2 years ago

conductor results for planning.HousingUnitInventory

check status
internal sgid :+1:
meta table
- item id :+1:
- item name :+1:
- geometry type :+1:
open sgid :+1:
open data :+1:
arcgis online :+1:
stewardship
- Description :+1:
- Data Source :+1:
- Website URL :+1:
- Endpoint :+1:
- Data Type :+1: