Version History of Tiekeperuspiiri Peruspiiri
Click here for a data sample
This table, sourced from the website of 'Department of Urban Environment, City of Helsinki' in the country of Finland (ISO country code: 'fi'), represents the version history of the base table rows of 'tiekeperuspiiri__peruspiiri'. It contains additional columns '_start_date' and '_end_date' which store the extraction dates of each version. The table contains historical data related to 'gml_id', 'kunta', 'kunta_nimi', 'kunta_nim0', 'nimi', 'nimi_se', 'suurpiiri', 'suurpiiri0', 'suurpiiri1', 'tunnus', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. It also includes 'geom' column which stores geometric data. This table provides valuable information for data analysis and can be utilized, for example, to track the changes in geographical boundaries or demographic information over time.
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 | The unique row number identifier for the version history. |
|---|
| gml_id | string | The GML identifier for the row. |
|---|
| kunta | int | The municipality code. |
|---|
| kunta_nimi | string | The name of the municipality. |
|---|
| kunta_nim0 | string | An alternate name of the municipality. |
|---|
| nimi | string | The name of the row. |
|---|
| nimi_se | string | The name of the row in Swedish. |
|---|
| suurpiiri | string | The administrative division code. |
|---|
| suurpiiri0 | string | An alternate administrative division code. |
|---|
| suurpiiri1 | int | An additional administrative division code. |
|---|
| tunnus | int | The unique identifier for the row. |
|---|
| geom_geojson | string | The geographic shape of the row in GeoJSON format. |
|---|
| geom_geotext | string | The geographic shape of the row in Geotext format. |
|---|
| geom_type | string | The type of geographic shape. |
|---|
| geom_centroid | string | The centroid of the geographic shape. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geographic shape. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geographic shape. |
|---|
| geom | binary | The original geographic shape data. |
|---|
