Skip to content

Policy intervention

Alias: policy_intervention | API: feature_types/100

One or more action taken by a government, organization, or company to achieve a specific policy objective or goal. These measures can include new laws, regulations, subsidies, taxes, or public campaigns

Properties

Alias Name Type Unit Description
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
label Label text Informative name or code for this feature
construction_year Construction year int2 Year in which this feature was built
funding_year Funding year int2
maingroup Maingroup text Main classification (user defined) of a feature (equivalent of 'category')
subgroup Subgroup text Sub classification (user defined) of a feature
budget Budget int8 Euro A financial plan that outlines expected income and expenditures over a specific period, helping individuals, organizations, or governments manage their finances and allocate resources efficiently
status Status propchoice_fk Situation of an object at a particular time during a process
roof_area_green Roof area green float4 m2
roof_water_storage_capacity Roof water storage capacity float4 mm
status_start Status start timestamptz Start time of the current object status
status_end Status end timestamptz End time of the current status
building_id Building ID feature_type_fk Foreign key to building
region_id Region ID feature_type_fk Foreign key to region
details Details jsonb Field for country- or dataset specific info that is not used for visualization or calculation purposes
centroid Centroid geometry
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'.

Choices for status

Alias Name Unit Description
planned Planned Intervention planned
ready Ready Intervention has been done, result is still in use
finished Finished Intervention is done, result no longer there