City Planning Polygon Data
Click here for a data sample
This table contains data from the 'Helsinki Urban Environment Sector' website in Finland. It provides information about city plans and their details. The table includes various columns such as '_extract_date', '_row_number', 'gid', 'asemakaava', 'kaavatunnu', 'hankenumer', 'kieli1', 'kieli2', 'kaavanimi1', 'kaavanimi2', 'kaavanlaat', 'hyvaksyja', 'vireilletu', 'hyvaksymis', 'voimaantul', 'kuntakoodi', 'kaavanvaih', 'kaavatyypp', 'kaavatyyp0', 'aluesijain', 'nahtaville', 'nahtavilla', 'kaavamaara', 'kaavalinkk', 'pintaala', 'lisatietoj', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This data can be utilized in data analytics for various purposes such as analyzing the distribution of city plans across different areas, studying the approval and enforcement timelines, assessing the size and characteristics of the plans, and identifying trends in the types of plans and their status over time.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the record was extracted. |
|---|
| _row_number | long | The row number of the record. |
|---|
| gid | int | The unique ID of the record. |
|---|
| 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 date when the kaava was vireilletu. |
|---|
| hyvaksymis | string | The date when the kaava was hyvaksymis. |
|---|
| voimaantul | string | The date when the kaava was voimaantul. |
|---|
| 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 date when the kaava was nahtaville. |
|---|
| 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 timestamp when the kaava was created. |
|---|
| yhtmuokkau | string | The timestamp when the kaava was modified. |
|---|
| yhtdatanom | string | The date when the kaava data was published. |
|---|
| geom_geojson | string | The geometrical data of the kaava in GeoJSON format. |
|---|
| geom_geotext | string | The geometrical data of the kaava in WKT format. |
|---|
| geom_type | string | The type of the geometrical data. |
|---|
| geom_centroid | string | The centroid point coordinates of the geometrical data. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometrical data. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometrical data. |
|---|
| geom | binary | The geometrical data of the kaava. |
|---|
