Seutukartta Tuusula Small Areas Dataset Collection
Tables
-
Geographical Areas in Tuusula, FinlandTSV
This table contains data about small areas in Tuusula, a municipality in Finland. The data is sourced from the website of the Department of Urban Environment of Helsinki. The table includes various columns such as the extraction date, row number, size of the area, municipality, larger area, status, small area name, ISO name, and other attributes. The table also contains geospatial information, such as the geometry in GeoJSON and Geotext formats, the type of geometry, geometric centroid, and center coordinates. The table provides valuable data for data analytics and can be used for various purposes, such as analyzing the distribution of small areas, studying the relationship between different attributes, and conducting spatial analysis in the context of Tuusula municipality in Finland.
-
Version History of Tuusula Small Areas in the Helsinki Metropolitan Area, Sourced from Helsingin kaupunkiympariston toimiala, FinlandTSV
This table provides the version history of rows in the 'Tuusula Small Areas' table extracted from the website of the 'Helsinki Metropolitan Area Urban Environment Division'. The data in this table originates from Finland. It contains information about various attributes such as the start and end dates of each row, row number, size information, municipality, region, status, name, ISO name, group, geojson and geotext representations of the geometry, geometry type, centroid, center coordinates, and the geometry itself. The table is useful for data analytics tasks such as tracking changes over time, analyzing trends, and comparing different versions of the 'Tuusula Small Areas' dataset.
Column Descriptions
Geographical Areas in Tuusula, Finland
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data was extracted. |
_row_number | long | The row number of the data entry. |
kokotun | int | The size of the object. |
kunta | int | The municipality of the object. |
suur | int | The area of the object. |
tila | int | The status of the object. |
pien | int | The smallness of the object. |
nimi | string | The name of the object. |
nimi_iso | string | The ISO name of the object. |
mtryhm | int | The measurement group of the object. |
geom_geojson | string | The geometry of the object in GeoJSON format. |
geom_geotext | string | The geometry of the object in Geotext format. |
geom_type | string | The type of geometry of the object. |
geom_centroid | string | The centroid point of the object. |
geom_center_x | double | The x-coordinate of the center point of the object. |
geom_center_y | double | The y-coordinate of the center point of the object. |
geom | binary | The full geometry of the object. |
Version History of Tuusula Small Areas in the Helsinki Metropolitan Area, Sourced 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 | An additional column for maintaining the version history of the base table rows. |
kokotun | int | A column with an unidentified purpose or meaning. |
kunta | int | A column representing the municipality of the row. |
suur | int | A column with unknown purpose or meaning. |
tila | int | A column showing the status of the row. |
pien | int | A column with unspecified purpose or meaning. |
nimi | string | A column depicting the name of the row. |
nimi_iso | string | A column with the name of the row in ISO format. |
mtryhm | int | A column representing the measurement group of the row. |
geom_geojson | string | A column containing geometry data in GeoJSON format. |
geom_geotext | string | A column containing geometry data in Geotext format. |
geom_type | string | A column representing the type of geometry. |
geom_centroid | string | A column containing 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 | A column containing the geometrical representation of the row. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | October 22, 2018 |