MobileQueries

Used Techs

• Android Studio - Java
• Google Cloud
  • IAM
  • BigQuery
• Mapbox
  • Navigation Service
  • Maps Service

---

Query Data

Database data is acquired from The New York City Taxi and Limousine Commision (TLC) and stored in BigQuery database. December 2020 data is used in this project.

• yellow_tripdata_2020-12.csv.
• taxi+_zone_lookup.csv.

---

Structure Diagram

---

Type 1 Query

This Query is returns "The five most passenger transported day and transported passenger values." from BigQuery database.

---

Type 2 Query

This query returns "The five shortest distanced transportation records between two input dates." from BigQuery database.

---

Type 3 Query

This Query returns "The longest distanced transportation at input date." from BigQuery database and shows the transportation road in mapbox map.