I need to model a terrain topography from the elevations in a .csv file. The .csv contains a 1000 by 1000 array of elevations of points at 1.0m plan spacings (i.e., a million points).
The point coordinates are defined in relation to the lower-left corner, so to obtain the x/y plan coordinates I had to define two sequences. To get a column array of the z elevations I used Excel.ReadFromFile and then Flatten. At this point I now have 3 separate lists with x, y and z defined.
I then used Point.ByCoordinates to create my terrain points and Topography.ByPoints to generate the topo surface. In parallel I also used List.Create to combine x, y and z into a new list which I can export to a .csv .
Altough the graph I put together worked and I was able to generate the points it took a considerable amount of time! As for the topo surface, I pretty much gave up after 4 hours running time… Was this to be expected given the number of points I am using?
Bearing in mind that I have also generated a .csv with all the point coordinates would it be preferable to import this file to Civil3D and generate a TIN surface instead of trying to use Revit?
Can anyone give a few tips/pointers on how to speed up the process? Any help would be much appreciated.