The XYZ functionality allows any down hole data stored in OpenGround Cloud to be rep-resented in the drawing either by a point group or a surface by means of a wizard interface. The information can either be displayed at the correct Z value down hole At Elevation or use the actual value of the data as the Z coordinate At Value.
XYZ Point Group of "N Values below 30"
XYZ Point Group
Connect: HBSI_CreatePointGroup
From the OpenGround Cloud ribbon click Point Group to display the XYZ Point Group Wizard.
The XYZ Point Group Wizard has four steps.
Step One: Select Source Data
This step is used to select the table of data in OpenGround Cloud to create the point group on.
- Grouping: At the top of the wizard page is the Grouping Pick List, the default selection is All Data, the pick list will itemise all groups defined in the project and individual boreholes. Select the group or borehole to limit the XYZ Point Group to.
- Project Explorer: The Project Explorer lists all of the data tables within the project, the greyed out rows indicate there are no entries for that data table in the project
- From the Project Explorer select the data table to create the XYZ Point Group on.
- Search Project Explorer: enter a value to find the matching data tables
- Next: Press Next to proceed to the next step in the wizard.
Step Two: Select Data Filters
Step two of the wizard displays the selected data in a standard OpenGround Cloud grid. The standard grid filters can be used to only select the data required. For instance you may not be interested in N value metres in the top 3 m of a hole.
Use the Filter tool in the column headings to filter the data so only the matching records are dis-played.
- Next: Press Next to proceed to the next step in the wizard.
Step Three: Set Location Details
Step three of the wizard is used to specify the locations at where the point group should be created.
- Name: Enter the name for the XYZ Point Group.
- Location: From the pick list select either Easting, Northing or Latitude, Longitude to specify the X and Y coordinates for the location
- At Elevation: If the point should be plotted at the elevation down the hole, pick the depth related data field from the pick list. Note: only the depth data fields are listed.
- At Value: Uses the value of the selected data field for the plotted point of the Z coordinate. For instance, if using N Values from a standard penetration test results table, if N value is 30 then the point will be plotted with the Z coordinate as 30. Note: all numeric data fields are listed.
- Next: Press Next to proceed to the next step in the wizard.
Step Four: Set Additional Values
Step four of the wizard is used to add labels to the points. Additional down hole data related to the plotted value can be added to the point
- Add: Press Add to append an additional label to the point, from the newly created pick list in the grid above select the desired label to add to the point. This process can be repeated mul-tiple times
- Remove: Select a label row from the grid above and click Remove to erase it from the labels to be created.
- Finish: Press Finish to create the XYZ point group. XYZ point groups use standard AutoCAD Civil 3D point groups, the point groups can be edited and styled in the normal way. The point group data will be refreshed with the latest data when the Geotechnical Extension Update command is used.
The point groups are created using the KNX_Geotechnical Point style for the point marker. A point label style is created for each XYZ point group having the name KNX_<XYZ point group name>.