Wastewater Profiles.pdf
Wastewater Profiles
© 2010 Autodesk, Inc. All rights reserved. NOT FOR DISTRIBUTION. The contents of this guide were created for Autodesk® Topobase™ 2011. The contents of this guide are not intended for other versions of Autodesk® Topobase™.
Country Kit Workshop
Wastewater Profiles - ii
TABLE OF CONTENTS Table of Contents.................................................................................................................................... 1 Profiles.................................................................................................................................................... 2 Configuration....................................................................................................................................... 2 System Tables .................................................................................................................................. 2 Data Model...................................................................................................................................... 3 Main tables...................................................................................................................................... 4 Adding tables................................................................................................................................... 5 Adding static labels .......................................................................................................................... 6 Display model .................................................................................................................................. 7 Steps to create a profile definition ....................................................................................................... 8 Step 1. General settings .................................................................................................................. 9 Step 2. Point feature classes .......................................................................................................... 10 Step 3. Line feature classes ............................................................................................................ 11 Step 4. Vertical lines ...................................................................................................................... 13 Step 5. Attributes........................................................................................................................... 14 Step 6. Create frame ...................................................................................................................... 15 Step 7. Create axes and grid lines................................................................................................... 18 Step 8. Create tic marks and labels ................................................................................................ 20 Step 9. Create labels ...................................................................................................................... 23 Step 10. Static Text ........................................................................................................................ 24 Creating a profile ............................................................................................................................... 26 Getting started .............................................................................................................................. 26 Profile Settings .............................................................................................................................. 28 Feature and Axis Selection ............................................................................................................. 29 Drawing Profile .............................................................................................................................. 32
Country Kit Workshop
Wastewater Profiles - 1
PROFILES Configuration System Tables These are the system tables that store the definition of the profile: Table
Description
TB_PROFILE
Point feature class to store the origin of a profile. It stores the general settings of the profile.
TB_PROFILE_AXIS
Line string feature class to store the axis of the profile.
TB_PROFILE_DEFINITION
To store the profile definition.
TB_PROFILE_DETAIL
To store profile details. It is related to the TB_PROFILE_DEFINITION table by the FID of the profile. This table stores the exact configuration of the profile, the border lines, the grid detail at the bottom, the legend, the position of the features relative to the origin, and so on.
TB_PROFILE_SUB_DETAIL
To store profile sub details such as offsets of labels. These records are related to those in the TB_PROFILE_DETAIL by the FID.
Country Kit Workshop
Wastewater Profiles - 2
Data Model The results of the profile are stored in the database. Once a profile is generated, a set of features (points, lines, polygons, and labels) are created in the corresponding feature classes of the Profile topic. The figure below shows the feature classes that could be part of the profile:
If not provided, the feature classes have to be created manually.
Country Kit Workshop
Wastewater Profiles - 3
Main tables The main tables for the profile features are:
The line defined for the profile (WW_LINE_PRO), which represents the section. The attribute FID_PARENT has to be related to the WW_LINE feature class. The attribute FID_PROFILE has to be related to TB_PROFILE
The WW_LINE_PRO feature class has a label feature class and as many label definitions as labels will be represented in the profile. In this case it has three label definitions to show the name, length and slope of the section.
Verify the properties of the label definition Line Pro Length Label, if you enable the Automatically create label when feature is created, then the label will be created automatically when the profile line is created. Otherwise you can show the label using the Profile Designer (See Step 9. Create Labels)
Country Kit Workshop
Wastewater Profiles - 4
The SQL statement of the label definition gets the properties of the section following the syntax below: select round(c.PIPE_LENGTH,2) from WW_LINE_PRO a, WW_LINE b, WW_SECTION c where a.FID = $id and a.fid_parent = b.fid and b.fid_attr = c.fid
The point defined for the profile (WW_POINT_PRO) represents the network points. In the same way as with the line, the attribute FID_PARENT has to be related to the WW_POINT feature class. The attribute FID_PROFILE has to be related to TB_PROFILE
The WW_POINT_PRO feature class has a label feature class and as many label definitions as labels will be represented in the profile. In this case it has two label definitions to show the name, and height of the point.
Adding tables If you need to add new feature classes to be represented in the profile, e.g. decoration feature classes to store the axis, static texts, title and so on; you have to make sure that the new feature class has an attribute FID_PROFILE related to the TB_PROFILE.FID. For example, create line feature class WW_PROFILE_LINE_REP_PRO, you will use this feature class to create the tic marks for the axes.
Add attributes: FID_PROFILE - NUMBER(10) related to TB_PROFILE LINESTYLE – NUMBER(10) – This attribute can serve to assign different line styles to use in the display manager.
Country Kit Workshop
Wastewater Profiles - 5
Note that in this data model there is a point feature class (WW_PROFILE_POINT_REP_PRO) with a label definition to generate the labels for the tic marks. Note that the feature class has an attribute DISTANCE_FROM_ORIGIN, this will store the position of the tic mark that is generated automatically.
The label definition has these settings: Label definition name Distance from origin
SQL select DISTANCE_FROM_ORIGIN from WW_PROFILE_POINT_REP_PRO where FID = $id
Orientation Absolute, 0 degrees
Adding static labels Create a label feature class WW_PRO_STATIC_TEXT_TBL for the WW_PROFILE_STATIC_TEXT point feature class. Create a label definition: Label definition name Static Text Height
SQL Select 'Height' from dual
Orientation Absolute, 0 degrees
This label will display the text ‘Height’ in the profile.
Country Kit Workshop
Wastewater Profiles - 6
Display model In order to see the profile you have to create a display model that includes all the profile feature classes.
Country Kit Workshop
Wastewater Profiles - 7
Steps to create a profile definition The following steps explain how to create a simple profile with the information shown in the figure below.
Country Kit Workshop
Wastewater Profiles - 8
Step 1. General settings Define profile general settings
Country Kit Workshop
Wastewater Profiles - 9
Step 2. Point feature classes Define point feature classes that will be part of the profile: Manhole
Detail Title = Description of the detail Main feature class= WW_POINT (the feature class where the geometries are stored) Profile feature class=WW_POINT_PRO (the feature class where the point geometry features for the profiles will be stored)
Define where clause according to the type of feature class: f.f_class_id_attr in ( select f_class_id from tb_dictionary where upper(rtrim(f_class_name)) like 'WW_MANHOLE')
You can create as many profile features as types of points you have.
Country Kit Workshop
Wastewater Profiles - 10
Step 3. Line feature classes Define line feature classes that will be part of the profile: Section
Detail Title = Description of the detail Main feature class= WW_LINE (the feature class where the geometries are stored) Profile feature class=WW_LINE_PRO (the feature class where the point geometry features for the profiles will be stored)
The select Statement for the section filters the coordinates of the points that are topologically connected with the section. The select gets the X, Y coordinates plus the Z value.
Country Kit Workshop
Wastewater Profiles - 11
select g.fid FID, g.geom.sdo_point.x EASTING, g.geom.sdo_point.y NORTHING, g.Z HEIGHT from ww_line a, ww_conn b, ww_section f, ww_point g where ((a.fid = b.fid_from and g.fid = b.fid_to) or (a.fid = b.fid_to and g.fid = b.fid_from)) and a.fid_attr = f.fid and a.fid=$FID
Country Kit Workshop
Wastewater Profiles - 12
Step 4. Vertical lines Define the vertical lines that will connect to the manholes
Select Detail Title Manhole, under vertical lines set these values:
Feature class = select WW_PROFILE_LINE_PRO Offset = 10
Country Kit Workshop
Wastewater Profiles - 13
Step 5. Attributes You can set values to some attributes of the profile features (WW_POINT_PRO, WW_LINE_PRO) for stylization.
Select Detail Title Manhole, under Feature Class Attributes set these values:
Attribute = select FEATURE_TYPE Value = Manhole
This means that the attribute FEATURE_TYPE of the table WW_POINT_PRO will be set to ‘Manhole’. You can use this setting to stylize the feature class WW_POINT_PRO in the display manager.
Country Kit Workshop
Wastewater Profiles - 14
Step 6. Create frame In order to create a frame for the profile you need to define the width and height of it given that the profile will be drawn in the origin (0,0). The example below shows some values for the frame.
Country Kit Workshop
Wastewater Profiles - 15
a) Create left frame, in the Decoration tab: Enter the Detail Title = Frame Left and select WW_PROFILE_LINE_PRO,set the values as shown below.
Select Attribute = LINESTYLE and Value = 1 Toggle on the Add profile Height in the End Northing.
You can use the attribute LINESTYLE in the feature class WW_PROFILE_LINE_PRO in the display manager to stylize the different type of lines:
Frames: LINESTYLE =1 Axis: LINESTYLE =2 Grid: LINESTYLE = 3 Vertical lines: LINESTYLE = NULL
Country Kit Workshop
Wastewater Profiles - 16
b) Create all the other frames in the same way and with the following properties: Detail Title/ Attribute Frame Left
Frame Right
Frame Bottom
Frame Top
Attribute
Easting
Northing
LINESTYLE = 1
Start Easting: -120
Start Northing: -60
End Easting: -120
End Northing: 80 Add Profile Height
Start Easting:100 Add Profile Width End Easting: 100 Add Profile Width
Start Northing: -60
Start Easting:-120
Start Northing: -60
End Easting: 100 Add Profile Width
End Northing: -60
Start Easting:-120
Start Northing: 80 Add Profile Height End Northing: 80 Add Profile Height
LINESTYLE = 1
LINESTYLE = 1
LINESTYLE = 1
End Easting: 100 Add Profile Width
Country Kit Workshop
End Northing: 80 Add Profile Height
Wastewater Profiles - 17
Step 7. Create axes and grid lines You will create the X and Y axes, and horizontal and vertical lines at the bottom of the profile. Continue in the Decoration tab as with the frame lines. Enter the corresponding Detail Title and select WW_PROFILE_LINE_PRO and Single Line for Decoration type. Set the values as shown in the table below.
Country Kit Workshop
Wastewater Profiles - 18
Detail Title XAxis
YAxis
Grid H1
Grid H2
Grid H3
Grid V1
Grid V2
Grid V3
Country Kit Workshop
Attribute LINESTYLE = 2
LINESTYLE = 2
Easting Start Easting: 0
Northing Start Northing: 0
End Easting: 10 Add Profile Width
End Northing: 0
Start Easting: 0
Start Northing: 0
End Easting: 0
End Northing: 20 Add Profile Height Start Northing: -20
LINESTYLE = 3
Start Easting:-25
End Northing: -20
LINESTYLE = 3
End Easting: 10 Add Profile Width Start Easting:-25
End Northing: -30
LINESTYLE = 3
End Easting: 10 Add Profile Width Start Easting:-25 End Easting: 10 Add Profile Width
End Northing: -40
Start Easting:-25
Start Northing: -20
End Easting: -25
End Northing: -40
Start Easting: 0
Start Northing: -20
End Easting: 0
End Northing: -40
Start Easting: 10 Add Profile Width End Easting: 10 Add Profile Width
Start Northing: -20
LINESTYLE = 3
LINESTYLE = 3
LINESTYLE = 3
Start Northing: -30
Start Northing: -40
End Northing: -40
Wastewater Profiles - 19
Step 8. Create tic marks and labels You can create lines or points that are repeated given an interval. For example, you could use small repetitive lines for the tic marks on the axes. Enter the values as shown below:
Detail Title = XAxis Tic Mark Profile Feature Class = WW_PROFILE_LINE_REP_PRO Decoration type = Repeated Vertical Line Interval = 20 Reference Origin = o Start Easting: 0 , End Easting: 0 o Start Northing: -1, End Northing: -6
You can repeat this step for the Y axis tic marks, create a repeated horizontal line instead.
Country Kit Workshop
Wastewater Profiles - 20
Now create a new decoration feature for the label of the X Axis using the point feature class WW_PROFILE_POINT_REP_PRO. Enter the values as shown below:
Detail Title = XAxis Tic Mark Label Profile Feature Class = WW_PROFILE_POINT_REP_PRO Decoration type = Repeated Vertical Point Interval = 20 Reference Origin = o Start Easting: 0 o Start Northing: -10
Country Kit Workshop
Wastewater Profiles - 21
The previous step creates the repetitive points at the given interval, now you need to create the label for the points. In the navigation pane, click Labels. Enter the values as shown below:
Sub Detail Title = XAxis Tic Mark Label Dist Profile Feature Class = WW_PROFILE_PT_REP_PRO_TBL Reference Feature = XAxis Tic Mark label Label Definition = Distance from origin Reference Origin = o Start Easting: leave empty, the value is taken from the parent label definition o Start Northing: -12
In the same way, you can create labels for the tic marks of the Y axis.
Country Kit Workshop
Wastewater Profiles - 22
Step 9. Create labels In the navigation pane, click Labels. Enter the values as shown below:
Sub Detail Title = Manhole Height Profile Feature Class = WW_POINT_PRO_TBL Reference Feature =Manhole Label Definition = Point Pro Height Label Reference Origin = o Start Easting: leave empty, the value is taken from the parent label definition o Start Northing: -27
In the same way you can add other labels such as length and slope of the sections, manholes bottom elevation and any other relevant values.
Country Kit Workshop
Wastewater Profiles - 23
Step 10. Static Text Add a static text ‘Height’ in the grid. In the navigation pane, click Decoration. Enter the values as shown below:
Detail Title = Static Text Height Parent Profile Feature Class = WW_PROFILE_STATIC_TEXT Decoration Type = Single Point Reference Origin = Start Easting: -20 Start Northing: -25
Country Kit Workshop
Wastewater Profiles - 24
In the navigation pane, click Labels. Enter the values as shown below:
Sub Detail Title = Static Text Height Label Profile Feature Class = WW_PRO_STATIC_TEXT_TBL Reference Feature = Static Text Height Parent Label Definition = Static Text Height Reference Origin = Start Easting: -20 Start Northing: -27
Note: If you do not specify the coordinates for the sub details, the labels will be placed relative to the geometry of the reference feature.
Country Kit Workshop
Wastewater Profiles - 25
Creating a profile Getting started In Topobase Client, select the document, right-click and select Profile Manager.
The Profile Manager window is opened. To create a new profile, select the option from the menu Profile > Create Profile or click on the Create profile icon (
) in the toolbar.
Country Kit Workshop
Wastewater Profiles - 26
The Profile Definition List is shown displaying the available definitions for the data model. Select the profile definition that you created, Profile Test. Enter a name under Profile title, this name will serve to identify the different profiles that you create.
Click OK.
Country Kit Workshop
Wastewater Profiles - 27
The Profile Manager window shows the new profile with the default settings as defined in the profile definition.
Profile Settings The Profile Settings area at the top of the window contains the following fields:
FID: identification number of the profile, assigned automatically. User: name of the Topobase user Height scale factor: vertical exaggeration for the profile. Length scale factor: horizontal exaggeration. The length of the sections to be represented in the profile is multiplied by this factor (i.e., a value of 1 means that the length of the sections in the profile is maintained). Reference altitude: vertical offset of the profile origin. The value of the reference altitude is subtracted from the length of all vertical lines. In this data set, the bottom elevation of the manholes is a value greater than 400m; so in the profile the manhole altitude shown by the vertical lines is the actual height minus the reference altitude of 400. Reference distance: horizontal offset of the profile origin.
Country Kit Workshop
Wastewater Profiles - 28
Origin point: Easting, Northing, and Orientation of the profile origin point. The coordinates of the profile are acquired when the profile is drawn.
Feature and Axis Selection There are two methods for selecting features for the profile:
Topological selection with intermediate features: Choose a network topology, a start feature, an end feature, and optionally intermediate points. Topobase executes a shortest path propagation between the selected start and end features.
Feature selection: Individual features (point networks or sections) are selected directly on the map.
To select features through topological selection In the Profile Manager window, under Feature selection process, select the option Topological selection with intermediate feature(s) from the combo box. The Profile - Topological Selection With Intermediate Feature(s) dialog box is opened. By default it shows the available Logical topology: WW.
Country Kit Workshop
Wastewater Profiles - 29
The buttons in the Topological Selection toolbar are used to select the start, intermediate, and end features. Click on the first button to select the first feature on the map. Using the map cursor, select the starting feature (in this example manhole 4768).
Then click on the third button to select the end feature. Click on manhole 140. When the features are selected, the tree explorer Main Features is updated with the FIDs of the features selected. Note that in this case the FIDs correspond to the WW_POINT feature class. The intermediate features are optional.
Click OK. Country Kit Workshop
Wastewater Profiles - 30
A shortest path propagation is generated between the selected features, and a list of all the features on this path are shown under Feature explorer in the Profile Manager window. In this example there are five points including the selected starting and ending manholes, and four sections connecting the points. The explorer also shows the FID of each feature. Note that there are buttons to highlight or zoom to the features, or to display a feature’s form.
If you click the highlight icon, all the features for the profile are highlighted in yellow on the map.
To select an axis After selecting the features for the profile, you can select an axis where the features will be projected. There are two methods for selecting an axis:
Topological selection with intermediate feature(s): Follow the same process explained above to select an axis that follows the topology of the lines. Normally you will the exact same selection as in the previous step.
Country Kit Workshop
Wastewater Profiles - 31
Polyline digitization: This option digitizes a line on the map parallel to the sections represented in the profile.
Drawing Profile Once all the parameters have been set, you are ready to draw the profile. In the Profile Manager form select the option in the menu Profile > Draw Profile or click on the Draw profile icon in the toolbar.
You will be prompted to place the origin on the map. It is best to place the point in the outside areas of the map so the profile does not cover any existing features. Then specify an orientation to the origin point. The features will be created and the profile will be shown on the map.
Country Kit Workshop
Wastewater Profiles - 32
The following figure shows the profile that has been drawn on the map. (The frame is not shown in the figure below).
All necessary information is displayed in the profile for analysis. You can graphically identify slopes and lengths of sections, as well as the height of features relative to the reference altitude. The relationship between slopes and length of the pipes can also be identified in the profile. All these values will help you identify necessary information, find data entry errors, and make comparisons (i.e., short pipes typically have higher slopes than longer pipes). Note that the colors of this display are defined in the Display Manager and can be changed as desired. The information displayed in the profile above:
Names of the manholes are on top: 4768, 958, 959, etc. Sections names: i.e. 4768-958 for the first section. Normally sections are named using the names of their starting and ending manholes. Height of each manhole is displayed in the first row of the grid. Lengths of the sections are shown at the bottom of the grid.
You can add more values such as slopes, manhole bottom elevations and any other relevant value.
Country Kit Workshop
Wastewater Profiles - 33
© 2010 Autodesk, Inc. All rights reserved. NOT FOR DISTRIBUTION. The contents of this guide were created for Autodesk® Topobase™ 2011. The contents of this guide are not intended for other versions of Autodesk® Topobase™.
Country Kit Workshop
Wastewater Profiles - ii
TABLE OF CONTENTS Table of Contents.................................................................................................................................... 1 Profiles.................................................................................................................................................... 2 Configuration....................................................................................................................................... 2 System Tables .................................................................................................................................. 2 Data Model...................................................................................................................................... 3 Main tables...................................................................................................................................... 4 Adding tables................................................................................................................................... 5 Adding static labels .......................................................................................................................... 6 Display model .................................................................................................................................. 7 Steps to create a profile definition ....................................................................................................... 8 Step 1. General settings .................................................................................................................. 9 Step 2. Point feature classes .......................................................................................................... 10 Step 3. Line feature classes ............................................................................................................ 11 Step 4. Vertical lines ...................................................................................................................... 13 Step 5. Attributes........................................................................................................................... 14 Step 6. Create frame ...................................................................................................................... 15 Step 7. Create axes and grid lines................................................................................................... 18 Step 8. Create tic marks and labels ................................................................................................ 20 Step 9. Create labels ...................................................................................................................... 23 Step 10. Static Text ........................................................................................................................ 24 Creating a profile ............................................................................................................................... 26 Getting started .............................................................................................................................. 26 Profile Settings .............................................................................................................................. 28 Feature and Axis Selection ............................................................................................................. 29 Drawing Profile .............................................................................................................................. 32
Country Kit Workshop
Wastewater Profiles - 1
PROFILES Configuration System Tables These are the system tables that store the definition of the profile: Table
Description
TB_PROFILE
Point feature class to store the origin of a profile. It stores the general settings of the profile.
TB_PROFILE_AXIS
Line string feature class to store the axis of the profile.
TB_PROFILE_DEFINITION
To store the profile definition.
TB_PROFILE_DETAIL
To store profile details. It is related to the TB_PROFILE_DEFINITION table by the FID of the profile. This table stores the exact configuration of the profile, the border lines, the grid detail at the bottom, the legend, the position of the features relative to the origin, and so on.
TB_PROFILE_SUB_DETAIL
To store profile sub details such as offsets of labels. These records are related to those in the TB_PROFILE_DETAIL by the FID.
Country Kit Workshop
Wastewater Profiles - 2
Data Model The results of the profile are stored in the database. Once a profile is generated, a set of features (points, lines, polygons, and labels) are created in the corresponding feature classes of the Profile topic. The figure below shows the feature classes that could be part of the profile:
If not provided, the feature classes have to be created manually.
Country Kit Workshop
Wastewater Profiles - 3
Main tables The main tables for the profile features are:
The line defined for the profile (WW_LINE_PRO), which represents the section. The attribute FID_PARENT has to be related to the WW_LINE feature class. The attribute FID_PROFILE has to be related to TB_PROFILE
The WW_LINE_PRO feature class has a label feature class and as many label definitions as labels will be represented in the profile. In this case it has three label definitions to show the name, length and slope of the section.
Verify the properties of the label definition Line Pro Length Label, if you enable the Automatically create label when feature is created, then the label will be created automatically when the profile line is created. Otherwise you can show the label using the Profile Designer (See Step 9. Create Labels)
Country Kit Workshop
Wastewater Profiles - 4
The SQL statement of the label definition gets the properties of the section following the syntax below: select round(c.PIPE_LENGTH,2) from WW_LINE_PRO a, WW_LINE b, WW_SECTION c where a.FID = $id and a.fid_parent = b.fid and b.fid_attr = c.fid
The point defined for the profile (WW_POINT_PRO) represents the network points. In the same way as with the line, the attribute FID_PARENT has to be related to the WW_POINT feature class. The attribute FID_PROFILE has to be related to TB_PROFILE
The WW_POINT_PRO feature class has a label feature class and as many label definitions as labels will be represented in the profile. In this case it has two label definitions to show the name, and height of the point.
Adding tables If you need to add new feature classes to be represented in the profile, e.g. decoration feature classes to store the axis, static texts, title and so on; you have to make sure that the new feature class has an attribute FID_PROFILE related to the TB_PROFILE.FID. For example, create line feature class WW_PROFILE_LINE_REP_PRO, you will use this feature class to create the tic marks for the axes.
Add attributes: FID_PROFILE - NUMBER(10) related to TB_PROFILE LINESTYLE – NUMBER(10) – This attribute can serve to assign different line styles to use in the display manager.
Country Kit Workshop
Wastewater Profiles - 5
Note that in this data model there is a point feature class (WW_PROFILE_POINT_REP_PRO) with a label definition to generate the labels for the tic marks. Note that the feature class has an attribute DISTANCE_FROM_ORIGIN, this will store the position of the tic mark that is generated automatically.
The label definition has these settings: Label definition name Distance from origin
SQL select DISTANCE_FROM_ORIGIN from WW_PROFILE_POINT_REP_PRO where FID = $id
Orientation Absolute, 0 degrees
Adding static labels Create a label feature class WW_PRO_STATIC_TEXT_TBL for the WW_PROFILE_STATIC_TEXT point feature class. Create a label definition: Label definition name Static Text Height
SQL Select 'Height' from dual
Orientation Absolute, 0 degrees
This label will display the text ‘Height’ in the profile.
Country Kit Workshop
Wastewater Profiles - 6
Display model In order to see the profile you have to create a display model that includes all the profile feature classes.
Country Kit Workshop
Wastewater Profiles - 7
Steps to create a profile definition The following steps explain how to create a simple profile with the information shown in the figure below.
Country Kit Workshop
Wastewater Profiles - 8
Step 1. General settings Define profile general settings
Country Kit Workshop
Wastewater Profiles - 9
Step 2. Point feature classes Define point feature classes that will be part of the profile: Manhole
Detail Title = Description of the detail Main feature class= WW_POINT (the feature class where the geometries are stored) Profile feature class=WW_POINT_PRO (the feature class where the point geometry features for the profiles will be stored)
Define where clause according to the type of feature class: f.f_class_id_attr in ( select f_class_id from tb_dictionary where upper(rtrim(f_class_name)) like 'WW_MANHOLE')
You can create as many profile features as types of points you have.
Country Kit Workshop
Wastewater Profiles - 10
Step 3. Line feature classes Define line feature classes that will be part of the profile: Section
Detail Title = Description of the detail Main feature class= WW_LINE (the feature class where the geometries are stored) Profile feature class=WW_LINE_PRO (the feature class where the point geometry features for the profiles will be stored)
The select Statement for the section filters the coordinates of the points that are topologically connected with the section. The select gets the X, Y coordinates plus the Z value.
Country Kit Workshop
Wastewater Profiles - 11
select g.fid FID, g.geom.sdo_point.x EASTING, g.geom.sdo_point.y NORTHING, g.Z HEIGHT from ww_line a, ww_conn b, ww_section f, ww_point g where ((a.fid = b.fid_from and g.fid = b.fid_to) or (a.fid = b.fid_to and g.fid = b.fid_from)) and a.fid_attr = f.fid and a.fid=$FID
Country Kit Workshop
Wastewater Profiles - 12
Step 4. Vertical lines Define the vertical lines that will connect to the manholes
Select Detail Title Manhole, under vertical lines set these values:
Feature class = select WW_PROFILE_LINE_PRO Offset = 10
Country Kit Workshop
Wastewater Profiles - 13
Step 5. Attributes You can set values to some attributes of the profile features (WW_POINT_PRO, WW_LINE_PRO) for stylization.
Select Detail Title Manhole, under Feature Class Attributes set these values:
Attribute = select FEATURE_TYPE Value = Manhole
This means that the attribute FEATURE_TYPE of the table WW_POINT_PRO will be set to ‘Manhole’. You can use this setting to stylize the feature class WW_POINT_PRO in the display manager.
Country Kit Workshop
Wastewater Profiles - 14
Step 6. Create frame In order to create a frame for the profile you need to define the width and height of it given that the profile will be drawn in the origin (0,0). The example below shows some values for the frame.
Country Kit Workshop
Wastewater Profiles - 15
a) Create left frame, in the Decoration tab: Enter the Detail Title = Frame Left and select WW_PROFILE_LINE_PRO,set the values as shown below.
Select Attribute = LINESTYLE and Value = 1 Toggle on the Add profile Height in the End Northing.
You can use the attribute LINESTYLE in the feature class WW_PROFILE_LINE_PRO in the display manager to stylize the different type of lines:
Frames: LINESTYLE =1 Axis: LINESTYLE =2 Grid: LINESTYLE = 3 Vertical lines: LINESTYLE = NULL
Country Kit Workshop
Wastewater Profiles - 16
b) Create all the other frames in the same way and with the following properties: Detail Title/ Attribute Frame Left
Frame Right
Frame Bottom
Frame Top
Attribute
Easting
Northing
LINESTYLE = 1
Start Easting: -120
Start Northing: -60
End Easting: -120
End Northing: 80 Add Profile Height
Start Easting:100 Add Profile Width End Easting: 100 Add Profile Width
Start Northing: -60
Start Easting:-120
Start Northing: -60
End Easting: 100 Add Profile Width
End Northing: -60
Start Easting:-120
Start Northing: 80 Add Profile Height End Northing: 80 Add Profile Height
LINESTYLE = 1
LINESTYLE = 1
LINESTYLE = 1
End Easting: 100 Add Profile Width
Country Kit Workshop
End Northing: 80 Add Profile Height
Wastewater Profiles - 17
Step 7. Create axes and grid lines You will create the X and Y axes, and horizontal and vertical lines at the bottom of the profile. Continue in the Decoration tab as with the frame lines. Enter the corresponding Detail Title and select WW_PROFILE_LINE_PRO and Single Line for Decoration type. Set the values as shown in the table below.
Country Kit Workshop
Wastewater Profiles - 18
Detail Title XAxis
YAxis
Grid H1
Grid H2
Grid H3
Grid V1
Grid V2
Grid V3
Country Kit Workshop
Attribute LINESTYLE = 2
LINESTYLE = 2
Easting Start Easting: 0
Northing Start Northing: 0
End Easting: 10 Add Profile Width
End Northing: 0
Start Easting: 0
Start Northing: 0
End Easting: 0
End Northing: 20 Add Profile Height Start Northing: -20
LINESTYLE = 3
Start Easting:-25
End Northing: -20
LINESTYLE = 3
End Easting: 10 Add Profile Width Start Easting:-25
End Northing: -30
LINESTYLE = 3
End Easting: 10 Add Profile Width Start Easting:-25 End Easting: 10 Add Profile Width
End Northing: -40
Start Easting:-25
Start Northing: -20
End Easting: -25
End Northing: -40
Start Easting: 0
Start Northing: -20
End Easting: 0
End Northing: -40
Start Easting: 10 Add Profile Width End Easting: 10 Add Profile Width
Start Northing: -20
LINESTYLE = 3
LINESTYLE = 3
LINESTYLE = 3
Start Northing: -30
Start Northing: -40
End Northing: -40
Wastewater Profiles - 19
Step 8. Create tic marks and labels You can create lines or points that are repeated given an interval. For example, you could use small repetitive lines for the tic marks on the axes. Enter the values as shown below:
Detail Title = XAxis Tic Mark Profile Feature Class = WW_PROFILE_LINE_REP_PRO Decoration type = Repeated Vertical Line Interval = 20 Reference Origin = o Start Easting: 0 , End Easting: 0 o Start Northing: -1, End Northing: -6
You can repeat this step for the Y axis tic marks, create a repeated horizontal line instead.
Country Kit Workshop
Wastewater Profiles - 20
Now create a new decoration feature for the label of the X Axis using the point feature class WW_PROFILE_POINT_REP_PRO. Enter the values as shown below:
Detail Title = XAxis Tic Mark Label Profile Feature Class = WW_PROFILE_POINT_REP_PRO Decoration type = Repeated Vertical Point Interval = 20 Reference Origin = o Start Easting: 0 o Start Northing: -10
Country Kit Workshop
Wastewater Profiles - 21
The previous step creates the repetitive points at the given interval, now you need to create the label for the points. In the navigation pane, click Labels. Enter the values as shown below:
Sub Detail Title = XAxis Tic Mark Label Dist Profile Feature Class = WW_PROFILE_PT_REP_PRO_TBL Reference Feature = XAxis Tic Mark label Label Definition = Distance from origin Reference Origin = o Start Easting: leave empty, the value is taken from the parent label definition o Start Northing: -12
In the same way, you can create labels for the tic marks of the Y axis.
Country Kit Workshop
Wastewater Profiles - 22
Step 9. Create labels In the navigation pane, click Labels. Enter the values as shown below:
Sub Detail Title = Manhole Height Profile Feature Class = WW_POINT_PRO_TBL Reference Feature =Manhole Label Definition = Point Pro Height Label Reference Origin = o Start Easting: leave empty, the value is taken from the parent label definition o Start Northing: -27
In the same way you can add other labels such as length and slope of the sections, manholes bottom elevation and any other relevant values.
Country Kit Workshop
Wastewater Profiles - 23
Step 10. Static Text Add a static text ‘Height’ in the grid. In the navigation pane, click Decoration. Enter the values as shown below:
Detail Title = Static Text Height Parent Profile Feature Class = WW_PROFILE_STATIC_TEXT Decoration Type = Single Point Reference Origin = Start Easting: -20 Start Northing: -25
Country Kit Workshop
Wastewater Profiles - 24
In the navigation pane, click Labels. Enter the values as shown below:
Sub Detail Title = Static Text Height Label Profile Feature Class = WW_PRO_STATIC_TEXT_TBL Reference Feature = Static Text Height Parent Label Definition = Static Text Height Reference Origin = Start Easting: -20 Start Northing: -27
Note: If you do not specify the coordinates for the sub details, the labels will be placed relative to the geometry of the reference feature.
Country Kit Workshop
Wastewater Profiles - 25
Creating a profile Getting started In Topobase Client, select the document, right-click and select Profile Manager.
The Profile Manager window is opened. To create a new profile, select the option from the menu Profile > Create Profile or click on the Create profile icon (
) in the toolbar.
Country Kit Workshop
Wastewater Profiles - 26
The Profile Definition List is shown displaying the available definitions for the data model. Select the profile definition that you created, Profile Test. Enter a name under Profile title, this name will serve to identify the different profiles that you create.
Click OK.
Country Kit Workshop
Wastewater Profiles - 27
The Profile Manager window shows the new profile with the default settings as defined in the profile definition.
Profile Settings The Profile Settings area at the top of the window contains the following fields:
FID: identification number of the profile, assigned automatically. User: name of the Topobase user Height scale factor: vertical exaggeration for the profile. Length scale factor: horizontal exaggeration. The length of the sections to be represented in the profile is multiplied by this factor (i.e., a value of 1 means that the length of the sections in the profile is maintained). Reference altitude: vertical offset of the profile origin. The value of the reference altitude is subtracted from the length of all vertical lines. In this data set, the bottom elevation of the manholes is a value greater than 400m; so in the profile the manhole altitude shown by the vertical lines is the actual height minus the reference altitude of 400. Reference distance: horizontal offset of the profile origin.
Country Kit Workshop
Wastewater Profiles - 28
Origin point: Easting, Northing, and Orientation of the profile origin point. The coordinates of the profile are acquired when the profile is drawn.
Feature and Axis Selection There are two methods for selecting features for the profile:
Topological selection with intermediate features: Choose a network topology, a start feature, an end feature, and optionally intermediate points. Topobase executes a shortest path propagation between the selected start and end features.
Feature selection: Individual features (point networks or sections) are selected directly on the map.
To select features through topological selection In the Profile Manager window, under Feature selection process, select the option Topological selection with intermediate feature(s) from the combo box. The Profile - Topological Selection With Intermediate Feature(s) dialog box is opened. By default it shows the available Logical topology: WW.
Country Kit Workshop
Wastewater Profiles - 29
The buttons in the Topological Selection toolbar are used to select the start, intermediate, and end features. Click on the first button to select the first feature on the map. Using the map cursor, select the starting feature (in this example manhole 4768).
Then click on the third button to select the end feature. Click on manhole 140. When the features are selected, the tree explorer Main Features is updated with the FIDs of the features selected. Note that in this case the FIDs correspond to the WW_POINT feature class. The intermediate features are optional.
Click OK. Country Kit Workshop
Wastewater Profiles - 30
A shortest path propagation is generated between the selected features, and a list of all the features on this path are shown under Feature explorer in the Profile Manager window. In this example there are five points including the selected starting and ending manholes, and four sections connecting the points. The explorer also shows the FID of each feature. Note that there are buttons to highlight or zoom to the features, or to display a feature’s form.
If you click the highlight icon, all the features for the profile are highlighted in yellow on the map.
To select an axis After selecting the features for the profile, you can select an axis where the features will be projected. There are two methods for selecting an axis:
Topological selection with intermediate feature(s): Follow the same process explained above to select an axis that follows the topology of the lines. Normally you will the exact same selection as in the previous step.
Country Kit Workshop
Wastewater Profiles - 31
Polyline digitization: This option digitizes a line on the map parallel to the sections represented in the profile.
Drawing Profile Once all the parameters have been set, you are ready to draw the profile. In the Profile Manager form select the option in the menu Profile > Draw Profile or click on the Draw profile icon in the toolbar.
You will be prompted to place the origin on the map. It is best to place the point in the outside areas of the map so the profile does not cover any existing features. Then specify an orientation to the origin point. The features will be created and the profile will be shown on the map.
Country Kit Workshop
Wastewater Profiles - 32
The following figure shows the profile that has been drawn on the map. (The frame is not shown in the figure below).
All necessary information is displayed in the profile for analysis. You can graphically identify slopes and lengths of sections, as well as the height of features relative to the reference altitude. The relationship between slopes and length of the pipes can also be identified in the profile. All these values will help you identify necessary information, find data entry errors, and make comparisons (i.e., short pipes typically have higher slopes than longer pipes). Note that the colors of this display are defined in the Display Manager and can be changed as desired. The information displayed in the profile above:
Names of the manholes are on top: 4768, 958, 959, etc. Sections names: i.e. 4768-958 for the first section. Normally sections are named using the names of their starting and ending manholes. Height of each manhole is displayed in the first row of the grid. Lengths of the sections are shown at the bottom of the grid.
You can add more values such as slopes, manhole bottom elevations and any other relevant value.
Country Kit Workshop
Wastewater Profiles - 33
