{"id":16892,"date":"2023-03-09T06:00:00","date_gmt":"2023-03-08T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=16892"},"modified":"2022-10-29T13:08:43","modified_gmt":"2022-10-29T04:08:43","slug":"%e5%9b%bd%e5%9c%9f%e6%95%b0%e5%80%a4%e6%83%85%e5%a0%b1%e3%81%ae%e9%81%bf%e9%9b%a3%e6%96%bd%e8%a8%ad%e3%81%ae%e3%83%9d%e3%82%a4%e3%83%b3%e3%83%88%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92sql-server%e3%81%ab","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=16892","title":{"rendered":"\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u907f\u96e3\u65bd\u8a2d\u306e\u30dd\u30a4\u30f3\u30c8\u30c7\u30fc\u30bf\u3092SQL Server\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b"},"content":{"rendered":"\n<p>\u3000\u5168\u56fd\u306b\u306f\u907f\u96e3\u65bd\u8a2d\u304c\u7d04 12 \u4e07\u7b87\u6240\u3042\u308b\uff0e\u305d\u308c\u3089\u306e\u4f4d\u7f6e\u30c7\u30fc\u30bf\u3092 SQL Server \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u3044\uff0e\u4f55\u5ea6\u304b\u8a66\u884c\u932f\u8aa4\u306e\u7d50\u679c\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u306b\u6210\u529f\u3057\u305f\u306e\u3067\u5099\u5fd8\u9332\u3068\u3057\u3066\u516c\u958b\u3059\u308b\uff0e<\/p>\n<p><!--more--><\/p>\n<h2>\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u907f\u96e3\u65bd\u8a2d\u30c7\u30fc\u30bf<\/h2>\n<p>\u3000\u4f8b\u306b\u3088\u3063\u3066\uff0c\u56fd\u571f\u6570\u5024\u60c5\u5831\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30b5\u30fc\u30d3\u30b9\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u3066\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092 Shape2SQL \u3067\u76f4\u63a5 SQL Server \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u3068\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3066\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u304c\u6b62\u307e\u308b\uff0e\u307e\u305f\u6587\u5b57\u5316\u3051\u304c\u767a\u751f\u3057\u3066\u65e5\u672c\u8a9e\u304c\u8868\u793a\u3055\u308c\u306a\u3044\uff0e\u5c5e\u6027\u540d\u306b\u65e5\u672c\u8a9e\u304c\u4f7f\u308f\u308c\u3066\u3044\u308b\u3068\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u3088\u3046\u3067\u3042\u308b\uff0e<\/p>\n<figure id=\"attachment_16893\" aria-describedby=\"caption-attachment-16893\" style=\"width: 374px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/06-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16893\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/06-4.png\" alt=\"Shape2SQL\u3067\u767a\u751f\u3059\u308b\u30a8\u30e9\u30fc\u3068\u6587\u5b57\u5316\u3051\" width=\"374\" height=\"453\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/06-4.png 374w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/06-4-248x300.png 248w\" sizes=\"auto, (max-width: 374px) 100vw, 374px\" \/><\/a><figcaption id=\"caption-attachment-16893\" class=\"wp-caption-text\">Shape2SQL\u3067\u767a\u751f\u3059\u308b\u30a8\u30e9\u30fc\u3068\u6587\u5b57\u5316\u3051<\/figcaption><\/figure>\n<p>\u3000Shape2SQL \u306f\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u304c\u306a\u3055\u308c\u3066\u304a\u3089\u305a\uff0c\u73fe\u72b6\u306e\u307e\u307e\u4f7f\u3044\u7d9a\u3051\u308b\u307b\u304b\u306a\u3044\uff0e\u65e9\u3005\u306b WKT \u8868\u73fe\u4ed8\u304d\u306e csv \u30d5\u30a1\u30a4\u30eb\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u65b9\u91dd\u306b\u5207\u308a\u66ff\u3048\u305f\uff0e<\/p>\n<h2>QGIS\u3067\u306e\u4f5c\u696d<\/h2>\n<h3>\u307e\u305a\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u306e\u30de\u30fc\u30b8<\/h3>\n<p>\u3000\u907f\u96e3\u65bd\u8a2d\u306e\u30c7\u30fc\u30bf\u306f\u90fd\u9053\u5e9c\u770c\u5225\u306b 47 \u500b\u3042\u308b\uff0e\u3053\u308c\u3089\u3092QGIS\u3067\u958b\u304d\uff0c\u30ec\u30a4\u30e4\u3092\u30de\u30fc\u30b8\u3057\u3066\u4e00\u3064\u306e\u30ec\u30a4\u30e4\u306b\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_16894\" aria-describedby=\"caption-attachment-16894\" style=\"width: 381px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/00-6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16894\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/00-6.png\" alt=\"\u300c\u30d9\u30af\u30bf\u300d\u300c\u30c7\u30fc\u30bf\u7ba1\u7406\u30c4\u30fc\u30eb\u300d\u300c\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u30de\u30fc\u30b8\u300d\" width=\"381\" height=\"224\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/00-6.png 381w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/00-6-300x176.png 300w\" sizes=\"auto, (max-width: 381px) 100vw, 381px\" \/><\/a><figcaption id=\"caption-attachment-16894\" class=\"wp-caption-text\">\u300c\u30d9\u30af\u30bf\u300d\u300c\u30c7\u30fc\u30bf\u7ba1\u7406\u30c4\u30fc\u30eb\u300d\u300c\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u30de\u30fc\u30b8\u300d<\/figcaption><\/figure>\n<figure id=\"attachment_16895\" aria-describedby=\"caption-attachment-16895\" style=\"width: 690px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/01-6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16895\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/01-6.png\" alt=\"\u300c\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u30de\u30fc\u30b8\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u521d\u671f\u72b6\u614b\" width=\"690\" height=\"555\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/01-6.png 690w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/01-6-300x241.png 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/a><figcaption id=\"caption-attachment-16895\" class=\"wp-caption-text\">\u300c\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u30de\u30fc\u30b8\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u521d\u671f\u72b6\u614b<\/figcaption><\/figure>\n<figure id=\"attachment_16897\" aria-describedby=\"caption-attachment-16897\" style=\"width: 690px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/02-6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16897\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/02-6.png\" alt=\"\u300c\u5165\u529b\u30ec\u30a4\u30e4\u300d\u3067\u300c\u3059\u3079\u3066\u9078\u629e\u300d\" width=\"690\" height=\"555\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/02-6.png 690w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/02-6-300x241.png 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/a><figcaption id=\"caption-attachment-16897\" class=\"wp-caption-text\">\u300c\u5165\u529b\u30ec\u30a4\u30e4\u300d\u3067\u300c\u3059\u3079\u3066\u9078\u629e\u300d<\/figcaption><\/figure>\n<figure id=\"attachment_16898\" aria-describedby=\"caption-attachment-16898\" style=\"width: 690px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/03-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16898\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/03-4.png\" alt=\"\u300c\u5909\u63db\u5148\u306e\u5ea7\u6a19\u53c2\u7167\u7cfb\u300d\u3068\u300c\u51fa\u529b\u30ec\u30a4\u30e4\u300d\u3092\u6307\u5b9a\" width=\"690\" height=\"555\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/03-4.png 690w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/03-4-300x241.png 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/a><figcaption id=\"caption-attachment-16898\" class=\"wp-caption-text\">\u300c\u5909\u63db\u5148\u306e\u5ea7\u6a19\u53c2\u7167\u7cfb\u300d\u3068\u300c\u51fa\u529b\u30ec\u30a4\u30e4\u300d\u3092\u6307\u5b9a<\/figcaption><\/figure>\n<figure id=\"attachment_16899\" aria-describedby=\"caption-attachment-16899\" style=\"width: 946px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/04-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16899\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/04-4.png\" alt=\"\u300c\u51fa\u529b\u30ec\u30a4\u30e4\u300d\u306b\u300c\u30d5\u30a1\u30a4\u30eb\u306b\u4fdd\u5b58\u300d\u3092\u9078\u3093\u3060\u5834\u5408\" width=\"946\" height=\"533\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/04-4.png 946w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/04-4-300x169.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/04-4-768x433.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption id=\"caption-attachment-16899\" class=\"wp-caption-text\">\u300c\u51fa\u529b\u30ec\u30a4\u30e4\u300d\u306b\u300c\u30d5\u30a1\u30a4\u30eb\u306b\u4fdd\u5b58\u300d\u3092\u9078\u3093\u3060\u5834\u5408<\/figcaption><\/figure>\n<figure id=\"attachment_16901\" aria-describedby=\"caption-attachment-16901\" style=\"width: 690px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/05-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16901\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/05-5.png\" alt=\"\u300c\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u30de\u30fc\u30b8\u300d\u3067\u5168\u3066\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u8a2d\u5b9a\u3057\u305f\u3068\u3053\u308d\" width=\"690\" height=\"555\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/05-5.png 690w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/05-5-300x241.png 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/a><figcaption id=\"caption-attachment-16901\" class=\"wp-caption-text\">\u300c\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u30de\u30fc\u30b8\u300d\u3067\u5168\u3066\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u8a2d\u5b9a\u3057\u305f\u3068\u3053\u308d<\/figcaption><\/figure>\n<p>\u3000\u7d50\u679c\u306f\u4e0b\u56f3\u306e\u901a\u308a\uff0e\u5168\u3066\u306e\u30dd\u30a4\u30f3\u30c8\u30c7\u30fc\u30bf\u304c\u4e00\u3064\u306e\u30ec\u30a4\u30e4\u306b\u30de\u30fc\u30b8\u3055\u308c\u308b\uff0e<\/p>\n<figure id=\"attachment_16902\" aria-describedby=\"caption-attachment-16902\" style=\"width: 806px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/09-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16902\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/09-2.png\" alt=\"\u5168\u3066\u306e\u30dd\u30a4\u30f3\u30c8\u30c7\u30fc\u30bf\u304c\u4e00\u3064\u306e\u30ec\u30a4\u30e4\u306b\u30de\u30fc\u30b8\u3055\u308c\u308b\" width=\"806\" height=\"760\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/09-2.png 806w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/09-2-300x283.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/09-2-768x724.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption id=\"caption-attachment-16902\" class=\"wp-caption-text\">\u5168\u3066\u306e\u30dd\u30a4\u30f3\u30c8\u30c7\u30fc\u30bf\u304c\u4e00\u3064\u306e\u30ec\u30a4\u30e4\u306b\u30de\u30fc\u30b8\u3055\u308c\u308b<\/figcaption><\/figure>\n<p>\u3000\u3053\u306e\u5f8c\uff0c\u51fa\u529b\u3055\u308c\u305f\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092Shape2SQL\u3067\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3088\u3046\u3068\u3057\u305f\u304c\uff0c\u5148\u7a0b\u3068\u540c\u69d8\u306e\u30a8\u30e9\u30fc\u306b\u898b\u821e\u308f\u308c\u3066\u5931\u6557\u3057\u305f\uff0e<\/p>\n<h3>\u300c\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u300d\u300c\u65b0\u898f\u30d5\u30a1\u30a4\u30eb\u306b\u5730\u7269\u3092\u4fdd\u5b58\u300d<\/h3>\n<p>\u3000\u3055\u3066\uff0c\u65b9\u91dd\u3092\u5909\u66f4\u3057\u3066csv\u30d5\u30a1\u30a4\u30eb\u306b\u51fa\u529b\u3059\u308b\uff0e\u6ce8\u610f\u70b9\u3092\u5217\u8a18\u3059\u308b\uff0e<\/p>\n<ul>\n<li>\u300c\u5f62\u5f0f\u300d\u3092\u300c\u30ab\u30f3\u30de\u3067\u533a\u5207\u3089\u308c\u305f\u5024[CSV]\u300d\u306b\u5909\u66f4\u3059\u308b<\/li>\n<li>\u300c\u5ea7\u6a19\u53c2\u7167\u7cfb\u300d\u3092EPSG:4326\u306b\u5909\u66f4\u3059\u308b<\/li>\n<li>\u6587\u5b57\u30b3\u30fc\u30c9\u306fShift_JIS\u306e\u307e\u307e\u3068\u3059\u308b<\/li>\n<li>\u300c\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\u30d5\u30a3\u30fc\u30eb\u30c9\u3068\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u9078\u629e\u300d\u3067layer\u3068path\u306e\u30c1\u30a7\u30c3\u30af\u3092\u5916\u3059<\/li>\n<li>\u300c\u30b8\u30aa\u30e1\u30c8\u30ea\u578b\u300d\u3092\u70b9Point\u306b\u5909\u66f4\u3059\u308b<\/li>\n<li>\u300c\u30ec\u30a4\u30e4\u30aa\u30d7\u30b7\u30e7\u30f3\u300d\u306e GEOMETRY \u3092 AS_WKT \u306b\u5909\u66f4\u3059\u308b<\/li>\n<li>LINEFORMAT \u3092 CRLF \u306b\u5909\u66f4\u3059\u308b<\/li>\n<li>SEPARATOR \u3092 TAB \u306b\u5909\u66f4\u3059\u308b<\/li>\n<li>STRING_QUOTING \u3092 IF_NEEDED \u306b\u5909\u66f4\u3059\u308b<\/li>\n<\/ul>\n<figure id=\"attachment_16903\" aria-describedby=\"caption-attachment-16903\" style=\"width: 593px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/20.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16903\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/20.png\" alt=\"\u540d\u524d\u3092\u3064\u3051\u3066\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u4fdd\u5b58\" width=\"593\" height=\"1002\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/20.png 593w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/20-178x300.png 178w\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/a><figcaption id=\"caption-attachment-16903\" class=\"wp-caption-text\">\u540d\u524d\u3092\u3064\u3051\u3066\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u4fdd\u5b58<\/figcaption><\/figure>\n<h2>\u30e1\u30e2\u5e33\u3067\u306e\u4f5c\u696d<\/h2>\n<p>\u3000\u30e1\u30e2\u5e33\u3067\u306e\u4f5c\u696d\u306f\u91cd\u8981\u3067\u3042\u308b\uff0e<\/p>\n<h3>csv\u30d5\u30a1\u30a4\u30eb\u306e\u62e1\u5f35\u5b50\u3092txt\u306b\u5909\u66f4\u3059\u308b<\/h3>\n<p>\u3000csv\u30d5\u30a1\u30a4\u30eb\u3092txt\u30d5\u30a1\u30a4\u30eb\u306b\u5909\u66f4\u3057\uff0c\u30e1\u30e2\u5e33\u3067\u958b\u3051\u308b\u3088\u3046\u306b\u3059\u308b\uff0e<\/p>\n<h3>\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u30de\u30fc\u30af\u3092\u4e00\u62ec\u7f6e\u63db\u3067\u524a\u9664<\/h3>\n<p>\u3000\u7f6e\u63db\u6a5f\u80fd\u3067\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u30de\u30fc\u30af\u3092\u524a\u9664\u3059\u308b\uff0e<\/p>\n<h2>SQL Server\u3067\u306e\u4f5c\u696d<\/h2>\n<h3>\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30dd\u30fc\u30c8<\/h3>\n<p>\u3000\u4e0b\u56f3\u306e\u3088\u3046\u306b\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\uff0e\u7d30\u304b\u3044\u8a18\u8ff0\u306f\u7701\u7565\u3059\u308b\u304c\uff0c\u30c7\u30fc\u30bf\u9577\u304c50 \u3060\u3068\u5207\u308a\u6368\u3066\u30a8\u30e9\u30fc\u304c\u81f3\u308b\u3068\u3053\u308d\u3067\u767a\u751f\u3059\u308b\u305f\u3081\uff0c\u4e00\u5f8b\u3067255\u306b\u62e1\u5f35\u3057\u3066\u3044\u308b\uff0e<\/p>\n<figure id=\"attachment_16904\" aria-describedby=\"caption-attachment-16904\" style=\"width: 595px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/21.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16904\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/21.png\" alt=\"SQL Server\u306b\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30dd\u30fc\u30c8\" width=\"595\" height=\"696\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/21.png 595w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/21-256x300.png 256w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/><\/a><figcaption id=\"caption-attachment-16904\" class=\"wp-caption-text\">SQL Server\u306b\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30dd\u30fc\u30c8<\/figcaption><\/figure>\n<h3>\u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u306e\u5909\u66f4<\/h3>\n<p>\u3000\u30c6\u30fc\u30d6\u30eb\u306b Location \u5217\u3092\u8ffd\u52a0\u3057\u30c7\u30fc\u30bf\u578b\u3092 geography \u3068\u3059\u308b\uff0e<\/p>\n<h3>\u30af\u30a8\u30ea\u3067\u30c6\u30fc\u30d6\u30eb\u306e Location \u5217\u3092\u66f4\u65b0<\/h3>\n<p>\u3000\u30af\u30a8\u30ea\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u66f4\u65b0\u3059\u308b\u524d\u306b\uff0c\u3057\u3066\u304a\u304b\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\u3053\u3068\u304c\u3042\u308b\uff0eWKT\u5217\u306bWKT\u8868\u73fe\u4ee5\u5916\u306e\u884c\u304c\u7d1b\u308c\u8fbc\u3093\u3067\u3044\u306a\u3044\u304b\u78ba\u8a8d\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\uff0e<\/p>\n<pre>SELECT\t*\nFROM\tdbo.T_Shelter\nWHERE\tLEFT(WKT, 5) &lt;&gt; 'POINT'<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u901a\u308a\uff0e<\/p>\n<pre>(5 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<p>\u3000\u3053\u308c\u3089\u306e\u884c\u3092\u524a\u9664\u3059\u308b\uff0e<\/p>\n<pre>DELETE\t\nFROM\tdbo.T_Shelter\nWHERE\tLEFT(WKT, 5) &lt;&gt; 'POINT'<\/pre>\n<pre>(5 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<p>\u3000\u7136\u308b\u5f8c\uff0c\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\uff0e<\/p>\n<pre>UPDATE\tdbo.T_Shelter\nSET\tLocation = geography::STPointFromText(WKT, 4326)<\/pre>\n<pre>(125927 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<h2>\u30e1\u30bf\u30c7\u30fc\u30bf<\/h2>\n<table style=\"width: 100%; height: 532px;\">\n<tbody>\n<tr style=\"height: 27px;\">\n<th style=\"height: 27px;\">shp\u5c5e\u6027<\/th>\n<th style=\"height: 27px;\">\u5c5e\u6027\u540d<\/th>\n<th style=\"height: 27px;\">\u8aac\u660e<\/th>\n<\/tr>\n<tr style=\"height: 50px;\">\n<td style=\"height: 50px;\">P20_001<\/td>\n<td style=\"height: 50px;\">\u884c\u653f\u533a\u57df\u30b3\u30fc\u30c9<\/td>\n<td style=\"height: 50px;\">\u90fd\u9053\u5e9c\u770c\u30b3\u30fc\u30c9\u3068\u5e02\u533a\u753a\u6751\u30b3\u30fc\u30c9\u304b\u3089\u306a\u308b\uff0c\u907f\u96e3\u65bd\u8a2d\u306e\u6240\u5728\u3059\u308b\u884c\u653f\u533a\u3092\u7279\u5b9a\u3059\u308b\u305f\u3081\u306e\u30b3\u30fc\u30c9\uff0c\u30b3\u30fc\u30c9\u30ea\u30b9\u30c8\u300c<a href=\"https:\/\/nlftp.mlit.go.jp\/ksj\/gml\/codelist\/AdminiBoundary_CD.xlsx\" target=\"_blank\" rel=\"noopener\">\u884c\u653f\u533a\u57df\u30b3\u30fc\u30c9<\/a>\u300d<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">P20_002<\/td>\n<td style=\"height: 27px;\">\u540d\u79f0<\/td>\n<td style=\"height: 27px;\">\u907f\u96e3\u65bd\u8a2d\u306e\u540d\u79f0<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">P20_003<\/td>\n<td style=\"height: 27px;\">\u4f4f\u6240<\/td>\n<td style=\"height: 27px;\">\u907f\u96e3\u65bd\u8a2d\u306e\u4f4f\u6240<\/td>\n<\/tr>\n<tr style=\"height: 50px;\">\n<td style=\"height: 50px;\">P20_004<\/td>\n<td style=\"height: 50px;\">\u65bd\u8a2d\u306e\u7a2e\u985e<\/td>\n<td style=\"height: 50px;\">\u907f\u96e3\u65bd\u8a2d\u306e\u7a2e\u985e<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">P20_005<\/td>\n<td style=\"height: 27px;\">\u53ce\u5bb9\u4eba\u6570<\/td>\n<td style=\"height: 27px;\">\u907f\u96e3\u65bd\u8a2d\u306e\u5f62\u614b\u3054\u3068\u306e\u53ce\u5bb9\u53ef\u80fd\u4eba\u6570<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">P20_006<\/td>\n<td style=\"height: 27px;\">\u65bd\u8a2d\u898f\u6a21<\/td>\n<td style=\"height: 27px;\">\u907f\u96e3\u65bd\u8a2d\u306e\u5f62\u614b\u3054\u3068\u306e\u9762\u7a4d\uff08\u5e73\u65b9\u30e1\u30fc\u30c8\u30eb\uff09<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">P20_007<\/td>\n<td style=\"height: 27px;\">\u5730\u9707\u707d\u5bb3<\/td>\n<td style=\"height: 27px;\">\u00a0<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">P20_008<\/td>\n<td style=\"height: 27px;\">\u6d25\u6ce2\u707d\u5bb3<\/td>\n<td style=\"height: 27px;\">\u00a0<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">P20_009<\/td>\n<td style=\"height: 27px;\">\u6c34\u5bb3<\/td>\n<td style=\"height: 27px;\">\u00a0<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">P20_010<\/td>\n<td style=\"height: 27px;\">\u706b\u5c71\u707d\u5bb3<\/td>\n<td style=\"height: 27px;\">\u00a0<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">P20_011<\/td>\n<td style=\"height: 27px;\">\u305d\u306e\u4ed6<\/td>\n<td style=\"height: 27px;\">\u00a0<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">P20_012<\/td>\n<td style=\"height: 27px;\">\u6307\u5b9a\u306a\u3057<\/td>\n<td style=\"height: 27px;\">\u00a0<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">\u30ec\u30d9\u30eb<\/td>\n<td style=\"height: 27px;\">\u30ec\u30d9\u30eb<\/td>\n<td style=\"height: 27px;\">\n<p>\u30ec\u30d9\u30eb\uff11\uff1a\u56fd\u571f\u6570\u5024\u60c5\u5831\u3068\u4f4d\u7f6e\u304c\u4e00\u81f4<\/p>\n<p>\u30ec\u30d9\u30eb\uff12\uff1aGIS\u30c7\u30fc\u30bf\u304c\u6574\u5099\u3055\u308c\u3066\u3044\u308b\u81ea\u6cbb\u4f53\u306e\u65bd\u8a2d\u3068\u4e00\u304c\u4e00\u81f4<\/p>\n<p>\u30ec\u30d9\u30eb\uff13\uff1a\u9632\u707d\u30de\u30c3\u30d7\uff0c\u30cf\u30b6\u30fc\u30c9\u30de\u30c3\u30d7\u307e\u305f\u306fWEB\u5730\u56f3\u3068\u4f4d\u7f6e\u304c\u4e00\u81f4<\/p>\n<p>\u30ec\u30d9\u30eb\uff14\uff1a\u56fd\u571f\u6570\u5024\u60c5\u5831\u3068\u4f4d\u7f6e\u304c\u7570\u306a\u308a\u30ec\u30d9\u30eb\uff13\u3068\u4f4d\u7f6e\u304c\u4e00\u81f4<\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">\u5099\u8003<\/td>\n<td style=\"height: 27px;\">\u5099\u8003<\/td>\n<td style=\"height: 27px;\">\u00a0<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">\u7def\u5ea6<\/td>\n<td style=\"height: 27px;\">\u7def\u5ea6<\/td>\n<td style=\"height: 27px;\">\u00a0<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">\u7d4c\u5ea6<\/td>\n<td style=\"height: 27px;\">\u7d4c\u5ea6<\/td>\n<td style=\"height: 27px;\">\u00a0<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"height: 27px;\">No<\/td>\n<td style=\"height: 27px;\">No<\/td>\n<td style=\"height: 27px;\">\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>\u3000\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u907f\u96e3\u65bd\u8a2d\u30c7\u30fc\u30bf\u3092 SQL Server \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\uff0e\u5c5e\u6027\u540d\u304c\u65e5\u672c\u8a9e\u306e\u305f\u3081 Shape2SQL \u306b\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\uff0e\u305d\u306e\u305f\u3081 QGIS \u3092\u7528\u3044\u3066 csv \u30d5\u30a1\u30a4\u30eb\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\uff0c\u30e1\u30e2\u5e33\u3067\u52a0\u5de5\u3057\u305f\u4e0a\u3067 SQL Server \u306e\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\uff0cSQL Server \u306e\u6a5f\u80fd\u3092\u4f7f\u3063\u3066\u7a7a\u9593\u30c7\u30fc\u30bf\u306b\u5909\u63db\u3059\u308b\u5fc5\u8981\u304c\u3042\u3063\u305f\uff0e<\/p>\n<p>\u3000\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u306f\u305d\u306e<a href=\"https:\/\/www.esrij.com\/gis-guide\/esri-dataformat\/shapefile\/\" target=\"_blank\" rel=\"noopener\">\u898f\u683c<\/a>\u306b\u304a\u3044\u30662\u30d0\u30a4\u30c8\u6587\u5b57\u306f5\u6587\u5b57\u307e\u3067\uff0c1\u30d0\u30a4\u30c8\u6587\u5b57\u306f\u3068\u6c7a\u307e\u3063\u3066\u3044\u308b\uff0e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u304c\u5931\u6557\u3059\u308b\u306e\u306f Shape2SQL \u304c\u65e5\u672c\u8a9e\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u305f\u3081\u3068\u601d\u308f\u308c\u308b\uff0e\u56fd\u571f\u4ea4\u901a\u7701\u306b\u304a\u304b\u308c\u3066\u306f\uff0c\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u30921\u30d0\u30a4\u30c8\u6587\u5b57\u3067\u8a18\u8ff0\u3057\u3066\u3044\u305f\u3060\u304d\u305f\u3044\uff0e\u307e\u305f\u90fd\u9053\u5e9c\u770c\u5225\u30d5\u30a1\u30a4\u30eb\u3082\u826f\u3044\u304c\uff0c\u53ef\u80fd\u306a\u3089\u300c\u5168\u56fd\u300d\u306e\u907f\u96e3\u65bd\u8a2d\u3092\u307e\u3068\u3081\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u516c\u958b\u3057\u3066\u3044\u305f\u3060\u304d\u305f\u3044\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3000\u5168\u56fd\u306b\u306f\u907f\u96e3\u65bd\u8a2d\u304c\u7d04 12 \u4e07\u7b87\u6240\u3042\u308b\uff0e\u305d\u308c\u3089\u306e\u4f4d\u7f6e\u30c7\u30fc\u30bf\u3092 SQL Server \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u3044\uff0e\u4f55\u5ea6\u304b\u8a66\u884c\u932f\u8aa4\u306e\u7d50\u679c\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u306b\u6210\u529f\u3057\u305f\u306e\u3067\u5099\u5fd8\u9332\u3068\u3057\u3066\u516c\u958b\u3059\u308b\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":[9529,12905,2657,4698,4673,4964,7228,9620,5413,8060,4569,9177,4672,12944,4657,7669,2740,12047,9619,12945,6392,5123,12121,4238,1801,2861,2871,6739,9506,2498,12893,2783,9107,2684,12946,2499,9195,3600,9194,9196,12943,7635,3803,9501,12947,9197,9199,3726,1806,333,9137,9198,5529,9499,2844,8538,3634,12726,3532,12942],"class_list":["post-16892","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-as_wkt","tag-crlf","tag-csv","tag-delete","tag-from","tag-geography","tag-geometry","tag-if_needed","tag-left","tag-lineformat","tag-point","tag-qgis","tag-select","tag-separator","tag-set","tag-shape2sql","tag-sql-server","tag-stpointfromtext-2","tag-string_quoting","tag-txt-2","tag-update","tag-where","tag-wkt","tag-4238","tag-1801","tag-2861","tag-2871","tag-6739","tag-9506","tag-2498","tag-12893","tag-2783","tag-9107","tag-2684","tag-12946","tag-2499","tag-9195","tag-3600","tag-9194","tag-9196","tag-12943","tag-7635","tag-3803","tag-9501","tag-12947","tag-9197","tag-9199","tag-3726","tag-1806","tag-333","tag-9137","tag-9198","tag-5529","tag-9499","tag-2844","tag-8538","tag-3634","tag-12726","tag-3532","tag-12942"],"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/16892","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=16892"}],"version-history":[{"count":16,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/16892\/revisions"}],"predecessor-version":[{"id":16954,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/16892\/revisions\/16954"}],"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=16892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}