Sewer User Manual
Chapter 1Introducing the MunsysQ Sewer User Manual
MunsysQ Sewer is used to capture and maintain gravity, pressure and vacuum sewer networks in QGIS. It does not require GIS expertise: the Sewer menus guide you through each function, and the sewer business rules are applied as you work.
MunsysQ Sewer is one of the MunsysQ applications, alongside MunsysQ Cadastral, Drainage, Roads and Water. All of them work on the same Munsys database as Munsys on AutoCAD.
About this manual
This manual describes the functions of MunsysQ Sewer: how a sewer network is captured, given its elevations, checked, posted to the database and maintained. It assumes that you are familiar with:
- the sewer business rules of your organisation
- the MunsysQ panel, QAD command line and edit cycle, as described in the MunsysQ Concepts User Manual
- common GIS terminology.
What is in this manual
| Chapter | What it covers |
|---|---|
| 2. Getting acquainted with MunsysQ Sewer | Sewer networks, loading the Sewer application, the Sewer menus and layers. |
| 3. Sewer data in the project | How the sewer layers show the data in the database. |
| 4. Creating sewer data | Capture settings and capturing pipes, nodes, service connections, elevations, basins, residential sewers and annotation, then checking integrity and posting. |
| 5. Maintaining sewer data | Changing pipes, nodes, elevations and attributes, and deleting and restoring sewer objects. |
| 6. Converting drawing entities to sewer objects | Turning imported or construction geometry into sewer objects. |
| Appendix A. Sewer menus | The complete Capture, Change and Extras menus of MunsysQ Sewer. |
Additional reading material
Before you use this manual, read the MunsysQ Concepts User Manual. It explains the topics that are the same in every application:
- connecting to the Munsys data, through WFS-T or directly to the database
- the MunsysQ panel and the QAD command line
- Munsys objects, tags, lookup values and application settings
- the edit cycle of capture, integrity check and posting, and record locking
- the Object and Tools menus that all applications share.
Conventions in this manual
| Convention | Meaning |
|---|---|
| A function in the MunsysQ menu tree. Expand each level, then double-click the last item. | |
Select sewer pipes... | A prompt on the QAD command line. |
SP_SEWGPIPE | A database table, column or value. |
| Enter | A key on the keyboard. |
Finding the information you need
- For the manuals, click on the MunsysQ panel.
- For help on a dialog box, click its button.
- For the latest support options, visit www.openspatial.com.
Chapter 2Getting acquainted with MunsysQ Sewer
About MunsysQ Sewer
MunsysQ Sewer is used to capture and maintain gravity, pressure and vacuum sewer networks. Sewer pipes are laid along cadastral boundaries and are broken where nodes such as manholes, junctions and reducers are inserted. Service connections link the parcels to the network, and sewer basins divide the network into the areas that drain to a purification works or to a primary outfall sewer.
The Sewer menus allow fast and efficient capture and maintenance of the network. The sewer business rules are built into the functions, so that the data is maintained to engineering standards before it is posted to the database.
About sewer objects
- Sewer pipes are laid along cadastral boundaries. There are three kinds:
- Gravity pipes: street sewers in the road reserve, midblock sewers through the middle of the parcels, and outfall sewers, the bulk pipes.
- Pressure pipes: pipes in which sewage is pumped against gravity, also called rising mains.
- Vacuum pipes: pipes in which the flow is driven by an induced vacuum.
- Sewer nodes show where pipes connect or end, for example manholes, junctions, pump stations and end caps. Valves are nodes too.
- Service connections are the first connection from a parcel to the network. They usually meet the pipe at 45 or 90 degrees. The pipe is not broken where a service connection joins it.
- Residential sewers run from the buildings on a parcel to the service connection. They are not part of the network connectivity.
- Sewer basins are polygons that show part of the network up to the purification works, or smaller sections up to the primary outfall sewers.
- Sewer symbols are additional annotation, such as a cleanout or a direction arrow. They are not part of the network.
- Labels show the value of a pipe attribute, such as diameter and material. Notes and dimension arrows add information to plans.
Loading MunsysQ Sewer
Before you start, QGIS must be connected to the Munsys data and the MunsysQ panel must show its menus. Connecting is described in Chapter 3 of the MunsysQ Concepts User Manual.
- Open the QGIS project that contains the sewer layers.
- On the MunsysQ panel, select in the list. The Sewer menus are displayed in the menu tree.
The MunsysQ Sewer menus
The Sewer functions are grouped in three menus. The Object and Tools menus below them are shared by all applications and are described in the Concepts User Manual.
| Menu | Contains |
|---|---|
| Sewer settings; drawing gravity, pressure and vacuum pipes; flow direction; placing and inserting nodes; single, double and freehand service connections; pipe and node elevations; sewer basins; residential sewers; sewer symbols, labels, notes and dimension arrows; data integrity; posting to the database. | |
| Editing attributes; changing pipe geometry and vertices; moving, rotating and snapping nodes; opening and closing valves; changing node types; pipe and node elevations and updating elevations between nodes and pipes; changing pipe and service connection attributes; linking service connections; notes and comments; deleting, undeleting and restoring objects. | |
| Converting blocks, lines, text and polygons to sewer objects. |
Munsys on AutoCAD offers many of these functions on toolbars as well. In MunsysQ every function is in the menu tree.
The sewer layers
Each type of sewer object is stored in its own spatial table and shown in QGIS as its own layer. A MunsysQ project normally holds them in a Sewer group in the Layers panel.
| Layer | Spatial table | Geometry | Contains |
|---|---|---|---|
| Sewer Pipes (Gravity) | SP_SEWGPIPE | Line | Gravity pipes. |
| Sewer Pipes (Pressure) | SP_SEWRPIPE | Line | Pressure pipes (rising mains). |
| Sewer Pipes (Vacuum) | SP_SEWVPIPE | Line | Vacuum pipes. |
| Sewer Nodes | SP_SEWNODE | Point | Manholes, junctions, pump stations and all other nodes, including valves. |
| Sewer SCs | SP_SEWSERV | Line | Service connections. |
| Sewer Residential Pipes | SP_SEWRESPIPE | Line | Residential sewers. |
| Sewer Basins | SP_SEWBASIN | Polygon | Sewer basins and their tags. |
| Sewer Symbols | SP_SEWSYM | Point | Sewer symbols. |
| Sewer Labels | SP_SEWLABEL | Point | Pipe labels. |
| Sewer Notes | SP_SEWNOTE | Point | Notes. |
| Sewer Dimensions, Sewer Dimension Notes | SP_SEWDIM, SP_SEWNOTE | Point | Dimension arrows and their text. |
| Sewer Map Page Grid | SP_SEWMAPPAGE | Polygon | The map page grid used to locate services by map page number. |
MunsysQ finds the layer that a function needs by its spatial table, so you can rename the layers or move them to other groups.
Chapter 3Sewer data in the project
In Munsys on AutoCAD, sewer data is brought into the drawing with the Query menu: the sewer network, sewer basins, residential sewers or the map page grid. In MunsysQ there is no query step. The sewer layers are connected to the database while the project is open, and QGIS reads the objects for the area that you are looking at.
The sewer network
The network is made up of the pipe, node and service connection layers, with the labels, notes and dimensions that belong to them. Keep these layers switched on while you capture or change the network, so that every function can find the objects that it connects to.
Sewer basins and residential sewers
Sewer basins and residential sewers are not part of the network. They are in their own layers, Sewer Basins and Sewer Residential Pipes. Switch them on when you need them.
The map page grid
The Sewer Map Page Grid layer shows the page layout used to locate services by map page number. Switch it on when you need to find a page; it is not part of the network.
Chapter 4Creating sewer data
Capturing sewer data
When you capture a sewer network, start with the cadastral data and the existing sewer objects visible, so that new objects are positioned correctly and nothing is captured twice.
A network is normally captured in this order:
- Pipes first. Then show the flow direction and check that the pipes run towards the lowest point of the network.
- Nodes. Manholes give access to gravity pipes; pump stations are placed on pressure pipes; valves are inserted between pipes; vent stacks ventilate the network; vacuum stations and vacuum chambers are placed on vacuum pipes; an end cap closes off the end of a network.
- Service connections, which link the parcels to the gravity pipes.
- Elevations of the pipes and nodes, from the long sections.
- Residential sewers and sewer basins at any time, because they do not affect the network.
When the network is complete, check its integrity and post it to the database.
Sewer capture settings
The Sewer settings are the defaults that the capture and integrity functions use. Default values are set by the GIS administrator; you can change many of them for your current session to speed up capture.
| Group | Settings |
|---|---|
| Gravity Pipe, Pressure Pipe, Vacuum Pipe | For each kind of pipe: Default Offset Distance, Diameter, Material and Type for new pipes, and Label Height. |
| Residential Pipe | Default Offset Distance for residential sewers. |
| Service Connection | Sewer Category, Service Connection Length and Service Connection Type for new service connections; SC Link Mun ID, the type of object, parcel or building, to which service connections are linked. |
| Sewer Node, Node, Sewer Symbol | Node Function for new nodes; Sewer Node Scale and Sewer Symbol Scale. |
| Integrity | Short Objects; Node, Pipe, Search and Service Connection Tolerance. |
| Basin, Dimension, Note | Basin Tag Height, Dimension Note Height and Note Tag Height. |
To specify sewer capture settings
- Choose . The Sewer Settings dialog box shows the current session settings.
- Select a setting to see its description in the box below the list.
- To change a value, click it, and then type a new value or choose one from the list.
- Click .
The new values apply to objects that you capture from now on, until you change them again or close QGIS. They do not change objects that already exist.
Capturing sewer pipes
The flow in a sewer pipe is driven by gravity and the downhill slope of the pipe, by positive pressure from pumps, or by negative pressure in a vacuum system. Capture pipes in the direction of flow where you can, and always show and correct the flow direction before posting.
In residential areas, pipes are usually captured at an offset from the cadastral boundaries. Elsewhere they are captured freehand, point by point.
Drawing offset gravity pipes
A gravity pipe is a single straight line between two nodes. You indicate where it runs, then the boundary segment to offset it from.
- Choose .
- Specify an approximate start point and an approximate end point for the pipe.
- Select the boundary segment to offset the pipe from.
- At
Specify point on side to offset:, click on the side of the boundary where the pipe must lie. - Enter the offset distance, or press Enter to accept the Gravity Pipe Default Offset Distance.
Drawing offset pressure and vacuum pipes
Pressure and vacuum pipes can have several segments, so they are traced along a boundary by points or by picking its segments.
By points
- Choose and or .
- At
Specify first point or [Offset segment]:, pick the first point along the boundary, then the next points. Press Enter after the last point. - At
Specify point on side to offset:, click on the side where the pipe must lie. - Enter the offset distance, or press Enter for the default of that kind of pipe.
By selecting segments
- Choose the function, then type
Oand press Enter for the Offset segment option. - At
Select offset segment:, pick a boundary segment, and click on the side for the pipe. - At
Multiply offset by <1>:, enter a factor for the default offset distance, or press Enter. - Continue selecting segments, then answer
Done selecting offset segments [Yes/No] <Yes>:with Enter.
Drawing freehand sewer pipes
- Choose and , or .
- Specify the first point, then the next points, by clicking on the map or typing coordinates.
- Press Enter after the last point.
Freehand gravity pipes are straight lines: each pair of points that you pick creates one pipe, so you can capture a sequence of gravity pipes in one go. Pressure and vacuum pipes are created as one pipe through all the points.
New pipes receive the diameter, material and type from the Sewer settings and are highlighted as pending edits.
Showing and changing flow direction
| Function | What it does |
|---|---|
| Shows an arrow on each selected pipe in its flow direction. | |
| Reverses the direction of the selected pipes. Show the direction first, so that you can see the result. | |
| Removes the direction arrows from the map. |
Capturing sewer nodes
A node is placed either at the end of a pipe or inserted at any point along a pipe, which breaks the pipe there. Placement rules apply to some node types: for example, manholes can only be placed on gravity pipes, while end caps can be placed on gravity, pressure or vacuum pipes.
| Place at an endpoint | Insert at the nearest point on a pipe |
|---|---|
| Manhole (Public), Manhole (Private), Junction, Lamphole, Rodding Eye, Metering Point, End Cap, Air Vacuum Release, Vent Stack, Reducer, Open Valve, Scour Valve, Pump Station (Public), Pump Station (Private), Reservoir, Vacuum Station, Vacuum Chamber | Manhole (Public), Manhole (Private), Junction, Air Vacuum Release, Vent Stack, Reducer, Open Valve, Scour Valve |
The node types available at your site are defined in the database and may differ.
Placing endpoint sewer nodes
- Choose and the node type, for example .
- Select the pipe close to the end where the node must go. The node is placed at that end of the pipe.
Inserting nearest sewer nodes
- Choose and the node type.
- Select the point on the pipe where the node must go. The pipe is broken at that point.
PIPE_ID; all its other attributes are copied from the original, and the original is recorded as its lineage parent.Capturing sewer service connections
Service connections connect the parcels to the gravity pipes. They are placed at 45 or 90 degrees to the pipe, as a single or a double connection, at the end of the pipe or at the nearest point along it. A freehand service connection can take any route. The length and type come from the Sewer settings.
Placing single service connections
- Choose and , , or .
- At
Select sewer pipe for service connection:, select the gravity pipe: near its end for an Endpoint connection, or at the point where the connection joins for a Nearest connection. - Move the cursor to the side of the pipe where the parcel is and click. The service connection is drawn at the chosen angle with the default length.
Placing double service connections
A double service connection serves the parcels on both sides of a pipe, or two parcels on one side, from one point.
- Choose and the angle and position.
- Select the gravity pipe as for a single connection.
- Click to place the first branch, then click again to place the second branch.
Placing freehand service connections
Use a freehand service connection when the connection is longer than the default length or does not meet the pipe at 45 or 90 degrees. It receives the default service connection type.
- Choose .
- Select the gravity pipe where the service connection starts.
- Specify the points of the connection, ending inside the parcel, and press Enter.
Attaching sewer elevations
Elevations are entered from the long sections of the design or as-built drawings. Cover and invert elevations are stored on both ends of each pipe, so that drop manholes, where incoming pipes enter higher than the outgoing pipe, are recorded correctly. Nodes store their cover elevation and depth.
The same functions are on the menu, for new objects, and on the menu, for existing objects.
To attach or change pipe elevations
- Choose or .
- Select the sewer pipe. The Sewer Pipe Information dialog box is displayed.
- In the group, enter the Cover Elevation and the Invert Elevation (the bottom of the pipe). The Depth is calculated.
- In the group, enter the Cover Elevation and Invert Elevation.
- Check the Length and Gradient in the group, which are calculated from the two ends, and click .
To attach or change node elevations
- Choose or .
- Select the sewer node. The Sewer Node Information dialog box shows its current values, if any.
- Enter the Node Depth (the difference between the cover and the invert of the node) and the Cover Elevation, and click .
Capturing sewer basins
Sewer basins are polygons that show the part of the network that drains to a purification works or to a primary outfall sewer. A basin does not affect the network.
- Choose .
- At
Specify first point:, pick the first corner of the basin, then the next corners atSpecify next point:. - Press Enter to close the boundary. It is closed back to the first point.
The basin polygon is created directly, and its tag is placed with the Basin Tag Height from the Sewer settings.
Capturing residential sewers
Residential sewers run from the buildings on a parcel to the service connection. They can be drawn freehand or at an offset from a boundary.
- : pick the points of the pipe and press Enter.
- : the prompts are the same as for offset pressure and vacuum pipes, with the Residential Pipe Default Offset Distance.
Placing sewer annotation
Placing sewer symbols
Sewer symbols, such as a cleanout or a direction arrow, can be placed anywhere and are not part of the network.
- Choose . The Sewer Symbols dialog box lists the available symbols.
- Select the symbol and click .
- Specify the insertion point.
- At
Specify rotation angle or [Align to segment] <0>:, type the angle, pick it on the map, or typeAand select a segment to align the symbol to.
LU_SMS_SEWSYM, which the administrator can extend.Placing sewer labels
A sewer label shows the diameter and material of a pipe. Because it reads the pipe's attributes, it shows the new values after the pipe has been changed and posted.
- Choose and , or .
- Select the pipe to label.
- Specify the insertion point of the label.
- Enter the label height, or press Enter for the label height setting of that kind of pipe.
- Specify the angle: type it, pick it on the map, or type
Ato align the label to a segment.
Placing sewer notes
Notes add information for map production, for example to mark the start of a pressure pipe or a landmark.
- Choose .
- Specify the insertion point of the note.
- Enter the note height, or press Enter for the Note Tag Height setting.
- Specify the angle: type it, pick it on the map, or type
Ato align the note to a segment. - At
Enter note value:, type the text of the note and press Enter.
Placing dimension arrows
A map cannot show a pipe at its true offset from a parcel boundary, so dimension arrows are used to state the offset.
- Choose .
- At
Select first segment for dimension:, select the segment that the arrows must be perpendicular to. - At
Select second segment for dimension:, select the point on the second segment that the arrows must align to. - At
Enter distance or [Actual]:, type the distance, press Enter for the default gravity pipe offset distance, or typeAto use the measured distance.
Checking sewer integrity
The integrity check validates new and changed objects against the sewer business rules before they are posted. The rules are held in the database and are applied by the Munsys REST service, so they are the same as in Munsys on AutoCAD. The check has two parts:
- Object integrity checks each object on its own: its geometry and its attributes.
- Network integrity checks how the objects fit together into a network: the topology of the geometry and the connectivity recorded in the attributes. Because it depends on the relationships between objects, it also looks at neighbouring objects that you did not change.
| Object check | Description |
|---|---|
| Short objects | Objects shorter than the Short Objects setting. |
| Duplicate points | Redundant points within the snap tolerance, which are removed. |
| Incomplete geometry | Objects without a valid geometry. |
| Outside database extents | Objects outside the geographic extents of the database. |
| Attribute rules | The attribute rules defined for the table, for example values that may not be empty. |
| Attribute data types | Values that do not fit the column, for example a tag longer than the TAG_VALUE column. |
| Network check | Description |
|---|---|
| Pipes within snap tolerance | Pipes that could be snapped to other pipes within the snap tolerance. |
| Pipes without nodes | Pipes without a node at each end. |
| Duplicate pipes | Two pipes connected to the same pair of nodes. |
| Nodes within snap tolerance | Nodes that could be snapped to pipes within the snap tolerance. |
| Isolated nodes | Nodes not connected to any pipe. |
| Nodes with too many or too few pipes | Nodes connected to more, or fewer, pipes than their type allows. |
| Duplicate nodes | Nodes captured on top of one another. |
To check sewer object integrity
- Select the sewer objects to check on the map. If nothing is selected, all sewer objects with pending edits are checked.
- Choose .
- The MunsysQ Integrity message reports how many objects were checked and failed, how many issues were found, and how many integrity markers were written.
To check sewer network integrity
- Select the part of the network to check, or select nothing to check the objects with pending edits.
- Choose .
- Read the result in the MunsysQ Integrity message.
Browsing integrity markers
Each problem is marked on the map by a point in the Integrity Errors layer. zooms to the markers and opens their attribute table, which lists for each marker the rule, the error code and message, the layer and object affected, and a description.
Select a row and use the attribute table's button to go to that problem.
Erasing integrity markers
asks for confirmation and then removes all the markers. Markers are a working aid on your computer only and are never posted.
Posting sewer data to the database
New and changed sewer data that has passed the integrity check is posted to the database.
- Choose . The Post to Database dialog box lists each sewer layer with pending edits and the number of objects to be inserted, updated and deleted.
- Check the totals and click .
- The Post to Database Results dialog box shows what was posted, with a status and a message for each layer. Click .
Before posting, MunsysQ recalculates the gradient of every changed pipe from its elevations. After posting, the edit highlight is cleared, your locks on the posted objects are released, and the changes are visible to all users. Posting is described in full in the Concepts User Manual.
Chapter 5Maintaining sewer data
Once the pipes and nodes have been placed, they must be joined correctly, with no overlaps or undershoots, and every pipe must have a node at each end. The menu provides the functions for this, and for changing elevations and attributes such as pipe diameter, material and type.
When you change an existing object it is locked for you, and the change is a pending edit. Changed objects must pass the integrity check before they are posted.
Changing sewer pipes
To extend a sewer pipe to a boundary
Extends a pipe until it meets a boundary object, for example to form a T-junction during capture.
- Choose .
- Select the boundary object that the pipe must extend to.
- Select the pipe to extend, near the end that must be extended.
To extend a sewer pipe by distance
Extends a pipe by a distance at the end nearest to the point where you select it. A negative distance shortens the pipe.
- Choose .
- Select the pipe near the end to extend.
- At
Enter distance:, type the distance and press Enter.
To extend a sewer pipe and break another at the intersection
- Choose .
- Select the pipe to be broken.
- Select the pipe to extend.
To break a sewer pipe
- Choose .
- Select the point on the pipe where it must be broken.
The pipe becomes two pipes, as described under Inserting nearest sewer nodes.
To change a sewer pipe
Moves the endpoint of a pipe to a new location.
- Choose .
- Select the pipe near the endpoint to move.
- Specify the new location of the endpoint.
To fillet sewer pipes
Connects two pipes at their projected intersection.
- Choose .
- Select the first pipe, then the second.
To trim a sewer pipe
- Choose .
- Select the cutting edge, a line that crosses the pipe.
- Select the part of the pipe that must be cut off.
To join sewer pipes
Joins two pipes into one. The joined pipe keeps the attributes of the first pipe that you select; the second pipe is marked for deletion. If there is a gap between the pipes, it is closed with a straight segment.
- Choose .
- Select the first pipe, the one to join to.
- Select the second pipe close to the end that must be joined.
To change the vertices of a sewer pipe
| Function | Steps |
|---|---|
Select the pipe, then at Select segment end point: the end to extend, and at Specify position for new point: the new vertex. | |
Select the pipe, then Specify point closest to vertex to move: and Specify point to move vertex to:. | |
| Select the pipe, then the vertex to remove. A vertex can be removed only from a pipe with more than two vertices. | |
Select the pipe, then at Select segment for inserted point: the segment, and at Specify position for new point: the new vertex. |
Changing sewer nodes
Nodes can be moved, rotated and snapped to pipes, valves can be opened and closed, and the type of a node can be changed. These functions are mostly used when the network is cleaned up after capture.
To move a sewer node
- Choose .
- Select the node, then specify its new insertion point.
To rotate a sewer node
- Choose .
- Select the node.
- At
Specify rotation angle or [Align to segment] <0>:, type the angle, pick it with two points, or typeAand select a segment to align the node to.
To snap a node to the endpoint of a pipe
- Choose .
- Select the node, then the pipe close to the endpoint that the node must snap to.
To snap a node to a pipe, breaking the pipe
- Choose .
- Select the node, then the pipe, then the point where the pipe must be broken. The node is snapped to the break.
To open or close a valve
Changes the status of a valve between open and closed. The symbol changes with the status; the node type does not.
- Choose .
- Select the valves. The Valve Status dialog box is displayed.
- Choose the status and click .
To change a node type
Changes the type of one or more nodes. The symbol and the NODE_TYPE column are updated to the new type.
- Choose .
- Select the nodes and press Enter. The Node Types dialog box is displayed.
- Select the new type and click .
Updating elevations between nodes and pipes
The elevations of a node and of the pipes connected to it are stored separately. The connection between them is the network connectivity, so changing one does not change the other: a node's depth is not updated when the invert of a connected pipe changes, and a pipe's cover elevation is not updated when the node's cover changes. These functions bring them back in line, following the connectivity.
| Function | What it updates |
|---|---|
| From the selected nodes to the connected pipes: the start and end cover elevations, and the start invert elevation, from each node's cover elevation and depth. | |
| From the selected pipes to the connected nodes: each node's cover elevation and depth, from the pipes' cover and invert elevations. | |
| The gradient of the selected pipes, from their invert elevations and length. |
To update pipe elevations from nodes
- Choose .
- At
Select sewer nodes..., select the nodes and press Enter. The command line reports how many pipes were updated.
To update node elevations from pipes
- Choose .
- At
Select sewer pipes..., select the pipes and press Enter. The command line reports how many nodes were updated.
A node's depth is calculated from the start invert elevation of its downstream pipe, not from the end invert of the upstream pipe.
To recalculate pipe gradients
- Choose .
- At
Select sewer pipes..., select the pipes and press Enter. The command line reports how many pipes were updated.
The updated objects are pending edits. Check their integrity and post them as for any other change.
Changing sewer attribute data
Editing sewer object attributes
shows the attributes of the selected sewer objects of one type, for example gravity pipes, in the columns Attribute, Value and Status. Attributes with a fixed list of values offer the list. Attributes that may not be changed are unavailable.
- Choose .
- Select the objects and press Enter. If they are of different types, choose the type to edit.
- To give all the selected objects the same value, select . To edit them one by one, clear it and use the arrow buttons to move between objects; select to have the map follow.
- Change the values and click .
The changes are pending edits until they pass the integrity check and are posted. Mandatory attributes must be completed, or the object fails the object integrity check.
Editing linked table attributes
Some information about sewer objects is kept in linked, non-spatial tables. lets you step through the linked records of an object, change them, and insert or delete records, depending on your privileges. Linked table changes are written to the database directly, so you can only select objects that have already been posted.
Changing pipe diameter, material and type
Changes the diameter, material or type that a pipe was given at capture. Each kind of pipe has its own lists, so choose the menu for gravity, pressure or vacuum pipes.
- Choose , or , and , or .
- Select the pipes and press Enter. The selection dialog box highlights the current value if you selected one pipe; you can search the list by code or description.
- Select the new value and click .
Changing a service connection type
- Choose .
- Select the service connections and press Enter.
- Select the new type from the list and click .
Linking service connections to parcels and buildings
Links service connections to the parcels and buildings that they serve, so that the network can be traced to a property or building.
- Choose .
- Select the service connections and press Enter.
- If the end of a service connection lies inside a parcel, its
PRCL_GIDcolumn is set to the GID of that parcel. - If it also lies inside a building, its
LINK_IDcolumn is set to the GID of the building.
Changing sewer notes
- Choose .
- Select the note. The Sewer Note box is displayed.
- Change the text and click .
Adding comments
- Choose .
- Select the sewer objects. The Sewer Comment box is displayed.
- Type the comment and click . It is stored in the
COMMENTScolumn of each selected object.
Deleting and undeleting sewer objects
Sewer objects that are no longer part of the network are deleted. A deletion is a pending edit: the objects are removed from the database when you post.
To delete sewer objects
- Choose .
- Select the sewer objects and press Enter. Objects that are not sewer objects are left out of the selection.
The objects are marked for deletion and shown in the DELETED group at the top of the Layers panel until you post.
To undelete sewer objects
- Choose . The objects marked for deletion are shown.
- Select the objects to keep. They are no longer marked for deletion, and any changes made to them before they were deleted are kept.
Restoring a deleted object
brings back an object whose deletion has already been posted, from the archive that the database keeps of deleted objects. See the Concepts User Manual.
Chapter 6Converting drawing entities to sewer objects
Sewer networks often exist as CAD drawings. After a drawing has been brought into QGIS with , or geometry has been drawn on a construction layer, the functions convert it to sewer objects. The procedure for imports and the Object Conversion dialog box are described in the Concepts User Manual.
Some basic attributes are set during conversion. Complete the remaining attributes, and the elevations, afterwards; then check integrity and post as for captured objects.
Converting blocks to sewer symbols
- Choose .
- Select the block references and press Enter.
- In the Sewer Symbols dialog box, select the symbol and click . One sewer symbol is created for each block.
Converting blocks to sewer nodes
- Choose and the node type, for example .
- Select the block references and press Enter. One node is created for each block.
Converting lines to sewer objects
Lines can be converted to gravity, vacuum or pressure pipes, service connections or residential sewers.
- Choose and , , , or .
- Select the lines and press Enter.
PIPE_ID and PRCL_GID columns are filled in.Converting text to sewer basin tags and notes
- Choose and or .
- Select the text and press Enter.
Converting polygons to sewer basins
- Choose .
- Select the polygons and press Enter.
ReferenceGlossary
- Cover elevation
- The ground level at a node or at the end of a pipe.
- Depth
- The difference between the cover elevation and the invert elevation.
- Drop manhole
- A manhole where an incoming pipe enters higher than the outgoing pipe leaves.
- Endpoint node
- A node placed at the end of a pipe.
- Gradient
- The slope of a pipe, calculated from its invert elevations and length.
- Gravity pipe
- A sewer pipe in which sewage flows downhill under gravity: a street, midblock or outfall sewer.
- Invert elevation
- The level of the inside bottom of a pipe.
- Lineage parent
- The pipe that a new pipe was split from, recorded when a pipe is broken.
- Nearest node
- A node inserted at a point along a pipe, breaking the pipe there.
- Pressure pipe (rising main)
- A sewer pipe in which sewage is pumped against gravity.
- Residential sewer
- A pipe from a building to the service connection. Not part of the network connectivity.
- Service connection (SC)
- The connection between a parcel and the network.
- Sewer basin
- A polygon showing the part of the network that drains to a purification works or primary outfall sewer.
- Vacuum pipe
- A sewer pipe in which the flow is driven by an induced vacuum.
For the terms that all applications share, see the glossary of the Concepts User Manual.