v_export_bal

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

uid_adresse

text

2147483647

√

null

cle_interop

text

2147483647

√

null

commune_insee

bpchar

√

null

commune_nom

text

2147483647

√

null

commune_deleguee_insee

bpchar

√

null

commune_deleguee_nom

text

2147483647

√

null

voie_nom

text

2147483647

√

null

lieudit_complement_nom

text

2147483647

√

null

numero

int4

√

null

suffixe

text

2147483647

√

null

position

text

2147483647

√

null

float8

17,17

√

null

float8

17,17

√

null

long

numeric

131089

√

null

lat

numeric

131089

√

null

cad_parcelles

text

2147483647

√

null

source

text

2147483647

√

null

date_der_maj

date

√

null

View Definition

SELECT ''::text AS uid_adresse,
        CASE
            WHEN ((p.suffixe IS NOT NULL) AND (v.code_fantoir IS NOT NULL)) THEN concat(c.insee_code, '_', (v.code_fantoir)::text, '_', lpad((p.numero)::text, 5, '0'::text), '_', p.suffixe)
            WHEN ((p.suffixe IS NULL) AND (v.code_fantoir IS NULL)) THEN concat(c.insee_code, '_', 'xxxx', '_', lpad((p.numero)::text, 5, '0'::text))
            WHEN ((p.suffixe IS NULL) AND (v.code_fantoir IS NOT NULL)) THEN concat(c.insee_code, '_', (v.code_fantoir)::text, '_', lpad((p.numero)::text, 5, '0'::text))
            WHEN ((p.suffixe IS NOT NULL) AND (v.code_fantoir IS NULL)) THEN concat(c.insee_code, '_', 'xxxx', '_', lpad((p.numero)::text, 5, '0'::text), '_', p.suffixe)
            ELSE NULL::text
        END AS cle_interop,
    c.insee_code AS commune_insee,
    c.commune_nom,
    cd.insee_code AS commune_deleguee_insee,
    cd.commune_deleguee_nom,
    v.nom_complet AS voie_nom,
    p.lieudit_complement_nom,
    p.numero,
    p.suffixe,
    p.type_pos AS "position",
    st_x(p.geom) AS x,
    st_y(p.geom) AS y,
    round((st_x(st_transform(p.geom, 4326)))::numeric, 10) AS long,
    round((st_y(st_transform(p.geom, 4326)))::numeric, 10) AS lat,
    g.id AS cad_parcelles,
    c.commune_nom AS source,
    p.date_modif AS date_der_maj
   FROM (((((adresse.point_adresse p
     LEFT JOIN adresse.commune c ON ((p.id_commune = c.id_com)))
     LEFT JOIN adresse.referencer_com rc ON ((p.id_commune = rc.id_com)))
     LEFT JOIN adresse.commune_deleguee cd ON ((cd.id_com_del = rc.id_com_deleguee)))
     LEFT JOIN adresse.voie v ON ((p.id_voie = v.id_voie)))
     LEFT JOIN adresse.parcelle g ON ((p.id_parcelle = g.fid)))
UNION
 SELECT ''::text AS uid_adresse,
    concat(c.insee_code, '_', 'xxxx', '_', ld.numero) AS cle_interop,
    c.insee_code AS commune_insee,
    c.commune_nom,
    cd.insee_code AS commune_deleguee_insee,
    cd.commune_deleguee_nom,
    ld.nom_ld AS voie_nom,
    ''::character varying(255) AS lieudit_complement_nom,
    ld.numero,
    ''::text AS suffixe,
    ''::text AS "position",
    st_x(ld.geom) AS x,
    st_y(ld.geom) AS y,
    round((st_x(st_transform(ld.geom, 4326)))::numeric, 10) AS long,
    round((st_y(st_transform(ld.geom, 4326)))::numeric, 10) AS lat,
    ''::text AS cad_parcelles,
    c.commune_nom AS source,
    ld.date_der_maj
   FROM (((adresse.lieux_dits ld
     LEFT JOIN adresse.commune c ON ((c.id_com = ld.id_com)))
     LEFT JOIN adresse.referencer_com rc ON ((ld.id_com = rc.id_com)))
     LEFT JOIN adresse.commune_deleguee cd ON ((cd.id_com_del = rc.id_com_deleguee)))
  WHERE (ld.integration_ban = true);

Columns

View Definition

Possibly Referenced Tables/Views