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 |
Database, Spatial Database, Transportation
[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]. |
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
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
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
@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} }
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 -