Slide 45
Slide 45 text
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
mysql> SELECT OGR_FID, ST_AsText(SHAPE), pref_name, city_name, s_name FROM geotest.h27ka23_utf8 WHERE
City_name='中村区' AND S_name LIKE '名駅1丁目'¥G
*************************** 1. row ***************************
OGR_FID: 1291
ST_AsText(SHAPE): POLYGON((35.1714383792575 136.880530344871,35.1714334916918
136.880578003878,35.1712304148452 136.880676613883,35.1711455917084 136.880960603925,35.170917088022
136.88198536401,35.1717659549363 136.882132452539,35.1719721646628 136.882168167574,35.1729521469771
136.882100876943,35.1734866931952 136.882027901788,35.1737608573632 136.88209162179,35.1738287373692
136.882088727695,35.173777238823 136.882529997,35.1735446657061 136.882663721771,35.1732290147527
136.882836564598,35.1730788175477 136.882902696931,35.1727904003677 136.883097486261,35.1726116266665
136.883200275345,35.172097516127 136.883580626978,35.171881132686 136.883742208184,35.171305375454
136.88417212652,35.1708566373497 136.884290761177,35.1698268543349 136.884626599348,35.1698117437829
136.884639644829,35.1690505776424 136.884866108417,35.1684136804101 136.88505060912,35.1676826495225
136.885244585496,35.1676609880786 136.885257138169,35.1675777685102 136.88451235585,35.1674853057151
136.883757358322,35.1674270995724 136.88331924717,35.1674075668575 136.883247851131,35.1673621787224
136.883081885212,35.1673470105787 136.882799263001,35.1679427752338 136.882342119012,35.168428486375
136.88198387296,35.1689183109133 136.881668146643,35.1694744240097 136.881332052728,35.1694644272673
136.881303292384,35.1713652044956 136.880319183163,35.1715333148049 136.880205063275,35.1715690013892
136.880257256582,35.173701094889 136.879567382601,35.1740314514692 136.879450868808,35.1741274208335
136.879741034936,35.1735293284842 136.879980574331,35.1728639275748 136.880197337619,35.1722314838013
136.880294981521,35.1721522044944 136.88039159533,35.1720218939305 136.880408924968,35.1717381912865
136.880421425892,35.1714383792575 136.880530344871))
pref_name: 愛知県
city_name: 中村区
s_name: 名駅1丁目
1 row in set (0.34 sec)
[実行例の続き]
45