@Brandon Mix That is my method. We use a database to store all the data that the county has in the reverse way the county stores it. Then we sort, filter and query to get what we are looking for. Then we use the city information to get the rest of the information from the county in bulk.
It's hard to give you a full answer to your question because if you can imagine cleaning 40+ cities of different types of formats/data/junk from a city so that the database can read the cities data and get the rest of the information out can be difficult.
If you really want to know my thousands of methods of cleaning data from cities, storing it and then getting the rest of the information this would be an extremely long post.
Is the city information correctly formatted? Is the property address in one column like this?
![](https://assets0.biggerpockets.com/uploads/uploaded_images/normal_1571784652-Screen_Shot_2019-10-22_at_3.50.25_PM.png)
Or does it look like this?
![](https://assets0.biggerpockets.com/uploads/uploaded_images/normal_1571784745-Screen_Shot_2019-10-22_at_3.52.02_PM.png)
Or maybe this?
![](https://assets0.biggerpockets.com/uploads/uploaded_images/normal_1571785884-Screen_Shot_2019-10-22_at_4.11.17_PM.png)
Is there missing information that you would have to filled in. Is the city list in png, txt, pdf or csv format? I've dealt with pictures taken from a cell phone of city addresses and then emailed to me. Sometimes I use high-tech to get the information and sometimes I don't.
Let me know. I'm here to help. Feel free to send me a message in my inbox.