Multiple Values for Parcel Numbers under one property?

This is a basic question I’m sure, but I’m creating a database of properties along a major corridor in my real estate market. Sometimes a property (i.e. a retail center) will have multiple APN #'s (parcel numbers) for one property.

I’m not sure if I should collect this information but I have for some properties. Was wondering if I should take the time to input the APN’s in a specific way. For instance, the location of 3012 W Sunset Blvd Los Angeles, CA is a parking lot with 4 different parcels (5426017030 is one)

You could do this by having a table for Properties and a table for APNs and then you could link multiple APNs to a single property, and store unique information per parcel if need be (like the sq. ft. for instance).

2 Likes