PHPackages                             epigra/trgeozones - 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. [Database &amp; ORM](/categories/database)
4. /
5. epigra/trgeozones

ActiveLibrary[Database &amp; ORM](/categories/database)

epigra/trgeozones
=================

Türkiye İl İlçe Semt Muhit Mahalle ve Posta Kodları Laravel Paketi. Adds Turkish Geographical Zones Support to your project including Cities, Districts and Countries in Turkish

4.2.3(2y ago)8820.3k↓40.9%19proprietaryPHPCI passing

Since Jul 28Pushed 2y ago4 watchersCompare

[ Source](https://github.com/epigra/tr-geozones)[ Packagist](https://packagist.org/packages/epigra/trgeozones)[ RSS](/packages/epigra-trgeozones/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependenciesVersions (20)Used By (0)

Ülkeler ve Türkiye İl İlçe Semt Mahalle ve Posta Kodu Veritabanı (Laravel)
==========================================================================

[](#ülkeler-ve-türkiye-i̇l-i̇lçe-semt-mahalle-ve-posta-kodu-veritabanı-laravel)

Bu paket Türkiye'deki İl, İlçe, Semt ve Mahalleleri içeren veritabanıdır. Ayrıca bu veritabanı içerisinde yer alan verilerin posta kodları da bulunmaktadır.

Yükleme
-------

[](#yükleme)

`composer require epigra/trgeozones` diyerek paketi indirebilirsiniz.

### Migrate

[](#migrate)

Kurulumu tamamladıktan sonra tabloları oluşturmak için

```
php artisan migrate

```

demeniz gerekmektedir.

### Seed

[](#seed)

Tüm tabloları seed etmek için sisteminizdeki DatabaseSeeder'da yer alan `run()` methodu içerisine

```
$this->call(Epigra\TrGeoZones\Database\Seeders\TrGeoZonesDatabaseSeeder::class);

```

satırını ekleyerek tüm seederları çalıştırabilir; ayrı ayrı çalıştırmak isterseniz opsiyonel olarak aşağıdaki sınıfları kullanabilirsiniz.

```
$this->call(Epigra\TrGeoZones\Database\Seeders\GeozoneCountriesTableSeeder::class);
$this->call(Epigra\TrGeoZones\Database\Seeders\GeozoneCitiesTableSeeder::class);
$this->call(Epigra\TrGeoZones\Database\Seeders\GeozoneCountiesTableSeeder::class);
$this->call(Epigra\TrGeoZones\Database\Seeders\GeozoneDistrictsTableSeeder::class);
$this->call(Epigra\TrGeoZones\Database\Seeders\GeozoneNeighbourhoodsTableSeeder::class);

```

şeklinde ekleyebilirsiniz.

Veri Güncelliği
---------------

[](#veri-güncelliği)

Veriler  adresinde yayınlanan veriler doğrultusunda 10.08.2022 itibarıyla günceldir.

İndirdiğiniz excel tablosu üzerinden güncelleme yapmak isterseniz öncesinde `composer require maatwebsite/excel epigra/trstringhelper` komutunu çalıştırarak gerekli paketleri kurduğunuzdan ve Kernel içerisine `\Epigra\TrGeoZones\Console\ExcelMigrator::class` eklediğinizden emin olduktan sonra

```
php artisan trgeozones:import

```

komutunu kullanarak excel importu gerçekleştirebilirsiniz.

Excel Import komutu statik olarak storage klasörünün içerisinde yer alacak `trgeozones_update.xlsx` dosyasına bakacak şekilde çalışmaktadır..

SQL Dump
--------

[](#sql-dump)

Seeder kullanmadan SQL formatında dumpları indirmek için [http://epigra.com/packages/tr\_geozones\_sql\_dump-2020-09-28.zip](http://epigra.com/packages/tr_geozones_sql_dump-2020-09-28.zip) adresindeki arşivi kullanabilirsiniz.

###  Health Score

43

—

FairBetter than 91% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity42

Moderate usage in the ecosystem

Community22

Small or concentrated contributor base

Maturity72

Established project with proven stability

 Bus Factor2

2 contributors hold 50%+ of commits

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.

###  Release Activity

Cadence

Every ~224 days

Recently: every ~69 days

Total

13

Last Release

894d ago

Major Versions

1.0 → 2.02019-08-17

2.2 → 3.02020-07-13

3.2 → 4.02023-03-06

### Community

Maintainers

![](https://www.gravatar.com/avatar/fbf60dfc9bfd3201bde2fe32ba65d0cef2fc576bd85fd4a84b36170a5c04fd7f?d=identicon)[jnbn](/maintainers/jnbn)

---

Top Contributors

[![jnbn](https://avatars.githubusercontent.com/u/112425?v=4)](https://github.com/jnbn "jnbn (18 commits)")[![Biostate](https://avatars.githubusercontent.com/u/5051330?v=4)](https://github.com/Biostate "Biostate (10 commits)")[![enespolat24](https://avatars.githubusercontent.com/u/21336979?v=4)](https://github.com/enespolat24 "enespolat24 (5 commits)")[![serkansahinn](https://avatars.githubusercontent.com/u/55761865?v=4)](https://github.com/serkansahinn "serkansahinn (4 commits)")[![oceceli](https://avatars.githubusercontent.com/u/24857144?v=4)](https://github.com/oceceli "oceceli (1 commits)")[![omeripek](https://avatars.githubusercontent.com/u/50427567?v=4)](https://github.com/omeripek "omeripek (1 commits)")[![relliv](https://avatars.githubusercontent.com/u/17010054?v=4)](https://github.com/relliv "relliv (1 commits)")[![aysetas](https://avatars.githubusercontent.com/u/41993475?v=4)](https://github.com/aysetas "aysetas (1 commits)")[![taylanunutmaz](https://avatars.githubusercontent.com/u/30219204?v=4)](https://github.com/taylanunutmaz "taylanunutmaz (1 commits)")[![dependabot-preview[bot]](https://avatars.githubusercontent.com/in/2141?v=4)](https://github.com/dependabot-preview[bot] "dependabot-preview[bot] (1 commits)")[![haydar](https://avatars.githubusercontent.com/u/6452942?v=4)](https://github.com/haydar "haydar (1 commits)")[![mnurullaher](https://avatars.githubusercontent.com/u/92983436?v=4)](https://github.com/mnurullaher "mnurullaher (1 commits)")

---

Tags

citycodelaravelpostalstateturkeylaraveldatabasecountrycityTurkishdistrictilceilveritabani

### Embed Badge

![Health badge](/badges/epigra-trgeozones/health.svg)

```
[![Health](https://phpackages.com/badges/epigra-trgeozones/health.svg)](https://phpackages.com/packages/epigra-trgeozones)
```

###  Alternatives

[tomatophp/filament-locations

Database Seeds for Countries / Cities / Areas / Languages / Currancy with ready to use resources for FilamentPHP

2320.8k6](/packages/tomatophp-filament-locations)[nevadskiy/laravel-geonames

Populate your database using the GeoNames service.

2715.1k](/packages/nevadskiy-laravel-geonames)[yurtesen/geonames

Geonames importer and models for Eloquent ORM

311.7k](/packages/yurtesen-geonames)[hpolthof/laravel-translations-db

A database translations implementation for Laravel 5.

525.8k](/packages/hpolthof-laravel-translations-db)[cubettech/lacassa

Cassandra based query builder for laravel.

358.5k](/packages/cubettech-lacassa)[cuneytyuksel/turkey-cities

Turkey Cities and States - Türkiye İl ve İlçeler (PTT)

251.8k](/packages/cuneytyuksel-turkey-cities)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)
