{"id":11193,"date":"2020-06-11T06:00:00","date_gmt":"2020-06-10T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=11193"},"modified":"2020-12-18T15:39:06","modified_gmt":"2020-12-18T06:39:06","slug":"%e7%ac%ac-6-%e7%ab%a0%e3%80%80%e7%a9%ba%e9%96%93%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e3%82%a4%e3%83%b3%e3%83%9d%e3%83%bc%e3%83%88%e3%81%99%e3%82%8b-beginning-spatial-with-sql-server-2008","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=11193","title":{"rendered":"\u7b2c 6 \u7ae0\u3000\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b (Beginning Spatial with SQL Server 2008)"},"content":{"rendered":"\n<p>\u3000\u591a\u304f\u306e\u7a7a\u9593\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u30ab\u30b9\u30bf\u30e0\u5b9a\u7fa9\u306e\u7a7a\u9593\u6a5f\u80fd\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u3044\u308b\uff0e\u4f8b\u3048\u3070\u9867\u5ba2\u30bb\u30c3\u30c8\u306e\u5c40\u5728\u3068\uff0c\u5e83\u304f\u53d7\u3051\u5165\u308c\u3089\u308c\u305f\u8868\u73fe\u306e\u7a7a\u9593\u30c7\u30fc\u30bf\uff0c\u5730\u7403\u4e0a\u306e\u6c4e\u7528\u6027\u306e\u3042\u308b\u7279\u5fb4\uff0c\u4f8b\u3048\u3070\u56fd\u3084\u5dde\u306e\u5883\u754c\u7dda\uff0c\u4e16\u754c\u306e\u4e3b\u8981\u90fd\u5e02\u306e\u5c40\u5728\u304a\u3088\u3073\u4e3b\u8981\u306a\u9053\u8def\u3084\u9244\u9053\u306e\u7d4c\u8def\u306a\u3069\u3067\u3042\u308b\uff0e\u3053\u306e\u60c5\u5831\u306f\u81ea\u5206\u81ea\u8eab\u3067\u4f5c\u6210\u3059\u308b\u3088\u308a\u3082\uff0c\u591a\u304f\u306e\u4ee3\u66ff\u53ef\u80fd\u306a\u8cc7\u6e90\u304c\u5b58\u5728\u3057\u3066\u304a\u308a\uff0c\u305d\u3053\u304b\u3089\u666e\u901a\u306b\u4f7f\u3046\u305f\u3081\u306e\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u7a7a\u9593\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u642d\u8f09\u3067\u304d\u308b\uff0e<\/p>\n<p>\u3000\u672c\u7ae0\u3067\u306f\uff0c\u305d\u3053\u304b\u3089\u4e00\u822c\u516c\u958b\u3055\u308c\u305f\u7a7a\u9593\u60c5\u5831\u3092\u53d6\u5f97\u3067\u304d\u308b\u8cc7\u6e90\uff0c\u305d\u3053\u3067\u305d\u306e\u30c7\u30fc\u30bf\u304c\u666e\u901a\u306b\u63d0\u4f9b\u3055\u308c\u308b\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u304a\u3088\u3073\u305d\u306e\u60c5\u5831\u3092 SQL Server \u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u306e\u306b\u4f7f\u3048\u308b\u6280\u8853\u3092\u7d39\u4ecb\u3057\u3088\u3046\uff0e<\/p>\n<p><!--more--><\/p>\n<h3>\u7a7a\u9593\u30c7\u30fc\u30bf\u306e\u8cc7\u6e90<\/h3>\n<p>\u3000\u7a7a\u9593\u30c7\u30fc\u30bf\u8cc7\u6e90\u306f\u8c4a\u5bcc\u306b\u5b58\u5728\u3057\uff0c\u6559\u80b2\u6a5f\u95a2\u3084\u653f\u5e9c\u6a5f\u95a2\u3068\u540c\u69d8\uff0c\u3055\u307e\u3056\u307e\u306a\u5546\u7528\u30c7\u30fc\u30bf\u30d9\u30f3\u30c0\u30fc\u304b\u3089\u3082\u53d6\u5f97\u3067\u304d\uff0c\u7121\u6599\u3067\u60c5\u5831\u3092\u5229\u7528\u53ef\u80fd\u3067\u3042\u308b\uff0eTable 6-1 \u306b\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u7121\u6599\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\u5c11\u6570\u306e\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u8cc7\u6e90\u306e\u8a73\u7d30\u3092\u793a\u3059\uff0e<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\"><caption>Table 6-1. \u7121\u6599\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\u7a7a\u9593\u60c5\u5831\u8cc7\u6e90<\/caption>\n<tbody>\n<tr>\n<th style=\"width: 30%;\">\u8cc7\u6e90<\/th>\n<th style=\"width: 70%;\">\u8a73\u7d30<\/th>\n<\/tr>\n<tr>\n<td style=\"width: 30%;\"><a href=\"https:\/\/www.census.gov\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.census.gov\/<\/a><\/td>\n<td style=\"width: 70%;\">\u7c73\u56fd\u56fd\u52e2\u8abf\u67fb\u5c40\u5730\u7406\u5b66\u90e8\u306f\u9ad8\u54c1\u8cea\u306e\u7a7a\u9593\u60c5\u5831\u3092\u4fdd\u6709\u3057\u3066\u304a\u308a\uff0c\u305d\u308c\u306b\u306f\u5730\u540d\u8f9e\u5178\uff0c\u90f5\u4fbf\u756a\u53f7\u96c6\u8a08\u30a8\u30ea\u30a2 (ZCTAs), TIGER \u9053\u8def\u30fb\u6cb3\u5ddd\u30fb\u9244\u9053\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304a\u3088\u3073\u4ed6\u306e\u591a\u304f\u306e\u5730\u7406\u7684\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u3092\u5305\u62ec\u3057\u3066\u3044\u308b\uff08\u5408\u8846\u56fd\u9650\u5b9a\uff09\uff0e<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 30%;\"><a href=\"http:\/\/geodata.grid.unep.ch\/\" target=\"_blank\" rel=\"noopener\">http:\/\/geodata.grid.unep.ch\/<\/a><\/td>\n<td style=\"width: 70%;\">\u56fd\u9023\u5730\u7406\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\u306f\u5730\u7403\uff0c\u56fd\u5bb6\uff0c\u5730\u57df\u304a\u3088\u3073\u6e96\u5730\u57df\u7d71\u8a08\u304a\u3088\u3073\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u542b\u307f\uff0c\u305d\u308c\u3089\u3092\u30ab\u30d0\u30fc\u3059\u308b\u30c6\u30fc\u30de\uff0c\u3064\u307e\u308a\u6de1\u6c34\uff0c\u4eba\u53e3\uff0c\u68ee\u6797\uff0c\u6392\u51fa\uff0c\u6c17\u5019\uff0c\u707d\u5bb3\uff0c\u5065\u5eb7\u304a\u3088\u3073 GDP \u3068\u3057\u3066\u30ab\u30d0\u30fc\u3059\u308b\uff0e<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 30%;\">http:\/\/biogeo.berkeley.edu\/gadm\/<\/td>\n<td style=\"width: 70%;\">\u30b0\u30ed\u30fc\u30d0\u30eb\u884c\u653f\u533a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 (GADM) \u306f\u56fd\u5883\u7dda\uff0c\u5dde\uff0c\u56fd\u5bb6\u304a\u3088\u3073\u5168\u4e16\u754c\u3092\u30ab\u30d0\u30fc\u3059\u308b\u306e\u3068\u540c\u7b49\u306e 1 \u500b\u306e ZIP \u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u4fdd\u6709\u3057\u3066\u304a\u308a\uff0c\u30d0\u30fc\u30af\u30ec\u30a4\u306e\u30ab\u30ea\u30d5\u30a9\u30eb\u30cb\u30a2\u5927\u5b66\u304c\u904b\u55b6\u3057\u3066\u3044\u308b\uff0e<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 30%;\"><a href=\"https:\/\/geonames.nga.mil\/gns\/html\/\" target=\"_blank\" rel=\"noopener\">http:\/\/earth-info.nga.mil\/gns\/html\/<\/a><\/td>\n<td style=\"width: 70%;\">\u30a2\u30e1\u30ea\u30ab\u56fd\u5bb6\u5730\u7406\u7a7a\u9593\u60c5\u5831\u5c40 (NGA) \u306e GEOnet \u30cd\u30fc\u30e0\u30b5\u30fc\u30d0\u30fc (GNS) \u306f\u5168\u3066\u306e\u5916\u56fd\u306e\u5730\u540d\u306e\u516c\u7684\u30ea\u30dd\u30b8\u30c8\u30ea\u3067\u3042\u308a\uff0c\u5c40\u5728\uff0c\u884c\u653f\u533a\u5206\u304a\u3088\u3073\u54c1\u8cea\u306b\u95a2\u3059\u308b\u60c5\u5831\u3092\u4fdd\u6709\u3059\u308b\uff0e<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 30%;\">http:\/\/geodata.gov\/wps\/portal\/gos<\/td>\n<td style=\"width: 70%;\">\u5408\u8846\u56fd\u653f\u5e9c\u300e\u5730\u7406\u7a7a\u9593\u30ef\u30f3\u30b9\u30c8\u30c3\u30d7\u300f\u5730\u7406\u30c7\u30fc\u30bf\u30a6\u30a7\u30d6\u30da\u30fc\u30b8\u306f\u5206\u985e\u3055\u308c\u305f\u30ea\u30f3\u30af\u3092\u4fdd\u6709\u3057\uff0c\u69d8\u3005\u306a\u8cc7\u6e90\u306f\u751f\u614b\u5b66\uff0c\u5730\u8cea\u5b66\uff0c\u5065\u5eb7\uff0c\u4ea4\u901a\u624b\u6bb5\u304a\u3088\u3073\u4eba\u53e3\u7d71\u8a08\u306b\u95a2\u3057\u3066\u5730\u57df\u3092\u30ab\u30d0\u30fc\u3059\u308b\uff0e<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u3000\u7b2c 4 \u7ae0\u3067\u793a\u3057\u305f\u3088\u3046\u306b\uff0cSQL Server 2008 \u306e\u9759\u7684\u7a7a\u9593\u30e1\u30bd\u30c3\u30c9\u306f\u305d\u308c\u305e\u308c\uff0cWKT \u8868\u73fe\u304b\u3089\u3067\u3082 WKB \u8868\u73fe\u304b\u3089\u3067\u3082 GML \u8868\u73fe\u304b\u3089\u3067\u3082\u540c\u6642\u306b\u4e00\u3064\u306e\u7a7a\u9593\u30c7\u30fc\u30bf\u306e\u30a2\u30a4\u30c6\u30e0\u3092\u751f\u6210\u3067\u304d\u308b\u3060\u3051\u3067\u3042\u308b\uff0e\u3057\u304b\u3057\uff0cTable 6-1 \u306b\u5217\u6319\u3057\u305f\u3088\u3046\u306a\u7a7a\u9593\u30c7\u30fc\u30bf\u8cc7\u6e90\u306f\u3055\u307e\u3056\u307e\u306a\u4ed6\u306e\u7a2e\u985e\u306e\u7a7a\u9593\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u84c4\u7a4d\u3057\u3066\u3044\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\uff0c\u4f55\u5343\u3082\u306e\u4e00\u500b\u4e00\u500b\u306e\u30a2\u30a4\u30c6\u30e0\u3092\u4e00\u3064\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u8a18\u8ff0\u3057\u3066\u3044\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\uff0e\u3086\u3048\u306b\uff0c\u9759\u7684\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u3044\u3066\u306f\uff0c\u305d\u308c\u3089\u306e\u8cc7\u6e90\u304b\u3089\u76f4\u63a5 geography \u30c7\u30fc\u30bf\u3084 geometry \u30c7\u30fc\u30bf\u3092\u751f\u6210\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u306a\u3044\uff0e<\/p>\n<p>\u3000\u672c\u7ae0\u306e\u6b8b\u308a\u3067\uff0c\u5229\u7528\u53ef\u80fd\u306a\u3044\u304f\u3064\u304b\u306e\u4e00\u822c\u7684\u306a\u7a7a\u9593\u30c7\u30fc\u30bf\u306e\u4ee3\u66ff\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u3064\u3044\u3066\u8b70\u8ad6\u3057\uff0c\u3053\u306e\u30c7\u30fc\u30bf\u3092 SQL Server 2008 \u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u306e\u306b\u4f7f\u3048\u308b\u6280\u8853\u3092\u8aac\u660e\u3059\u308b\uff0e<\/p>\n<h3>\u8868\u5f62\u5f0f\u306e\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/h3>\n<p>\u3000\u9593\u9055\u3044\u306a\u304f\u7a7a\u9593\u30c7\u30fc\u30bf\u3067\u306f\u306a\u3044\u304c\uff0c\u3082\u3063\u3068\u3082\u8c4a\u5bcc\u306a\uff08\u305d\u3057\u3066\u3082\u3063\u3068\u3082\u7c21\u7d20\u306a\uff09\u7121\u6599\u3067\u5229\u7528\u53ef\u80fd\u3067\u4e00\u822c\u306b\u5834\u6240\u306e\u540d\u524d\u304b\u3089\u53d6\u5f97\u3055\u308c\u308b\u5730\u7406\u60c5\u5831\u306e\u8cc7\u6e90\u3068\u306f\uff0c\u5404\u5834\u6240\u306e\u4f4d\u7f6e\u3092\u8a18\u8ff0\u3057\u305f\u4e00\u7d44\u306e\u7def\u5ea6\u3068\u7d4c\u5ea6\u5ea7\u6a19\u3067\u3042\u308b\uff0e\u3053\u308c\u3089\u306e\u8cc7\u6e90\u306f\u95a2\u9023\u3059\u308b\u4ed6\u306e\u60c5\u5831\uff0c\u3064\u307e\u308a\u4eba\u53e3\u3084\u7d4c\u6e08\u6307\u6570\u306e\u5217\u3092\u4fdd\u6709\u3057\u3066\u3044\u308b\u53ef\u80fd\u6027\u3082\u3042\u308b\uff0e\u3053\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u8868\u73fe\u3055\u308c\u305f\u60c5\u5831\u306f\u4e00\u822c\u306b\u300c\u5730\u540d\u8f9e\u5178\u300d\u3068\u3057\u3066\u77e5\u3089\u308c\u3066\u304a\u308a\uff0c\u6e2c\u5730\u60c5\u5831\u306e\u8f9e\u66f8\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u4eee\u306b\u5730\u7406\u6642\u70b9\u306e\u3088\u3046\u306a\u7def\u5ea6\u3068\u7d4c\u5ea6\uff08\u307e\u305f\u306f\u6295\u5f71\u5ea7\u6a19\u7cfb\u304b\u3089\u306e\u5317\u5ea7\u6a19\u3068\u6771\u5ea7\u6a19\uff09\u3092\u542b\u3080\u30c7\u30fc\u30bf\u306e\u69cb\u9020\u5316\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u7a7a\u9593\u60c5\u5831\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\u3044\u306a\u3089\uff0c\u4e00\u3064\u306e\u9759\u7684\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3063\u3066 geography \u578b\u304b geometry \u578b\u306e Point \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u751f\u6210\u3067\u304d\uff0c\u305d\u308c\u306f\u30c7\u30fc\u30bf\u306e\u5404\u30a2\u30a4\u30c6\u30e0\u3092\u8868\u73fe\u3057\u305f\u5ea7\u6a19\u5024\u306b\u57fa\u3065\u3044\u3066\u3044\u308b\uff0e\u3053\u308c\u306b\u306f\u6b21\u306e\u30b9\u30c6\u30c3\u30d7\u304c\u95a2\u4e0e\u3057\u3066\u3044\u308b\uff0e<\/p>\n<ol>\n<li>SQL Server 2008 \u306e\u63d0\u4f9b\u3059\u308b\u30d0\u30eb\u30af\u30a4\u30f3\u30dd\u30fc\u30c8\u30e1\u30bd\u30c3\u30c9\u306e\u4e00\u3064\u3092\u4f7f\u3063\u3066\u69cb\u9020\u5316\u30c7\u30fc\u30bf\u3092\u65b0\u898f\u30c6\u30fc\u30d6\u30eb\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\uff0e\u3064\u307e\u308a\uff0cOPENROWSET \u304a\u3088\u3073 BULK INSERT T-SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\uff0cBCP \u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3\u3042\u308b\u3044\u306f\u30a4\u30f3\u30dd\u30fc\u30c8\u30fb\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u30a6\u30a3\u30b6\u30fc\u30c9\u3067\u3042\u308b\uff0e<\/li>\n<li>ALTER TABLE \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u4f7f\u3063\u3066\u30c6\u30fc\u30d6\u30eb\u306b\u65b0\u3057\u3044 geography \u578b\u307e\u305f\u306f geometry \u578b\u306e\u5217\u3092\u8ffd\u52a0\u3057\uff0c\u7531\u6765\u3059\u308b\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u4fdd\u6301\u3059\u308b\uff0e<\/li>\n<li>T-SQL \u306e UPDATE \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u9759\u7684\u30e1\u30bd\u30c3\u30c9\u3068\u5171\u306b\u4f7f\u3063\u3066\u65b0\u3057\u3044\u5217\u306b\u6295\u5165\u3059\u308b\uff0e\u305d\u308c\u306f\u30a4\u30f3\u30dd\u30fc\u30c8\u3055\u308c\u305f\u30c7\u30fc\u30bf\u5185\u306e\u5217\u306e\u5ea7\u6a19\u5024\u306b\u57fa\u3065\u3044\u3066\u3044\u308b\uff0e<\/li>\n<\/ol>\n<p>\u3000\u3053\u306e\u30a2\u30d7\u30ed\u30fc\u30c1\u3092\u8aac\u660e\u3059\u308b\u305f\u3081\uff0c\u30a2\u30e1\u30ea\u30ab\u5730\u8cea\u8abf\u67fb\u6240 (USGS) \u306e\u63d0\u4f9b\u3059\u308b\u5730\u9707\u30c7\u30fc\u30bf\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u3063\u3066\u4f8b\u3092\u793a\u3057\u305f\u3044\uff0eUSGS \u306f\u7121\u6599\u3067\u5229\u7528\u53ef\u80fd\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u6570\u591a\u304f\u4f5c\u6210\u3057\u3066\u304a\u308a\uff0c\u30a6\u30a7\u30d6\u30b5\u30a4\u30c8 <a href=\"https:\/\/www.usgs.gov\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.usgs.gov<\/a> \u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\uff0e\u305d\u306e\u4e00\u3064\u306b\u76f4\u8fd1 7 \u65e5\u9593\u306e\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u4e16\u754c\u898f\u6a21\u306e\u5730\u9707\u306e\u30ea\u30b9\u30c8\u304c\u3042\u308a\uff0chttp:\/\/earthquake.usgs.gov\/eqcenter\/catalogs\/eqs7day-M1.txt \u306e\u30ea\u30f3\u30af\u304b\u3089\u76f4\u63a5\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\uff0e\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u306f\u30b3\u30f3\u30de\u533a\u5207\u308a\u306e\u30c7\u30fc\u30bf\u30ea\u30b9\u30c8\u3067\u3042\u308a\uff0c\u5404\u5730\u9707\u306e\u3055\u307e\u3056\u307e\u306a\u5c5e\u6027\u3092\u5217\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u4fdd\u6709\u3057\u3066\u304a\u308a\uff0c\u5185\u5bb9\u306f Table 6-2 \u306b\u5217\u6319\u3057\u3066\u8a18\u8ff0\u3057\u3066\u3042\u308b\uff0e<\/p>\n<table style=\"border-collapse: collapse; width: 100%; height: 253px;\"><caption>Table 6-2. eqs7day-M1.txt \u30d5\u30a1\u30a4\u30eb\u306e\u30c7\u30fc\u30bf\u5217<\/caption>\n<tbody>\n<tr style=\"height: 23px;\">\n<th style=\"width: 20%; height: 23px;\">\u5217<\/th>\n<th style=\"width: 80%; height: 23px;\">\u8a73\u7d30<\/th>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 20%; height: 23px;\">Src<\/td>\n<td style=\"width: 80%; height: 23px;\">\u30c7\u30fc\u30bf\u306b\u8ca2\u732e\u3059\u308b\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u8cc7\u6e90\u306e\u8b58\u5225\u5b50\uff0c\uff12\u6587\u5b57<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 20%; height: 23px;\">Eqid<\/td>\n<td style=\"width: 80%; height: 23px;\">\u3053\u306e\u5730\u9707\u306e\u4e00\u610f\u306e\u8b58\u5225\u5b50<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 20%; height: 23px;\">Version<\/td>\n<td style=\"width: 80%; height: 23px;\">\u30d0\u30fc\u30b8\u30e7\u30f3\u756a\u53f7<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 20%; height: 23px;\">Datetime<\/td>\n<td style=\"width: 80%; height: 23px;\">\u8a18\u9332\u306e\u767a\u751f\u3057\u305f\u65e5\u306e\u6587\u5b57\u5217<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 20%; height: 23px;\">Lat<\/td>\n<td style=\"width: 80%; height: 23px;\">\u9707\u6e90\u5730\u306e\u7def\u5ea6\uff0cEPSG:4326 \u7a7a\u9593\u53c2\u7167\u7cfb\u3067\u8a18\u8ff0<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 20%; height: 23px;\">Lon<\/td>\n<td style=\"width: 80%; height: 23px;\">\u9707\u6e90\u5730\u306e\u7d4c\u5ea6\uff0cEPSG:4326 \u7a7a\u9593\u53c2\u7167\u7cfb\u3067\u8a18\u8ff0<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 20%; height: 23px;\">Magnitude<\/td>\n<td style=\"width: 80%; height: 23px;\">\u5730\u9707\u306e\u30de\u30b0\u30cb\u30c1\u30e5\u30fc\u30c9\uff0c\u5404\u89b3\u6e2c\u6240\u3067\u8a08\u6e2c\u3057\u305f\u5730\u9707\u6ce2\u3067\u6c7a\u5b9a\u3055\u308c\u308b<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 20%; height: 23px;\">Depth<\/td>\n<td style=\"width: 80%; height: 23px;\">\u9707\u6e90\u5730\u306e\u6df1\u3055\uff0c\u30ad\u30ed\u30e1\u30fc\u30c8\u30eb\u3067\u6e2c\u5b9a<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 20%; height: 23px;\">NST<\/td>\n<td style=\"width: 80%; height: 23px;\">\u5831\u544a\u3057\u305f\u89b3\u6e2c\u6240\u306e\u6570<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 20%; height: 23px;\">Region<\/td>\n<td style=\"width: 80%; height: 23px;\">\u5730\u9707\u306e\u767a\u751f\u3057\u305f\u5730\u57df\u3092\u8a18\u8ff0\u3057\u305f\u6587\u5b57\u5217<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u3000\u3053\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u306b\u306f\u6b21\u306e\u30b9\u30c6\u30c3\u30d7\u306b\u5f93\u3046\uff0e<\/p>\n<ol>\n<li>\u30a6\u30a7\u30d6\u30d6\u30e9\u30a6\u30b6\u3092\u958b\u304d\uff0c\u30a2\u30c9\u30ec\u30b9\u30d0\u30fc\u306b\u6b21\u306e\u3088\u3046\u306b URL \u3092\u30bf\u30a4\u30d7\u3059\u308b\uff1ahttp:\/\/earthquake.usgs.gov\/eqcenter\/catalogs\/eqs7day-M1.txt. Figure 6-1 \u306b\u4f8b\u793a\u3059\u3088\u3046\u306b\u30d6\u30e9\u30a6\u30b6\u306f\u6700\u65b0\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u3092\u8868\u793a\u3059\u308b\uff0e<\/li>\n<li>\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u5834\u6240\u306b\u4fdd\u5b58\u3059\u308b\uff0e\u300c\u30d5\u30a1\u30a4\u30eb\u300d\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u300c\u4fdd\u5b58\u300d\uff08\u307e\u305f\u306f\u300c\u30da\u30fc\u30b8\u3092\u4fdd\u5b58\u300d\uff0e\u30d6\u30e9\u30a6\u30b6\u306e\u7a2e\u985e\u306b\u3088\u308b\uff09\uff0e\u540d\u524d\u3068\u5834\u6240\u3092\u4fc3\u3055\u308c\u308b\uff0e\u3053\u306e\u4f8b\u3067\u306f\u30d5\u30a1\u30a4\u30eb\u540d\u3092 eqs7day-M1.txt, \u4fdd\u5b58\u5834\u6240\u3092 C:\\Spatial \u30d5\u30a9\u30eb\u30c0\u30fc\u3068\u60f3\u5b9a\u3057\u3066\u3044\u308b\uff0e<\/li>\n<\/ol>\n<p>\u6ce8\u8a18\u3000eqs7day-M1.txt \u30d5\u30a1\u30a4\u30eb\u306f\u76f4\u8fd1\u306e 7 \u65e5\u9593\u306e\u30c7\u30fc\u30bf\u3067\u5e38\u306b\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u305f\u3081\uff0c\u5b9f\u969b\u306e\u5185\u5bb9\u306f\u672c\u7ae0\u3067\u8aac\u660e\u3057\u305f\u3082\u306e\u3068\u306f\u7570\u306a\u308b\uff0e<\/p>\n<h4>\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/h4>\n<p>\u3000SQL Server 2008 \u306b\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u65b9\u6cd5\u306f\u6570\u591a\u304f\u5b58\u5728\u3059\u308b\uff0e\u3053\u306e\u4f8b\u3067\u306f\u30a4\u30f3\u30dd\u30fc\u30c8\u30fb\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u4f7f\u3044\uff0c\u30c7\u30fc\u30bf\u3092\u8cc7\u6e90\u304b\u3089\u76ee\u6a19\u306b\u5411\u304b\u3063\u3066\u79fb\u52d5\u3057\uff0c\u7c21\u6f54\u306a\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u4e00\u3064\u305a\u3064\u751f\u6210\u3057\u3066\u3082\u3089\u3046\u3053\u3068\u306b\u3059\u308b\uff0e\u305d\u306e\u30b9\u30c6\u30c3\u30d7\u306f\u6b21\u306e\u901a\u308a\u3067\u3042\u308b\uff0e<\/p>\n<ol>\n<li>SQL Server Management Studio \u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u30fc\u30da\u30a4\u30f3\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30bf\u30b9\u30af\u300d\u3092\u9078\u629e\u3057\u300c\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u300d\u3068\u9032\u3080\uff0e<\/li>\n<li>\u30a4\u30f3\u30dd\u30fc\u30c8\u30fb\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u30a6\u30a3\u30b6\u30fc\u30c9\u304c\u958b\u304f\uff0e\u300c\u6b21\u3078\u300d\u3092\u30af\u30ea\u30c3\u30af\uff0e<\/li>\n<li>\u30a6\u30a3\u30b6\u30fc\u30c9\u306e\u6700\u521d\u306e\u30da\u30fc\u30b8\u306f\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u9078\u629e\u3059\u308b\u3088\u3046\u4fc3\u3057\u3066\u304f\u308b\uff0e\u30b9\u30af\u30ea\u30fc\u30f3\u6700\u4e0a\u90e8\u306b\u3042\u308b\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u300d\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u30ea\u30b9\u30c8\u304b\u3089 Flat File Source \u3092\u9078\u629e\u3059\u308b\uff0e<\/li>\n<li>\u30d6\u30e9\u30a6\u30ba\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u5148\u306b\u4fdd\u5b58\u3057\u3066\u304a\u3044\u305f eqs7day-M1.txt \u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3078\u3068\u30ca\u30d3\u30b2\u30fc\u30c8\u3059\u308b\uff0eOpen \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/li>\n<li>\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u63a5\u7d9a\u306e\u305f\u3081\u306e Text Qualifier \u30d5\u30a3\u30fc\u30eb\u30c9\u306f none \u306b\u30bb\u30c3\u30c8\u3055\u308c\u3066\u3044\u308b\uff0eeqs-7day-M1.tst \u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u5185\u90e8\u306e\u6587\u5b57\u5217\u306f\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u3067\u56f2\u307e\u308c\u3066\u304a\u308a\uff0c\u3053\u306e\u5024\u3092\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57 (&#8220;) \u306b\u5909\u66f4\u3059\u308b\uff0e<\/li>\n<li>eqs-7day-M1.txt \u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u306b\u306f\u30d8\u30c3\u30c0\u30fc\u884c\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u305f\u3081\uff0c\u6700\u521d\u306e\u30c7\u30fc\u30bf\u884c\u3092\u5217\u540d\u306b\u3059\u308b\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u308b\uff0e<\/li>\n<li>\u30da\u30a4\u30f3\u5de6\u5074\u306e\u8a73\u7d30\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e\u5404\u5217\u3092\u9806\u756a\u306b\u30af\u30ea\u30c3\u30af\u3057\uff0c\u53f3\u5074\u306e\u5c5e\u6027\u30da\u30a4\u30f3\u304b\u3089\uff0c\u30c7\u30fc\u30bf\u578b\u306e\u5024\u3092\u4fee\u6b63\u3057\uff0c\u5024\u306b\u9069\u5408\u3059\u308b\u3088\u3046\u306b OutputColumnWidth \u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u4fee\u6b63\u3059\u308b\uff0eTable 6-3 \u306b\u793a\u3059\uff0e<\/li>\n<li>\u9069\u5207\u306a\u5909\u66f4\u3092\u52a0\u3048\u305f\u306a\u3089\uff0c\u6b21\u3078\u306e\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e\u30a6\u30a3\u30b6\u30fc\u30c9\u306f\u76ee\u6a19\u3092\u9078\u629e\u3059\u308b\u3088\u3046\u306b\u4fc3\u3057\u3066\u304f\u308b\uff0e<\/li>\n<li>SQL Server 2008 \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8a73\u7d30\u3092\u5165\u529b\u3057\uff0c\u6b21\u3078\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/li>\n<li>\u30a6\u30a3\u30b6\u30fc\u30c9\u306f\u30bd\u30fc\u30b9\u3068\u306a\u308b\u30c6\u30fc\u30d6\u30eb\u3068\u30d3\u30e5\u30fc\u3092\u9078\u629e\u3059\u308b\u3088\u3046\u4fc3\u3057\u3066\u304f\u308b\uff0e\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u30a6\u30a3\u30b6\u30fc\u30c9\u306f\u81ea\u52d5\u7684\u306b\u76ee\u6a19\u30c6\u30fc\u30d6\u30eb\u3092\u65b0\u898f\u4f5c\u6210\u3057\uff0c\u305d\u306e\u540d\u524d\u306f eqs7day-M1 \u3068\u306a\u308b\u305f\u3081\uff0c\u6b21\u3078\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/li>\n<li>\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u4fdd\u5b58\u3057\u3066\u5b9f\u884c\u3059\u308b\u30b9\u30af\u30ea\u30fc\u30f3\u3067\uff0c\u5b8c\u4e86\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff08\u4eee\u306b SQL Server 2008 Express, Web \u3042\u308b\u3044\u306f Workgroup Edition \u3092\u4f7f\u3063\u3066\u3044\u308b\u306a\u3089\uff0c\u3053\u306e\u30b9\u30af\u30ea\u30fc\u30f3\u306f\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u5b9f\u884c\u3059\u308b\u3068\u306a\u3063\u3066\u3044\u308b\uff09\uff0e\u30d1\u30c3\u30b1\u30fc\u30b8\u306e\u8981\u7d04\u304c\u51fa\u73fe\u3057\uff0c\u8a73\u7d30\u3092\u78ba\u8a8d\u3059\u308b\u3088\u3046\u4fc3\u3055\u308c\u308b\uff0e<\/li>\n<li>\u5b8c\u4e86\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u5b9f\u884c\u3059\u308b\uff0e<\/li>\n<\/ol>\n<p>\u6ce8\u8a18\u3000SQL Server 2008 Express, Web \u307e\u305f\u306f Workgroup Edition \u3067\u306f\u30a4\u30f3\u30dd\u30fc\u30c8\u30fb\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u4f7f\u3063\u3066\u5373\u5ea7\u306b\u5b9f\u884c\u3059\u308b\u3060\u3051\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u4f5c\u6210\u3067\u304d\u308b\uff0e\u30a6\u30a3\u30b6\u30fc\u30c9\u306b\u3088\u308a\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u4fdd\u5b58\u3059\u308b\u306b\u306f\uff0cSQL Server Standard, Developer \u3042\u308b\u3044\u306f Enterprise Edition \u3092\u4f7f\u308f\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\uff0e<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\"><caption>Table 6-3. USGS \u5730\u9707\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u63a5\u7d9a\u306e\u305f\u3081\u306e\u5217\u306e\u5c5e\u6027<\/caption>\n<tbody>\n<tr>\n<th style=\"width: 20%;\">\u540d\u524d<\/th>\n<th style=\"width: 40%;\">\u30c7\u30fc\u30bf\u578b<\/th>\n<th style=\"width: 40%;\">OutputColumnWidth<\/th>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">Src<\/td>\n<td style=\"width: 40%;\">string [DT_STR]<\/td>\n<td style=\"width: 40%;\">2<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">Eqid<\/td>\n<td style=\"width: 40%;\">string [DT_STR]<\/td>\n<td style=\"width: 40%;\">8<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">Version<\/td>\n<td style=\"width: 40%;\">string [DT_STR]<\/td>\n<td style=\"width: 40%;\">1<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">Datetime<\/td>\n<td style=\"width: 40%;\">string [DT_STR]<\/td>\n<td style=\"width: 40%;\">50<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">Lat<\/td>\n<td style=\"width: 40%;\">double-precision float [DT_R8]<\/td>\n<td style=\"width: 40%;\">\u00a0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">Lon<\/td>\n<td style=\"width: 40%;\">double-precision float [DT_R8]<\/td>\n<td style=\"width: 40%;\">\u00a0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">Magnitude<\/td>\n<td style=\"width: 40%;\">float [DT_R8]<\/td>\n<td style=\"width: 40%;\">\u00a0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">Depth<\/td>\n<td style=\"width: 40%;\">float [DT_R4]<\/td>\n<td style=\"width: 40%;\">\u00a0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">NST<\/td>\n<td style=\"width: 40%;\">two-byte signed integer [DT_I2]<\/td>\n<td style=\"width: 40%;\">\u00a0<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\">Region<\/td>\n<td style=\"width: 40%;\">string [DT_STR]<\/td>\n<td style=\"width: 40%;\">\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u3000\u5b9f\u884c\u304c\u6210\u529f\u3057\uff0c\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u76ee\u6a19\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3055\u308c\u305f\u884c\u6570\u304c\u8a18\u8ff0\u3055\u308c\u3066\u3044\u308b\u306e\u3092\u77e5\u3089\u305b\u308b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u53d7\u3051\u53d6\u308b\u3060\u308d\u3046\uff0e\u3067\u306f\uff0c\u9589\u3058\u308b\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u9589\u3058\u3088\u3046\uff0e<\/p>\n<p>\u3000\u6211\u3005\u306e\u65b0\u3057\u3044\u30c6\u30fc\u30d6\u30eb\u306e\u4e2d\u8eab\u3092\u898b\u3066\u307f\u3088\u3046\uff0e\u65b0\u3057\u3044\u30af\u30a8\u30ea\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u958b\u304d\uff0c\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u767a\u884c\u3059\u308b\uff0e<\/p>\n<pre>SELECT * FROM [eqs7day-M1]<\/pre>\n<p>\u3000\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u633f\u5165\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092 Figure 6-2 \u306b\u793a\u3059\u3088\u3046\u306b\u898b\u308b\u3053\u3068\u304c\u3067\u304d\u308b\uff0e<\/p>\n<h4>\u5730\u7406\u578b\u306e\u5217\u3092\u52a0\u3048\u308b<\/h4>\n<p>\u3000\u5404\u5730\u9707\u306e\u4f4d\u7f6e\u306f\u73fe\u5728\u305d\u306e eqs7day-M1 \u30c6\u30fc\u30d6\u30eb\u306b\u8a18\u8ff0\u3055\u308c\u3066\u304a\u308a\uff0c\u7d4c\u5ea6\u3068\u7def\u5ea6\u306e\u5ea7\u6a19\u5024\u306f Lat \u5217\u3068 Lon \u5217\u3092\u4f7f\u3063\u3066\u84c4\u7a4d\u3055\u308c\u3066\u3044\u308b\uff0eSQL Server \u306b\u3088\u308a\u63d0\u4f9b\u3055\u308c\u308b\u3044\u304b\u306a\u308b\u7a7a\u9593\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046\u305f\u3081\u306b\u3082\uff0cgeography \u578b\u3084 geometry \u578b\u3092\u4f7f\u3046\u4ee3\u308f\u308a\u306b\uff0c\u3053\u308c\u3089\u306e\u5ea7\u6a19\u3092\u4f7f\u3063\u3066\u5404\u5730\u9707\u306e\u8868\u73fe\u3092\u751f\u6210\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\uff0eLat \u304a\u3088\u3073 Lon \u5217\u304c\u6b63\u78ba\u306a\u4f4d\u7f6e\u3092\u8a18\u8ff0\u3057\u305f\u5730\u7406\u5ea7\u6a19\u3092\u542b\u3093\u3067\u3044\u308b\u305f\u3081\uff0cgeography \u578b\u3092\u4f7f\u3063\u3066\u8868\u73fe\u3055\u308c\u305f\u5404\u5730\u9707\u3092\u8868\u73fe\u3059\u308b Point \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u751f\u6210\u3059\u308b\u3053\u3068\u306b\u3059\u308b\uff0e\u30c6\u30fc\u30d6\u30eb\u306b Location \u3068\u3044\u3046\u540d\u306e geography \u578b\u306e\u65b0\u3057\u3044\u5217\u3092\u8ffd\u52a0\u3059\u308b\u305f\u3081\uff0c\u6b21\u306e T-SQL \u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\uff0e<\/p>\n<pre>ALTER TABLE [eqs7day-M1]\nADD Location geography\nGO<\/pre>\n<h4>\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u79fb\u5165\u3059\u308b<\/h4>\n<p>\u3000eqs7day-M1 \u30c6\u30fc\u30d6\u30eb\u306b\u65b0\u3057\u3044 geography \u578b\u306e\u5217\u3092\u8ffd\u52a0\u3057\u305f\u3068\u3053\u308d\u3067\uff0c\u4eca\u5ea6\u306f\u305d\u3053\u306b\u5404\u5730\u9707\u3092\u8868\u73fe\u3059\u308b Point geometries \u3092\u79fb\u5165\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\uff0egeography \u578b\u306e <a href=\"https:\/\/docs.microsoft.com\/ja-jp\/sql\/t-sql\/spatial-geography\/point-geography-data-type?view=sql-server-ver15\" target=\"_blank\" rel=\"noopener\">Point() \u30e1\u30bd\u30c3\u30c9<\/a>\uff0c\u3053\u308c\u306f\u305d\u308c\u306e\u57fa\u3065\u304f SRID 4326 \u3068\u5171\u306b Lat \u304a\u3088\u3073 Lon \u5217\u306e\u5185\u90e8\u306b\u542b\u307e\u308c\u308b\u5024\u3092\u63d0\u4f9b\u3059\u308b\u304c\uff0c\u3092\u4f7f\u3063\u3066\u3053\u308c\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u308b\uff0e\u6b21\u306b\uff0cSQL \u306e UPDATE \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u4f7f\u3063\u305f\u3053\u306e\u30e1\u30bd\u30c3\u30c9\u306e\u7d50\u679c\u3068\u3057\u3066\u306e Location \u5217\u306e\u5024\u3092\u30bb\u30c3\u30c8\u3057\u3088\u3046\uff0eLocation \u5217\u306b\u79fb\u5165\u3059\u308b\u305f\u3081\u306b\uff0c\u6b21\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\uff0e<\/p>\n<pre class=\"\">UPDATE [eqs7day-M1]\nSET Location = geography::Point(Lat, Lon, 4326)<\/pre>\n<p>\u3000\u3053\u3053\u306b\u793a\u3059\u3088\u3046\u306b\uff0c\u5f71\u97ff\u3057\u305f\u591a\u304f\u306e\u884c\u306e\u6570\u3092\u53d7\u3051\u53d6\u308b\u3060\u308d\u3046\uff0e\u5f71\u97ff\u3055\u308c\u308b\u884c\u6570\u306f\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u5185\u306e\u5730\u9707\u306e\u6570\u306b\u3088\u308b\uff0e<\/p>\n<pre class=\"\">843 raw(s) affected.<\/pre>\n<p>\u3000Location \u5217\u306e\u5185\u5bb9\u3092\u8abf\u3079\u308b\u305f\u3081\uff0c\u4eca\u5ea6\u306f\u6b21\u306e\u30af\u30a8\u30ea\u3092\u8d70\u3089\u305b\u3088\u3046\uff0e<\/p>\n<pre class=\"\">SELECT TOP 5\nEqid,\nLocation.STAsText() AS Eqicenter\nFROM [eqs7day-Mq]<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3042\u308b\uff0e<\/p>\n<pre class=\"\">Eqid      Epicenter\n14394700  POINT (-117.85 36.0864)\n14394696  POINT (-118.008 34.4421)\n00069720  POINT (-153.883 60.1676)\n14394684  POINT (-115.92 32.6763)\n14394680  POINT (-116.424 33.027)\n<\/pre>\n<p>\u3000Point() \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3063\u3066\uff0cLocation \u5217\u306b\u5730\u7403\u8868\u9762\u4e0a\u306e\u5404\u5730\u9707\u306e\u9707\u6e90\u5730\u306e\u7def\u5ea6\u3068\u7d4c\u5ea6\u3092\u8868\u73fe\u3059\u308b Point geometries \u3092\u79fb\u5165\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u305f\uff0e\u3057\u304b\u3057\uff0c\u5730\u9707\u306e\u8d77\u6e90\u306e\u5730\u70b9\uff08\u7206\u5fc3\u5730\uff09\u306f\u901a\u5e38\u5730\u7403\u5185\u90e8\u306e\u5730\u4e0b\u6570\u5341\u304b\u3089\u6570\u767e\u30de\u30a4\u30eb\u306e\u6df1\u3044\u3068\u3053\u308d\u306b\u3042\u308b\uff0eeqs7day-M1 \u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u5185\u3067\u306f\uff0c\u9707\u6e90\u5730\u306e\u6df1\u5ea6\u306f\u30ad\u30ed\u30e1\u30fc\u30c8\u30eb\u3067\u8868\u73fe\u3055\u308c\uff0cDepth \u5217\u306b\u8a18\u9332\u3055\u308c\u3066\u3044\u308b\uff0e\u4ee3\u308f\u308a\u306b\u5404\u5730\u9707\u306e\u9707\u6e90\u5730\u306e\u4f4d\u7f6e\u306e\u8868\u73fe\u3092\u53ef\u80fd\u306b\u3059\u308b\u305f\u3081\u306b\u306f\uff0cLocation \u5217\u5185\u3067 Point \u305d\u308c\u305e\u308c\u3092\u5b9a\u7fa9\u3057\uff0cDepth \u5217\u306e\u5ea7\u6a19\u5024\u306b\u57fa\u3065\u304d Location \u5217\u306b\u8ffd\u52a0\u306e z \u5ea7\u6a19\u3092\u4ed8\u52a0\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\uff0e\u3053\u306e\u305f\u3081\u306b Point() \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046\u3053\u3068\u306f\u3067\u304d\u306a\u3044\u304c\uff0c\u305d\u308c\u306f\u4e8c\u3064\u306e\u5ea7\u6a19\u5024\u3057\u304b\u53d6\u3089\u306a\u3044\u305f\u3081\u3067\u3042\u308a\uff0cWKT \u69cb\u6587\u306b\u57fa\u3065\u304f\u9759\u7684\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046\u3053\u3068\u304c\u3067\u304d\uff0c\u305d\u308c\u306f z \u5ea7\u6a19\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u308b\uff0e<\/p>\n<p>\u3000\u6b21\u306e\u30b3\u30fc\u30c9\u304c\u793a\u3059\u306e\u306f\uff0c\u4ee3\u308f\u308a\u306b <a href=\"https:\/\/docs.microsoft.com\/ja-jp\/sql\/t-sql\/spatial-geometry\/stpointfromtext-geometry-data-type?view=sql-server-ver15\" target=\"_blank\" rel=\"noopener\">STPointFromText() \u30e1\u30bd\u30c3\u30c9<\/a>\u3092\u4f7f\u3063\u3066 Location \u5217\u3092\u66f4\u65b0\u3059\u308b\u65b9\u6cd5\u3067\u3042\u308a\uff0c\u5404\u5730\u9707\u306e\u7def\u5ea6\uff0c\u7d4c\u5ea6\u304a\u3088\u3073\u6df1\u5ea6\u306b\u57fa\u3065\u304f\u4e00\u500b\u306e Point \u306e WKT \u8868\u73fe\u3092\u751f\u6210\u3059\u308b\u3053\u3068\u306b\u3088\u308b\uff0eDepth \u5217\u304c\u5730\u7403\u8868\u9762\u304b\u3089\u4e0b\u306e\u8ddd\u96e2\u3092\u8868\u73fe\u3059\u308b\u305f\u3081\uff0c\u5404 Point \u306e z \u5ea7\u6a19\u306f Depth \u5217\u306e\u8ca0\u306e\u5024\u306b\u57fa\u3065\u3044\u3066\u30bb\u30c3\u30c8\u3055\u308c\u308b\uff0e<\/p>\n<pre class=\"\">UPDATE [eqs7day-Ma]\nSET Location = geography::STPointFromText(\n'Point(\n+ CAST(Lon AS varchar(255)) + ' '\n+ CAST(Lat AS varchar(255)) + ' '\n+ CAST(-Depth AS varchar(255)) + ')',\n4326)<\/pre>\n<p>\u3000\u4eca\u5ea6\u306f eqs7day-M1 \u30c6\u30fc\u30d6\u30eb\u306b\u542b\u307e\u308c\u308b\u5404\u5730\u9707\u306e\u9707\u6e90\u5730\u3092\u8868\u73fe\u3059\u308b Point \u3092\u542b\u3093\u3060\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3088\u3046\uff0e\u6b21\u306e\u901a\u308a\u3067\u3042\u308b\uff0e<\/p>\n<pre>SELECT\nEqid,\nLocation.AsTextZM() AS Hypocenter\nFROM [eqs7day-Mq]<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u6b21\u306e\u901a\u308a\u3067\u3042\u308b\uff0e<\/p>\n<pre class=\"\">Eqid      Hypocenter\n14394700  POINT (-117.85 36.0864 -4.5)\n14394696  POINT (-118.007 34.4421 -7.7)\n00069720  POINT (-153.883 60.1676 -100)\n14394684  POINT (-115.92 32.6763 -6.2)\n14394680  POINT (-116.424 33.027 -7.4)<\/pre>\n<p>\u30c1\u30c3\u30d7\u30b9\u3000\u4e00\u5ea6 Location \u5217\u306b\u5404\u5730\u9707\u306e Point \u8868\u73fe\u3092\u79fb\u5165\u3057\u305f\u3089\uff0c\u5143\u306e\u7def\u5ea6\uff0c\u7d4c\u5ea6\u304a\u3088\u3073\u6df1\u5ea6\u306e\u5217\u306f\u524a\u9664\u3057\u3066\u69cb\u308f\u306a\u3044\uff0e\u4eee\u306b\u3067\u3082\u5143\u306e\u5ea7\u6a19\u5024\u306e\u53d6\u5f97\u304c\u5fc5\u8981\u306b\u306a\u3063\u305f\u3089\uff0cLat, Lon \u304a\u3088\u3073 Z \u5c5e\u6027\u3092\u4f7f\u3046\u3053\u3068\u304c\u3067\u304d\u308b\uff08\u8a73\u7d30\u306f\u7b2c 11 \u7ae0\u3067\u89e3\u8aac\u3059\u308b\uff09\uff0e<\/p>\n<h3>Keyhole Markup Language \u304b\u3089\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/h3>\n<p>\u3000<a href=\"https:\/\/developers.google.com\/kml\/documentation\/kml_tut?hl=ja\" target=\"_blank\" rel=\"noopener noreferrer\">KML<\/a> \u306f Keyhole \u793e\u306b\u3088\u308a\u72ec\u81ea\u306b\u958b\u767a\u3055\u308c\u305f GML \u30d9\u30fc\u30b9\u306e\u8a00\u8a9e\u3067\u3042\u308a\uff0cEarthViewer \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u5185\u3067\u4f7f\u308f\u308c\u308b\uff0e2004 \u5e74\u306b Google \u304c EarthViewer \u3068\u5171\u306b Keyhole \u3092\u8cb7\u53ce\u3057\uff0c\u4eca\u3067\u306f\u6709\u540d\u306b\u306a\u3063\u305f <a href=\"https:\/\/www.google.com\/earth\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Earth<\/a> \u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0 (http:\/\/earth.google.com) \u3092\u958b\u767a\u3059\u308b\u305f\u3081\u306e\u57fa\u76e4\u3068\u3057\u3066 Google \u304c\u4f7f\u3063\u3066\u3044\u308b\uff0eKML \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306f\u305d\u308c\u4ee5\u6765\u4f55\u5ea6\u304b\u306e\u6539\u8a02\u3092\u7d4c\u3066\u3044\u308b\uff08\u57f7\u7b46\u6642\u70b9\u3067\u306e\u6700\u65b0\u30d0\u30fc\u30b8\u30e7\u30f3\u306f KML 2.2\uff09\u304c\uff0cGoogle Earth \u3067\u4f7f\u308f\u308c\u308b\u7a7a\u9593\u60c5\u5831\u3092\u84c4\u7a4d\u3059\u308b\u30cd\u30a4\u30c6\u30a3\u30d6\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u3042\u308a\u7d9a\u3051\u3066\u3044\u308b\uff0e2008 \u5e74\uff0cKML \u306f Open Geospatial Consortium \u306b\u7a7a\u9593\u60c5\u5831\u6a19\u6e96\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3068\u3057\u3066\u63a1\u7528\u3055\u308c\uff0c\u4eca\u3084\u6700\u65b0\u306e KML \u4ed5\u69d8\u306e\u5b9f\u88c5\u306f <a href=\"https:\/\/www.ogc.org\/standards\/kml\/\" target=\"_blank\" rel=\"noopener noreferrer\">OGC \u30a6\u30a7\u30d6\u30b5\u30a4\u30c8<\/a>\u3067\u898b\u308b\u3053\u3068\u304c\u3067\u304d\u308b\uff0e\u30a2\u30c9\u30ec\u30b9\u306f\u4ee5\u4e0b\u306e\u901a\u308a\uff0e http:\/\/www.opengeospatial.org\/standards\/kml\/<\/p>\n<p>\u3000KML \u304c Google Earth \u30b3\u30df\u30e5\u30cb\u30c6\u30a3\u5185\u90e8\u3067\u4f7f\u308f\u308c\u30e6\u30fc\u30b6\u30fc\u306e\u4f5c\u6210\u3057\u305f\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u30b7\u30a7\u30a2\u3057\u3066\u3044\u308b\u4e00\u65b9\uff0c\u3088\u308a\u5e83\u3044\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u30b3\u30df\u30e5\u30cb\u30c6\u30a3\u306e\u9593\u3067\u306f Google Earth \u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u306e\u4eba\u6c17\u3068\u5feb\u9069\u3055\u306f\uff0cKML \u306f\u307e\u3059\u307e\u3059\u6559\u80b2\u3068\u7814\u7a76\u76ee\u7684\u3067\u4f7f\u308f\u308c\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u304d\u3066\u3044\u308b\u3053\u3068\u3092\u610f\u5473\u3057\u3066\u304a\u308a\uff0c\u305d\u308c\u306f\u6551\u6025\u3084\u707d\u5bb3\u6642\u306e\u30b5\u30fc\u30d3\u30b9\u306e\u3088\u3046\u306a\u91cd\u8981\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u304a\u3044\u3066\u3082\u540c\u69d8\u3067\u3042\u308b\uff0eOGC \u306b\u3088\u308b\u6a19\u6e96\u63a1\u7528\u3068\u3082\u76f8\u307e\u3063\u3066\uff0cKML \u306f\u7a7a\u9593\u30c7\u30fc\u30bf\u306e\u4e92\u63db\u6027\u306b\u3068\u3063\u3066\uff0c\u307e\u3059\u307e\u3059\u91cd\u8981\u306a\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u306a\u308a\u3064\u3064\u3042\u308b\uff0e<\/p>\n<h4>KML \u3092 GML \u3068\u6bd4\u8f03\u3059\u308b<\/h4>\n<p>\u3000GML \u306e\u3088\u3046\u306b\uff0cKML \u30d5\u30a1\u30a4\u30eb\u306f\u7a7a\u9593\u6a5f\u80fd\uff0c\u3064\u307e\u308a Points, Paths \uff08LineString \u3068\u540c\u7b49\u306e\u3082\u306e\uff09\u304a\u3088\u3073 Polygons \u3092\u8a18\u8ff0\u3059\u308b\u305f\u3081\u7570\u306a\u308b\u7a2e\u985e\u306e\u5730\u7406\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4fdd\u6709\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\uff0e\u3057\u304b\u3057\uff0cGML \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u304c\uff08WKT \u304a\u3088\u3073 WKB \u306e\u3088\u3046\u306b\uff09\u7d14\u7c8b\u306b\u5730\u7406\u7684\u7279\u5fb4\u306e\u5f62\u614b\u3068\u4f4d\u7f6e\u3092\u8a18\u8ff0\u3059\u308b\u76ee\u7684\u3067\u4f7f\u308f\u308c\u308b\u4e00\u65b9\u3067\uff0cKML \u30d5\u30a1\u30a4\u30eb\u306f\u305d\u308c\u3089\u306e\u7279\u5fb4\u304c\u30b9\u30bf\u30a4\u30eb\u3092\u6574\u3048\u3089\u308c\uff0c\u30b0\u30e9\u30d5\u30a3\u30ab\u30eb\u306a\u30c7\u30a3\u30b9\u30d7\u30ec\u30a4\u3067\u8868\u73fe\u3055\u308c\u308b\u65b9\u6cd5\u3092\u4ed8\u52a0\u7684\u306b\u6307\u5b9a\u3059\u308b\uff0e<\/p>\n<p>\u3000KML \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u8aac\u660e\u3059\u308b\u305f\u3081\uff0chttp:\/\/code.google.com\/apis\/kml\/documentation\/kml_tut.html \u3067\u5229\u7528\u53ef\u80fd\u306a\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u304b\u3089\u53d6\u5f97\u3057\u305f Path \u306e KML \u8868\u73fe\u3092 Listing 6-1 \u306b\u793a\u3059\uff0e<\/p>\n<p>\u3000\u3053\u306e KML \u8868\u73fe\u306f\uff0c\u554f\u984c\u306b\u3057\u3066\u3044\u308b LineString \u306e\u7d14\u7c8b\u306a\u5730\u7406\u5c5e\u6027\u3092\u8a18\u8ff0\u3059\u308b\u306e\u306b\u5fc5\u8981\u3068\u3055\u308c\u308b\u3088\u308a\u3082\uff0c\u591a\u304f\u306e\u60c5\u5831\u3092\u542b\u3093\u3067\u3044\u308b\u3053\u3068\u306b\u6ce8\u610f\u3055\u308c\u305f\u3044\uff0e\u591a\u304f\u306e\u7570\u306a\u308b\u30b9\u30bf\u30a4\u30eb\u304a\u3088\u3073\u8a18\u8ff0\u8981\u7d20\u304c\u5b58\u5728\u3059\u308b\uff0e\u4eee\u306b\u3053\u306e\u540c\u3058\u6a5f\u80fd\u3092 GML \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u4f7f\u3063\u3066\u8a18\u8ff0\u3057\u3088\u3046\u3068\u3059\u308b\u3068\uff0c\u305d\u3053\u306b\u306f\u5f62\u614b\u306b\u95a2\u3059\u308b\u8981\u7d20\u3057\u304b\u542b\u307e\u308c\u3066\u3044\u306a\u3044\u305f\u3081\uff0cListing 6-2 \u306b\u793a\u3059\u3088\u3046\u306a\u30b3\u30fc\u30c9\u3092\u8981\u6c42\u3059\u308b\u3057\u304b\u306a\u3044\uff0e<\/p>\n<h4>KML \u3092 GML \u306b\u5909\u63db\u3059\u308b<\/h4>\n<p>\u3000\u9ad8\u5ea6\u306b\u69cb\u9020\u5316\u3055\u308c\u305f XML \u306e\u6027\u8cea\u306e\u5229\u70b9\u306e\u4e00\u3064\u306f\uff0c\u660e\u793a\u7684\u306a\u5909\u63db\u3092\u6307\u5b9a\u3057\u3066 XML \u306e\u4e00\u3064\u306e\u65b9\u8a00\u304b\u3089\u5225\u306e\u65b9\u8a00\u306b\u5909\u63db\u3059\u308b\u3053\u3068\u304c\u6bd4\u8f03\u7684\u305f\u3084\u3059\u3044\u3053\u3068\u3067\u3042\u308b\uff0e\u751f\u6210\u3057\u3066\u5fc5\u8981\u306a\u5909\u63db\u3092\u9069\u7528\u3059\u308b\u3053\u3068\u306b\u3088\u308a\uff0c\uff08Listing 6-1 \u306b\u793a\u3057\u305f\u3088\u3046\u306b\uff09 KML \u304b\u3089\uff08Listing 6-2 \u306b\u793a\u3057\u305f\u3088\u3046\u306b\uff09 GML \u306b\u5909\u63db\u3059\u308b\u3053\u3068\u306f\u53ef\u80fd\u3067\u3042\u308a\uff0cgeography \u578b\u304a\u3088\u3073 geometry \u578b\u306e <a href=\"https:\/\/docs.microsoft.com\/ja-jp\/sql\/t-sql\/spatial-geometry\/geomfromgml-geometry-data-type?view=sql-server-ver15\" target=\"_blank\" rel=\"noopener\">GeomFromGml() \u30e1\u30bd\u30c3\u30c9<\/a>\u3092\u4f7f\u3063\u3066\u305d\u308c\u3092 SQL Server \u306b\u8ab2\u3059\u3053\u3068\u304c\u3067\u304d\u308b\uff0eKML \u304b\u3089 GML \u306b\u5909\u63db\u3059\u308b\u305f\u3081\u306b\u306f\uff0c\u6b21\u306e\u5909\u63db\u304c\u8d77\u304d\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\uff0e<\/p>\n<ol>\n<li>\u7d14\u7c8b\u306b\u30b9\u30bf\u30a4\u30eb\u3084\u8a18\u8ff0\u7684\u306a\u5c5e\u6027\u3092\u8a18\u8ff0\u3059\u308b KML \u8981\u7d20\u3092\u524a\u9664\u3059\u308b\uff0e\u305d\u308c\u3089\u306f GML \u30d5\u30a1\u30a4\u30eb\u306b\u306f\u5168\u304f\u95a2\u4fc2\u304c\u306a\u3044\uff0e\u3053\u308c\u3089\u306e\u8981\u7d20\u3068\u306f &lt;LookAt&gt;, &lt;visibility&gt;, &lt;styleUrl&gt;, &lt;Style&gt; \u304a\u3088\u3073 &lt;name&gt; \u3067\u3042\u308b\uff0e<\/li>\n<li>\u5730\u7406\u7684\u5c5e\u6027\u306b\u95a2\u9023\u3059\u308b\u305d\u308c\u3089\u306e\u8981\u7d20\u306e\u5185\u5bb9\u3092\u53d6\u5f97\u3057\uff0c\u305d\u308c\u3089\u3092\u540c\u7b49\u306e GML \u8981\u7d20\u3067\u7f6e\u63db\u3059\u308b\uff0eTable 6-4 \u306b\u793a\u3059\uff0e<\/li>\n<li>&lt;coordinates&gt; \u8981\u7d20\u306e\u5185\u5bb9\u3092\u64cd\u4f5c\u3057\uff0c\u305d\u308c\u306b\u306f KML geometry \u306b\u304a\u3051\u308b\u5404 point \u306e\u5ea7\u6a19\u304c\u542b\u307e\u308c\u308b\u304c\uff0c\u540c\u7b49\u306e GML \u306e &lt;postList&gt; \u3084 &lt;pos&gt; \u8981\u7d20\u306e\u9069\u5207\u306a\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u3059\u308b\uff0e\n<ol style=\"list-style-type: lower-alpha;\">\n<li>\u5404\u5ea7\u6a19\u5024\u306e\u30bf\u30d7\u30eb\u9593\u306b\u4f7f\u308f\u308c\u308b\u30bb\u30d1\u30ec\u30fc\u30bf\u30fc\u306e\u30b3\u30f3\u30de\u3092\u30b9\u30da\u30fc\u30b9\u306b\u7f6e\u63db\u3059\u308b\uff0e<\/li>\n<li>\u4eee\u306b KML &lt;coordinates&gt; \u8981\u7d20\u5185\u90e8\u306e\u5ea7\u6a19\u5024\u304c\u9ad8\u5ea6 (z) \u5ea7\u6a19\u3067\u8a18\u8ff0\u3055\u308c\u3066\u3044\u308b\u306a\u3089\uff0c\u3053\u306e\u5024\u306f\u7121\u8996\u3059\u308b\uff0e<\/li>\n<li>\u4e8c\u3064\u306e\u6b8b\u308a\u306e\u5ea7\u6a19\u306e\u9806\u3092\u9006\u8ee2\u3055\u305b\uff0c\u7def\u5ea6-\u7d4c\u5ea6\u306e\u9806\u306b\u8a18\u8ff0\u3059\u308b\uff0e<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<table style=\"border-collapse: collapse; width: 100%;\"><caption>Table 6-4. \u5730\u7406 KML \u8981\u7d20\u304a\u3088\u3073\u76f8\u5f53\u3059\u308b GML<\/caption>\n<tbody>\n<tr>\n<th style=\"width: 30%;\">KML<\/th>\n<th style=\"width: 30%;\">GML<\/th>\n<th style=\"width: 40%;\">\u8a73\u7d30<\/th>\n<\/tr>\n<tr>\n<td style=\"width: 30%;\">&lt;GeometryCoolection&gt;<\/td>\n<td style=\"width: 30%;\">&lt;GeometryCollection&gt;<\/td>\n<td style=\"width: 40%;\">Geometry Collection \u8981\u7d20\u3092\u793a\u3059<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 30%;\">&lt;Polygon&gt;<\/td>\n<td style=\"width: 30%;\">&lt;Polygon&gt;<\/td>\n<td style=\"width: 40%;\">Polygon geometry \u3092\u793a\u3059<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 30%;\">&lt;LineString&gt;<\/td>\n<td style=\"width: 30%;\">&lt;LineString&gt;<\/td>\n<td style=\"width: 40%;\">LineString geometry \u3092\u793a\u3059<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 30%;\">&lt;Point&gt;<\/td>\n<td style=\"width: 30%;\">&lt;Point&gt;<\/td>\n<td style=\"width: 40%;\">Point geometry \u3092\u793a\u3059<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 30%;\">&lt;outerBoundaryIs&gt;<\/td>\n<td style=\"width: 30%;\">&lt;exterior&gt;<\/td>\n<td style=\"width: 40%;\">Polygon \u306e\u5916\u90e8\u5883\u754c\u3092\u793a\u3059<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 30%;\">&lt;innerBoundaryIs&gt;<\/td>\n<td style=\"width: 30%;\">&lt;interior&gt;<\/td>\n<td style=\"width: 40%;\">Polygon \u306e\u5185\u90e8\u5883\u754c\u3092\u793a\u3059<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 30%;\">&lt;coordinates&gt;<sup>a<\/sup><\/td>\n<td style=\"width: 30%;\">&lt;pos&gt;&lt;posList&gt;<\/td>\n<td style=\"width: 40%;\">geometry \u306e\u5ea7\u6a19\u30ea\u30b9\u30c8\u3092\u542b\u3080\u8981\u7d20<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><sup>a<\/sup> GML \u306b\u304a\u3044\u3066\u306f\uff0c&lt;pos&gt; \u8981\u7d20\u306f &lt;posList&gt; \u8981\u7d20\u3068\u306f\u660e\u78ba\u306b\u533a\u5225\u3055\u308c\u308b\uff0e&lt;pos&gt; \u8981\u7d20\u306f\uff081 \u70b9\u306e Point geometry \u3092\u5b9a\u7fa9\u3059\u308b\u306e\u306b\u4f7f\u308f\u308c\u308b\u3088\u3046\u306b\uff09\u5358\u4e00\u306e\u5ea7\u6a19\u30bf\u30d7\u30eb\u3092\u4fdd\u6709\u3057\uff0c&lt;posList&gt; \u8981\u7d20\u306f\uff08LineString \u3084 Polygon \u306b\u304a\u3051\u308b\u3088\u3046\u306b\uff09\u8907\u6570\u306e\u5ea7\u6a19\u30bf\u30d7\u30eb\u3092\u4fdd\u6709\u3059\u308b\uff0e<\/p>\n<p>\u4ed8\u8a18\u3000KML \u306b\u304a\u3044\u3066\u5168\u3066\u306e multielement geometry \u306fGeometry Collection \u3068\u3057\u3066\u8868\u73fe\u3055\u308c\u308b\uff0eMultiPoint, MultiLineString \u307e\u305f\u306f MultiPolygon geometry \u3068\u540c\u7b49\u3067\u3042\u308b\u7279\u7570\u7684\u306a\u540c\u7a2e\u306e\u8981\u7d20\u306f\u5b58\u5728\u3057\u306a\u3044\uff0e<\/p>\n<p>\u4ed8\u8a18\u3000GML \u6a19\u6e96\u306e\u521d\u671f\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u306f &lt;coordinates&gt; \u8981\u7d20\u304c\u542b\u307e\u308c\uff0c\u305d\u308c\u306f KML \u3067\u4f7f\u308f\u308c\u308b\u3082\u306e\u3068\u9177\u4f3c\u3057\u3066\u3044\u308b\uff0e\u3057\u304b\u3057\uff0c\u3053\u308c\u306f GML \u30d0\u30fc\u30b8\u30e7\u30f3 3.1.0 \u3067\u975e\u63a8\u5968\u3068\u306a\u308a\uff0cSQL Server 2008 \u3067\u306f\u63d0\u4f9b\u3055\u308c\u306a\u3044\uff0e\u305d\u306e\u4ee3\u308f\u308a\uff0c\u5fc5\u305a &lt;posList&gt; \u8981\u7d20\u307e\u305f\u306f &lt;pos&gt; \u8981\u7d20\u3092\u4f7f\u308f\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\uff0e<\/p>\n<p>\u3000Listing 6-1 \u306b\u793a\u3057\u305f KML \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u304b\u3089\uff0cListing 6-2 \u306b\u793a\u3057\u305f\u540c\u7b49\u306e GML \u8868\u73fe\u306b\u5909\u63db\u3059\u308b\u306e\u306b\u5fc5\u8981\u306a\u5909\u5316\u3092\u8d77\u3053\u3059\u305f\u3081\u306b\u4f7f\u3044\u305f\u3044\u306a\u3089\uff0c\u3044\u304f\u3064\u304b\u306e\u65b9\u6cd5\u304c\u5b58\u5728\u3059\u308b\uff0e\u4f8b\u3048\u3070\uff0cXQuery \u3092\u4f7f\u3046\u3053\u3068\u3082\u3067\u304d\u308b\u3057\uff0c\u3042\u308b\u3044\u306f\uff0cExtensible Stylesheet Language Transformation (XSLT) \u3092\u4f7f\u3046\u3053\u3068\u3082\u3067\u304d\u308b\uff0eXQuery \u304a\u3088\u3073 XSLT \u306f\u5171\u306b World Wide Web Consortium (W3C) \u306b\u3088\u308a\u7ba1\u7406\u3055\u308c\u308b\u627f\u8a8d\u3055\u308c\u305f\u6a19\u6e96\u3067\u3042\u308b\uff0e\u305d\u308c\u3089\u304c\u5909\u63db\u3057 XML \u30c7\u30fc\u30bf\u3092\u554f\u3044\u5408\u308f\u305b\u308b\u306e\u306b\u4f7f\u308f\u308c\u308b\u65b9\u6cd5\u306e\u3055\u3089\u306a\u308b\u60c5\u5831\u306f\uff0cW3C \u30a6\u30a7\u30d6\u30da\u30fc\u30b8\u306e\u305d\u308c\u305e\u308c <a href=\"https:\/\/www.w3.org\/TR\/xslt.html\" target=\"_blank\" rel=\"noopener\">http:\/\/www.w3.org\/TR\/xslt.html<\/a> \u304a\u3088\u3073 <a href=\"https:\/\/www.w3.org\/TR\/xquery\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.w3.org\/TR\/xquery\/<\/a> \u3092\u53c2\u7167\u3055\u308c\u305f\u3044\uff0e\u3057\u304b\u3057\uff0c\u4e8c\u3064\u306e XML \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u9593\u306e\u7c21\u5358\u306a\u5909\u63db\u3092\u5b9f\u884c\u3059\u308b\u3060\u3051\u306e\u3044\u304b\u306a\u308b\u65b9\u6cd5\u3082\uff0c\u6b21\u306b\u8ff0\u3079\u308b\u5236\u7d04\u306b\u82e6\u3057\u3080\u3053\u3068\u306b\u306a\u308b\u304b\u3082\u77e5\u308c\u306a\u3044\uff0e<\/p>\n<ul>\n<li>\u30aa\u30ea\u30b8\u30ca\u30eb\u306e KML \u30d5\u30a1\u30a4\u30eb\u306b\u542b\u307e\u308c\u308b\u4f55\u304b\u8a18\u8ff0\u7684\u30fb\u30b9\u30bf\u30a4\u30ea\u30f3\u30b0\u8981\u7d20\u3092\u5931\u3046\u304b\u3082\u77e5\u308c\u306a\u3044\uff0e\u305d\u3053\u306b\u306f GML \u3067\u306f\u8868\u73fe\u3067\u304d\u306a\u3044\uff0c\u5404 geometry \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u3064\u3044\u3066\u306e\u6709\u7528\u306a\u4ed8\u52a0\u60c5\u5831\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\uff0e<\/li>\n<li>\u30bd\u30fc\u30b9\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u5bfe\u3057\u3066\u5b9f\u884c\u3059\u308b\u691c\u8a3c\u3084\u30a8\u30e9\u30fc\u30c1\u30a7\u30c3\u30af\u304c\u5b58\u5728\u305b\u305a\uff0c\u6709\u52b9\u306a geometry \u3092\u751f\u6210\u3059\u308b\u304b\u3069\u3046\u304b\u30c1\u30a7\u30c3\u30af\u3067\u304d\u306a\u3044\uff0e\u4f8b\u3048\u3070\uff0c\u5909\u63db\u3055\u308c\u305f GML \u8868\u73fe\u304b\u3089 geography \u578b\u306e Polygon \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u751f\u6210\u3059\u308b\u305f\u3081\u306b\u306f\uff0c\u7a7a\u9593\u306e\u9818\u57df\u3092\u4fdd\u6709\u3059\u308b\u305d\u308c\u3089\u306e\u30ea\u30f3\u30b0\u306e\u30dd\u30a4\u30f3\u30c8\u306f\u53cd\u6642\u8a08\u56de\u308a\u306e\u9806\u3067\u5217\u6319\u3057\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\u304c\uff0c\u305d\u308c\u306f\u30aa\u30ea\u30b8\u30ca\u30eb\u306e KML &lt;coordinates&gt; \u8981\u7d20\u5185\u3067\u5217\u6319\u3055\u308c\u3066\u3044\u308b\u306e\u3068\u306f\u9055\u3046\u304b\u3082\u77e5\u308c\u306a\u3044\uff0e<\/li>\n<\/ul>\n<p>\u3000\u4eee\u306b\u3082\u3063\u3068\u5805\u7262\u306a\u65b9\u6cd5\u3092\u4f7f\u3063\u3066 KML \u30c7\u30fc\u30bf\u3092 SQL Server 2008 \u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\u3044\u306a\u3089\uff0c\u3053\u306e\u76ee\u7684\u306b\u7279\u5316\u3057\u305f\u30b5\u30fc\u30c9\u30d1\u30fc\u30c6\u30a3\u88fd\u306e\u30c4\u30fc\u30eb\u304c\u5229\u7528\u3067\u304d\u308b\u7bc4\u56f2\u3092\u8abf\u67fb\u3057\u305f\u304f\u306a\u308b\u3060\u308d\u3046\uff0e\u672c\u7ae0\u306e\u6700\u5f8c\u306b\u305d\u306e\u3044\u304f\u3064\u304b\u3092\u5217\u6319\u3059\u308b\uff0e<\/p>\n<p>\u4ed8\u8a18\u3000KML \u304a\u3088\u3073 GML \u306f\u5358\u306a\u308b XML \u30d9\u30fc\u30b9\u306e\u7a7a\u9593\u30c7\u30fc\u30bf\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u306f\u306a\u3044\uff0e\u4f8b\u3048\u3070\uff0cGPS Exchange Format (GPX) \u306f\u591a\u304f\u306e\u643a\u5e2f\u578b GPS \u30c7\u30d0\u30a4\u30b9\u9593\u3067\u30c7\u30fc\u30bf\u3092\u30b7\u30a7\u30a2\u3057\u84c4\u7a4d\u3059\u308b\u306e\u306b\u4f7f\u308f\u308c\u308b XML \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u3042\u308b\uff0e<\/p>\n<h3>ESRI shapefile format \u304b\u3089\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/h3>\n<p>\u3000shapefile \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306f Environmental Systems Research Institute \u793e (ESRI) \u306b\u3088\u308a\u8a2d\u8a08\u3055\u308c\u7dad\u6301\u3055\u308c\u3066\u3044\u308b\uff0e\u6700\u521d\u306b\u958b\u767a\u3055\u308c\u305f\u306e\u306f GIS \u306e\u30b9\u30a4\u30fc\u30c8 ARC\/INFO \u306e\u7528\u9014\u306e\u305f\u3081\u3067\u3042\u308a\uff0cshapefile \u306f\u4eca\u3084\uff0c\u3042\u3089\u3086\u308b\u7a2e\u985e\u306e\u30b7\u30b9\u30c6\u30e0\u9593\u3067\u7a7a\u9593\u60c5\u5831\u3092\u5909\u63db\u3059\u308b\u306e\u306b\u4f7f\u3046\u975e\u5e38\u306b\u4e00\u822c\u7684\u306a\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3068\u306a\u3063\u3066\u304a\u308a\uff0c\u307b\u3068\u3093\u3069\u306e\u5546\u7528\u7a7a\u9593\u30c7\u30fc\u30bf\u306b\u63d0\u4f9b\u3055\u308c\u308b\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u3042\u308b\uff0e\u6642\u9593\u3068\u3068\u3082\u306b\uff0c\u5de8\u5927\u306a\u7a7a\u9593\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u304c ESRI shapefile \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u4f5c\u6210\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u304d\u305f\uff0e<\/p>\n<p>\u3000shapefile \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u63d0\u4f9b\u3055\u308c\u308b\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306f\u4e00\u822c\u306b &#8220;a shapefile&#8221; \uff08\u5358\u6570\u5f62\uff09\u3068\u547c\u3070\u308c\u308b\u306b\u3082\u95a2\u308f\u3089\u305a\uff0c\u3053\u308c\u306f\u5c11\u3057\u8aa4\u79f0\u3067\u3042\u308b\uff0e\u3068\u3044\u3046\u306e\u306f\uff0c\u5358\u4e00\u306e shapefile \u306f\u5b9f\u969b\u306b\u3044\u304f\u3064\u304b\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u4fdd\u6709\u3057\u3066\u3044\u308b\u304b\u3089\u3067\u3042\u308b\uff0e\u4e0e\u3048\u3089\u308c\u305f shapefile \u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u95a2\u9023\u3059\u308b\u5404\u30d5\u30a1\u30a4\u30eb\u306f\u540c\u3058\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u6301\u3061\uff0c\u305d\u308c\u306b\u30d5\u30a1\u30a4\u30eb\u306e\u62e1\u5f35\u5b50\u304c\u7d9a\u304f\uff0e<\/p>\n<ul>\n<li>.shp: SHP \u30d5\u30a1\u30a4\u30eb\u306f\u751f\u306e\u5e7e\u4f55\u5b66\u7684\u5f62\u614b\u30c7\u30fc\u30bf\u3067\u3042\u308b\uff0e\u5404 SHP \u30d5\u30a1\u30a4\u30eb\u306f\u305f\u3060\u4e00\u7a2e\u985e\u306e geometry \u5f62\u614b\u3092\u4fdd\u6709\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\uff0ePoints, LineStrings \u3042\u308b\u3044\u306f Polygon \u3067\u3042\u308b\uff0e<\/li>\n<li>.shx: SHX \u30d5\u30a1\u30a4\u30eb\u306f shapefile \u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u7dad\u6301\u3057\uff0cshapefile \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u5185\u306e\u3059\u3079\u3066\u306e\u5f62\u614b\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u767b\u9332\u3092\u4e00\u3064\u4fdd\u6301\u3059\u308b\uff0e\u5404\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u767b\u9332\u306f SHP \u30d5\u30a1\u30a4\u30eb\u5185\u306b\u8a18\u9332\u3055\u308c\u305f\u95a2\u9023\u3059\u308b\u5f62\u614b\u306e\u59cb\u70b9\u3068\u9577\u3055\u3068\u3092\u8a18\u8ff0\u3059\u308b\uff0e<\/li>\n<li>.dbf: DBF \u30d5\u30a1\u30a4\u30eb\u306f\u5404\u5f62\u614b\u306e\u4ed8\u52a0\u7684\u306a\uff0c\u975e\u7a7a\u9593\u5c5e\u6027\u3092\u4fdd\u6709\u3059\u308b\uff0e\u4f8b\u3048\u3070\uff0c\u30a2\u30e1\u30ea\u30ab\u306e\u5dde\u3092\u8868\u73fe\u3057\u305f Polygons \u3092\u542b\u3080 shapefile \u5185\u3067\uff0cDBF \u30d5\u30a1\u30a4\u30eb\u306f\u5404\u5dde\u306e\u540d\u524d\uff0c\u305d\u306e\u4eba\u53e3\uff0c\u3042\u308b\u3044\u306f\u305d\u306e\u5dde\u90fd\u3092\u4fdd\u6709\u3057\u3066\u3044\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\uff0e<\/li>\n<li>.prj: PRJ \u30d5\u30a1\u30a4\u30eb\u306f\uff0c\u8868\u73fe\u3055\u308c\u305f\u5730\u7406\u30c7\u30fc\u30bf\u306e\u5ea7\u6a19\u306b\u304a\u3051\u308b\u6295\u5f71\u6cd5\u306b\u3064\u3044\u3066\u306e\u8a73\u7d30\u3092\u4fdd\u6709\u3057\uff0c\u540c\u3058\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u304c sys.spatial_reference_systems \u30c6\u30fc\u30d6\u30eb\u306e well_known_text \u5217\u3067\u4f7f\u308f\u308c\u3066\u3044\u308b\uff0eSQL Server \u306b shapefile \u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u6642\u306b\u306f\uff0c\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u306f\u6b63\u78ba\u306a\u7a7a\u9593\u53c2\u7167\u8b58\u5225\u5b50 (SRID) \u3092\u5b9a\u7fa9\u3059\u308b\u306e\u306b\u5fc5\u8981\u3068\u3055\u308c\u308b\u60c5\u5831\u3092\u4fdd\u6709\u3057\u3066\u3044\u308b\uff0e<\/li>\n<\/ul>\n<p>\u4ed8\u8a18\u3000shapefile \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u306f\u3044\u304b\u306a\u308b\u691c\u8a3c\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3082 SHP \u30d5\u30a1\u30a4\u30eb\u304a\u3088\u3073\u95a2\u9023\u3059\u308b SHX \u30d5\u30a1\u30a4\u30eb\u3092\u4fdd\u6709\u3057\u3066\u3044\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\uff0e.dbf \u304a\u3088\u3073 .prj \u62e1\u5f35\u5b50\u3092\u6709\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u306f\u4efb\u610f\u3067\u3042\u308a\uff0c\u305d\u306e\u30c7\u30fc\u30bf\u306b\u95a2\u3059\u308b\u4ed8\u52a0\u7684\u306a\u60c5\u5831\u3092\u4fdd\u6709\u3059\u308b\uff0e<\/p>\n<h4>\u30b5\u30f3\u30d7\u30eb Shapefile \u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b<\/h4>\n<p>\u3000shapefile \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u304b\u3089 SQL server \u306b\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3059\u308b\u305f\u3081\uff0c \u30ab\u30ea\u30d5\u30a9\u30eb\u30cb\u30a2\u5dde\u306e \u90f5\u4fbf\u756a\u53f7\u30a8\u30ea\u30a2\u96c6\u8a08 (ZCTAs) \u3092\u8868\u73fe\u3059\u308b\u7c73\u56fd\u56fd\u52e2\u8abf\u67fb\u5c40\u304b\u3089\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u304a\u3046\uff0eZCTAs \u306f\u7c73\u56fd\u56fd\u52e2\u8abf\u67fb\u5c40\u306e 2000 \u5e74\u306e\u8abf\u67fb\u306b\u3088\u308a\u5b9a\u7fa9\u3055\u308c\uff0c\u7c73\u56fd\u90f5\u653f\u516c\u793e\u3067\u4f7f\u308f\u308c\u308b 5 \u6841\u306e\u6570\u5b57\u306e\u90f5\u4fbf\u756a\u53f7\u306e\u305f\u3081\u306e\u914d\u9001\u30a8\u30ea\u30a2\u306b\u307b\u307c\u76f8\u5f53\u3059\u308b\uff0eZCTA \u306e\u5730\u57df\u306e ESRI shapefile \u306f\uff0c\u30ab\u30ea\u30d5\u30a9\u30eb\u30cb\u30a2\u5dde\u306e\u3082\u306e\u306a\u3089\u76f4\u63a5\u7c73\u56fd\u56fd\u52e2\u8abf\u67fb\u5c40\u306e\u30a6\u30a7\u30d6\u30b5\u30a4\u30c8\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\uff0eURL \u306f http:\/\/www.census.gov\/geo\/cob\/bdy\/zt\/zt06_d00_shp.zip. \u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u3053\u306e ZIP \u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u5185\u5bb9\u3092\u89e3\u51cd\u3059\u308b\uff0e\u6b21\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u542b\u307e\u308c\u3066\u3044\u308b\uff0e<\/p>\n<ul>\n<li>zt06_d00.shp<\/li>\n<li>zt06_d00.shx<\/li>\n<li>zt06_d00.dbf<\/li>\n<\/ul>\n<p>\u3000SHP \u30d5\u30a1\u30a4\u30eb\u306f\u3053\u308c\u3089\u306e\u3046\u3061\u3067\u6700\u5927\u30b5\u30a4\u30ba\u3067\u3042\u308a (4,560 KB), \u5404 ZCTA \u3092\u8868\u73fe\u3059\u308b Polygon \u306e\u5f62\u614b\u3092\u5b9a\u7fa9\u3059\u308b\u751f\u30c7\u30fc\u30bf\u3092\u4fdd\u6709\u3057\u3066\u3044\u308b\uff0eSHX \u30d5\u30a1\u30a4\u30eb\u306f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30d5\u30a1\u30a4\u30eb\u3067\u3042\u308a\uff0cshapefile \u5185\u306e\u5404\u5f62\u614b\u306e\u59cb\u70b9\u3068\u9577\u3055\u3092\u8a18\u9332\u3057\u3066\u3044\u308b\uff0e\u7d14\u7c8b\u306b\u7a7a\u9593\u60c5\u5831\u3092\u8868\u73fe\u3057\u3066\u3044\u308b\u5404 ZCTA \u3092\u4fdd\u6709\u3057\u3066\u3044\u308b\u3053\u308c\u3089\u4e8c\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u52a0\u3048\u3066\uff0cDBF \u30d5\u30a1\u30a4\u30eb\u306f\u95a2\u9023\u3059\u308b\u4ed8\u52a0\u7684\u306a\u30c7\u30fc\u30bf\u306e\u5217\u3092\u4fdd\u6709\u3057\uff0c\u305d\u308c\u306f Table 6-5 \u306b\u5217\u6319\u3057\u3066\u8a18\u8ff0\u3057\u3066\u3042\u308b\uff0e<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\"><caption>Table 6-5. zt06_d00.dbf \u30d5\u30a1\u30a4\u30eb\u5185\u306e\u30c7\u30fc\u30bf\u306e\u5217<\/caption>\n<tbody>\n<tr>\n<th style=\"width: 10%;\">\u5217<\/th>\n<th style=\"width: 90%;\">\u8a18\u8ff0<\/th>\n<\/tr>\n<tr>\n<td style=\"width: 10%;\">Area<\/td>\n<td style=\"width: 90%;\">\u5404 ZCTA \u306e\u5185\u90e8\u306e\u9762\u7a4d\uff0c\u5e73\u65b9\u30ad\u30ed\u30e1\u30fc\u30c8\u30eb<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 10%;\">Perimeter<\/td>\n<td style=\"width: 90%;\">\u5404 ZCTA \u306e\u5916\u5468\u9577\uff0c\u30ad\u30ed\u30e1\u30fc\u30c8\u30eb<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 10%;\">ZT06 D00<\/td>\n<td style=\"width: 90%;\">\u81ea\u52d5\u7684\u306b\u751f\u6210\u3057\u305f\u9023\u7d9a\u3059\u308b\u5f62\u614b\u306e\u756a\u53f7<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 10%;\">ZT06 D00 ID<\/td>\n<td style=\"width: 90%;\">\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u306e\u5f62\u614b\u306e\u756a\u53f7<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 10%;\">ZCTA<\/td>\n<td style=\"width: 90%;\">ZCTA \u306e\u53c2\u7167\u3059\u308b 5 \u6841\u306e\u756a\u53f7<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 10%;\">NAME<\/td>\n<td style=\"width: 90%;\">ZCTA \u306b\u540c\u3058<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 10%;\">LSAD<\/td>\n<td style=\"width: 90%;\">\u6cd5\u7684\/\u7d71\u8a08\u7684\u5730\u57df\u306e\u8a18\u8ff0\u30b3\u30fc\u30c9\uff0e2\u6587\u5b57\u306e\u9818\u57df\u3067\u6cd5\u7684\u3042\u308b\u3044\u306f\u7d71\u8a08\u7684\u5730\u57df\u306e\u7a2e\u985e\u306e\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u306b\u5bfe\u5fdc\uff0e5 \u6841\u306e ZCTA \u30b3\u30fc\u30c9\u306e\u305f\u3081\uff0c\u901a\u5e38\u306f Z5 \u3068\u3059\u308b\uff0e<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 10%;\">LSAD_TRANS<\/td>\n<td style=\"width: 90%;\">\u5404\u5f62\u614b\u306e LSAD \u306b\u95a2\u3059\u308b\u8a18\u8ff0\uff0eZCTAs \u306e\u5834\u5408\u306f &#8216;5-Digit ZCTA&#8217; \u3068\u306a\u308b\uff0e<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u30c1\u30c3\u30d7\u30b9\u3000zt06_d00.dbf \u306b\u542b\u307e\u308c\u308b\u3055\u3089\u306a\u308b\u30c7\u30fc\u30bf\u306b\u3064\u3044\u3066\u306f http:\/\/vcgi.org\/metadata\/BoundaryOther_ZCTA2000.txt \u306b\u76f8\u8ac7\u3055\u308c\u305f\u3044\uff0e<\/p>\n<p>\u3000ZCTA shapefile \u306b\u95a2\u9023\u3059\u308b PRJ \u30d5\u30a1\u30a4\u30eb\u304c\u5168\u304f\u542b\u307e\u308c\u3066\u3044\u306a\u3044\u3053\u3068\u306b\u6ce8\u610f\u3055\u308c\u305f\u3044\uff0e\u306a\u3089\u3070\uff0c\u3069\u3046\u3084\u3063\u3066\u5ea7\u6a19\u3092\u5b9a\u7fa9\u3059\u308b\u305f\u3081\u306b\u4f7f\u308f\u308c\u308b\u7a7a\u9593\u53c2\u7167\u7cfb\u3092\u77e5\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u306e\u3060\u308d\u3046\uff1f\u7c73\u56fd\u56fd\u52e2\u8abf\u67fb\u5c40\u30a6\u30a7\u30d6\u30b5\u30a4\u30c8\u3092\u3055\u3089\u306b\u691c\u7d22\u3059\u308b\u3068\uff0c\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u30da\u30fc\u30b8\u304c\u898b\u3064\u304b\u3063\u305f\uff0e\u305d\u308c\u306f http:\/\/www.census.gov\/geo\/www\/cob\/zt_metadata.html \u306b\u3042\u3063\u305f\uff0e\u3053\u306e\u30da\u30fc\u30b8\u306f ZCTA \u30c7\u30fc\u30bf\u304c NAD 83 \u57fa\u6e96\u70b9\u306b\u57fa\u3065\u304f\u5730\u7406\u5ea7\u6a19\u7cfb\u3092\u4f7f\u3063\u3066\u5b9a\u7fa9\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u8a18\u8ff0\u3057\u3066\u3044\u308b\uff0e\u3044\u304b\u306a\u308b\u7a7a\u9593\u53c2\u7167\u7cfb\u306e WKT \u8868\u73fe\u3067\u3082\uff0c\u4f7f\u7528\u3055\u308c\u308b\u5ea7\u6a19\u306e\u7a2e\u985e\u306e\u8868\u73fe\u306e\u30ad\u30fc\u30ef\u30fc\u30c9\u3067\u958b\u59cb\u3057\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\u3053\u3068\u3092\u6211\u3005\u306f\u77e5\u3063\u3066\u3044\u308b\uff0eZCTA \u30c7\u30fc\u30bf\u306b\u304a\u3044\u3066\u4f7f\u308f\u308c\u308b\u5730\u7406\u5ea7\u6a19\u7cfb\u3067\u306f\uff0c\u3053\u308c\u306f GEOGCS \u3067\u3042\u308b\uff0e\u6211\u3005\u306f\u307e\u305f\uff0c\u7a7a\u9593\u53c2\u7167\u7cfb\u306e WKT \u8868\u73fe\u304c\uff0c\u305d\u308c\u306b\u57fa\u3065\u304f\u57fa\u6e96\u70b9\u306e\u540d\u524d\uff0c\u3053\u3053\u3067\u306f NAD83 \u3060\u304c\uff0c\u305d\u308c\u3092\u8a18\u8ff0\u3057\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\u3053\u3068\u3082\u77e5\u3063\u3066\u3044\u308b\uff0e\u3053\u306e\u60c5\u5831\u304b\u3089\uff0c\u6211\u3005\u306f\u3053\u306e\u7a7a\u9593\u53c2\u7167\u7cfb\u306e\u305f\u3081\u306e\u9069\u5207\u306a\u8b58\u5225\u5b50\u3092 sys.spatial_reference_systems \u30c6\u30fc\u30d6\u30eb\u5185\u3067\u691c\u7d22\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\uff0e\u6b21\u306e\u30af\u30a8\u30ea\u3092\u4f7f\u3046\uff0e<\/p>\n<pre>SELECT  spatial_reference_id\nFROM  sys.spatial_reference_systems\nWHERE  well_known_text LIKE 'GEOGCS%\"NAD83\"%'<\/pre>\n<p>\u3000\u4e00\u884c\u306e\u7d50\u679c\u304c\u8fd4\u3063\u3066\u304f\u308b\uff0e<\/p>\n<pre>spatial_reference_id\n4269<\/pre>\n<p>\u3000\u3055\u3066\uff0c\u3053\u306e shapefile \u306b\u542b\u307e\u308c\u308b\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u306b\u3042\u305f\u3063\u3066\u306f SRID 4269 \u3092\u4f7f\u3046\u3079\u304d\u3067\u3042\u308b\uff0e\u3053\u306e\u7a7a\u9593\u53c2\u7167\u7cfb\u306f\u5730\u7406\u5ea7\u6a19\u306b\u57fa\u3065\u3044\u3066\u3044\u308b\u305f\u3081\uff0c\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u84c4\u7a4d\u3059\u308b\u305f\u3081\u306b\u306f geography \u578b\u3092\u9078\u629e\u3057\u3088\u3046\uff0e\u3053\u306e\u60c5\u5831\u3092\u57fa\u306b\uff0c\u4eca\u3084\u30c7\u30fc\u30bf\u3092 shapefile \u304b\u3089 SQL server \u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u6e96\u5099\u304c\u6574\u3063\u305f\uff0e<\/p>\n<h4>Shapefile \u30c7\u30fc\u30bf\u3092 Shape2SQL \u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/h4>\n<p>\u3000Shap2SQL \u306f\u4eba\u6c17\u306e\uff0c\u7c21\u5358\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u3042\u308a\uff0cshapefile \u30c7\u30fc\u30bf\u3092 SQL Server 2008 \u306b\u642d\u8f09\u3059\u308b\u3053\u3068\u306b\u7279\u5316\u3057\u3066\u8a2d\u8a08\u3055\u308c\u305f\uff0e<a href=\"https:\/\/www.sharpgis.net\/page\/SQL-Server-2008-Spatial-Tools\" target=\"_blank\" rel=\"noopener\">SQL Spatial Tools<\/a> \u30d1\u30c3\u30b1\u30fc\u30b8\u306e\u4e00\u90e8\u3068\u3057\u3066\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u53ef\u80fd\u3067\u3042\u308a\uff0c\u7121\u6599\u3067\u5229\u7528\u53ef\u80fd\u3067\u3042\u308b\uff0e\u6b21\u306e URL \u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\uff0ehttp:\/\/www.sharpgis.net\/page\/SQL-Server-2008-Spatial-Tools.aspx<\/p>\n<p>\u3000SqlSpatialTools zip \u30a2\u30fc\u30ab\u30a4\u30d6\u3092 \u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u89e3\u51cd\u3057\u305f\u3089\uff0cShape2Sql.exe \u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u3066\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u642d\u8f09\u3059\u308b\uff0e\u6700\u521d\u306b Shape2SQL \u3092\u5b9f\u884c\u3057\u305f\u6642\u306b\u306f Figure 6-3 \u306b\u793a\u3059\u3088\u3046\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u306e\u8a73\u7d30\u3092\u5165\u529b\u3059\u308b\u3088\u3046\u4fc3\u3055\u308c\u308b\uff0e<\/p>\n<p>\u3000Database Configuration \u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u3067\u306f\uff0cshapefile \u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\u3044 SQL Server 2008 \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\u3092\u5165\u529b\u3057\uff0c\u30b5\u30fc\u30d0\u30fc\u306b\u63a5\u7d9a\u3059\u308b\u306e\u306b\u5fc5\u8981\u306a\u8a8d\u8a3c\u306e\u3044\u305a\u308c\u304b\u3092\u5165\u529b\u3059\u308b\uff0e\u6b21\u306b\u9069\u5207\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u30ea\u30b9\u30c8\u304b\u3089\u9078\u629e\u3057\uff0cOK \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n<p>\u3000\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u69cb\u6210\u304c\u5b8c\u4e86\u3057\u305f\u3089\uff0cShape2SQL \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30e1\u30a4\u30f3\u30a6\u30a3\u30f3\u30c9\u30a6\u304c\u8868\u308c\u308b\uff0eFigure 6-4 \u306bShape2SQL \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u793a\u3057\uff0c\u5148\u306b\u4fdd\u5b58\u3057\u305f\u30ab\u30ea\u30d5\u30a9\u30eb\u30cb\u30a2\u5dde ZCTA \u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u306e\u306b\u5fc5\u8981\u306a\u8a2d\u5b9a\u3092\u793a\u3057\u3066\u3042\u308b\uff0e<\/p>\n<p>\u3000\u30ab\u30ea\u30d5\u30a9\u30eb\u30cb\u30a2\u5dde ZCTA \u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u306e\u306b\u9069\u5207\u306a\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u8a2d\u5b9a\u3059\u308b\u305f\u3081\u306b\u6b21\u306e\u30b9\u30c6\u30c3\u30d7\u306b\u5f93\u3046\uff0e<\/p>\n<p>\u6ce8\u610f\u3000shapefile \u3092 Shape2SQL \u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u305f\u3081\u306b\u306f\uff0cSHP \u30d5\u30a1\u30a4\u30eb\u3068 SHX \u30d5\u30a1\u30a4\u30eb\u306f\u5fc5\u305a\u540c\u3058\u5834\u6240\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\uff0e\u4eee\u306b\u95a2\u9023\u3059\u308b DBF \u30d5\u30a1\u30a4\u30eb\u304c\u540c\u3058\u5834\u6240\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u3068\uff0c\u5404\u5f62\u614b\u306b\u95a2\u9023\u3059\u308b\u4ed8\u52a0\u7684\u306a\uff0c\u975e\u7a7a\u9593\u5c5e\u6027\u3092 DBF \u30d5\u30a1\u30a4\u30eb\u304b\u3089 SQL Server \u30c6\u30fc\u30d6\u30eb\u306e\u5217\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3068\u306a\u308b\uff0e<\/p>\n<p>\u6ce8\u610f\u3000\u4eee\u306b\u3067\u3082 shapefile \u304c .prj \u62e1\u5f35\u5b50\u306e\u3042\u308b\u30d5\u30a1\u30a4\u30eb\u3092\u4fdd\u6709\u3059\u308b\u306a\u3089\uff0c\u5fc5\u305a\u5bfe\u5fdc\u3059\u308b SRID \u3092\u624b\u52d5\u3067\u6307\u5b9a\u3057\uff0cPRJ \u30d5\u30a1\u30a4\u30eb\u5185\u306b\u542b\u307e\u308c\u308b\u8a73\u7d30\u3092\u9069\u5408\u3055\u305b\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\uff0eShape2SQL \u306f\u5bfe\u5fdc\u3059\u308b SRID \u3092\u81ea\u52d5\u3067\u306f\u8a2d\u5b9a\u3057\u3066\u304f\u308c\u306a\u3044\uff0e<\/p>\n<p>\u4ed8\u8a18\u3000\u4ed8\u52a0\u7684\u306a\u30c7\u30fc\u30bf\u5217\u306f\u95a2\u9023\u3059\u308b DBF \u30d5\u30a1\u30a4\u30eb\u306b\u542b\u307e\u308c\u308b\u30c7\u30fc\u30bf\u306b\u57fa\u3065\u3044\u3066\u3044\u308b\uff0e\u4eee\u306b DBF \u30d5\u30a1\u30a4\u30eb\u304c\u5b58\u5728\u3057\u306a\u3044\u306a\u3089\uff0c\u5404\u30b7\u30a7\u30a4\u30d7\u306b\u95a2\u9023\u3059\u308b\u4ed8\u52a0\u60c5\u5831\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u306a\u3044\uff0e<\/p>\n<ol>\n<li>\u30b9\u30af\u30ea\u30fc\u30f3\u53f3\u4e0a\u306e\u30b3\u30fc\u30ca\u30fc\u306b\u3042\u308b&#8230;\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\uff0cshapefile \u3092\u9078\u629e\u3059\u308b\uff0e\u4fdd\u5b58\u3057\u3066\u304a\u3044\u305f zt06_d00.shp \u30d5\u30a1\u30a4\u30eb\u306e\u4f4d\u7f6e\u3092\u63a2\u3057\u3066\u30cf\u30a4\u30e9\u30a4\u30c8\u3057\uff0cOpen \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306f shapefile \u5185\u3067\u898b\u3064\u304b\u3063\u305f\u5f62\u614b\u306e\u6570\u3068\u7a2e\u985e\u3092\u8868\u793a\u3059\u308b\uff0ezt06_d00.shp \u30d5\u30a1\u30a4\u30eb\u306f\u3053\u306e\u5834\u5408\uff0c2490 \u500b\u306e Polygon \u5f62\u614b\u3092\u4fdd\u6709\u3057\u3066\u3044\u305f\uff0e<\/li>\n<li>Database Properties \u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f Server \u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3066\u9069\u5207\u306a\u30b5\u30fc\u30d0\u30fc\u3068\u3069\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30c7\u30fc\u30bf\u3092\u633f\u5165\u3059\u308b\u304b\u3092\u6307\u5b9a\u3059\u308b\uff0e\u4eee\u306b\u8a73\u7d30\u3092\u5909\u66f4\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u306a\u3089\uff0cConfigure \u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066 Database Configuration \u30c0\u30a4\u30a2\u30ed\u30b0\u30dc\u30c3\u30af\u30b9\u3092\u958b\u304f\uff0e<\/li>\n<li>Geometry Properties \u30bb\u30af\u30b7\u30e7\u30f3\u306f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30a6\u30a3\u30f3\u30c9\u30a6\u306e\u5de6\u4e0b\u306b\u3042\u308a\uff0c\u6b21\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u3092 SQL Server \u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u65b9\u6cd5\u3092\u6307\u5b9a\u3059\u308b\uff0e\n<ul style=\"list-style-type: disc;\">\n<li>Replace existing table: \u3053\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b\u3068\uff0c\u4eee\u306b\u6307\u5b9a\u3057\u305f\u540d\u524d\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u65e2\u306b\u5b58\u5728\u3059\u308b\u5834\u5408\uff0c\u305d\u308c\u306f\u524a\u9664\u3055\u308c\uff0c\u30a4\u30f3\u30dd\u30fc\u30c8\u3055\u308c\u305f\u5f62\u614b\u30c7\u30fc\u30bf\u3092\u542b\u3080\u65b0\u3057\u3044\u30c6\u30fc\u30d6\u30eb\u306b\u7f6e\u63db\u3055\u308c\u308b\uff0e\u30c1\u30a7\u30c3\u30af\u3057\u306a\u3044\u306a\u3089\uff0c\u4ee3\u308f\u308a\u306b\u30c7\u30fc\u30bf\u306f\u65e2\u306b\u5b58\u5728\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u306b\u8ffd\u52a0\u3055\u308c\u308b\uff0e\u4eee\u306b\u6307\u5b9a\u3057\u305f\u540d\u524d\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u5b58\u5728\u3057\u306a\u3044\u306a\u3089\uff0c\u3053\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u6709\u7121\u306b\u95a2\u4fc2\u306a\u304f\u65b0\u3057\u3044\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u6210\u3055\u308c\u308b\uff0e<\/li>\n<li>Planar Geometry\/Geography (Spheric): \u633f\u5165\u3059\u308b\u30c7\u30fc\u30bf\u304c\u30a4\u30f3\u30dd\u30fc\u30c8\u3055\u308c\u308b\u5217\u306e\u30c7\u30fc\u30bf\u578b\u3092\u5b9a\u7fa9\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u3053\u3053\u304b\u3089\u9078\u629e\u3059\u308b\uff0ePlanar Geometry \u578b\u3092\u9078\u629e\u3059\u308b\u3068 geometry \u578b\u304c\u4f7f\u308f\u308c\u308b\u3053\u3068\u306b\u306a\u308a\uff0cGeography (Spheric) \u3092\u9078\u629e\u3059\u308b\u3068 geography \u578b\u3092\u9078\u629e\u3059\u308b\u3053\u3068\u306b\u306a\u308b\uff0e\u30ab\u30ea\u30d5\u30a9\u30eb\u30cb\u30a2\u5dde ZCTA \u30c7\u30fc\u30bf\u306f\u5730\u7406\u5ea7\u6a19\u3092\u4f7f\u3063\u3066\u5b9a\u7fa9\u3055\u308c\u3066\u304a\u308a\uff0c Geography (Spheric) \u3092\u9078\u629e\u3059\u308b\uff0e<\/li>\n<li>Set SRID: \u5f62\u614b\u306e\u3069\u306e\u5ea7\u6a19\u304c\u5b9a\u7fa9\u3055\u308c\u308b\u304b\u306e\u7a7a\u9593\u53c2\u7167\u7cfb\u3092\u8b58\u5225\u3059\u308b\u6574\u6570\u5024\u306e\u5165\u529b\u306f\u5fc5\u9808\u3067\u3042\u308b\uff0e\u4eee\u306b shapefile \u304c .prj \u62e1\u5f35\u5b50\u3092\u6301\u3064\u30d5\u30a1\u30a4\u30eb\u306b\u95a2\u9023\u3057\u3066\u7531\u6765\u3059\u308b\u306a\u3089\uff0c\u305d\u306e\u30d5\u30a1\u30a4\u30eb\u5185\u306b\u542b\u307e\u308c\u308b\u8a73\u7d30\u306b\u5bfe\u5fdc\u3059\u308b SRID \u3092\u9078\u629e\u3059\u3079\u304d\u3067\u3042\u308b\uff0e\u4eee\u306b PRJ \u30d5\u30a1\u30a4\u30eb\u304c\u5b58\u5728\u3057\u306a\u3044\u306a\u3089\uff0c\u4ee3\u308f\u308a\u306b\u8a72\u5f53\u30d5\u30a1\u30a4\u30eb\u306b\u95a2\u9023\u3059\u308b\u4ed6\u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u3092\u691c\u67fb\u3059\u308b\u304b\uff0c\u3042\u308b\u3044\u306f\u30c7\u30fc\u30bf\u306e\u63d0\u4f9b\u8005\u306b\u63a5\u89e6\u3059\u308b\u304b\u3057\u3066\uff0c\u9069\u5207\u306a\u7a7a\u9593\u53c2\u7167\u7cfb\u3092\u5fc5\u305a\u898b\u3064\u3051\u51fa\u3055\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\uff0e\u3053\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306f\u3059\u3067\u306b\u5b9a\u7fa9\u3055\u308c\u305f\u5ea7\u6a19\u304c\u5b58\u5728\u3059\u308b\u7a7a\u9593\u53c2\u7167\u3092\u8b58\u5225\u3059\u308b\u3053\u3068\u3092\u7279\u8a18\u3057\u3066\u304a\u304f\uff0e\u305d\u308c\u306f\uff0c\u305d\u3053\u306b\u30c7\u30fc\u30bf\u3092\u6295\u5f71\u3057\u305f\u3044\u7a7a\u9593\u53c2\u7167\u7cfb\u3092\u8b58\u5225\u3059\u308b\u3082\u306e\u3067\u306f\u306a\u3044\uff0e\u30ab\u30ea\u30d5\u30a9\u30eb\u30cb\u30a2\u5dde ZCTA \u306b\u95a2\u3057\u3066\u306f\uff0cSRID \u306b\u306f 4269 \u3068\u5165\u529b\u3059\u308b\uff0e<\/li>\n<li>Create Spatial Index: \u3053\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u30c1\u30a7\u30c3\u30af\u3055\u308c\u308b\u3068\uff0cShape2SQL \u306f\u81ea\u52d5\u3067\u30c7\u30fc\u30bf\u306e\u633f\u5165\u3055\u308c\u308b\u30c6\u30fc\u30d6\u30eb\u306b\u7a7a\u9593\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u751f\u6210\u3059\u308b\uff0e\u7a7a\u9593\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u7279\u5b9a\u306e\u7a7a\u9593\u30af\u30a8\u30ea\u306e\u901f\u5ea6\u3092\u6539\u5584\u3057\uff0c\u3053\u308c\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u7b2c 14 \u7ae0\u3067\u8b70\u8ad6\u3059\u308b\uff0e<\/li>\n<li>Table Name: \u3053\u306e\u5024\u306f\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u3055\u308c\u308b\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u5b9a\u7fa9\u3059\u308b\uff0e\u4eee\u306b\u30c6\u30fc\u30d6\u30eb\u304c\u65e2\u306b\u5b58\u5728\u3057\u3066\u304a\u308a\uff0cReplace Existing Table \u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u30c1\u30a7\u30c3\u30af\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\uff0c\u3053\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u30b9\u30ad\u30fc\u30de\u306f shapefile \u304b\u3089\u30a4\u30f3\u30dd\u30fc\u30c8\u3055\u308c\u308b\u30c7\u30fc\u30bf\u5217\u306b\u5fc5\u305a\u9069\u5408\u3057\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\uff0e\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30c6\u30fc\u30d6\u30eb\u540d\u306f\u30bd\u30fc\u30b9\u306e shapefile \u306e\u30d5\u30a1\u30a4\u30eb\u540d\u3068\u540c\u3058\u3067\u3042\u308a\uff0c\u3053\u3053\u3067\u306f zt06_d00 \u3068\u306a\u308b\uff0e<\/li>\n<\/ul>\n<\/li>\n<li>Attribute \u30bb\u30af\u30b7\u30e7\u30f3\u306f\u30a6\u30a3\u30f3\u30c9\u30a6\u53f3\u4e0b\u306b\u3042\u308a\uff0c\u6b21\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u306e\u3069\u306e\u5217\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u304b\u3092\u6307\u5b9a\u3059\u308b\uff0e\n<ul style=\"list-style-type: disc;\">\n<li>Geometry Name: \u3053\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u306f\u30a4\u30f3\u30dd\u30fc\u30c8\u3055\u308c\u305f\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u4fdd\u6301\u3059\u308b geometry \u5217\u307e\u305f\u306f geography \u5217\u306e\u540d\u524d\u3092\u5b9a\u7fa9\u3059\u308b\uff0e\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u5217\u540d\u306f geom \u3067\u3042\u308b\uff0e\u5730\u7406\u5ea7\u6a19\u306b\u57fa\u3065\u304f\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3088\u3046\u3068\u3057\u3066\u3044\u308b\u305f\u3081\uff0c\u3053\u3053\u306f geog \u306b\u5909\u66f4\u3059\u308b\uff0e<\/li>\n<li>ID Column Name: \u30c6\u30fc\u30d6\u30eb\u5185\u306e\u5404\u884c\u306b\u4e00\u610f\u306e ID \u3092\u5c0e\u5165\u3057\u305f\u3044\u306a\u3089\uff0c\u3053\u3053\u306b\u305d\u306e\u5217\u540d\u3092\u5165\u529b\u3059\u3079\u304d\u3067\u3042\u308b\uff0e\u3053\u306e\u5024\u306f\u751f\u6210\u3055\u308c\u305f\u30c6\u30fc\u30d6\u30eb\u5185\u306b IDENTIFY(1, 1) \u306e\u6574\u6570\u5217\u3092\u751f\u6210\u3057\uff0c\u305d\u306e\u5217\u306b\u57fa\u3065\u3044\u305f\u4e3b\u30ad\u30fc\u3092\u4f5c\u6210\u3059\u308b\uff0e\u4eee\u306b ID \u5217\u3092\u4f5c\u6210\u3057\u305f\u304f\u306a\u3044\u306a\u3089\uff0c\u3053\u306e\u5024\u306f\u7a7a\u306e\u307e\u307e\u306b\u3057\u3066\u304a\u304f\uff0e<\/li>\n<li>Optional attributes box: Attribute \u30bb\u30af\u30b7\u30e7\u30f3\u306e\u6700\u5f8c\u306e\u30dc\u30c3\u30af\u30b9\u3067\u306f\uff0c\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u4ed8\u52a0\u7684\u306a\u30c7\u30fc\u30bf\u5217\u306b\uff0cshapefile \u5185\u306b\u95a2\u9023\u3059\u308b\u5404\u5f62\u614b\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u304b\u5426\u304b\u3092\u9078\u629e\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\uff0e\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\u3044\u5404\u5c5e\u6027\u306e\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e\u5404\u5c5e\u6027\u306f SQL Server \u30c6\u30fc\u30d6\u30eb\u5185\u306e\u305d\u308c\u81ea\u8eab\u306e\u5217\u306b\u5bfe\u5fdc\u3059\u308b\uff0e<\/li>\n<\/ul>\n<\/li>\n<li>\u9078\u629e\u3057\u305f\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6e80\u305f\u3057\u305f\u3089\uff0cUpload to Database \u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/li>\n<\/ol>\n<p>\u3000Shape2SQL \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u30a4\u30f3\u30dd\u30fc\u30c8\u3092\u5b8c\u4e86\u3057\u305f\u3089\uff0c\u6b21\u306e\u30af\u30a8\u30ea\u3092 SQL Server Management Studio \u3067\u5b9f\u884c\u3057\u3066\u30c7\u30fc\u30bf\u3092\u30c6\u30b9\u30c8\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308b\uff0e<\/p>\n<pre>SELECT  TOP 5\nZCTA, \ngeog.STAsText() AS WKT\nFROM  zt06_d00<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u6b21\u306e\u901a\u308a\uff0e<\/p>\n<pre>ZCTA   WKT\n96044  POLYGON ((-122.671733 41.914761, -122.682284 41...\n960XX  POLYGON ((-122.671733 41.914761, -122.677967 41...\n96023  POLYGON ((-122.161862 41.881475, -122.156785 41...\n96064  POLYGON ((-122.161862 41.881475, -122.156785 41...\n96086  POLYGON ((-123.136812 41.866186, -123.1422 41...<\/pre>\n<h3>\u30b5\u30fc\u30c9\u30d1\u30fc\u30c6\u30a3\u88fd\u306e\u5909\u63db\u30c4\u30fc\u30eb\u3092\u4f7f\u3046<\/h3>\n<p>\u3000\u672c\u7ae0\u3067\u8b70\u8ad6\u3057\u3066\u304d\u305f\u6280\u8853\u306f\uff0c\u3055\u307e\u3056\u307e\u306a\u7c21\u7d20\u306a\u624b\u6cd5\u3067\u3042\u308a\uff0cSQL Server 2008 \u306b\u3055\u307e\u3056\u307e\u306a\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306e\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\uff0e\u3057\u304b\u3057\u4eee\u306b\uff0c\u65e2\u5b58\u306e\u5de8\u5927\u306a\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306e\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3064\u3082\u308a\u306a\u3089\uff0c\u3053\u306e\u76ee\u7684\u306e\u305f\u3081\u306b\u8a2d\u8a08\u3055\u308c\u305f\u5c02\u7528\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3046\uff0c\u3082\u3063\u3068\u3075\u3055\u308f\u3057\u3044\u65b9\u6cd5\u304c\u5b58\u5728\u3059\u308b\u3053\u3068\u306b\u6c17\u304c\u3064\u304f\u3060\u308d\u3046\uff0e\u7a7a\u9593\u30c7\u30fc\u30bf\u3092 SQL Server 2008 \u304c\u4f7f\u3048\u308b\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306e\u4e00\u3064\u306b\u5909\u63db\u3059\u308b\u306e\u3092\u4fc3\u9032\u3059\u308b\u306e\u306b\u5229\u7528\u53ef\u80fd\u306a\u30c4\u30fc\u30eb\u306f\u6570\u591a\u304f\u5b58\u5728\u3059\u308b\uff0e\u3053\u308c\u3089\u306e\u30c4\u30fc\u30eb\u306e\u3044\u304f\u3064\u304b\u306f\u7121\u6599\u3067\u5229\u7528\u53ef\u80fd\u3067\u3042\u308b\u4e00\u65b9\u3067\uff0c\u4ed6\u306e\u30c4\u30fc\u30eb\u306f Microsoft \u306e\u7a7a\u9593\u30d1\u30fc\u30c8\u30ca\u30fc\u306b\u3088\u3063\u3066\u958b\u767a\u3055\u308c\u305f\u5546\u7528\u30c4\u30fc\u30eb\u3067\u3042\u308b\uff0e\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u6709\u7528\u3068\u601d\u308f\u308c\u308b\u30c4\u30fc\u30eb\u306e\u3044\u304f\u3064\u304b\u3092\u7d39\u4ecb\u3059\u308b\uff0e<\/p>\n<h4>\u5546\u7528\u30c4\u30fc\u30eb<\/h4>\n<p>\u3000SQL Server 2008 \u3092\u30b5\u30dd\u30fc\u30c8\u3059\u308b\u5546\u7528\u30c4\u30fc\u30eb\u306e\u591a\u304f\u306f\u7a7a\u9593\u30c7\u30fc\u30bf\u306e\u5b8c\u5168\u62bd\u51fa\uff0c\u5909\u63db\uff0c\u642d\u8f09 (ETL) \u30d7\u30ed\u30bb\u30b9\u3092\u63d0\u4f9b\u3057\u3066\u304a\u308a\uff0c\u591a\u304f\u306e\u7570\u306a\u308b\u7a7a\u9593\u30c7\u30fc\u30bf\u578b\u306e\u9593\u3067\u306e\u5909\u63db\u3092\u53ef\u80fd\u3068\u3059\u308b\uff0e\u30d5\u30a1\u30a4\u30eb\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u81ea\u4f53\u306e\u5358\u7d14\u306a\u5909\u63db\u306b\u52a0\u3048\u3066\uff0c\u3053\u308c\u3089\u306e\u30c4\u30fc\u30eb\u306f\u307e\u305f\u30d5\u30a1\u30a4\u30eb\u5185\u306b\u4fdd\u6709\u3059\u308b\u30c7\u30fc\u30bf\u306e\u518d\u6295\u5f71\u3092\u3082\u63d0\u4f9b\u3057\u3066\u304a\u308a\uff0c\u30c7\u30fc\u30bf\u306e\u8996\u899a\u5316\u3068\u89e3\u6790\u3082\u540c\u69d8\u3067\u3042\u308b\uff0e\u3044\u304f\u3064\u304b\u306e\u5546\u7528\u30c4\u30fc\u30eb\u3092\u6b21\u306b\u793a\u3059\uff0e<\/p>\n<ul>\n<li><a href=\"https:\/\/www.esrij.com\/products\/arcgis\/\" target=\"_blank\" rel=\"noopener\">ArcGIS<\/a> \uff08\u30d0\u30fc\u30b8\u30e7\u30f3 9.3 \u304a\u3088\u3073\u305d\u308c\u4ee5\u4e0a\uff09\u306f\uff0c\u9577\u671f\u78ba\u7acb\u3057\u305f\u696d\u754c\u6a19\u6e96\u306e ESRI (http:\/\/www.esri.com) \u304b\u3089\u306e GIS \u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\uff0cSQL Server 2008 \u3068\u5171\u306b\u767a\u5c55\u3057\u3066\u7a7a\u9593\u30c7\u30fc\u30bf\u306e\u64cd\u4f5c\uff0c\u89e3\u6790\u304a\u3088\u3073\u30d7\u30ec\u30bc\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u306e\u3059\u3079\u3066\u306e\u5074\u9762\u3092\u30b5\u30dd\u30fc\u30c8\u3059\u308b\u591a\u304f\u306e\u30c4\u30fc\u30eb\u3092\u63d0\u4f9b\u3057\u3066\u304d\u305f\uff0e<\/li>\n<li><a href=\"http:\/\/manifold.net\/\" target=\"_blank\" rel=\"noopener\">Manifold<\/a> (http:\/\/manifold.net) \u3082\u307e\u305f SQL Server 2008 \u306b\u76f4\u63a5\u63a5\u7d9a\u3057\u3066\u6570\u767e\u306e\u7a7a\u9593\u30c7\u30fc\u30bf\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\uff0c\u518d\u6295\u5f71\u304a\u3088\u3073\u7a7a\u9593\u30c7\u30fc\u30bf\u306e\u8996\u899a\u7de8\u96c6\u9593\u306e\u5909\u63db\u3068\u30a4\u30f3\u30dd\u30fc\u30c8\u3092\u63d0\u4f9b\u3059\u308b\uff0e<\/li>\n<li>Feature Manipulation Engine (FME) \u306f Safe Software (<a href=\"https:\/\/www.safe.com\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.safe.com<\/a>) \u306e\u8a2d\u8a08\u3067\uff0c\u5e83\u7bc4\u56f2\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u9593\u306e\u7a7a\u9593\u30c7\u30fc\u30bf\u306e\u5909\u63db\u3092\u4fc3\u9032\u3059\u308b\u304c\uff0c\u305d\u308c\u3082\u307e\u305f\u57fa\u672c\u7684\u306a\u8996\u899a\u5316\u30c4\u30fc\u30eb\u306b\u542b\u307e\u308c\u308b\uff0e\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u306e\u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u52a0\u3048\u3066\uff0cFME \u306f SQL Server Integration Services (SSIS) \u3092\u62e1\u5f35\u3057\uff0c\u65e2\u306b\u5b58\u5728\u3059\u308b SSIS \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u4e00\u90e8\u3068\u3057\u3066\u8907\u96d1\u306a\u7a7a\u9593 ETL \u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u308b\uff0e<\/li>\n<\/ul>\n<h4>\u7121\u6599\u30c4\u30fc\u30eb<\/h4>\n<p>\u3000\u4eee\u306b\u4e8c\u3064\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u9593\u3067\u306e\u5358\u7d14\u306a\u5909\u63db\u3057\u304b\u5fc5\u8981\u3068\u3057\u306a\u3044\u306a\u3089\uff0c\u4ee3\u308f\u308a\u306b\u6b21\u306b\u793a\u3059\u30bd\u30fc\u30b9\u306e\u5185\u306e\u4e00\u3064\u3092\u8abf\u3079\u305f\u304f\u306a\u308b\u306b\u9055\u3044\u306a\u3044\uff0e<\/p>\n<ul>\n<li>FWTools (<a href=\"https:\/\/fwtools.org\/\" target=\"_blank\" rel=\"noopener\">http:\/\/fwtools.org<\/a>) \u306f\u69d8\u3005\u306a\u6709\u7528\u306a\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u306e GIS \u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3092\u542b\u3080\u30d1\u30c3\u30b1\u30fc\u30b8\u3067\u3042\u308a\uff0cOGR \u30e9\u30a4\u30d6\u30e9\u30ea\u304a\u3088\u3073\u7a7a\u9593\u30c7\u30fc\u30bf\u9593\u306e\u5909\u63db\u306e\u305f\u3081\u306e\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30c4\u30fc\u30eb\u3082\u542b\u307e\u308c\u308b\uff0e<\/li>\n<li>Spatial Order (http:\/\/spatialorder.com\/downloads.htm) \u306f\u591a\u304f\u306e\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u5909\u63db\u30c4\u30fc\u30eb\u3092\u7121\u6599\u3067\u63d0\u4f9b\u3059\u308b\u30b3\u30f3\u30b5\u30eb\u30bf\u30f3\u30c8\u30d5\u30a1\u30fc\u30e0\u3067\u3042\u308a\uff0c\u305d\u3053\u306b\u306f ESRI shapefile \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u304b\u3089 GML \u3078\u306e\u30c4\u30fc\u30eb (<a href=\"http:\/\/cdr.eionet.europa.eu\/help\/cdda\/FME_processes\/Shp2GML.html\" target=\"_blank\" rel=\"noopener\">shp2gml<\/a>) \u3084 ESRI \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u304b\u3089 WKT \u3078\u306e\u30c4\u30fc\u30eb (<a href=\"https:\/\/github.com\/sagarlekar\/shp2wkt\" target=\"_blank\" rel=\"noopener\">shp2wkt<\/a>) \u3082\u542b\u307e\u308c\u308b\uff0e<\/li>\n<li><a href=\"http:\/\/www.zonums.com\/\" target=\"_blank\" rel=\"noopener\">Zonum Solutions<\/a> (http:\/\/www.zonum.com) \u306f ESRI shapefile \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3068 Google Earth KML \u30d5\u30a1\u30a4\u30eb\u9593\u306e\u5909\u63db\u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3\u3092\u63d0\u4f9b\u3057\uff0c\u5ea7\u6a19\u7cfb\u3068\u57fa\u6e96\u70b9\u306e\u7bc4\u56f2\u306e\u9593\u306e\u5909\u63db\u80fd\u529b\u3082\u542b\u307e\u308c\u308b\uff0e<\/li>\n<\/ul>\n<h3>\u8981\u7d04<\/h3>\n<p>\u3000\u672c\u7ae0\u3067\u306f\uff0c\u305d\u3053\u3067\u7a7a\u9593\u30c7\u30fc\u30bf\u304c\u63d0\u4f9b\u3055\u308c\u3066\u3044\u308b\u69d8\u3005\u306a\u30c7\u30fc\u30bf\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u3064\u3044\u3066\uff0c\u307e\u305f\u305d\u308c\u3089\u306e\u30c7\u30fc\u30bf\u3092 SQL Server 2008 \u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u7fd2\u5f97\u3057\u305f\uff0e\u7279\u306b\uff0c\u672c\u7ae0\u3067\u306f\u6b21\u306e\u70b9\u306b\u3064\u3044\u3066\u30ab\u30d0\u30fc\u3057\u305f\uff0e<\/p>\n<ul>\n<li>\u591a\u304f\u306e\u4ee3\u66ff\u53ef\u80fd\u306a\u30d5\u30a1\u30a4\u30eb\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u304c\u5b58\u5728\u3057\u3066\u304a\u308a\uff0c\u7a7a\u9593\u60c5\u5831\u306f\u305d\u3053\u3067\u666e\u901a\u306b\u63d0\u4f9b\u3055\u308c\u3066\u304a\u308a\uff0c\u8868\u5f62\u5f0f\u306e\u5730\u7406\u60c5\u5831\u3084 ESRI shapefile \u304a\u3088\u3073 Google Earth \u3067\u3082\u4f7f\u7528\u3055\u308c\u308b KML \u30d5\u30a1\u30a4\u30eb\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u542b\u3080\uff0e<\/li>\n<li>\u591a\u304f\u306e\u8cc7\u6e90\u304c\u3042\u308a\uff0c\u305d\u3053\u304b\u3089\u81ea\u7531\u306b\u5229\u7528\u3067\u304d\u308b\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u7d4c\u7531\u3067\u53d6\u5f97\u53ef\u80fd\u3067\u3042\u308b\uff0e\u305d\u306e\u8cc7\u6e90\u304b\u3089\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u306f\u54c1\u8cea\u3068\u30ab\u30d0\u30fc\u7387\u306f\u69d8\u3005\u306a\u7bc4\u56f2\u306b\u3042\u308b\uff0e\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u91cd\u8981\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u4f7f\u3044\u305f\u3044\u306a\u3089\uff0c\u307e\u305a\u305d\u306e\u30c7\u30fc\u30bf\u306e\u7cbe\u5ea6\u306b\u6ce8\u610f\u3059\u3079\u304d\u3067\u3042\u308b\uff01<\/li>\n<li>\u8868\u5f62\u5f0f\u3067\u63d0\u4f9b\u3055\u308c\u308b\u7c21\u5358\u306a\u7a7a\u9593\u60c5\u5831\u306f\uff0c\u30a4\u30f3\u30dd\u30fc\u30c8\u30fb\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30dd\u30fc\u30c8\u3067\u304d\u308b\uff0eT-SQL \u306e UPDATE \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3068\u540c\u6642\u306b geography \u578b\u306e Point() \u9759\u7684\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3044\uff0c\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u5404\u884c\u306e\u5ea7\u6a19\u5024\u304b\u3089 geography \u578b\u307e\u305f\u306f geometry \u578b\u306e\u5217\u3092\u79fb\u5165\u3059\u308b\uff0e<\/li>\n<li>z \u5ea7\u6a19\u3092\u542b\u3080\u8868\u5f62\u5f0f\u306e\u60c5\u5831\u304b\u3089\u7a7a\u9593\u30c7\u30fc\u30bf\u306e\u30a2\u30a4\u30c6\u30e0\u3092\u69cb\u7bc9\u3059\u308b\u306b\u306f\uff0c\u5404\u5ea7\u6a19\u5024\u306b\u57fa\u3065\u304f geometry \u306e WKT \u8868\u73fe\u3092\u624b\u52d5\u3067\u69cb\u7bc9\u3067\u304d\u308b\uff0e\u6b21\u306b\u305d\u306e\u8868\u73fe\u3092 STPointFromText() \u306e\u3088\u3046\u306a\u95a2\u9023\u3059\u308b WKT \u30e1\u30bd\u30c3\u30c9\u306b\u901a\u3059\uff0e<\/li>\n<li>KML \u306f GML \u540c\u69d8 XML \u30d9\u30fc\u30b9\u306e\u7a7a\u9593\u30c7\u30fc\u30bf\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u3042\u308b\uff0e\u4e8c\u3064\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u9593\u306b\u306f\u3044\u304f\u3064\u304b\u306e\u985e\u4f3c\u6027\u304c\u3042\u308b\u304c\uff0c\u91cd\u8981\u306a\u9055\u3044\u3082\u3042\u308b\uff0eSQL Server \u3092\u4f7f\u3063\u3066 KML \u304b\u3089 GML \u306b\u5909\u63db\u3059\u308b\u305f\u3081\u306b\u306f\uff0c\u5404 KML \u8981\u7d20\u3092\u8a72\u5f53\u3059\u308b GML \u8981\u7d20\u306b\u5909\u63db\u3057\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\uff0e<\/li>\n<li>Shape2SQL \u306f\u7121\u6599\u306e\u30c4\u30fc\u30eb\u3067\u3042\u308a\uff0cESRI shapefile \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u304b\u3089 SQL Server \u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u305f\u3081\u306b\u8a2d\u8a08\u3055\u308c\u3066\u3044\u308b\uff0e<\/li>\n<li>\u4ed6\u306b\u3082\uff0cSQL Server \u306b\u4e92\u63db\u6027\u306e\u3042\u308b\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3057\u305f\u308a\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u305f\u3081\u306e\u591a\u304f\u306e\u30c4\u30fc\u30eb\u304c\u3042\u308b\uff0e<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u3000\u591a\u304f\u306e\u7a7a\u9593\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u30ab\u30b9\u30bf\u30e0\u5b9a\u7fa9\u306e\u7a7a\u9593\u6a5f\u80fd\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u3044\u308b\uff0e\u4f8b\u3048\u3070\u9867\u5ba2\u30bb\u30c3\u30c8\u306e\u5c40\u5728\u3068\uff0c\u5e83\u304f\u53d7\u3051\u5165\u308c\u3089\u308c\u305f\u8868\u73fe\u306e\u7a7a\u9593\u30c7\u30fc\u30bf\uff0c\u5730\u7403\u4e0a\u306e\u6c4e\u7528\u6027\u306e\u3042\u308b\u7279\u5fb4\uff0c\u4f8b\u3048\u3070\u56fd\u3084\u5dde\u306e\u5883\u754c\u7dda\uff0c\u4e16\u754c\u306e\u4e3b\u8981\u90fd\u5e02\u306e\u5c40\u5728\u304a\u3088\u3073\u4e3b\u8981\u306a\u9053\u8def\u3084 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=11193\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;\u7b2c 6 \u7ae0\u3000\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b (Beginning Spatial with SQL Server 2008)&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[7614,7609,7616,7615,7611,7610,7648,7651,7644,7646,7668,7565,4527,7554,7642,7701,7656,7596,7687,7552,7550,7594,7675,7682,7672,7674,7558,7649,7140,4081,7583,7582,7599,7581,7641,7450,7557,7639,7699,4082,7630,7621,7703,2878,2885,7704,4673,7709,7526,5129,7468,4964,7680,7587,7228,7261,7688,7676,7619,7608,7532,7643,7541,7533,7359,555,7637,7638,7689,7692,7622,7623,7600,7597,7598,7559,7605,7560,7662,7666,7142,7702,266,7627,7263,7262,7264,7353,4528,7531,7575,7561,7465,7711,7602,7549,7693,7620,3725,7604,7657,7678,7679,7588,4548,4575,7224,7652,7562,7677,7705,4672,4657,7681,7669,7671,7640,7714,7715,7645,7647,7500,7712,7456,2740,7707,2750,7670,7556,7708,7580,7589,7593,4772,5424,7452,7551,7685,7574,7517,7584,6392,7694,3593,5908,7595,4742,7633,859,7459,7540,7464,7592,7579,7632,7629,7631,7665,7516,7527,7716,7663,7664,7591,7572,7530,7136,2796,4958,4549,2861,7553,7571,7634,7661,2829,7710,7502,7529,7570,7455,7525,7585,4844,7713,2937,7555,1090,4295,7686,1041,4078,1805,7618,2874,7617,5002,7576,2859,462,7706,7573,1026,7510,32,7673,7548,7528,3576,4288,6909,7507,5357,7577,7635,7566,7667,7659,4269,7238,7387,4483,7538,4313,4442,829,7625,7700,7310,7636,4503,7503,5065,7519,7514,5178,7193,7606,7513,7586,7518,7535,7537,289,7568,7442,7202,2764,7695,7658,7624,7236,7697,7506,7504,7626,7271,7523,7698,7601,7509,7603,7508,7309,7522,3592,7547,7524,7660,7521,7569,7546,7520,6230,7511,7590,7536,7543,7501,7683,7684,7181,7696,7653,7188,7512,7654,4016,7545,7234,4017,7534,7544,4960,4013,7208,7567,7607,2591,7578,2761,7563,981,603,2723,7515,4437,7655,7505,7226,7564,7542,7539,7628,7650,7227],"class_list":{"0":"post-11193","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-technology","7":"tag-coordinates","8":"tag-lookat","9":"tag-pos","10":"tag-postlist","11":"tag-styleurl","12":"tag-visibility","13":"tag-dbf","14":"tag-prj","15":"tag-shp","16":"tag-shx","17":"tag-7668","18":"tag-7565","19":"tag-add","20":"tag-alter-table","21":"tag-arc-info","22":"tag-arcgis","23":"tag-area","24":"tag-astextzm","25":"tag-attribute","26":"tag-bcp","27":"tag-bulk-insert","28":"tag-cast","29":"tag-configure","30":"tag-create-spatial-index","31":"tag-database-configuration","32":"tag-database-properties","33":"tag-datetime","35":"tag-depth","36":"tag-developer","37":"tag-double-precision-float","38":"tag-dt_str","39":"tag-earthviewer","40":"tag-enterprise-edition","41":"tag-environmental-systems-research-institute","42":"tag-epsg","43":"tag-eqid","44":"tag-esri","45":"tag-etl","46":"tag-express","47":"tag-extensible-stylesheet-language-transformation","48":"tag-exterior","49":"tag-feature-manipulation-engine","50":"tag-flat-file-source","51":"tag-float","52":"tag-fme","53":"tag-from","54":"tag-fwtools","55":"tag-gadm","56":"tag-gdp","57":"tag-geogcs","58":"tag-geography","59":"tag-geography-spheric","61":"tag-geometry","62":"tag-geometry-collection","63":"tag-geometry-name","64":"tag-geometry-properties","65":"tag-geometrycoolection","66":"tag-geomfromgml","67":"tag-geonet","68":"tag-gis","69":"tag-gml","70":"tag-gns","71":"tag-google-earth","72":"tag-gps","73":"tag-gps-exchange-format","74":"tag-gpx","75":"tag-id-column-name","76":"tag-identify","77":"tag-innerboundaryis","78":"tag-interior","79":"tag-keyhole","80":"tag-keyhole-markup-language","81":"tag-kml","82":"tag-lat","83":"tag-linestring","84":"tag-lon","85":"tag-lsad","86":"tag-lsad_trans","87":"tag-magnitude","88":"tag-manifold","89":"tag-microsoft","90":"tag-multielement-geometry","91":"tag-multilinestring","92":"tag-multipoint","93":"tag-multipolygon","94":"tag-nad-83","95":"tag-name","96":"tag-nga","97":"tag-none","98":"tag-nst","99":"tag-ogc","100":"tag-ogr","101":"tag-open-geospatial-consortium","102":"tag-openrowset","103":"tag-optional-attributes-box","104":"tag-outerboundaryis","105":"tag-outputcolumnwidth","106":"tag-paths","107":"tag-perimeter","108":"tag-planar-geometry-geography-spheric","109":"tag-planar-geometry","110":"tag-point","111":"tag-points","113":"tag-polygons","115":"tag-region","116":"tag-replace-existing-table","117":"tag-safe-software","118":"tag-select","119":"tag-set","120":"tag-set-srid","121":"tag-shape2sql","122":"tag-shape2sql-exe","123":"tag-shapefile","124":"tag-shp2gml","125":"tag-shp2wkt","128":"tag-spatial","129":"tag-spatial-orde","130":"tag-spatial_reference_id","131":"tag-sql-server","132":"tag-sql-server-integration-services","133":"tag-sql-server-management-studio","134":"tag-sql-spatial-tools","135":"tag-src","136":"tag-ssis","137":"tag-standard","138":"tag-stastext","139":"tag-stpointfromtext","140":"tag-string","141":"tag-style","142":"tag-sys-spatial_reference_systems","143":"tag-t-sql","144":"tag-table-name","145":"tag-text-qualifier","146":"tag-tiger","147":"tag-two-byte-signed-integer","148":"tag-update","149":"tag-upload-to-database","150":"tag-url","151":"tag-usgs","152":"tag-varchar","153":"tag-version","154":"tag-w3c","155":"tag-web","156":"tag-well_known_text","157":"tag-wkb","158":"tag-wkt","160":"tag-workgroup-edition","161":"tag-world-wide-web-consortium","162":"tag-xquery","163":"tag-xslt","164":"tag-zcta","165":"tag-zctas","166":"tag-zip","167":"tag-zonum-solutions","168":"tag-zt06-d00","169":"tag-zt06-d00-id","170":"tag-z","171":"tag-7572","172":"tag-7530","173":"tag-7136","174":"tag-2796","175":"tag-4958","176":"tag-4549","177":"tag-2861","178":"tag-7553","179":"tag-7571","180":"tag-7634","181":"tag-7661","182":"tag-2829","183":"tag-7710","184":"tag-7502","185":"tag-7529","186":"tag-7570","187":"tag-7455","188":"tag-7525","189":"tag-7585","190":"tag-4844","191":"tag-7713","192":"tag-2937","193":"tag-7555","194":"tag-1090","195":"tag-4295","196":"tag-7686","197":"tag-1041","198":"tag-4078","199":"tag-1805","200":"tag-7618","201":"tag-2874","202":"tag-7617","203":"tag-5002","204":"tag-7576","205":"tag-2859","206":"tag-462","207":"tag-7706","208":"tag-7573","209":"tag-1026","210":"tag-7510","211":"tag-32","212":"tag-7673","213":"tag-7548","214":"tag-7528","215":"tag-3576","216":"tag-4288","217":"tag-6909","218":"tag-7507","219":"tag-5357","220":"tag-7577","221":"tag-7635","222":"tag-7566","223":"tag-7667","224":"tag-7659","225":"tag-4269","226":"tag-7238","227":"tag-7387","228":"tag-4483","229":"tag-7538","230":"tag-4313","231":"tag-4442","232":"tag-829","233":"tag-7625","234":"tag-7700","235":"tag-7310","236":"tag-7636","237":"tag-4503","238":"tag-7503","239":"tag-5065","240":"tag-7519","241":"tag-7514","242":"tag-5178","243":"tag-7193","244":"tag-7606","245":"tag-7513","246":"tag-7586","247":"tag-7518","248":"tag-7535","249":"tag-7537","250":"tag-289","251":"tag-7568","252":"tag-7442","253":"tag-7202","254":"tag-2764","255":"tag-7695","256":"tag-7658","257":"tag-7624","258":"tag-7236","259":"tag-7697","260":"tag-7506","261":"tag-7504","262":"tag-7626","263":"tag-7271","264":"tag-7523","265":"tag-7698","266":"tag-7601","267":"tag-7509","268":"tag-7603","269":"tag-7508","270":"tag-7309","271":"tag-7522","272":"tag-3592","273":"tag-7547","274":"tag-7524","275":"tag-7660","276":"tag-7521","277":"tag-7569","278":"tag-7546","279":"tag-7520","280":"tag-6230","281":"tag-7511","282":"tag-7590","283":"tag-7536","284":"tag-7543","285":"tag-7501","286":"tag-7683","287":"tag-7684","288":"tag-7181","289":"tag-7696","290":"tag-7653","291":"tag-7188","292":"tag-7512","293":"tag-7654","294":"tag-4016","295":"tag-7545","296":"tag-7234","297":"tag-4017","298":"tag-7534","299":"tag-7544","300":"tag-4960","301":"tag-4013","302":"tag-7208","303":"tag-7567","304":"tag-7607","305":"tag-2591","306":"tag-7578","307":"tag-2761","308":"tag-7563","309":"tag-981","310":"tag-603","311":"tag-2723","312":"tag-7515","313":"tag-4437","314":"tag-7655","315":"tag-7505","316":"tag-7226","317":"tag-7564","318":"tag-7542","319":"tag-7539","320":"tag-7628","321":"tag-7650","322":"tag-7227"},"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/11193","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=11193"}],"version-history":[{"count":193,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/11193\/revisions"}],"predecessor-version":[{"id":13656,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/11193\/revisions\/13656"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}