geof_09judgerfuncs.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "90662c69-2af0-43d4-9e1a-0fe66519292a",
   "metadata": {},
   "source": [
    "## 位置情報とパブリックデータ#09: <br>(地理空間関数)オブジェクト間の関係判定"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "076203cb-668f-4a93-867b-ca9a042274e8",
   "metadata": {},
   "source": [
    "#### データベース接続"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "9581807a-d06d-4481-ad35-b061a2cc6997",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdin",
     "output_type": "stream",
     "text": [
      "Password: ········\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Success: 'jumbo' connection established and activated for user 'jumbo', with default database 'jumbo'\n"
     ]
    }
   ],
   "source": [
    "%connect jumbo"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b17a5305-69cf-4be4-af75-12c72ac702da",
   "metadata": {},
   "source": [
    "#### お掃除"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "6f9f992c-6fc8-426b-84f3-ba49487d4085",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "ename": "ERROR",
     "evalue": "Unable to run SQL: Unable to run SQL query: Database reported error:3807:Object 'jumbo.geotest' does not exist.",
     "output_type": "error",
     "traceback": [
      "Unable to run SQL: Unable to run SQL query: Database reported error:3807:Object 'jumbo.geotest' does not exist."
     ]
    }
   ],
   "source": [
    "drop table jumbo.geotest; "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9c8de16f-66ed-4a26-88a4-0f3163ecd63d",
   "metadata": {},
   "source": [
    "#### 空テーブルの用意"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "8754fbf4-48ca-443a-9412-761cbff6d7c1",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Success: 0 rows affected"
      ]
     },
     "execution_count": 3,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    }
   ],
   "source": [
    "create table jumbo.geotest ( \n",
    "オブジェクト名 varchar(10) character set unicode, \n",
    "区分 varchar(10) character set unicode, \n",
    "lonlat st_geometry \n",
    ") primary index (オブジェクト名) \n",
    "; "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "047cc48c-4276-4c4f-b0c3-735ab6176422",
   "metadata": {},
   "source": [
    "#### データの挿入"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "f1010d73-b97f-4f62-9f61-952f08774960",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "Success: 1 rows affected"
      ]
     },
     "execution_count": 4,
     "metadata": {
      "application/vnd.teradata.resultset": ""
     },
     "output_type": "execute_result"
    }
   ],
   "source": [
    "insert into jumbo.geotest values ('点0','基準','point(146 42)'); \n",
    "insert into jumbo.geotest values ('点1','単独','point(146 37)'); \n",
    "insert into jumbo.geotest values ('点2','比較','point(146 36)'); \n",
    "insert into jumbo.geotest values ('点3','比較','point(146 35)'); \n",
    "insert into jumbo.geotest values ('点4','比較','point(146 38)'); \n",
    "insert into jumbo.geotest values ('頂0','基準','linestring(142 41,142.5 42,143 41,145.5 41,146 42,146.5 41)'); \n",
    "insert into jumbo.geotest values ('頂1','単独','linestring(138 37.5,138.5 36.5,139 37.5)'); \n",
    "insert into jumbo.geotest values ('頂2','比較','linestring(139 37,139.5 36,140 37)'); \n",
    "insert into jumbo.geotest values ('頂3','比較','linestring(140 36.5,140.5 35.5,141 36.5)'); \n",
    "insert into jumbo.geotest values ('頂4','比較','linestring(141 35.5,141.5 34.5,142 35.5)'); \n",
    "insert into jumbo.geotest values ('頂5','比較','linestring(142 35,142.5 34,143 35)'); \n",
    "insert into jumbo.geotest values ('頂6','比較','linestring(139 39,139.5 38,140 39)'); \n",
    "insert into jumbo.geotest values ('頂7','比較','linestring(140 38.5,140.5 37.5,141 38.5)'); \n",
    "insert into jumbo.geotest values ('頂8','比較','linestring(142 43,142.5 42,143 43)'); \n",
    "insert into jumbo.geotest values ('頂9','比較','linestring(142 42,142.5 41,143 42)'); \n",
    "insert into jumbo.geotest values ('線0','基準','linestring(131 38,147 38)'); \n",
    "insert into jumbo.geotest values ('線1','単独','linestring(131 37.5,131 36.5)'); \n",
    "insert into jumbo.geotest values ('線2','比較','linestring(132 37,132 36)'); \n",
    "insert into jumbo.geotest values ('線3','比較','linestring(133 36.5,133 35.5)'); \n",
    "insert into jumbo.geotest values ('線4','比較','linestring(134 35.5,134 34.5)'); \n",
    "insert into jumbo.geotest values ('線5','比較','linestring(135 35,135 34)'); \n",
    "insert into jumbo.geotest values ('線6','比較','linestring(132 39,132 38)'); \n",
    "insert into jumbo.geotest values ('線7','比較','linestring(133 38.5,133 37.5)'); \n",
    "insert into jumbo.geotest values ('線8','比較','linestring(134 38,135 38)'); \n",
    "insert into jumbo.geotest values ('面0','基準','polygon((124 36,147 36,147 34,124 34,124 36))'); \n",
    "insert into jumbo.geotest values ('面1','単独','polygon((124 37.5,125 37.5,125 36.5,124 36.5,124 37.5))'); \n",
    "insert into jumbo.geotest values ('面2','比較','polygon((125 37,126 37,126 36,125 36,125 37))'); \n",
    "insert into jumbo.geotest values ('面3','比較','polygon((126 36.5,127 36.5,127 35.5,126 35.5,126 36.5))'); \n",
    "insert into jumbo.geotest values ('面4','比較','polygon((127 35.5,128 35.5,128 34.5,127 34.5,127 35.5))'); \n",
    "insert into jumbo.geotest values ('面5','比較','polygon((128 35,129 35,129 34,128 34,128 35))'); "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a2c6ffd0-42c3-47cd-b3c9-ecaddef0bb86",
   "metadata": {},
   "source": [
    "#### 関係判定関数の確認テスト"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "c5656021-2cde-45a3-9a4f-90f87b9b69fe",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "application/vnd.teradata.resultset": "\"名前左\",\"名前右\",\"関係\",\"左右_intersects\",\"右左_intersects\",\"左右_disjoint\",\"右左_disjoint\",\"左右_contains\",\"右左_contains\",\"左右_within\",\"右左_within\",\"左右_overlaps\",\"右左_overlaps\",\"左右_crosses\",\"右左_crosses\"\n\"面0\",\"面0\",\"01_自分自身\",\"1\",\"1\",\"0\",\"0\",\"1\",\"1\",\"1\",\"1\",\"0\",\"0\",\"\",\"\"\n\"線0\",\"線0\",\"02_自分自身\",\"1\",\"1\",\"0\",\"0\",\"1\",\"1\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\"\n\"頂0\",\"頂0\",\"03_自分自身\",\"1\",\"1\",\"0\",\"0\",\"1\",\"1\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\"\n\"点0\",\"点0\",\"04_自分自身\",\"1\",\"1\",\"0\",\"0\",\"1\",\"1\",\"1\",\"1\",\"0\",\"0\",\"\",\"\"\n\"面0\",\"面1\",\"05_離れ\",\"0\",\"0\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"\",\"\"\n\"面0\",\"面2\",\"06_外触\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"\",\"\"\n\"面0\",\"面3\",\"07_交差\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"1\",\"1\",\"\",\"\"\n\"面0\",\"面4\",\"08_中に\",\"1\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"\",\"\"\n\"面0\",\"面5\",\"09_内触\",\"1\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"\",\"\"\n\"面0\",\"線1\",\"10_離れ\",\"0\",\"0\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"\",\"\",\"0\",\"0\"\n\"面0\",\"線2\",\"11_外触\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"\",\"\",\"0\",\"0\"\n\"面0\",\"線3\",\"12_交差\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"\",\"\",\"1\",\"1\"\n\"面0\",\"線4\",\"13_中に\",\"1\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"1\",\"\",\"\",\"0\",\"0\"\n\"面0\",\"線5\",\"14_内触\",\"1\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"1\",\"\",\"\",\"0\",\"0\"\n\"面0\",\"頂1\",\"15_離れ\",\"0\",\"0\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"\",\"\",\"0\",\"0\"\n\"面0\",\"頂2\",\"16_外触\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"\",\"\",\"0\",\"0\"\n\"面0\",\"頂3\",\"17_交差\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"\",\"\",\"1\",\"1\"\n\"面0\",\"頂4\",\"18_中に\",\"1\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"1\",\"\",\"\",\"0\",\"0\"\n\"面0\",\"頂5\",\"19_内触\",\"1\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"1\",\"\",\"\",\"0\",\"0\"\n\"面0\",\"点1\",\"20_離れ\",\"0\",\"0\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"\",\"\",\"0\",\"0\"\n\"面0\",\"点2\",\"21_交差\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"\",\"\",\"0\",\"0\"\n\"面0\",\"点3\",\"22_中に\",\"1\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"1\",\"\",\"\",\"0\",\"0\"\n\"線0\",\"線1\",\"23_離れ\",\"0\",\"0\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"\n\"線0\",\"線6\",\"24_触る\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"\n\"線0\",\"線7\",\"25_交差\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"1\",\"1\"\n\"線0\",\"線8\",\"26_線上\",\"1\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"0\",\"0\"\n\"線0\",\"頂1\",\"27_離れ\",\"0\",\"0\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"\n\"線0\",\"頂6\",\"28_触る\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"1\",\"1\"\n\"線0\",\"頂7\",\"29_交差\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"1\",\"1\"\n\"線0\",\"点1\",\"30_離れ\",\"0\",\"0\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"\",\"\",\"0\",\"0\"\n\"線0\",\"点4\",\"31_交差\",\"1\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"1\",\"\",\"\",\"0\",\"0\"\n\"頂0\",\"頂1\",\"32_離れ\",\"0\",\"0\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"\n\"頂0\",\"頂8\",\"33_触る\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"1\",\"1\"\n\"頂0\",\"頂9\",\"34_交差\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"1\",\"1\"\n\"頂0\",\"点0\",\"35_交差\",\"1\",\"1\",\"0\",\"0\",\"1\",\"0\",\"0\",\"1\",\"\",\"\",\"0\",\"0\"\n\"頂0\",\"点1\",\"36_離れ\",\"0\",\"0\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"\",\"\",\"0\",\"0\"\n\"点0\",\"点1\",\"37_離れ\",\"0\",\"0\",\"1\",\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"\",\"\"",
      "text/html": [
       "<div class = \"td-resultset-table-div\" style = \"max-height: 100%; overflow-y: auto\">\n",
       "      <table class=\"tdhistory883810\"><style>\n",
       "      table.tdhistory883810 { display: block !important; min-height: 588px !important; overflow: auto !important; height: 588px !important; width: 100% !important; border: 1px solid rgb(207, 207, 207) !important; border-collapse: collapse !important; ; color: var(--jp-ui-font-color1) !important; }\n",
       "      th.tdhistory883810 { border: 1px solid rgb(198,198,198) !important; border-collapse: collapse !important; ; padding: 2px 5px !important; ; font-size: 13px !important; ; text-align: center !important; white-space: normal !important; color: var(--jp-ui-font-color1) !important; }\n",
       "      th.tdhistory883810:last-child { text-align: left !important; }\n",
       "      tbody.tdhistory883810 tr:nth-child(even) { background: rgba(243, 243, 243, 0.75) !important; }\n",
       "      tbody.tdhistory883810 tr:nth-child(odd) { background: var(--jp-ui-inverse-font-color1) !important; }\n",
       "      td.tdhistory883810 { border: 1px solid rgb(207, 207, 207) !important; border-collapse: collapse !important; ; padding: 2px 5px !important; ; font-size: 13px !important; ; text-align: left !important;          white-space: nowrap !important; overflow:hidden !important; text-overflow:ellipsis !important;; }\n",
       "    </style><thead><tr style= \"background: rgba(243, 243, 243, 0.75)\"><th class=\"tdhistory883810\"></th><th class=\"tdhistory883810\">名前左</th><th class=\"tdhistory883810\">名前右</th><th class=\"tdhistory883810\">関係</th><th class=\"tdhistory883810\">左右_intersects</th><th class=\"tdhistory883810\">右左_intersects</th><th class=\"tdhistory883810\">左右_disjoint</th><th class=\"tdhistory883810\">右左_disjoint</th><th class=\"tdhistory883810\">左右_contains</th><th class=\"tdhistory883810\">右左_contains</th><th class=\"tdhistory883810\">左右_within</th><th class=\"tdhistory883810\">右左_within</th><th class=\"tdhistory883810\">左右_overlaps</th><th class=\"tdhistory883810\">右左_overlaps</th><th class=\"tdhistory883810\">左右_crosses</th><th class=\"tdhistory883810\">右左_crosses</th></tr></thead><tbody class=\"tdhistory883810 resultset-body\"><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">1</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">01_自分自身</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">2</th><td class=\"tdhistory883810\">線0</td><td class=\"tdhistory883810\">線0</td><td class=\"tdhistory883810\">02_自分自身</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">3</th><td class=\"tdhistory883810\">頂0</td><td class=\"tdhistory883810\">頂0</td><td class=\"tdhistory883810\">03_自分自身</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">4</th><td class=\"tdhistory883810\">点0</td><td class=\"tdhistory883810\">点0</td><td class=\"tdhistory883810\">04_自分自身</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">5</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">面1</td><td class=\"tdhistory883810\">05_離れ</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">6</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">面2</td><td class=\"tdhistory883810\">06_外触</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">7</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">面3</td><td class=\"tdhistory883810\">07_交差</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">8</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">面4</td><td class=\"tdhistory883810\">08_中に</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">9</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">面5</td><td class=\"tdhistory883810\">09_内触</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">10</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">線1</td><td class=\"tdhistory883810\">10_離れ</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">11</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">線2</td><td class=\"tdhistory883810\">11_外触</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">12</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">線3</td><td class=\"tdhistory883810\">12_交差</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">13</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">線4</td><td class=\"tdhistory883810\">13_中に</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">14</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">線5</td><td class=\"tdhistory883810\">14_内触</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">15</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">頂1</td><td class=\"tdhistory883810\">15_離れ</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">16</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">頂2</td><td class=\"tdhistory883810\">16_外触</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">17</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">頂3</td><td class=\"tdhistory883810\">17_交差</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">18</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">頂4</td><td class=\"tdhistory883810\">18_中に</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">19</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">頂5</td><td class=\"tdhistory883810\">19_内触</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">20</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">点1</td><td class=\"tdhistory883810\">20_離れ</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">21</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">点2</td><td class=\"tdhistory883810\">21_交差</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">22</th><td class=\"tdhistory883810\">面0</td><td class=\"tdhistory883810\">点3</td><td class=\"tdhistory883810\">22_中に</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">23</th><td class=\"tdhistory883810\">線0</td><td class=\"tdhistory883810\">線1</td><td class=\"tdhistory883810\">23_離れ</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">24</th><td class=\"tdhistory883810\">線0</td><td class=\"tdhistory883810\">線6</td><td class=\"tdhistory883810\">24_触る</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">25</th><td class=\"tdhistory883810\">線0</td><td class=\"tdhistory883810\">線7</td><td class=\"tdhistory883810\">25_交差</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">26</th><td class=\"tdhistory883810\">線0</td><td class=\"tdhistory883810\">線8</td><td class=\"tdhistory883810\">26_線上</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">27</th><td class=\"tdhistory883810\">線0</td><td class=\"tdhistory883810\">頂1</td><td class=\"tdhistory883810\">27_離れ</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">28</th><td class=\"tdhistory883810\">線0</td><td class=\"tdhistory883810\">頂6</td><td class=\"tdhistory883810\">28_触る</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">29</th><td class=\"tdhistory883810\">線0</td><td class=\"tdhistory883810\">頂7</td><td class=\"tdhistory883810\">29_交差</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">30</th><td class=\"tdhistory883810\">線0</td><td class=\"tdhistory883810\">点1</td><td class=\"tdhistory883810\">30_離れ</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">31</th><td class=\"tdhistory883810\">線0</td><td class=\"tdhistory883810\">点4</td><td class=\"tdhistory883810\">31_交差</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">32</th><td class=\"tdhistory883810\">頂0</td><td class=\"tdhistory883810\">頂1</td><td class=\"tdhistory883810\">32_離れ</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">33</th><td class=\"tdhistory883810\">頂0</td><td class=\"tdhistory883810\">頂8</td><td class=\"tdhistory883810\">33_触る</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">34</th><td class=\"tdhistory883810\">頂0</td><td class=\"tdhistory883810\">頂9</td><td class=\"tdhistory883810\">34_交差</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">35</th><td class=\"tdhistory883810\">頂0</td><td class=\"tdhistory883810\">点0</td><td class=\"tdhistory883810\">35_交差</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">36</th><td class=\"tdhistory883810\">頂0</td><td class=\"tdhistory883810\">点1</td><td class=\"tdhistory883810\">36_離れ</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td></tr><tr><th class=\"tdhistory883810\" style= \"background: rgba(243, 243, 243, 0.75)\">37</th><td class=\"tdhistory883810\">点0</td><td class=\"tdhistory883810\">点1</td><td class=\"tdhistory883810\">37_離れ</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">1</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\">0</td><td class=\"tdhistory883810\"></td><td class=\"tdhistory883810\"></td></tr></tbody></table></div>"
      ]
     },
     "execution_count": 5,
     "metadata": {
      "application/vnd.teradata.resultset": "{\"resultSetID\":\"C:\\\\\\\\Users\\\\\\\\youruserdirectory\\\\\\\\Teradata\\\\\\\\Resultsets\\\\\\\\2023.10.19_18.02.33.420_JST\",\"historyID\":89,\"chunkID\":\"00001\",\"sessionid\":\"\",\"portnum\":\"\",\"dockermode\":\"standalone\",\"totalRowCount\":37,\"chunkCount\":0,\"rowLimit\":0,\"columnMetadata\":[{\"columnName\":\"名前左\",\"columnTypeName\":\"VARCHAR\",\"length\":10,\"scale\":10},{\"columnNumber\":1,\"columnName\":\"名前右\",\"columnTypeName\":\"VARCHAR\",\"length\":10,\"scale\":10},{\"columnNumber\":2,\"columnName\":\"関係\",\"columnTypeName\":\"VARCHAR\",\"length\":7,\"scale\":7},{\"columnNumber\":3,\"columnName\":\"左右_intersects\",\"columnTypeName\":\"INTEGER\"},{\"columnNumber\":4,\"columnName\":\"右左_intersects\",\"columnTypeName\":\"INTEGER\"},{\"columnNumber\":5,\"columnName\":\"左右_disjoint\",\"columnTypeName\":\"INTEGER\"},{\"columnNumber\":6,\"columnName\":\"右左_disjoint\",\"columnTypeName\":\"INTEGER\"},{\"columnNumber\":7,\"columnName\":\"左右_contains\",\"columnTypeName\":\"INTEGER\"},{\"columnNumber\":8,\"columnName\":\"右左_contains\",\"columnTypeName\":\"INTEGER\"},{\"columnNumber\":9,\"columnName\":\"左右_within\",\"columnTypeName\":\"INTEGER\"},{\"columnNumber\":10,\"columnName\":\"右左_within\",\"columnTypeName\":\"INTEGER\"},{\"columnNumber\":11,\"columnName\":\"左右_overlaps\",\"columnTypeName\":\"INTEGER\"},{\"columnNumber\":12,\"columnName\":\"右左_overlaps\",\"columnTypeName\":\"INTEGER\"},{\"columnNumber\":13,\"columnName\":\"左右_crosses\",\"columnTypeName\":\"INTEGER\"},{\"columnNumber\":14,\"columnName\":\"右左_crosses\",\"columnTypeName\":\"INTEGER\"}]}"
     },
     "output_type": "execute_result"
    }
   ],
   "source": [
    "with src as ( \t\t\n",
    "\t /*吟味したい関係に名前を付ける、nullはあとで落とす*/ \t\n",
    "\tselect \t\n",
    "\t名前左, \t\n",
    "\t名前右, \t\n",
    "\tlonlat左, \t\n",
    "\tlonlat右, \t\n",
    "\tcase \t\n",
    "\twhen 名前左='面0' and 名前右='面0' then '01_自分自身' \t\n",
    "\twhen 名前左='線0' and 名前右='線0' then '02_自分自身' \t\n",
    "\twhen 名前左='頂0' and 名前右='頂0' then '03_自分自身' \t\n",
    "\twhen 名前左='点0' and 名前右='点0' then '04_自分自身' \t\n",
    "\twhen 名前左='面0' and 名前右='面1' then '05_離れ' \t\n",
    "\twhen 名前左='面0' and 名前右='面2' then '06_外触' \t\n",
    "\twhen 名前左='面0' and 名前右='面3' then '07_交差' \t\n",
    "\twhen 名前左='面0' and 名前右='面4' then '08_中に' \t\n",
    "\twhen 名前左='面0' and 名前右='面5' then '09_内触' \t\n",
    "\twhen 名前左='面0' and 名前右='線1' then '10_離れ' \t\n",
    "\twhen 名前左='面0' and 名前右='線2' then '11_外触' \t\n",
    "\twhen 名前左='面0' and 名前右='線3' then '12_交差' \t\n",
    "\twhen 名前左='面0' and 名前右='線4' then '13_中に' \t\n",
    "\twhen 名前左='面0' and 名前右='線5' then '14_内触' \t\n",
    "\twhen 名前左='面0' and 名前右='頂1' then '15_離れ' \t\n",
    "\twhen 名前左='面0' and 名前右='頂2' then '16_外触' \t\n",
    "\twhen 名前左='面0' and 名前右='頂3' then '17_交差' \t\n",
    "\twhen 名前左='面0' and 名前右='頂4' then '18_中に' \t\n",
    "\twhen 名前左='面0' and 名前右='頂5' then '19_内触' \t\n",
    "\twhen 名前左='面0' and 名前右='点1' then '20_離れ' \t\n",
    "\twhen 名前左='面0' and 名前右='点2' then '21_交差' \t\n",
    "\twhen 名前左='面0' and 名前右='点3' then '22_中に' \t\n",
    "\twhen 名前左='線0' and 名前右='線1' then '23_離れ' \t\n",
    "\twhen 名前左='線0' and 名前右='線6' then '24_触る' \t\n",
    "\twhen 名前左='線0' and 名前右='線7' then '25_交差' \t\n",
    "\twhen 名前左='線0' and 名前右='線8' then '26_線上' \t\n",
    "\twhen 名前左='線0' and 名前右='頂1' then '27_離れ' \t\n",
    "\twhen 名前左='線0' and 名前右='頂6' then '28_触る' \t\n",
    "\twhen 名前左='線0' and 名前右='頂7' then '29_交差' \t\n",
    "\twhen 名前左='線0' and 名前右='点1' then '30_離れ' \t\n",
    "\twhen 名前左='線0' and 名前右='点4' then '31_交差' \t\n",
    "\twhen 名前左='頂0' and 名前右='頂1' then '32_離れ' \t\n",
    "\twhen 名前左='頂0' and 名前右='頂8' then '33_触る' \t\n",
    "\twhen 名前左='頂0' and 名前右='頂9' then '34_交差' \t\n",
    "\twhen 名前左='頂0' and 名前右='点0' then '35_交差' \t\n",
    "\twhen 名前左='頂0' and 名前右='点1' then '36_離れ' \t\n",
    "\twhen 名前左='点0' and 名前右='点1' then '37_離れ' \t\n",
    "\telse null end as 関係 \t\n",
    "\tfrom (\t\n",
    "\t\tselect \n",
    "\t\tオブジェクト名 as 名前左, \n",
    "\t\tlonlat as lonlat左 \n",
    "\t\tfrom jumbo.geotest \n",
    "\t\twhere 区分='基準' \n",
    "\t) a1 cross join ( \t\n",
    "\t\tselect \n",
    "\t\tオブジェクト名 as 名前右, \n",
    "\t\t区分, \n",
    "\t\tlonlat as lonlat右 \n",
    "\t\tfrom jumbo.geotest \n",
    "\t) a2 \t\n",
    ") \t\t\n",
    "\t /*全テストケース*/ \t\n",
    "\tselect \t\n",
    "\t名前左, \t\n",
    "\t名前右, \t\n",
    "\t関係, \t\n",
    "\tlonlat左.st_intersects(lonlat右) as 左右_intersects, \n",
    "\tlonlat右.st_intersects(lonlat左) as 右左_intersects, \n",
    "\tlonlat左.st_disjoint(lonlat右) as 左右_disjoint, \n",
    "\tlonlat右.st_disjoint(lonlat左) as 右左_disjoint, \n",
    "\tlonlat左.st_contains(lonlat右) as 左右_contains, \n",
    "\tlonlat右.st_contains(lonlat左) as 右左_contains, \n",
    "\tlonlat左.st_within(lonlat右) as 左右_within, \n",
    "\tlonlat右.st_within(lonlat左) as 右左_within, \n",
    "\tlonlat左.st_overlaps(lonlat右) as 左右_overlaps, \n",
    "\tlonlat右.st_overlaps(lonlat左) as 右左_overlaps, \n",
    "\tlonlat左.st_crosses(lonlat右) as 左右_crosses, \n",
    "\tlonlat右.st_crosses(lonlat左) as 右左_crosses \n",
    "\tfrom src \t\n",
    "\twhere 関係 is not null \n",
    "\torder by 関係 \n",
    "\t; \t"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "97e66928-0ce7-40ac-9379-f21e61e45ce5",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Teradata SQL",
   "language": "Teradata SQL",
   "name": "teradatasql"
  },
  "language_info": {
   "codemirror_mode": "Teradata SQL",
   "file_extension": ".tdrs",
   "mimetype": "application/vnd.teradata.resultset",
   "name": "Teradata SQL",
   "nbconvert_exporter": "",
   "pygments_lexer": "",
   "version": "16.20"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}