LoginSignup
2
1

More than 5 years have passed since last update.

Golang+MySQLでPolygonを取得する

Posted at

概要

MySQLに入れたポリゴンデータを取得するのに、どんな型を使えば良いのか分からなかったのでメモ
orb.Polygonの他にorb.Pointorb.LineStringなんかも使えるので、空間系のデータを扱うのに便利そう
問題はgormや他のormでどうやって使えばいいのか分からない・・・

コード

query.go
import (
    "github.com/paulmach/orb"
    "github.com/paulmach/orb/encoding/wkb"
)
func Do() {
    var polygon orb.Polygon
    query := "SELECT ST_AsBinary(polygon) FROM areas WHERE MBRIntersects(GeomFromText('POLYGON((135.4949573  34.700436, 135.498854 34.697071))'), polygon)"
    row := DB.QueryRow(query)
    err := row.Scan(wkb.Scanner(&polygon))
}

2
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
2
1