You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We should check our iasWorld docs for enumerated values with human-readable text, e.g. permit improvement codes. Where possible, we should extract the values out into a seed in the ccao schema that we can use as a crosswalk between codes and their human-readable values.
Create a unified schema for storing enumerated column values as seeds
Move these existing values to said schema and out of the docs
As a rule of thumb, I'd say anytime a column has more than 5 enumerated values then the values should live in the seed(s), with a pointer from the docs to the seed(s). If <= 5 values, let's keep the enumerated value in the docs and add it to the seed(s).
The text was updated successfully, but these errors were encountered:
jeancochrane
changed the title
Store enumerated column values as seeds
Store enumerated iasWorld column values as seeds
Sep 16, 2024
jeancochrane
changed the title
Store enumerated iasWorld column values as seeds
Store enumerated iasWorld column value crosswalks using seeds
Sep 16, 2024
We should check our iasWorld docs for enumerated values with human-readable text, e.g. permit improvement codes. Where possible, we should extract the values out into a seed in the
ccao
schema that we can use as a crosswalk between codes and their human-readable values.Adapted from https://github.com/ccao-data/data-architecture/pull/597/files#r1761797258:
The text was updated successfully, but these errors were encountered: