As an IT Scientist, I have little knowledge on Agriculture based on Agric Science I did in Secondary School but this
knowledge wasn't enough so I started interviewing Farmers,Agricultural Lecturers and Students within my area and In my school on what to do to ensure excellent farming, maximum crop yield and to ensure that
all this information are passed from one generation of Farmer to another without alteration. The average resopnse I got were stated below.
1.) If appropriate planning are in place regarding financial Capabilities,production cost,crops yields things will be okay.
2.) Testing of soil propertises need to be done to know the crop suitable for a particular Areas.
3.) The major problems faced by farmers are mostly drought, weeds and Insect Attacks. If this can be mitigated, then maximum yield can be expected.
4.) Most Young Agricultural graduates and Farmers lack interest in Farming because of unavailability of Informations on Modern trends in Agriculture.
All Professors and all Agricultural Students and graduates in various Universities Points out that If USDA Dataset can be collabrated with Social Network for purpose of Dataset Analysis, Data Visualisation, information Exchange(Just like in Facebook),it will make farming/Agricultural Studies one of the most interesting discipline in the world.
For Instance a Young Graduate trying to setup a Soyabeans Farming can immediately leverage USDA Datasets and can share his knowledge, ideas or issues with other Users(Farmers) via a social network thus ensuring information propagation through an unbroken succession from one generation of Farmer to another. Farmers are ensured that any issues on farming can easily be resolved by leveraging USDA Dataset and by other responses from Farmers from various Farming disciplines within the Social Network.
What Inspiration & Interview Lands me into.
USDA Dataset is Very Broad though the API Call for each dataset is very simple. Thanks for the USDA Enginneers.
From Inspiration above, we all knew that Water(H2O) and Air(O2) are two essential commodities that support human lives.
While Human uses Oxygen(O2), plant uses Carbondioxide(CO2) for Photosythesis as can be expressed mathematically in
the Photosynthetic Equation Below
From the Photosynthetic Equation Above, You can Visualize the quantity of Water and Carbon(iv)Oxide needed as a reactant to yield a Product called Sugar.So from this equation, you can understand that water is very essential for plants growths and crops yield. Consequently, lack of water commonly known as DROUGHT can be disasterous to plants as it can inhibits photosynthesis in plants and can lead to little or no crop yield or the plant may even die off due to lack of water.
What I built
An app that allows American Farmers to visualized their idea crops,predicts production cost, knows the favourable state for growing a particullar crop, visualized the amount of water needed(eg. Irrigated Water,Ground Water, Surface Water) and quantity of crops yields in Bushels over time. The app also allows information exchange between Farmers via a social network. The App leverages Irrigation Technology & Water Use (ARMS DATASET 1999-2006).
What this App Does
Components A: USDA Data Visualisations
The App leverages Irrigation Technology & Water Use (ARMS DATASET 1999-2006). From the USDA Dataset above, we picked up two crops (Soyabeans and Corn) so we started with Soyabeans as a case study via the API Call. so the app were able to integrate all Planted Acres, Irrigated Acres, the ground water usage, surface water usage and irrigated water used on the crop(Soyabeans) and amount of products yields(Bushels) per application over time(eg 2006,2002,2000,1999 etc..). This datasets were collected for every states in United States. All this datasets were dynamically created via API Call to deploy Data Visualization components and statistical graphs were ploted using Bar Charts, Column Charts,Aggregated Area Chart and Pie Chart distribution Analysis over time.
With this Graphs Visualization Components, Farmers can be able to Visualized graphs Dataset on each states in USA on crops Yields(eg.Soyabeans) over time(eg year 2006,2002,2000,1999 etc)
For instance in Arkansas, Kansas, Nebraska etc........Farmer can graphically visualize over time,
A.) Amount of surface water used vs Crop Yield(Eg. Soyabeans in Bushel)
B.) Amount of Ground Water Used vs Crop Yield(Eg. Soyabeans in Bushel)
C.) Amount of Irrigated Water Applied vs Crop Yield(Eg. Soyabeans in Bushel)
D.) Amount of planted Acres etc...
From this graph Visualisation statistical Analysis, Farmer can be able to know the quantity of water
needed and amount of crops that can be produce with it with respect to time(Eg. year 2006,2002,2000,1999).
For instance in Nebraska state in the year 2006, the average Arms Datasets were as follows
Ground Water Used: 90.472 Percent of Irrigated Acres.
Surface Water Used: 9.528 Percent of Irrigated Acres.
Water Used Per Irrigated Acres: 9.715 Per Inches.
Irrigated Acres: 2369.147 Per 1,000 Acres.
Planted Acres: 5050.109 Per 1,000 Acres.
Crop Yield Per Irrgated Acres: 61.98 Pounds(cotton), Bushels(all other crops).
All this statistical Data will help Farmers in decision making process like checking production cost, crops yield and Business Profitability
The app also provides Dataset Graphs Visualisation Components that allows Farmers to Compare and visualize data at State Levelon
the amount of planted Acres per state, the amount of Water needed(Eg Irrigated, Surface and Ground Water) versus Crop Yield etc per state.
This will help USA Farmers to know the States that consumes more water and amount of crop yields(eg. Soyabeans).
For instance, graphs data visualisation on state level comparison eg in year 2006, shows that
INDIANA consumes highest Groundwater(about 100.00 percent of irrigated acres and crop yields was 40.561 Bushels) while
NEBRASKA consumes lesser Groundwater(90.472 percent of irrigated acres and yield the highest crop in the year about
Based on Production Cost,You can see that Nebraska in the year 2006(ARMS DataSets) consumes lesser water and produces the
highest Crop Yields(Eg. Soyabeans) than its counter part state Indiana that consumes the highest water in the same
year but produces a lesser Crop Yields.
The Inference from this Arms dataset 2006 makes Nebraska one of the best state in USA suitable for Soyabeans Farming both in production cost and crop Yields.
Components B: Social Network Integration with 1-to-1 Chat System with Photo Sharing Option
My Interview with Farmers, Professors and all Agriculttural Students and graduates in various Universities
Points out that If USDA Dataset can be collabrated with Social Network for purpose of Dataset Analysis, Data Visualisation,
information Exchange(Just like in Facebook),it will make farming/Agricultural Studies one of the most interesting discipline
in the world. For Instance a Young Graduate trying to setup a Soyabeans Farming can immediately leverage USDA Datasets and
can share his knowledge, ideas or issues with other Users(Farmers) via a social network thus ensuring information propagation
through an unbroken succession from one generation of Farmer to another.
This Social Integration are design to function just like facebook.
it will help farmers exchange informations between themselves. Farmers, Agriculturist can be able to Share and post
status updates, post photos, post and Share Videos, send like & comments etc. about Agricultural modern trends and for educative puposes. Farmers can be
able to send friend request to their fellow Farmers, Makes friends and chat with one another on 1-to-1 chat conversations
with photo sharing options. Users can be able to search Farmers based on their names,email address, phone number and Farmers
farming specialization. For instance if you are looking for a farmer that speacialized on Corn Farming to have a conversation
with him or her, you can just type corn in the search box and all farmers that specialized on corn farming will be
If you know how to use facebook, this social integration will be easy for you as everything were implemented using facebooklike technology and user friendly UI designs.
How it Works
Just call up the application and make one time registration. Login to start accessing the app.
To visualize USDA Datasets, click on AGRO PRODUCT, select soyabeans as a case study and then navigate. On the landing page, you can be able to access the USDA Datasets on different states overtime eg(year 2006,2002,2000,1999), If the states you are looking for is not loaded, Click on LOAD MORE US STATE button to load more state.
Every Populated states immediately shows average Planted Acres, ground water used,surface water used, irrigated water applied
and amount of crop yield over time.
To be able to visualize datasets statistics of a particular state eg ARKANSAS,NEBRASKA etc... you can click on
Click on View State Statistics
To be able to compare datasets statistics for all states at state level, click on Compare All States flanking each state. Once you are there first select the year eg (2006,2002,2000,1999) that you want to compare and visualized, and the graphs data will be loaded for each year choosen. For further details reference the demonstration video or email me.
For Social integration, everybody is already facebook fans, so just assume yourself to be accessing facebooks where you can post Status Updates, Post Photos, Post and Share Videos on Farming and Agro-Educations. Can Send Friend request, Makes friends, Like and Comments on every post being Shared, can search and connect to any Farmer in United States. Among all can be able to Chat with other Farmers in United States on 1-to-1 chat messages with photo sharing option..
Challenges I faced
Some Datasets has null values when making API Call to USDA ARMS DATASETs. NUll simply means that the value in Undetermined,
unknown or Not available. I implore a module on my server backend that converts all null values in the API to zero
to make statistical analysis more efficient.
Again Building a Social Network with Facebook design with all techonogical components and features to make the app user
friendly and integrating it with USDA DATASETS for Data Analysis and Visualization took much of my time to be precise(32 days)
We will adding other remaining crops and its datasets one after the other via the API call and allows data Visualisation on the fly while ensuring
that all datasets are in place.
we need to expand social aspect of the Apps to allow farmers to start creating Farmers Groups, Farmers Page just like in facebook. Eg A farmer can create a group on titled "Rice Farming" and other farmers who are interested on Rice farming can follow up.
Android Version in less than 14 days. IOS and Windows version can be coded in less than 30 days if there is a need for it . All resources is just set for coding.
Technology Upgrade coming soon......
1.) Using Memcache to offload load on the database.
2.) Presently the Chat system works on Long connection polling and server sent Events.
Currently, this chat system will be using Redis or finally ejabbered/Xmmp protocols.
C, Java, Objective C, Coldfusion, PHP,Oracle,Mysql,Memcache, Redis,Ejabbered/XMMP and Phonegap.