Burroughs is an historical database of places in Lawrence, Kansas with a time-machine experience for the user dialing back exterior and interior views of city blocks, buildings, and businesses through the years, decades, and centuries, with building and business histories as well as public discussion walls tied to each physical location.
Following the fundamental schema of Blocks / Buildings / Businesses, the addition of "Block sides" as a class and db table that can be comprised of Locations much the way Buildings are with a junction table/class "block_side_locations" tying them together in a many to many relationship.
Block sides indirectly include buildings in that to generate what buildings are in a block the list of Locations that make up the Block Side's footprint at any given date in time can be used to retrieve the list of Buildings that are associated with those Locations at that time. The same could then be similarly generated for Existences if necessary.
Following the fundamental schema of Blocks / Buildings / Businesses, the addition of "Block sides" as a class and db table that can be comprised of Locations much the way Buildings are with a junction table/class "block_side_locations" tying them together in a many to many relationship.
Block sides indirectly include buildings in that to generate what buildings are in a block the list of Locations that make up the Block Side's footprint at any given date in time can be used to retrieve the list of Buildings that are associated with those Locations at that time. The same could then be similarly generated for Existences if necessary.