rel_batiment_groupe_rpls

5383413 rows


Description

Table de relation entre les bâtiments de la BDNB et les éléments de la table RPLS 2022

Columns

Column Type Size Nulls Auto Default Children Parents Comments
batiment_groupe_id varchar 30 null

Clé d’Intéropérabilité du groupe de bâtiment dans la BDNB
ident_rpls varchar 2147483647 null

identifiant rpls de la source
code_departement_insee varchar 2 √ null

département du bâtiment
cle_interop_adr text 2147483647 √ null
adresse.cle_interop_adr rel_batiment_groupe_rpls_cle_interop_adr_fkeyR

clé d’interopérabilité de l’adresse géocodée
adresse_brut text 2147483647 √ null

adresse brute envoyée au géocodeur
adresse_geocodee text 2147483647 √ null

libelle de l’adresse retournée par le géocodeur
fiabilite_geocodage text 2147483647 √ null

fiabilité du géocodage
fiabilite_globale text 2147483647 √ null

fiabilité du global du croissemnt
batiment_id text 2147483647 √ null

batiment_id
local_id text 2147483647 √ null

local_id
rpls_open bool 1 √ null

True si rpls est dans la base de données open

Indexes

Constraint Name Type Sort Column(s)
rel_batiment_groupe_rpls_pk_id Primary key Asc/Asc batiment_groupe_id + ident_rpls
rel_batiment_groupe_rpls_cle_interop_adr_idx Performance Asc cle_interop_adr
rel_batiment_groupe_rpls_code_departement_insee_idx Performance Asc code_departement_insee

Check Constraints

Constraint Name Constraint
rel_batiment_groupe_rpls_loa_code_departement_insee_check (((code_departement_insee)::text = ANY ((ARRAY['01'::character varying, '02'::character varying, '03'::character varying, '04'::character varying, '05'::character varying, '06'::character varying, '07'::character varying, '08'::character varying, '09'::character varying, '10'::character varying, '11'::character varying, '12'::character varying, '13'::character varying, '14'::character varying, '15'::character varying, '16'::character varying, '17'::character varying, '18'::character varying, '19'::character varying, '21'::character varying, '22'::character varying, '23'::character varying, '24'::character varying, '25'::character varying, '26'::character varying, '27'::character varying, '28'::character varying, '29'::character varying, '2A'::character varying, '2B'::character varying, '30'::character varying, '31'::character varying, '32'::character varying, '33'::character varying, '34'::character varying, '35'::character varying, '36'::character varying, '37'::character varying, '38'::character varying, '39'::character varying, '40'::character varying, '41'::character varying, '42'::character varying, '43'::character varying, '44'::character varying, '45'::character varying, '46'::character varying, '47'::character varying, '48'::character varying, '49'::character varying, '50'::character varying, '51'::character varying, '52'::character varying, '53'::character varying, '54'::character varying, '55'::character varying, '56'::character varying, '57'::character varying, '58'::character varying, '59'::character varying, '60'::character varying, '61'::character varying, '62'::character varying, '63'::character varying, '64'::character varying, '65'::character varying, '66'::character varying, '67'::character varying, '68'::character varying, '69'::character varying, '70'::character varying, '71'::character varying, '72'::character varying, '73'::character varying, '74'::character varying, '75'::character varying, '76'::character varying, '77'::character varying, '78'::character varying, '79'::character varying, '80'::character varying, '81'::character varying, '82'::character varying, '83'::character varying, '84'::character varying, '85'::character varying, '86'::character varying, '87'::character varying, '88'::character varying, '89'::character varying, '90'::character varying, '91'::character varying, '92'::character varying, '93'::character varying, '94'::character varying, '95'::character varying])::text[])))

Relationships

Close relationships within degrees of separation