{"id":13102,"date":"2020-12-31T06:00:00","date_gmt":"2020-12-30T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=13102"},"modified":"2022-07-29T14:43:06","modified_gmt":"2022-07-29T05:43:06","slug":"shape2sql-%e3%81%a7%e3%82%b7%e3%82%a7%e3%83%bc%e3%83%97%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab%e3%82%92-sql-server-2008-r2-%e3%81%ab%e3%82%a2%e3%83%83%e3%83%97%e3%83%ad%e3%83%bc%e3%83%89%e3%81%99","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=13102","title":{"rendered":"Shape2SQL \u3067\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092 SQL Server 2008 R2 \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b"},"content":{"rendered":"\n

\u3000Shape2SQL \u306f\u4ee5\u524d\u306e\u8a18\u4e8b<\/a>\u3067\u3082\u89e6\u308c\u305f\u304c\uff0cESRI \u793e\u306e Shape \u30d5\u30a1\u30a4\u30eb\u3092 SQL Server \u306e\u30c6\u30fc\u30d6\u30eb\u306b\u76f4\u63a5\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u304f\u308c\u308b\u30c4\u30fc\u30eb\u3067\u3042\u308b\uff0e\u6b8b\u5ff5\u306a\u304c\u3089\u66f4\u65b0\u306f\u505c\u6b62\u3057\u3066\u304a\u308a\uff0c\u6700\u65b0\u306e SQL Server \u3068\u306f\u4e92\u63db\u6027\u304c\u306a\u3044\uff0e\u4eca\u56de\uff0cSQL Server 2008 R2 \u3092\u65b0\u898f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3068\u3053\u308d\uff0c\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u304c\u3046\u307e\u304f\u884c\u3063\u305f\u306e\u3067\u5831\u544a\u3059\u308b\uff0e<\/p>\n

<\/p>\n

SQL Server 2008 R2 Express Service Pack 2 \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/h2>\n

\u3000\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u5143\u306f\u516c\u5f0f<\/a>\u306b\u3042\u308b\uff0e\u3053\u3053\u3067\u6ce8\u610f\u304c\u5fc5\u8981\u3060\u304c\uff0cService Pack 3 \u3060\u3068\u300c\u6a5f\u80fd\u306e\u9078\u629e\u300d\u304c\u767d\u7d19\u3067\u4f55\u3082\u9078\u629e\u3067\u304d\u305a\uff0c\u305d\u308c\u4ee5\u4e0a\u4f5c\u696d\u304c\u9032\u307e\u306a\u3044\uff0eService Pack 2 \u3092\u9078\u3076\u3053\u3068\uff0e<\/p>\n

\"Microsoft\u00ae<\/a>
Microsoft\u00ae SQL Server\u00ae 2008 R2 SP2 – Express Edition<\/figcaption><\/figure>\n

\u3000\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\uff0c\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u805e\u304b\u308c\u308b\u306e\u3067\u5404\u81ea\u306e\u74b0\u5883\u306b\u9069\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u9078\u629e\u3059\u308b\uff0e<\/p>\n

\"SQL<\/a>
SQL Server 2008 R2 \u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u9078\u629e\u3059\u308b<\/figcaption><\/figure>\n
\"\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u753b\u9762\"<\/a>
\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u753b\u9762<\/figcaption><\/figure>\n
\"\u30e9\u30a4\u30bb\u30f3\u30b9\u6761\u9805\u306b\u540c\u610f\u3059\u308b\"<\/a>
\u30e9\u30a4\u30bb\u30f3\u30b9\u6761\u9805\u306b\u540c\u610f\u3059\u308b<\/figcaption><\/figure>\n
\"\u6a5f\u80fd\u306e\u9078\u629e\"<\/a>
\u6a5f\u80fd\u306e\u9078\u629e<\/figcaption><\/figure>\n
\"\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u69cb\u6210\"<\/a>
\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u69cb\u6210<\/figcaption><\/figure>\n
\"\u30b5\u30fc\u30d0\u30fc\u306e\u69cb\u6210\"<\/a>
\u30b5\u30fc\u30d0\u30fc\u306e\u69cb\u6210<\/figcaption><\/figure>\n
\"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u306e\u69cb\u6210\"<\/a>
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u306e\u69cb\u6210<\/figcaption><\/figure>\n
\"\u30a8\u30e9\u30fc\u30ec\u30dd\u30fc\u30c8\"<\/a>
\u30a8\u30e9\u30fc\u30ec\u30dd\u30fc\u30c8<\/figcaption><\/figure>\n
\"\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u9032\u884c\u72b6\u6cc1\"<\/a>
\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u9032\u884c\u72b6\u6cc1<\/figcaption><\/figure>\n
\"\u5b8c\u4e86\"<\/a>
\u5b8c\u4e86<\/figcaption><\/figure>\n

SQL Server Management Studio \u304b\u3089 SQL Server 2008 R2 \u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u63a5\u7d9a\u3059\u308b<\/h2>\n

\u3000SQL Server Management Studio \u306e\u30b5\u30fc\u30d0\u30fc\u3078\u306e\u63a5\u7d9a\u3067\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\uff12\u3064\u3042\u308b\u306e\u304c\u308f\u304b\u308b\uff0eSQLEXPRESS \u3068\u3042\u308b\u306e\u304c 2008 R2 \u3067\u3042\u308a\uff0c\u3053\u3061\u3089\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u9078\u629e\u3057\u3066\u63a5\u7d9a\u3059\u308b\uff0e<\/p>\n

\"SQL<\/a>
SQL Server Management Studio \u306e\u8d77\u52d5\u753b\u9762\u3067\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c2\u3064\u3042\u308b\u306e\u304c\u308f\u304b\u308b<\/figcaption><\/figure>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u65b0\u898f\u4f5c\u6210\u3059\u308b<\/h3>\n

\u3000\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9…\u300d\u3092\u9078\u3076\uff0e\u540d\u79f0\u3092 MEDICAL_AREADB \u3068\u3059\u308b\uff0e<\/p>\n

\"\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u304b\u3089\u300c\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9...\u300d\"<\/a>
\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u304b\u3089\u300c\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9…\u300d<\/figcaption><\/figure>\n

\u3000\u3053\u308c\u3067\u6e96\u5099\u304c\u6574\u3063\u305f\uff0e<\/p>\n

\u56fd\u571f\u4ea4\u901a\u7701\u6570\u5024\u60c5\u5831\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30b5\u30fc\u30d3\u30b9\u304b\u3089 Shape \u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b<\/h2>\n

\u3000\u5834\u6240\u306f\u3053\u3061\u3089<\/a>\u306b\u306a\u308b\uff0e\u65b0\u578b\u30b3\u30ed\u30ca\u30a6\u30a4\u30eb\u30b9\u3067\u533b\u7642\u5d29\u58ca\u304c\u8d77\u304d\u3064\u3064\u3042\u308b 2020 \u5e74\u306e\u5e74\u672b\uff0c\u533b\u7642\u570f<\/a>\u306b\u3064\u3044\u3066\u306e\u30c7\u30fc\u30bf\u3092\u773a\u3081\u3066\u307f\u3088\u3046\uff0e<\/p>\n

\u3000\u30da\u30fc\u30b8\u3092\u30b9\u30af\u30ed\u30fc\u30eb\u3057\u3066\u3044\u304f\u3068\u5730\u56f3\u304c\u898b\u3048\u3066\u304f\u308b\uff0e\u3053\u3053\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\uff0e\u5168\u56fd\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n

\"\u533b\u7642\u570f\u30c7\u30fc\u30bf\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\"<\/a>
\u533b\u7642\u570f\u30c7\u30fc\u30bf\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/figcaption><\/figure>\n

\u3000\u5b9f\u969b\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30dc\u30bf\u30f3\u306b\u9077\u79fb\u3059\u308b\uff0e<\/p>\n

\"\u5b9f\u969b\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30dc\u30bf\u30f3\"<\/a>
\u5b9f\u969b\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30dc\u30bf\u30f3<\/figcaption><\/figure>\n

\u3000\u300c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u8b66\u544a\u304c\u51fa\u308b\u304c\uff0c\u69cb\u308f\u305aOK\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n

\"\u30d5\u30a1\u30a4\u30eb\u30b5\u30a4\u30ba\u306e\u8b66\u544a\u304c\u51fa\u308b\"<\/a>
\u30d5\u30a1\u30a4\u30eb\u30b5\u30a4\u30ba\u306e\u8b66\u544a\u304c\u51fa\u308b<\/figcaption><\/figure>\n

\u3000\u5c55\u958b\u3059\u308b\u3068\u30b5\u30a4\u30ba\u306f\u5b9f\u306b 1.23GB \u3082\u3042\u308b\uff0e\u5de8\u5927\u306a\u30d5\u30a1\u30a4\u30eb\u3067\u3042\u308b\uff0e<\/p>\n

\"zip\u30d5\u30a1\u30a4\u30eb\u3092\u5c55\u958b\u3059\u308b\"<\/a>
zip\u30d5\u30a1\u30a4\u30eb\u3092\u5c55\u958b\u3059\u308b<\/figcaption><\/figure>\n

\u30e1\u30bf\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3059\u308b<\/h3>\n

\u3000\u3044\u304d\u306a\u308a\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u524d\u306b\uff0c\u5217\u540d\u3092\u78ba\u8a8d\u3057\u3066\u304a\u304f\uff0e<\/p>\n

\u3000\u30c7\u30fc\u30bf\u5f62\u72b6\u306f\u300c\u9762\u300d\u3068\u3042\u308b\u306e\u3067 Geometry \u578b\u3067\u3042\u308b\u3053\u3068\u304c\u308f\u304b\u308b\uff0e<\/p>\n

\u3000\u533b\u7642\u570f\u306b\u306f\u4e00\u6b21\uff0c\u4e8c\u6b21\uff0c\u4e09\u6b21\u304c\u3042\u308b\uff0e.shp \u30d5\u30a1\u30a4\u30eb\u306f\uff13\u3064\u3042\u308b\u304c\uff0c\u30d5\u30a1\u30a4\u30eb\u540d\u306e\u6570\u5b57\u304c\u3053\u308c\u306b\u5bfe\u5fdc\u3059\u308b\uff0e<\/p>\n

\"\u533b\u7642\u570f\u3054\u3068\u306b\u30d5\u30a1\u30a4\u30eb\u304c\u5206\u304b\u308c\u3066\u3044\u308b\"<\/a>
\u533b\u7642\u570f\u3054\u3068\u306b\u30d5\u30a1\u30a4\u30eb\u304c\u5206\u304b\u308c\u3066\u3044\u308b<\/figcaption><\/figure>\n

\u4e00\u6b21\u533b\u7642\u570f<\/h3>\n\n\n\n\n\n\n\n\n
\u5c5e\u6027\u540d<\/th>\nColumn<\/th>\n\u5c5e\u6027\u306e\u578b<\/th>\nData Type<\/th>\n<\/tr>\n
\u884c\u653f\u533a\u57df\u30b3\u30fc\u30c9<\/td>\nA38a_001<\/td>\n\u30b3\u30fc\u30c9\u30ea\u30b9\u30c8\u300c\u884c\u653f\u30b3\u30fc\u30c9\u300d<\/td>\n\u00a0<\/td>\n<\/tr>\n
\u5e02\u533a\u753a\u6751\u540d<\/td>\nA38a_002<\/td>\n\u6587\u5b57\u5217\u578b<\/td>\nCharacterString<\/td>\n<\/tr>\n
\u4e8c\u6b21\u533b\u7642\u570f\u30b3\u30fc\u30c9<\/td>\nA38a_003<\/td>\n\u6587\u5b57\u5217\u578b<\/td>\nCharacterString<\/td>\n<\/tr>\n
\u4e8c\u6b21\u533b\u7642\u570f\u540d<\/td>\nA38a_004<\/td>\n\u6587\u5b57\u5217\u578b<\/td>\nCharacterString<\/td>\n<\/tr>\n
\u8a2d\u5b9a\u30d5\u30e9\u30b0<\/td>\nA38a_005<\/td>\n\u30b3\u30fc\u30c9\u30ea\u30b9\u30c8\u300c\u8a2d\u5b9a\u30d5\u30e9\u30b0\u300d<\/td>\n\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4e8c\u6b21\u533b\u7642\u570f<\/h3>\n

\u3000\u4e8c\u6b21\u533b\u7642\u570f\u306f\u4ed6\u306e\u533b\u7642\u570f\u3068\u7570\u306a\u308a\uff0c\u9762\u7a4d\u3068\u4eba\u53e3\u306e\u30c7\u30fc\u30bf\u304c\u4ed8\u4e0e\u3055\u308c\u3066\u3044\u308b\uff0e\u533b\u7642\u570f\u306e\u4e2d\u5fc3\u3092\u306a\u3059\u3082\u306e\u3067\u3042\u308b\u3053\u3068\u304c\u308f\u304b\u308b\uff0e<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u5c5e\u6027\u540d<\/th>\nColumn<\/th>\n\u5c5e\u6027\u306e\u578b<\/th>\nData Type<\/th>\n<\/tr>\n
\u884c\u653f\u533a\u57df\u30b3\u30fc\u30c9<\/td>\nA38b_001<\/td>\n\u30b3\u30fc\u30c9\u30ea\u30b9\u30c8\u300c\u884c\u653f\u30b3\u30fc\u30c9\u300d<\/td>\n\u00a0<\/td>\n<\/tr>\n
\u5e02\u533a\u753a\u6751\u540d<\/td>\nA38b_002<\/td>\n\u6587\u5b57\u5217\u578b<\/td>\nCharacterString<\/td>\n<\/tr>\n
\u4e8c\u6b21\u533b\u7642\u570f\u30b3\u30fc\u30c9<\/td>\nA38b_003<\/td>\n\u6587\u5b57\u5217\u578b<\/td>\nCharacterString<\/td>\n<\/tr>\n
\u4e8c\u6b21\u533b\u7642\u570f\u540d<\/td>\nA38b_004<\/td>\n\u6587\u5b57\u5217\u578b<\/td>\nCharacterString<\/td>\n<\/tr>\n
\u9762\u7a4d\uff08\u533b\u7642\u8a08\u753b\uff09<\/td>\nA38b_005<\/td>\n\u5b9f\u6570\u578b<\/td>\nReal<\/td>\n<\/tr>\n
\u9762\u7a4d\uff08\u56fd\u571f\u5730\u7406\u9662\uff09<\/td>\nA38b_006<\/td>\n\u5b9f\u6570\u578b<\/td>\nReal<\/td>\n<\/tr>\n
\u4eba\u53e3\uff08\u533b\u7642\u8a08\u753b\uff09<\/td>\nA38b_007<\/td>\n\u6574\u6570\u578b<\/td>\nInteger<\/td>\n<\/tr>\n
\u7dcf\u4eba\u53e3\uff08\u4f4f\u6c11\u57fa\u672c\u53f0\u5e33\uff09<\/td>\nA38b_008<\/td>\n\u6574\u6570\u578b<\/td>\nInteger<\/td>\n<\/tr>\n
\u4eba\u53e3\uff0815\u624d\u672a\u6e80\uff09<\/td>\nA38b_009<\/td>\n\u6574\u6570\u578b<\/td>\nInteger<\/td>\n<\/tr>\n
\u4eba\u53e3\uff0815\u624d\u4ee5\u4e0a65\u624d\u672a\u6e80\uff09<\/td>\nA38b_010<\/td>\n\u6574\u6570\u578b<\/td>\nInteger<\/td>\n<\/tr>\n
\u4eba\u53e3\uff0865\u624d\u4ee5\u4e0a\uff09<\/td>\nA38b_011<\/td>\n\u6574\u6570\u578b<\/td>\nInteger<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4e09\u6b21\u533b\u7642\u570f<\/h3>\n

\u3000\u4e09\u6b21\u533b\u7642\u570f\u306b\u3042\u308b\u306e\u306f\u90fd\u9053\u5e9c\u770c\u540d\u304f\u3089\u3044\u3067\u3042\u308b\uff0e<\/p>\n\n\n\n\n\n
\u5c5e\u6027\u540d<\/th>\nColumn<\/th>\n\u5c5e\u6027\u306e\u578b<\/th>\nData Type<\/th>\n<\/tr>\n
\u90fd\u9053\u5e9c\u770c\u540d<\/td>\nA38c_001<\/td>\n\u6587\u5b57\u5217\u578b<\/td>\nCharacterString<\/td>\n<\/tr>\n
\u4e09\u6b21\u533b\u7642\u570f\u540d<\/td>\nA38c_002<\/td>\n\u6587\u5b57\u5217\u578b<\/td>\nCharacterString<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Shape2SQL\u3092\u8d77\u52d5\u3059\u308b<\/h2>\n

Database Configuration \u3067\u30b5\u30fc\u30d0\u30fc\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u6307\u5b9a\u3059\u308b<\/h3>\n

\u3000\u8d77\u52d5\u3057\u3066\u6700\u521d\u306b\u73fe\u308c\u308b\u753b\u9762\u306f Database Configuration \u3067\u3042\u308b\uff0eServer name \u306b SQL Server \u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\u3092\u30b3\u30d4\u30da\u3059\u308b\uff0e<\/p>\n

\"Database<\/a>
Database Configuration \u306e Server name \u306b SQL Server \u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\u3092\u30b3\u30d4\u30da\u3059\u308b<\/figcaption><\/figure>\n

\u3000\u3059\u308b\u3068 Connect to a database \u306e Select or enter a database name \u304b\u3089\uff0c\u5148\u7a0b\u4f5c\u6210\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 MEDICAL_AREADB \u3092\u30d7\u30eb\u30c0\u30a6\u30f3\u3067\u9078\u629e\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308b\uff0eOK \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n

\"\u5148\u307b\u3069\u4f5c\u6210\u3057\u305f<\/a>
\u5148\u307b\u3069\u4f5c\u6210\u3057\u305f MEDICAL_AREADB \u304c\u30d7\u30eb\u30c0\u30a6\u30f3\u3067\u9078\u629e\u3067\u304d\u308b<\/figcaption><\/figure>\n

Shape \u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a\u3059\u308b<\/h3>\n

\u3000\u30a2\u30d7\u30ea\u306e\u672c\u4f53\u753b\u9762\u3067\u3042\u308b\uff0e\u6700\u4e0a\u6bb5\u306b Shapefile \u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u5165\u529b\u3059\u308b\u6b04\u304c\u3042\u308b\uff0e\u305d\u306e\u53f3\u7aef\u306b … \u30dc\u30bf\u30f3\u304c\u3042\u308a\uff0c\u30af\u30ea\u30c3\u30af\u3057\u3066\u30c0\u30a4\u30a2\u30ed\u30b0\u304b\u3089\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a\u3059\u308b\uff0e<\/p>\n

\"\u53f3\u4e0a\u306e...\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066<\/a>
\u53f3\u4e0a\u306e…\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a\u3059\u308b<\/figcaption><\/figure>\n

\u3000\u753b\u9762\u5de6\u4e0b\u306f\u30b8\u30aa\u30e1\u30c8\u30ea\u306e\u5c5e\u6027\u3092\u6307\u5b9a\u3059\u308b\uff0ePlanar Geometry \u306b\u30c1\u30a7\u30c3\u30af\u304c\u5165\u3063\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\uff0cSet SRID \u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\uff0cUpload to Database \u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n

\u3000\u753b\u9762\u53f3\u4e0b\u306f\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u5217\u306b\u30c1\u30a7\u30c3\u30af\u304c\u5165\u3063\u3066\u3044\u308b\uff0e\u3053\u306e\u30c1\u30a7\u30c3\u30af\u306e\u30aa\u30f3\u30aa\u30d5\u3067\u5217\u3054\u3068\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u304b\u3057\u306a\u3044\u304b\u3092\u9078\u629e\u3067\u304d\u308b\u3088\u3046\u3060\uff0e<\/p>\n

\"A38-14_1.shp<\/a>
A38-14_1.shp \u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u4e2d<\/figcaption><\/figure>\n

SQL Server Management Studio \u304b\u3089\u7d50\u679c\u3092\u78ba\u8a8d\u3059\u308b<\/h2>\n

\u3000\u4e0b\u8a18\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\uff0e<\/p>\n

SELECT TOP (1000) [ID]\n      ,[A38a_001@]\n      ,[A38a_002@]\n      ,[A38a_003@]\n      ,[A38a_004@]\n      ,[A38a_005@]\n      ,LEFT(CAST([geom] as nvarchar(max)),40)\tAS POLYGON\n\t  ,[geom]\n  FROM [MEDICAL_AREADB].[dbo].[A38-14_1]<\/pre>\n
\u3000\u30af\u30a8\u30ea\u306e\u7d50\u679c\u306f\u4ee5\u4e0b\u3067\u3042\u308b\uff0e\u6587\u5b57\u5217\u304c\u6587\u5b57\u5316\u3051\u3057\u3066\u3044\u308b\uff0e\u539f\u56e0\u3068\u5bfe\u51e6\u6cd5\u306f\u4e0d\u660e\u3067\u3042\u308b\uff0e<\/p>\n
\"SQL<\/a>
SQL Server \u306e\u7a7a\u9593\u7d50\u679c<\/figcaption><\/figure>\n
ID\tA38a_001@\tA38a_002@\tA38a_003@\tA38a_004@\tA38a_005@\tPOLYGON\n1\t01395\t\u0083j\u0083Z\u0083R\u0092\u00ac\t0105\t\u008c\u00e3\u008eu\t1\tPOLYGON ((140.642083 42.877189, 140.6419\n2\t01586\t\u0082\u00de\u0082\u00a9\u0082\u00ed\u0092\u00ac\t0110\t\u0093\u008c\u0092_\u0090U\t1\tPOLYGON ((142.27979 42.981125, 142.27953\n3\t01456\t\u0088\u00a4\u0095\u00ca\u0092\u00ac\t0112\t\u008f\u00e3\u0090\u00ec\u0092\u0086\u0095\u0094\t1\tPOLYGON ((142.615518 44.026789, 142.6151\n4\t01204\t\u0088\u00ae\u0090\u00ec\u008es\t0112\t\u008f\u00e3\u0090\u00ec\u0092\u0086\u0095\u0094\t1\tPOLYGON ((142.432083 43.947289, 142.4318\n5\t01216\t\u0088\u00b0\u0095\u00ca\u008es\t0107\t\u0092\u0086\u008b\u00f3\u0092m\t1\tPOLYGON ((142.238501 43.652331, 142.2385\n6\t01585\t\u0088\u00c0\u0095\u00bd\u0092\u00ac\t0110\t\u0093\u008c\u0092_\u0090U\t1\tPOLYGON ((141.954421 42.854375, 141.9543\n7\t01436\t\u0089J\u0097\u00b3\u0092\u00ac\t0107\t\u0092\u0086\u008b\u00f3\u0092m\t1\tPOLYGON ((141.68065 43.738631, 141.68030\n8\t01431\t\u0089Y\u0089P\u0092\u00ac\t0107\t\u0092\u0086\u008b\u00f3\u0092m\t1\tPOLYGON ((141.783482 43.486502, 141.7832\n9\t01607\t\u0089Y\u0089\u00cd\u0092\u00ac\t0111\t\u0093\u00fa\u008d\u0082\t1\tPOLYGON ((142.882097 42.466316, 142.8816\n10\t01649\t\u0089Y\u0096y\u0092\u00ac\t0119\t\u008f\\\u008f\u009f\t1\tPOLYGON ((143.767769 43.163051, 143.7676<\/pre>\n
\u307e\u3068\u3081<\/h2>\n
\u3000Shape2SQL \u3067 SQL Server \u306bShape \u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u306b\u306f SQL Server 2008 R2 \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u304c\u3042\u3063\u305f\uff0e\u305f\u3060\u3057\uff0c\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306fSQL Server 2008 R2\u3067\u3042\u308b\u5fc5\u8981\u306f\u306a\u304f\uff0c\u6700\u65b0\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\uff08\u57f7\u7b46\u6642\u70b9\u3067\u306fSQL Server 2019\u3067\u3042\u308b\uff09\u3067\u3082\u53ef\u80fd\u3067\u3042\u3063\u305f\uff0eSQL Server 2008 R2\u306b\u542b\u307e\u308c\u308b\u4f55\u3089\u304b\u306e\u30c4\u30fc\u30eb\u304c Shape2SQL \u306b\u5fc5\u8981\u306a\u306e\u304b\u3082\u3057\u308c\u306a\u3044\uff0e<\/p>\n
\u3000\u6587\u5b57\u5217\u30c7\u30fc\u30bf\u306f\u6587\u5b57\u5316\u3051\u3057\u3066\u304a\u308a\uff0c\u539f\u56e0\u3068\u5bfe\u51e6\u6cd5\u306f\u73fe\u6642\u70b9\u3067\u4e0d\u660e\u3067\u3042\u308b\uff0e\u884c\u653f\u533a\u57df\u30b3\u30fc\u30c9\u306f\u7dcf\u52d9\u7701<\/a>\u304c\u516c\u8868\u3057\u3066\u304a\u308a\uff0c\u7d50\u5408\u3059\u308b\u3053\u3068\u3067\u5bfe\u51e6\u53ef\u80fd\u3068\u601d\u308f\u308c\u308b\u304c\uff0c\u533b\u7642\u570f\u30b3\u30fc\u30c9\u306f\u5225\u9014\u691c\u7d22\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3000Shape2SQL \u306f\u4ee5\u524d\u306e\u8a18\u4e8b\u3067\u3082\u89e6\u308c\u305f\u304c\uff0cESRI \u793e\u306e Shape \u30d5\u30a1\u30a4\u30eb\u3092 SQL Server \u306e\u30c6\u30fc\u30d6\u30eb\u306b\u76f4\u63a5\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u304f\u308c\u308b\u30c4\u30fc\u30eb\u3067\u3042\u308b\uff0e\u6b8b\u5ff5\u306a\u304c\u3089\u66f4\u65b0\u306f\u505c\u6b62\u3057\u3066\u304a\u308a\uff0c\u6700\u65b0\u306e SQL Server … <\/p>\n
“Shape2SQL \u3067\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092 SQL Server 2008 R2 \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":13155,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[9122,9131,9130,9132,9111,7672,7639,7724,266,9134,9112,9110,9136,9135,7681,7669,9116,2740,9115,2750,9118,7448,7694,1801,2796,4099,2669,4117,9117,9119,2783,4101,9114,2684,462,32,4102,9121,3576,7667,4083,9123,9133,5981,9125,9126,5223,4313,2807,5985,9128,4084,333,9120,9129,4496,1022,3634,2487,4094,5141,821,9124,9127,5162,7227],"class_list":["post-13102","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-shp-2","tag-9131","tag-9130","tag-9132","tag-connect-to-a-database","tag-database-configuration","tag-esri","tag-geometry","tag-microsoft","tag-planar-geometry","tag-select-or-enter-a-database-name","tag-server-name","tag-service-pack-2","tag-service-pack-3","tag-set-srid","tag-shape2sql","tag-shape","tag-sql-server","tag-sql-server-2008-r2","tag-sql-server-management-studio","tag-sqlexpress","tag-srid","tag-upload-to-database","tag-1801","tag-2796","tag-4099","tag-2669","tag-4117","tag-9117","tag-9119","tag-2783","tag-4101","tag-9114","tag-2684","tag-462","tag-32","tag-4102","tag-9121","tag-3576","tag-7667","tag-4083","tag-9123","tag-9133","tag-5981","tag-9125","tag-9126","tag-5223","tag-4313","tag-2807","tag-5985","tag-9128","tag-4084","tag-333","tag-9120","tag-9129","tag-4496","tag-1022","tag-3634","tag-2487","tag-4094","tag-5141","tag-821","tag-9124","tag-9127","tag-5162","tag-7227"],"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/13102","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=13102"}],"version-history":[{"count":43,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/13102\/revisions"}],"predecessor-version":[{"id":15711,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/13102\/revisions\/15711"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/media\/13155"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}