schema.sql

CREATE DATABASE schools_dbs;
USE schools_dbs;

CREATE TABLE schools (
    id SERIAL PRIMARY KEY,
    name VARCHAR(255),
    address VARCHAR(255),
    latitude FLOAT,
    longitude FLOAT
);

insert into schools (name, address, latitude, longitude) values ('Universitas Madura', '16626 Ronald Regan Way', 39.9153943, -7.9165006);
insert into schools (name, address, latitude, longitude) values ('Centre Universitaire de Tebessa', '20 Stoughton Street', 37.888248, 116.537067);
insert into schools (name, address, latitude, longitude) values ('European Carolus Magnus University', '159 Surrey Plaza', 51.7840088, 22.3268117);
insert into schools (name, address, latitude, longitude) values ('Université de Ngaoundéré', '50 4th Court', 41.9227482, -8.5332804);
insert into schools (name, address, latitude, longitude) values ('University of KwaZulu-Natal', '185 Oriole Place', -6.831959, 107.0805202);
insert into schools (name, address, latitude, longitude) values ('Hobe Sound Bible College', '3 Melby Alley', 59.2050499, 17.8873144);
insert into schools (name, address, latitude, longitude) values ('Universitas Islam Sultan Agung', '404 Scofield Hill', -6.8958354, 107.6039392);
insert into schools (name, address, latitude, longitude) values ('Newberry College', '36665 Hagan Drive', -2.4681009, -66.1415263);
insert into schools (name, address, latitude, longitude) values ('Université Paris Sud (Paris XI)', '0 Kings Way', 49.689425, 21.9126813);
insert into schools (name, address, latitude, longitude) values ('Florida Metropolitan University, Fort Lauderdale College', '5726 4th Hill', -9.3483845, -77.1708039);
insert into schools (name, address, latitude, longitude) values ('Gaborone Universal College of Law', '3024 Monica Road', 41.1276055, -8.64789);
insert into schools (name, address, latitude, longitude) values ('Asian University of Science and Technology', '4 Scott Hill', 45.7013243, -73.9284855);
insert into schools (name, address, latitude, longitude) values ('Takestan Islamic Azad University', '4 Melrose Street', 51.718833, 19.1490758);
insert into schools (name, address, latitude, longitude) values ('Waterford Institute Of Technology', '61 Old Shore Street', 41.276688, 80.238959);
insert into schools (name, address, latitude, longitude) values ('Hollins University', '81308 Hazelcrest Pass', 42.2971095, -71.4720787);
insert into schools (name, address, latitude, longitude) values ('Ecole Supérieure d''Agriculture de Purpan', '7 Butternut Park', 35.8504632, 140.3548218);
insert into schools (name, address, latitude, longitude) values ('Montana Tech', '5921 Weeping Birch Lane', 55.7, 37.58333);
insert into schools (name, address, latitude, longitude) values ('Tilka Manjhi Bhagalpur University', '130 Kim Park', 27.622768, 113.854556);
insert into schools (name, address, latitude, longitude) values ('Moody Bible Institute', '64 Fisk Crossing', -6.971678, 107.5845418);
insert into schools (name, address, latitude, longitude) values ('Islamic Azad University, Sowmesara', '015 Scofield Road', 49.4663065, 19.1517652);
insert into schools (name, address, latitude, longitude) values ('Pittsburg State University', '06 Cherokee Hill', 31.018498, 109.463987);
insert into schools (name, address, latitude, longitude) values ('Sindh Madressatul Islam University', '54994 Rockefeller Plaza', 20.5511364, -103.461601);
insert into schools (name, address, latitude, longitude) values ('Universidad del Valle de Toluca', '0 Gina Court', 14.7342524, 121.0702642);
insert into schools (name, address, latitude, longitude) values ('Rocky Mountain College', '7 Bellgrove Terrace', 24.724853, 118.489851);
insert into schools (name, address, latitude, longitude) values ('Altai State Technical University', '02709 Harper Circle', 16.7733926, 101.2451095);
insert into schools (name, address, latitude, longitude) values ('Universidad Nueva San Salvador', '0863 Mesta Pass', 53.1310185, -6.7449927);
insert into schools (name, address, latitude, longitude) values ('Shaoguan University', '7406 Esker Junction', 4.9224556, 13.2923232);
insert into schools (name, address, latitude, longitude) values ('University of Wah', '760 Red Cloud Parkway', 38.03, -87.58);
insert into schools (name, address, latitude, longitude) values ('Université de Caen Basse Normandie', '575 Golf View Drive', 15.4575357, -92.281427);
insert into schools (name, address, latitude, longitude) values ('Saybrook Institute', '8539 Butterfield Drive', 49.9406828, 19.7770123);
insert into schools (name, address, latitude, longitude) values ('Akwa Ibom State University of Technology', '1697 Bashford Road', 11.6786404, 124.4087296);
insert into schools (name, address, latitude, longitude) values ('CCS Haryana Agricultural University', '6789 Melody Place', -11.1227218, -77.6105679);
insert into schools (name, address, latitude, longitude) values ('Cross River University of Science and Technology', '68 Autumn Leaf Drive', 41.9483514, 45.8147918);
insert into schools (name, address, latitude, longitude) values ('Ferris University', '44 Mockingbird Avenue', -21.2922593, -50.3407923);
insert into schools (name, address, latitude, longitude) values ('Technological Education Institute of Kozani', '910 Arrowood Drive', 33.3437146, 130.6838866);
insert into schools (name, address, latitude, longitude) values ('Korea National Open University', '60 Miller Road', 49.9912948, 17.960745);
insert into schools (name, address, latitude, longitude) values ('Universidad del Pacífico', '256 Autumn Leaf Hill', 48.7520903, 16.3813139);
insert into schools (name, address, latitude, longitude) values ('Burlington College', '4 Corben Alley', -9.7934897, 124.4319309);
insert into schools (name, address, latitude, longitude) values ('Roskilde University', '3149 Milwaukee Circle', 31.5259995, 49.8905718);
insert into schools (name, address, latitude, longitude) values ('University of Mississippi Medical Center', '2 Hanover Terrace', 52.4818411, 19.2910855);
insert into schools (name, address, latitude, longitude) values ('Atish Dipankar University', '8 Spaight Road', 23.301616, 115.660142);
insert into schools (name, address, latitude, longitude) values ('Midway College', '2417 Mifflin Avenue', -25.3168473, 45.4863093);
insert into schools (name, address, latitude, longitude) values ('University of Colombo', '142 Rowland Plaza', 36.545015, 104.138586);
insert into schools (name, address, latitude, longitude) values ('Nelson Mandela Metropolitan University', '128 Lukken Hill', 22.0462137, 111.012675);
insert into schools (name, address, latitude, longitude) values ('Universität Osnabrück', '77249 Morning Terrace', -18.1661375, -47.944531);
insert into schools (name, address, latitude, longitude) values ('West Liberty State College', '17930 Manley Terrace', 31.85074, 117.198958);
insert into schools (name, address, latitude, longitude) values ('New England Conservatory of Music', '14626 Ridge Oak Circle', -12.1695811, 44.40047);
insert into schools (name, address, latitude, longitude) values ('Seinan Gakuin University', '84 Melrose Drive', -7.4471282, 109.2179589);
insert into schools (name, address, latitude, longitude) values ('Andong National University', '06 Hoffman Road', 40.7325414, 22.6920826);
insert into schools (name, address, latitude, longitude) values ('Hanyang University', '9017 Bunting Plaza', 26.647932, 107.917448);
insert into schools (name, address, latitude, longitude) values ('Western Mindanao State University', '51 Maple Wood Parkway', -27.4697707, 153.0251235);
insert into schools (name, address, latitude, longitude) values ('Universitas 17 Agustus 1945 Semarang', '10 Washington Point', 54.5997042, 18.4823439);
insert into schools (name, address, latitude, longitude) values ('Simpson College Iowa', '71889 Katie Avenue', 8.0036924, -81.5596427);
insert into schools (name, address, latitude, longitude) values ('Kaunas Medical Academy', '34003 Meadow Ridge Trail', 28.122424, 109.746848);
insert into schools (name, address, latitude, longitude) values ('Kyungpook National University', '2 Ludington Parkway', 16.424148, 120.5983132);
insert into schools (name, address, latitude, longitude) values ('Escola Superior de Artes e Design', '1537 Transport Alley', 43.6953508, 7.2559678);
insert into schools (name, address, latitude, longitude) values ('Firat (Euphrates) University', '7212 Marquette Terrace', 22.916134, 114.1002135);
insert into schools (name, address, latitude, longitude) values ('Universidad Veracruzana', '5685 Crowley Pass', 18.1254083, -77.1470783);
insert into schools (name, address, latitude, longitude) values ('City University Programs in Bulgaria ', '5 Troy Plaza', -6.5114699, 106.8325872);
insert into schools (name, address, latitude, longitude) values ('Western Delta University', '0 Hagan Street', 44.4140877, 43.8736157);
insert into schools (name, address, latitude, longitude) values ('Tabriz Islamic Art University', '5 Hoepker Lane', 5.976337, 121.2234268);
insert into schools (name, address, latitude, longitude) values ('Guangxi Traditional Chinese Medical University', '65 Hintze Parkway', 34.613586, 118.367215);
insert into schools (name, address, latitude, longitude) values ('National University of Arts', '65 Towne Plaza', 45.4136084, -66.0783767);
insert into schools (name, address, latitude, longitude) values ('The Chicago schools of Professional Psychology', '21 Kropf Lane', 12.3856506, 125.3027214);
insert into schools (name, address, latitude, longitude) values ('Spring Arbor College', '6223 Blaine Way', 23.105394, 113.874335);
insert into schools (name, address, latitude, longitude) values ('Arkansas Tech University', '066 Meadow Vale Pass', -7.1691828, 108.0050384);
insert into schools (name, address, latitude, longitude) values ('University of Wah', '9 Kennedy Trail', -23.144255, -64.325272);
insert into schools (name, address, latitude, longitude) values ('Punjab Technical University', '28 Truax Park', 10.1197024, -69.0393069);
insert into schools (name, address, latitude, longitude) values ('Hebei University of Economics and Trade', '3484 Harper Point', 52.804249, 6.186692);
insert into schools (name, address, latitude, longitude) values ('Shaheed Benazir Bhutto Women University ', '38 Mandrake Street', 54.0691945, 45.0923988);
insert into schools (name, address, latitude, longitude) values ('schools of Management Fribourg', '424 Armistice Court', 53.8298337, 20.275033);
insert into schools (name, address, latitude, longitude) values ('Universidade Estadual do Norte Fluminense', '65304 South Court', 49.6605765, 14.4266438);
insert into schools (name, address, latitude, longitude) values ('Fachhochschule Biberach, Hochschule für Bauwesen und Wirtschaft', '4 Mitchell Avenue', 31.306136, 120.6240412);
insert into schools (name, address, latitude, longitude) values ('University of Pretoria', '724 Monument Crossing', 30.2638032, 102.8054753);
insert into schools (name, address, latitude, longitude) values ('Youngstown State University', '39 Alpine Parkway', 55.0007073, 36.4284209);
insert into schools (name, address, latitude, longitude) values ('Iqra University', '3399 Bonner Plaza', 10.4145738, 8.5721016);
insert into schools (name, address, latitude, longitude) values ('Université Panthéon-Sorbonne (Paris I)', '3 Clemons Plaza', 49.8691711, 22.9586235);
insert into schools (name, address, latitude, longitude) values ('Universitas Proklamasi 45', '8 8th Parkway', 30.242572, 120.053059);
insert into schools (name, address, latitude, longitude) values ('Instituts Supérieurs de Formation des Maîtres', '16030 Schmedeman Road', 7.591829, 124.0735387);
insert into schools (name, address, latitude, longitude) values ('Gurukul University', '4 Dapin Park', 33.8849101, -117.9941812);
insert into schools (name, address, latitude, longitude) values ('Universidad Técnica Estatal de Quevedo', '3973 Pierstorff Street', 36.8466981, -76.2900032);
insert into schools (name, address, latitude, longitude) values ('Norwegian schools of Economics and Business Administration', '22 Leroy Place', 15.0541658, -91.229784);
insert into schools (name, address, latitude, longitude) values ('Universidad Nacional de La Rioja', '92208 Pleasure Circle', 43.8006906, 5.8147664);
insert into schools (name, address, latitude, longitude) values ('Hungarian Academy of Craft and Design', '57 High Crossing Lane', 1.7131812, 33.6063855);
insert into schools (name, address, latitude, longitude) values ('York University', '5442 Ridgeway Hill', -3.2581112, -79.9553924);
insert into schools (name, address, latitude, longitude) values ('Universidad de Almería', '4 Oak Road', 49.689224, 6.0628765);
insert into schools (name, address, latitude, longitude) values ('Christ University', '71890 Buena Vista Plaza', -5.3860856, -79.4703885);
insert into schools (name, address, latitude, longitude) values ('Teikyo Heisei University', '70 Truax Street', -27.2369945, 28.8476254);
insert into schools (name, address, latitude, longitude) values ('Université Abou Bekr Belkaid, Tlemcen', '24321 Alpine Trail', 32.8872867, 130.8841776);
insert into schools (name, address, latitude, longitude) values ('Universidad Lasallista Benavente', '2 Lien Lane', 19.0561748, -98.2151462);
insert into schools (name, address, latitude, longitude) values ('SASTRA Deemed University', '77242 Thierer Pass', 1.2481932, 35.1103736);
insert into schools (name, address, latitude, longitude) values ('1 December University of Alba Iulia', '3 Pankratz Park', 55.9309486, -3.1859102);
insert into schools (name, address, latitude, longitude) values ('Kanda University of International Studies', '810 Lighthouse Bay Street', -2.576499, 112.542);
insert into schools (name, address, latitude, longitude) values ('Martin University', '01742 Birchwood Lane', 12.9815608, 7.6222665);
insert into schools (name, address, latitude, longitude) values ('St. Louis College of Pharmacy', '7714 Clyde Gallagher Street', 48.3940341, 28.4034797);
insert into schools (name, address, latitude, longitude) values ('Saratov State Agrarian University', '623 Prentice Point', 59.8419074, 17.5964867);
insert into schools (name, address, latitude, longitude) values ('Universität Kassel', '43993 Mosinee Avenue', 56.8134441, 13.9368114);
insert into schools (name, address, latitude, longitude) values ('Northeast Forest University', '80357 Mandrake Alley', 44.2990355, 15.8462167);
insert into schools (name, address, latitude, longitude) values ('Cag University', '1 Warbler Parkway', 2.7239834, 101.9476452);
insert into schools (name, address, latitude, longitude) values ('Universidad del Cauca', '76 Bobwhite Trail', 37.280716, 140.3354054);