Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id_opendata | varchar | 60 | null |
|
|
Identifiant open data de la mutation. |
||||
| batiment_groupe_id | varchar | 22 | null |
|
|
Clé d’Intéropérabilité du groupe de bâtiment dans la BDNB |
||||
| parcelle_unifiee_id | varchar | 22 | null |
|
|
Identifiant de la parcelle unifiée. |
||||
| code_departement_insee | varchar | 2 | null |
|
|
Département du groupe de bâtiments. |
||||
| fiabilite_croisement | varchar | 10 | √ | null |
|
|
Fiabilite de l’appariement entre les batiments groupes et les mutations. La fiabilité est forte si l’ensemble des locaux de la mutation se situent sur un unique bâtiment groupe. La fiabilité est faible si les locaux de la mutation ne peuvent être associés à un unique bâtiment groupe. |
|||
| join_id_opendata | bool | 1 | √ | null |
|
|
L’appariement a été réalisé à partir de l’id_opendata en le croisant avec les dv3f. |
|||
| join_geom_local | bool | 1 | √ | null |
|
|
L’appariement a été réalisé à partir de la présence du localisant ponctuel du local ayant muté au sein de la géométrie de la parcelle unifiée. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| rel_batiment_groupe_dvf_open_pk_id | Primary key | Asc/Asc | id_opendata + batiment_groupe_id |
| rel_batiment_groupe_dvf_open_batiment_groupe_id_idx | Performance | Asc | batiment_groupe_id |
| rel_batiment_groupe_dvf_open_code_departement_insee_idx | Performance | Asc | code_departement_insee |
| rel_batiment_groupe_dvf_open_parcelle_unifiee_id_idx | Performance | Asc | parcelle_unifiee_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| rel_batiment_groupe_dvf_open_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
