History of Tuusula Greater Area Polygons in Finland from Helsingin kaupunkiymparisto Toimiala
Click here for a data sample
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 trends or patterns in the version history. The table is sourced from the website of 'Helsinki City Environment' in Finland (ISO country code 'FI').
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
