Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Populate 'in_prescat', 'in_dhcd', 'in_dchousing' fields #577

Open
NealHumphrey opened this issue Sep 21, 2017 · 0 comments
Open

Populate 'in_prescat', 'in_dhcd', 'in_dchousing' fields #577

NealHumphrey opened this issue Sep 21, 2017 · 0 comments

Comments

@NealHumphrey
Copy link
Collaborator

The project table has 3 boolean fields indicating whether a particular project was found in each of the sources. These need to be populated as a post-processing step.

In the project table the unique_data_id column represents where the project was first found, but if a later source has the same record it won't be reflected in the project data. Since the 'subsidies' table always has a record for each project regarldess of where it was first found, use the 'subsidies' table to identify which data sources each project was found in. Construct a sql query and python code that returns a unique list of nlihc_ids and returns true for each column if there was at least one matching unique_data_id for that data source. Bulk update the project table with this data.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant