Version History of Tuusula Small Areas in the Helsinki Metropolitan Area, Sourced from Helsingin kaupunkiympariston toimiala, Finland
Click here for a data sample
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.
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
