search

sfcpc / housing-dashboard

4 stars 0 forks source link

[Dashboard] Some projects have blank statuses #191

Open rajpara11 opened 4 years ago

rajpara11 commented 4 years ago

Projects with blank statuses. There is a table with on the ‘Data Quality’ page with examples. There are many reasons this can happen:

  1. Accela records have incorrect graph structure (i.e. parents and children fields don’t match up) PRJ records are closed (not withdrawn or cancelled) out but all child records are withdrawn (i.e. 2005.0902, 2018-008227PRJ)
  2. Unit legalizations with shell PRJ’s (and no entitlements) that have no related building permits (i.e. 2019-021126PRJ)
  3. Shell PRJ’s with no ENT records but no related building permits (i.e. 2019-016101PRJ, 2019-002706PRJ)
  4. Incorrect related building permits for records where there’s no status in Planning (i.e. 2019-015753PRJ, 2018-017124PRJ
  5. Active shell PRJ points to a building permit that is cancelled or withdrawn (i.e. 2018-010977PRJ, 2018-007041PRJ)
  6. (A bug in our code that won’t be fixed in time) When we do a PTS grouping we only allow that grouping to have one PRJ parent, when in reality there can be multiple (see https://github.com/sfcpc/housing-dashboard/issues/115)