Storm Pipe Network File¶

File extension: spn

File Object¶

class gsshapy.orm.StormPipeNetworkFile[source]¶

Bases: sqlalchemy.ext.declarative.api.Base, gsshapy.base.file_base.GsshaPyFileObjectBase

Object interface for the Storm Pipe Network File.

This file is similar in structure as the channel input file. The contents of this file is abstracted to several supporting objects: SuperLink, SuperNode, Pipe, SuperJunction, and Connection.

See: http://www.gsshawiki.com/Subsurface_Drainage:Subsurface_Drainage: http://www.gsshawiki.com/images/d/d6/SUPERLINK_TN.pdf

tableName = u'spn_storm_pipe_network_files'¶: Database tablename

id¶: PK

fileExtension¶: STRING

connections¶: RELATIONSHIP

superLinks¶: RELATIONSHIP

superJunctions¶: RELATIONSHIP

projectFile¶: RELATIONSHIP

Supporting Objects¶

class gsshapy.orm.SuperLink(slinkNumber, numPipes)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Object containing data for a single super link in the subsurface drainage network. A super link consists of several pipes and super nodes.

tableName = u'spn_super_links'¶: Database tablename

id¶: PK

stormPipeNetworkFileID¶: FK

stormPipeNetworkFile¶: RELATIONSHIP

superNodes¶: RELATIONSHIP

pipes¶: RELATIONSHIP

slinkNumber¶: INTEGER

numPipes¶: INTEGER

class gsshapy.orm.SuperNode(nodeNumber, groundSurfaceElev, invertElev, manholeSA, nodeInletCode, cellI, cellJ, weirSideLength, orificeDiameter)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Object containing data for a single super node in the subsurface drainage network. Super nodes belong to one super link.

tableName = u'spn_super_nodes'¶: Database tablename

id¶: PK

superLinkID¶: FK

superLink¶: RELATIONSHIP

nodeNumber¶: INTEGER

groundSurfaceElev¶: FLOAT

invertElev¶: FLOAT

manholeSA¶: FLOAT

nodeInletCode¶: INTEGER

cellI¶: INTEGER

cellJ¶: INTEGER

weirSideLength¶: FLOAT

orificeDiameter¶: FLOAT

class gsshapy.orm.Pipe(pipeNumber, xSecType, diameterOrHeight, width, slope, roughness, length, conductance, drainSpacing)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Object containing data for a single pipe in the subsurface drainage network. Pipes belong to one super link.

tableName = u'spn_pipes'¶: Database tablename

id¶: PK

superLinkID¶: FK

superLink¶: RELATIONSHIP

pipeNumber¶: INTEGER

xSecType¶: INTEGER

diameterOrHeight¶: FLOAT

width¶: FLOAT

slope¶: FLOAT

roughness¶: FLOAT

length¶: FLOAT

conductance¶: FLOAT

drainSpacing¶: FLOAT

class gsshapy.orm.SuperJunction(sjuncNumber, groundSurfaceElev, invertElev, manholeSA, inletCode, linkOrCellI, nodeOrCellJ, weirSideLength, orificeDiameter)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Object containing data for a single super junction in the subsurface drainage network. Super junctions are where two or more super links join or the unconnected end of a super link.

tableName = u'spn_super_junctions'¶: Database tablename

id¶: PK

stormPipeNetworkFileID¶: FK

stormPipeNetworkFile¶: RELATIONSHIP

sjuncNumber¶: INTEGER

groundSurfaceElev¶: FLOAT

invertElev¶: FLOAT

manholeSA¶: FLOAT

inletCode¶: INTEGER

linkOrCellI¶: INTEGER

nodeOrCellJ¶: INTEGER

weirSideLength¶: FLOAT

orificeDiameter¶: FLOAT

class gsshapy.orm.Connection(slinkNumber, upSjuncNumber, downSjuncNumber)[source]¶

Bases: sqlalchemy.ext.declarative.api.Base

Object containing data for a single connection in the subsurface drainage network. Connections between super links and super junctions are mapped via these records.

tableName = u'spn_connections'¶: Database tablename

id¶: PK

stormPipeNetworkFileID¶: FK

stormPipeNetworkFile¶: RELATIONSHIP

slinkNumber¶: INTEGER

upSjuncNumber¶: INTEGER

downSjuncNumber¶: INTEGER