I would like to create 100 meters circle buffers in a UTM projection from a point table whose SRID is EPSG:4326 and keeping the id column. I wonder what is the straightest way. Is that possible to get it in one query after having created a buffer table with the URM SRID? Like:

INSERT INTO buffers SELECT id_points, ST_Buffer (geom, 100 , 'quad_segs=8') AS geom from points

but this would require I guess to add ST_transform somewhere and ST_Buffer does not like to involve two different SRID.

  • 3
    Just cast to geography within the buffer request.
    – Vince
    Feb 13, 2021 at 0:14
  • 1
    it seems it required to be cast twice: INSERT INTO buffers SELECT id_points, CAST(ST_Buffer(CAST(points.geom AS geography), 100 , 'quad_segs=8') AS geometry) AS geom from points. Thanks for the tip!
    – Severin
    Feb 15, 2021 at 17:40
  • 1
    or points.geom::geography,...)::geometry
    – Vince
    Feb 15, 2021 at 17:54


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.