batiment_groupe_compile_compat_v06

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
bnb_grp_id varchar 22 √ null
code_departement_insee varchar 2 √ null
depnum int4 10 √ null
parcelle_unifiee_id varchar 22 √ null
fiabilite_cr_adr_niv_1 text 2147483647 √ null
fiabilite_cr_adr_niv_2 text 2147483647 √ null
code_commune_insee varchar 5 √ null
code_iris varchar 9 √ null
code_epci_insee varchar 2147483647 √ null
libelle_commune_insee text 2147483647 √ null
igntop202112_bat_is_there_fictive_geom_bat bool 1 √ null
etaban202111_label text 2147483647 √ null
is_croisement_spx_reussi bool 1 √ null
fiabilite_emprise_sol varchar 7 √ null
fiabilite_hauteur varchar 7 √ null
categorie varchar 2147483647 √ null
geom_groupe geometry 2147483647 √ null
s_geom_groupe int4 10 √ null
adedpe202006_l_ch_gen_princ _text 2147483647 √ null
adedpe202006_l_ecs_gen_princ _text 2147483647 √ null
adedpe202006_logtype_avancee_masque_max text 2147483647 √ null
adedpe202006_logtype_baie_fs numeric 10,3 √ null
adedpe202006_logtype_baie_mat text 2147483647 √ null
adedpe202006_logtype_baie_orientation _text 2147483647 √ null
adedpe202006_logtype_baie_remplissage text 2147483647 √ null
adedpe202006_logtype_baie_type_vitrage text 2147483647 √ null
adedpe202006_logtype_baie_u numeric 10,3 √ null
adedpe202006_logtype_ch_gen_lib _text 2147483647 √ null
adedpe202006_logtype_ch_gen_lib_appoint text 2147483647 √ null
adedpe202006_logtype_ch_gen_lib_princ text 2147483647 √ null
adedpe202006_logtype_ch_is_solaire bool 1 √ null
adedpe202006_logtype_ch_type_ener_corr text 2147483647 √ null
adedpe202006_logtype_ch_type_inst text 2147483647 √ null
adedpe202006_logtype_classe_conso_ener varchar 1 √ null
adedpe202006_logtype_classe_estim_ges varchar 1 √ null
adedpe202006_logtype_coherence_data_methode_dpe bool 1 √ null
adedpe202006_logtype_conso_ener numeric 12,2 √ null
adedpe202006_logtype_date_reception_dpe date 13 √ null
adedpe202006_logtype_ecs_gen_lib _text 2147483647 √ null
adedpe202006_logtype_ecs_gen_lib_appoint text 2147483647 √ null
adedpe202006_logtype_ecs_gen_lib_princ text 2147483647 √ null
adedpe202006_logtype_ecs_is_solaire bool 1 √ null
adedpe202006_logtype_ecs_type_ener text 2147483647 √ null
adedpe202006_logtype_ecs_type_inst text 2147483647 √ null
adedpe202006_logtype_enr text 2147483647 √ null
adedpe202006_logtype_estim_ges numeric 12,2 √ null
adedpe202006_logtype_inertie text 2147483647 √ null
adedpe202006_logtype_is_3cl bool 1 √ null
adedpe202006_logtype_mur_ep_mat_ext text 2147483647 √ null
adedpe202006_logtype_mur_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_nom_methode_dpe text 2147483647 √ null
adedpe202006_logtype_numero_dpe varchar 13 √ 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_perc_surf_vitree_ext numeric 4,3 √ null
adedpe202006_logtype_periode_construction text 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_presence_balcon bool 1 √ null
adedpe202006_logtype_presence_climatisation bool 1 √ null
adedpe202006_logtype_ratio_ges_conso numeric 12,2 √ null
adedpe202006_logtype_s_hab int4 10 √ null
adedpe202006_logtype_traversant text 2147483647 √ null
adedpe202006_logtype_type_batiment text 2147483647 √ null
adedpe202006_logtype_type_ventilation text 2147483647 √ null
adedpe202006_max_conso_ener numeric 11,1 √ null
adedpe202006_max_estim_ges numeric 11,1 √ null
adedpe202006_mean_class_conso_ener varchar 1 √ null
adedpe202006_mean_class_estim_ges varchar 1 √ null
adedpe202006_min_conso_ener numeric 11,1 √ null
adedpe202006_min_estim_ges numeric 11,1 √ 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_std_conso_ener numeric 11,1 √ null
adedpe202006_std_estim_ges numeric 11,1 √ null
altitude_sol int4 10 √ null
anarnc202012_chauffage_collectif_urbain bool 1 √ null
anarnc202012_l_annee_construction _text 2147483647 √ null
anarnc202012_l_energie_chauffage_collectif text 2147483647 √ null
anarnc202012_l_nom_copro _text 2147483647 √ null
anarnc202012_l_type_chauffage _text 2147483647 √ null
anarnc202012_nb_ascenseurs numeric 0 √ null
anarnc202012_nb_classe_ener_a numeric 0 √ null
anarnc202012_nb_classe_ener_b numeric 0 √ null
anarnc202012_nb_classe_ener_c numeric 0 √ null
anarnc202012_nb_classe_ener_d numeric 0 √ null
anarnc202012_nb_classe_ener_e numeric 0 √ null
anarnc202012_nb_classe_ener_f numeric 0 √ null
anarnc202012_nb_classe_ener_g numeric 0 √ null
anarnc202012_nb_classe_ener_nc numeric 0 √ null
anarnc202012_nb_log numeric 0 √ null
anarnc202012_nb_lot_garpark numeric 0 √ null
anarnc202012_nb_lot_tertiaire numeric 0 √ null
anarnc202012_nb_lot_tot numeric 0 √ null
anarnc202012_periode_construction_max text 2147483647 √ null
ancqpv201410_nom_qp text 2147483647 √ null
arcthd202111_l_bat_type _text 2147483647 √ null
arcthd202111_l_nom _text 2147483647 √ null
arcthd202111_nb_pdl numeric 17,3 √ null
cerdvf2021v5_logtype_annee_constr text 2147483647 √ null
cerdvf2021v5_logtype_cconlc varchar 2147483647 √ null
cerdvf2021v5_logtype_cconlc_txt text 2147483647 √ null
cerdvf2021v5_logtype_code_naf varchar 5 √ null
cerdvf2021v5_logtype_code_naf_txt text 2147483647 √ null
cerdvf2021v5_logtype_date_mut date 13 √ null
cerdvf2021v5_logtype_dteloc varchar 2147483647 √ null
cerdvf2021v5_logtype_dteloc_txt text 2147483647 √ null
cerdvf2021v5_logtype_etage text 2147483647 √ null
cerdvf2021v5_logtype_is_bureau bool 1 √ null
cerdvf2021v5_logtype_is_habitation bool 1 √ null
cerdvf2021v5_logtype_is_logsoc bool 1 √ null
cerdvf2021v5_logtype_is_vacant bool 1 √ null
cerdvf2021v5_logtype_nb_agrem int4 10 √ null
cerdvf2021v5_logtype_nb_annexe int4 10 √ null
cerdvf2021v5_logtype_nb_cave_cellier_remise int4 10 √ null
cerdvf2021v5_logtype_nb_chambre int4 10 √ null
cerdvf2021v5_logtype_nb_cuisine int4 10 √ null
cerdvf2021v5_logtype_nb_dep int4 10 √ null
cerdvf2021v5_logtype_nb_garage int4 10 √ null
cerdvf2021v5_logtype_nb_kitchenette int4 10 √ null
cerdvf2021v5_logtype_nb_piscine int4 10 √ null
cerdvf2021v5_logtype_nb_pprinc int4 10 √ null
cerdvf2021v5_logtype_nb_sam int4 10 √ null
cerdvf2021v5_logtype_nb_sea int4 10 √ null
cerdvf2021v5_logtype_nb_terrasse int4 10 √ null
cerdvf2021v5_logtype_s_bati int4 10 √ null
cerdvf2021v5_logtype_s_bati_mut int8 19 √ null
cerdvf2021v5_logtype_s_dep int4 10 √ null
cerdvf2021v5_logtype_s_hab int4 10 √ null
cerdvf2021v5_logtype_s_hab_mut int8 19 √ null
cerdvf2021v5_logtype_s_pro int4 10 √ null
cerdvf2021v5_logtype_s_terrain_mut int8 19 √ null
cerdvf2021v5_logtype_valeur_fonc int8 19 √ null
cerdvf2021v5_logtype_valeur_fonc_par_m2_bati int8 19 √ null
cerdvf2021v5_logtype_valeur_fonc_par_m2_hab int8 19 √ null
cerdvf2021v5_logtype_valeur_fonc_par_m2_terrain int8 19 √ null
cerdvf2021v5_logtype_valeur_loc int8 19 √ null
cerdvf2021v5_max_valeur_fonc_par_m2_hab numeric 10,2 √ null
cerdvf2021v5_mean_valeur_fonc_par_m2_hab numeric 10,2 √ null
cerdvf2021v5_mean_valeur_fonc_par_m2_hab_t1 numeric 10,2 √ null
cerdvf2021v5_mean_valeur_fonc_par_m2_hab_t2 numeric 10,2 √ null
cerdvf2021v5_mean_valeur_fonc_par_m2_hab_t3 numeric 10,2 √ null
cerdvf2021v5_mean_valeur_fonc_par_m2_hab_t4sup numeric 10,2 √ null
cerdvf2021v5_med_valeur_fonc_par_m2_hab numeric 10,2 √ null
cerdvf2021v5_min_valeur_fonc_par_m2_hab numeric 10,2 √ null
cerdvf2021v5_nb_loc int4 10 √ null
cerdvf2021v5_nb_log int4 10 √ null
cerdvf2021v5_nb_log_soc int4 10 √ null
cerdvf2021v5_sum_nb_mutation_annee int4 10 √ null
cerffo2021_bat_annee_construction int4 10 √ null
cerffo2021_bat_emprise_sol_deduite int4 10 √ null
cerffo2021_bat_emprise_sol_deduite_sans_park_inc int4 10 √ null
cerffo2021_bat_is_ascenseur bool 1 √ null
cerffo2021_bat_is_bureau bool 1 √ null
cerffo2021_bat_is_ch_central bool 1 √ null
cerffo2021_bat_is_eau bool 1 √ null
cerffo2021_bat_is_egout bool 1 √ null
cerffo2021_bat_is_elec bool 1 √ null
cerffo2021_bat_is_escalier bool 1 √ null
cerffo2021_bat_is_gaz bool 1 √ null
cerffo2021_bat_is_sous_sol bool 1 √ null
cerffo2021_bat_is_videordure bool 1 √ null
cerffo2021_bat_l_code_naf _text 2147483647 √ null
cerffo2021_bat_l_loc_dep_incorp _text 2147483647 √ null
cerffo2021_bat_l_loc_dep_non_incorp _text 2147483647 √ null
cerffo2021_bat_l_loc_sec _text 2147483647 √ null
cerffo2021_bat_l_loc_sec_txt _text 2147483647 √ null
cerffo2021_bat_l_loc_ter _text 2147483647 √ null
cerffo2021_bat_l_pev_etat_entretien _text 2147483647 √ null
cerffo2021_bat_l_usage_mixite _text 2147483647 √ null
cerffo2021_bat_l_usage_niveau_1 _int4 10 √ null
cerffo2021_bat_l_usage_niveau_1_txt text 2147483647 √ null
cerffo2021_bat_l_usage_niveau_2 _int4 10 √ null
cerffo2021_bat_l_usage_niveau_2_txt text 2147483647 √ null
cerffo2021_bat_l_usage_niveau_3 _int4 10 √ null
cerffo2021_bat_l_usage_niveau_3_txt text 2147483647 √ null
cerffo2021_bat_mat_mur varchar 2147483647 √ null
cerffo2021_bat_mat_mur_txt text 2147483647 √ null
cerffo2021_bat_mat_toit varchar 2147483647 √ null
cerffo2021_bat_mat_toit_txt text 2147483647 √ null
cerffo2021_bat_nb_adresse int4 10 √ null
cerffo2021_bat_nb_baignoire int4 10 √ null
cerffo2021_bat_nb_cave_dep_incorp int4 10 √ null
cerffo2021_bat_nb_douche int4 10 √ null
cerffo2021_bat_nb_garage_dep_incorp int4 10 √ null
cerffo2021_bat_nb_garpark int4 10 √ null
cerffo2021_bat_nb_grenier_dep_incorp int4 10 √ null
cerffo2021_bat_nb_lavabo int4 10 √ null
cerffo2021_bat_nb_loc int4 10 √ null
cerffo2021_bat_nb_loc_appt int4 10 √ null
cerffo2021_bat_nb_loc_burx int4 10 √ null
cerffo2021_bat_nb_loc_com int4 10 √ null
cerffo2021_bat_nb_loc_com_rdc int4 10 √ null
cerffo2021_bat_nb_loc_com_sec int4 10 √ null
cerffo2021_bat_nb_loc_com_ter int4 10 √ null
cerffo2021_bat_nb_loc_com_vac int4 10 √ null
cerffo2021_bat_nb_loc_dep int4 10 √ null
cerffo2021_bat_nb_loc_dep_incorp int4 10 √ null
cerffo2021_bat_nb_loc_dep_non_incorp int4 10 √ null
cerffo2021_bat_nb_loc_hab int4 10 √ null
cerffo2021_bat_nb_loc_maison int4 10 √ null
cerffo2021_bat_nb_log int4 10 √ null
cerffo2021_bat_nb_log_hlm int4 10 √ null
cerffo2021_bat_nb_log_loue int4 10 √ null
cerffo2021_bat_nb_log_occ_prop int4 10 √ null
cerffo2021_bat_nb_log_pevph int4 10 √ null
cerffo2021_bat_nb_log_sem int4 10 √ null
cerffo2021_bat_nb_log_soc int4 10 √ null
cerffo2021_bat_nb_log_vac int4 10 √ null
cerffo2021_bat_nb_niveau int4 10 √ null
cerffo2021_bat_nb_pev_pro int4 10 √ null
cerffo2021_bat_nb_piece_annexe int4 10 √ null
cerffo2021_bat_nb_piece_princ int4 10 √ null
cerffo2021_bat_nb_piece_tx int4 10 √ null
cerffo2021_bat_nb_piscine int4 10 √ null
cerffo2021_bat_nb_sdb int4 10 √ null
cerffo2021_bat_nb_terrasse int4 10 √ null
cerffo2021_bat_nb_terrasse_dep_incorp int4 10 √ null
cerffo2021_bat_nb_wc int4 10 √ null
cerffo2021_bat_s_cave_dep_incorp int4 10 √ null
cerffo2021_bat_s_dep_incorp int4 10 √ null
cerffo2021_bat_s_dep_non_incorp int4 10 √ null
cerffo2021_bat_s_garage_dep_incorp int4 10 √ null
cerffo2021_bat_s_grenier_dep_incorp int4 10 √ null
cerffo2021_bat_s_loc_appt int4 10 √ null
cerffo2021_bat_s_loc_com int4 10 √ null
cerffo2021_bat_s_loc_com_rdc int4 10 √ null
cerffo2021_bat_s_loc_com_sec int4 10 √ null
cerffo2021_bat_s_loc_com_ter int4 10 √ null
cerffo2021_bat_s_loc_dep int4 10 √ null
cerffo2021_bat_s_loc_dep_incorp int4 10 √ null
cerffo2021_bat_s_loc_dep_non_incorp int4 10 √ null
cerffo2021_bat_s_loc_hors_sol_avec_dep int4 10 √ null
cerffo2021_bat_s_loc_hors_sol_non_dep int4 10 √ null
cerffo2021_bat_s_loc_hors_sol_non_dep_inc int4 10 √ null
cerffo2021_bat_s_loc_mi int4 10 √ null
cerffo2021_bat_s_loc_pro_princetdepcouv int4 10 √ null
cerffo2021_bat_s_loc_pro_tot int4 10 √ null
cerffo2021_bat_s_loc_tot int4 10 √ null
cerffo2021_bat_s_log int4 10 √ null
cerffo2021_bat_s_log_hlm int4 10 √ null
cerffo2021_bat_s_log_sem int4 10 √ null
cerffo2021_bat_s_log_soc int4 10 √ null
cerffo2021_bat_s_max_hors_sol_avec_dep int4 10 √ null
cerffo2021_bat_s_max_hors_sol_non_dep int4 10 √ null
cerffo2021_bat_s_max_hors_sol_non_dep_inc int4 10 √ null
cerffo2021_bat_s_pev_dep int4 10 √ null
cerffo2021_bat_s_pev_pro int4 10 √ null
cerffo2021_bat_s_terrasse_dep_incorp int4 10 √ null
cerffo2021_bat_usage_niveau_1 int4 10 √ null
cerffo2021_bat_usage_niveau_1_txt text 2147483647 √ null
cerffo2021_bat_usage_niveau_2 int4 10 √ null
cerffo2021_bat_usage_niveau_2_txt text 2147483647 √ null
cerffo2021_bat_usage_niveau_3 int4 10 √ null
cerffo2021_bat_usage_niveau_3_txt text 2147483647 √ null
cerffo2021_bat_usage_principal text 2147483647 √ null
dhurpl2019_is_pmr bool 1 √ null
dhurpl2019_is_qpv bool 1 √ null
dhurpl2019_l_annee_construction _text 2147483647 √ null
dhurpl2019_l_bat_nom _text 2147483647 √ null
dhurpl2019_l_cat_org _text 2147483647 √ null
dhurpl2019_l_ident_org _text 2147483647 √ null
dhurpl2019_l_raison_sociale _text 2147483647 √ null
dhurpl2019_l_siret _text 2147483647 √ null
dhurpl2019_loyer_moyen numeric 0 √ null
dhurpl2019_loyer_moyen_m2 numeric 10,1 √ null
dhurpl2019_nb_classe_ener_a numeric 0 √ null
dhurpl2019_nb_classe_ener_b numeric 0 √ null
dhurpl2019_nb_classe_ener_c numeric 0 √ null
dhurpl2019_nb_classe_ener_d numeric 0 √ null
dhurpl2019_nb_classe_ener_e numeric 0 √ null
dhurpl2019_nb_classe_ener_f numeric 0 √ null
dhurpl2019_nb_classe_ener_g numeric 0 √ null
dhurpl2019_nb_classe_ener_nc numeric 0 √ null
dhurpl2019_nb_classe_ges_a numeric 0 √ null
dhurpl2019_nb_classe_ges_b numeric 0 √ null
dhurpl2019_nb_classe_ges_c numeric 0 √ null
dhurpl2019_nb_classe_ges_d numeric 0 √ null
dhurpl2019_nb_classe_ges_e numeric 0 √ null
dhurpl2019_nb_classe_ges_f numeric 0 √ null
dhurpl2019_nb_classe_ges_g numeric 0 √ null
dhurpl2019_nb_classe_ges_nc numeric 0 √ null
dhurpl2019_nb_loc_assoc numeric 0 √ null
dhurpl2019_nb_log numeric 0 √ null
dhurpl2019_nb_log_loue numeric 0 √ null
dhurpl2019_nb_log_vac numeric 0 √ null
dhurpl2019_s_log_hab numeric 0 √ null
dhurpl2019_type_cons _text 2147483647 √ null
enepdl2020_nb_pdl_pro numeric 17,3 √ null
enepdl2020_nb_pdl_res numeric 17,3 √ null
enepdl2020_nb_pdl_tot numeric 17,3 √ null
enethe2019_conso_ener_par_m2_res numeric 17,3 √ null
enethe2019_conso_ener_par_pdl_res numeric 17,3 √ null
enethe2019_conso_ener_res numeric 17,3 √ null
enethe2019_conso_thermo_par_m2_res numeric 17,3 √ null
enethe2019_conso_thermo_par_pdl_res numeric 17,3 √ null
enethe2019_conso_thermo_res numeric 17,3 √ null
enethe2019_gradient_moy_res numeric 17,3 √ null
enethe2019_nb_pdl_res numeric 17,3 √ null
etaban202111_nb_adresse int4 10 √ null
geoarg2020_alea varchar 2147483647 √ null
georad2020_alea varchar 2147483647 √ null
igntop202112_bat_l_etat _text 2147483647 √ null
igntop202112_bat_mean_hauteur_m int4 10 √ null
igntop202112_bat_l_nature _text 2147483647 √ null
igntop202112_equ_l_nat_detail _text 2147483647 √ null
igntop202112_equ_l_nature _text 2147483647 √ null
igntop202112_equ_l_toponyme _text 2147483647 √ null
igntop202112_zoac_l_nat_detail _text 2147483647 √ null
igntop202112_zoac_l_nature _text 2147483647 √ null
igntop202112_zoac_l_toponyme _text 2147483647 √ null
insbpe2019_l_type_equipement _varchar 2147483647 √ null
mcumer202007_dist500min int2 5 √ null
mcumer202007_tico text 2147483647 √ null
mtedle2020_elec_conso_pro numeric 17,3 √ null
mtedle2020_elec_conso_pro_par_m2_pro numeric 17,3 √ null
mtedle2020_elec_conso_res numeric 17,3 √ null
mtedle2020_elec_conso_res_par_m2_res numeric 17,3 √ null
mtedle2020_elec_conso_res_par_pdl_res numeric 17,3 √ null
mtedle2020_elec_conso_tot numeric 17,3 √ null
mtedle2020_elec_conso_tot_par_m2_tot numeric 17,3 √ null
mtedle2020_elec_nb_pdl_pro numeric 17,3 √ null
mtedle2020_elec_nb_pdl_res numeric 17,3 √ null
mtedle2020_elec_nb_pdl_tot numeric 17,3 √ null
mtedle2020_gaz_conso_pro numeric 17,3 √ null
mtedle2020_gaz_conso_pro_par_m2_pro_corr numeric 17,3 √ null
mtedle2020_gaz_conso_res numeric 17,3 √ null
mtedle2020_gaz_conso_res_par_m2_res_corr numeric 17,3 √ null
mtedle2020_gaz_conso_res_par_pdl_res numeric 17,3 √ null
mtedle2020_gaz_conso_tot numeric 17,3 √ null
mtedle2020_gaz_conso_tot_par_m2_tot_corr numeric 17,3 √ null
mtedle2020_gaz_nb_pdl_pro numeric 17,3 √ null
mtedle2020_gaz_nb_pdl_res numeric 17,3 √ null
mtedle2020_gaz_nb_pdl_tot numeric 17,3 √ null
osmgeo202103_l_fclass _text 2147483647 √ null
osmgeo202103_name _text 2147483647 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views