batiment_groupe_compile

0 rows


Description

vue complète de la table bâtiment groupe

Columns

Column Type Size Nulls Auto Default Children Parents Comments
batiment_groupe_id varchar 22 √ null
code_departement_insee varchar 2 √ null
parcelle_unifiee_id varchar 22 √ null
s_geom_groupe int4 10 √ null
code_iris varchar 9 √ null
code_commune_insee varchar 5 √ null
libelle_commune_insee text 2147483647 √ null
code_epci_insee text 2147483647 √ null
contient_fictive_geom_groupe bool 1 √ null
geom_groupe geometry 2147483647 √ null
cle_interop_adr_principale_ban text 2147483647 √ null
cle_interop_adr_principale text 2147483647 √ null
libelle_adr_principale_ban text 2147483647 √ null
libelle_adr_principale text 2147483647 √ null
nb_adresse int4 10 √ null
nb_adresse_valid int4 10 √ null
nb_adresse_valid_ban int4 10 √ null
fiabilite_cr_adr_niv_1 text 2147483647 √ null
fiabilite_cr_adr_niv_2 text 2147483647 √ null
dle_elec_conso_res_par_m2 numeric 17,3 √ null
dle_elec_conso_pro_par_m2 numeric 17,3 √ null
dle_elec_conso_tot_par_m2 numeric 17,3 √ null
dle_gaz_conso_res_par_m2 numeric 17,3 √ null
dle_gaz_conso_pro_par_m2 numeric 17,3 √ null
dle_gaz_conso_tot_par_m2 numeric 17,3 √ null
dle_reseau_conso_res_par_m2 numeric 17,3 √ null
dle_reseau_conso_pro_par_m2 numeric 17,3 √ null
dle_reseau_conso_tot_par_m2 numeric 17,3 √ null
fiabilite_emprise_sol varchar 7 √ null
fiabilite_hauteur varchar 7 √ null
fiabilite_adresse bool 1 √ null
croisement_geospx_reussi bool 1 √ null
ffo_prop_personne_id_proprietaire_principal text 2147483647 √ null
ffo_prop_denomination_proprietaire_principal text 2147483647 √ null
ffo_prop_groupe_proprietaire_principal text 2147483647 √ null
ffo_prop_nb_proprietaire int4 10 √ null
ffo_prop_nb_proprietaire_bailleur int4 10 √ null
ffo_prop_nb_proprietaire_pm int4 10 √ null
ffo_prop_nb_gestionnaire int4 10 √ null
ffo_prop_nb_gestionaire_bailleur int4 10 √ null
ffo_prop_nb_gestionnaire_pm int4 10 √ null
simu_dpe_indecence_energetique_initial float4 8,8 √ null
simu_dpe_indecence_energetique_renove float4 8,8 √ null
simu_dpe_volume_habitable int4 10 √ null
simu_dpe_volume_brut int4 10 √ null
simu_dpe_surface_facade_vitree int4 10 √ null
simu_dpe_surface_facade_totale int4 10 √ null
simu_dpe_surface_facade_mitoyenne int4 10 √ null
simu_dpe_surface_facade_ext int4 10 √ null
simu_dpe_surface_enveloppe int4 10 √ null
simu_dpe_surface_verticale int4 10 √ null
simu_dpe_surface_deperditive int4 10 √ null
simu_dpe_surface_deperditive_verticale int4 10 √ null
simu_dpe_surface_toiture int4 10 √ null
simu_dpe_sh int4 10 √ null
simu_dpe_compacite float4 8,8 √ null
simu_dpe_compacite_verticale float4 8,8 √ null
simu_dpe_compacite_brute float4 8,8 √ null
simu_dpe_compacite_verticale_brute float4 8,8 √ null
simu_dpe_correction_vertical float4 8,8 √ null
simu_dpe_correction_surface_horizontale float4 8,8 √ null
simu_dpe_correction_plancher_bas_non_deperditif int4 10 √ null
simu_dpe_ratio_volume_superstructure_defaut_volume_geom float4 8,8 √ null
simu_dpe_summer_solar_radiation int4 10 √ null
simu_dpe_gisement_gain_conso_finale_total int4 10 √ null
simu_dpe_gisement_gain_ges_mean int4 10 √ null
simu_dpe_gisement_gain_energetique_mean int4 10 √ null
simu_dpe_etat_initial_consommation_energie_estim_inc int4 10 √ null
simu_dpe_etat_initial_consommation_energie_estim_lower int4 10 √ null
simu_dpe_etat_initial_consommation_energie_estim_mean int4 10 √ null
simu_dpe_etat_initial_consommation_energie_estim_upper int4 10 √ null
simu_dpe_etat_initial_consommation_energie_primaire_estim_lower int4 10 √ null
simu_dpe_etat_initial_consommation_energie_primaire_estim_mean int4 10 √ null
simu_dpe_etat_initial_consommation_energie_primaire_estim_upper int4 10 √ null
simu_dpe_etat_initial_consommation_ges_estim_inc int4 10 √ null
simu_dpe_etat_initial_ges_estim_lower int4 10 √ null
simu_dpe_etat_initial_ges_estim_mean int4 10 √ null
simu_dpe_etat_initial_ges_estim_upper int4 10 √ null
simu_dpe_etat_initial_risque_canicule int4 10 √ null
simu_dpe_etat_initial_risque_canicule_inc int4 10 √ null
simu_dpe_etat_renove_consommation_energie_estim_inc int4 10 √ null
simu_dpe_etat_renove_consommation_energie_estim_lower int4 10 √ null
simu_dpe_etat_renove_consommation_energie_estim_mean int4 10 √ null
simu_dpe_etat_renove_consommation_energie_estim_upper int4 10 √ null
simu_dpe_etat_renove_consommation_energie_primaire_estim_lower int4 10 √ null
simu_dpe_etat_renove_consommation_energie_primaire_estim_mean int4 10 √ null
simu_dpe_etat_renove_consommation_energie_primaire_estim_upper int4 10 √ null
simu_dpe_etat_renove_consommation_ges_estim_inc int4 10 √ null
simu_dpe_etat_renove_ges_estim_lower int4 10 √ null
simu_dpe_etat_renove_ges_estim_mean int4 10 √ null
simu_dpe_etat_renove_ges_estim_upper int4 10 √ null
simu_dpe_etat_renove_risque_canicule int4 10 √ null
simu_dpe_etat_renove_risque_canicule_inc int4 10 √ null
simu_dpe_etiquette_dpe_initial_a float4 8,8 √ null
simu_dpe_etiquette_dpe_initial_b float4 8,8 √ null
simu_dpe_etiquette_dpe_initial_c float4 8,8 √ null
simu_dpe_etiquette_dpe_initial_d float4 8,8 √ null
simu_dpe_etiquette_dpe_initial_e float4 8,8 √ null
simu_dpe_etiquette_dpe_initial_f float4 8,8 √ null
simu_dpe_etiquette_dpe_initial_g float4 8,8 √ null
simu_dpe_etiquette_dpe_initial_error float4 8,8 √ null
simu_dpe_etiquette_dpe_initial_map varchar 1 √ null
simu_dpe_etiquette_dpe_initial_map_2nd varchar 3 √ null
simu_dpe_etiquette_dpe_initial_map_prob float4 8,8 √ null
simu_dpe_etiquette_dpe_initial_map_2nd_prob float4 8,8 √ null
simu_dpe_etiquette_dpe_initial_inc int4 10 √ null
simu_dpe_etiquette_dpe_renove_a float4 8,8 √ null
simu_dpe_etiquette_dpe_renove_b float4 8,8 √ null
simu_dpe_etiquette_dpe_renove_c float4 8,8 √ null
simu_dpe_etiquette_dpe_renove_d float4 8,8 √ null
simu_dpe_etiquette_dpe_renove_e float4 8,8 √ null
simu_dpe_etiquette_dpe_renove_f float4 8,8 √ null
simu_dpe_etiquette_dpe_renove_g float4 8,8 √ null
simu_dpe_etiquette_dpe_renove_error float4 8,8 √ null
simu_dpe_etiquette_dpe_renove_map varchar 1 √ null
simu_dpe_etiquette_dpe_renove_map_2nd varchar 3 √ null
simu_dpe_etiquette_dpe_renove_map_prob float4 8,8 √ null
simu_dpe_etiquette_dpe_renove_map_2nd_prob float4 8,8 √ null
simu_dpe_etiquette_dpe_renove_inc int4 10 √ null
simu_dvf_usage_niveau_1_txt text 2147483647 √ null
simu_dvf_valeur_fonciere_etat_initial_estim_lower float8 17,17 √ null
simu_dvf_valeur_fonciere_etat_initial_estim_mean float8 17,17 √ null
simu_dvf_valeur_fonciere_etat_initial_estim_upper float8 17,17 √ null
simu_dvf_valeur_fonciere_etat_initial_incertitude text 2147483647 √ null
simu_dvf_valeur_fonciere_etat_renove_estim_lower float8 17,17 √ null
simu_dvf_valeur_fonciere_etat_renove_estim_mean float8 17,17 √ null
simu_dvf_valeur_fonciere_etat_renove_estim_upper float8 17,17 √ null
simu_dvf_valeur_fonciere_etat_renove_incertitude text 2147483647 √ null
simu_dvf_classe_dpe_conso_initial text 2147483647 √ null
simu_dvf_classe_dpe_conso_renove text 2147483647 √ null
simu_dvf_r2 float8 17,17 √ null
simu_dvf_difference_abs_valeur_fonciere_etat_initial_renove float8 17,17 √ null
simu_dvf_difference_rel_valeur_fonciere_etat_initial_renove float8 17,17 √ null
simu_dvf_difference_rel_valeur_fonciere_etat_initial_renove_cat text 2147483647 √ null
simu_dvf_difference_rel_valeur_fonciere_initial_mean_iris float8 17,17 √ null
simu_dvf_difference_rel_valeur_fonciere_renove_mean_iris float8 17,17 √ null
simu_dvf_renovation numeric 0 √ null
simu_dvf_gain_classe_b_vers_a numeric 0 √ null
simu_dvf_gain_classe_c_vers_a numeric 0 √ null
simu_dvf_gain_classe_c_vers_b numeric 0 √ null
simu_dvf_gain_classe_d_vers_a numeric 0 √ null
simu_dvf_gain_classe_d_vers_b numeric 0 √ null
simu_dvf_gain_classe_d_vers_c numeric 0 √ null
simu_dvf_gain_classe_e_vers_a numeric 0 √ null
simu_dvf_gain_classe_e_vers_b numeric 0 √ null
simu_dvf_gain_classe_e_vers_c numeric 0 √ null
simu_dvf_gain_classe_e_vers_d numeric 0 √ null
simu_dvf_gain_classe_f_vers_a numeric 0 √ null
simu_dvf_gain_classe_f_vers_b numeric 0 √ null
simu_dvf_gain_classe_f_vers_c numeric 0 √ null
simu_dvf_gain_classe_f_vers_d numeric 0 √ null
simu_dvf_gain_classe_f_vers_e numeric 0 √ null
simu_dvf_gain_classe_g_vers_a numeric 0 √ null
simu_dvf_gain_classe_g_vers_b numeric 0 √ null
simu_dvf_gain_classe_g_vers_c numeric 0 √ null
simu_dvf_gain_classe_g_vers_d numeric 0 √ null
simu_dvf_gain_classe_g_vers_e numeric 0 √ null
simu_dvf_gain_classe_g_vers_f numeric 0 √ null
enveloppe_source_information_principale text 2147483647 √ null
enveloppe_score_fiabilite int4 10 √ null
enveloppe_type_batiment_dpe text 2147483647 √ null
enveloppe_type_vitrage text 2147483647 √ null
enveloppe_type_materiaux_menuiserie text 2147483647 √ null
enveloppe_type_gaz_lame text 2147483647 √ null
enveloppe_type_fermeture text 2147483647 √ null
enveloppe_epaisseur_lame int2 5 √ null
enveloppe_vitrage_vir bool 1 √ null
enveloppe_traversant text 2147483647 √ null
enveloppe_u_baie_vitree numeric 0 √ null
enveloppe_uw numeric 0 √ null
enveloppe_facteur_solaire_baie_vitree numeric 0 √ null
enveloppe_presence_balcon bool 1 √ null
enveloppe_l_orientation_baie_vitree _text 2147483647 √ null
enveloppe_pourcentage_surface_baie_vitree_exterieur numeric 0 √ null
enveloppe_type_isolation_mur_exterieur text 2147483647 √ null
enveloppe_epaisseur_isolation_mur_exterieur_estim int4 10 √ null
enveloppe_materiaux_structure_mur_exterieur text 2147483647 √ null
enveloppe_materiaux_structure_mur_exterieur_simplifie text 2147483647 √ null
enveloppe_epaisseur_structure_mur_exterieur text 2147483647 √ null
enveloppe_u_mur_exterieur numeric 0 √ null
enveloppe_l_local_non_chauffe_mur _text 2147483647 √ null
enveloppe_local_non_chauffe_principal_mur text 2147483647 √ null
enveloppe_l_orientation_mur_exterieur _text 2147483647 √ null
enveloppe_type_isolation_plancher_bas text 2147483647 √ null
enveloppe_type_plancher_bas_deperditif text 2147483647 √ null
enveloppe_u_plancher_bas_final_deperditif numeric 0 √ null
enveloppe_u_plancher_bas_brut_deperditif numeric 0 √ null
enveloppe_l_local_non_chauffe_plancher_bas _text 2147483647 √ null
enveloppe_local_non_chauffe_principal_plancher_bas text 2147483647 √ null
enveloppe_type_adjacence_principal_plancher_bas text 2147483647 √ null
enveloppe_type_isolation_plancher_haut text 2147483647 √ null
enveloppe_type_plancher_haut_deperditif text 2147483647 √ null
enveloppe_u_plancher_haut_deperditif numeric 0 √ null
enveloppe_l_local_non_chauffe_plancher_haut _text 2147483647 √ null
enveloppe_local_non_chauffe_principal_plancher_haut text 2147483647 √ null
enveloppe_type_adjacence_principal_plancher_haut text 2147483647 √ null
enveloppe_materiaux_toiture_simplifie text 2147483647 √ null
enveloppe_type_porte text 2147483647 √ null
enveloppe_u_porte numeric 0 √ null
enveloppe_classe_inertie text 2147483647 √ null
periode_construction_periode_construction_probable text 2147483647 √ null
periode_construction_source text 2147483647 √ null
periode_construction_fiabilite text 2147483647 √ null
systeme_energetique_source_information_principale text 2147483647 √ null
systeme_energetique_score_fiabilite int4 10 √ null
systeme_energetique_type_batiment_dpe text 2147483647 √ null
systeme_energetique_type_installation_chauffage text 2147483647 √ null
systeme_energetique_type_energie_chauffage text 2147483647 √ null
systeme_energetique_type_generateur_chauffage text 2147483647 √ null
systeme_energetique_type_generateur_chauffage_anciennete text 2147483647 √ null
systeme_energetique_type_energie_chauffage_appoint text 2147483647 √ null
systeme_energetique_type_generateur_chauffage_appoint text 2147483647 √ null
systeme_energetique_type_generateur_chauffage_anciennete_appoin text 2147483647 √ null
systeme_energetique_chauffage_solaire bool 1 √ null
systeme_energetique_nb_generateur_chauffage int2 5 √ null
systeme_energetique_nb_installation_chauffage int2 5 √ null
systeme_energetique_l_type_generateur_chauffage _text 2147483647 √ null
systeme_energetique_type_energie_climatisation text 2147483647 √ null
systeme_energetique_type_generateur_climatisation text 2147483647 √ null
systeme_energetique_type_generateur_climatisation_anciennete text 2147483647 √ null
systeme_energetique_type_installation_ecs text 2147483647 √ null
systeme_energetique_type_energie_ecs text 2147483647 √ null
systeme_energetique_type_generateur_ecs text 2147483647 √ null
systeme_energetique_type_generateur_ecs_anciennete text 2147483647 √ null
systeme_energetique_type_energie_ecs_appoint text 2147483647 √ null
systeme_energetique_type_generateur_ecs_appoint text 2147483647 √ null
systeme_energetique_type_generateur_ecs_anciennete_appoint text 2147483647 √ null
systeme_energetique_ecs_solaire bool 1 √ null
systeme_energetique_nb_generateur_ecs int2 5 √ null
systeme_energetique_nb_installation_ecs int2 5 √ null
systeme_energetique_l_type_generateur_ecs _text 2147483647 √ null
systeme_energetique_type_ventilation text 2147483647 √ null
systeme_energetique_type_production_energie_renouvelable text 2147483647 √ null
bdtopo_bat_l_nature _text 2147483647 √ null
bdtopo_bat_l_usage_1 _text 2147483647 √ null
bdtopo_bat_l_usage_2 _text 2147483647 √ null
bdtopo_bat_l_etat _text 2147483647 √ null
bdtopo_bat_hauteur_mean int4 10 √ null
bdtopo_bat_max_hauteur int4 10 √ null
bdtopo_bat_altitude_sol_mean int4 10 √ null
bdtopo_equ_l_nature _text 2147483647 √ null
bdtopo_equ_l_nature_detaillee _text 2147483647 √ null
bdtopo_equ_l_toponyme _text 2147483647 √ null
bdtopo_zoa_l_nature _text 2147483647 √ null
bdtopo_zoa_l_nature_detaillee _text 2147483647 √ null
bdtopo_zoa_l_toponyme _text 2147483647 √ null
bpe_l_type_equipement _text 2147483647 √ null
delimitation_enveloppe_dict text 2147483647 √ null
dle_elec_2020_nb_pdl_res numeric 17,3 √ null
dle_elec_2020_nb_pdl_pro numeric 17,3 √ null
dle_elec_2020_nb_pdl_tot numeric 17,3 √ null
dle_elec_2020_conso_res numeric 17,3 √ null
dle_elec_2020_conso_pro numeric 17,3 √ null
dle_elec_2020_conso_tot numeric 17,3 √ null
dle_elec_2020_conso_res_par_pdl numeric 17,3 √ null
dle_elec_2020_conso_pro_par_pdl numeric 17,3 √ null
dle_elec_2020_conso_tot_par_pdl numeric 17,3 √ null
dle_gaz_2020_nb_pdl_res numeric 17,3 √ null
dle_gaz_2020_nb_pdl_pro numeric 17,3 √ null
dle_gaz_2020_nb_pdl_tot numeric 17,3 √ null
dle_gaz_2020_conso_res numeric 17,3 √ null
dle_gaz_2020_conso_pro numeric 17,3 √ null
dle_gaz_2020_conso_tot numeric 17,3 √ null
dle_gaz_2020_conso_res_par_pdl numeric 17,3 √ null
dle_gaz_2020_conso_pro_par_pdl numeric 17,3 √ null
dle_gaz_2020_conso_tot_par_pdl numeric 17,3 √ null
dle_reseaux_2020_nb_pdl_res numeric 17,3 √ null
dle_reseaux_2020_nb_pdl_pro numeric 17,3 √ null
dle_reseaux_2020_nb_pdl_tot numeric 17,3 √ null
dle_reseaux_2020_conso_res numeric 17,3 √ null
dle_reseaux_2020_conso_pro numeric 17,3 √ null
dle_reseaux_2020_conso_tot numeric 17,3 √ null
dle_reseaux_2020_conso_res_par_pdl numeric 17,3 √ null
dle_reseaux_2020_conso_pro_par_pdl numeric 17,3 √ null
dle_reseaux_2020_conso_tot_par_pdl numeric 17,3 √ null
dle_reseaux_2020_identifiant_reseau text 2147483647 √ null
dle_reseaux_2020_type_reseau text 2147483647 √ null
dpe_mix_arrete_identifiant_dpe text 2147483647 √ null
dpe_mix_arrete_arrete_2021 bool 1 √ null
dpe_mix_arrete_type_dpe text 2147483647 √ null
dpe_mix_arrete_type_batiment_dpe text 2147483647 √ null
dpe_mix_arrete_periode_construction_dpe text 2147483647 √ null
dpe_mix_arrete_annee_construction_dpe int2 5 √ null
dpe_mix_arrete_version text 2147483647 √ null
dpe_mix_arrete_date_etablissement_dpe timestamp 29,6 √ null
dpe_mix_arrete_date_reception_dpe timestamp 29,6 √ null
dpe_mix_arrete_nombre_niveau_logement int2 5 √ null
dpe_mix_arrete_nombre_niveau_immeuble int2 5 √ null
dpe_mix_arrete_surface_habitable_immeuble numeric 0 √ null
dpe_mix_arrete_surface_habitable_logement numeric 0 √ null
dpe_mix_arrete_conso_5_usages_ep_m2 numeric 0 √ null
dpe_mix_arrete_conso_5_usages_ef_m2 numeric 0 √ null
dpe_mix_arrete_emission_ges_5_usages_m2 numeric 0 √ null
dpe_mix_arrete_classe_bilan_dpe text 2147483647 √ null
dpe_mix_arrete_classe_emission_ges text 2147483647 √ null
dpe_mix_arrete_classe_conso_energie_arrete_2012 text 2147483647 √ null
dpe_mix_arrete_classe_emission_ges_arrete_2012 text 2147483647 √ null
dpe_mix_arrete_conso_3_usages_ep_m2_arrete_2012 numeric 0 √ null
dpe_mix_arrete_emission_ges_3_usages_ep_m2_arrete_2012 numeric 0 √ null
dpe_mix_arrete_type_installation_chauffage text 2147483647 √ null
dpe_mix_arrete_type_energie_chauffage text 2147483647 √ null
dpe_mix_arrete_type_generateur_chauffage text 2147483647 √ null
dpe_mix_arrete_type_generateur_chauffage_anciennete text 2147483647 √ null
dpe_mix_arrete_type_energie_chauffage_appoint text 2147483647 √ null
dpe_mix_arrete_type_generateur_chauffage_appoint text 2147483647 √ null
dpe_mix_arrete_type_generateur_chauffage_anciennete_appoint text 2147483647 √ null
dpe_mix_arrete_chauffage_solaire bool 1 √ null
dpe_mix_arrete_nb_generateur_chauffage int2 5 √ null
dpe_mix_arrete_nb_installation_chauffage int2 5 √ null
dpe_mix_arrete_type_energie_climatisation text 2147483647 √ null
dpe_mix_arrete_type_generateur_climatisation text 2147483647 √ null
dpe_mix_arrete_type_generateur_climatisation_anciennete text 2147483647 √ null
dpe_mix_arrete_type_installation_ecs text 2147483647 √ null
dpe_mix_arrete_type_energie_ecs text 2147483647 √ null
dpe_mix_arrete_type_generateur_ecs text 2147483647 √ null
dpe_mix_arrete_type_generateur_ecs_anciennete text 2147483647 √ null
dpe_mix_arrete_type_energie_ecs_appoint text 2147483647 √ null
dpe_mix_arrete_type_generateur_ecs_appoint text 2147483647 √ null
dpe_mix_arrete_type_generateur_ecs_anciennete_appoint text 2147483647 √ null
dpe_mix_arrete_ecs_solaire bool 1 √ null
dpe_mix_arrete_nb_generateur_ecs int2 5 √ null
dpe_mix_arrete_nb_installation_ecs int2 5 √ null
dpe_mix_arrete_plusieurs_facade_exposee bool 1 √ null
dpe_mix_arrete_type_ventilation text 2147483647 √ null
dpe_mix_arrete_type_production_energie_renouvelable text 2147483647 √ null
dpe_mix_arrete_type_vitrage text 2147483647 √ null
dpe_mix_arrete_type_materiaux_menuiserie text 2147483647 √ null
dpe_mix_arrete_type_gaz_lame text 2147483647 √ null
dpe_mix_arrete_type_fermeture text 2147483647 √ null
dpe_mix_arrete_epaisseur_lame int2 5 √ null
dpe_mix_arrete_vitrage_vir bool 1 √ null
dpe_mix_arrete_surface_vitree_nord numeric 0 √ null
dpe_mix_arrete_surface_vitree_sud numeric 0 √ null
dpe_mix_arrete_surface_vitree_ouest numeric 0 √ null
dpe_mix_arrete_surface_vitree_est numeric 0 √ null
dpe_mix_arrete_surface_vitree_horizontal numeric 0 √ null
dpe_mix_arrete_traversant text 2147483647 √ null
dpe_mix_arrete_u_baie_vitree numeric 0 √ null
dpe_mix_arrete_uw numeric 0 √ null
dpe_mix_arrete_facteur_solaire_baie_vitree numeric 0 √ null
dpe_mix_arrete_presence_balcon bool 1 √ null
dpe_mix_arrete_l_orientation_baie_vitree _text 2147483647 √ null
dpe_mix_arrete_pourcentage_surface_baie_vitree_exterieur numeric 0 √ null
dpe_mix_arrete_type_isolation_mur_exterieur text 2147483647 √ null
dpe_mix_arrete_epaisseur_isolation_mur_exterieur_estim int4 10 √ null
dpe_mix_arrete_materiaux_structure_mur_exterieur text 2147483647 √ null
dpe_mix_arrete_epaisseur_structure_mur_exterieur text 2147483647 √ null
dpe_mix_arrete_surface_mur_totale numeric 0 √ null
dpe_mix_arrete_surface_mur_exterieur numeric 0 √ null
dpe_mix_arrete_surface_mur_deperditif numeric 0 √ null
dpe_mix_arrete_u_mur_exterieur numeric 0 √ null
dpe_mix_arrete_l_local_non_chauffe_mur _text 2147483647 √ null
dpe_mix_arrete_local_non_chauffe_principal_mur text 2147483647 √ null
dpe_mix_arrete_l_orientation_mur_exterieur _text 2147483647 √ null
dpe_mix_arrete_type_isolation_plancher_bas text 2147483647 √ null
dpe_mix_arrete_type_plancher_bas_deperditif text 2147483647 √ null
dpe_mix_arrete_surface_plancher_bas_totale numeric 0 √ null
dpe_mix_arrete_surface_plancher_bas_deperditif numeric 0 √ null
dpe_mix_arrete_u_plancher_bas_final_deperditif numeric 0 √ null
dpe_mix_arrete_u_plancher_bas_brut_deperditif numeric 0 √ null
dpe_mix_arrete_l_local_non_chauffe_plancher_bas _text 2147483647 √ null
dpe_mix_arrete_local_non_chauffe_principal_plancher_bas text 2147483647 √ null
dpe_mix_arrete_type_adjacence_principal_plancher_bas text 2147483647 √ null
dpe_mix_arrete_type_isolation_plancher_haut text 2147483647 √ null
dpe_mix_arrete_type_plancher_haut_deperditif text 2147483647 √ null
dpe_mix_arrete_surface_plancher_haut_totale numeric 0 √ null
dpe_mix_arrete_surface_plancher_haut_deperditif numeric 0 √ null
dpe_mix_arrete_u_plancher_haut_deperditif numeric 0 √ null
dpe_mix_arrete_l_local_non_chauffe_plancher_haut _text 2147483647 √ null
dpe_mix_arrete_local_non_chauffe_principal_plancher_haut text 2147483647 √ null
dpe_mix_arrete_type_adjacence_principal_plancher_haut text 2147483647 √ null
dpe_mix_arrete_type_porte text 2147483647 √ null
dpe_mix_arrete_surface_porte numeric 0 √ null
dpe_mix_arrete_u_porte numeric 0 √ null
dpe_mix_arrete_classe_inertie text 2147483647 √ null
dpe_mix_arrete_deperdition_mur numeric 0 √ null
dpe_mix_arrete_deperdition_baie_vitree numeric 0 √ null
dpe_mix_arrete_deperdition_plancher_bas numeric 0 √ null
dpe_mix_arrete_deperdition_plancher_haut numeric 0 √ null
dpe_mix_arrete_deperdition_pont_thermique numeric 0 √ null
dpe_mix_arrete_deperdition_porte numeric 0 √ null
dpe_mix_arrete_nb_classe_bilan_dpe_a int4 10 √ null
dpe_mix_arrete_nb_classe_bilan_dpe_b int4 10 √ null
dpe_mix_arrete_nb_classe_bilan_dpe_c int4 10 √ null
dpe_mix_arrete_nb_classe_bilan_dpe_d int4 10 √ null
dpe_mix_arrete_nb_classe_bilan_dpe_e int4 10 √ null
dpe_mix_arrete_nb_classe_bilan_dpe_f int4 10 √ null
dpe_mix_arrete_nb_classe_bilan_dpe_g int4 10 √ null
dpe_mix_arrete_nb_classe_conso_energie_arrete_2012_a int4 10 √ null
dpe_mix_arrete_nb_classe_conso_energie_arrete_2012_b int4 10 √ null
dpe_mix_arrete_nb_classe_conso_energie_arrete_2012_c int4 10 √ null
dpe_mix_arrete_nb_classe_conso_energie_arrete_2012_d int4 10 √ null
dpe_mix_arrete_nb_classe_conso_energie_arrete_2012_e int4 10 √ null
dpe_mix_arrete_nb_classe_conso_energie_arrete_2012_f int4 10 √ null
dpe_mix_arrete_nb_classe_conso_energie_arrete_2012_g int4 10 √ null
dpe_mix_arrete_nb_classe_conso_energie_arrete_2012_nc int4 10 √ null
dv3f_valeur_fonciere_min numeric 10,2 √ null
dv3f_valeur_fonciere_max numeric 10,2 √ null
dv3f_valeur_fonciere_med numeric 10,2 √ null
dv3f_valeur_fonciere_mean numeric 10,2 √ null
dv3f_valeur_fonciere_mean_t1 numeric 10,2 √ null
dv3f_valeur_fonciere_mean_t2 numeric 10,2 √ null
dv3f_valeur_fonciere_mean_t3 numeric 10,2 √ null
dv3f_valeur_fonciere_mean_t4sup numeric 10,2 √ null
dv3f_nb_mutation_annee int4 10 √ null
dv3f_nb_loc int4 10 √ null
dv3f_nb_log int4 10 √ null
dv3f_nb_log_soc int4 10 √ null
dv3f_id_locmut text 2147483647 √ null
dv3f_local_id text 2147483647 √ null
dv3f_id_mutation text 2147483647 √ null
dv3f_usage_simple text 2147483647 √ null
dv3f_usage_simple_txt text 2147483647 √ null
dv3f_usage_detail text 2147483647 √ null
dv3f_usage_detail_txt text 2147483647 √ null
dv3f_code_naf varchar 5 √ null
dv3f_code_naf_txt text 2147483647 √ null
dv3f_bureau bool 1 √ null
dv3f_habitation bool 1 √ null
dv3f_logsoc bool 1 √ null
dv3f_vacant bool 1 √ null
dv3f_s_bati int4 10 √ null
dv3f_s_hab int4 10 √ null
dv3f_s_dep int4 10 √ null
dv3f_s_pro int4 10 √ null
dv3f_nb_salle_a_mange int4 10 √ null
dv3f_nb_chambre int4 10 √ null
dv3f_nb_kitchenette int4 10 √ null
dv3f_nb_cuisine int4 10 √ null
dv3f_nb_salle_d_eau int4 10 √ null
dv3f_nb_annexe int4 10 √ null
dv3f_nb_piece_principale int4 10 √ null
dv3f_nb_dep int4 10 √ null
dv3f_nb_garage int4 10 √ null
dv3f_nb_agrement int4 10 √ null
dv3f_nb_terrasse int4 10 √ null
dv3f_nb_piscine int4 10 √ null
dv3f_nb_cave_cellier_remise int4 10 √ null
dv3f_annee_constr text 2147483647 √ null
dv3f_etage text 2147483647 √ null
dv3f_valeur_loc int8 19 √ null
dv3f_valeur_fonciere_par_m2_hab int8 19 √ null
dv3f_valeur_fonciere_par_m2_bati int8 19 √ null
dv3f_valeur_fonciere_par_m2_terrain int8 19 √ null
dv3f_valeur_fonciere_brute int8 19 √ null
dv3f_s_hab_mutation int8 19 √ null
dv3f_s_bati_mutation int8 19 √ null
dv3f_s_terrain_mutation int8 19 √ null
dv3f_date_mutation date 13 √ null
dvf_open_id_opendata varchar 60 √ null
dvf_open_valeur_fonciere numeric 0 √ null
dvf_open_date_mutation date 13 √ null
dvf_open_nb_locaux_mutee_mutation int4 10 √ null
dvf_open_nb_maison_mutee_mutation int4 10 √ null
dvf_open_nb_appartement_mutee_mutation int4 10 √ null
dvf_open_nb_dependance_mutee_mutation int4 10 √ null
dvf_open_nb_locaux_tertiaire_mutee_mutation int4 10 √ null
dvf_open_surface_bati_mutee_residencielle_individuelle numeric 0 √ null
dvf_open_surface_bati_mutee_residencielle_collective numeric 0 √ null
dvf_open_surface_bati_mutee_dependance numeric 0 √ null
dvf_open_surface_bati_mutee_tertiaire numeric 0 √ null
dvf_open_surface_terrain_mutee numeric 0 √ null
dvf_open_nb_piece_principale int4 10 √ null
dvf_open_prix_m2_local numeric 0 √ null
dvf_open_prix_m2_terrain numeric 0 √ null
dvf_open_nb_mutation int4 10 √ null
dvf_open_valeur_fonciere_median numeric 0 √ null
dvf_open_valeur_fonciere_moyenne numeric 0 √ null
dvf_open_valeur_fonciere_max numeric 0 √ null
dvf_open_valeur_fonciere_min numeric 0 √ null
dvf_open_prix_m2_local_median numeric 0 √ null
dvf_open_prix_m2_local_moyen numeric 0 √ null
dvf_open_prix_m2_local_max numeric 0 √ null
dvf_open_prix_m2_local_min numeric 0 √ null
dvf_open_prix_m2_terrain_median numeric 0 √ null
dvf_open_prix_m2_terrain_moyen numeric 0 √ null
dvf_open_prix_m2_terrain_max numeric 0 √ null
dvf_open_prix_m2_terrain_min numeric 0 √ null
dvf_open_nb_locaux_mutee int4 10 √ null
dvf_open_nb_maisons_mutee int4 10 √ null
dvf_open_nb_appartement_mutee int4 10 √ null
dvf_open_nb_dependance_mutee int4 10 √ null
dvf_open_nb_locaux_tertiaire_mutee int4 10 √ null
l_denomination_bailleur_social _text 2147483647 √ null
exposition_bruit bool 1 √ null
exposition_bruit_routier_et_ou_ferroviaire bool 1 √ null
zone_prioritaire_bruit bool 1 √ null
exposition_bruit_routier bool 1 √ null
exposition_bruit_ferroviaire bool 1 √ null
exposition_bruit_aeroport bool 1 √ null
nb_logement_social float8 17,17 √ null
nb_logement_social_expose_bruit float8 17,17 √ null
nb_logement_social_expose_bruit_rte_et_ou_fer float8 17,17 √ null
nb_logement_social_zone_prioritaire_bruit float8 17,17 √ null
nb_logement_social_expose_routier float8 17,17 √ null
nb_logement_social_expose_ferroviaire float8 17,17 √ null
nb_logement_social_expose_aeroport float8 17,17 √ null
type_exposition_bruit text 2147483647 √ null
type_exposition_bruit_routier_et_ou_ferroviaire text 2147483647 √ null
type_exposition_bruit_simplifie text 2147483647 √ null
ffo_bat_emprise_sol_deduite_sans_park_incorp int4 10 √ null
ffo_bat_presence_ch_central bool 1 √ null
ffo_bat_raccord_eau bool 1 √ null
ffo_bat_raccord_egout bool 1 √ null
ffo_bat_raccord_elec bool 1 √ null
ffo_bat_l_loc_sec_txt _text 2147483647 √ null
ffo_bat_l_pev_etat_entretien _text 2147483647 √ null
ffo_bat_mat_mur text 2147483647 √ null
ffo_bat_mat_toit text 2147483647 √ null
ffo_bat_nb_adresse int4 10 √ null
ffo_bat_nb_baignoire int4 10 √ null
ffo_bat_nb_douche int4 10 √ null
ffo_bat_nb_niveau int4 10 √ null
ffo_bat_nb_lavabo int4 10 √ null
ffo_bat_nb_loc_burx int4 10 √ null
ffo_bat_nb_loc_com_sec int4 10 √ null
ffo_bat_nb_loc_com_ter int4 10 √ null
ffo_bat_nb_loc_hab int4 10 √ null
ffo_bat_nb_log_loue int4 10 √ null
ffo_bat_nb_log_loue_meuble int4 10 √ null
ffo_bat_nb_log_loue_autre int4 10 √ null
ffo_bat_nb_log_occ_prop int4 10 √ null
ffo_bat_nb_log_pevph int4 10 √ null
ffo_bat_nb_pev_pro int4 10 √ null
ffo_bat_nb_piece_annexe int4 10 √ null
ffo_bat_nb_piece_tx int4 10 √ null
ffo_bat_nb_piscine int4 10 √ null
ffo_bat_nb_sdb int4 10 √ null
ffo_bat_nb_wc int4 10 √ null
ffo_bat_s_dep_non_incorp int4 10 √ null
ffo_bat_s_loc_appt int4 10 √ null
ffo_bat_s_loc_com int4 10 √ null
ffo_bat_s_loc_dep_incorp int4 10 √ null
ffo_bat_s_loc_dep_non_incorp int4 10 √ null
ffo_bat_s_loc_hors_sol_avec_dep int4 10 √ null
ffo_bat_s_loc_hors_sol_non_dep_inc int4 10 √ null
ffo_bat_s_loc_hors_sol_non_dep int4 10 √ null
ffo_bat_s_loc_mi int4 10 √ null
ffo_bat_s_loc_pro_princetdepcouv int4 10 √ null
ffo_bat_s_log_hlm int4 10 √ null
ffo_bat_s_log_sem int4 10 √ null
ffo_bat_s_max_hors_sol_avec_dep int4 10 √ null
ffo_bat_s_max_hors_sol_non_dep_inc int4 10 √ null
ffo_bat_s_max_hors_sol_non_dep int4 10 √ null
ffo_bat_s_pev_dep int4 10 √ null
ffo_bat_s_pev_pro int4 10 √ null
ffo_bat_annee_construction int4 10 √ null
ffo_bat_emprise_sol_deduite int4 10 √ null
ffo_bat_presence_ascenseur bool 1 √ null
ffo_bat_presence_bureau bool 1 √ null
ffo_bat_presence_escalier bool 1 √ null
ffo_bat_raccord_gaz bool 1 √ null
ffo_bat_presence_sous_sol bool 1 √ null
ffo_bat_presence_videordure bool 1 √ null
ffo_bat_usage_principal text 2147483647 √ null
ffo_bat_usage_niveau_1 int4 10 √ null
ffo_bat_usage_niveau_1_txt text 2147483647 √ null
ffo_bat_usage_niveau_2 int4 10 √ null
ffo_bat_usage_niveau_2_txt text 2147483647 √ null
ffo_bat_usage_niveau_3 int4 10 √ null
ffo_bat_usage_niveau_3_txt text 2147483647 √ null
ffo_bat_l_usage_niveau_1 _int4 10 √ null
ffo_bat_l_usage_niveau_1_txt text 2147483647 √ null
ffo_bat_l_usage_niveau_2 _int4 10 √ null
ffo_bat_l_usage_niveau_2_txt text 2147483647 √ null
ffo_bat_l_usage_niveau_3 _int4 10 √ null
ffo_bat_l_usage_niveau_3_txt text 2147483647 √ null
ffo_bat_l_usage_mixite _text 2147483647 √ null
ffo_bat_usage_mixite_global text 2147483647 √ null
ffo_bat_l_loc_dep_incorp _text 2147483647 √ null
ffo_bat_l_loc_dep_non_incorp _text 2147483647 √ null
ffo_bat_l_loc_sec _text 2147483647 √ null
ffo_bat_l_loc_ter _text 2147483647 √ null
ffo_bat_l_code_naf _text 2147483647 √ null
ffo_bat_l_code_naf_txt _text 2147483647 √ null
ffo_bat_mat_mur_txt text 2147483647 √ null
ffo_bat_mat_toit_txt text 2147483647 √ null
ffo_bat_nb_cave_dep_incorp int4 10 √ null
ffo_bat_nb_garage_dep_incorp int4 10 √ null
ffo_bat_nb_garpark int4 10 √ null
ffo_bat_nb_grenier_dep_incorp int4 10 √ null
ffo_bat_nb_loc int4 10 √ null
ffo_bat_nb_loc_appt int4 10 √ null
ffo_bat_nb_loc_com int4 10 √ null
ffo_bat_nb_loc_com_rdc int4 10 √ null
ffo_bat_nb_loc_dep int4 10 √ null
ffo_bat_nb_loc_dep_incorp int4 10 √ null
ffo_bat_nb_loc_dep_non_incorp int4 10 √ null
ffo_bat_nb_loc_maison int4 10 √ null
ffo_bat_nb_log int4 10 √ null
ffo_bat_nb_log_residence_principale int4 10 √ null
ffo_bat_nb_log_residence_secondaire int4 10 √ null
ffo_bat_nb_log_hlm int4 10 √ null
ffo_bat_nb_log_sem int4 10 √ null
ffo_bat_nb_log_soc int4 10 √ null
ffo_bat_nb_log_vac int4 10 √ null
ffo_bat_nb_piece_principale int4 10 √ null
ffo_bat_nb_terrasse int4 10 √ null
ffo_bat_nb_terrasse_dep_incorp int4 10 √ null
ffo_bat_s_cave_dep_incorp int4 10 √ null
ffo_bat_s_dep_incorp int4 10 √ null
ffo_bat_s_garage_dep_incorp int4 10 √ null
ffo_bat_s_grenier_dep_incorp int4 10 √ null
ffo_bat_s_loc_com_rdc int4 10 √ null
ffo_bat_s_loc_com_sec int4 10 √ null
ffo_bat_s_loc_com_ter int4 10 √ null
ffo_bat_s_loc_dep int4 10 √ null
ffo_bat_s_loc_pro_tot int4 10 √ null
ffo_bat_s_loc_tot int4 10 √ null
ffo_bat_s_log int4 10 √ null
ffo_bat_s_log_residence_principale int4 10 √ null
ffo_bat_s_log_residence_secondaire int4 10 √ null
ffo_bat_s_log_soc int4 10 √ null
ffo_bat_s_terrasse_dep_incorp int4 10 √ null
hthd_nb_pdl numeric 17,3 √ null
hthd_l_type_pdl _text 2147483647 √ null
hthd_l_nom_pdl _text 2147483647 √ null
ffo_loc_locaux_immeuble_dict json 2147483647 √ null
merimee_distance_batiment_historique_plus_proche int2 5 √ null
merimee_nom_batiment_historique_plus_proche text 2147483647 √ null
pie_l_usage_principal _text 2147483647 √ null
pie_l_usage_principal_detaille _text 2147483647 √ null
pie_erp bool 1 √ null
pie_l_designation_site _text 2147483647 √ null
pie_l_designation_batiment_terrain _text 2147483647 √ null
pie_l_occupant _text 2147483647 √ null
pie_l_ministere _text 2147483647 √ null
pie_l_libelle_occupant _text 2147483647 √ null
pie_l_proprietaire _text 2147483647 √ null
pie_l_libelle_proprietaire _text 2147483647 √ null
pie_surface numeric 0 √ null
pie_annee_construction int4 10 √ null
pie_etat_de_sante_minimal varchar 17 √ null
pie_tri_dechets bool 1 √ null
qpv_nom_quartier text 2147483647 √ null
rnc_numero_immat_principal varchar 30 √ null
rnc_periode_construction_max text 2147483647 √ null
rnc_l_annee_construction _text 2147483647 √ null
rnc_nb_lot_garpark numeric 0 √ null
rnc_nb_lot_tot numeric 0 √ null
rnc_nb_log numeric 0 √ null
rnc_nb_lot_tertiaire numeric 0 √ null
rnc_l_nom_copro _text 2147483647 √ null
rnc_l_siret _text 2147483647 √ null
rnc_copro_dans_pvd bool 1 √ null
rpls_rpls_open bool 1 √ null
rpls_nb_classe_ener_a numeric 0 √ null
rpls_nb_classe_ener_b numeric 0 √ null
rpls_nb_classe_ener_c numeric 0 √ null
rpls_nb_classe_ener_d numeric 0 √ null
rpls_nb_classe_ener_e numeric 0 √ null
rpls_nb_classe_ener_f numeric 0 √ null
rpls_nb_classe_ener_g numeric 0 √ null
rpls_nb_classe_ener_nc numeric 0 √ null
rpls_classe_ener_principale text 2147483647 √ null
rpls_nb_classe_ges_a numeric 0 √ null
rpls_nb_classe_ges_b numeric 0 √ null
rpls_nb_classe_ges_c numeric 0 √ null
rpls_nb_classe_ges_d numeric 0 √ null
rpls_nb_classe_ges_e numeric 0 √ null
rpls_nb_classe_ges_f numeric 0 √ null
rpls_nb_classe_ges_g numeric 0 √ null
rpls_nb_classe_ges_nc numeric 0 √ null
rpls_classe_ges_principale text 2147483647 √ null
rpls_accessible_pmr bool 1 √ null
rpls_dans_qpv bool 1 √ null
rpls_l_annee_construction _text 2147483647 √ null
rpls_l_ident_org _text 2147483647 √ null
rpls_l_raison_sociale _text 2147483647 √ null
rpls_raison_sociale_principal text 2147483647 √ null
rpls_loyer_moyen numeric 0 √ null
rpls_loyer_moyen_m2 numeric 10,1 √ null
rpls_nb_loc_assoc numeric 0 √ null
rpls_nb_log_loue numeric 0 √ null
rpls_nb_log_vac numeric 0 √ null
rpls_l_bat_nom _text 2147483647 √ null
rpls_l_cat_org _text 2147483647 √ null
rpls_l_siret _text 2147483647 √ null
rpls_siret_principal text 2147483647 √ null
rpls_nb_log numeric 0 √ null
rpls_s_log_hab numeric 0 √ null
rpls_type_construction _text 2147483647 √ null
id_reseau text 2147483647 √ null
potentiel_raccordement_reseau_chaleur text 2147483647 √ null
potentiel_obligation_raccordement text 2147483647 √ null
indicateur_systeme_chauffage text 2147483647 √ null
indicateur_distance_au_reseau text 2147483647 √ null
consommation_chaleur_par_rapport_distance_au_reseau text 2147483647 √ null
usage_principal_bdnb_open text 2147483647 √ null
mixite_usage_residentiel_tertiaire bool 1 √ null
categorie_usage_propriete text 2147483647 √ null
presence_logement_social bool 1 √ null
dh_moyen_2003_maison_ou_collectif_dernier_etage int4 10 √ null
classe_plus_probable_dh_2003_maison_ou_collectif_dernier_etage text 2147483647 √ null
fiabilite_dh_2003_maison_ou_collectif_dernier_etage text 2147483647 √ null
dh_moyen_2003_collectif_etage_courant int4 10 √ null
classe_plus_probable_dh_2003_collectif_etage_courant text 2147483647 √ null
fiabilite_dh_2003_collectif_etage_courant text 2147483647 √ null
alea_radon text 2147483647 √ null
alea_argile text 2147483647 √ null
alea_sismique text 2147483647 √ null
categorie_hauteur_residentiel_risque_sismique text 2147483647 √ null
classe_famille_incendie_residentiel text 2147483647 √ null
pac_faisabilite_ayant_droit text 2147483647 √ null
type_pac_ayant_droit text 2147483647 √ null
pac_faisabilite text 2147483647 √ null
type_pac text 2147483647 √ null
critere_surface_non_bati bool 1 √ null
critere_toiture_terrasse bool 1 √ null
critere_favorabilite_annee_construction_ayant_droit text 2147483647 √ null
critere_favorabilite_annee_construction text 2147483647 √ null
critere_presence_balcon_ayant_droit bool 1 √ null
critere_presence_balcon bool 1 √ null
critere_typologie_moyenne_ayant_droit bool 1 √ null
critere_typologie_moyenne bool 1 √ null
contrainte_urbanisme_ac4 bool 1 √ null
contrainte_urbanisme_ac1 bool 1 √ null
monument_historique bool 1 √ null
denomination_monument_historique text 2147483647 √ null
distance_monument_historique int4 10 √ null
dpe_ter_identifiant_dpe text 2147483647 √ null
dpe_ter_type_dpe_tertiaire text 2147483647 √ null
dpe_ter_source_nouvelle_base_ademe bool 1 √ null
dpe_ter_version text 2147483647 √ null
dpe_ter_date_etablissement_dpe timestamp 29,6 √ null
dpe_ter_date_reception_dpe timestamp 29,6 √ null
dpe_ter_annee_construction_dpe int2 5 √ null
dpe_ter_shon numeric 0 √ null
dpe_ter_surface_utile numeric 0 √ null
dpe_ter_classe_conso_energie_dpe_tertiaire text 2147483647 √ null
dpe_ter_classe_emission_ges_dpe_tertiaire text 2147483647 √ null
dpe_ter_conso_dpe_tertiaire_ep_m2 numeric 0 √ null
dpe_ter_emission_ges_dpe_tertiaire_m2 numeric 0 √ null
dpe_ter_categorie_erp_dpe_tertiaire text 2147483647 √ null
dpe_ter_periode_construction_dpe text 2147483647 √ null
dpe_ter_type_erp_dpe_tertiaire text 2147483647 √ null
dpe_ter_methode_application_dpe_tertiaire text 2147483647 √ null
dpe_ter_sous_modele_dpe_tertiaire text 2147483647 √ null
dpe_ter_type_energie_chauffage text 2147483647 √ null
dpe_ter_type_energie_ecs text 2147483647 √ null
dpe_ter_type_energie_climatisation text 2147483647 √ null
dpe_ter_derniere_annee_consommation int2 5 √ null
dpe_ter_conso_autre_fossile numeric 0 √ null
dpe_ter_conso_bois numeric 0 √ null
dpe_ter_conso_electricite numeric 0 √ null
dpe_ter_conso_fioul numeric 0 √ null
dpe_ter_conso_gaz numeric 0 √ null
dpe_ter_conso_gpl_butane_propane numeric 0 √ null
dpe_ter_conso_reseau_chaleur numeric 0 √ null
dpe_ter_conso_reseau_froid numeric 0 √ null
systeme_energetique_ter_source_information_principale text 2147483647 √ null
systeme_energetique_ter_score_fiabilite int4 10 √ null
systeme_energetique_ter_type_energie_chauffage text 2147483647 √ null
systeme_energetique_ter_type_energie_ecs text 2147483647 √ null
systeme_energetique_ter_type_energie_climatisation text 2147483647 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views