Building Open Data Registry

The dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland.

Tables

Building Information for Open Data in Helsinki City, FinlandTSV
This table contains information about building data in the city of Helsinki. It is sourced from the website of Helsinki City Environment Sector. The data originates from Finland (ISO country code: FI). The table includes various columns such as 'id', 'kg_krakenn', 'i_pyraknro', 'c_vtj_prt', 'c_kiinteis', 'i_nkoord', 'i_ekoord', 'c_valmpvm', 'c_julkisiv', 'i_kokala', 'i_kerrlkm', 'i_kerrosal', 'i_kellaral', 'd_ashuoala', 'c_kayttark', 'c_lammtapa', 'c_poltaine', 'c_rakeaine', 'i_raktilav', 'c_hissi', 'c_viemlii', 'c_vesilii', 'c_sahkolii', 'i_huoneist', 'katunimi_s', 'katunimi_r', 'osoitenume', 'postinumer', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. This data can be utilized in various data...
Building Point Register Information HistoryTSV
The table contains the version history of the 'avoindatarakennukset_piste_rekisteritiedot__rakennukset_piste_rekisteritiedotpoint' table rows sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. Each row in the table represents a specific version of a building record. The '_start_date' column indicates when the row was extracted from the data source, while the '_end_date' column denotes the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version. The table includes various columns such as 'id', 'kg_krakenn', 'i_pyraknro', 'c_vtj_prt', 'c_kiinteis', and many others that store information related to buildings. The data in this table can be utilized for data analytics purposes, such as...

Column Descriptions

Building Information for Open Data in Helsinki City, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data entry.
id	int	The unique identifier for each entry.
kg_krakenn	int	The code for the building's construction type.
i_pyraknro	int	The number of staircases in the building.
c_vtj_prt	int	The official name of the building.
c_kiinteis	string	The name of the property.
i_nkoord	int	The northern coordinate of the building's location.
i_ekoord	int	The eastern coordinate of the building's location.
c_valmpvm	string	The date of the property's value assessment.
c_julkisiv	int	The type of façade of the building.
i_kokala	int	The total area of the building in square meters.
i_kerrlkm	int	The number of floors in the building.
i_kerrosal	int	The number of rooms on the main floor of the building.
i_kellaral	int	The number of rooms in the basement of the building.
d_ashuoala	int	The total area of the attic space in square meters.
c_kayttark	int	The primary use of the building.
c_lammtapa	int	The type of heating system in the building.
c_poltaine	int	The fuel type used for heating the building.
c_rakeaine	int	The material used for the building's frame.
i_raktilav	int	The volume of the building's frame in cubic meters.
c_hissi	string	Indicates whether the building has an elevator or not.
c_viemlii	string	The type of sewage system in the building.
c_vesilii	string	The type of water supply in the building.
c_sahkolii	string	The type of electricity supply in the building.
i_huoneist	int	The number of apartments in the building.
katunimi_s	string	The street name in Swedish.
katunimi_r	string	The street name in Finnish.
osoitenume	int	The house number.
postinumer	int	The postal code.
datanomist	string	The name of the data owner.
paivitetty	string	The date when the data was last updated.
geom_geojson	string	The geometry of the building in GeoJSON format.
geom_geotext	string	The geometry of the building in Well-Known Text (WKT) format.
geom_type	string	The type of geometry of the building.
geom_centroid	string	The centroid of the building's geometry.
geom_center_x	double	The X coordinate of the centroid.
geom_center_y	double	The Y coordinate of the centroid.
geom	binary	The complete geometry information of the building.

Building Point Register Information History

Column	Type	Comment
_start_date	date	The start date indicating the beginning of the validity period of the row version.
_end_date	date	The end date indicating the end of the validity period of the row version.
_row_number	long	The number assigned to each row version.
id	int	The unique identifier of the row.
kg_krakenn	int	The value representing the building's weight.
i_pyraknro	int	The number of floors in the building.
c_vtj_prt	int	The value representing the construction type of the building.
c_kiinteis	string	The value indicating whether the building is permanent or not.
i_nkoord	int	The northern coordinate of the building's location.
i_ekoord	int	The eastern coordinate of the building's location.
c_valmpvm	string	The value representing the completion date of the building.
c_julkisiv	int	The value representing the facade of the building.
i_kokala	int	The total floor area of the building.
i_kerrlkm	int	The number of apartments on each floor.
i_kerrosal	int	The total number of above-ground floors.
i_kellaral	int	The total number of basement floors.
d_ashuoala	int	The floor area of the apartment.
c_kayttark	int	The value representing the intended use of the building.
c_lammtapa	int	The value representing the heating method of the building.
c_poltaine	int	The value representing the fuel type used for heating.
c_rakeaine	int	The value representing the material of the external wall.
i_raktilav	int	The volume of the building structure.
c_hissi	string	The value indicating whether the building has an elevator or not.
c_viemlii	string	The value representing the wastewater disposal method.
c_vesilii	string	The value representing the water supply method.
c_sahkolii	string	The value representing the electricity supply method.
i_huoneist	int	The number of apartments in the building.
katunimi_s	string	The street name in Swedish.
katunimi_r	string	The street name in Russian.
osoitenume	int	The address number.
postinumer	int	The postal code.
datanomist	string	The owner of the data.
paivitetty	string	The date of the last update.
geom_geojson	string	The geometry of the building in GeoJSON format.
geom_geotext	string	The geometry of the building in Geotext format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid of the building's geometry.
geom_center_x	double	The x-coordinate of the centroid.
geom_center_y	double	The y-coordinate of the centroid.
geom	binary	The geometry of the building.

Additional Info

Last Updated	September 13, 2024
Created	July 8, 2018