A simplified Google Map that considers traffic costs based on current location and provides more appropriate search functions.

Different from the past, which only displayed the distance, it has been changed to use a more intuitive traffic time.

• Frontend : HTML, CSS, Bootstrap
• Backend : Flask, sqlAlchemy
• Database : google cloud sql (postgreSQL)
• Service : google map API (Distance Matrix API, Places API)

Create a virtual environment :

python -m venv <environment path>

Download library :

pip install -r requirement.txt

Read Reference 1, Section : Create and manage---instances.

1. Distance Matrix API -> Read Reference 2, Section : setup.

2. Places API -> Read Reference 3, Section : setup.

1. set apiKey_file_path
2. set GOOGLE_APPLICATION_CREDENTIALS key file(json)
3. set database connection information (user, password, db, etc.)

You can use goole cloud sql interface to import data.Or use pgAdmin (video reference)

1. Run "./hunter/connectDB.py" to create all the table what you need.

2. import "./dataset/location.csv" for location table.

3. import "./dataset/restaurant.csv" and "./dataset/TaipeiRest.csv" to restaurant table.

4. Run "Preprocessing.py" to preprocess data and get park data(If you don't have park data).

1. Use python to connect cloud sql (postgreSQL)
2. Distance API document
3. Place AP document