To download the data set, please sign up or log in

Yleiskaavan käyttötarkoitusalueet

Yleiskaavan käyttötarkoitusalueet

Tables

Column Descriptions

Tampere Ora Yk Kt Alue Viewpolygon, Fkit Tamperetampere Ora Yk 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. First 25 characters of minimum string: ... and first 25 characters of maximum string: 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. Minimum string is and maximum string is O.
alueen_nro int 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. Minimum value is 0 and maximum value is 66.
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. Constant 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 int 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. Constant 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. Constant 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. Constant 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. Minimum string is 035-004 and maximum string is 045-011.
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.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3343 rows, out of which 2 are empty, making the null percent 0.06. First 25 characters of minimum string: POLYGON ((23.917439763666... and first 25 characters of maximum string: POLYGON ((24.114320100670...
geom_center_x double Longitude of the centroid of the geometry. Column geom_center_x has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23.55 and maximum value is 24.11.
geom_center_y double Latitude of the centroid of the geometry. Column geom_center_y has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 61.42 and maximum value is 61.83.
geom_type string Geometry type. Column geom_type has 3343 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created November 26, 2018