PHPackages jericdei/psgc-database - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [CLI & Console](/categories/cli) 4. / 5. jericdei/psgc-database ActiveLibrary[CLI & Console](/categories/cli) jericdei/psgc-database ====================== This is a simple CLI tool to easily add Philippine Standard Geographic Code (PSGC) data to your database. 017[4 PRs](https://github.com/jericdei/psgc-database/pulls)PHPCI passing Since Oct 13Pushed 1mo ago1 watchersCompare [ Source](https://github.com/jericdei/psgc-database)[ Packagist](https://packagist.org/packages/jericdei/psgc-database)[ RSS](/packages/jericdei-psgc-database/feed)WikiDiscussions main Synced 1mo ago READMEChangelogDependenciesVersions (5)Used By (0) PSGC Database ============= [](#psgc-database) [![Latest Version on Packagist](https://camo.githubusercontent.com/39979a127667dac3239d3272e2ec37c94b2746e890c5cf95bae6ba5b5312b01a/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f6a657269636465692f707367632d64617461626173652e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/jericdei/psgc-database)[![GitHub Tests Action Status](https://camo.githubusercontent.com/76b7e4c2fefc2ded696a35da7c266d1e64e0baa419b51e8881f56371583fefca/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f616374696f6e732f776f726b666c6f772f7374617475732f6a657269636465692f707367632d64617461626173652f72756e2d74657374732e796d6c3f6272616e63683d6d61696e266c6162656c3d7465737473267374796c653d666c61742d737175617265)](https://github.com/jericdei/psgc-database/actions?query=workflow%3Arun-tests+branch%3Amain)[![GitHub Code Style Action Status](https://camo.githubusercontent.com/ff2d42c7012960eb5768b736c671be2f5265d0ce881295d7617707ba9a2ef99e/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f616374696f6e732f776f726b666c6f772f7374617475732f6a657269636465692f707367632d64617461626173652f6669782d7068702d636f64652d7374796c652d6973737565732e796d6c3f6272616e63683d6d61696e266c6162656c3d636f64652532307374796c65267374796c653d666c61742d737175617265)](https://github.com/jericdei/psgc-database/actions?query=workflow%3A%22Fix+PHP+code+style+issues%22+branch%3Amain)[![Total Downloads](https://camo.githubusercontent.com/dac3f14ae941f1d6750c7801c5d88d19eca478d94d3b7169d697759b026327d7/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f6a657269636465692f707367632d64617461626173652e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/jericdei/psgc-database) **WORK IN PROGRESS!!** This is a simple CLI tool to easily add Philippine Standard Geographic Code (PSGC) data to your database. Support us ---------- [](#support-us) [![](https://camo.githubusercontent.com/de650658746238dc87403dd4e0402c91e3b6584237655a6168f25482c3290e18/68747470733a2f2f6769746875622d6164732e73332e65752d63656e7472616c2d312e616d617a6f6e6177732e636f6d2f707367632d64617461626173652e6a70673f743d31)](https://spatie.be/github-ad-click/psgc-database) We invest a lot of resources into creating [best in class open source packages](https://spatie.be/open-source). You can support us by [buying one of our paid products](https://spatie.be/open-source/support-us). We highly appreciate you sending us a postcard from your hometown, mentioning which of our package(s) you are using. You'll find our address on [our contact page](https://spatie.be/about-us). We publish all received postcards on [our virtual postcard wall](https://spatie.be/open-source/postcards). Installation ------------ [](#installation) You can install the package via composer: ``` composer require jericdei/psgc-database:dev-master ``` You can publish the config file with: ``` php artisan vendor:publish --tag="psgc-database-config" ``` Usage ----- [](#usage) ### Make sure to publish and run the migrations [](#make-sure-to-publish-and-run-the-migrations) ``` php artisan vendor:publish --tag="psgc-database-migrations" php artisan migrate ``` ### Download the latest PSGC data and store in your `storage/public` directory [](#download-the-latest-psgc-data-and-store-in-your-storagepublic-directory) ``` php artisan psgc-db:download ``` ### Convert the Excel file into tables in your database [](#convert-the-excel-file-into-tables-in-your-database) ``` php artisan psgc-db:convert ``` Testing ------- [](#testing) ``` composer test ``` Changelog --------- [](#changelog) Please see [CHANGELOG](CHANGELOG.md) for more information on what has changed recently. Contributing ------------ [](#contributing) Please see [CONTRIBUTING](CONTRIBUTING.md) for details. Security Vulnerabilities ------------------------ [](#security-vulnerabilities) Please review [our security policy](../../security/policy) on how to report security vulnerabilities. Credits ------- [](#credits) - [Jeric June Logan](https://github.com/jericdei) - [All Contributors](../../contributors) License ------- [](#license) The MIT License (MIT). Please see [License File](LICENSE.md) for more information. ### Health Score 24 — LowBetter than 32% of packages Maintenance60 Regular maintenance activity Popularity6 Limited adoption so far Community10 Small or concentrated contributor base Maturity18 Early-stage or recently created project Bus Factor1 Top contributor holds 60% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Community Maintainers ![](https://www.gravatar.com/avatar/7f65607dcc07f8da38f84f86c831568afe371f16ec4c7553b750765e03bdb2b6?d=identicon)[jericdei](/maintainers/jericdei) --- Top Contributors [![jericdei](https://avatars.githubusercontent.com/u/85361575?v=4)](https://github.com/jericdei "jericdei (15 commits)")[![dependabot[bot]](https://avatars.githubusercontent.com/in/29110?v=4)](https://github.com/dependabot[bot] "dependabot[bot] (5 commits)")[![github-actions[bot]](https://avatars.githubusercontent.com/in/15368?v=4)](https://github.com/github-actions[bot] "github-actions[bot] (5 commits)") --- Tags psgc ### Embed Badge ![Health badge](/badges/jericdei-psgc-database/health.svg) ``` [![Health](https://phpackages.com/badges/jericdei-psgc-database/health.svg)](https://phpackages.com/packages/jericdei-psgc-database) ``` ### Alternatives [wp-cli/wp-cli WP-CLI framework 5.0k17.2M320](/packages/wp-cli-wp-cli)[consolidation/annotated-command Initialize Symfony Console commands from annotated command class methods. 22569.8M19](/packages/consolidation-annotated-command)[chi-teck/drupal-code-generator Drupal code generator 26947.8M5](/packages/chi-teck-drupal-code-generator)[seld/cli-prompt Allows you to prompt for user input on the command line, and optionally hide the characters they type 24725.8M17](/packages/seld-cli-prompt)[illuminate/console The Illuminate Console package. 12944.1M5.1k](/packages/illuminate-console)[php-tui/php-tui Comprehensive TUI library heavily influenced by Ratatui 589747.0k6](/packages/php-tui-php-tui) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)