Automating Pre-Fabricated Vertical Drain arrangement

Hi. We are currently working on a waste management facility and part of it is to spread out an array of vertical drain pipes throughout a reclamation area. This will consists of thousands of pipes due to the enormity of the site. The idea is to have the top elevation within the sand area (topography) and bottom elevation +500mm below alluvium level (topography). Is there any available script that we can utilize so as to avoid modelling it one by one. I hope you got the idea. Please see attached images:

We hope we can find a better solution. I know dynamo is more than capable of doing this.