Map of Kauniainen: Subareas
Tables
-
Areas in Kauniainen MunicipalityTSV
This table contains data from the 'Helsinki Urban Environment Sector' website, which originates from Finland. It provides information on the small areas of Kauniainen, including their sizes, municipalities, classification, names, and geographic data. The table includes various columns like '_extract_date', '_row_number', 'kokotun', 'kunta', 'suur', 'tila', 'pien', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', which can be utilized for data analytics. Examples of data analysis include studying the population density, spatial distribution, and classification of the small areas in Kauniainen, as well as performing geospatial analysis and generating visualizations of the geographic features.
-
Version History of Kauniainen Small Area Polygons from Helsingin kaupunkiympariston toimiala, FinlandTSV
This table contains the version history of the base table 'seutukarttakauniainen_pienalueet__kauniainen_pienalueetpolygon'. It includes additional columns '_start_date' and '_end_date', representing the extraction dates of each row. The data in this table is sourced from the website of 'Helsinki Urban Environment Division', which originates from the country with the ISO country code 'FI'. The table can be leveraged for various data analytics purposes, such as analyzing changes and updates made to the base table over time, tracking historical trends and patterns, and identifying the most recent version of rows based on the '_end_date' column.
Column Descriptions
Areas in Kauniainen Municipality
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data was extracted. |
_row_number | long | The row number of the record. |
kokotun | int | The total area in square meters. |
kunta | int | The municipality where the data corresponds to. |
suur | int | The size of an object. |
tila | int | The status of an object. |
pien | int | The small size of an object. |
nimi | string | The name of an object. |
nimi_iso | string | The ISO standardized name of an object. |
mtryhm | int | The group to which an object belongs. |
geom_geojson | string | The geometry of an object in GeoJSON format. |
geom_geotext | string | The geometry of an object in Well-Known Text (WKT) format. |
geom_type | string | The type of geometry. |
geom_centroid | string | The centroid of an object geometry. |
geom_center_x | double | The X-coordinate of the center point of an object geometry. |
geom_center_y | double | The Y-coordinate of the center point of an object geometry. |
geom | binary | The geometry of an object. |
Version History of Kauniainen Small Area Polygons from Helsingin kaupunkiympariston toimiala, Finland
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 | A unique identifier for each row version in the table. |
kokotun | int | The value of the 'kokotun' column in the base table for the given row version. |
kunta | int | The value of the 'kunta' column in the base table for the given row version. |
suur | int | The value of the 'suur' column in the base table for the given row version. |
tila | int | The value of the 'tila' column in the base table for the given row version. |
pien | int | The value of the 'pien' column in the base table for the given row version. |
nimi | string | The value of the 'nimi' column in the base table for the given row version. |
nimi_iso | string | The value of the 'nimi_iso' column in the base table for the given row version. |
mtryhm | int | The value of the 'mtryhm' column in the base table for the given row version. |
geom_geojson | string | The value of the 'geom_geojson' column in the base table for the given row version. |
geom_geotext | string | The value of the 'geom_geotext' column in the base table for the given row version. |
geom_type | string | The value of the 'geom_type' column in the base table for the given row version. |
geom_centroid | string | The value of the 'geom_centroid' column in the base table for the given row version. |
geom_center_x | double | The X-coordinate of the center point of the geometry in the 'geom' column for the given row version. |
geom_center_y | double | The Y-coordinate of the center point of the geometry in the 'geom' column for the given row version. |
geom | binary | The geometry value for the given row version in the base table. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | October 21, 2018 |