Next Article in Journal
Integrating a City’s Existing Infrastructure Vulnerabilities and Carbon Footprint for Achieving City-Wide Sustainability and Resilience Goals
Previous Article in Journal
Prioritization of Local Indicators for the Development of an Age-Friendly City: A Community Perspective
Article Menu
Issue 3 (September) cover image

Export Article

Open AccessArticle

Developing an Intelligent PostGIS Database to Support Accessibility Tools for Urban Pedestrians

1
Department of Electronics and Telecommunication Engineering, Mbeya University Mbeya of Science and Technology, Mbeya, Tanzania
2
College of Informatics and Virtual Education, University of Dodoma, Dodoma, Tanzania
3
Dipartmento di Elettronica, Informazione e Bioingegneria, Politecnico di Milano, 20133 Milano, Italy
*
Author to whom correspondence should be addressed.
Urban Sci. 2018, 2(3), 52; https://doi.org/10.3390/urbansci2030052
Received: 27 April 2018 / Revised: 14 June 2018 / Accepted: 14 June 2018 / Published: 22 June 2018
  |  
PDF [1894 KB, uploaded 22 June 2018]
  |  

Abstract

People with mobility impairment must travel through cities with extra care. An intelligent 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. The methods and techniques for intelligent database to storeand retrieve accessibility information by using a relational intelligent PostGIS database are described. The conceptual data model is designed for an intelligent database (PostGIS). 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. Therefore, the novelty of this approach lies in developing an intelligent database for the enrichment of geographical maps with information about the accessibility of urban pedestrian areas for people with mobility problems. View Full-Text
Keywords: city accessibility; dynamic database; path; PostGIS; smart city; users city accessibility; dynamic database; path; PostGIS; smart city; users
Figures

Figure 1

This is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited (CC BY 4.0).
SciFeed

Share & Cite This Article

MDPI and ACS Style

Sinkonde, D.; Mselle, L.; Shidende, N.; Comai, S.; Matteucci, M. Developing an Intelligent PostGIS Database to Support Accessibility Tools for Urban Pedestrians. Urban Sci. 2018, 2, 52.

Show more citation formats Show less citations formats

Note that from the first issue of 2016, MDPI journals use article numbers instead of page numbers. See further details here.

Article Metrics

Article Access Statistics

1

Comments

[Return to top]
Urban Sci. EISSN 2413-8851 Published by MDPI AG, Basel, Switzerland RSS E-Mail Table of Contents Alert
Back to Top