To download the data set, please sign up or log in
Palvelualueet
Tables
-
Tl195, Avointl195, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tietolajille inventoidaan levähdys- ja pysäköimisalueiden perustiedot. Tiehen välittömästi liittyvän alueen tieosoite määritellään alueen keskikohdan mukaan. Erillisen alueen osoitteena käytetään alueen keskikohdan projektiota tielle. Kuvaustekniikka perustuu: PATY Palvelualueen tyyppi, joka sinänsä takaa tietyn varustetason, koodataan palvelutasin ja sitä vastaavan opastuksen nojalla seuraavasti: 1 = levähdysalue I (palvelualuevarustus, korkein taso), 2 = levähdysalue II (perusvarustelu), 3 = yksityinen palvelualue (luokkaan 1 rinnastettava, taajaman ulkopuolinen yksityinen palvelualue), 4 = pysäköimisalue I (lisävarusteltu), 5 = pysäköimisalue II (minimivarustus), 6 = lastausalue, 7 = laituri, 8 = muua alue (esim. raskaan...
Column Descriptions
Tl195, Avointl195, Latest
| Column | Type | Comment |
|---|---|---|
| s_pasuunta | string | Data source did not contain a description for S_PASUUNTA. Column s_pasuunta has 3363 rows, out of which 119 are empty, making the null percent 3.54. Minimum string is and maximum string is on. |
| pavalo | int | Data source did not contain a description for PAVALO. Column pavalo has 3363 rows, out of which 788 are empty, making the null percent 23.43. Minimum value is 0 and maximum value is 1. |
| s_pavalo | string | Data source did not contain a description for S_PAVALO. Column s_pavalo has 3363 rows, out of which 788 are empty, making the null percent 23.43. Minimum string is and maximum string is on. |
| patkp | int | Data source did not contain a description for PATKP. Column patkp has 3363 rows, out of which 110 are empty, making the null percent 3.27. Minimum value is 0 and maximum value is 2. |
| s_patkp | string | Data source did not contain a description for S_PATKP. Column s_patkp has 3363 rows, out of which 110 are empty, making the null percent 3.27. Minimum string is and maximum string is osin. |
| pasahko | int | Data source did not contain a description for PASAHKO. Column pasahko has 3363 rows, out of which 581 are empty, making the null percent 17.28. Minimum value is 0 and maximum value is 1. |
| s_pasahko | string | Data source did not contain a description for S_PASAHKO. Column s_pasahko has 3363 rows, out of which 581 are empty, making the null percent 17.28. Minimum string is and maximum string is on. |
| pauinti | int | Data source did not contain a description for PAUINTI. Column pauinti has 3363 rows, out of which 586 are empty, making the null percent 17.42. Minimum value is 0 and maximum value is 1. |
| s_pauinti | string | Data source did not contain a description for S_PAUINTI. Column s_pauinti has 3363 rows, out of which 586 are empty, making the null percent 17.42. Minimum string is and maximum string is on. |
| panimi | string | Data source did not contain a description for PANIMI. Column panimi has 3363 rows, out of which 61 are empty, making the null percent 1.81. Minimum string is and maximum string is Österby. |
| pavarus | string | Data source did not contain a description for PAVARUS. Column pavarus has 3363 rows, out of which 2589 are empty, making the null percent 76.98. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yleinen tie päättyy, jatk... |
| paurakka | int | Data source did not contain a description for PAURAKKA. Column paurakka has 3363 rows, out of which 3346 are empty, making the null percent 99.49. Minimum value is 100 and maximum value is 400. |
| s_paurakka | string | Data source did not contain a description for S_PAURAKKA. Column s_paurakka has 3363 rows, out of which 3346 are empty, making the null percent 99.49. Minimum string is and maximum string is yrittäjä. |
| patunnus | string | Data source did not contain a description for PATUNNUS. Column patunnus has 3363 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Livi100 and maximum string is TMTMVI933992999. |
| 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 3363 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 3363 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 3363 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 3363 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 3363 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 3363 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 3363 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 3363 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. |
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 3363 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 42532 and maximum value is 46766. |
| ely | int | Data source did not contain a description for ELY. Column ely has 3363 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 3363 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 83015. |
| 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 3363 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 3363 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 995. |
| aet | int | Data source did not contain a description for AET. Column aet has 3363 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 25455. |
| puoli | int | Data source did not contain a description for PUOLI. Column puoli has 3363 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 9. |
| 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. |
| paty | int | Data source did not contain a description for PATY. Column paty has 3363 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 9. |
| s_paty | string | Data source did not contain a description for S_PATY. Column s_paty has 3363 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ei tietoa and maximum string is yksityinen. |
| liitpys | int | Data source did not contain a description for LIITPYS. Column liitpys has 3363 rows, out of which 3256 are empty, making the null percent 96.82. Minimum value is 1 and maximum value is 3. |
| s_liitpys | string | Data source did not contain a description for S_LIITPYS. Column s_liitpys has 3363 rows, out of which 3256 are empty, making the null percent 96.82. Minimum string is and maximum string is polkupy. |
| payritys | int | Data source did not contain a description for PAYRITYS. Column payritys has 3363 rows, out of which 3209 are empty, making the null percent 95.42. Minimum value is 1 and maximum value is 4. |
| s_payritys | string | Data source did not contain a description for S_PAYRITYS. Column s_payritys has 3363 rows, out of which 3209 are empty, making the null percent 95.42. Minimum string is and maximum string is ravintola. |
| pamuoto | int | Data source did not contain a description for PAMUOTO. Column pamuoto has 3363 rows, out of which 90 are empty, making the null percent 2.68. Minimum value is 0 and maximum value is 6. |
| s_pamuoto | string | Data source did not contain a description for S_PAMUOTO. Column s_pamuoto has 3363 rows, out of which 90 are empty, making the null percent 2.68. Minimum string is and maximum string is ei tyypit. |
| pasuunta | int | Data source did not contain a description for PASUUNTA. Column pasuunta has 3363 rows, out of which 119 are empty, making the null percent 3.54. Minimum value is 0 and maximum value is 1. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 3363 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 (20.7509708931768 6... and first 25 characters of maximum string: POINT (31.286163544036604... |
| 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 3363 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 | September 11, 2020 |
|---|---|
| Created | July 9, 2018 |