adresse

26943304 rows


Description

Table de description des adresses. Les adresses dans la BDNB sont un sous-ensemble des adresses BAN de type housenumber (adressage au numéro) et uniquement localisé en France hexagonale et Corse. Des adresses ARCEP viennent compléter les adresses BAN quand ces adresses n’existent pas dans la BAN. Les géolocalisants ponctuels sont au format Lambert-93 (ESPG:2154).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
cle_interop_adr text 2147483647 null
adresse_metrique.cle_interop_adr adresse_metrique_cle_interop_adr_fkeyR
rel_batiment_adresse.cle_interop_adr rel_batiment_adresse_cle_interop_adr_fkeyR
rel_batiment_construction_adresse.cle_interop_adr rel_batiment_construction_adresse_cle_interop_adr_fkeyR
rel_batiment_groupe_adresse.cle_interop_adr rel_batiment_groupe_adresse_cle_interop_adr_fkeyR
rel_batiment_groupe_dpe_logement.cle_interop_adr rel_batiment_groupe_dpe_logement_cle_interop_adr_fkeyR
rel_batiment_groupe_rnc.cle_interop_adr rel_batiment_groupe_rnc_cle_interop_adr_fkeyR
rel_batiment_groupe_rpls.cle_interop_adr rel_batiment_groupe_rpls_cle_interop_adr_fkeyR

(BAN/Arcep) Clé d’interopérabilité de l’adresse postale
code_departement_insee varchar 2 null

Code département INSEE
numero int4 10 √ null

Numéro de l’adresse
rep text 2147483647 √ null

Indice de répétition du numéro de l’adresse
type_voie text 2147483647 √ null

Type de voie
nom_voie text 2147483647 null

Nom de la voie
libelle_adresse text 2147483647 null

Libellé complet de l’adresse
code_postal varchar 5 √ null

Code postal
code_commune_insee varchar 5 null

Code INSEE de la commune
libelle_commune text 2147483647 null

Libellé de la commune
source text 2147483647 null

Source de l’adresse
geom_adresse geometry 2147483647 null

Géométrie de l’adresse (Lambert-93)

Indexes

Constraint Name Type Sort Column(s)
adresse_pk_id Primary key Asc cle_interop_adr
adresse_code_departement_insee_idx Performance Asc code_departement_insee
adresse_geom_adresse_idx Performance Asc geom_adresse

Check Constraints

Constraint Name Constraint
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[])))
adresse_loading_source_check ((source = ANY (ARRAY['Arcep'::text, 'BAN'::text])))

Relationships

Close relationships within degrees of separation