1. Home
  2. Datasets
  3. Winkki tyot yleisilla alueilla
To download the data set, please sign up or log in

Winkki tyot yleisilla alueilla

No description available for layer avoindata:Winkki_works (Winkki_tyot_yleisilla_alueilla)

Tables

Column Descriptions

Winkki workspolygon, Avoindatawinkki works, Latest

Column Type Comment
tietopalve int Data source did not contain a description for tietopalve. Column tietopalve has 3 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 3.
event_iden string Data source did not contain a description for event_iden. Column event_iden has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is HKRV17-01064 and maximum string is KAPA023026.
event_phas int Data source did not contain a description for event_phas. Column event_phas has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Constant value is 0.
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 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2010-06-01 00:00:00 and maximum value is 2017-07-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. Column event_endt has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2010-06-27 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 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Henkilönostin jk:llä,TSA and maximum string is nostotyö.
location_d string Data source did not contain a description for location_d. Column location_d has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum string is and maximum string is Heino Kaskenkatu.
licence_id int Data source did not contain a description for licence_id. Column licence_id has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1246121 and maximum value is 2606831.
licence_i0 string Data source did not contain a description for licence_i0. Column licence_i0 has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is KP1008235 and maximum string is LJ1800013.
licence_ty string Data source did not contain a description for licence_ty. Column licence_ty has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Liikennejärjestely and maximum string is Liikennejärjestely-KTL.
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 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2010-06-01 00:00:00 and maximum value is 2018-03-28 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. Column lic_enddat has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 2028-04-06 00:00:00.
licence_s0 string Data source did not contain a description for licence_s0. Column licence_s0 has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ACTIVE.
licence_ap string Data source did not contain a description for licence_ap. Column licence_ap has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: As Oy Ståhlbergintie 6... and first 25 characters of maximum string: Stara / Korjausrakentamin...
licence_op string Data source did not contain a description for licence_op. Column licence_op has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is MAALAUSHOVI OY and maximum string is Turun pelti ja eristys Oy.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 3 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 3 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.923048... and first 25 characters of maximum string: POLYGON ((25.005818653004...
geom_center_x float Longitude of center. Column geom_center_x has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.91 and maximum value is 25.01.
geom_center_y float Latitude of center. Column geom_center_y has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.16 and maximum value is 60.19.
geom_type string Geometry type. Column geom_type has 3 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 workspolygon, Avoindatawinkki works, Full history

Column Type Comment
tietopalve int Data source did not contain a description for tietopalve. Column tietopalve has 3 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 3.
event_iden string Data source did not contain a description for event_iden. Column event_iden has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is HKRV17-01064 and maximum string is KAPA023026.
event_phas int Data source did not contain a description for event_phas. Column event_phas has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Constant value is 0.
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 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2010-06-01 00:00:00 and maximum value is 2017-07-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. Column event_endt has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2010-06-27 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 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Henkilönostin jk:llä,TSA and maximum string is nostotyö.
location_d string Data source did not contain a description for location_d. Column location_d has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum string is and maximum string is Heino Kaskenkatu.
licence_id int Data source did not contain a description for licence_id. Column licence_id has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1246121 and maximum value is 2606831.
licence_i0 string Data source did not contain a description for licence_i0. Column licence_i0 has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is KP1008235 and maximum string is LJ1800013.
licence_ty string Data source did not contain a description for licence_ty. Column licence_ty has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Liikennejärjestely and maximum string is Liikennejärjestely-KTL.
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 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2010-06-01 00:00:00 and maximum value is 2018-03-28 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. Column lic_enddat has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 2028-04-06 00:00:00.
licence_s0 string Data source did not contain a description for licence_s0. Column licence_s0 has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ACTIVE.
licence_ap string Data source did not contain a description for licence_ap. Column licence_ap has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: As Oy Ståhlbergintie 6... and first 25 characters of maximum string: Stara / Korjausrakentamin...
licence_op string Data source did not contain a description for licence_op. Column licence_op has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is MAALAUSHOVI OY and maximum string is Turun pelti ja eristys Oy.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 3 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 3 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.923048... and first 25 characters of maximum string: POLYGON ((25.005818653004...
geom_center_x float Longitude of center. Column geom_center_x has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.91 and maximum value is 25.01.
geom_center_y float Latitude of center. Column geom_center_y has 3 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.16 and maximum value is 60.19.
geom_type string Geometry type. Column geom_type has 3 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