to include corrections from dcp_attributes
Where jobnumber matches job in dcp_attributes and there IS a value in units_prop_res, then replace u_prop with value in units_prop_res
THE FOLLOWING UPDATES I AM STILL THINKING THROUGH
To reflect the loss of residential units when multiple dwellings are converted into hotels (but only for alterations resulting in a significant increase in "units"):
Where job_type= A1 AND occ_init= Residential% AND occ_prop=hotel% AND x_mixeduse=[blank] AND units_prop > (unit_init+2) THEN re-set value for units_prop to 0
To reflect the gain of residential units when hotels are converted into multiple dwellings (but only for alterations resulting in a significant decrease in "units")
Where job_type= A1 AND occ_init=hotel% AND occ_prop=Residential% AND x_mixeduse=[blank] AND (units_prop +2) < unit_init THEN re-set value for units_init to 0
to include corrections from dcp_attributes Where jobnumber matches job in dcp_attributes and there IS a value in units_prop_res, then replace u_prop with value in units_prop_res
THE FOLLOWING UPDATES I AM STILL THINKING THROUGH
To reflect the loss of residential units when multiple dwellings are converted into hotels (but only for alterations resulting in a significant increase in "units"): Where job_type= A1 AND occ_init= Residential% AND occ_prop=hotel% AND x_mixeduse=[blank] AND units_prop > (unit_init+2) THEN re-set value for units_prop to 0
To reflect the gain of residential units when hotels are converted into multiple dwellings (but only for alterations resulting in a significant decrease in "units") Where job_type= A1 AND occ_init=hotel% AND occ_prop=Residential% AND x_mixeduse=[blank] AND (units_prop +2) < unit_init THEN re-set value for units_init to 0