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

Tapahtumat alue

No description available for layer avoindata:Tapahtumat_alue (Tapahtumat_alue)

Tables

Column Descriptions

Tapahtumat aluepolygon, Avoindatatapahtumat alue, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 251 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 251.
hakemus string Data source did not contain a description for hakemus. Column hakemus has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Tapahtuma.
hakemuksen string Data source did not contain a description for hakemuksen. Column hakemuksen has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Promootio and maximum string is Ulkoilmatapahtuma.
hakemustun string Data source did not contain a description for hakemustun. Column hakemustun has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is TP1901036 and maximum string is TP2200619.
nimi string Data source did not contain a description for nimi. Column nimi has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: 280 vuotta Hattujen sodan... and first 25 characters of maximum string: Yleisötapahtumat...
rakentamin date Data source did not contain a description for rakentamin. Column is empty.
tapahtuma date Data source did not contain a description for tapahtuma. Column is empty.
tapahtuma0 date Data source did not contain a description for tapahtuma0. Column is empty.
purkaminen date Data source did not contain a description for purkaminen. Column is empty.
tapahtuman string Data source did not contain a description for tapahtuman. Column tapahtuman has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is - and maximum string is Suljettu.
tapahtuma1 string Data source did not contain a description for tapahtuma1. Column tapahtuma1 has 251 rows, out of which 236 are empty, making the null percent 94.02. Minimum string is and maximum string is www.wing.com/piknik.
osoite string Data source did not contain a description for osoite. Column osoite has 251 rows, out of which 50 are empty, making the null percent 19.92. Minimum string is and maximum string is Vasikkasaari.
kaupungino string Data source did not contain a description for kaupungino. Column kaupungino has 251 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 251 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 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Aseman Lapset ry and maximum string is Yksityishenkilö.
geometryty string Data source did not contain a description for geometryty. Column geometryty has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_Polygon.
rakentami0 timestamp Data source did not contain a description for rakentami0. Column rakentami0 has 251 rows, out of which 196 are empty, making the null percent 78.09. Minimum value is 2022-07-04 00:00:00 and maximum value is 2025-04-26 00:00:00.
tapahtuma2 timestamp Data source did not contain a description for tapahtuma2. Column tapahtuma2 has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2021-10-16 00:00:00 and maximum value is 2025-04-27 00:00:00.
tapahtuma3 timestamp Data source did not contain a description for tapahtuma3. Column tapahtuma3 has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2022-07-08 00:00:00 and maximum value is 2025-04-27 00:00:00.
purkamine0 timestamp Data source did not contain a description for purkamine0. Column purkamine0 has 251 rows, out of which 213 are empty, making the null percent 84.86. Minimum value is 2022-07-18 00:00:00 and maximum value is 2025-04-28 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 251 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.856429000000... and first 25 characters of maximum string: POLYGON ((25.163077999999...
geom_center_x float Longitude of center. Column geom_center_x has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.86 and maximum value is 25.17.
geom_center_y float Latitude of center. Column geom_center_y has 251 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 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POLYGON.

Tapahtumat aluepolygon, Avoindatatapahtumat alue, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 251 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 251.
hakemus string Data source did not contain a description for hakemus. Column hakemus has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Tapahtuma.
hakemuksen string Data source did not contain a description for hakemuksen. Column hakemuksen has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Promootio and maximum string is Ulkoilmatapahtuma.
hakemustun string Data source did not contain a description for hakemustun. Column hakemustun has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is TP1901036 and maximum string is TP2200619.
nimi string Data source did not contain a description for nimi. Column nimi has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: 280 vuotta Hattujen sodan... and first 25 characters of maximum string: Yleisötapahtumat...
rakentamin date Data source did not contain a description for rakentamin. Column is empty.
tapahtuma date Data source did not contain a description for tapahtuma. Column is empty.
tapahtuma0 date Data source did not contain a description for tapahtuma0. Column is empty.
purkaminen date Data source did not contain a description for purkaminen. Column is empty.
tapahtuman string Data source did not contain a description for tapahtuman. Column tapahtuman has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is - and maximum string is Suljettu.
tapahtuma1 string Data source did not contain a description for tapahtuma1. Column tapahtuma1 has 251 rows, out of which 236 are empty, making the null percent 94.02. Minimum string is and maximum string is www.wing.com/piknik.
osoite string Data source did not contain a description for osoite. Column osoite has 251 rows, out of which 50 are empty, making the null percent 19.92. Minimum string is and maximum string is Vasikkasaari.
kaupungino string Data source did not contain a description for kaupungino. Column kaupungino has 251 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 251 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 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Aseman Lapset ry and maximum string is Yksityishenkilö.
geometryty string Data source did not contain a description for geometryty. Column geometryty has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_Polygon.
rakentami0 timestamp Data source did not contain a description for rakentami0. Column rakentami0 has 251 rows, out of which 196 are empty, making the null percent 78.09. Minimum value is 2022-07-04 00:00:00 and maximum value is 2025-04-26 00:00:00.
tapahtuma2 timestamp Data source did not contain a description for tapahtuma2. Column tapahtuma2 has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2021-10-16 00:00:00 and maximum value is 2025-04-27 00:00:00.
tapahtuma3 timestamp Data source did not contain a description for tapahtuma3. Column tapahtuma3 has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2022-07-08 00:00:00 and maximum value is 2025-04-27 00:00:00.
purkamine0 timestamp Data source did not contain a description for purkamine0. Column purkamine0 has 251 rows, out of which 213 are empty, making the null percent 84.86. Minimum value is 2022-07-18 00:00:00 and maximum value is 2025-04-28 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 251 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.856429000000... and first 25 characters of maximum string: POLYGON ((25.163077999999...
geom_center_x float Longitude of center. Column geom_center_x has 251 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.86 and maximum value is 25.17.
geom_center_y float Latitude of center. Column geom_center_y has 251 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 251 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 7, 2022
Created July 5, 2022