{"id":15655,"date":"2022-10-20T06:00:00","date_gmt":"2022-10-19T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=15655"},"modified":"2022-09-28T09:23:32","modified_gmt":"2022-09-28T00:23:32","slug":"__trashed","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=15655","title":{"rendered":"eStat\u304b\u3089\u56fd\u52e2\u8abf\u67fb\u306e\u5c0f\u5730\u57df\u306e\u5883\u754c\u30c7\u30fc\u30bf\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057SQL Server\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b"},"content":{"rendered":"\n<p>\u3000\u56fd\u52e2\u8abf\u67fb\u306e\u7d50\u679c\u304ceStat\u306b\u63b2\u8f09\u3055\u308c\u59cb\u3081\u3066\u3044\u308b\uff0e\u4eca\u56de\u306f<a href=\"https:\/\/www.e-stat.go.jp\/gis\/statmap-search?type=2\" target=\"_blank\" rel=\"noopener\">\u5c0f\u5730\u57df\u306e\u5883\u754c\u30c7\u30fc\u30bf<\/a>\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\uff0cSQL Server\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u307e\u3067\u306e\u8a18\u9332\u3092\u8a18\u3059\uff0e<\/p>\n<p><!--more--><\/p>\n<h2>\u5c0f\u5730\u57df\u306e\u5883\u754c\u30c7\u30fc\u30bf\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b<\/h2>\n<p>\u3000\u524d\u534a\u306f\u56f3\u89e3\u3092\u4e2d\u5fc3\u306b\u89e3\u8aac\u3059\u308b\uff0e<\/p>\n<h3>eStat\u30c8\u30c3\u30d7\u30da\u30fc\u30b8\u304b\u3089\u5730\u56f3<\/h3>\n<figure id=\"attachment_15657\" aria-describedby=\"caption-attachment-15657\" style=\"width: 682px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/60.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15657\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/60.png\" alt=\"eStat\u30c8\u30c3\u30d7\u30da\u30fc\u30b8\u304b\u3089\u5730\u56f3\" width=\"682\" height=\"338\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/60.png 682w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/60-300x149.png 300w\" sizes=\"auto, (max-width: 682px) 100vw, 682px\" \/><\/a><figcaption id=\"caption-attachment-15657\" class=\"wp-caption-text\">eStat\u30c8\u30c3\u30d7\u30da\u30fc\u30b8\u304b\u3089\u5730\u56f3<\/figcaption><\/figure>\n<h3>\u5883\u754c\u30c7\u30fc\u30bf\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/h3>\n<figure id=\"attachment_15658\" aria-describedby=\"caption-attachment-15658\" style=\"width: 708px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/61.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15658\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/61.png\" alt=\"\u5883\u754c\u30c7\u30fc\u30bf\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\" width=\"708\" height=\"426\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/61.png 708w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/61-300x181.png 300w\" sizes=\"auto, (max-width: 708px) 100vw, 708px\" \/><\/a><figcaption id=\"caption-attachment-15658\" class=\"wp-caption-text\">\u5883\u754c\u30c7\u30fc\u30bf\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/figcaption><\/figure>\n<h3>\u5c0f\u5730\u57df<\/h3>\n<figure id=\"attachment_15659\" aria-describedby=\"caption-attachment-15659\" style=\"width: 653px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/62.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15659\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/62.png\" alt=\"\u5c0f\u5730\u57df\" width=\"653\" height=\"319\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/62.png 653w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/62-300x147.png 300w\" sizes=\"auto, (max-width: 653px) 100vw, 653px\" \/><\/a><figcaption id=\"caption-attachment-15659\" class=\"wp-caption-text\">\u5c0f\u5730\u57df<\/figcaption><\/figure>\n<h3>\u56fd\u52e2\u8abf\u67fb<\/h3>\n<figure id=\"attachment_15660\" aria-describedby=\"caption-attachment-15660\" style=\"width: 654px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/63.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15660\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/63.png\" alt=\"\u56fd\u52e2\u8abf\u67fb\" width=\"654\" height=\"354\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/63.png 654w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/63-300x162.png 300w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><\/a><figcaption id=\"caption-attachment-15660\" class=\"wp-caption-text\">\u56fd\u52e2\u8abf\u67fb<\/figcaption><\/figure>\n<h3>\u5c0f\u5730\u57df\uff08\u753a\u4e01\u30fb\u5b57\u7b49\u5225\uff09(JGD2000)<\/h3>\n<figure id=\"attachment_15661\" aria-describedby=\"caption-attachment-15661\" style=\"width: 657px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/64.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15661\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/64.png\" alt=\"\u5c0f\u5730\u57df\uff08\u753a\u4e01\u30fb\u5b57\u7b49\u5225\uff09(JGD2000)\" width=\"657\" height=\"415\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/64.png 657w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/64-300x189.png 300w\" sizes=\"auto, (max-width: 657px) 100vw, 657px\" \/><\/a><figcaption id=\"caption-attachment-15661\" class=\"wp-caption-text\">\u5c0f\u5730\u57df\uff08\u753a\u4e01\u30fb\u5b57\u7b49\u5225\uff09(JGD2000)<\/figcaption><\/figure>\n<h3>\u30c7\u30fc\u30bf\u5f62\u5f0f\u3092\u9078\u3076<\/h3>\n<p>\u3000\u4eca\u56de\u306f\u300c\u4e16\u754c\u6e2c\u5730\u7cfb\u5e73\u9762\u76f4\u89d2\u5ea7\u6a19\u7cfb\u30fbShapefile\u300d\u3092\u9078\u3093\u3060\u304c\uff0c\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3067\u304d\u306a\u3044\u30d5\u30a1\u30a4\u30eb\u304c3\u3064\u307b\u3069\u5b58\u5728\u3059\u308b\u3053\u3068\u304c\u5f8c\u306b\u5224\u660e\u3057\u305f\uff0e\u8aad\u8005\u306b\u306f\u300c\u4e16\u754c\u6e2c\u5730\u7cfb\u7def\u5ea6\u7d4c\u5ea6\u30fbShapefile\u300d\u3092\u9078\u3076\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_15662\" aria-describedby=\"caption-attachment-15662\" style=\"width: 656px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/65.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15662\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/65.png\" alt=\"\u30c7\u30fc\u30bf\u5f62\u5f0f\u3092\u9078\u3076\" width=\"656\" height=\"354\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/65.png 656w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/65-300x162.png 300w\" sizes=\"auto, (max-width: 656px) 100vw, 656px\" \/><\/a><figcaption id=\"caption-attachment-15662\" class=\"wp-caption-text\">\u30c7\u30fc\u30bf\u5f62\u5f0f\u3092\u9078\u3076<\/figcaption><\/figure>\n<h3>\u90fd\u9053\u5e9c\u770c\u3092\u9078\u3076<\/h3>\n<figure id=\"attachment_15663\" aria-describedby=\"caption-attachment-15663\" style=\"width: 656px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/66.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15663\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/66.png\" alt=\"\u90fd\u9053\u5e9c\u770c\u3092\u9078\u3076\" width=\"656\" height=\"818\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/66.png 656w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/66-241x300.png 241w\" sizes=\"auto, (max-width: 656px) 100vw, 656px\" \/><\/a><figcaption id=\"caption-attachment-15663\" class=\"wp-caption-text\">\u90fd\u9053\u5e9c\u770c\u3092\u9078\u3076<\/figcaption><\/figure>\n<h3>\u90fd\u9053\u5e9c\u770c\u5168\u57df\u3092\u9078\u3076<\/h3>\n<p>\u3000\u6700\u3082\u4e0a\u306b\u3042\u308b\u5317\u6d77\u9053\u5168\u57df\u3092\u9078\u3076\uff0e\u3053\u306e\u4f5c\u696d\u3092\u3059\u3079\u3066\u306e\u90fd\u9053\u5e9c\u770c\u306b\u3064\u3044\u3066\u7e70\u308a\u8fd4\u3059\uff0e<\/p>\n<figure id=\"attachment_15664\" aria-describedby=\"caption-attachment-15664\" style=\"width: 655px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/67.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15664\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/67.png\" alt=\"\u90fd\u9053\u5e9c\u770c\u5168\u57df\u3092\u9078\u3076\" width=\"655\" height=\"944\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/67.png 655w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/67-208x300.png 208w\" sizes=\"auto, (max-width: 655px) 100vw, 655px\" \/><\/a><figcaption id=\"caption-attachment-15664\" class=\"wp-caption-text\">\u90fd\u9053\u5e9c\u770c\u5168\u57df\u3092\u9078\u3076<\/figcaption><\/figure>\n<h2>Shape2SQL\u3067SQL Server\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b<\/h2>\n<p>\u3000\u4ee5\u524d<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=13279\" target=\"_blank\" rel=\"noopener\">\u6cb3\u5ddd\u306e\u30c7\u30fc\u30bf\u3092\u30de\u30fc\u30b8<\/a>\u3057\u305f\u969b\u306b\u5c5e\u6027\u30c6\u30fc\u30d6\u30eb\u306e\u6587\u5b57\u5316\u3051\u304c\u767a\u751f\u3057\u305f\uff0e\u539f\u56e0\u306f\u4e0d\u660e\u306e\u307e\u307e\u3067\u3042\u308b\u304c\uff0cQGIS\u3067\u30ec\u30a4\u30e4\u30fc\u3092\u30de\u30fc\u30b8\u305b\u305a\u306b\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u9010\u4e00\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u3068\uff0c\u6587\u5b57\u5316\u3051\u304c\u767a\u751f\u3057\u306a\u3044\u3053\u3068\u304c\u5224\u660e\u3057\u305f\uff0e\u305d\u306e\u305f\u3081\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u5f8c\u306bSQL Server\u3067\u30ec\u30b3\u30fc\u30c9\u3092\u96c6\u3081\u308b\u65b9\u91dd\u3068\u3057\u305f\uff0e<\/p>\n<h3>Shape2SQL\u306eDatabase Configuration<\/h3>\n<p>\u3000Database Configuration\u3067\u306fServer name\u306bSQL Server\u306e\u30b5\u30fc\u30d0\u30fc\u540d\u3092\u5165\u529b\u3059\u308b\u3068\uff0cSelect or enter a database name\u306b\u30b5\u30fc\u30d0\u30fc\u5185\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u30ea\u30b9\u30c8\u30a2\u30c3\u30d7\u3055\u308c\u308b\uff0e<\/p>\n<figure id=\"attachment_15666\" aria-describedby=\"caption-attachment-15666\" style=\"width: 344px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/71.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15666\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/71.png\" alt=\"Shape2SQL\u306eDatabase Configuration\" width=\"344\" height=\"401\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/71.png 344w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/71-257x300.png 257w\" sizes=\"auto, (max-width: 344px) 100vw, 344px\" \/><\/a><figcaption id=\"caption-attachment-15666\" class=\"wp-caption-text\">Shape2SQL\u306eDatabase Configuration<\/figcaption><\/figure>\n<h3>Shape2SQL\u306eSever name, Select or enter a database name\u3092\u5165\u529b<\/h3>\n<p>\u3000\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3057\u305f\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u9078\u3076\uff0e\u3053\u3053\u3067\u306fZIPCODE\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u6307\u5b9a\u3057\u3066\u3044\u308b\uff0e<\/p>\n<figure id=\"attachment_15667\" aria-describedby=\"caption-attachment-15667\" style=\"width: 344px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/72.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15667\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/72.png\" alt=\"Shape2SQL\u306eSever name, Select or enter a database name\u3092\u5165\u529b\" width=\"344\" height=\"401\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/72.png 344w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/72-257x300.png 257w\" sizes=\"auto, (max-width: 344px) 100vw, 344px\" \/><\/a><figcaption id=\"caption-attachment-15667\" class=\"wp-caption-text\">Shape2SQL\u306eSever name, Select or enter a database name\u3092\u5165\u529b<\/figcaption><\/figure>\n<p>\u3000Shapefile\u306e\u53f3\u7aef\u306e&#8230;\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30c0\u30a4\u30a2\u30ed\u30b0\u3067\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a\u3059\u308b\uff0eUpload to Database\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u304cSQL Server\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3055\u308c\u308b\uff0e47\u500b\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u306b\u3064\u304d\u540c\u69d8\u306e\u624b\u9806\u3092\u7e70\u308a\u8fd4\u3059\uff0e<\/p>\n<figure id=\"attachment_15668\" aria-describedby=\"caption-attachment-15668\" style=\"width: 439px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/73.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15668\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/73.png\" alt=\"Shape2SQl\u306e\u8a2d\u5b9a\u304c\u7d42\u308f\u3063\u305f\u3068\u3053\u308d\" width=\"439\" height=\"366\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/73.png 439w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/73-300x250.png 300w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><figcaption id=\"caption-attachment-15668\" class=\"wp-caption-text\">Shape2SQl\u306e\u8a2d\u5b9a\u304c\u7d42\u308f\u3063\u305f\u3068\u3053\u308d<\/figcaption><\/figure>\n<h3>Shape2SQL\u3067\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3055\u308c\u305f\u30c6\u30fc\u30d6\u30eb<\/h3>\n<p>\u300047\u90fd\u9053\u5e9c\u770c\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u3068\u4e0b\u56f3\u306e\u3088\u3046\u306a\u72b6\u614b\u306b\u306a\u308b\uff0e\u5b9f\u306f3\u500b\u307b\u3069\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u306b\u5931\u6557\u3057\u3066\u3044\u308b\uff0e\u8a72\u5f53\u3059\u308b\u90fd\u9053\u5e9c\u770c\u306f\u7fa4\u99ac\u770c\uff0c\u9999\u5ddd\u770c\uff0c\u4f50\u8cc0\u770c\u3067\u3042\u308b\uff0e\u539f\u56e0\u306f\u4e0d\u660e\u3067\u3042\u308b\uff0e\u3053\u306e\u4f5c\u696d\u306e\u5f8c\uff0c\u4e16\u754c\u6e2c\u5730\u7cfb\u7d4c\u5ea6\u7def\u5ea6\u306e\u65b9\u3067\u8a66\u307f\u308b\u3068\u3059\u3079\u3066\u3046\u307e\u304f\u884c\u3063\u305f\uff0e<\/p>\n<figure id=\"attachment_15669\" aria-describedby=\"caption-attachment-15669\" style=\"width: 296px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/51.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15669\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/51.png\" alt=\"Shape2SQL\u3067\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3055\u308c\u305f\u30c6\u30fc\u30d6\u30eb\" width=\"296\" height=\"892\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/51.png 296w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/51-100x300.png 100w\" sizes=\"auto, (max-width: 296px) 100vw, 296px\" \/><\/a><figcaption id=\"caption-attachment-15669\" class=\"wp-caption-text\">Shape2SQL\u3067\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3055\u308c\u305f\u30c6\u30fc\u30d6\u30eb<\/figcaption><\/figure>\n<h3>\u30ec\u30b3\u30fc\u30c9\u3092\u96c6\u3081\u308b\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210<\/h3>\n<p>\u3000\u4e0b\u8a18\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\uff0e<\/p>\n<pre>USE [ZIPCODE]\nGO\nCREATE TABLE [dbo].[T_JAPAN_CITY](\n\t[ID] [int] IDENTITY(1,1) NOT NULL,\n\t[KEY_CODE] [nvarchar](255) NULL,\n\t[PREF] [nvarchar](255) NULL,\n\t[CITY] [nvarchar](255) NULL,\n\t[S_AREA] [nvarchar](255) NULL,\n\t[PREF_NAME] [nvarchar](255) NULL,\n\t[CITY_NAME] [nvarchar](255) NULL,\n\t[S_NAME] [nvarchar](255) NULL,\n\t[KIGO_E] [nvarchar](255) NULL,\n\t[HCODE] [int] NULL,\n\t[AREA] [float] NULL,\n\t[PERIMETER] [float] NULL,\n\t[R2KAxx] [bigint] NULL,\n\t[R2KAxx_ID] [bigint] NULL,\n\t[KIHON1] [nvarchar](255) NULL,\n\t[DUMMY1] [nvarchar](255) NULL,\n\t[KIHON2] [nvarchar](255) NULL,\n\t[KEYCODE1] [nvarchar](255) NULL,\n\t[KEYCODE2] [nvarchar](255) NULL,\n\t[AREA_MAX_F] [nvarchar](255) NULL,\n\t[KIGO_D] [nvarchar](255) NULL,\n\t[N_KEN] [nvarchar](255) NULL,\n\t[N_CITY] [nvarchar](255) NULL,\n\t[KIGO_I] [nvarchar](255) NULL,\n\t[KBSUM] [int] NULL,\n\t[JINKO] [bigint] NULL,\n\t[SETAI] [bigint] NULL,\n\t[X_CODE] [float] NULL,\n\t[Y_CODE] [float] NULL,\n\t[KCODE1] [nvarchar](255) NULL,\n\t[geom] [geometry] NULL,\nPRIMARY KEY CLUSTERED \n(\n\t[ID] ASC\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\nGO\nALTER TABLE [dbo].[T_JAPAN_CITY]  WITH CHECK ADD  CONSTRAINT [enforce_srid_geometry_T_JAPAN_CITY] CHECK  (([geom].[STSrid]=(0)))\nGO\nALTER TABLE [dbo].[T_JAPAN_CITY] CHECK CONSTRAINT [enforce_srid_geometry_T_JAPAN_CITY]\nGO<\/pre>\n<h3>\u4f5c\u6210\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u306b\u30ec\u30b3\u30fc\u30c9\u3092\u96c6\u3081\u308b<\/h3>\n<p>\u3000\u4e0b\u8a18\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u4f5c\u6210\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u306b\u30ec\u30b3\u30fc\u30c9\u3092\u96c6\u3081\u308b\uff0eFROM\u53e5\u306e\u30c6\u30fc\u30d6\u30eb\u9023\u756a\u3092\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u3057\u306647\u56de\u5b9f\u884c\u3059\u308b\uff0e<\/p>\n<pre>USE\tZIPCODE;\nGO\nINSERT\tINTO\t[dbo].[T_JAPAN_CITY]([KEY_CODE],\n\t[PREF],\n\t[CITY],\n\t[S_AREA],\n\t[PREF_NAME],\n\t[CITY_NAME],\n\t[S_NAME],\n\t[KIGO_E],\n\t[HCODE],\n\t[AREA],\n\t[PERIMETER],\n\t[R2KAxx],\n\t[R2KAxx_ID],\n\t[KIHON1],\n\t[DUMMY1],\n\t[KIHON2],\n\t[KEYCODE1],\n\t[KEYCODE2],\n\t[AREA_MAX_F],\n\t[KIGO_D],\n\t[N_KEN],\n\t[N_CITY],\n\t[KIGO_I],\n\t[KBSUM],\n\t[JINKO],\n\t[SETAI],\n\t[X_CODE],\n\t[Y_CODE],\n\t[KCODE1],\n\t[geom])\nSELECT\t\t[KEY_CODE],\n\t[PREF],\n\t[CITY],\n\t[S_AREA],\n\t[PREF_NAME],\n\t[CITY_NAME],\n\t[S_NAME],\n\t[KIGO_E],\n\t[HCODE],\n\t[AREA],\n\t[PERIMETER],\n\t[R2KAxx],\n\t[R2KAxx_ID],\n\t[KIHON1],\n\t[DUMMY1],\n\t[KIHON2],\n\t[KEYCODE1],\n\t[KEYCODE2],\n\t[AREA_MAX_F],\n\t[KIGO_D],\n\t[N_KEN],\n\t[N_CITY],\n\t[KIGO_I],\n\t[KBSUM],\n\t[JINKO],\n\t[SETAI],\n\t[X_CODE],\n\t[Y_CODE],\n\t[KCODE1],\n\t[geom]\nFROM\tdbo.r2ka01<\/pre>\n<h3>\u4e0d\u8981\u3068\u306a\u3063\u305f\u30c6\u30fc\u30d6\u30eb\u3092\u524a\u9664\u3059\u308b<\/h3>\n<p>\u3000INSERT\u5143\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u30fc\u304b\u3089\u524a\u9664\u3059\u308b\uff0e<\/p>\n<h3>\u30af\u30a8\u30ea<\/h3>\n<p>\u3000\u4e0b\u8a18\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u3068\uff0c<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=15604\" target=\"_blank\" rel=\"noopener\">\u90f5\u4fbf\u756a\u53f7\u30c6\u30fc\u30d6\u30eb<\/a>\u3068\u5883\u754c\u30c7\u30fc\u30bf\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3057\u305f\u30ec\u30b3\u30fc\u30c9\u304c\u62bd\u51fa\u3055\u308c\u308b\uff0e\u7d50\u5408\u6761\u4ef6\u304c\u59a5\u5f53\u3067\u3042\u308b\u304b\u5426\u304b\uff0c\u81ea\u4fe1\u304c\u306a\u3044\uff0e<\/p>\n<pre>USE\tZIPCODE;\nGO\nSELECT\tZ.\u90f5\u4fbf\u756a\u53f7\n\t,\tZ.\u90fd\u9053\u5e9c\u770c\u540d\n\t,\tZ.\u5e02\u533a\u753a\u6751\u540d\n\t,\tZ.\u753a\u57df\u540d\n\t,\tC.S_NAME\n\t,\tZ.\u5168\u56fd\u5730\u65b9\u516c\u5171\u56e3\u4f53\u30b3\u30fc\u30c9\n\t,\tC.KEY_CODE\n\t,\tC.geom\n\t,\tC.X_CODE\n\t,\tC.Y_CODE\n\t,\tC.AREA\nFROM\tdbo.ZIPCODE\tAS\tZ\nINNER\tJOIN\tdbo.T_JAPAN_CITY\tAS C\nON\tZ.\u90fd\u9053\u5e9c\u770c\u540d=C.PREF_NAME\nAND\tZ.\u5e02\u533a\u753a\u6751\u540d=C.CITY_NAME\nAND\tC.S_NAME\tLIKE\tZ.\u753a\u57df\u540d+'%'\nAND\tZ.\u753a\u57df\u540d\t&lt;&gt;''\nWHERE\tZ.\u90f5\u4fbf\u756a\u53f7='1000001'<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u4ee5\u4e0b\u3067\u3042\u308b\uff0e\u90f5\u4fbf\u756a\u53f7\u304b\u3089\u7687\u5c45\u3092\u62bd\u51fa\u3057\u3066\u3044\u308b\uff0e<\/p>\n<figure id=\"attachment_16569\" aria-describedby=\"caption-attachment-16569\" style=\"width: 696px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/25.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16569\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/25.png\" alt=\"\u90f5\u4fbf\u756a\u53f7\u304b\u3089\u7687\u5c45\u3092\u62bd\u51fa\" width=\"696\" height=\"521\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/25.png 696w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/25-300x225.png 300w\" sizes=\"auto, (max-width: 696px) 100vw, 696px\" \/><\/a><figcaption id=\"caption-attachment-16569\" class=\"wp-caption-text\">\u90f5\u4fbf\u756a\u53f7\u304b\u3089\u7687\u5c45\u3092\u62bd\u51fa<\/figcaption><\/figure>\n<h3>\u4e16\u754c\u6e2c\u5730\u7cfb\u7d4c\u5ea6\u7def\u5ea6\u306e\u5834\u5408<\/h3>\n<p>\u3000\u4e16\u754c\u6e2c\u5730\u7cfb\u7d4c\u5ea6\u7def\u5ea6\u306e\u5834\u5408\uff0cWHERE \u533a\u3092\u7701\u7565\u3057\u3066\u5168\u4ef6\u3092\u62bd\u51fa\u3057\u305f\u7d50\u679c\u306f\u4ee5\u4e0b\u3067\u3042\u308b\uff0e\u3053\u3061\u3089\u306e\u65b9\u3092\u4f7f\u3046\u3079\u304d\u304b\u3082\u3057\u308c\u306a\u3044\uff0e<\/p>\n<pre>(187849 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(127382 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(232019 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>\u3000\u56fd\u52e2\u8abf\u67fb\u306e\u5c0f\u5730\u57df\u306e\u5883\u754c\u30c7\u30fc\u30bf\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\uff0cShape2SQL\u3067SQL Server\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\uff0e\u90f5\u4fbf\u756a\u53f7\u30c6\u30fc\u30d6\u30eb\u3068\u7d50\u5408\u3059\u308b\u3068\u90f5\u4fbf\u756a\u53f7\u304b\u3089\u5c0f\u5730\u57df\u3092\u62bd\u51fa\u3067\u304d\uff0c\u30b8\u30aa\u30e1\u30c8\u30ea\u30c7\u30fc\u30bf\u3082\u62bd\u51fa\u53ef\u80fd\u3068\u306a\u3063\u305f\uff0e<\/p>\n<p>\u3000\u90f5\u4fbf\u756a\u53f7\u304b\u3089\u4f4f\u6240\u3092\u9078\u629e\u3059\u308bWEB\u30b5\u30fc\u30d3\u30b9\u306f\u4e00\u822c\u7684\u3067\u3042\u308b\u304c\uff0c\u3053\u306e\u3088\u3046\u306a\u4ed5\u7d44\u307f\u3067\u3042\u308b\u3068\u63a8\u6e2c\u3055\u308c\u308b\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3000\u56fd\u52e2\u8abf\u67fb\u306e\u7d50\u679c\u304ceStat\u306b\u63b2\u8f09\u3055\u308c\u59cb\u3081\u3066\u3044\u308b\uff0e\u4eca\u56de\u306f\u5c0f\u5730\u57df\u306e\u5883\u754c\u30c7\u30fc\u30bf\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\uff0cSQL Server\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u307e\u3067\u306e\u8a18\u9332\u3092\u8a18\u3059\uff0e<\/p>\n","protected":false},"author":1,"featured_media":15391,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[12025,12024,7554,5205,12020,7901,7672,6372,5564,2885,4673,7228,7155,12018,12023,12029,8413,6743,12030,6744,7065,12026,4674,12021,12019,4672,9112,9110,7669,7640,2740,12022,12027,7694,7154,12032,12028,12017,1801,2758,9114,9582,2684,462,32,5202,9409,10963,2703,12044,12016,4443,10952,7792,10962,9408,12031,12042,2723,4439,12043],"class_list":{"0":"post-15655","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-technology","8":"tag-allow_page_locks","9":"tag-allow_row_locks","10":"tag-alter-table","11":"tag-bigint","12":"tag-clustered","13":"tag-create-table","14":"tag-database-configuration","15":"tag-dbo","16":"tag-estat","17":"tag-float","18":"tag-from","19":"tag-geometry","20":"tag-go","21":"tag-identity","22":"tag-ignore_dup_key","23":"tag-iiner-join","24":"tag-insert-into","25":"tag-int","26":"tag-like","27":"tag-not-null","28":"tag-nvarchar","29":"tag-optimize_for_sequential_key","30":"tag-order-by","31":"tag-pad_index","32":"tag-primary-key","33":"tag-select","34":"tag-select-or-enter-a-database-name","35":"tag-server-name","36":"tag-shape2sql","37":"tag-shapefile","38":"tag-sql-server","39":"tag-statistics_norecompute","40":"tag-textimage_on","41":"tag-upload-to-database","42":"tag-use","43":"tag-web","44":"tag-with-check-add-constraint","45":"tag-zipcode","46":"tag-1801","47":"tag-2758","48":"tag-9114","49":"tag-9582","50":"tag-2684","51":"tag-462","52":"tag-32","53":"tag-5202","54":"tag-9409","56":"tag-2703","57":"tag-12044","58":"tag-12016","59":"tag-4443","60":"tag-10952","61":"tag-7792","62":"tag-10962","63":"tag-9408","64":"tag-12031","65":"tag-12042","66":"tag-2723","67":"tag-4439","68":"tag-12043"},"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15655","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15655"}],"version-history":[{"count":27,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15655\/revisions"}],"predecessor-version":[{"id":16572,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15655\/revisions\/16572"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/media\/15391"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}