To download the data set, please sign up or log in

Liikennevaylat

Liikennevaylat

Tables

Column Descriptions

Liikennevaylat, Helliikennevaylat, Full history

Column Type Comment
vaylatyypp string Data source did not contain a description for vaylatyypp. Column vaylatyypp has 95381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alikulku (jalkakäytävä, p... and first 25 characters of maximum string: Yhdistetty jalkakäytävä j...
dgntasonro int Data source did not contain a description for dgntasonro. Column dgntasonro has 95381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 63.
dgntasonim string Data source did not contain a description for dgntasonim. Column dgntasonim has 95381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Taso 10 - Ylikulut ja sil... and first 25 characters of maximum string: Taso 9 - Alikulut (jku pp...
ajo_pvm timestamp Data source did not contain a description for ajo_pvm. Column ajo_pvm has 95381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2015-01-13 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 95381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (24.8322570204... and first 25 characters of maximum string: LINESTRING (25.2519739264...
geom_center_x float Longitude of center. Column is empty.
geom_center_y float Latitude of center. Column is empty.
geom_type string Geometry type. Column geom_type has 95381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING.
orig_extractdate string The date when the data was originally fetched from the source.

Liikennevaylat, Helliikennevaylat, Latest

Column Type Comment
vaylatyypp string Data source did not contain a description for vaylatyypp. Column vaylatyypp has 95381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alikulku (jalkakäytävä, p... and first 25 characters of maximum string: Yhdistetty jalkakäytävä j...
dgntasonro int Data source did not contain a description for dgntasonro. Column dgntasonro has 95381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 63.
dgntasonim string Data source did not contain a description for dgntasonim. Column dgntasonim has 95381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Taso 10 - Ylikulut ja sil... and first 25 characters of maximum string: Taso 9 - Alikulut (jku pp...
ajo_pvm timestamp Data source did not contain a description for ajo_pvm. Column ajo_pvm has 95381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2015-01-13 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 95381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (24.8322570204... and first 25 characters of maximum string: LINESTRING (25.2519739264...
geom_center_x float Longitude of center. Column is empty.
geom_center_y float Latitude of center. Column is empty.
geom_type string Geometry type. Column geom_type has 95381 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING.

Additional Info

Last Updated September 9, 2020
Created September 7, 2020