id |
ID |
serial_pk |
|
Primary key |
dc_id |
DC ID |
int4 |
|
ID of dataconnection that manages the basic properties (label, geometry) of a particular feature |
id_src |
ID SRC |
text |
|
Identifier of the object in the source dataset |
category |
Category |
propchoice_fk |
|
Subtype of a feature |
label |
Label |
text |
|
Informative name or code for this feature |
status |
Status |
propchoice_fk |
|
Situation of an object at a particular time during a process |
maingroup |
Maingroup |
text |
|
Main classification (user defined) of a feature (equivalent of 'category') |
subgroup |
Subgroup |
text |
|
Sub classification (user defined) of a feature |
construction_date |
Construction date |
date |
|
Date at which this feature was built |
nominal_voltage |
Nominal voltage |
float4 |
V |
The voltage value used to classify electrical devices and systems. It is a reference value that manufacturers use to specify and standardize their products |
details |
Details |
jsonb |
|
Field for country- or dataset specific info that is not used for visualization or calculation purposes |
houses |
Houses |
int4 |
|
Number of houses |
households |
Households |
int4 |
|
Number of households |
home_rental_rate |
Home rental rate |
float4 |
% |
Percentage of homes that are rented |
home_ownership_rate |
Home ownership rate |
float4 |
% |
Percentage of homes that are owner-occupied |
houses_multi_family |
Houses multi-family |
int4 |
|
Number of multi-family homes |
households_single_person |
Households single person |
int8 |
|
A private household consisting of one person |
residential_property_value_avg |
Residential property value avg |
float8 |
EUR |
Average property value of residential objects based on the Valuation of Immovable Property Act (WOZ). Only objects classified as primary residences (code 10) or homes with a practice space (code 11) with a value greater than zero are included. The average uses the valuation reference date of the previous year (e.g. 2021 uses reference date 1 January 2020). Not reported when the housing stock is fewer than 20 homes or the number of WOZ objects is fewer than 50. |
houses_housing_association |
Houses housing association |
int8 |
% |
Rental homes owned by admitted public housing institutions (housing associations). The count reflects homes where the owner has been identified as an admitted institution; it does not refer to social housing, as only ownership — not rent level — was assessed. Reference date: 1 January of the relevant year. Reported as a percentage of total housing stock for 20 or more homes per neighbourhood, and when the share of homes with unknown ownership was 50% or less. |
houses_1945_1965 |
Houses 1945-1965 |
int4 |
|
Number of houses built from 1945 till 1965 |
houses_1965_1975 |
Houses 1965-1975 |
int4 |
|
Number of houses built from 1965 till 1975 |
houses_1975_1985 |
Houses 1975-1985 |
int4 |
|
Number of houses built from 1975 till 1985 |
houses_1985_1995 |
Houses 1985-1995 |
int4 |
|
Number of houses built from 1985 till 1995 |
houses_1995_2005 |
Houses 1995-2005 |
int4 |
|
Number of houses built from 1995 till 2005 |
houses_2005_2015 |
Houses 2005-2015 |
int4 |
|
Number of houses built from 2005 till 2015 |
houses_abandoned |
Houses abandoned |
int4 |
|
Number of unoccupied dwellings or houses in the Netherlands. This statistic includes residential properties that are not currently inhabited, which could be due to various reasons such as being for sale, under renovation, or simply vacant |
inhabitants_age_0_15 |
Inhabitants age 0-15 |
int8 |
|
Number of inhabitants in the age group 0 to 15 years |
inhabitants_age_15_25 |
Inhabitants age 15-25 |
int8 |
|
Number of inhabitants in the age group 15 to 25 years |
inhabitants_age_25_45 |
Inhabitants age 25-45 |
int8 |
|
Number of inhabitants in the age group 25 to 45 years |
inhabitants_age_45_65 |
Inhabitants age 45-65 |
int8 |
|
Number of inhabitants in the age group 45 to 65 years |
inhabitants_age_above_65 |
Inhabitants age above 65 |
int8 |
|
Number of inhabitants aged 65 and above |
inhabitants |
Inhabitants |
int4 |
|
Number of inhabitants |
inhabitants_female |
Inhabitants female |
int4 |
|
Number of females |
inhabitants_male |
Inhabitants male |
int4 |
|
Number of males |
houses_before_1945 |
Houses before 1945 |
int4 |
|
Houses build before 1945 |
houses_after_2015 |
Houses after 2015 |
int4 |
|
Number of houses built from 2015 |
household_size_avg |
Household size avg |
float4 |
|
This average is calculated as the number of persons living in private households divided by the number of private households |
natural_gas_consumption |
Natural gas consumption |
float8 |
m3/connection/year |
Average annual natural gas consumption of private homes, as calculated from the connection registries of energy grid operators. Homes with very low or zero consumption are included when district heating is present, which may result in a low average in areas with district heating. Figures are rounded to tens and reported for six or more occupied homes per housing type or ownership type. |
electricity_consumption |
Electricity consumption |
float8 |
kWh/connection/year |
Average annual electricity consumption on individual connections of private homes, as calculated from the connection registries of energy grid operators. Self-generated electricity (e.g. solar panels) is unknown and therefore not included. Collective consumption (e.g. elevators, hallway lighting) is also excluded. Figures are rounded to tens and reported for six or more occupied homes per housing type or ownership type. |
natural_gas_connections |
Natural gas connections |
int4 |
|
Number of natural gas connections |
electricity_connections |
Electricity connections |
int4 |
|
Number of electricity connections |
avg_electricity_consumption |
Avg electricity consumption |
float8 |
kWh/connection/year |
Average annual electricity consumption on individual connections of private homes, as calculated from the connection registries of energy grid operators. Self-generated electricity (e.g. solar panels) is unknown and therefore not included. Collective consumption (e.g. elevators, hallway lighting) is also excluded. Figures are rounded to tens and reported for six or more occupied homes per housing type or ownership type. |
avg_natural_gas_consumption |
Avg natural gas consumption |
float8 |
m3/connection/year |
Average annual natural gas consumption of private homes, as calculated from the connection registries of energy grid operators. Homes with very low or zero consumption are included when district heating is present, which may result in a low average in areas with district heating. Figures are rounded to tens and reported for six or more occupied homes per housing type or ownership type. |
share_net_consuming_electricity_connections |
Share net consuming electricity connections |
int4 |
% |
Share of the electricity connections with net electricity consumption. On balance, these connections consume energy rather than feed it back into the grid. This share decreases as more electricity is fed back into the grid (e.g., due to solar panels). |
share_net_consuming_natural_gas_connections |
Share net consuming natural gas connections |
int4 |
% |
Share of the natural gas connections with net natural gas consumption. On balance, these connections consume energy rather than feed it back into the grid. This share decreases as more natural gas is fed back into the grid (e.g., due to hydrogen production). |
website |
Website |
text |
|
Website of the object |
grid_connection_queue_demand |
Grid connection queue demand |
float4 |
MW |
Number of requests in the queue for a grid connection for electricity consumption |
grid_connection_queue_supply |
Grid connection queue supply |
float4 |
MW |
Number of requests in the queue for a grid connection for electricity feed-in |
grid_connection_requests_demand |
Grid connection requests demand |
int4 |
|
Total number of submitted grid connection requests for electricity consumption |
grid_connection_requests_supply |
Grid connection requests supply |
int4 |
|
Total number of submitted grid connection requests for electricity feed-in |
grid_required_transport_capacity_demand |
Grid required transport capacity demand |
float4 |
MW |
Required transport capacity of the grid for electricity consumption |
grid_required_transport_capacity_supply |
Grid required transport capacity supply |
float4 |
MW |
Required transport capacity of the grid for electricity feed-in |
grid_transport_capacity_demand |
Grid transport capacity demand |
float4 |
MW |
Available transport capacity of the grid for electricity consumption |
grid_transport_capacity_supply |
Grid transport capacity supply |
float4 |
MW |
Available transport capacity of the grid for electricity feed-in |
grid_year_solved_demand |
Grid year solved demand |
int2 |
|
Expected year in which grid expansions will be completed to address existing electricity consumption bottlenecks |
grid_year_solved_supply |
Grid year solved supply |
int2 |
|
Expected year in which grid expansions will be completed to address existing electricity feed-in bottlenecks |
centroid |
Centroid |
geometry |
|
Point geometry representing the centre of the object |
polygon |
Polygon |
geometry |
|
Polygon geometry of the object |
solar_panel_coverage_pv |
Solar panel coverage (PV) |
propchoice_fk |
|
The coverage of installed PV (Photovoltaic). These are solar panels that generate electricity from sunlight. |
administrative_area_category_level_10_id |
Administrative area category level 10 ID |
feature_type_fk |
|
Foreign key to a administrative area with category 'level_10'. In the Netherlands, this is a 'buurt'. |
administrative_area_category_level_8_id |
Administrative area category level 8 ID |
feature_type_fk |
|
Foreign key to a administrative area with category 'level_8'. In the Netherlands, this is a 'gemeente'. |
administrative_area_category_level_9_id |
Administrative area category level 9 ID |
feature_type_fk |
|
Foreign key to a administrative area with category 'level_9'. In the Netherlands, this is a 'wijk'. |
inhabitant_income_avg |
Inhabitant income avg |
float8 |
1000 EUR/person |
Average income per inhabitant |
offices_failed_energy_label_c |
Offices_failed_energy_label_c |
int4 |
|
Office units larger than 100 m² are required, as of January 1, 2023, to have an energy label of at least C in order to continue being used as office space. Exceptions apply to: A) Office units where the office space accounts for less than 50% of the total floor area of the building (i.e. all combined units), and B) Office units with a designated monumental (heritage) status. |
housing_stock |
Housing stock |
int8 |
|
Total number of homes on 1 January of the relevant year. A home is a residential object with at least a residential function and optionally one or more other use functions. |
houses_rental |
Houses rental |
int8 |
|
Homes that are not occupied by the owner of the property. In the case of homes where no resident is registered, it is likely that the property is intended for the rental market |
houses_rental_other |
Houses rental other |
int8 |
% |
Rental homes owned by companies, private individuals, and institutional investors, including homes where ownership was established but the owner does not fall into the housing association category. Reference date: 1 January of the relevant year. Reported as a percentage of total housing stock for 20 or more homes per neighbourhood, and when the share of homes with unknown ownership was 50% or less. |
houses_vacant |
Houses vacant |
int8 |
|
Residential properties that are unoccupied for a certain period |
buildings |
Buildings |
int4 |
|
Total number of buildings |
building_units |
Building units |
int4 |
|
Total number of building units |
fully_allocated |
Fully allocated |
boolean |
|
Indicates whether all available grid capacity has been fully allocated |
share_of_building_units_label_a_5_plus |
Share of building_units label A 5 plus |
text |
% |
Share of building_units with energy label A+++++ |
share_of_building_units_label_a_4_plus |
Share of building_units label A 4 plus |
int2 |
% |
Share of building_units with energy label A++++ |
share_of_building_units_label_a_3_plus |
Share of building_units label A 3 plus |
int2 |
% |
Share of building_units with energy label A+++ |
share_of_building_units_label_a_2_plus |
Share of building_units label A 2 plus |
int2 |
% |
Share of building_units with energy label A++ |
share_of_building_units_label_a_1_plus |
Share of building_units label A 1 plus |
int2 |
% |
Share of building_units with energy label A+ |
share_of_building_units_label_a |
Share of building_units label A |
int2 |
% |
Share of building_units with energy label A |
share_of_building_units_label_b |
Share of building_units label B |
int2 |
% |
Share of building_units with energy label B |
share_of_building_units_label_c |
Share of building_units label C |
int2 |
% |
Share of building_units with energy label C |
share_of_building_units_label_d |
Share of building_units label D |
int2 |
% |
Share of building_units with energy label D |
share_of_building_units_label_e |
Share of building_units label E |
int2 |
% |
Share of building_units with energy label E |
share_of_building_units_label_f |
Share of building_units label F |
int2 |
% |
Share of building_units with energy label F |
share_of_building_units_label_g |
Share of building_units label G |
text |
% |
Share of building_units with energy label G |
start_date |
Start date |
date |
|
Date since which this object exists |
end_date |
End date |
date |
|
Date till which this object existed |