I am dealing with all real estate properties in one city, I have access to all public records and can download lists (excel/csv) of all properties with all the basic information about them.
This will be called the master list. It will include ALL properties.
I need to be able to use this information in many ways, here are a few:
1. I want to be able to upload a partial list, using a unique field, I will need an output of all relevant fields.
Example: I have a separate small list (not the same format as the master list) of certain addresses that are considered abandoned, I need to match the addressed on the small list against the master list and get the associated mailing address of of the owner of these specific addresses on the small list.
2. I need to be able to narrow down the master list with specific rules to create a smaller list.
Example: I want all the properties with an address that is different from the owners mailing address to be exported.
3. I need to be able to update the master list every month.
I want to create an application that can be always updated with more queries or features.
I will only respond to you if you mention your favorite color.
Thanks for looking.