ç®æ¬¡ æ¬ã¨ã³ããªã®æ¦è¦ åæ 極ç¹ã®è¡¨ãæ¹ 2ç¹éã§ç·ãå¼ã ç·ã¯ã©ãã«ã²ãããã®ã ã¡ãã£ã¨ãããã ã¾ã¨ã æ¬ã¨ã³ããªã®æ¦è¦ ãã®è¨äºã¯ RDBMS-GIS(MySQL,PostgreSQLãªã©) Advent Calendar 2022 ã®6æ¥ç®ã¨ãã¦ä½æãã¦ãã¾ãã ãµã¨æãã¤ãã¦ãã£ã¦ã¿ããã©ããããããªããã¨ã«ãªã£ãã¡ã¢ã§ãã åæ æå ã«ãã£ãMySQL8.0.17ã§æ¤è¨¼ãã¦ãã¾ãã SRIDã¯4326ã使ãã¾ãã SRID=4326ã®å ´åãAXIS["Lat",NORTH],AXIS["Lon",EAST]ã®é çªãªã®ã§ã緯度âçµåº¦ã®é çªã§æ¸ãã¾ãã ä»åã¯ãã£ããã¨ç®åºãããã®ã§ç´°ãã精度ã¯ãã ããã¾ããã 極ç¹ã®è¡¨ãæ¹ ã¾ãã¯2ç¹ã®å ´æã«ã¤ãã¦èãã¾ãã å極ç¹WKTï¼POINT(90 0) å極ç¹WKTï¼POINT(-90 0) 極ç¹ã«çµåº¦ã¯ãªãã®ã§ä»®ã«0ã¨ãã¾ãã S
{{#tags}}- {{label}}
{{/tags}}