20240627 16184000 1.0 TRUE NON WVC LINES 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) + ((("TX"-"FX") < 0 AND ("TY" - "FY") >0)*2)))DIRECTION:CASE WHEN "BEARING" >337.5 THEN 'N'WHEN "BEARING" >=0 AND "BEARING"< 22.5 THEN 'N'WHEN "BEARING">22.5 AND "BEARING"<67.5 THEN 'NE'WHEN "BEARING">67.5 AND "BEARING"<112.5 THEN 'E'WHEN "BEARING">112.5 AND "BEARING"<157.5 THEN 'SE'WHEN "BEARING">157.5 AND "BEARING"<202.5 THEN 'S'WHEN "BEARING">202.5 AND "BEARING"<247.5 THEN 'SW'WHEN "BEARING">247.5 AND "BEARING"<292.5 THEN 'W'WHEN "BEARING">292.5 AND "BEARING"<337.5 THEN 'NW'END Chad Bunn, Robert Zito