Avoindatapiirijako Osaalue Dataset Collection

The dataset collection contains one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Area Division Sub-area Polygon Data in Helsinki Urban Environment Sector, FinlandTSV
This table contains data from 'Helsinki Urban Environment Sector' website, which originates from Finland. It provides information about the subdivision areas and polygon boundaries with various attributes. The data in this table can be utilized in data analytics to analyze the distribution and characteristics of subdivision areas, perform spatial analysis, calculate centroid coordinates, determine the type of geometry, track data creation and modification dates, and analyze data ownership and update information.
Version History of Area Subdivision - Subarea PolygonsTSV
This table contains the version history of the rows extracted from the 'Helsingin kaupunkiympariston toimiala' data source. It is sourced from the country 'Finland' with the ISO country code 'fi'. The table, named avoindatapiirijako_osaaluepiirijako_osaaluepolygonhistory, is a historical record of the base table avoindatapiirijako_osaalue__piirijako_osaaluepolygon. The rows in this table include information about the start and end dates when each row was extracted. The table includes various columns like '_row_number', 'id', 'aluejako', 'kunta', 'tunnus', 'nimi_fi', 'nimi_se', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'kokotunnus', 'paivitetty', 'datanomist', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. The data in this...

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the record.
id	int	The unique identifier of the record.
aluejako	string	The division of the area.
kunta	int	The municipality.
tunnus	int	The identifier.
nimi_fi	string	The name in Finnish.
nimi_se	string	The name in Swedish.
yhtluontip	string	The creation date of the entity.
yhtmuokkau	string	The modification date of the entity.
yhtdatanom	string	The data submission date of the entity.
kokotunnus	int	The full identifier of the entity.
paivitetty	string	The date of the latest update.
datanomist	string	The data owner.
geom_geojson	string	The geometry of the entity in GeoJSON format.
geom_geotext	string	The geometry of the entity 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 centroid.
geom_center_y	double	The y-coordinate of the centroid.
geom	binary	The geometry of the entity.

Column	Type	Comment
_start_date	date	The start date indicating the beginning of the validity period for the row version.
_end_date	date	The end date indicating the end of the validity period for the row version.
_row_number	long	The row number indicating the position of the row version within the table.
id	int	The unique identifier for each row version.
aluejako	string	The area division.
kunta	int	The municipality.
tunnus	int	The identifier.
nimi_fi	string	The name in Finnish.
nimi_se	string	The name in Swedish.
yhtluontip	string	The creation date and time for the row version.
yhtmuokkau	string	The last modification date and time for the row version.
yhtdatanom	string	The date and time when the row version became invalid.
kokotunnus	int	The full identifier.
paivitetty	string	The last updated date and time for the row version.
datanomist	string	The data custodian.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in Geotext format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid position for the geometry.
geom_center_x	double	The X-coordinate of the center point of the geometry.
geom_center_y	double	The Y-coordinate of the center point of the geometry.
geom	binary	The geometric data.

Last Updated	September 13, 2024
Created	April 24, 2024