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

Talvinopeusrajoitus

Talvinopeusrajoitus

Tables

  • Tl169, Avointl169, LatestTSV

    Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Piirit kirjaavat talvinopeusrajoitustiedot päätösten mukaisesti toimistotyönä. Nopeusrajoitukset viedään pitkinä osuuksina, huomioimatta tiekohtaisiin rajoituksiin sisältyvää lyhyttä, tien yleistä rajoitustasoa alempaa rajoitusta (pistekohtaiset rajoitukset, porrastukset jne.). Kuvaustekniikka perustuu: TALVINOP Rajoituksen arvo (km/h)

Column Descriptions

Tl169, Avointl169, Latest

Column Type Comment
objectid int Data source did not contain a description for OBJECTID. Column objectid has 3490 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 53198 and maximum value is 56991.
ely int Data source did not contain a description for ELY. Column ely has 3490 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 14.
tie int Data source did not contain a description for TIE. Column tie has 3490 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 18884.
lakkautpvm date Data source did not contain a description for LAKKAUTPVM. Column is empty.
ajr int Data source did not contain a description for AJR. Column ajr has 3490 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 2.
aosa int Data source did not contain a description for AOSA. Column aosa has 3490 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 580.
aet int Data source did not contain a description for AET. Column aet has 3490 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 15769.
losa int Data source did not contain a description for LOSA. Column losa has 3490 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 580.
let int Data source did not contain a description for LET. Column let has 3490 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 23259.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
talvinop int Data source did not contain a description for TALVINOP. Column talvinop has 3490 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60 and maximum value is 100.
s_talvinop int Data source did not contain a description for S_TALVINOP. Column s_talvinop has 3490 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60 and maximum value is 100.
id int Data source did not contain a description for ID. Column is empty.
muutospvm date Data source did not contain a description for MUUTOSPVM. Column is empty.
ualue int Data source did not contain a description for UALUE. Column ualue has 3490 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 129 and maximum value is 1437.
s_ualue string Data source did not contain a description for S_UALUE. Column s_ualue has 3490 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus 17-22 and maximum string is Äänekoski 19-24.
liva string Data source did not contain a description for LIVA. Column liva has 3490 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Pohjanmaan ELY and maximum string is Varsinais-Suomen ELY.
kuntakoodi int Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 3490 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
kunta string Data source did not contain a description for KUNTA. Column kunta has 3490 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.
maakuntako int Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 3490 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 19.
maakunta string Data source did not contain a description for MAAKUNTA. Column maakunta has 3490 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Karjala and maximum string is Varsinais-Suomi.
laani string Data source did not contain a description for LAANI. Column laani has 3490 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Suomen lääni and maximum string is Oulun l??ni.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3490 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 (20.7641124814... and first 25 characters of maximum string: LINESTRING (30.9178741388...
geom_center_x double Longitude of the centroid of the geometry. Column is empty.
geom_center_y double Latitude of the centroid of the geometry. Column is empty.
geom_type string Geometry type. Column geom_type has 3490 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 10, 2020
Created July 9, 2018
tablename avointl169__tl169_all_piped