vw_sign_symbol

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

text

2147483647

√

null

uuid

2147483647

√

null

_inserted_date

timestamp

29,6

√

null

_inserted_user

text

2147483647

√

null

_last_modified_date

timestamp

29,6

√

null

_last_modified_user

text

2147483647

√

null

case_decision

text

2147483647

√

null

case_id

text

2147483647

√

null

comment

text

2147483647

√

null

complex

bool

√

null

dimension_1

numeric

8,3

√

null

dimension_2

numeric

8,3

√

null

fk_coating

int4

√

null

fk_durability

int4

√

null

fk_lighting

int4

√

null

fk_marker_type

text

2147483647

√

null

fk_mirror_shape

int4

√

null

fk_official_sign

text

2147483647

√

null

fk_owner

uuid

2147483647

√

null

fk_parent

uuid

2147483647

√

null

fk_provider

uuid

2147483647

√

null

fk_sign_type

int4

√

null

fk_status

int4

√

null

fk_user_sign

uuid

2147483647

√

null

hanging_mode

"signalo_db"."sign_hanging"

2147483647

√

null

inscription_1

text

2147483647

√

null

inscription_2

text

2147483647

√

null

inscription_3

text

2147483647

√

null

installation_date

date

√

null

manufacturing_date

date

√

null

mirror_protruding

bool

√

null

mirror_red_frame

bool

√

null

natural_direction_or_left

bool

√

null

picture

text

2147483647

√

null

usr_sign_1

text

2147483647

√

null

usr_sign_2

text

2147483647

√

null

usr_sign_3

text

2147483647

√

null

azimut

int2

√

null

offset_x

int4

√

null

offset_y

int4

√

null

offset_x_verso

int4

√

null

offset_y_verso

int4

√

null

frame_id

uuid

2147483647

√

null

frame__inserted_date

timestamp

29,6

√

null

frame__inserted_user

text

2147483647

√

null

frame__last_modified_date

timestamp

29,6

√

null

frame__last_modified_user

text

2147483647

√

null

frame_anchor

"signalo_db"."anchor"

2147483647

√

null

frame_comment

text

2147483647

√

null

frame_dimension_1

numeric

8,3

√

null

frame_dimension_2

numeric

8,3

√

null

frame_double_sided

bool

√

null

frame_fk_azimut

uuid

2147483647

√

null

frame_fk_frame_fixing_type

int4

√

null

frame_fk_frame_type

int4

√

null

frame_fk_provider

uuid

2147483647

√

null

frame_fk_status

int4

√

null

frame_picture

text

2147483647

√

null

frame_rank

int4

√

null

frame_usr_frame_1

text

2147483647

√

null

frame_usr_frame_2

text

2147483647

√

null

frame_usr_frame_3

text

2147483647

√

null

sign_rank

int4

√

null

support_id

uuid

2147483647

√

null

group_by_anchor

bool

√

null

fk_support_type

int4

√

null

fk_support_base_type

int4

√

null

support_geometry

geometry

2147483647

√

null

directional_sign

bool

√

null

_symbol_value_de

text

2147483647

√

null

_symbol_value_fr

text

2147483647

√

null

_symbol_value_it

text

2147483647

√

null

_symbol_value_ro

text

2147483647

√

null

_img_de

text

2147483647

√

null

_img_fr

text

2147483647

√

null

_img_it

text

2147483647

√

null

_img_ro

text

2147483647

√

null

_img_de_right

text

2147483647

√

null

_img_fr_right

text

2147483647

√

null

_img_it_right

text

2147483647

√

null

_img_ro_right

text

2147483647

√

null

_symbol_height

int4

√

null

_symbol_width

int4

√

null

_azimut_rectified

int4

√

null

_azimut_offset_x_rectified

int4

√

null

_azimut_offset_y_rectified

int4

√

null

_natural_direction_or_left_rectified

bool

√

null

_verso

bool

√

null

_rank

int8

√

null

_final_rank

int8

√

null

_symbol_shift

int8

√

null

_group_height

int8

√

null

_group_width

int4

√

null

_previous_sign_in_frame

uuid

2147483647

√

null

_next_sign_in_frame

uuid

2147483647

√

null

_previous_frame

uuid

2147483647

√

null

_next_frame

uuid

2147483647

√

null

_max_shift_for_azimut

int8

√

null

_img_direction

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

WITH joined_tables AS (
         SELECT sign.id,
            sign._inserted_date,
            sign._inserted_user,
            sign._last_modified_date,
            sign._last_modified_user,
            sign.case_decision,
            sign.case_id,
            sign.comment,
            sign.complex,
            sign.dimension_1,
            sign.dimension_2,
            sign.fk_coating,
            sign.fk_durability,
            sign.fk_lighting,
            sign.fk_marker_type,
            sign.fk_mirror_shape,
            sign.fk_official_sign,
            sign.fk_owner,
            sign.fk_parent,
            sign.fk_provider,
            sign.fk_sign_type,
            sign.fk_status,
            sign.fk_user_sign,
            sign.hanging_mode,
            sign.inscription_1,
            sign.inscription_2,
            sign.inscription_3,
            sign.installation_date,
            sign.manufacturing_date,
            sign.mirror_protruding,
            sign.mirror_red_frame,
            sign.natural_direction_or_left,
            sign.picture,
            sign.usr_sign_1,
            sign.usr_sign_2,
            sign.usr_sign_3,
            azimut.azimut,
            azimut.offset_x,
            azimut.offset_y,
            azimut.offset_x_verso,
            azimut.offset_y_verso,
            frame.id AS frame_id,
            frame._inserted_date AS frame__inserted_date,
            frame._inserted_user AS frame__inserted_user,
            frame._last_modified_date AS frame__last_modified_date,
            frame._last_modified_user AS frame__last_modified_user,
            frame.anchor AS frame_anchor,
            frame.comment AS frame_comment,
            frame.dimension_1 AS frame_dimension_1,
            frame.dimension_2 AS frame_dimension_2,
            frame.double_sided AS frame_double_sided,
            frame.fk_azimut AS frame_fk_azimut,
            frame.fk_frame_fixing_type AS frame_fk_frame_fixing_type,
            frame.fk_frame_type AS frame_fk_frame_type,
            frame.fk_provider AS frame_fk_provider,
            frame.fk_status AS frame_fk_status,
            frame.picture AS frame_picture,
            frame.rank AS frame_rank,
            frame.usr_frame_1 AS frame_usr_frame_1,
            frame.usr_frame_2 AS frame_usr_frame_2,
            frame.usr_frame_3 AS frame_usr_frame_3,
            sign.rank AS sign_rank,
            support.id AS support_id,
            support.group_by_anchor,
            support.fk_support_type,
            support.fk_support_base_type,
            support.geometry AS support_geometry,
            COALESCE(vl_official_sign.directional_sign, vl_user_sign.directional_sign, vl_marker_type.directional_sign, false) AS directional_sign,
                CASE
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.value_de
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.value_de
                    ELSE vl_official_sign.value_de
                END AS _symbol_value_de,
                CASE
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.value_fr
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.value_fr
                    ELSE vl_official_sign.value_fr
                END AS _symbol_value_fr,
                CASE
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.value_it
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.value_it
                    ELSE vl_official_sign.value_it
                END AS _symbol_value_it,
                CASE
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.value_ro
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.value_ro
                    ELSE vl_official_sign.value_ro
                END AS _symbol_value_ro,
                CASE
                    WHEN (sign.complex IS TRUE) THEN 'complex.svg'::text
                    WHEN (sign.fk_sign_type = 11) THEN vl_official_sign.img_de
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.img_de
                    WHEN (sign.fk_sign_type = 13) THEN ((('mirror'::text ||
                    CASE
                        WHEN (sign.fk_mirror_shape = 12) THEN '-circular'::text
                        ELSE ''::text
                    END) ||
                    CASE
                        WHEN (NOT sign.mirror_red_frame) THEN '-noframe'::text
                        ELSE ''::text
                    END) || '.svg'::text)
                    WHEN (sign.fk_sign_type = 14) THEN 'street-plate.svg'::text
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.img_de
                    ELSE NULL::text
                END AS _img_de,
                CASE
                    WHEN (sign.complex IS TRUE) THEN 'complex.svg'::text
                    WHEN (sign.fk_sign_type = 11) THEN vl_official_sign.img_fr
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.img_fr
                    WHEN (sign.fk_sign_type = 13) THEN ((('mirror'::text ||
                    CASE
                        WHEN (sign.fk_mirror_shape = 12) THEN '-circular'::text
                        ELSE ''::text
                    END) ||
                    CASE
                        WHEN (NOT sign.mirror_red_frame) THEN '-noframe'::text
                        ELSE ''::text
                    END) || '.svg'::text)
                    WHEN (sign.fk_sign_type = 14) THEN 'street-plate.svg'::text
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.img_fr
                    ELSE NULL::text
                END AS _img_fr,
                CASE
                    WHEN (sign.complex IS TRUE) THEN 'complex.svg'::text
                    WHEN (sign.fk_sign_type = 11) THEN vl_official_sign.img_it
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.img_it
                    WHEN (sign.fk_sign_type = 13) THEN ((('mirror'::text ||
                    CASE
                        WHEN (sign.fk_mirror_shape = 12) THEN '-circular'::text
                        ELSE ''::text
                    END) ||
                    CASE
                        WHEN (NOT sign.mirror_red_frame) THEN '-noframe'::text
                        ELSE ''::text
                    END) || '.svg'::text)
                    WHEN (sign.fk_sign_type = 14) THEN 'street-plate.svg'::text
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.img_it
                    ELSE NULL::text
                END AS _img_it,
                CASE
                    WHEN (sign.complex IS TRUE) THEN 'complex.svg'::text
                    WHEN (sign.fk_sign_type = 11) THEN vl_official_sign.img_ro
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.img_ro
                    WHEN (sign.fk_sign_type = 13) THEN ((('mirror'::text ||
                    CASE
                        WHEN (sign.fk_mirror_shape = 12) THEN '-circular'::text
                        ELSE ''::text
                    END) ||
                    CASE
                        WHEN (NOT sign.mirror_red_frame) THEN '-noframe'::text
                        ELSE ''::text
                    END) || '.svg'::text)
                    WHEN (sign.fk_sign_type = 14) THEN 'street-plate.svg'::text
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.img_ro
                    ELSE NULL::text
                END AS _img_ro,
                CASE
                    WHEN (sign.complex IS TRUE) THEN 'complex.svg'::text
                    WHEN (sign.fk_sign_type = 11) THEN vl_official_sign.img_de_right
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.img_de_right
                    WHEN (sign.fk_sign_type = 13) THEN ((('mirror'::text ||
                    CASE
                        WHEN (sign.fk_mirror_shape = 12) THEN '-circular'::text
                        ELSE ''::text
                    END) ||
                    CASE
                        WHEN (NOT sign.mirror_red_frame) THEN '-noframe'::text
                        ELSE ''::text
                    END) || '.svg'::text)
                    WHEN (sign.fk_sign_type = 14) THEN 'street-plate.svg'::text
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.img_de_right
                    ELSE NULL::text
                END AS _img_de_right,
                CASE
                    WHEN (sign.complex IS TRUE) THEN 'complex.svg'::text
                    WHEN (sign.fk_sign_type = 11) THEN vl_official_sign.img_fr_right
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.img_fr_right
                    WHEN (sign.fk_sign_type = 13) THEN ((('mirror'::text ||
                    CASE
                        WHEN (sign.fk_mirror_shape = 12) THEN '-circular'::text
                        ELSE ''::text
                    END) ||
                    CASE
                        WHEN (NOT sign.mirror_red_frame) THEN '-noframe'::text
                        ELSE ''::text
                    END) || '.svg'::text)
                    WHEN (sign.fk_sign_type = 14) THEN 'street-plate.svg'::text
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.img_fr_right
                    ELSE NULL::text
                END AS _img_fr_right,
                CASE
                    WHEN (sign.complex IS TRUE) THEN 'complex.svg'::text
                    WHEN (sign.fk_sign_type = 11) THEN vl_official_sign.img_it_right
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.img_it_right
                    WHEN (sign.fk_sign_type = 13) THEN ((('mirror'::text ||
                    CASE
                        WHEN (sign.fk_mirror_shape = 12) THEN '-circular'::text
                        ELSE ''::text
                    END) ||
                    CASE
                        WHEN (NOT sign.mirror_red_frame) THEN '-noframe'::text
                        ELSE ''::text
                    END) || '.svg'::text)
                    WHEN (sign.fk_sign_type = 14) THEN 'street-plate.svg'::text
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.img_it_right
                    ELSE NULL::text
                END AS _img_it_right,
                CASE
                    WHEN (sign.complex IS TRUE) THEN 'complex.svg'::text
                    WHEN (sign.fk_sign_type = 11) THEN vl_official_sign.img_ro_right
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.img_ro_right
                    WHEN (sign.fk_sign_type = 13) THEN ((('mirror'::text ||
                    CASE
                        WHEN (sign.fk_mirror_shape = 12) THEN '-circular'::text
                        ELSE ''::text
                    END) ||
                    CASE
                        WHEN (NOT sign.mirror_red_frame) THEN '-noframe'::text
                        ELSE ''::text
                    END) || '.svg'::text)
                    WHEN (sign.fk_sign_type = 14) THEN 'street-plate.svg'::text
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.img_ro_right
                    ELSE NULL::text
                END AS _img_ro_right,
                CASE
                    WHEN (sign.complex IS TRUE) THEN 106
                    WHEN (sign.fk_sign_type = 11) THEN vl_official_sign.img_height
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.img_height
                    WHEN (sign.fk_sign_type = 13) THEN 80
                    WHEN (sign.fk_sign_type = 14) THEN 50
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.img_height
                    ELSE NULL::integer
                END AS _symbol_height,
                CASE
                    WHEN (sign.complex IS TRUE) THEN 121
                    WHEN (sign.fk_sign_type = 11) THEN vl_official_sign.img_width
                    WHEN (sign.fk_sign_type = 12) THEN vl_marker_type.img_width
                    WHEN (sign.fk_sign_type = 13) THEN 100
                    WHEN (sign.fk_sign_type = 14) THEN 100
                    WHEN (sign.fk_sign_type = 15) THEN vl_user_sign.img_width
                    ELSE NULL::integer
                END AS _symbol_width
           FROM ((((((signalo_db.sign
             LEFT JOIN signalo_db.frame ON ((frame.id = sign.fk_frame)))
             LEFT JOIN signalo_db.azimut ON ((azimut.id = frame.fk_azimut)))
             LEFT JOIN signalo_db.support ON ((support.id = azimut.fk_support)))
             LEFT JOIN signalo_db.vl_official_sign ON ((vl_official_sign.id = sign.fk_official_sign)))
             LEFT JOIN signalo_db.vl_user_sign ON ((vl_user_sign.id = sign.fk_user_sign)))
             LEFT JOIN signalo_db.vl_marker_type ON ((vl_marker_type.id = sign.fk_marker_type)))
        ), ordered_recto_signs_not_grouped_by_anchor AS (
         SELECT joined_tables.id,
            joined_tables._inserted_date,
            joined_tables._inserted_user,
            joined_tables._last_modified_date,
            joined_tables._last_modified_user,
            joined_tables.case_decision,
            joined_tables.case_id,
            joined_tables.comment,
            joined_tables.complex,
            joined_tables.dimension_1,
            joined_tables.dimension_2,
            joined_tables.fk_coating,
            joined_tables.fk_durability,
            joined_tables.fk_lighting,
            joined_tables.fk_marker_type,
            joined_tables.fk_mirror_shape,
            joined_tables.fk_official_sign,
            joined_tables.fk_owner,
            joined_tables.fk_parent,
            joined_tables.fk_provider,
            joined_tables.fk_sign_type,
            joined_tables.fk_status,
            joined_tables.fk_user_sign,
            joined_tables.hanging_mode,
            joined_tables.inscription_1,
            joined_tables.inscription_2,
            joined_tables.inscription_3,
            joined_tables.installation_date,
            joined_tables.manufacturing_date,
            joined_tables.mirror_protruding,
            joined_tables.mirror_red_frame,
            joined_tables.natural_direction_or_left,
            joined_tables.picture,
            joined_tables.usr_sign_1,
            joined_tables.usr_sign_2,
            joined_tables.usr_sign_3,
            joined_tables.azimut,
            joined_tables.offset_x,
            joined_tables.offset_y,
            joined_tables.offset_x_verso,
            joined_tables.offset_y_verso,
            joined_tables.frame_id,
            joined_tables.frame__inserted_date,
            joined_tables.frame__inserted_user,
            joined_tables.frame__last_modified_date,
            joined_tables.frame__last_modified_user,
            joined_tables.frame_anchor,
            joined_tables.frame_comment,
            joined_tables.frame_dimension_1,
            joined_tables.frame_dimension_2,
            joined_tables.frame_double_sided,
            joined_tables.frame_fk_azimut,
            joined_tables.frame_fk_frame_fixing_type,
            joined_tables.frame_fk_frame_type,
            joined_tables.frame_fk_provider,
            joined_tables.frame_fk_status,
            joined_tables.frame_picture,
            joined_tables.frame_rank,
            joined_tables.frame_usr_frame_1,
            joined_tables.frame_usr_frame_2,
            joined_tables.frame_usr_frame_3,
            joined_tables.sign_rank,
            joined_tables.support_id,
            joined_tables.group_by_anchor,
            joined_tables.fk_support_type,
            joined_tables.fk_support_base_type,
            joined_tables.support_geometry,
            joined_tables.directional_sign,
            joined_tables._symbol_value_de,
            joined_tables._symbol_value_fr,
            joined_tables._symbol_value_it,
            joined_tables._symbol_value_ro,
            joined_tables._img_de,
            joined_tables._img_fr,
            joined_tables._img_it,
            joined_tables._img_ro,
            joined_tables._img_de_right,
            joined_tables._img_fr_right,
            joined_tables._img_it_right,
            joined_tables._img_ro_right,
            joined_tables._symbol_height,
            joined_tables._symbol_width,
            joined_tables.azimut AS _azimut_rectified,
            joined_tables.offset_x AS _azimut_offset_x_rectified,
            joined_tables.offset_y AS _azimut_offset_y_rectified,
            joined_tables.natural_direction_or_left AS _natural_direction_or_left_rectified,
            false AS _verso,
            row_number() OVER (PARTITION BY joined_tables.support_id, joined_tables.azimut ORDER BY joined_tables.frame_rank, joined_tables.sign_rank) AS _rank
           FROM joined_tables
          WHERE ((joined_tables.hanging_mode <> 'VERSO'::signalo_db.sign_hanging) AND (joined_tables.group_by_anchor IS FALSE))
          ORDER BY joined_tables.support_id, joined_tables.azimut, (row_number() OVER (PARTITION BY joined_tables.support_id, joined_tables.azimut ORDER BY joined_tables.frame_rank, joined_tables.sign_rank))
        ), ordered_recto_signs_grouped_by_anchor AS (
         SELECT joined_tables.id,
            joined_tables._inserted_date,
            joined_tables._inserted_user,
            joined_tables._last_modified_date,
            joined_tables._last_modified_user,
            joined_tables.case_decision,
            joined_tables.case_id,
            joined_tables.comment,
            joined_tables.complex,
            joined_tables.dimension_1,
            joined_tables.dimension_2,
            joined_tables.fk_coating,
            joined_tables.fk_durability,
            joined_tables.fk_lighting,
            joined_tables.fk_marker_type,
            joined_tables.fk_mirror_shape,
            joined_tables.fk_official_sign,
            joined_tables.fk_owner,
            joined_tables.fk_parent,
            joined_tables.fk_provider,
            joined_tables.fk_sign_type,
            joined_tables.fk_status,
            joined_tables.fk_user_sign,
            joined_tables.hanging_mode,
            joined_tables.inscription_1,
            joined_tables.inscription_2,
            joined_tables.inscription_3,
            joined_tables.installation_date,
            joined_tables.manufacturing_date,
            joined_tables.mirror_protruding,
            joined_tables.mirror_red_frame,
            joined_tables.natural_direction_or_left,
            joined_tables.picture,
            joined_tables.usr_sign_1,
            joined_tables.usr_sign_2,
            joined_tables.usr_sign_3,
            joined_tables.azimut,
            joined_tables.offset_x,
            joined_tables.offset_y,
            joined_tables.offset_x_verso,
            joined_tables.offset_y_verso,
            joined_tables.frame_id,
            joined_tables.frame__inserted_date,
            joined_tables.frame__inserted_user,
            joined_tables.frame__last_modified_date,
            joined_tables.frame__last_modified_user,
            joined_tables.frame_anchor,
            joined_tables.frame_comment,
            joined_tables.frame_dimension_1,
            joined_tables.frame_dimension_2,
            joined_tables.frame_double_sided,
            joined_tables.frame_fk_azimut,
            joined_tables.frame_fk_frame_fixing_type,
            joined_tables.frame_fk_frame_type,
            joined_tables.frame_fk_provider,
            joined_tables.frame_fk_status,
            joined_tables.frame_picture,
            joined_tables.frame_rank,
            joined_tables.frame_usr_frame_1,
            joined_tables.frame_usr_frame_2,
            joined_tables.frame_usr_frame_3,
            joined_tables.sign_rank,
            joined_tables.support_id,
            joined_tables.group_by_anchor,
            joined_tables.fk_support_type,
            joined_tables.fk_support_base_type,
            joined_tables.support_geometry,
            joined_tables.directional_sign,
            joined_tables._symbol_value_de,
            joined_tables._symbol_value_fr,
            joined_tables._symbol_value_it,
            joined_tables._symbol_value_ro,
            joined_tables._img_de,
            joined_tables._img_fr,
            joined_tables._img_it,
            joined_tables._img_ro,
            joined_tables._img_de_right,
            joined_tables._img_fr_right,
            joined_tables._img_it_right,
            joined_tables._img_ro_right,
            joined_tables._symbol_height,
            joined_tables._symbol_width,
            joined_tables.azimut AS _azimut_rectified,
            joined_tables.offset_x AS _azimut_offset_x_rectified,
            joined_tables.offset_y AS _azimut_offset_y_rectified,
            joined_tables.natural_direction_or_left AS _natural_direction_or_left_rectified,
            false AS _verso,
            row_number() OVER (PARTITION BY joined_tables.support_id, joined_tables.azimut, joined_tables.frame_anchor ORDER BY joined_tables.frame_rank, joined_tables.sign_rank) AS _rank
           FROM joined_tables
          WHERE ((joined_tables.hanging_mode <> 'VERSO'::signalo_db.sign_hanging) AND (joined_tables.group_by_anchor IS TRUE))
          ORDER BY joined_tables.support_id, joined_tables.azimut, joined_tables.frame_anchor, (row_number() OVER (PARTITION BY joined_tables.support_id, joined_tables.azimut, joined_tables.frame_anchor ORDER BY joined_tables.frame_rank, joined_tables.sign_rank))
        ), ordered_verso_signs_not_grouped_by_anchor AS (
         SELECT jt.id,
            jt._inserted_date,
            jt._inserted_user,
            jt._last_modified_date,
            jt._last_modified_user,
            jt.case_decision,
            jt.case_id,
            jt.comment,
            jt.complex,
            jt.dimension_1,
            jt.dimension_2,
            jt.fk_coating,
            jt.fk_durability,
            jt.fk_lighting,
            jt.fk_marker_type,
            jt.fk_mirror_shape,
            jt.fk_official_sign,
            jt.fk_owner,
            jt.fk_parent,
            jt.fk_provider,
            jt.fk_sign_type,
            jt.fk_status,
            jt.fk_user_sign,
            jt.hanging_mode,
            jt.inscription_1,
            jt.inscription_2,
            jt.inscription_3,
            jt.installation_date,
            jt.manufacturing_date,
            jt.mirror_protruding,
            jt.mirror_red_frame,
            jt.natural_direction_or_left,
            jt.picture,
            jt.usr_sign_1,
            jt.usr_sign_2,
            jt.usr_sign_3,
            jt.azimut,
            jt.offset_x,
            jt.offset_y,
            jt.offset_x_verso,
            jt.offset_y_verso,
            jt.frame_id,
            jt.frame__inserted_date,
            jt.frame__inserted_user,
            jt.frame__last_modified_date,
            jt.frame__last_modified_user,
            jt.frame_anchor,
            jt.frame_comment,
            jt.frame_dimension_1,
            jt.frame_dimension_2,
            jt.frame_double_sided,
            jt.frame_fk_azimut,
            jt.frame_fk_frame_fixing_type,
            jt.frame_fk_frame_type,
            jt.frame_fk_provider,
            jt.frame_fk_status,
            jt.frame_picture,
            jt.frame_rank,
            jt.frame_usr_frame_1,
            jt.frame_usr_frame_2,
            jt.frame_usr_frame_3,
            jt.sign_rank,
            jt.support_id,
            jt.group_by_anchor,
            jt.fk_support_type,
            jt.fk_support_base_type,
            jt.support_geometry,
            jt.directional_sign,
            jt._symbol_value_de,
            jt._symbol_value_fr,
            jt._symbol_value_it,
            jt._symbol_value_ro,
            jt._img_de,
            jt._img_fr,
            jt._img_it,
            jt._img_ro,
            jt._img_de_right,
            jt._img_fr_right,
            jt._img_it_right,
            jt._img_ro_right,
            jt._symbol_height,
            jt._symbol_width,
            (jt.azimut + 180) AS _azimut_rectified,
            COALESCE(az.offset_x, jt.offset_x_verso) AS _azimut_offset_x_rectified,
            COALESCE(az.offset_y, jt.offset_y_verso) AS _azimut_offset_y_rectified,
            (NOT jt.natural_direction_or_left) AS _natural_direction_or_left_rectified,
            true AS _verso,
            (1000 + row_number() OVER (PARTITION BY jt.support_id, jt.azimut ORDER BY jt.frame_rank, jt.sign_rank)) AS _rank
           FROM (joined_tables jt
             LEFT JOIN signalo_db.azimut az ON (((az.azimut = ((jt.azimut + 180) % 360)) AND (az.fk_support = jt.support_id))))
          WHERE ((jt.hanging_mode <> 'RECTO'::signalo_db.sign_hanging) AND (jt.group_by_anchor IS FALSE))
          ORDER BY jt.support_id, jt.azimut, (1000 + row_number() OVER (PARTITION BY jt.support_id, jt.azimut ORDER BY jt.frame_rank, jt.sign_rank))
        ), ordered_verso_signs_grouped_by_anchor AS (
         SELECT jt.id,
            jt._inserted_date,
            jt._inserted_user,
            jt._last_modified_date,
            jt._last_modified_user,
            jt.case_decision,
            jt.case_id,
            jt.comment,
            jt.complex,
            jt.dimension_1,
            jt.dimension_2,
            jt.fk_coating,
            jt.fk_durability,
            jt.fk_lighting,
            jt.fk_marker_type,
            jt.fk_mirror_shape,
            jt.fk_official_sign,
            jt.fk_owner,
            jt.fk_parent,
            jt.fk_provider,
            jt.fk_sign_type,
            jt.fk_status,
            jt.fk_user_sign,
            jt.hanging_mode,
            jt.inscription_1,
            jt.inscription_2,
            jt.inscription_3,
            jt.installation_date,
            jt.manufacturing_date,
            jt.mirror_protruding,
            jt.mirror_red_frame,
            jt.natural_direction_or_left,
            jt.picture,
            jt.usr_sign_1,
            jt.usr_sign_2,
            jt.usr_sign_3,
            jt.azimut,
            jt.offset_x,
            jt.offset_y,
            jt.offset_x_verso,
            jt.offset_y_verso,
            jt.frame_id,
            jt.frame__inserted_date,
            jt.frame__inserted_user,
            jt.frame__last_modified_date,
            jt.frame__last_modified_user,
            jt.frame_anchor,
            jt.frame_comment,
            jt.frame_dimension_1,
            jt.frame_dimension_2,
            jt.frame_double_sided,
            jt.frame_fk_azimut,
            jt.frame_fk_frame_fixing_type,
            jt.frame_fk_frame_type,
            jt.frame_fk_provider,
            jt.frame_fk_status,
            jt.frame_picture,
            jt.frame_rank,
            jt.frame_usr_frame_1,
            jt.frame_usr_frame_2,
            jt.frame_usr_frame_3,
            jt.sign_rank,
            jt.support_id,
            jt.group_by_anchor,
            jt.fk_support_type,
            jt.fk_support_base_type,
            jt.support_geometry,
            jt.directional_sign,
            jt._symbol_value_de,
            jt._symbol_value_fr,
            jt._symbol_value_it,
            jt._symbol_value_ro,
            jt._img_de,
            jt._img_fr,
            jt._img_it,
            jt._img_ro,
            jt._img_de_right,
            jt._img_fr_right,
            jt._img_it_right,
            jt._img_ro_right,
            jt._symbol_height,
            jt._symbol_width,
            (jt.azimut + 180) AS _azimut_rectified,
            COALESCE(az.offset_x, jt.offset_x_verso) AS _azimut_offset_x_rectified,
            COALESCE(az.offset_y, jt.offset_y_verso) AS _azimut_offset_y_rectified,
            (NOT jt.natural_direction_or_left) AS _natural_direction_or_left_rectified,
            true AS _verso,
            (1000 + row_number() OVER (PARTITION BY jt.support_id, jt.azimut, jt.frame_anchor ORDER BY jt.frame_rank, jt.sign_rank)) AS _rank
           FROM (joined_tables jt
             LEFT JOIN signalo_db.azimut az ON (((az.azimut = ((jt.azimut + 180) % 360)) AND (az.fk_support = jt.support_id))))
          WHERE ((jt.hanging_mode <> 'RECTO'::signalo_db.sign_hanging) AND (jt.group_by_anchor IS TRUE))
          ORDER BY jt.support_id, jt.azimut, jt.frame_anchor, (1000 + row_number() OVER (PARTITION BY jt.support_id, jt.azimut, jt.frame_anchor ORDER BY jt.frame_rank, jt.sign_rank))
        ), ordered_signs_not_grouped_by_anchor AS (
         SELECT ordered_recto_signs_not_grouped_by_anchor.id,
            ordered_recto_signs_not_grouped_by_anchor._inserted_date,
            ordered_recto_signs_not_grouped_by_anchor._inserted_user,
            ordered_recto_signs_not_grouped_by_anchor._last_modified_date,
            ordered_recto_signs_not_grouped_by_anchor._last_modified_user,
            ordered_recto_signs_not_grouped_by_anchor.case_decision,
            ordered_recto_signs_not_grouped_by_anchor.case_id,
            ordered_recto_signs_not_grouped_by_anchor.comment,
            ordered_recto_signs_not_grouped_by_anchor.complex,
            ordered_recto_signs_not_grouped_by_anchor.dimension_1,
            ordered_recto_signs_not_grouped_by_anchor.dimension_2,
            ordered_recto_signs_not_grouped_by_anchor.fk_coating,
            ordered_recto_signs_not_grouped_by_anchor.fk_durability,
            ordered_recto_signs_not_grouped_by_anchor.fk_lighting,
            ordered_recto_signs_not_grouped_by_anchor.fk_marker_type,
            ordered_recto_signs_not_grouped_by_anchor.fk_mirror_shape,
            ordered_recto_signs_not_grouped_by_anchor.fk_official_sign,
            ordered_recto_signs_not_grouped_by_anchor.fk_owner,
            ordered_recto_signs_not_grouped_by_anchor.fk_parent,
            ordered_recto_signs_not_grouped_by_anchor.fk_provider,
            ordered_recto_signs_not_grouped_by_anchor.fk_sign_type,
            ordered_recto_signs_not_grouped_by_anchor.fk_status,
            ordered_recto_signs_not_grouped_by_anchor.fk_user_sign,
            ordered_recto_signs_not_grouped_by_anchor.hanging_mode,
            ordered_recto_signs_not_grouped_by_anchor.inscription_1,
            ordered_recto_signs_not_grouped_by_anchor.inscription_2,
            ordered_recto_signs_not_grouped_by_anchor.inscription_3,
            ordered_recto_signs_not_grouped_by_anchor.installation_date,
            ordered_recto_signs_not_grouped_by_anchor.manufacturing_date,
            ordered_recto_signs_not_grouped_by_anchor.mirror_protruding,
            ordered_recto_signs_not_grouped_by_anchor.mirror_red_frame,
            ordered_recto_signs_not_grouped_by_anchor.natural_direction_or_left,
            ordered_recto_signs_not_grouped_by_anchor.picture,
            ordered_recto_signs_not_grouped_by_anchor.usr_sign_1,
            ordered_recto_signs_not_grouped_by_anchor.usr_sign_2,
            ordered_recto_signs_not_grouped_by_anchor.usr_sign_3,
            ordered_recto_signs_not_grouped_by_anchor.azimut,
            ordered_recto_signs_not_grouped_by_anchor.offset_x,
            ordered_recto_signs_not_grouped_by_anchor.offset_y,
            ordered_recto_signs_not_grouped_by_anchor.offset_x_verso,
            ordered_recto_signs_not_grouped_by_anchor.offset_y_verso,
            ordered_recto_signs_not_grouped_by_anchor.frame_id,
            ordered_recto_signs_not_grouped_by_anchor.frame__inserted_date,
            ordered_recto_signs_not_grouped_by_anchor.frame__inserted_user,
            ordered_recto_signs_not_grouped_by_anchor.frame__last_modified_date,
            ordered_recto_signs_not_grouped_by_anchor.frame__last_modified_user,
            ordered_recto_signs_not_grouped_by_anchor.frame_anchor,
            ordered_recto_signs_not_grouped_by_anchor.frame_comment,
            ordered_recto_signs_not_grouped_by_anchor.frame_dimension_1,
            ordered_recto_signs_not_grouped_by_anchor.frame_dimension_2,
            ordered_recto_signs_not_grouped_by_anchor.frame_double_sided,
            ordered_recto_signs_not_grouped_by_anchor.frame_fk_azimut,
            ordered_recto_signs_not_grouped_by_anchor.frame_fk_frame_fixing_type,
            ordered_recto_signs_not_grouped_by_anchor.frame_fk_frame_type,
            ordered_recto_signs_not_grouped_by_anchor.frame_fk_provider,
            ordered_recto_signs_not_grouped_by_anchor.frame_fk_status,
            ordered_recto_signs_not_grouped_by_anchor.frame_picture,
            ordered_recto_signs_not_grouped_by_anchor.frame_rank,
            ordered_recto_signs_not_grouped_by_anchor.frame_usr_frame_1,
            ordered_recto_signs_not_grouped_by_anchor.frame_usr_frame_2,
            ordered_recto_signs_not_grouped_by_anchor.frame_usr_frame_3,
            ordered_recto_signs_not_grouped_by_anchor.sign_rank,
            ordered_recto_signs_not_grouped_by_anchor.support_id,
            ordered_recto_signs_not_grouped_by_anchor.group_by_anchor,
            ordered_recto_signs_not_grouped_by_anchor.fk_support_type,
            ordered_recto_signs_not_grouped_by_anchor.fk_support_base_type,
            ordered_recto_signs_not_grouped_by_anchor.support_geometry,
            ordered_recto_signs_not_grouped_by_anchor.directional_sign,
            ordered_recto_signs_not_grouped_by_anchor._symbol_value_de,
            ordered_recto_signs_not_grouped_by_anchor._symbol_value_fr,
            ordered_recto_signs_not_grouped_by_anchor._symbol_value_it,
            ordered_recto_signs_not_grouped_by_anchor._symbol_value_ro,
            ordered_recto_signs_not_grouped_by_anchor._img_de,
            ordered_recto_signs_not_grouped_by_anchor._img_fr,
            ordered_recto_signs_not_grouped_by_anchor._img_it,
            ordered_recto_signs_not_grouped_by_anchor._img_ro,
            ordered_recto_signs_not_grouped_by_anchor._img_de_right,
            ordered_recto_signs_not_grouped_by_anchor._img_fr_right,
            ordered_recto_signs_not_grouped_by_anchor._img_it_right,
            ordered_recto_signs_not_grouped_by_anchor._img_ro_right,
            ordered_recto_signs_not_grouped_by_anchor._symbol_height,
            ordered_recto_signs_not_grouped_by_anchor._symbol_width,
            ordered_recto_signs_not_grouped_by_anchor._azimut_rectified,
            ordered_recto_signs_not_grouped_by_anchor._azimut_offset_x_rectified,
            ordered_recto_signs_not_grouped_by_anchor._azimut_offset_y_rectified,
            ordered_recto_signs_not_grouped_by_anchor._natural_direction_or_left_rectified,
            ordered_recto_signs_not_grouped_by_anchor._verso,
            ordered_recto_signs_not_grouped_by_anchor._rank
           FROM ordered_recto_signs_not_grouped_by_anchor
        UNION
         SELECT ordered_verso_signs_not_grouped_by_anchor.id,
            ordered_verso_signs_not_grouped_by_anchor._inserted_date,
            ordered_verso_signs_not_grouped_by_anchor._inserted_user,
            ordered_verso_signs_not_grouped_by_anchor._last_modified_date,
            ordered_verso_signs_not_grouped_by_anchor._last_modified_user,
            ordered_verso_signs_not_grouped_by_anchor.case_decision,
            ordered_verso_signs_not_grouped_by_anchor.case_id,
            ordered_verso_signs_not_grouped_by_anchor.comment,
            ordered_verso_signs_not_grouped_by_anchor.complex,
            ordered_verso_signs_not_grouped_by_anchor.dimension_1,
            ordered_verso_signs_not_grouped_by_anchor.dimension_2,
            ordered_verso_signs_not_grouped_by_anchor.fk_coating,
            ordered_verso_signs_not_grouped_by_anchor.fk_durability,
            ordered_verso_signs_not_grouped_by_anchor.fk_lighting,
            ordered_verso_signs_not_grouped_by_anchor.fk_marker_type,
            ordered_verso_signs_not_grouped_by_anchor.fk_mirror_shape,
            ordered_verso_signs_not_grouped_by_anchor.fk_official_sign,
            ordered_verso_signs_not_grouped_by_anchor.fk_owner,
            ordered_verso_signs_not_grouped_by_anchor.fk_parent,
            ordered_verso_signs_not_grouped_by_anchor.fk_provider,
            ordered_verso_signs_not_grouped_by_anchor.fk_sign_type,
            ordered_verso_signs_not_grouped_by_anchor.fk_status,
            ordered_verso_signs_not_grouped_by_anchor.fk_user_sign,
            ordered_verso_signs_not_grouped_by_anchor.hanging_mode,
            ordered_verso_signs_not_grouped_by_anchor.inscription_1,
            ordered_verso_signs_not_grouped_by_anchor.inscription_2,
            ordered_verso_signs_not_grouped_by_anchor.inscription_3,
            ordered_verso_signs_not_grouped_by_anchor.installation_date,
            ordered_verso_signs_not_grouped_by_anchor.manufacturing_date,
            ordered_verso_signs_not_grouped_by_anchor.mirror_protruding,
            ordered_verso_signs_not_grouped_by_anchor.mirror_red_frame,
            ordered_verso_signs_not_grouped_by_anchor.natural_direction_or_left,
            ordered_verso_signs_not_grouped_by_anchor.picture,
            ordered_verso_signs_not_grouped_by_anchor.usr_sign_1,
            ordered_verso_signs_not_grouped_by_anchor.usr_sign_2,
            ordered_verso_signs_not_grouped_by_anchor.usr_sign_3,
            ordered_verso_signs_not_grouped_by_anchor.azimut,
            ordered_verso_signs_not_grouped_by_anchor.offset_x,
            ordered_verso_signs_not_grouped_by_anchor.offset_y,
            ordered_verso_signs_not_grouped_by_anchor.offset_x_verso,
            ordered_verso_signs_not_grouped_by_anchor.offset_y_verso,
            ordered_verso_signs_not_grouped_by_anchor.frame_id,
            ordered_verso_signs_not_grouped_by_anchor.frame__inserted_date,
            ordered_verso_signs_not_grouped_by_anchor.frame__inserted_user,
            ordered_verso_signs_not_grouped_by_anchor.frame__last_modified_date,
            ordered_verso_signs_not_grouped_by_anchor.frame__last_modified_user,
            ordered_verso_signs_not_grouped_by_anchor.frame_anchor,
            ordered_verso_signs_not_grouped_by_anchor.frame_comment,
            ordered_verso_signs_not_grouped_by_anchor.frame_dimension_1,
            ordered_verso_signs_not_grouped_by_anchor.frame_dimension_2,
            ordered_verso_signs_not_grouped_by_anchor.frame_double_sided,
            ordered_verso_signs_not_grouped_by_anchor.frame_fk_azimut,
            ordered_verso_signs_not_grouped_by_anchor.frame_fk_frame_fixing_type,
            ordered_verso_signs_not_grouped_by_anchor.frame_fk_frame_type,
            ordered_verso_signs_not_grouped_by_anchor.frame_fk_provider,
            ordered_verso_signs_not_grouped_by_anchor.frame_fk_status,
            ordered_verso_signs_not_grouped_by_anchor.frame_picture,
            ordered_verso_signs_not_grouped_by_anchor.frame_rank,
            ordered_verso_signs_not_grouped_by_anchor.frame_usr_frame_1,
            ordered_verso_signs_not_grouped_by_anchor.frame_usr_frame_2,
            ordered_verso_signs_not_grouped_by_anchor.frame_usr_frame_3,
            ordered_verso_signs_not_grouped_by_anchor.sign_rank,
            ordered_verso_signs_not_grouped_by_anchor.support_id,
            ordered_verso_signs_not_grouped_by_anchor.group_by_anchor,
            ordered_verso_signs_not_grouped_by_anchor.fk_support_type,
            ordered_verso_signs_not_grouped_by_anchor.fk_support_base_type,
            ordered_verso_signs_not_grouped_by_anchor.support_geometry,
            ordered_verso_signs_not_grouped_by_anchor.directional_sign,
            ordered_verso_signs_not_grouped_by_anchor._symbol_value_de,
            ordered_verso_signs_not_grouped_by_anchor._symbol_value_fr,
            ordered_verso_signs_not_grouped_by_anchor._symbol_value_it,
            ordered_verso_signs_not_grouped_by_anchor._symbol_value_ro,
            ordered_verso_signs_not_grouped_by_anchor._img_de,
            ordered_verso_signs_not_grouped_by_anchor._img_fr,
            ordered_verso_signs_not_grouped_by_anchor._img_it,
            ordered_verso_signs_not_grouped_by_anchor._img_ro,
            ordered_verso_signs_not_grouped_by_anchor._img_de_right,
            ordered_verso_signs_not_grouped_by_anchor._img_fr_right,
            ordered_verso_signs_not_grouped_by_anchor._img_it_right,
            ordered_verso_signs_not_grouped_by_anchor._img_ro_right,
            ordered_verso_signs_not_grouped_by_anchor._symbol_height,
            ordered_verso_signs_not_grouped_by_anchor._symbol_width,
            ordered_verso_signs_not_grouped_by_anchor._azimut_rectified,
            ordered_verso_signs_not_grouped_by_anchor._azimut_offset_x_rectified,
            ordered_verso_signs_not_grouped_by_anchor._azimut_offset_y_rectified,
            ordered_verso_signs_not_grouped_by_anchor._natural_direction_or_left_rectified,
            ordered_verso_signs_not_grouped_by_anchor._verso,
            ordered_verso_signs_not_grouped_by_anchor._rank
           FROM ordered_verso_signs_not_grouped_by_anchor
        ), ordered_signs_grouped_by_anchor AS (
         SELECT ordered_recto_signs_grouped_by_anchor.id,
            ordered_recto_signs_grouped_by_anchor._inserted_date,
            ordered_recto_signs_grouped_by_anchor._inserted_user,
            ordered_recto_signs_grouped_by_anchor._last_modified_date,
            ordered_recto_signs_grouped_by_anchor._last_modified_user,
            ordered_recto_signs_grouped_by_anchor.case_decision,
            ordered_recto_signs_grouped_by_anchor.case_id,
            ordered_recto_signs_grouped_by_anchor.comment,
            ordered_recto_signs_grouped_by_anchor.complex,
            ordered_recto_signs_grouped_by_anchor.dimension_1,
            ordered_recto_signs_grouped_by_anchor.dimension_2,
            ordered_recto_signs_grouped_by_anchor.fk_coating,
            ordered_recto_signs_grouped_by_anchor.fk_durability,
            ordered_recto_signs_grouped_by_anchor.fk_lighting,
            ordered_recto_signs_grouped_by_anchor.fk_marker_type,
            ordered_recto_signs_grouped_by_anchor.fk_mirror_shape,
            ordered_recto_signs_grouped_by_anchor.fk_official_sign,
            ordered_recto_signs_grouped_by_anchor.fk_owner,
            ordered_recto_signs_grouped_by_anchor.fk_parent,
            ordered_recto_signs_grouped_by_anchor.fk_provider,
            ordered_recto_signs_grouped_by_anchor.fk_sign_type,
            ordered_recto_signs_grouped_by_anchor.fk_status,
            ordered_recto_signs_grouped_by_anchor.fk_user_sign,
            ordered_recto_signs_grouped_by_anchor.hanging_mode,
            ordered_recto_signs_grouped_by_anchor.inscription_1,
            ordered_recto_signs_grouped_by_anchor.inscription_2,
            ordered_recto_signs_grouped_by_anchor.inscription_3,
            ordered_recto_signs_grouped_by_anchor.installation_date,
            ordered_recto_signs_grouped_by_anchor.manufacturing_date,
            ordered_recto_signs_grouped_by_anchor.mirror_protruding,
            ordered_recto_signs_grouped_by_anchor.mirror_red_frame,
            ordered_recto_signs_grouped_by_anchor.natural_direction_or_left,
            ordered_recto_signs_grouped_by_anchor.picture,
            ordered_recto_signs_grouped_by_anchor.usr_sign_1,
            ordered_recto_signs_grouped_by_anchor.usr_sign_2,
            ordered_recto_signs_grouped_by_anchor.usr_sign_3,
            ordered_recto_signs_grouped_by_anchor.azimut,
            ordered_recto_signs_grouped_by_anchor.offset_x,
            ordered_recto_signs_grouped_by_anchor.offset_y,
            ordered_recto_signs_grouped_by_anchor.offset_x_verso,
            ordered_recto_signs_grouped_by_anchor.offset_y_verso,
            ordered_recto_signs_grouped_by_anchor.frame_id,
            ordered_recto_signs_grouped_by_anchor.frame__inserted_date,
            ordered_recto_signs_grouped_by_anchor.frame__inserted_user,
            ordered_recto_signs_grouped_by_anchor.frame__last_modified_date,
            ordered_recto_signs_grouped_by_anchor.frame__last_modified_user,
            ordered_recto_signs_grouped_by_anchor.frame_anchor,
            ordered_recto_signs_grouped_by_anchor.frame_comment,
            ordered_recto_signs_grouped_by_anchor.frame_dimension_1,
            ordered_recto_signs_grouped_by_anchor.frame_dimension_2,
            ordered_recto_signs_grouped_by_anchor.frame_double_sided,
            ordered_recto_signs_grouped_by_anchor.frame_fk_azimut,
            ordered_recto_signs_grouped_by_anchor.frame_fk_frame_fixing_type,
            ordered_recto_signs_grouped_by_anchor.frame_fk_frame_type,
            ordered_recto_signs_grouped_by_anchor.frame_fk_provider,
            ordered_recto_signs_grouped_by_anchor.frame_fk_status,
            ordered_recto_signs_grouped_by_anchor.frame_picture,
            ordered_recto_signs_grouped_by_anchor.frame_rank,
            ordered_recto_signs_grouped_by_anchor.frame_usr_frame_1,
            ordered_recto_signs_grouped_by_anchor.frame_usr_frame_2,
            ordered_recto_signs_grouped_by_anchor.frame_usr_frame_3,
            ordered_recto_signs_grouped_by_anchor.sign_rank,
            ordered_recto_signs_grouped_by_anchor.support_id,
            ordered_recto_signs_grouped_by_anchor.group_by_anchor,
            ordered_recto_signs_grouped_by_anchor.fk_support_type,
            ordered_recto_signs_grouped_by_anchor.fk_support_base_type,
            ordered_recto_signs_grouped_by_anchor.support_geometry,
            ordered_recto_signs_grouped_by_anchor.directional_sign,
            ordered_recto_signs_grouped_by_anchor._symbol_value_de,
            ordered_recto_signs_grouped_by_anchor._symbol_value_fr,
            ordered_recto_signs_grouped_by_anchor._symbol_value_it,
            ordered_recto_signs_grouped_by_anchor._symbol_value_ro,
            ordered_recto_signs_grouped_by_anchor._img_de,
            ordered_recto_signs_grouped_by_anchor._img_fr,
            ordered_recto_signs_grouped_by_anchor._img_it,
            ordered_recto_signs_grouped_by_anchor._img_ro,
            ordered_recto_signs_grouped_by_anchor._img_de_right,
            ordered_recto_signs_grouped_by_anchor._img_fr_right,
            ordered_recto_signs_grouped_by_anchor._img_it_right,
            ordered_recto_signs_grouped_by_anchor._img_ro_right,
            ordered_recto_signs_grouped_by_anchor._symbol_height,
            ordered_recto_signs_grouped_by_anchor._symbol_width,
            ordered_recto_signs_grouped_by_anchor._azimut_rectified,
            ordered_recto_signs_grouped_by_anchor._azimut_offset_x_rectified,
            ordered_recto_signs_grouped_by_anchor._azimut_offset_y_rectified,
            ordered_recto_signs_grouped_by_anchor._natural_direction_or_left_rectified,
            ordered_recto_signs_grouped_by_anchor._verso,
            ordered_recto_signs_grouped_by_anchor._rank
           FROM ordered_recto_signs_grouped_by_anchor
        UNION
         SELECT ordered_verso_signs_grouped_by_anchor.id,
            ordered_verso_signs_grouped_by_anchor._inserted_date,
            ordered_verso_signs_grouped_by_anchor._inserted_user,
            ordered_verso_signs_grouped_by_anchor._last_modified_date,
            ordered_verso_signs_grouped_by_anchor._last_modified_user,
            ordered_verso_signs_grouped_by_anchor.case_decision,
            ordered_verso_signs_grouped_by_anchor.case_id,
            ordered_verso_signs_grouped_by_anchor.comment,
            ordered_verso_signs_grouped_by_anchor.complex,
            ordered_verso_signs_grouped_by_anchor.dimension_1,
            ordered_verso_signs_grouped_by_anchor.dimension_2,
            ordered_verso_signs_grouped_by_anchor.fk_coating,
            ordered_verso_signs_grouped_by_anchor.fk_durability,
            ordered_verso_signs_grouped_by_anchor.fk_lighting,
            ordered_verso_signs_grouped_by_anchor.fk_marker_type,
            ordered_verso_signs_grouped_by_anchor.fk_mirror_shape,
            ordered_verso_signs_grouped_by_anchor.fk_official_sign,
            ordered_verso_signs_grouped_by_anchor.fk_owner,
            ordered_verso_signs_grouped_by_anchor.fk_parent,
            ordered_verso_signs_grouped_by_anchor.fk_provider,
            ordered_verso_signs_grouped_by_anchor.fk_sign_type,
            ordered_verso_signs_grouped_by_anchor.fk_status,
            ordered_verso_signs_grouped_by_anchor.fk_user_sign,
            ordered_verso_signs_grouped_by_anchor.hanging_mode,
            ordered_verso_signs_grouped_by_anchor.inscription_1,
            ordered_verso_signs_grouped_by_anchor.inscription_2,
            ordered_verso_signs_grouped_by_anchor.inscription_3,
            ordered_verso_signs_grouped_by_anchor.installation_date,
            ordered_verso_signs_grouped_by_anchor.manufacturing_date,
            ordered_verso_signs_grouped_by_anchor.mirror_protruding,
            ordered_verso_signs_grouped_by_anchor.mirror_red_frame,
            ordered_verso_signs_grouped_by_anchor.natural_direction_or_left,
            ordered_verso_signs_grouped_by_anchor.picture,
            ordered_verso_signs_grouped_by_anchor.usr_sign_1,
            ordered_verso_signs_grouped_by_anchor.usr_sign_2,
            ordered_verso_signs_grouped_by_anchor.usr_sign_3,
            ordered_verso_signs_grouped_by_anchor.azimut,
            ordered_verso_signs_grouped_by_anchor.offset_x,
            ordered_verso_signs_grouped_by_anchor.offset_y,
            ordered_verso_signs_grouped_by_anchor.offset_x_verso,
            ordered_verso_signs_grouped_by_anchor.offset_y_verso,
            ordered_verso_signs_grouped_by_anchor.frame_id,
            ordered_verso_signs_grouped_by_anchor.frame__inserted_date,
            ordered_verso_signs_grouped_by_anchor.frame__inserted_user,
            ordered_verso_signs_grouped_by_anchor.frame__last_modified_date,
            ordered_verso_signs_grouped_by_anchor.frame__last_modified_user,
            ordered_verso_signs_grouped_by_anchor.frame_anchor,
            ordered_verso_signs_grouped_by_anchor.frame_comment,
            ordered_verso_signs_grouped_by_anchor.frame_dimension_1,
            ordered_verso_signs_grouped_by_anchor.frame_dimension_2,
            ordered_verso_signs_grouped_by_anchor.frame_double_sided,
            ordered_verso_signs_grouped_by_anchor.frame_fk_azimut,
            ordered_verso_signs_grouped_by_anchor.frame_fk_frame_fixing_type,
            ordered_verso_signs_grouped_by_anchor.frame_fk_frame_type,
            ordered_verso_signs_grouped_by_anchor.frame_fk_provider,
            ordered_verso_signs_grouped_by_anchor.frame_fk_status,
            ordered_verso_signs_grouped_by_anchor.frame_picture,
            ordered_verso_signs_grouped_by_anchor.frame_rank,
            ordered_verso_signs_grouped_by_anchor.frame_usr_frame_1,
            ordered_verso_signs_grouped_by_anchor.frame_usr_frame_2,
            ordered_verso_signs_grouped_by_anchor.frame_usr_frame_3,
            ordered_verso_signs_grouped_by_anchor.sign_rank,
            ordered_verso_signs_grouped_by_anchor.support_id,
            ordered_verso_signs_grouped_by_anchor.group_by_anchor,
            ordered_verso_signs_grouped_by_anchor.fk_support_type,
            ordered_verso_signs_grouped_by_anchor.fk_support_base_type,
            ordered_verso_signs_grouped_by_anchor.support_geometry,
            ordered_verso_signs_grouped_by_anchor.directional_sign,
            ordered_verso_signs_grouped_by_anchor._symbol_value_de,
            ordered_verso_signs_grouped_by_anchor._symbol_value_fr,
            ordered_verso_signs_grouped_by_anchor._symbol_value_it,
            ordered_verso_signs_grouped_by_anchor._symbol_value_ro,
            ordered_verso_signs_grouped_by_anchor._img_de,
            ordered_verso_signs_grouped_by_anchor._img_fr,
            ordered_verso_signs_grouped_by_anchor._img_it,
            ordered_verso_signs_grouped_by_anchor._img_ro,
            ordered_verso_signs_grouped_by_anchor._img_de_right,
            ordered_verso_signs_grouped_by_anchor._img_fr_right,
            ordered_verso_signs_grouped_by_anchor._img_it_right,
            ordered_verso_signs_grouped_by_anchor._img_ro_right,
            ordered_verso_signs_grouped_by_anchor._symbol_height,
            ordered_verso_signs_grouped_by_anchor._symbol_width,
            ordered_verso_signs_grouped_by_anchor._azimut_rectified,
            ordered_verso_signs_grouped_by_anchor._azimut_offset_x_rectified,
            ordered_verso_signs_grouped_by_anchor._azimut_offset_y_rectified,
            ordered_verso_signs_grouped_by_anchor._natural_direction_or_left_rectified,
            ordered_verso_signs_grouped_by_anchor._verso,
            ordered_verso_signs_grouped_by_anchor._rank
           FROM ordered_verso_signs_grouped_by_anchor
        ), ordered_shifted_signs_not_grouped_by_anchor AS (
         SELECT ordered_signs_not_grouped_by_anchor.id,
            ordered_signs_not_grouped_by_anchor._inserted_date,
            ordered_signs_not_grouped_by_anchor._inserted_user,
            ordered_signs_not_grouped_by_anchor._last_modified_date,
            ordered_signs_not_grouped_by_anchor._last_modified_user,
            ordered_signs_not_grouped_by_anchor.case_decision,
            ordered_signs_not_grouped_by_anchor.case_id,
            ordered_signs_not_grouped_by_anchor.comment,
            ordered_signs_not_grouped_by_anchor.complex,
            ordered_signs_not_grouped_by_anchor.dimension_1,
            ordered_signs_not_grouped_by_anchor.dimension_2,
            ordered_signs_not_grouped_by_anchor.fk_coating,
            ordered_signs_not_grouped_by_anchor.fk_durability,
            ordered_signs_not_grouped_by_anchor.fk_lighting,
            ordered_signs_not_grouped_by_anchor.fk_marker_type,
            ordered_signs_not_grouped_by_anchor.fk_mirror_shape,
            ordered_signs_not_grouped_by_anchor.fk_official_sign,
            ordered_signs_not_grouped_by_anchor.fk_owner,
            ordered_signs_not_grouped_by_anchor.fk_parent,
            ordered_signs_not_grouped_by_anchor.fk_provider,
            ordered_signs_not_grouped_by_anchor.fk_sign_type,
            ordered_signs_not_grouped_by_anchor.fk_status,
            ordered_signs_not_grouped_by_anchor.fk_user_sign,
            ordered_signs_not_grouped_by_anchor.hanging_mode,
            ordered_signs_not_grouped_by_anchor.inscription_1,
            ordered_signs_not_grouped_by_anchor.inscription_2,
            ordered_signs_not_grouped_by_anchor.inscription_3,
            ordered_signs_not_grouped_by_anchor.installation_date,
            ordered_signs_not_grouped_by_anchor.manufacturing_date,
            ordered_signs_not_grouped_by_anchor.mirror_protruding,
            ordered_signs_not_grouped_by_anchor.mirror_red_frame,
            ordered_signs_not_grouped_by_anchor.natural_direction_or_left,
            ordered_signs_not_grouped_by_anchor.picture,
            ordered_signs_not_grouped_by_anchor.usr_sign_1,
            ordered_signs_not_grouped_by_anchor.usr_sign_2,
            ordered_signs_not_grouped_by_anchor.usr_sign_3,
            ordered_signs_not_grouped_by_anchor.azimut,
            ordered_signs_not_grouped_by_anchor.offset_x,
            ordered_signs_not_grouped_by_anchor.offset_y,
            ordered_signs_not_grouped_by_anchor.offset_x_verso,
            ordered_signs_not_grouped_by_anchor.offset_y_verso,
            ordered_signs_not_grouped_by_anchor.frame_id,
            ordered_signs_not_grouped_by_anchor.frame__inserted_date,
            ordered_signs_not_grouped_by_anchor.frame__inserted_user,
            ordered_signs_not_grouped_by_anchor.frame__last_modified_date,
            ordered_signs_not_grouped_by_anchor.frame__last_modified_user,
            ordered_signs_not_grouped_by_anchor.frame_anchor,
            ordered_signs_not_grouped_by_anchor.frame_comment,
            ordered_signs_not_grouped_by_anchor.frame_dimension_1,
            ordered_signs_not_grouped_by_anchor.frame_dimension_2,
            ordered_signs_not_grouped_by_anchor.frame_double_sided,
            ordered_signs_not_grouped_by_anchor.frame_fk_azimut,
            ordered_signs_not_grouped_by_anchor.frame_fk_frame_fixing_type,
            ordered_signs_not_grouped_by_anchor.frame_fk_frame_type,
            ordered_signs_not_grouped_by_anchor.frame_fk_provider,
            ordered_signs_not_grouped_by_anchor.frame_fk_status,
            ordered_signs_not_grouped_by_anchor.frame_picture,
            ordered_signs_not_grouped_by_anchor.frame_rank,
            ordered_signs_not_grouped_by_anchor.frame_usr_frame_1,
            ordered_signs_not_grouped_by_anchor.frame_usr_frame_2,
            ordered_signs_not_grouped_by_anchor.frame_usr_frame_3,
            ordered_signs_not_grouped_by_anchor.sign_rank,
            ordered_signs_not_grouped_by_anchor.support_id,
            ordered_signs_not_grouped_by_anchor.group_by_anchor,
            ordered_signs_not_grouped_by_anchor.fk_support_type,
            ordered_signs_not_grouped_by_anchor.fk_support_base_type,
            ordered_signs_not_grouped_by_anchor.support_geometry,
            ordered_signs_not_grouped_by_anchor.directional_sign,
            ordered_signs_not_grouped_by_anchor._symbol_value_de,
            ordered_signs_not_grouped_by_anchor._symbol_value_fr,
            ordered_signs_not_grouped_by_anchor._symbol_value_it,
            ordered_signs_not_grouped_by_anchor._symbol_value_ro,
            ordered_signs_not_grouped_by_anchor._img_de,
            ordered_signs_not_grouped_by_anchor._img_fr,
            ordered_signs_not_grouped_by_anchor._img_it,
            ordered_signs_not_grouped_by_anchor._img_ro,
            ordered_signs_not_grouped_by_anchor._img_de_right,
            ordered_signs_not_grouped_by_anchor._img_fr_right,
            ordered_signs_not_grouped_by_anchor._img_it_right,
            ordered_signs_not_grouped_by_anchor._img_ro_right,
            ordered_signs_not_grouped_by_anchor._symbol_height,
            ordered_signs_not_grouped_by_anchor._symbol_width,
            ordered_signs_not_grouped_by_anchor._azimut_rectified,
            ordered_signs_not_grouped_by_anchor._azimut_offset_x_rectified,
            ordered_signs_not_grouped_by_anchor._azimut_offset_y_rectified,
            ordered_signs_not_grouped_by_anchor._natural_direction_or_left_rectified,
            ordered_signs_not_grouped_by_anchor._verso,
            ordered_signs_not_grouped_by_anchor._rank,
            row_number() OVER (PARTITION BY ordered_signs_not_grouped_by_anchor.support_id, ordered_signs_not_grouped_by_anchor._azimut_rectified ORDER BY ordered_signs_not_grouped_by_anchor._rank) AS _final_rank,
            COALESCE(sum(ordered_signs_not_grouped_by_anchor._symbol_height) OVER (PARTITION BY ordered_signs_not_grouped_by_anchor.support_id, ordered_signs_not_grouped_by_anchor._azimut_rectified ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING), (0)::bigint) AS _symbol_shift,
            COALESCE(sum(ordered_signs_not_grouped_by_anchor._symbol_height) OVER (PARTITION BY ordered_signs_not_grouped_by_anchor.support_id, ordered_signs_not_grouped_by_anchor._azimut_rectified), (0)::bigint) AS _group_height,
            max(ordered_signs_not_grouped_by_anchor._symbol_width) OVER (PARTITION BY ordered_signs_not_grouped_by_anchor.support_id, ordered_signs_not_grouped_by_anchor._azimut_rectified) AS _group_width,
            NULLIF(first_value(ordered_signs_not_grouped_by_anchor.id) OVER (PARTITION BY ordered_signs_not_grouped_by_anchor.support_id, ordered_signs_not_grouped_by_anchor._azimut_rectified, ordered_signs_not_grouped_by_anchor.frame_rank ROWS BETWEEN 1 PRECEDING AND CURRENT ROW), ordered_signs_not_grouped_by_anchor.id) AS _previous_sign_in_frame,
            NULLIF(last_value(ordered_signs_not_grouped_by_anchor.id) OVER (PARTITION BY ordered_signs_not_grouped_by_anchor.support_id, ordered_signs_not_grouped_by_anchor._azimut_rectified, ordered_signs_not_grouped_by_anchor.frame_rank ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING), ordered_signs_not_grouped_by_anchor.id) AS _next_sign_in_frame,
            NULLIF(first_value(ordered_signs_not_grouped_by_anchor.frame_id) OVER (PARTITION BY ordered_signs_not_grouped_by_anchor.support_id, ordered_signs_not_grouped_by_anchor._azimut_rectified ROWS BETWEEN 1 PRECEDING AND CURRENT ROW), ordered_signs_not_grouped_by_anchor.frame_id) AS _previous_frame,
            NULLIF(last_value(ordered_signs_not_grouped_by_anchor.frame_id) OVER (PARTITION BY ordered_signs_not_grouped_by_anchor.support_id, ordered_signs_not_grouped_by_anchor._azimut_rectified ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING), ordered_signs_not_grouped_by_anchor.frame_id) AS _next_frame
           FROM ordered_signs_not_grouped_by_anchor
        ), ordered_shifted_signs_grouped_by_anchor AS (
         SELECT ordered_signs_grouped_by_anchor.id,
            ordered_signs_grouped_by_anchor._inserted_date,
            ordered_signs_grouped_by_anchor._inserted_user,
            ordered_signs_grouped_by_anchor._last_modified_date,
            ordered_signs_grouped_by_anchor._last_modified_user,
            ordered_signs_grouped_by_anchor.case_decision,
            ordered_signs_grouped_by_anchor.case_id,
            ordered_signs_grouped_by_anchor.comment,
            ordered_signs_grouped_by_anchor.complex,
            ordered_signs_grouped_by_anchor.dimension_1,
            ordered_signs_grouped_by_anchor.dimension_2,
            ordered_signs_grouped_by_anchor.fk_coating,
            ordered_signs_grouped_by_anchor.fk_durability,
            ordered_signs_grouped_by_anchor.fk_lighting,
            ordered_signs_grouped_by_anchor.fk_marker_type,
            ordered_signs_grouped_by_anchor.fk_mirror_shape,
            ordered_signs_grouped_by_anchor.fk_official_sign,
            ordered_signs_grouped_by_anchor.fk_owner,
            ordered_signs_grouped_by_anchor.fk_parent,
            ordered_signs_grouped_by_anchor.fk_provider,
            ordered_signs_grouped_by_anchor.fk_sign_type,
            ordered_signs_grouped_by_anchor.fk_status,
            ordered_signs_grouped_by_anchor.fk_user_sign,
            ordered_signs_grouped_by_anchor.hanging_mode,
            ordered_signs_grouped_by_anchor.inscription_1,
            ordered_signs_grouped_by_anchor.inscription_2,
            ordered_signs_grouped_by_anchor.inscription_3,
            ordered_signs_grouped_by_anchor.installation_date,
            ordered_signs_grouped_by_anchor.manufacturing_date,
            ordered_signs_grouped_by_anchor.mirror_protruding,
            ordered_signs_grouped_by_anchor.mirror_red_frame,
            ordered_signs_grouped_by_anchor.natural_direction_or_left,
            ordered_signs_grouped_by_anchor.picture,
            ordered_signs_grouped_by_anchor.usr_sign_1,
            ordered_signs_grouped_by_anchor.usr_sign_2,
            ordered_signs_grouped_by_anchor.usr_sign_3,
            ordered_signs_grouped_by_anchor.azimut,
            ordered_signs_grouped_by_anchor.offset_x,
            ordered_signs_grouped_by_anchor.offset_y,
            ordered_signs_grouped_by_anchor.offset_x_verso,
            ordered_signs_grouped_by_anchor.offset_y_verso,
            ordered_signs_grouped_by_anchor.frame_id,
            ordered_signs_grouped_by_anchor.frame__inserted_date,
            ordered_signs_grouped_by_anchor.frame__inserted_user,
            ordered_signs_grouped_by_anchor.frame__last_modified_date,
            ordered_signs_grouped_by_anchor.frame__last_modified_user,
            ordered_signs_grouped_by_anchor.frame_anchor,
            ordered_signs_grouped_by_anchor.frame_comment,
            ordered_signs_grouped_by_anchor.frame_dimension_1,
            ordered_signs_grouped_by_anchor.frame_dimension_2,
            ordered_signs_grouped_by_anchor.frame_double_sided,
            ordered_signs_grouped_by_anchor.frame_fk_azimut,
            ordered_signs_grouped_by_anchor.frame_fk_frame_fixing_type,
            ordered_signs_grouped_by_anchor.frame_fk_frame_type,
            ordered_signs_grouped_by_anchor.frame_fk_provider,
            ordered_signs_grouped_by_anchor.frame_fk_status,
            ordered_signs_grouped_by_anchor.frame_picture,
            ordered_signs_grouped_by_anchor.frame_rank,
            ordered_signs_grouped_by_anchor.frame_usr_frame_1,
            ordered_signs_grouped_by_anchor.frame_usr_frame_2,
            ordered_signs_grouped_by_anchor.frame_usr_frame_3,
            ordered_signs_grouped_by_anchor.sign_rank,
            ordered_signs_grouped_by_anchor.support_id,
            ordered_signs_grouped_by_anchor.group_by_anchor,
            ordered_signs_grouped_by_anchor.fk_support_type,
            ordered_signs_grouped_by_anchor.fk_support_base_type,
            ordered_signs_grouped_by_anchor.support_geometry,
            ordered_signs_grouped_by_anchor.directional_sign,
            ordered_signs_grouped_by_anchor._symbol_value_de,
            ordered_signs_grouped_by_anchor._symbol_value_fr,
            ordered_signs_grouped_by_anchor._symbol_value_it,
            ordered_signs_grouped_by_anchor._symbol_value_ro,
            ordered_signs_grouped_by_anchor._img_de,
            ordered_signs_grouped_by_anchor._img_fr,
            ordered_signs_grouped_by_anchor._img_it,
            ordered_signs_grouped_by_anchor._img_ro,
            ordered_signs_grouped_by_anchor._img_de_right,
            ordered_signs_grouped_by_anchor._img_fr_right,
            ordered_signs_grouped_by_anchor._img_it_right,
            ordered_signs_grouped_by_anchor._img_ro_right,
            ordered_signs_grouped_by_anchor._symbol_height,
            ordered_signs_grouped_by_anchor._symbol_width,
            ordered_signs_grouped_by_anchor._azimut_rectified,
            ordered_signs_grouped_by_anchor._azimut_offset_x_rectified,
            ordered_signs_grouped_by_anchor._azimut_offset_y_rectified,
            ordered_signs_grouped_by_anchor._natural_direction_or_left_rectified,
            ordered_signs_grouped_by_anchor._verso,
            ordered_signs_grouped_by_anchor._rank,
            row_number() OVER (PARTITION BY ordered_signs_grouped_by_anchor.support_id, ordered_signs_grouped_by_anchor._azimut_rectified, ordered_signs_grouped_by_anchor.frame_anchor ORDER BY ordered_signs_grouped_by_anchor._rank) AS _final_rank,
            COALESCE(sum(ordered_signs_grouped_by_anchor._symbol_height) OVER (PARTITION BY ordered_signs_grouped_by_anchor.support_id, ordered_signs_grouped_by_anchor._azimut_rectified, ordered_signs_grouped_by_anchor.frame_anchor ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING), (0)::bigint) AS _symbol_shift,
            COALESCE(sum(ordered_signs_grouped_by_anchor._symbol_height) OVER (PARTITION BY ordered_signs_grouped_by_anchor.support_id, ordered_signs_grouped_by_anchor._azimut_rectified, ordered_signs_grouped_by_anchor.frame_anchor), (0)::bigint) AS _group_height,
            max(ordered_signs_grouped_by_anchor._symbol_width) OVER (PARTITION BY ordered_signs_grouped_by_anchor.support_id, ordered_signs_grouped_by_anchor._azimut_rectified, ordered_signs_grouped_by_anchor.frame_anchor) AS _group_width,
            NULLIF(first_value(ordered_signs_grouped_by_anchor.id) OVER (PARTITION BY ordered_signs_grouped_by_anchor.support_id, ordered_signs_grouped_by_anchor._azimut_rectified, ordered_signs_grouped_by_anchor.frame_anchor, ordered_signs_grouped_by_anchor.frame_rank ROWS BETWEEN 1 PRECEDING AND CURRENT ROW), ordered_signs_grouped_by_anchor.id) AS _previous_sign_in_frame,
            NULLIF(last_value(ordered_signs_grouped_by_anchor.id) OVER (PARTITION BY ordered_signs_grouped_by_anchor.support_id, ordered_signs_grouped_by_anchor._azimut_rectified, ordered_signs_grouped_by_anchor.frame_anchor, ordered_signs_grouped_by_anchor.frame_rank ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING), ordered_signs_grouped_by_anchor.id) AS _next_sign_in_frame,
            NULLIF(first_value(ordered_signs_grouped_by_anchor.frame_id) OVER (PARTITION BY ordered_signs_grouped_by_anchor.support_id, ordered_signs_grouped_by_anchor._azimut_rectified, ordered_signs_grouped_by_anchor.frame_anchor ROWS BETWEEN 1 PRECEDING AND CURRENT ROW), ordered_signs_grouped_by_anchor.frame_id) AS _previous_frame,
            NULLIF(last_value(ordered_signs_grouped_by_anchor.frame_id) OVER (PARTITION BY ordered_signs_grouped_by_anchor.support_id, ordered_signs_grouped_by_anchor._azimut_rectified, ordered_signs_grouped_by_anchor.frame_anchor ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING), ordered_signs_grouped_by_anchor.frame_id) AS _next_frame
           FROM ordered_signs_grouped_by_anchor
        ), union_view AS (
         SELECT ossng.id,
            ossng._inserted_date,
            ossng._inserted_user,
            ossng._last_modified_date,
            ossng._last_modified_user,
            ossng.case_decision,
            ossng.case_id,
            ossng.comment,
            ossng.complex,
            ossng.dimension_1,
            ossng.dimension_2,
            ossng.fk_coating,
            ossng.fk_durability,
            ossng.fk_lighting,
            ossng.fk_marker_type,
            ossng.fk_mirror_shape,
            ossng.fk_official_sign,
            ossng.fk_owner,
            ossng.fk_parent,
            ossng.fk_provider,
            ossng.fk_sign_type,
            ossng.fk_status,
            ossng.fk_user_sign,
            ossng.hanging_mode,
            ossng.inscription_1,
            ossng.inscription_2,
            ossng.inscription_3,
            ossng.installation_date,
            ossng.manufacturing_date,
            ossng.mirror_protruding,
            ossng.mirror_red_frame,
            ossng.natural_direction_or_left,
            ossng.picture,
            ossng.usr_sign_1,
            ossng.usr_sign_2,
            ossng.usr_sign_3,
            ossng.azimut,
            ossng.offset_x,
            ossng.offset_y,
            ossng.offset_x_verso,
            ossng.offset_y_verso,
            ossng.frame_id,
            ossng.frame__inserted_date,
            ossng.frame__inserted_user,
            ossng.frame__last_modified_date,
            ossng.frame__last_modified_user,
            ossng.frame_anchor,
            ossng.frame_comment,
            ossng.frame_dimension_1,
            ossng.frame_dimension_2,
            ossng.frame_double_sided,
            ossng.frame_fk_azimut,
            ossng.frame_fk_frame_fixing_type,
            ossng.frame_fk_frame_type,
            ossng.frame_fk_provider,
            ossng.frame_fk_status,
            ossng.frame_picture,
            ossng.frame_rank,
            ossng.frame_usr_frame_1,
            ossng.frame_usr_frame_2,
            ossng.frame_usr_frame_3,
            ossng.sign_rank,
            ossng.support_id,
            ossng.group_by_anchor,
            ossng.fk_support_type,
            ossng.fk_support_base_type,
            ossng.support_geometry,
            ossng.directional_sign,
            ossng._symbol_value_de,
            ossng._symbol_value_fr,
            ossng._symbol_value_it,
            ossng._symbol_value_ro,
            ossng._img_de,
            ossng._img_fr,
            ossng._img_it,
            ossng._img_ro,
            ossng._img_de_right,
            ossng._img_fr_right,
            ossng._img_it_right,
            ossng._img_ro_right,
            ossng._symbol_height,
            ossng._symbol_width,
            ossng._azimut_rectified,
            ossng._azimut_offset_x_rectified,
            ossng._azimut_offset_y_rectified,
            ossng._natural_direction_or_left_rectified,
            ossng._verso,
            ossng._rank,
            ossng._final_rank,
            ossng._symbol_shift,
            ossng._group_height,
            ossng._group_width,
            ossng._previous_sign_in_frame,
            ossng._next_sign_in_frame,
            ossng._previous_frame,
            ossng._next_frame
           FROM ordered_shifted_signs_not_grouped_by_anchor ossng
        UNION
         SELECT ossg.id,
            ossg._inserted_date,
            ossg._inserted_user,
            ossg._last_modified_date,
            ossg._last_modified_user,
            ossg.case_decision,
            ossg.case_id,
            ossg.comment,
            ossg.complex,
            ossg.dimension_1,
            ossg.dimension_2,
            ossg.fk_coating,
            ossg.fk_durability,
            ossg.fk_lighting,
            ossg.fk_marker_type,
            ossg.fk_mirror_shape,
            ossg.fk_official_sign,
            ossg.fk_owner,
            ossg.fk_parent,
            ossg.fk_provider,
            ossg.fk_sign_type,
            ossg.fk_status,
            ossg.fk_user_sign,
            ossg.hanging_mode,
            ossg.inscription_1,
            ossg.inscription_2,
            ossg.inscription_3,
            ossg.installation_date,
            ossg.manufacturing_date,
            ossg.mirror_protruding,
            ossg.mirror_red_frame,
            ossg.natural_direction_or_left,
            ossg.picture,
            ossg.usr_sign_1,
            ossg.usr_sign_2,
            ossg.usr_sign_3,
            ossg.azimut,
            ossg.offset_x,
            ossg.offset_y,
            ossg.offset_x_verso,
            ossg.offset_y_verso,
            ossg.frame_id,
            ossg.frame__inserted_date,
            ossg.frame__inserted_user,
            ossg.frame__last_modified_date,
            ossg.frame__last_modified_user,
            ossg.frame_anchor,
            ossg.frame_comment,
            ossg.frame_dimension_1,
            ossg.frame_dimension_2,
            ossg.frame_double_sided,
            ossg.frame_fk_azimut,
            ossg.frame_fk_frame_fixing_type,
            ossg.frame_fk_frame_type,
            ossg.frame_fk_provider,
            ossg.frame_fk_status,
            ossg.frame_picture,
            ossg.frame_rank,
            ossg.frame_usr_frame_1,
            ossg.frame_usr_frame_2,
            ossg.frame_usr_frame_3,
            ossg.sign_rank,
            ossg.support_id,
            ossg.group_by_anchor,
            ossg.fk_support_type,
            ossg.fk_support_base_type,
            ossg.support_geometry,
            ossg.directional_sign,
            ossg._symbol_value_de,
            ossg._symbol_value_fr,
            ossg._symbol_value_it,
            ossg._symbol_value_ro,
            ossg._img_de,
            ossg._img_fr,
            ossg._img_it,
            ossg._img_ro,
            ossg._img_de_right,
            ossg._img_fr_right,
            ossg._img_it_right,
            ossg._img_ro_right,
            ossg._symbol_height,
            ossg._symbol_width,
            ossg._azimut_rectified,
            ossg._azimut_offset_x_rectified,
            ossg._azimut_offset_y_rectified,
            ossg._natural_direction_or_left_rectified,
            ossg._verso,
            ossg._rank,
            ossg._final_rank,
            ossg._symbol_shift,
            ossg._group_height,
            ossg._group_width,
            ossg._previous_sign_in_frame,
            ossg._next_sign_in_frame,
            ossg._previous_frame,
            ossg._next_frame
           FROM ordered_shifted_signs_grouped_by_anchor ossg
        )
 SELECT ((uv.id || '-'::text) || (uv._verso)::integer) AS pk,
    uv.id,
    uv._inserted_date,
    uv._inserted_user,
    uv._last_modified_date,
    uv._last_modified_user,
    uv.case_decision,
    uv.case_id,
    uv.comment,
    uv.complex,
    uv.dimension_1,
    uv.dimension_2,
    uv.fk_coating,
    uv.fk_durability,
    uv.fk_lighting,
    uv.fk_marker_type,
    uv.fk_mirror_shape,
    uv.fk_official_sign,
    uv.fk_owner,
    uv.fk_parent,
    uv.fk_provider,
    uv.fk_sign_type,
    uv.fk_status,
    uv.fk_user_sign,
    uv.hanging_mode,
    uv.inscription_1,
    uv.inscription_2,
    uv.inscription_3,
    uv.installation_date,
    uv.manufacturing_date,
    uv.mirror_protruding,
    uv.mirror_red_frame,
    uv.natural_direction_or_left,
    uv.picture,
    uv.usr_sign_1,
    uv.usr_sign_2,
    uv.usr_sign_3,
    uv.azimut,
    uv.offset_x,
    uv.offset_y,
    uv.offset_x_verso,
    uv.offset_y_verso,
    uv.frame_id,
    uv.frame__inserted_date,
    uv.frame__inserted_user,
    uv.frame__last_modified_date,
    uv.frame__last_modified_user,
    uv.frame_anchor,
    uv.frame_comment,
    uv.frame_dimension_1,
    uv.frame_dimension_2,
    uv.frame_double_sided,
    uv.frame_fk_azimut,
    uv.frame_fk_frame_fixing_type,
    uv.frame_fk_frame_type,
    uv.frame_fk_provider,
    uv.frame_fk_status,
    uv.frame_picture,
    uv.frame_rank,
    uv.frame_usr_frame_1,
    uv.frame_usr_frame_2,
    uv.frame_usr_frame_3,
    uv.sign_rank,
    uv.support_id,
    uv.group_by_anchor,
    uv.fk_support_type,
    uv.fk_support_base_type,
    uv.support_geometry,
    uv.directional_sign,
    uv._symbol_value_de,
    uv._symbol_value_fr,
    uv._symbol_value_it,
    uv._symbol_value_ro,
    uv._img_de,
    uv._img_fr,
    uv._img_it,
    uv._img_ro,
    uv._img_de_right,
    uv._img_fr_right,
    uv._img_it_right,
    uv._img_ro_right,
    uv._symbol_height,
    uv._symbol_width,
    uv._azimut_rectified,
    uv._azimut_offset_x_rectified,
    uv._azimut_offset_y_rectified,
    uv._natural_direction_or_left_rectified,
    uv._verso,
    uv._rank,
    uv._final_rank,
    uv._symbol_shift,
    uv._group_height,
    uv._group_width,
    uv._previous_sign_in_frame,
    uv._next_sign_in_frame,
    uv._previous_frame,
    uv._next_frame,
    max(uv._group_height) OVER (PARTITION BY uv.support_id, uv.azimut, uv._verso) AS _max_shift_for_azimut,
        CASE
            WHEN ((uv.directional_sign IS TRUE) AND ((((uv.frame_anchor = 'LEFT'::signalo_db.anchor) AND (uv._natural_direction_or_left_rectified = true)) OR ((uv.frame_anchor = 'CENTER'::signalo_db.anchor) AND (uv._natural_direction_or_left_rectified = false))) OR ((uv.frame_anchor = 'RIGHT'::signalo_db.anchor) AND (uv._natural_direction_or_left_rectified = false)))) THEN '_right'::text
            ELSE ''::text
        END AS _img_direction
   FROM union_view uv;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views