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

Winkki vuokraukset ja tapahtumat yleisilla alueilla

No description available for layer avoindata:Winkki_rents_audiences (Winkki_vuokraukset_ja_tapahtumat_yleisilla_alueilla)

Tables

Column Descriptions

Winkki rents audiencespolygon, Avoindatawinkki rents audiences, Latest

Column Type Comment
tietopalve int Data source did not contain a description for tietopalve. Column tietopalve has 617 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 617.
event_iden string Data source did not contain a description for event_iden. Column event_iden has 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is CCDD21123 and maximum string is V08-180.
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 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1994-07-25 00:00:00 and maximum value is 2022-06-06 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 617 rows, out of which 0 are empty, making the null percent 0. 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: Yksityisen päiväkodin lei...
location_d string Data source did not contain a description for location_d. Column location_d has 617 rows, out of which 185 are empty, making the null percent 29.98. 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 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 667461 and maximum value is 2763821.
licence_i0 string Data source did not contain a description for licence_i0. Column licence_i0 has 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is UL1000434 and maximum string is VL2200082.
licence_ty string Data source did not contain a description for licence_ty. Column licence_ty has 617 rows, out of which 0 are empty, making the null percent 0. 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 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Aluekeräyspisteet... and first 25 characters of maximum string: Ulkomainoslaitepaikka (al...
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 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1994-07-25 00:00:00 and maximum value is 2030-01-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 617 rows, out of which 0 are empty, making the null percent 0. 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 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Lasitettu katuterassi 30 ... and first 25 characters of maximum string: Terassi lasitettu...
licence_ap string Data source did not contain a description for licence_ap. Column licence_ap has 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 9Lives ensihoito Oy and maximum string is Zen and Trading Oy.
restaurant string Data source did not contain a description for restaurant. Column restaurant has 617 rows, out of which 615 are empty, making the null percent 99.68. Minimum string is and maximum string is Vltava.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/WINKKI.
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 617 rows, out of which 0 are empty, making the null percent 0. 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 617 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.22.
geom_center_y float Latitude of center. Column geom_center_y has 617 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 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.

Winkki rents audiencespolygon, Avoindatawinkki rents audiences, Full history

Column Type Comment
tietopalve int Data source did not contain a description for tietopalve. Column tietopalve has 617 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 617.
event_iden string Data source did not contain a description for event_iden. Column event_iden has 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is CCDD21123 and maximum string is V08-180.
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 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1994-07-25 00:00:00 and maximum value is 2022-06-06 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 617 rows, out of which 0 are empty, making the null percent 0. 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: Yksityisen päiväkodin lei...
location_d string Data source did not contain a description for location_d. Column location_d has 617 rows, out of which 185 are empty, making the null percent 29.98. 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 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 667461 and maximum value is 2763821.
licence_i0 string Data source did not contain a description for licence_i0. Column licence_i0 has 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is UL1000434 and maximum string is VL2200082.
licence_ty string Data source did not contain a description for licence_ty. Column licence_ty has 617 rows, out of which 0 are empty, making the null percent 0. 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 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Aluekeräyspisteet... and first 25 characters of maximum string: Ulkomainoslaitepaikka (al...
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 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1994-07-25 00:00:00 and maximum value is 2030-01-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 617 rows, out of which 0 are empty, making the null percent 0. 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 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Lasitettu katuterassi 30 ... and first 25 characters of maximum string: Terassi lasitettu...
licence_ap string Data source did not contain a description for licence_ap. Column licence_ap has 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 9Lives ensihoito Oy and maximum string is Zen and Trading Oy.
restaurant string Data source did not contain a description for restaurant. Column restaurant has 617 rows, out of which 615 are empty, making the null percent 99.68. Minimum string is and maximum string is Vltava.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 617 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/WINKKI.
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 617 rows, out of which 0 are empty, making the null percent 0. 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 617 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.22.
geom_center_y float Latitude of center. Column geom_center_y has 617 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 617 rows, out of which 0 are empty, making the null percent 0. 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 July 7, 2022
Created July 5, 2022