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

Tieliikenneonnettomuudet 2017

Tieliikenneonnettomuudet 2017

Tables

Column Descriptions

Tieliikenne 2017, Tieliikennetieliikenne 2017, Full history

Column Type Comment
vvonn int Data source did not contain a description for vvonn. Column vvonn has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2017.
kkonn int Data source did not contain a description for kkonn. Column kkonn has 4428 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 12.
kello string Data source did not contain a description for kello. Column kello has 4428 rows, out of which 2 are empty, making the null percent 0.05. Minimum string is and maximum string is 06.00-06.59.
vakav int Data source did not contain a description for vakav. Column vakav has 4428 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 3.
onntyyppi int Data source did not contain a description for onntyyppi. Column onntyyppi has 4428 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 9.
lkmhapa int Data source did not contain a description for lkmhapa. Column lkmhapa has 4428 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 17.
lkmlaka int Data source did not contain a description for lkmlaka. Column lkmlaka has 4428 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 3.
lkmjk int Data source did not contain a description for lkmjk. Column lkmjk has 4428 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 6.
lkmpp int Data source did not contain a description for lkmpp. Column lkmpp has 4428 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 3.
lkmmo int Data source did not contain a description for lkmmo. Column lkmmo has 4428 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 3.
lkmmp int Data source did not contain a description for lkmmp. Column lkmmp has 4428 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 4.
lkmmuukulk int Data source did not contain a description for lkmmuukulk. Column lkmmuukulk has 4428 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 3.
x float Data source did not contain a description for x. Column x has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 96158.80 and maximum value is 701298.88.
y float Data source did not contain a description for y. Column y has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6647636.00 and maximum value is 7730596.50.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (19.700844459062072... and first 25 characters of maximum string: POINT (19.951750061746527...
geom_center_x float Longitude of center. Column geom_center_x has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.70 and maximum value is 30.93.
geom_center_y float Latitude of center. Column geom_center_y has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.89 and maximum value is 69.68.
geom_type string Geometry type. Column geom_type has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.
orig_extractdate string The date when the data was originally fetched from the source.

Tieliikenne 2017, Tieliikennetieliikenne 2017, Latest

Column Type Comment
vvonn int Data source did not contain a description for vvonn. Column vvonn has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2017.
kkonn int Data source did not contain a description for kkonn. Column kkonn has 4428 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 12.
kello string Data source did not contain a description for kello. Column kello has 4428 rows, out of which 2 are empty, making the null percent 0.05. Minimum string is and maximum string is 06.00-06.59.
vakav int Data source did not contain a description for vakav. Column vakav has 4428 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 3.
onntyyppi int Data source did not contain a description for onntyyppi. Column onntyyppi has 4428 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 9.
lkmhapa int Data source did not contain a description for lkmhapa. Column lkmhapa has 4428 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 17.
lkmlaka int Data source did not contain a description for lkmlaka. Column lkmlaka has 4428 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 3.
lkmjk int Data source did not contain a description for lkmjk. Column lkmjk has 4428 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 6.
lkmpp int Data source did not contain a description for lkmpp. Column lkmpp has 4428 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 3.
lkmmo int Data source did not contain a description for lkmmo. Column lkmmo has 4428 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 3.
lkmmp int Data source did not contain a description for lkmmp. Column lkmmp has 4428 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 4.
lkmmuukulk int Data source did not contain a description for lkmmuukulk. Column lkmmuukulk has 4428 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 3.
x float Data source did not contain a description for x. Column x has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 96158.80 and maximum value is 701298.88.
y float Data source did not contain a description for y. Column y has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6647636.00 and maximum value is 7730596.50.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (19.700844459062072... and first 25 characters of maximum string: POINT (19.951750061746527...
geom_center_x float Longitude of center. Column geom_center_x has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.70 and maximum value is 30.93.
geom_center_y float Latitude of center. Column geom_center_y has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.89 and maximum value is 69.68.
geom_type string Geometry type. Column geom_type has 4428 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.

Additional Info

Last Updated February 9, 2020
Created February 9, 2020