sfcpc / housing-dashboard

4 stars 0 forks source link

[Dashboard] Project statuses for some projects have overlapping dates #189

Open rajpara11 opened 4 years ago

rajpara11 commented 4 years ago

There are a small subset of projects (~28) which can have an ‘filed for permits’ status with negative months. This is because the ‘entitled’ date is after the ‘under_construction’ date. In cases like this the entitled status would be 0 days and ‘filed for permits’ would be negative. Some examples:

Case 1: Planning: 2015-010013PRJ DBI:201611283577, 201808207754, 201808207755, 201809170484, 201809170488, 201809170489, 201809170490, 201809170491, 201809170492, 201809170493, 201912230380 Result: Date Entitlements approved is after the first construction document date

Case 2: Planning: 2019-003765PRJ DBI: 201708023714, 201809140292, 201910215091 Result: Entitlements approved is after under construction(full permit 201708023714 has issued date before it)

Case 3: Planning: 2019-001839PRJ DBI: 201902011937 Result: Entitlements approved is after under construction(full permit has issued date before entitlements approved date)

Case 4: Planning: 2016-010387PRJ DBI: 201312113850 and 201703060737 Result: Date Entitlements approved is after first construction document date for DBI

Case 5: Planning: 2015-013010PRJ DBI: 201603222793 Result: Date Entitlements approved is after full permit’s issued date