{"version":"1.0","type":"rich","title":"Postgres/PostGIS query for buffer and spatial 'shifted' point","description":"This example shows how PostGIS builds a composite set of geographic buffers and a projected point for use in a Tableau dashboard. It first creates a donut-shaped buffer by taking the difference between two concentric buffer polygons around a point defined by longitude and latitude. It then projects a new point three times the buffer distance away, rotates it 90 degrees, and buffers it into a small circle. The code uses `ST_MakePoint`, `ST_Buffer`, `ST_Difference`, `ST_Project`, and `st_collect` to assemble the result as a geography MultiPolygon.","provider_name":"VizHub AI Studio","provider_url":"https://next.vizhub.com","html":"<iframe src=\"https://next.vizhub.com/viz/gist-9eb640ed3b343ff8bbf9f6220bec3011?mode=embed\" width=\"960\" height=\"500\" scrolling=\"no\" frameborder=\"1\"></iframe>","width":960,"height":500,"cache_age":3600}