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

Lyhyt maanvuokraus piste

No description available for layer avoindata:Lyhyt_maanvuokraus_piste (Lyhyt_maanvuokraus_piste)

Tables

Column Descriptions

Lyhyt maanvuokraus pistempoint, Avoindatalyhyt maanvuokraus piste, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 66 and maximum value is 896.
hakemus string Data source did not contain a description for hakemus. Column hakemus has 71 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 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Banderollit silloissa.
hakemustun string Data source did not contain a description for hakemustun. Column hakemustun has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is VP2100691 and maximum string is VP2200622.
nimi string Data source did not contain a description for nimi. Column nimi has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: "Helsinki Festival 12.8. ... and first 25 characters of maximum string: www.intokustannus.fi...
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 71 rows, out of which 65 are empty, making the null percent 91.55. The single string value is: 2A Sörnäisten rantatie-Vi...
kaupungino string Data source did not contain a description for kaupungino. Column kaupungino has 71 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 4 KAMPPI.
status string Data source did not contain a description for status. Column status has 71 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 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Drumsö Idrottskamrater Di... and first 25 characters of maximum string: Venealan Keskusliitto Fin...
geometryty string Data source did not contain a description for geometryty. Column geometryty has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_Point.
vuokraus_0 timestamp Data source did not contain a description for vuokraus_0. Column vuokraus_0 has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2022-06-27 00:00:00 and maximum value is 2022-11-21 00:00:00.
vuokraus_1 timestamp Data source did not contain a description for vuokraus_1. Column vuokraus_1 has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2022-07-10 00:00:00 and maximum value is 2022-12-04 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: MULTIPOINT ((24.882466000... and first 25 characters of maximum string: MULTIPOINT ((25.047495 60...
geom_center_x float Longitude of center. Column is empty.
geom_center_y float Latitude of center. Column is empty.
geom_type string Geometry type. Column geom_type has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_MULTIPOINT.

Lyhyt maanvuokraus pistempoint, Avoindatalyhyt maanvuokraus piste, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 66 and maximum value is 896.
hakemus string Data source did not contain a description for hakemus. Column hakemus has 71 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 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Banderollit silloissa.
hakemustun string Data source did not contain a description for hakemustun. Column hakemustun has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is VP2100691 and maximum string is VP2200622.
nimi string Data source did not contain a description for nimi. Column nimi has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: "Helsinki Festival 12.8. ... and first 25 characters of maximum string: www.intokustannus.fi...
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 71 rows, out of which 65 are empty, making the null percent 91.55. The single string value is: 2A Sörnäisten rantatie-Vi...
kaupungino string Data source did not contain a description for kaupungino. Column kaupungino has 71 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 4 KAMPPI.
status string Data source did not contain a description for status. Column status has 71 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 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Drumsö Idrottskamrater Di... and first 25 characters of maximum string: Venealan Keskusliitto Fin...
geometryty string Data source did not contain a description for geometryty. Column geometryty has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_Point.
vuokraus_0 timestamp Data source did not contain a description for vuokraus_0. Column vuokraus_0 has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2022-06-27 00:00:00 and maximum value is 2022-11-21 00:00:00.
vuokraus_1 timestamp Data source did not contain a description for vuokraus_1. Column vuokraus_1 has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2022-07-10 00:00:00 and maximum value is 2022-12-04 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: MULTIPOINT ((24.882466000... and first 25 characters of maximum string: MULTIPOINT ((25.047495 60...
geom_center_x float Longitude of center. Column is empty.
geom_center_y float Latitude of center. Column is empty.
geom_type string Geometry type. Column geom_type has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_MULTIPOINT.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 6, 2022
Created July 6, 2022