swmm_vw_raingages

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

name

varchar

2147483647

√

null

format

varchar

2147483647

√

null

interval

varchar

2147483647

√

null

scf

varchar

2147483647

√

null

source

varchar

2147483647

√

null

geom

geometry

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 (ROW('raingage@', replace((obj_id)::text, ' '::text, '_'::text), '_', state))::character varying AS name,
    'INTENSITY'::character varying AS format,
    '0:15'::character varying AS "interval",
    '1.0'::character varying AS scf,
    'TIMESERIES default_tww_raingage_timeserie'::character varying AS source,
    (st_centroid(perimeter_geometry))::geometry(Point,2056) AS geom,
    state,
        CASE
            WHEN (_function_hierarchic = ANY (ARRAY[5062, 5064, 5066, 5068, 5069, 5070, 5071, 5072, 5074])) THEN 'primary'::text
            ELSE 'secondary'::text
        END AS hierarchy,
    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
         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)
        UNION
         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_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
         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_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