How to create a cone polygon in Alteryx?

[ishackm]

Hi everyone,

This is my first post here.

I have the following data for each spatial point:

X and Y coordinate for the point on a map

“Angle to Map North” and “Visibility sector radius”

The angle of the cone is always 45 degrees.

I would like to create a polygon for each point as below.

Is there a workflow as such in Alteryx I could use?

Many Thanks,

[AngelosPachis]

Hi @ishackm ,

I believe this workflow answers your question. The theory behind it is that from your starting point you go on and find the two points that form the edges of your arc. The angle between the starting point and those two edges will be (in degrees) your "angle to map north" +/- 45/2 from map north.

Then for the messy trigonometric part, I would suggest going through the following two pages:

https://www.movable-type.co.uk/scripts/latlong.html (section Destination point given distance and bearing from start point)

https://stackoverflow.com/questions/3225803/calculate-endpoint-given-distance-bearing-starting-point

In the formulas, all coordinates and angles should be converted to radians and then back to degrees (took me a while to figure this out)

Assuming your coordinates are given on a map and look like the following

Your output would look something like this 

Hope that helps,

Angelos

[PhilipMannering · Accepted solution]

This is my best effort, a few degrees off..