/tech-parent

Tech parent project including ball-backend and ball-frontend as submodules

Team - Tech Vision | 6° BD

Tech Vision


Challenge Requirements Planning Sprints Technologies Methodology BacklogsTeam


💻 Project configuration

Requirements:

Tech parent project including tech-backend and tech-frontend as submodules

git clone --recurse-submodules https://github.com/TechVisionn/tech-parent.git
  • To update submodules projects in tech-parent after having cloned the project ( Replace "branch_name" with branch name)
git pull --recurse-submodules origin <branch_name>
  • First of all, open ".env" file and configure the path of projects paste, as in the example below:

Git Submodules Documentation


✏️ Problem

The company requires the implementation of a Geographic Information System (GIS) to speed up analysis and improve internal processes. Although the data is available in the public sphere of ProAgro, we face challenges such as a lack of organization, the presence of sensitive information and an excess of data to be managed.

(ProAgro is a federal government program aimed at agricultural financing for small and medium-sized Brazilian producers).


🚀 Solution

We propose a comprehensive solution that involves the collection and refinement of public data from ProAgro, efficient restructuring of the database and the development of a personalized Geographic Information System (GIS), providing information in a simpler and more organized way for the user. This approach seeks to facilitate the understanding and analysis of data, contributing to improvements in the company's internal processes.


🌌 Challenge

Organization of a public Proagro database for quick queries and analysis in the Geographic Information System.


🎯 Project Requirements

📌 Functional Requirements

  • Model a spatial relational database from Proagro tables;
  • Plot the perimeter of the plots reported in the Proagro tables in the geographic information system;
  • Attribute relevant agricultural information to plots plotted in a geographic information system;
  • Cross-reference the Gleba’s spatial information with its location (Municipality and State);
  • Connect and consume the Visiona Vegetation Index Time Series API;
  • The Visiona API query must return a time series for each plot consulted;
  • Save consumed/queried time series in the database;
  • Develop a simple front end that shows the spatially distributed plots, a plot selection button, and the vegetation index graph;
  • The vegetation index time series must be presented by dates defined between 30 days before the planting date and 30 days after the harvest date informed in the Proagro tables and organized in the database.

📌 Non-Functional Requirements

  • The site's response time must be below 1.5 minutes in 99.99% of requests;
  • The application's query engine must generate trails in JSON format (optional);
  • Documentation (Fatec Requirement)
  • The system must contain metrics to help observe its behavior: Qty of requests, response time, qty and % of failures when obtaining data from Golden Sources.


⏳ Delivery Planning

  • Kickoff - 21/08/2023 to 28/08/2023

  • SPRINT 1 - 04/09/2023 to 24/09/2023

  • SPRINT 2 - 25/09/2023 to 15/10/2023

  • SPRINT 3 - 16/10/2023 to 05/11/2023

  • SPRINT 4 - 06/11/2023 to 26/11/2023

  • Solutions Fair - 12/12/2023 at 7 pm


🔗 Click the link below to view the Kanban of team activities:

Kanban Projects GitHub


📅 Sprints

🔖 SPRINT 1 (Folder Link): Done ☑️

🔖 SPRINT 2 (Folder Link): Done ☑️

🔖 SPRINT 3: (Folder Link): Done ☑️

🔖 SPRINT 4: (Folder Link): Done ☑️


🕹️ Technologies Used

  • Database: MySQL and MongoDB
  • Backend: Python
  • Front-end: React
  • Tools: Visual Studio Code, GitHub.

💡 Methodology Used

  • Agile Methodology: Framework Scrum

🔮 Product and Sprint Backlog

🛸 Epics and User Stories


🎓 Team

Avatar Name Role LinkedIn GitHub
Bryan Ribeiro Product Owner
Carlos Souza Scrum Master
Camila Pacheco Dev Team
Andrew Augusto Dev Team
Zaion Felippe Dev Team
José Santos Dev Team
Gabriel Santos Dev Team
Orlando Pereira Dev Team
Kauã Borgarelli Dev Team