batiment_groupe_dle_reseaux_multimillesime

16312 rows


Description

Données de consommations des données locales de l’énergie du SDES pour le vecteur réseau de chaleur agrégées à l’échelle du bâtiment. Attention les données sur les réseaux de chaleurs sont aujourd’hui bien moins fiable que les vecteurs gaz ou éléctricité.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
batiment_groupe_id varchar 30 null
batiment_groupe.batiment_groupe_id batiment_groupe_dle_reseaux_multimillesime_batiment_groupe_id_fR

Clé d’Intéropérabilité du groupe de bâtiment dans la BDNB
code_departement_insee varchar 2 √ null

Code département INSEE
millesime varchar 4 null

Code département INSEE
nb_pdl_res numeric 17,3 √ null

(dle) Nombre de PDL RC résidentiel
nb_pdl_pro numeric 17,3 √ null

(dle) Nombre de PDL RC professionel
nb_pdl_tot numeric 17,3 √ null

(dle) Nombre total de PDL RC
conso_res numeric 17,3 √ null

(dle) Consommation RC résidentielle kWh/an
conso_pro numeric 17,3 √ null

(dle) Consommation RC professionnelle kWh/an
conso_tot numeric 17,3 √ null

(dle) Consommation RC totale kWh/an
conso_res_par_pdl numeric 17,3 √ null

(dle) Consommation RC résidentielle par point de livraison kWh/pdl.an
conso_pro_par_pdl numeric 17,3 √ null

(dle) Consommation RC professionnelle par point de livraison kWh/pdl.an
conso_tot_par_pdl numeric 17,3 √ null

(dle) Consommation RC totale par point de livraison kWh/pdl.an
identifiant_reseau _varchar 2147483647 √ null

(dle) Identifiant du réseau de chaleur
type_reseau _varchar 2147483647 √ null

(dle) type du réseau de chaleur

Indexes

Constraint Name Type Sort Column(s)
batiment_groupe_dle_reseaux_multimillesime_pk_id Primary key Asc/Asc batiment_groupe_id + millesime
batiment_groupe_dle_reseaux_multimillesime_code_departement_ins Performance Asc code_departement_insee
batiment_groupe_dle_reseaux_multimillesime_millesime_idx Performance Asc millesime

Check Constraints

Constraint Name Constraint
batiment_groupe_dle_reseaux__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