0

I have a real estate management application that I need to save the Property Address for.

I was originally going to save it as raw data (address, city, state), but I want the user to be able to query the other user's properties based on address (let's assume I have 10,000 properties, I want them to query it, raw addresses I think may be difficult to use).

Question 1: What is the recommended method to save location addresses to the database?

Potential Solutions:

Solution 1: save it as raw address, city state.

Solution 2: Save raw address but use database for city and state information.

Solution 3: Use geo location lat/long. I think i don't want to do this because the address can get misinterpretted.

Question 2: I would like to integrate a google autocomplete for finding an address. I don't know if this is feasible for what i'm trying to do. Any recommendations?

Any advice is greatly appreciated! Looking this up is difficult since "address" and "location" can mean a lot of things in the coding world.

Kevin Danikowski
  • 4,620
  • 6
  • 41
  • 75

1 Answers1

2

So here are the relevant sources I found to come to a conclusion of my search.

  1. Best practices for storing postal addresses in a database (RDBMS)? is roughly a duplicate of this

  2. Is this a good way to model address information in a relational database? is insightful

  3. https://smartystreets.com/articles/address-apis is an api which can do what I'm discussion, and i'm sure there are alternatives to this if you look that up.

Kevin Danikowski
  • 4,620
  • 6
  • 41
  • 75