swmm_vw_subareas

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

subcatchment

text

2147483647

√

null

nimperv

numeric

√

null

nperv

numeric

√

null

simperv

numeric

√

null

sperv

numeric

√

null

pctzero

int4

√

null

routeto

varchar

2147483647

√

null

pctrouted

float8

17,17

√

null

description

text

2147483647

√

null

tag

varchar

2147483647

√

null

state

text

2147483647

√

null

hierarchy

text

2147483647

√

null

obj_id

varchar

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT concat(replace((ca.obj_id)::text, ' '::text, '_'::text), '_', ca.state) AS subcatchment,
    0.01 AS nimperv,
    0.1 AS nperv,
        CASE
            WHEN (ca.surface_storage IS NOT NULL) THEN ca.surface_storage
            ELSE 0.05
        END AS simperv,
        CASE
            WHEN (ca.surface_storage IS NOT NULL) THEN ca.surface_storage
            ELSE 0.05
        END AS sperv,
    25 AS pctzero,
    'OUTLET'::character varying AS routeto,
    NULL::double precision AS pctrouted,
    ca.identifier AS description,
    (ca.obj_id)::character varying AS tag,
    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,
            sr.surface_storage,
            'rw_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.surface_runoff_parameters sr ON (((ca_1.obj_id)::text = (sr.fk_catchment_area)::text)))
             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,
            sr.surface_storage,
            'ww_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.surface_runoff_parameters sr ON (((ca_1.obj_id)::text = (sr.fk_catchment_area)::text)))
             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,
            sr.surface_storage,
            'rw_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.surface_runoff_parameters sr ON (((ca_1.obj_id)::text = (sr.fk_catchment_area)::text)))
             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,
            sr.surface_storage,
            'ww_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.surface_runoff_parameters sr ON (((ca_1.obj_id)::text = (sr.fk_catchment_area)::text)))
             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