Version History of KaavamaaraysPolygon in Helsingin kaupunkiymparisto DB (Finland)
Click here for a data sample
This table stores the version history of rows extracted from the Helsingin kaupunkiympariston toimiala website. The rows contain various data related to avoindatakaavamaarayskaavamaarayspolygon. The table has additional columns '_start_date' and '_end_date' which represent the extraction dates of each row version. The table contains information such as 'gid', 'kaavamaara', 'tyyppi', 'luokka', 'teksti', 'symbolityy', 'maanalaine', 'leveys', 'sitova', 'pintaala', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'angle', 'x_scale', 'y_scale', 'asemakaava', 'rakennusal', 'ymparistoa', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The information in this table can be utilized in various data analytics tasks, such as analyzing the historical changes and trends in the avoindatakaavamaarayskaavamaarayspolygon data, identifying patterns or correlations between different attributes, or performing spatial analysis based on the 'geom' column. This data is sourced from the website of 'Helsinki City Environment Sector' which is located in Finland (FI).
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for the row version. |
|---|
| _end_date | date | The end date of the validity period for the row version. |
|---|
| _row_number | long | The unique identifier of the row version. |
|---|
| gid | int | The identifier of the row in the base table. |
|---|
| kaavamaara | string | The value representing the 'kaavamaara' of the row in the base table. |
|---|
| tyyppi | string | The type of the row in the base table. |
|---|
| luokka | string | The classification of the row in the base table. |
|---|
| teksti | string | The text associated with the row in the base table. |
|---|
| symbolityy | string | The symbol type of the row in the base table. |
|---|
| maanalaine | boolean | Indicates if the row in the base table is underground. |
|---|
| leveys | string | The width of the row in the base table. |
|---|
| sitova | boolean | Indicates if the row in the base table is binding. |
|---|
| pintaala | string | The area of the row in the base table. |
|---|
| yhtluontip | string | The timestamp of the row creation in the base table. |
|---|
| yhtmuokkau | string | The timestamp of the row modification in the base table. |
|---|
| yhtdatanom | string | The timestamp of the data nomination in the base table. |
|---|
| angle | string | The angle of the row in the base table. |
|---|
| x_scale | string | The X scale of the row in the base table. |
|---|
| y_scale | string | The Y scale of the row in the base table. |
|---|
| asemakaava | string | The asemakaava associated with the row in the base table. |
|---|
| rakennusal | string | The rakennusal associated with the row in the base table. |
|---|
| ymparistoa | string | The ymparistoa associated with the row in the base table. |
|---|
| 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 the geometry associated with the row. |
|---|
| geom_centroid | string | The centroid of the geometry associated with the row. |
|---|
| 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 associated with the row. |
|---|
