To download the data set, please sign up or log in
Winkki, vuokraukset ja tapahtumat yleisillä alueilla
Tables
-
Winkki Rents Audiencespolygon, Hkrwinkki Rents AudiencesTSV
Luontotietojärjestelmässä voi tutustua Helsingin monipuoliseen luontoon. Järjestelmän keskeisimpiä luontoaineistoja ovat luonnonsuojelukohteet, arvokkaat kasvisto- ja kasvillisuuskohteet, linnustollisesti arvokkaat kohteet, arvokkaat geologiset kohteet, tärkeät lepakkoalueet, kääpäkohteet ja arvokkaat metsäluonnon monimuotoisuuskohteet. Palvelusta on yleisöversio ja virkaversio. Yleisöversion tietosisältöä on suodatettu luonnonsuojelusyistä. Virkaversiota käytetään kaupungin sisäisissä suunnittelu- ja tutkimustarkoituksissa. Helsingin Luontotietojärjestelmän avoimena datana julkaistava aineisto koostuu seuraavista WFS-rajapinnan tasoista, jotka on ryhmitelty rauhoitettuihin / rauhoitettaviin kohteisiin, arvokkaisiin luontokohteisiin, vesistöaineistoihin ja muuhun luontotietooon....
Column Descriptions
Winkki Rents Audiencespolygon, Hkrwinkki Rents Audiences
| Column | Type | Comment |
|---|---|---|
| event_iden | string | Data source did not contain a description for event_iden. Column event_iden has 1115 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HKRHKTVTAP13-72 and maximum string is HKRU12-541. |
| event_star | string | 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 1115 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2007-01-01 00:00:00 and maximum value is 2019-11-01 00:00:00. |
| event_endd | string | 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. Column event_endt has 1115 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2016-12-31 00:00:00 and maximum value is 2037-12-31 00:00:00. |
| event_desc | string | Data source did not contain a description for event_desc. Column event_desc has 1115 rows, out of which 1 are empty, making the null percent 0.09. Minimum string is and maximum string is Helsingin Taidemuseo/teos. |
| location_d | string | Data source did not contain a description for location_d. Column location_d has 1115 rows, out of which 687 are empty, making the null percent 61.61. Minimum string is and maximum string is Siltasaarenkatu 13 vp. |
| licence_id | int | Data source did not contain a description for licence_id. Column licence_id has 1115 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 2696721. |
| licence_i0 | string | Data source did not contain a description for licence_i0. Column licence_i0 has 1115 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 UL1200671. |
| licence_ty | string | Data source did not contain a description for licence_ty. Column licence_ty has 1115 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 1115 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aluekeräyspisteet... and first 25 characters of maximum string: Lupatyyppi: ulkoilmatilai... |
| licence_st | string | 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 1115 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2007-01-01 00:00:00 and maximum value is 2019-11-01 00:00:00. |
| licence_en | string | 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. Column lic_enddat has 1115 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2018-12-24 00:00:00 and maximum value is 2037-12-31 00:00:00. |
| licence_s0 | string | Data source did not contain a description for licence_s0. Column licence_s0 has 1115 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 1115 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 kävelykeskusta-alueel... and first 25 characters of maximum string: N/A... |
| licence_ap | string | Data source did not contain a description for licence_ap. Column licence_ap has 1115 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 N/A. |
| restaurant | string | Data source did not contain a description for restaurant. Column restaurant has 1115 rows, out of which 744 are empty, making the null percent 66.73. Minimum string is and maximum string is Common Table oy. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 1115 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.912693... and first 25 characters of maximum string: POLYGON ((24.949676140455... |
| geom_center_x | double | Longitude of the centroid of the geometry. Column geom_center_x has 1115 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.21. |
| geom_center_y | double | Latitude of the centroid of the geometry. Column geom_center_y has 1115 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 1115 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. |
Additional Info
| Last Updated | April 12, 2019 |
|---|---|
| Created | October 21, 2018 |