{"id":15771,"date":"2022-11-03T06:00:00","date_gmt":"2022-11-02T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=15771"},"modified":"2022-08-05T14:10:02","modified_gmt":"2022-08-05T05:10:02","slug":"%e5%9b%bd%e5%9c%9f%e6%95%b0%e5%80%a4%e6%83%85%e5%a0%b1%e3%81%ae%e6%b2%b3%e5%b7%9d%e3%83%87%e3%83%bc%e3%82%bf%e3%81%8c%e4%b8%80%e9%83%a8%e7%9b%b4%e3%81%a3%e3%81%a6%e3%81%84%e3%81%9f%e4%bb%b6","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=15771","title":{"rendered":"\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u304c\u4e00\u90e8\u76f4\u3063\u3066\u3044\u305f\u4ef6"},"content":{"rendered":"\n<p>\u3000\u4ee5\u524d\u306e\u8a18\u4e8b\u3067\u56fd\u571f\u4ea4\u901a\u7701\u306e\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u304c\u7834\u640d\u3057\u3066\u3044\u308b\u3068\u53e3\u3092\u9178\u3063\u3071\u304f\u3057\u3066\u8ff0\u3079\u305f\u304c\uff0c\u3044\u3064\u306e\u9593\u306b\u304b\u4fee\u5fa9\u3055\u308c\u3066\u3044\u305f\uff0e\u4fee\u5fa9\u3055\u308c\u3066\u3044\u305f\u306e\u306f\u5317\u6d77\u9053\u304a\u3088\u3073\u8328\u57ce\u770c\u306e\u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u3067\u3042\u308b\uff0e\u5c90\u961c\u770c\u3068\u4e09\u91cd\u770c\u306e\u30d5\u30a1\u30a4\u30eb\u306f\u7834\u640d\u3057\u305f\u307e\u307e\u3067\u3042\u308a\uff0c\u4fee\u5fa9\u3092\u8981\u3057\u305f\uff0e<\/p>\n<p>\u53c2\u8003\uff1a<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=13836\" target=\"_blank\" rel=\"noopener\">QGIS\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u8a08\u7b97\u6a5f\u3067\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u306e\u5c5e\u6027\u3092\u4fee\u6b63\u3059\u308b<\/a><\/p>\n<p><a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=13762\" target=\"_blank\" rel=\"noopener\">QGIS\u3067\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u4fee\u6b63\u3059\u308b<\/a><\/p>\n<p><a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=13587\" target=\"_blank\" rel=\"noopener\">\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u306e\u5c5e\u6027\u30c6\u30fc\u30d6\u30eb\u3092\u7de8\u96c6\u3057\u3066\u307f\u305f\u304c\u2026<\/a><\/p>\n<p><!--more--><\/p>\n<h2>\u56fd\u571f\u6570\u5024\u60c5\u5831\u6cb3\u5ddd\u30c7\u30fc\u30bf\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/h2>\n<p>\u3000<a href=\"https:\/\/nlftp.mlit.go.jp\/ksj\/gml\/datalist\/KsjTmplt-W05.html\" target=\"_blank\" rel=\"noopener\">\u56fd\u571f\u6570\u5024\u60c5\u5831\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30b5\u30fc\u30d3\u30b9<\/a>\u304b\u3089\u5165\u308b\uff0e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_15772\" aria-describedby=\"caption-attachment-15772\" style=\"width: 970px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/00.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15772\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/00.png\" alt=\"\u56fd\u571f\u6570\u5024\u60c5\u5831\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30b5\u30fc\u30d3\u30b9\" width=\"970\" height=\"898\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/00.png 970w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/00-300x278.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/00-768x711.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption id=\"caption-attachment-15772\" class=\"wp-caption-text\">\u56fd\u571f\u6570\u5024\u60c5\u5831\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30b5\u30fc\u30d3\u30b9<\/figcaption><\/figure>\n<h3>GIS\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u5229\u7528\u8005\u30a2\u30f3\u30b1\u30fc\u30c8<\/h3>\n<p>\u3000GIS\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u5229\u7528\u8005\u30a2\u30f3\u30b1\u30fc\u30c8\u753b\u9762\u306b\u9077\u79fb\u3059\u308b\uff0e\u4efb\u610f\u306a\u306e\u3067\u9589\u3058\u3066\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u3082\u826f\u3044\uff0e<\/p>\n<figure id=\"attachment_15773\" aria-describedby=\"caption-attachment-15773\" style=\"width: 898px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15773\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/01.png\" alt=\"GIS\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u5229\u7528\u8005\u30a2\u30f3\u30b1\u30fc\u30c8\" width=\"898\" height=\"519\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/01.png 898w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/01-300x173.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/01-768x444.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption id=\"caption-attachment-15773\" class=\"wp-caption-text\">GIS\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u5229\u7528\u8005\u30a2\u30f3\u30b1\u30fc\u30c8<\/figcaption><\/figure>\n<h3>\u5404\u90fd\u9053\u5e9c\u770c\u306b\u3064\u304d\uff13\u500b\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u4e00\u3064\u306e\u30d5\u30a9\u30eb\u30c0\u306b\u307e\u3068\u3081\u308b<\/h3>\n<p>\u3000zip\u30d5\u30a1\u30a4\u30eb\u306b\u5727\u7e2e\u3055\u308c\u305f\u72b6\u614b\u3067.dbf\u30d5\u30a1\u30a4\u30eb\uff0c.shp\u30d5\u30a1\u30a4\u30eb\uff0c.shx\u30d5\u30a1\u30a4\u30eb\u306e\uff13\u500b\u304c\uff11\u90fd\u9053\u5e9c\u770c\u306b\u3064\u304d\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u308c\u308b\uff0e\u4ed6\u306b\u3082gml\u30d5\u30a1\u30a4\u30eb\u306a\u3069\u304c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u308c\u308b\u304c\u4eca\u56de\u306f\u4f7f\u7528\u3057\u306a\u3044\u306e\u3067\u5ec3\u68c4\u3059\u308b\uff0e\u4eca\u56de\u4f7f\u7528\u3059\u308b\u306e\u306f\u30d5\u30a1\u30a4\u30eb\u540d\u306bStream\u3068\u306e\u6587\u5b57\u5217\u306e\u3042\u308b\u30d5\u30a1\u30a4\u30eb\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000zip\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u3092\u53d6\u308a\u51fa\u3057\uff0c\u4e00\u3064\u306e\u30d5\u30a9\u30eb\u30c0\u306b\u307e\u3068\u3081\u3066\u304a\u304f\uff0e<\/p>\n<h3>\u30d5\u30a1\u30a4\u30eb\u540d\u306e\u5909\u66f4\u306f\u898f\u5247\u7684\u306b<\/h3>\n<p>\u3000\u4e0b\u56f3\u3092\u3088\u304f\u898b\u308b\u3068\u5206\u304b\u308b\u304c\uff0cW05-\u306e\u76f4\u5f8c\u306e\u4e8c\u6841\u306e\u6570\u5024\u306f\u90fd\u9053\u5e9c\u770c\u3068\u306f\u7121\u95a2\u4fc2\u3067\u3042\u308b\uff0e\u4f55\u3089\u304b\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u756a\u53f7\u306a\u306e\u304b\u3082\u3057\u308c\u306a\u3044\uff0e\u90fd\u9053\u5e9c\u770c\u306b\u95a2\u4fc2\u306e\u3042\u308b\u306e\u306f_GML\u306e\u76f4\u524d\u306e\u4e8c\u6841\u306e\u6570\u5024\u3067\u3042\u308b\uff0e<\/p>\n<figure id=\"attachment_15774\" aria-describedby=\"caption-attachment-15774\" style=\"width: 144px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15774\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/02.png\" alt=\"zip\u30d5\u30a1\u30a4\u30eb\u540d\u306b\u6ce8\u76ee\" width=\"144\" height=\"403\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/02.png 144w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/02-107x300.png 107w\" sizes=\"auto, (max-width: 144px) 100vw, 144px\" \/><\/a><figcaption id=\"caption-attachment-15774\" class=\"wp-caption-text\">zip\u30d5\u30a1\u30a4\u30eb\u540d\u306b\u6ce8\u76ee<\/figcaption><\/figure>\n<p>\u3000\u4e0b\u56f3\u306e\u3088\u3046\u306b\u7121\u95a2\u4fc2\u306e\u6570\u5024\u3084\u8a18\u53f7\u3092\u30d5\u30a1\u30a4\u30eb\u540d\u304b\u3089\u624b\u52d5\u3067\u524a\u9664\u3059\u308b\uff0e\u3053\u306e\u4f5c\u696d\u306f\u5f8c\u3067SQL Server\u3067INSERT\u3059\u308b\u6642\u306b\u5fc5\u8981\u306b\u306a\u308b\uff0e<\/p>\n<figure id=\"attachment_15775\" aria-describedby=\"caption-attachment-15775\" style=\"width: 180px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15775\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/03.png\" alt=\"\u7121\u95a2\u4fc2\u306e\u6570\u5b57\u3068\u8a18\u53f7\u3092\u524a\u9664\" width=\"180\" height=\"315\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/03.png 180w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/03-171x300.png 171w\" sizes=\"auto, (max-width: 180px) 100vw, 180px\" \/><\/a><figcaption id=\"caption-attachment-15775\" class=\"wp-caption-text\">\u7121\u95a2\u4fc2\u306e\u6570\u5b57\u3068\u8a18\u53f7\u3092\u524a\u9664<\/figcaption><\/figure>\n<h2>Shape2SQL\u3067SQL Server\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9<\/h2>\n<p>\u3000\u4eca\u56de\u306f\uff11\u30d5\u30a1\u30a4\u30eb\u305a\u3064Shape2SQL\u3067SQL Server\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\uff0cSQL Server\u5185\u3067\u4e00\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u307e\u3068\u3081\u308b\u3053\u3068\u306b\u3059\u308b\uff0e<\/p>\n<p>\u3000\u4e0b\u56f3\u306e\u3088\u3046\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a\u3057\uff0cUpload to Database\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e\u6b86\u3069\u306e\u30d5\u30a1\u30a4\u30eb\u306f\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u304c\u6210\u529f\u3059\u308b\uff0e\u3057\u304b\u3057\uff0cGeography\u3092\u9078\u629e\u3059\u308b\u3068\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u81ea\u4f53\u304c\u505c\u6b62\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u304c\u5b58\u5728\u3057\u305f\uff0e21\u756a\u76ee\u306e\u5c90\u961c\u770c\u306824\u756a\u76ee\u306e\u4e09\u91cd\u770c\u3067\u3042\u308b\uff0e\u8208\u5473\u6df1\u3044\u3053\u3068\u306bPlanar Geometry\u3092\u9078\u629e\u3059\u308b\u3068\u30a8\u30e9\u30fc\u304c\u51fa\u73fe\u3057\u3064\u3064\u3082\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u305d\u306e\u3082\u306e\u306f\u6210\u529f\u3057\u305f\uff0e\u307e\u305f\uff0cQGIS\u3067\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u4fee\u5fa9\u3059\u308b\u3068\u6587\u5b57\u5316\u3051\u304c\u767a\u751f\u3057\u305f\uff0e\u56fd\u571f\u4ea4\u901a\u7701\u306f\u3053\u3046\u3044\u3046\u30d5\u30a1\u30a4\u30eb\u306e\u5185\u90e8\u306b\u3082\u30c1\u30a7\u30c3\u30af\u3092\u3057\u3066\u3044\u305f\u3060\u304d\u305f\u3044\uff0e<\/p>\n<figure id=\"attachment_15776\" aria-describedby=\"caption-attachment-15776\" style=\"width: 439px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15776\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/04.png\" alt=\"Shape2SQL\u3067SQL Server\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\" width=\"439\" height=\"447\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/04.png 439w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/04-295x300.png 295w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><figcaption id=\"caption-attachment-15776\" class=\"wp-caption-text\">Shape2SQL\u3067SQL Server\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9<\/figcaption><\/figure>\n<h2>\u65b0\u3057\u304f\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\uff0c\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u96c6\u3081\u308b<\/h2>\n<p>\u3000\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u65b0\u305f\u306b\u30c6\u30fc\u30d6\u30eb\u30921\u3064\u4f5c\u6210\u3059\u308b\uff0e<\/p>\n<pre>USE [JAPANRIVERDB]\nGO\n\nSET ANSI_NULLS ON\nGO\n\nSET QUOTED_IDENTIFIER ON\nGO\n\nCREATE TABLE [dbo].[W05_Stream](\n\t[ID] [int] IDENTITY(1,1) NOT NULL,\n\t[W05_001] [nvarchar](255) NULL,\n\t[W05_002] [nvarchar](255) NULL,\n\t[W05_003] [nvarchar](255) NULL,\n\t[W05_004] [nvarchar](255) NULL,\n\t[W05_005] [nvarchar](255) NULL,\n\t[W05_006] [nvarchar](255) NULL,\n\t[W05_007] [nvarchar](255) NULL,\n\t[W05_008] [nvarchar](255) NULL,\n\t[W05_009] [nvarchar](255) NULL,\n\t[W05_010] [nvarchar](255) NULL,\n\t[geom] [geography] NULL,\nPRIMARY KEY CLUSTERED \n(\n\t[ID] ASC\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\nGO\n\nALTER TABLE [dbo].[W05_Stream]  WITH CHECK ADD  CONSTRAINT [enforce_srid_geometry_W05_Stream] CHECK  (([geom].[STSrid]=(4326)))\nGO\n\nALTER TABLE [dbo].[W05_Stream] CHECK CONSTRAINT [enforce_srid_geometry_W05_Stream]\nGO<\/pre>\n<p>\u3000\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u30c7\u30fc\u30bf\u3092\u96c6\u3081\u308b\uff0eFROM\u53e5\u306e\u9023\u756a\u3092\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u3057\u306647\u56de\u7e70\u308a\u8fd4\u3059\uff0e<\/p>\n<pre>USE\tJAPANRIVERDB;\nGO\nINSERT INTO\tdbo.W05_Stream\n(\n\t[W05_001] ,\n\t[W05_002] ,\n\t[W05_003] ,\n\t[W05_004] ,\n\t[W05_005] ,\n\t[W05_006] ,\n\t[W05_007] ,\n\t[W05_008] ,\n\t[W05_009] ,\n\t[W05_010] ,\n\t[geom]\n)\nSELECT\t\n\t[W05_001] ,\n\t[W05_002] ,\n\t[W05_003] ,\n\t[W05_004] ,\n\t[W05_005] ,\n\t[W05_006] ,\n\t[W05_007] ,\n\t[W05_008] ,\n\t[W05_009] ,\n\t[W05_010] ,\n\t[geom]\nFROM\tdbo.[W05_01-g_Stream]<\/pre>\n<h2>\u6cb3\u5ddd\u30c6\u30fc\u30d6\u30eb\uff0c\u6c34\u57df\u7cfb\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b<\/h2>\n<p>\u3000<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=13299\" target=\"_blank\" rel=\"noopener\">\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u306e\u6c34\u57df\u7cfb\u30b3\u30fc\u30c9\u3092\u63a2\u7d22\u3059\u308b<\/a>\u3067\u8ff0\u3079\u305f\u3088\u3046\u306b\uff0c\u6cb3\u5ddd\u30c6\u30fc\u30d6\u30eb\u304a\u3088\u3073\u6c34\u57df\u7cfb\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\uff0e<a href=\"https:\/\/nlftp.mlit.go.jp\/ksj\/gml\/codelist\/WaterSystemCodeCd.html\" target=\"_blank\" rel=\"noopener\">\u6c34\u7cfb\u57df\u30b3\u30fc\u30c9\u7a2e\u5225<\/a>\u3068<a href=\"https:\/\/nlftp.mlit.go.jp\/ksj\/gml\/codelist\/RiverCodeCd.html\" target=\"_blank\" rel=\"noopener\">\u6cb3\u5ddd\u30b3\u30fc\u30c9\u7a2e\u5225<\/a>\u3067\u3042\u308b\uff0e\u30c6\u30fc\u30d6\u30eb\u540d\u306f\u305d\u308c\u305e\u308cT_WaterSystem, T_River\u3068\u3059\u308b\uff0e<\/p>\n<h2>\u30af\u30a8\u30ea<\/h2>\n<p>\u3000\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u307f\u308b\uff0e&#8217;\u6cb3\u5ddd\u540d&#8217;\u306b\u306f\u4eca\u56de\u300c\u6700\u4e0a\u5ddd\u300d\u3092\u6307\u5b9a\u3057\u3066\u307f\u305f\uff0e<\/p>\n<pre>SELECT[ID]\n\t,[W05_001]\n\t,[W05_002]\n\t,[W05_004]\n\t,[geom]\n\t,R.RiverName\n\t,W.WaterSystem\nFROM [JAPANRIVERDB].[dbo].[W05_Stream]\tAS\tS\nINNER\tJOIN\tdbo.T_River\tAS R\nON\tS.W05_002=R.RiverCode\nINNER\tJOIN\tdbo.T_WaterSystem\tAS\tW\nON\tS.W05_001=W.WaterSystemCode\nWHERE\tW.WaterSystem='\u6cb3\u5ddd\u540d'<\/pre>\n<h2>\u7d50\u679c<\/h2>\n<p>\u3000\u7d50\u679c\u306f\u4ee5\u4e0b\u3067\u3042\u308b\uff0e<\/p>\n<pre>(2360 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<figure id=\"attachment_15782\" aria-describedby=\"caption-attachment-15782\" style=\"width: 389px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/05.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15782\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/05.png\" alt=\"SQL Server\u306e\u7a7a\u9593\u30af\u30a8\u30ea\u7d50\u679c\" width=\"389\" height=\"542\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/05.png 389w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/08\/05-215x300.png 215w\" sizes=\"auto, (max-width: 389px) 100vw, 389px\" \/><\/a><figcaption id=\"caption-attachment-15782\" class=\"wp-caption-text\">SQL Server\u306e\u7a7a\u9593\u30af\u30a8\u30ea\u7d50\u679c<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u3000\u4ee5\u524d\u306e\u8a18\u4e8b\u3067\u56fd\u571f\u4ea4\u901a\u7701\u306e\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u304c\u7834\u640d\u3057\u3066\u3044\u308b\u3068\u53e3\u3092\u9178\u3063\u3071\u304f\u3057\u3066\u8ff0\u3079\u305f\u304c\uff0c\u3044\u3064\u306e\u9593\u306b\u304b\u4fee\u5fa9\u3055\u308c\u3066\u3044\u305f\uff0e\u4fee\u5fa9\u3055\u308c\u3066\u3044\u305f\u306e\u306f\u5317\u6d77\u9053\u304a\u3088\u3073\u8328\u57ce\u770c\u306e\u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u3067\u3042\u308b\uff0e\u5c90\u961c\u770c\u3068\u4e09\u91cd\u770c\u306e\u30d5\u30a1\u30a4\u30eb\u306f\u7834\u640d\u3057\u305f\u307e\u307e\u3067\u3042 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=15771\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u304c\u4e00\u90e8\u76f4\u3063\u3066\u3044\u305f\u4ef6&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":15391,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[12078,9122,12079,12025,12024,7554,7911,7901,4673,4964,12077,9254,12023,4000,6745,8413,12026,12021,9134,12080,9177,4672,7669,2740,12022,9159,12027,7694,7154,5123,12028,9151,1801,2498,9114,2684,462,9591,32,5903,7804,9583,5074,333,9137,9399,5902,3634,7240,9155,12076,6280,4439],"class_list":["post-15771","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-dbf-2","tag-shp-2","tag-shx-2","tag-allow_page_locks","tag-allow_row_locks","tag-alter-table","tag-check-constraint","tag-create-table","tag-from","tag-geography","tag-gis","tag-gml","tag-ignore_dup_key","tag-inner-join","tag-insert","tag-insert-into","tag-optimize_for_sequential_key","tag-pad_index","tag-planar-geometry","tag-primary-key-clustered","tag-qgis","tag-select","tag-shape2sql","tag-sql-server","tag-statistics_norecompute","tag-stream","tag-textimage_on","tag-upload-to-database","tag-use","tag-where","tag-with-check-add-constraint","tag-zip","tag-1801","tag-2498","tag-9114","tag-2684","tag-462","tag-9591","tag-32","tag-5903","tag-7804","tag-9583","tag-5074","tag-333","tag-9137","tag-9399","tag-5902","tag-3634","tag-7240","tag-9155","tag-12076","tag-6280","tag-4439"],"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15771","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=15771"}],"version-history":[{"count":10,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15771\/revisions"}],"predecessor-version":[{"id":15787,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15771\/revisions\/15787"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/media\/15391"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}