Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Document common groups of classes and make a view for them #565

Open
jeancochrane opened this issue Aug 5, 2024 · 0 comments
Open

Document common groups of classes and make a view for them #565

jeancochrane opened this issue Aug 5, 2024 · 0 comments

Comments

@jeancochrane
Copy link
Contributor

It would be nice to have a canonical definition of class groupings like "vacant", "improved", "single-family", "multifamily", etc defined in a table/view that we could use for reference and for filtering queries that operate on these class definitions. Two design options for implementing this would be:

  1. Add a new seed to the ccao schema with two columns, group (string) and classes (array of strings)
  2. Update the existing ccao.class_dict seed with a new column groups that is an array of strings, then define a view on top of this seed that expands out groups into the same schema proposed in bullet 1 above

2 is preferable to 1 since it retains ccao.class_dict as the single source of truth for class metadata, but 1 is an option if 2 is not feasible for some reason.

Adapted from this comment:

We should really have a table that defines various class groupings like this (and for stuff like "all SF", "all MF", etc.). Maybe we can add it to ccao.class_dict.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant