Building Urban Land Information Management System in PostgreSQL, for the Case of Ethiopia

Population growth and rapid urbanization have caused an exponential increase in urban land demand in Ethiopia. The information required for land administration and management has been tremendously increasing as well. Therefore, this paper describes the steps for a building database prototype for urban land information management system for the case of Ethiopia which results to develop an efficient and effective way of spatial and non-spatial urban land data management system. This research project will develop a central database system using a PostgreSQL software to retrieve, update and store the required data using a user-friendly graphical interface. System requirement and specification is devoted to a system design which incorporates the intended system behaviour using a use case diagram, logical design of the system using a class diagram. The design system is validated and tested via sample data which can store, retrieve, and update the required data as per the user requirement. Developing this type of urban land information management system, therefore, facilitates and increases the efficiency of land registration and related activities at the municipality level. Thence, citizens would be satisfied by the service delivery of the municipality. The land and real estate ownerships registration will also become automated. Furthermore, any spatial and non-spatial data related with the system can be stored in the database which will be ready for more analysis as to be able to use by policymakers, urban planners for the purpose of sustainable development of urban area infrastructural developments and land use policy. The research will lay ground for another task to develop CityGML 3D modelling for selected cities thereby contributes to spatial data infrastructure development to Ethiopia.