| Peer-Reviewed

Optimizing Transportation with Spatial Databases Using Google Maps in Ado-Ekiti

Received: 22 July 2019     Accepted: 26 December 2019     Published: 8 January 2020
Views:       Downloads:
Abstract

Transportation is the movement of man, goods and services from one place to another. A database is an organised collection of logically structured data, while spatial databases are enhanced databases capable of storing and querying data that represents objects defined in a geometric space. Databases offer transportation planning and management the capacity for operation planning – Best & Alternative Route Planning (BARP), Transport Intelligence, Fleet Management, Freight Payment and Billing, Carrier Sourcing and Visibility. Using Ado-Ekiti as a case study, this works discusses the role of databases for transportation planning and management, it identifies the need for spatially enabled transportation databases to facilitate commuting. Transportation, building transportation databases, database analysis and functionalities for transportation were discussed. The work further implements the use of Google maps as an open spatial database in determining best and alternative routes in Ado-Ekiti. Results obtained shows that readily available spatial databases will make transportation easier, smarter and more cost-effective. The work concludes and recommends the need for continued integration of accurate geospatial data with transportation management for effective transportation service delivery. It further advises the need to promote crowdsourcing, volunteered geographic information and open-source approaches to mapping the environment as veritable sources of data for spatial databases.

Published in American Journal of Aerospace Engineering (Volume 6, Issue 2)
DOI 10.11648/j.ajae.20190602.12
Page(s) 39-43
Creative Commons

This is an Open Access article, distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution and reproduction in any medium or format, provided the original work is properly cited.

Copyright

Copyright © The Author(s), 2020. Published by Science Publishing Group

Keywords

Database, Spatial Database, Transportation

References
[1] P. Rigaux, M. O. Scholl, and A. Voisard, Spatial databases : with application to GIS. Morgan Kaufmann Publishers, 2002.
[2] S. Shekhar and S. Chawla, Spatial databases : a tour. Prentice Hall, 2003.
[3] W. Li, An Efficient Query System for High-dimensional Spatio-temporal Data. ProQuest, 2008.
[4] W. Kresse and D. M. Danko, Springer handbook of geographic information, 1. Berlin: Springer, 2012.
[5] P. Amirian, A. Basiri, and A. Winstanley, “Evaluation of Data Management Systems for Geospatial Big Data,” 2014, pp. 678–690.
[6] Elseiver, “Introducing the transportation database center app on sciencedirect,” 2015. [Online]. Available: https://www.elsevier.com/social-sciences/transportation/introducing-the-transportation-database-center-app-on-sciencedirect. [Accessed: 09-Nov-2017].
[7] T. Jiang, Z. Wu, Y. Song, X. Liu, H. Liu, and H. Zhang, “Sustainable Transport Data Collection and Application: China Urban Transport Database,” Math. Probl. Eng., vol. 2013, no. 1024–123X, 2013.
[8] T. Jiang, Z. Wu, Y. Song, X. Liu, H. Liu, and H. Zhang, “Sustainable Transport Data Collection and Application: China Urban Transport Database,” Math. Probl. Eng., vol. 2013, pp. 1–10, Dec. 2013.
[9] P. Gupta, N. Jain, P. K. Sikdar, and K. Kumar, “Geographical Information System in Transportation Planning,” Geospatial World, 2009. [Online]. Available: https://www.geospatialworld.net/article/geographical-information-system-in-transportation-planning/.
[10] M. P. Miska, A. Torday, H. Warita, and M. Kuwahara, “The international traffic database project,” in Proceedings of the ITS World Congress, Beijing, China, 2007, 2007.
[11] P. A. Longley, M. F. Goodchild, D. J. Magurie, and D. W. Rhind, Geographic Information Systems and Science. West Sussex PO19, England: John Wiley & Sons Ltd, 2005.
[12] Oracle, “Transportation Management | Oracle,” 2015. [Online]. Available: https://www.oracle.com/br/applications/supply-chain-management/solutions/logistics/transportation-management.html.
[13] Google, “[Google Maps directions for driving Dave Hotel, Ado - Iworoko - Ifaki Rd, Ado Ekiti to Federal Polytechnic Ado-Ekiti Continuous Education Center, NTA Road, Ado Ekiti].” [Online]. Available: https://goo.gl/maps/DpWi1bvUxh8K7xbS7. [Accessed: 11-Oct-2017].
Cite This Article
  • APA Style

    Israel Oluwaseun Taiwo, Taiwo Oluboyede. (2020). Optimizing Transportation with Spatial Databases Using Google Maps in Ado-Ekiti. American Journal of Aerospace Engineering, 6(2), 39-43. https://doi.org/10.11648/j.ajae.20190602.12

    Copy | Download

    ACS Style

    Israel Oluwaseun Taiwo; Taiwo Oluboyede. Optimizing Transportation with Spatial Databases Using Google Maps in Ado-Ekiti. Am. J. Aerosp. Eng. 2020, 6(2), 39-43. doi: 10.11648/j.ajae.20190602.12

    Copy | Download

    AMA Style

    Israel Oluwaseun Taiwo, Taiwo Oluboyede. Optimizing Transportation with Spatial Databases Using Google Maps in Ado-Ekiti. Am J Aerosp Eng. 2020;6(2):39-43. doi: 10.11648/j.ajae.20190602.12

    Copy | Download

  • @article{10.11648/j.ajae.20190602.12,
      author = {Israel Oluwaseun Taiwo and Taiwo Oluboyede},
      title = {Optimizing Transportation with Spatial Databases Using Google Maps in Ado-Ekiti},
      journal = {American Journal of Aerospace Engineering},
      volume = {6},
      number = {2},
      pages = {39-43},
      doi = {10.11648/j.ajae.20190602.12},
      url = {https://doi.org/10.11648/j.ajae.20190602.12},
      eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.ajae.20190602.12},
      abstract = {Transportation is the movement of man, goods and services from one place to another. A database is an organised collection of logically structured data, while spatial databases are enhanced databases capable of storing and querying data that represents objects defined in a geometric space. Databases offer transportation planning and management the capacity for operation planning – Best & Alternative Route Planning (BARP), Transport Intelligence, Fleet Management, Freight Payment and Billing, Carrier Sourcing and Visibility. Using Ado-Ekiti as a case study, this works discusses the role of databases for transportation planning and management, it identifies the need for spatially enabled transportation databases to facilitate commuting. Transportation, building transportation databases, database analysis and functionalities for transportation were discussed. The work further implements the use of Google maps as an open spatial database in determining best and alternative routes in Ado-Ekiti. Results obtained shows that readily available spatial databases will make transportation easier, smarter and more cost-effective. The work concludes and recommends the need for continued integration of accurate geospatial data with transportation management for effective transportation service delivery. It further advises the need to promote crowdsourcing, volunteered geographic information and open-source approaches to mapping the environment as veritable sources of data for spatial databases.},
     year = {2020}
    }
    

    Copy | Download

  • TY  - JOUR
    T1  - Optimizing Transportation with Spatial Databases Using Google Maps in Ado-Ekiti
    AU  - Israel Oluwaseun Taiwo
    AU  - Taiwo Oluboyede
    Y1  - 2020/01/08
    PY  - 2020
    N1  - https://doi.org/10.11648/j.ajae.20190602.12
    DO  - 10.11648/j.ajae.20190602.12
    T2  - American Journal of Aerospace Engineering
    JF  - American Journal of Aerospace Engineering
    JO  - American Journal of Aerospace Engineering
    SP  - 39
    EP  - 43
    PB  - Science Publishing Group
    SN  - 2376-4821
    UR  - https://doi.org/10.11648/j.ajae.20190602.12
    AB  - Transportation is the movement of man, goods and services from one place to another. A database is an organised collection of logically structured data, while spatial databases are enhanced databases capable of storing and querying data that represents objects defined in a geometric space. Databases offer transportation planning and management the capacity for operation planning – Best & Alternative Route Planning (BARP), Transport Intelligence, Fleet Management, Freight Payment and Billing, Carrier Sourcing and Visibility. Using Ado-Ekiti as a case study, this works discusses the role of databases for transportation planning and management, it identifies the need for spatially enabled transportation databases to facilitate commuting. Transportation, building transportation databases, database analysis and functionalities for transportation were discussed. The work further implements the use of Google maps as an open spatial database in determining best and alternative routes in Ado-Ekiti. Results obtained shows that readily available spatial databases will make transportation easier, smarter and more cost-effective. The work concludes and recommends the need for continued integration of accurate geospatial data with transportation management for effective transportation service delivery. It further advises the need to promote crowdsourcing, volunteered geographic information and open-source approaches to mapping the environment as veritable sources of data for spatial databases.
    VL  - 6
    IS  - 2
    ER  - 

    Copy | Download

Author Information
  • Department of Surveying and Geoinformatics, The Federal Polytechnic Ado-Ekiti, Ekiti State, Nigeria

  • Department of Surveying and Geoinformatics, The Federal Polytechnic Ado-Ekiti, Ekiti State, Nigeria

  • Sections