Yleiskaavan käyttötarkoitusalueet

Tables

Tampere Ora Yk Kt Alue Viewpolygon, Fkit Tamperetampere Ora Yk Kt Alue ViewTSV
No description available for layer fkit_tampere:tampere_ora_YK_KT_ALUE_VIEW (Yleiskaavan käyttötarkoitusalueet)

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