AGROGEOINFORMATICS By Basleen Kaur Makkar Guntas Kaur Grewal

AGROGEOINFORMATICS By: Basleen Kaur Makkar Guntas Kaur Grewal

INTRODUCTION Our project on agro-geoinformatics focuses on collection of data such as soil details, water quality and crop details by farmers and officials from various areas of Punjab. Agro-geoinformatics is critical for agriculture sustainability, food security, agricultural industry, natural resource conservation and land use management. The collected data will be utilised to inform the farmers about agricultural practices in accordance to their land resources available to them.

OBJECTIVES The prime objective of this application is to gather data of different agricultural lands/areas from their respective farmers. The gathered data will be stored, preserved, processed, accessed analysed to facilitate improved decision making. The application, will help improve the productivity and crop yield by alleviating the agricultural conditions. This will reduce the gap between farmers and agricultural scientists. The information will prove to be substantial for environmental research, agricultural decision making and policy formulation.

REQUIREMENTS Agro- geoinformatics is an android application. The requirements for creating this application are: Device Capabilities Android operating system, working cellular network, internet access RAM 3 gb & above Processor Intel Quad Core & above IDE Android studio SDK Android Operating System Windows, Linux or Mac OS X System

USER REQUIREMENTS This mobile application, agrogeoinformatics has been developed to overcome the disadvantages of the existing web application. The proposed system Agro-geoinformatics is a user friendly, powerful and interactive application(online) that is handy i. e. it is available on an android device which can be a tablet or a smartphone, and directly links to a database where the request records are updated automatically and the data is readily available anytime it is needed. Only authorized and valid personnel can access the application to observe and analyse the data.

MODULES Employee/Admin Login: This activity will allow the employees of the concerned departments to register and login through the app to access the collected data. Water Quality: This activity consists of a form that will allow the user to enter information regarding water quality in their area. It includes fields like date of observation, name of the farmer, detailed information about the location of the field, crop rotation, depth of the water table, water quality, source of irrigation and crops.

Crop details: This activity includes a form to add information regarding one’s crop. It includes fields such as date of observation, name of the farmer, detailed information regarding one’s land, variety of crop, weeds, seasons, method of harvesting and pest control. Soil Quality: This activity includes a form for the user to enter information regarding the soil of their agricultural land. It includes fields like, name of the farmer, date of observation, detailed information about the location, crop, soil colour, soil texture, type of manure used and its quantity.

Admin Module: The admin login function is for admin to login to access the details entered by the farmers. Admin can also view map view. About us: About us option is used to give advantage to the farmers about the information how to use the application.

Development and Implementation Introduction to Languages: Java The entire component has been developed using Java technology. Java has been chosen as the platform because of its feature rich nature. The Java Platform provides robust end-toend solutions for networked applications as well as a trusted standard for embedded applications. There a number of ways to create apps for Android devices, but the recommended method for most developers is to write native apps using Java and the Android SDK. Java for Android apps is both similar to other types of Java applications. So Java was a natural choice for development process.

PHP is a recursive acronym for PHP: Hypertext Preprocessor. PHP is a server side scripting language that is embedded in HTML. It is used to manage dynamic content, databases, session tracking, even build entire e-commerce sites. It is integrated with a number of popular databases, including My. SQL, Postgre. SQL, Oracle, Sybase, Informix, and Microsoft SQL Server. Android is an open source and Linux-based operating system for mobile devices such as smartphones and tablet computers. Android was developed by the Open Handset Alliance, led by Google, and other companies.

DATABASE DESIGN The database and the respective tables have been created on sql server and php has been used as a server side language to create a connection between the front and the back end of the application. Microsoft SQL is a popular Relational Database Management System (RDBMS) developed by Microsoft. Being a database server, its primary function is to store and retrieve the data as and when requested by other software applications.

Administering Microsoft SQL server database can help one optimize as well as maintain your server’s performance while ensuring its recoverability and availability. A number of procedures have been created either to insert the required information or save the results from various modules. 1) Soil details:

2) Crop details: 3) Water Details:

OUTLINE OF THE SYSTEM DESIGN Modules (Screenshots) 1) Home module:

2) Detail forms:

3) Admin Login/Module:

4) Tabular form/Mapview:

Modules 1) Home Screen in Punjabi

2) Detail forms:

3) Login/Admin module:

CONCLUSION The proposed system that is an Android Application called Agrogeoinformatics, which has been developed using Java, Android Studio, server and Php that fully meets the objectives of the system for which it has been developed. This application has been developed by keeping in mind the famers’ welfare and help them increase agricultural productivity and subsequently the earned profits. The aforementioned results are obtained from the suggestions of the concerned scientists in accordance with the land resources available.

FUTURE SCOPE In future we will try to authenticate the app once it is being in more use and knowledge by keeping register and login module. To elaborate, in the future only registered people can access the services. And now this application is in Punjabi and English i. e. bilingual application which reduces the language deficiencies, as some of the farmers might not understand English however in future we will try to develop it in other languages like Hindi which will help the people in other states to access services of the application easily.

THANK YOU!