swmm_vw_curves

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

name

varchar

2147483647

√

null

type

text

2147483647

√

null

xvalue

numeric

0

√

null

yvalue

numeric

0

√

null

state

text

2147483647

√

null

hierarchy

text

2147483647

√

null

obj_id

varchar

16

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

( SELECT (concat('pump_curve@', pu.obj_id))::character varying AS name,
        CASE
            WHEN (row_number() OVER (PARTITION BY pu.obj_id ORDER BY pu.obj_id, hq.altitude) = 1) THEN 'Pump4'::text
            ELSE NULL::text
        END AS type,
    hq.altitude AS xvalue,
    hq.flow AS yvalue,
        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.hq_relation hq
     LEFT JOIN tww_od.overflow_char oc ON (((hq.fk_overflow_char)::text = (oc.obj_id)::text)))
     LEFT JOIN tww_vl.overflow_char_kind_overflow_char vl_oc_ki ON ((oc.kind_overflow_char = vl_oc_ki.code)))
     LEFT JOIN tww_od.overflow of ON (((of.fk_overflow_char)::text = (oc.obj_id)::text)))
     LEFT JOIN tww_od.pump pu ON (((pu.obj_id)::text = (of.obj_id)::text)))
     LEFT JOIN tww_od.wastewater_node wn ON (((wn.obj_id)::text = (of.fk_wastewater_node)::text)))
     LEFT JOIN tww_od.wastewater_structure ws ON (((ws.fk_main_wastewater_node)::text = (wn.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 ((ws_st.vsacode = ANY (ARRAY[6530, 6533, 8493, 6529, 6526, 7959])) AND (vl_oc_ki.vsacode = 6220) AND (pu.obj_id IS NOT NULL))
  ORDER BY pu.obj_id, hq.altitude)
UNION ALL
( SELECT (concat('prank_weir_curve@', pw.obj_id))::character varying AS name,
        CASE
            WHEN (row_number() OVER (PARTITION BY pw.obj_id ORDER BY pw.obj_id, hq.altitude) = 1) THEN 'Rating'::text
            ELSE NULL::text
        END AS type,
    hq.altitude AS xvalue,
    hq.flow AS yvalue,
        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.hq_relation hq
     LEFT JOIN tww_od.overflow_char oc ON (((hq.fk_overflow_char)::text = (oc.obj_id)::text)))
     LEFT JOIN tww_vl.overflow_char_kind_overflow_char vl_oc_ki ON ((oc.kind_overflow_char = vl_oc_ki.code)))
     LEFT JOIN tww_od.overflow of ON (((of.fk_overflow_char)::text = (oc.obj_id)::text)))
     LEFT JOIN tww_od.prank_weir pw ON (((pw.obj_id)::text = (of.obj_id)::text)))
     LEFT JOIN tww_od.wastewater_node wn ON (((wn.obj_id)::text = (of.fk_wastewater_node)::text)))
     LEFT JOIN tww_od.wastewater_structure ws ON (((ws.fk_main_wastewater_node)::text = (wn.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 ((ws_st.vsacode = ANY (ARRAY[6530, 6533, 8493, 6529, 6526, 7959])) AND (vl_oc_ki.vsacode = 6220) AND (pw.obj_id IS NOT NULL))
  ORDER BY pw.obj_id, hq.altitude)
UNION ALL
( SELECT (concat('storageCurve@', wn.obj_id))::character varying AS name,
        CASE
            WHEN (row_number() OVER (PARTITION BY wn.obj_id ORDER BY wn.obj_id, hr.water_depth) = 1) THEN 'Storage'::text
            ELSE NULL::text
        END AS type,
    hr.water_depth AS xvalue,
    hr.water_surface AS yvalue,
        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.hydr_geom_relation hr
     LEFT JOIN tww_od.hydr_geometry hg ON (((hg.obj_id)::text = (hr.fk_hydr_geometry)::text)))
     LEFT JOIN tww_od.wastewater_node wn ON (((hg.obj_id)::text = (wn.fk_hydr_geometry)::text)))
     LEFT JOIN tww_od.wastewater_structure ws ON (((ws.fk_main_wastewater_node)::text = (wn.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)))
  ORDER BY wn.obj_id, hr.water_depth);

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views