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 |
|
Feature type identifier in source dataset |
category |
Category |
propchoice_fk |
|
Subtype of a feature |
maingroup |
Maingroup |
text |
|
Main classification (user defined) of a feature (equivalent of 'category') |
status |
Status |
propchoice_fk |
|
Situation of an object at a particular time during a process |
label |
Label |
text |
|
Informative name or code for this feature |
label_angle |
Label angle |
float4 |
Degrees |
Placement angle for label |
intended_use |
Intended use |
propchoice_fk |
|
Intended use of an object as legally defined by the government. |
is_multi_tenant |
Is_multi_tenant |
boolean |
|
|
construction_year |
Construction year |
int2 |
|
Year in which this feature was built |
area |
Area |
float4 |
m2 |
|
area_building_units |
Area building units |
float4 |
m2 |
Total area of all building units |
building_units |
Building units |
int4 |
|
Total number of building units |
heat_pump_potential |
Heat pump potential |
propchoice_fk |
|
Indicates how suitable a residential or small utility building is for deploying an electric (eHP) or hybrid heat pump (hHP). |
energy_label_max |
Energy label max |
text |
|
The highest energy label from a group of energy labels. |
energy_label_min |
Energy label min |
text |
|
The lowest energy label from a group of energy labels. |
energy_label_mode |
Energy label mode |
text |
|
The most common energy label from a group of energy labels. |
energy_label_c_requirement_exists |
Energy label C requirement exists |
propchoice_fk |
|
Does a energy label C requirement exist? This is a legal obligation in the Netherlands stating that, as of January 1, 2023, office buildings must have at least energy label C. Without this label, offices may no longer be used unless an exemption applies. |
energy_label_c_requirement_met |
Energy label C requirement met |
boolean |
|
The energy label C requirement is a legal obligation in the Netherlands stating that, as of January 1, 2023, office buildings must have at least energy label C. Without this label, offices may no longer be used unless an exemption applies. |
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. |
business_park |
Business park |
text |
|
Business park name |
height |
Height |
float8 |
m |
Length of an object from top to bottom along its vertical axis (difference between height_top and height_bottom). |
height_eave |
Height eave |
float8 |
m |
Height from ground surface to the lowest point of a building's roof (typically the gutter). |
floors |
Floors |
int2 |
|
Number of floors |
floors_estimated |
Floors estimated |
int2 |
|
Number of floors estimated |
floors_category |
Floors category |
propchoice_fk |
|
Category of the number of floors |
roof_type |
Roof type |
propchoice_fk |
|
|
perimeter |
Perimeter |
float4 |
m |
|
roof_flat_share |
Roof flat share |
int2 |
% |
Relative surface area of a roof that is flat |
roof_area_green |
Roof area green |
float4 |
m2 |
|
roof_water_storage_capacity |
Roof water storage capacity |
float4 |
mm |
|
ground_settlement_rate |
Ground settlement rate |
float4 |
mm/year |
|
footprint |
Footprint |
geometry |
|
Polygon indicating the area covered by a building or structure at ground level |
vertical_displacement |
Vertical displacement |
float4 |
mm |
|
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'. |
substation_high_mid_voltage_id |
Substation high mid voltage ID |
feature_type_fk |
|
|
substation_mid_low_voltage_id |
Substation mid low voltage ID |
feature_type_fk |
|
|
region_business_park_id |
Region business park ID |
feature_type_fk |
|
|
region_protected_townscapes_id |
Region protected townscapes ID |
feature_type_fk |
|
|
monument_id |
Monument ID |
feature_type_fk |
|
|
policy_intervention_sde_subsidy_id |
Policy intervention SDE subsidy ID |
feature_type_fk |
|
|
estimated_electricity_consumption |
Estimated electricity consumption |
float4 |
kWh/m2/year |
The estimated annual electricity consumption per m2 |
estimated_natural_gas_consumption |
Estimated natural gas consumption |
float4 |
m3/m2/year |
The estimated annual natural gas consumption per m2 |
estimated_heat_consumption |
Estimated heat consumption |
float4 |
kWh/m2/year |
The estimated annual heat consumption per m2 |
details |
Details |
jsonb |
|
Field for country- or dataset specific info that is not used for visualization or calculation purposes |
status_start |
Status start |
timestamptz |
|
Start time of the current object status |
status_end |
Status end |
timestamptz |
|
End time of the current status |
energy_label_provisional |
Energy label provisional |
text |
|
Energy label provisional |
centroid |
Centroid |
geometry |
|
|
polygon |
Polygon |
geometry |
|
|
polygon_3d |
Polygon 3D |
geometry |
|
Polygon with elevation (z) coordinates |
shopping_building_units |
Shopping building units |
int2 |
|
Number of shopping building units |
sports_building_units |
Sports building units |
int2 |
|
Number of sports building units |
industrial_building_units |
Industrial building units |
int2 |
|
Number of industrial building units |
prison_building_units |
Prison building units |
int2 |
|
Number of prison building units |
convening_building_units |
Convening building units |
int2 |
|
Number of convening building units |
healthcare_building_units |
Healthcare building units |
int2 |
|
Number of healthcare building units |
education_building_units |
Education building units |
int2 |
|
Number of education building units |
residential_building_units |
Residential building units |
int2 |
|
Number of residential building units |
other_building_units |
Other building units |
int2 |
|
Number of other building units |
lodging_building_units |
Lodging building units |
int2 |
|
Number of lodging building units |
office_building_units |
Office building units |
int2 |
|
Number of office building units |
area_industrial |
Area industrial |
float4 |
m2 |
|
area_education |
Area education |
float4 |
m2 |
|
area_prison |
Area prison |
float4 |
m2 |
|
area_shopping |
Area shopping |
float4 |
m2 |
|
area_convening |
Area convening |
float4 |
m2 |
|
area_healthcare |
Area healthcare |
float4 |
m2 |
|
area_sports |
Area sports |
float4 |
m2 |
|
area_office |
Area office |
float4 |
m2 |
|
area_other |
Area other |
float4 |
m2 |
|
area_residential |
Area residential |
float4 |
m2 |
|
area_lodging |
Area lodging |
float4 |
m2 |
|
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 |