Arbutus Lab

Custom build

A Gate Map Backed by Its Own Database

Before leaving to access a destination, it is unclear which gates are in the way, whether they are open or closed, and whether you will have cell service on the trip.

Island Gates shows the gates on the road to that place and marks each one open, closed, or unknown. The sheet for a gate states cell service there: yes and the carrier names, no, or unknown. The iPhone app is the client. PostgreSQL with PostGIS holds the records, and an API is how the phone reads and updates them.

The Database

Each gate has a coordinate, a status, and a history of status changes. A place is stored when a known gate sits on its access road, with the roads that connect it to the public network and the gates those roads cross.

An optional set of rows records cell service. While that switch is on, the app sends a sample about once a minute, including in the background: precise location, a device id kept on the phone, and the carrier name. A sample within 10 metres of one already stored is dropped.

The API

The public API is gates.avanalytics.ca. It serves the gate list, the places behind those gates, photo reports, and cell-service samples. The map does not require an account.

A photo report includes the picture and the location stored in the picture. A vision model reads the photo. The stored status becomes open or closed only when that reading matches what the person reported. A disagreement leaves the gate unchanged.

The Phone

The iPhone app has the map, the place list, and a saved list. Saved gates, saved destinations, and the notification choice stay on the phone. Alerts can cover every gate, only saved gates, or none, and they are posted only while the app is open. The map refreshes about every 2 minutes in that same window.

Settings chooses Light, Dark, or System. A $5 support purchase is handled by Apple and does not unlock a feature.

The Screens

A Build Like This

The same three parts apply to a private map of assets, a field-status list, or a spatial table a team already keeps: a PostgreSQL database, an API that writes it, and a phone or web client that does not talk to the database directly.

The status rule sits in that API. The phone can send a report. It cannot mark a gate open on its own.

Privacy

A gate photo and the location in that photo are sent to gates.avanalytics.ca so the status can be checked.

Saved gates, saved destinations, and the notification choice stay on the phone.

The map does not require an account.

With Help map cell service on, the app sends precise location, a device id kept on the phone, and the carrier name to gates.avanalytics.ca.

The form on this page sends your name, email, and message to Arbutus Visual Analytics by email. We use them to reply.

Support

Send a question about Island Gates. You can also email marc@avanalytics.ca.