rel_batiment_construction_adresse

40120880 rows


Description

Table de relation entre les adresses postales BAN/Arcep et les entrées de la table batiment_construction. Pour plus d’informations voir la méthodologie détaillée d’association des adresses aux bâtiments, publiée sur le site de la BDNB.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
batiment_construction_id text 2147483647 null
batiment_construction.batiment_construction_id rel_batiment_construction_adresse_batiment_construction_id_fkeyR

(BDNB) Identifiant des objets “bâtiment construction”. Equivalent aux objets “bâtiment” de la BDTopo, mais ré-allotis à une unité foncière. Celle table intègre également des géométries fictives, comblant les “trous” de la BDTopo
cle_interop_adr text 2147483647 null
adresse.cle_interop_adr rel_batiment_construction_adresse_cle_interop_adr_fkeyR

(BAN/Arcep) Clé d’interopérabilité de l’adresse postale (BAN si elle existe, sinon Arcep)
code_departement_insee varchar 2 null

(BDNB) Code département INSEE
distance_batiment_construction_adresse int4 10 null

(BDNB) Distance entre le géolocalisant adresse et la géométrie de bâtiment
fiabilite int4 10 null

(BDNB) Score de fiabilité de la relation Adresse-Construction, valeur comprise entre 12 et 0. Plus une relation est fiable, plus ce score est élevé.
adresse_principale bool 1 null

(BDNB) Booléen précisant si l’adresse courante est l’une des adresses principales de la construction ou non. Une relation est taguée comme principale si l’adresse qui la compose obtient le score de fiabilité le plus important parmi toutes les adresses desservant une même construction. Il se peut, par conséquent, qu’une construction ait plusieurs adresses principales : toutes celles ayant le score de fiabilité le plus haut pour cette construction.
geom_batiment_construction_adresse geometry 2147483647 √ null

(BDNB) Géolocalisant du trait reliant le point adresse à la géométrie de la construction (Lambert-93, SRID=2154)

Indexes

Constraint Name Type Sort Column(s)
rel_batiment_construction_adresse_pk_id Primary key Asc/Asc batiment_construction_id + cle_interop_adr
rel_batiment_construction_adresse_cle_interop_adr_idx Performance Asc cle_interop_adr
rel_batiment_construction_adresse_code_departement_insee_idx Performance Asc code_departement_insee
rel_batiment_construction_adresse_geom_batiment_construction_ad Performance Asc geom_batiment_construction_adresse

Check Constraints

Constraint Name Constraint
rel_batiment_construction_ad_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