Sql for Turkey Cities (lat//long information included)

turkey-cities.sql

/* Sql for Turkey Cities (lat long information included) */
/* https://gist.github.com/serkanince/ */


CREATE TABLE sehirler (
    id INT NOT NULL,
    adi VARCHAR(50) NOT NULL,
    lat DECIMAL(10, 4) NOT NULL,
    long DECIMAL(10, 4) NOT NULL,
    PRIMARY KEY (id)
);

INSERT INTO sehirler (id, adi, lat, long) VALUES
(1, 'Adana', 37.0000, 35.3213),
(2, 'Adıyaman', 37.7648, 38.2763),
(3, 'Afyonkarahisar', 38.7507, 30.5566),
(4, 'Ağrı', 39.7217, 43.0567),
(5, 'Amasya', 40.6530, 35.8337),
(6, 'Ankara', 39.9208, 32.8541),
(7, 'Antalya', 36.8841, 30.7056),
(8, 'Artvin', 41.1828, 41.8183),
(9, 'Aydın', 37.8560, 27.8416),
(10, 'Balıkesir', 39.6484, 27.8826),
(11, 'Bilecik', 40.1500, 30.1419),
(12, 'Bingöl', 38.8820, 40.4988),
(13, 'Bitlis', 38.3938, 42.1234),
(14, 'Bolu', 40.7392, 31.6116),
(15, 'Burdur', 37.4613, 30.0668),
(16, 'Bursa', 40.1917, 29.0611),
(17, 'Çanakkale', 40.1553, 26.4142),
(18, 'Çankırı', 40.6013, 33.6134),
(19, 'Çorum', 40.5506, 34.9556),
(20, 'Denizli', 37.7765, 29.0864),
(21, 'Diyarbakır', 37.9144, 40.2306),
(22, 'Edirne', 41.6772, 26.5550),
(23, 'Elazığ', 38.6810, 39.2264),
(24, 'Erzincan', 39.7500, 39.5000),
(25, 'Erzurum', 39.9000, 41.2700),
(26, 'Eskişehir', 39.7667, 30.5250),
(27, 'Gaziantep', 37.0662, 37.3833),
(28, 'Giresun', 40.9128, 38.3895),
(29, 'Gümüşhane', 40.4603, 39.4816),
(30, 'Hakkari', 37.5833, 43.7333),
(31, 'Hatay', 36.4018, 36.3498),
(32, 'Isparta', 37.7648, 30.5563),
(33, 'Mersin', 36.8000, 34.6333),
(34, 'İstanbul', 41.0053, 28.9770),
(35, 'İzmir', 38.4189, 27.1287),
(36, 'Kars', 40.6167, 43.1000),
(37, 'Kastamonu', 41.3887, 33.7827),
(38, 'Kayseri', 38.7312, 35.4787),
(39, 'Kırklareli', 41.7333, 27.2167),
(40, 'Kırşehir', 39.1425, 34.1709),
(41, 'Kocaeli', 40.8533, 29.8815),
(42, 'Konya', 37.8667, 32.4833),
(43, 'Kütahya', 39.4167, 29.9833),
(44, 'Malatya', 38.3552, 38.3095),
(45, 'Manisa', 38.6191, 27.4288),
(46, 'Kahramanmaraş', 37.5833, 36.9333),
(47, 'Mardin', 37.3122, 40.7350),
(48, 'Muğla', 37.2153, 28.3636),
(49, 'Muş', 38.7433, 41.5064),
(50, 'Nevşehir', 38.6244, 34.7237),
(51, 'Niğde', 37.9667, 34.6833),
(52, 'Ordu', 40.9839, 37.8764),
(53, 'Rize', 41.0201, 40.5234),
(54, 'Sakarya', 40.7667, 30.4000),
(55, 'Samsun', 41.2928, 36.3313),
(56, 'Siirt', 37.9333, 41.9500),
(57, 'Sinop', 42.0231, 35.1531),
(58, 'Sivas', 39.7477, 37.0179),
(59, 'Tekirdağ', 40.9833, 27.5167),
(60, 'Tokat', 40.3167, 36.5500),
(61, 'Trabzon', 40.9819, 39.7191),
(62, 'Tunceli', 39.3074, 39.4388),
(63, 'Şanlıurfa', 37.1671, 38.7939),
(64, 'Uşak', 38.6823, 29.4082),
(65, 'Van', 38.4912, 43.4166),
(66, 'Yozgat', 39.8200, 34.8048),
(67, 'Zonguldak', 41.4564, 31.7987),
(68, 'Aksaray', 38.3687, 34.0370),
(69, 'Bayburt', 40.2552, 40.2249),
(70, 'Karaman', 37.1759, 33.2287),
(71, 'Kırıkkale', 39.8468, 33.5153),
(72, 'Batman', 37.8550, 41.1350),
(73, 'Şırnak', 37.5164, 42.4614),
(74, 'Bartın', 41.6358, 32.3375),
(75, 'Ardahan', 41.1102, 42.7022),
(76, 'Iğdır', 39.9167, 44.0333),
(77, 'Yalova', 40.6500, 29.2667),
(78, 'Karabük', 41.2045, 32.6249),
(79, 'Kilis', 36.7184, 37.1212),
(80, 'Osmaniye', 37.2130, 36.1763),
(81, 'Düzce', 40.8438, 31.1565);

if you want a add a ef migration for dotnet project, you can use this

using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace YourNamespace.Migrations
{
    public partial class VeritabaninaSehirlerEkle : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.Sql(@"
                INSERT INTO sehirler (id, adi, lat, long) VALUES
                (1, 'Adana', 37.0000, 35.3213),
                (2, 'Adıyaman', 37.7648, 38.2763),
                (3, 'Afyonkarahisar', 38.7507, 30.5566),
                (4, 'Ağrı', 39.7217, 43.0567),
                (5, 'Amasya', 40.6530, 35.8337),
                (6, 'Ankara', 39.9208, 32.8541),
                (7, 'Antalya', 36.8841, 30.7056),
                (8, 'Artvin', 41.1828, 41.8183),
                (9, 'Aydın', 37.8560, 27.8416),
                (10, 'Balıkesir', 39.6484, 27.8826),
                (11, 'Bilecik', 40.1500, 30.1419),
                (12, 'Bingöl', 38.8820, 40.4988),
                (13, 'Bitlis', 38.3938, 42.1234),
                (14, 'Bolu', 40.7392, 31.6116),
                (15, 'Burdur', 37.4613, 30.0668),
                (16, 'Bursa', 40.1917, 29.0611),
                (17, 'Çanakkale', 40.1553, 26.4142),
                (18, 'Çankırı', 40.6013, 33.6134),
                (19, 'Çorum', 40.5506, 34.9556),
                (20, 'Denizli', 37.7765, 29.0864),
                (21, 'Diyarbakır', 37.9144, 40.2306),
                (22, 'Edirne', 41.6772, 26.5550),
                (23, 'Elazığ', 38.6810, 39.2264),
                (24, 'Erzincan', 39.7500, 39.5000),
                (25, 'Erzurum', 39.9000, 41.2700),
                (26, 'Eskişehir', 39.7667, 30.5250),
                (27, 'Gaziantep', 37.0662, 37.3833),
                (28, 'Giresun', 40.9128, 38.3895),
                (29, 'Gümüşhane', 40.4603, 39.4816),
                (30, 'Hakkari', 37.5833, 43.7333),
                (31, 'Hatay', 36.4018, 36.3498),
                (32, 'Isparta', 37.7648, 30.5563),
                (33, 'Mersin', 36.8000, 34.6333),
                (34, 'İstanbul', 41.0053, 28.9770),
                (35, 'İzmir', 38.4189, 27.1287),
                (36, 'Kars', 40.6167, 43.1000),
                (37, 'Kastamonu', 41.3887, 33.7827),
                (38, 'Kayseri', 38.7312, 35.4787),
                (39, 'Kırklareli', 41.7333, 27.2167),
                (40, 'Kırşehir', 39.1425, 34.1709),
                (41, 'Kocaeli', 40.8533, 29.8815),
                (42, 'Konya', 37.8667, 32.4833),
                (43, 'Kütahya', 39.4167, 29.9833),
                (44, 'Malatya', 38.3552, 38.3095),
                (45, 'Manisa', 38.6191, 27.4288),
                (46, 'Kahramanmaraş', 37.5833, 36.9333),
                (47, 'Mardin', 37.3122, 40.7350),
                (48, 'Muğla', 37.2153, 28.3636),
                (49, 'Muş', 38.7433, 41.5064),
                (50, 'Nevşehir', 38.6244, 34.7237),
                (51, 'Niğde', 37.9667, 34.6833),
                (52, 'Ordu', 40.9839, 37.8764),
                (53, 'Rize', 41.0201, 40.5234),
                (54, 'Sakarya', 40.7667, 30.4000),
                (55, 'Samsun', 41.2928, 36.3313),
                (56, 'Siirt', 37.9333, 41.9500),
                (57, 'Sinop', 42.0231, 35.1531),
                (58, 'Sivas', 39.7477, 37.0179),
                (59, 'Tekirdağ', 40.9833, 27.5167),
                (60, 'Tokat', 40.3167, 36.5500),
                (61, 'Trabzon', 40.9819, 39.7191),
                (62, 'Tunceli', 39.3074, 39.4388),
                (63, 'Şanlıurfa', 37.1671, 38.7939),
                (64, 'Uşak', 38.6823, 29.4082),
                (65, 'Van', 38.4912, 43.4166),
                (66, 'Yozgat', 39.8200, 34.8048),
                (67, 'Zonguldak', 41.4564, 31.7987),
                (68, 'Aksaray', 38.3687, 34.0370),
                (69, 'Bayburt', 40.2552, 40.2249),
                (70, 'Karaman', 37.1759, 33.2287),
                (71, 'Kırıkkale', 39.8468, 33.5153),
                (72, 'Batman', 37.8550, 41.1350),
                (73, 'Şırnak', 37.5164, 42.4614),
                (74, 'Bartın', 41.6358, 32.3375),
                (75, 'Ardahan', 41.1102, 42.7022),
                (76, 'Iğdır', 39.9167, 44.0333),
                (77, 'Yalova', 40.6500, 29.2667),
                (78, 'Karabük', 41.2045, 32.6249),
                (79, 'Kilis', 36.7184, 37.1212),
                (80, 'Osmaniye', 37.2130, 36.1763),
                (81, 'Düzce', 40.8438, 31.1565);
            ");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.Sql(@"
                DELETE FROM sehirler;
            ");
        }
    }
}