Overview
Zerachiel is a comprehensive web and mobile management system designed to modernize and streamline cemetery operations. It centralizes cemetery data and provides intuitive tools for staff to manage burial records, assign plots, and schedule maintenance activities. Visitors benefit from a guided and user-friendly experience thanks to the mobile app, which integrates an interactive map, advanced search features to locate loved ones, and step-by-step navigation to specific gravesites. By digitizing records and simplifying field operations, Zerachiel enhances accuracy, accessibility, and overall service efficiency for cemetery organizations.
Features
- Mobile interactive cemetery map with searchable gravesites
- Guided navigation to specific tombs through the mobile app
- Burial record management with filtering and detailed information
- Admin dashboard for plot assignments and maintenance tasks
- Real-time data synchronization between web and mobile applications
- Search system for locating deceased individuals and family areas
- Role-based access control for staff and administrators
- Maintenance scheduling and task management
Technologies Used
- Flutter for cross-platform mobile development
- ArcGIS Runtime SDK for interactive mapping and spatial navigation
- Next.js for the responsive web interface and server-side rendering
- NestJS for backend architecture and REST API design
- MySQL for reliable and structured database management
- JWT for secure authentication and role-based permissions
- Tailwind CSS for clean and responsive UI components
Challenges & Solutions
Challenges
Designing an accurate and intuitive mapping experience exclusively on mobile required managing geospatial data and handling irregular plot shapes. Integrating ArcGIS within Flutter introduced complexity due to limited documentation and the need for precise coordinate handling. Ensuring consistent data synchronization between the mobile map and the administrative web dashboard also required careful API planning. Additionally, the system needed to provide fast search performance even with large amounts of burial records.
Solutions
I implemented a flexible geospatial data model to accurately represent plot layouts and configured ArcGIS Runtime SDK to handle offline map rendering and smooth user interaction. To guarantee data consistency, I structured the NestJS REST API with clear endpoints, validation rules, and optimized queries. Caching strategies and indexed MySQL tables were used to accelerate search operations. For the user experience, I designed simplified flows and map interactions that make navigation intuitive even for non-technical visitors.