To download the data set, please sign up or log in
Päivätunnus - Päivätunnus (vesiväyläaineisto)
Tables
-
Paivatunnukset, Avoinpaivatunnukset, LatestTSV
Vesiväyläaineisto on Liikenneviraston vesiväylärekisterissä ylläpidettävä aineisto, joka sisältää viralliset vesiväylätiedot ja merenkulun turvalaitteiden tiedot. Lisäksi aineistoon kuuluvat ruoppaus- ja läjitysalueet, vesiväyliin liittyvät rajoitusalueet sekä vesiliikennemerkit. Aineisto on luonteeltaan väyläomaisuuden hallintaan tarkoitettua perusrekisteritietoa.
Column Descriptions
Paivatunnukset, Avoinpaivatunnukset, Latest
| Column | Type | Comment |
|---|---|---|
| jnr | int | Data source did not contain a description for JNR. Column jnr has 14163 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 9360 and maximum value is 221106. |
| kork_ved | float | Data source did not contain a description for KORK_VED. Column kork_ved has 14163 rows, out of which 4055 are empty, making the null percent 28.63. Minimum value is 0.00 and maximum value is 360.00. |
| pmm_tyyp | int | Data source did not contain a description for PMM_TYYP. Column pmm_tyyp has 14163 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 20. |
| pmvs_tyyp | int | Data source did not contain a description for PMVS_TYYP. Column pmvs_tyyp has 14163 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 10. |
| tlnumero | int | Data source did not contain a description for TLNUMERO. Column tlnumero has 14163 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 86253. |
| pmv_tyyp | int | Data source did not contain a description for PMV_TYYP. Column pmv_tyyp has 14163 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 56. |
| pmpm_tyyp | int | Data source did not contain a description for PMPM_TYYP. Column pmpm_tyyp has 14163 rows, out of which 6481 are empty, making the null percent 45.76. Minimum value is 1 and maximum value is 12. |
| korkeus | float | Data source did not contain a description for KORKEUS. Column korkeus has 14163 rows, out of which 7422 are empty, making the null percent 52.40. Minimum value is 0.20 and maximum value is 60.00. |
| kork_maa | float | Data source did not contain a description for KORK_MAA. Column kork_maa has 14163 rows, out of which 6296 are empty, making the null percent 44.45. Minimum value is 0.00 and maximum value is 320.00. |
| leveys | float | Data source did not contain a description for LEVEYS. Column leveys has 14163 rows, out of which 7963 are empty, making the null percent 56.22. Minimum value is 0.10 and maximum value is 10.00. |
| irrotus_pv | timestamp | Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 14163 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:30 and maximum value is 2020-09-11 02:30:43. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 14163 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 (19.13144089739295 ... and first 25 characters of maximum string: POINT (31.233860604369116... |
| 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 14163 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 |