Historical Version of Neighborhood Data from Helsingin kaupunkiympariston toimiala in Finland
Click here for a data sample
This table contains the version history of rows from the 'helkaupunginosakaupunginosa' base table. It is named 'helkaupunginosakaupunginosa__history' and sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. The table includes columns '_start_date' and '_end_date' which represent the extraction dates of the row versions. The table could be utilized in data analytics to analyze the changes in various attributes over time, such as 'data_luoja', 'tarkkuus', 'mittausera', 'pinta', 'historia_p', 'omistaja', 'muokkaus_p', 'data_muokk', 'id', 'aluejako', 'kunta', 'tunnus', 'nimi', 'nimi_se', 'alkuperako', 'luonti_pvm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The 'geom' column contains geospatial information related to the geographical locations represented by the rows. By analyzing the historical versions, valuable insights can be gained about the changes in these attributes over time.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for this row version. |
|---|
| _end_date | date | The end date of the validity period for this row version. |
|---|
| _row_number | long | The row number of the version history entry. |
|---|
| data_luoja | string | The creator of the data. |
|---|
| tarkkuus | int | The accuracy of the data. |
|---|
| mittausera | int | The measurement unit of the data. |
|---|
| pinta | int | The surface of the data. |
|---|
| historia_p | timestamp | A flag indicating if this row version is a historical entry. |
|---|
| omistaja | string | The owner of the data. |
|---|
| muokkaus_p | timestamp | A flag indicating if this row version has been modified. |
|---|
| data_muokk | string | The date of the last modification of the data. |
|---|
| id | int | The unique identifier of the row version. |
|---|
| aluejako | string | The administrative division of the data. |
|---|
| kunta | int | The municipality of the data. |
|---|
| tunnus | int | The identifier of the data. |
|---|
| nimi | string | The name of the data. |
|---|
| nimi_se | string | The name of the data in Swedish. |
|---|
| alkuperako | int | The original source of the data. |
|---|
| luonti_pvm | timestamp | The creation date of the data. |
|---|
| geom_geojson | string | The serialized geometry in GeoJSON format. |
|---|
| geom_geotext | string | The serialized geometry in WKT 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 point of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry. |
|---|
| geom | binary | The geometry data. |
|---|
