Challenge #423: Wind Tower Proximity—Earth Day Special

[AGilbert]

With spatial expressions as an alternative to the find nearest tool. 

Spoiler

[jeprime]

It was definitely a challenge, as spatial work is not common in my workflows. Thanks for the practice.

[binuacs]

Spoiler

[Watermark]

JSON parse makes life easier. Use the column definitions in the container to also make life easier. 

Spoiler

 

[AaronSmatta]

Happy Earth Day

[Qiu]

It is a fun challenge.

Spoiler

And as noticed before the "Maximum Distances" field in the "Find Nearest" tool can not accept manual input anymore. 😬

[AGilbert]

Re: Find Nearest tool in 2023.2 - Alteryx Community

@Qiu the XML of the find nearest tool can be updated to use it as it was prior to the 2023.2 software release.

[Qiu]

@AGilbert 
This is good to know. Thank you very much.

[TurboToad]

Happy Earth day! 🌳🌻

Spoiler

[Yoshiro_Fujimori]

My solution.

Spoiler

Workflow


Expression in Formula tool
Irvine HQ = 
ST_CreatePoint(
ToNumber(REGEX_Replace([Irvine HQ (lat, long)], "^.*, ", "")),
ToNumber(REGEX_Replace([Irvine HQ (lat, long)], ",.*", ""))
)