1. Home
  2. Datasets
  3. Lyhyt maanvuokraus alue
To download the data set, please sign up or log in

Lyhyt maanvuokraus alue

No description available for layer avoindata:Lyhyt_maanvuokraus_alue (Lyhyt_maanvuokraus_alue)

Tables

Column Descriptions

Lyhyt maanvuokraus aluepolygon, Avoindatalyhyt maanvuokraus alue, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 911.
hakemus string Data source did not contain a description for hakemus. Column hakemus has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Lyhyt maanvuokraus.
hakemuksen string Data source did not contain a description for hakemuksen. Column hakemuksen has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Benji-hyppylaite and maximum string is Talviterassi.
hakemustun string Data source did not contain a description for hakemustun. Column hakemustun has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is VP1800174 and maximum string is VP2200636.
nimi string Data source did not contain a description for nimi. Column nimi has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Arkeologinen koekaivaus... and first 25 characters of maximum string: Vattuniemen Ankkalampi - ...
vuokraus_a date Data source did not contain a description for vuokraus_a. Column is empty.
vuokraus_p date Data source did not contain a description for vuokraus_p. Column is empty.
osoite string Data source did not contain a description for osoite. Column osoite has 840 rows, out of which 43 are empty, making the null percent 5.12. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yrjönkatu 30, 00100 Helsi...
kaupungino string Data source did not contain a description for kaupungino. Column kaupungino has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 10 SÖRNÄINEN and maximum string is 9 KAIVOPUISTO.
status string Data source did not contain a description for status. Column status has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Käynnissä and maximum string is Tuleva.
hakija string Data source did not contain a description for hakija. Column hakija has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 88 Eats Oy and maximum string is Zuhat Oy.
geometryty string Data source did not contain a description for geometryty. Column geometryty has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_Polygon.
vuokraus_0 timestamp Data source did not contain a description for vuokraus_0. Column vuokraus_0 has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2018-08-01 00:00:00 and maximum value is 2024-01-01 00:00:00.
vuokraus_1 timestamp Data source did not contain a description for vuokraus_1. Column vuokraus_1 has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2022-07-17 00:00:00 and maximum value is 2031-11-30 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POLYGON ((24.844036 60.25... and first 25 characters of maximum string: POLYGON ((25.158591999999...
geom_center_x float Longitude of center. Column geom_center_x has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.84 and maximum value is 25.16.
geom_center_y float Latitude of center. Column geom_center_y has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.15 and maximum value is 60.28.
geom_type string Geometry type. Column geom_type has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POLYGON.

Lyhyt maanvuokraus aluepolygon, Avoindatalyhyt maanvuokraus alue, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 911.
hakemus string Data source did not contain a description for hakemus. Column hakemus has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Lyhyt maanvuokraus.
hakemuksen string Data source did not contain a description for hakemuksen. Column hakemuksen has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Benji-hyppylaite and maximum string is Talviterassi.
hakemustun string Data source did not contain a description for hakemustun. Column hakemustun has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is VP1800174 and maximum string is VP2200636.
nimi string Data source did not contain a description for nimi. Column nimi has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Arkeologinen koekaivaus... and first 25 characters of maximum string: Vattuniemen Ankkalampi - ...
vuokraus_a date Data source did not contain a description for vuokraus_a. Column is empty.
vuokraus_p date Data source did not contain a description for vuokraus_p. Column is empty.
osoite string Data source did not contain a description for osoite. Column osoite has 840 rows, out of which 43 are empty, making the null percent 5.12. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yrjönkatu 30, 00100 Helsi...
kaupungino string Data source did not contain a description for kaupungino. Column kaupungino has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 10 SÖRNÄINEN and maximum string is 9 KAIVOPUISTO.
status string Data source did not contain a description for status. Column status has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Käynnissä and maximum string is Tuleva.
hakija string Data source did not contain a description for hakija. Column hakija has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 88 Eats Oy and maximum string is Zuhat Oy.
geometryty string Data source did not contain a description for geometryty. Column geometryty has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_Polygon.
vuokraus_0 timestamp Data source did not contain a description for vuokraus_0. Column vuokraus_0 has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2018-08-01 00:00:00 and maximum value is 2024-01-01 00:00:00.
vuokraus_1 timestamp Data source did not contain a description for vuokraus_1. Column vuokraus_1 has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2022-07-17 00:00:00 and maximum value is 2031-11-30 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POLYGON ((24.844036 60.25... and first 25 characters of maximum string: POLYGON ((25.158591999999...
geom_center_x float Longitude of center. Column geom_center_x has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.84 and maximum value is 25.16.
geom_center_y float Latitude of center. Column geom_center_y has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.15 and maximum value is 60.28.
geom_type string Geometry type. Column geom_type has 840 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 6, 2022
Created July 4, 2022