All of the boolean columns in the database tables seem to have imported incorrectly; all values in all rows are false when certainly many of them should be true.
My plan is to migrate the models to integer fields and modify the import scripts to set them to 1 or 0. Once this is done, I'll unfortunately have to truncate the tables and re-import.
All of the boolean columns in the database tables seem to have imported incorrectly; all values in all rows are false when certainly many of them should be true.
Furthermore, I've found that for the types of queries we may want to run (e.g. reproducing the types of things on the IHS portal: http://www.housingstudies.org/dataportal/composition/housing-units-composition/community-area/2012/2012/) it might be more sensible to convert these columns to integer 0 and 1. This would allow quicker counts, sums, etc. on these columns.
My plan is to migrate the models to integer fields and modify the import scripts to set them to 1 or 0. Once this is done, I'll unfortunately have to truncate the tables and re-import.