To download the data set, please sign up or log in
Taululinja
Tables
-
Taululinja, Avointaululinja, LatestTSV
Taululinja on 1-3 linjataulun muodostama optinen linja. Yleensä taululinja osoittaa väylän keskilinjaa. Sisältää Liikenneviraston vesiväylärekisteriin merkityt taululinjat.
Column Descriptions
Taululinja, Avointaululinja, Latest
| Column | Type | Comment |
|---|---|---|
| tyyppi | int | Data source did not contain a description for TYYPPI. Column tyyppi has 2707 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 3. |
| suunta | float | Data source did not contain a description for SUUNTA. Column suunta has 2707 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.00 and maximum value is 360.00. |
| etu_tl_nr | int | Data source did not contain a description for ETU_TL_NR. Column etu_tl_nr has 2707 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 85502. |
| kes_tl_nr | int | Data source did not contain a description for KES_TL_NR. Column kes_tl_nr has 2707 rows, out of which 289 are empty, making the null percent 10.68. Minimum value is 0 and maximum value is 48967. |
| tak_tl_nr | int | Data source did not contain a description for TAK_TL_NR. Column tak_tl_nr has 2707 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 85503. |
| geom_pvm | date | Data source did not contain a description for GEOM_PVM. Column is empty. |
| gdo_gid | int | Data source did not contain a description for GDO_GID. Column gdo_gid has 2707 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2917 and maximum value is 239651. |
| navlinjat | int | Data source did not contain a description for NAVLINJAT. Column navlinjat has 2707 rows, out of which 701 are empty, making the null percent 25.90. Minimum value is 3549 and maximum value is 240720. |
| irrotus_pv | timestamp | Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 2707 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-09-11 02:30:59 and maximum value is 2020-09-11 02:31:02. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 2707 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 (19.4904950620... and first 25 characters of maximum string: LINESTRING (30.2627131282... |
| 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 2707 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 11, 2020 |
|---|---|
| Created | July 9, 2018 |