MySQL 8.0で強化されたGIS機能と使用事例の紹介＋シェープファイルとGeoJSONファイルのインポート手順について

Slide 1

Slide 1 text

Copyright © 2019, Oracle and/or its affiliates. All rights reserved. MySQL 8.0で強化されたGIS機能と使用事例の紹介とシェープファイルのインポート手順について updated: 2019/07/26 Yoshiaki Yamasaki / 山﨑由章 MySQL Senior Solution Engineer, Asia Pacific and Japan

Slide 41

Slide 41 text

Copyright © 2019, Oracle and/or its affiliates. All rights reserved. mysql> SELECT * FROM geometry_columns; +-----------------+----------------+--------------+-------------------+-----------------+------+---------+ | F_TABLE_CATALOG | F_TABLE_SCHEMA | F_TABLE_NAME | F_GEOMETRY_COLUMN | COORD_DIMENSION | SRID | TYPE | +-----------------+----------------+--------------+-------------------+-----------------+------+---------+ | NULL | NULL | h27ka01_utf8 | SHAPE | 2 | 4612 | POLYGON | +-----------------+----------------+--------------+-------------------+-----------------+------+---------+ 1 row in set (0.00 sec) mysql> SELECT OGR_FID, ST_AsText(SHAPE), pref_name, city_name, s_name FROM geotest.h27ka01_utf8 WHERE City_name='白石区' AND S_name LIKE '東札幌五条１丁目'¥G *************************** 1. row *************************** OGR_FID: 3427 ST_AsText(SHAPE): POLYGON((43.0550809625361 141.387224543675,43.0550502503096 141.3869756233,43.0547956186902 141.386634897518,43.0554402089588 141.385733087378,43.0558313933916 141.385147563851,43.0562073782988 141.384561479229,43.0562504366654 141.384619566842,43.0564183414694 141.384846424007,43.0569802153486 141.385605384596,43.0573103628311 141.386051346905,43.0569143505206 141.38664998984,43.0567840871079 141.386797496904,43.0565725208237 141.387010208612,43.0564259538551 141.387140872716,43.0562709902474 141.387249306647,43.0559812036326 141.387404321055,43.0559001806069 141.3874413246,43.0560030294864 141.388388102444,43.0552097870596 141.388510734379,43.0551769103868 141.388142060102,43.0550809625361 141.387224543675)) pref_name: 北海道 city_name: 白石区 s_name: 東札幌五条１丁目 1 row in set (0.27 sec) [実行例の続き] 41 ※注：GDAL 2.4.2/32bit版使用時に、SRIDがNULLになる事象を確認しています。 SRIDを含むデータの場合、この部分にSRIDが入っていることを確認して下さい。

Slide 1

Slide 1 text

Slide 2

Slide 2 text

Slide 3

Slide 3 text

Slide 4

Slide 4 text

Slide 5

Slide 5 text

Slide 6

Slide 6 text

Slide 7

Slide 7 text

Slide 8

Slide 8 text

Slide 9

Slide 9 text

Slide 10

Slide 10 text

Slide 11

Slide 11 text

Slide 12

Slide 12 text

Slide 13

Slide 13 text

Slide 14

Slide 14 text

Slide 15

Slide 15 text

Slide 16

Slide 16 text

Slide 17

Slide 17 text

Slide 18

Slide 18 text

Slide 19

Slide 19 text

Slide 20

Slide 20 text

Slide 21

Slide 21 text

Slide 22

Slide 22 text

Slide 23

Slide 23 text

Slide 24

Slide 24 text

Slide 25

Slide 25 text

Slide 26

Slide 26 text

Slide 27

Slide 27 text

Slide 28

Slide 28 text

Slide 29

Slide 29 text

Slide 30

Slide 30 text

Slide 31

Slide 31 text

Slide 32

Slide 32 text

Slide 33

Slide 33 text

Slide 34

Slide 34 text

Slide 35

Slide 35 text

Slide 36

Slide 36 text

Slide 37

Slide 37 text

Slide 38

Slide 38 text

Slide 39

Slide 39 text

Slide 40

Slide 40 text