History of Tonttipolygon Rows from Helsingin kaupunkiympariston toimiala in Finland
Click here for a data sample
This table contains the version history of the 'avoindatatontti__tonttipolygon' table rows. The rows in this table represent different versions of the rows in the base table. Each row in this table has additional columns '_start_date' and '_end_date' which specify the date range during which the row was extracted from the data source. The '_start_date' column contains the starting date of the row version, and the '_end_date' column contains the ending date of the row version. If the value in the '_end_date' column is null, it means that the row is the most recent version of the row. The table contains various other columns such as 'gid', 'tontti_uui', 'tyyppi', 'kunta', 'sijaintial', 'ryhma', 'yksikko', 'tehokkuusl', 'km2', 'lisakm2', 'lisakm2kuv', 'lisakm2riv', 'yhteensakm', 'lisatietoj', 'kellari', 'kerrosluku', 'ullakko', 'pintaala', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'korttelial', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. This table is sourced from the website of 'Helsingin kaupunkiympäristön toimiala' which is a data source originating from the country Finland (ISO country code 'fi'). The data in this table can be utilized in various data analytics tasks, such as analyzing changes in the tontti (land plot) attributes over time, tracking modifications to the geometry data, studying the distribution and characteristics of different types of tontti polygons, and conducting spatial analysis based on the geographic information provided in the table.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period of the row version. |
|---|
| _end_date | date | The end date of the validity period of the row version. |
|---|
| _row_number | long | The number indicating the order of the row version within the table. |
|---|
| gid | int | The unique identifier of the row. |
|---|
| tontti_uui | string | The unique identifier of the plot. |
|---|
| tyyppi | string | The type of the row. |
|---|
| kunta | int | The municipality of the row. |
|---|
| sijaintial | int | The location of the row. |
|---|
| ryhma | int | The group of the row. |
|---|
| yksikko | int | The unit of the row. |
|---|
| tehokkuusl | string | The efficiency level of the row. |
|---|
| km2 | int | The area in square kilometers. |
|---|
| lisakm2 | string | The additional area in square kilometers. |
|---|
| lisakm2kuv | string | The additional area in square kilometers (image). |
|---|
| lisakm2riv | boolean | The additional area in square kilometers (row). |
|---|
| yhteensakm | string | The total area in square kilometers. |
|---|
| lisatietoj | string | Additional information about the row. |
|---|
| kellari | string | Indicates if the row has a basement. |
|---|
| kerrosluku | string | The number of floors in the row. |
|---|
| ullakko | string | Indicates if the row has an attic. |
|---|
| pintaala | float | The surface area of the row. |
|---|
| yhtluontip | string | The date and time of the row creation. |
|---|
| yhtmuokkau | string | The date and time of the row modification. |
|---|
| yhtdatanom | string | The date and time of the row data nomination. |
|---|
| korttelial | string | The block area of the row. |
|---|
| geom_geojson | string | The geometry of the row in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row in GeoText format. |
|---|
| geom_type | string | The type of geometry of the row. |
|---|
| geom_centroid | string | The centroid of the geometry of the row. |
|---|
| geom_center_x | double | The X-coordinate of the center of the geometry of the row. |
|---|
| geom_center_y | double | The Y-coordinate of the center of the geometry of the row. |
|---|
| geom | binary | The full geometry of the row. |
|---|
