https://community.esri.com/t5/arcgis-online-questions/arcade-script-to-pull-a-intersect-value-from/m-p/1495472#M59800 <P>Hey AGOL Blog,<BR /><BR />I have 5 overlapping/stacked floor layers that each have a room_id attribute. I'm trying to run a script that checks a floor value inputted by the user in a separate field and returns the room_id value for that specific floor.&nbsp;<BR /><BR /></P><DIV><DIV><SPAN>// Check the value of the room level field: values are "base" "lowr" "uppr" "pent" "mezz"</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>roomlevel</SPAN><SPAN> = </SPAN><SPAN>$feature</SPAN><SPAN>.</SPAN><SPAN>Room_Level</SPAN></DIV><BR /><DIV><SPAN>// Create a feature set using the 'Basement' layer in the map</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>based</SPAN><SPAN> = </SPAN><SPAN>FeatureSetByName</SPAN><SPAN>(</SPAN><SPAN>$map</SPAN><SPAN>, </SPAN><SPAN>"BORG_Basement_Level"</SPAN><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>// Intersect the current location with the the level and </SPAN></DIV><DIV><SPAN>// get the first intersecting room</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>base1</SPAN><SPAN> = </SPAN><SPAN>First</SPAN><SPAN>(</SPAN><SPAN>Intersects</SPAN><SPAN>(</SPAN><SPAN>$feature</SPAN><SPAN>, </SPAN><SPAN>based</SPAN><SPAN>))</SPAN></DIV><BR /><DIV><SPAN>// Create a feature set using the 'Lower' layer in the map</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>lowerd</SPAN><SPAN> = </SPAN><SPAN>FeatureSetByName</SPAN><SPAN>(</SPAN><SPAN>$map</SPAN><SPAN>, </SPAN><SPAN>"BORG_LowerLevel"</SPAN><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>// Intersect the current location with the the level and </SPAN></DIV><DIV><SPAN>// get the first intersecting room</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>lower1</SPAN><SPAN> = </SPAN><SPAN>First</SPAN><SPAN>(</SPAN><SPAN>Intersects</SPAN><SPAN>(</SPAN><SPAN>$feature</SPAN><SPAN>, </SPAN><SPAN>lowerd</SPAN><SPAN>))</SPAN></DIV><BR /><DIV><SPAN>// Create a feature set using the 'Upper' layer in the map</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>upperd</SPAN><SPAN> = </SPAN><SPAN>FeatureSetByName</SPAN><SPAN>(</SPAN><SPAN>$map</SPAN><SPAN>, </SPAN><SPAN>"BORG_UpperLevel"</SPAN><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>// Intersect the current location with the the level and </SPAN></DIV><DIV><SPAN>// get the first intersecting room</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>upper1</SPAN><SPAN> = </SPAN><SPAN>First</SPAN><SPAN>(</SPAN><SPAN>Intersects</SPAN><SPAN>(</SPAN><SPAN>$feature</SPAN><SPAN>, </SPAN><SPAN>upperd</SPAN><SPAN>))</SPAN></DIV><BR /><DIV><SPAN>// Create a feature set using the 'Penthouse' layer in the map</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>pentd</SPAN><SPAN> = </SPAN><SPAN>FeatureSetByName</SPAN><SPAN>(</SPAN><SPAN>$map</SPAN><SPAN>, </SPAN><SPAN>"BORG_Penthouse"</SPAN><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>// Intersect the current location with the the level and </SPAN></DIV><DIV><SPAN>// get the first intersecting room</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>pent1</SPAN><SPAN> = </SPAN><SPAN>First</SPAN><SPAN>(</SPAN><SPAN>Intersects</SPAN><SPAN>(</SPAN><SPAN>$feature</SPAN><SPAN>, </SPAN><SPAN>pentd</SPAN><SPAN>))</SPAN></DIV><BR /><DIV><SPAN>// Create a feature set using the 'Mezzanine' layer in the map</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>mezzd</SPAN><SPAN> = </SPAN><SPAN>FeatureSetByName</SPAN><SPAN>(</SPAN><SPAN>$map</SPAN><SPAN>, </SPAN><SPAN>"BORG_Mezzanine"</SPAN><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>// Intersect the current location with the the level and </SPAN></DIV><DIV><SPAN>// get the first intersecting room</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>mezz1</SPAN><SPAN> = </SPAN><SPAN>First</SPAN><SPAN>(</SPAN><SPAN>Intersects</SPAN><SPAN>(</SPAN><SPAN>$feature</SPAN><SPAN>, </SPAN><SPAN>mezzd</SPAN><SPAN>))</SPAN></DIV><BR /><DIV><SPAN>// If the current location does intersect a feature, </SPAN></DIV><DIV><SPAN>// return the name of the region. Otherwise, return null</SPAN></DIV><BR /><DIV><SPAN>return</SPAN> <SPAN>When</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; </SPAN><SPAN>roomlevel</SPAN><SPAN> == </SPAN><SPAN>"base"</SPAN><SPAN>, </SPAN><SPAN>base1</SPAN><SPAN>[</SPAN><SPAN>'room_id'</SPAN><SPAN>],</SPAN></DIV><DIV><SPAN>&nbsp; </SPAN><SPAN>roomlevel</SPAN><SPAN> == </SPAN><SPAN>"lowr"</SPAN><SPAN>, </SPAN><SPAN>lower1</SPAN><SPAN>[</SPAN><SPAN>'room_id'</SPAN><SPAN>],</SPAN></DIV><DIV><SPAN>&nbsp; </SPAN><SPAN>roomlevel</SPAN><SPAN> == </SPAN><SPAN>"uppr"</SPAN><SPAN>, </SPAN><SPAN>upper1</SPAN><SPAN>[</SPAN><SPAN>'room_id'</SPAN><SPAN>],</SPAN></DIV><DIV><SPAN>&nbsp; </SPAN><SPAN>roomlevel</SPAN><SPAN> == </SPAN><SPAN>"pent"</SPAN><SPAN>, </SPAN><SPAN>pent1</SPAN><SPAN>[</SPAN><SPAN>'room_id'</SPAN><SPAN>],</SPAN></DIV><DIV><SPAN>&nbsp; </SPAN><SPAN>roomlevel</SPAN><SPAN> == </SPAN><SPAN>"mezz"</SPAN><SPAN>, </SPAN><SPAN>mezz1</SPAN><SPAN>[</SPAN><SPAN>'room_id'</SPAN><SPAN>]</SPAN></DIV><DIV><SPAN>)<BR /><BR /></SPAN>The final part of the script is where I'm having the most trouble, I don't know how to format the script to output the desired value reliably. Right now can only make it return the basement value.<BR /><BR />Thanks!</DIV></DIV> Thu, 20 Jun 2024 16:11:18 GMT jmcdonald_sdi 2024-06-20T16:11:18Z https://community.esri.com/t5/arcgis-online-questions/arcade-script-to-pull-a-intersect-value-from/m-p/1495472#M59800 <P>Hey AGOL Blog,<BR /><BR />I have 5 overlapping/stacked floor layers that each have a room_id attribute. I'm trying to run a script that checks a floor value inputted by the user in a separate field and returns the room_id value for that specific floor.&nbsp;<BR /><BR /></P><DIV><DIV><SPAN>// Check the value of the room level field: values are "base" "lowr" "uppr" "pent" "mezz"</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>roomlevel</SPAN><SPAN> = </SPAN><SPAN>$feature</SPAN><SPAN>.</SPAN><SPAN>Room_Level</SPAN></DIV><BR /><DIV><SPAN>// Create a feature set using the 'Basement' layer in the map</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>based</SPAN><SPAN> = </SPAN><SPAN>FeatureSetByName</SPAN><SPAN>(</SPAN><SPAN>$map</SPAN><SPAN>, </SPAN><SPAN>"BORG_Basement_Level"</SPAN><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>// Intersect the current location with the the level and </SPAN></DIV><DIV><SPAN>// get the first intersecting room</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>base1</SPAN><SPAN> = </SPAN><SPAN>First</SPAN><SPAN>(</SPAN><SPAN>Intersects</SPAN><SPAN>(</SPAN><SPAN>$feature</SPAN><SPAN>, </SPAN><SPAN>based</SPAN><SPAN>))</SPAN></DIV><BR /><DIV><SPAN>// Create a feature set using the 'Lower' layer in the map</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>lowerd</SPAN><SPAN> = </SPAN><SPAN>FeatureSetByName</SPAN><SPAN>(</SPAN><SPAN>$map</SPAN><SPAN>, </SPAN><SPAN>"BORG_LowerLevel"</SPAN><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>// Intersect the current location with the the level and </SPAN></DIV><DIV><SPAN>// get the first intersecting room</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>lower1</SPAN><SPAN> = </SPAN><SPAN>First</SPAN><SPAN>(</SPAN><SPAN>Intersects</SPAN><SPAN>(</SPAN><SPAN>$feature</SPAN><SPAN>, </SPAN><SPAN>lowerd</SPAN><SPAN>))</SPAN></DIV><BR /><DIV><SPAN>// Create a feature set using the 'Upper' layer in the map</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>upperd</SPAN><SPAN> = </SPAN><SPAN>FeatureSetByName</SPAN><SPAN>(</SPAN><SPAN>$map</SPAN><SPAN>, </SPAN><SPAN>"BORG_UpperLevel"</SPAN><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>// Intersect the current location with the the level and </SPAN></DIV><DIV><SPAN>// get the first intersecting room</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>upper1</SPAN><SPAN> = </SPAN><SPAN>First</SPAN><SPAN>(</SPAN><SPAN>Intersects</SPAN><SPAN>(</SPAN><SPAN>$feature</SPAN><SPAN>, </SPAN><SPAN>upperd</SPAN><SPAN>))</SPAN></DIV><BR /><DIV><SPAN>// Create a feature set using the 'Penthouse' layer in the map</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>pentd</SPAN><SPAN> = </SPAN><SPAN>FeatureSetByName</SPAN><SPAN>(</SPAN><SPAN>$map</SPAN><SPAN>, </SPAN><SPAN>"BORG_Penthouse"</SPAN><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>// Intersect the current location with the the level and </SPAN></DIV><DIV><SPAN>// get the first intersecting room</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>pent1</SPAN><SPAN> = </SPAN><SPAN>First</SPAN><SPAN>(</SPAN><SPAN>Intersects</SPAN><SPAN>(</SPAN><SPAN>$feature</SPAN><SPAN>, </SPAN><SPAN>pentd</SPAN><SPAN>))</SPAN></DIV><BR /><DIV><SPAN>// Create a feature set using the 'Mezzanine' layer in the map</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>mezzd</SPAN><SPAN> = </SPAN><SPAN>FeatureSetByName</SPAN><SPAN>(</SPAN><SPAN>$map</SPAN><SPAN>, </SPAN><SPAN>"BORG_Mezzanine"</SPAN><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>// Intersect the current location with the the level and </SPAN></DIV><DIV><SPAN>// get the first intersecting room</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>mezz1</SPAN><SPAN> = </SPAN><SPAN>First</SPAN><SPAN>(</SPAN><SPAN>Intersects</SPAN><SPAN>(</SPAN><SPAN>$feature</SPAN><SPAN>, </SPAN><SPAN>mezzd</SPAN><SPAN>))</SPAN></DIV><BR /><DIV><SPAN>// If the current location does intersect a feature, </SPAN></DIV><DIV><SPAN>// return the name of the region. Otherwise, return null</SPAN></DIV><BR /><DIV><SPAN>return</SPAN> <SPAN>When</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; </SPAN><SPAN>roomlevel</SPAN><SPAN> == </SPAN><SPAN>"base"</SPAN><SPAN>, </SPAN><SPAN>base1</SPAN><SPAN>[</SPAN><SPAN>'room_id'</SPAN><SPAN>],</SPAN></DIV><DIV><SPAN>&nbsp; </SPAN><SPAN>roomlevel</SPAN><SPAN> == </SPAN><SPAN>"lowr"</SPAN><SPAN>, </SPAN><SPAN>lower1</SPAN><SPAN>[</SPAN><SPAN>'room_id'</SPAN><SPAN>],</SPAN></DIV><DIV><SPAN>&nbsp; </SPAN><SPAN>roomlevel</SPAN><SPAN> == </SPAN><SPAN>"uppr"</SPAN><SPAN>, </SPAN><SPAN>upper1</SPAN><SPAN>[</SPAN><SPAN>'room_id'</SPAN><SPAN>],</SPAN></DIV><DIV><SPAN>&nbsp; </SPAN><SPAN>roomlevel</SPAN><SPAN> == </SPAN><SPAN>"pent"</SPAN><SPAN>, </SPAN><SPAN>pent1</SPAN><SPAN>[</SPAN><SPAN>'room_id'</SPAN><SPAN>],</SPAN></DIV><DIV><SPAN>&nbsp; </SPAN><SPAN>roomlevel</SPAN><SPAN> == </SPAN><SPAN>"mezz"</SPAN><SPAN>, </SPAN><SPAN>mezz1</SPAN><SPAN>[</SPAN><SPAN>'room_id'</SPAN><SPAN>]</SPAN></DIV><DIV><SPAN>)<BR /><BR /></SPAN>The final part of the script is where I'm having the most trouble, I don't know how to format the script to output the desired value reliably. Right now can only make it return the basement value.<BR /><BR />Thanks!</DIV></DIV> Thu, 20 Jun 2024 16:11:18 GMT https://community.esri.com/t5/arcgis-online-questions/arcade-script-to-pull-a-intersect-value-from/m-p/1495472#M59800 jmcdonald_sdi 2024-06-20T16:11:18Z https://community.esri.com/t5/arcgis-online-questions/arcade-script-to-pull-a-intersect-value-from/m-p/1495589#M59809 <P>Since you know which floor the feature is on, why run all the intersections? Just run it once according to the floor.</P><LI-CODE lang="javascript">// Check the value of the room level field: values are "base" "lowr" "uppr" "pent" "mezz" var roomlevel = $feature.Room_Level var floor = Decode(roomlevel, "base", "BORG_Basement_Level", "lowr", "BORG_LowerLevel", "uppr", "BORG_UpperLevel", "pent", "BORG_Penthouse", "mezz", "BORG_Mezzanine") var fs = FeatureSetByName($map, floor) // Intersect the current location with the the level and // get the first intersecting room var location = First(Intersects($feature, fs)); iif(IsEmpty(location), null, location['room_id'])</LI-CODE> Thu, 20 Jun 2024 19:02:42 GMT https://community.esri.com/t5/arcgis-online-questions/arcade-script-to-pull-a-intersect-value-from/m-p/1495589#M59809 KenBuja 2024-06-20T19:02:42Z