Slide 50
Slide 50 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.h27ka15_utf8 WHERE
City_name='中央区' AND S_name LIKE '万代島'¥G
*************************** 1. row ***************************
OGR_FID: 814
ST_AsText(SHAPE): POLYGON((37.9232426725295 139.059374657909,37.9231617541823
139.059516226588,37.9230092055425 139.059385383328,37.9229074836943 139.059549543294,37.9230698762218
139.059712272404,37.9230244326007 139.059794970949,37.9230044037725 139.059832364056,37.9229825296813
139.059873164603,37.9227881445128 139.060220878237,37.9238405488986 139.061153562309,37.9242586362481
139.061515015303,37.9249719262301 139.062144850395,37.9247628490608 139.062531156223,37.9248445685455
139.062605709245,37.9250643060827 139.062227436983,37.9257749829017 139.062843624098,37.9258171885402
<<中略>>
139.062750784307,37.9272359547297 139.06238521585,37.9258639890293 139.061570339505,37.9258235755662
139.061542753025,37.9257894798066 139.061518590326,37.9253294093601 139.061252386949,37.9251779393372
139.061072671085,37.9251588795265 139.061054530295,37.9248900759988 139.060799774072,37.9246863453157
139.060626462834,37.9240887756498 139.060113525324,37.923827574607 139.059887489324,37.9237747347258
139.059838172089,37.9237504841939 139.059816396186,37.9232426725295 139.059374657909))
pref_name: 新潟県
city_name: 中央区
s_name: 万代島
1 row in set (0.23 sec)
[実行例の続き]
50