Incorporate parking spots in DevDB

[fvankrieken]

Revisiting emails, hope this will be simpler than I thought it would be yesterday

Housing would like parking lots included in hdb. This is stored, in some form, in their systems (now and bis. now has replaced bis, both are web apps for developers managing applications). We get many datasets relating to this

• dob_jobapplications (bis - old system)
• dob_permitissuance (bis)
• dob_now_applications
• dob_now_permits
• dob_cofos

Those first 4 we get from open data. CofOs we get manually from DOB because they include extra columns for us

It seems like it would be simplest to ask DOB to add this data to CofOs for multiple reasons. Primarily, because MF has told us that's where she's found them in the past (if you look at an individual CofO pdf, it's a field). But she also says we've gotten a table from them in the past with a parking spot column, so they hopefully have already done the work of parsing it out of text fields.

So this will have a few parts

• [ ] reach out to DOB for this data. This includes both
  • historical parking spots (going back as long as possible)
  • moving forwards, include parking spots as column in CofO data they send us This might take some back and forth if it's not that quite simple. If it'd be simpler for them to send something separate from the CofO export, that simply has parking lots without additional information
• [ ] archive parking spots data. We currently append each CofO export we get to the previous via a library script. I don't think it'd be inappropriate to, for a special "build" of this recipe dataset, merge it with whatever historical parking lot dataset we get. The historical dataset might need to be cleaned/wrangled a little
• [ ] add logic to get these values in devdb. Should be relatively simple but depends on the structure of the data we receive from DOB

[fvankrieken]

dob_now_applications does actually include parking lots, and it makes it through devdb build up to final query that creates exports. Checking in with housing on if this actually meets their needs already

[fvankrieken]

Emailed DOB about possibility of getting this data for BIS applications