rel_batiment_adresse

20080072 rows


Description

Table de relation entre les adresses et les bâtiments des fichiers fonciers en utilisant les informations FANTOIR de l’adressage des fichiers fonciers pour générer les clefs d’intéropérabilité BAN correspondantes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
batiment_id varchar 16 null
batiment.batiment_id rel_batiment_adresse_batiment_id_fkeyR

(ffo:idbat) Identifiant du bâtiment au sens des fichiers fonciers
cle_interop_adr text 2147483647 null
adresse.cle_interop_adr rel_batiment_adresse_cle_interop_adr_fkeyR

(bdnb) Clé d’intéropérabilité des adresses géoréférencées (“Fichiers Fonciers”, “BAN” ou “Arcep”)
code_departement_insee varchar 2 null

(insee) Code département INSEE
origine varchar 2147483647 null

Origine du lien batiment_adresse (’Géocodage, Reconstruction Fantoir ou les 2) Permet également de s’assurer de la fiabilité du lien. Un lien validé par 2 méthodes est considéré comme plus fiable que par une seule méthode.

Indexes

Constraint Name Type Sort Column(s)
rel_batiment_adresse_pk_id Primary key Asc/Asc batiment_id + cle_interop_adr
rel_batiment_adresse_cle_interop_adr_idx Performance Asc cle_interop_adr
rel_batiment_adresse_code_departement_insee_idx Performance Asc code_departement_insee

Check Constraints

Constraint Name Constraint
rel_batiment_adresse_loading_origine_check (((origine)::text = ANY ((ARRAY['Geocodage + Reconstruction Fantoire'::character varying, 'Reconstruction Fantoire'::character varying, 'Geocodage'::character varying])::text[])))
rel_batiment_adresse_loading_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