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