README

A Laravel package that provides all 33 departments and 1,122+ municipalities of Colombia, based on official DANE (Departamento Administrativo Nacional de Estadística) codes.

Requirements

• PHP 8.1+
• Laravel 10, 11, or 12

Installation

Install the package via Composer:

composer require baironbernal/colombia-locations

Laravel will automatically discover the service provider. Then run the migrations:

php artisan migrate

Finally, seed the database with all Colombian departments and municipalities:

php artisan db:seed --class="BaironBernal\ColombiaLocations\Database\Seeders\ColombiaLocationsSeeder"

Database Structure

departments table

municipalities table

About DANE codes: The municipality code is formed by the 2-digit department code + 3 digits for the municipality. For example, 05001 = Medellín (05 = Antioquia, 001 = Medellín).

Usage

The package ships with two Eloquent models you can use directly.

Get all departments

use BaironBernal\ColombiaLocations\Models\Department;

$departments = Department::all();

Get all municipalities of a department

use BaironBernal\ColombiaLocations\Models\Department;

$antioquia = Department::where('code', '05')->first();
$municipalities = $antioquia->municipalities;

Get a municipality with its department

use BaironBernal\ColombiaLocations\Models\Municipality;

$medellin = Municipality::where('code', '05001')->first();
echo $medellin->name;              // "Medellín"
echo $medellin->department->name;  // "Antioquia"

Search municipalities by name

use BaironBernal\ColombiaLocations\Models\Municipality;

$results = Municipality::where('name', 'like', '%bogotá%')->get();

Get departments with their municipalities eager loaded

use BaironBernal\ColombiaLocations\Models\Department;

$departments = Department::with('municipalities')->get();

Publishing Assets

If you want to customize the migrations or seeders, you can publish them to your project:

# Publish migrations
php artisan vendor:publish --tag=colombia-locations-migrations

# Publish seeders
php artisan vendor:publish --tag=colombia-locations-seeders

Data Coverage

License

This package is open-sourced software licensed under the MIT license.