Some of this issue arose as part of #801, which fixed 6 condo billing bbls being missing from pluto 24v1 and 24v1.1
The problem there rose from a couple things
lack of distinguishing from unit lots and condo billing bbls in remove_unitlots.sql
incorrect data coming from pts
The filter in the query that has been changed check if multiple lots
are unit lots (originally erroneously)
have the exact same address and building area as other unit lots
The 6 missing lots were pairs: both condo billing bbls (lot = 75xx), each where 1 had the same address as the other erroneously. This fix is certainly needed, but we probably want to be catching things like this to let DOF know moving forward.
Some of this issue arose as part of #801, which fixed 6 condo billing bbls being missing from pluto 24v1 and 24v1.1
The problem there rose from a couple things
remove_unitlots.sql
The filter in the query that has been changed check if multiple lots
The 6 missing lots were pairs: both condo billing bbls (lot = 75xx), each where 1 had the same address as the other erroneously. This fix is certainly needed, but we probably want to be catching things like this to let DOF know moving forward.