Started Building ID in Helsinki by City Environment Sector from Finland
Click here for a data sample
This table contains data from the website of Helsingin kaupunkiympariston toimiala in Finland. It provides information about the commenced building identifiers and their associated polygons. The table contains various columns including '_extract_date', '_row_number', 'rakennustu', 'kohdenimi', 'tekstisuun', 'tekstikoko', 'tekstifont', 'buix_bid', 'paivitetty', 'datanomist', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. The data in this table can be utilized for various data analytics purposes such as analyzing the distribution of different building types, exploring the geographical characteristics of the buildings, examining the update history of the data, and studying the textual attributes associated with the buildings.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted from the source. |
|---|
| _row_number | long | The unique identifier for each row in the table. |
|---|
| rakennustu | int | The type of building. |
|---|
| kohdenimi | string | The name of the target. |
|---|
| tekstisuun | int | The direction of the text. |
|---|
| tekstikoko | float | The size of the text. |
|---|
| tekstifont | string | The font used for the text. |
|---|
| buix_bid | int | The bid for the building. |
|---|
| paivitetty | string | The date when the data about the building was last updated. |
|---|
| datanomist | string | The name of the data analyst who last handled the data. |
|---|
| geom_geojson | string | The geographic data of the building in GeoJSON format. |
|---|
| geom_geotext | string | The geographic data of the building in GeoText format. |
|---|
| geom_type | string | The type of geographic data. |
|---|
| geom_centroid | string | The centroid of the geographic data. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geographic data. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geographic data. |
|---|
| geom | binary | The complete geometric representation of the building. |
|---|
