mvw_catchment_area_totals

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

_obj_id

varchar

16

√

null

fk_log_card

varchar

16

√

null

perimeter_geometry

geometry

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT cat.obj_id AS _obj_id,
    lc.obj_id AS fk_log_card,
    ca_agg.perimeter_geometry
   FROM ((((tww_od.catchment_area_totals cat
     LEFT JOIN tww_od.hydraulic_char_data hc_c ON ((((hc_c.obj_id)::text = (cat.fk_hydraulic_char_data)::text) AND (hc_c.status = 6372))))
     LEFT JOIN tww_od.wastewater_node wn ON (((hc_c.fk_wastewater_node)::text = (wn.obj_id)::text)))
     LEFT JOIN tww_od.log_card lc ON (((lc.fk_pwwf_wastewater_node)::text = (wn.obj_id)::text)))
     LEFT JOIN ( WITH ca AS (
                 SELECT catchment_area.fk_special_building_ww_current AS fk_log_card,
                    catchment_area.perimeter_geometry AS geom
                   FROM tww_od.catchment_area
                  WHERE (catchment_area.fk_special_building_ww_current IS NOT NULL)
                UNION
                 SELECT catchment_area.fk_special_building_rw_current AS fk_log_card,
                    catchment_area.perimeter_geometry AS geom
                   FROM tww_od.catchment_area
                  WHERE (catchment_area.fk_special_building_rw_current IS NOT NULL)
                ), collector AS (
                 SELECT COALESCE(main_lc.obj_id, lc_1.obj_id) AS obj_id,
                    ca.geom
                   FROM ((ca
                     LEFT JOIN tww_od.log_card lc_1 ON (((ca.fk_log_card)::text = (lc_1.obj_id)::text)))
                     LEFT JOIN tww_od.log_card main_lc ON (((main_lc.obj_id)::text = (lc_1.fk_main_structure)::text)))
                )
         SELECT collector.obj_id,
            st_unaryunion(st_collect(collector.geom)) AS perimeter_geometry
           FROM collector
          GROUP BY collector.obj_id) ca_agg ON (((ca_agg.obj_id)::text = (lc.obj_id)::text)));

mvw_catchment_area_totals

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views