Bringing open data to affordable housing decision makers in Washington DC. A D3/Javascript based website to visualize data related to affordable housing in Washington DC. Data processing with Python.
Fixes the issue that the "dhcd_dfd_projects" table, which contains loan information, was returning empty. This was due to an error returned from quickbase that the query was too large. Fixed by only requesting default fields for now, and made note for future users that all fields could be obtained by chunking the request.
Also started making progress towards the reporting / QA task for verifying we are properly matching records. Added a 'found_via' parameter to the _get_nlihc_id_from_db method, telling how the element was identified, as well as the list of all the mar_ids that it found using the addresses. Set up useless function that when finished can use these mar_ids to geocode the project so that it doesn't need to be done during hte cleaning step.
TODO:
map the fields of the dhcd_project table to the subsidy table so that we can use the data
finish the _geocode_if_needed function; this will mean it doesn't need to occur during cleaning.
Modify append_addresses so that it returns the in-memory copy of what it writes to teh file
move _geocode_if_needed below append_addresses, and use the resulting mar_ids to geocode the project.
Fixes the issue that the "dhcd_dfd_projects" table, which contains loan information, was returning empty. This was due to an error returned from quickbase that the query was too large. Fixed by only requesting default fields for now, and made note for future users that all fields could be obtained by chunking the request.
Also started making progress towards the reporting / QA task for verifying we are properly matching records. Added a 'found_via' parameter to the _get_nlihc_id_from_db method, telling how the element was identified, as well as the list of all the mar_ids that it found using the addresses. Set up useless function that when finished can use these mar_ids to geocode the project so that it doesn't need to be done during hte cleaning step.
TODO: