Vacant Plot Information in Helsinki City, Finland
Click here for a data sample
The avoindatatontti__tonttipolygon table contains data from Helsingin kaupunkiympariston toimiala website, which is a public dataset from Finland (ISO country code 'fi'). The table includes various attributes such as extract date, row number, unique identifier, type, municipality, location, group, unit, efficiency, area in km2, additional area, additional area with a corresponding image and row, total area, additional information, basement availability, number of floors, attic availability, surface area, creation date, modification date, data update date, block information, geometry in GeoJSON format, geometry in GeoText format, geometry type, centroid coordinates, and the raw geometry. The table provides valuable information that can be utilized in data analytics for various purposes, such as studying the distribution of properties in different municipalities, analyzing the efficiency and size of different types of parcels, exploring the availability of basements and attics, examining the characteristics of different groups and units, and conducting spatial analysis based on the geometry data.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date on which the data was extracted. |
|---|
| _row_number | long | The sequential number of the row in the table. |
|---|
| gid | int | The unique identification number of the row. |
|---|
| tontti_uui | string | The unique identifier for the tontti. |
|---|
| tyyppi | string | The type of the tontti or property. |
|---|
| kunta | int | The municipality where the tontti is located. |
|---|
| sijaintial | int | The address or location details of the tontti. |
|---|
| ryhma | int | The group or category to which the tontti belongs. |
|---|
| yksikko | int | The unit or entity associated with the tontti. |
|---|
| tehokkuusl | string | The efficiency level or rating of the tontti. |
|---|
| km2 | int | The area of the tontti in square kilometers. |
|---|
| lisakm2 | string | Additional area of the tontti in square kilometers. |
|---|
| lisakm2kuv | string | Additional area of the tontti in square kilometers, as described visually. |
|---|
| lisakm2riv | boolean | Additional area of the tontti in square kilometers, as described in text. |
|---|
| yhteensakm | string | The total area of the tontti in square kilometers. |
|---|
| lisatietoj | string | Additional information or details about the tontti. |
|---|
| kellari | string | Indicates whether the tontti has a cellar or not. |
|---|
| kerrosluku | string | The number of floors or stories in the tontti. |
|---|
| ullakko | string | Indicates whether the tontti has an attic or not. |
|---|
| pintaala | float | The total surface area of the tontti in square meters. |
|---|
| yhtluontip | string | The date and time when the tontti was created. |
|---|
| yhtmuokkau | string | The date and time when the tontti was last modified. |
|---|
| yhtdatanom | string | The date and time when the tontti data was last inspected or updated. |
|---|
| korttelial | string | The area of the block or plot in which the tontti is located. |
|---|
| geom_geojson | string | The geometry of the tontti represented in GEOJSON format. |
|---|
| geom_geotext | string | The geometry of the tontti represented as a Geotext. |
|---|
| geom_type | string | The type of geometry representing the tontti. |
|---|
| geom_centroid | string | The centroid point of the tontti's geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the tontti's geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the tontti's geometry. |
|---|
| geom | binary | The full geometry information of the tontti. |
|---|
