Version History of District Division and District Polygon
Click here for a data sample
This table contains the version history of the 'Piirijako_suupriiripolygon' table, sourced from the website of the Helsinki City Environment Sector in Finland. The table includes information about the start and end dates of each version. It also includes columns such as 'id', 'aluejako', 'kunta', 'tunnus', 'nimi_fi', 'nimi_se', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'kokotunnus', 'paivitetty', 'datanomist', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns provide various details about the geographic divisions, such as identifying codes, names in Finnish and Swedish, creation and modification information, and geographic data in different formats. The history of the rows in this table can be utilized in data analytics to analyze the changes and evolution of the geographic divisions over time, track updates performed by different users, or investigate patterns and relationships between the divisions and other datasets. With this historical view, users can gain insights into the development and dynamics of the city's administrative divisions.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column indicates the start date of the validity period for the row version. |
|---|
| _end_date | date | This column indicates the end date of the validity period for the row version. |
|---|
| _row_number | long | This column represents the row number of the version in the table. |
|---|
| id | int | This column contains the unique identifier for each row. |
|---|
| aluejako | string | This column stores the information related to area division. |
|---|
| kunta | int | This column holds the information about the municipality. |
|---|
| tunnus | int | This column stores a distinct identifier for each row. |
|---|
| nimi_fi | string | This column contains the name in Finnish language. |
|---|
| nimi_se | string | This column contains the name in Swedish language. |
|---|
| yhtluontip | string | This column indicates the creation date of the row. |
|---|
| yhtmuokkau | string | This column indicates the modification date of the row. |
|---|
| yhtdatanom | string | This column indicates the date of data anonymization for the row. |
|---|
| kokotunnus | int | This column stores the composite identifier for the row. |
|---|
| paivitetty | string | This column indicates the date and time of the row update. |
|---|
| datanomist | string | This column contains information about the data owner. |
|---|
| geom_geojson | string | This column stores the geometry data of the row in GeoJSON format. |
|---|
| geom_geotext | string | This column stores the geometry data of the row in plain text format. |
|---|
| geom_type | string | This column indicates the type of geometry data stored for the row. |
|---|
| geom_centroid | string | This column stores the coordinates of the centroid of the geometry. |
|---|
| geom_center_x | double | This column stores the X-coordinate of the center of the geometry. |
|---|
| geom_center_y | double | This column stores the Y-coordinate of the center of the geometry. |
|---|
| geom | binary | This column stores the geometry data of the row. |
|---|
