Modern approach for intelligent database to support urban city accessibility tools for the pedestrian

VIEWS - 18 (Abstract) 10 (PDF)
Daniel Sinkonde


Travelling through cities is one of the things which people with mobility impairment always have to deal with. A designed dynamic database of Maps for Easy Paths (MEP) project for storing and retrieving accessibility information about a particular path by using PostGIS may enable the public to enjoy the privilege of the technology that alleviates the problem of city accessibility through the Web, or more recently, through smartphones/tablet applications. An application of methods and techniques for designing a dynamic database to store and retrieve accessibility information by using a relational PostGIS is described. The conceptual data model is designed for a database (PostGIS) which provides an optimal description of the user requirements. Users will be able to actively participate in the process of taking pictures of obstacles, uploading them to the MEP server and giving some comments on the attributes of the picture of the barrier. The resulting data will help others to locate and evaluate paths. This paper presents the conceptual data model design as well as a review of features of the data of the existing systems. The paper demonstrates that our data-driven approach can be used to facilitate the planning, design, and implementation of an appropriate application to achieve the MEP goal. Therefore, the novelty of this approach lies in developing the dynamic database for the enrichment of geographical maps with information about the accessibility of urban pedestrian areas for people with mobility problems.


city accessibility; dynamic database; path; PostGIS; smart city; users

Full Text:



D. Ding et al., “Design considerations for a personalized wheelchair navigation system,” in Annual International Conference of the IEEE Engineering in Medicine and Biology - Proceedings, 2007, pp. 4790–4793.

N. Thapar et al., “A pilot study of functional access to public buildings and facilities for persons with impairments.,” Disabil. Rehabil., vol. 26, no. 5, pp. 280–289, 2004.

A. R. Meyers, J. J. Anderson, D. R. Miller, K. Shipp, and H. Hoenig, "Barriers, facilitators, and access for wheelchair users: substantive and methodologic lessons from a pilot study of environmental effects," Soc. Sci. Med., vol. 55, no. 8, pp. 1435–1446, 2002.

United States Access Board, Americans with Disabilities Act and Architectural Barriers Act Accessibility Guidelines. 2004.

S. Darcy, “Inherent complexity: Disability, accessible tourism and accommodation information preferences,” Tour. Manag., vol. 31, no. 6, pp. 816–826, 2010.

S. Comai, D. Kayange, R. Mangiarotti, M. Matteucci, S. Ugur Yavuz, and F. Valentini, Mapping City Accessibility: Review and Analysis, vol. 217. 2015.

Duvall, J., Sinagra, E., Stuckey, D., Cooper, R. & Pearlman, J. Year. Proposed Surface Roughness Standard for Pathways Used by Wheelchairs. In: Transportation Research Board 93rd Annual Meeting, 2014.

Vaishnavi, V., & Kuechler, W. (2004). Design research in information systems.

Chatzimilioudis, G., Konstantinidis, A., Laoudias, C., & Zeinalipour-Yazti, D. (2012). Crowdsourcing with smartphones. IEEE Internet Computing, 16 (5), 36–44.

Heipke, C. (2010). Crowdsourcing geospatial data. ISPRS Journal of Photogrammetry and Remote Sensing, 65 (6), 550–557.

Schemmann, B., Herrmann, A. M., Chappin, M. M. H., & Heimeriks, G. J. (2016). Crowdsourcing ideas: Involving ordinary users in the ideation phase of new product development. Research Policy, 45 (6), 1145–1154.

Brambilla, M., Ceri, S., Mauri, A., & Volonterio, R. (2014). Community-based Crowdsourcing. WWW’14 Companion, 891–896.

Rice, M. T., Jacobson, R. D., Caldwell, D. R., McDermott, S. D., Paez, F. I., Aburizaiza, A. O., … Qin, H. (2013). Crowdsourcing techniques for augmenting traditional accessibility maps with transitory obstacle information. Cartography and Geographic Information Science, 40(3), 210–219.

Mirri, S., Prandi, C., Salomoni, P., Callegati, F., & Campi, A. (2014). On combining crowdsourcing, sensing and open data for an accessible smart city. In Proceedings - 2014 8th International Conference on Next Generation Mobile Applications, Services, and Technologies, NGMAST 2014 (pp. 294–299).



  • There are currently no refbacks.

Copyright (c) 2018 Daniel Sinkonde

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.


Journal of Smart Cities is a peer-reviewed, open-access journal. All journal content, except where otherwise noted, is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.