search

sfcpc / housing-dashboard

4 stars 0 forks source link

[Relational] Should we filter PTS permits on the proposed use? #149

Open rajpara11 opened 4 years ago

rajpara11 commented 4 years ago

Currently, we would count units for things like residential hotels. However, the proposed use is not always filled out, but does look like there are about 10 values we can look for if we wanted to narrow it down (and maybe allow empty values)?

rajpara11 commented 4 years ago

Looks like the only uses that concern us are misc group residns., 2 family dwelling, apartments, 1 family dwelling. However, if we took this approach we might artificially filter out some new residential use that is input later on, so not entirely sure if we want to do this

rajpara11 commented 4 years ago

Something that makes this interesting is whether we should be doing this at the project level or table level on the relational side (i.e. if a project looks like residential in Planning, but looks non-residential in DBI, should we completely filter that project out? Or should we just use the planning data?)