Skip to content

Instantly share code, notes, and snippets.

@hasibkamal
Last active December 24, 2022 02:51
Show Gist options
  • Save hasibkamal/b2f8d664473eaa0acd29e0eff2005df5 to your computer and use it in GitHub Desktop.
Save hasibkamal/b2f8d664473eaa0acd29e0eff2005df5 to your computer and use it in GitHub Desktop.
Bangladesh district lang and lat
SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
DROP TABLE IF EXISTS `bd_district_lat_lng`;
CREATE TABLE `bd_district_lat_lng` (
`id` tinyint(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8 NOT NULL,
`lat` double NOT NULL,
`lng` double NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `bd_district_lat_lng` (`id`, `name`, `lat`, `lng`) VALUES
(1, 'Dhaka', 23.810332, 90.4125181),
(2, 'Faridpur', 23.5423919, 89.6308921),
(3, 'Gazipur', 24.0958171, 90.4125181),
(4, 'Gopalganj', 26.4685472, 84.4433318),
(5, 'Jamalpur', 25.312717, 86.4906091),
(6, 'Kishoreganj', 24.4260457, 90.9820668),
(7, 'Madaripur', 23.2393346, 90.1869644),
(8, 'Manikganj', 23.8616512, 90.0003228),
(9, 'Munshiganj', 23.4980931, 90.4126621),
(10, 'Mymensingh', 24.7434484, 90.3983829),
(11, 'Narayanganj', 23.6226398, 90.4997973),
(12, 'Narsingdi', 24.134378, 90.7860057),
(13, 'Netrokona', 24.8103284, 90.8656415),
(14, 'Rajbari', 23.715134, 89.5874819),
(15, 'Shariatpur', 23.2423214, 90.4347711),
(16, 'Sherpur', 25.0746235, 90.1494904),
(17, 'Tangail', 24.244968, 89.9113052),
(18, 'Bogra', 24.8435589, 89.3701078),
(19, 'Joypurhat', 25.0947349, 89.0944937),
(20, 'Naogaon', 24.9131597, 88.7530952),
(21, 'Natore', 24.410243, 89.0076177),
(22, 'Nawabganj', 28.5405365, 79.6305599),
(23, 'Pabna', 24.0113256, 89.2562239),
(24, 'Rajshahi', 24.3635886, 88.6241351),
(25, 'Sirajgonj', 24.3141115, 89.5699615),
(26, 'Dinajpur', 25.6279123, 88.6331758),
(27, 'Gaibandha', 25.3296928, 89.5429652),
(28, 'Kurigram', 25.8072414, 89.6294746),
(29, 'Lalmonirhat', 25.9923398, 89.2847251),
(30, 'Nilphamari', 25.8482798, 88.9414134),
(31, 'Panchagarh', 26.2708705, 88.5951751),
(32, 'Rangpur', 25.7438916, 89.275227),
(33, 'Thakurgaon', 26.0418392, 88.4282616),
(34, 'Barguna', 22.0952915, 90.1120696),
(35, 'Barisal', 22.7029212, 90.3465971),
(36, 'Bhola', 22.1785315, 90.7101023),
(37, 'Jhalokati', 22.57208, 90.1869644),
(38, 'Patuakhali', 22.2248632, 90.4547503),
(39, 'Pirojpur', 22.5790744, 89.9759264),
(40, 'Bandarban', 21.8311002, 92.3686321),
(41, 'Brahmanbaria', 23.9608181, 91.1115014),
(42, 'Chandpur', 23.2513148, 90.8517846),
(43, 'Chittagong', 22.3475365, 91.8123324),
(44, 'Comilla', 23.46188, 91.186911),
(45, 'CoxBazar', 21.4394636, 92.0077316),
(46, 'Feni', 23.0159132, 91.3975831),
(47, 'Khagrachari', 23.1321751, 91.949021),
(48, 'Lakshmipur', 22.9446744, 90.8281907),
(49, 'Noakhali', 22.8723789, 91.0973184),
(50, 'Rangamati', 22.7324173, 92.2985134),
(51, 'Habiganj', 24.4771236, 91.4506565),
(52, 'Maulvibazar', 24.3095344, 91.7314903),
(53, 'Sunamganj', 25.0714535, 91.3991627),
(54, 'Sylhet', 24.904539, 91.8611011),
(55, 'Bagerhat', 22.6602436, 89.7895478),
(56, 'Chuadanga', 23.6160512, 88.8263006),
(57, 'Jessore', 23.1634014, 89.2181664),
(58, 'Jhenaidah', 23.5449873, 89.1726031),
(59, 'Khulna', 22.845641, 89.5403279),
(60, 'Kushtia', 23.8906995, 89.1099368),
(61, 'Magura', 23.4854655, 89.4198305),
(62, 'Meherpur', 23.8051991, 88.6723578),
(63, 'Narail', 23.1656982, 89.4990219),
(64, 'Satkhira', 22.3154812, 89.1114525);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment