1. Home
  2. Datasets
  3. Winkki, vuokraukset ja ...
To download the data set, please sign up or log in

Winkki, vuokraukset ja tapahtumat yleisillä alueilla

Winkki, vuokraukset ja tapahtumat yleisillä alueilla

Tables

Column Descriptions

Winkki rents audiencespolygon, Hkrwinkki rents audiences, Full history

Column Type Comment
event_iden string Data source did not contain a description for event_iden. Column event_iden has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is CCDD21123 and maximum string is V13-10.
event_star date Data source did not contain a description for event_star. Column is empty.
event_sta0 timestamp Data source did not contain a description for event_sta0. Column event_sta0 has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1994-07-25 00:00:00 and maximum value is 2019-11-01 00:00:00.
event_endd date Data source did not contain a description for event_endd. Column is empty.
event_endt timestamp Data source did not contain a description for event_endt.
event_desc string Data source did not contain a description for event_desc. Column event_desc has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 10 Sörnäinen, 7 asemaa. V... and first 25 characters of maximum string: Ympärivuotinen terassilup...
location_d string Data source did not contain a description for location_d. Column location_d has 1136 rows, out of which 553 are empty, making the null percent 48.68. Minimum string is and maximum string is Ympäröivät puistot.
licence_id int Data source did not contain a description for licence_id. Column licence_id has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 667461 and maximum value is 2717141.
licence_i0 string Data source did not contain a description for licence_i0. Column licence_i0 has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is UL1000434 and maximum string is VL1900103.
licence_ty string Data source did not contain a description for licence_ty. Column licence_ty has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ulkoilmatilaisuus and maximum string is Vuokrasopimus.
rental_sub string Data source did not contain a description for rental_sub. Column rental_sub has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aluekeräyspisteet and maximum string is Viljelypalstat.
licence_st date Data source did not contain a description for licence_st. Column is empty.
lic_startd timestamp Data source did not contain a description for lic_startd. Column lic_startd has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1994-07-25 00:00:00 and maximum value is 2028-04-01 00:00:00.
licence_en date Data source did not contain a description for licence_en. Column is empty.
lic_enddat timestamp Data source did not contain a description for lic_enddat.
licence_s0 string Data source did not contain a description for licence_s0. Column licence_s0 has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ACTIVE and maximum string is PLAN.
licence_de string Data source did not contain a description for licence_de. Column licence_de has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kesäterassi 1.4.-31.10. v... and first 25 characters of maximum string: Ympärivuotinen terassilup...
licence_ap string Data source did not contain a description for licence_ap. Column licence_ap has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A&S Ravintolat Oy and maximum string is Zugu Oy.
restaurant string Data source did not contain a description for restaurant. Column restaurant has 1136 rows, out of which 781 are empty, making the null percent 68.75. Minimum string is and maximum string is Zen sushi.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((24.866490... and first 25 characters of maximum string: POLYGON ((25.222708575675...
geom_center_x float Longitude of center. Column geom_center_x has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.84 and maximum value is 25.22.
geom_center_y float Latitude of center. Column geom_center_y has 1136 rows, out of which 0 are empty, making the null percent 0.00. 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 1136 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.

Winkki rents audiencespolygon, Hkrwinkki rents audiences, Latest

Column Type Comment
event_iden string Data source did not contain a description for event_iden. Column event_iden has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is CCDD21123 and maximum string is V13-10.
event_star date Data source did not contain a description for event_star. Column is empty.
event_sta0 timestamp Data source did not contain a description for event_sta0. Column event_sta0 has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1994-07-25 00:00:00 and maximum value is 2019-11-01 00:00:00.
event_endd date Data source did not contain a description for event_endd. Column is empty.
event_endt timestamp Data source did not contain a description for event_endt.
event_desc string Data source did not contain a description for event_desc. Column event_desc has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 10 Sörnäinen, 7 asemaa. V... and first 25 characters of maximum string: Ympärivuotinen terassilup...
location_d string Data source did not contain a description for location_d. Column location_d has 1136 rows, out of which 553 are empty, making the null percent 48.68. Minimum string is and maximum string is Ympäröivät puistot.
licence_id int Data source did not contain a description for licence_id. Column licence_id has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 667461 and maximum value is 2717141.
licence_i0 string Data source did not contain a description for licence_i0. Column licence_i0 has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is UL1000434 and maximum string is VL1900103.
licence_ty string Data source did not contain a description for licence_ty. Column licence_ty has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ulkoilmatilaisuus and maximum string is Vuokrasopimus.
rental_sub string Data source did not contain a description for rental_sub. Column rental_sub has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aluekeräyspisteet and maximum string is Viljelypalstat.
licence_st date Data source did not contain a description for licence_st. Column is empty.
lic_startd timestamp Data source did not contain a description for lic_startd. Column lic_startd has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1994-07-25 00:00:00 and maximum value is 2028-04-01 00:00:00.
licence_en date Data source did not contain a description for licence_en. Column is empty.
lic_enddat timestamp Data source did not contain a description for lic_enddat.
licence_s0 string Data source did not contain a description for licence_s0. Column licence_s0 has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ACTIVE and maximum string is PLAN.
licence_de string Data source did not contain a description for licence_de. Column licence_de has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kesäterassi 1.4.-31.10. v... and first 25 characters of maximum string: Ympärivuotinen terassilup...
licence_ap string Data source did not contain a description for licence_ap. Column licence_ap has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A&S Ravintolat Oy and maximum string is Zugu Oy.
restaurant string Data source did not contain a description for restaurant. Column restaurant has 1136 rows, out of which 781 are empty, making the null percent 68.75. Minimum string is and maximum string is Zen sushi.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((24.866490... and first 25 characters of maximum string: POLYGON ((25.222708575675...
geom_center_x float Longitude of center. Column geom_center_x has 1136 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.84 and maximum value is 25.22.
geom_center_y float Latitude of center. Column geom_center_y has 1136 rows, out of which 0 are empty, making the null percent 0.00. 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 1136 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.

Additional Info

Last Updated September 7, 2020
Created September 7, 2020