mvw_tww_channel

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

obj_id

varchar

√

null

bedding_encasement

int4

√

null

connection_type

int4

√

null

function_amelioration

int4

√

null

function_hierarchic

int4

√

null

function_hydraulic

int4

√

null

jetting_interval

numeric

4,2

√

null

pipe_length

numeric

7,2

√

null

seepage

int4

√

null

usage_current

int4

√

null

usage_planned

int4

√

null

ws_accessibility

int4

√

null

ws_condition_score

numeric

3,2

√

null

ws_contract_section

text

2147483647

√

null

ws_elevation_determination

int4

√

null

ws_financing

int4

√

null

ws_fk_main_wastewater_node

varchar

√

null

ws_fk_operator

varchar

√

null

ws_fk_owner

varchar

√

null

ws_gross_costs

numeric

10,2

√

null

ws_identifier

text

2147483647

√

null

ws_inspection_interval

numeric

4,2

√

null

ws_last_modification

timestamp

29,6

√

null

ws_location_name

text

2147483647

√

null

ws_records

text

2147483647

√

null

ws_remark

text

2147483647

√

null

ws_renovation_necessity

int4

√

null

ws_replacement_value

numeric

10,2

√

null

ws_rv_base_year

int2

√

null

ws_rv_construction_type

int4

√

null

ws_status

int4

√

null

ws_status_survey_year

int2

√

null

ws_structure_condition

int4

√

null

ws_subsidies

numeric

10,2

√

null

ws_urgency_figure

int2

√

null

ws_year_of_construction

int2

√

null

ws_year_of_replacement

int2

√

null

progression2d_geometry

geometry

2147483647

√

null

_re_min_height

int4

√

null

_re_max_height

int4

√

null

_re_length_effective

numeric

√

null

_re_materials

_varchar

2147483647

√

null

fk_reach_point_from

varchar

√

null

_from_ne

varchar

√

null

fk_reach_point_to

varchar

√

null

_to_ne

varchar

√

null

tww_is_primary

bool

√

null

Relationships

Close relationships within degrees of separation

View Definition

WITH channel_geometries AS (
         SELECT ch_1.obj_id,
            st_startpoint(st_linemerge(st_collect(st_force2d(re_1.progression3d_geometry)))) AS channel_start_point,
            st_endpoint(st_linemerge(st_collect(st_force2d(re_1.progression3d_geometry)))) AS channel_end_point
           FROM (((tww_od.channel ch_1
             JOIN tww_od.wastewater_structure ws_1 ON (((ch_1.obj_id)::text = (ws_1.obj_id)::text)))
             JOIN tww_od.wastewater_networkelement ne_1 ON (((ne_1.fk_wastewater_structure)::text = (ws_1.obj_id)::text)))
             JOIN tww_od.reach re_1 ON (((re_1.obj_id)::text = (ne_1.obj_id)::text)))
          GROUP BY ch_1.obj_id
        ), reach_start_end_points AS (
         SELECT re_1.obj_id,
            ne_1.fk_wastewater_structure,
            re_1.fk_reach_point_from,
            re_1.fk_reach_point_to,
            st_startpoint(st_force2d(re_1.progression3d_geometry)) AS reach_start_point,
            st_endpoint(st_force2d(re_1.progression3d_geometry)) AS reach_end_point
           FROM (tww_od.reach re_1
             JOIN tww_od.wastewater_networkelement ne_1 ON (((ne_1.obj_id)::text = (re_1.obj_id)::text)))
        ), rp_channel AS (
         SELECT cg.obj_id,
            rs.fk_reach_point_from,
            re_1.fk_reach_point_to
           FROM ((channel_geometries cg
             JOIN reach_start_end_points rs ON ((((rs.fk_wastewater_structure)::text = (cg.obj_id)::text) AND st_equals(rs.reach_start_point, cg.channel_start_point))))
             JOIN reach_start_end_points re_1 ON ((((re_1.fk_wastewater_structure)::text = (cg.obj_id)::text) AND st_equals(re_1.reach_end_point, cg.channel_end_point))))
        )
 SELECT ch.obj_id,
    ch.bedding_encasement,
    ch.connection_type,
    ch.function_amelioration,
    ch.function_hierarchic,
    ch.function_hydraulic,
    ch.jetting_interval,
    ch.pipe_length,
    ch.seepage,
    ch.usage_current,
    ch.usage_planned,
    ws.accessibility AS ws_accessibility,
    ws.condition_score AS ws_condition_score,
    ws.contract_section AS ws_contract_section,
    ws.elevation_determination AS ws_elevation_determination,
    ws.financing AS ws_financing,
    ws.fk_main_wastewater_node AS ws_fk_main_wastewater_node,
    ws.fk_operator AS ws_fk_operator,
    ws.fk_owner AS ws_fk_owner,
    ws.gross_costs AS ws_gross_costs,
    ws.identifier AS ws_identifier,
    ws.inspection_interval AS ws_inspection_interval,
    ws.last_modification AS ws_last_modification,
    ws.location_name AS ws_location_name,
    ws.records AS ws_records,
    ws.remark AS ws_remark,
    ws.renovation_necessity AS ws_renovation_necessity,
    ws.replacement_value AS ws_replacement_value,
    ws.rv_base_year AS ws_rv_base_year,
    ws.rv_construction_type AS ws_rv_construction_type,
    ws.status AS ws_status,
    ws.status_survey_year AS ws_status_survey_year,
    ws.structure_condition AS ws_structure_condition,
    ws.subsidies AS ws_subsidies,
    ws.urgency_figure AS ws_urgency_figure,
    ws.year_of_construction AS ws_year_of_construction,
    ws.year_of_replacement AS ws_year_of_replacement,
    (st_multi(st_force2d(st_forcecurve(st_linemerge(st_collect(st_curvetoline(re.progression3d_geometry)))))))::geometry(MultiCurve,2056) AS progression2d_geometry,
    min(re.clear_height) AS _re_min_height,
    max(re.clear_height) AS _re_max_height,
    sum(re.length_effective) AS _re_length_effective,
    array_agg(DISTINCT vl_mat.value_en) AS _re_materials,
    rpc.fk_reach_point_from,
    rp_from.fk_wastewater_networkelement AS _from_ne,
    rpc.fk_reach_point_to,
    rp_to.fk_wastewater_networkelement AS _to_ne,
    vl_fh.tww_is_primary
   FROM ((((((((tww_od.channel ch
     JOIN rp_channel rpc ON (((rpc.obj_id)::text = (ch.obj_id)::text)))
     LEFT JOIN tww_od.reach_point rp_from ON (((rp_from.obj_id)::text = (rpc.fk_reach_point_from)::text)))
     LEFT JOIN tww_od.reach_point rp_to ON (((rp_to.obj_id)::text = (rpc.fk_reach_point_to)::text)))
     LEFT JOIN tww_od.wastewater_structure ws ON (((ch.obj_id)::text = (ws.obj_id)::text)))
     LEFT JOIN tww_od.wastewater_networkelement ne ON (((ne.fk_wastewater_structure)::text = (ws.obj_id)::text)))
     LEFT JOIN tww_od.reach re ON (((ne.obj_id)::text = (re.obj_id)::text)))
     LEFT JOIN tww_vl.channel_function_hierarchic vl_fh ON ((vl_fh.code = ch.function_hierarchic)))
     LEFT JOIN tww_vl.reach_material vl_mat ON ((vl_mat.code = re.material)))
  GROUP BY ch.obj_id, ch.bedding_encasement, ch.connection_type, ch.function_amelioration, ch.function_hierarchic, ch.function_hydraulic, ch.jetting_interval, ch.pipe_length, ch.seepage, ch.usage_current, ch.usage_planned, ws.accessibility, ws.condition_score, ws.contract_section, ws.elevation_determination, ws.financing, ws.fk_main_wastewater_node, ws.fk_operator, ws.fk_owner, ws.gross_costs, ws.identifier, ws.inspection_interval, ws.last_modification, ws.location_name, ws.records, ws.remark, ws.renovation_necessity, ws.replacement_value, ws.rv_base_year, ws.rv_construction_type, ws.status, ws.status_survey_year, ws.structure_condition, ws.subsidies, ws.urgency_figure, ws.year_of_construction, ws.year_of_replacement, rpc.fk_reach_point_from, rp_from.fk_wastewater_networkelement, rpc.fk_reach_point_to, rp_to.fk_wastewater_networkelement, vl_fh.tww_is_primary;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views