Version History of Asemakaavapolygon for Helsingin kaupunkiympariston toimiala (Finland)
Click here for a data sample
This table contains the version history of the 'avoindataasemakaava__asemakaavapolygon' table. It has two additional columns compared to its base table: '_start_date' and '_end_date'. The '_start_date' column contains the date when the row was extracted from the data source, while the '_end_date' column contains the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version. The data in this table is sourced from the website of 'Helsinki City Environment Sector' (Helsingin kaupunkiympariston toimiala) which originates from the country with ISO country code 'fi'. This table can be used for various data analytics purposes such as analyzing the changes in zoning plans (asemakaava) over time, examining the approval process of different plans, calculating the surface area (pintaala) of each plan, and determining the geographic location (geom) and centroid coordinates (geom_centroid) of the plans.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date indicating the validity period of the row version. |
|---|
| _end_date | date | The end date indicating the validity period of the row version. |
|---|
| _row_number | long | The row number of the version in the table. |
|---|
| gid | int | The unique identifier of the row. |
|---|
| asemakaava | string | The Asemakaava value. |
|---|
| kaavatunnu | int | The Kaavatunnu value. |
|---|
| hankenumer | string | The Hankenumer value. |
|---|
| kieli1 | string | The Kieli1 value. |
|---|
| kieli2 | string | The Kieli2 value. |
|---|
| kaavanimi1 | string | The Kaavanimi1 value. |
|---|
| kaavanimi2 | string | The Kaavanimi2 value. |
|---|
| kaavanlaat | string | The Kaavanlaat value. |
|---|
| hyvaksyja | string | The Hyvaksyja value. |
|---|
| vireilletu | string | The Vireilletu value. |
|---|
| hyvaksymis | string | The Hyvaksymis value. |
|---|
| voimaantul | string | The Voimaantul value. |
|---|
| kuntakoodi | int | The Kuntakoodi value. |
|---|
| kaavanvaih | string | The Kaavanvaih value. |
|---|
| kaavatyypp | string | The Kaavatyypp value. |
|---|
| kaavatyyp0 | string | The Kaavatyyp0 value. |
|---|
| aluesijain | string | The Aluesijain value. |
|---|
| nahtaville | string | The Nahtaville value. |
|---|
| nahtavilla | string | The Nahtavilla value. |
|---|
| kaavamaara | string | The Kaavamaara value. |
|---|
| kaavalinkk | string | The Kaavalinkk value. |
|---|
| pintaala | float | The Pintaala value. |
|---|
| lisatietoj | string | The Lisatietoj value. |
|---|
| yhtluontip | string | The Yhtluontip value. |
|---|
| yhtmuokkau | string | The Yhtmuokkau value. |
|---|
| yhtdatanom | string | The Yhtdatanom value. |
|---|
| geom_geojson | string | The GeoJSON representation of the geometry. |
|---|
| geom_geotext | string | The textual representation of the geometry. |
|---|
| geom_type | string | The type of the geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry. |
|---|
| geom | binary | The geometry value. |
|---|
