I have an address point shapefile for buildings in a city. The point shapefile shows only a single point for each building; apartments are listed in a table called additional addresses. I need to create a many-to-one relate from the additional addresses table to the address point shapefile using the unique street address. I then need to make a copy of the address point for each instance in additional addresses table.
I need to end up with a stack of points, one for each apartment at the address. Has anyone seen a Python script that does something similar?