Conference PaperPDF Available

GEOAGRI: A Geospatial web-based decision support system to Farm-to-Market Road Network Plan

Abstract

Geographic Information System (GIS) for Agricultural and Fisheries Machinery and Infrastructure (GEOAGRI) was developed by Caraga State University in partnership with the Department of Agriculture mainly to aid various agencies which intend to propose a farm-to-market road project. GEOAGRI provides visualization of the road and automatically cross-checks it to all existing proposed, ongoing, and completed road projects for possible duplication. The web-based GIS system requires the user to upload a shapefile or KML of the road; it then pinpoints the location based on its geometry and executes an intersection query to the existing road projects within the location. By having this mechanism, one can determine the extent of the intersection of the proposed road to the existing ones that users can also be view on the map. In addition, it can help the agency managers in deciding whether to approve or deny the project. The system also embedded other map layers such as rice production, public market, machinery, and infrastructures which is also one of the determining factors in the approval of the proposed road. Non-registered users may also view all the existing road projects and do basic map queries. The system is accessible at http://geoagri.da.gov.ph/, which is running and operational.
GEOAGRI: A Geospatial web-based decision
support system to Farm-to-Market Road Network
Plan
Edsel Matt O. Morales
College of Computing and Information
Sciences (CCIS)
Caraga State University
Ampayon, Butuan City, Philippines,
8600
eomorales@carsu.edu.ph
Elbert S. Moyon
College of Computing and Information
Sciences
Caraga State University
Ampayon, Butuan City, Philippines,
8600
esmoyon@carsu.edu.ph
Jaymer M. Jayoma
College of Computing and Information
Sciences (CCIS)
Caraga State University
Ampayon, Butuan City, Philippines,
8600
jmjayoma@carsu.edu.ph
AbstractGeographic Information System (GIS) for
Agricultural and Fisheries Machinery and Infrastructure
(GEOAGRI) was developed by Caraga State University in
partnership with the Department of Agriculture mainly to aid
various agencies which intend to propose a farm-to-market road
project. GEOAGRI provides visualization of the road and
automatically cross-checks it to all existing proposed, ongoing,
and completed road projects for possible duplication. The web-
based GIS system requires the user to upload a shapefile or
KML of the road; it then pinpoints the location based on its
geometry and executes an intersection query to the existing road
projects within the location. By having this mechanism, one can
determine the extent of the intersection of the proposed road to
the existing ones that users can also be view on the map. In
addition, it can help the agency managers in deciding whether
to approve or deny the project. The system also embedded other
map layers such as rice production, public market, machinery,
and infrastructures which is also one of the determining factors
in the approval of the proposed road. Non-registered users may
also view all the existing road projects and do basic map queries.
The system is accessible at http://geoagri.da.gov.ph/, which is
running and operational.
KeywordsDecision-support system, Farm to Market Road,
Spatial Analysis, GIS
I. INTRODUCTION
Farm-to-market roads (FMRs) are implemented by
several agencies in the Philippines, like the Department of
Agriculture (DA) and the Department of Public Works and
Highways (DPWH) and etc. They are mandated to coordinate
with Local Government Units (LGUs) and involve them in
developing the project [1]. And with the Mandanas-Garcia
ruling that will take in the next fiscal year [2], the state’s
agriculture department encourages the LGUs throughout the
country to identify the priority locations and propose an FMR
project.
FMRs would improve the logistics and linkages of
production areas locally and to the export markets. FMRs
give the farmers access to better prices and make their
products saleability. It also provides the accessibility of
primary services like health services, school access, and
security [3].
Currently, DA has an existing system that is called
IROAD or the Integrated Road on Agricultural Development
[4] that displays the completed FMR projects. It has basic
functionalities like showing layers on the map, searching, and
filtering. It also allows users to upload a Keyhole Markup
Language (KML) file that the Regional Agricultural
Engineering Division (RAED) and partner agencies can add
to the map as a layer for visual analysis.
However, the current system does not store GIS data from
the users for spatial analysis. FMR proposals are still not
consolidated because of its lack of capibilities that the LGUs
can utilize. For this reason, DA through the Bureau of
Agricultural and Fisheries Engineering (BAFE) is developing
GEOAGRI System that can facilitate LGUs needs since DA-
BAFE is responsible for implementing agri-fisheries
engineering, a farm-to-market road, and other relevant
projects [5]. GEOAGRI will serve as repositories of all the
FMR proposals by the LGUs or even from the different
cooperating agencies. A particular FMR proposal goes into
validation, approval, prioritization, and implementation.
Hence, it would require comprehensive management.
In this paper, we focus on how the system uses spatial
analysis to avoid possible duplication of FMR proposals to
ease the decision-making of agency managers.
II. CONCEPTUAL BASIS
GEOAGRI is an improvement of the existing IROAD
system developed by the DA-BAFE. The old system can
display map layers such as the proposed roads,
infrastructures, and machinery. It also allows a public user to
filter the road layers on the map by location (Region,
Province, Municipality, and Barangay). Although the system
can identify if the roads intersect by visually examining the
map, it does not have a mechanism to check its duplication
before approving or denying the FMR projects. Additionally,
the system lacks data and user management, and map
rendering is slow as it loads layers in one request. Integration
of spatial database into a map server is a great tool to address
map request and response issues. It can dynamically display
map information with a reasonable speed that can also be
embedded in a Content Management System (CMS) [6].
Having a map server also allows sharing of geospatial
information through its services like Web Map Service
(WMS) for tile rendering, Web Feature Service (WFS) for
obtaining feature information, among others [7].
On the other hand, administrators resolve user data
management using the Django platform, a web-based
framework built using Python [8]. Django has built-in user
management that includes authentications and authorization.
Also, it can impose a group policy to handle data fluently [9].
III. MATERIALS AND METHODS
For the system to be helpful to the agency’s managers,
checking mechanisms for duplications were implemented
using Django. PostgreSQL with PostGIS plugin for spatial
database and GEOS or Geometry Engine, Open Source for
spatial functionality. Furthermore, GeoDjango, a Django
module that turns it into a GIS framework, was utilized for
spatial management and queries.
Fig. 1. Process flow in checking for duplication
Fig. 1 illustrates the process flow in checking for
duplication. First, a registered user to the system uploads an
FMR project. The system will then inspect the completeness
of the files using JavaScript a client-based programming
language for the web. The accepted file formats are the
following:
Shapefile - uploads should contain at least four files
which are .shp (which stores the geometry of the
file), .shx (the index file that stores the index of the
feature geometry), .dbf (stores the attributes
information of features), and .prj (stores the
coordinate system information) [10].
Keyhole Markup Language (KML) is a file format
(.kml) that users can be view in Google Earth. It’s a
single file that may contain multiple features of
different types.
After checking the files, it will be validated for its
geometry type, dimension, number of coordinates, and
attributes. If the conditions are met, then the location will be
identified. After getting the location, it will execute a filter
query to the road table to get the existing FMR projects then
the result of that query will be used to check for duplication
of a project.
A. Validation of the uploaded files
Upon successfully uploading the file, the system will
convert it into a geometry object to obtain its information
using GEOS API that the GeoDjango module provides.
Results are (1) dimension whether it only contains x and y
coordinates (2D) or it contains z-coordinate for 3D,
representing elevation. Either of the two, the system corrects
its dimension and sets it in 2D. It also checks for its (2)
geometry type if it is a LineString or MultiLineString. Other
than the mentioned types it throws an error prompt. Then it
checks for its (3) number of coordinates to confirm if it
contains at least 2 points that comprise a line. Lastly, it will
check for its (4) attributes. The uploaded file should have at
least the following:
RD_CLASS (road class can be Barangay, Municipal,
Provincial, National or Private)
RD_TYPE (road type can be Earth, Gravel,
Concrete)
RD_LENGTH (road length in kilometers)
RD_WIDTH (road width in meters)
PROVINCE (road province’s location)
REGION (road region’s location)
MUNICITIES (road municipality or city’s location)
BARANGAY (road barangay’s location)
RD_NAME (name of the road)
RD_STATUS (either it is proposed, ongoing,
competed).
Additionally, the system transforms the coordination
system of the geometry into Spatial Reference Identifier or
SRID 32651 (WGS 84 / UTM zone 51N) [11].
B. Identification of the proposed FMR Location
Although the uploaded file contains the location of the
road project, the system still checks for validation using the
existing Barangay Boundary provided by the Philippine
Statistics Authority (PSA). It is imported to the database
using PostGIS Shapefile and DBF loader. An ST_Contains
query will be executed between Barangay Boundary and the
uploaded file.
Fig. 2. ST_Contains query in getting location of road project
Fig. 2 illustrates the query executed in getting the location
of the road project. This query is translated in GeoDjango as
contains, for example:
geos_for_loc = GEOSGeometry (str(geom _uploaded_file))
get_location =
BarangayBoundary.objects.filter(geom__contains=geos_for_loc).v
alues('region','province','municities','barangay').first()
Based on the code snippet above, the location of the road
can be obtained using its geometry by creating a
GEOSGeometry object from the uploaded file, then execute
the query. Fig. 2 shows that if the geometry of the uploaded
file or if the geometry of Barangay Boundary includes the
geometry of the uploaded file [12], then other pieces of
information such as region, province, municipality, and
barangay of the geometry can be extracted where it returned
true.
C. Identification of Existing FMRs within the location
Using the result of the second process which is the
location, the existing road projects can be obtained by
filtering the Road table like this:
base_road = Road.objects.filter(rd_barangay =
get_location[‘barangay’], rd_municities =
get_location[‘municities’], rd_province=
get_location[‘province’]).values('rd_name','geom')
The snippet above will get all the road projects information
such as road name and geometry filtered by location extracted
from the uploaded file geometry.
D. FMR checking for duplication
Depending on how many road projects existed within the
location of the uploaded file, the application will check for
intersection or overlapping. Its geometry will be used in
intersects query iterating the existing road projects.
Fig. 3. Intersects query to check for intersection
As illustrated in Fig. 3, ST_Intersects returns true if the
intersection of two geometries (LineString) does not result in
an empty set [13]. If the query returns true, the name and the
information of the road is obtained where it intersected. It will
then be stored in an array or list and use it for visualization.
Having this mechanism, we can quickly identify how
many road projects intersected with the newly uploaded file.
Thus, it helps the agency’s manager decide whether to
approve or deny the road layer for public consumption.
IV. RESULTS AND DISCUSSIONS
GEOAGRI provides modules depending on the user type
and its access level. For public or non-registered user, only
the Search Roads, Display Layer and Filter Road Layer
modules are accessible. They can search, view and filter the
available layers on the map such as Infrastructures,
Machinery, Public Market, Rice Production Area,
Waterways, Barangay Boundary, Flood Susceptibility, and
Road as shown in Fig. 4.
Fig. 4. GEOAGRI Map Layers
Registered users can access Data Management module
aside plus the access level of the unregistered user. On the
other hand, administrators have access to the remaining
modules like the Reports, User Management, Grieveance
and Requests and Activity Logs as shown in Fig. 5.
Fig. 5. GEOAGRI Modules
User registration needs the approval of the DA-BAFE
Central Office. Once approved, they can now start uploading
a road project.
Fig. 6. GEOAGRI Upload Interface
An interface was created for easy uploading of shapefile
or KML. The user can access this in the Data Management
module by clicking the Upload Shapefile or KML button on
the upper right corner of the table. A modal or pop-up dialog
will be displayed, as shown in Fig. 6. Depending on the
validity of the uploaded file, the system will display a prompt,
as shown in Fig. 7 and Fig. 8.
Fig. 7. GEOAGRI Upload Error Prompt
Fig. 8. GEOAGRI Upload Success Prompt
Once the registered user successfully uploads a road
project, it will be tagged as Pending by the system subject to
approval by the manager before it can be viewable publicly.
Fig. 9. GEOAGRI Data Management Interface
Fig. 9 shows the rich interface of GEOAGRI to display
all the road projects, including the new added projects.
Filtering the upload status is by clicking the buttons on the
upper left corner. Searching can be done by inputting
keywords on the search box and sorting the table of
information can done by clicking the table headers. Also, the
three buttons on the Action column enable the user to update
the road details, check for overlapping or intersections, and
an option to archive the road with the admin’s approval.
Fig. 10. GEOAGRI interface showing number of roads it intersected
Fig. 10 illustrates how easily the road project is
intersecting of with the existing ones. This is an option in
deciding whether to approve or reject the road project.
Fig. 11. GEOAGRI interface showing the road project and where it
intersected
In addition, visual examination of the road is done for
further analysis, as shown in Fig. 11 by clicking the middle
button under the Action column of the Data Management
module.
Fig. 12. GEOAGRI data in graph
GEOAGRI also provides a graphical representation of the
data for a quick overview. It gives the agency head the idea
about the number of road projects per region, province, and
municipality according to road status, type, and class. A
sample graph is shown in Fig. 12 displays the number of road
projects by road type per region.
Fig. 13. GEOAGRI Reports
For further analysis, agency managers can also download
the road projects raw data in Excel format, PDF, or even
generate a shapefile based on the table in the Report module.
The user needs to click the buttons found on the upper-right
corner of the reports table, as shown in Fig. 13.
V. REMARKS AND FUTURE WORKS
This paper presented the process and methods of how
GEOAGRI utilized the spatial data that the LGU can provide
to come up with a science-based approach in terms of
decision-making in the implementation of its FMR Projects.
It also makes use of the publicly available datasets from PSA
for the Barangay Boundary for enriching its ouput.
Currently, the system is accessible at this link
http://geoagri.da.gov.ph. The DA-BAFE maintains the
server, and the development of GEOAGRI is still ongoing to
address the other gaps, such as FMR prioritization and
validation.
VI. ACKNOWLEDGMENT
This work is an output of Caraga State University (CSU)
through the Center for Human-Computer Interaction (CHCI),
one of the research centers of the College of Computing and
Information Sciences (CCIS) and funded by DA-BAFE. We
acknowledge the DA-BAFE for trusting CSU in developing
the system. The researchers also extend their grateful
appreciation to the bureau’s personnel spearheaded by Engr.
Arnel Tenorio and Engr. Cristy Pulido for accommodating
the projects’ concerns and providing the necessary
requirement for developing the application.
VII. REFERENCES
[1]
"Official Gazette of the Republic of the Philippines," 14 September
2021. [Online]. Available:
https://www.officialgazette.gov.ph/1996/05/08/memorandum-
order-no-367-s-1996/.
[2]
"Mandanas ruling to affect agriculture sector," Senate of the
Philippines, 23 June 2021. [Online]. Available:
http://legacy.senate.gov.ph/photo_release/2021/0623_01.asp.
[Accessed 11 November 2021].
[3]
A. Lopez, "PNA," PNA, 10 July 2020. [Online]. Available:
https://www.pna.gov.ph/articles/1108493. [Accessed 14 September
2021].
[4]
"iROAD," [Online]. Available: http://iroad.da.gov.ph/. [Accessed
31 August 2021].
[5]
"DA-BAFE Mandate and Functions," [Online]. Available:
http://bafe.da.gov.ph/index.php/mandate-and-functions/. [Accessed
14 September 2021].
[6]
A. D. M. J. R. M. S. Jaymer Jayoma, "Development of a Land
Property registry system application and dynamic database
management for web-based GIS mapping: A case of Butuan City,
Philippines," in 34th Asian Conference on Remote Sensing 2013,
ACRS 2013, Bali, Indonesia, 2013.
[7]
"Services - GeoServer," [Online]. Available:
https://docs.geoserver.org/master/en/user/services/index.html.
[Accessed 15 September 2021].
[8]
J. M. Jayoma, E. S. Moyon and E. M. O. Morales, "OCR Based
Document Archiving and Indexing Using PyTesseract: A Record
Management System for DSWD Caraga, Philippines," in 2020 IEEE
12th International Conference on Humanoid, Nanotechnology,
Information Technology, Communication and Control,
Environment, and Management (HNICEM), Manila, Philippines,
2020.
[9]
"User Authentication in Django," [Online]. Available:
https://docs.djangoproject.com/en/2.2/topics/auth/. [Accessed 15
September 2021].
[10]
"ArcGIS for Desktop - Shapefile file extensions," [Online].
Available: https://desktop.arcgis.com/en/arcmap/10.3/manage-
data/shapefiles/shapefile-file-extensions.htm. [Accessed 15
September 2021].
[11]
"WGS 84 / UTM zone 51N - EPSG: 32651," [Online]. Available:
https://epsg.io/32651. [Accessed 15 September 2021].
[12]
"ST_Contains," [Online]. Available:
https://postgis.net/docs/ST_Contains.html. [Accessed 14 September
2021].
[13]
"The ST_Intersects() function - IBM Docs," [Online]. Available:
https://www.ibm.com/docs/en/informix-
servers/12.10?topic=functions-st-intersects-function. [Accessed 14
September 2021].
ResearchGate has not been able to resolve any citations for this publication.
Conference Paper
Full-text available
Small to large companies handle multiple forms of records every day. These organizations could use these records for historical, demographical, sociological, medical, or scientific research and serve as benchmarks to measure the organization's future activities and decisions. The Department of Social Worker and Development (DSWD) Caraga continuously generates records daily. Still, their records management system is conventional, giving them a hard time retrieving and keeping track of the record's whereabouts. With this, DSWD Caraga embarks into record's digitization for its management to ensure the preservation of permanent and valuable papers, secured and accessible for future reference as required by the organization's different offices based on existing rules and regulations in records management. This paper endeavors to automate records classification using the open-source Python-Tesseract (PyTesseract) library, the wrapper for Google's Tesseract-OCR Engine. The process starts by converting paper-based documents into digital format (scanning) and then recognize and extract the text using the PyTesseract library. By integrating this library to Django and MySQL, management of record's classification, indexing, and archiving becomes easy. With the help of this system, record's safekeeping and retrieval bring comfort for the records officer.
Development of a Land Property registry system application and dynamic database management for web-based GIS mapping: A case of Butuan City, Philippines
  • A D M J R M S Jayoma
A. D. M. J. R. M. S. Jaymer Jayoma, "Development of a Land Property registry system application and dynamic database management for web-based GIS mapping: A case of Butuan City, Philippines," in 34th Asian Conference on Remote Sensing 2013, ACRS 2013, Bali, Indonesia, 2013.