vw_catchment_area_diverted

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

_id

int8

19

√

null

fk_log_card_current

varchar

16

√

null

fk_log_card_planned

varchar

16

√

null

_type

text

2147483647

√

null

geom

geometry

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT row_number() OVER () AS _id,
    fk_log_card_current,
    fk_log_card_planned,
    _type,
    geom
   FROM ( SELECT catchment_area.fk_special_building_ww_current AS fk_log_card_current,
            catchment_area.fk_special_building_ww_planned AS fk_log_card_planned,
            'ww'::text AS _type,
            st_unaryunion(st_collect(catchment_area.perimeter_geometry)) AS geom
           FROM tww_od.catchment_area
          WHERE ((catchment_area.fk_special_building_ww_current)::text <> (catchment_area.fk_special_building_ww_planned)::text)
          GROUP BY catchment_area.fk_special_building_ww_current, catchment_area.fk_special_building_ww_planned
        UNION ALL
         SELECT catchment_area.fk_special_building_rw_current AS fk_log_card_current,
            catchment_area.fk_special_building_rw_planned AS fk_log_card_planned,
            'rw'::text AS _type,
            st_unaryunion(st_collect(catchment_area.perimeter_geometry)) AS geom
           FROM tww_od.catchment_area
          WHERE ((catchment_area.fk_special_building_rw_current)::text <> (catchment_area.fk_special_building_rw_planned)::text)
          GROUP BY catchment_area.fk_special_building_rw_current, catchment_area.fk_special_building_rw_planned) agg;

vw_catchment_area_diverted

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views