{"id":178,"date":"2008-05-26T04:41:00","date_gmt":"2008-05-26T04:41:00","guid":{"rendered":"http:\/\/blog.trungson.com\/?p=178"},"modified":"2008-05-26T04:41:00","modified_gmt":"2008-05-26T04:41:00","slug":"geographical-city-mysql-database","status":"publish","type":"post","link":"http:\/\/blog.trungson.com\/?p=178","title":{"rendered":"Geographical city MySQL database"},"content":{"rendered":"<p><textarea name=\"code\" class=\"sql\"><\/p>\n<p>CREATE TABLE `geo_city` (<br \/>\n  `CityId` int(10) unsigned NOT NULL default &#8216;0&#8217;,<br \/>\n  `CountryId` int(10) unsigned NOT NULL default &#8216;0&#8217;,<br \/>\n  `RegionId` int(10) unsigned NOT NULL default &#8216;0&#8217;,<br \/>\n  `City` varchar(100) NOT NULL default &#8221;,<br \/>\n  `Latitude` float NOT NULL default &#8216;0&#8217;,<br \/>\n  `Longitude` float NOT NULL default &#8216;0&#8217;,<br \/>\n  `TimeZone` varchar(6) NOT NULL default &#8221;,<br \/>\n  `DmaId` int(10) unsigned NOT NULL default &#8216;0&#8217;,<br \/>\n  `Code` varchar(5) NOT NULL default &#8221;,<br \/>\n  PRIMARY KEY  (`CityId`),<br \/>\n  KEY `CountryId` (`CountryId`),<br \/>\n  KEY `RegionId` (`RegionId`),<br \/>\n  KEY `City` (`City`)<br \/>\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT=&#8217;Cities from GeoBytes&#8217;;<\/p>\n<p>&#8212;<br \/>\n&#8212; Dumping data for table `geo_city`<br \/>\n&#8212;<\/p>\n<p>INSERT INTO `geo_city` VALUES(27239, 254, 124, &#8216;Gray Mountain&#8217;, 35.8756, -111.412, &#8216;-07:00&#8217;, 753, &#8216;GMOU&#8217;);<br \/>\nINSERT INTO `geo_city` VALUES(35786, 254, 148, &#8216;Rapelje&#8217;, 45.9932, -109.288, &#8216;-07:00&#8217;, 756, &#8216;RAPE&#8217;);<br \/>\nINSERT INTO `geo_city` VALUES(4354, 122, 2329, &#8216;Tamana&#8217;, 32.917, 130.567, &#8216;+09:00&#8217;, 0, &#8216;TAMA&#8217;);<br \/>\nINSERT INTO `geo_city` VALUES(13343, 254, 144, &#8216;Croswell&#8217;, 43.2651, -82.6467, &#8216;-05:00&#8217;, 505, &#8216;CROS&#8217;);<br \/>\nINSERT INTO `geo_city` VALUES(39829, 254, 146, &#8216;Vardaman&#8217;, 33.9472, -89.1968, &#8216;-06:00&#8217;, 673, &#8216;VARD&#8217;);<br \/>\nINSERT INTO `geo_city` VALUES(39933, 254, 144, &#8216;Vicksburg&#8217;, 42.1149, -85.4789, &#8216;-05:00&#8217;, 563, &#8216;VICK&#8217;);<br \/>\nINSERT INTO `geo_city` VALUES(21609, 254, 137, &#8216;Bryant&#8217;, 41.9723, -90.3407, &#8216;-06:00&#8217;, 682, &#8216;BRYA&#8217;);<br \/>\nINSERT INTO `geo_city` VALUES(29400, 254, 134, &#8216;Kellogg&#8217;, 47.7187, -116.088, &#8216;-08:00&#8217;, 881, &#8216;KELL&#8217;);<br \/>\nINSERT INTO `geo_city` VALUES(38484, 254, 152, &#8216;Stockton&#8217;, 40.4365, -74.9753, &#8216;-05:00&#8217;, 501, &#8216;STOC&#8217;);<br \/>\nINSERT INTO `geo_city` VALUES(7528, 254, 127, &#8216;Akron&#8217;, 40.1266, -103.261, &#8216;-07:00&#8217;, 751, &#8216;AKRO&#8217;);<\/p>\n<p><\/textarea><br \/>\nFull File: <a href=\"http:\/\/blog.trungson.com\/uploads\/geocities.txt\">uploads\/geocities.txt<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>CREATE TABLE `geo_city` ( `CityId` int(10) unsigned NOT NULL default &#8216;0&#8217;, `CountryId` int(10) unsigned NOT NULL default &#8216;0&#8217;, `RegionId` int(10) unsigned NOT NULL default &#8216;0&#8217;, `City` varchar(100) NOT NULL default &#8221;, `Latitude` float NOT NULL default &#8216;0&#8217;, `Longitude` float NOT NULL default &#8216;0&#8217;, `TimeZone` varchar(6) NOT NULL default &#8221;, `DmaId` int(10) unsigned NOT NULL default [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts\/178"}],"collection":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=178"}],"version-history":[{"count":0,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}