To download the data set, please sign up or log in
Näkemäpituus
Tables
-
Tl113, Avointl113, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Näkemäpituudella tarkoitetaan matkaa, jolla henkilöauton kuljettaja esteettä näkee tiellä 110 cm korkeudella olevan pisteen. Näkemäpituus mitataan näkemien ääriarvojen kohdalla ja oletetaan, että näkemäpituus muuttuu lineaarisesti niiden välillä. Pitkän ja lyhyen näkemän hakemisesta on annettu erilliset mittausohjeet. Mittaukset ja tulosten esikäsittelyn tierekisteriä varten hoidetaan keskitetysti. Näkemät rekisteröidään vain inventointisuuntaan. Vastakkaisen suunnan näkemistä on mahdollista saada arvio matemaattisin menetelmin tai tilata erillinen mittaus.
Column Descriptions
Tl113, Avointl113, Latest
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 245036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2003748 and maximum value is 2248927. |
| ely | int | Data source did not contain a description for ELY. Column ely has 245036 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 245036 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 70363. |
| 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 245036 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 245036 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 582. |
| aet | int | Data source did not contain a description for AET. Column aet has 245036 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 31568. |
| 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. |
| nakema | int | Data source did not contain a description for NAKEMA. Column nakema has 245036 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 7516. |
| 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 245036 rows, out of which 1 are empty, making the null percent 0.00. 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 245036 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is Äänekoski 19-24. |
| liva | string | Data source did not contain a description for LIVA. Column liva has 245036 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 245036 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 245036 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is Äänekoski. |
| maakuntako | int | Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 245036 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 245036 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is Varsinais-Suomi. |
| laani | string | Data source did not contain a description for LAANI. Column laani has 245036 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is Oulun l??ni. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 245036 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.74957608291185 ... and first 25 characters of maximum string: POINT (31.405187551943776... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 245036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 20.75 and maximum value is 31.41. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 245036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.83 and maximum value is 70.09. |
| geom_type | string | Geometry type. Column geom_type has 245036 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 |