Database Table: Planning Directory Area - Underground Plan in Progress
Click here for a data sample
The table contains data obtained from the website of Helsingin kaupunkiympariston toimiala, which originates from Finland (ISO country code: fi). It represents information related to 'avoindatakaavahakemisto_alue_maanalainenkaava_vireilla__kaavahakemisto_alue_maanalainenkaava_vireillapolygon' table. The table consists of several columns that store various attributes such as '_extract_date', '_row_number', 'id', 'tyyppi', 'kaavatunnu', 'luokka', 'alkuperain', 'pintaala', 'korkeusjar', 'sijaintial', 'hyvaksymis', 'lainvoimai', 'voimaantul', 'vahvistami', 'luontipvm', 'muokkauspv', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', 'geom'. This table can be utilized for data analytics by performing various operations such as filtering, aggregating and analyzing the attributes stored in the columns.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted. |
|---|
| _row_number | long | The row number of the record. |
|---|
| id | int | The unique identifier for each record. |
|---|
| tyyppi | string | The type of the record. |
|---|
| kaavatunnu | string | The code for the property. |
|---|
| luokka | string | The class of the property. |
|---|
| alkuperain | string | The origin of the property. |
|---|
| pintaala | float | The area of the property. |
|---|
| korkeusjar | string | The altitude of the property. |
|---|
| sijaintial | string | The location of the property. |
|---|
| hyvaksymis | string | The approval status of the property. |
|---|
| lainvoimai | date | The legal status of the property. |
|---|
| voimaantul | date | The effective date of the property. |
|---|
| vahvistami | date | The confirmation date of the property. |
|---|
| luontipvm | date | The creation date of the record. |
|---|
| muokkauspv | date | The modification date of the record. |
|---|
| datanomist | string | The owner of the data. |
|---|
| paivitetty | date | Flag indicating whether the record has been updated. |
|---|
| geom_geojson | string | The geographic data of the property in GeoJSON format. |
|---|
| geom_geotext | string | The geographic data of the property in GeoText format. |
|---|
| geom_type | string | The type of the geographic data. |
|---|
| geom_centroid | string | The centroid coordinates of the property. |
|---|
| geom_center_x | double | The x coordinate of the center point of the property. |
|---|
| geom_center_y | double | The y coordinate of the center point of the property. |
|---|
| geom | binary | The geometric representation of the property. |
|---|
