swmm_vw_outfalls

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

name

varchar

√

null

invertelev

numeric

√

null

type

varchar

2147483647

√

null

stagedata

text

2147483647

√

null

tide_gate

varchar

2147483647

√

null

routeto

varchar

2147483647

√

null

description

text

2147483647

√

null

tag

varchar

2147483647

√

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 wn.obj_id AS name,
    COALESCE(wn.bottom_level, (0)::numeric) AS invertelev,
    'FREE'::character varying AS type,
    NULL::text AS stagedata,
    'NO'::character varying AS tide_gate,
    NULL::character varying AS routeto,
    ws.identifier AS description,
    (dp.obj_id)::character varying AS tag,
    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.discharge_point dp
     LEFT JOIN tww_od.wastewater_structure ws ON (((ws.obj_id)::text = (dp.obj_id)::text)))
     LEFT JOIN tww_od.wastewater_networkelement we ON (((we.fk_wastewater_structure)::text = (ws.obj_id)::text)))
     LEFT JOIN tww_od.wastewater_node wn ON (((wn.obj_id)::text = (we.obj_id)::text)))
     LEFT JOIN tww_vl.wastewater_structure_status ws_st ON ((ws.status = ws_st.code)))
     LEFT JOIN tww_vl.channel_function_hierarchic cfhi ON ((cfhi.code = wn._function_hierarchic)))
  WHERE ((wn.obj_id IS NOT NULL) AND (ws_st.vsacode = ANY (ARRAY[6530, 6533, 8493, 6529, 6526, 7959])))
UNION
 SELECT wn.obj_id AS name,
    COALESCE(wn.bottom_level, (0)::numeric) AS invertelev,
    'FREE'::character varying AS type,
    NULL::text AS stagedata,
    'NO'::character varying AS tide_gate,
    NULL::character varying AS routeto,
    ws.identifier AS description,
    (ii.obj_id)::character varying AS tag,
    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.infiltration_installation ii
     LEFT JOIN tww_od.wastewater_structure ws ON (((ws.obj_id)::text = (ii.obj_id)::text)))
     LEFT JOIN tww_od.wastewater_networkelement we ON (((we.fk_wastewater_structure)::text = (ws.obj_id)::text)))
     LEFT JOIN tww_od.wastewater_node wn ON (((wn.obj_id)::text = (we.obj_id)::text)))
     LEFT JOIN tww_vl.wastewater_structure_status ws_st ON ((ws.status = ws_st.code)))
     LEFT JOIN tww_vl.channel_function_hierarchic cfhi ON ((cfhi.code = wn._function_hierarchic)))
  WHERE ((wn.obj_id IS NOT NULL) 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