Hi all. I am trying to create a borehole inclined line, but I just could create a vertical line using the fields X, Y, From, To fields. I would like to create a no vertical (the line inclined with angle). I have other fields (Azimuth, Dip, Z, Depth), but I don't know the calc for it.
Below. The piece of code. It is working well and it can create a vertical line. But I am not sure how can I create a no vertical line
Set pPointCollection = New Polyline Dim pzawarePC As IZAware Set pzawarePC = pPointCollection pzawarePC.ZAware = True ' get first coordinate and store pPoint.x = pRow.Value([XField]) pPoint.y = pRow.Value([YField]) Dim pZAware As IZAware Set pZAware = pPoint pZAware.ZAware = True pPoint.Z = pRow.Value([TopField]) pPointCollection.AddPoint pPoint ' get second coordinate and store pPoint.x = pRow.Value([XField]) + 0.00001 pPoint.y = pRow.Value([YField]) Set pZAware = pPoint pZAware.ZAware = True
pPoint.Z = pRow.Value([BottonField]) pPointCollection.AddPoint pPoint ' store the pointcolletion in the featurebuffer Set pFeature.Shape = pPointCollection
Fields that I am not using from my shape (Z, Depth, Dip, Azimut)
Below the printscreen about two lines. The vertical line was created using the calc above. The second line was created using the ArcHydro tool.
thanks Evans. I have tried resize that number. But it did not work well. I believe that for each segment and borehole there is the inclination. I think that it is calculated using the delph, dip and azimuth.
Crisjovano, Sorry! I misunderstood your first post.
What I would do is first create a single directional borehole line, turn it into a route, and then locate the borehole intervals along its length.
This is what I did recently for this very exercise using available tools.
1) Your X, Y, Z, azimuth, dip, and depth values are the same for every borehole, so normalize your intervals table into a table where each row is a different borehole. Then create two new fields, 'horizontal' and 'vertical' for instance. The horizontal value is going to be the length of the line in 2d as if you were looking down on the line in plan view. The vertical value is going to be the distance down from the plan view horizon to the bottom of the borehole. Horizontal = cos(dip) * depth and Vertical = sin(dip) * depth.
2) Create 2d lines using the 'Bearing Distance to Line' tool in Data Management. Use the X, Y, azimuth, and HORIZONTAL (not depth) fields.
3) Put these lines in a Z-aware feature class and enter the borehole collar elevation ('Z') and borehole bottom elevation ('Z' - 'vertical') for each line.
4) Turn these lines into routes using the Create Routes tool. Take care with the coordinate priority so that your boreholes get measured from top to bottom and use the 'ONE FIELD' parameter for the measure source and set From-Measure Field to the depth value.
5) Use the Locate Features Along Routes tool to place the borehole intervals along the measured borehole lines.
If you need to automate this, I would recommend python over ArcObjects