batiment_groupe_compile_compat_v06

0 rows


Description

vue complète de la table bâtiment groupe rétrocompatible version 0.6

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 text 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 text 2147483647 √ null
geom_groupe geometry 2147483647 √ null
s_geom_groupe int4 10 √ 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 text 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 text 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 text 2147483647 √ null
cerffo2021_bat_mat_mur_txt text 2147483647 √ null
cerffo2021_bat_mat_toit text 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_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 text 2147483647 √ null
georad2020_alea text 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 _text 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