Geographical Division of Helsinki City Environment Department

This dataset collection, sourced from the website of Helsingin kaupunkiympariston toimiala in Finland, includes one or more dataset tables. The tables in this collection are part of the avoindatakarttalehtijako_05x05_km collection.

Tables

History of Map Sheets Division (0.5x0.5km) - Helsingin kaupunkiympäristön toimiala - FinlandTSV
This table contains the version history of the rows in the 'avoindatakarttalehtijako_05x05_km__karttalehtijako_05x05_kmpolygon' table sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. The rows in this table represent different versions of the base table rows, with each row having '_start_date' and '_end_date' columns indicating the extraction dates. The table includes various columns such as 'id', 'tunnus', 'lehtikoko', 'lehtikoko0', 'koordinaat', 'koordinaa0', 'km_indeksi', 'km_indeks0', 'km_alainde', 'kunnan_alu', 'pintaala', 'luonti_pvm', 'data_muokk', 'muokkaus_p', 'omistaja', 'historia_p', 'data_luoja', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This historical version data can be utilized in...
Public Map Sheet Division in 0.5x0.5 km Grid - Map Sheet Division in 0.5x0.5 km PolygonTSV
This table contains data from the avoindatakarttalehtijako_05x05_km__karttalehtijako_05x05_kmpolygon dataset sourced from the website of Helsingin kaupunkiympariston toimiala. The dataset originates from Finland (ISO country code: fi). The table includes various columns such as _extract_date, _row_number, id, tunnus, lehtikoko, lehtikoko0, koordinaat, koordinaa0, km_indeksi, km_indeks0, km_alainde, kunnan_alu, pintaala, luonti_pvm, data_muokk, muokkaus_p, omistaja, historia_p, data_luoja, geom_geojson, geom_geotext, geom_type, geom_centroid, geom_center_x, and geom_center_y. The data in this table can be utilized for data analytics purposes such as spatial analysis, geographical mapping, area calculations, historical analysis, and data integration with other datasets.

Column Descriptions

Public Map Sheet Division in 0.5x0.5 km Grid - Map Sheet Division in 0.5x0.5 km Polygon

Column	Type	Comment
_extract_date	date	The date when the record was extracted.
_row_number	long	The row number of the record.
id	int	The unique identifier of the record.
tunnus	string	The tunnus of the record.
lehtikoko	int	The lehtikoko of the record.
lehtikoko0	int	The lehtikoko0 of the record.
koordinaat	int	The koordinaat of the record.
koordinaa0	int	The koordinaa0 of the record.
km_indeksi	int	The km_indeksi of the record.
km_indeks0	int	The km_indeks0 of the record.
km_alainde	string	The km_alainde of the record.
kunnan_alu	string	The kunnan_alu of the record.
pintaala	string	The pintaala of the record.
luonti_pvm	string	The date of creation of the record.
data_muokk	string	The data muokk of the record.
muokkaus_p	string	The muokkaus_p of the record.
omistaja	string	The omistaja of the record.
historia_p	string	The historia_p of the record.
data_luoja	string	The data luoja of the record.
geom_geojson	string	The geom_geojson of the record.
geom_geotext	string	The geom_geotext of the record.
geom_type	string	The geom_type of the record.
geom_centroid	string	The geom_centroid of the record.
geom_center_x	double	The X-coordinate of the geom_center of the record.
geom_center_y	double	The Y-coordinate of the geom_center of the record.
geom	binary	The geometry information of the record.

History of Map Sheets Division (0.5x0.5km) - Helsingin kaupunkiympäristön toimiala - 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 row number indicating the version history of the base table rows.
id	int	The unique identifier of the row.
tunnus	string	The tunnus of the row.
lehtikoko	int	The lehtikoko of the row.
lehtikoko0	int	The lehtikoko0 of the row.
koordinaat	int	The koordinaat of the row.
koordinaa0	int	The koordinaa0 of the row.
km_indeksi	int	The km_indeksi of the row.
km_indeks0	int	The km_indeks0 of the row.
km_alainde	string	The km_alainde of the row.
kunnan_alu	string	The kunnan_alu of the row.
pintaala	string	The pintaala of the row.
luonti_pvm	string	The creation date of the row.
data_muokk	string	The data_muokk of the row.
muokkaus_p	string	The muokkaus_p of the row.
omistaja	string	The omistaja of the row.
historia_p	string	The historia_p of the row.
data_luoja	string	The data_luoja of the row.
geom_geojson	string	The geom_geojson of the row.
geom_geotext	string	The geom_geotext of the row.
geom_type	string	The geom_type of the row.
geom_centroid	string	The centroid of the geom field of the row.
geom_center_x	double	The x-coordinate of the center point of the geom field of the row.
geom_center_y	double	The y-coordinate of the center point of the geom field of the row.
geom	binary	The geom field of the row.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024