… only one permit type: Source data from foundation datasets, adjust all data processing to match those file contents and file formats. Group permit data by facility after pulling out active GWP or VWPs separately. Join permit status to mp_all. Sum permitted MPs only after separating GW and SW, then carry that change into remaining Table 3 formatting. Add QA checks and remove code sections of deprecated table formatting. This is push attempt 3.
… only one permit type: Source data from foundation datasets, adjust all data processing to match those file contents and file formats. Group permit data by facility after pulling out active GWP or VWPs separately. Join permit status to mp_all. Sum permitted MPs only after separating GW and SW, then carry that change into remaining Table 3 formatting. Add QA checks and remove code sections of deprecated table formatting. This is push attempt 3.