Takes a GeoJSON Point and calculates the circle polygon given a radius in units (default units are kilometers).
geoCircle(point, radius[, units])
|point||Required. The center of the circle as either coordinates or a GeoJSON Point.|
|radius||Required. The radius of the circle as an integer or decimal.|
|units||Optional. Specified as a string. Options are ‘degrees’, ‘radians’, ‘miles’, or ‘kilometers’. Default is ‘kilometers’.|
Return a GeoJSON circle with a radius of 1.5 miles from a given point., in kilometers, of a manually passed GeoJSON linestring.
SELECT geoCircle('[-104.979127,39.761563]', 1.5, 'miles')
Generate a heatmap of interest based on points. The geo_data column stores a given point and the interest column stores an interest score, which will be used as the radius of the circle.
SELECT geoCircle(geo_data, interest, 'miles') FROM dev.locations