Building Identification Numbers in Helsinki, Finland

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

Tables

Started Building ID in Helsinki by City Environment Sector from FinlandTSV
This table contains data from the website of Helsingin kaupunkiympariston toimiala in Finland. It provides information about the commenced building identifiers and their associated polygons. The table contains various columns including '_extract_date', '_row_number', 'rakennustu', 'kohdenimi', 'tekstisuun', 'tekstikoko', 'tekstifont', 'buix_bid', 'paivitetty', 'datanomist', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. The data in this table can be utilized for various data analytics purposes such as analyzing the distribution of different building types, exploring the geographical characteristics of the buildings, examining the update history of the data, and studying the textual attributes associated with the buildings.
Version History of Building Identifier and Polygon, Sourced from Helsinki Urban Environment Sector, FinlandTSV
This table contains the version history of rows extracted from the 'Helsinki Urban Environment Sector' data source in Finland (ISO country code 'fi'). The base table for this history table is related to building identifiers and their corresponding polygons. The table includes columns such as '_start_date' and '_end_date' representing the extraction dates for each row version. Each row also has a unique '_row_number' identifier. This table includes various data fields such as 'rakennustu', 'kohdenimi', 'tekstisuun', 'tekstikoko', 'tekstifont', 'buix_bid', 'paivitetty', 'datanomist', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These fields provide valuable information that can be utilized in data analytics. For instance, the...

Column Descriptions

Started Building ID in Helsinki by City Environment Sector from Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted from the source.
_row_number	long	The unique identifier for each row in the table.
rakennustu	int	The type of building.
kohdenimi	string	The name of the target.
tekstisuun	int	The direction of the text.
tekstikoko	float	The size of the text.
tekstifont	string	The font used for the text.
buix_bid	int	The bid for the building.
paivitetty	string	The date when the data about the building was last updated.
datanomist	string	The name of the data analyst who last handled the data.
geom_geojson	string	The geographic data of the building in GeoJSON format.
geom_geotext	string	The geographic data of the building in GeoText format.
geom_type	string	The type of geographic data.
geom_centroid	string	The centroid of the geographic data.
geom_center_x	double	The x-coordinate of the center point of the geographic data.
geom_center_y	double	The y-coordinate of the center point of the geographic data.
geom	binary	The complete geometric representation of the building.

Version History of Building Identifier and Polygon, Sourced from Helsinki Urban Environment Sector, Finland

Column	Type	Comment
_start_date	date	The date indicating the start of the validity period for the row version.
_end_date	date	The date indicating the end of the validity period for the row version.
_row_number	long	An additional column used to represent the row number of the version history.
rakennustu	int	A column containing data related to the building type.
kohdenimi	string	A column containing data related to the item name.
tekstisuun	int	A column containing data related to the text alignment.
tekstikoko	float	A column containing data related to the text size.
tekstifont	string	A column containing data related to the text font.
buix_bid	int	A column containing data related to the BID.
paivitetty	string	A column containing data related to the date of update.
datanomist	string	A column containing data related to the data analyst.
geom_geojson	string	A column containing the geojson representation of the geometry data.
geom_geotext	string	A column containing the geotext representation of the geometry data.
geom_type	string	A column containing data related to the type of geometry.
geom_centroid	string	A column containing data related to the centroid of the geometry.
geom_center_x	double	A column containing data related to the x-coordinate of the center of the geometry.
geom_center_y	double	A column containing data related to the y-coordinate of the center of the geometry.
geom	binary	A column containing the geometry data.

Additional Info

Last Updated	September 13, 2024
Created	July 8, 2018