nate-wessel / hamilton-import Goto Github PK

On this line:

https://github.com/Nate-Wessel/hamilton-import/blob/master/conflation.sql#L157

I'm having trouble thinking of a case where multiple parcels could belong to a single building wherein the area of intersection between building and parcel is over 90%. You're basically talking about overlapping parcels which I'm unsure if are likely to exist especially in my data set. Far more often you see condo buildings divided up by parcel: a duplex in half, a triplex in thirds, etc. I suppose if an area had a ton of townhouses where the first floor and second floor were different parcels this query might work..?

Any thoughts on this issue? I also modified the next query for addresses on buildings across multiple parcels (which seems like the same exact problem, right?) to rather than finding areas of intersection under 90% (which was unfortunately assigning slivers of secondary buildings to the wrong side of the street and creating duplicate addresses in my dataset) now instead finding areas of intersection over 50%.