Suuralueet Dataset Collection
Tables
-
History of Tuusula Greater Area Polygons in Finland from Helsingin kaupunkiymparisto ToimialaTSV
This table contains the version history of the 'seutukarttatuusula_suuralueet__tuusula_suuralueetpolygon' table. It provides information about the versions of rows extracted from the data source. The table has additional columns compared to the base table, which are '_start_date' and '_end_date'. The '_start_date' column represents the date when a particular version of the row was extracted, while the '_end_date' column represents the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it indicates that the row is the most recent version. The data in this table can be utilized in various data analytics tasks, such as tracking changes in the attributes of the base table rows over time, analyzing the frequency of updates, and identifying...
-
Suuralueet in Tuusula, FinlandTSV
The table contains information about the municipalities and regions in Tuusula, Finland. It provides data related to the extract date, row number, size category, municipality, region, name, ISO name, group, geometric data in GeoJSON and Geotext formats, geometric type, centroid, center x-coordinate, center y-coordinate, and geometry. The table can be used for various data analytics purposes such as analyzing the size distribution of regions, studying the relationship between municipalities and regions, visualizing the geometric data, and performing spatial analysis.
Column Descriptions
Suuralueet 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 kokotun value. |
kunta | int | The name of the municipality. |
suur | int | The suur value. |
nimi | string | The name. |
nimi_iso | string | The ISO name. |
mtryhm | int | The mtryhm value. |
geom_geojson | string | The geometry data in GeoJSON format. |
geom_geotext | string | The geometry data in Geotext format. |
geom_type | string | The type of geometry. |
geom_centroid | string | 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 | The geometry data. |
History of Tuusula Greater Area Polygons in Finland from Helsingin kaupunkiymparisto Toimiala
Column | Type | Comment |
---|---|---|
_start_date | date | A column indicating the start date of the validity period for the row version. |
_end_date | date | A column indicating the end date of the validity period for the row version. |
_row_number | long | A column indicating the row number of the version history. |
kokotun | int | A column with an unspecified purpose or meaning. |
kunta | int | A column containing a municipality or local district name. |
suur | int | A column with an unspecified purpose or meaning. |
nimi | string | A column containing a name. |
nimi_iso | string | A column containing an ISO standardized name. |
mtryhm | int | A column categorizing data into a specific group or category. |
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 indicating the type of geometry data. |
geom_centroid | string | A column containing the centroid of the geometry data. |
geom_center_x | double | A column containing the x-coordinate of the centroid of the geometry data. |
geom_center_y | double | A column containing the y-coordinate of the centroid of the geometry data. |
geom | binary | A column containing the actual geometry data. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | October 22, 2018 |