Integrated GIS-Database for Effective Property Rate Collection and Management-A Case Study

Cynthia Borkai Boye, Julius Zuotaa


The potential of property rate as a source of revenue has least been realised by most local assemblies/municipalities in Ghana. Thus, local assemblies turn to depend more on the central common fund for developmental projects and provision of services for the citizens.  In this study, a geodatabase was created to facilitate effective collection and management of property rate for the Tarkwa-Nsuaem Municipality. Questionnaires were administered to gather data on immovable properties and their owners in the study area. Spatial data was acquired using Garmin handheld GPS receivers. An entity relational (ER) model was developed from which a database was created in Microsoft Access and then integrated into ArcGIS geodatabase. This technique was adopted to allow incorporation of user-defined data model into the ArcGIS schema that hosts the final database. The results revealed that out of 100 buildings used for the purpose of this study, 51 owners were found to have defaulted in the payment of their property rate for 2016, and 49 owners have fulfilled their property rate obligations. Querying the system displays building owners’ information that could be used to track or notify property rate defaulters. This study clearly shows that an integrated GIS-Database could help provide a more efficient collection, tracking and management of property rate revenue. Findings of the study confirms the fact that property rate payment is generally low in the country; less than 50% of building owners usually pay their property rates to the assembly yearly. It is recommended that the assembly adopts the proposed GIS-database for tracking property rate defaulters in the study area. Also stringent measures should be taken to combine education and law enforcement so as to enjoin property owners to comply with their task obligations. 


Property Rate, GIS, Database, Tracking, Effective Collection

Full Text:



Agboklu, G. (2013), “How a Property Rate Bill is Computed in Accra, Ghana”, Accessed: January 11, 2017.

Alupungu, E., Appiah, K. K., Mpeanin, G., Owusu, M. A. and Orgen-Woode, E. B. (2012), “Analysing the Sources of Internally Generated Funds and its Contributions; Evidence from Kumasi Metropolitan Assembly”, Unpublished BSc Project Report, Christian Service University College, 48pp.

Bahl, R. (2009), “Property tax reform in developing and transition countries”, United States Agency for International Development, pp. 1–3.

Batini, C., Ceri, S. and Navathe, S. (1989), Conceptual Database Design: An Entity Relationship Approach, Elsevier Science Publishers BV (North Holland), pp.1-48.

Boamah, N. A. (2013), “Constraints on Property Rating in Offinso South Municipality of Ghana”, Commonwealth Journal of Local Governance, Vol. 13, No. 14, pp. 77-89.

Braid, R. M. (2005), “Tax Competition, Tax Exporting and Higher-Government Choice of Tax Instruments for Local Governments”, Journal of Public Economics, Vol. 89, pp. 1789-1821.

Cattell, R. (2010), “Scalable SQL and NoSQL data stores”, SIGMOD Record, Vol. 39, No. 4, pp.12-27.

Chen, P. P. S. (1976), “The Entity-Relationship

Model- Toward a Unified View of Data”,

ACM Transactions on Database Systems

(TODS), Vol.1, No.1, pp.9-36.

Codd, E.F. (1979), “Extending the database relational model to capture more meaning”, ACM 1979, Transactions on Database Systems (TODS), New York, USA, Vol. 4,No. 4, pp. 397-434.

Ling, T.W. and Lee, M.L. (2008), “Entity‐Relationship Model” Wiley Encyclopedia of Computer Science and Engineering.

Riccardi, G. (2002), Database System Concepts

with Website Development Applications, Addison-Wesley Longman Publishing Co., Inc, Boston, MA, USA, 250 pp.

Slack, E. (2010), The Property Tax in Theory and Practice, Institute of Municipal Finance and Governance, Munk School of Global Affairs, University of Toronto, Canada, 17 pp.

Song, I.Y. and Chen, P. P. (2009), “Entity relationship model”, In Encyclopedia of Database Systems, pp. 1003-1009.

Tahiru, F. (2013), “Investigating the Challenges in Revenue Collection Process and the Development of a Computerised Solution: The Case Study of AMA Property Rate Collection” Unpublished MPhil Thesis Report, Kwame Nkrumah University of Science and Technology, Kumasi, 85 pp.

Tahiru, F., Agbesi, S. and Osei-Owusu, A. (2014),

“Investigating the Challenges in Revenue

Collection Process: The Case Study of

Ghana AMA Property Rate Collection”,

International Journal of Innovation and Scientific Research, Vol. 11, No. 2, pp. 566-576.

Teorey, T. J., Yang, D. and Fry, J. P. (1986), “A logical design methodology for relational databases using the extended entity-relationship model”, ACM Computing Surveys (CSUR), Vol. 18, No. 2, pp.197-222.

Yeboah, K., Johanson, L., and Fiatornu, S. (2008), “Urban Management Land Information System (UMLIS)- Possibilities and Benefits”, The FIG Congress 2008 Facing the Challenges- Building the Capacity, Austria, 11-16 April, 2008, pp.11-16.


  • There are currently no refbacks.