To download the data set, please sign up or log in
Yleiskaavan käyttötarkoitusalueet
Tables
-
Yk Kt Alue Viewpolygon, Opendatayk Kt Alue ViewTSV
Yleiskaavan käyttötarkoitusalueet tietokanta sisältää kaikki yleiskaavojen voimassa olevat aluevaraukset, sekä alueita koskevat kaavamääräykset. Aluevarausmerkinnöillä osoitetaan alueen pääasiallinen käyttötarkoitus. Alueiden käyttötarkoitukset on ryhmitelty 11 pääluokkaan, jotka ovat: A = Asuminen, C = Keskustatoiminnot, P ja KM = Palvelut, T = Työ ja tuotanto, V = Virkistys, R = Loma-asuminen, L = Liikenne, E = Erityisalueet, S = Suojelu, M = Maa- ja metsätalous, W = vesialueet.
Column Descriptions
Yk Kt Alue Viewpolygon, Opendatayk Kt Alue View
| Column | Type | Comment |
|---|---|---|
| maaraystek | string | Data source did not contain a description for MAARAYSTEK. Column maaraystek has 3343 rows, out of which 338 are empty, making the null percent 10.11. An example value is YMPÄRISTÖHÄIRIÖTÄ AIHEUTT... |
| yleiskaava | string | Data source did not contain a description for YLEISKAAVA. Column yleiskaava has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Nurmi-Sorilan oyk and maximum string is Vuoreksen oyk. |
| yleiskaav0 | string | Data source did not contain a description for YLEISKAAV0. Column yleiskaav0 has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is yk035 and maximum string is yk045. |
| lainvoima | timestamp | Data source did not contain a description for LAINVOIMA. |
| oikeusvaik | string | Data source did not contain a description for OIKEUSVAIK. Column oikeusvaik has 3343 rows, out of which 49 are empty, making the null percent 1.47. |
| alueen_nro | string | Data source did not contain a description for ALUEEN_NRO. Column alueen_nro has 3343 rows, out of which 473 are empty, making the null percent 14.15. |
| kaytto_tar | string | Data source did not contain a description for KAYTTO_TAR. Column kaytto_tar has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AO-5 and maximum string is W. |
| pinta_ala | float | Data source did not contain a description for PINTA_ALA. Column pinta_ala has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.00 and maximum value is 87848552.00. |
| alue_tehok | int | Data source did not contain a description for ALUE_TEHOK. Column alue_tehok has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 1. |
| tontti_teh | int | Data source did not contain a description for TONTTI_TEH. Column tontti_teh has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 450. |
| kortteli_t | int | Data source did not contain a description for KORTTELI_T. Column kortteli_t has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 0. |
| rak_oikeus | int | Data source did not contain a description for RAK_OIKEUS. Column rak_oikeus has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 168618. |
| korttelika | string | Data source did not contain a description for KORTTELIKA. Column korttelika has 3343 rows, out of which 3251 are empty, making the null percent 97.25. This column is filled with a constant value. The single string value is: 0. |
| asukasmaar | int | Data source did not contain a description for ASUKASMAAR. Column asukasmaar has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 1935. |
| perhekunta | int | Data source did not contain a description for PERHEKUNTA. Column perhekunta has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 3. |
| asuntokoko | int | Data source did not contain a description for ASUNTOKOKO. Column asuntokoko has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 200. |
| asuntomaar | int | Data source did not contain a description for ASUNTOMAAR. Column asuntomaar has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 1738. |
| tyopaikkam | int | Data source did not contain a description for TYOPAIKKAM. Column tyopaikkam has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 140629. |
| rak_paik_l | int | Data source did not contain a description for RAK_PAIK_L. Column rak_paik_l has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 35. |
| varikoodi | int | Data source did not contain a description for VARIKOODI. Column varikoodi has 3343 rows, out of which 2 are empty, making the null percent 0.06. Minimum value is 1 and maximum value is 18. |
| auto_paik | int | Data source did not contain a description for AUTO_PAIK. Column auto_paik has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 0. |
| kaup_maano | int | Data source did not contain a description for KAUP_MAANO. Column kaup_maano has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 0. |
| maarayskoo | string | Data source did not contain a description for MAARAYSKOO. Column maarayskoo has 3343 rows, out of which 12 are empty, making the null percent 0.36. |
| mi_symbolo | string | Data source did not contain a description for MI_SYMBOLO. Column mi_symbolo has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Pen (12, 2, 0) Brush (2, ... and first 25 characters of maximum string: Pen (30, 2, 16711680) Bru... |
| mi_prinx | int | Data source did not contain a description for MI_PRINX. Column mi_prinx has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 9926 and maximum value is 14095. |
| geom_geojson | string | Geometry in GeoJSON format. |
| orig_extractdate | string |
Additional Info
| Last Updated | September 2, 2023 |
|---|---|
| Created | August 9, 2018 |