Whilst there are many tools on the market to renumber piles and provide a pile marking scheme, many of these tools rely on the piles being nested into pile caps. This is useful for most of the piles it will not cover situations where piling is incorporated into ground beams or foundation slabs. Many of the standard numbering tools will also not group the piles and number clockwise. Most of the industry will want to number the piles as shown in the image below.
My new approach to this problem is to first collect all the piling in Dynamo, then collect the foundations and framing that the piling is placed into. I then intersect the geometry and group the piles by the hosting elements. Although I am referring to hosted elements, the piling is a combination of pile and pile caps, single piles placed into foundation slabs and piles placed into ground beams. The below image shows the piling intersecting with the foundation elements.
Here you can see a small section of the project with the piling marked. The blue geometry is generated by Dynamo. These are the foundation slabs, pile caps and ground beams.
Anyway, there is far too much to explain in this blog post so take a look at the YouTube video to see the script in action. I also run through the Dynamo graph and explain each section and the logic of how it works.
Hope this has been useful
LawrenceH
Autodesk Revit Structure 
Hi, and thanks for sharing. Could you add the Dynamo script?
thanks in advanced
Hi Lawrence
Any chance you could provide a download of the dynamo file, please?
Hi Andy, Unfortunately, with the free version of WordPress I can only upload PDFs
Hi, can you share the dynamo scripts? I am stuck in a project and don’t have any idea how to extract the information. Thanks. my email in the post
Hi Lawrence, can you get my email address from the comment? If so, any chance you could email it to me? I’ve created the dynamo routine from the video but it isn’t working and I can’t work out why. It would be good to rule out an error in my input by having the original file.
Ill send it over shortly
Hi Lawrence, I’ve just started out with dynamo and I’ve tried following along with your tutorial but I’ve messed up somewhere and I can’t for the life of me work out where. Any help would be greatly appreciated, perhaps I could email you my script to look over or maybe if you’re feeling generous you could email me yours so I can compare. Cheers Lawrence, keep up the good work with the excellent Blog
Hi Nick, Glad you have taken a look at Dynamo, you’ll love it once you get into the workflow. Send me your script and I will give you some pointers. My mail is lawrence.hooker@symetri.com