Postgres/PostGIS query for buffer and spatial 'shifted' point
CAST( | |
-- make collection | |
st_collect(ARRAY[ | |
-- make line from two range polygons | |
st_difference( CAST( | |
st_buffer( | |
CAST( | |
ST_MakePoint( | |
"postinfo"."lon", | |
"postinfo"."lat") AS geography(POINT, 4326)), | |
"ranges"."range"+1, | |
8)::geometry AS geometry(POLYGON, 4326)) , CAST( | |
st_buffer( | |
CAST( | |
ST_MakePoint( | |
"postinfo"."lon", | |
"postinfo"."lat") AS geography(POINT, 4326)), | |
"ranges"."range", | |
8)::geometry AS geometry(POLYGON, 4326)) ) | |
, | |
-- create polygon (Tableau can't handle mixed geography types) | |
ST_buffer( | |
-- create point at distance from mission to create 'air' on dashboard | |
ST_Project( | |
CAST( | |
ST_MakePoint( | |
"postinfo"."lon", | |
"postinfo"."lat") AS geography(POINT, 4326)), | |
"ranges"."range" * | |
3, | |
radians( | |
90.0))::geometry | |
-- end st_project | |
,0.001) | |
]) | |
AS geography(MultiPolygon, 4326)) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment