swmm_vw_dwf

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

node

varchar

2147483647

√

null

constituent

varchar

2147483647

√

null

baseline

float8

17,17

√

null

patterns

varchar

2147483647

√

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
        CASE
            WHEN (ca.type_ca = 'rw_current'::text) THEN ca.fk_wastewater_networkelement_rw_current
            WHEN (ca.type_ca = 'rw_planned'::text) THEN ca.fk_wastewater_networkelement_rw_planned
            WHEN (ca.type_ca = 'ww_current'::text) THEN ca.fk_wastewater_networkelement_ww_current
            WHEN (ca.type_ca = 'ww_planned'::text) THEN ca.fk_wastewater_networkelement_ww_planned
            ELSE NULL::character varying
        END AS node,
    'FLOW'::character varying AS constituent,
        CASE
            WHEN (ca.fk_wastewater_networkelement_ww_current IS NOT NULL) THEN
            CASE
                WHEN (ca.waste_water_production_current IS NOT NULL) THEN (ca.waste_water_production_current)::double precision
                ELSE
                CASE
                    WHEN ((ca.surface_area IS NOT NULL) AND (ca.surface_area <> (0)::numeric)) THEN (((((COALESCE((ca.population_density_current)::integer, 0))::numeric * ca.surface_area) * (160)::numeric) / (((24 * 60) * 60))::numeric))::double precision
                    ELSE (((((COALESCE((ca.population_density_current)::integer, 0))::double precision * st_area(ca.perimeter_geometry)) / (10000)::double precision) * (160)::double precision) / (((24 * 60) * 60))::double precision)
                END
            END
            WHEN (ca.fk_wastewater_networkelement_ww_planned IS NOT NULL) THEN
            CASE
                WHEN (ca.waste_water_production_planned IS NOT NULL) THEN (ca.waste_water_production_planned)::double precision
                ELSE
                CASE
                    WHEN ((ca.surface_area IS NOT NULL) AND (ca.surface_area <> (0)::numeric)) THEN (((((COALESCE((ca.population_density_planned)::integer, 0))::numeric * ca.surface_area) * (160)::numeric) / (((24 * 60) * 60))::numeric))::double precision
                    ELSE (((((COALESCE((ca.population_density_planned)::integer, 0))::double precision * st_area(ca.perimeter_geometry)) / (10000)::double precision) * (160)::double precision) / (((24 * 60) * 60))::double precision)
                END
            END
            WHEN (ca.fk_wastewater_networkelement_rw_current IS NOT NULL) THEN (0)::double precision
            WHEN (ca.fk_wastewater_networkelement_rw_planned IS NOT NULL) THEN (0)::double precision
            ELSE NULL::double precision
        END AS baseline,
    'dailyPatternDWF'::character varying AS patterns,
    ca.state,
        CASE
            WHEN (ca._function_hierarchic = ANY (ARRAY[5062, 5064, 5066, 5068, 5069, 5070, 5071, 5072, 5074])) THEN 'primary'::text
            ELSE 'secondary'::text
        END AS hierarchy,
    ca.wn_obj_id AS obj_id
   FROM ( SELECT ca_1.obj_id,
            ca_1.direct_discharge_current,
            ca_1.direct_discharge_planned,
            ca_1.discharge_coefficient_rw_current,
            ca_1.discharge_coefficient_rw_planned,
            ca_1.discharge_coefficient_ww_current,
            ca_1.discharge_coefficient_ww_planned,
            ca_1.drainage_system_current,
            ca_1.drainage_system_planned,
            ca_1.identifier,
            ca_1.infiltration_current,
            ca_1.infiltration_planned,
            ca_1.perimeter_geometry,
            ca_1.population_density_current,
            ca_1.population_density_planned,
            ca_1.remark,
            ca_1.retention_current,
            ca_1.retention_planned,
            ca_1.runoff_limit_current,
            ca_1.runoff_limit_planned,
            ca_1.seal_factor_rw_current,
            ca_1.seal_factor_rw_planned,
            ca_1.seal_factor_ww_current,
            ca_1.seal_factor_ww_planned,
            ca_1.sewer_infiltration_water_production_current,
            ca_1.sewer_infiltration_water_production_planned,
            ca_1.surface_area,
            ca_1.waste_water_production_current,
            ca_1.waste_water_production_planned,
            ca_1.last_modification,
            ca_1.fk_dataowner,
            ca_1.fk_provider,
            ca_1.fk_wastewater_networkelement_rw_current,
            ca_1.fk_wastewater_networkelement_rw_planned,
            ca_1.fk_wastewater_networkelement_ww_planned,
            ca_1.fk_wastewater_networkelement_ww_current,
            ca_1.fk_special_building_rw_planned,
            ca_1.fk_special_building_rw_current,
            ca_1.fk_special_building_ww_planned,
            ca_1.fk_special_building_ww_current,
            'current'::text AS state,
            'rw_current'::text AS type_ca,
            wn.obj_id AS wn_obj_id,
            cfhi.vsacode AS _function_hierarchic
           FROM ((((tww_od.catchment_area ca_1
             LEFT JOIN tww_od.wastewater_networkelement ne ON (((ne.obj_id)::text = (ca_1.fk_wastewater_networkelement_rw_current)::text)))
             LEFT JOIN tww_od.wastewater_node wn ON (((wn.obj_id)::text = (ne.obj_id)::text)))
             LEFT JOIN tww_od.wastewater_structure ws ON (((ws.obj_id)::text = (ne.fk_wastewater_structure)::text)))
             LEFT JOIN tww_vl.channel_function_hierarchic cfhi ON ((cfhi.code = wn._function_hierarchic)))
          WHERE (ca_1.fk_wastewater_networkelement_rw_current IS NOT NULL)
        UNION ALL
         SELECT ca_1.obj_id,
            ca_1.direct_discharge_current,
            ca_1.direct_discharge_planned,
            ca_1.discharge_coefficient_rw_current,
            ca_1.discharge_coefficient_rw_planned,
            ca_1.discharge_coefficient_ww_current,
            ca_1.discharge_coefficient_ww_planned,
            ca_1.drainage_system_current,
            ca_1.drainage_system_planned,
            ca_1.identifier,
            ca_1.infiltration_current,
            ca_1.infiltration_planned,
            ca_1.perimeter_geometry,
            ca_1.population_density_current,
            ca_1.population_density_planned,
            ca_1.remark,
            ca_1.retention_current,
            ca_1.retention_planned,
            ca_1.runoff_limit_current,
            ca_1.runoff_limit_planned,
            ca_1.seal_factor_rw_current,
            ca_1.seal_factor_rw_planned,
            ca_1.seal_factor_ww_current,
            ca_1.seal_factor_ww_planned,
            ca_1.sewer_infiltration_water_production_current,
            ca_1.sewer_infiltration_water_production_planned,
            ca_1.surface_area,
            ca_1.waste_water_production_current,
            ca_1.waste_water_production_planned,
            ca_1.last_modification,
            ca_1.fk_dataowner,
            ca_1.fk_provider,
            ca_1.fk_wastewater_networkelement_rw_current,
            ca_1.fk_wastewater_networkelement_rw_planned,
            ca_1.fk_wastewater_networkelement_ww_planned,
            ca_1.fk_wastewater_networkelement_ww_current,
            ca_1.fk_special_building_rw_planned,
            ca_1.fk_special_building_rw_current,
            ca_1.fk_special_building_ww_planned,
            ca_1.fk_special_building_ww_current,
            'planned'::text AS state,
            'rw_planned'::text AS type_ca,
            wn.obj_id AS wn_obj_id,
            cfhi.vsacode AS _function_hierarchic
           FROM ((((tww_od.catchment_area ca_1
             LEFT JOIN tww_od.wastewater_networkelement ne ON (((ne.obj_id)::text = (ca_1.fk_wastewater_networkelement_rw_planned)::text)))
             LEFT JOIN tww_od.wastewater_node wn ON (((wn.obj_id)::text = (ne.obj_id)::text)))
             LEFT JOIN tww_od.wastewater_structure ws ON (((ws.obj_id)::text = (ne.fk_wastewater_structure)::text)))
             LEFT JOIN tww_vl.channel_function_hierarchic cfhi ON ((cfhi.code = wn._function_hierarchic)))
          WHERE (ca_1.fk_wastewater_networkelement_rw_planned IS NOT NULL)
        UNION ALL
         SELECT ca_1.obj_id,
            ca_1.direct_discharge_current,
            ca_1.direct_discharge_planned,
            ca_1.discharge_coefficient_rw_current,
            ca_1.discharge_coefficient_rw_planned,
            ca_1.discharge_coefficient_ww_current,
            ca_1.discharge_coefficient_ww_planned,
            ca_1.drainage_system_current,
            ca_1.drainage_system_planned,
            ca_1.identifier,
            ca_1.infiltration_current,
            ca_1.infiltration_planned,
            ca_1.perimeter_geometry,
            ca_1.population_density_current,
            ca_1.population_density_planned,
            ca_1.remark,
            ca_1.retention_current,
            ca_1.retention_planned,
            ca_1.runoff_limit_current,
            ca_1.runoff_limit_planned,
            ca_1.seal_factor_rw_current,
            ca_1.seal_factor_rw_planned,
            ca_1.seal_factor_ww_current,
            ca_1.seal_factor_ww_planned,
            ca_1.sewer_infiltration_water_production_current,
            ca_1.sewer_infiltration_water_production_planned,
            ca_1.surface_area,
            ca_1.waste_water_production_current,
            ca_1.waste_water_production_planned,
            ca_1.last_modification,
            ca_1.fk_dataowner,
            ca_1.fk_provider,
            ca_1.fk_wastewater_networkelement_rw_current,
            ca_1.fk_wastewater_networkelement_rw_planned,
            ca_1.fk_wastewater_networkelement_ww_planned,
            ca_1.fk_wastewater_networkelement_ww_current,
            ca_1.fk_special_building_rw_planned,
            ca_1.fk_special_building_rw_current,
            ca_1.fk_special_building_ww_planned,
            ca_1.fk_special_building_ww_current,
            'current'::text AS state,
            'ww_current'::text AS type_ca,
            wn.obj_id AS wn_obj_id,
            cfhi.vsacode AS _function_hierarchic
           FROM ((((tww_od.catchment_area ca_1
             LEFT JOIN tww_od.wastewater_networkelement ne ON (((ne.obj_id)::text = (ca_1.fk_wastewater_networkelement_ww_current)::text)))
             LEFT JOIN tww_od.wastewater_node wn ON (((wn.obj_id)::text = (ne.obj_id)::text)))
             LEFT JOIN tww_od.wastewater_structure ws ON (((ws.obj_id)::text = (ne.fk_wastewater_structure)::text)))
             LEFT JOIN tww_vl.channel_function_hierarchic cfhi ON ((cfhi.code = wn._function_hierarchic)))
          WHERE (ca_1.fk_wastewater_networkelement_ww_current IS NOT NULL)
        UNION ALL
         SELECT ca_1.obj_id,
            ca_1.direct_discharge_current,
            ca_1.direct_discharge_planned,
            ca_1.discharge_coefficient_rw_current,
            ca_1.discharge_coefficient_rw_planned,
            ca_1.discharge_coefficient_ww_current,
            ca_1.discharge_coefficient_ww_planned,
            ca_1.drainage_system_current,
            ca_1.drainage_system_planned,
            ca_1.identifier,
            ca_1.infiltration_current,
            ca_1.infiltration_planned,
            ca_1.perimeter_geometry,
            ca_1.population_density_current,
            ca_1.population_density_planned,
            ca_1.remark,
            ca_1.retention_current,
            ca_1.retention_planned,
            ca_1.runoff_limit_current,
            ca_1.runoff_limit_planned,
            ca_1.seal_factor_rw_current,
            ca_1.seal_factor_rw_planned,
            ca_1.seal_factor_ww_current,
            ca_1.seal_factor_ww_planned,
            ca_1.sewer_infiltration_water_production_current,
            ca_1.sewer_infiltration_water_production_planned,
            ca_1.surface_area,
            ca_1.waste_water_production_current,
            ca_1.waste_water_production_planned,
            ca_1.last_modification,
            ca_1.fk_dataowner,
            ca_1.fk_provider,
            ca_1.fk_wastewater_networkelement_rw_current,
            ca_1.fk_wastewater_networkelement_rw_planned,
            ca_1.fk_wastewater_networkelement_ww_planned,
            ca_1.fk_wastewater_networkelement_ww_current,
            ca_1.fk_special_building_rw_planned,
            ca_1.fk_special_building_rw_current,
            ca_1.fk_special_building_ww_planned,
            ca_1.fk_special_building_ww_current,
            'planned'::text AS state,
            'ww_planned'::text AS type_ca,
            wn.obj_id AS wn_obj_id,
            cfhi.vsacode AS _function_hierarchic
           FROM ((((tww_od.catchment_area ca_1
             LEFT JOIN tww_od.wastewater_networkelement ne ON (((ne.obj_id)::text = (ca_1.fk_wastewater_networkelement_ww_planned)::text)))
             LEFT JOIN tww_od.wastewater_node wn ON (((wn.obj_id)::text = (ne.obj_id)::text)))
             LEFT JOIN tww_od.wastewater_structure ws ON (((ws.obj_id)::text = (ne.fk_wastewater_structure)::text)))
             LEFT JOIN tww_vl.channel_function_hierarchic cfhi ON ((cfhi.code = wn._function_hierarchic)))
          WHERE (ca_1.fk_wastewater_networkelement_ww_planned IS NOT NULL)) ca;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views