Page 1 of 11
Journal for Studies in Management and Planning
Available at http://edupediapublications.org/journals/index.php/JSMaP/
e-ISSN: 2395-0463
Volume 02 Issue 1
January 2016
Available online: http://edupediapublications.org/journals/index.php/JSMaP/ P a g e | 98
Automated Computer-Based Record Keeping System For
Quick Land Cadastral Information In Iyaji Layout Part A,
Oyo-West Local Government Area, Oyo, Oyo-State.
Y.O .Afonja 1
, R.A Jimoh 2
, A. A.Jimoh
3
, L.O.Opoola 4
1 Department of Surveying and Geoinformatics, Federal School of Surveying, P.M.B 1024, Oyo, Oyo State, Nigeria.
2 Department of Geohydrology, Geomodeling and Geoexplore Consultants Limited, P.O. Box 302, Ikorodu, Lagos
State, Nigeria
3 Department of Quantity Surveying, The Oke-Ogun Polytechnic, Saki, Oyo State, Nigeria.
4 Department Of Surveying and Geoinformatics, Yaba College of Technology, P.M.B 2011,Yaba, Lagos State,
Nigeria
Corresponding Authors:afonja2008@yahoo.com, geomodgeoexploreconsultants@gmail.com
ABSTRACT
This study is carried out purposely in order to create
a computer-based record keeping system that
provides readily accessible means of getting
cadastral information needed for quick decision
making for Iyaji Layout part A, Oyo-west Local
Government Area, Oyo, Oyo-state. The study shows
that it is very easy and quick in accessing information
with simple interaction with the database. It provides
avoidance of ambiguity in record keeping over land
or property. It is used for current and adequate
record keeping of property, for regulation of land
dispute, or property valuation for the purpose of
taxation. Acquisition of geometric data was done
using land survey method and database was created
by interpreting the two datasets i.e. linking the
graphic and attribute data together. The use of
digital equipment and GIS applications has become
veritable tool that must be used by all and sundry,
spatial information system must be provided for
spatial decision making. This will in turn aid physical
and economic development, hence sustainability of
the landscape in question and the environment at
large. Receivers of CHC GPS X20 Model and South
Total Station model NTS 355R. The instrument
(South Total Station model NTS 355R) was used to
test for horizontal error and vertical index error.
Key Words: Iyaji Layout parts A, cadastral
information, computer-based record keeping system.
1. INTRODUCTION
It is imperative that land should be properly managed
because of the vital role it plays in human affair vis- a-vis the source of most material wealth. To
effectively manage land and the resource,
comprehensive information about land should be
recorded in an organized and robust manner. This
will enable quick and flexible access to land related
information. Cadastral is the spatial land parcel of
land information system. It is the official record of
interest and also the legally recognized registration of
the quantity, value and ownership of land parcels.
Cadastre is a record containing unambiguous
description of land, the related rights to the land and
other information on the land [3].The continuous
expansion of population and increased commercial
activities has brought about great demand on land for
both private and public lands. Today land use
Page 2 of 11
Journal for Studies in Management and Planning
Available at http://edupediapublications.org/journals/index.php/JSMaP/
e-ISSN: 2395-0463
Volume 02 Issue 1
January 2016
Available online: http://edupediapublications.org/journals/index.php/JSMaP/ P a g e | 99
become more intense and complex and because of the
complexity, volume and diversity of information
expected from the land record, manual procedures
and methods of data processing are not able to meet
the pressure of such demand [4].The information in a
cadastre is collected, stored, referenced and retrieved
primarily at the land parcel level. Other referencing
systems such as coordinates, may then be added to
facilitate data manipulation and the exchange of
information with other systems[1]
The best way to minimize these problems is the
comprehensive application of Geographic
Information System in public and private landed
properties in Nigeria to create reliable and all- embracing geospatial database tool for decision
support system. This would further enhance the
smooth implementation the current land reform
efforts of the Federal Government of Nigeria. The
advent of computer technology has modernized the
existing cadastral system [2]
In view of the above, the need for the creation of
cadastral information system of Iyaji Layout becomes
a necessity when considering the most readily
accessible mean of getting cadastral information, to
ensure proper record keeping, unambiguity in land
description and location and improving on search
time for obtaining information as Decision Support
System.
2.0 STUDY AREA
The study area falls within Oyo Township, Oyo -
West Local Government Area in Oyo State. The site
lies between Latitude 7o50’16.12” and 7o49”54.97”
and Longitude 3o54”29.46” and 3o54”51.36”. The site
is a portion of Iyaji Layout on the right side of the
road while going to ILORA town. The total study
area is about 24.383 Hectares.
The map of the study area is as shown in the Fig.1 below.
Fig 1: The Study area
Page 3 of 11
Journal for Studies in Management and Planning
Available at http://edupediapublications.org/journals/index.php/JSMaP/
e-ISSN: 2395-0463
Volume 02 Issue 1
January 2016
Available online: http://edupediapublications.org/journals/index.php/JSMaP/ P a g e | 100
3.0 METHODOLOGY
3.1 DATABASE DESIGN
The database design for the sake of this study work
was done in ArcGIS 10.1 environment. The drawing
were imported from AutoCAD to ArcGIS 10.1, all
the layers created in AutoCAD are converted from
polyline to polygon. Database was designed for all
the data collected on site. Two phases of processes
were required to obtain a GIS database; these are:
The Design Phase and the Construction phase. The
design phase consists of Conceptual design, Logical
design and Physical design while the Construction
phase consists of the spatial database as being
demonstrated in Fig 2. Below
Fig.2: Design and construction phase in database design (Kufoniyi, 1998)
For the purpose of this study, the following relations and tables were designed as seen in Table 1, 2,3 and
4:●PARCELS: (P_Id,P_Area, P_Status, P_Owner, P_Road, P_use, C of O, P_O_Indigene, P_Block) Relationship
●BUILDINGS: (B_Id, B_Area, B_Tax rate, B_Value, B_status, B_Use, B_Block, B_Road, B_Type, P_Id)
●BLOCKS: (BL_Id, BL_Name, BL_Length, BL_Area, BL_Road)
●ROAD: (R_Id, R_Name, R_Length, R_Status,R_Width )
Table 1: Table of Parcel Entity and Attribute in relational structure
FIELD (Attribute Name) DESCRIPTION
P_Id
P_Use
P_Status
Parcel Identification
Parcel Use
Parcel Status
CONSTRUCTION
STAGE
DESIGN PHASE
VIEW OFREALITY VIEW OF REALITY VIEW OF REALITY
CONCEPTUAL DESIGN
LOGICAL DESGN
PHYSICAL DESIGN
SPATIAL DATABASE
REALITY
