User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
gis:postgis [2022/05/06 11:49]
Jan Forman [Buffer point using SQL]
gis:postgis [2022/05/06 11:50] (current)
Jan Forman [Buffer point using SQL]
Line 27: Line 27:
 ====== Buffer point using SQL ====== ====== Buffer point using SQL ======
 +1000 meters - keep SJTSK in meters then convert it to WGS84
 <code> <code>
 SELECT id,ST_Transform(ST_Buffer(ST_Transform(shape,5514),1000),4326) FROM table SELECT id,ST_Transform(ST_Buffer(ST_Transform(shape,5514),1000),4326) FROM table
 </code> </code>
gis/postgis.txt · Last modified: 2022/05/06 11:50 by Jan Forman