Documentation

geo.ST_Intersects() function

Flux 0.63.0+

The geo.ST_Intersects() function is experimental and subject to change at any time. By using this function, you accept the risks of experimental functions.

The geo.ST_Intersects() function tests if the specified geographic information system (GIS) geometry intersects with the specified region and returns true or false.

import "experimental/geo"

geo.ST_Intersects(
  region: {lat: 40.7, lon: -73.3, radius: 20.0},
  geometry: {linestring: "39.7515 14.01433, 38.3527 13.9228, 36.9978 15.08433"}
)

// Returns false

Parameters

region

The region to test. Specify record properties for the shape. See Region definitions.

geometry

The GIS geometry to test. Can be either point or linestring geometry. See GIS geometry definitions.

Examples

Test if geographic points intersect with a region
import "experimental/geo"

region = {
  minLat: 40.51757813,
  maxLat: 40.86914063,
  minLon: -73.65234375,
  maxLon: -72.94921875
}

data
  |> geo.toRows()
  |> map(fn: (r) => ({
    r with st_within: geo.ST_Intersects(region: box, geometry: {lat: r.lat, lon: r.lon})
  }))

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.