1. Home
  2. Datasets
  3. Winkki, työt yleisillä ...
To download the data set, please sign up or log in

Winkki, työt yleisillä alueilla

Winkki, työt yleisillä alueilla

Tables

Column Descriptions

Winkki workspolygon, Hkrwinkki works, Latest

Column Type Comment
event_iden string Data source did not contain a description for event_iden. Column event_iden has 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is DNA1258434 and maximum string is YKShel 2018-000273_2.
event_phas int Data source did not contain a description for event_phas. Column event_phas has 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 1.
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 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010-06-01 00:00:00 and maximum value is 2019-05-03 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 660 rows, out of which 0 are empty, making the null percent 0.00. 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 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 2 kpl vaihtolavoja... and first 25 characters of maximum string: äkillinen vikatyö, rajaus...
location_d string Data source did not contain a description for location_d. Column location_d has 660 rows, out of which 421 are empty, making the null percent 63.79. Minimum string is and maximum string is YHDYSKUNNANTIE.
licence_id int Data source did not contain a description for licence_id. Column licence_id has 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1246121 and maximum value is 2711901.
licence_i0 string Data source did not contain a description for licence_i0. Column licence_i0 has 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AL1100341 and maximum string is LJ1800018.
licence_ty string Data source did not contain a description for licence_ty. Column licence_ty has 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aitauslupa 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 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010-06-01 00:00:00 and maximum value is 2019-04-20 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 660 rows, out of which 2 are empty, making the null percent 0.30. Minimum value is 2019-05-10 00:00:00 and maximum 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 660 rows, out of which 0 are empty, making the null percent 0.00. 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 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AALTO Real Estate Oy and maximum string is YIT Talo Oy.
licence_op string Data source did not contain a description for licence_op. Column licence_op has 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alfakivi Oy and maximum string is YIT Talo Oy.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 660 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.838044... and first 25 characters of maximum string: POLYGON ((25.160140054495...
geom_center_x float Longitude of center. Column geom_center_x has 660 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.18.
geom_center_y float Latitude of center. Column geom_center_y has 660 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.29.
geom_type string Geometry type. Column geom_type has 660 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.

Winkki workspolygon, Hkrwinkki works, Full history

Column Type Comment
event_iden string Data source did not contain a description for event_iden. Column event_iden has 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is DNA1258434 and maximum string is YKShel 2018-000273_2.
event_phas int Data source did not contain a description for event_phas. Column event_phas has 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 1.
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 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010-06-01 00:00:00 and maximum value is 2019-05-03 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 660 rows, out of which 0 are empty, making the null percent 0.00. 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 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 2 kpl vaihtolavoja... and first 25 characters of maximum string: äkillinen vikatyö, rajaus...
location_d string Data source did not contain a description for location_d. Column location_d has 660 rows, out of which 421 are empty, making the null percent 63.79. Minimum string is and maximum string is YHDYSKUNNANTIE.
licence_id int Data source did not contain a description for licence_id. Column licence_id has 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1246121 and maximum value is 2711901.
licence_i0 string Data source did not contain a description for licence_i0. Column licence_i0 has 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AL1100341 and maximum string is LJ1800018.
licence_ty string Data source did not contain a description for licence_ty. Column licence_ty has 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aitauslupa 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 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010-06-01 00:00:00 and maximum value is 2019-04-20 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 660 rows, out of which 2 are empty, making the null percent 0.30. Minimum value is 2019-05-10 00:00:00 and maximum 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 660 rows, out of which 0 are empty, making the null percent 0.00. 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 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AALTO Real Estate Oy and maximum string is YIT Talo Oy.
licence_op string Data source did not contain a description for licence_op. Column licence_op has 660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alfakivi Oy and maximum string is YIT Talo Oy.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 660 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.838044... and first 25 characters of maximum string: POLYGON ((25.160140054495...
geom_center_x float Longitude of center. Column geom_center_x has 660 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.18.
geom_center_y float Latitude of center. Column geom_center_y has 660 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.29.
geom_type string Geometry type. Column geom_type has 660 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 September 7, 2020
Created September 7, 2020