Jeffrey Bernadas

Software Engineer

I build enterprise-grade and responsive digital solutions for the web and mobile.

Back to Projects

PSGC API

PSGC API screenshots 1
PSGC API screenshots 2

Description

A RESTful API providing access to the Philippine Standard Geographic Code (PSGC) data. The data is sourced from official PSGC Excel sheets, transformed into JSON using custom scripts, and grouped by PSGC specification codes for easy access and filtering.

Features

  • -API versioning (V1 uses JSON files, V2 planned with database)
  • -Custom scripts to transform official PSGC Excel data to structured JSON
  • -Rate limiting: 25 requests/10 min (1 request/10 min for all barangays endpoint)
  • -Returns population numbers and counts for regions, provinces, cities, etc.
  • -Redis caching with 1-hour TTL for all endpoints
  • -Pagination support for all endpoints
  • -Comprehensive Swagger documentation
  • -Filter by regions, provinces, cities, municipalities, and barangays
  • -Completely free and open source

Tech Stack

  • Node.js
  • Express.js
  • Redis
  • Swagger
  • Winston Logger
Jeffrey Bernadas