American Journal of Aerospace Engineering
Volume 6, Issue 2, December 2019, Pages: 39-43
Received: Jul. 22, 2019;
Accepted: Dec. 26, 2019;
Published: Jan. 8, 2020
Views 678 Downloads 177
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
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.
Israel Oluwaseun Taiwo,
Optimizing Transportation with Spatial Databases Using Google Maps in Ado-Ekiti, American Journal of Aerospace Engineering.
Vol. 6, No. 2,
2019, pp. 39-43.
Copyright © 2019 Authors retain the copyright of this article.
This article is an open access article distributed under the Creative Commons Attribution License (http://creativecommons.org/licenses/by/4.0/
) which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
P. Rigaux, M. O. Scholl, and A. Voisard, Spatial databases : with application to GIS. Morgan Kaufmann Publishers, 2002.
S. Shekhar and S. Chawla, Spatial databases : a tour. Prentice Hall, 2003.
W. Li, An Efficient Query System for High-dimensional Spatio-temporal Data. ProQuest, 2008.
W. Kresse and D. M. Danko, Springer handbook of geographic information, 1. Berlin: Springer, 2012.
P. Amirian, A. Basiri, and A. Winstanley, “Evaluation of Data Management Systems for Geospatial Big Data,” 2014, pp. 678–690.
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].
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.
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.
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/.
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.
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.
Oracle, “Transportation Management | Oracle,” 2015. [Online]. Available: https://www.oracle.com/br/applications/supply-chain-management/solutions/logistics/transportation-management.html.
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].