1. Home
  2. Datasets
  3. Tien päällyste
To download the data set, please sign up or log in

Tien päällyste

Tien päällyste

Tables

  • Tl137, Avointl137, Full historyTSV

    Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tieto rekisteröidään aina, kun tieosuus ensimmäisen kerran päällystetään tai kun päällysteen luokka vaihdetaan toiseksi. Jälkimmäiseen tapaukseen liitty yleensä myös jonkinasteinen rakenteenparantaminen. Kuvaustekniikka perustuu: PÄÄLLUOK 1 = betoni, 2 = kivi, 10 = kovat asfalttibetonit, 20 = pehmeät asfalttibetonit, 30 = soratien pintaus, 40 = sorakulutuskerros

  • Tl137, Avointl137, LatestTSV

    Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tieto rekisteröidään aina, kun tieosuus ensimmäisen kerran päällystetään tai kun päällysteen luokka vaihdetaan toiseksi. Jälkimmäiseen tapaukseen liitty yleensä myös jonkinasteinen rakenteenparantaminen. Kuvaustekniikka perustuu: PÄÄLLUOK 1 = betoni, 2 = kivi, 10 = kovat asfalttibetonit, 20 = pehmeät asfalttibetonit, 30 = soratien pintaus, 40 = sorakulutuskerros

Column Descriptions

Tl137, Avointl137, Full history

Column Type Comment
objectid int Data source did not contain a description for OBJECTID. Column objectid has 90251 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 773217 and maximum value is 864623.
ely int Data source did not contain a description for ELY. Column ely has 90251 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 90251 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 99507.
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 90251 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 90251 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 999.
aet int Data source did not contain a description for AET. Column aet has 90251 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 26859.
losa int Data source did not contain a description for LOSA. Column losa has 90251 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 999.
let int Data source did not contain a description for LET. Column let has 90251 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 31584.
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.
paalluok int Data source did not contain a description for PAALLUOK. Column paalluok has 90251 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 50.
s_paalluok string Data source did not contain a description for S_PAALLUOK. Column s_paalluok has 90251 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AB and maximum string is sora.
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 90251 rows, out of which 2 are empty, making the null percent 0.00. Minimum value is 129 and maximum value is 9999.
s_ualue string Data source did not contain a description for S_UALUE. Column s_ualue has 90251 rows, out of which 2 are empty, making the null percent 0.00. 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 90251 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 90251 rows, out of which 1 are empty, making the null percent 0.00. Minimum value is 5 and maximum value is 992.
kunta string Data source did not contain a description for KUNTA. Column kunta has 90251 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is Akaa and maximum string is Äänekoski.
maakuntako int Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 90251 rows, out of which 1 are empty, making the null percent 0.00. Minimum value is 1 and maximum value is 19.
maakunta string Data source did not contain a description for MAAKUNTA. Column maakunta has 90251 rows, out of which 1 are empty, making the null percent 0.00. 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 90251 rows, out of which 1 are empty, making the null percent 0.00. 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 90251 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.9374550591... and first 25 characters of maximum string: MULTILINESTRING ((27.7038...
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 90251 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_MULTILINESTRING.
orig_extractdate string The date when the data was originally fetched from the source.

Tl137, Avointl137, Latest

Column Type Comment
objectid int Data source did not contain a description for OBJECTID. Column objectid has 90251 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 773217 and maximum value is 864623.
ely int Data source did not contain a description for ELY. Column ely has 90251 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 90251 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 99507.
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 90251 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 90251 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 999.
aet int Data source did not contain a description for AET. Column aet has 90251 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 26859.
losa int Data source did not contain a description for LOSA. Column losa has 90251 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 999.
let int Data source did not contain a description for LET. Column let has 90251 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 31584.
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.
paalluok int Data source did not contain a description for PAALLUOK. Column paalluok has 90251 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 50.
s_paalluok string Data source did not contain a description for S_PAALLUOK. Column s_paalluok has 90251 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AB and maximum string is sora.
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 90251 rows, out of which 2 are empty, making the null percent 0.00. Minimum value is 129 and maximum value is 9999.
s_ualue string Data source did not contain a description for S_UALUE. Column s_ualue has 90251 rows, out of which 2 are empty, making the null percent 0.00. 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 90251 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 90251 rows, out of which 1 are empty, making the null percent 0.00. Minimum value is 5 and maximum value is 992.
kunta string Data source did not contain a description for KUNTA. Column kunta has 90251 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is Akaa and maximum string is Äänekoski.
maakuntako int Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 90251 rows, out of which 1 are empty, making the null percent 0.00. Minimum value is 1 and maximum value is 19.
maakunta string Data source did not contain a description for MAAKUNTA. Column maakunta has 90251 rows, out of which 1 are empty, making the null percent 0.00. 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 90251 rows, out of which 1 are empty, making the null percent 0.00. 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 90251 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.9374550591... and first 25 characters of maximum string: MULTILINESTRING ((27.7038...
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 90251 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_MULTILINESTRING.

Additional Info

Last Updated September 9, 2020
Created September 9, 2020