swmm_vw_dividers

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

name

varchar

√

null

elevation

numeric

√

null

diverted_link

text

2147483647

√

null

type

text

2147483647

√

null

cutoffflow

int4

√

null

maxdepth

int4

√

null

initialdepth

int4

√

null

surchargedepth

int4

√

null

pondedarea

int4

√

null

geom

geometry

2147483647

√

null

state

text

2147483647

√

null

hierarchy

text

2147483647

√

null

obj_id

varchar

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT ma.obj_id AS name,
    COALESCE(wn.bottom_level, (0)::numeric) AS elevation,
    '???'::text AS diverted_link,
    'CUTOFF'::text AS type,
    0 AS cutoffflow,
    0 AS maxdepth,
    0 AS initialdepth,
    0 AS surchargedepth,
    0 AS pondedarea,
    wn.situation3d_geometry AS geom,
        CASE
            WHEN (ws_st.vsacode = ANY (ARRAY[7959, 6529, 6526])) THEN 'planned'::text
            ELSE 'current'::text
        END AS state,
        CASE
            WHEN (cfhi.vsacode = ANY (ARRAY[5062, 5064, 5066, 5068, 5069, 5070, 5071, 5072, 5074])) THEN 'primary'::text
            ELSE 'secondary'::text
        END AS hierarchy,
    wn.obj_id
   FROM (((((((tww_od.manhole ma
     LEFT JOIN tww_od.wastewater_structure ws ON (((ws.obj_id)::text = (ma.obj_id)::text)))
     LEFT JOIN tww_vl.wastewater_structure_status ws_st ON ((ws.status = ws_st.code)))
     LEFT JOIN tww_od.wastewater_networkelement ne ON (((ne.fk_wastewater_structure)::text = (ws.obj_id)::text)))
     LEFT JOIN tww_od.wastewater_node wn ON (((wn.obj_id)::text = (ne.obj_id)::text)))
     LEFT JOIN tww_vl.channel_function_hierarchic cfhi ON ((cfhi.code = wn._function_hierarchic)))
     LEFT JOIN tww_od.cover co ON (((ws.fk_main_cover)::text = (co.obj_id)::text)))
     LEFT JOIN tww_vl.manhole_function mf ON ((ma.function = mf.code)))
  WHERE ((mf.vsacode = 4798) AND (ws_st.vsacode = ANY (ARRAY[6530, 6533, 8493, 6529, 6526, 7959])))
UNION ALL
 SELECT ss.obj_id AS name,
    COALESCE(wn.bottom_level, (0)::numeric) AS elevation,
    '???'::text AS diverted_link,
    'CUTOFF'::text AS type,
    0 AS cutoffflow,
    0 AS maxdepth,
    0 AS initialdepth,
    0 AS surchargedepth,
    0 AS pondedarea,
    wn.situation3d_geometry AS geom,
        CASE
            WHEN (ws_st.vsacode = ANY (ARRAY[7959, 6529, 6526])) THEN 'planned'::text
            ELSE 'current'::text
        END AS state,
        CASE
            WHEN (cfhi.vsacode = ANY (ARRAY[5062, 5064, 5066, 5068, 5069, 5070, 5071, 5072, 5074])) THEN 'primary'::text
            ELSE 'secondary'::text
        END AS hierarchy,
    wn.obj_id
   FROM (((((((tww_od.special_structure ss
     LEFT JOIN tww_od.wastewater_structure ws ON (((ws.obj_id)::text = (ss.obj_id)::text)))
     LEFT JOIN tww_vl.wastewater_structure_status ws_st ON ((ws.status = ws_st.code)))
     LEFT JOIN tww_od.wastewater_networkelement ne ON (((ne.fk_wastewater_structure)::text = (ws.obj_id)::text)))
     LEFT JOIN tww_od.wastewater_node wn ON (((wn.obj_id)::text = (ne.obj_id)::text)))
     LEFT JOIN tww_vl.channel_function_hierarchic cfhi ON ((cfhi.code = wn._function_hierarchic)))
     LEFT JOIN tww_od.cover co ON (((ws.fk_main_cover)::text = (co.obj_id)::text)))
     LEFT JOIN tww_vl.special_structure_function ssf ON ((ss.function = ssf.code)))
  WHERE ((ssf.vsacode = 4799) AND (ws_st.vsacode = ANY (ARRAY[6530, 6533, 8493, 6529, 6526, 7959])));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views