{"id":16668,"date":"2023-01-26T06:00:00","date_gmt":"2023-01-25T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=16668"},"modified":"2022-10-18T16:00:40","modified_gmt":"2022-10-18T07:00:40","slug":"%e5%9b%bd%e5%9c%9f%e6%95%b0%e5%80%a4%e6%83%85%e5%a0%b1%e3%81%ae%e4%bb%a4%e5%92%8c2%e5%b9%b4%e3%81%ae%e5%8c%bb%e7%99%82%e5%9c%8f%e3%83%87%e3%83%bc%e3%82%bf%e3%81%ae%e6%96%87%e5%ad%97%e5%8c%96%e3%81%91","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=16668","title":{"rendered":"\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u4ee4\u548c2\u5e74\u306e\u533b\u7642\u570f\u30c7\u30fc\u30bf\u306e\u6587\u5b57\u5316\u3051\u304c\u76f4\u3063\u3066\u3044\u305f"},"content":{"rendered":"\n<p>\u3000\u4ee5\u524d\u306e\u6295\u7a3f\uff08<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=13102\" target=\"_blank\" rel=\"noopener\">Shape2SQL \u3067\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092 SQL Server 2008 R2 \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b<\/a>\uff09\u3067\u56fd\u571f\u6570\u5024\u60c5\u5831\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30b5\u30fc\u30d3\u30b9\u306e\u533b\u7642\u570f\u30c7\u30fc\u30bf\u304c\u6587\u5b57\u5316\u3051\u3057\u3066\u3044\u308b\u3068\u8a18\u8ff0\u3057\u305f\uff0e\u6539\u3081\u3066\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066 SQL Server \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u3068\u3053\u308d\uff0c\u3044\u3064\u306e\u9593\u306b\u304b\u6587\u5b57\u5316\u3051\u304c\u76f4\u3063\u3066\u3044\u305f\uff0e\u4ee5\u524d\u306b\u3082\u6cb3\u5ddd\u30c7\u30fc\u30bf\u306e\u6587\u5b57\u5316\u3051\u3092\u6307\u6458\u3057\u305f\u3053\u3068\u304c\u3042\u308b\u304c\uff0c\u3053\u3061\u3089\u3082\u4fee\u6b63\u3055\u308c\u3066\u3044\u305f\uff08<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=15771\" target=\"_blank\" rel=\"noopener\">\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u304c\u4e00\u90e8\u76f4\u3063\u3066\u3044\u305f\u4ef6<\/a>\uff09\uff0e\u3069\u3046\u3084\u3089\u56fd\u571f\u4ea4\u901a\u7701\u306b\u6307\u6458\u3059\u308b\u3068\u4fee\u6b63\u3057\u3066\u304f\u308c\u308b\u3089\u3057\u3044\uff0e<\/p>\n<p><!--more--><\/p>\n<h2>\u56fd\u571f\u6570\u5024\u60c5\u5831\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30b5\u30fc\u30d3\u30b9<\/h2>\n<h3>\u300c\u653f\u7b56\u533a\u57df\u300d\u300c\u884c\u653f\u5730\u57df\u300d\u300c\u533b\u7642\u570f\u300d<\/h3>\n<p>\u3000\u56fd\u571f\u6570\u5024\u60c5\u5831\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30b5\u30fc\u30d3\u30b9\u306e\u300c\u653f\u7b56\u533a\u57df\u300d\u300c\u884c\u653f\u5730\u57df\u300d\u300c\u533b\u7642\u570f\u300d\u306b\u76ee\u7684\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308b\uff0e<\/p>\n<figure id=\"attachment_16669\" aria-describedby=\"caption-attachment-16669\" style=\"width: 525px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/00-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-16669\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/00-2-1024x348.png\" alt=\"\u300c\u653f\u7b56\u533a\u57df\u300d\u300c\u884c\u653f\u5730\u57df\u300d\u300c\u533b\u7642\u570f\u300d\" width=\"525\" height=\"178\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/00-2-1024x348.png 1024w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/00-2-300x102.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/00-2-768x261.png 768w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/00-2.png 1209w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/a><figcaption id=\"caption-attachment-16669\" class=\"wp-caption-text\">\u300c\u653f\u7b56\u533a\u57df\u300d\u300c\u884c\u653f\u5730\u57df\u300d\u300c\u533b\u7642\u570f\u300d<\/figcaption><\/figure>\n<p>\u3000\u5168\u56fd\u306e\u4ee4\u548c2\u5e74\u3092\u9078\u3076\uff0e\u4f8b\u306b\u3088\u3063\u3066\u30a2\u30f3\u30b1\u30fc\u30c8\u304c\u3042\u308b\u306e\u3067\u610f\u898b\u3092\u8a00\u3044\u305f\u3044\u4eba\u306f\u66f8\u304d\u8fbc\u3093\u3067\u304a\u304f\uff0e<\/p>\n<figure id=\"attachment_16670\" aria-describedby=\"caption-attachment-16670\" style=\"width: 525px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/01-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-16670\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/01-2-1024x258.png\" alt=\"\u5168\u56fd\u306e\u4ee4\u548c2\u5e74\u3092\u9078\u3076\" width=\"525\" height=\"132\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/01-2-1024x258.png 1024w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/01-2-300x75.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/01-2-768x193.png 768w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/01-2.png 1236w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/a><figcaption id=\"caption-attachment-16670\" class=\"wp-caption-text\">\u5168\u56fd\u306e\u4ee4\u548c2\u5e74\u3092\u9078\u3076<\/figcaption><\/figure>\n<p>\u3000\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f zip \u30d5\u30a1\u30a4\u30eb\u3092\u5c55\u958b\u3059\u308b\u3068 3GB \u3092\u8d85\u3048\u308b\u30d5\u30a9\u30eb\u30c0\u30fc\u306b\u306a\u308b\uff0e\u4e2d\u8eab\u3092\u8997\u304f\u30683\u7a2e\u985e\u306e Shapefile \u304c\u5b58\u5728\u3059\u308b\u3053\u3068\u304c\u5206\u304b\u308b\uff0e<\/p>\n<h2>Shape2SQL\u3067SQL Server\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9<\/h2>\n<p>\u3000\u3042\u307e\u308a\u671f\u5f85\u305b\u305a\u306b Shape2SQL \u3067 SQL Server \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u307f\u305f\uff0e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u5148\u306f MedicalAreaDB \u3067\u3042\u308b\uff0e<\/p>\n<figure id=\"attachment_16671\" aria-describedby=\"caption-attachment-16671\" style=\"width: 439px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/02-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16671\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/02-2.png\" alt=\"1\u6b21\u533b\u7642\u570f\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\" width=\"439\" height=\"397\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/02-2.png 439w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/02-2-300x271.png 300w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><figcaption id=\"caption-attachment-16671\" class=\"wp-caption-text\">\u4e00\u6b21\u533b\u7642\u570f\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9<\/figcaption><\/figure>\n<p>\u3000SQL Server Management Studio \u304b\u3089\u4e0b\u8a18\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u307f\u305f\uff0e<\/p>\n<pre>SELECT TOP (1) [ID]\n      ,[A38a_001]\n      ,[A38a_002]\n      ,[A38a_003]\n      ,[A38a_004]\n      ,[A38a_005]\n      ,[geog]\n  FROM [MedicalAreaDB].[dbo].[A38-20_1]<\/pre>\n<p>\u3000\u7d50\u679c\u306e\u4e00\u90e8\u3067\u3042\u308b\uff0e<\/p>\n<pre>ID A38a_001 A38a_002 A38a_003 A38a_004 A38a_005 geog<br \/>1 01101 \u4e2d\u592e\u533a 0104 \u672d\u5e4c 1 0xE610000001040E070000806B3470B87F4540ECEFC...<\/pre>\n<p>\u3000\u4f55\u3068\uff0c\u6587\u5b57\u5316\u3051\u3057\u3066\u3044\u306a\u3044\uff01\u7d9a\u3051\u3066\u4e8c\u6b21\u533b\u7642\u570f\uff0c\u4e09\u6b21\u533b\u7642\u570f\u306e\u30c7\u30fc\u30bf\u3082\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u307f\u308b\uff0e<\/p>\n<figure id=\"attachment_16676\" aria-describedby=\"caption-attachment-16676\" style=\"width: 439px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/03-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16676\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/03-2.png\" alt=\"2\u6b21\u533b\u7642\u570f\u306e\u30c7\u30fc\u30bf\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\" width=\"439\" height=\"457\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/03-2.png 439w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/03-2-288x300.png 288w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><figcaption id=\"caption-attachment-16676\" class=\"wp-caption-text\">\u4e8c\u6b21\u533b\u7642\u570f\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9<\/figcaption><\/figure>\n<figure id=\"attachment_16677\" aria-describedby=\"caption-attachment-16677\" style=\"width: 439px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/04-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16677\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/04-2.png\" alt=\"3\u6b21\u533b\u7642\u570f\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\" width=\"439\" height=\"457\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/04-2.png 439w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/04-2-288x300.png 288w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><figcaption id=\"caption-attachment-16677\" class=\"wp-caption-text\">\u4e09\u6b21\u533b\u7642\u570f\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9<\/figcaption><\/figure>\n<h2>\u4e8c\u6b21\u533b\u7642\u570f\uff0c\u4e09\u6b21\u533b\u7642\u570f\u304c\u591a\u3059\u304e\u308b<\/h2>\n<p>\u3000\u6c17\u306b\u306a\u3063\u305f\u306e\u304c\u30d5\u30a1\u30a4\u30eb\u6570\u3067\u3042\u308b\uff0e\u4e00\u6b21\u533b\u7642\u570f\u304c\u7d0411.8\u4e07\u4ef6\u306a\u306e\u306f\u826f\u3044\u3068\u3057\u3066\u3082\uff0c\u4e8c\u6b21\u533b\u7642\u570f\u3068\u4e09\u6b21\u533b\u7642\u570f\u306f\u305d\u308c\u305e\u308c\u7d0411.6\u4e07\u4ef6\uff0e\u7d30\u304b\u3044\u6570\u5b57\u306b\u9055\u3044\u306f\u3042\u308b\u304c\uff0c\u4e8c\u6b21\u533b\u7642\u570f\u3084\u4e09\u6b21\u533b\u7642\u570f\u304c11.6\u4e07\u4ef6\u3082\u3042\u308b\u306e\u306f\u660e\u3089\u304b\u306b\u591a\u3059\u304e\u308b\uff0e<\/p>\n<p>\u3000\u4e8c\u6b21\u533b\u7642\u570f\u306f\u4e00\u6b21\u533b\u7642\u570f\u306e\u4e0a\u4f4d\u306b\u6765\u308b\u3082\u306e\u3067\uff0c\u3055\u3089\u306b\u4e09\u6b21\u533b\u7642\u570f\u306f\u4e8c\u6b21\u533b\u7642\u570f\u306e\u4e0a\u4f4d\u306b\u6765\u308b\u3082\u306e\u3067\u3042\u308b\uff0e\u4e09\u6b21\u533b\u7642\u570f\u3068\u306f\u901a\u5e38\uff0c\u90fd\u9053\u5e9c\u770c\u5358\u4f4d\u3067\u8a2d\u5b9a\u3055\u308c\u308b\u3082\u306e\u3067\u3042\u308b\u304b\u3089\uff0c\u305b\u3044\u305c\u3044\u6570\u5341\u4ef6\u304c\u3044\u3044\u3068\u3053\u308d\u306e\u306f\u305a\u3060\uff0e\u4e8c\u6b21\u533b\u7642\u570f\u306f\u305d\u306e\u9593\u306e\u6841\u6570\u306b\u53ce\u307e\u308b\u306f\u305a\u3067\u3042\u308b\uff0e<\/p>\n<h3>\u4e8c\u6b21\u533b\u7642\u570f\u3054\u3068\u306e\u30c7\u30fc\u30bf\u6570\u3092\u62bd\u51fa<\/h3>\n<p>\u3000\u8a66\u3057\u306b\u4e8c\u6b21\u533b\u7642\u570f\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\uff0c\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u307f\u308b\uff0e\u4e8c\u6b21\u533b\u7642\u570f\u30b3\u30fc\u30c9\u3054\u3068\u306e\u4ef6\u6570\u3092\u62bd\u51fa\u3059\u308b\u3082\u306e\u3067\u3042\u308b\uff0e<\/p>\n<pre>SELECT\tM.A38b_003\n,\tM.A38b_004\n,\tCOUNT(*)\tAS CNT\n  FROM [MedicalAreaDB].[dbo].[A38-20_2]\tAS M\n  GROUP BY\tM.A38b_003, M.A38b_004\n    ORDER\tBY\tCNT DESC<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u901a\u308a\uff0e<\/p>\n<pre>(335 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<p>\u3000\u5168\u4f53\u304c 335 \u4ef6\u3068\u8a00\u3046\u6570\u5b57\u306f\u59a5\u5f53\u306a\u3082\u306e\u3060\u3068\u601d\u3046\uff0e\u3057\u304b\u3057\u7d50\u679c\u30bf\u30d6\u306b\u8868\u793a\u3055\u308c\u308b\u30c8\u30c3\u30d7\u306e\u884c\u306f\u679c\u305f\u3057\u3066\u672c\u5f53\u306a\u306e\u3060\u308d\u3046\u304b\uff0e<\/p>\n<pre>A38b_003\tA38b_004\tCNT\n0409\t\u77f3\u5dfb\u30fb\u767b\u7c73\u30fb\u6c17\u4ed9\u6cbc\t7595<\/pre>\n<p>\u3000\u5f97\u3089\u308c\u305f\u7d50\u679c\u3092 Excel \u306b\u30da\u30fc\u30b9\u30c8\u3057\u3066\u30d4\u30dc\u30c3\u30c8\u30b0\u30e9\u30d5\u306b\u3057\u3066\u307f\u305f\uff0e3\u5206\u306e1\u307b\u3069\u306f\u5358\u4e00\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u306a\u308b\u3053\u3068\u304c\u5206\u304b\u308b\u304c\uff0c\u6b8b\u308a3\u5206\u306e2\u306f\u96e2\u5cf6\u306e\u6570\u3092\u8003\u616e\u3057\u3066\u3082\u59a5\u5f53\u306a\u3082\u306e\u306a\u306e\u3060\u308d\u3046\u304b\uff0e<\/p>\n<figure id=\"attachment_16682\" aria-describedby=\"caption-attachment-16682\" style=\"width: 481px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/05-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16682\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/05-3.png\" alt=\"\u4e8c\u6b21\u533b\u7642\u570f\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u6570\" width=\"481\" height=\"474\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/05-3.png 481w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/05-3-300x296.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/05-3-100x100.png 100w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/><\/a><figcaption id=\"caption-attachment-16682\" class=\"wp-caption-text\">\u4e8c\u6b21\u533b\u7642\u570f\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u6570<\/figcaption><\/figure>\n<h3>\u4e09\u6b21\u533b\u7642\u570f\u3054\u3068\u306e\u30c7\u30fc\u30bf\u6570\u3092\u62bd\u51fa<\/h3>\n<p>\u3000\u3064\u3044\u3067\u306b\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u307f\u3088\u3046\uff0e\u4e09\u6b21\u533b\u7642\u570f\u3054\u3068\u306e\u30c7\u30fc\u30bf\u6570\u3092\u964d\u9806\u3067\u62bd\u51fa\u3059\u308b\u3082\u306e\u3067\u3042\u308b\uff0e<\/p>\n<pre>SELECT [A38c_001]\n      ,[A38c_002]\n      ,COUNT(*)\tAS CNT\n  FROM [MedicalAreaDB].[dbo].[A38-20_3]\tas A\n  GROUP\tBY\tA.A38c_001, A.A38c_002\n  ORDER\tBY\tCNT DESC<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u6b21\u306e\u901a\u308a\uff0e<\/p>\n<pre>(52 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<p>\u3000\u3084\u306f\u308a\u6570\u5341\u4ef6\u3068\u691c\u8a0e\u3092\u3064\u3051\u305f\u6841\u6570\u306f\u6b63\u3057\u3044\uff0e\u30c8\u30c3\u30d7\u306f\u9577\u5d0e\u770c\u306e 9172 \u4ef6\u3067\u3042\u308b\uff0e\u3053\u308c\u306f\u59a5\u5f53\u306a\u6570\u5b57\u304b\u3082\u3057\u308c\u306a\u3044\u304c\uff0c\u4ed6\u306e\u5e9c\u770c\u306e\u6570\u767e\u304b\u3089\u6570\u5343\u306e\u6570\u3082\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u6570\u304c\u672c\u5f53\u306b\u6b63\u3057\u3044\u306e\u304b\uff0c\u78ba\u8a8d\u304c\u5fc5\u8981\u3060\u308d\u3046\uff0e<\/p>\n<pre>A38c_001\tA38c_002\tCNT\n\u9577\u5d0e\u770c\t\t9172\n\u9e7f\u5150\u5cf6\u770c\t\t8075\n\u5ca9\u624b\u770c\t\t8022\n\u5bae\u57ce\u770c\t\t7977\n\u4e09\u91cd\u770c\t\t7432\n\u6771\u4eac\u90fd\t\t5991\n\u6c96\u7e04\u770c\t\t5244\n\u611b\u5a9b\u770c\t\t4931\n\u9ad8\u77e5\u770c\t\t4482\n\u548c\u6b4c\u5c71\u770c\t\t4070\n\u5fb3\u5cf6\u770c\t\t3491\n\u5cf6\u6839\u770c\t\t3440\n\u5c71\u53e3\u770c\t\t2974\n\u5317\u6d77\u9053\t\u9053\u592e\t2942\n\u798f\u4e95\u770c\t\t2930\n\u5317\u6d77\u9053\t\u9053\u5357\t2797\n\u65b0\u6f5f\u770c\t\t2653\n\u79cb\u7530\u770c\t\t2444\n\u5927\u5206\u770c\t\t2328\n\u9752\u68ee\u770c\t\t2195\n\u5175\u5eab\u770c\t\t2126\n\u798f\u5ca1\u770c\t\t1921\n\u718a\u672c\u770c\t\t1917\n\u9759\u5ca1\u770c\t\t1710\n\u5317\u6d77\u9053\t\u91e7\u8def\u30fb\u6839\u5ba4\t1704\n\u77f3\u5ddd\u770c\t\t1675\n\u5bae\u5d0e\u770c\t\t1674\n\u5343\u8449\u770c\t\t1434\n\u795e\u5948\u5ddd\u770c\t\t1224\n\u611b\u77e5\u770c\t\t1054\n\u4eac\u90fd\u5e9c\t\t958\n\u5317\u6d77\u9053\t\u9053\u5317\t952\n\u9ce5\u53d6\u770c\t\t805\n\u9999\u5ddd\u770c\t\t739\n\u5c71\u5f62\u770c\t\t650\n\u5e83\u5cf6\u770c\t\t529\n\u5ca1\u5c71\u770c\t\t384\n\u4f50\u8cc0\u770c\t\t296\n\u8328\u57ce\u770c\t\t179\n\u5317\u6d77\u9053\t\u30aa\u30db\u30fc\u30c4\u30af\t158\n\u5317\u6d77\u9053\t\u5341\u52dd\t130\n\u798f\u5cf6\u770c\t\t126\n\u5927\u962a\u5e9c\t\t53\n\u5bcc\u5c71\u770c\t\t40\n\u57fc\u7389\u770c\t\t2\n\u6803\u6728\u770c\t\t1\n\u7fa4\u99ac\u770c\t\t1\n\u5948\u826f\u770c\t\t1\n\u9577\u91ce\u770c\t\t1\n\u5c90\u961c\u770c\t\t1\n\u5c71\u68a8\u770c\t\t1\n\u6ecb\u8cc0\u770c\t\t1<\/pre>\n<h3>\u4e00\u6b21\u533b\u7642\u570f\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u6d41\u7528\u3057\u3066\u306a\u3044\u304b\uff1f<\/h3>\n<p>\u3000\u4e00\u3064\u306e\u4eee\u8aac\u3060\u304c\uff0c\u4e00\u6b21\u533b\u7642\u570f\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u305d\u306e\u307e\u307e\u4e8c\u6b21\u533b\u7642\u570f\u306b\u6d41\u7528\u3057\u305f\u3068\u306f\u8003\u3048\u3089\u308c\u306a\u3044\u3060\u308d\u3046\u304b\uff0e\u3057\u304b\u3057\u3053\u308c\u3092\u691c\u8a3c\u3059\u308b\u306b\u306f STEquals() \u30e1\u30bd\u30c3\u30c9\u3092\u5168\u884c\u306b\u5bfe\u3057\u3066\u5b9f\u884c\u3057\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\uff0e\u76f4\u7a4d\u3067 11.6 \u4e07\u00d7 11.6 \u4e07\u56de\uff08\u7d04 13.5 \u5104\u56de\uff09\u3068\u306f\uff0c\u6c17\u306e\u9060\u304f\u306a\u308b\u3088\u3046\u306a\u6642\u9593\u304c\u304b\u304b\u308b\u3068\u4e88\u60f3\u3055\u308c\u308b\uff0e<\/p>\n<p>\u3000\u4eee\u306b\u305d\u306e\u4eee\u8aac\u304c\u6b63\u3057\u3044\u3068\u4eee\u5b9a\u3059\u308b\u3068\uff0cQGIS \u3067\u878d\u5408\uff08\u30c7\u30a3\u30be\u30eb\u30d6\uff09\u3067\u304d\u308b\u3060\u308d\u3046\uff0e\u30de\u30eb\u30c1\u30dd\u30ea\u30b4\u30f3\u3092\u8a31\u53ef\u3059\u308c\u3070\u96e2\u5cf6\u3084\u98db\u3073\u5730\u3082\u8868\u73fe\u3067\u304d\u308b\u3060\u308d\u3046\uff0e\u3084\u3063\u3066\u307f\u308b\u4fa1\u5024\u306f\u3042\u308a\u305d\u3046\u3060\uff0e<\/p>\n<p>\u3000\u3057\u304b\u3057\uff0c\u3067\u3042\u308b\uff0e\u4e8c\u6b21\u533b\u7642\u570f\u30c6\u30fc\u30d6\u30eb\u306f\u9762\u7a4d\u3068\u4eba\u53e3\u3082\u5c5e\u6027\u306b\u542b\u3093\u3067\u304a\u308a\uff0c\u3053\u308c\u3089\u304c\u98df\u3044\u9055\u3046\u3068\u30c7\u30fc\u30bf\u306b\u9f5f\u9f6c\u3092\u6765\u3059\u53ef\u80fd\u6027\u304c\u3042\u308b\uff0e\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u4ef6\u6570\u3092\u78ba\u8a8d\u3059\u308b\uff0e<\/p>\n<pre>SELECT       COUNT(*)\tAS CNT\n  FROM [MedicalAreaDB].[dbo].[A38-20_2]\tAS M\n  GROUP BY\tM.A38b_001, M.A38b_002, M.A38b_003, M.A38b_004, M.A38b_005,\tM.A38b_006,\tM.A38b_007,\tM.A38b_008,\tM.A38b_009,\tM.A38b_010,\tM.A38b_011<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u6b21\u306e\u901a\u308a\uff0e<\/p>\n<pre>(335 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<p>\u3000\u554f\u984c\u306a\u3055\u305d\u3046\u3067\u3042\u308b\uff0e\u5c5e\u6027\u306b\u306f\u91cd\u8907\u304c\u3042\u308a\uff0c\u7570\u306a\u308b\u306e\u306f POLYGON \u30c7\u30fc\u30bf\u3060\u3051\u306e\u3088\u3046\u3060\uff0e<\/p>\n<h2>QGIS\u3067\u878d\u5408\uff08\u30c7\u30a3\u30be\u30eb\u30d6\uff09\u3092\u5b9f\u884c\u3059\u308b<\/h2>\n<p>\u3000<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=15837\" target=\"_blank\" rel=\"noopener\">\u56fd\u571f\u5730\u7406\u9662\u306e\u5730\u7403\u5730\u56f3\u65e5\u672c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u304b\u3089\u90fd\u9053\u5e9c\u770c\u306e\u30dd\u30ea\u30b4\u30f3\u30c7\u30fc\u30bf\u3092QGIS\u3067\u4f5c\u6210\u3059\u308b<\/a>\u3067\u8ff0\u3079\u305f\u3088\u3046\u306b\uff0cQGIS \u3067\u300c\u30d9\u30af\u30bf\u300d\u300c\u7a7a\u9593\u6f14\u7b97\u30c4\u30fc\u30eb\u300d\u300c\u878d\u5408\u300d\u3068\u9032\u3080\u3068\u30dd\u30ea\u30b4\u30f3\u3092\u878d\u5408\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u308b\uff0e<\/p>\n<p>\u3000QGIS \u3067\u4e8c\u6b21\u533b\u7642\u570f\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304d\uff0c\u4e0b\u56f3\u306e\u3088\u3046\u306b\u8a2d\u5b9a\u3059\u308b\uff0e\u8a73\u7d30\u30d1\u30e9\u30e1\u30fc\u30bf\u306f\u6307\u5b9a\u3057\u306a\u3044\uff0e<\/p>\n<figure id=\"attachment_16692\" aria-describedby=\"caption-attachment-16692\" style=\"width: 690px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/10-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16692\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/10-1.png\" alt=\"QGIS\u3067\u300c\u30d9\u30af\u30bf\u300d\u300c\u6f14\u7b97\u30c4\u30fc\u30eb\u300d\u300c\u878d\u5408\u300d\u3092\u9078\u3076\" width=\"690\" height=\"555\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/10-1.png 690w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/10-1-300x241.png 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/a><figcaption id=\"caption-attachment-16692\" class=\"wp-caption-text\">QGIS\u3067\u300c\u30d9\u30af\u30bf\u300d\u300c\u7a7a\u9593\u6f14\u7b97\u30c4\u30fc\u30eb\u300d\u300c\u878d\u5408\u300d\u3092\u9078\u3076<\/figcaption><\/figure>\n<p>\u3000\u300c\u57fa\u6e96\u3068\u306a\u308b\u5c5e\u6027\u300d\u306b\u306f\u4e8c\u6b21\u533b\u7642\u570f\u30b3\u30fc\u30c9\u3092\u793a\u3059\u5217\u3092\u6307\u5b9a\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_16694\" aria-describedby=\"caption-attachment-16694\" style=\"width: 690px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/11-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16694\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/11-1.png\" alt=\"\u4e8c\u6b21\u533b\u7642\u570f\u30b3\u30fc\u30c9\u3067\u96c6\u7d04\u3059\u308b\" width=\"690\" height=\"555\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/11-1.png 690w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/11-1-300x241.png 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/a><figcaption id=\"caption-attachment-16694\" class=\"wp-caption-text\">\u4e8c\u6b21\u533b\u7642\u570f\u30b3\u30fc\u30c9\u3067\u96c6\u7d04\u3059\u308b<\/figcaption><\/figure>\n<p>\u3000\u5b9f\u884c\u3059\u308b\u3068\u5c5e\u6027\u30c6\u30fc\u30d6\u30eb\u306e\u884c\u6570\u304c 335 \u4ef6\u3068\u306a\u308b\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\u4e0b\u56f3\u3092\u53c2\u8003\u306b\u878d\u5408\u3057\u3066\u3067\u304d\u305f\u30ec\u30a4\u30e4\u3092\u4fdd\u5b58\u3059\u308b\uff0e\u30d5\u30a1\u30a4\u30eb\u540d\u3092 T_MedicalArea2 \u3068\u3057\u3066\u3044\u308b\uff0e<\/p>\n<figure id=\"attachment_16695\" aria-describedby=\"caption-attachment-16695\" style=\"width: 593px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/13-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16695\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/13-1.png\" alt=\"\u300c\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u300d\u300c\u65b0\u898f\u30d5\u30a1\u30a4\u30eb\u306b\u5730\u7269\u3092\u4fdd\u5b58\u300d\" width=\"593\" height=\"664\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/13-1.png 593w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/10\/13-1-268x300.png 268w\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/a><figcaption id=\"caption-attachment-16695\" class=\"wp-caption-text\">\u300c\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u300d\u300c\u65b0\u898f\u30d5\u30a1\u30a4\u30eb\u306b\u5730\u7269\u3092\u4fdd\u5b58\u300d<\/figcaption><\/figure>\n<h2>SQL Server \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9<\/h2>\n<p>\u3000Shape2SQL \u3067 SQL Server \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u307f\u308b\uff0e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u306b\u306f\u7570\u69d8\u306b\u6642\u9593\u304c\u304b\u304b\u308b\uff0e<\/p>\n<h3>NumRings() \u30e1\u30bd\u30c3\u30c9\u3067\u30b8\u30aa\u30e1\u30c8\u30ea\u306e\u30ea\u30f3\u30b0\u6570\u3092\u78ba\u8a8d\u3059\u308b<\/h3>\n<p>\u3000NumRings() \u30e1\u30bd\u30c3\u30c9\u306f geography \u578b\u306e Polygon \u306e\u30ea\u30f3\u30b0\u306e\u7dcf\u6570\u3092\u6c42\u3081\u305f\u3044\u6642\u306b\u4f7f\u3046\uff0e\u5916\u90e8\u30ea\u30f3\u30b0\u3068\u5185\u90e8\u30ea\u30f3\u30b0\u3092\u533a\u5225\u3057\u306a\u3044\uff0e\u30c6\u30fc\u30d6\u30eb A38-20_2 \u3068\u30c6\u30fc\u30d6\u30eb T_MedicalArea2 \u3068\u306b\u5bfe\u3057\u3066\u305d\u308c\u305e\u308c\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\uff0e<\/p>\n<pre>SELECT\tSUM(A.geog.NumRings())\n  FROM\tdbo.[A38-20_2]\tAS A\nSELECT\tSUM(T.geog.NumRings())\n  FROM\tdbo.[T_MedicalArea2]\tAS T<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u6b21\u306e\u901a\u308a\uff0e<\/p>\n<pre>(1 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n\u8b66\u544a: NULL \u5024\u306f\u96c6\u8a08\u307e\u305f\u306f\u305d\u306e\u4ed6\u306e SET \u6f14\u7b97\u3067\u524a\u9664\u3055\u308c\u307e\u3057\u305f\u3002\n(1 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(\u5217\u540d\u306a\u3057)\n116408\n(\u5217\u540d\u306a\u3057)\n135<\/pre>\n<p>\u3000\u4e21\u8005\u306e\u7d50\u679c\u306f\u7b49\u3057\u3044\u3068\u4e88\u60f3\u3057\u3066\u3044\u305f\u304c\uff0c\u4e88\u60f3\u5916\u306e\u7d50\u679c\u3068\u306a\u3063\u305f\uff0e\u30c6\u30fc\u30d6\u30eb T_MedicalArea2 \u3067\u306f\u307b\u3068\u3093\u3069\u306e\u884c\u3067 NumRings() \u30e1\u30bd\u30c3\u30c9\u306e\u8fd4\u308a\u5024\u304c NULL \u3068\u306a\u308a\uff0c\u307e\u305f\u5c5e\u6027\u304c\u6587\u5b57\u5316\u3051\u3057\u305f\uff0e\u5f8c\u3067\u308f\u304b\u3063\u305f\u306e\u3060\u304c\uff0cNumRIngs() \u30e1\u30bd\u30c3\u30c9\u306f\u30de\u30eb\u30c1\u30dd\u30ea\u30b4\u30f3\u306b\u9069\u7528\u3055\u308c\u308b\u3068 NULL \u3092\u8fd4\u3059\u4ed5\u69d8\u3068\u306a\u3063\u3066\u3044\u308b\uff0e\u305d\u308c\u3067\u3082\u30c6\u30fc\u30d6\u30eb A38-20_2 \u3067\u306f\u30ea\u30f3\u30b0\u306e\u7dcf\u6570 (116408) \u306f\u5168\u884c\u6570 (116365) \u3088\u308a\u82e5\u5e72\u5c11\u306a\u304f\u306a\u3063\u305f\uff0e<\/p>\n<h2>\u5e73\u621026\u5e74\u306e\u533b\u7642\u570f\u306e\u30c7\u30fc\u30bf\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b<\/h2>\n<p>\u3000\u6b21\u306e\u65b9\u91dd\u3082\u7acb\u305f\u306a\u3044\u305f\u3081\uff0c\u5e73\u621026\u5e74\u306e\u533b\u7642\u570f\u306e\u30c7\u30fc\u30bf\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066 SQL Server \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u307f\u305f\uff0e\u3053\u3061\u3089\u306e\u5c5e\u6027\u306f\u6587\u5b57\u5316\u3051\u3057\u3066\u3044\u305f\uff0e\u3069\u3046\u3084\u3089\u3053\u306e\u30d6\u30ed\u30b0\u3067\u6307\u6458\u3057\u305f\u30c7\u30fc\u30bf\u3060\u3051\u3092\u4fee\u6b63\u3057\u3066\u3044\u308b\u3088\u3046\u3067\u3042\u308b\uff0e\u4f55\u3068\u3044\u3046\u304b\uff0c\u6b8b\u5ff5\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u3068\u308a\u3042\u3048\u305a\uff0c\u30c6\u30fc\u30d6\u30eb\u306e\u5168\u884c\u6570\u306f\u5206\u304b\u308b\u306e\u3067\u63b2\u8f09\u3057\u3066\u304a\u304f\uff0e<\/p>\n<table>\n<tbody>\n<tr>\n<th>\u00a0<\/th>\n<th>\u5e73\u621026\u5e74<\/th>\n<th>\u4ee4\u548c2\u5e74<\/th>\n<\/tr>\n<tr>\n<th>\u4e00\u6b21\u533b\u7642\u570f<\/th>\n<td>73041<\/td>\n<td>118119<\/td>\n<\/tr>\n<tr>\n<th>\u4e8c\u6b21\u533b\u7642\u570f<\/th>\n<td>71308<\/td>\n<td>116365<\/td>\n<\/tr>\n<tr>\n<th>\u4e09\u6b21\u533b\u7642\u570f<\/th>\n<td>70983<\/td>\n<td>116037<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u3000\u4e0b\u8868\u306f NumRIng() \u30e1\u30bd\u30c3\u30c9\u306e\u7d50\u679c\u306e\u5408\u8a08\u3067\u3042\u308b\uff0e<\/p>\n<table style=\"width: 100%; height: 108px;\">\n<tbody>\n<tr style=\"height: 27px;\">\n<th style=\"height: 27px;\">\u00a0<\/th>\n<th style=\"height: 27px;\">\u5e73\u621026\u5e74<\/th>\n<th style=\"height: 27px;\">\u4ee4\u548c2\u5e74<\/th>\n<\/tr>\n<tr style=\"height: 27px;\">\n<th style=\"height: 27px;\">\u4e00\u6b21\u533b\u7642\u570f<\/th>\n<td style=\"height: 27px;\">73175<\/td>\n<td style=\"height: 27px;\">118282<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<th style=\"height: 27px;\">\u4e8c\u6b21\u533b\u7642\u570f<\/th>\n<td style=\"height: 27px;\">71331<\/td>\n<td style=\"height: 27px;\">116408<\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<th style=\"height: 27px;\">\u4e09\u6b21\u533b\u7642\u570f<\/th>\n<td style=\"height: 27px;\">70985<\/td>\n<td style=\"height: 27px;\">116056<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>csv\u30d5\u30a1\u30a4\u30eb\u3067SQL Server\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3066\u307f\u308b<\/h2>\n<p>\u3000\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u304c\u99c4\u76ee\u306a\u3089 csv \u30d5\u30a1\u30a4\u30eb\u306f\u3069\u3046\u3060\u308d\u3046\u304b\uff0e\u4e0b\u56f3\u306e\u8a2d\u5b9a\u3067\u878d\u5408\u3057\u305f335\u4ef6\u306e\u30de\u30eb\u30c1\u30dd\u30ea\u30b4\u30f3\u3092 csv \u30d5\u30a1\u30a4\u30eb\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\uff0cSQL Server \u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3066\u307f\u305f\uff0e<\/p>\n<ul>\n<li>\u300c\u5f62\u5f0f\u300d\u3092\u300c\u30ab\u30f3\u30de\u3067\u533a\u5207\u3089\u308c\u305f\u5024\u300d\u3068\u3059\u308b<\/li>\n<li>\u300c\u5ea7\u6a19\u53c2\u7167\u7cfb\u300d\u3092EPSG: 4326 \u3068\u3059\u308b<\/li>\n<li>\u300c\u6587\u5b57\u30b3\u30fc\u30c9\u300d\u3092Shift_JIS \u3068\u3059\u308b<\/li>\n<li>\u300c\u30b8\u30aa\u30e1\u30c8\u30ea\u300d\u3092\u30dd\u30ea\u30b4\u30f3\u3068\u3057\uff0c\u300c\u30de\u30eb\u30c1\u30bf\u30a4\u30d7\u306b\u3059\u308b\u300d\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/li>\n<li>\u30ec\u30a4\u30e4\u30aa\u30d7\u30b7\u30e7\u30f3\u3067 GEOMETRY \u3092 AS_WKT \u3068\u3059\u308b<\/li>\n<li>LINEFORMAT \u3092 CRLF \u3068\u3059\u308b<\/li>\n<li>SEPASRATOR \u3092 TAB \u3068\u3059\u308b<\/li>\n<li>STRING_QUOTED \u3092 ALWAYS \u3068\u3059\u308b\uff08\u5f8c\u306b\u30e1\u30e2\u5e33\u3067\u524a\u9664\u3059\u308b\uff09<\/li>\n<\/ul>\n<figure id=\"attachment_16716\" aria-describedby=\"caption-attachment-16716\" style=\"width: 593px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/27.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16716\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/27.png\" alt=\"\u540d\u524d\u3092\u3064\u3051\u3066\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u4fdd\u5b58\" width=\"593\" height=\"664\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/27.png 593w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/27-268x300.png 268w\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/a><figcaption id=\"caption-attachment-16716\" class=\"wp-caption-text\">\u540d\u524d\u3092\u3064\u3051\u3066\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u4fdd\u5b58<\/figcaption><\/figure>\n<p>\u3000SQL Server \u306e\u30a6\u30a3\u30b6\u30fc\u30c9\u3067\u306f WKT \u306eDataType \u3092\u30c6\u30ad\u30b9\u30c8\u30b9\u30c8\u30ea\u30fc\u30e0\u306b\u3059\u308b\u306a\u3069\u5de5\u592b\u304c\u3044\u308b\uff0e<\/p>\n<figure id=\"attachment_16719\" aria-describedby=\"caption-attachment-16719\" style=\"width: 634px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/25.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16719\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/25.png\" alt=\"WKT\u306eDataType\u3092\u30c6\u30ad\u30b9\u30c8\u30b9\u30c8\u30ea\u30fc\u30e0\u306b\u3059\u308b\" width=\"634\" height=\"556\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/25.png 634w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/25-300x263.png 300w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/a><figcaption id=\"caption-attachment-16719\" class=\"wp-caption-text\">WKT\u306eDataType\u3092\u30c6\u30ad\u30b9\u30c8\u30b9\u30c8\u30ea\u30fc\u30e0\u306b\u3059\u308b<\/figcaption><\/figure>\n<p>\u3000\u3057\u304b\u3057\uff0cSQL Server \u306e\u30a6\u30a3\u30b6\u30fc\u30c9\u3067\u4e0b\u56f3\u306e\u3088\u3046\u306a\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\uff0e<\/p>\n<figure id=\"attachment_16717\" aria-describedby=\"caption-attachment-16717\" style=\"width: 607px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/28.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16717\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/28.png\" alt=\"\u6307\u5b9a\u3057\u305f\u30d8\u30c3\u30c0\u30fc\u307e\u305f\u306f\u30c7\u30fc\u30bf\u306e\u884c\u533a\u5207\u308a\u8a18\u53f7&quot;{CR}{LF}&quot;\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\uff0e\" width=\"607\" height=\"165\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/28.png 607w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/28-300x82.png 300w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/a><figcaption id=\"caption-attachment-16717\" class=\"wp-caption-text\">\u6307\u5b9a\u3057\u305f\u30d8\u30c3\u30c0\u30fc\u307e\u305f\u306f\u30c7\u30fc\u30bf\u306e\u884c\u533a\u5207\u308a\u8a18\u53f7&#8221;{CR}{LF}&#8221;\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\uff0e<\/figcaption><\/figure>\n<p>\u3000\u69cb\u308f\u305a\u306b\u9032\u3081\u3066\u3044\u304f\uff0e<\/p>\n<figure id=\"attachment_16718\" aria-describedby=\"caption-attachment-16718\" style=\"width: 595px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/29.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16718\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/29.png\" alt=\"\u5217\u30de\u30c3\u30d4\u30f3\u30b0\" width=\"595\" height=\"579\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/29.png 595w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/29-300x292.png 300w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/><\/a><figcaption id=\"caption-attachment-16718\" class=\"wp-caption-text\">\u5217\u30de\u30c3\u30d4\u30f3\u30b0<\/figcaption><\/figure>\n<p>\u3000\u6700\u7d42\u7684\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3067\u304d\u305f\u884c\u306f7\u884c\u3060\u3051\u3067\u3042\u3063\u305f\uff0e<\/p>\n<figure id=\"attachment_16720\" aria-describedby=\"caption-attachment-16720\" style=\"width: 634px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/26.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-16720\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/26.png\" alt=\"\u6700\u7d42\u7684\u306b\u8ee2\u9001\u3067\u304d\u305f\u306e\u306f7\u884c\u306e\u307f\" width=\"634\" height=\"556\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/26.png 634w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/26-300x263.png 300w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/a><figcaption id=\"caption-attachment-16720\" class=\"wp-caption-text\">\u6700\u7d42\u7684\u306b\u8ee2\u9001\u3067\u304d\u305f\u306e\u306f7\u884c\u306e\u307f<\/figcaption><\/figure>\n<p>\u3000\u78ba\u8a8d\u306e\u610f\u5473\u3067\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\uff0e<\/p>\n<pre>SELECT\tLEN([WKT])\n      ,[A38b_001]\n      ,[A38b_002]\n      ,[A38b_003]\n      ,[A38b_004]\n      ,[A38b_005]\n      ,[A38b_006]\n      ,[A38b_007]\n      ,[A38b_008]\n      ,[A38b_009]\n      ,[A38b_010]\n      ,[A38b_011]\n  FROM [MedicalAreaDB].[dbo].[T_MEDICALAREA2]<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u901a\u308a\uff0e\u5168\u6ec5\u3068\u8a00\u3063\u3066\u3044\u3044\u7d50\u679c\u3067\u3042\u308b\uff0e<\/p>\n<pre>(\u5217\u540d\u306a\u3057)\tA38b_001\tA38b_002\tA38b_003\tA38b_004\tA38b_005\tA38b_006\tA38b_007\tA38b_008\tA38b_009\tA38b_010\tA38b_011\n863462\t30201,30202,30304\t\u548c\u6b4c\u5c71\u5e02,\u6d77\u5357\u5e02,\u7d00\u7f8e\u91ce\u753a\t3001\t\u548c\u6b4c\u5c71\t438.24000000000\t438.25000000000\t425220\t425900\t49352\t243383\t133165\n769402\t30205,30381,30382,30383,30390,30392\t\u5fa1\u574a\u5e02,\u7f8e\u6d5c\u753a,\u65e5\u9ad8\u753a,\u7531\u826f\u753a,\u5370\u5357\u753a,\u65e5\u9ad8\u5ddd\u753a\t3005\t\u5fa1\u574a\t579.02000000000\t579.02000000000\t63603\t61675\t7088\t33859\t20728\n950155\t30204,30361,30362,30366\t\u6709\u7530\u5e02,\u6e6f\u6d45\u753a,\u5e83\u5ddd\u753a,\u6709\u7530\u5ddd\u753a\t3004\t\u6709\u7530\t474.86000000000\t474.79000000000\t74255\t72830\t8353\t40242\t24235\n115824\t30203,30341,30343,30344\t\u6a4b\u672c\u5e02,\u304b\u3064\u3089\u304e\u753a,\u4e5d\u5ea6\u5c71\u753a,\u9ad8\u91ce\u753a\t3003\t\u6a4b\u672c\t463.42000000000\t463.42000000000\t88342\t86150\t9271\t47182\t29697\n92423\t30208,30209\t\u7d00\u306e\u5ddd\u5e02,\u5ca9\u51fa\u5e02\t3002\t\u90a3\u8cc0\t266.72000000000\t266.72000000000\t116068\t115807\t14392\t69103\t32312\n296071\t05204,05209,05303\t\u5927\u9928\u5e02,\u9e7f\u89d2\u5e02,\u5c0f\u5742\u753a\t0501\t\u5927\u9928\u30fb\u9e7f\u89d2\t1822.00000000000\t1822.44000000000\t111552\t106969\t10261\t54953\t41755\n5300406\t\t\t\t\t\t\t\t\t\t\t<\/pre>\n<h2>\u4e8c\u6b21\u533b\u7642\u570f\u306e\u30e1\u30bf\u30c7\u30fc\u30bf<\/h2>\n<table>\n<tbody>\n<tr>\n<th>shp\u5c5e\u6027\u540d<\/th>\n<th>\u5c5e\u6027\u540d<\/th>\n<th>\u8aac\u660e<\/th>\n<\/tr>\n<tr>\n<td>A38b_001<\/td>\n<td>\u884c\u653f\u533a\u57df\u30b3\u30fc\u30c9<\/td>\n<td>\u5f53\u8a72\u4e8c\u6b21\u533b\u7642\u570f\u3092\u69cb\u6210\u3059\u308b\u5e02\u533a\u753a\u6751\u306e<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><\/td>\n<\/tr>\n<tr>\n<td>A38b_002<\/td>\n<td>\u5e02\u533a\u753a\u6751\u540d<\/td>\n<td>\u5f53\u8a72\u4e8c\u6b21\u533b\u7642\u570f\u3092\u69cb\u6210\u3059\u308b\u5e02\u533a\u753a\u6751\u306e\u540d\u79f0<\/td>\n<\/tr>\n<tr>\n<td>A38b_003<\/td>\n<td>\u4e8c\u6b21\u533b\u7642\u570f\u30b3\u30fc\u30c9<\/td>\n<td>\u5f53\u8a72\u4e8c\u6b21\u533b\u7642\u570f\u3092\u793a\u3059\u4e00\u610f\u306e\u30b3\u30fc\u30c9<\/td>\n<\/tr>\n<tr>\n<td>A38b_004<\/td>\n<td>\u4e8c\u6b21\u533b\u7642\u570f\u540d<\/td>\n<td>\u5f53\u8a72\u4e8c\u6b21\u533b\u7642\u570f\u306e\u540d\u79f0<\/td>\n<\/tr>\n<tr>\n<td>A38b_005<\/td>\n<td>\u9762\u7a4d\uff08\u533b\u7642\u8a08\u753b\uff09<\/td>\n<td>\u90fd\u9053\u5e9c\u770c\u304c\u5b9a\u3081\u305f\u5730\u57df\u4fdd\u5065\u533b\u7642\u8a08\u753b\u306b\u63b2\u8f09\u3055\u308c\u3066\u3044\u308b\u9762\u7a4d\uff08\u33a1\uff09<\/td>\n<\/tr>\n<tr>\n<td>A38b_006<\/td>\n<td>\u9762\u7a4d\uff08\u56fd\u571f\u5730\u7406\u9662\uff09<\/td>\n<td>\u56fd\u571f\u5730\u7406\u9662\u304c\u300c\u5168\u56fd\u90fd\u9053\u5e9c\u770c\u5e02\u533a\u753a\u6751\u5225\u9762\u7a4d\u8abf\u300d\u3068\u3057\u3066\u516c\u8868\u3057\u3066\u3044\u308b\u5e02\u533a\u753a\u6751\u5225\u306e\u9762\u7a4d\u3092\u3001\u69cb\u6210\u3059\u308b\u5e02\u533a\u753a\u6751\u306b\u3064\u3044\u3066\u5408\u8a08\u3057\u305f\u9762\u7a4d\uff08\u33a1\uff09<\/td>\n<\/tr>\n<tr>\n<td>A38b_007<\/td>\n<td>\u4eba\u53e3\uff08\u533b\u7642\u8a08\u753b\uff09<\/td>\n<td>\u90fd\u9053\u5e9c\u770c\u304c\u5b9a\u3081\u305f\u5730\u57df\u4fdd\u5065\u533b\u7642\u8a08\u753b\u306b\u63b2\u8f09\u3055\u308c\u3066\u3044\u308b\u4eba\u53e3\uff08\u4eba\uff09<\/td>\n<\/tr>\n<tr>\n<td>A38b_008<\/td>\n<td>\u7dcf\u4eba\u53e3\uff08\u4f4f\u6c11\u57fa\u672c\u53f0\u5e33<\/td>\n<td>\u7dcf\u52d9\u7701\u304c\u300c\u4f4f\u6c11\u57fa\u672c\u53f0\u5e33\u306b\u57fa\u3065\u304f\u4eba\u53e3\u3001\u4eba\u53e3\u52d5\u614b\u53ca\u3073\u4e16\u5e2f\u6570\u300d\u3068\u3057\u3066\u516c\u8868\u3057\u3066\u3044\u308b\u5e02\u533a\u753a\u6751\u5225\u30fb\u5e74\u9f62\u5225\u306e\u7dcf\u4eba\u53e3\u3092\u3001\u69cb\u6210\u3059\u308b\u5e02\u533a\u753a\u6751\u306b\u3064\u3044\u3066\u5408\u8a08\u3057\u305f\u3082\u306e\uff08\u4eba\uff09<\/td>\n<\/tr>\n<tr>\n<td>A38b_009<\/td>\n<td>\u4eba\u53e3\uff0815\u624d\u672a\u6e80\uff09\uff08\u4f4f\u6c11\u57fa\u672c\u53f0\u5e33\uff09<\/td>\n<td>\u7dcf\u52d9\u7701\u304c\u300c\u4f4f\u6c11\u57fa\u672c\u53f0\u5e33\u306b\u57fa\u3065\u304f\u4eba\u53e3\u3001\u4eba\u53e3\u52d5\u614b\u53ca\u3073\u4e16\u5e2f\u6570\u300d\u3068\u3057\u3066\u516c\u8868\u3057\u3066\u3044\u308b\u5e02\u533a\u753a\u6751\u5225\u30fb\u5e74\u9f62\u5225\u306e15\u624d\u672a\u6e80\u4eba\u53e3\u3092\u3001\u69cb\u6210\u3059\u308b\u5e02\u533a\u753a\u6751\u306b\u3064\u3044\u3066\u5408\u8a08\u3057\u305f\u3082\u306e\uff08\u4eba\uff09<\/td>\n<\/tr>\n<tr>\n<td>A38b_010<\/td>\n<td>\u4eba\u53e3\uff0815\u624d\u4ee5\u4e0a65\u624d\u672a\u6e80\uff09\uff08\u4f4f\u6c11\u57fa\u672c\u53f0\u5e33\uff09<\/td>\n<td>\u7dcf\u52d9\u7701\u304c\u300c\u4f4f\u6c11\u57fa\u672c\u53f0\u5e33\u306b\u57fa\u3065\u304f\u4eba\u53e3\u3001\u4eba\u53e3\u52d5\u614b\u53ca\u3073\u4e16\u5e2f\u6570\u300d\u3068\u3057\u3066\u516c\u8868\u3057\u3066\u3044\u308b\u5e02\u533a\u753a\u6751\u5225\u30fb\u5e74\u9f62\u5225\u306e15\u624d\u4ee5\u4e0a65\u624d\u672a\u6e80\u4eba\u53e3\u3092\u3001\u69cb\u6210\u3059\u308b\u5e02\u533a\u753a\u6751\u306b\u3064\u3044\u3066\u5408\u8a08\u3057\u305f\u3082\u306e\uff08\u4eba\uff09<\/td>\n<\/tr>\n<tr>\n<td>A38b_011<\/td>\n<td>\u4eba\u53e3\uff0865\u624d\u4ee5\u4e0a\uff09\uff08\u4f4f\u6c11\u57fa\u672c\u53f0\u5e33\uff09<\/td>\n<td>\u7dcf\u52d9\u7701\u304c\u300c\u4f4f\u6c11\u57fa\u672c\u53f0\u5e33\u306b\u57fa\u3065\u304f\u4eba\u53e3\u3001\u4eba\u53e3\u52d5\u614b\u53ca\u3073\u4e16\u5e2f\u6570\u300d\u3068\u3057\u3066\u516c\u8868\u3057\u3066\u3044\u308b\u5e02\u533a\u753a\u6751\u5225\u30fb\u5e74\u9f62\u5225\u306e65\u624d\u4ee5\u4e0a\u4eba\u53e3\u3092\u3001\u69cb\u6210\u3059\u308b\u5e02\u533a\u753a\u6751\u306b\u3064\u3044\u3066\u5408\u8a08\u3057\u305f\u3082\u306e\uff08\u4eba\uff09<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>\u3000\u4ee4\u548c2\u5e74\uff082020\u5e74\uff09\u304a\u3088\u3073\u5e73\u621025\u5e74\uff082014\u5e74\uff09\u306e\u533b\u7642\u570f\u306e\u30c7\u30fc\u30bf\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066 SQL Server \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\uff0e<\/p>\n<p>\u3000\u4ee4\u548c2\u5e74\u306e\u5c5e\u6027\u306e\u6587\u5b57\u5316\u3051\u306f\u76f4\u3063\u3066\u3044\u305f\u304c\uff0c\u5e73\u621026\u5e74\u306e\u5c5e\u6027\u306e\u6587\u5b57\u5316\u3051\u306f\u76f4\u3063\u3066\u3044\u306a\u304b\u3063\u305f\uff0e<\/p>\n<p>\u3000\u4e8c\u6b21\u533b\u7642\u570f\u304a\u3088\u3073\u4e09\u6b21\u533b\u7642\u570f\u306e\u884c\u6570\u306f\u660e\u3089\u304b\u306b\u591a\u3059\u304e\u308b\u3068\u601d\u308f\u308c\u305f\uff0e\u4e8c\u6b21\u533b\u7642\u570f\u306e\u5c5e\u6027\u306b\u306f\u91cd\u8907\u304c\u3042\u308a\uff0c\u7570\u306a\u308b\u306e\u306f\u30dd\u30ea\u30b4\u30f3\u30c7\u30fc\u30bf\u3067\u3042\u3063\u305f\uff0e\u305d\u306e\u305f\u3081\u4e8c\u6b21\u533b\u7642\u570f\u306f 335 \u884c\u306b\uff0c\u4e09\u6b21\u533b\u7642\u6a29\u306f 52 \u884c\u306b\u96c6\u7d04\u3067\u304d\u305d\u3046\u3060\u3063\u305f\u305f\u3081\uff0cQGIS \u3067\u30dd\u30ea\u30b4\u30f3\u3092\u878d\u5408\u3057\u305f\uff0e\u3057\u304b\u3057\u305d\u306e\u7d50\u679c\uff0c\u5c5e\u6027\u304c\u6587\u5b57\u5316\u3051\u3057\uff0c\u30dd\u30ea\u30b4\u30f3\u306e\u6570\u3092\u6570\u3048\u308b NumRing() \u30e1\u30bd\u30c3\u30c9\u306e\u8fd4\u308a\u5024\u304c NULL \u306b\u306a\u308b\u306a\u3069\u60aa\u5f71\u97ff\u304c\u898b\u3089\u308c\u305f\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3000\u4ee5\u524d\u306e\u6295\u7a3f\uff08Shape2SQL \u3067\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092 SQL Server 2008 R2 \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\uff09\u3067\u56fd\u571f\u6570\u5024\u60c5\u5831\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30b5\u30fc\u30d3\u30b9\u306e\u533b\u7642\u570f\u30c7\u30fc\u30bf\u304c\u6587\u5b57\u5316\u3051\u3057\u3066\u3044\u308b\u3068\u8a18\u8ff0\u3057\u305f\uff0e\u6539\u3081\u3066\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066 SQ &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=16668\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u4ee4\u548c2\u5e74\u306e\u533b\u7642\u570f\u30c7\u30fc\u30bf\u306e\u6587\u5b57\u5316\u3051\u304c\u76f4\u3063\u3066\u3044\u305f&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/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":[6391,265,4673,7587,6390,1030,467,12410,4644,4674,7727,9177,4672,7669,2740,2750,12537,6389,1801,6739,2783,9114,2684,12111,4749,9194,12899,7238,9123,5982,5981,7247,12892,333,9137,12112,7245,12895,3634,12726,7240,12109,12897,1782,12896,4439,12898,12900],"class_list":["post-16668","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-by","tag-excel","tag-from","tag-geography","tag-group","tag-group-by","tag-null","tag-numrings-2","tag-order","tag-order-by","tag-polygon","tag-qgis","tag-select","tag-shape2sql","tag-sql-server","tag-sql-server-management-studio","tag-stequals","tag-sum","tag-1801","tag-6739","tag-2783","tag-9114","tag-2684","tag-12111","tag-4749","tag-9194","tag-12899","tag-7238","tag-9123","tag-5982","tag-5981","tag-7247","tag-12892","tag-333","tag-9137","tag-12112","tag-7245","tag-12895","tag-3634","tag-12726","tag-7240","tag-12109","tag-12897","tag-1782","tag-12896","tag-4439","tag-12898","tag-12900"],"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/16668","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=16668"}],"version-history":[{"count":42,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/16668\/revisions"}],"predecessor-version":[{"id":16842,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/16668\/revisions\/16842"}],"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=16668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}