Skip to content

Instantly share code, notes, and snippets.

@johnniehard

johnniehard/getradius.sql

Created July 1, 2020 08:38
Show Gist options
  • Save johnniehard/5c7db300be67712f2c7153ecbf661898 to your computer and use it in GitHub Desktop.
Save johnniehard/5c7db300be67712f2c7153ecbf661898 to your computer and use it in GitHub Desktop.
Download ZIP
Getting the centroid and radius of (circle) polygons with postgis.
Raw
getradius.sql
create table "magnus-etuna".trees as
select fid, center as geom, radius as crownRadius from "magnus-etuna"."tree-polygons", ST_MinimumBoundingRadius(geom) as geom;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment