batiment_private_v064


Description

vue privé BDNB- export ponctuel pour le CGDD. Filtrage manuel par ABreit. Sources https://gitlab.com/gorenove/fabrik/bdnb_forge/-/tree/v06_maintenance/pipeline/09_extract

Columns

Column Type Size Nulls Auto Default Children Parents Comments
bnb_id varchar 30 √ null
etaban202111_id text 2147483647 √ null
etaban202111_l_id _text 2147483647 √ null
arcthd2021t1_l_id _text 2147483647 √ null
igntop202103_bat_l_id _text 2147483647 √ null
adedpe202006_logtype_numero_dpe varchar 13 √ null
adedpe202006_l_numero_dpe _text 2147483647 √ null
anarnc202012_l_id _text 2147483647 √ null
ancqpv201410_id text 2147483647 √ null
dhurpl2019_l_id _text 2147483647 √ null
insbpe2019_l_id _text 2147483647 √ null
mcumer202007_id text 2147483647 √ null
mtedle2019_elec_l_id _text 2147483647 √ null
mtedle2019_gaz_l_id _text 2147483647 √ null
osmgeo202103_l_id _text 2147483647 √ null
cerffo2020_l_idpar _varchar 2147483647 √ null
etaban202111_label text 2147483647 √ null
etaban202111_nb_adresse int4 10 √ null
departement varchar 2 √ null
code_insee varchar 5 √ null
code_iris varchar 9 √ null
commune text 2147483647 √ null
arcthd2021t1_l_bat_cat "enumeration"."_enum_catg_loc_imb" 2147483647 √ null
arcthd2021t1_l_nom _text 2147483647 √ null
arcthd2021t1_nb_pdl int4 10 √ null
arcthd2021t1_l_bat_type "enumeration"."_enum_type_imb" 2147483647 √ null
mtedle2019_elec_conso_pro numeric 17,3 √ null
mtedle2019_elec_conso_res numeric 17,3 √ null
mtedle2019_gaz_conso_pro numeric 17,3 √ null
mtedle2019_gaz_conso_res numeric 17,3 √ null
mtedle2019_gaz_conso_tot numeric 17,3 √ null
mtedle2019_elec_conso_tot numeric 17,3 √ null
mtedle2019_gaz_nb_pdl_pro numeric 17,3 √ null
mtedle2019_gaz_nb_pdl_res numeric 17,3 √ null
mtedle2019_elec_nb_pdl_pro numeric 17,3 √ null
mtedle2019_elec_nb_pdl_res numeric 17,3 √ null
adedpe202006_logtype_classe_conso_ener "enumeration"."enum_class_dpe" 2147483647 √ null
adedpe202006_logtype_classe_estim_ges "enumeration"."enum_class_dpe" 2147483647 √ null
adedpe202006_logtype_conso_ener numeric 12,2 √ null
adedpe202006_logtype_estim_ges numeric 12,2 √ null
adedpe202006_mean_class_conso_ener "enumeration"."enum_class_dpe" 2147483647 √ null
adedpe202006_mean_conso_ener numeric 11,1 √ null
adedpe202006_std_conso_ener numeric 11,1 √ null
adedpe202006_mean_estim_ges numeric 11,1 √ null
adedpe202006_std_estim_ges numeric 11,1 √ null
adedpe202006_mean_class_estim_ges "enumeration"."enum_class_dpe" 2147483647 √ null
adedpe202006_nb_classe_ene_a int4 10 √ null
adedpe202006_nb_classe_ene_b int4 10 √ null
adedpe202006_nb_classe_ene_c int4 10 √ null
adedpe202006_nb_classe_ene_d int4 10 √ null
adedpe202006_nb_classe_ene_e int4 10 √ null
adedpe202006_nb_classe_ene_f int4 10 √ null
adedpe202006_nb_classe_ene_g int4 10 √ null
adedpe202006_nb_classe_ene_nc int4 10 √ null
adedpe202006_nb_classe_ges_a int4 10 √ null
adedpe202006_nb_classe_ges_b int4 10 √ null
adedpe202006_nb_classe_ges_c int4 10 √ null
adedpe202006_nb_classe_ges_d int4 10 √ null
adedpe202006_nb_classe_ges_e int4 10 √ null
adedpe202006_nb_classe_ges_f int4 10 √ null
adedpe202006_nb_classe_ges_g int4 10 √ null
adedpe202006_nb_classe_ges_nc int4 10 √ null
adedpe202006_logtype_inertie text 2147483647 √ null
cerffo2020_mat_mur_txt "enumeration"."enum_cerffo2020_mat_mur" 2147483647 √ null
adedpe202006_logtype_mur_mat_ext text 2147483647 √ null
adedpe202006_logtype_mur_ep_mat_ext text 2147483647 √ null
adedpe202006_logtype_mur_pos_isol_ext text 2147483647 √ null
adedpe202006_logtype_mur_u_ext numeric 10,3 √ null
adedpe202006_logtype_perc_surf_vitree_ext numeric 4,3 √ null
cerffo2020_mat_toit_txt "enumeration"."enum_cerffo2020_mat_toit" 2147483647 √ null
adedpe202006_logtype_ph_mat text 2147483647 √ null
adedpe202006_logtype_ph_pos_isol text 2147483647 √ null
adedpe202006_logtype_ph_type_adjacence text 2147483647 √ null
adedpe202006_logtype_ph_u numeric 10,3 √ null
adedpe202006_logtype_pb_mat text 2147483647 √ null
adedpe202006_logtype_pb_pos_isol text 2147483647 √ null
adedpe202006_logtype_pb_type_adjacence text 2147483647 √ null
adedpe202006_logtype_pb_u numeric 10,3 √ null
adedpe202006_logtype_baie_orientation _text 2147483647 √ null
adedpe202006_logtype_baie_mat text 2147483647 √ null
adedpe202006_logtype_baie_type_vitrage text 2147483647 √ null
adedpe202006_logtype_baie_remplissage text 2147483647 √ null
adedpe202006_logtype_baie_fs numeric 10,3 √ null
adedpe202006_logtype_baie_u numeric 10,3 √ null
adedpe202006_logtype_avancee_masque_max text 2147483647 √ null
anarnc202012_l_type_chauffage _text 2147483647 √ null
adedpe202006_logtype_ch_type_inst text 2147483647 √ null
adedpe202006_logtype_ch_gen_lib_princ text 2147483647 √ null
adedpe202006_logtype_ch_gen_lib_appoint text 2147483647 √ null
adedpe202006_logtype_ch_is_solaire bool 1 √ null
adedpe202006_logtype_ch_type_ener_corr text 2147483647 √ null
adedpe202006_logtype_ecs_type_inst text 2147483647 √ null
adedpe202006_logtype_ecs_gen_lib_princ text 2147483647 √ null
adedpe202006_logtype_ecs_gen_lib_appoint text 2147483647 √ null
adedpe202006_logtype_ecs_is_solaire bool 1 √ null
adedpe202006_logtype_ecs_type_ener text 2147483647 √ null
adedpe202006_logtype_type_ventilation text 2147483647 √ null
adedpe202006_logtype_presence_climatisation bool 1 √ null
adedpe202006_logtype_enr text 2147483647 √ null
adedpe202006_logtype_traversant text 2147483647 √ null
adedpe202006_logtype_type_batiment text 2147483647 √ null
adedpe202006_logtype_date_reception_dpe date 13 √ null
adedpe202006_logtype_nom_methode_dpe text 2147483647 √ null
adedpe202006_logtype_presence_balcon bool 1 √ null
adedpe202006_l_ecs_gen_princ _text 2147483647 √ null
adedpe202006_l_ch_gen_princ _text 2147483647 √ null
cerdvf2021v5_mean_valeur_fonc_par_m2_hab numeric 10,2 √ null
cerdvf2021v5_logtype_valeur_fonc_par_m2_hab int8 19 √ null
cerdvf2021v5_logtype_s_hab_mut int8 19 √ null
cerdvf2021v5_logtype_date_mut date 13 √ null
cerffo2020_annee_construction int4 10 √ null
cerffo2020_nb_log int4 10 √ null
cerffo2020_usage_principal text 2147483647 √ null
cerffo2020_usage_niveau_1_txt "enumeration"."enum_cerffo2020_usag_niv1" 2147483647 √ null
cerffo2020_nb_niveau int4 10 √ null
cerffo2020_l_prop_or_gest_denomination _text 2147483647 √ null
cerffo2020_l_siren _varchar 2147483647 √ null
cerffo2020_nb_prop_bailleur int4 10 √ null
cerffo2020_nb_prop_pm int4 10 √ null
cerffo2020_nb_loc_com int4 10 √ null
cerffo2020_nb_log_soc int4 10 √ null
cerffo2020_s_tup int8 19 √ null
cerffo2020_idtup varchar 14 √ null
geombui geometry 2147483647 √ null
igntop202103_bat_hauteur numeric 7,2 √ null
dist_ban_tup int4 10 √ null
altitude_sol int4 10 √ null
geoarg2020_alea "enumeration"."enum_alea_arg_type" 2147483647 √ null
georad2020_alea "enumeration"."enum_alea_rad_type" 2147483647 √ null
mcumer202007_dist500min int4 10 √ null
mcumer202007_is_mer bool 1 √ null
mcumer202007_tico text 2147483647 √ null
ancqpv201410_is_qpv bool 1 √ null
ancqpv201410_nom_qp text 2147483647 √ null
osmgeo202103_name text 2147483647 √ null
osmgeo202103_l_fclass _text 2147483647 √ null
insbpe2019_l_type_equipement _text 2147483647 √ null
adr_fiabilite_niv_1 "enumeration"."enum_fiab_bat_niv1_v064" 2147483647 √ null
adr_fiabilite_niv_2 "enumeration"."enum_fiab_bat_niv2_v064" 2147483647 √ null
config_adr "enumeration"."enum_config_bat_v064" 2147483647 √ null
fiabilite_emprise_sol "enumeration"."enum_spx_fiab_v064" 2147483647 √ null
fiabilite_hauteur "enumeration"."enum_spx_fiab_v064" 2147483647 √ null
fiabilite_adresse_ign bool 1 √ null
is_croisement_spx_reussi bool 1 √ null
matching_type text 2147483647 √ null
cerffo2020_is_ascenseur bool 1 √ null
cerffo2020_is_escalier bool 1 √ null
cerffo2020_is_videordure bool 1 √ null
cerffo2020_is_gaz bool 1 √ null
cerffo2020_nb_log_hlm int4 10 √ null
cerffo2020_nb_log_sem int4 10 √ null
cerffo2020_s_log_soc int4 10 √ null
mtedle2019_elec_conso_res_par_m2_res numeric 17,3 √ null
mtedle2019_gaz_conso_res_par_m2_res_corr numeric 17,3 √ null
mtedle2019_elec_conso_pro_par_m2_pro numeric 17,3 √ null
mtedle2019_gaz_conso_pro_par_m2_pro_corr numeric 17,3 √ null
cerffo2020_usage_niveau_2_txt "enumeration"."enum_cerffo2020_usag_niv2" 2147483647 √ null
cerffo2020_usage_niveau_3_txt "enumeration"."enum_cerffo2020_usag_niv3" 2147483647 √ null
cerffo2020_l_usage_mixite _text 2147483647 √ null
cerffo2020_l_loc_dep_incorp _text 2147483647 √ null
cerffo2020_l_loc_dep_non_incorp _text 2147483647 √ null
cerffo2020_l_loc_ter _text 2147483647 √ null
cerffo2020_l_loc_sec _text 2147483647 √ null
cerffo2020_l_code_naf _text 2147483647 √ null
cerffo2020_l_code_naf_txt _text 2147483647 √ null
cerffo2020_nb_prop int4 10 √ null
cerffo2020_nb_loc int4 10 √ null
cerffo2020_nb_loc_maison int4 10 √ null
cerffo2020_nb_piece_princ int4 10 √ null
cerffo2020_nb_log_vac int4 10 √ null
cerffo2020_nb_loc_dep int4 10 √ null
cerffo2020_nb_loc_dep_incorp int4 10 √ null
cerffo2020_nb_loc_dep_non_incorp int4 10 √ null
cerffo2020_nb_terrasse int4 10 √ null
cerffo2020_nb_terrasse_dep_incorp int4 10 √ null
cerffo2020_nb_cave_dep_incorp int4 10 √ null
cerffo2020_nb_garage_dep_incorp int4 10 √ null
cerffo2020_nb_garpark int4 10 √ null
cerffo2020_nb_grenier_dep_incorp int4 10 √ null
cerffo2020_is_bureau bool 1 √ null
cerffo2020_nb_loc_com_rdc int4 10 √ null
cerffo2020_s_loc_dep int4 10 √ null
cerffo2020_s_dep_incorp int4 10 √ null
cerffo2020_s_terrasse_dep_incorp int4 10 √ null
cerffo2020_s_cave_dep_incorp int4 10 √ null
cerffo2020_s_garage_dep_incorp int4 10 √ null
cerffo2020_s_grenier_dep_incorp int4 10 √ null
cerffo2020_s_log int4 10 √ null
cerffo2020_s_loc_tot int4 10 √ null
cerffo2020_s_loc_pro_tot int4 10 √ null
cerffo2020_s_loc_com_rdc int4 10 √ null
cerffo2020_s_loc_com_sec int4 10 √ null
cerffo2020_s_loc_com_ter int4 10 √ null
cerffo2020_emprise_sol_deduite int4 10 √ null
cerffo2020_l_idbat _varchar 2147483647 √ null
volume_brut int4 10 √ null
surface_facade_vitree int4 10 √ null
surface_facade_totale int4 10 √ null
surface_facade_mitoyenne int4 10 √ null
surface_facade_ext int4 10 √ null
gisement_gain_ges_mean int4 10 √ null
gisement_gain_energetique_mean int4 10 √ null
etiquette_dpe_initial_inc int4 10 √ null
etiquette_dpe_initial_map text 2147483647 √ null
etiquette_dpe_initial_map_2nd_prob float4 8,8 √ null
etiquette_dpe_initial_map_2nd text 2147483647 √ null
etiquette_dpe_renove_inc int4 10 √ null
etiquette_dpe_renove_map text 2147483647 √ null
etiquette_dpe_renove_map_2nd text 2147483647 √ null
etiquette_dpe_renove_map_2nd_prob float4 8,8 √ null
etat_renove_ges_estim_upper int4 10 √ null
etat_renove_ges_estim_mean int4 10 √ null
etat_renove_ges_estim_lower int4 10 √ null
etat_renove_consommation_ges_estim_inc int4 10 √ null
etat_renove_consommation_energie_primaire_estim_upper int4 10 √ null
etat_renove_consommation_energie_primaire_estim_lower int4 10 √ null
etat_renove_consommation_energie_estim_upper int4 10 √ null
etat_renove_consommation_energie_primaire_estim_mean int4 10 √ null
etat_renove_consommation_energie_estim_mean int4 10 √ null
etat_renove_consommation_energie_estim_lower int4 10 √ null
etat_renove_consommation_energie_estim_inc int4 10 √ null
etat_initial_ges_estim_upper int4 10 √ null
etat_initial_ges_estim_mean int4 10 √ null
etat_initial_ges_estim_lower int4 10 √ null
etat_initial_consommation_ges_estim_inc int4 10 √ null
etat_initial_consommation_energie_primaire_estim_upper int4 10 √ null
etat_initial_consommation_energie_primaire_estim_lower int4 10 √ null
etat_initial_consommation_energie_estim_upper int4 10 √ null
etat_initial_consommation_energie_primaire_estim_mean int4 10 √ null
etat_initial_consommation_energie_estim_mean int4 10 √ null
etat_initial_consommation_energie_estim_lower int4 10 √ null
etat_initial_consommation_energie_estim_inc int4 10 √ null
etiquette_dpe_initial_a float4 8,8 √ null
etiquette_dpe_initial_b float4 8,8 √ null
etiquette_dpe_initial_c float4 8,8 √ null
etiquette_dpe_initial_d float4 8,8 √ null
etiquette_dpe_initial_e float4 8,8 √ null
etiquette_dpe_initial_f float4 8,8 √ null
etiquette_dpe_initial_g float4 8,8 √ null
etiquette_dpe_renove_a float4 8,8 √ null
etiquette_dpe_renove_b float4 8,8 √ null
etiquette_dpe_renove_c float4 8,8 √ null
etiquette_dpe_renove_d float4 8,8 √ null
etiquette_dpe_renove_e float4 8,8 √ null
etiquette_dpe_renove_f float4 8,8 √ null
etiquette_dpe_renove_g float4 8,8 √ null
volume_habitable int4 10 √ null

View Definition

Possibly Referenced Tables/Views