swmm_vw_infiltration

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

subcatchment

text

2147483647

√

null

maxrate

int4

10

√

null

minrate

numeric

0

√

null

decay

int4

10

√

null

drytime

int4

10

√

null

maxinfil

int4

10

√

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.state = 'current'::text) THEN concat(replace((ca.obj_id)::text, ' '::text, '_'::text), '_', 'rw_current')
            WHEN (ca.state = 'planned'::text) THEN concat(replace((ca.obj_id)::text, ' '::text, '_'::text), '_', 'rw_planned')
            ELSE NULL::text
        END AS subcatchment,
    3 AS maxrate,
    0.5 AS minrate,
    4 AS decay,
    7 AS drytime,
    0 AS maxinfil,
    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,
            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,
            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)) ca;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views