Add DMPED + ODCA HPTF projects to Catalog

[ptatian]

Add Housing Production Trust Fund projects from ODCA database (**PresCat.ODCA_HPTF_2018).

[ptatian]

Updated issue to include adding DMPED data as well. Should compare DMPED and ODCA data to come up with a unique set of new projects or subsidies to add to Catalog. Should not replace existing project or subsidy data with these data.

[ptatian]

@mcohenui Updated instructions for adding new projects.

[mcohenui]

@ptatian Do we have a sense of whether the DMPED data or ODCA data will be updated over time? Should I be writing this as a one off program to add what we have now, or as a process that we expect to incorporate into Prezcat updates?

[ptatian]

@mcohenui It seems not very likely the ODCA data will be updated, since that was for a one-off study. DMPED should be updating its data fairly regularly, however. So, we might want to think about that possibility.

[ptatian]

Hi @mcohenui. Yes, I see. We do want to capture that information. Two issues we need to resolve.

1. Parsing the multiple addresses. We already have some code for doing this for the DHCD notice data. The %Rcasd_address_parse() macro in the DHCD library can be used to turn a list of addresses/address ranges into individual address records. The macro takes these parameters. All are required.
   • data= input data set,
   • out= output data set,
   • addr= var with list of addresses to be parsed,
   • keepin= this parameter needs to be included but you can just set to nothing,
   • id= One or more ID vars that can be used to relate parsed addresses back to original project

You might give this macro a try and see how well it does with the address lists in the file. Then we can see if we need to make any adjustments.

2. Adding multiple addresses to the Catalog. I think this is the bigger challenge as the current process for adding projects only lets you specify one address per project. We would either have to change the code for adding projects to allow multiple addresses OR add the multiple addresses to Building_geocode afterward as a separate step. The latter is not difficult but you need to know the NLIHC_ID for the projects to do this, which means it may need to be done as a separate issue after we add the projects to the Catalog.

Let me know what you think.

[ptatian]

@mcohenui Checking in on this issue. Have you been able to make any progress?

[mcohenui]

@ptatian About at the same place. I have had a few deliverables due. Will start back up next week.