Large-scale public records portal

A portal that lets officials search, filter and export a very large table of public records without waiting, with access decided by role and every use logged.

Built the load pipeline, the database, the search backend, the portal and its cloud infrastructure.

Receive the extract

Files are checked for shape and completeness before anything is loaded.

Bulk load

Rows go in through the database’s bulk path, with duplicates removed during the load.

Index

Indexes are built for the lookups and filters the portal offers.

Serve

An API pages results and applies the role check on every request.

Operate

The portal runs on cloud servers with two independent ways to reach them for maintenance.