Description: This storm drain network dataset was derived from an original storm drain dataset and invert data kept in a separate database. The datasets were combined in order to calculate slope for each pipe. Calculations for Slope, Bearing, Direction :SLOPE:F_ELEV IS NOT NULL AND F_INVERT >0 AND T_ELEV IS NOT NULL AND T_INVERT >0(((F_ELEV-F_INVERT) - (T_ELEV-T_INVERT))/Length)*100BEARING:WHERE:"FX" = X coordinate of starting point of line "FY" = Y coordinate of starting point of line "TX" = X coordinate of ending point of line "TY" = Y coordinate of ending point of lineIn QGIS(atan(("TX"-"FX")/("TY"-"FY"))) * 180/3.14159 + (180 *((("TY"-"FY") 0)*2)))DIRECTION:CASE WHEN "BEARING" >337.5 THEN 'N'WHEN "BEARING" >=0 AND "BEARING"22.5 AND "BEARING"67.5 AND "BEARING"112.5 AND "BEARING"157.5 AND "BEARING"202.5 AND "BEARING"247.5 AND "BEARING"292.5 AND "BEARING"<337.5 THEN 'NW'END
Description: This storm drain network dataset was derived from an original storm drain dataset and invert data kept in a separate database. The datasets were combined in order to calculate slope for each pipe. Calculations for Slope, Bearing, Direction :SLOPE:F_ELEV IS NOT NULL AND F_INVERT >0 AND T_ELEV IS NOT NULL AND T_INVERT >0(((F_ELEV-F_INVERT) - (T_ELEV-T_INVERT))/Length)*100BEARING:WHERE:"FX" = X coordinate of starting point of line "FY" = Y coordinate of starting point of line "TX" = X coordinate of ending point of line "TY" = Y coordinate of ending point of lineIn QGIS(atan(("TX"-"FX")/("TY"-"FY"))) * 180/3.14159 + (180 *((("TY"-"FY") 0)*2)))DIRECTION:CASE WHEN "BEARING" >337.5 THEN 'N'WHEN "BEARING" >=0 AND "BEARING"22.5 AND "BEARING"67.5 AND "BEARING"112.5 AND "BEARING"157.5 AND "BEARING"202.5 AND "BEARING"247.5 AND "BEARING"292.5 AND "BEARING"<337.5 THEN 'NW'END
Description: This storm drain network dataset was derived from an original storm drain dataset and invert data kept in a separate database. The datasets were combined in order to calculate slope for each pipe. Calculations for Slope, Bearing, Direction :SLOPE:F_ELEV IS NOT NULL AND F_INVERT >0 AND T_ELEV IS NOT NULL AND T_INVERT >0(((F_ELEV-F_INVERT) - (T_ELEV-T_INVERT))/Length)*100BEARING:WHERE:"FX" = X coordinate of starting point of line "FY" = Y coordinate of starting point of line "TX" = X coordinate of ending point of line "TY" = Y coordinate of ending point of lineIn QGIS(atan(("TX"-"FX")/("TY"-"FY"))) * 180/3.14159 + (180 *((("TY"-"FY") 0)*2)))DIRECTION:CASE WHEN "BEARING" >337.5 THEN 'N'WHEN "BEARING" >=0 AND "BEARING"22.5 AND "BEARING"67.5 AND "BEARING"112.5 AND "BEARING"157.5 AND "BEARING"202.5 AND "BEARING"247.5 AND "BEARING"292.5 AND "BEARING"<337.5 THEN 'NW'END
Color: [0, 0, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: center Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 16 Font Family: Arial Font Style: normal Font Weight: normal Font Decoration: none