Building industry dataset collection

This dataset collection consists of tables sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland.

Tables

Building Areas PolygonTSV
This table contains data from the 'Helsinki City Environment Sector' website, which originates from Finland. The table 'avoindatarakennusala__rakennusalapolygon' stores information related to building areas. It includes various columns such as '_extract_date', '_row_number', 'gid', 'rakennusal', 'tyyppi', 'maanalaine', 'kaavamerki', 'km2', 'lisakm2', 'lisakm2riv', 'kellari', 'kerrosluku', 'ullakko', 'varisavy', 'sitova', 'pintaala', 'lisatietoj', 'lisakm2kuv', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'asemakaava', 'ra_tyyppi', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. This data can be utilized in different data analytics scenarios, such as calculating the total area of different building types, analyzing the distribution of...
Building Subarea Polygon Version HistoryTSV
This table contains the version history of rows from the 'avoindatarakennusala__rakennusalapolygon' table. It provides information about various attributes related to building polygons such as their type, size, location, and additional details. The '_start_date' column indicates the date when a particular version of the row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row became available. If the '_end_date' value is null, it means that the row is the most recent version. The data in this table can be used for data analytics purposes, such as analyzing the changes in building types over time, identifying patterns in building sizes, or studying the distribution of underground structures. The table is sourced from the...

Column Descriptions

Building Areas Polygon

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The sequential number of each row.
gid	int	The unique identifier of each row.
rakennusal	string	The building identifier.
tyyppi	string	The type of the building.
maanalaine	boolean	Indicates whether the building is underground or not.
kaavamerki	string	The zoning symbol of the area.
km2	int	The area of the building in square kilometers.
lisakm2	string	Additional area of the building in square kilometers.
lisakm2riv	boolean	Additional area of the building per row in square kilometers.
kellari	string	Indicates whether the building has a basement or not.
kerrosluku	int	The number of floors in the building.
ullakko	string	Indicates whether the building has an attic or not.
varisavy	int	The color tone of the building.
sitova	string	Indicates whether the building has a binding agreement or not.
pintaala	float	The surface area of the building.
lisatietoj	string	Additional information about the building.
lisakm2kuv	string	Additional area of the building in square kilometers according to an image.
yhtluontip	string	The creation date of the building data.
yhtmuokkau	string	The modification date of the building data.
yhtdatanom	string	The data submitter of the building data.
asemakaava	string	The zoning plan of the area.
ra_tyyppi	string	The type of the area.
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 the geometry of the building.
geom_centroid	string	The centroid point of the geometry of the building.
geom_center_x	double	The x-coordinate of the center point of the geometry of the building.
geom_center_y	double	The y-coordinate of the center point of the geometry of the building.
geom	binary	The geometry data of the building.

Building Subarea Polygon Version History

Column	Type	Comment
_start_date	date	The start date of the validity period for the row version.
_end_date	date	The end date of the validity period for the row version.
_row_number	long	The row number of the version in the table.
gid	int	The unique identifier for the row.
rakennusal	string	The building area.
tyyppi	string	The type of building.
maanalaine	boolean	Indicates if the building is underground.
kaavamerki	string	The code for the area.
km2	int	The area in square kilometers.
lisakm2	string	Additional area in square kilometers.
lisakm2riv	boolean	Additional area in square kilometers for the row.
kellari	string	Indicates if the building has a cellar.
kerrosluku	int	The number of floors in the building.
ullakko	string	Indicates if the building has an attic.
varisavy	int	The color scheme of the building.
sitova	string	Indicates if the building is binding.
pintaala	float	The surface area of the building.
lisatietoj	string	Additional information about the building.
lisakm2kuv	string	Additional area in square kilometers for the image.
yhtluontip	string	The creation date for the row.
yhtmuokkau	string	The modification date for the row.
yhtdatanom	string	The date of the data change for the row.
asemakaava	string	The urban plan for the area.
ra_tyyppi	string	The type of the area.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in GeoText format.
geom_type	string	The type of the geometry.
geom_centroid	string	The centroid of the geometry.
geom_center_x	double	The X-coordinate of the center of the geometry.
geom_center_y	double	The Y-coordinate of the center of the geometry.
geom	binary	The geometry of the area.

Additional Info

Last Updated	April 24, 2024
Created	April 24, 2024