{ "culture": "en-US", "name": "", "guid": "", "catalogPath": "", "snippet": "", "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) + (((\"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", "summary": "", "title": "Lines", "tags": [], "type": "", "typeKeywords": [], "thumbnail": "", "url": "", "minScale": "NaN", "maxScale": "NaN", "spatialReference": "", "accessInformation": "Chad Bunn, Robert Zito", "licenseInfo": "", "portalUrl": "" }