Mehmet Deniz denizme
denizme
/ Türkiye İl İlçe Listesi sql
Created
May 30, 2018 13:48
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create database IlilceDB; | |
| Go | |
| USE IlilceDB | |
| create table Iller( | |
| IlID int not null primary key identity(1,1), | |
| Il nvarchar(100) | |
| ) | |
| create table Ilceler( |
denizme
/ Türkiye İL İLÇE Listesi json
Created
May 30, 2018 13:45
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "cityId": 1, | |
| "plateCode": 1, | |
| "cityName": "Adana", | |
| "towns": [ | |
| { | |
| "townId": 1, | |
| "townName": "Aladağ" | |
| }, |
denizme
/ Türkiye İlçe Listesi Json
Created
May 30, 2018 13:33
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "townId": 1, | |
| "townName": "Aladağ" | |
| }, | |
| { | |
| "townId": 2, | |
| "townName": "Ceyhan" | |
| }, | |
| { |
denizme
/ Türkiye İlçe Listesi Json
Last active
May 30, 2018 13:30
Türkiye ilçe listesi, plaka kodu ile birlikte, json formatında
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "townId": 1, | |
| "plateCoe": 1, | |
| "townName": "Aladağ" | |
| }, | |
| { | |
| "townId": 2, | |
| "plateCoe": 1, | |
| "townName": "Ceyhan" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "cityId": 1, | |
| "cityName": "Adana", | |
| "plateCode": 1 | |
| }, | |
| { | |
| "cityId": 2, | |
| "cityName": "Adıyaman", | |
| "plateCode": 2 |