Baiyue Cao

Results 16 comments of Baiyue Cao

## Issues that I noticed: There are 3 kinds of BBLs - `bbl` the physical lot bbl, it's the same as billing bbl for non-condos - for condos, we call...

```sql SELECT pts.prime_bbl, coalesce(cama.residarea, pts.residarea) as residarea, coalesce(cama.officearea, pts.officearea) as officearea, coalesce(cama.retailarea, pts.retailarea) as retailarea, coalesce(cama.garagearea, pts.garagearea) as garagearea, coalesce(cama.storagearea, pts.storagearea) as storagearea, coalesce(cama.factoryarea, pts.factoryarea) as factoryarea, coalesce(cama.otherarea, pts.otherarea) as...

Hi @docmarionum1 @ishiland I have the test data (for each function and each releases, including the UPAD update) used by the `geographic research unit` at DCP, and it can be...

[geosupport QA Data.zip](https://github.com/ishiland/python-geosupport/files/3481929/geosupport.QA.Data.zip) Sorry for getting back so late, here are the files used for the QAQC, I think GRU generate new test data every release cycle, we can discuss...

There isn't, but based on my guess it's `geosupport version`, `borough code`, `house number`, `street name`, `GRC`, `some other comments`