To download the data set, please sign up or log in
Nopeusrajoitus
Tables
-
Tl168, Avointl168, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tälle tietolajille rekisteröidään vain pysyvät nopeusrajoitukset (ei tilapäisiä tai ns. vaihtuvia nopeusrajoituksia). Vaihtuvat nopeusrajoitukset ja niiden voimassaoloajat voidaan rekisteröidä omalle tietolajilleen. Koska maastossa ei voi erottaa tilapäisiä tai vaihtuvia nopeusrajoituksia pysyvistä, joudutaan rajoituksen luonne varmistamaan nopeusrajoituspäätöksistä. Kuvaustekniikka perustuu: NOPRAJ rajoituksen arvo (km/h), NOPTAAJA 1 = rajoitus on "taajam"-merkin vaikutusalueella
Column Descriptions
Tl168, Avointl168, Latest
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 97322 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 940078 and maximum value is 1039818. |
| ely | int | Data source did not contain a description for ELY. Column ely has 97322 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 97322 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 70741. |
| 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 97322 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 97322 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 997. |
| aet | int | Data source did not contain a description for AET. Column aet has 97322 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 24430. |
| losa | int | Data source did not contain a description for LOSA. Column losa has 97322 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 997. |
| let | int | Data source did not contain a description for LET. Column let has 97322 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. |
| puoli | int | Data source did not contain a description for PUOLI. Column puoli has 97322 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 2. |
| 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. |
| nopraj | int | Data source did not contain a description for NOPRAJ. Column nopraj has 97322 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 20 and maximum value is 120. |
| s_nopraj | int | Data source did not contain a description for S_NOPRAJ. Column s_nopraj has 97322 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 20 and maximum value is 120. |
| noprala | int | Data source did not contain a description for NOPRALA. Column noprala has 97322 rows, out of which 1428 are empty, making the null percent 1.47. Minimum value is 1 and maximum value is 8. |
| s_noprala | string | Data source did not contain a description for S_NOPRALA. Column s_noprala has 97322 rows, out of which 1428 are empty, making the null percent 1.47. Minimum string is and maximum string is yleisraj. |
| noptaaja | int | Data source did not contain a description for NOPTAAJA. Column noptaaja has 97322 rows, out of which 83741 are empty, making the null percent 86.05. Constant value is 1. |
| s_noptaaja | string | Data source did not contain a description for S_NOPTAAJA. Column s_noptaaja has 97322 rows, out of which 83741 are empty, making the null percent 86.05. The single string value is: . |
| 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 97322 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 9000. |
| s_ualue | string | Data source did not contain a description for S_UALUE. Column s_ualue has 97322 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 97322 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 97322 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 97322 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 97322 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 97322 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 97322 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 97322 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 (21.1747974417... and first 25 characters of maximum string: MULTILINESTRING ((29.5039... |
| 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 97322 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 10, 2020 |
|---|---|
| Created | July 9, 2018 |