Table of Contents

• Table of Contents
• Description
• Client
• Illustration of Features
• Demonstration
• User Manual
• Sprint Epic
• Product Backlog
• Technologies
• Members
• Schedule of API

Description

POP is a platform for monitoring agricultural activities registered in Proagro. Furthermore, the system has prediction tools that aim to help the user in decision-making.

Client

Resulting from a unique initiative by the Brazilian Government to encourage the creation of an integrating company in the space industry, Visiona is a joint venture between Embraer Defense & Security and Telebras.

Illustration of Features

To access our prototype, click here.

Demonstration

To access our project playlist, click here:

Sprint Epic

Sprint	Epic
Sprint 1	DevOps, Data treatment, Database settings, Land mapping
Sprint 2	Land mapping in QGIS, User details
Sprint 3	Time series, Terms for users
Sprint 4	App

Product Backlog

• SPRINT 1: Basic Features
• Data Integrity Assessment
• Treatment of Evaluated Data
• Implementation of LGPD Rules
• Implementation of Relational DDL
• Relational Database Modeling
• ETL configuration
• Study for the Creation of the QGIS Plugin
• Back - Creation of the Model for Communication with the Database
• Back - Endpoint Implementation
• Front - Login Page
• Front - Mapping Screen
• Back - Creation of Endpoints
• Front - API Consumption
• Creating StatefulSet PostGIS
• AKS Cluster Configuration
• Github Actions Pipeline
• Helm Chart Configuration
• SPRINT 2: QGIS Features
• Add Admin User
• Delete Account
• Data Dictionary
• Limit Map By Beters
• Validate Informations
• New Page For Admin User
• Update User
• Login Page in QGIS
• Create Docker Image
• Mapping Screen in QGIS
• User Manual
• Help Screen in Web App
• Automatic Horizontal Service Escalation
• Creation of Application Deployment
• SPRINT 3: Time series
• Authorization to Use Owner Data
• E-mail Service
• Update Data Dictionary
• Update User Manual
• Load Test with Locust
• Create Route with Trained Model
• Create Prediction Model
• Study Redis Queue/FastAPI Cache Layer
• Create NoSQL Service for Prediction
• Apache Cassandra NoSQL Modeling
• Create Owner Term Route
• SPRINT 4: Weather chart
• Open Weather API
• Terms in QGIS
• Encrypted Database Backup
• Load Test with Locust in Maps View
• Cloud Application
• Download PDF with Details

Technologies

Members

• Betriz Medeiros (PO)
• Victor Cavichioli (SM)
• Pedro Motta (DEV)
• Hamilton Zanini (DEV)

For more information¹, click here.

Schedule of API

Date	Event
21/08 a 25/08	Kick-off.
04/09 a 24/09	Sprint 1
25/09 a 15/10	Sprint 2
16/10 a 05/11	Sprint 3
06/11 a 26/11	Sprint 4
12/12	Solutions Fair

Footnotes

1. Team responsible for API development ↩