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

Israel Oluwaseun Taiwo; Taiwo Oluboyede

doi:doi:10.11648/j.ajae.20190602.12

| Peer-Reviewed

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

Israel Oluwaseun Taiwo, Taiwo Oluboyede

Published in American Journal of Aerospace Engineering (Volume 6, Issue 2)

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

Views: Downloads:

Download PDF

Share This Article

Twitter
Linked In
Facebook

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), 2024. 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

Plain Text BibTeX RIS

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

Israel Oluwaseun Taiwo

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

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

Download PDF

Sections

Plain Text BibTeX RIS

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