SM

Sayed Mowafi

Full-Stack Developer|
Mobile2024

Metermap

Mobile app for utility meter reading route optimization. Upload Excel data, generate optimized routes, and navigate with real-time tracking.

9:41

Meter 1 of 6

#1007 · Type: E

Villa 12, Al Wasl Rd

1
2
3
4
5
6
Map
Reading

Metermap

React Native / Expo

React Native / Expo

Overview

Metermap is a React Native mobile application designed to help field technicians efficiently navigate to meter locations. The app solves the challenge of planning optimal routes through dozens or hundreds of meter locations scattered across a service area.

The Problem

Utility companies and contractors need to read hundreds of meters spread across large service areas. Without route optimization, technicians waste significant time backtracking and navigating inefficiently. Existing solutions are either too expensive for small operations or require manual route planning that takes hours.

The Solution

Metermap automates the entire workflow from data import to navigation. Technicians upload an Excel spreadsheet exported from their billing system, and the app automatically converts UTM coordinates to latitude/longitude, groups meters by location, calculates the optimal visiting order, and displays the route on a satellite map. The satellite view helps locate meters in areas where street addresses are unreliable.

How It Works

1

Export meter data from your billing or asset management system as an Excel file

2

Upload the file to Metermap, which converts UTM coordinates to lat/long and parses meter details

3

Review any meters with missing coordinates and add them manually or via MyLand URL

4

Generate the optimized route using clustering and nearest-neighbor algorithms

5

Navigate using the satellite map with real-time GPS location tracking

6

Mark each meter as completed and track your overall progress

7

Data syncs to Firebase Firestore for persistence across sessions

Key Features

  • Excel import with UTM to latitude/longitude coordinate conversion using Proj4
  • Intelligent route optimization using clustering and nearest-neighbor algorithms
  • Real-time location tracking with route visualization on satellite maps
  • Satellite map view for easy location identification in the field
  • Progress tracking to mark meters as completed during rounds
  • Automatic grouping of multiple meters at the same address
  • Manual coordinate entry for meters missing location data via direct input or MyLand URL
  • Firebase Firestore for data persistence and session management

Technology Stack

React NativeExpoFirebaseOpenRouteServiceReact NavigationProj4

Customization & Extensibility

The app is built with a modular architecture that makes it adaptable for various field service industries. The coordinate conversion system uses Proj4 to support multiple UTM zones and can be extended for other coordinate systems. The routing algorithm parameters can be tuned for different optimization priorities like shortest distance versus fastest time. The Firebase backend can be replaced with any REST API, and the Excel parser can be configured to match different column formats from various billing systems.

Results

Field technicians using Metermap report completing their rounds significantly faster by eliminating backtracking and reducing time spent searching for meters. The satellite view and coordinate conversion handle the common problem of inaccurate or missing address data. Progress tracking prevents missed meters and provides supervisors with visibility into field operations.

Future Improvements

Planned enhancements for upcoming releases:

  • Turn-by-turn voice navigation for smoother hands-free field work
  • Firebase-based meter location correction system for misclassified coordinates
  • Offline mode with local caching for areas with poor connectivity
  • Photo capture for meter readings with automatic OCR
  • Integration with billing systems for automatic data sync

Command Palette

Search for a command to run...