# List the pipes within a room / space **URL:** \ **Category:** Revit\ **Tags:** revit, dynamo, rooms\ **Created:** [December 21, 2021, 3:31pm UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608 "2021-12-21T15:31:46Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![L\_VDV](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/l_vdv/32/129866_2.png) [@L\_VDV](https://forum.dynamobim.com/u/L_VDV)\ **Post date:** [December 21, 2021, 3:31pm UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/1 "2021-12-21T15:31:46Z")
Hello I am fairly new to Dynamo but I would like to list the pipes in a Room or Space. I get a list of the spaces, pipe size and lengths but this is not quite correct. **REVIT** ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/b/bb5bb155126cc3d20ccd72600456afde43491ec5.png) **Dynamo** ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/2/323c6f0ec8ae645e3e1317f60dc2c10a65f1a137.png) **Excel** (Left = export, Right is what i need) ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/0/b0d7113e57b1f823c701e4453dec8e36aed2dda5.png) ---
**Author:** ![Elie.Trad](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/elie.trad/32/110373_2.png) [@Elie.Trad](https://forum.dynamobim.com/u/Elie.Trad)\ **Post date:** [December 21, 2021, 4:51pm UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/4 "2021-12-21T16:51:40Z")
Hi @L_VDV and welcome, you need to match the number of space names as per the respective intersecting pipes, hope this helps: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/1/019277618bea0c75d411bb6f36250f88e054ce19.png) ---
**Author:** ![L\_VDV](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/l_vdv/32/129866_2.png) [@L\_VDV](https://forum.dynamobim.com/u/L_VDV)\ **Post date:** [December 22, 2021, 7:48am UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/5 "2021-12-22T07:48:11Z")
Great, @tradelie thx! Part 1 worked, but I’m still struggling with the pipe size… Do you have any idea how I can solve this? **DYNAMO** ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/a/bae7c777e682d80d2849a26188de63bc316c0392.png) **EXCEL** ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/3/3398845bf463e89a2679c3d878fc35c96fd18d85.png) ---
**Author:** ![Elie.Trad](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/elie.trad/32/110373_2.png) [@Elie.Trad](https://forum.dynamobim.com/u/Elie.Trad)\ **Post date:** [December 22, 2021, 11:45am UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/6 "2021-12-22T11:45:42Z")
@L_VDV all I can think of is swapping the intersecting geometries to get the sizes of the respective pipes, hope it works for you: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/f/0f92ac094c0efcaf8a93f708015a71878fb5cce9.png) ---
**Author:** ![L\_VDV](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/l_vdv/32/129866_2.png) [@L\_VDV](https://forum.dynamobim.com/u/L_VDV)\ **Post date:** [December 23, 2021, 8:21am UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/7 "2021-12-23T08:21:49Z")
@Elie.Trad thanks again to reply! The solution is not correct, at least not with me… Do your lengths and sizes match? **REVIT** ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/b/abb303ecd95695d0467541c6454e8b7798a78804.png) **DYNAMO** ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/f/7f429240ca8f2fcd27cbdd30fa21bc2cc017473d.png) **EXCEL** ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/1/81d03fd88417a3f5e5931f1a7a2fb6fa9abc5542.png) ---
**Author:** ![L\_VDV](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/l_vdv/32/129866_2.png) [@L\_VDV](https://forum.dynamobim.com/u/L_VDV)\ **Post date:** [December 23, 2021, 9:29am UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/8 "2021-12-23T09:29:51Z")
What I just noticed: the “List.Flatten” a “List.Of Repeated Item” match, the sorting is different from the length. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/7/b77d2614c9093ae9b9c7aecb804fd3d1addf375d.png) ---
**Author:** ![Elie.Trad](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/elie.trad/32/110373_2.png) [@Elie.Trad](https://forum.dynamobim.com/u/Elie.Trad)\ **Post date:** [December 23, 2021, 11:58am UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/9 "2021-12-23T11:58:11Z")
@L_VDV Ah that is true, the thing is in the second intersection node, intersection results are coming out as per the intersecting pipes, so for ex., the 50 mm pipe is intersecting with (2) spaces, so on and so forth, without any reference to the intersected space, if I come up with a solution to it I will let you know ---
**Author:** ![L\_VDV](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/l_vdv/32/129866_2.png) [@L\_VDV](https://forum.dynamobim.com/u/L_VDV)\ **Post date:** [December 23, 2021, 12:08pm UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/10 "2021-12-23T12:08:19Z")
@Elie.Trad, what do you think of this option: Is it possible to pass the element ID to the pipes intersections? After this we can add the size back in an extra column based on the element ID? ---
**Author:** ![Elie.Trad](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/elie.trad/32/110373_2.png) [@Elie.Trad](https://forum.dynamobim.com/u/Elie.Trad)\ **Post date:** [December 23, 2021, 1:32pm UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/11 "2021-12-23T13:32:06Z")
@L_VDV check this out, it is a bit messy, maybe someone else can think of lesser nodes, hope it works for you: ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/c/fc2a27282db7f55fdc3bb65d55d711b3e0f8e578.png) [pipes.dyn](https://forum.dynamobim.com/uploads/short-url/tiIyPidfV0q9HsHzyN8SNycqBPr.dyn) (55.6 KB) ---
**Author:** ![L\_VDV](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/l_vdv/32/129866_2.png) [@L\_VDV](https://forum.dynamobim.com/u/L_VDV)\ **Post date:** [January 10, 2022, 8:38am UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/13 "2022-01-10T08:38:07Z")
hello @Elie.Trad My best wishes for 2022. I was on vacation. This seems to work for me, also for ducts! Super! ---
**Author:** ![L\_VDV](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/l_vdv/32/129866_2.png) [@L\_VDV](https://forum.dynamobim.com/u/L_VDV)\ **Post date:** [January 11, 2022, 12:17pm UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/14 "2022-01-11T12:17:09Z")
@Elie.Trad Today we used the script. When you have a project with several levels it no longer works. It also no longer works with spaces that extend over different floors (technical shaft). I’m trying to find a solution but so far I haven’t found it… I’m trying to work with this node: [All Pipes at Reference Level – Dynamo Nodes](https://dynamonodes.com/2017/11/01/all-pipes-at-reference-level/) **LVL00** ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/3/2390e70efab028c4421ea4a13e304e1287ab1677.png) **LVL01** ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/e/de968c10f5110e6dd37cf659d9b84c45f1113362.png) **EXCEL** ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/2/92ce28c7891161bed270264a4e53555a3b06356d.png) ---
**Author:** ![Elie.Trad](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/elie.trad/32/110373_2.png) [@Elie.Trad](https://forum.dynamobim.com/u/Elie.Trad)\ **Post date:** [January 11, 2022, 12:47pm UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/15 "2022-01-11T12:47:06Z")
@L_VDV Try to group your spaces by level as well, make sure that your spaces list by level is in order as same as your pipes list by level, before executing the rest of the script; For the shafts, I think it will be easier since it will be one space with the inclusive pipes sorted by ascending levels ---
**Author:** ![L\_VDV](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/l_vdv/32/129866_2.png) [@L\_VDV](https://forum.dynamobim.com/u/L_VDV)\ **Post date:** [January 12, 2022, 9:42am UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/16 "2022-01-12T09:42:43Z")
@Elie.Trad This part succeeded. We have chosen to generate per level. This to limit the heaviness of the script. What I notice is that the shafts name only is taken on the level where the space starts. Example: “schacht 1” starts at lvl00, this works correctly. The pipes on lvl01 inside “schacht 1” don’t get the name “schacht 1”. Space “schacht 1” goes from lvl00 to lvl02. **Dynamo** ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/7/0749450d1f02491f9af9a0d64be21ef80667b5f7.png) **Excel** lvl00 =\> OK ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/b/bbe9b8b2a6211d07314eb32fb49885c8acabac2f.png) lvl01 =\> “schacht 1” is missing ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/1/81f75beec0fc3be34e4543a1b2d83147cbc4089c.png) ---
**Author:** ![Elie.Trad](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/elie.trad/32/110373_2.png) [@Elie.Trad](https://forum.dynamobim.com/u/Elie.Trad)\ **Post date:** [January 12, 2022, 10:30am UTC](https://forum.dynamobim.com/t/list-the-pipes-within-a-room-space/71608/17 "2022-01-12T10:30:32Z")
@L_VDV Try to repeat the shaft space by the count of the levels, as same as the first iteration in this post, this way you will get enough “shaft” elements for the inclusive pipes.