Dataset collection 'avoindatatontti' from Helsingin kaupunkiympäristön toimiala in Finland

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

Tables

History of Tonttipolygon Rows from Helsingin kaupunkiympariston toimiala in FinlandTSV
This table contains the version history of the 'avoindatatontti__tonttipolygon' table rows. The rows in this table represent different versions of the rows in the base table. Each row in this table has additional columns '_start_date' and '_end_date' which specify the date range during which the row was extracted from the data source. The '_start_date' column contains the starting date of the row version, and the '_end_date' column contains the ending date of the row version. If the value in the '_end_date' column is null, it means that the row is the most recent version of the row. The table contains various other columns such as 'gid', 'tontti_uui', 'tyyppi', 'kunta', 'sijaintial', 'ryhma', 'yksikko', 'tehokkuusl', 'km2', 'lisakm2', 'lisakm2kuv', 'lisakm2riv', 'yhteensakm',...
Vacant Plot Information in Helsinki City, FinlandTSV
The avoindatatontti__tonttipolygon table contains data from Helsingin kaupunkiympariston toimiala website, which is a public dataset from Finland (ISO country code 'fi'). The table includes various attributes such as extract date, row number, unique identifier, type, municipality, location, group, unit, efficiency, area in km2, additional area, additional area with a corresponding image and row, total area, additional information, basement availability, number of floors, attic availability, surface area, creation date, modification date, data update date, block information, geometry in GeoJSON format, geometry in GeoText format, geometry type, centroid coordinates, and the raw geometry. The table provides valuable information that can be utilized in data analytics for various purposes,...

Column Descriptions

Vacant Plot Information in Helsinki City, Finland

Column	Type	Comment
_extract_date	date	The date on which the data was extracted.
_row_number	long	The sequential number of the row in the table.
gid	int	The unique identification number of the row.
tontti_uui	string	The unique identifier for the tontti.
tyyppi	string	The type of the tontti or property.
kunta	int	The municipality where the tontti is located.
sijaintial	int	The address or location details of the tontti.
ryhma	int	The group or category to which the tontti belongs.
yksikko	int	The unit or entity associated with the tontti.
tehokkuusl	string	The efficiency level or rating of the tontti.
km2	int	The area of the tontti in square kilometers.
lisakm2	string	Additional area of the tontti in square kilometers.
lisakm2kuv	string	Additional area of the tontti in square kilometers, as described visually.
lisakm2riv	boolean	Additional area of the tontti in square kilometers, as described in text.
yhteensakm	string	The total area of the tontti in square kilometers.
lisatietoj	string	Additional information or details about the tontti.
kellari	string	Indicates whether the tontti has a cellar or not.
kerrosluku	string	The number of floors or stories in the tontti.
ullakko	string	Indicates whether the tontti has an attic or not.
pintaala	float	The total surface area of the tontti in square meters.
yhtluontip	string	The date and time when the tontti was created.
yhtmuokkau	string	The date and time when the tontti was last modified.
yhtdatanom	string	The date and time when the tontti data was last inspected or updated.
korttelial	string	The area of the block or plot in which the tontti is located.
geom_geojson	string	The geometry of the tontti represented in GEOJSON format.
geom_geotext	string	The geometry of the tontti represented as a Geotext.
geom_type	string	The type of geometry representing the tontti.
geom_centroid	string	The centroid point of the tontti's geometry.
geom_center_x	double	The x-coordinate of the center point of the tontti's geometry.
geom_center_y	double	The y-coordinate of the center point of the tontti's geometry.
geom	binary	The full geometry information of the tontti.

History of Tonttipolygon Rows from Helsingin kaupunkiympariston toimiala in Finland

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The number indicating the order of the row version within the table.
gid	int	The unique identifier of the row.
tontti_uui	string	The unique identifier of the plot.
tyyppi	string	The type of the row.
kunta	int	The municipality of the row.
sijaintial	int	The location of the row.
ryhma	int	The group of the row.
yksikko	int	The unit of the row.
tehokkuusl	string	The efficiency level of the row.
km2	int	The area in square kilometers.
lisakm2	string	The additional area in square kilometers.
lisakm2kuv	string	The additional area in square kilometers (image).
lisakm2riv	boolean	The additional area in square kilometers (row).
yhteensakm	string	The total area in square kilometers.
lisatietoj	string	Additional information about the row.
kellari	string	Indicates if the row has a basement.
kerrosluku	string	The number of floors in the row.
ullakko	string	Indicates if the row has an attic.
pintaala	float	The surface area of the row.
yhtluontip	string	The date and time of the row creation.
yhtmuokkau	string	The date and time of the row modification.
yhtdatanom	string	The date and time of the row data nomination.
korttelial	string	The block area of the row.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geometry of the row in GeoText format.
geom_type	string	The type of geometry of the row.
geom_centroid	string	The centroid of the geometry of the row.
geom_center_x	double	The X-coordinate of the center of the geometry of the row.
geom_center_y	double	The Y-coordinate of the center of the geometry of the row.
geom	binary	The full geometry of the row.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024