Geopanap Application

The Geopanap application is a semi-government platform designed to streamline and manage various processes related to land leases and environmental compliance. It provides a comprehensive solution for land management, customer relations, and regulatory compliance in the context of mineral exploration and extraction activities.

Description

The Geopanap application facilitates the management of land leases, customer information, environmental compliance records, and regulatory documentation for mineral-related activities. It serves as a centralized platform for semi-governmental agencies to efficiently manage and monitor land use, lease agreements, and environmental impact assessments.

Table Definitions

• gmail_accounts: Stores Gmail account information for user authentication.
• customers: Manages customer information, including name, contact details, and associated Gmail account.
• leases: Tracks land lease agreements, including lease details, customer associations, and expiration dates.
• minerals: Stores information about minerals involved in exploration and extraction activities.
• ec_records: Records environmental compliance data, including expiration dates, status updates, and related lease information.
• gpcb_records: Manages regulatory documentation and compliance records, including IFP and GPCB IDs, status updates, and associated lease information.

Features

• Land Lease Management: Allows semi-governmental agencies to manage land lease agreements, including lease details, survey information, and lease expiry dates.
• Customer Relationship Management: Provides tools for managing customer information, including contact details and associated land leases.
• Environmental Compliance Tracking: Facilitates the tracking of environmental compliance records, including expiration dates, status updates, and regulatory documentation.
• Regulatory Documentation Management: Offers functionalities for storing and managing regulatory documents related to mineral exploration and extraction activities.
• User Authentication and Access Control: Implements user authentication mechanisms and access controls to ensure data security and integrity.
• Store password in database using Encryption

Technologies Used

• Development Platform: Tooljet
• Language: HTML, CSS,JavaScript
• Database: PostgreSQL
• File Storage: AWS S3

Screenshots

1)ER Diagram

2)Customer

3)Lease

4)EC

5)GPCB

Demo

https://youtu.be/zcCoNqmiFtw