Yleisten alueiden rekisteri, viheralueet

Tables

Ylre viheraluepolygon, Hkrylre viheralue, LatestTSV
No description available for layer hkr:ylre_viheralue (Yleisten alueiden rekisteri, viheralueet)

Column Descriptions

Ylre viheraluepolygon, Hkrylre viheralue, Latest

Column	Type	Comment
viheralue	int	Data source did not contain a description for viheralue. Column viheralue has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 401 and maximum value is 241581.
puistonume	int	Data source did not contain a description for puistonume. Column puistonume has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21 and maximum value is 10581.
puiston_ni	string	Data source did not contain a description for puiston_ni. Column puiston_ni has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A501 and maximum string is ÖRSKINPUISTO.
puistonimi	int	Data source did not contain a description for puistonimi. Column puistonimi has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 149301.
osoite	string	Data source did not contain a description for osoite. Column osoite has 4146 rows, out of which 1 are empty, making the null percent 0.02. Minimum string is and maximum string is Örskinkuja.
kaupungino	string	Data source did not contain a description for kaupungino. Column kaupungino has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alppiharju and maximum string is Östersundom.
osa_alue	string	Data source did not contain a description for osa_alue. Column osa_alue has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ala-Malmi and maximum string is Östersundom.
suurpiiri	string	Data source did not contain a description for suurpiiri. Column suurpiiri has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Eteläinen and maximum string is Östersundom.
kaavamerki	string	Data source did not contain a description for kaavamerki. Column kaavamerki has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is YY.
kaavamerk0	string	Data source did not contain a description for kaavamerk0. Column kaavamerk0 has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alue, joka on varattu kun... and first 25 characters of maximum string: Yleisurheilukenttä...
kayttotark	string	Data source did not contain a description for kayttotark. Column kayttotark has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Asemakaavoitettu viheralu... and first 25 characters of maximum string: Yleiskaavan viheralue / v...
kayttotar0	int	Data source did not contain a description for kayttotar0. Column kayttotar0 has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 6001.
omistaja	string	Data source did not contain a description for omistaja. Column omistaja has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ei tietoa... and first 25 characters of maximum string: Yksityinen tai julkisyhte...
vuokraus	string	Data source did not contain a description for vuokraus. Column vuokraus has 4146 rows, out of which 2503 are empty, making the null percent 60.37. Minimum string is and maximum string is Sopimus.
vuokraaja	string	Data source did not contain a description for vuokraaja. Column vuokraaja has 4146 rows, out of which 2504 are empty, making the null percent 60.40. Minimum string is and maximum string is Sosiaalivirasto.
pinta_ala	int	Data source did not contain a description for pinta_ala. Column pinta_ala has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 7 and maximum value is 2122187.
paivitetty	date	Data source did not contain a description for paivitetty. Column is empty.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POLYGON ((24.828207248761... and first 25 characters of maximum string: POLYGON ((25.244243503111...
geom_center_x	float	Longitude of center. Column geom_center_x has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.83 and maximum value is 25.25.
geom_center_y	float	Latitude of center. Column geom_center_y has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.11 and maximum value is 60.30.
geom_type	string	Geometry type. Column geom_type has 4146 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POLYGON.

Additional Info

Last Updated	September 7, 2020
Created	August 6, 2018