vw_tww_damage_channel

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

obj_id

varchar

16

√

null

channel_damage_begin

int2

5

√

null

channel_damage_code

int4

10

√

null

channel_damage_end

int2

5

√

null

channel_distance

numeric

7,2

√

null

channel_quantification1

int4

10

√

null

channel_quantification2

int4

10

√

null

ws_identifier

text

2147483647

√

null

situation2d_geometry

geometry

2147483647

√

null

direction

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

WITH base AS (
         SELECT dc.obj_id,
            dc.channel_damage_begin,
            dc.channel_damage_code,
            dc.channel_damage_end,
            dc.channel_distance,
            dc.channel_quantification1,
            dc.channel_quantification2,
            ws.identifier AS ws_identifier,
            st_linemerge(st_collect(st_force2d(re.progression3d_geometry))) AS ch_progression2d_geometry,
                CASE
                    WHEN (re_2.obj_id IS NULL) THEN 'upstream'::text
                    ELSE 'downstream'::text
                END AS direction
           FROM ((((((((tww_od.damage_channel dc
             LEFT JOIN tww_od.damage da ON (((da.obj_id)::text = (dc.obj_id)::text)))
             LEFT JOIN tww_od.examination ex ON (((ex.obj_id)::text = (da.fk_examination)::text)))
             LEFT JOIN tww_od.re_maintenance_event_wastewater_structure mews ON (((mews.fk_maintenance_event)::text = (ex.obj_id)::text)))
             LEFT JOIN tww_od.wastewater_structure ws ON (((mews.fk_wastewater_structure)::text = (ws.obj_id)::text)))
             LEFT JOIN tww_od.wastewater_networkelement ne ON (((ws.obj_id)::text = (ne.fk_wastewater_structure)::text)))
             LEFT JOIN tww_od.reach re ON (((re.obj_id)::text = (ne.obj_id)::text)))
             LEFT JOIN tww_od.reach_point rp ON (((rp.obj_id)::text = (ex.fk_reach_point)::text)))
             LEFT JOIN tww_od.reach re_2 ON (((re_2.fk_reach_point_from)::text = (rp.obj_id)::text)))
          WHERE (ex.recording_type = 3686)
          GROUP BY dc.obj_id, dc.channel_damage_begin, dc.channel_damage_code, dc.channel_damage_end, dc.channel_distance, dc.channel_quantification1, dc.channel_quantification2, ws.identifier, re_2.obj_id
        )
 SELECT obj_id,
    channel_damage_begin,
    channel_damage_code,
    channel_damage_end,
    channel_distance,
    channel_quantification1,
    channel_quantification2,
    ws_identifier,
    st_lineinterpolatepoint(ch_progression2d_geometry,
        CASE
            WHEN (direction = 'downstream'::text) THEN LEAST(((channel_distance)::double precision / st_length(ch_progression2d_geometry)), (1)::double precision)
            ELSE ((1)::double precision - LEAST(((channel_distance)::double precision / st_length(ch_progression2d_geometry)), (1)::double precision))
        END) AS situation2d_geometry,
    direction
   FROM base;

vw_tww_damage_channel

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views